mIRC Home    About    Download    Register    News    Help

Print Thread
#97614 14/09/04 02:24 PM
Joined: Mar 2004
Posts: 540
A
Armada Offline OP
Fjord artisan
OP Offline
Fjord artisan
A
Joined: Mar 2004
Posts: 540
I can look up fine but whats wrong with thise code
Sample Text:
<&Daedalus> ListenersChange¿ZZigc¿26¿250
Code:
 
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.

#97615 14/09/04 06:49 PM
Joined: Jul 2003
Posts: 742
Hoopy frood
Offline
Hoopy frood
Joined: Jul 2003
Posts: 742
where do you get mysql.dll?


http://MTec89Net.com
irc.freenode.net #MTec89Net
#97616 14/09/04 06:54 PM
Joined: Mar 2004
Posts: 540
A
Armada Offline OP
Fjord artisan
OP Offline
Fjord artisan
A
Joined: Mar 2004
Posts: 540
mircscripts.org dll archive

#97617 14/09/04 09:44 PM
Joined: Mar 2004
Posts: 45
D
Ameglian cow
Offline
Ameglian cow
D
Joined: Mar 2004
Posts: 45
Nice name in the post... grin

#97618 14/09/04 11:32 PM
Joined: Jul 2003
Posts: 742
Hoopy frood
Offline
Hoopy frood
Joined: Jul 2003
Posts: 742
can u point to a LIBMYSQL.DLL V4.0.4-BETA?


http://MTec89Net.com
irc.freenode.net #MTec89Net
#97619 15/09/04 02:43 AM
Joined: Mar 2004
Posts: 540
A
Armada Offline OP
Fjord artisan
OP Offline
Fjord artisan
A
Joined: Mar 2004
Posts: 540
I have no clue what version I had I just know it works for me and my mysql lol I just havent tried to insert if Youd like I can up the one I have to my site?

#97620 15/09/04 02:52 AM
Joined: Jul 2003
Posts: 742
Hoopy frood
Offline
Hoopy frood
Joined: Jul 2003
Posts: 742
please, i need the version that works, i cant find it


http://MTec89Net.com
irc.freenode.net #MTec89Net
#97621 15/09/04 02:55 AM
Joined: Mar 2004
Posts: 540
A
Armada Offline OP
Fjord artisan
OP Offline
Fjord artisan
A
Joined: Mar 2004
Posts: 540


Link Copied to Clipboard