Hallo,
verkauft jemand eine WBB 4.1 oder höher Lizenz?
MFG
Preislich steht VH
Zahle NUR mit PayPal Käuferschutz
Hallo,
verkauft jemand eine WBB 4.1 oder höher Lizenz?
MFG
Preislich steht VH
Zahle NUR mit PayPal Käuferschutz
; check the manual that corresponds to your MySQL server version for the right syntax to use near
Welche MYSQL version nutzt du denn @.Maskulin
die frage ist wie?
//EDIT
Userspawn soll sein 1, 2 oder 3 .... Haus , Zivi , oder Fraktion
Name soll halt der Username sein
Ich möchte 2 neue Felder in das Feld USER eintragen...
In user ist z.b. UserID Scheine X Y Z Position ETC-..... und jetzt will ich noch statt umzubenennen, wie ich es jetzt getan habe, neue sachen erstellen ( NAME und Userspawn)
MFG
das heisst ich soll USER exportieren mit den sachen die ich umbenannt habe und dann die alte SQL draufspielen und dann dazu noch mal die exportierte draufladen?
weil das dann praktisch die fehlenden hinzufügt?
MFG
Es ist ein Selfmade und kein Godfather müll.
Was du bezweifelst interessiert mich nicht. Mir geht es um eine Allgemeine Lösung ohne es MANUELL eintragen zu müssen .
Ich habe die fehlenden Felder eingetragen(andere nicht gebrauchte umbenannt) und alles Manuell eingetragen. Jetzt gehts.
Es soll aber automatisch von Script her eingetragen werden und das funktioniert irgendwie nicht.
Selfmade
//
Ich weiss nicht wovon das von Bedeutung wäre^^
Ich habe gerade in user das feld forum_ban umbenannt in userspawn um es zu testen....hab dem userspawn die werte 2 gegebn (zivispawn) im script definiert...geht leider auch nicht
jetzt kommt diese errormeldung
[09:20:24 06/23/17] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Name' in 'field list' (Query: "UPDATE user SET IP='255.255.255.255',Leiter='0',Mitglied='0',Rang='1',Exp='0',Admin='0',Skin='135',Geld='2000.00',Konto='0.00',Job='0',Arbeitslosengeld='0',X='1841.72',Y='-9285.62',Z='4.41', userspawn = '2', Level='0',Perso='0',Scheine='00000000',PaydaySekunden='73',Kredit='0',Kreditsumme='0.00',Kreditrate='0',Online='1498209624',WantedLevel='0',Knastzeit='0',Hausschlüssel='-1',Handy='0',Telefonbuch='0',Telefonbucheintrag='0',Handynummer='0',Warns='0',Tod='0',Gefangen='0',Name='0',Level='0', Punkte='0',Kills='0',Tode='0', Ban='-1', Strafe='-1', StrafCP='1',Tutorial='0',Repair='-1',Grundwehrdienst='83',Geschäftschlüssel='-1' WHERE userID='3'")
[09:21:20 06/23/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Name") (Query: "SELECT * FROM user WHERE userID='3'")
[09:21:20 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:21:20 06/23/17] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'Name' in 'field list' (Query: "UPDATE user SET IP='255.255.255.255',Leiter='0',Mitglied='0',Rang='0',Exp='0',Admin='0',Skin='0',Geld='0.00',Konto='0.00',Job='0',Arbeitslosengeld='0',X='1795.53',Y='-9284.27',Z='14.61', userspawn = '2', Level='0',Perso='0',Scheine='00000000',PaydaySekunden='0',Kredit='0',Kreditsumme='0.00',Kreditrate='0',Online='1498209680',WantedLevel='0',Knastzeit='0',Hausschlüssel='-1',Handy='0',Telefonbuch='0',Telefonbucheintrag='0',Handynummer='0',Warns='0',Tod='0',Gefangen='0',Name='0',Level='0', Punkte='0',Kills='0',Tode='0', Ban='-1', Strafe='-1', StrafCP='0',Tutorial='0',Repair='0',Grundwehrdienst='83',Geschäftschlüssel='-1' WHERE userID='3'")
Warum passiert das hier?
UPDATE user SET IP='255.255.255.255'
//Edit <--- Name und userspawn dazu jetzt kommt folgendes
[09:30:45 06/23/17] [WARNING] CMySQLHandle::Create - connection already exists
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_float - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_float - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_float - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_float - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_float - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_float - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[09:33:38 06/23/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') (Query: "SELECT * FROM user WHERE userID='3'")
[09:33:38 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
Alles anzeigen
das ist klar aber wo genau ? userspawn ins Feld USER eintragen oder als ALLgemeines ?
hier ein Bild
Und wo genau fehlt das?
und wie trage ich das ein?
//edit
userspawn im script
format(query,sizeof query,"UPDATE user SET IP='%s',Leiter='%d',Mitglied='%d',Rang='%d',Exp='%d',Admin='%d',Skin='%d',Geld='%.2f',Konto='%.2f',Job='%d',Arbeitslosengeld='%d',X='%.2f',Y='%.2f',Z='%.2f', userspawn = '%d', Level='%d',Perso='%d',Scheine='%d%d%d%d%d%d%d%d',PaydaySekunden='%d',Kredit='%d',Kreditsumme='%.2f',Kreditrate='%d',Online='%d',WantedLevel='%d',Knastzeit='%d',Hausschlüssel='%d',Handy='%d',Telefonbuch='%d',Telefonbucheintrag='%d',Handynummer='%d',Warns='%d',Tod='%d',Gefangen='%d'",
Guten Morgen liebe Community,
Wir haben ein Problem mit dem Loginsystem...
Kurz zum Fehler:
Man macht register, dann kann man normal spielen.
Loggt man sich jedoch nochmals ein, wird der Account gefunden, wenn man jedoch sein Passwort eingibt, kommt "Server closed the Connection" , also man wird gekickt.
Das passiert jedes mal.
Hier mal die Serverlog.txt wenn ich Server starte:
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[08:29:43] filterscripts = "" (string)
[08:29:43]
[08:29:43] Server Plugins
[08:29:43] --------------
[08:29:43] Loading plugin: streamer.so
[08:29:43]
*** Streamer Plugin v2.8 by Incognito loaded ***
[08:29:43] Loaded.
[08:29:43] Loading plugin: mysql.so
[08:29:43] >> plugin.mysql: R39-6 successfully loaded.
[08:29:43] Loaded.
[08:29:43] Loading plugin: sscanf.so
[08:29:43]
[08:29:43] ===============================
[08:29:43] sscanf plugin loaded.
[08:29:43] Version: 2.8.1
[08:29:43] (c) 2012 Alex "Y_Less" Cole
[08:29:43] ===============================
[08:29:43] Loaded.
[08:29:43] Loading plugin: Encrypt.so
[08:29:43]
[08:29:43] ______________________________________
[08:29:43] Encrypt Plugin v0.1 loaded
[08:29:43] ______________________________________
[08:29:43] Loaded.
[08:29:43] Loading plugin: nativechecker.so
[08:29:43] Loaded.
[08:29:43] Loaded 5 plugins.
[08:29:43]
[08:29:43] Filterscripts
[08:29:43] ---------------
[08:29:43] Loaded 0 filterscripts.
[08:29:43] Filterscript 'CIMap.amx' loaded.
[08:29:43] -mSelection- WARNING: No Items found in file: skins_PD.txt
[08:29:43] -mSelection- WARNING: No Items found in file: skins_FD.txt
[08:29:43] Test mit USERID: -1 ||
[08:29:43] Db handle 1
[08:29:43] * SQL Verbindung hergestellt.
[08:29:43] User: 1
[08:29:43] Feuer entfacht!
[08:29:43] DEBUG: Feuer 1 erstellt.
[08:29:43] SELECT * FROM `frakautos`
[08:29:43] SELECT * FROM `frakkasse`
[08:29:43] ----- Frakkasse -----
[08:29:43] - ID 1 Betrag 87.000000
[08:29:43] - ID 2 Betrag -355.000000
[08:29:43] - ID 3 Betrag 17755.000000
[08:29:43] - ID 4 Betrag 817.000000
[08:29:43] - ID 5 Betrag -20.000000
[08:29:43] - ID 6 Betrag 0.000000
[08:29:43] - ID 7 Betrag 300.000000
[08:29:43] - ID 8 Betrag 78200.000000
[08:29:43] - ID 9 Betrag 108000.000000
[08:29:43] - ID 10 Betrag 0.000000
[08:29:43] - ID 11 Betrag 633133.000000
[08:29:43] - ID 12 Betrag 0.000000
[08:29:43] - ID 13 Betrag -48.000000
[08:29:43] - ID 14 Betrag -19.000000
[08:29:43] - ID 15 Betrag 0.000000
[08:29:43] ----- Frakkasse Ende-----
[08:29:43] SELECT * FROM `blitzer`
[08:29:43] SELECT * FROM `lager`
[08:29:43] SELECT * FROM `gangwar`
[08:29:43]
----------------------------------
[08:29:43] Number of vehicle models: 34
[08:29:45] SELECT * FROM häuser WHERE 'ID' < 2
[08:29:45] 10 Häuser wurden geladen.
[08:29:45] SELECT * FROM geschaft WHERE 'ID' < 13
[08:29:45] 13 Geschäfte wurden geladen.
[08:29:45] ----- Autohaus-----
[08:29:45] Datensätze: 0
[08:29:45] -----Autohaus ende----
[08:29:45] SELECT * FROM `frakrang`
Alles anzeigen
Serverlog wenn ich joine:
[08:33:28] [connection] MEINE IP requests connection cookie.
[08:33:29] [connection] incoming connection: MEINEIP id: 0
[08:33:29] [join] SGTblue has joined the server (0:IP)
[08:33:31] SELECT ID FROM login WHERE Name='SGTblue'
[08:33:44] INSERT INTO login (Name,Passwort,salt) VALUES ('SGTblue','HASCHPW','HASHSALT')
[08:33:44] SELECT ID FROM login WHERE Name='SGTblue'
[08:33:44] INSERT INTO user (userID) VALUES ('2')
[08:33:44] INSERT INTO waffen (Name) VALUES ('SGTblue')
[08:33:45] UPDATE user SET Geschlecht='1' WHERE userID='2'
[08:33:50] UPDATE `user` SET Jahr='1998',Monat='1',Tag='1' WHERE userID='2'
[08:33:55] UPDATE user SET email='dsdasdas@aol.com' WHERE userID='2'
Alles anzeigen
Serverlog wenn ich rejoine und jetzt ACHTUNG! : Server gibt an "Account gefunden" - "Logge dich nun ein" <-- Ich logge mich mit PW ein und werde gekickt !!!!!!!!
[08:37:18] UPDATE user SET IP='255.255.255.255',Leiter='0',Mitglied='0',Rang='1',Exp='0',Admin='0',Skin='135',Geld='2000.00',Konto='0.00',Job='0',Arbeitslosengeld='0',X='1826.55',Y='-9284.69',Z='4.42', userspawn = '2', Level='0',Perso='0',Scheine='00000000',PaydaySekunden='145',Kredit='0',Kreditsumme='0.00',Kreditrate='0',Online='1498207038',WantedLevel='0',Knastzeit='0',Hausschlüssel='-1',Handy='0',Telefonbuch='0',Telefonbucheintrag='0',Handynummer='0',Warns='0',Tod='0',Gefangen='0',Name='0',Level='0', Punkte='0',Kills='0',Tode='0', Ban='0', Strafe='-1', StrafCP='1',Tutorial='0',Repair='-1',Grundwehrdienst='83',Geschäftschlüssel='-1' WHERE userID='2'
[08:37:18] DELETE FROM moebel WHERE ID='2'
[08:37:18] DELETE FROM inventar WHERE ID='2'
[08:37:18] UPDATE usersitzungen SET dauer='197',logout=1498207038 WHERE sitzungsid='0'
[08:37:18] INSERT INTO serverlogs (id, Name, time, typ, log, ip) VALUES (2, 'SGTblue[AFK]', 1498207038, 1, 'Hat sich ausgeloggt', '255.255.255.255')
[08:37:18] UPDATE user SET eingeloggt='0' WHERE userID='2'
[08:37:18] [part] SGTblue[AFK] has left the server (0:1)
[08:37:33] [connection] MEINE IP requests connection cookie.
[08:37:34] [connection] incoming connection: MEINE IP id: 0
[08:37:34] [join] SGTblue has joined the server (0:IP)
[08:37:36] SELECT ID FROM login WHERE Name='SGTblue'
[08:37:36] SELECT X FROM user WHERE userID='2'
[08:37:36] SELECT Y FROM user WHERE userID='2'
[08:37:36] SELECT Z FROM user WHERE userID='2'
[08:38:00] SELECT Passwort,salt FROM login WHERE Name='SGTblue' LIMIT 1
[08:38:00] SELECT * FROM user WHERE userID='2'
[08:38:00] SELECT * FROM moebel WHERE ID='2'
[08:38:00] SELECT * FROM inventar WHERE ID='2'
[08:38:00] SELECT * FROM drogen WHERE drogenid='2'
[08:38:00] SELECT * FROM cars WHERE ID='2'
[08:38:00] UPDATE user SET eingeloggt='1' WHERE userID='2'
[08:38:00] SELECT * FROM complaints_topics WHERE `from`='2' AND status=4
[08:38:00] INSERT INTO serverlogs (id, Name, time, typ, log, ip) VALUES (2, 'SGTblue', 1498207080, 1, 'Hat sich eingeloggt', 'IPMEINE')
[08:38:00] SELECT * FROM complaints_topics WHERE `from`='2' AND status=4
[08:38:00] UPDATE user SET IP='255.255.255.255',Leiter='0',Mitglied='0',Rang='0',Exp='0',Admin='0',Skin='0',Geld='0.00',Konto='0.00',Job='0',Arbeitslosengeld='0',X='1795.53',Y='-9284.27',Z='14.61', userspawn = '0', Level='0',Perso='0',Scheine='00000000',PaydaySekunden='0',Kredit='0',Kreditsumme='0.00',Kreditrate='0',Online='1498207080',WantedLevel='0',Knastzeit='0',Hausschlüssel='-1',Handy='0',Telefonbuch='0',Telefonbucheintrag='0',Handynummer='0',Warns='0',Tod='0',Gefangen='0',Name='0',Level='0', Punkte='0',Kills='0',Tode='0', Ban='-1', Strafe='-1', StrafCP='0',Tutorial='0',Repair='0',Grundwehrdienst='83',Geschäftschlüssel='-1' WHERE userID='2'
[08:38:00] DELETE FROM moebel WHERE ID='2'
[08:38:00] DELETE FROM inventar WHERE ID='2'
[08:38:00] UPDATE usersitzungen SET dauer='197',logout=1498207080 WHERE sitzungsid='1'
[08:38:00] INSERT INTO serverlogs (id, Name, time, typ, log, ip) VALUES (2, 'SGTblue', 1498207080, 1, 'Hat sich ausgeloggt', '255.255.255.255')
[08:38:00] UPDATE user SET eingeloggt='0' WHERE userID='2'
[08:38:00] [part] SGTblue has left the server (0:2)
Alles anzeigen
Und hier die MYSQL LOG!! Bitte genau anschauen :
[08:37:18 06/23/17] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'userspawn' in 'field list' (Query: "UPDATE user SET IP='255.255.255.255',Leiter='0',Mitglied='0',Rang='1',Exp='0',Admin='0',Skin='135',Geld='2000.00',Konto='0.00',Job='0',Arbeitslosengeld='0',X='1826.55',Y='-9284.69',Z='4.42', userspawn = '2', Level='0',Perso='0',Scheine='00000000',PaydaySekunden='145',Kredit='0',Kreditsumme='0.00',Kreditrate='0',Online='1498207038',WantedLevel='0',Knastzeit='0',Hausschlüssel='-1',Handy='0',Telefonbuch='0',Telefonbucheintrag='0',Handynummer='0',Warns='0',Tod='0',Gefangen='0',Name='0',Level='0', Punkte='0',Kills='0',Tode='0', Ban='0', Strafe='-1', StrafCP='1',Tutorial='0',Repair='-1',Grundwehrdienst='83',Geschäftschlüssel='-1' WHERE userID='2'")
[08:38:00 06/23/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Name") (Query: "SELECT * FROM user WHERE userID='2'")
[08:38:00 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[08:38:00 06/23/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("userspawn") (Query: "SELECT * FROM user WHERE userID='2'")
[08:38:00 06/23/17] [ERROR] cache_get_field_content_int - invalid datatype
[08:38:00 06/23/17] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'userspawn' in 'field list' (Query: "UPDATE user SET IP='255.255.255.255',Leiter='0',Mitglied='0',Rang='0',Exp='0',Admin='0',Skin='0',Geld='0.00',Konto='0.00',Job='0',Arbeitslosengeld='0',X='1795.53',Y='-9284.27',Z='14.61', userspawn = '0', Level='0',Perso='0',Scheine='00000000',PaydaySekunden='0',Kredit='0',Kreditsumme='0.00',Kreditrate='0',Online='1498207080',WantedLevel='0',Knastzeit='0',Hausschlüssel='-1',Handy='0',Telefonbuch='0',Telefonbucheintrag='0',Handynummer='0',Warns='0',Tod='0',Gefangen='0',Name='0',Level='0', Punkte='0',Kills='0',Tode='0', Ban='-1', Strafe='-1', StrafCP='0',Tutorial='0',Repair='0',Grundwehrdienst='83',Geschäftschlüssel='-1' WHERE userID='2'")
Diese Log kommt nur, wenn ich rejoine! Davor war sie nicht da... also ich meine sie war leer.... nur durchs rejoinen kommt anscheinend diese Fehlercodes--
Ich bitte schnellstens um Hilfe....Ich weiß echt nicht woran das legen kann
Mit freundlichen Grüßen
xD sehr schade, warum wurd er gesperrt?
Wollte das 0.6er
Wäre Interessant zu wissen ob er es nun released xD
will mir mal die Updates anschauen
vielen dank klappt
Ich gehe mal davon aus, das du GTA Network nutzt.
Das sollte dir Helfen
Deine Lösung funktioniert super danke
@root Deine nicht so "DistanceTo" Exisitier tnicht also unbekannt..
Dankesehr
MFG
Sehr geehrte Breadfishcommunity,
Ich habe einen GTA V Server und komme nicht weiter beim Scripten.
In SAMP gab es die Funktion http://wiki.sa-mp.com/wiki/IsPlayerInRangeOfPoint IS PLAYER IN RANGE OF POINT
Die gleiche Funktion benötige ich für GTA V aber ich finde diese nicht im Internet
Bitte um schnelle Hilfe
Mit freundlichen Grüßen
Sehr geehrte Breadfishcommunity,
Ich habe den Mapeditor von GTA V ordnungsgemäß installiert und so wie beschrieben alles gehandhabt.
https://de.gta5-mods.com/scripts/map-editor
Leider funktioniert dieser nicht.
wenn ich ingame F7 drücke passiert einfach nichts.
Bitte um schnelle Hilfe
PS : Bereits neu installiert und mit admin ausgeführt
Mit freundlichen Grüßen
Habs hinbekommen, hat nur daran gelegen, dass Whirlpool.so gefehlt hat geht jetzt alles wieder
danke
Hi Community,
Ich hab da ein Problem mit meinem CNR Server.
Ich möchte diesen gerne starten, jedoch sagt er mir über NATIVE... , viele Errors an und er Startet nicht "File or Function not found"
Ich verstehe nicht warum, selbst beim updaten von mehreren Streamern etc. funktioniert es nicht.
Hier mal die Windowslog, wo alles Funktioniert :
Jedoch ist die MYSQL .DLL nicht die wie im Include (r34) und hier r39-6. Hab das gleiche auch auf Linux getestet(nur errors...)
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[01:29:04]
[01:29:04] Server Plugins
[01:29:04] --------------
[01:29:04] Loading plugin: crashdetect.dll
[01:29:04] CrashDetect v4.15.1 is OK.
[01:29:04] Loaded.
[01:29:04] Loading plugin: mysql.dll
[01:29:04] >> plugin.mysql: R39-6 successfully loaded.
[01:29:04] Loaded.
[01:29:04] Loading plugin: sscanf.dll
[01:29:04]
[01:29:04] ===============================
[01:29:04] sscanf plugin loaded.
[01:29:04] Version: 2.8.2
[01:29:04] (c) 2012 Alex "Y_Less" Cole
[01:29:04] ===============================
[01:29:04] Loaded.
[01:29:04] Loading plugin: streamer.dll
[01:29:04] Loaded.
[01:29:04] Loading plugin: Whirlpool.dll
[01:29:04]
[01:29:04] ==================
[01:29:04]
[01:29:04] Whirlpool loaded
[01:29:04]
[01:29:04] ==================
[01:29:04]
[01:29:04] Loaded.
[01:29:04] Loading plugin: MapAndreas.dll
[01:29:04] Loaded.
[01:29:04] Loaded 6 plugins.
[01:29:04]
[01:29:04] Ban list
[01:29:04] --------
[01:29:04] Loaded: samp.ban
[01:29:04]
[01:29:04]
[01:29:04] Filterscripts
[01:29:04] ---------------
[01:29:04] Loading filterscript 'maps.amx'...
[01:29:04] [MAPS.amx] Es wurden 51 Objekte erstellt.
[01:29:04] [MAPS.amx] Es wurden 500 Dynamische Objekte erstellt.
[01:29:04] Loaded 1 filterscripts.
[01:29:04]
[01:29:04]
[01:29:04]
[01:29:04] =======================================
[01:29:04] | |
[01:29:04] | YSI version 3.09.0684 |
[01:29:04] | By Alex "Y_Less" Cole |
[01:29:04] | |
[01:29:04] =======================================
[01:29:04]
[01:29:04]
[01:29:04]
[01:29:08] Es wurden 10 Lieder geladen.
[01:29:08] Es wurden 6 Derbymaps geladen.
[01:29:08] Filterscript 'maps.amx' load failed.
[01:29:08] Number of vehicle models: 1
[01:29:08] [connection] 127.0.0.1:55056 requests connection cookie.
[01:29:09] [connection] incoming connection: 127.0.0.1:55056 id: 0
[01:29:10] [npc:join] securityguy has joined the server (0:127.0.0.1)
[01:29:13] MS: 1 (dataTimer)
Und hier die CFG:
echo Executing Server Config...
lanmode 0
rcon_password egal
maxplayers 350
port 7777
hostname .::BLAH
gamemode0 XXXXXX
filterscripts maps
plugins crashdetect.dll mysql.dll sscanf.dll streamer.dll Whirlpool.dll MapAndreas.dll
announce 0
chatlogging 0
weburl http://www.bavaria-multigaming.de
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
maxnpc 50
logtimeformat [%H:%M:%S]
language German / Deutsch
Der Server startet hier, jedoch auf Linux nicht hier die Logs:
Den Streamer hab ich jetzt mal geupdatet (script+plugin) Davor war eine Streamerversion von 2014 drauf(gleiche Errors)
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[09:22:29]
[09:22:29] Server Plugins
[09:22:29] --------------
[09:22:29] Loading plugin: mysql_static.so
[09:22:29] >> plugin.mysql: R34 successfully loaded.
[09:22:29] Loaded.
[09:22:29] Loading plugin: MapAndreas.so
[09:22:29] Loaded.
[09:22:29] Loading plugin: nativechecker.so
[09:22:29] Loaded.
[09:22:29] Loading plugin: streamer.so
[09:22:29]
*** Streamer Plugin v2.8.2 by Incognito loaded ***
[09:22:29] Loaded.
[09:22:29] Loading plugin: sscanf.so
[09:22:29]
[09:22:29] ===============================
[09:22:29] sscanf plugin loaded.
[09:22:29] Version: 2.8.2
[09:22:29] (c) 2012 Alex "Y_Less" Cole
[09:22:29] ===============================
[09:22:29] Loaded.
[09:22:29] Loaded 5 plugins.
[09:22:29]
[09:22:29] Ban list
[09:22:29] --------
[09:22:29] Loaded: samp.ban
[09:22:29]
[09:22:30]
[09:22:30] Filterscripts
[09:22:30] ---------------
[09:22:30] Loading filterscript 'maps.amx'...
[09:22:30] Error: Function not registered: 'CreateDynamicObject'
[09:22:30] Error: Function not registered: 'DestroyDynamicObject'
[09:22:30] Error: Function not registered: 'CreateDynamicObjectEx'
[09:22:30] Error: Function not registered: 'SetDynamicObjectMaterial'
[09:22:30] *** Streamer Plugin: CreateDynamicObjectEx: Expecting 18 parameter(s), but found 15
[09:22:30] *** Streamer Plugin: CreateDynamicObject: Expecting 14 parameter(s), but found 12
[09:22:30] *** Streamer Plugin: CreateDynamicObjectEx: Expecting 18 parameter(s), but found 15
[09:22:30] [MAPS.amx] Es wurden 51 Objekte erstellt.
[09:22:30] [MAPS.amx] Es wurden 500 Dynamische Objekte erstellt.
[09:22:30] Loaded 1 filterscripts.
[09:22:30] Error: Function not registered: 'SSCANF_Init'
[09:22:30] Error: Function not registered: 'SSCANF_Join'
[09:22:30] Error: Function not registered: 'SSCANF_Leave'
[09:22:30] Error: Function not registered: 'DestroyDynamicPickup'
[09:22:30] Error: Function not registered: 'CreateDynamicPickup'
[09:22:30] Error: Function not registered: 'IsValidDynamicPickup'
[09:22:30] Error: Function not registered: 'Streamer_GetFloatData'
[09:22:30] Error: Function not registered: 'IsValidDynamicObject'
[09:22:30] Error: Function not registered: 'DestroyDynamicObject'
[09:22:30] Error: Function not registered: 'CreateDynamicObject'
[09:22:30] Error: Function not registered: 'mysql_pquery'
[09:22:30] Error: Function not registered: 'CreateDynamic3DTextLabel'
[09:22:30] Error: Function not registered: 'Streamer_UpdateEx'
[09:22:30] Error: Function not registered: 'sscanf'
[09:22:30] Error: Function not registered: 'MoveDynamicObject'
[09:22:30] Error: Function not registered: 'GetDynamicObjectPos'
[09:22:30] Error: Function not registered: 'Streamer_GetIntData'
[09:22:30] Error: Function not registered: 'SetDynamicObjectPos'
[09:22:30] Error: Function not registered: 'SetDynamicObjectRot'
[09:22:30] Error: Function not registered: 'EditDynamicObject'
[09:22:30] Error: Function not registered: 'UpdateDynamic3DTextLabelText'
[09:22:30] Error: Function not registered: 'DestroyDynamic3DTextLabel'
[09:22:30] Error: Function not registered: 'WP_Hash'
[09:22:30] Error: Function not registered: 'orm_addvar_string'
[09:22:30] Error: Function not registered: 'orm_addvar_int'
[09:22:30] Error: Function not registered: 'orm_addvar_float'
[09:22:30] Error: Function not registered: 'IsValidDynamic3DTextLabel'
[09:22:30] Script[gamemodes/cnr.amx]: Run time error 19: "File or function is not found"
[09:22:30] Number of vehicle models: 0
Und hier die CFG:
echo Executing Server Config...
lanmode 0
rcon_password XXXXXXXXXX
hostname SA-MP 0.3 Server
password xXXXXX
gamemode0 XXXXXXXXXXXXXXXXX
announce 1
query 1
weburl http://www.bavaria-multigaming.de
maxnpc 20
filterscripts maps
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 350.0
stream_rate 1000
plugins mysql_static.so MapAndreas.so nativechecker.so streamer.so sscanf.so
maxplayers 150
bind 62.75.251.99
port 7777
language German
logtimeformat [%H:%M:%S]
Das kommt wenn ich in Linux MYSQl auch auf r39-6 mache :
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[09:30:44]
[09:30:44] Server Plugins
[09:30:44] --------------
[09:30:44] Loading plugin: mysql.so
[09:30:44] >> plugin.mysql: R39-6 successfully loaded.
[09:30:44] Loaded.
[09:30:44] Loading plugin: MapAndreas.so
[09:30:44] Loaded.
[09:30:44] Loading plugin: nativechecker.so
[09:30:44] Loaded.
[09:30:44] Loading plugin: streamer.so
[09:30:44]
*** Streamer Plugin v2.8.2 by Incognito loaded ***
[09:30:44] Loaded.
[09:30:44] Loading plugin: sscanf.so
[09:30:44]
[09:30:44] ===============================
[09:30:44] sscanf plugin loaded.
[09:30:44] Version: 2.8.2
[09:30:44] (c) 2012 Alex "Y_Less" Cole
[09:30:44] ===============================
[09:30:44] Loaded.
[09:30:44] Loaded 5 plugins.
[09:30:44]
[09:30:44] Ban list
[09:30:44] --------
[09:30:44] Loaded: samp.ban
[09:30:44]
[09:30:44]
[09:30:44] Filterscripts
[09:30:44] ---------------
[09:30:44] Loading filterscript 'maps.amx'...
[09:30:44] Error: Function not registered: 'CreateDynamicObject'
[09:30:44] Error: Function not registered: 'DestroyDynamicObject'
[09:30:44] Error: Function not registered: 'CreateDynamicObjectEx'
[09:30:44] Error: Function not registered: 'SetDynamicObjectMaterial'
[09:30:44] *** Streamer Plugin: CreateDynamicObjectEx: Expecting 18 parameter(s), but found 15
[09:30:44] *** Streamer Plugin: CreateDynamicObject: Expecting 14 parameter(s), but found 12
[09:30:44] *** Streamer Plugin: CreateDynamicObjectEx: Expecting 18 parameter(s), but found 15
[09:30:44] [MAPS.amx] Es wurden 51 Objekte erstellt.
[09:30:44] [MAPS.amx] Es wurden 500 Dynamische Objekte erstellt.
[09:30:44] Loaded 1 filterscripts.
[09:30:45] Error: Function not registered: 'SSCANF_Init'
[09:30:45] Error: Function not registered: 'SSCANF_Join'
[09:30:45] Error: Function not registered: 'SSCANF_Leave'
[09:30:45] Error: Function not registered: 'DestroyDynamicPickup'
[09:30:45] Error: Function not registered: 'CreateDynamicPickup'
[09:30:45] Error: Function not registered: 'IsValidDynamicPickup'
[09:30:45] Error: Function not registered: 'Streamer_GetFloatData'
[09:30:45] Error: Function not registered: 'IsValidDynamicObject'
[09:30:45] Error: Function not registered: 'DestroyDynamicObject'
[09:30:45] Error: Function not registered: 'CreateDynamicObject'
[09:30:45] Error: Function not registered: 'CreateDynamic3DTextLabel'
[09:30:45] Error: Function not registered: 'Streamer_UpdateEx'
[09:30:45] Error: Function not registered: 'sscanf'
[09:30:45] Error: Function not registered: 'MoveDynamicObject'
[09:30:45] Error: Function not registered: 'GetDynamicObjectPos'
[09:30:45] Error: Function not registered: 'Streamer_GetIntData'
[09:30:45] Error: Function not registered: 'SetDynamicObjectPos'
[09:30:45] Error: Function not registered: 'SetDynamicObjectRot'
[09:30:45] Error: Function not registered: 'EditDynamicObject'
[09:30:45] Error: Function not registered: 'UpdateDynamic3DTextLabelText'
[09:30:45] Error: Function not registered: 'DestroyDynamic3DTextLabel'
[09:30:45] Error: Function not registered: 'WP_Hash'
[09:30:45] Error: Function not registered: 'IsValidDynamic3DTextLabel'
[09:30:45] Script[gamemodes/cnr.amx]: Run time error 19: "File or function is not found"
[09:30:45] Number of vehicle models: 0
Bitte um schnellstmögliche Hilfe
Mit freundlichen Grüßen
//EDIT habe das Streamerplugin und sscanf mal nach vorne geschoben jetzt kommt aber das:
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team
[09:35:07]
[09:35:07] Server Plugins
[09:35:07] --------------
[09:35:07] Loading plugin: mysql.so
[09:35:07] >> plugin.mysql: R39-6 successfully loaded.
[09:35:07] Loaded.
[09:35:07] Loading plugin: streamer.so
[09:35:07]
*** Streamer Plugin v2.8.2 by Incognito loaded ***
[09:35:07] Loaded.
[09:35:07] Loading plugin: sscanf.so
[09:35:07]
[09:35:07] ===============================
[09:35:07] sscanf plugin loaded.
[09:35:07] Version: 2.8.2
[09:35:07] (c) 2012 Alex "Y_Less" Cole
[09:35:07] ===============================
[09:35:07] Loaded.
[09:35:07] Loading plugin: MapAndreas.so
[09:35:07] Loaded.
[09:35:07] Loading plugin: nativechecker.so
[09:35:07] Loaded.
[09:35:07] Loaded 5 plugins.
[09:35:07]
[09:35:07] Ban list
[09:35:07] --------
[09:35:07] Loaded: samp.ban
[09:35:07]
[09:35:07]
[09:35:07] Filterscripts
[09:35:07] ---------------
[09:35:07] Loading filterscript 'maps.amx'...
[09:35:07] *** Streamer Plugin: CreateDynamicObjectEx: Expecting 18 parameter(s), but found 15
[09:35:07] *** Streamer Plugin: CreateDynamicObject: Expecting 14 parameter(s), but found 12
[09:35:07] *** Streamer Plugin: CreateDynamicObjectEx: Expecting 18 parameter(s), but found 15
[09:35:07] [MAPS.amx] Es wurden 51 Objekte erstellt.
[09:35:07] [MAPS.amx] Es wurden 500 Dynamische Objekte erstellt.
[09:35:07] Loaded 1 filterscripts.
[09:35:07] Error: Function not registered: 'WP_Hash'
[09:35:07] Script[gamemodes/cnr.amx]: Run time error 19: "File or function is not found"
[09:35:07] Number of vehicle models: 0
Das habe ich tatsächlich alles schon versucht. Er installiert mir dennoch nur die Version 3.2.8
Danke für die schnelle Antwort
//edit hat geklappt
<----- Alle third-party pakages wurden entfernt, danach klappte die Installation, dennoch danke und
//Close