Converting to mysql. - Printable Version

Converting to mysql. - 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)
+--- Thread: Converting to mysql. (/showthread.php?tid=515168)

Converting to mysql. - kepa333 - 24.05.2014

Hello there im trying to convert my gamemode to mysql, but i cant understand at all how things works, as i saw on tutorials it should be like this:

Код:

			dini_Set(file, "IP", PlayerInfo[playerid][pIP]);
			dini_IntSet(file, "Gender", PlayerInfo[playerid][pGender]);// Old sys
			
			format(string,sizeof(string),"INSERT INTO `user` (IP, gender) VALUES ('%s', '%s')",PlayerInfo[playerid][pIP], PlayerInfo[playerid][pGender]);// converted
			mysql_query(string);
			
			dini_IntSet(file, "Level", PlayerInfo[playerid][pLevel]);
			dini_IntSet(file, "Minutes", PlayerInfo[playerid][pMinutes]);// Old sys
			
			format(string,sizeof(string),"INSERT INTO `user` (level, minutes) VALUES ('%s', '%s')",PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pMinutes]);// converted
			mysql_query(string);
			
			dini_IntSet(file, "Hours", PlayerInfo[playerid][pHours]);// Old sys
			dini_IntSet(file, "Age", PlayerInfo[playerid][pAge]);
			
			format(string,sizeof(string),"INSERT INTO `user` (hours, age) VALUES ('%s', '%s')",PlayerInfo[playerid][pHours], PlayerInfo[playerid][pAge]);// converted
			mysql_query(string);

if anyone can correct me or tell me easier way would be greate.

regards.

Re: Converting to mysql. - Vince - 24.05.2014

That's not how it works at all. You should probably learn a few SQL queries first before attempting to use them in Pawn. SQL is an entire separate language.

Re: Converting to mysql. - GutierrezDeVelasco - 24.05.2014

I'll do it for $10dls

Re: Converting to mysql. - kepa333 - 24.05.2014

Nah, ill do it by myself even if mysql is like chinese for me.

Re: Converting to mysql. - GutierrezDeVelasco - 24.05.2014

I used these two threads to learn about Using BlueG's MySQL plugin

https://sampforum.blast.hk/showthread.php?tid=337810

https://sampforum.blast.hk/showthread.php?tid=435485

Good luck!!

Re: Converting to mysql. - kepa333 - 27.05.2014

I'ts made like this now, and it works just prfect!!

Код HTML:

Saving:

	format(query,sizeof(query),"UPDATE `userdata` SET `gender` = '%d' WHERE `username` = '%s'",PlayerInfo[playerid][pGender], name);
	mysql_query(query);
	//
	//dini_IntSet(file, "Level", PlayerInfo[playerid][pLevel]);//
	//
	format(query,sizeof(query),"UPDATE `userdata` SET `level` = '%d' WHERE `username` = '%s'",PlayerInfo[playerid][pLevel], name);
	mysql_query(query);
	//
	dini_IntSet(file, "Minutes", PlayerInfo[playerid][pMinutes]);
	//dini_IntSet(file, "Hours", PlayerInfo[playerid][pHours]);
	//
	format(query,sizeof(query),"UPDATE `userdata` SET `hours` = '%d' WHERE `username` = '%s'",PlayerInfo[playerid][pHours], name);
	mysql_query(query);

Loading

	//PlayerInfo[playerid][pGender] = dini_Int(file, "Gender");
	format(query, sizeof(query), "SELECT `gender` FROM `userdata` WHERE `username` = '%s'", name);
	mysql_query(query);
	mysql_store_result();
	if(mysql_num_rows())
	{
	    new temp[10];
	    mysql_fetch_row(temp);
	    PlayerInfo[playerid][pGender] = strval(temp);
	}
	mysql_free_result();
	
	//PlayerInfo[playerid][pLevel] = dini_Int(file, "Level");
	if(PlayerInfo[playerid][pLevel] == 0) PlayerInfo[playerid][pLevel] = 1;
	format(query, sizeof(query), "SELECT `level` FROM `userdata` WHERE `username` = '%s'", name);
	mysql_query(query);
	mysql_store_result();
	if(mysql_num_rows())
	{
	    new temp[10];
	    mysql_fetch_row(temp);
	    PlayerInfo[playerid][pLevel] = strval(temp);
	}
	mysql_free_result();

Is there any way to make it in less lines, i dont want to make 3000 lines for this.

Re: Converting to mysql. - DobbysGamertag - 27.05.2014

You can use multiple things in one query.

EG:

pawn Код:

new query[300]; // random size. 

format(query,sizeof(query),"UPDATE `userdata` SET `gender`='%d',`level`='%d',`hours`='%d' WHERE `user`='%s' ",PlayerInfo[playerid][pGender],PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pHours],name);
mysql_query(query);

Wrote it up quick. It may not work but thats the basic idea of it.

Re: Converting to mysql. - kepa333 - 27.05.2014

I will try it out tomorrow thanks!.