17.11.2013, 10:46
(
Последний раз редактировалось Voxel; 07.12.2013 в 16:46.
)
Simple SQLite Commands/Features
By Voxel
Info:
Hello fella's,
So in my previous topic i posted a SQL base starting script and you can view it here:
https://sampforum.blast.hk/showthread.php?tid=476204
I decided to make a tutorial to explain how to make simple SQL commands such as /givemoney or /setscore, /setkills etc. This can be very helpfull to administrate your server.
Lets get started shall we?
Tutorial:
First things first, i reccomend you use my filterscript to follow this tutorial, or if you can convert it to your variables then thats fine aswell.
1. A cash test command
First we will make a command that tests if your money saving is working properly.
(note that i am using ZCMD)
2. /setkills command
Second we will make a command that will change the kills value in your database.
3. /setdeaths command
This is basicly the same as /setkills only we change the database info from USER_KILLS to USER_DEATHS and we change the command params to /setdeaths [playerid] [deaths]
4. /setscore command
As fourth we make a /setscore command to set the players score to the desired value, again you use the same functions as you do with kills and deaths
5. /givemoney command
Now we will make a /givemoney command to give the player money on top of his already set value with a limit so it cannot be abused
6. /setadmin command
And finally we will need to set a players admin rank!
I hope you guys understand this and good luck with your SQLite database!
By Voxel
Info:
Hello fella's,
So in my previous topic i posted a SQL base starting script and you can view it here:
https://sampforum.blast.hk/showthread.php?tid=476204
I decided to make a tutorial to explain how to make simple SQL commands such as /givemoney or /setscore, /setkills etc. This can be very helpfull to administrate your server.
Lets get started shall we?
Tutorial:
First things first, i reccomend you use my filterscript to follow this tutorial, or if you can convert it to your variables then thats fine aswell.
1. A cash test command
First we will make a command that tests if your money saving is working properly.
(note that i am using ZCMD)
pawn Код:
CMD:cashtest(playerid, params[]) //the command
{
User[playerid][USER_MONEY] += 1000000;
//User can also be pInfo and USER_MONEY can be pMoney (depends on what you set)
GivePlayerMoney(playerid, 1000000);
//gives the player the in-game money wich is then stored in the database (at USER_MONEY)
return 1;
}
Second we will make a command that will change the kills value in your database.
pawn Код:
CMD:setkills(playerid, params[])
{
if(User[playerid][USER_ADMIN] >= 5)
//we check if the user is admin level 5 or higher
{
new targetid ,amount;
if(sscanf(params, "ud", targetid, amount)) return SendClientMessage(playerid, COL_WHITE, "/setkills [playerid] [kills]");
if(!IsPlayerConnected(targetid)) return SendClientMessage(playerid, COL_WHITE, "Player is not online");
User[playerid][USER_KILLS] = amount;
//gets the variable amount and sets it to the entered value, so /setkills [id] [value = amount]
}
else
{
SendClientMessage(playerid, COL_RED, "You are not a administrator!");
}
return 1;
}
This is basicly the same as /setkills only we change the database info from USER_KILLS to USER_DEATHS and we change the command params to /setdeaths [playerid] [deaths]
pawn Код:
CMD:setdeaths(playerid, params[])
{
if(User[playerid][USER_ADMIN] >= 5)
//we check if the user is admin level 5 or higher
{
new targetid ,amount;
if(sscanf(params, "ud", targetid, amount)) return SendClientMessage(playerid, COL_WHITE, "/setdeaths [playerid] [deaths]");
if(!IsPlayerConnected(targetid)) return SendClientMessage(playerid, COL_WHITE, "Player is not online");
User[playerid][USER_DEATHS] = amount;
//gets the variable amount and sets it to the entered value, so /setdeaths [id] [value = amount]
}
else
{
SendClientMessage(playerid, COL_RED, "You are not a administrator!");
}
return 1;
}
As fourth we make a /setscore command to set the players score to the desired value, again you use the same functions as you do with kills and deaths
pawn Код:
CMD:setscore(playerid, params[])
{
if(User[playerid][USER_ADMIN] >= 5)
//we check if the user is admin level 5 or higher
{
new targetid ,amount;
if(sscanf(params, "ud", targetid, amount)) return SendClientMessage(playerid, COL_WHITE, "/setscore [playerid] [score]");
if(!IsPlayerConnected(targetid)) return SendClientMessage(playerid, COL_WHITE, "Player is not online");
User[playerid][USER_SCORE] = amount;
//gets the variable amount and sets it to the entered value, so /setscore [id] [value = amount]
}
else
{
SendClientMessage(playerid, COL_RED, "You are not a administrator!");
}
return 1;
}
Now we will make a /givemoney command to give the player money on top of his already set value with a limit so it cannot be abused
pawn Код:
CMD:givemoney(playerid, params[])
{
if(User[playerid][USER_ADMIN] >= 5)
//we check if the user is admin level 5 or higher
{
new targetid, amount;
if(sscanf(params, "ud", targetid, amount)) return SendClientMessage(playerid, COL_WHITE, "/givemoney [playerid] [money]");
if(!IsPlayerConnected(targetid)) return SendClientMessage(playerid, COL_WHITE, "Player is not online");
if(amount < 0 || amount > 30000) return SendClientMessage(playerid, COL_WHITE, "You can only give a maximum amount of $30 000");
//here we check if the user types a amount between 0 and 30000, if he exceeds this value he will recieve a message that he can only give a maximum of 300000
User[playerid][USER_MONEY] += amount;
//here we get the value of the givin amount again but this time we put: plus and equal
GivePlayerMoney(playerid, amount);
//and finally we give the player the amount (value) that we put in our params of the command!
}
else
{
SendClientMessage(playerid, COL_RED, "You are not a administrator!");
}
return 1;
}
And finally we will need to set a players admin rank!
pawn Код:
CMD:setadmin(playerid,params[])
{
if(User[playerid][USER_ADMIN] >= 6 || IsPlayerAdmin(playerid))
//we check if he has the maximum admin rank or if he is a rcon admin
{
new targetid, level;
if(sscanf(params, "ud", targetid, level)) return SendClientMessage(playerid, COL_WHITE,"/setadmin [playerid] [level]");
if(!IsPlayerConnected(targetid)) return SendClientMessage(playerid, COL_WHITE, "Player is not online");
if(level < 0 || level > 6) return SendClientMessage(playerid, COL_WHITE, "You can only set admin levels from 1 to 6!");
//we check if he enters a value between 0 and 6 otherwise he will get a error saying only admin levels between 1 and 6.
User[targetid][USER_ADMIN] = level;
//we set the variable level to the value we gave in the params and it saves it in the database
}
else
{
SendClientMessage(playerid, COL_RED, "You are not a administrator!");
}
return 1;
}
