I can look up fine but whats wrong with thise code
Sample Text:
<&Daedalus> ListenersChange¿ZZigc¿26¿250
on *:text:*ListenersChange*:#SNRadioBot.Info: {
if ($nick == Daedalus) {
tokenize 191 $1-
set %temp_dj $2
set %temp_count $3
set %temp_overall $4
set %temp_timestamp $asctime(ddd h:nn:ss tt)
updatelisteners
}
}
alias updatelisteners {
var %mysql.name = $rand(a,z) $+ $rand(a,z) $+ $rand(a,z) $+ $rand(a,z) $+ $rand(a,z)
echo -q $dll(sql\mysql.dll, connect, %mysql.name -huwd IP UNAME PASS DB)
set %queryListners INSERT INTO listencount (id, dj, count, overall, timestamp) VALUES ('', ' $+ %temp_dj $+ ', ' $+ %temp_count $+ ', ' $+ %temp_overall $+ ', ' $+ %temp_timestamp $+ ')
echo -q $dll(sql\mysql.dll, query, %mysql.name %queryListners)
}
Resulting error codes whatnot:
1 010 Connect uspou
0 021 Query INSERT INTO listencount (id, dj, count, overall, timestamp) VALUES ('', 'ZZigc', '24', '250', 'Tue 9:22:59 am')
010 Successful connect.
1 010 [function] [label]
Returned when the connect function succeeded.
021 Unable to send Query.
0 021 [function] [query]
Unable to send Query. Usually results from insufficient
permissions on the server, or the connection to the server has
been dropped.