Guten Abend Breadfish,
Und zwar habe ich das Problem das keine Userakten gespeichert werden.
Code:
stock SaveAccount(playerid)
{
if(Spieler[playerid][pEingeloggt] == 0)return 1;
new mainQuery[2700],secondQuery[1024];
format(secondQuery, sizeof(secondQuery),"UPDATE `"SERVERTAG"_accounts` SET `Admin` = '%d', `Geschlecht` = '%d', `Tutorial` = '%d', `Level` = '%d', `Respekt` = '%d', `MaxRespekt` = '%d', `PayDay` = '%d', `Spawn` = '%d', `Skin` = '%d', `Job` = '%d', `JobMoney` = '%d', `Fraktion` = '%d', `FraktionSkin` = '%d', `FrakionsRank` = '%d',",
Spieler[playerid][pAdmin],Spieler[playerid][pGeschlecht],Spieler[playerid][pTutorial],Spieler[playerid][pLevel],Spieler[playerid][pRespekt],Spieler[playerid][pMaxRespekt],Spieler[playerid][pPayDay],Spieler[playerid][pSpawn],Spieler[playerid][pSkin],Spieler[playerid][pJob],Spieler[playerid][pJobMoney],Spieler[playerid][pFraktion],Spieler[playerid][pFraktionSkin],Spieler[playerid][pFrakionsRank]);
strcat(mainQuery,secondQuery);
format(secondQuery,sizeof(secondQuery),"`Portmanee` = '%d', `Bank` = '%d', `Sparbuch` = '%d', `Handynummer` = '%d', `Handyguthaben` = '%d', `Verwarnungen` = '%d', `Perso` = '%d', `Verheiratet` = '%s', `VerheiratetName` = '%s', `Kills` = '%d', `Tode` = '%d', `Verbrechen` = '%d', `Wanteds` = '%d', `Spielzeit` = '%d', `KnastSkill` = '%d', `Knast` = '%d',",
Spieler[playerid][pPortmanee],Spieler[playerid][pBank],Spieler[playerid][pSparbuch],Spieler[playerid][pHandynummer],Spieler[playerid][pHandyguthaben],Spieler[playerid][pVerwarnungen],Spieler[playerid][pPerso],Spieler[playerid][pVerheiratet],Spieler[playerid][pVerheiratetName],Spieler[playerid][pKills],Spieler[playerid][pTode],Spieler[playerid][pVerbrechen],Spieler[playerid][pWanteds],Spieler[playerid][pSpielzeit],Spieler[playerid][pKnastSkill],Spieler[playerid][pKnast]);
strcat(mainQuery,secondQuery);
format(secondQuery,sizeof(secondQuery),"`KnastZelle` = '%d', `KnastZeit` = '%d', `Tot` = '%d', `TotUnix` = '%d', `TotX` = '%f', `TotY` = '%f', `TotZ` = '%f', `Premium` = '%d', `PremiumTage` = '%d', `Materialien` = '%s', `MaterialienSafe` = '%s', `Drogen` = '%d', `DrogenSafe` = '%d', `BusSkill` = '%d', `BusSkillExp` = '%d', `BusSkillMaxExp` = '%d', `PilotExp` = '%d',",
Spieler[playerid][pKnastZelle],Spieler[playerid][pKnastZeit],Spieler[playerid][pTot],Spieler[playerid][pTotUnix],Spieler[playerid][pTotX],Spieler[playerid][pTotY],Spieler[playerid][pTotZ],Spieler[playerid][pPremium],Spieler[playerid][pPremiumTage],Spieler[playerid][pMaterialien],Spieler[playerid][pMaterialienSafe],Spieler[playerid][pDrogen],Spieler[playerid][pDrogenSafe],Spieler[playerid][pBusSkill],Spieler[playerid][pBusSkillExp],Spieler[playerid][pBusSkillMaxExp],Spieler[playerid][pPilotExp]);
strcat(mainQuery,secondQuery);
format(secondQuery,sizeof(secondQuery),"`Autoschein` = '%d', `AutoscheinPunkte` = '%d', `Flugschein` = '%d', `Bootsschein` = '%d', `Angelschein` = '%d', `Waffenschein` = '%d', `Zollschein` = '%d', `HausSchluessel` = '%d', `PaintballPunkte` = '%d', `Kanister` = '%d' WHERE Name = '%e'",
Spieler[playerid][pAutoschein],Spieler[playerid][pAutoscheinPunkte],Spieler[playerid][pFlugschein],Spieler[playerid][pBootsschein],Spieler[playerid][pAngelschein],Spieler[playerid][pWaffenschein],Spieler[playerid][pZollschein],Spieler[playerid][pHausSchluessel],Spieler[playerid][pPaintballPunkte],Spieler[playerid][pKanister],Spieler[playerid][pName]);
strcat(mainQuery,secondQuery);
mysql_function_query(handle,mainQuery,false,"","");
strdel(mainQuery,0,sizeof(mainQuery));
strdel(secondQuery,0,sizeof(secondQuery));
for(new vehSlot=0;vehSlot<MAX_PLAYER_VEHICLES;vehSlot++)
{
if(!strcmp(Spieler[playerid][pName], PrivateVehicle[playerid][vehSlot][vehBesitzer], true))
{
if(PrivateVehicle[playerid][vehSlot][modelid] != 0)
{
format(secondQuery, sizeof(secondQuery), "UPDATE `"#SERVERTAG"_fahrzeuge` SET `modelid`='%d', `vehPosX`='%f', `vehPosY`='%f', `vehPosZ`='%f', `vehPosA`='%f', `vehHealth`='%f', ",
PrivateVehicle[playerid][vehSlot][modelid],
PrivateVehicle[playerid][vehSlot][vehPosX],
PrivateVehicle[playerid][vehSlot][vehPosY],
PrivateVehicle[playerid][vehSlot][vehPosZ],
PrivateVehicle[playerid][vehSlot][vehPosA],
PrivateVehicle[playerid][vehSlot][vehHealth]);
strcat(mainQuery, secondQuery);
format(secondQuery, sizeof(secondQuery), "`vehColor1`='%d', `vehColor2`='%d', `vehPaintjob`='%d', `vehSpoiler`='%d', `vehHood`='%d', ",
PrivateVehicle[playerid][vehSlot][vehColor1],
PrivateVehicle[playerid][vehSlot][vehColor2],
PrivateVehicle[playerid][vehSlot][vehPaintjob],
PrivateVehicle[playerid][vehSlot][vehSpoiler],
PrivateVehicle[playerid][vehSlot][vehHood]);
strcat(mainQuery, secondQuery);
format(secondQuery, sizeof(secondQuery), "`vehRoof`='%d', `vehSideskirt`='%d', `vehLamps`='%d', `vehNitro`='%d', `vehExhaust`='%d', ",
PrivateVehicle[playerid][vehSlot][vehRoof],
PrivateVehicle[playerid][vehSlot][vehSideskirt],
PrivateVehicle[playerid][vehSlot][vehLamps],
PrivateVehicle[playerid][vehSlot][vehNitro],
PrivateVehicle[playerid][vehSlot][vehExhaust]);
strcat(mainQuery, secondQuery);
format(secondQuery, sizeof(secondQuery), "`vehWheels`='%d', `vehStereo`='%d', `vehHydraulics`='%d', `vehFrontBumper`='%d', `vehRearBumper`='%d', ",
PrivateVehicle[playerid][vehSlot][vehWheels],
PrivateVehicle[playerid][vehSlot][vehStereo],
PrivateVehicle[playerid][vehSlot][vehHydraulics],
PrivateVehicle[playerid][vehSlot][vehFrontBumper],
PrivateVehicle[playerid][vehSlot][vehRearBumper]);
strcat(mainQuery, secondQuery);
format(secondQuery, sizeof(secondQuery), "`vehVentRight`='%d', `vehVentLeft`='%d', `vehPreis`='%d', `vehNeonID`='%d', `vehNumberPlate`='%s', `vehFuel`='%f', ",
PrivateVehicle[playerid][vehSlot][vehVentRight],
PrivateVehicle[playerid][vehSlot][vehVentLeft],
PrivateVehicle[playerid][vehSlot][vehPreis],
PrivateVehicle[playerid][vehSlot][vehNeonID],
PrivateVehicle[playerid][vehSlot][vehNumberPlate],
Vehicle[PrivateVehicle[playerid][vehSlot][vehID]][vehFuel]);
strcat(mainQuery, secondQuery);
format(secondQuery, sizeof(secondQuery), "`vehKMStand`='%f', `vehInterior`='%d', `vehWorld`='%d' WHERE `vehBesitzer`='%s' AND `Slot`='%d'",
Vehicle[PrivateVehicle[playerid][vehSlot][vehID]][vehKMStand],
PrivateVehicle[playerid][vehSlot][vehInterior],
PrivateVehicle[playerid][vehSlot][vehWorld],
PrivateVehicle[playerid][vehSlot][vehBesitzer],
vehSlot);
strcat(mainQuery, secondQuery);
mysql_function_query(handle, mainQuery, false, "", "");
strdel(mainQuery, 0, sizeof(mainQuery));
strdel(secondQuery, 0, sizeof(secondQuery));
}
}
}
return 1;
}
MySQL-Log
[22:00:56] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "samp:dnr-city", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[22:00:56] [DEBUG] CMySQLHandle::Create - creating new connection..
[22:00:56] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[22:00:56] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[22:00:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:00:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[22:00:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[22:00:56] [DEBUG] mysql_errno - connection: 1
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `DNR_accounts` ( `ID` int(5) NOT NUL", callback: "(null)", format: "(null)"
[22:00:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:00:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:00:56] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `DNR_fahrzeuge` ( `ID` int(11) NOT N", callback: "(null)", format: "(null)"
[22:00:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[22:00:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[22:00:56] [DEBUG] CMySQLConnection::Connect - connection was successful
[22:00:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[22:00:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[22:00:56] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `DNR_häuser` ( `ID` int(11) NOT NULL", callback: "(null)", format: "(null)"
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `DNR_banrange` ( `ID` int(10) NOT NU", callback: "(null)", format: "(null)"
[22:00:56] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `DNR_multiaccount` ( `ID` int(10) NO", callback: "(null)", format: "(null)"
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `DNR_gutscheine` ( `ID` int(10) NOT ", callback: "(null)", format: "(null)"
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `DNR_tankstellen` ( `ID` int(10) NOT", callback: "(null)", format: "(null)"
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `DNR_fvehicles` ( `ID` int(10) NOT N", callback: "(null)", format: "(null)"
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `DNR_häuser`", callback: "LoadHouses", format: "(null)"
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `DNR_gutscheine`", callback: "LoadGutscheine", format: "(null)"
[22:00:56] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `DNR_tankstellen`", callback: "LoadTanken", format: "(null)"
[22:00:56] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 286.564 milliseconds
[22:00:56] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:00:56] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:00:56] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 177.328 milliseconds
[22:00:56] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:00:56] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:00:57] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 177.905 milliseconds
[22:00:57] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:00:57] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:00:57] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 241.655 milliseconds
[22:00:57] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:00:57] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:00:57] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 192.87 milliseconds
[22:00:57] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:00:57] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:00:58] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 176.261 milliseconds
[22:00:58] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:00:58] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:00:58] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 192.822 milliseconds
[22:00:58] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:00:58] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:00:58] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 230.449 milliseconds
[22:00:59] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:00:59] [DEBUG] CMySQLQuery::Execute[LoadHouses] - starting query execution
[22:00:59] [DEBUG] CMySQLQuery::Execute[LoadHouses] - query was successfully executed within 0.478 milliseconds
[22:00:59] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:00:59] [DEBUG] CMySQLQuery::Execute[LoadGutscheine] - starting query execution
[22:00:59] [DEBUG] Calling callback "LoadHouses"..
[22:00:59] [DEBUG] cache_get_data - connection: 1
[22:00:59] [DEBUG] CMySQLQuery::Execute[LoadGutscheine] - query was successfully executed within 4.104 milliseconds
[22:00:59] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:00:59] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[22:00:59] [DEBUG] CMySQLQuery::Execute[LoadTanken] - starting query execution
[22:00:59] [DEBUG] Calling callback "LoadGutscheine"..
[22:00:59] [DEBUG] cache_get_data - connection: 1
[22:00:59] [DEBUG] CMySQLQuery::Execute[LoadTanken] - query was successfully executed within 1.32 milliseconds
[22:00:59] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:00:59] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[22:00:59] [DEBUG] Calling callback "LoadTanken"..
[22:01:00] [DEBUG] cache_get_data - connection: 1
[22:01:00] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[22:01:36] [DEBUG] mysql_format - connection: 1, len: 66, format: "SELECT * FROM `DNR_accounts` WHERE `Name` = '%s'"
[22:01:36] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `DNR_accounts` WHERE `Name` = 'ArcadioN'", callback: "OnQueryFinish", format: "siii"
[22:01:36] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution
[22:01:36] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - query was successfully executed within 0.927 milliseconds
[22:01:36] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:01:37] [DEBUG] Calling callback "OnQueryFinish"..
[22:01:37] [DEBUG] cache_get_data - connection: 1
[22:01:37] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[22:01:39] [DEBUG] mysql_format - connection: 1, len: 256, format: "INSERT INTO `DNR_accounts` (`Name`,`Passwort`) VALUES ('%s', md5('%s'))"
[22:01:39] [DEBUG] mysql_query - connection: 1, query: "INSERT INTO `DNR_accounts` (`Name`,`Passwort`) VALUES ('ArcadioN", use_cache: true
[22:01:39] [DEBUG] CMySQLQuery::Execute - starting query execution
[22:01:39] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 59.904 milliseconds
[22:01:39] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:01:39] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[22:01:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `DNR_accounts` SET `Admin` = '0', `Geschlecht` = '1', `Tu", callback: "(null)", format: "(null)"
[22:01:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:01:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.791 milliseconds
[22:01:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:02:56] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `DNR_accounts` SET `Admin` = '0', `Geschlecht` = '1', `Tu", callback: "(null)", format: "(null)"
[22:02:56] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `DNR_accounts` SET `Eingeloggt` = '0' WHERE `Name` = 'Arc", callback: "(null)", format: "(null)"
[22:02:56] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:02:57] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.606 milliseconds
[22:02:57] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:02:57] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:02:57] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 29.756 milliseconds
[22:02:57] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
Ich hoffe es könnte mir jemand helfen. 
Lg
