SA:MP MySQL v2.1 problem

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
  • ich benutze das include von
    SA:MP MySQL v2.1 Functions
    * (c) Copyright 2011, StrickenKid


    wäre nett wenn mir jemand helfenwürde das auf strickenkid um zuschreiben
    @'Jeffry'

    stock AktualisiereTOPTENListen(status)
    {
    new query[512], TopTenName[10][MAX_PLAYER_NAME], TopTenValue[10], data[64], counter=0, string[512];
    if(status == 1 || status == 999)//Morde
    {
    format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Gebannt` = '0' ORDER BY `Morde` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("Name", TopTenName[counter]);
    mysql_fetch_field("Morde", data), TopTenValue[counter] = strval(data);
    counter++;
    }
    mysql_free_result();
    counter = 0;
    format(string, sizeof(string), "{FFBF00}1. %s | %d Morde", TopTenName[0], TopTenValue[0]), SetDynamicObjectMaterialText(TOPTENSchilder[0], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s | %d Morde\n{0080FF}3. {FFFFFF}%s | %d Morde\n{0080FF}4. {FFFFFF}%s | %d Morde", TopTenName[1], TopTenValue[1], TopTenName[2], TopTenValue[2], TopTenName[3], TopTenValue[3]), SetDynamicObjectMaterialText(TOPTENSchilder[0], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s | %d Morde\n{0080FF}6. {FFFFFF}%s | %d Morde\n{0080FF}7. {FFFFFF}%s | %d Morde", TopTenName[4], TopTenValue[4], TopTenName[5], TopTenValue[5], TopTenName[6], TopTenValue[6]), SetDynamicObjectMaterialText(TOPTENSchilder[0], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s | %d Morde\n{0080FF}9. {FFFFFF}%s | %d Morde\n{0080FF}10. {FFFFFF}%s | %d Morde", TopTenName[7], TopTenValue[7], TopTenName[8], TopTenValue[8], TopTenName[9], TopTenValue[9]), SetDynamicObjectMaterialText(TOPTENSchilder[0], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    if(status == 2 || status == 999)//Tode
    {
    format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Gebannt` = '0' ORDER BY `Tode` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("Name", TopTenName[counter]);
    mysql_fetch_field("Tode", data), TopTenValue[counter] = strval(data);
    counter++;
    }
    mysql_free_result();
    counter = 0;
    format(string, sizeof(string), "{FFBF00}1. %s | %d Tode", TopTenName[0], TopTenValue[0]), SetDynamicObjectMaterialText(TOPTENSchilder[1], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s | %d Tode\n{0080FF}3. {FFFFFF}%s | %d Tode\n{0080FF}4. {FFFFFF}%s | %d Tode", TopTenName[1], TopTenValue[1], TopTenName[2], TopTenValue[2], TopTenName[3], TopTenValue[3]), SetDynamicObjectMaterialText(TOPTENSchilder[1], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s | %d Tode\n{0080FF}6. {FFFFFF}%s | %d Tode\n{0080FF}7. {FFFFFF}%s | %d Tode", TopTenName[4], TopTenValue[4], TopTenName[5], TopTenValue[5], TopTenName[6], TopTenValue[6]), SetDynamicObjectMaterialText(TOPTENSchilder[1], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s | %d Tode\n{0080FF}9. {FFFFFF}%s | %d Tode\n{0080FF}10. {FFFFFF}%s | %d Tode", TopTenName[7], TopTenValue[7], TopTenName[8], TopTenValue[8], TopTenName[9], TopTenValue[9]), SetDynamicObjectMaterialText(TOPTENSchilder[1], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    if(status == 3 || status == 999)//Maximale Wantedpunkte
    {
    format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Gebannt` = '0' ORDER BY `MaxWanteds` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("Name", TopTenName[counter]);
    mysql_fetch_field("MaxWanteds", data), TopTenValue[counter] = strval(data);
    counter++;
    }
    mysql_free_result();
    counter = 0;
    format(string, sizeof(string), "{FFBF00}1. %s | %d Punkte", TopTenName[0], TopTenValue[0]), SetDynamicObjectMaterialText(TOPTENSchilder[2], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s | %d Punkte\n{0080FF}3. {FFFFFF}%s | %d Punkte\n{0080FF}4. {FFFFFF}%s | %d Punkte", TopTenName[1], TopTenValue[1], TopTenName[2], TopTenValue[2], TopTenName[3], TopTenValue[3]), SetDynamicObjectMaterialText(TOPTENSchilder[2], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s | %d Punkte\n{0080FF}6. {FFFFFF}%s | %d Punkte\n{0080FF}7. {FFFFFF}%s | %d Punkte", TopTenName[4], TopTenValue[4], TopTenName[5], TopTenValue[5], TopTenName[6], TopTenValue[6]), SetDynamicObjectMaterialText(TOPTENSchilder[2], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s | %d Punkte\n{0080FF}9. {FFFFFF}%s | %d Punkte\n{0080FF}10. {FFFFFF}%s | %d Punkte", TopTenName[7], TopTenValue[7], TopTenName[8], TopTenValue[8], TopTenName[9], TopTenValue[9]), SetDynamicObjectMaterialText(TOPTENSchilder[2], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    if(status == 4 || status == 999)//Level
    {
    format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Gebannt` = '0' ORDER BY `Level` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("Name", TopTenName[counter]);
    mysql_fetch_field("Level", data), TopTenValue[counter] = strval(data);
    counter++;
    }
    mysql_free_result();
    counter = 0;
    format(string, sizeof(string), "{FFBF00}1. %s | Level %d", TopTenName[0], TopTenValue[0]), SetDynamicObjectMaterialText(TOPTENSchilder[3], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s | Level %d\n{0080FF}3. {FFFFFF}%s | Level %d\n{0080FF}4. {FFFFFF}%s | Level %d", TopTenName[1], TopTenValue[1], TopTenName[2], TopTenValue[2], TopTenName[3], TopTenValue[3]), SetDynamicObjectMaterialText(TOPTENSchilder[3], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s | Level %d\n{0080FF}6. {FFFFFF}%s | Level %d\n{0080FF}7. {FFFFFF}%s | Level %d", TopTenName[4], TopTenValue[4], TopTenName[5], TopTenValue[5], TopTenName[6], TopTenValue[6]), SetDynamicObjectMaterialText(TOPTENSchilder[3], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s | Level %d\n{0080FF}9. {FFFFFF}%s | Level %d\n{0080FF}10. {FFFFFF}%s | Level %d", TopTenName[7], TopTenValue[7], TopTenName[8], TopTenValue[8], TopTenName[9], TopTenValue[9]), SetDynamicObjectMaterialText(TOPTENSchilder[3], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    if(status == 5 || status == 999)//Kill/Death-Rotation
    {
    format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Gebannt` = '0' AND `Level` >= '3' AND `Morde` >= '30' AND `Tode` >= '8' ORDER BY `Morde`/`Tode` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    new Float:kills, Float:deaths, Float:kd, KDR[10][16];
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("Name", TopTenName[counter]);
    mysql_fetch_field("Morde", data), kills = floatstr(data);
    mysql_fetch_field("Tode", data), deaths = floatstr(data);
    if(deaths < 1.0)deaths = 1.0;
    kd=floatdiv(kills, deaths);
    format(KDR[counter], sizeof(KDR[]), "%f", kd);
    strdel(KDR[counter], strlen(KDR[counter])-4, strlen(KDR[counter]));
    counter++;
    }
    mysql_free_result();
    counter = 0;
    format(string, sizeof(string), "{FFBF00}1. %s | %s", TopTenName[0], KDR[0]), SetDynamicObjectMaterialText(TOPTENSchilder[4], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s | %s\n{0080FF}3. {FFFFFF}%s | %s\n{0080FF}4. {FFFFFF}%s | %s", TopTenName[1], KDR[1], TopTenName[2], KDR[2], TopTenName[3], KDR[3]), SetDynamicObjectMaterialText(TOPTENSchilder[4], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s | %s\n{0080FF}6. {FFFFFF}%s | %s\n{0080FF}7. {FFFFFF}%s | %s", TopTenName[4], KDR[4], TopTenName[5], KDR[5], TopTenName[6], KDR[6]), SetDynamicObjectMaterialText(TOPTENSchilder[4], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s | %s\n{0080FF}9. {FFFFFF}%s | %s\n{0080FF}10. {FFFFFF}%s | %s", TopTenName[7], KDR[7], TopTenName[8], KDR[8], TopTenName[9], KDR[9]), SetDynamicObjectMaterialText(TOPTENSchilder[4], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    if(status == 6 || status == 999)//AFK-Zeit
    {
    format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Gebannt` = '0' ORDER BY `AFKZeit` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("Name", TopTenName[counter]);
    mysql_fetch_field("AFKZeit", data), TopTenValue[counter] = strval(data);
    TopTenValue[counter] = (TopTenValue[counter]/60)/60;
    counter ++;
    }
    counter = 0;
    mysql_free_result();
    format(string, sizeof(string), "{FFBF00}1. %s | %d Stunden", TopTenName[0], TopTenValue[0]), SetDynamicObjectMaterialText(TOPTENSchilder[5], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s | %d Stunden\n{0080FF}3. {FFFFFF}%s | %d Stunden\n{0080FF}4. {FFFFFF}%s | %d Stunden", TopTenName[1], TopTenValue[1], TopTenName[2], TopTenValue[2], TopTenName[3], TopTenValue[3]), SetDynamicObjectMaterialText(TOPTENSchilder[5], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s | %d Stunden\n{0080FF}6. {FFFFFF}%s | %d Stunden\n{0080FF}7. {FFFFFF}%s | %d Stunden", TopTenName[4], TopTenValue[4], TopTenName[5], TopTenValue[5], TopTenName[6], TopTenValue[6]), SetDynamicObjectMaterialText(TOPTENSchilder[5], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s | %d Stunden\n{0080FF}9. {FFFFFF}%s | %d Stunden\n{0080FF}10. {FFFFFF}%s | %d Stunden", TopTenName[7], TopTenValue[7], TopTenName[8], TopTenValue[8], TopTenName[9], TopTenValue[9]), SetDynamicObjectMaterialText(TOPTENSchilder[5], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    if(status == 7 || status == 999)//Pfandflaschen
    {
    format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Gebannt` = '0' ORDER BY `FlaschenGesamt` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("Name", TopTenName[counter]);
    mysql_fetch_field("FlaschenGesamt", data), TopTenValue[counter] = strval(data);
    counter++;
    }
    mysql_free_result();
    counter = 0;
    format(string, sizeof(string), "{FFBF00}1. %s | %d Flaschen", TopTenName[0], TopTenValue[0]), SetDynamicObjectMaterialText(TOPTENSchilder[6], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s | %d Flaschen\n{0080FF}3. {FFFFFF}%s | %d Flaschen\n{0080FF}4. {FFFFFF}%s | %d Flaschen", TopTenName[1], TopTenValue[1], TopTenName[2], TopTenValue[2], TopTenName[3], TopTenValue[3]), SetDynamicObjectMaterialText(TOPTENSchilder[6], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s | %d Flaschen\n{0080FF}6. {FFFFFF}%s | %d Flaschen\n{0080FF}7. {FFFFFF}%s | %d Flaschen", TopTenName[4], TopTenValue[4], TopTenName[5], TopTenValue[5], TopTenName[6], TopTenValue[6]), SetDynamicObjectMaterialText(TOPTENSchilder[6], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s | %d Flaschen\n{0080FF}9. {FFFFFF}%s | %d Flaschen\n{0080FF}10. {FFFFFF}%s | %d Flaschen", TopTenName[7], TopTenValue[7], TopTenName[8], TopTenValue[8], TopTenName[9], TopTenValue[9]), SetDynamicObjectMaterialText(TOPTENSchilder[6], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    if(status == 8 || status == 999)//Reichste Fraktion
    {
    format(query, sizeof(query), "SELECT * FROM `frakinfo` WHERE `fID` < '17' AND `fID` != '2' AND `fID` != '7' ORDER BY `Geld` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("SmallName", TopTenName[counter]);
    mysql_fetch_field("Geld", data), TopTenValue[counter] = strval(data);
    counter++;
    }
    mysql_free_result();
    counter = 0;
    format(string, sizeof(string), "{FFBF00}1. %s | %s€", TopTenName[0], number_format(TopTenValue[0])), SetDynamicObjectMaterialText(TOPTENSchilder[7], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s | %s€\n{0080FF}3. {FFFFFF}%s | %s€\n{0080FF}4. {FFFFFF}%s | %s€", TopTenName[1], number_format(TopTenValue[1]), TopTenName[2], number_format(TopTenValue[2]), TopTenName[3], number_format(TopTenValue[3])), SetDynamicObjectMaterialText(TOPTENSchilder[7], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s | %s€\n{0080FF}6. {FFFFFF}%s | %s€\n{0080FF}7. {FFFFFF}%s | %s€", TopTenName[4], number_format(TopTenValue[4]), TopTenName[5], number_format(TopTenValue[5]), TopTenName[6], number_format(TopTenValue[6])), SetDynamicObjectMaterialText(TOPTENSchilder[7], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s | %s€\n{0080FF}9. {FFFFFF}%s | %s€\n{0080FF}10. {FFFFFF}%s | %s€", TopTenName[7], number_format(TopTenValue[7]), TopTenName[8], number_format(TopTenValue[8]), TopTenName[9], number_format(TopTenValue[9])), SetDynamicObjectMaterialText(TOPTENSchilder[7], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    if(status == 9 || status == 999)//Reichster Spieler
    {
    format(query, sizeof(query), "SELECT `Name` FROM `accounts` JOIN `accounts_bank` WHERE `accounts`.`userID` = `accounts_bank`.`userID` AND `Gebannt` = '0' ORDER BY `accounts`.`Geld`+`accounts_bank`.`GirokontoStand`+`accounts_bank`.`SparkontoStand` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("Name", TopTenName[counter]);
    counter++;
    }
    mysql_free_result();
    counter = 0;
    format(string, sizeof(string), "{FFBF00}1. %s", TopTenName[0]), SetDynamicObjectMaterialText(TOPTENSchilder[8], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s\n{0080FF}3. {FFFFFF}%s\n{0080FF}4. {FFFFFF}%s", TopTenName[1], TopTenName[2], TopTenName[3]), SetDynamicObjectMaterialText(TOPTENSchilder[8], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s\n{0080FF}6. {FFFFFF}%s\n{0080FF}7. {FFFFFF}%s", TopTenName[4], TopTenName[5], TopTenName[6]), SetDynamicObjectMaterialText(TOPTENSchilder[8], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s\n{0080FF}9. {FFFFFF}%s\n{0080FF}10. {FFFFFF}%s", TopTenName[7], TopTenName[8], TopTenName[9]), SetDynamicObjectMaterialText(TOPTENSchilder[8], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    if(status == 10 || status == 999)//Paintball Teffer
    {
    format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Gebannt` = '0' ORDER BY `PaintballMorde` DESC LIMIT 10;");
    mysql_query(sqlHandle, query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
    mysql_fetch_field("Name", TopTenName[counter]);
    mysql_fetch_field("PaintballMorde", data), TopTenValue[counter] = strval(data);
    counter ++;
    }
    mysql_free_result();
    format(string, sizeof(string), "{FFBF00}1. %s | %d Treffer", TopTenName[0], TopTenValue[0]), SetDynamicObjectMaterialText(TOPTENSchilder[9], 4, string, 120, "Arial", 40, 1, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}2. {FFFFFF}%s | %d Treffer\n{0080FF}3. {FFFFFF}%s | %d Treffer\n{0080FF}4. {FFFFFF}%s | %d Treffer", TopTenName[1], TopTenValue[1], TopTenName[2], TopTenValue[2], TopTenName[3], TopTenValue[3]), SetDynamicObjectMaterialText(TOPTENSchilder[9], 3, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}5. {FFFFFF}%s | %d Treffer\n{0080FF}6. {FFFFFF}%s | %d Treffer\n{0080FF}7. {FFFFFF}%s | %d Treffer", TopTenName[4], TopTenValue[4], TopTenName[5], TopTenValue[5], TopTenName[6], TopTenValue[6]), SetDynamicObjectMaterialText(TOPTENSchilder[9], 2, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    format(string, sizeof(string), "{0080FF}8. {FFFFFF}%s | %d Treffer\n{0080FF}9. {FFFFFF}%s | %d Treffer\n{0080FF}10. {FFFFFF}%s | %d Treffer", TopTenName[7], TopTenValue[7], TopTenName[8], TopTenValue[8], TopTenName[9], TopTenValue[9]), SetDynamicObjectMaterialText(TOPTENSchilder[9], 1, string, 120, "Arial", 41, 0, -32256, 0xFF121212, 1);
    }
    return 1;
    }



    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90308) : warning 219: local variable "query" shadows a variable at a preceding level
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90314) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90330) : error 035: argument type mismatch (argument 1)
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90332) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90348) : error 035: argument type mismatch (argument 1)
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90350) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90366) : error 035: argument type mismatch (argument 1)
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90368) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90384) : error 035: argument type mismatch (argument 1)
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90387) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90408) : error 035: argument type mismatch (argument 1)
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90410) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90427) : error 035: argument type mismatch (argument 1)
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90429) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90445) : error 035: argument type mismatch (argument 1)
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90447) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90455) : error 017: undefined symbol "number_format"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90456) : error 017: undefined symbol "number_format"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90457) : error 017: undefined symbol "number_format"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90458) : error 017: undefined symbol "number_format"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90463) : error 035: argument type mismatch (argument 1)
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90465) : error 017: undefined symbol "mysql_retrieve_row"
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90480) : error 035: argument type mismatch (argument 1)
    C:\Users\Administrator\Desktop\Test-Sever server\gamemodes\Test-Sever.pwn(90482) : error 017: undefined symbol "mysql_retrieve_row"
    Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase




    23 Errors.

    2 Mal editiert, zuletzt von TimeLine ()

  • Du benutzt ein Falsches Include Kollege.


    LAde dir das Include für R5 runter.

  • das 2.1 ist doxh das gleiche wie R5 von blueg.
    Am besten schreibst du es in R41 schwer ist es nicht... alles steht im download was du ändern musst

  • Schreibe doch in google mysql r5 blueg

    C:\Users\Administrator\Desktop\test-server server\gamemodes\test-server.pwn(3371) : error 035: argument type mismatch (argument 1)

    stock mysql_GetStringByString(Table[], Field[], Where[],Where2[])
    {
    #pragma unused Where2
    #pragma unused Where
    #pragma unused Table
    new str[512];
    format(query, 512, "%s", Field);
    mysql_fetch_field(query,str);// hier ist der fehler!
    return str;
    }

    Einmal editiert, zuletzt von TimeLine ()