Problem OnPlayerSpawn

[ExTREME.]

salut

Am creat un clan se salveaza clan name ca am rezolvat problema cu clan name culoare........ se scrie tot in Clans.db

dar Dupa ce es dp sv si intru iar clanul creat dispare uitati ce am la OnPlayerSpawn

[pawn]public OnPlayerSpawn(playerid)

{

new Query[256], string[128], DBResult:Result;

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

Result = db_query( Database, Query );

if( db_num_rows( Result ))

{

new Field[ 30 ];

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        GetPlayerSkin( playerid, P_DATA[ playerid ][ ClanMemberSkin ] );

        GetPlayerSkin( playerid, P_DATA[ playerid ][ ClanLeaderSkin ] );

    }

      else

      {

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

      }

      db_free_result( Result );

      return 1;

}[/pawn]

Si numi spawneaza nik arme culoarea numelui nik skin nik

Va rog ajutatima :D

[ExTREME.]

nu stie nimeni:O?

[xxSPEEDYxx]

nu stie nimeni:O?

Daca nu ai vazut in systemul ala( al meu ) este, cand se creeaza database am pus:

`Key` INTEGER PRIMARY KEY AUTOINCREMENT

Deci cand selectezi la OnPlayerSpawn faci:

SELECT `Key` FROM ...

Tot te mai chinui cu asta?))...

[ExTREME.]

da  ma mai chinui:))

[ExTREME.]

tot nu merge