Mysql problem - Printable Version

Mysql problem - 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: Mysql problem (/showthread.php?tid=307540)

Mysql problem - Tanush123 - 30.12.2011

pawn Код:

CMD:oskin(playerid,params[])
{
    new oskin1,oskin2;
    if(PlayerInfo[playerid][Member] == -255) return 0;
    CheckMySQL();
    format(str, sizeof(str), "SELECT * FROM orgs WHERE Orgid = '%d'",orgid);
    mysql_query(str);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        mysql_fetch_field_row(str,"Skin1"); oskin1 = strval(str);
        mysql_fetch_field_row(str,"Skin2"); oskin2 = strval(str);
        if(GetPlayerSkin(playerid) == oskin1)
        {
            SetPlayerSkin(playerid,oskin2);
        }
        else if(GetPlayerSkin(playerid) == oskin2)
        {
            SetPlayerSkin(playerid,oskin1);
        }
    }
    mysql_free_result();
    return 1;
}

Well nothing happens when i does /oskin? im noob in mysql still so can you guys help

Re: Mysql problem - FireCat - 30.12.2011

Not very efficient cuz it's late and Im tired...

pawn Код:

CMD:oskin(playerid,params[])
{
    new oskin1,oskin2;
    if(PlayerInfo[playerid][Member] == -255) return 0;
    CheckMySQL();
    format(str, sizeof(str), "SELECT Skin1 FROM orgs WHERE Orgid = '%d'",orgid);
    mysql_query(str);
    mysql_store_result();
    oskin1 = mysql_fetch_int(str);

    mysql_free_result();    
    format(str, sizeof(str), "SELECT Skin2 FROM orgs WHERE Orgid = '%d'",orgid);
        mysql_query(str);
        mysql_store_result();   
        oskin2 = mysql_fetch_int(str);
        if(GetPlayerSkin(playerid) == oskin1)
        {
            SetPlayerSkin(playerid,oskin2);
        }
        else if(GetPlayerSkin(playerid) == oskin2)
        {
            SetPlayerSkin(playerid,oskin1);
        }
    }
    mysql_free_result();
    return 1;
}

Re: Mysql problem - Tanush123 - 01.01.2012

pawn Код:

D:\Users\Tanush\Desktop\SA-MP SERVERS\SA-MP Server Stunt\gamemodes\server.pwn(4382) : error 035: argument type mismatch (argument 1)
D:\Users\Tanush\Desktop\SA-MP SERVERS\SA-MP Server Stunt\gamemodes\server.pwn(4387) : error 035: argument type mismatch (argument 1)

pawn Код:

first error: oskin1 = mysql_fetch_int(str);
    second error: oskin2 = mysql_fetch_int(str);

Re: Mysql problem - THE_KNOWN - 01.01.2012

pawn Код:

CMD:oskin(playerid,params[])
{
    new oskin1,oskin2;
    if(PlayerInfo[playerid][Member] == -255) return 0;
    CheckMySQL();
    format(str, sizeof(str), "SELECT Skin1 FROM orgs WHERE Orgid = %d",orgid);
    mysql_query(str);
    mysql_store_result();
    oskin1 = mysql_fetch_int();
    mysql_free_result();
    format(str, sizeof(str), "SELECT Skin2 FROM orgs WHERE Orgid = %d",orgid);
    mysql_query(str);
    mysql_store_result();
    oskin2 = mysql_fetch_int();
    if(GetPlayerSkin(playerid) == oskin1)
    {
        SetPlayerSkin(playerid,oskin2);
    }
    else if(GetPlayerSkin(playerid) == oskin2 || GetPlayerSkin(playerid) != oskin1)
    {
        SetPlayerSkin(playerid,oskin1);
    }
    }
    mysql_free_result();
    return 1;
}

Re: Mysql problem - Tanush123 - 01.01.2012

thanks