SA-MP Forums Archive
Bays Script - 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: Bays Script (/showthread.php?tid=608704)


Bays Script - Zevcore - 04.06.2016

I have no idea why it does not work, everything wczutuje, but it does not show.

PHP код:
enum E_BAYS
{
    bUID,
    bName[32],
    bCargo[32],
    Float:bPosX,
    Float:bPosY,
    Float:bPosZ
}
new BayCache[E_BAYS][MAX_PLAYERS];
stock Bays_Init(playerid)
{
    new data[528];
    
    mysql_query( "SELECT * FROM `bays`");
    
    mysql_store_result();
    new ret = mysql_num_rows();
    for(new i = 0; i < ret; i++)
    {
        if(mysql_fetch_row(data, "|"))
        {
            sscanf(data, "p<|>ds[32]s[32]fff",
                BayCache[bUID][playerid],
                BayCache[bName][playerid],
                BayCache[bCargo][playerid],
                BayCache[bPosX][playerid],
                BayCache[bPosY][playerid],
                BayCache[bPosZ][playerid]
            );
            
            SetPlayerMapIcon(playerid, 0, BayCache[bPosX][playerid], BayCache[bPosY][playerid], BayCache[bPosZ][playerid], 51, -1);
            Create3DTextLabel("Custom Text", -1, BayCache[bPosX][playerid], BayCache[bPosY][playerid], BayCache[bPosZ][playerid],100.0, 1, 0);
    
        }
    }
    mysql_free_result();
    return 1;
}
stock Create_Bay(playerid)
{
    new
        Float:Pos[3],
        query[328],
        name[36],
        cargo[36];
        
    format(name, sizeof name, "Miasto");
    format(cargo, sizeof cargo, "Cargo");
        
    GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]);
    format(query, sizeof query, "INSERT INTO `bays` (`name`, `cargo`, `posX`, `posY`, `posZ`) VALUES ('%s', '%s', '%2.f', '%2.f', '%2.f')", name, cargo, Pos[0], Pos[1], Pos[2]);
    
    mysql_query(query);
    
    return 1;
}
CMD:creb(playerid)
{
    Create_Bay(playerid);
    SendClientMessage(playerid, -1, "Dok stworzony!");
    return 1;
}
CMD:refb(playerid)
{
    Bays_Init(playerid);
    SendClientMessage(playerid, -1, "Doki odświeżone!");
    
    return 1;
} 


Re: Bays Script - justjamie - 04.06.2016

from
PHP код:
mysql_query( "SELECT * FROM `bays`"); 
to
PHP код:
format(query,sizeof(query),"SELECT * FROM `bays`");
mysql_query(query);