Converting to mysql.
#6

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.
Reply


Messages In This Thread
Converting to mysql. - by kepa333 - 24.05.2014, 21:28
Re: Converting to mysql. - by Vince - 24.05.2014, 21:40
Re: Converting to mysql. - by GutierrezDeVelasco - 24.05.2014, 22:11
Re: Converting to mysql. - by kepa333 - 24.05.2014, 22:21
Re: Converting to mysql. - by GutierrezDeVelasco - 24.05.2014, 22:35
Re: Converting to mysql. - by kepa333 - 27.05.2014, 19:42
Re: Converting to mysql. - by DobbysGamertag - 27.05.2014, 20:05
Re: Converting to mysql. - by kepa333 - 27.05.2014, 20:30

Forum Jump:


Users browsing this thread: 1 Guest(s)