[dusk]

The problem is that it doesn't work for me. It doesn't set the right skin, always 0. I send a query OnPlayerConnect and SpawnPlayer as soon as he logins.

Here's the loading:

pawn Код:

forward OnSpawnCheck(playerid);
public OnSpawnCheck(playerid)
{
    new tmp[32],Float:Pos[3],skin;
    cache_get_row(0,0,tmp,dbHandle); skin=strval(tmp);
    cache_get_row(0,1,tmp,dbHandle); Pos[0]=floatstr(tmp);
    cache_get_row(0,2,tmp,dbHandle); Pos[1]=floatstr(tmp);
    cache_get_row(0,3,tmp,dbHandle); Pos[2]=floatstr(tmp);
    printf("%d",skin);
    SetSpawnInfo(playerid,0,skin,Pos[0],Pos[1],Pos[2],0,0,0,0,0,0,0);
    return 1;
}

And it prints out the skin correctly. But it's not loaded... The coordinates are correct.

[Avi Raj]

use this :-

pawn Код:

forward OnSpawnCheck(playerid);
public OnSpawnCheck(playerid)
{
    new tmp[32],Float:Pos[3],skin;
    cache_get_row(0,0,tmp,dbHandle); skin=strval(tmp);
    cache_get_row(0,1,tmp,dbHandle); Pos[0]=floatstr(tmp);
    cache_get_row(0,2,tmp,dbHandle); Pos[1]=floatstr(tmp);
    cache_get_row(0,3,tmp,dbHandle); Pos[2]=floatstr(tmp);
    cache_get_row(0,4,tmp,dbHandle); Pos[3]=floatstr(tmp);
    printf("%d",skin);
    SetSpawnInfo(playerid,0,skin,Pos[0],Pos[1],Pos[2],Pos[3],0,0,0,0,0,0); // pos[3] // For Floating Angle
    return 1;
}

[dusk]

Okay..that will set the player's facing angle. But how does that help me with my problem?

[Avi Raj]

What skin you need?
Random or what?

[Abhishek.]

Quote:

It doesn't set the right skin, always 0. seSetSpawnInfo(playerid,0,skin,Pos[0],Pos[1],Pos[2],Pos[3],0,0,0,0,0,0 what would you expect when its set to 0

2nd parameter

[dusk]

Avi Raj, i need the skin it loads...Which is not 0 in the DB.

Abhishek, I dare to disagree: https://sampwiki.blast.hk/wiki/SetSpawnInfo

[dusk]

bump

[Avi Raj]

dusk, i was Helping you and you did : -Rep!
Lol, then don't think someone will Help you.

[Abhishek.]

he wants the sking he loads from the mysql database

Код:

    cache_get_row(0,0,tmp,dbHandle); skin=strval(tmp);

i cant help coz i dont have any knowledge on mysql databse
EDIT:well do it prints correctly?

[dusk]

Avi Raj, I did NOT -rep you. Why should I do that? You tried, and I appreciate it.

Abhishek, yes it is printed out correctly.