?mysql_format(ourConnection, query, sizeof(query), "UPDATE characters SET pAdmin = %i, pLastSkin = %i, pLevel = %i, pEXP = %i, pMoney = %i, pBank = %i, pPaycheck = %i, pPhone = %i, pLastOnline = '%e', pLastOnlineTime = %i, pAdminjailed = %i, pAdminjailTime = %i WHERE char_dbid = %i",
??PlayerInfo[playerid][pAdmin],
??PlayerInfo[playerid][pLastSkin],
??PlayerInfo[playerid][pLevel],
??PlayerInfo[playerid][pEXP],
??PlayerInfo[playerid][pMoney],
??PlayerInfo[playerid][pBank],
??PlayerInfo[playerid][pPaycheck],
??PlayerInfo[playerid][pPhone],
??ReturnDate(),
??PlayerInfo[playerid][pLastOnlineTime],
??PlayerInfo[playerid][pAdminjailed],
??PlayerInfo[playerid][pAdminjailTime],
??PlayerInfo[playerid][pDBID]);
?mysql_tquery(ourConnection, query);
?
?mysql_format(ourConnection, query, sizeof(query), "UPDATE characters SET pFaction = %i, pFactionRank = %i, pVehicleSpawned = %i, pVehicleSpawnedID = %i, pTimeplayed = %i, pMaskID = %i, pMaskIDEx = %i, pOfflinejailed = 0 WHERE char_dbid = %i",
??PlayerInfo[playerid][pFaction],
??PlayerInfo[playerid][pFactionRank],
??PlayerInfo[playerid][pVehicleSpawned],
??PlayerInfo[playerid][pVehicleSpawnedID],
??PlayerInfo[playerid][pTimeplayed],
??PlayerInfo[playerid][pMaskID][0],
??PlayerInfo[playerid][pMaskID][1],
??PlayerInfo[playerid][pDBID]);
?mysql_tquery(ourConnection, query);
And
mysql_format(ourConnection, query, sizeof(query), "UPDATE characters SET pAdmin = %i, pLastSkin = %i, pLevel = %i, pEXP = %i, pMoney = %i, pBank = %i, pPaycheck = %i, pPhone = %i, pLastOnline = '%e', pLastOnlineTime = %i, pAdminjailed = %i, pAdminjailTime = %i \
pFaction = %i, pFactionRank = %i, pVehicleSpawned = %i, pVehicleSpawnedID = %i, pTimeplayed = %i, pMaskID = %i, pMaskIDEx = %i, pOfflinejailed = 0 WHERE char_dbid = %i",
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pLastSkin],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pEXP],
PlayerInfo[playerid][pMoney],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pPaycheck],
PlayerInfo[playerid][pPhone],
ReturnDate(),
PlayerInfo[playerid][pLastOnlineTime],
PlayerInfo[playerid][pAdminjailed],
PlayerInfo[playerid][pAdminjailTime],
PlayerInfo[playerid][pFaction],
PlayerInfo[playerid][pFactionRank],
PlayerInfo[playerid][pVehicleSpawned],
PlayerInfo[playerid][pVehicleSpawnedID],
PlayerInfo[playerid][pTimeplayed],
PlayerInfo[playerid][pMaskID][0],
PlayerInfo[playerid][pMaskID][1],
PlayerInfo[playerid][pDBID]);
mysql_tquery(ourConnection, query);
Which one should I do? And why?