Vice City: Multiplayer

VC:MP Discussion => Support => Topic started by: KAKAN on Oct 17, 2015, 08:56 AM

Title: mysql help
Post by: KAKAN on Oct 17, 2015, 08:56 AM
Can anyone fill up the 'mysql' category in the Wiki, I want it, someone who knows about vcmp MySQL, can fill it up please?
Title: Re: mysql help
Post by: Xmair on Oct 17, 2015, 10:25 AM
I'll fill it up when I have time, You can use this link (http://forum.vc-mp.org/?topic=444.0) to know the basics and other functions of mysql.
Title: Re: mysql help
Post by: KAKAN on Oct 17, 2015, 06:36 PM
New error:-
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?
Title: Re: mysql help
Post by: KAKAN on Oct 18, 2015, 06:28 AM
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?
test <- mysql_connect("sql6.freemysqlhosting.net","sql693416","ashittypassagain","sql693416");
Title: Re: mysql help
Post by: DizzasTeR on Oct 18, 2015, 08:10 AM
Try address as localhost
Title: Re: mysql help
Post by: KAKAN on Oct 18, 2015, 08:35 AM
Quote from: Doom_Killer on Oct 18, 2015, 08:10 AMTry address as localhost
Nah, didn't work,
And I have 5MB of space for only ACCOUNTS and BANS! is it okay?
Title: Re: mysql help
Post by: Thijn on Oct 18, 2015, 09:00 AM
Define cant connect. Do you get an error?
Title: Re: mysql help
Post by: KAKAN on Oct 18, 2015, 09:19 AM
It just says:-
the index 'mysql_connect' does not existsBtw @Thijn please read and reply to my PM if you can.
Title: Re: mysql help
Post by: Thijn on Oct 18, 2015, 10:44 AM
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.
Title: Re: mysql help
Post by: KAKAN on Oct 18, 2015, 12:24 PM
Yea, I have loaded it, and it doesn't give any errors
Title: Re: mysql help
Post by: KAKAN on Oct 18, 2015, 03:03 PM
Wait, is this the syntax for MySQL?
mysql_connect( szHost, szUsername, szPassword, szDatabase, iPort )
Title: Re: mysql help
Post by: KAKAN on Oct 18, 2015, 04:03 PM
Problem fixed.
I haven't updated the MySQL file since a while.