mIRC Home    About    Download    Register    News    Help

Print Thread
mysql db #42567 17/08/03 09:23 PM
Joined: Mar 2003
Posts: 437
M
MTech Offline OP
Fjord artisan
OP Offline
Fjord artisan
M
Joined: Mar 2003
Posts: 437
how can i write to a mysql db using sockets?

Re: mysql db #42568 17/08/03 10:04 PM
Joined: Dec 2002
Posts: 2,962
S
starbucks_mafia Offline
Hoopy frood
Offline
Hoopy frood
S
Joined: Dec 2002
Posts: 2,962
Do you mean you want to communicate with a MySQL database? Use mysql.dll, it's available on mircscripts.org.

If you mean you want to create an actual SQL database with mIRC scripting then sorry but that's a bad idea. It would be ridiculous to try it even if you were an expert on the subject (which by asking this very question I don't think you are). If you ever got anywhere on it it would still be 99% unuseable and/or impractical.


Spelling mistakes, grammatical errors, and stupid comments are intentional.
Re: mysql db #42569 17/08/03 10:06 PM
Joined: Mar 2003
Posts: 437
M
MTech Offline OP
Fjord artisan
OP Offline
Fjord artisan
M
Joined: Mar 2003
Posts: 437
commmunicate? im trying to wrtie to one...so i should use the dll?

Re: mysql db #42570 17/08/03 10:08 PM
Joined: Dec 2002
Posts: 2,962
S
starbucks_mafia Offline
Hoopy frood
Offline
Hoopy frood
S
Joined: Dec 2002
Posts: 2,962
No. Read my second paragraph.


Spelling mistakes, grammatical errors, and stupid comments are intentional.
Re: mysql db #42571 17/08/03 10:48 PM
Joined: Dec 2002
Posts: 2,809
C
codemastr Offline
Hoopy frood
Offline
Hoopy frood
C
Joined: Dec 2002
Posts: 2,809
The MySQL protocol is complex and some features (such as compression and encryption) simply can not be implemented through an mIRC script. I'd suggest you use the mysql.dll (or whatever it's called) it's a much better alternative.

Re: mysql db #42572 17/08/03 10:59 PM
Joined: Jan 2003
Posts: 3,012
KingTomato Offline
Hoopy frood
Offline
Hoopy frood
Joined: Jan 2003
Posts: 3,012
sql is so complex, windows has its own library for managing the sockets. >:F


-KingTomato
Re: mysql db #42573 18/08/03 04:28 AM
Joined: Feb 2003
Posts: 309
C
CloCkWeRX Offline
Fjord artisan
Offline
Fjord artisan
C
Joined: Feb 2003
Posts: 309
*ahem*
You have a hell of a lot of alternatives here.
A) mircscripts.org -> mysql socket script. It works via signals but is slow slow slow!
B) mysql.dll on mircscripts.org -> Works fine; but not with mysql 4.1.0 or greater I've found
C) A COM Object -> there are a few out there, but many are under development so are buggy; or return a resultset as an array of result objects; which mirc can't deal with.
You can work via vbscript or whatever; and that has the advantage of running seperately from mirc (so it doesn't freeze up).
D) myODBC + COM object -> Its slow but allows you to read/write from/to any odbc database.

Find the com objects with google, or mysql.com

Re: mysql db #42574 18/08/03 10:03 PM
Joined: Dec 2002
Posts: 2,809
C
codemastr Offline
Hoopy frood
Offline
Hoopy frood
C
Joined: Dec 2002
Posts: 2,809
MySQL isn't ODBC by default, is it?

Re: mysql db #42575 20/08/03 05:06 AM
Joined: Feb 2003
Posts: 309
C
CloCkWeRX Offline
Fjord artisan
Offline
Fjord artisan
C
Joined: Feb 2003
Posts: 309
sadly no; you need to play around with myODBC.