Vice City: Multiplayer

Server Development => Scripting and Server Management => Topic started by: ali_vcmp on Nov 20, 2014, 06:43 PM

Title: setlevel cmd not work :/
Post by: ali_vcmp on Nov 20, 2014, 06:43 PM
I Make This Setlevel cmd and i set any player level /setlevel ali 10 is doesnt Work :/ I Was Tried
else if ( cmd == "setlevel" )
{
if ( !text ) ePrivMessage( "Syntax, /c " + cmd + " <Nick/ID> <Level> ", player );
local plr = GetPlayer( GetTok( text, " ", 1 ) );
if ( !plr ) PrivMessage( "Unknown Player..", player );
else
{
   local lvl = GetTok( text, " ", 2);
   if (!IsNum(lvl)) ePrivMessage("Level Must Be In Numbers..",player);
   else
   {
   ePrivMessage(" Admin " + player.Name + " Set Level To " + plr.Name + ", Level: " + lvl + ".",player);
   QuerySQL(database,"UPDATE registration SET account_level='" + lvl + "' WHERE user='" + player.Name.tolower() + "'");
   }
}
}
Title: Re: setlevel cmd not work :/
Post by: MatheuS on Nov 20, 2014, 07:48 PM
Quote from: ali_vcmp on Nov 20, 2014, 06:43 PMI Make This Setlevel cmd and i set any player level /setlevel ali 10 is doesnt Work :/ I Was Tried
else if ( cmd == "setlevel" )
{
if ( !text ) ePrivMessage( "Syntax, /c " + cmd + " <Nick/ID> <Level> ", player );
local plr = GetPlayer( GetTok( text, " ", 1 ) );
if ( !plr ) PrivMessage( "Unknown Player..", player );
else
{
   local lvl = GetTok( text, " ", 2);
   if (!IsNum(lvl)) ePrivMessage("Level Must Be In Numbers..",player);
   else
   {
   ePrivMessage(" Admin " + player.Name + " Set Level To " + plr.Name + ", Level: " + lvl + ".",player);
   QuerySQL(database,"UPDATE registration SET account_level='" + lvl + "' WHERE user='" + player.Name.tolower() + "'");
   }
}
}

ePrivMessage // you have this function in the script?


PrivMessage( "Unknown Player..", player );  // this wrong
PrivMessage( player, "Hey you, have fun here!");  // certain function

