Advertisement
Guest User

Update1

a guest
Aug 23rd, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.68 KB | None | 0 0
  1. event onLoad(){
  2. database.execute(
  3. "CREATE TABLE IF NOT EXIST `playerinfo` (
  4. `steamid` VARCHAR(17) NOT NULL,
  5. `name` VARCHAR(255) NOT NULL,
  6. `description` VARCHAR(255) NOT NULL,
  7. `age` INT(11) NOT NULL,
  8. PRIMARY KEY (`steamid`));"
  9. );
  10.  
  11. }
  12.  
  13. playerInfoFormat = "INSERT INTO playerinfo (PlayerName, Description, Age, steamid) VALUES ('{0}', '{1}', '{2}', '{3}');";
  14. command createinfo(arg, description, age){
  15. permission = "adminci";
  16. execute() {
  17. if(arguments.count !=3){
  18. player.message("Badly placed command: /createinfo <player> <description> <age>", "red");
  19. return;
  20. }
  21. argPlayer = toPlayer(arg);
  22. if(isPlayer(argPlayer) == false){
  23. player.message("Player not found", "red");
  24. return;
  25. }
  26. database.execute(str.format(playerInfoFormat, argPlayer.name, dt.now.string));
  27. player.message("You have registered " + argPlayer.name + " whit this data " + description + " , " + age + "green");
  28.  
  29. argPlayer.message("You are now a citizen thanks to " + player.name + " whit this data " + description + " , " + age + "green");
  30.  
  31. }
  32. }
  33.  
  34.  
  35. playerInfoF = "SELECT FROM playerinfo (PlayerName, Description, Age, SteamId) VALUES ('{0}', '{1}', '{2}', '{3}');";
  36. command info(startPlayer) {
  37. permission = "infocity";
  38. execute(){
  39. argPlayer = toPlayer(startPlayer);
  40. if(isPlayer(argPlayer) == false){
  41. player.message("Player not found", "red");
  42. return;
  43. }
  44. if(arguments.count !=0) {
  45. player.message("Badly placed command: /info <player>>", "red");
  46. return;
  47. }
  48. database.execute(str.format(playerInfoF, argPlayer, dt.now.string));
  49. player.message("The citizen has been registered with this data " + argPlayer + ", " + description + ", " + age + "green");
  50. }
  51. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement