Üdv az lenne a problémám hogy minden egyes adatot betölt a mysql kivéve a vip-t valaki tudna segíteni ebbe ? , a vip-t menti csak bejelentkezésnél nem tölti be :S
stock LoginPlayer( playerid )
{
new
iData[ 21 ],
szData[ 4 ] [ 100 ],
Float: fData[ 4 ];
format( szQuery, sizeof( szQuery ), \"SELECT `RegID`, `Money`, `Score`, `Kills`, `Deaths`, `Chatcolor`, `IDcolor`, `Bank`, `MyTitle`, `MyText`, `Saved_X`, `Saved_Y`, `Saved_Z`, `Saved_A`, `OnHours`, `OnMinutes`, `OnSeconds`, `AdminLvl`, `Warns`, `AllowGoto`, `AllowPM`, `Posts`, `Tests`,`Vip` FROM `Players` WHERE `Name` = \'%s\'\", pName( playerid ) );
mysql_query( szQuery );
mysql_store_result( );
mysql_fetch_row_format( szRow, \"|\" );
sscanf( szRow, \"p<|>ddddds[10]s[10]ds[45]s[45]ffffdddddddddddddd\",
iData[ 0 ], // RegID 1
iData[ 1 ], // Money 2
iData[ 2 ], // Score 3
iData[ 3 ], // Kills 4
iData[ 4 ], // Deaths 5
szData[ 0 ], // ChatColor 6
szData[ 1 ], // IDColor 7
iData[ 5 ], // Bank 8
szData[ 2 ], // MyTitle
szData[ 3 ], // MyText
fData[ 0 ], // Saved Pos X
fData[ 1 ], // Saved Pos Y
fData[ 2 ], // Saved Pos Z
fData[ 3 ], // Saved Pos Angle
iData[ 6 ], // Online Hours 9
iData[ 7 ], // Online Minutes 10
iData[ 8 ], // Online Seconds 11
iData[ 9 ], // Admin Level 12
iData[ 10 ], // Warns 13
iData[ 11 ], // Allow Goto 14
iData[ 12 ], // Allow PM 15
iData[ 13 ], // Posts 16
iData[ 14 ], // Tests 17
iData[ 15 ], // Skin 18
iData[ 16 ] // VIP
//iData[ 17 ] //Drog
);
mysql_free_result( );
// Player Integer Variable\'s
SetPVarInt( playerid, \"RegID\", iData[ 0 ] );
SetPVarInt( playerid, \"Cash\", iData[ 1 ] );
SetPlayerScore( playerid, iData[ 2 ] );
SetPVarInt( playerid, \"Kills\", iData[ 3 ] );
SetPVarInt( playerid, \"Deaths\", iData[ 4 ] );
SetPVarInt( playerid, \"Bank\", iData[ 5 ] );
SetPVarInt( playerid, \"OnlineHours\", iData[ 6 ] );
SetPVarInt( playerid, \"OnlineMinutes\", iData[ 7 ] );
SetPVarInt( playerid, \"OnlineSeconds\", iData[ 8 ] );
SetPVarInt( playerid, \"Level\", iData[ 9 ] );
SetPVarInt( playerid, \"Warns\", iData[ 10 ] );
SetPVarInt( playerid, \"AllowGoto\", iData[ 11 ] );
SetPVarInt( playerid, \"AllowPM\", iData[ 12 ] );
SetPVarInt( playerid, \"Posts\", iData[ 13 ] );
SetPVarInt( playerid, \"Tests\", iData[ 14 ] );
SetPVarInt( playerid, \"Skin\", iData[ 15 ] );
SetPVarInt( playerid, \"VIP\", iData[ 16 ] );
// SetPVarInt( playerid, \"Drog\", iData[ 17 ] );
// Player String Variable\'s
SetPVarString( playerid, \"ChatColor\", szData[ 0 ] );
SetPVarString( playerid, \"IDColor\", szData[ 1 ] );
SetPVarString( playerid, \"MyTitle\", szData[ 2 ] );
SetPVarString( playerid, \"MyText\", szData[ 3 ] );
// Player Float Variable\'s
SetPVarFloat( playerid, \"SavedPosX\", fData[ 0 ] );
SetPVarFloat( playerid, \"SavedPosY\", fData[ 1 ] );
SetPVarFloat( playerid, \"SavedPosZ\", fData[ 2 ] );
SetPVarFloat( playerid, \"SavedPosA\", fData[ 3 ] );
if( GetPVarInt( playerid, \"Level\" ) == 0 )
{
format( szFormat, sizeof( szFormat ), \"{ffffff}|- {ffaa00}NLP: Sikeresen bejelentkeztél! {ffffff}-|\", szRank[ GetPVarInt( playerid, \"Level\" ) ], GetPVarInt( playerid, \"Level\" ) );
SendClientMessage( playerid, COLOR_GREEN, szFormat );
}
else
{
format( szFormat, sizeof( szFormat ), \"{ffffff}|- {ffaa00}NLP: Sikeresen bejelentkeztél! Rang: %s(Szint: %d){ffffff}-|\", szRank[ GetPVarInt( playerid, \"Level\" ) ], GetPVarInt( playerid, \"Level\" ) );
SendClientMessage( playerid, COLOR_GREEN, szFormat );
}
foreach(Houses, iHouseID)
{
if( HouseInfo[ iHouseID ] [ HouseOwnerRegID ] == GetPVarInt( playerid, \"RegID\" ) )
{
SetPVarInt( playerid, \"PlayerHouse\", iHouseID );
}
}
return 1;
}