[SystemX]

Quote:

Error: [19:09:06] [ERROR] CMySQLQuery::Execute - (error #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,vw) VALUES('2','DM3','-1509.048217','755.630187','7.187500','0','0')' at line 1

I'm getting the above error when I'm trying to add a event to my databse

I'm using this code to add event map

Код:

CMD:savemap(playerid, params[])
{
	new name[100],vid,query[800],int,vw;
	if(p_state[playerid]!=C_MAP) return SendClientMessage(playerid, red,"You are not creating a map");
	if(sscanf(params,"s[129]",name)) return SendClientMessage(playerid, red, "USAGE: /savemap <Map Name>");
	format(cmap_name,sizeof(cmap_name),name);
	if(pevent_type[playerid]==TDM)
	{
	format(query,sizeof(query),"INSERT INTO `event_maps`(event_type,map_name,r_spawnx,r_spawny,r_spawnz,b_spawnx,b_spawny,b_spawnz,int,vw) VALUES('%d','%s','%f','%f','%f','%f','%f','%f','%d','%d')",pevent_type[playerid],name,set_rs[playerid][0],set_rs[playerid][1],set_rs[playerid][2],set_bs[playerid][0],set_bs[playerid][1],set_bs[playerid][2],GetPlayerInterior(playerid),GetPlayerVirtualWorld(playerid));
	}
	else if(pevent_type[playerid]==DM)
	{
	int=GetPlayerInterior(playerid);
	vw=GetPlayerVirtualWorld(playerid);
	format(query,sizeof(query),"INSERT INTO `event_maps`(event_type,map_name,r_spawnx,r_spawny,r_spawnz,int,vw) VALUES('%d','%s','%f','%f','%f','%d','%d')",pevent_type[playerid],name,set_rs[playerid][0],set_rs[playerid][1],set_rs[playerid][2],int,vw);
	}
	mysql_query(mysql,query);
	SendClientMessage(playerid, lblue,"You have created an event map");
	return 1;
}

I started getting this error, Since I added two more values to query and that is int and vw.

If I remove both of them from query then it works perfectly, but When I add them then I get error.

Structures of my table:

[iKarim]

Not sure but try this:

PHP код:

CMD:savemap(playerid, params[])
{
    new name[100]
    if(p_state[playerid]!=C_MAP) return SendClientMessage(playerid, red,"You are not creating a map");
    if(sscanf(params,"s[100]",name)) return SendClientMessage(playerid, red, "USAGE: /savemap <Map Name>");
    new vid,query[800],int,vw;
    format(cmap_name,sizeof(cmap_name),name);
    if(pevent_type[playerid]==TDM)
    {
        format(query,sizeof(query),"INSERT INTO `event_maps`(event_type,map_name,r_spawnx,r_spawny,r_spawnz,b_spawnx,b_spawny,b_spawnz,int,vw) VALUES(%d,'%s',%f,%f,%f,%f,%f,%f,%d,%d);",pevent_type[playerid],name,set_rs[playerid][0],set_rs[playerid][1],set_rs[playerid][2],set_bs[playerid][0],set_bs[playerid][1],set_bs[playerid][2],GetPlayerInterior(playerid),GetPlayerVirtualWorld(playerid));
    }
    else if(pevent_type[playerid]==DM)
    {
        int=GetPlayerInterior(playerid);
        vw=GetPlayerVirtualWorld(playerid);
        format(query,sizeof(query),"INSERT INTO `event_maps`(event_type,map_name,r_spawnx,r_spawny,r_spawnz,int,vw) VALUES(%d,'%s',%f,%f,%f,%d,%d);",pevent_type[playerid],name,set_rs[playerid][0],set_rs[playerid][1],set_rs[playerid][2],int,vw);
    }
    mysql_query(mysql,query);
    SendClientMessage(playerid, lblue,"You have created an event map");
    return 1;
} 


[JeaSon]

PHP код:

CMD:savemap(playerid, params[])
{
    new name[100],vid,query[800];
    new int = GetPlayerInterior(playerid);
    new vm = GetPlayerVirtualWorld(playerid);
    if(p_state[playerid]!=C_MAP) return SendClientMessage(playerid, red,"You are not creating a map");
    if(sscanf(params,"s[129]",name)) return SendClientMessage(playerid, red, "USAGE: /savemap <Map Name>");
    format(cmap_name,sizeof(cmap_name),name);
    if(pevent_type[playerid]==TDM)
    {
        format(query,sizeof(query),"INSERT INTO `event_maps`(event_type,map_name,r_spawnx,r_spawny,r_spawnz,b_spawnx,b_spawny,b_spawnz,int,vw) VALUES('%d','%s','%f','%f','%f','%f','%f','%f','%d','%d')",pevent_type[playerid],name,set_rs[playerid][0],set_rs[playerid][1],set_rs[playerid][2],set_bs[playerid][0],set_bs[playerid][1],set_bs[playerid][2],GetPlayerInterior(playerid),GetPlayerVirtualWorld(playerid));
    }
    else if(pevent_type[playerid]==DM)
    {
        format(query,sizeof(query),"INSERT INTO `event_maps`(event_type,map_name,r_spawnx,r_spawny,r_spawnz,int,vw) VALUES('%d','%s','%f','%f','%f','%d','%d')",pevent_type[playerid],name,set_rs[playerid][0],set_rs[playerid][1],set_rs[playerid][2],int,vw);
    }
    mysql_query(mysql,query);
    SendClientMessage(playerid, lblue,"You have created an event map");
    return 1;
} 


[AbyssMorgan]

'int' is not allowed as the name of the SQL

Change to 'pint'

[SystemX]

Quote:

Originally Posted by AbyssMorgan 'int' is not allowed as the name of the SQL Change to 'pint'

Thank you @AbyssMorgan, Now its working!