mysql_query with multiple querys
#3

Something like this should work.

pawn Код:
new string[512];
new fstring[512];
string = "UPDATE Users\n SET Password='%s',Admin=%d,Money=%d,Skin=%d,Armor=%f,Health=%f,Xpos=%f,Ypos=%f,Zpos=%f,Apos=%f,";
strcat(string, "Interior=%d, VWorld=%d WHERE Name='%s'");
format(fstring, sizeof(fstring), string,
    UserStats[playerid][Password], UserStats[playerid][Admin], UserStats[playerid][Money],
    UserStats[playerid][Skin], UserStats[playerid][Armor], UserStats[playerid][Health],
    UserStats[playerid][Xpos], UserStats[playerid][Ypos], UserStats[playerid][Zpos],
    UserStats[playerid][Apos], UserStats[playerid][Interior],
    UserStats[playerid][World], UserStats[playerid][Name]
);
mysql_query(fstring);
Reply


Messages In This Thread
mysql_query with multiple querys - by TheCancler - 06.02.2013, 20:05
Re: mysql_query with multiple querys - by TheCancler - 07.02.2013, 02:07
Re: mysql_query with multiple querys - by T0pAz - 07.02.2013, 02:16
Re: mysql_query with multiple querys - by Vince - 07.02.2013, 05:06
Re: mysql_query with multiple querys - by Joao Pedro - 07.02.2013, 05:08
Re: mysql_query with multiple querys - by Scenario - 07.02.2013, 05:11
Re: mysql_query with multiple querys - by Joao Pedro - 07.02.2013, 05:40
Re: mysql_query with multiple querys - by 3ventic - 07.02.2013, 06:26
Re: mysql_query with multiple querys - by Jstylezzz - 07.02.2013, 06:30
Re: mysql_query with multiple querys - by Scenario - 07.02.2013, 17:12
Re: mysql_query with multiple querys - by Johndaonee - 07.02.2013, 17:29
Re: mysql_query with multiple querys - by TheCancler - 08.02.2013, 19:20
Re: mysql_query with multiple querys - by Height - 08.02.2013, 19:27
Re: mysql_query with multiple querys - by TheCancler - 09.02.2013, 21:12
Re: mysql_query with multiple querys - by PrawkC - 09.02.2013, 21:20
Re: mysql_query with multiple querys - by TheCancler - 09.02.2013, 21:22
Re: mysql_query with multiple querys - by PrawkC - 09.02.2013, 21:23
Re: mysql_query with multiple querys - by TheCancler - 09.02.2013, 21:28
Re: mysql_query with multiple querys - by Sergei - 09.02.2013, 21:32

Forum Jump:


Users browsing this thread: 1 Guest(s)