RL-Script Ladefehler

Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

  • RL-Script Ladefehler

    Hallo, ich habe Probleme mit der mysql Datenbank wen ich ein RL-Script lade. Erstmal technische Daten:
    Windows 7 Home 64bit
    MTA 1.5.2 Server
    Script: Reallife Reloaded mta-sa.org/thread/16140-releas…reloaded-script-vio-lite/

    Die Logs beim Starten stehen in einer Antwort


    Ich habe echt alles versucht. Ich habe es mithilfe eines Tutorials erstellt. Ich habe eine DB erstellt per XAMPP und phpMyAdmin und in diese auch die .sql Datei eingebunden. Dan habe ich in der acl.xml Datei für das Script Admin rechte vergeben und es auch was aber unwichtig ist in die Serverconfig eingebunden heißt es startet mit dem Server.
    Das Modul mta_mysql.dll ist auch im modules ordner in dem deathmatch ordner und auch mit dem folgenden Satz in die Serverconfig eingebunden:
    <module src="mta_mysql.dll" />

    Die libmysql.dll ist auch drin und auch in dem Script ordner ist im mysql ordner die Datei eingebunden

    gMysqlHost = "localhost"
    gMysqlUser = "root"
    gMysqlPass = ""
    gMysqlDatabase1 = "extended"
    gMysqlDatabase2 = "extended"

    Die Datenbank heißt auch zu 100% extended.
    Ich komm einfach nicht mehr weiter ich weiß nicht was ich falsch mache. Ich hoffe ihr könnt mir helfen.
  • Spoiler anzeigen
    ==================================================================
    = Multi Theft Auto: San Andreas v1.5.2
    ==================================================================
    = Server name : Default MTA Server
    = Server IP address: auto
    = Server port : 22003
    =
    = Log file : .. 1.5/server/mods/deathmatch/logs/server.log
    = Maximum players : 32
    = HTTP port : 22005
    = Voice Chat : Disabled
    = Bandwidth saving : Medium
    ==================================================================
    [2016-06-05 13:36:18] Resource 'acpanel' requests some acl rights. Use the command 'aclrequest list acpanel'
    [2016-06-05 13:36:58] Resources: 194 loaded, 0 failed
    [2016-06-05 13:36:58] Starting resources...
    [2016-06-05 13:36:59] Server minclientversion is now 1.5.2-9.07985.0
    [2016-06-05 13:37:00] ERROR: vio fraktionen/mission/shoprob_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio environment/zoll_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio abseil/abseil_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio carsys/tacho/speedo.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio carsys/tempomat.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/bonus_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/car_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/fdepot_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/fschein_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/handy_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/license_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/materialtruck_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/job_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/rathaus_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/self_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio clicksys/playerclick/stats_click.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio client/afk_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio client/hunger_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio client/nametag_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio environment/damage.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio environment/faggio_check.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] WARNING: vio/fraktionen/army/heligrab/heli_c.lua(Line 120) [Client] isPlayerDead is deprecated and may not work in future versions. Please replace with isPedDead.
    [2016-06-05 13:37:00] ERROR: vio fraktionen/aztecas/aztecas_gunshop_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio fraktionen/mafia/mafia_shop_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio fraktionen/sfpd/beschlag_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio fraktionen/triaden/triaden_shop_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio friendlist/friendlist_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio helpmenue/helpmenue_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio housesys/houses_client.lua is invalid. Please re-compile at luac.mtasa.com/
  • Spoiler anzeigen
    [2016-06-05 13:37:00] ERROR: vio jobs/nahverkehr/bus_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] WARNING: vio/parachute/skydiving_cl.lua(Line 22) [Client] isPlayerDead is deprecated and may not work in future versions. Please replace with isPedDead.
    [2016-06-05 13:37:00] WARNING: vio/parachute/openChute.lua(Line 35) [Client] isPlayerDead is deprecated and may not work in future versions. Please replace with isPedDead.
    [2016-06-05 13:37:00] ERROR: vio register_login/login_window.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio register_login/register_window.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio social/social_client.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] ERROR: vio social/social_gui.lua is invalid. Please re-compile at luac.mtasa.com/
    [2016-06-05 13:37:00] Some files in 'vio' use deprecated functions.
    [2016-06-05 13:37:00] Use the 'upgrade' command to perform a basic upgrade of resources.
    [2016-06-05 13:37:01] ERROR: vio\mysql\mysql_start.lua:8: attempt to call global 'mysql_connect' (a nil value)
    [2016-06-05 13:37:01] 45642997
    [2016-06-05 13:37:01] SCRIPT ERROR: vio\biz\biz.lua:39: unexpected symbol near ']'
    [2016-06-05 13:37:01] ERROR: Loading script failed: vio\biz\biz.lua:39: unexpected symbol near ']'
    [2016-06-05 13:37:01] ERROR: vio\carsys\outsource_mysql.lua:1: attempt to call global 'mysql_query' (a nil value)
    [2016-06-05 13:37:01] ERROR: vio\carsys\carhouses\carhouses_mysql.lua:43: attempt to call global 'mysql_query' (a nil value)
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\mission\materialtruck_server.lua:5: Bad argument @ 'createMarker' [Expected number at argument 9, got root]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\mission\materialtruck_server.lua:6: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] ERROR: vio\fraktionen\blacklist_server.lua:77: attempt to call global 'mysql_query' (a nil value)
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:1: Bad argument @ 'createMarker' [Expected number at argument 9, got root]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:2: Bad argument @ 'createBlipAttachedTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:3: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:4: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:46: Bad argument @ 'addEventHandler' [Expected element at argument 2, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\newsreporter\newspaper_server.lua:58: Bad argument @ 'fileGetSize' [Expected scriptfile at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\newsreporter\newspaper_server.lua:59: Bad argument @ 'fileRead' [Expected scriptfile at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\newsreporter\newspaper_server.lua:63: Bad argument @ 'fileClose' [Expected scriptfile at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:1: Bad argument @ 'createMarker' [Expected number at argument 9, got root]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:2: Bad argument @ 'createBlipAttachedTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:3: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:4: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:47: Bad argument @ 'addEventHandler' [Expected element at argument 2, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:1: Bad argument @ 'createMarker' [Expected number at argument 9, got root]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:2: Bad argument @ 'createBlipAttachedTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:3: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:4: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-05 13:37:01] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:46: Bad argument @ 'addEventHandler' [Expected element at argument 2, got boolean]
    [2016-06-05 13:37:02] WARNING: vio\script.lua:84: Expected positive value, got negative. This warning may be an error in future versions.
    [2016-06-05 13:37:02] ERROR: vio\script.lua:91: attempt to call global 'mysql_query' (a nil value)
    [2016-06-05 13:37:02] ERROR: vio\environment\cctv.lua:28: Database query failed: no such table: cctvterminals
    [2016-06-05 13:37:02] ERROR: vio\environment\cctv.lua:39: Database query failed: no such table: cctvcameras
    [2016-06-05 13:37:02] ERROR: vio\environment\cctv.lua:55: Database query failed: no such table: cctvterminals
    [2016-06-05 13:37:02] ERROR: vio\environment\cctv.lua:57: bad argument #1 to 'ipairs' (table expected, got string)
    [2016-06-05 13:37:02] ERROR: vio\fraktionen\fdepots.lua:43: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-05 13:37:02] ERROR: vio\fraktionen\aztecas\aztecassettings.lua:13: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-05 13:37:02] ERROR: vio\fraktionen\mafia\mafiasettings.lua:14: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-05 13:37:02] ERROR: vio\fraktionen\triaden\triadensettings.lua:14: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-05 13:37:02] ERROR: vio\internet\email_server.lua:3: attempt to call global 'mysql_query' (a nil value)
    [2016-06-05 13:37:02] Gamemode 'Reloaded Reallife' started.
    [2016-06-05 13:37:02] ERROR: vio\fraktionen\gangareas.lua:52: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-05 13:37:02] Initiating changemode from 'vio' to 'play'
    [2016-06-05 13:37:02] ERROR: Unable to start resource play;
    [2016-06-05 13:37:02] Querying MTA master server... success! (Auto detected IP:92.252.123.78)
    [2016-06-05 13:37:02] Server started and is ready to accept connections!
    [2016-06-05 13:37:02] To stop the server, type 'shutdown' or press Ctrl-C
    [2016-06-05 13:37:02] Type 'help' for a list of commands.
    [2016-06-05 13:37:02] ERROR: vio\fraktionen\mission\frakshop_server.lua:35: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-05 13:37:02] ERROR: vio\biz\prestige.lua:5: attempt to call global 'MySQL_DatasetExist' (a nil value)
    [2016-06-05 13:37:02] ERROR: vio\internet\homepages_server\buyit_server.lua:29: attempt to call global 'mysql_query' (a nil value)
    [2016-06-05 13:37:02] Stopping vio
    [2016-06-05 13:37:02] ERROR: vio\carsys\carsys_mysql.lua:142: attempt to call global 'mysql_query' (a nil value)
    [2016-06-05 13:37:03] Starting play
    [2016-06-05 13:37:03] Starting freeroam
    [2016-06-05 13:37:03] Gamemode 'play' started.
    [2016-06-05 13:37:03] startResource: Resource 'play' started

    [/spoiler]
  • Ich weiß ja nicht, inwieweit du darüber informiert bist, allerdings bezieht sich dieses Forum lediglich auf dieses Projekt, demnach kannst du keine gescheite Antwort erwarten, welches sich auf ein anderes und dementsprechend feindliches Projekt bezieht.

    Meines Erachtens gehört dieser Thread in den Papierkorb.
  • Es soll kein feindliches Projekt sein. Ich habe den für den Privatgebrauch weil ich das Script bissel ändern will und mein können testen will. Ich starte den Server nur über den Server ordner in MTA und damit kann man ja keinen großen Server machen(Hamachi). Ich möchte in nur zum testen haben.
  • die Fehler stehen doch da??


    Bei den error Meldungen musst du in die Klassen springen, wo er einen Fehler anzeigt. Den Fehler musst du finden und beheben.
    Hat nix mit configuration zu tun, da er die Klassen nicht kompilieren kann...

    Wenn du deine fehlerklasse auf der beigesendeten webpage einfügst sollte er dir die Fehler automatisch anzeigen...

    Einfach mal error Meldungen lesen ist meist die halbe Miete
  • Alles gemacht wie du meintest hier ist die neue Meldung @Bush
    Spoiler anzeigen
    ==================================================================
    = Multi Theft Auto: San Andreas v1.5.2
    ==================================================================
    = Server name : Default MTA Server
    = Server IP address: auto
    = Server port : 22003
    =
    = Log file : .. 1.5/server/mods/deathmatch/logs/server.log
    = Maximum players : 32
    = HTTP port : 22005
    = Voice Chat : Disabled
    = Bandwidth saving : Medium
    ==================================================================
    [2016-06-06 17:53:27] Resource 'acpanel' requests some acl rights. Use the command 'aclrequest list acpanel'
    [2016-06-06 17:54:11] Resources: 194 loaded, 0 failed
    [2016-06-06 17:54:11] MODULE: File not 32 bit - mods\deathmatch\modules\mta_mysql.dll
    [2016-06-06 17:54:11] MODULE: Unable to initialize mods\deathmatch\modules\libmysql.dll!
    [2016-06-06 17:54:11] Starting resources...
    [2016-06-06 17:54:12] Server minclientversion is now 1.5.2-9.07985.0
    [2016-06-06 17:54:13] WARNING: vio/fraktionen/army/heligrab/heli_c.lua(Line 120) [Client] isPlayerDead is deprecated and may not work in future versions. Please replace with isPedDead.
    [2016-06-06 17:54:13] WARNING: vio/parachute/skydiving_cl.lua(Line 22) [Client] isPlayerDead is deprecated and may not work in future versions. Please replace with isPedDead.
    [2016-06-06 17:54:13] WARNING: vio/parachute/openChute.lua(Line 35) [Client] isPlayerDead is deprecated and may not work in future versions. Please replace with isPedDead.
    [2016-06-06 17:54:13] WARNING: vio/register_login/register_window.lua [Client] is encoded in ANSI instead of UTF-8. Please convert your file to UTF-8.
    [2016-06-06 17:54:13] Some files in 'vio' use deprecated functions.
    [2016-06-06 17:54:13] Use the 'upgrade' command to perform a basic upgrade of resources.
    [2016-06-06 17:54:14] ERROR: vio\mysql\mysql_start.lua:8: attempt to call global 'mysql_connect' (a nil value)
    [2016-06-06 17:54:14] 45644694
    [2016-06-06 17:54:14] SCRIPT ERROR: vio\biz\biz.lua:39: unexpected symbol near ']'
    [2016-06-06 17:54:14] ERROR: Loading script failed: vio\biz\biz.lua:39: unexpected symbol near ']'
    [2016-06-06 17:54:14] ERROR: vio\carsys\outsource_mysql.lua:1: attempt to call global 'mysql_query' (a nil value)
    [2016-06-06 17:54:14] ERROR: vio\carsys\carhouses\carhouses_mysql.lua:43: attempt to call global 'mysql_query' (a nil value)
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\mission\materialtruck_server.lua:5: Bad argument @ 'createMarker' [Expected number at argument 9, got root]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\mission\materialtruck_server.lua:6: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] ERROR: vio\fraktionen\blacklist_server.lua:77: attempt to call global 'mysql_query' (a nil value)
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:1: Bad argument @ 'createMarker' [Expected number at argument 9, got root]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:2: Bad argument @ 'createBlipAttachedTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:3: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:4: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\aztecas\aztecas_gunshop_server.lua:46: Bad argument @ 'addEventHandler' [Expected element at argument 2, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\newsreporter\newspaper_server.lua:58: Bad argument @ 'fileGetSize' [Expected scriptfile at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\newsreporter\newspaper_server.lua:59: Bad argument @ 'fileRead' [Expected scriptfile at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\newsreporter\newspaper_server.lua:63: Bad argument @ 'fileClose' [Expected scriptfile at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:1: Bad argument @ 'createMarker' [Expected number at argument 9, got root]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:2: Bad argument @ 'createBlipAttachedTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:3: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:4: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\mafia\mafia_shop_server.lua:47: Bad argument @ 'addEventHandler' [Expected element at argument 2, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:1: Bad argument @ 'createMarker' [Expected number at argument 9, got root]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:2: Bad argument @ 'createBlipAttachedTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:3: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:4: Bad argument @ 'setElementVisibleTo' [Expected element at argument 1, got boolean]
    [2016-06-06 17:54:14] WARNING: vio\fraktionen\triaden\triaden_shop_server.lua:46: Bad argument @ 'addEventHandler' [Expected element at argument 2, got boolean]
    [2016-06-06 17:54:15] WARNING: vio\script.lua:84: Expected positive value, got negative. This warning may be an error in future versions.
    [2016-06-06 17:54:15] ERROR: vio\script.lua:91: attempt to call global 'mysql_query' (a nil value)
    [2016-06-06 17:54:15] ERROR: vio\environment\cctv.lua:28: Database query failed: no such table: cctvterminals
    [2016-06-06 17:54:15] ERROR: vio\environment\cctv.lua:39: Database query failed: no such table: cctvcameras
    [2016-06-06 17:54:15] ERROR: vio\environment\cctv.lua:55: Database query failed: no such table: cctvterminals
    [2016-06-06 17:54:15] ERROR: vio\environment\cctv.lua:57: bad argument #1 to 'ipairs' (table expected, got string)
    [2016-06-06 17:54:15] ERROR: vio\fraktionen\fdepots.lua:43: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-06 17:54:15] ERROR: vio\fraktionen\aztecas\aztecassettings.lua:13: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-06 17:54:15] ERROR: vio\fraktionen\mafia\mafiasettings.lua:14: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-06 17:54:15] ERROR: vio\fraktionen\triaden\triadensettings.lua:14: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-06 17:54:15] ERROR: vio\internet\email_server.lua:3: attempt to call global 'mysql_query' (a nil value)
    [2016-06-06 17:54:15] Gamemode 'Reloaded Reallife' started.
    [2016-06-06 17:54:15] ERROR: vio\fraktionen\gangareas.lua:52: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-06 17:54:15] Initiating changemode from 'vio' to 'play'
    [2016-06-06 17:54:15] ERROR: Unable to start resource play;
    [2016-06-06 17:54:15] Querying MTA master server... success! (Auto detected IP:188.118.161.113)
    [2016-06-06 17:54:15] Server started and is ready to accept connections!
    [2016-06-06 17:54:15] To stop the server, type 'shutdown' or press Ctrl-C
    [2016-06-06 17:54:15] Type 'help' for a list of commands.
    [2016-06-06 17:54:15] ERROR: vio\fraktionen\mission\frakshop_server.lua:35: attempt to call global 'MySQL_GetString' (a nil value)
    [2016-06-06 17:54:15] ERROR: vio\biz\prestige.lua:5: attempt to call global 'MySQL_DatasetExist' (a nil value)
    [2016-06-06 17:54:15] ERROR: vio\internet\homepages_server\buyit_server.lua:29: attempt to call global 'mysql_query' (a nil value)
    [2016-06-06 17:54:15] Stopping vio
    [2016-06-06 17:54:15] ERROR: vio\carsys\carsys_mysql.lua:142: attempt to call global 'mysql_query' (a nil value)
    [2016-06-06 17:54:16] Starting play
    [2016-06-06 17:54:16] Starting freeroam
    [2016-06-06 17:54:16] Gamemode 'play' started.
    [2016-06-06 17:54:16] startResource: Resource 'play' started
    [2016-06-06 17:54:27] Server stopped!
    [2016-06-06 17:54:27] Stopping resources.....................
    [2016-06-06 17:54:27] Closing SQLite3 database

  • Spoiler anzeigen
    gMysqlHost = "localhost"
    gMysqlUser = "root"
    gMysqlPass = ""
    gMysqlDatabase1 = "extended"
    gMysqlDatabase2 = "extended"

    function MySQL_Startup()
    handler = mysql_connect(gMysqlHost, gMysqlUser, gMysqlPass, gMysqlDatabase1)
    if( not handler) then
    outputDebugString("Couldn't run query: Unable to connect to the MySQL server!")
    outputDebugString("Please shutdown the server and start the MySQL server!")
    end
    handler_old = mysql_connect(gMysqlHost, gMysqlUser, gMysqlPass, gMysqlDatabase2)
    if( not handler_old) then
    outputDebugString("Couldn't run query: Unable to connect to the MySQL server!")
    outputDebugString("Please shutdown the server and start the MySQL server!")
    end
    end
    MySQL_Startup()

    function MySQL_End()
    mysql_close(handler)
    end

    function MySQL_GetVar(tablename, feldname, bedingung)
    local result = mysql_query(handler, "SELECT "..feldname.." from "..tablename.." WHERE "..bedingung)
    if( not result) then
    outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
    else
    if(mysql_num_rows(result) > 0) then
    local dsatz = mysql_fetch_assoc(result)
    local savename = feldname
    mysql_free_result(result)
    return tonumber(dsatz[feldname])
    else
    mysql_free_result(result)
    return false
    end
    end
    end

    function MySQL_GetString(tablename, feldname, bedingung)
    local result = mysql_query(handler, "SELECT "..feldname.." from "..tablename.." WHERE "..bedingung)
    if( not result) then
    outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
    else
    if(mysql_num_rows(result) > 0) then
    local dsatz = mysql_fetch_assoc(result)
    local savename = feldname
    mysql_free_result(result)
    return dsatz[feldname]
    else
    mysql_free_result(result)
    return false
    end
    end
    end

    function MySQL_SetVar(tablename, feldname, var, bedingung)
    if var then
    local result = mysql_query(handler, "UPDATE "..tablename.." SET "..feldname.." = "..var.." WHERE "..bedingung)
    if( not result) then
    outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
    else
    mysql_free_result(result)
    return false
    end
    end
    end

    function MySQL_DelRow(tablename, bedingung)
    local result = mysql_query(handler, "DELETE FROM "..tablename.." WHERE "..bedingung)
    if( not result) then
    outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
    else
    mysql_free_result(result)
    return false
    end
    outputDebugString ("geloescht?!")
    end

    function MySQL_SetString(tablename, feldname, var, bedingung)
    if var and bedingung then
    local result = mysql_query(handler, "UPDATE "..tablename.." SET "..feldname.." = '"..var.."' WHERE "..bedingung)
    if( not result) then
    outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
    else
    mysql_free_result(result)
    return false
    end
    end
    end

    function MySQL_DatasetExist(tablename, bedingung)
    local result = mysql_query(handler, "SELECT * from "..tablename.." WHERE "..bedingung)
    if( not result) then
    outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
    else
    if(mysql_num_rows(result) > 0) then
    mysql_free_result(result)
    return true
    else
    mysql_free_result(result)
    return false
    end
    end
    end

    function MySQL_Safe ( string )
    return MySQL_Save ( string )
    end
    function MySQL_Save ( string )
    if string then
    return mysql_escape_string ( handler, string )
    end
    end

    function mysql_vio_query ( query )

    if stringSaveFind(query, "Adminlevel") then
    outputDebugString ( "Query: "..query)
    end
    local result = mysql_query ( handler, query )
    local oldres = result
    if not result then
    outputDebugString ( "Error: Invalid Query: "..tostring ( query ) )
    outputDebugString("Error executing the query: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
    else
    mysql_free_result ( result )
    end
    return oldres
    end

    function stringSaveFind ( arg1, arg2 )

    if arg1 and arg2 then
    return string.find ( arg1, arg2 )
    else
    return false
    end
    end

    --addEventHandler ( "onResourceStart", getResourceRootElement(getThisResource()),MySQL_Startup )
    --addEventHandler ( "onResourceStop", getResourceRootElement(getThisResource()),MySQL_End)

    --[[


    ]]

    Dieser Beitrag wurde bereits 1 mal editiert, zuletzt von LaBa ()

  • gMysqlHost = "localhost"
    gMysqlUser = "root"
    gMysqlPass = ""
    gMysqlDatabase1 = "extended"
    gMysqlDatabase2 = "extended"

    Falsch. Ich glaube du hast keine Datenbank verwaltung. Ich empfehle dir : Gameserver-sponsor.de für einen Monat kannst du kostenlos einen Server testen + Datenbank. Falls du fragen hast adde mich auf skype.
    LIVE VLONE, DIE VLONE
  • Also die Fehler die es beim script raushaut kannst du doch so einfach beheben.
    In den Fehlermeldungen steht alles Leserlich drinn.


    1. Alles "isPlayerDead" zu "isPedDead" umschreiben.
    2. Das Script ist schon alt und anscheinend nicht mehr in den neuen Versionen ganz kompatibel.
    3. Deine SQL wird nicht verbunden. Irgendwo nen Schreibfehler reinbekommen ?


    Aber so genau weiß ich auch nicht. Mein Scripten ist schon lange her und ich müsste erstmal selber probieren woran es liegt bevor ich dir ne richtige Hilfreiche Antwort geben kann.


    Schau im MTA Forum vorbei oder vll. kann dir [vio]Fliege01 rat geben

    MuDDaGeR schrieb:

    F steht für freekills die was unternehmen h steht für hdf jetz