MYSQL Probleme Kenn mich nicht so gut aus

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Hey leute Ich kenn mich wirklich garnicht mit MYSQL aus ein netter kerl hat mir 1 Script geschickt jedoch krieg ich sehr viele probleme :S Hier mein ServerLog


    [21:00:11] *** Streamer Plugin: Obsolete or invalid native "Streamer_RegisterInterface" found (script needs to be recompiled with the latest include file)
    [21:00:11] *** Streamer Plugin: Obsolete or invalid native "Streamer_AddPlayer" found (script needs to be recompiled with the latest include file)
    [21:00:11] *** Streamer Plugin: Obsolete or invalid native "Streamer_RemovePlayer" found (script needs to be recompiled with the latest include file)
    [21:00:11] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyPickup" found (script needs to be recompiled with the latest include file)
    [21:00:11] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyCheckpoint" found (script needs to be recompiled with the latest include file)
    [21:00:11] *** Streamer Plugin: Include file version (unknown version) does not match plugin version (0x26105) (script needs to be recompiled with the latest include file)
    [21:00:11] Error: Function not registered: 'mysql_real_escape_string'
    [21:00:11] Error: Function not registered: 'mysql_query'
    [21:00:11] Error: Function not registered: 'mysql_store_result'
    [21:00:11] Error: Function not registered: 'mysql_fetch_row'
    [21:00:11] Error: Function not registered: 'mysql_free_result'
    [21:00:11] Error: Function not registered: 'mysql_fetch_int'
    [21:00:11] Error: Function not registered: 'mysql_num_rows'
    [21:00:11] Error: Function not registered: 'mysql_fetch_field'
    [21:00:11] Error: Function not registered: 'mysql_init'
    [21:00:11] Error: Function not registered: 'mysql_connect'
    [21:00:11] [MySQL] Connected (0) to 'samp3201'@'Localhost via UNIX socket'.
    [21:00:11] [MySQL] Server Version 5.1.66-0+squeeze1.
    [21:00:11] Lade Gangzonen..
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_fetch_int called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] Zone: 0 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_fetch_int called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] Zone: 1 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_fetch_int called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] Zone: 2 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_fetch_int called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] Zone: 3 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_fetch_int called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] Zone: 4 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_fetch_int called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] Zone: 5 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_fetch_int called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] Zone: 6 | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_fetch_int called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Failed to exeute query. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no prior successful query executed. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.
    [21:00:11] [MySQL] Error (0): Function: mysql_store_result called when no result stored. Table 'samp3201_germantropicreallife.gangzones' doesn't exist.

  • Verbunden hat MySQL. Die benötigten Tabellen sind in der Datenbank nicht vorhanden. Sprich dein Kumpel muss dir, damit es klappt, noch die Datenbankstruktur geben(je nachdem auch den Inhalt davon).
    //edit:
    Dein Plugin scheint auch nicht ganz zu funktionieren...
    Eventuell veraltet oder das falsche?
    Arbeite dich am besten mal in die Grundlagen von MySQL ein.
    Die brauchst du auf jeden Fall, wenn du damit arbeiten willst.