MySQL question (connection handle)
#5

That's how i update a player's info:

Код:
		
.
.
                format(l_string,sizeof(l_string), "UPDATE `players` SET `PlayerLevel` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pLevel],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `AdminLevel` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pAdmin],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `HelperLevel` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pHelper],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `DonateRank` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][pDonateRank],name);
		mysql_function_query(dbHandle, l_string, false, "", "");

		format(l_string,sizeof(l_string), "UPDATE `players` SET `UpgradePoints` = '%d' WHERE `Name` = '%s'",PlayerInfo[playerid][gPupgrade],name);
		mysql_function_query(dbHandle, l_string, false, "", "");
.
.
Reply


Messages In This Thread
MySQL question (connection handle) - by pop.nicku - 03.01.2013, 15:07
Re: MySQL question (connection handle) - by [HK]Ryder[AN] - 03.01.2013, 15:10
Re: MySQL question (connection handle) - by pop.nicku - 03.01.2013, 15:32
Re: MySQL question (connection handle) - by [HK]Ryder[AN] - 03.01.2013, 15:47
Re: MySQL question (connection handle) - by pop.nicku - 03.01.2013, 15:51
Re: MySQL question (connection handle) - by Mandrakke - 03.01.2013, 19:21
Re: MySQL question (connection handle) - by ReneG - 03.01.2013, 20:35
Re: MySQL question (connection handle) - by pop.nicku - 03.01.2013, 20:53

Forum Jump:


Users browsing this thread: 1 Guest(s)