Danke hat geklappt.
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 ?
-
Wir sind hier im MTA Bereich nicht SAMP!
Ups Sorry, error ist immernoch da...
-
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") -
Immer noch der gleiche error
-
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 lineCompilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase
4 Errors.
-
Ja ich verbinde mich richtig mit der datenbank sonst könnte ich mich auch nicht registrieren.
-
Ja eigentlich schon,
http://puu.sh/gyz1N/f80ccf3e2a.png -
enum players{
db_id,
level,
money,
spawnchange,
hp,
alevel,
frak,
frang,
donator,
carkeys
} -
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;
} -
Benutze als SAMP Code statt Quelltext
Sorry wen ich so dumm frage aber wie geht das ich bin neu im forum
-
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.