MTA-Reallife Datenbank mit der Phpmyadmin einrichten!

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

  • MTA-Reallife Datenbank mit der Phpmyadmin einrichten!

    Hallo liebe Community,

    (1. Ich habe ein folgendes Problem und zwar habe ich ein mta reallife server aber ich weiß halt nicht wie ich das mit der Phpmyadmin " sachen machen " wie z.b
    die Mysql Vom server " da meine Phpmyadmin kack " einzutragen, weil ich nicht weiß was ich da eingeben muss, Danke im Voraus.)

    2. kann das wegen der Mysql daten bank das tutorial nicht abspielen? also das ich nach register stand bild habe?
    kann es daran liegen wenn ja wie löse ich es, habe Ein linux Root Server.


    Mit Freundlichen Grüßen
    [sL] Aerox
  • Also ich kenn mich nicht damit aus deswegen frage ich dich einfach mal ob du da mal rüber gucken kannst, ich packe hier ein quellcode rein vom letzten server restart

    Quellcode: debugscript| Server.txd

    1. [2017-08-03 21:38:12] Resources: 128 loaded, 0 failed
    2. [2017-08-03 21:38:12] MODULE: File not found - x64/modules/mtamysql.so
    3. [2017-08-03 21:38:12] Starting resources...
    4. [2017-08-03 21:38:12] Server minclientversion is now 1.5.4-9.11595.0
    5. [2017-08-03 21:38:12] ERROR: Couldn't find resource Modloader. Check it exists.
    6. [2017-08-03 21:38:12] WARNING: ultimate/usefull/utility.lua(Line 56) [Client] getControlState is deprecated and may not work in future versions. Please replace with getPedControlState before Tuesday.
    7. [2017-08-03 21:38:12] WARNING: ultimate/addict/client/effects_client.lua(Line 135) [Client] setControlState is deprecated and may not work in future versions. Please replace with setPedControlState before Tuesday.
    8. [2017-08-03 21:38:12] WARNING: ultimate/addict/client/effects_client.lua(Line 148) [Client] getControlState is deprecated and may not work in future versions. Please replace with getPedControlState before Tuesday.
    9. [2017-08-03 21:38:12] WARNING: ultimate/anticheat/anticheat_client.lua(Line 20) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    10. [2017-08-03 21:38:12] WARNING: ultimate/blips/customblips.lua(Line 56) [Client] getControlState is deprecated and may not work in future versions. Please replace with getPedControlState before Tuesday.
    11. [2017-08-03 21:38:12] WARNING: ultimate/carsys/tuning/tuning_server.lua(Line 94) [Server] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    12. [2017-08-03 21:38:12] Please wait...
    13. [2017-08-03 21:38:12] WARNING: ultimate/casino/cardgames/blackjack/blackjack_client.lua(Line 160) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    14. [2017-08-03 21:38:12] WARNING: ultimate/casino/roulett/roulett_client.lua(Line 126) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    15. [2017-08-03 21:38:12] WARNING: ultimate/client/customradio_client.lua(Line 204) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    16. [2017-08-03 21:38:12] WARNING: ultimate/client/nametag_client.lua(Line 165) [Client] getControlState is deprecated and may not work in future versions. Please replace with getPedControlState before Tuesday.
    17. [2017-08-03 21:38:12] WARNING: ultimate/environment/death.lua(Line 172) [Server] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    18. [2017-08-03 21:38:12] WARNING: ultimate/environment/playerspawn.lua(Line 4) [Server] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    19. [2017-08-03 21:38:12] WARNING: ultimate/environment/spawn.lua(Line 8) [Server] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    20. [2017-08-03 21:38:12] WARNING: ultimate/fraktionen/army/army_refire.lua(Line 13) [Client] setControlState is deprecated and may not work in future versions. Please replace with setPedControlState before Tuesday.
    21. [2017-08-03 21:38:12] WARNING: ultimate/food/pizzastack.lua(Line 113) [Server] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    22. [2017-08-03 21:38:12] WARNING: ultimate/fun/casinorob/casinorob_client.lua(Line 25) [Client] getControlState is deprecated and may not work in future versions. Please replace with getPedControlState before Tuesday.
    23. [2017-08-03 21:38:12] WARNING: ultimate/fun/shootingranch/shootingranch_client.lua(Line 106) [Client] setControlState is deprecated and may not work in future versions. Please replace with setPedControlState before Tuesday.
    24. [2017-08-03 21:38:12] WARNING: ultimate/guns/firemode_client.lua(Line 56) [Client] setControlState is deprecated and may not work in future versions. Please replace with setPedControlState before Tuesday.
    25. [2017-08-03 21:38:12] WARNING: ultimate/guns/firemode_client.lua(Line 71) [Client] getControlState is deprecated and may not work in future versions. Please replace with getPedControlState before Tuesday.
    26. [2017-08-03 21:38:12] WARNING: ultimate/guns/refiredelay_client.lua(Line 22) [Client] setControlState is deprecated and may not work in future versions. Please replace with setPedControlState before Tuesday.
    27. [2017-08-03 21:38:12] WARNING: ultimate/hobby/rcclub/rc_client.lua(Line 177) [Client] setControlState is deprecated and may not work in future versions. Please replace with setPedControlState before Tuesday.
    28. [2017-08-03 21:38:12] WARNING: ultimate/missions/area51/thetruth_area51_mission.lua(Line 34) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    29. [2017-08-03 21:38:12] WARNING: ultimate/register_login/login_window.lua(Line 40) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    30. [2017-08-03 21:38:12] WARNING: ultimate/realdriveby/driveby_client.lua(Line 111) [Client] setControlState is deprecated and may not work in future versions. Please replace with setPedControlState before Tuesday.
    31. [2017-08-03 21:38:12] WARNING: ultimate/shops/24-7/24-7_server.lua(Line 14) [Server] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    32. [2017-08-03 21:38:12] WARNING: ultimate/shops/gunshop/gunshop_client.lua(Line 16) [Client] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    33. [2017-08-03 21:38:12] WARNING: ultimate/shops/gunshop/gunshop_server.lua(Line 37) [Server] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    34. [2017-08-03 21:38:12] WARNING: ultimate/tutorial/tutorial_server.lua(Line 26) [Server] showPlayerHudComponent is deprecated and may not work in future versions. Please replace with setPlayerHudComponentVisible before Tuesday.
    35. [2017-08-03 21:38:12] Some files in 'ultimate' use deprecated functions.
    36. [2017-08-03 21:38:12] Use the 'upgrade' command to perform a basic upgrade of resources.
    37. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_start.lua:11: Bad usage @ 'dbConnect' [Unknown database 'root']
    38. [2017-08-03 21:38:13] INFO: [MySQL_Startup] Couldn't run query: Unable to connect to the MySQL server!
    39. [2017-08-03 21:38:13] INFO: [MySQL_Startup] Please shutdown the server and start the MySQL server!
    40. [2017-08-03 21:38:13] WARNING: ultimate/script.lua:1: Access denied @ 'setServerPassword'
    41. [2017-08-03 21:38:13] WARNING: ultimate/ai/ai_car.lua:23: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    42. [2017-08-03 21:38:13] WARNING: ultimate/ai/ai_car.lua:23: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    43. [2017-08-03 21:38:13] WARNING: ultimate/ai/ai_car.lua:39: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    44. [2017-08-03 21:38:13] WARNING: ultimate/ai/ai_car.lua:39: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    45. [2017-08-03 21:38:13] ERROR: ultimate/ai/ai_car.lua:57: 'for' limit must be a number
    46. [2017-08-03 21:38:13] SCRIPT ERROR: ultimate/clicksys/geld_server.lua:1: '=' expected near 'pay_func'
    47. [2017-08-03 21:38:13] ERROR: Loading script failed: ultimate/clicksys/geld_server.lua:1: '=' expected near 'pay_func'
    48. [2017-08-03 21:38:13] WARNING: ultimate/fraktionen/newsreporter/newspaper_server.lua:47: Bad argument @ 'fileGetSize' [Expected scriptfile at argument 1, got boolean]
    49. [2017-08-03 21:38:13] WARNING: ultimate/fraktionen/newsreporter/newspaper_server.lua:48: Bad argument @ 'fileRead' [Expected scriptfile at argument 1, got boolean]
    50. [2017-08-03 21:38:13] WARNING: ultimate/fraktionen/newsreporter/newspaper_server.lua:52: Bad argument @ 'fileClose' [Expected scriptfile at argument 1, got boolean]
    51. [2017-08-03 21:38:13] WARNING: ultimate/fun/lotto/lotto_server.lua:3: Bad argument @ 'fileGetSize' [Expected scriptfile at argument 1, got boolean]
    52. [2017-08-03 21:38:13] WARNING: ultimate/fun/lotto/lotto_server.lua:4: Bad argument @ 'fileRead' [Expected scriptfile at argument 1, got boolean]
    53. [2017-08-03 21:38:13] WARNING: ultimate/fun/lotto/lotto_server.lua:5: Bad argument @ 'fileClose' [Expected scriptfile at argument 1, got boolean]
    54. [2017-08-03 21:38:13] WARNING: ultimate/register_login/loggedin_mysql.lua:13: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got boolean]
    55. [2017-08-03 21:38:13] SCRIPT ERROR: ultimate/clicksys/clicksys_server.lua:1: '=' expected near '-'
    56. [2017-08-03 21:38:13] ERROR: Loading script failed: ultimate/clicksys/clicksys_server.lua:1: '=' expected near '-'
    57. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:216: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    58. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:216: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    59. [2017-08-03 21:38:13] INFO: [createCarhouses] Error executing the query
    60. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:231: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    61. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:231: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    62. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:245: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got boolean]
    63. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:287: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    64. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:287: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    65. [2017-08-03 21:38:13] INFO: [checkForOldMails] Error executing the query
    66. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:331: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    67. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:331: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    68. [2017-08-03 21:38:13] INFO: [loadOffers] Error executing the query
    69. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:368: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got boolean]
    70. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:369: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    71. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:369: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    72. [2017-08-03 21:38:13] INFO: [createSaveAblePlacedObjects] Error executing the query
    73. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:386: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    74. [2017-08-03 21:38:13] WARNING: ultimate/mysql/mysql_functions.lua:386: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    75. [2017-08-03 21:38:13] INFO: [initTetrisHighscores] Error executing the query
    76. [2017-08-03 21:38:13] WARNING: ultimate/register_login/loggedin_mysql.lua:13: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got boolean]
    77. [2017-08-03 21:38:13] WARNING: ultimate/biz/prestige.lua:6: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    78. [2017-08-03 21:38:13] WARNING: ultimate/biz/prestige.lua:6: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    79. [2017-08-03 21:38:13] WARNING: ultimate/fraktionen/gangareas.lua:112: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    80. [2017-08-03 21:38:13] WARNING: ultimate/fraktionen/gangareas.lua:112: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    81. [2017-08-03 21:38:13] ERROR: ultimate/fraktionen/gangareas.lua:113: attempt to get length of local 'result' (a boolean value)
    82. [2017-08-03 21:38:13] WARNING: ultimate/fraktionen/fdepots.lua:30: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    83. [2017-08-03 21:38:13] WARNING: ultimate/fraktionen/fdepots.lua:30: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    84. [2017-08-03 21:38:13] ERROR: ultimate/fraktionen/fdepots.lua:31: attempt to get length of local 'dsatz' (a boolean value)
    85. [2017-08-03 21:38:13] WARNING: ultimate/housesys/houses_mysql.lua:119: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    86. [2017-08-03 21:38:13] WARNING: ultimate/housesys/houses_mysql.lua:119: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    87. [2017-08-03 21:38:13] INFO: [houseCreation] Error executing the query.
    88. [2017-08-03 21:38:13] Gamemode 'Moavi-Reallife' started.
    89. [2017-08-03 21:38:13] Querying MTA master server... success! (Auto detected IP:185.188.7.102)
    90. [2017-08-03 21:38:13] Authorized serial account protection is enabled for the ACL group(s): `Admin` See http://mtasa.com/authserial
    91. [2017-08-03 21:38:13] WARNING: <owner_email_address> not set
    92. [2017-08-03 21:38:13] Server started and is ready to accept connections!
    93. [2017-08-03 21:38:13] To stop the server, type 'shutdown' or press Ctrl-C
    94. [2017-08-03 21:38:13] Type 'help' for a list of commands.
    95. [2017-08-03 21:38:14] WARNING: ultimate/mysql/mysql_functions.lua:12: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    96. [2017-08-03 21:38:14] WARNING: ultimate/mysql/mysql_functions.lua:12: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    97. [2017-08-03 21:38:14] INFO: [setBizDataSQL] Error executing the query
    98. [2017-08-03 21:38:19] CONNECT: [sL]FlakkZ connected (IP: 95.91.227.169 Serial: 06014E2D4DBE9BB3B05C71BCDCA3ACA1 Version: 1.5.4-9.11595.1)
    99. [2017-08-03 21:38:19] JOIN: [sL]FlakkZ joined the game (IP: 95.91.227.169)
    100. [2017-08-03 21:38:26] WARNING: ultimate/register_login/account.lua:23: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    101. [2017-08-03 21:38:26] WARNING: ultimate/register_login/account.lua:23: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    102. [2017-08-03 21:38:39] WARNING: ultimate/register_login/account.lua:23: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    103. [2017-08-03 21:38:39] WARNING: ultimate/register_login/account.lua:23: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    104. [2017-08-03 21:38:39] WARNING: ultimate/register_login/loggedin_mysql.lua:3: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got boolean]
    105. [2017-08-03 21:38:39] WARNING: ultimate/register_login/register_login_server.lua:142: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got boolean]
    106. [2017-08-03 21:38:39] WARNING: ultimate/register_login/register_login_server.lua:143: Bad argument @ 'dbExec' [Expected db-connection at argument 1, got boolean]
    107. [2017-08-03 21:38:39] WARNING: ultimate/register_login/register_login_server.lua:169: Bad argument @ 'dbQuery' [Expected db-connection at argument 1, got boolean]
    108. [2017-08-03 21:38:39] WARNING: ultimate/register_login/register_login_server.lua:169: Bad argument @ 'dbPoll' [Expected db-query at argument 1, got boolean]
    109. [2017-08-03 21:38:39] ERROR: ultimate/register_login/register_login_server.lua:169: attempt to index a boolean value
    Alles anzeigen
  • das ding ist weiß ja nicht mal was ich da bei, eingeben muss da ich ja ein phpmyadmin datenbank habe und ein neuen ordner angelegt habe extra für den server deswegen frage ich

    Quellcode

    1. local gMysqlHost = "127.0.0.1"
    2. local gMysqlUser = "root"
    3. local gMysqlPass = "*******"
    4. local gMysqlDatabase = "root"
    5. handler = nil
    6. playerUID = {}
    7. playerUIDName = {}
  • Step 1 --> prntscr.com/g4184a

    Step 2: prntscr.com/g418fb

    Step 3: prntscr.com/g418p5 | Daten eintragen und Hacken rein!

    Step 4 : Deine .sql datei Importieren, Daten eintragen and your finished!

    Black schrieb:

    Och hoffe ihr bekommt mal ein Blitz ins Auge

    Es gibt Leute, die geizen mit ihrem Verstand wie andere mit ihrem Geld

    Mein Ultimate Edit: github.com/n0pe97/Ultimate-Edit

    Mein GitHub: GitHub
    Discord: n0pe#3317
    Teamspeak: Visual-Life