23.06.2014, 12:25
Hey.I have a problem with my Sqlite System.
OnGameModeInit:
OnGameModeExit:
OnPlayerConnect:
and OnDialogResponde:
OnGameModeInit:
PHP код:
Database = db_open("DataBase.db");
db_free_result(db_query(Database, "CREATE TABLE IF NOT EXISTS `Conturi` (`PlayerIP`,\
`Nume`,\
`Parola`,\
`AdminLevel`,\
`Ucideri`,\
`Decese`,\
`Bani`,\
`Culoare`,\
`Skin`,\
`Level`)"));
PHP код:
db_close(Database);
PHP код:
new Query[256], DBResult:Result;
format(Query, sizeof(Query), "SELECT * FROM `Conturi` WHERE `Nume` = '%s'", DB_Escape(Name(playerid)));
Result = db_query(Database,Query);
new string[128];
if(db_num_rows(Result))
{
format(string,sizeof(string),"{FFFFFF}Bine ai revenit {00FFFF}%s\nLast login {FF0000}XX:XX XX.XX.XX{FFFFFF}\nTe rog sa iti intoduci {FFFF00}parola",Name(playerid));
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Logare",string,"Logare","Iesire");
}else{
format(string,sizeof(string),"{FFFFFF}Bine ai venit {00FFFF}%s{FFFFFF}.\n{FFFFFF}Te rog sa iti intoduci {FFFF00}parola {FFFFFF}pentru a te inregistra",Name(playerid));
ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Inregisrtare",string,"Inregistrare","Iesire");
}
db_free_result(DBResult:Result);
PHP код:
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
new string[128],string2[128];
switch( dialogid )
{
case DIALOG_REGISTER:
{
if(!response) return Kick(playerid);
if(response)
{
format(string,sizeof(string),"{FFFFFF}Bine ai venit {00FFFF}%s{FFFFFF}.\n{FF0000}In parola trebuie sa ai minim 4 caractere si maxim 26.",Name(playerid));
if(strlen(inputtext) < 4) return ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Inregisrtare",string,"Inregistrare","Iesire");
if(strlen(inputtext) > 26) return ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Inregisrtare",string,"Inregistrare","Iesire");
{
format(string2,sizeof(string2),"{FFFFFF}Bine ai venit {00FFFF}%s{FFFFFF}.\n{FF0000}Nu poti lasa campul gol.\n{FFFFFF}",Name(playerid));
if(!strlen(inputtext)) return ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Inregisrtare",string2,"Inregistrare","Iesire");
new name[MAX_PLAYER_NAME+1];
GetPlayerName(playerid,name,sizeof(name));
new Query[129];
This is not work------> format(Query, sizeof(Query), "INSERT INTO `Conturi` (`PlayerIP`,`Nume`,\
`Parola`, `AdminLevel`,\
`Ucideri`,`Decese`,\
`Bani`,`Culoare`,\
`Skin`,`Level`) VALUES('%d','%s','%s','%d','%d','%d','%d','%d','%d','%d')",GetPlayerIPEx(playerid),DB_Escape(name),DB_Escape(inputtext),0,0,0,0,0,0,0);
db_query(Database, Query);
db_free_result( db_query(Database, Query) );
}
}
}
case DIALOG_LOGIN:
{
if(!response) return Kick(playerid);
if(response)
{
}
}
}
return 1;
}