[Saadat]

Hey there, I need a little help from you guys, as you all can see that i'm not a good scripter. I wanted to ask you all that how can I insert a MySQL database in my server,

HERES MY SERVER LOG:

Код:

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3e-R2, ©2005-2012 SA-MP Team

[15:12:47] 
[15:12:47] Server Plugins
[15:12:47] --------------
[15:12:47]  Loading plugin: mysql.dll
[15:12:47] 

  > MySQL plugin R5 successfully loaded.

[15:12:47]   Loaded.
[15:12:47]  Loaded 1 plugins.

[15:12:47] 
[15:12:47] Filterscripts
[15:12:47] ---------------
[15:12:47]   Loading filterscript 'npcs.amx'...
[15:12:47]   Loaded 1 filterscripts.

[15:12:47] Incoming connection: 127.0.0.1:64434
[15:12:47] Incoming connection: 127.0.0.1:64435
[15:12:47] Incoming connection: 127.0.0.1:64436
[15:12:47] Incoming connection: 127.0.0.1:64437
[15:12:47] Incoming connection: 127.0.0.1:64448
[15:12:47] Incoming connection: 127.0.0.1:64439
[15:12:47] Incoming connection: 127.0.0.1:64438
[15:12:47] Incoming connection: 127.0.0.1:64441
[15:12:47] Incoming connection: 127.0.0.1:64440
[15:12:47] Incoming connection: 127.0.0.1:64442
[15:12:47] Incoming connection: 127.0.0.1:64443
[15:12:47] Incoming connection: 127.0.0.1:64446
[15:12:47] Incoming connection: 127.0.0.1:64445
[15:12:47] Incoming connection: 127.0.0.1:64447
[15:12:47] Incoming connection: 127.0.0.1:64449
[15:12:47] Incoming connection: 127.0.0.1:64444
[15:12:48] [MYSQL]: [ERROR]: Connection To `cnr` Failed!
[15:12:48] [MYSQL]: Could Not Retrieve Field - Shutting Down Server.
[15:12:48] 
----------------------------------
[15:12:48] SERVER: HIDDEN
[15:12:48] GAME MODE: HIDDEN
[15:12:48] MAP NAME: HIDDEN
[15:12:48] VERSION: HIDDEN
[15:12:48] MAX PLAYER SLOTS: HIDDEN
[15:12:48] DEVELOPER NAME: HIDDEN
[15:12:48] WEBSITE: HIDDEN
[15:12:48] LAST EDITED: HIDDEN
[15:12:48] ----------------------------------

[15:12:48] Number of vehicle models: 125
[15:12:48] --- Server Shutting Down.

This is my friends script, he gave it to me, I have created a database @ http://sql09.freemysql.net/ . But I don't know how to insert it in my script, so everything goes fine.
Hope you guys will help me out.

regards,
Saadat.

[Vince]

Download XAMPP and set up a database locally. External SQL DBs are incredibly slow.

[Saadat]

I've downloaded > Installed XAMPP. But I can't start the MySQL in it, its gives some error, I can't start MySQL, and even if I do, how can I connect it to my server? Do I have to enter the MySQL info in my script? Help please, Explain this to me please.

[Roel]

Run a gamemode that doesn't require SQL, and learn about SQL first, and if you are going to run zombie apocalypse, you should have a VPS that is against DDOS, because this gamemode get's ddosed every day if your playerbase is above 20 or something, anyway, it's just a hint.

[Saadat]

Thanks Roel for your help, but I don't want MySQL for Zombie Apocalypse, I have another CnR gamemode created by a friend, who dosen't want to run it anymore. He told me to add my MySql database, and a .mysql file to put in my database, then just enter the database info in my script. But the problem is that I don't know how to create a database, and secondly enter its info in my script. Help me Roel please, and I will +rep you and tell my friends too to +rep you, because you are really helpful.

[Roel]

Well I don't care about the reps, but were is this cnr server hosted?
Localy or at another location, if it is hosted at another location then the best thing to do is also host your database at that location to avoid lags.
Anyway if it is hosted localy you can download > usbwebserver > ******.
This is a easy tool that I use normaly to test servers local, you don't have to install it, just run it as adminstrator, then you will see a button > phpmyadmin > click on it > then enter username: root > pass: usbw > and import the database you need for you server, then use
mysql_connect("localhost","root","yourdatabasename ","usbw"); in your ongamemodeinit
This should work...

[Saadat]

Thanks for your help, and I know that you don't need this but ' +REP ' . Anyway, can you help me out ? teamviewer maybe?

[Saadat]

Can anyone help me with teamviewer? i need someone very professional please!!

[Brshama]

i've got same problem and waiting for reply.