[speed258]

hi guys in new r7 plungin blueg is a new funcktion cache_get_row so how correctly know where and which row is getting server to player? example:

Код:

cache_get_row(0, 6, temp), sscanf(temp, "f", zpos[0]),
	cache_get_row(0, 7, temp), sscanf(temp, "f", zpos[1]),
	cache_get_row(0, 8, temp), sscanf(temp, "f", zpos[2]),

in my mysql database x.y,z pos is X - 6, Y -7, Z -8 but still nothing i get any ideas what can be wrong?

[speed258]

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?

[speed258]

and here my mysql database any ideas what can be wrong?

[speed258]

anyone please help my to solve the problem

[Misiur]

1. Set your database and tables encoding to utf8_general_ci - this will spare you problems later
2. Use [ pawn] tag, not quotes
3. Missing quote in checkacc
4. Use mysql_format, not normal format (sql injection and stuff)
5. Wrong index in cache_get_row (2 instead of 1)

pawn Код:

stock CheckAccount(playerid)
{
    mysql_format(data, query, "SELECT SQLID, Password FROM `profiles` WHERE `Name` = '%e' LIMIT 0,1", PlayerName(playerid));
    mysql_function_query(data, query, true, "checkacc", "i", playerid);
    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, data); 
            usrDB[playerid][SQLID] = strval(id);
            cache_get_row(0, 1, usrDB[playerid][password], data);
            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;
}

[speed258]

pawn Код:

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

}
}
}

and this code is correct? how about LoadAccount(playerid) better use here or after playerspawn callback?

[Misiur]

I don't know if code is correct, run it maybe? Placement is good, because you might want to load some spawn-related data (position, skin or something)

[speed258]

pawn Код:

stock LoadAccount(playerid)
{
    mysql_format(data, query, "SELECT * FROM `users` WHERE `SQLID` = %i", usrDB[playerid][SQLID]);
    mysql_function_query(duomenys, query, true, "LoadPlayerData", "i", playerid);
}

here i prepare load data

pawn Код:

stock LoadPlayerData(playerid)
{
new Float:zpos[4];
    new temp[140];
cache_get_row(0, 5, temp), sscanf(temp, "f", zpos[0]), // x
    cache_get_row(0, 6, temp), sscanf(temp, "f", zpos[1]),//y
    cache_get_row(0, 7, temp), sscanf(temp, "f", zpos[2]),//z
    cache_get_row(0, 8, temp), sscanf(temp, "f", zpos[3]);//angle
SetPlayerPos(playerid,zpos[0],zpos[1],zpos[2]);
    //
    SetPlayerFacingAngle(playerid,zpos[3]);

here my load data and nothing loading i'm still falling from sky but in my database x,y,z,angle id is X(6), Y(7), Z(, ANGLE(9) any ideas why i'am falling?

[Misiur]

pawn Код:

cache_get_row(0, 5, temp), sscanf(temp, "f", zpos[0]), // x
cache_get_row(0, 6, temp), sscanf(temp, "f", zpos[1]),//y
cache_get_row(0, 7, temp), sscanf(temp, "f", zpos[2]),//z
cache_get_row(0, 8, temp), sscanf(temp, "f", zpos[3]);//angle

1. Move index back by 1 (in PMA they start at 1, cache_get_row is 0 based)
2. use floatval

pawn Код:

cache_get_row(0, 4, temp);
zpos[0] = floatstr(temp);
cache_get_row(0, 5, temp);
zpos[1] = floatstr(temp);
cache_get_row(0, 6, temp);
zpos[2] = floatstr(temp);
cache_get_row(0, 7, temp);
zpos[3] = floatstr(temp);

#e: oops, stupid me

[speed258]

but if i want use sscanf so no way to make on sscanf just floatstr? you see on sscanf simplier to use to me so every script if possible use sscanf