Look here! (http://forum.vc-mp.org/?topic=113.0)
Title: Re: setlevel cmd not work :/
Post by: Sk on Nov 20, 2014, 08:09 PM
try this and let me know
else if ( cmd == "setlevel" )
{
if ( !text ) ePrivMessage( "Syntax, /c " + cmd + " <Nick/ID> <Level> ", player );
else
{
local plr = FindPlayer( GetTok( text, " ", 1 ) );
if ( !plr ) PrivMessage( "Unknown Player..", player );
else
{
local lvl = GetTok( text, " ", 2);
if (!IsNum(lvl)) ePrivMessage("Level Must Be In Numbers..",player);
else
{
ePrivMessage(" Admin " + player.Name + " Set Level To " + plr.Name + ", Level: " + lvl + ".",player);
QuerySQL(database,"UPDATE registration SET account_level='" + lvl + "' WHERE user='" + plr.Name.tolower() + "'");
}
}
}
}



Title: Re: setlevel cmd not work :/
Post by: ali_vcmp on Nov 20, 2014, 08:13 PM
Sk You're Cmd Not Work :/
Title: Re: setlevel cmd not work :/
Post by: ali_vcmp on Nov 20, 2014, 08:15 PM
Quote from: MatheuS on Nov 20, 2014, 07:48 PM
Quote from: ali_vcmp on Nov 20, 2014, 06:43 PMI Make This Setlevel cmd and i set any player level /setlevel ali 10 is doesnt Work :/ I Was Tried
else if ( cmd == "setlevel" )
{
if ( !text ) ePrivMessage( "Syntax, /c " + cmd + " <Nick/ID> <Level> ", player );
local plr = GetPlayer( GetTok( text, " ", 1 ) );
if ( !plr ) PrivMessage( "Unknown Player..", player );
else
{
   local lvl = GetTok( text, " ", 2);
   if (!IsNum(lvl)) ePrivMessage("Level Must Be In Numbers..",player);
   else
   {
   ePrivMessage(" Admin " + player.Name + " Set Level To " + plr.Name + ", Level: " + lvl + ".",player);
   QuerySQL(database,"UPDATE registration SET account_level='" + lvl + "' WHERE user='" + player.Name.tolower() + "'");
   }
}
}

ePrivMessage // you have this function in the script?


PrivMessage( "Unknown Player..", player );  // this wrong
PrivMessage( player, "Hey you, have fun here!");  // certain function

Look here! (http://forum.vc-mp.org/?topic=113.0http://)
function ePrivMessage( text, player )
{
    ClientMessage( "** pm >> " + text, player, 255, 165, 0);
}
yes i have
Title: Re: setlevel cmd not work :/
Post by: Sk on Nov 20, 2014, 08:15 PM
ok i edited the line
WHERE user='"+player.Name.tolower()+"' into WHERE user='"+plr.Name.tolower()+"'
new code
else if ( cmd == "setlevel" )
{
if ( !text ) ePrivMessage( "Syntax, /c " + cmd + " <Nick/ID> <Level> ", player );
else
{
local plr = FindPlayer( GetTok( text, " ", 1 ) );
if ( !plr ) PrivMessage( "Unknown Player..", player );
else
{
local lvl = GetTok( text, " ", 2);
if (!IsNum(lvl)) ePrivMessage("Level Must Be In Numbers..",player);
else
{
ePrivMessage(" Admin " + player.Name + " Set Level To " + plr.Name + ", Level: " + lvl + ".",player);
QuerySQL(database,"UPDATE registration SET account_level='" + lvl + "' WHERE user='" + plr.Name.tolower() + "'");
}
}
}
}
try editing and then try
and if you could show me/us some console error? i might help even further
Title: Re: setlevel cmd not work :/
Post by: ali_vcmp on Nov 20, 2014, 08:24 PM
I'II Already Try Not Work ???
Title: Re: setlevel cmd not work :/
Post by: MatheuS on Nov 20, 2014, 08:24 PM
else if ( cmd == "setlevel" )
   {
   if ( !text ) ePrivMessage( "Syntax, /c " + cmd + " <Nick/ID> <Level> ", player );
   local plr = GetPlayer( GetTok( text, " ", 1 ) );
   if ( !plr ) PrivMessage( player, "Unknown Player.." );
   else
   {
      local lvl = GetTok( text, " ", 2);
      if (!IsNum(lvl)) ePrivMessage("Level Must Be In Numbers..",player);
      else
      {
      ePrivMessage(" Admin " + player.Name + " Set Level To " + plr.Name + ", Level: " + lvl + ".",player);
      QuerySQL(database,"UPDATE registration SET account_level='" + lvl + "' WHERE user='" + player.Name.tolower() + "'");
      }
   }
   }

try.
Title: Re: setlevel cmd not work :/
Post by: ali_vcmp on Nov 20, 2014, 08:27 PM
Also Not Work ???
Title: Re: setlevel cmd not work :/
Post by: MatheuS on Nov 20, 2014, 08:28 PM
http://forum.vc-mp.org/?topic=113.0
Title: Re: setlevel cmd not work :/
Post by: ali_vcmp on Nov 20, 2014, 08:32 PM
i type /setlevel ali 10 Server Send ME admin change ali_vcmp level 10 and i type level its not change my level :/ 
Title: Re: setlevel cmd not work :/
Post by: Sk on Nov 20, 2014, 08:32 PM
Quote from: MatheuS on Nov 20, 2014, 08:28 PMhttp://forum.vc-mp.org/?topic=113.0
yup please show us what error from console.....
(yar koi tasweer ly kr error ki upload kro or humain dikhao) to eng -> (bro please upload the picture of the error and show us..)
Title: Re: setlevel cmd not work :/
Post by: MatheuS on Nov 20, 2014, 08:35 PM
Quote from: ali_vcmp on Nov 20, 2014, 08:32 PMi type /setlevel ali 10 Server Send ME admin change ali_vcmp level 10 and i type level its not change my level :/ 

So the error is here:

QuerySQL(database,"UPDATE registration SET account_level='" + lvl + "' WHERE user='" + player.Name.tolower() + "'");
Title: Re: setlevel cmd not work :/
Post by: Sk on Nov 20, 2014, 08:38 PM
can,t help without console error picture or something
Title: Re: setlevel cmd not work :/
Post by: ali_vcmp on Nov 20, 2014, 08:41 PM
http://postimg.org/gallery/hysyow4e/ See This Pictures
Title: Re: setlevel cmd not work :/
Post by: ali_vcmp on Nov 20, 2014, 08:41 PM
http://postimg.org/gallery/hysyow4e/ see this pictures
Title: Re: setlevel cmd not work :/
Post by: MacTavish on Nov 21, 2014, 10:43 AM
Ali it is WHERE account_name

But it also not work
Title: Re: setlevel cmd not work :/
Post by: ali_vcmp on Nov 21, 2014, 01:32 PM
Console Don't Show Any error
Title: Re: setlevel cmd not work :/
Post by: ali_vcmp on Nov 21, 2014, 01:35 PM
Thanks Rathore ITs Work Me Without Any Error Like Num Gettok :D
Title: Re: setlevel cmd not work :/
Post by: Sk on Nov 21, 2014, 01:41 PM
good news but next time please try the correct values cause the mistake was your own and to be on the safe side use some permissions because any one who joins the server can use this command to some one who is registered in database and set his level to what ever he wants.
Take care.