mysql help

[KAKAN]

Can anyone fill up the 'mysql' category in the Wiki, I want it, someone who knows about vcmp MySQL, can fill it up please?

[Xmair]

I'll fill it up when I have time, You can use this link to know the basics and other functions of mysql.

[KAKAN]

New error:-

Code Select Expand

test <- mysql_connect("mysql11.000webhost.com","a3151520_kakan","ashittypasshere","a3151520_vcmp");This shows that the index 'mysql_connect' doesn't exists.
I have loaded the mysql plugin too, then whats the problem?

[KAKAN]

Okay, that website doesn't allows external connections.
I moved to a new website for MySQL, it allows external connection tho.
I can access it through HeldiSQL, phpMyAdmin, but can't connect it to my VCMP server, what's the problem?

Code Select Expand

test <- mysql_connect("sql6.freemysqlhosting.net","sql693416","ashittypassagain","sql693416");

[DizzasTeR]

Try address as localhost

[KAKAN]

Try address as localhost

Nah, didn't work,
And I have 5MB of space for only ACCOUNTS and BANS! is it okay?

[Thijn]

Define cant connect. Do you get an error?

[KAKAN]

It just says:-

Code Select Expand

the index 'mysql_connect' does not existsBtw @Thijn please read and reply to my PM if you can.

[Thijn]

Then the plugin isn't loaded. Make sure you add it to your server.cfg and it doesn't give an error when it's trying to load it.

[KAKAN]

Yea, I have loaded it, and it doesn't give any errors

[KAKAN]

Wait, is this the syntax for MySQL?

Code Select Expand

mysql_connect( szHost, szUsername, szPassword, szDatabase, iPort )

[KAKAN]

Problem fixed.
I haven't updated the MySQL file since a while.