Hab interesse an das Design Pn hab ich dir geschickt
Beiträge von BeatsNinja114
-
-
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.
-
Hallo. Ich hab ein Problem und zwar wenn ich ein Haus erstelle wird kein Text angezeigt also ob es verkauft ist oder ob es zum kaufen ist welchen Preis etc.... siehe bilder. Bitte um hilfe
ocmd:createhouse(playerid,params[])
{
if(pInfo[playerid][pAdmin] == 5) {
new p,r,int;
if(sscanf(params,"iii",p,r,int))return SendClientMessage(playerid,COLOR_GREY,"Benutze: /createhouse [Preis] [Zimmer (max. 6)] [Interior ID (Liste: /hints)]");
{
if(r <= 6) {
if(int <= 10) {
new st[16];
format(st,sizeof st,"%d",r);
mysql_pquery(dbHandle,"SELECT * FROM `haeuser`","OnQueryFinish","sdddsd","SELECT * FROM `haeuser`",QuerySelectAllHouse,playerid,p,st,int);
SendClientMessage(playerid,COLOR_LIGHTGREEN,"Du hast das Haus erfolgreich erstellt!");
} else {
SendClientMessage(playerid,COLOR_LIGHTRED,"Die InteriorID eines Hauses darf nicht größer als 10 sein!");
}
} else {
SendClientMessage(playerid,COLOR_LIGHTRED,"Die Zimmer eines Hauses dürfen nicht mehr als 6 sein!");
}
}
}
return 1;
}case QueryCallHouse:
{
cache_get_data(rows,fields);
if(rows) {
oldtime=GetTickCount();
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]);
}
HausInfo[ho][hLabel]=Create3DTextLabel(str,COLOR_AO,HausInfo[ho][hPosX],HausInfo[ho][hPosY],HausInfo[ho][hPosZ],7,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;
}
printf("<-| [MYSQL-LOAD] Es wurden %d Häuser geladen - Dauer: %dms",ho,GetTickCount()-oldtime);
}
} -
-
Ich nehme an deine Gewinnspiel teil!
-
Dame lebendig begraben