Szerző Téma: MySQL query sor szétválasztása (Megtekintve 590 alkalommal)

Erik3333 · « **Dátum:** 2012. május 10. - 07:12:44 »

Helló!
Hogyan tudnám kettészedni ezt a sort, úgy, hogy mûködjön?

format(string, sizeof(string), \"UPDATE `accounts` SET `AdminLevel` = \'%d\', `Score` = \'%d\', `Money` = \'%d\', `Kills` = \'%d\', `Deaths` = \'%d\', `AdminSegedLevel` = \'%d\', `Blind` = \'%d\', `Bortonben` = \'%d\', `BortonIdo` = \'%d\', `Freeze` = \'%d\', `Cigi` = \'%d\', `Kaja` = \'%d\' WHERE Username= \'%s\'\", PlayerData[playerid][AdminLevel], GetPlayerScore(playerid), GetPlayerMoney(playerid), PlayerData[playerid][Kills], PlayerData[playerid][Deaths], PlayerData[playerid][AdminSegedLevel], PlayerData[playerid][blind], PlayerData[playerid][bortonben], PlayerData[playerid][bortonIdo], PlayerData[playerid][Freeze], PlayerData[playerid][Cigi], PlayerData[playerid][Kaja], PlayerName(playerid));

asdasd[gtaforum] · « **Válasz #1 Dátum:** 2012. május 10. - 07:33:29 »

format(string, sizeof(string), \"UPDATE `accounts` SET `AdminLevel` = \'%d\', `Score` = \'%d\', `Money` = \'%d\', `Kills` = \'%d\', `Deaths` = \'%d\', `AdminSegedLevel` = \'%d\', WHERE Username= \'%s\'\", PlayerData[playerid][AdminLevel], GetPlayerScore(playerid), GetPlayerMoney(playerid), PlayerData[playerid][Kills], PlayerData[playerid][Deaths], PlayerData[playerid][AdminSegedLevel], PlayerName(playerid));
mysql_query(string);
format(string, sizeof(string), \"UPDATE `accounts` SET `Blind` = \'%d\', `Bortonben` = \'%d\', `BortonIdo` = \'%d\', `Freeze` = \'%d\', `Cigi` = \'%d\', `Kaja` = \'%d\' ,WHERE Username= \'%s\'\" ,PlayerData[playerid][blind], PlayerData[playerid][bortonben], PlayerData[playerid][bortonIdo], PlayerData[playerid][Freeze], PlayerData[playerid][Cigi], PlayerData[playerid][Kaja], PlayerName(playerid));
mysql_query(string);

Erik3333 · « **Válasz #2 Dátum:** 2012. május 10. - 07:12:44 »

Helló!
Hogyan tudnám kettészedni ezt a sort, úgy, hogy mûködjön?

format(string, sizeof(string), \"UPDATE `accounts` SET `AdminLevel` = \'%d\', `Score` = \'%d\', `Money` = \'%d\', `Kills` = \'%d\', `Deaths` = \'%d\', `AdminSegedLevel` = \'%d\', `Blind` = \'%d\', `Bortonben` = \'%d\', `BortonIdo` = \'%d\', `Freeze` = \'%d\', `Cigi` = \'%d\', `Kaja` = \'%d\' WHERE Username= \'%s\'\", PlayerData[playerid][AdminLevel], GetPlayerScore(playerid), GetPlayerMoney(playerid), PlayerData[playerid][Kills], PlayerData[playerid][Deaths], PlayerData[playerid][AdminSegedLevel], PlayerData[playerid][blind], PlayerData[playerid][bortonben], PlayerData[playerid][bortonIdo], PlayerData[playerid][Freeze], PlayerData[playerid][Cigi], PlayerData[playerid][Kaja], PlayerName(playerid));

asdasd[gtaforum] · « **Válasz #3 Dátum:** 2012. május 10. - 07:33:29 »

format(string, sizeof(string), \"UPDATE `accounts` SET `AdminLevel` = \'%d\', `Score` = \'%d\', `Money` = \'%d\', `Kills` = \'%d\', `Deaths` = \'%d\', `AdminSegedLevel` = \'%d\', WHERE Username= \'%s\'\", PlayerData[playerid][AdminLevel], GetPlayerScore(playerid), GetPlayerMoney(playerid), PlayerData[playerid][Kills], PlayerData[playerid][Deaths], PlayerData[playerid][AdminSegedLevel], PlayerName(playerid));
mysql_query(string);
format(string, sizeof(string), \"UPDATE `accounts` SET `Blind` = \'%d\', `Bortonben` = \'%d\', `BortonIdo` = \'%d\', `Freeze` = \'%d\', `Cigi` = \'%d\', `Kaja` = \'%d\' ,WHERE Username= \'%s\'\" ,PlayerData[playerid][blind], PlayerData[playerid][bortonben], PlayerData[playerid][bortonIdo], PlayerData[playerid][Freeze], PlayerData[playerid][Cigi], PlayerData[playerid][Kaja], PlayerName(playerid));
mysql_query(string);