hey im having problems in how to use this mysql connection and add to db.

My intention is to save all text from certain nick in to db on my mysql and add ctime next to it.

Example in db how to be stored:

ctime - The1LineFromTheNick
ctime - The2LineFromTheNick
ctime - The3LineFromTheNick


This is how far i got: (not much i know frown )

Code:
 
menu channel {
  Relayer
  .On: set %relay on | echo -as RELAYER Turned 09ON
  .Off: unset %relay | echo -as RELAYER Turned 04OFF
}

on *:text:*:#ChannelToListenOn: {
  if ($network == NetworkToListenOn && $nick == NameToListenOn && %relay == on) {
    if ( $chr(91) isin $1 && $chr(93) isin $3) {
      if (SEARCH !isin $2 && GROUP !isin $2) {
        if (FIRST !isin $2 && LAST !isin $2) {
          [color:green] ;Need to remove color from %text [/color]
          var %text = $1-
          var %Connection.String = (DRIVER={MySQL ODBC 3.51 Driver};, SERVER=MySQL.MySite.com;, $&
            PORT=80;, DATABASE=myDatabase;, USER=myUsername;, PASSWORD=myPassword;, OPTION=3;)
        }
      }
    }
  }
}


i know the remote bit trigger just fine, its more about getting $ctime - %text (with stripped color) & mysql part to work

Any help would be appreciated laugh