mIRC Home    About    Download    Register    News    Help

Print Thread
#78791 11/04/04 12:41 AM
Joined: Apr 2004
Posts: 1
F
Faces Offline OP
Mostly harmless
OP Offline
Mostly harmless
F
Joined: Apr 2004
Posts: 1
Why hello there smile

Me and a freind, was just talking about how best to dump a game mysql dump, from interent to local hdd via mirc. As the bot would be in mircscript, we first looked upon hashtables, but heh, it fell short frown

How about expanding hash tables a bit, obviously not as much as mysql and sql db's, but maybe a little more advanced, so you can have multiple columns and for the $hget to be more advanced to cope with this?

#78792 11/04/04 12:51 AM
Joined: Apr 2004
Posts: 2
T
TuB Offline
Bowl of petunias
Offline
Bowl of petunias
T
Joined: Apr 2004
Posts: 2
Great idea... currently the only way that I can think of to add multiple data into a single field is by laboriously splitting up data with commas and using $gettok to pin point anything specific that you want to get.

Expansion of Hash Tables would be an awesome new feature for the next update smirk

#78793 11/04/04 06:40 AM
Joined: Dec 2002
Posts: 1,321
H
Hoopy frood
Offline
Hoopy frood
H
Joined: Dec 2002
Posts: 1,321
mIRC can already access a MySQL recordset through $com() and ADODB.Recordset (and perhaps an ADODB.Command object to send the SQL string). You can retrieve the dataset, then use the .Save method and save it to a file as an XML file which you can use MSXML2.DOMDocument object to parse locally with relative ease or parse it directly from the recordset, depending on what you want to do at the time.

Also, you don't necessarily need to $gettok() a multi-value $hget since you can /tokenize on the character you're splitting the columns with (such as 9 for tab) and simply refer to the position number.


DALnet: #HelpDesk and #m[color:#FF0000]IR[color:#EEEE00]C
#78794 11/04/04 11:47 AM
Joined: Mar 2004
Posts: 10
C
Pikka bird
Offline
Pikka bird
C
Joined: Mar 2004
Posts: 10
you can also connect to a mysql database using a dll and sockets. There are scripts and files located at mircscripts.org


Link Copied to Clipboard