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


createbar? - Tanush123 - 07.01.2012

Ok i was changing up createbar then when i create in game and look at my DB, it doesnt INSERT anything
pawn Код:
CMD:createbar(playerid,params[])
    {
        if(PlayerData[playerid][AdminLevel] < 4) return 0;
        new barid = GetBarid();
        new bint = GetPlayerInterior(playerid);
        new bworld = GetPlayerVirtualWorld(playerid);
        if(barid == 0) return SCM(playerid,red,"ERROR: You have reached the maximum ID");
        GetPlayerPos(playerid,X,Y,Z);
        format(str,sizeof(str),"INSERT INTO Bars (ID,PosX,PosY,PosZ,Int,World) VALUES ('%d','%f','%f','%f','%i','%i')",GetBarid(),X,Y,Z,bint,bworld);
        mysql_query(str);
        UnloadBar();
        SetTimerEx("ReloadBar",5000,0,"i",playerid);
        format(str,sizeof(str),"You have created Bar ID: %d, all bars will load in 5 seconds",barid);
        SCM(playerid,orange,str);
        return 1;
    }


Re: createbar? - Tanush123 - 08.01.2012

bump

Re: createbar? - Jochemd - 08.01.2012

Did you enable mysql_debug? Look in the Debug.txt what error it gave (assuming you're using MySQL plugin from BlueG).

Re: createbar? - Tanush123 - 08.01.2012

Код:
[17:22:56] CMySQLHandler::Query(INSERT INTO Bars (ID,PosX,PosY,PosZ,Int,World) VALUES ('1','0.000000','0.000000','0.000000','0','0')) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Int,World) VALUES ('1','0.000000','0.000000','0.000000','0','0')' at line 1)
Fixed.