GTA Közösség - A magyar GTA fórum

San Andreas Multiplayer (SA-MP) => SA-MP: Szerverfejlesztés => Segítségkérés => A témát indította: Erik3333 - 2012. május 10. - 07:12:44

Cím: MySQL query sor szétválasztása
Írta: Erik3333 - 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));

Cím: MySQL query sor szétválasztása
Írta: asdasd[gtaforum] - 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);

Cím: MySQL query sor szétválasztása
Írta: Erik3333 - 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));

Cím: MySQL query sor szétválasztása
Írta: asdasd[gtaforum] - 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);