Problem(error/warning): Kad pokrenem mod i ucem u samp ne izbacuje mi dialog, evo imate dole mysql_log
Deo skripte: [pawn]protected CheckPlayerAccount( playerid )
{
new rows, fields;
cache_get_data( rows, fields, mSQL );
if( !rows )
{
if( !IsValidRoleplayName( ImeIgraca( playerid ) ) )
{
SendClientMessage( playerid, CRVENA, "#NON-RP NICKNAME: {FFFFFF}Dobili ste kick zbog krivo formatiranog imena." );
SendClientMessage( playerid, CRVENA, "#NON-RP NICKNAME: {FFFFFF}Vase ime mora biti u formatu {FA5555}'Ime_Prezime'." );
defer KickIgraca(playerid);
return 1;
}
if( ServerInfo[ Registracija ] == false )
{
SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}REGISTRACIJA JE TRENUTNO ONEMOGUCENA." );
SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}JV - ADMIN TEAM." );
defer KickIgraca(playerid);
return 1;
}
Register(playerid);
}
else
{
cache_get_field_content( 0, "password", PlayerInfo[ playerid ][ xLozinka ], mSQL, 150 );
PlayerInfo[ playerid ][ xRegistrovan ] = cache_get_field_content_int( 0, "registered" );
PlayerInfo[ playerid ][ xID ] = cache_get_field_content_int( 0, "user_id" );
PlayerInfo[ playerid ][ xLevel ] = cache_get_field_content_int( 0, "level" );
PlayerInfo[ playerid ][ xRespekt ] = cache_get_field_content_int( 0, "exp" );
PlayerInfo[ playerid ][ xOnlineSati ] = cache_get_field_content_int( 0, "xOnlineSati" );
PlayerInfo[ playerid ][ xDrzava ] = cache_get_field_content_int( 0, "country" );
PlayerInfo[ playerid ][ xNovac ] = cache_get_field_content_int( 0, "money" );
PlayerInfo[ playerid ][ xBRacun ] = cache_get_field_content_int( 0, "xBRacun" );
PlayerInfo[ playerid ][ xPosao ] = cache_get_field_content_int( 0, "job_id" );
PlayerInfo[ playerid ][ xUgovor ] = cache_get_field_content_int( 0, "contract" );
PlayerInfo[ playerid ][ xSkin ] = cache_get_field_content_int( 0, "skin_id" );
PlayerInfo[ playerid ][ xWarn ] = cache_get_field_content_int( 0, "warn" );
PlayerInfo[ playerid ][ xAdmin ] = cache_get_field_content_int( 0, "admin_lvl" );
PlayerInfo[ playerid ][ xHelper ] = cache_get_field_content_int( 0, "helper_level" );
PlayerInfo[ playerid ][ xTestAdmin ] = cache_get_field_content_int( 0, "xTestAdmin" );
PlayerInfo[ playerid ][ xVIPLevel ] = cache_get_field_content_int( 0, "vip_level" );
PlayerInfo[ playerid ][ xVPoen ] = cache_get_field_content_int( 0, "v_poen" );
PlayerInfo[ playerid ][ xVCoin ] = cache_get_field_content_int( 0, "xVCoin" );
PlayerInfo[ playerid ][ xTogStats ] = bool:cache_get_field_content_int( 0, "xTogStats" );
if( PlayerInfo[ playerid ][ xRegistrovan ] == 1 )
{
new query[128];
mysql_format( mSQL, query, sizeof(query), "SELECT * FROM `banned` WHERE `user_id` = '%d' LIMIT 1", PlayerInfo[ playerid ][ xID ] );
mysql_pquery( mSQL, query, "CheckPlayerBan", "i", playerid );
}
else
{
if( ServerInfo[ Registracija ] == false )
{
SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}REGISTRACIJA JE TRENUTNO ONEMOGUCENA." );
SendClientMessage( playerid, CRVENA, "#REGISTER: {FFFFFF}JV - ADMIN TEAM." );
defer KickIgraca(playerid);
return 1;
}
Register(playerid);
}
}
return(true);
}[/pawn]
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (error #1054) Unknown column 'xTogStats' in 'field list' (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats` FROM `users` WHERE `p_name` = 'Amil_Vetar' LIMIT 1")
Nedostaje ti u tabeli xTogStats colum samo ti kaze unkown columm
1. u tabeli nedostaje kolona
2. Ako naziv kolone u TABELI CREATE i UPDATE nisu isti. U slučajevima, oni mogu izgledati isto, ali možda postoje znakovi koji se ne mogu isprintati ili imaju Unicode znakove koji izgledaju isto, ali zapravo su različite kodne tačke.
Hvala svima rjesio sam