Hi,
I'm trying to use mysql.dll for mIRC (http://sourceforge.net/project/showfiles.php?group_id=29203&package_id=21107) but it randomly crashes my mIRC with:
----------------------------------------------
Event Type: Error
Event Source: Application Error
Event Category: None
Event ID: 1000
Date: 16-2-2005
Time: 6:11:52
User: N/A
Computer: REMCO
Description:
Faulting application mirc.exe, version 6.1.6.0, faulting module ntdll.dll, version 5.1.2600.2180, fault address 0x00011404.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 6d 69 72 ure mir
0018: 63 2e 65 78 65 20 36 2e c.exe 6.
0020: 31 2e 36 2e 30 20 69 6e 1.6.0 in
0028: 20 6e 74 64 6c 6c 2e 64 ntdll.d
0030: 6c 6c 20 35 2e 31 2e 32 ll 5.1.2
0038: 36 30 30 2e 32 31 38 30 600.2180
0040: 20 61 74 20 6f 66 66 73 at offs
0048: 65 74 20 30 30 30 31 31 et 00011
0050: 34 30 34 0d 0a 404..
-----------------------------------------------
The database works fine with other applications.
Part of the script I use in mIRC, the rest is just on :TEXT: etc which calls the aliases:
----------------------------------------------------
alias _seen_exist {
var %query = SELECT event FROM seen WHERE nick=' $+ $1 $+ '
.echo -q $dll(mysql.dll,Query,koc %query)
return $gettok($dll(mysql.dll,Rows,koc),5,32)
}
alias _seen_update {
var %query = UPDATE seen SET address=' $+ $2 $+ ', event=' $+ $3 $+ ', ctime=' $+ $4 $+ ', network=' $+ $5 $+ ', reason=' $+ $6- $+ ' WHERE nick=' $+ $1 $+ '
.echo -q $dll(mysql.dll,Query,koc %query)
}
alias _seen_insert {
var %query = INSERT INTO seen (nick, address, event, ctime, network, reason) VALUES (' $+ $1 $+ ', ' $+ $2 $+ ', ' $+ $3 $+ ', ' $+ $4 $+ ', ' $+ $5 $+ ', ' $+ $6- $+ ')
.echo -q $dll(mysql.dll,Query,koc %query)
}
----------------------------------------------------
It randomly crashes with above error, sometimes it runs fine for 5 - 20 minutes while it's quite busy.
Any ideas are welcome, I've tried almost everything :/
Remco