MySQL Server - Printable Version

MySQL Server - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL Server (/showthread.php?tid=65100)

MySQL Server - GTAScripter - 09.02.2009

Hello everyone,

Iґm looking for a program that can set .ini to SQL. So I can put all my scriptfiles (.ini) to SQL. So I need to put in all tables and it will convert to SQL.

Greetzzz Alves

Re: MySQL Server - ICECOLDKILLAK8 - 09.02.2009

How many player accounts you got?

Re: MySQL Server - GTAScripter - 09.02.2009

500 active ones I just need a program to put in tables so they will get converted to SQL Query.

Re: MySQL Server - ICECOLDKILLAK8 - 09.02.2009

Make a backup of your script then edit it so it loads the player accounts from a file then make a function like OnPlayerUpdate that saves them to MYSQL

Re: MySQL Server - GTAScripter - 09.02.2009

Is that possible? Could you give me an example because Iґm not that good with SQL...

Re: MySQL Server - Eraz0r - 09.02.2009

should be something like this:

Code:

format(string,sizeof(string),"INSERT INTO table (level,points,money,...,...) VALUES (%d,%d,%d,...,...)",PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pPoints],...,...);
					samp_mysql_query(string);

after the read-out of OnPlayerLogin.

Re: MySQL Server - Luiss - 09.02.2009

Can you take the normal GF and modify it to make this work? Please

Re: MySQL Server - ICECOLDKILLAK8 - 09.02.2009

Quote:

Originally Posted by Luiss

Can you take the normal GF and modify it to make this work? Please

ModernTopia

Re: MySQL Server - Luiss - 09.02.2009

But if I needed to GF please help me

Re: MySQL Server - 1337pr0 - 10.02.2009

Quote:

Originally Posted by Luiss

But if I needed to GF please help me

Don't hi-jack threads.

Visit http://forum.sa-mp.com/index.php?topic=24634.0