Die Frage bleibt ja noch lohnt sich sowas denn noch?
Beiträge von ChristianW
-
-
Was ist denn da editiert?
Gleicher Text wie gestern!
-
Wir sind kein Supportforum für die Software.
-
Hey Fische,
Wieso öffnet sich der Dialog nichtmehr?
Eben gings noch habe aber dran rumgewerkelt?
if(!strcmp(cmd, "/hausinfo",true))
{
if(PlayerInfo[playerid][pHauskey] != 0)
{
new result[128],MSG_STRING[400],query[34],endstr[5000];
format(query,sizeof(query),"SELECT `Name` FROM `accounts` WHERE `Mietkey` = '%d' AND `Name` != `%s`",PlayerInfo[playerid][pHauskey],pn(playerid));
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
while(mysql_retrieve_row())
{
mysql_fetch_field_row(result,"Name");
format(endstr,sizeof(MSG_STRING),"%sName: %s\n",endstr,result);
return 1;
}
ShowPlayerDialog(playerid,DIALOG_HAUSINFO,DIALOG_STYLE_LIST,"Deine Mieter",MSG_STRING,"Beenden","");
}
else return ShowPlayerDialog(playerid,DIALOG_HAUSINFO,DIALOG_STYLE_MSGBOX,"Keine Mieter gefunden!","In deinem Haus hat sich bisher leider\nnoch kein Mieter eingemietet. Mache\ngegebenfalls Werbung oder\nsetze den Mietpreis tiefer!","Schliessen","");
}
else return SendClientMessage(playerid,WHITE,"Du hast noch kein Haus!");
} -
Wie kann ich eine Abfrage machen, ob ein Spieler mit dem Namen "Horst" Online ist? Also ich brauch das für nen Callback :b
new Name[24];
for(new i = 0; i < MAX_PLAYERS;i++)
{
GetPlayerName(i,Name,24);
if(!strcmp(Name,"Horst", true)) //Falls net geht false gerade unsicher
{
//Hier was danns ei soll
}
} -
Hey Com,
Ich habe folgegnden Error in der SQL Log:
[09:53:06] CMySQLHandler::Query(UPDATE `accounts` SET `Level`='0',`Adminrank`='2000', `Mietslot`='0',`Mietslot` = '0', `Supporter` = '0', `Donator` = '0',`Upgrade` = '0', `ConnectedTimer` = '0', `Neuling` = '0',`Register` = '0', `Sex` = '0', `Alter` = '0',`Origin` = '0', `CK` = '0', `Muted` = '0',`Knast` = '0', `Exp` = '0',`Accounts` = '0', `PlayerKreditTime` = '0', `PlayerKredit` = '0',`Crimes` = '0', `Kills` = '0', `ImKnast` = '0',`KnastTimer` = '0', `Tode` = '0', `Arrested` = '0',`WantedTode` = '0', `Telefonbuch` = '0', `Lottonr` = '0',Fische = '0', Gr.Fisch = '0', Job = '0',`PayCheck` = '0', `Rest` = '0', `HeadValue` = '0',`GangJailed` = '0', `Mauled` = '0', `Mats` = '0',`Drugplants` = '0', `Drugseems` = '0', `UnDrugs` = '0',`SLic` = '0', `Bizid` = '0', `Tutorial` = '0',`Bonus` = '0', `Spareparts` = '0', `MechaFuel` = '0',`TresorBomber` = '0', `Trucker` = '0', `Hausschlüssel` = '0',`Bikepunkte` = '0', `Autopunkte` = '0', `MatsBootmann` = '0',`Drogen` = '0', `Leader` = '0', `Member` = '0',`Rank` = '0', `Char` = '0', `ContractTime` = '0',`DeteSkill` = '0', `SexSkill` = '0', `BoxSkill` = '0',`LawSkill` = '0', `MechaSkill` = '0', `JackSkill` = '0',`CarSkill` = '0', `NewsSkill` = '0', `DrugsSkill` = '0',`KochSkill` = '0', `FischSkill` = '0', `SpielerLeben` = '0.000000',`Leben` = '0.000000', `Interior` = '0', `Lokal` = '0',`Team` = '0', `Model` = '0' `PNummer` = '0',`PHauskey` = '0', `PBizkey` = '0', `Autolic` = '0',`NewLic` = '0', `FlugLic` = '0', `FischLic` = '0',`GunLic` = '0', `pLKWLic` = '0', `RollerLic` = '0',`MotoLic` = '0', `AlcoholPerk` = '0', `DrugPerk` = '0',`MiserPerk` = '0', `PainPerk` = '0', `TraderPerk` = '0',`Tut` = '0', `Radio` = '0', `Warns` = '0',`Adjustable` = '1', `Fuel` = '0', `Married` = '0',`Ehepartner` = '', `InvWeapon` = '0', `InvAmmo` = '0',`InvWeapon2` = '0', `InvAmmo2` = '0', `InvDrugs` = '0',`InvMats` = '0', `Flugzeit` = '0', `Roadblock` = '0',`PlayMinutes` = '0', `GesamtMinuten` = '0', `MinutenSeitLogin` = '0',`MinutenSeitAnfang` = '0', `SFPass` = '0', `LVPass` = '0',`Guthaben` = '0', `Vertrag` = '0', `UhrId` = '0',`HandyID` = '0', `OwnPerso` = '0', `OwnAntrag` = '0',`PersoStop` = '0', `Gehalt` = '0', `FrakSperre` = '0',`BoxMats` = '0', `BoxDrugs` = '0', `PBan` = '0',`Tot` = '0', `FarmTime` = '0', `GDeaths` = '0',`GKills` = '0', `HatHaus` = '0', `Mietet` = '0',`Spawnanders` = '0', `Meldung` = '0', `Housekey` = '0',`RentHouseKey` = '0', `Story` = '1', `JobTime` = '0') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`PNummer` = '0',`PHauskey` = '0', `PBizkey` = '0', `Autolic` = '0',`NewLic` = '0' at line 1)
Der UpdateBefehl:
Spoiler anzeigen format(string, sizeof(string), "UPDATE `accounts` SET `Level`='%i',`Adminrank`='%i', `Mietslot`='%i',", PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pMietSlot]);
format(buffer, sizeof(buffer), "`Mietslot` = '%i', `Supporter` = '%i', `Donator` = '%i',",PlayerInfo[playerid][pMietSlot],PlayerInfo[playerid][pSupporter],PlayerInfo[playerid][pDonateRank]);
strcat(string, buffer);
format(buffer, sizeof(buffer),"`Upgrade` = '%i', `ConnectedTimer` = '%i', `Neuling` = '%i',",PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pNeuling]);
strcat(string,buffer);
format(buffer, sizeof(buffer),"`Register` = '%i', `Sex` = '%i', `Alter` = '%i',",PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pReg]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Origin` = '%i', `CK` = '%i', `Muted` = '%i',",PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pCK], PlayerInfo[playerid][pMuted]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Knast` = '%i', `Exp` = '%i',", PlayerInfo[playerid][pKnast],PlayerInfo[playerid][pExp],1);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Accounts` = '%i', `PlayerKreditTime` = '%i', `PlayerKredit` = '%i',",PlayerInfo[playerid][pAccount],PlayerInfo[playerid][pPlayerKreditDauer],PlayerInfo[playerid][pPlayerKredit]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Crimes` = '%i', `Kills` = '%i', `ImKnast` = '%i',",PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pJailed]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`KnastTimer` = '%i', `Tode` = '%i', `Arrested` = '%i',",PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArrested]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`WantedTode` = '%i', `Telefonbuch` = '%i', `Lottonr` = '%i',",PlayerInfo[playerid][pWantedDeaths], PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pLottoNr]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Fische = '%i', Gr.Fisch = '%i', Job = '%i',",PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pJob]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`PayCheck` = '%i', `Rest` = '%i', `HeadValue` = '%i',",PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pRest],PlayerInfo[playerid][pHeadValue]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`GangJailed` = '%i', `Mauled` = '%i', `Mats` = '%i',",PlayerInfo[playerid][pGangJailed],PlayerInfo[playerid][pMauled],PlayerInfo[playerid][pMats]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Drugplants` = '%i', `Drugseems` = '%i', `UnDrugs` = '%i',",PlayerInfo[playerid][pDrugplants],PlayerInfo[playerid][pDrugseems],PlayerInfo[playerid][pUnDrugs]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`SLic` = '%i', `Bizid` = '%i', `Tutorial` = '%i',",PlayerInfo[playerid][pSLic],PlayerInfo[playerid][pBizid],PlayerInfo[playerid][pTutorial]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Bonus` = '%i', `Spareparts` = '%i', `MechaFuel` = '%i',",PlayerInfo[playerid][pBonus],PlayerInfo[playerid][pSP],PlayerInfo[playerid][pMechaF]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`TresorBomber` = '%i', `Trucker` = '%i', `Hausschlüssel` = '%i',", PlayerInfo[playerid][pBombe],PlayerInfo[playerid][pTrucker],PlayerInfo[playerid][pHauskey]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Bikepunkte` = '%i', `Autopunkte` = '%i', `MatsBootmann` = '%i',", PlayerInfo[playerid][pBikepunkte], PlayerInfo[playerid][pAutopunkte],PlayerInfo[playerid][pBootsmann]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Drogen` = '%i', `Leader` = '%i', `Member` = '%i',",PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Rank` = '%i', `Char` = '%i', `ContractTime` = '%i',", PlayerInfo[playerid][pRank], PlayerInfo[playerid][pChar], PlayerInfo[playerid][pContractTime]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`DeteSkill` = '%i', `SexSkill` = '%i', `BoxSkill` = '%i',",PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pSexSkill],PlayerInfo[playerid][pBoxSkill]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`LawSkill` = '%i', `MechaSkill` = '%i', `JackSkill` = '%i',",PlayerInfo[playerid][pLawSkill],PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pJackSkill]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`CarSkill` = '%i', `NewsSkill` = '%i', `DrugsSkill` = '%i',",PlayerInfo[playerid][pCarSkill],PlayerInfo[playerid][pNewsSkill],PlayerInfo[playerid][pDrugsSkill]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`KochSkill` = '%i', `FischSkill` = '%i', `SpielerLeben` = '%f',",PlayerInfo[playerid][pCookSkill], PlayerInfo[playerid][pFishSkill],PlayerInfo[playerid][pHealth]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Leben` = '%f', `Interior` = '%i', `Lokal` = '%i',",PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pInt],PlayerInfo[playerid][pLocal]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Team` = '%i', `Model` = '%i' `PNummer` = '%i',",PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pModel],PlayerInfo[pPnumber]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`PHauskey` = '%i', `PBizkey` = '%i', `Autolic` = '%i',",PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pCarLic]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`NewLic` = '%i', `FlugLic` = '%i', `FischLic` = '%i',",PlayerInfo[playerid][pNewLic],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pFishLic]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`GunLic` = '%i', `pLKWLic` = '%i', `RollerLic` = '%i',",PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pLKWLic],PlayerInfo[playerid][pRollerLic]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`MotoLic` = '%i', `AlcoholPerk` = '%i', `DrugPerk` = '%i',",PlayerInfo[playerid][pMotoLic],PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pDrugPerk]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`MiserPerk` = '%i', `PainPerk` = '%i', `TraderPerk` = '%i',",PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pTraderPerk]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Tut` = '%i', `Radio` = '%i', `Warns` = '%i',",PlayerInfo[playerid][pTut],PlayerInfo[playerid][pRadio],PlayerInfo[playerid][pWarns]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Adjustable` = '%i', `Fuel` = '%i', `Married` = '%i',",PlayerInfo[playerid][pAdjustable],PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pMarried]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Ehepartner` = '%s', `InvWeapon` = '%i', `InvAmmo` = '%i',",PlayerInfo[playerid][pMarriedTo],PlayerInfo[playerid][pInvWeapon],PlayerInfo[playerid][pInvAmmo]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`InvWeapon2` = '%i', `InvAmmo2` = '%i', `InvDrugs` = '%i',",PlayerInfo[playerid][pInvWeapon2],PlayerInfo[playerid][pInvAmmo],PlayerInfo[playerid][pInvDrugs]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`InvMats` = '%i', `Flugzeit` = '%i', `Roadblock` = '%i',",PlayerInfo[playerid][pInvMats],PlayerInfo[playerid][pFlugTime],PlayerInfo[playerid][pRoadblock]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`PlayMinutes` = '%i', `GesamtMinuten` = '%i', `MinutenSeitLogin` = '%i',",PlayerInfo[playerid][pPlayMinutes],PlayerInfo[playerid][pGesamtMinutes],PlayerInfo[playerid][pMinutesSinceLogin]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`MinutenSeitAnfang` = '%i', `SFPass` = '%i', `LVPass` = '%i',",PlayerInfo[playerid][pMinutesSinceAn],PlayerInfo[playerid][pSFPASS],PlayerInfo[playerid][pLVPASS]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Guthaben` = '%i', `Vertrag` = '%i', `UhrId` = '%i',",PlayerInfo[playerid][pHandyGeld],PlayerInfo[playerid][pHandyVer],PlayerInfo[playerid][pUhrID]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`HandyID` = '%i', `OwnPerso` = '%i', `OwnAntrag` = '%i',",PlayerInfo[playerid][pHandyID],PlayerInfo[playerid][pOwnPerso],PlayerInfo[playerid][pOwnAntrag]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`PersoStop` = '%i', `Gehalt` = '%i', `FrakSperre` = '%i',",PlayerInfo[playerid][pPersoStop],PlayerInfo[playerid][pGehalt],PlayerInfo[playerid][pFrakSperre]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`BoxMats` = '%i', `BoxDrugs` = '%i', `PBan` = '%i',",PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],PlayerInfo[playerid][pban]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Tot` = '%i', `FarmTime` = '%i', `GDeaths` = '%i',",PlayerInfo[playerid][pTot], PlayerInfo[playerid][pFarmTime], PlayerInfo[playerid][pGDeaths]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`GKills` = '%i', `HatHaus` = '%i', `Mietet` = '%i',",PlayerInfo[playerid][pGKills], PlayerInfo[playerid][pHatHaus], PlayerInfo[playerid][pMietet]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`Spawnanders` = '%i', `Meldung` = '%i', `Housekey` = '%i',",PlayerInfo[playerid][pSpawnanders],PlayerInfo[playerid][pMeldung],PlayerInfo[playerid][pHouseKey]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"`RentHouseKey` = '%i', `Story` = '%i', `JobTime` = '%i'",PlayerInfo[playerid][pRentHouseKey],PlayerInfo[playerid][pStory], PlayerInfo[playerid][pJobTime]);
strcat(string,buffer);
mysql_query(string);Danke
-
Entferne mal den * hinter Account so wie hier:
format(buffer,sizeof(buffer),"Account = '%i', PlayerKreditTime = '%i', PlayerKredit = '%i',",PlayerInfo[playerid][pAccount],PlayerInfo[playerid][pPlayerKreditDauer],PlayerInfo[playerid][pPlayerKredit]);Habe ich :
Aber früher mi mysql_setint ging auch aber egal ich habe jez noch überal ``gemacht lets test
Again:
Zitat- An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`PNummer` = '0',`PHauskey` = '0', `PBizkey` = '0', `Autolic` = '0',`NewLic` = '0' at line 1)
@|Prototype|: Hast du ne Antwort
-
Der Error sagt dir doch, dass du einen Error in der Syntax der Abfrage hast
Und der Error sagt dir auch noch wo genau
Ich würde vermuten, dass es das Sternchen nach Account ist..
Evtl. musst du die Spaltennamen auch mal mit diesen `` umranden. Also z.B. `Muted` = '0'
Mir wurde gesagt das ist nicht zwingend NotwendigEdit: Geht nicht das bricht dann ab?
-
Hey,
Ich bekomme irgendwie bei meinem Update Befehl einen Error!
Der String ist auf 5000 und daher ist er doch nicht zu klein:
Errorcode:
Spoiler anzeigen [09:10:49] CMySQLHandler::Query(UPDATE `accounts` SET `Level`='0',`Adminrank`='2000',Mietslot='0',Mietslot = '0',Supporter = '0',Donator = '0',Upgrade = '0',ConnectedTimer = '0',Neuling = '0',Register = '0', Sex = '0', Alter = '0',Origin = '0', CK = '0', Muted = '0',Knast = '0', Exp = '0',Account* = '0', PlayerKreditTime = '0', PlayerKredit = '0',Crimes = '0', Kills = '0', ImKnast = '0',KnastTimer = '0', Tode = '0', Arrested = '0',WantedTode = '0', Telefonbuch = '0', Lottonr = '0',Fische = '0', Gr.Fisch = '0', Job = '0',PayCheck = '0', Rest = '0', HeadValue = '0',GangJailed = '0', Mauled = '0', Mats = '0',Drugplant = '0', Drugseems = '0', UnDrugs = '0',SLic = '0', Bizid = '0', Tutorial = '0',Bonus = '0', Spareparts = '0', MechaFuel = '0',TresorBomber = '0', Trucker = '0', Hausschlüssel = '0',Bikepunkte = '0', Autopunkte = '0', MatsBootmann = '0',Drogen = '0', Leader = '0', Member = '0',Rank = '0', Char = '0', ContractTime = '0',DeteSkill = '0', SexSkill = '0', BoxSkill = '0',Lawskill = '0', MechaSkill = '0', JackSkill = '0',CarSkill = '0', NewsSkill = '0', DrugsSkill = '0',KochSkill = '0', FischSkill = '0', SpielerLeben = '0.000000',Leben = '0.000000', Interior = '0', Lokal = '0',Team = '0', Model = '0'PNummer = '0',PHauskey = '0', PBizkey = '0', Autolic = '0',NewLic = '0', FlugLic = '0', FischLic = '0',GunLic = '0', pLKWLic = '0', RollerLic = '0',MotoLic = '0', AlcoholPerk = '0', DrugPerk = '0',MiserPerk = '0', PainPerk = '0', TraderPerk = '0',Tut = '0', Radio = '0', Warns = '0',Adjustable = '1', Fuel = '0', Married = '0',Ehepartner = '', InvWeapon = '0', InvAmmo = '0',InvWeapon2 = '0', InvAmmo2 = '0', InvDrugs = '0',InvMats = '0', Flugzeit = '0', Roadblock = '0',PlayMinutes = '1', GesamtMinuten = '1', MinutenSeitLogin = '1',MinutenSeitAnfang = '1', SFPass = '0', LVPass = '0',Guthaben = '0', Vertrag = '0', UhrId = '0',HandyID = '0', OwnPerso = '0', OwnAntrag = '0',PersoStop = '0', Gehalt = '0', FrakSperre = '0',BoxMats = '0', BoxDrugs = '0', PBan = '0',Tot = '0', FarmTime = '0', GDeaths = '0',GKills = '0', HatHaus = '0', Mietet = '0',Spawnanders = '0', Meldung = '0', Housekey = '0',RentHouseKey = '0', Story = '2', JobTime = '0') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Alter = '0',Origin = '0', CK = '0', Muted = '0',Knast = '0', Exp = '0',Account* ' at line 1)Zeilen(ca 30)
format(string, sizeof(string), "UPDATE `accounts` SET `Level`='%i',`Adminrank`='%i',Mietslot='%i',", PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pMietSlot]);
format(buffer, sizeof(buffer), "Mietslot = '%i',Supporter = '%i',Donator = '%i',",PlayerInfo[playerid][pMietSlot],PlayerInfo[playerid][pSupporter],PlayerInfo[playerid][pDonateRank]);
strcat(string, buffer);
format(buffer, sizeof(buffer),"Upgrade = '%i',ConnectedTimer = '%i',Neuling = '%i',",PlayerInfo[playerid][gPupgrade],PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pNeuling]);
strcat(string,buffer);
format(buffer, sizeof(buffer),"Register = '%i', Sex = '%i', Alter = '%i',",PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pReg]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Origin = '%i', CK = '%i', Muted = '%i',",PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pCK], PlayerInfo[playerid][pMuted]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Knast = '%i', Exp = '%i',", PlayerInfo[playerid][pKnast],PlayerInfo[playerid][pExp],1);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Account* = '%i', PlayerKreditTime = '%i', PlayerKredit = '%i',",PlayerInfo[playerid][pAccount],PlayerInfo[playerid][pPlayerKreditDauer],PlayerInfo[playerid][pPlayerKredit]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Crimes = '%i', Kills = '%i', ImKnast = '%i',",PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pJailed]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"KnastTimer = '%i', Tode = '%i', Arrested = '%i',",PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArrested]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"WantedTode = '%i', Telefonbuch = '%i', Lottonr = '%i',",PlayerInfo[playerid][pWantedDeaths], PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pLottoNr]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Fische = '%i', Gr.Fisch = '%i', Job = '%i',",PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pJob]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"PayCheck = '%i', Rest = '%i', HeadValue = '%i',",PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pRest],PlayerInfo[playerid][pHeadValue]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"GangJailed = '%i', Mauled = '%i', Mats = '%i',",PlayerInfo[playerid][pGangJailed],PlayerInfo[playerid][pMauled],PlayerInfo[playerid][pMats]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Drugplant = '%i', Drugseems = '%i', UnDrugs = '%i',",PlayerInfo[playerid][pDrugplants],PlayerInfo[playerid][pDrugseems],PlayerInfo[playerid][pUnDrugs]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"SLic = '%i', Bizid = '%i', Tutorial = '%i',",PlayerInfo[playerid][pSLic],PlayerInfo[playerid][pBizid],PlayerInfo[playerid][pTutorial]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Bonus = '%i', Spareparts = '%i', MechaFuel = '%i',",PlayerInfo[playerid][pBonus],PlayerInfo[playerid][pSP],PlayerInfo[playerid][pMechaF]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"TresorBomber = '%i', Trucker = '%i', Hausschlüssel = '%i',", PlayerInfo[playerid][pBombe],PlayerInfo[playerid][pTrucker],PlayerInfo[playerid][pHauskey]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Bikepunkte = '%i', Autopunkte = '%i', MatsBootmann = '%i',", PlayerInfo[playerid][pBikepunkte], PlayerInfo[playerid][pAutopunkte],PlayerInfo[playerid][pBootsmann]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Drogen = '%i', Leader = '%i', Member = '%i',",PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Rank = '%i', Char = '%i', ContractTime = '%i',", PlayerInfo[playerid][pRank], PlayerInfo[playerid][pChar], PlayerInfo[playerid][pContractTime]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"DeteSkill = '%i', SexSkill = '%i', BoxSkill = '%i',",PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pSexSkill],PlayerInfo[playerid][pBoxSkill]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Lawskill = '%i', MechaSkill = '%i', JackSkill = '%i',",PlayerInfo[playerid][pLawSkill],PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pJackSkill]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"CarSkill = '%i', NewsSkill = '%i', DrugsSkill = '%i',",PlayerInfo[playerid][pCarSkill],PlayerInfo[playerid][pNewsSkill],PlayerInfo[playerid][pDrugsSkill]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"KochSkill = '%i', FischSkill = '%i', SpielerLeben = '%f',",PlayerInfo[playerid][pCookSkill], PlayerInfo[playerid][pFishSkill],PlayerInfo[playerid][pHealth]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Leben = '%f', Interior = '%i', Lokal = '%i',",PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pInt],PlayerInfo[playerid][pLocal]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Team = '%i', Model = '%i'PNummer = '%i',",PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pModel],PlayerInfo[pPnumber]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"PHauskey = '%i', PBizkey = '%i', Autolic = '%i',",PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pCarLic]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"NewLic = '%i', FlugLic = '%i', FischLic = '%i',",PlayerInfo[playerid][pNewLic],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pFishLic]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"GunLic = '%i', pLKWLic = '%i', RollerLic = '%i',",PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pLKWLic],PlayerInfo[playerid][pRollerLic]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"MotoLic = '%i', AlcoholPerk = '%i', DrugPerk = '%i',",PlayerInfo[playerid][pMotoLic],PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pDrugPerk]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"MiserPerk = '%i', PainPerk = '%i', TraderPerk = '%i',",PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pTraderPerk]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Tut = '%i', Radio = '%i', Warns = '%i',",PlayerInfo[playerid][pTut],PlayerInfo[playerid][pRadio],PlayerInfo[playerid][pWarns]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Adjustable = '%i', Fuel = '%i', Married = '%i',",PlayerInfo[playerid][pAdjustable],PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pMarried]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Ehepartner = '%s', InvWeapon = '%i', InvAmmo = '%i',",PlayerInfo[playerid][pMarriedTo],PlayerInfo[playerid][pInvWeapon],PlayerInfo[playerid][pInvAmmo]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"InvWeapon2 = '%i', InvAmmo2 = '%i', InvDrugs = '%i',",PlayerInfo[playerid][pInvWeapon2],PlayerInfo[playerid][pInvAmmo],PlayerInfo[playerid][pInvDrugs]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"InvMats = '%i', Flugzeit = '%i', Roadblock = '%i',",PlayerInfo[playerid][pInvMats],PlayerInfo[playerid][pFlugTime],PlayerInfo[playerid][pRoadblock]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"PlayMinutes = '%i', GesamtMinuten = '%i', MinutenSeitLogin = '%i',",PlayerInfo[playerid][pPlayMinutes],PlayerInfo[playerid][pGesamtMinutes],PlayerInfo[playerid][pMinutesSinceLogin]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"MinutenSeitAnfang = '%i', SFPass = '%i', LVPass = '%i',",PlayerInfo[playerid][pMinutesSinceAn],PlayerInfo[playerid][pSFPASS],PlayerInfo[playerid][pLVPASS]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Guthaben = '%i', Vertrag = '%i', UhrId = '%i',",PlayerInfo[playerid][pHandyGeld],PlayerInfo[playerid][pHandyVer],PlayerInfo[playerid][pUhrID]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"HandyID = '%i', OwnPerso = '%i', OwnAntrag = '%i',",PlayerInfo[playerid][pHandyID],PlayerInfo[playerid][pOwnPerso],PlayerInfo[playerid][pOwnAntrag]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"PersoStop = '%i', Gehalt = '%i', FrakSperre = '%i',",PlayerInfo[playerid][pPersoStop],PlayerInfo[playerid][pGehalt],PlayerInfo[playerid][pFrakSperre]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"BoxMats = '%i', BoxDrugs = '%i', PBan = '%i',",PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],PlayerInfo[playerid][pban]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Tot = '%i', FarmTime = '%i', GDeaths = '%i',",PlayerInfo[playerid][pTot], PlayerInfo[playerid][pFarmTime], PlayerInfo[playerid][pGDeaths]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"GKills = '%i', HatHaus = '%i', Mietet = '%i',",PlayerInfo[playerid][pGKills], PlayerInfo[playerid][pHatHaus], PlayerInfo[playerid][pMietet]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"Spawnanders = '%i', Meldung = '%i', Housekey = '%i',",PlayerInfo[playerid][pSpawnanders],PlayerInfo[playerid][pMeldung],PlayerInfo[playerid][pHouseKey]);
strcat(string,buffer);
format(buffer,sizeof(buffer),"RentHouseKey = '%i', Story = '%i', JobTime = '%i'",PlayerInfo[playerid][pRentHouseKey],PlayerInfo[playerid][pStory], PlayerInfo[playerid][pJobTime]);
strcat(string,buffer);
mysql_query(string);Danke an eure Hilfe
-
Hey,
Wieso failt der Rentroom Befehl?
Dieses Haus ist unverkauft steht da
if(!strcmp(cmd,"/rentroom", true))
{
for(new i = 1; i < MaxHaus; i++)
{
if(!IsPlayerInRangeOfPoint(playerid,5.0,PlayerHaus[i][Hausx],PlayerHaus[i][Hausy],PlayerHaus[i][Hausz])) return SendClientMessage(playerid,WHITE,"Du bist an keinem Haus!");
if(PlayerHaus[i][Verkauft] != 0) return SendClientMessage(playerid,WHITE,"Dieses Haus ist unverkauft!");
if(PlayerHaus[i][Mietbar] != 0) return SendClientMessage(playerid,WHITE,"Der Besitzer wünscht keine Mieter!");
{
PlayerHaus[i][Mieter]++;
PlayerInfo[playerid][pMietKey] = PlayerHaus[i][Hausid];
SendClientMessage(playerid,WHITE,"Du hast dich in das Haus eingemietet!");
}
}
return 1;
} -
Erledigt
-
Mach den mal raus, das bringt nämlich 0Mal als Admin gestartet (SAMP sowie GTA) -> Einstellung und so
Wenn das nicht hilft, dann bennene den GTA SA Ordner mal umIch habe erstmal nen neuen Gta ordner geholt schaue ob der geht melde mich denn
-
Vlt ein mal ein Wettersystem das man da für die drei Städte einstellen kann
-
haste ne crashlog ?
Das kommtSQL
Alles anzeigenSA-MP 0.3x-R1-2 Exception At Address: 0x0040FB80 Base: 0x03BD0000 Registers: EAX: 0x00000FB4 EBX: 0x008D6264 ECX: 0x00000000 EDX: 0x002896C8 ESI: 0x008E48AC EDI: 0x008E48AC EBP: 0x00000000 ESP: 0x0028FC40 EFLAGS: 0x00210216 Stack: +0000: 0x0041B207 0x00000030 0x008E48AC 0x00C8E0C8 +0010: 0x00000FB4 0x0D288B38 0x008E48AC 0x0028FF74 +0020: 0x0083723B 0xFFFFFFFF 0x00808A7A 0x008E48AC +0030: 0x00000FB4 0x0D288B38 0x00000040 0x00000000 +0040: 0x008E48AC 0x0D288B38 0x0000001C 0x00000FC0 +0050: 0x00036003 0xFFFFFFFF 0x008241AF 0x0074BB74 +0060: 0x008D6264 0x00000FB4 0x0253F2FA 0x0028FCE0 +0070: 0x008E48AC 0x00B44874 0x00000254 0x00002E01 +0080: 0x00036003 0x00036003 0x00036003 0x0000000C +0090: 0x00000004 0x0028FCEC 0x00000000 0x0000001C +00A0: 0x0E5896F8 0x00000034 0x00B44874 0x00000010 +00B0: 0x00036003 0x00002E90 0x0000001C 0x00000000 +00C0: 0x00000000 0x005373AB 0x0000001C 0x008E48AC +00D0: 0x00000254 0x00B44874 0x00002E90 0x0040C814 +00E0: 0x008E48AC 0x00B44874 0x00002E90 0x00000254 +00F0: 0x00000000 0x008E4A60 0x0C07087A 0x0DDDB800 +0100: 0x0028A800 0x008E7B50 0x0028FF74 0x75C16731 +0110: 0x58AF09F4 0xFFFFFFFE 0x0040E2CA 0x0DDDB800 +0120: 0xFFFFFFFF 0x00000000 0x00000008 0x00000000 +0130: 0x75103524 0x00000000 0x00000000 0x00000515 +0140: 0x0040EAC8 0x00000000 0x00000001 0x00000000 +0150: 0x00863B10 0x005BA263 0x00000000 0x00863A6C +0160: 0x0086A578 0x00000000 0x0053BCAB 0x00863B10 +0170: 0x00863B10 0x00863A90 0x00863B10 0x0000000A +0180: 0x0053E593 0x00863B10 0x00748D00 0x75A94BC4 +0190: 0x00000000 0x0028FF84 0x7FFDE000 0x01713468 +01A0: 0x00000008 0x04160048 0x00000008 0x00000100 +01B0: 0x00000008 0x00000102 0x44200000 0x43C00000 +01C0: 0x00000000 0x00000000 0x00000500 0x00000300 +01D0: 0x00000000 0x0028FE50 0x003006FC 0x00000200 +01E0: 0x00000000 0x01800280 0x00429D96 0x00000280 +01F0: 0x00000180 0x0000002C 0x0028FE28 0x00825EA4 +0200: 0x0028FF74 0x00825EA4 0x75A94BC4 0x7FFDE000 +0210: 0x00821D17 0x00000065 0x00000065 0x0028FF84 +0220: 0x008246F1 0x00400000 0x00000000 0x01A032DD +0230: 0x0000000A 0x00000094 0x00000005 0x00000001 +0240: 0x00000A28 0x00000002 0x76726553 0x20656369 +0250: 0x6B636150 0x00003320 0x00000000 0x00000000 +0260: 0x00000000 0x00000000 0x00000000 0x00000000 +0270: 0x00000000 0x00000000 0x00000000 0x00000000 SCM Op: 0x0, lDbg: 0 LastRendObj: 0 Game Version: US 1.0
-
eig. kann das nicht an windows 8 liegen
Super was soll ich jez machen -
Hey,
Aus unerklärlichen Gründen crasht schon wiedr auf Windows 8 mein Samp nach dem durchlauf des LAdebalkens?
EIngestellt habe ich schon die Kompantriblität!
Grüsse
-
Schonmal was von Recourcensparen gehört
Anonymos seinsmüsste grhen!
-
-
BITTE NICHT MADDINS TUT NEHMEN:
Du hast später 100 Variablen:
Wenn 6 Connecten lädst du 600 Querys:
Folglich: Server steht 36 Sekunden still und stürzt ab!
-
Ach fuu ich dummer Junge xD