Patryk322
Wiek: 28 Na forum: 5261 dni Posty: 37
Nick w MP: Cris Asai
Piwa : 448
Witam jest taki problem ot?? zapisuje si? tylko do food, dalej nic.
Je?eli wpisz? komend? np nocar to nie zapisuje si? do mysql ilo??.
Kod: public SavePlayerStats(playerid, what)
{
if(!Logged[playerid]) return 1;
mysql_check();
if(what == SAVE_PLAYER_BASIC)
{
mysql_query_format("UPDATE `fc_characters` SET `age` = '%d', `sex` = '%d', `cash` = '%d', `hours` = '%d', `minutes` = '%d', `skin` = '%d', `bw` = '%d', `aj` = '%d', `health` = '%f', `job` = '%d', `block` = '%d', `penalty_points` = '%d', `food` = '%d', `payday` = '%d', `OsGodzina` = '%d', `pOsAuto` = '%d', `OsAj` = '%d', `OsMandat` = '%d', `OsPrawko` = '%d', `OsFrakcja` = '%d', `nocar` = '%d' WHERE `player_uid` = '%d' LIMIT 1",
CharacterCache[playerid][pAge],
CharacterCache[playerid][pSex],
CharacterCache[playerid][pCash],
CharacterCache[playerid][pHours],
CharacterCache[playerid][pMinutes],
CharacterCache[playerid][pSkin],
CharacterCache[playerid][pBW],
CharacterCache[playerid][pAJ],
CharacterCache[playerid][pHealth],
CharacterCache[playerid][pJob],
CharacterCache[playerid][pBlock],
CharacterCache[playerid][pPenaltyPoints],
CharacterCache[playerid][pFood],
CharacterCache[playerid][pPayDay],
CharacterCache[playerid][pOsGodzina],
CharacterCache[playerid][pOsAuto],
CharacterCache[playerid][pOsAj],
CharacterCache[playerid][pOsMandat],
CharacterCache[playerid][pOsPrawko],
CharacterCache[playerid][pOsFrakcja],
CharacterCache[playerid][pNoCar],
CharacterCache[playerid][pUID]);
}
if(what == SAVE_PLAYER_SETTING)
{
mysql_query_format("UPDATE `fc_characters` SET `tog` = '%d', `option` = '%d', `editor` = '%d', `document` = '%d', `insurance_cash` = '%d', `phone` = '%d', `last_skin` = '%d', `drugs_type` = '%d', `drugs_time` = '%d', `sell_drug` = '%d', `jail_time` = '%d', `jail_id` = '%d', `permit_time` = '%d' WHERE `player_uid` = '%d' LIMIT 1",
CharacterCache[playerid][pTog],
CharacterCache[playerid][pOption],
CharacterCache[playerid][pEditor],
CharacterCache[playerid][pDocument],
CharacterCache[playerid][pInsurance],
CharacterCache[playerid][pPhone],
CharacterCache[playerid][pLastSkin],
CharacterCache[playerid][pDrugs],
CharacterCache[playerid][pDrugsTime],
CharacterCache[playerid][pSellDrug],
CharacterCache[playerid][pJailTime],
CharacterCache[playerid][pJailID],
CharacterCache[playerid][pPermit],
CharacterCache[playerid][pUID]);
}
if(what == SAVE_PLAYER_POS)
{
mysql_query_format("UPDATE `fc_characters` SET `pos_x` = '%f', `pos_y` = '%f', `pos_z` = '%f', `vw` = '%d', `int` = '%d' WHERE `player_uid` = '%d' LIMIT 1",
CharacterCache[playerid][pPos][0],
CharacterCache[playerid][pPos][1],
CharacterCache[playerid][pPos][2],
CharacterCache[playerid][pVW],
CharacterCache[playerid][pInt],
CharacterCache[playerid][pUID]);
}
if(what == SAVE_PLAYER_GLOBAL)
{
mysql_query_format("UPDATE `ipb_members` SET `score` = '%d', `admin` = '%d' WHERE `member_id` = '%d' LIMIT 1",
CharacterCache[playerid][pGlobalScore],
CharacterCache[playerid][pAdmin],
CharacterCache[playerid][pGID]);
}
return 1;
}
a tutaj mysql ss http://i.imgur.com/OJjky9m.png[/code]