Spawnloc System

[umar4911]

I made a spawnloc system. My friend also wanted it so I thought to post it.

add this onScriptLoad()
[spoiler]

Code Select Expand

tele <- ConnectSQL( "databases/teleport.db" );
QuerySQL( tele, "CREATE TABLE IF NOT EXISTS spawn ( Autospawn TEXT, xaxis VARCHAR(25), yaxis VARCHAR(25), zaxis VARCHAR(25), Name VARCHAR(32) )" );

[/spoiler]



function onPlayerCommand(player, command, arguments)
[spoiler]

Code Select Expand

if(cmd == "setspawnloc")
 {
  local q = QuerySQL(tele, "SELECT * FROM spawn WHERE Name = '" + player.Name + "'");
  if(!q)
  {
   QuerySQL(tele, "INSERT INTO spawn ( Autospawn, xaxis, yaxis, zaxis, Name ) VALUES ( 'true' , '" + player.Pos.x + "' , '" + player.Pos.y + "' , '" + player.Pos.z + "', '" + player.Name + "' ) ");
  }
  else
  {
   QuerySQL(tele, "UPDATE spawn SET xaxis = '" + player.Pos.x + "' WHERE Name = '" + player.Name + "'");
   QuerySQL(tele, "UPDATE spawn SET yaxis = '" + player.Pos.y + "' WHERE Name = '" + player.Name + "'");
   QuerySQL(tele, "UPDATE spawn SET zaxis = '" + player.Pos.z + "' WHERE Name = '" + player.Name + "'");
   QuerySQL(tele, "UPDATE spawn SET Autospawn = 'true' WHERE Name = '" + player.Name + "'");
   MessagePlayer("Your spawnloc is updated and set to true. To disable it, use /spawnloc false", player);

  }
 }
 
 else if(cmd == "spawnloc")
 {
  if(!arguments) MessagePlayer("Error Unknown Syntax. Use /" + cmd + " <true/false>", player);
  local q = QuerySQL(tele, "SELECT * FROM spawn WHERE Name = '" + player.Name + "'");
  if(!q)
  {
   MessagePlayer("You didnot set any spawn location. Use /setspawnloc to set spawn location.", player);
  }
  else
  {
   if(arguments == "true")
   {
    QuerySQL(tele, "UPDATE spawn SET Autospawn = 'true' WHERE Name = '" + player.Name + "'");
   }
   if(arguments == "false")
   {
    QuerySQL(tele, "UPDATE spawn SET Autospawn = 'false' WHERE Name = '" + player.Name + "'");
   }
   // if(!arguments == "true", "false")
   else {
    MessagePlayer("Error Unknown Syntax. Use /" + cmd + " <true/false>", player);
   }
  }
 }
  [/spoiler]



function onPlayerSpawn(player)
[spoiler]

Code Select Expand

function onPlayerSpawn(player)
{
local q = QuerySQL(tele, "SELECT * FROM spawn WHERE Name = '" + player.Name + "'");
if( q && GetSQLColumnData(q, 0) == "true" )
{
local
xspawn = GetSQLColumnData(q, 1).tointeger(),
yspawn = GetSQLColumnData(q, 2).tointeger(),
zspawn = GetSQLColumnData(q, 3).tointeger();

player.Pos = Vector(xspawn, yspawn, zspawn);
MessagePlayer("You are Spawned at your saved location", player);
}
else
MessagePlayer("You are spawned", player);
}
[/spoiler]

[Mahmoud Tornado]

K Nice

[Cool]

LOL

[.]

Code Select Expand

tele <- ConnectSQL( "databases/teleport.db" );
QuerySQL( tele, ...
Why am I seeing plural? Please tell me you can make the difference between tables and databases.

[umar4911]

Code Select Expand

tele <- ConnectSQL( "databases/teleport.db" );
QuerySQL( tele, ...
Why am I seeing plural? Please tell me you can make the difference between tables and databases.

I didnot understand the question

[!]

tele <- ConnectSQL( "databases/teleport.db" );
QuerySQL( tele, ...

Why am I seeing plural? Please tell me you can make the difference between tables and databases.

I didnot understand the question

[umar4911]

tele <- ConnectSQL( "databases/teleport.db" );
QuerySQL( tele, ...

Why am I seeing plural? Please tell me you can make the difference between tables and databases.

I didnot understand the question

I just made a folder as it has more than 1 database