SA-MP Forums Archive
SQLite field get help needed - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQLite field get help needed (/showthread.php?tid=533064)


SQLite field get help needed - Kyance - 22.08.2014

So, I created a command "settings", which allows you to edit your name, email, password ...
But, I dunno how to .. do that email... = ...(Field); thing, It gives me an error, if I do email = Field, then it doesn't show anything :d

Code:
pawn Код:
CMD:settings(playerid, params[]) {
    new string[148], Query[120], DBResult:result, Field[70], email[50];
    format(Query, sizeof(Query), "SELECT * FROM `USERS` WHERE `NAME` = '%s'", DB_Escape(GetName(playerid)));
    result = db_query(HDF, Query);
    if(result) db_get_field_assoc(result, "EMAIL", Field, sizeof(Field)); email = strval(Field);
    format(string, sizeof(string), "{FFFFFF}Name - {64CC66}%s\n{FFFFFF}e-mail - {64CC66}%s\n{FFFFFF}Password - {64CC66}%s", GetName(playerid), email, PlayerInfo[playerid][Password]);
    ShowPlayerDialog(playerid, DIALOG_SETTINGS, DIALOG_STYLE_LIST, "Your settings/info", string, "Edit", "Close");
    db_free_result(result);
    return 1;
}


Respuesta: SQLite field get help needed - unuky - 22.08.2014

Because you are converting the email in a integer, use this:

pawn Код:
CMD:settings(playerid, params[]) {
    new string[148], Query[120], DBResult:result, Email[70];
    format(Query, sizeof(Query), "SELECT * FROM `USERS` WHERE `NAME` = '%s'", DB_Escape(GetName(playerid)));
    result = db_query(HDF, Query);
    if(result) db_get_field_assoc(result, "EMAIL", Email, sizeof(Email));
    format(string, sizeof(string), "{FFFFFF}Name - {64CC66}%s\n{FFFFFF}e-mail - {64CC66}%s\n{FFFFFF}Password - {64CC66}%s", GetName(playerid), Email, PlayerInfo[playerid][Password]);
    ShowPlayerDialog(playerid, DIALOG_SETTINGS, DIALOG_STYLE_LIST, "Your settings/info", string, "Edit", "Close");
    db_free_result(result);
    return 1;
}


Re: Respuesta: SQLite field get help needed - Kyance - 22.08.2014

Quote:
Originally Posted by unuky
Посмотреть сообщение
Because you are converting the email in a integer, use this:

pawn Код:
CMD:settings(playerid, params[]) {
    new string[148], Query[120], DBResult:result, Email[70];
    format(Query, sizeof(Query), "SELECT * FROM `USERS` WHERE `NAME` = '%s'", DB_Escape(GetName(playerid)));
    result = db_query(HDF, Query);
    if(result) db_get_field_assoc(result, "EMAIL", Email, sizeof(Email));
    format(string, sizeof(string), "{FFFFFF}Name - {64CC66}%s\n{FFFFFF}e-mail - {64CC66}%s\n{FFFFFF}Password - {64CC66}%s", GetName(playerid), Email, PlayerInfo[playerid][Password]);
    ShowPlayerDialog(playerid, DIALOG_SETTINGS, DIALOG_STYLE_LIST, "Your settings/info", string, "Edit", "Close");
    db_free_result(result);
    return 1;
}
Thank you