Beiträge von Soichiro_Yagami


    mysql_escape_string(inputtext,passwort,database);
    format(query,sizeof(query),"SELECT db_id FROM Clients WHERE Clientname='%s' AND password=MD5('%s')",name,passwort);
    mysql_function_query(database,query,true,"OnCheckPassword","i",playerid);


    Fehler gefunden

    mysql_escape_string(inputtext,passwort,database);
    format(query,sizeof(query),"SELECT ---->db_id<---- FROM Clients WHERE Clientname='%s' AND password=MD5('%s')",name,passwort);
    mysql_function_query(database,query,true,"OnCheckPassword","i",playerid);

    Ich sollte nicht nur die db_id selecten xD da muss ein * hin aber danke für den Support //Close


    ----------
    Loaded log file: "server_log.txt".
    ----------


    SA-MP Dedicated Server
    ----------------------
    v0.3z-R4, (C)2005-2014 SA-MP Team


    [00:34:23] filterscripts = "" (string)
    [00:34:23]
    [00:34:23] Server Plugins
    [00:34:23] --------------
    [00:34:23] Loading plugin: mysql.so
    [00:34:23] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory)
    [00:34:23] Loading plugin: sscanf.so
    [00:34:23]


    [00:34:23] ===============================


    [00:34:23] sscanf plugin loaded.


    [00:34:23] Version: 2.8.1


    [00:34:23] (c) 2012 Alex "Y_Less" Cole


    [00:34:23] ===============================


    [00:34:23] Loaded.
    [00:34:23] Loaded 1 plugins.


    [00:34:23]
    [00:34:23] Filterscripts
    [00:34:23] ---------------
    [00:34:23] Loaded 0 filterscripts.


    [00:34:23] Script[gamemodes/BE.amx]: Run time error 19: "File or function is not found"
    [00:34:23] Number of vehicle models: 0
    [00:34:24] --- Server Shutting Down.
    [00:34:24]


    Weiß jemand wie ich das mit der libmysqlclient_r.so.16 fixen kann ?


    new string[128];
    format(string,sizeof(string),"Herzlich Willkommen auf NSA-Reallife %s",getPlayerName(playerid));
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,string,"Dein Account wurde erfolgreich in der Datenbank gefunden.\n Bitte gebe dein Passwort ein um dich anzumelden.","Weiter","Abbrechen");


    [16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("level")
    [16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("money")
    [16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("spawnchange")
    [16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("hp")
    [16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("alevel")
    [16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frak")
    [16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frang")
    [16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("donator")
    [16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("carkeys")


    enum players{
    db_id,
    level,
    money,
    spawnchange,
    hp,
    alevel,
    frak,
    frang,
    donator,
    carkeys
    }
    new player[MAX_PLAYERS][players];[pwn]





    C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : error 028: invalid subscript (not an array or too many subscripts): "players"
    C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : warning 215: expression has no effect
    C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : error 001: expected token: ";", but found "]"
    C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : error 029: invalid expression, assumed zero
    C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : fatal error 107: too many error messages on one line


    Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase



    4 Errors.

    Herzlich Willkommen im Breadfish Forum.

    Danke und hier die Codes:


    SQL
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("level")
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("money")
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("spawnchange")
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("hp")
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("alevel")
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frak")
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frang")
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("donator")
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("carkeys")




    public OnCheckPassword(playerid)
    {
    new num_fields,num_rows;
    cache_get_data(num_rows,num_fields,database);
    if(num_rows==1)
    {
    //load
    player[playerid][level] = cache_get_field_content_int(0,"level",database);
    player[playerid][money] = cache_get_field_content_int(0,"money",database);
    player[playerid][spawnchange] = cache_get_field_content_int(0,"spawnchange",database);
    player[playerid][hp] = cache_get_field_content_int(0,"hp",database);
    player[playerid][alevel] = cache_get_field_content_int(0,"alevel",database);
    player[playerid][frak] = cache_get_field_content_int(0,"frak",database);
    player[playerid][frang] = cache_get_field_content_int(0,"frang",database);
    player[playerid][donator] = cache_get_field_content_int(0,"donator",database);
    player[playerid][carkeys] = cache_get_field_content_int(0,"carkeys",database);
    player[playerid][db_id] = cache_get_field_content_int(0,"id",database);
    SetPlayerScore(playerid, player[playerid][level]);
    GivePlayerMoney(playerid, player[playerid][money]);
    SetPlayerHealth(playerid,player[playerid][hp]);
    SendClientMessage(playerid, COLOR_RED, player[playerid][alevel]);
    }
    else
    {
    //Passwort falsch
    SendClientMessage(playerid,COLOR_RED,"Das eingegebene Passwort ist falsch.");
    ShowPlayerDialog(playerid,LOGIN_D,DIALOG_STYLE_PASSWORD,"Login","Gibt bitte dein Passwort ein:","Okay","Abbrechen");
    }
    return 1;
    }

    Lieben User,


    Ich bin seit einer zeit dabei einen SAMP Server zu schreiben,
    Leider ist mir wohl ein fehler beim Laden unterlaufen. Leider weiß ich nicht woran es Liegt hier mal den Error der MYSQL Log:

    SQL
    [20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("level")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("money")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("spawnchange")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("hp")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("alevel")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frak")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frang")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("donator")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("carkeys")



    Hier der SAMP Code:
    public OnCheckPassword(playerid){new num_fields,num_rows; cache_get_data(num_rows,num_fields,database); if(num_rows==1) { //load player[playerid][level] = cache_get_field_content_int(0,"level",database); player[playerid][money] = cache_get_field_content_int(0,"money",database); player[playerid][spawnchange] = cache_get_field_content_int(0,"spawnchange",database); player[playerid][hp] = cache_get_field_content_int(0,"hp",database); player[playerid][alevel] = cache_get_field_content_int(0,"alevel",database); player[playerid][frak] = cache_get_field_content_int(0,"frak",database); player[playerid][frang] = cache_get_field_content_int(0,"frang",database); player[playerid][donator] = cache_get_field_content_int(0,"donator",database); player[playerid][carkeys] = cache_get_field_content_int(0,"carkeys",database); player[playerid][db_id] = cache_get_field_content_int(0,"id",database); SetPlayerScore(playerid, player[playerid][level]); GivePlayerMoney(playerid, player[playerid][money]); SetPlayerHealth(playerid,player[playerid][hp]); SendClientMessage(playerid, COLOR_RED, player[playerid][alevel]); } else { SendClientMessage(playerid,COLOR_RED,"Das Passwort ist falsch."); ShowPlayerDialog(playerid,LOGIN_D,DIALOG_STYLE_PASSWORD,"Login","Gibt dein Passwort ein:","Okay","Abbrechen"); } return 1;}



    Würde mich über schnelle hilfe freuen.