Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public OnPlayerCommandText(playerid, cmdtext[])
- {
- if(!strcmp("/pos", cmdtext, true))
- {
- new params[50];
- format(params, sizeof(params), "%s", cmdtext[5]);
- new Float:X, Float:Y, Float:Z, pInt = GetPlayerInterior(playerid), pWorld = GetPlayerVirtualWorld(playerid);
- GetPlayerPos(playerid, X, Y, Z);
- format(Query, sizeof(Query), "SELECT * FROM `USERS` WHERE `NAME` = '%s'", ReturnPlayerName(playerid));
- Result = db_query(Database, Query);
- if(strmatch(params, "set"))
- {
- if(db_num_rows(Result))
- {
- format(Query, sizeof(Query), "UPDATE `USERS` SET X = '%f', Y = '%f', Z = '%f', INT = '%d', VWORLD = '%d' WHERE `NAME` = '%s'", X, Y, Z, pInt, pWorld, ReturnPlayerName(playerid));
- db_free_result(db_query(Database, Query));
- }
- else
- {
- format(Query, sizeof(Query), "INSERT INTO `USERS` (`NAME`, `X`, `Y`, `Z`, `INT`, `VWORLD`) VALUES('%s','%f','%f','%f','%d','%d')", ReturnPlayerName(playerid), X, Y, Z, pInt, pWorld);
- db_free_result(db_query(Database, Query));
- }
- gPlayerData[playerid][E_LAST_X] = X;
- gPlayerData[playerid][E_LAST_Y] = Y;
- gPlayerData[playerid][E_LAST_Z] = Z;
- gPlayerData[playerid][E_LAST_INT] = pInt;
- gPlayerData[playerid][E_LAST_VWORLD] = pWorld;
- SendLPOSMessage(playerid, "Location set!");
- }
- else if(strmatch(params, "last"))
- {
- if(db_num_rows(Result) && gPlayerData[playerid][E_LAST_X] != 0 && gPlayerData[playerid][E_LAST_Y] != 0)
- {
- SetPlayerPos(playerid, gPlayerData[playerid][E_LAST_X], gPlayerData[playerid][E_LAST_Y], gPlayerData[playerid][E_LAST_Z]);
- SetPlayerInterior(playerid, gPlayerData[playerid][E_LAST_INT]);
- SetPlayerVirtualWorld(playerid, gPlayerData[playerid][E_LAST_VWORLD]);
- } else SendLPOSMessage(playerid, "ERROR: Nothing had been created/set!");
- }
- else if(strmatch(params, "toggle"))
- {
- if(gPlayerData[playerid][E_DISABLED] == false) gPlayerData[playerid][E_DISABLED] = true, SendLPOSMessage(playerid, "Toggled");
- else gPlayerData[playerid][E_DISABLED] = false, SendLPOSMessage(playerid, "Un-Toggled");
- }
- else SendLPOSMessage(playerid, "USAGE: /pos [last/set/toggle]");
- }
- return 1;
- }
- return 0;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement