code:
alias test1 {
echo -a $dll(mysql.dll,connect,info -huw 27.0.0.1 user pass)
echo -a $dll(mysql.dll,SetDatabase,info users)
/var %query = SELECT COUNT(*) FROM info;
echo -a $dll(mysql.dll,query,info %query)
$dll(mysql.dll,close,info)
}
I have tried this 1 trillion times in many forms, even loged into mysql on my own too check (just started playing with mysql today (thanx for the dll working great so far) and worked fine in there, just wont work in mIRC :"(
any help appreciated
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
code:
alias test1 {
echo -a $dll(mysql.dll,connect,info -huw 27.0.0.1 user pass)
echo -a $dll(mysql.dll,SetDatabase,info users)
/var %query = SELECT COUNT(*) FROM info;
echo -a $dll(mysql.dll,query,info %query)
$dll(mysql.dll,close,info)
}
I have tried this 1 trillion times in many forms, even loged into mysql on my own too check (just started playing with mysql today (thanx for the dll working great so far) and worked fine in there, just wont work in mIRC :"(
any help appreciated
donc put the ";" at then end of your %query