SA-MP Forums Archive
[MYSQL] Savegate - 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] Savegate (/showthread.php?tid=620042)


[MYSQL] Savegate - ThatFag - 25.10.2016

i was trying to create an gate system but now the problem is that the gates wont be saving,when i create the gate , it saves okay with the coords but when i edit it , it wont update the coords and reloading it sends back to the old coords at the status where it was created.

Gated edit and Save gates
Код:
stock SaveGate(gateid)
{
	new iQuery[750], iFormat[212];
	strcat(iQuery, "UPDATE `GateInfo` SET ");
	mysql_format(MySQLPipeline, iFormat, sizeof(iFormat), "`ID` = '%d', ", gateid); strcat(iQuery, iFormat);
	mysql_format(MySQLPipeline, iFormat, sizeof(iFormat), "`X` = '%f', ", GateInfo[gateid][gateX]); strcat(iQuery, iFormat);
	mysql_format(MySQLPipeline, iFormat, sizeof(iFormat), "`Y` = '%f', ", GateInfo[gateid][gateY]); strcat(iQuery, iFormat);
	mysql_format(MySQLPipeline, iFormat, sizeof(iFormat), "`Z` = '%f', ", GateInfo[gateid][gateZ]); strcat(iQuery, iFormat);
	mysql_format(MySQLPipeline, iFormat, sizeof(iFormat), "`rotX` = '%f', ", GateInfo[gateid][gaterotX]); strcat(iQuery, iFormat);
	mysql_format(MySQLPipeline, iFormat, sizeof(iFormat), "`rotY` = '%f', ", GateInfo[gateid][gaterotY]); strcat(iQuery, iFormat);
	mysql_format(MySQLPipeline, iFormat, sizeof(iFormat), "`rotZ` = '%f', ", GateInfo[gateid][gaterotZ]); strcat(iQuery, iFormat);
	mysql_format(MySQLPipeline, iFormat, sizeof(iFormat), "`Interior` = %d, `VirtualWorld` = %d, ", GateInfo[gateid][gateInterior], GateInfo[gateid][gateVirtualWorld]); strcat(iQuery, iFormat);
    mysql_format(MySQLPipeline, iFormat, sizeof(iFormat), "`Model` = '%f', ", GateInfo[gateid][gateModel]); strcat(iQuery, iFormat);
	mysql_tquery(MySQLPipeline, iQuery);
	return 1;
}

else if(!strcmp(tmp, "edit", true, 4))
	{
		new atmid = GetClosestGate(playerid);
		if(atmid == -1) return SendClientError(playerid, "No Gate found!");
		if(GetPlayerDistanceToPointEx(playerid, GateInfo[atmid][gateX], GateInfo[atmid][gateY], GateInfo[atmid][gateZ]) < 8)
		{
		    EditDynamicObject(playerid, GateInfo[atmid][gateObject]);
		    gateedit[playerid] = 1;
		}
		else return SendClientError(playerid, "You are not close enough to an Gate right now!");
	}
also reloading command auto saves the gate

EditDyanmicObject
Код:
if(gateedit[playerid] == 1)
		{
			new atmid = GetClosestGate(playerid);
			if(GetPlayerDistanceToPointEx(playerid, GateInfo[atmid][gateX], GateInfo[atmid][gateY], GateInfo[atmid][gateZ]) < 8)
			{
				if(GateInfo[atmid][gateObject] == objectid)
				{
					GateInfo[atmid][gateX] = x;
					GateInfo[atmid][gateY] = y;
					GateInfo[atmid][gateZ] = z;
					GateInfo[atmid][gaterotX] = rx;
					GateInfo[atmid][gaterotY] = ry;
					GateInfo[atmid][gaterotZ] = rz;
					GateInfo[atmid][oldx] = x;
					GateInfo[atmid][oldy] = y;
					GateInfo[atmid][oldz] = z;
					return 1;
				}
			}
		}


Re: [MYSQL] Savegate - Mister0 - 25.10.2016

check if you didn't create the gate with createobject and you use maybe getdynamicobjectpos or else

Re: [MYSQL] Savegate - oMa37 - 25.10.2016

PHP код:
public OnPlayerEditDynamicObject(playerid, objectid, response, Float:x, Float:y, Float:z, Float:rx, Float:ry, Float:rz)
{
    switch(response)
    {
        case EDIT_RESPONSE_UPDATE:
        {
            if(gateedit[playerid] == 1)
            {
                new atmid = GetClosestGate(playerid);
                if(GetPlayerDistanceToPointEx(playerid, GateInfo[atmid][gateX], GateInfo[atmid][gateY], GateInfo[atmid][gateZ]) < 8)
                {
                    if(GateInfo[atmid][gateObject] == objectid)
                    {
                        GateInfo[atmid][oldx] = x;
                        GateInfo[atmid][oldy] = y;
                        GateInfo[atmid][oldz] = z;
                    }
                }
            }
        }
        case EDIT_RESPONSE_FINAL:
        {
            if(gateedit[playerid] == 1)
            {
                new atmid = GetClosestGate(playerid);
                if(GetPlayerDistanceToPointEx(playerid, GateInfo[atmid][gateX], GateInfo[atmid][gateY], GateInfo[atmid][gateZ]) < 8)
                {
                    if(GateInfo[atmid][gateObject] == objectid)
                    {
                        GateInfo[atmid][gateX] = x;
                        GateInfo[atmid][gateY] = y;
                        GateInfo[atmid][gateZ] = z;
                        GateInfo[atmid][gaterotX] = rx;
                        GateInfo[atmid][gaterotY] = ry;
                        GateInfo[atmid][gaterotZ] = rz;
                    }
                }
            }
        }
    }
    return 0;
} 
or this improved one;

PHP код:
public OnPlayerEditDynamicObject(playerid, objectid, response, Float:x, Float:y, Float:z, Float:rx, Float:ry, Float:rz)
{
    if(gateedit[playerid] == 1)
    {
        new atmid = GetClosestGate(playerid);
        if(GetPlayerDistanceToPointEx(playerid, GateInfo[atmid][gateX], GateInfo[atmid][gateY], GateInfo[atmid][gateZ]) < 8)
        {
            if(GateInfo[atmid][gateObject] == objectid)
            {
                switch(response)
                {
                    case EDIT_RESPONSE_UPDATE:
                    {
                        GateInfo[atmid][oldx] = x;
                        GateInfo[atmid][oldy] = y;
                        GateInfo[atmid][oldz] = z;
                    }
                    case EDIT_RESPONSE_FINAL:
                    {
                        GateInfo[atmid][gateX] = x;
                        GateInfo[atmid][gateY] = y;
                        GateInfo[atmid][gateZ] = z;
                        GateInfo[atmid][gaterotX] = rx;
                        GateInfo[atmid][gaterotY] = ry;
                        GateInfo[atmid][gaterotZ] = rz;
                    }
                }
            }
        }
    }
    return 0;
} 


Re: [MYSQL] Savegate - ThatFag - 25.10.2016

none of them worked still same thing, when gate reloads it goes back to created coords

Re: [MYSQL] Savegate - oMa37 - 25.10.2016

Because you are not saving it correctly.

Re: [MYSQL] Savegate - ThatFag - 26.10.2016

What you mean lol , if you check what i wrote at frist post the problem was " gate not saving the position" lol