20.08.2011, 13:24
Why isn't this writing in the data base?
I know mysql, but i figured out to give a try at sqlite.
It's not writing, why?
I know mysql, but i figured out to give a try at sqlite.
It's not writing, why?
pawn Code:
if(dialogid == Registerdialog)
{
if(!response) return Kick(playerid);
new string[200],DBResult:qresult;
format(string,sizeof(string),""lblue"Welcome "lyellow"%s"lblue"! \n"lwhite"Please enter your "lgreen"password"lwhite" to register your account! \n",GetPName(playerid));
if(strlen(inputtext) == 0) return ShowPlayerDialog(playerid,Registerdialog,1,""lwhite"Login",string,"Register","Kick");
format(Query,sizeof(Query),"INSERT INTO `Users` (`Username`, `Password`, `Money`, `Score`, `Kills`, `Deaths`, `Arrests`, `Jailtime`, `Robbed`, `Level`, `RobRank`) VALUES ('%s','%s',0,0,0,0,0,0,0,0,0,0)",GetPName(playerid),inputtext);
db_free_result(db_query(Users,Query));
SendClientMessage(playerid,Red,"[REGISTERED] "lgrey"You have been "lblue"registered"lgrey"!");
qresult = db_query(Users,"SELECT * FROM `Users`");
SendFMessageToAll(Green,"%s "lblue"has registered. "lyellow"There are now "lwhite"%i "lyellow"registered users in our server.",GetPName(playerid),db_num_rows(qresult));
}