Advertisement
TheKiller

Untitled

Jul 22nd, 2011
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 2.17 KB | None | 0 0
  1. public OnPlayerCommandText(playerid, cmdtext[])
  2. {
  3.     if(!strcmp("/pos", cmdtext, true))
  4.     {
  5.         new params[50];
  6.         format(params, sizeof(params), "%s", cmdtext[5]);
  7.         new Float:X, Float:Y, Float:Z, pInt = GetPlayerInterior(playerid), pWorld = GetPlayerVirtualWorld(playerid);
  8.         GetPlayerPos(playerid, X, Y, Z);
  9.         format(Query, sizeof(Query), "SELECT * FROM `USERS` WHERE `NAME` = '%s'", ReturnPlayerName(playerid));
  10.         Result = db_query(Database, Query);
  11.         if(strmatch(params, "set"))
  12.         {
  13.             if(db_num_rows(Result))
  14.             {
  15.                 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));
  16.                 db_free_result(db_query(Database, Query));
  17.             }
  18.             else
  19.             {
  20.                 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);
  21.                 db_free_result(db_query(Database, Query));
  22.             }
  23.             gPlayerData[playerid][E_LAST_X] = X;
  24.             gPlayerData[playerid][E_LAST_Y] = Y;
  25.             gPlayerData[playerid][E_LAST_Z] = Z;
  26.             gPlayerData[playerid][E_LAST_INT] = pInt;
  27.             gPlayerData[playerid][E_LAST_VWORLD] = pWorld;
  28.             SendLPOSMessage(playerid, "Location set!");
  29.         }
  30.         else if(strmatch(params, "last"))
  31.         {
  32.             if(db_num_rows(Result) && gPlayerData[playerid][E_LAST_X] != 0 && gPlayerData[playerid][E_LAST_Y] != 0)
  33.             {
  34.                 SetPlayerPos(playerid, gPlayerData[playerid][E_LAST_X], gPlayerData[playerid][E_LAST_Y], gPlayerData[playerid][E_LAST_Z]);
  35.                 SetPlayerInterior(playerid, gPlayerData[playerid][E_LAST_INT]);
  36.                 SetPlayerVirtualWorld(playerid, gPlayerData[playerid][E_LAST_VWORLD]);
  37.             } else SendLPOSMessage(playerid, "ERROR: Nothing had been created/set!");
  38.         }
  39.         else if(strmatch(params, "toggle"))
  40.         {
  41.             if(gPlayerData[playerid][E_DISABLED] == false) gPlayerData[playerid][E_DISABLED] = true, SendLPOSMessage(playerid, "Toggled");
  42.             else gPlayerData[playerid][E_DISABLED] = false, SendLPOSMessage(playerid, "Un-Toggled");
  43.         }
  44.         else SendLPOSMessage(playerid, "USAGE: /pos [last/set/toggle]");
  45.         }
  46.         return 1;
  47.     }
  48.     return 0;
  49. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement