[FireCat]

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?

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));
    }

[Lorenc_]

Try replace:

pawn Code:

('%s','%s',0,0,0,0,0,0,0,0,0,0)

with

pawn Code:

('%s', '%s', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')

That's how I do it. Works for me.

[FireCat]

Quote:

Originally Posted by Lorenc_ Try replace: pawn Code: ('%s','%s',0,0,0,0,0,0,0,0,0,0) with pawn Code: ('%s', '%s', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0') That's how I do it. Works for me.

Still doesn't.
How do you create tables?
I used sqlite database browser, but in the first column, i added ID and in ID i added INTEGER PRIMARY KEY for auto increment. Am i doing it wrong?

[Lorenc_]

pawn Code:

db_free_result(db_query(Database, "CREATE TABLE IF NOT EXISTS `USERS` (`IP`,`NAME`,`ID`)"));

I do it like that, not sure if its "Efficient" but works well

[FireCat]

Quote:

Originally Posted by Lorenc_ pawn Code: db_free_result(db_query(Database, "CREATE TABLE IF NOT EXISTS `USERS` (`IP`,`NAME`,`ID`)")); I do it like that, not sure if its "Efficient" but works well

If i could give you 10000 rep i would give it
THANK YOU!!
Worked perfect