Kann wer weiterhelfen?
Beiträge von BeatsNinja114
-
-
Hab mir dein Stock kopiert bekomme die Fehler
D:\Dekstop\SAMP\Sky of Limit\gamemodes\script.pwn(11786) : error 035: argument type mismatch (argument 1)
D:\Dekstop\SAMP\Sky of Limit\gamemodes\script.pwn(11795) : error 035: argument type mismatch (argument 1)
D:\Dekstop\SAMP\Sky of Limit\gamemodes\script.pwn(11796) : error 017: undefined symbol "mysql_store_result"
D:\Dekstop\SAMP\Sky of Limit\gamemodes\script.pwn(11797) : error 017: undefined symbol "mysql_num_rows"
D:\Dekstop\SAMP\Sky of Limit\gamemodes\script.pwn(11799) : error 017: undefined symbol "mysql_fetch_row"
D:\Dekstop\SAMP\Sky of Limit\gamemodes\script.pwn(11818) : error 017: undefined symbol "mysql_free_result"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase6 Errors.
-
Hab ich schon gemacht geht immernoch nicht. Also erst nach restart kommt der PickUp
-
Hallo,
Ich hab leider Probleme mit dem Autohaussystem das Problem ist wenn ich ein Autohaus erstelle das es erst nach restart ein PickUp da ist, Ich habe es schon versucht etwas umzuschreiben aber leider finde ich den Fehler nicht.
Bitte ich bräuchte hilfe wenn ihr noch Code braucht sagt es mir ruhigocmd@2:ccd,createcardealer(playerid,params[])
{
new name[32],price,level,Float:xPos[3];
if(pInfo[playerid][pAdmin] != 5)return 1;
if(sscanf(params,"dds[32]",price,level,name))return SendClientMessage(playerid,COLOR_GREY,"Benutze: /ccd [Preis] [Level] [Name]");
for(new i;i<MAX_AUTOHAUS;i++) {
if(AHInfo[i][zCreated])continue;
new str[256];
GetPlayerPos(playerid,xPos[0],xPos[1],xPos[2]);
format(str,sizeof str,"INSERT INTO `cardealers` (`Owner`, `PosX`, `PosY`, `PosZ`, `Name`, `Price`, `Level`, `LPosX`, `LPosY`, `LPosZ`, `cbought`) VALUES ('Niemand', '%f', '%f', '%f', '%s', '%d', '%d', '%f', '%f', '%f', '%f')",xPos[0],xPos[1],xPos[2],name,price,level,xPos[0],xPos[1],xPos[2],cbought);
mysql_pquery(dbHandle,str);
format(str,256,"SELECT * FROM `cardealers` WHERE `ID` = '%d'",i);
return mysql_pquery(dbHandle,str,"OnQueryFinish","sd",str,QuerySelectAllCarDealers);
}
return 1;
}
for(new i;i<MAX_AUTOHAUS;i++) {
if(!AHInfo[i][zCreated])continue;
if(IsPlayerInRangeOfPoint(playerid,3,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ]))
{
if((!strcmp(AHInfo[i][zOwner],"Niemand",true)))
{
if(pInfo[playerid][pMoney] >= AHInfo[i][zPrice])
{
if(GetPlayerScore(playerid) >= AHInfo[i][zLevel])
{
new q[128];
GetPlayerName(playerid,sendername,sizeof sendername);
pInfo[playerid][pMoney] -= AHInfo[i][zPrice];
pInfo[playerid][pAH] = i+1;
format(AHInfo[i][zOwner],24,"%s",sendername);
SendClientMessage(playerid,COLOR_LIGHTGREEN,"Du hast dir das Autohaus erfolgreich gekauft!");
SendClientMessage(playerid,COLOR_GREY,"Autohaus verwalten: /cardealer");
KillCarDealer(i);
format(q,128,"SELECT * FROM `cardealers` WHERE `ID` = '%d'",i+1);
return mysql_pquery(dbHandle,q,"OnQueryFinish","sd",q,QueryCallCarDealer);
}
else
{
return SendClientMessage(playerid,COLOR_LIGHTRED,"Dein Level reicht nicht aus, um dieses Autohaus zu kaufen!");
}
}
else
{
return SendClientMessage(playerid,COLOR_LIGHTRED,"Du hast nicht genug Geld, um dieses Autohaus zu kaufen!");
}
}
else
{
return SendClientMessage(playerid,COLOR_LIGHTRED,"Dieses Autohaus ist nicht zu verkaufen!");
}
}
}
case QueryCallCarDealer:
{
cache_get_data(rows,fields);
printf("CallCarDealer Rows: %d",rows);
if(rows == 1) {
for(new i;i<MAX_AUTOHAUS;i++) {
if(AHInfo[i][zCreated])continue;
cache_get_field_content(0,"ID",result);
AHInfo[i][zID] = strval(result);
cache_get_field_content(0,"Owner",result);
format(AHInfo[i][zOwner],32,"%s",result);
cache_get_field_content(0,"PosX",result);
AHInfo[i][zPosX] = floatstr(result);
cache_get_field_content(0,"PosY",result);
AHInfo[i][zPosY] = floatstr(result);
cache_get_field_content(0,"PosZ",result);
AHInfo[i][zPosZ] = floatstr(result);
cache_get_field_content(0,"Bank",result);
AHInfo[i][zBank] = strval(result);
cache_get_field_content(0,"Name",result);
format(AHInfo[i][zName],24,"%s",result);
cache_get_field_content(0,"Price",result);
AHInfo[i][zPrice] = strval(result);
cache_get_field_content(0,"Level",result);
AHInfo[i][zLevel] = strval(result);
cache_get_field_content(0,"OrderCap",result);
AHInfo[i][zOrderCap] = strval(result);
cache_get_field_content(0,"StoreCap",result);
AHInfo[i][zStoreCap] = strval(result);
cache_get_field_content(0,"LPosX",result);
AHInfo[i][zLPosX] = floatstr(result);
cache_get_field_content(0,"LPosY",result);
AHInfo[i][zLPosY] = floatstr(result);
cache_get_field_content(0,"LPosZ",result);
AHInfo[i][zLPosZ] = floatstr(result);
cache_get_field_content(0,"LPosA",result);
AHInfo[i][zLPosA] = floatstr(result);
if(AHInfo[i][cbought] == 0)
{
AHInfo[i][zPickup]=CreatePickup(1273,1,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ],0);
format(str,128,"** %s **\n Besitzer: %s\n Dieses Autohaus ist zu verkaufen!\nPreis: %s€\nLevel: %d\nAutohaus kaufen: /buy",AHInfo[i][zName],AHInfo[i][zOwner],inspoints(AHInfo[i][zPrice]),AHInfo[i][zLevel]);
AHInfo[i][zLabel]=Create3DTextLabel(str,COLOR_AHLABEL,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ],20,0,1);
}
else
{
AHInfo[i][zPickup]=CreatePickup(1272,1,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ],0);
format(str,128,"** %s **\nBesitzer: %s",AHInfo[i][zName],AHInfo[i][zOwner]);
AHInfo[i][zLabel]=Create3DTextLabel(str,COLOR_AHLABEL,AHInfo[i][zPosX],AHInfo[i][zPosY],AHInfo[i][zPosZ],20,0,1);
}
return AHInfo[i][zCreated] = true;
}
}
}
case QuerySelectAllCarDealers:
{
cache_get_data(rows,fields);
if(rows > 0 && rows < 6) {
oldtime=GetTickCount();
new idx,string[128];
for(;idx<rows;idx++) {
cache_get_field_content(idx,"ID",result);
AHInfo[idx][zID] = strval(result);
cache_get_field_content(idx,"Owner",result);
format(AHInfo[idx][zOwner],32,"%s",result);
cache_get_field_content(idx,"PosX",result);
AHInfo[idx][zPosX] = floatstr(result);
cache_get_field_content(idx,"PosY",result);
AHInfo[idx][zPosY] = floatstr(result);
cache_get_field_content(idx,"PosZ",result);
AHInfo[idx][zPosZ] = floatstr(result);
cache_get_field_content(idx,"Bank",result);
AHInfo[idx][zBank] = strval(result);
cache_get_field_content(idx,"Name",result);
format(AHInfo[idx][zName],24,"%s",result);
cache_get_field_content(idx,"Price",result);
AHInfo[idx][zPrice] = strval(result);
cache_get_field_content(idx,"Level",result);
AHInfo[idx][zLevel] = strval(result);
cache_get_field_content(idx,"OrderCap",result);
AHInfo[idx][zOrderCap] = strval(result);
cache_get_field_content(idx,"StoreCap",result);
AHInfo[idx][zStoreCap] = strval(result);
cache_get_field_content(idx,"LPosX",result);
AHInfo[idx][zLPosX] = floatstr(result);
cache_get_field_content(idx,"LPosY",result);
AHInfo[idx][zLPosY] = floatstr(result);
cache_get_field_content(idx,"LPosZ",result);
AHInfo[idx][zLPosZ] = floatstr(result);
cache_get_field_content(idx,"LPosA",result);
AHInfo[idx][zLPosA] = floatstr(result);
if(AHInfo[idx][cbought] == 0)
{
AHInfo[idx][zPickup]=CreatePickup(1273,1,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],0);
format(string,128,"** %s **\nBesitzer: %s \n Dieses Autohaus ist zu verkaufen!\nPreis: %s€\nLevel: %d\nAutohaus kaufen: /buy",AHInfo[idx][zName],AHInfo[idx][zOwner],inspoints(AHInfo[idx][zPrice]),AHInfo[idx][zLevel]);
AHInfo[idx][zLabel]=Create3DTextLabel(string,COLOR_AHLABEL,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],20,0,1);
AHInfo[idx][zCreated] = true;
}
else
{
AHInfo[idx][zPickup]=CreatePickup(1272,1,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],0);
format(string,128,"** %s **\nBesitzer: %s",AHInfo[idx][zName],AHInfo[idx][zOwner]);
AHInfo[idx][zLabel]=Create3DTextLabel(string,COLOR_AHLABEL,AHInfo[idx][zPosX],AHInfo[idx][zPosY],AHInfo[idx][zPosZ],20,0,1);
AHInfo[idx][zCreated] = true;
}
}
printf("<-| [MYSQL-LOAD] Es wurden %d Autohäuser geladen - Dauer: %dms",rows,GetTickCount()-oldtime);
}
}//push 3.02.2016
-
Hab interesse an das Design Pn hab ich dir geschickt
-
Hätte interesse hab dir schon eine PN geschrieben.
-
Ich nehme teil
-
Mhh Virtuelle Welt 0
----------
Loaded log file: "server_log.txt".
----------SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team[14:13:14]
[14:13:14] Server Plugins
[14:13:14] --------------
[14:13:14] Loading plugin: mysql.so
[14:13:14] >> plugin.mysql: R39-3 successfully loaded.
[14:13:14] Loaded.
[14:13:14] Loading plugin: streamer.so
[14:13:14]*** Streamer Plugin v2.7.7 by Incognito loaded ***
[14:13:14] Loaded.
[14:13:14] Loading plugin: sscanf.so
[14:13:14][14:13:14] ===============================
[14:13:14] sscanf plugin loaded.
[14:13:14] Version: 2.8.1
[14:13:14] (c) 2012 Alex "Y_Less" Cole
[14:13:14] ===============================
[14:13:14] Loaded.
[14:13:14] Loading plugin: audio.so
[14:13:14]*** Audio Plugin v0.5 R2 by Incognito loaded ***
[14:13:14] Loaded.
[14:13:14] Loading plugin: crashdetect.so
[14:13:14] Loaded.
[14:13:14] Loading plugin: nativechecker.so
[14:13:14] Loaded.
[14:13:14] Loaded 6 plugins.[14:13:14]
[14:13:14] Filterscripts
[14:13:14] ---------------
[14:13:14] Loaded 0 filterscripts.[14:13:14] [crashdetect]: gamemodes/script.amx does not contain debug information
[14:13:14] *** Audio Plugin: Started TCP server on port 7777
[14:13:14] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
[14:13:14] [crashdetect]: filterscripts/Maps.amx does not contain debug information
[14:13:14]
[14:13:14] Alle Maps wurden erfolgreich geladen!
[14:13:14]
[14:13:14] Filterscript 'Maps.amx' loaded.
[14:13:14] [crashdetect]: filterscripts/AudioHide.amx does not contain debug information
[14:13:14] Filterscript 'AudioHide.amx' loaded.
[14:13:14]
[14:13:14] SCRIPT - (c) by Zinne
[14:13:14]
[14:13:14] Number of vehicle models: 0
[14:13:14] [connection] 127.0.0.1:54879 requests connection cookie.
[14:13:14] [connection] 127.0.0.1:47128 requests connection cookie.
[14:13:14] [connection] 127.0.0.1:55140 requests connection cookie.
[14:13:14] [connection] 127.0.0.1:47076 requests connection cookie.
[14:13:15] [connection] incoming connection: 127.0.0.1:54879 id: 0
[14:13:15] [connection] incoming connection: 127.0.0.1:47128 id: 1
[14:13:15] [connection] incoming connection: 127.0.0.1:55140 id: 2
[14:13:15] [connection] incoming connection: 127.0.0.1:47076 id: 3
[14:13:15] [npc:join] Marihuanasamendealer has joined the server (0:127.0.0.1)
[14:13:15] [npc:join] Kokainsamendealer has joined the server (1:127.0.0.1)
[14:13:15] [npc:join] Kokainverarbeiter has joined the server (3:127.0.0.1)
[14:13:15] [npc:join] Marihuanaverarbeiter has joined the server (2:127.0.0.1)
[14:13:19] ho: 0 / Erstellte Label ID: 13
[14:13:19] Label Details: Color: 12022271 / Pos: 645.659973 / -1345.420043 / 13.546899 => 0, 1
[14:13:19] Label Text: Hausnummer 0
Dieses Haus ist zu verkaufen!
Preis: 1€
Level: 5
Mieträume: 1
Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
Haus kaufen: /buy |ENDE
[14:13:19] ho: 1 / Erstellte Label ID: 15
[14:13:19] Label Details: Color: 12022271 / Pos: 645.495971 / -1348.160034 / 13.546899 => 0, 1
[14:13:19] Label Text: Hausnummer 1
Dieses Haus ist zu verkaufen!
Preis: 50€
Level: 5
Mieträume: 6
Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
Haus kaufen: /buy |ENDE
[14:13:19] ho: 2 / Erstellte Label ID: 17
[14:13:19] Label Details: Color: 12022271 / Pos: 671.224975 / -1351.729980 / 13.544899 => 0, 1
[14:13:19] Label Text: Hausnummer 2
Dieses Haus ist zu verkaufen!
Preis: 1€
Level: 5
Mieträume: 5
Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
Haus kaufen: /buy |ENDE
[14:13:19] <-| [MYSQL-LOAD] Es wurden 3 Häuser geladen - Dauer: 0ms
[14:13:24] <-| [MYSQL-LOAD] Es wurden 9 Business geladen - Dauer: 1ms
[14:13:29] <-| [MYSQL-LOAD] Es wurden 13 Fraktionen geladen - Dauer: 4ms
[14:13:30] [npc:part] Kokainverarbeiter has left the server (3:0)
[14:13:30] [npc:part] Marihuanaverarbeiter has left the server (2:0)
[14:13:34] <-| [MYSQL-LOAD] Die Tabelle "Misc" wurde erfolgreich geladen - Dauer: 0ms
[14:15:01] Server password has been removed.
[14:22:06] [connection] 62.178.101.20:51865 requests connection cookie.
[14:22:07] [connection] incoming connection: 62.178.101.20:51865 id: 2
[14:22:07] [join] BeatsNinja114 has joined the server (2:62.178.101.20)
[14:22:16] <-| [LOAD] Spieler BeatsNinja114 (ID: 2) geladen - Dauer: 0ms
[14:22:27] ho: 0 / Erstellte Label ID: 60
[14:22:27] Label Details: Color: 12022271 / Pos: 644.588989 / -1333.010009 / 13.554400 => 0, 1
[14:22:27] Label Text: Hausnummer 0
Dieses Haus ist zu verkaufen!
Preis: 1€
Level: 5
Mieträume: 5
Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
Haus kaufen: /buy |ENDE
[14:22:30] Meine Welt: 0 -
Ich nehme Teil
-
Mhh also die Position stimmt.
----------
Loaded log file: "server_log.txt".
----------SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team[13:33:32]
[13:33:32] Server Plugins
[13:33:32] --------------
[13:33:32] Loading plugin: mysql.so
[13:33:32] >> plugin.mysql: R39-3 successfully loaded.
[13:33:32] Loaded.
[13:33:32] Loading plugin: streamer.so
[13:33:32]*** Streamer Plugin v2.7.7 by Incognito loaded ***
[13:33:32] Loaded.
[13:33:32] Loading plugin: sscanf.so
[13:33:32][13:33:32] ===============================
[13:33:32] sscanf plugin loaded.
[13:33:32] Version: 2.8.1
[13:33:32] (c) 2012 Alex "Y_Less" Cole
[13:33:32] ===============================
[13:33:32] Loaded.
[13:33:32] Loading plugin: audio.so
[13:33:32]*** Audio Plugin v0.5 R2 by Incognito loaded ***
[13:33:32] Loaded.
[13:33:32] Loading plugin: crashdetect.so
[13:33:32] Loaded.
[13:33:32] Loading plugin: nativechecker.so
[13:33:32] Loaded.
[13:33:32] Loaded 6 plugins.[13:33:32]
[13:33:32] Filterscripts
[13:33:32] ---------------
[13:33:32] Loaded 0 filterscripts.[13:33:32] [crashdetect]: gamemodes/script.amx does not contain debug information
[13:33:32] *** Audio Plugin: Started TCP server on port 7777
[13:33:32] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
[13:33:32] [crashdetect]: filterscripts/Maps.amx does not contain debug information
[13:33:32]
[13:33:32] Alle Maps wurden erfolgreich geladen!
[13:33:32]
[13:33:32] Filterscript 'Maps.amx' loaded.
[13:33:32] [crashdetect]: filterscripts/AudioHide.amx does not contain debug information
[13:33:32] Filterscript 'AudioHide.amx' loaded.
[13:33:32]
[13:33:32] SCRIPT - (c) by Zinne
[13:33:32]
[13:33:32] Number of vehicle models: 0
[13:33:32] [connection] 127.0.0.1:40731 requests connection cookie.
[13:33:32] [connection] 127.0.0.1:45283 requests connection cookie.
[13:33:32] [connection] 127.0.0.1:53696 requests connection cookie.
[13:33:32] [connection] 127.0.0.1:55945 requests connection cookie.
[13:33:33] [connection] incoming connection: 127.0.0.1:40731 id: 0
[13:33:33] [connection] incoming connection: 127.0.0.1:45283 id: 1
[13:33:33] [connection] incoming connection: 127.0.0.1:53696 id: 2
[13:33:33] [connection] incoming connection: 127.0.0.1:55945 id: 3
[13:33:33] [npc:join] Marihuanasamendealer has joined the server (0:127.0.0.1)
[13:33:33] [npc:join] Kokainsamendealer has joined the server (1:127.0.0.1)
[13:33:33] [npc:join] Marihuanaverarbeiter has joined the server (2:127.0.0.1)
[13:33:33] [npc:join] Kokainverarbeiter has joined the server (3:127.0.0.1)
[13:33:37] ho: 0 / Erstellte Label ID: 13
[13:33:37] Label Details: Color: 12022271 / Pos: 645.659973 / -1345.420043 / 13.546899 => 0, 1
[13:33:37] Label Text: Hausnummer 0
Dieses Haus ist zu verkaufen!
Preis: 50€
Level: 5
Mieträume: 1
Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
Haus kaufen: /buy |ENDE
[13:33:37] ho: 1 / Erstellte Label ID: 15
[13:33:37] Label Details: Color: 12022271 / Pos: 645.495971 / -1348.160034 / 13.546899 => 0, 1
[13:33:37] Label Text: Hausnummer 1
Dieses Haus ist zu verkaufen!
Preis: 50€
Level: 5
Mieträume: 6
Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
Haus kaufen: /buy |ENDE
[13:33:37] <-| [MYSQL-LOAD] Es wurden 2 Häuser geladen - Dauer: 0ms
[13:33:42] <-| [MYSQL-LOAD] Es wurden 9 Business geladen - Dauer: 1ms
[13:33:47] <-| [MYSQL-LOAD] Es wurden 13 Fraktionen geladen - Dauer: 3ms
[13:33:48] [npc:part] Kokainverarbeiter has left the server (3:0)
[13:33:48] [npc:part] Marihuanaverarbeiter has left the server (2:0)
[13:33:52] <-| [MYSQL-LOAD] Die Tabelle "Misc" wurde erfolgreich geladen - Dauer: 0ms
[13:35:19] Server password has been removed.
[13:36:07] [connection] 62.178.101.20:49689 requests connection cookie.
[13:36:08] [connection] incoming connection: 62.178.101.20:49689 id: 2
[13:36:09] [join] BeatsNinja114 has joined the server (2:62.178.101.20)
[13:38:55] <-| [LOAD] Spieler BeatsNinja114 (ID: 2) geladen - Dauer: 0ms
[13:39:03] ho: 0 / Erstellte Label ID: 13
[13:39:03] Label Details: Color: 12022271 / Pos: 645.659973 / -1345.420043 / 13.546899 => 0, 1
[13:39:03] Label Text: Hausnummer 0
Besitzer: BeatsNinja114
Mietpreis: 100€
Zimmer mieten - /rentroom |ENDE
[13:39:15] ho: 0 / Erstellte Label ID: 13
[13:39:15] Label Details: Color: 12022271 / Pos: 645.659973 / -1345.420043 / 13.546899 => 0, 1
[13:39:15] Label Text: Hausnummer 0
Dieses Haus ist zu verkaufen!
Preis: 50€
Level: 5
Mieträume: 1
Haus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken
Haus kaufen: /buy |ENDE
[13:41:36] [part] BeatsNinja114 has left the server (2:0)
[13:41:36]
[13:41:36] ::: MySQL Query Error :::
[13:41:36] ErrorID: 1054
[13:41:36] Error: Unknown column 'BankAcc' in 'field list'
[13:41:36] Callback:
[13:41:36] Query: UPDATE `accounts` SET `Admin` = '5', `Money` = '4999950', `Score` = '100', `Skin` = '44', `Kicks` = '0',`Bans` = '0', `Warns` = '0', `Banned` = '0', `BanGrund` = '', `Mute` = '0', `Geschlecht` = '1', `NextPayday` = '2',`Gras` = '0', `Kokain` = '0', `Grassamen` = '0', `Kokainsamen` = '0', `Joe` = '0', `Jose` = '0', `Hunger` = '10', `Durst` = '10',`Harndrang` = '10', `Haus` = '1', `Exp` = '0', `ForumAcc` = '0', `AH` = '-1', `Hitsound` = '1', `Timeban` = '0', `Carslots` = '1',`Biz` = '-1', `Tutorial` = '1', `Fraktion` = '0', `Leader` = '0', `Frakrank` = '0', `Handy` = '0', `Handynummer` = '0', `Handystatus` = '0',`Handyvertrag` = '0', `Handyguthaben` = '0', `Telefonbuch` = '0', `Benzinkanister` = '0', `Kanisterliter` = '0', `Supportpunkte` = '0',`BankAcc` = '0', `BankMoney` = '0', `BankPin` = '0', `MariLic` = '0', `KokaLic` = '0', `UnreadyMari` = '0', `UnreadyKoka` = '0', `MP3Player` = '0' WHERE `Name` = 'BeatsNinja114'
[13:41:36] ConnectionHandle: 1
[13:41:36]
[13:41:36]
[13:41:36] ::: MySQL Query Error :::
[13:41:36] ErrorID: 1054
[13:41:36] Error: Unknown column 'SessionAFK' in 'field list'
[13:41:36] Callback:
[13:41:36] Query: INSERT INTO `Logouts` (`Name`, `Date`, `Time`, `Reason`, `Sessiontime`, `SessionAFK`) VALUES ('BeatsNinja114', '16.12.2015', '13:41:36', 'Timeout/Crash', '2', '0')
[13:41:36] ConnectionHandle: 1
[13:41:36] -
Also das kommt.
----------
Loaded log file: "server_log.txt".
----------SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team[13:26:05]
[13:26:05] Server Plugins
[13:26:05] --------------
[13:26:05] Loading plugin: mysql.so
[13:26:05] >> plugin.mysql: R39-3 successfully loaded.
[13:26:05] Loaded.
[13:26:05] Loading plugin: streamer.so
[13:26:05]*** Streamer Plugin v2.7.7 by Incognito loaded ***
[13:26:05] Loaded.
[13:26:05] Loading plugin: sscanf.so
[13:26:05][13:26:05] ===============================
[13:26:05] sscanf plugin loaded.
[13:26:05] Version: 2.8.1
[13:26:05] (c) 2012 Alex "Y_Less" Cole
[13:26:05] ===============================
[13:26:05] Loaded.
[13:26:05] Loading plugin: audio.so
[13:26:05]*** Audio Plugin v0.5 R2 by Incognito loaded ***
[13:26:05] Loaded.
[13:26:05] Loading plugin: crashdetect.so
[13:26:05] Loaded.
[13:26:05] Loading plugin: nativechecker.so
[13:26:05] Loaded.
[13:26:05] Loaded 6 plugins.[13:26:05]
[13:26:05] Filterscripts
[13:26:05] ---------------
[13:26:05] Loaded 0 filterscripts.[13:26:05] [crashdetect]: gamemodes/script.amx does not contain debug information
[13:26:05] *** Audio Plugin: Started TCP server on port 7777
[13:26:05] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
[13:26:05] [crashdetect]: filterscripts/Maps.amx does not contain debug information
[13:26:05]
[13:26:05] Alle Maps wurden erfolgreich geladen!
[13:26:05]
[13:26:05] Filterscript 'Maps.amx' loaded.
[13:26:05] [crashdetect]: filterscripts/AudioHide.amx does not contain debug information
[13:26:05] Filterscript 'AudioHide.amx' loaded.
[13:26:05]
[13:26:05] SCRIPT - (c) by Zinne
[13:26:05]
[13:26:05] Number of vehicle models: 0
[13:26:05] [connection] 127.0.0.1:37421 requests connection cookie.
[13:26:05] [connection] 127.0.0.1:40746 requests connection cookie.
[13:26:05] [connection] 127.0.0.1:48338 requests connection cookie.
[13:26:05] [connection] 127.0.0.1:60177 requests connection cookie.
[13:26:06] [connection] incoming connection: 127.0.0.1:37421 id: 0
[13:26:06] [connection] incoming connection: 127.0.0.1:40746 id: 1
[13:26:06] [connection] incoming connection: 127.0.0.1:60177 id: 2
[13:26:06] [connection] incoming connection: 127.0.0.1:48338 id: 3
[13:26:06] [npc:join] Marihuanasamendealer has joined the server (0:127.0.0.1)
[13:26:06] [npc:join] Marihuanaverarbeiter has joined the server (3:127.0.0.1)
[13:26:06] [npc:join] Kokainsamendealer has joined the server (1:127.0.0.1)
[13:26:06] [npc:join] Kokainverarbeiter has joined the server (2:127.0.0.1)
[13:26:10] ho: 0 / Erstellte Label ID: 13
[13:26:10] ho: 1 / Erstellte Label ID: 15
[13:26:10] <-| [MYSQL-LOAD] Es wurden 2 Häuser geladen - Dauer: 0ms
[13:26:15] <-| [MYSQL-LOAD] Es wurden 9 Business geladen - Dauer: 1ms
[13:26:20] <-| [MYSQL-LOAD] Es wurden 13 Fraktionen geladen - Dauer: 3ms
[13:26:21] [npc:part] Marihuanaverarbeiter has left the server (3:0)
[13:26:21] [npc:part] Kokainverarbeiter has left the server (2:0)
[13:26:25] <-| [MYSQL-LOAD] Die Tabelle "Misc" wurde erfolgreich geladen - Dauer: 0ms
[13:27:52] Server password has been removed.
[13:28:16] [connection] 62.178.101.20:54560 requests connection cookie.
[13:28:17] [connection] incoming connection: 62.178.101.20:54560 id: 2
[13:28:17] [join] BeatsNinja114 has joined the server (2:62.178.101.20)
[13:28:26] <-| [LOAD] Spieler BeatsNinja114 (ID: 2) geladen - Dauer: 1ms
[13:28:48] ho: 0 / Erstellte Label ID: 58
[13:28:56] [part] BeatsNinja114 has left the server (2:1)
[13:28:56]
[13:28:56] ::: MySQL Query Error :::
[13:28:56] ErrorID: 1054
[13:28:56] Error: Unknown column 'SessionAFK' in 'field list'
[13:28:56] Callback:
[13:28:56] Query: INSERT INTO `Logouts` (`Name`, `Date`, `Time`, `Reason`, `Sessiontime`, `SessionAFK`) VALUES ('BeatsNinja114', '15.12.2015', '13:28:56', 'Quit', '0', '0')
[13:28:56] ConnectionHandle: 1
[13:28:56]
[13:28:56]
[13:28:56] ::: MySQL Query Error :::
[13:28:56] ErrorID: 1054
[13:28:56] Error: Unknown column 'BankAcc' in 'field list'
[13:28:56] Callback:
[13:28:56] Query: UPDATE `accounts` SET `Admin` = '5', `Money` = '5000000', `Score` = '100', `Skin` = '44', `Kicks` = '0',`Bans` = '0', `Warns` = '0', `Banned` = '0', `BanGrund` = '', `Mute` = '0', `Geschlecht` = '1', `NextPayday` = '0',`Gras` = '0', `Kokain` = '0', `Grassamen` = '0', `Kokainsamen` = '0', `Joe` = '0', `Jose` = '0', `Hunger` = '10', `Durst` = '10',`Harndrang` = '10', `Haus` = '-1', `Exp` = '0', `ForumAcc` = '0', `AH` = '-1', `Hitsound` = '1', `Timeban` = '0', `Carslots` = '1',`Biz` = '-1', `Tutorial` = '1', `Fraktion` = '0', `Leader` = '0', `Frakrank` = '0', `Handy` = '0', `Handynummer` = '0', `Handystatus` = '0',`Handyvertrag` = '0', `Handyguthaben` = '0', `Telefonbuch` = '0', `Benzinkanister` = '0', `Kanisterliter` = '0', `Supportpunkte` = '0',`BankAcc` = '0', `BankMoney` = '0', `BankPin` = '0', `MariLic` = '0', `KokaLic` = '0', `UnreadyMari` = '0', `UnreadyKoka` = '0', `MP3Player` = '0' WHERE `Name` = 'BeatsNinja114'
[13:28:56] ConnectionHandle: 1
[13:28:56]]
//edit
Das komische ich hab 3 Häuser erstellt aber nur eins wird in der Serverlog angezeigt
-
Also Welt bin ich in der 0
und es geht immernoch nicht
-
Geht immernoch nicht
-
hier der Code
case QueryCallLoadHouse:
{
cache_get_data(rows,fields);
if(rows) {
new ho;
for(;ho<rows;ho++) {
//if(ho==0){ho++;}
cache_get_field_content(ho,"ID",result);
HausInfo[ho][hID] = strval(result);
cache_get_field_content(ho,"PosX",result);
HausInfo[ho][hPosX] = floatstr(result);
cache_get_field_content(ho,"PosY",result);
HausInfo[ho][hPosY] = floatstr(result);
cache_get_field_content(ho,"PosZ",result);
HausInfo[ho][hPosZ] = floatstr(result);
cache_get_field_content(ho,"Level",result);
HausInfo[ho][hLevel] = strval(result);
cache_get_field_content(ho,"Preis",result);
HausInfo[ho][hPreis] = strval(result);
cache_get_field_content(ho,"Besitzer",result);
format(HausInfo[ho][hBesitzer],24,"%s",result);
cache_get_field_content(ho,"Bought",result);
HausInfo[ho][hBought] = strval(result);
cache_get_field_content(ho,"Rooms",result);
HausInfo[ho][hRooms] = strval(result);
cache_get_field_content(ho,"InteriorID",result);
HausInfo[ho][hInteriorID] = strval(result);
cache_get_field_content(ho,"Interior",result);
HausInfo[ho][hInterior] = strval(result);
cache_get_field_content(ho,"IntX",result);
HausInfo[ho][hIntX] = floatstr(result);
cache_get_field_content(ho,"IntY",result);
HausInfo[ho][hIntY] = floatstr(result);
cache_get_field_content(ho,"IntZ",result);
HausInfo[ho][hIntZ] = floatstr(result);
cache_get_field_content(ho,"Locked",result);
HausInfo[ho][hLocked] = strval(result);
cache_get_field_content(ho,"Rentable",result);
HausInfo[ho][hRentable] = strval(result);
cache_get_field_content(ho,"RentPrice",result);
HausInfo[ho][hRentPrice] = strval(result);
cache_get_field_content(ho,"Renter1",result);
format(HausInfo[ho][hRenter1],24,"%s",result);
cache_get_field_content(ho,"Renter2",result);
format(HausInfo[ho][hRenter2],24,"%s",result);
cache_get_field_content(ho,"Renter3",result);
format(HausInfo[ho][hRenter3],24,"%s",result);
cache_get_field_content(ho,"Renter4",result);
format(HausInfo[ho][hRenter4],24,"%s",result);
cache_get_field_content(ho,"Renter5",result);
format(HausInfo[ho][hRenter5],24,"%s",result);
cache_get_field_content(ho,"Renter6",result);
format(HausInfo[ho][hRenter6],24,"%s",result);
HausInfo[ho][hVW] = HausInfo[ho][hID]+1;
HausInfo[ho][hOutPickup] = CreatePickup(1318,1,HausInfo[ho][hIntX],HausInfo[ho][hIntY],HausInfo[ho][hIntZ],HausInfo[ho][hVW]);
if(HausInfo[ho][hBought] == 0) {
HausInfo[ho][hPickup] = CreatePickup(1272,1,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ]);
format(str,256,"Hausnummer %d\nDieses Haus ist zu verkaufen!\nPreis: %s€\nLevel: %d\nMieträume: %d\nHaus besichtigen: ~k~~VEHICLE_ENTER_EXIT~ drücken\nHaus kaufen: /buy",ho,inspoints(HausInfo[ho][hPreis]),HausInfo[ho][hLevel],HausInfo[ho][hRooms]);
} else {
if(HausInfo[ho][hRentable] == 1) {
format(str,256,"Hausnummer %d\nBesitzer: %s\nMietpreis: %s€\nZimmer mieten - /rentroom",ho,HausInfo[ho][hBesitzer],inspoints(HausInfo[ho][hRentPrice]));
} else if(HausInfo[ho][hRentable] == 0) {
format(str,256,"Hausnummer %d\nBesitzer: %s",ho,HausInfo[ho][hBesitzer]);
}
HausInfo[ho][hPickup] = CreatePickup(1239,1,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ]);
}
Create3DTextLabel(str,COLOR_AO,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ],15,1);
HausInfo[ho][hOutLabel]=Create3DTextLabel("Austreten:\n~k~~VEHICLE_ENTER_EXIT~ drücken",COLOR_AO,HausInfo[ho][hIntX],HausInfo[ho][hIntY],HausInfo[ho][hIntZ],5,HausInfo[ho][hVW],1);
HausInfo[ho][hCreated]=true;
}
}
} -
also korrekt abgespeichert wird es. vor und nach den restart werden keine Texte angezeigt Häuser aber erstellt
-
Es geht aber um das Haussystem und nicht und Bank und AFK @Whice
-
Hallo geht immernoch nicht. Hab jetzt den MYSQL log hochgeladen. Hier: http://37.114.60.129/serverlog/
Es geht aber es werden schon wieder die Texte nicht angezeigt.
MfG
BeatsNinja114
-
case QuerySelectAllHouse:
{
cache_get_data(rows,fields);
if(rows > MAX_HAEUSER) return 0;
new Float:X,Float:Y,Float:Z;
GetPlayerPos(playerid,X,Y,Z);
format(query,sizeof query,"INSERT INTO `haeuser` (`ID`, `PosX`, `PosY`,\
`PosZ`, `Level`, `Preis`, `Besitzer`, `Bought`, `Rooms`,`InteriorID`,`Interior`,`IntX`,`IntY`,`IntZ`,`Rentable`,\
`RentPrice`, `Renter1`, `Renter2`, `Renter3`, `Renter4`, `Renter5`");
format(query,sizeof query,"%s,`Renter6`)VALUES('%d', '%f', '%f', '%f', '5', '%d', 'Niemand','0', '%d',\
'%d', '%d', '%f', '%f', '%f', '1', '100', 'Niemand', 'Niemand', 'Niemand', 'Niemand', 'Niemand', 'Niemand')"\
,query,rows,X,Y,Z,pID,strval(extrastr),extraid,hIntID[extraid][0],hInteriorList[extraid][0], hInteriorList[extraid][1], hInteriorList[extraid][2]);
mysql_pquery(dbHandle,query);format(str,sizeof str,"SELECT * FROM `haeuser` WHERE `ID` = '%d'",rows);
mysql_pquery(dbHandle, str, "OnQueryFinish", "sdd", str, QueryCallLoadHouse, playerid);
}so hier. Sry hat etwas länger gedauert @Jeffry
-
-
So nachdem ich es umgeändert habe. Kann ich auf einmal kein Haus mehr erstellen es wird nur angezeigt das ich eins erstellt habe aber ein Pickup kommt nicht.
Datenbank ist auch leer.