Hi All...
OK, it's a little weird asking for assistance with someone else's script..especially one as complicated as this one...but here's the deal..
The attached script is awesome.
mIRC MySQL script - Author: MonoTeK
The problem is...the documentation isn't great.
I can get it to connect to my MySQL server...
I can even run queries...the problem is that whenever it encounters a NULL value in the database...it craps out.
I have a table in a database with 20 columns. I can do a /Mysql_query testing select * from testtable where ID = '1'
and it returns the data...( using /mysql_getfield(x,y) )...but firstly when it pulls a NULL value, it skips it. Secondly, there are some text strings that seem to interact with the mIRC parser and cause weird text color changes and stuff like that. Simple data like +8 for some reason triggers a BOLD modifier and some fields pull in 4-5 fields with weird stuff all in one field.
Not sure if that made any sense...but basically the script was written in like 2003/4 ..and I think new versions of MySQL and mIRC may be causing the problem.
So my question is this...can anyone fix the script?
I have tried to email the author, but have had no response.
Secondly, can anyone provide a better method of connecting to and pulling data from/writing data to a MySQL database?
I know about the mysql.dll file...but can't make it work..(maybe I just need a tutorial)...
Any thoughts?
If anyone wants to help but doesn't have access to a MySQL Database, you can either download
XAMPP....or private message me and I'll set you up a temp account on my MySQL server.
Thanks for reading.
AltReality