mysql r7
#2

Quote:

stock CheckAccount(playerid)
{
format(query, sizeof(query), "SELECT SQLID, Password FROM `profiles` WHERE `Name` = '%s' LIMIT 1", PlayerName(playerid));
mysql_function_query(data, query, true, "checkacc", "i", playerid);
printf("SQLID nick %s",PlayerName(playerid));//here i get NULL
return 1;
}

forward checkacc(playerid);
public checkacc(playerid)
{
if(playerid != INVALID_PLAYER_ID)// if the player is still connected
{
new rows, fields;
cache_get_data(rows, fields, data);

if(rows)
{
new id[30];
cache_get_row(0, 0, id, duomenys); usrDB[playerid][SQLID] = strval(id);
cache_get_row(0, 2, usrDB[playerid][password], data);
printf("SQLID nickslap %s",usrDB[playerid][password]); /// and here i get NULL
ShowPlayerDialog(playerid,3,DIALOG_STYLE_PASSWORD, "{2981FC}RPG {FFFFFF}• {F82222}Login","{FFFFFF}Please login:{FFFFFF}","Resume","Quit");
}
else
{
ShowPlayerDialog(playerid,2,DIALOG_STYLE_PASSWORD, "{2981FC}RPG {FFFFFF}• {F82222}Register","{FFFFFF}Please register,"Register","quit");
}
}
return 1;

and login system
Quote:

if(dialogid == 3) //
{
if(!response) //
{
SendClientMessage(playerid,BLUE,"RPG: Kick ASS");
Kick(playerid);
}
if(response) //
{
new textt[40];
if(sscanf(inputtext,"s[18]",textt)) return ShowPlayerDialog(playerid,3,DIALOG_STYLE_PASSWORD, "{2981FC}RPG {FFFFFF}• {F82222}Login","{FFFFFF}Insert Your password:","Resume","Quit");
printf("Text %s",textt); //here i get what i write into dialog
printf("Textas %s",usrDB[playerid][password]); //here i get NULL
if(strcmp(textt, usrDB[playerid][password]))
LoadAccount(playerid);
}
else
{
connect[playerid]++;
if(connect[playerid] == MAX_connect)
{
return SendClientMessage(playerid, RED, "RPG: out of wrong moves");
}
ShowPlayerDialog(playerid,3,DIALOG_STYLE_PASSWORD, "{2981FC}RPG {FFFFFF}• {F82222}Login","{FFFFFF}Your password is incorrect type new","resume","quit");

}
}
}

so any ideas what can be wrong whit this script?
Reply


Messages In This Thread
mysql r7 - by speed258 - 26.02.2013, 07:35
Re: mysql r7 - by speed258 - 26.02.2013, 10:11
Re: mysql r7 - by speed258 - 26.02.2013, 10:18
Re: mysql r7 - by speed258 - 26.02.2013, 11:59
Re: mysql r7 - by Misiur - 26.02.2013, 12:05
Re: mysql r7 - by speed258 - 26.02.2013, 12:39
Re: mysql r7 - by Misiur - 26.02.2013, 13:09
Re: mysql r7 - by speed258 - 26.02.2013, 13:29
Re: mysql r7 - by Misiur - 26.02.2013, 13:55
Re: mysql r7 - by speed258 - 26.02.2013, 14:19

Forum Jump:


Users browsing this thread: 2 Guest(s)