onplayerconnect

[ExTREME.]

sal dupa ce fac clanu setez skin name....se seteaza dar cand intru iar pe sv nu arata skin pe care lam setet...... ma puteti ajuta sa fac sa arate skin name..... uitati ce am la onplayerconnect

[pawn]new Query[ 256 ], DBResult:Result;

format(Query, sizeof(Query), "SELECT * FROM `Clans` WHERE `ClanName` = '%s'", Name(playerid));

Result = db_query(Database, Query);

if ( db_num_rows( Result ) )

{

new Field[30];

db_get_field_assoc(Result, "ClanLeaderSkin", Field, 30);

                P_DATA[ playerid ][ ClanLeadersSkin ] = strval( Field );

        db_get_field_assoc(Result, "ClanMemberSkin", Field, 30);

                P_DATA[ playerid ][ ClanMembersSkin ] = strval( Field );

db_get_field_assoc(Result, "ClanNameColor", Field, 30);

                P_DATA[ playerid ][ ClanNamesColor ] = strval( Field );

        db_get_field_assoc(Result, "ClanWeapon1", Field, 30);

                P_DATA[ playerid ][ ClanWeapons1 ] = strval( Field );

        db_get_field_assoc(Result, "ClanWeapon2", Field, 30);

                P_DATA[ playerid ][ ClanWeapons2 ] = strval( Field );

        db_get_field_assoc(Result, "ClanWeapon3", Field, 30);

                P_DATA[ playerid ][ ClanWeapons3 ] = strval( Field );

        db_get_field_assoc(Result, "ClanWeapon4", Field, 30);

                P_DATA[ playerid ][ ClanWeapons4 ] = strval( Field );

        db_get_field_assoc(Result, "ClanWeapon5", Field, 30);

                P_DATA[ playerid ][ ClanWeapons5 ] = strval( Field );

        db_get_field_assoc(Result, "ClanMember1", Field, 30);

                P_DATA[ playerid ][ ClanMembers1 ] = strval( Field );

        db_get_field_assoc(Result, "ClanMember2", Field, 30);

                P_DATA[ playerid ][ ClanMembers2 ] = strval( Field );

        db_get_field_assoc(Result, "ClanMember3", Field, 30);

                P_DATA[ playerid ][ ClanMembers3 ] = strval( Field );

        db_get_field_assoc(Result, "ClanMember4", Field, 30);

                P_DATA[ playerid ][ ClanMembers4 ] = strval( Field );

        db_get_field_assoc(Result, "ClanMember5", Field, 30);

                P_DATA[ playerid ][ ClanMembers5 ] = strval( Field );

        db_get_field_assoc(Result, "ClanKills", Field, 30);

                P_DATA[ playerid ][ ClanKillss ] = strval( Field );

        db_get_field_assoc(Result, "ClanDeaths", Field, 30);

                P_DATA[ playerid ][ ClanDeathss ] = strval( Field );

        db_get_field_assoc(Result, "ClanSef", Field, 30);

                P_DATA[ playerid ][ ClanSefs ] = strval( Field );

SetPlayerSkin( playerid, P_DATA[ playerid ][ ClanLeadersSkin ] );

SetPlayerSkin( playerid, P_DATA[ playerid ][ ClanMembersSkin ] );

}

    else

    {

    ShowPlayerDialog( playerid, 1200, DIALOG_STYLE_MSGBOX, "Clans Stats","The Clans Is The Best!","Ok","" );

    }

    db_free_result( Result );[/pawn]

[xxSPEEDYxx]

SetPlayerSkin... http://wiki.sa-mp.com/wiki/SetPlayerSkin