===== Some Errors ====== - Printable Version

===== Some Errors ====== - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: ===== Some Errors ====== (/showthread.php?tid=374258)

===== Some Errors ====== - xSkullx - 02.09.2012

pawn Код:

(516) : error 012: invalid function call, not a valid address
(516) : warning 215: expression has no effect
(516) : error 001: expected token: ";", but found ")"
(516) : error 029: invalid expression, assumed zero
(516) : fatal error 107: too many error messages on one line

And The Line:

pawn Код:

format( Query, sizeof( Query ), "SELECT * FROM `Vips` WHERE `Nume` = '%s'", PlayerName( playerid ) );

Re: ===== Some Errors ====== - Your:RP - 02.09.2012

pawn Код:

format( Query, sizeof( Query ), "SELECT * FROM `Vips` WHERE `Nume` = '%s'", PlayerName( playerid ) ;

This might help, not sure though, give me more of the surrounding code so i can test it

Re: ===== Some Errors ====== - xSkullx - 02.09.2012

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 );
    }

Re: ===== Some Errors ====== - Your:RP - 02.09.2012

Normally there's no spaces between [Vip] etc... witch makes it look really weird to me.

Re: ===== Some Errors ====== - xSkullx - 02.09.2012

Without spaces:

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);
        }
        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);
        }
        db_free_result(Result);
    }

Re: ===== Some Errors ====== - TaLhA XIV - 02.09.2012

PHP код:



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 );

    }

never worked with these type of codes so tell if worked.

Re: ===== Some Errors ====== - xSkullx - 02.09.2012

Same errors..

Re: ===== Some Errors ====== - RanSEE - 02.09.2012

Try this,

pawn Код:

public OnPlayerConnect( playerid )
{
    if(P_DATA[playerid][Vip] >= 1){
    new
    Query[ 256 ],
    string[ 128 ],
    DBResult:Result,
    Field[ 30 ],
    pname[MAX_PLAYER_NAME];

    GetPlayerName(playerid, pname, sizeof(pname));
    format(string,sizeof(string),"Welcome %s (%i).Your Courent Level: %s",pname,playerid,P_DATA[playerid][Vip]);
    SendClientMessage(playerid,ANY COLOUR,string);
    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}Tvoj VIP Level :\n\n{FF5500}Postali ste VIP level {00FF00}%d\n\n{E60000}Cestitamo!", 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}Ovaj korisnik ima VIP Level 0", "Quit", "" );
    #endif
    }
    db_free_result( Result );
    }
    return 1;
}

Not tested.

Re: ===== Some Errors ====== - mamorunl - 02.09.2012

Can you show the PlayerName() function?