02.09.2012, 11:09
That's the all code:
pawn Код:
new
Query[ 256 ],
DBResult:Result,
Field[ 30 ]
;
format( Query, sizeof( Query ), "SELECT * FROM `Vips` WHERE `Nume` = '%s'", PlayerName( playerid ) ;
Result = db_query( Database, Query );
if ( Result )
{
if ( db_num_rows( Result ) )
{
db_get_field_assoc( Result, "VipLevel", Field, 4 ); P_DATA[ playerid ][ Vip ] = strval( Field );
db_get_field_assoc( Result, "VSkin", Field, 4 ); P_DATA[ playerid ][ p_FavSkin ] = strval( Field );
#if defined SHOW_LEVEL_DIALOG
format( string, sizeof( string ), "\t{FF5500}Your V.I.P Level:\n\n{FF5500}You have V.I.P level {00FF00}%d\n\n{E60000}Congratulations!", P_DATA[ playerid ][ Vip ] );
ShowPlayerDialog( playerid, ONCONN, DIALOG_STYLE_MSGBOX, "{00FF00}V.I.P", string, "Quit", "" );
#endif
}
else
{
P_DATA[ playerid ][ Vip ] = 0;
P_DATA[ playerid ][ p_FavSkin ] = -1;
format( Query, sizeof Query, "INSERT INTO `Vips` VALUES(NULL,'%s','0','-1')", PlayerName( playerid ) );
db_query( Database, Query );
#if defined SHOW_LEVEL_DIALOG
ShowPlayerDialog( playerid, ONCONN+1, DIALOG_STYLE_MSGBOX, "{00FF00}V.I.P", "{E60000}This username have V.I.P level 0", "Quit", "" );
#endif
}
db_free_result( Result );
}