API tools faq
paste
Advertisement
Guest User

AngelBot

a guest
Feb 2nd, 2018
347
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 60.78 KB | None | 0 0
raw download clone embed print report
  1. const Discord = require('discord.js');
  2. const bot = new Discord.Client();
  3. const mysql = require('mysql');
  4.  
  5. var con = mysql.createConnection({
  6. host: "127.0.0.1",
  7. user: "root",
  8. password: "1234",
  9. database: "sadb"
  10. });
  11.  
  12. bot.on('ready', () => {
  13. RoleChannel = bot.channels.find("id", "391240210253348865");
  14. RPGChannel = bot.channels.find("id", "391243914490806283");
  15. RPGChannele = bot.channels.find("id", "394875582988550154");
  16. RPGChannel2 = bot.channels.find("id", "396068581051203585");
  17. StatsEnfer = bot.channels.find("id", "391667518177280020");
  18. StatsParadis = bot.channels.find("id", "391667555988930580");
  19. console.log("DemonVsAnge Bot 0.1")
  20. console.log("Bot started.")
  21. con.connect(err => {
  22. if(err) throw err;
  23. console.log("Connected to database.");
  24. })});
  25.  
  26.  
  27. bot.on('message', (message) => {
  28. if(message.author.bot) return;
  29. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss){
  30. if (err) throw err;
  31. let sql;
  32. if(resultrowss.length < 1){
  33. sql = `INSERT INTO lvl (id,lvl) VALUES ('${message.author.id}', '0')`
  34. con.query(sql, console.log);
  35. } else {
  36. let SatanRole = message.guild.roles.find("name", "Satan");
  37. let DieuRole = message.guild.roles.find("name", "Dieu");
  38. if(message.member.roles.has(SatanRole.id)){
  39. message.guild.members.get(message.author.id).setNickname(message.author.username + " [Lv ??]");
  40. } else if(message.member.roles.has(DieuRole.id)){
  41. message.guild.members.get(message.author.id).setNickname(message.author.username + " [Lv ??]");
  42. } else {
  43. message.guild.members.get(message.author.id).setNickname(message.author.username + " [Lv " + resultrowss[0].lvl + "]");
  44. }}})
  45. if(message.content == "!bugtimer"){
  46. con.query(`TRUNCATE timer`);
  47. message.channel.send("Timer reset");
  48. }
  49. if(message.content == "!reload"){
  50. if(message.author.id == "195626809436405760"){
  51. console.log("Reload efféctuée");
  52. process.exit();
  53. } else {
  54. return;
  55. }
  56. }
  57. if(message.content.startsWith("!level")){
  58. if(message.author.id == "195626809436405760"){
  59. var argss = message.content.toString().split(" ");
  60. if(argss[2] != null){
  61. if(argss[2].startsWith("<@!")){
  62. var mentionnedid = argss[2].replace("<@!", "").replace(">", "");
  63. con.query(`UPDATE started SET started = '1' WHERE id = '${mentionnedid}'`);
  64. con.query(`UPDATE prevlvl SET prevlvl = '${+argss[1] - 1}' WHERE id = '${mentionnedid}'`);
  65. con.query(`UPDATE hp SET hp = '${+argss[1] * 50}' WHERE id = '${mentionnedid}'`);
  66. con.query(`UPDATE lvl SET lvl = '${+argss[1]}' WHERE id = '${mentionnedid}'`);
  67. con.query(`UPDATE MaxXP SET MaxXP = '${+argss[1] * 100}' WHERE id = '${mentionnedid}'`);
  68. con.query(`UPDATE xp SET xp = '0' WHERE id = '${mentionnedid}'`);
  69. message.channel.send("Stats de "+ message.mentions.users.first() +" modifiées au niveau " + argss[1]);
  70. } else return; // pas de mention
  71. } else {
  72. con.query(`UPDATE started SET started = '1' WHERE id = '${message.author.id}'`);
  73. con.query(`UPDATE prevlvl SET prevlvl = '${+argss[1] - 1}' WHERE id = '${message.author.id}'`);
  74. con.query(`UPDATE hp SET hp = '${+argss[1] * 50}' WHERE id = '${message.author.id}'`);
  75. con.query(`UPDATE lvl SET lvl = '${+argss[1]}' WHERE id = '${message.author.id}'`);
  76. con.query(`UPDATE MaxXP SET MaxXP = '${+argss[1] * 100}' WHERE id = '${message.author.id}'`);
  77. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  78. message.channel.send("Stats personnelles modifiées au niveau " + argss[1]);
  79. }
  80. }};
  81. if(message.content.startsWith("!gold")){
  82. if(message.author.id == "195626809436405760"){
  83. var argss = message.content.toString().split(" ");
  84. if(argss[2] != null){
  85. if(argss[2].startsWith("<@!")){
  86. var mentionnedid = argss[2].replace("<@!", "").replace(">", "");
  87. con.query(`UPDATE gold SET gold = '${argss[1]}' WHERE id = '${mentionnedid}'`);
  88. message.channel.send("Argent de "+ message.mentions.users.first() +" modifié à " + argss[1]);
  89. } else return; // pas de mention
  90. } else {
  91. con.query(`UPDATE gold SET gold = '${argss[1]}' WHERE id = '${message.author.id}'`);
  92. message.channel.send("Argent personnel modifié à " + argss[1]);
  93. }
  94. }};
  95. if(message.channel.id == "396068581051203585"){
  96. if(message.content.startsWith("!shop")){
  97. var args = message.content.toString().split(" ");
  98. if(args[1] == ""){
  99. RPGChannel2.send("Après choix, faites !buy ID de l'item.\nVeuillez spécifier armes ou armures après le !shop.");
  100. } else if(args[1] == "armes"){
  101. RPGChannel2.send("```ID - Nom - Coût\n \na1 - Hache en fer - 0g\na2 - Gode - 500g\na3 - Sabre - 1000g\na4 - Katana très tranchant - 1500g\na5 - Sabre laser - 10000g```");
  102. } else if(args[1] == "armures"){
  103. RPGChannel2.send("```ID - Nom - Coût\n \nb1 - Plastron en cuir - 0g\nb2 - Bretelles très élégantes - 500g\nb3 - Plastron en acier - 1000g```");
  104. }else {
  105. RPGChannel2.send("Après choix, faites !buy ID de l'item.\nVeuillez spécifier armes ou armures après le !shop.");
  106. }
  107. }
  108. if(message.content.startsWith("!buy")){
  109. con.query(`SELECT * FROM stuff WHERE id = '${message.author.id}'`, function (err, resultrows){
  110. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultrowss){
  111. var args = message.content.toString().split(" ");
  112. if(args[1] == ""){
  113. RPGChannel2.send("Faites !shop et choisissez un objet qui vous convient, puis retenez son ID.");
  114. } else if(args[1] == "a1"){
  115. if(resultrows[0].arme == "Hache en fer"){
  116. RPGChannel.send("Impossible, vous l'avez déjà.");
  117. } else if (resultrowss[0].gold - 0 >= 0){
  118. RPGChannel2.send("```Achat d'une Hache en fer effectué.\nTotal: -0g\nArgent restant: "+ (+resultrowss[0].gold - 0) + "```");
  119. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 0}' WHERE id = '${message.author.id}'`);
  120. con.query(`UPDATE stuff SET arme = 'Hache en fer' WHERE id = '${message.author.id}'`);
  121. } else {
  122. RPGChannel2.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  123. }
  124. } else if(args[1] == "a2"){
  125. if(resultrows[0].arme == "Gode"){
  126. RPGChannel2.send("Impossible, vous l'avez déjà.");
  127. } else if (resultrowss[0].gold - 500 >= 0){
  128. RPGChannel2.send("```Achat d'un Gode effectué.\nTotal: -500g\nArgent restant: "+ (+resultrowss[0].gold - 500) + "```");
  129. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 500}' WHERE id = '${message.author.id}'`);
  130. con.query(`UPDATE stuff SET arme = 'Gode' WHERE id = '${message.author.id}'`);
  131. } else {
  132. RPGChannel2.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  133. }
  134. } else if(args[1] == "a3"){
  135. if(resultrows[0].arme == "Sabre"){
  136. RPGChannel2.send("Impossible, vous l'avez déjà.");
  137. } else if (resultrowss[0].gold - 1000 >= 0){
  138. RPGChannel2.send("```Achat d'un Sabre effectué.\nTotal: -1000g\nArgent restant: "+ (+resultrowss[0].gold - 1000) + "```");
  139. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 1000}' WHERE id = '${message.author.id}'`);
  140. con.query(`UPDATE stuff SET arme = 'Sabre' WHERE id = '${message.author.id}'`);
  141. } else {
  142. RPGChannel2.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  143. }
  144. } else if(args[1] == "a4"){
  145. if(resultrows[0].arme == "Katana très tranchant"){
  146. RPGChannel2.send("Impossible, vous l'avez déjà.");
  147. } else if (resultrowss[0].gold - 1000 >= 0){
  148. RPGChannel2.send("```Achat d'un Katana très tranchant effectué.\nTotal: -1500g\nArgent restant: "+ (+resultrowss[0].gold - 1500) + "```");
  149. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 1500}' WHERE id = '${message.author.id}'`);
  150. con.query(`UPDATE stuff SET arme = 'Katana très tranchant' WHERE id = '${message.author.id}'`);
  151. } else {
  152. RPGChannel2.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  153. }
  154. } else if(args[1] == "a5"){
  155. if(resultrows[0].arme == "Sabre laser"){
  156. RPGChannel2.send("Impossible, vous l'avez déjà.");
  157. } else if (resultrowss[0].gold - 10000 >= 0){
  158. RPGChannel2.send("```Achat d'un Sabre Laser effectué.\nTotal: -10000g\nArgent restant: "+ (+resultrowss[0].gold - 10000) + "```");
  159. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 10000}' WHERE id = '${message.author.id}'`);
  160. con.query(`UPDATE stuff SET arme = 'Sabre Laser' WHERE id = '${message.author.id}'`);
  161. } else {
  162. RPGChannel2.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  163. }
  164. } else if(args[1] == "b1"){
  165. if(resultrows[0].armure == "Plastron en cuir"){
  166. RPGChannel2.send("Impossible, vous l'avez déjà.");
  167. } else if (resultrowss[0].gold - 0 >= 0){
  168. RPGChannel2.send("```Achat d'un Plastron en cuir effectué.\nArgent restant: "+ (+resultrowss[0].gold - 0) + "```");
  169. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 0}' WHERE id = '${message.author.id}'`);
  170. con.query(`UPDATE stuff SET armure = 'Plastron en cuir' WHERE id = '${message.author.id}'`);
  171. } else {
  172. RPGChannel2.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  173. }
  174. } else if(args[1] == "b2"){
  175. if(resultrows[0].armure == "Bretelles très élégantes"){
  176. RPGChannel2.send("Impossible, vous les avez déjà.");
  177. } else if (resultrowss[0].gold - 500 >= 0){
  178. RPGChannel.send("```Achat de Bretelles très élégantes effectué.\nArgent restant: "+ (+resultrowss[0].gold - 500) + "```");
  179. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 500}' WHERE id = '${message.author.id}'`);
  180. con.query(`UPDATE stuff SET armure = 'Bretelles très élégantes' WHERE id = '${message.author.id}'`);
  181. } else {
  182. RPGChannel.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  183. }
  184. } else if(args[1] == "b3"){
  185. if(resultrows[0].armure == "Plastron en acier"){
  186. RPGChannel.send("Impossible, vous l'avez déjà.");
  187. } else if (resultrowss[0].gold - 1000 >= 0){
  188. RPGChannel.send("```Achat d'un Plastron en acier effectué.\nArgent restant: "+ (+resultrowss[0].gold - 1000) + "```");
  189. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 1000}' WHERE id = '${message.author.id}'`);
  190. con.query(`UPDATE stuff SET armure = 'Plastron en acier' WHERE id = '${message.author.id}'`);
  191. } else {
  192. RPGChannel.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  193. }
  194. }else {
  195. RPGChannel.send("Faites !shop et choisissez un objet qui vous convient, puis retenez son ID.");
  196. }
  197. })
  198. })
  199. }
  200. if(message.content.startsWith("!pvp")){
  201. var args = message.content.toString().split(" ");
  202. if(args[1] != null){
  203. if(args[1].startsWith("<")){
  204. var mentionnedid = message.content = message.content.replace("!pvp ", "").replace("<@!", "").replace(">", "");
  205. con.query(`SELECT * FROM lvl WHERE id = '${mentionnedid}'`, function (err, resultssssssssssss){
  206. if (err) throw err;
  207. if(resultssssssssssss.length < 1){
  208. RPGChannel2.send("Cette personne n'a pas encore commencé.");
  209. } else {
  210. var mentionnedid = message.content = message.content.replace("!pvp ", "").replace("<@!", "").replace(">", "");
  211. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  212. if (err) throw err;
  213. con.query(`SELECT * FROM hp WHERE id = '${mentionnedid}'`, function (err, resultrowss){
  214. if (err) throw err;
  215. if(mentionnedid == "391325576348303360"){
  216. RPGChannel2.send("Désintégration de " + message.author.username + " en cours..");
  217. RPGChannel2.send("Désintégration terminée, remise au niveau 0 pour " + message.author.username);
  218. } else {
  219. var diffhp = resultrows[0].hp - resultrowss[0].hp;
  220. if(diffhp == 0){
  221. var Winrate = 50;
  222. }else if(diffhp >= 50 && diffhp < 99){
  223. var Winrate = Math.floor(Math.random() * (70 - 60 + 1)) + 60;
  224. }else if(diffhp >= 100 && diffhp < 199){
  225. var Winrate = Math.floor(Math.random() * (80 - 70 + 1)) + 70;
  226. }else if(diffhp >= 200 && diffhp < 499){
  227. var Winrate = Math.floor(Math.random() * (90 - 80 + 1)) + 80;
  228. }else if(diffhp >= 500 && diffhp < 999){
  229. var Winrate = Math.floor(Math.random() * (100 - 90 + 1)) + 90;
  230. }else if(diffhp >= 1000){
  231. var Winrate = 100;
  232. }else if(diffhp <= -50 && diffhp > -99){
  233. var Winrate = Math.floor(Math.random() * (40 - 30 + 1)) + 30;
  234. }else if(diffhp <= -100 && diffhp > -199){
  235. var Winrate = Math.floor(Math.random() * (30 - 20 + 1)) + 20;
  236. }else if(diffhp <= -200 && diffhp > -499){
  237. var Winrate = Math.floor(Math.random() * (20 - 10 + 1)) + 10;
  238. }else if(diffhp <= -500 && diffhp > -999){
  239. var Winrate = Math.floor(Math.random() * (10 - 0 + 1)) + 0;
  240. }else if(diffhp <= -1000){
  241. var Winrate = 0;
  242. }
  243. var WinrateReel = Math.floor(Math.random() * 100);
  244. RPGChannel2.send("```Combattant: " + message.author.username + " (" + resultrows[0].hp + "hp)\nEnnemi: " + message.mentions.users.first().username + " (" + resultrowss[0].hp + "hp)\n" + Winrate +"% de chance de victoire```");
  245. if(WinrateReel < Winrate){
  246. RPGChannel2.send("```Victoire de "+ message.author.username +" contre "+ message.mentions.users.first().username +"\navec "+ Winrate +"% de chance de victoire.\n```");
  247. } else {
  248. RPGChannel2.send("```Défaite de "+ message.author.username +" contre "+ message.mentions.users.first().username +"\navec "+ Winrate +"% de chance de victoire.\n```");
  249. }
  250. }
  251. })
  252. })
  253. }
  254. })
  255. } else {
  256. RPGChannel2.send("Veuillez mentionner quelqu'un.");
  257. }
  258. } else {
  259. RPGChannel2.send("Veuillez mentionner quelqu'un.");
  260. }
  261. }
  262. if(message.content == "!fight"){
  263. var date = new Date();
  264. var hours = date.getHours();
  265. var minutes = date.getMinutes();
  266. var seconds = date.getSeconds();
  267. con.query(`SELECT * FROM timer WHERE id = '${message.author.id}'`, function (err, resultsssssssssssss) {
  268. if (err) throw err;
  269. let sql;
  270. if(resultsssssssssssss.length < 1){
  271. sql = `INSERT INTO timer (id,timer) VALUES ('${message.author.id}', '0')`
  272. con.query(sql, console.log);
  273. }
  274. con.query(`SELECT * FROM timermin WHERE id = '${message.author.id}'`, function (err, resultsssssssssssssssssssssssssssss) {
  275. if (err) throw err;
  276. let sql;
  277. if(resultsssssssssssssssssssssssssssss.length < 1){
  278. sql = `INSERT INTO timermin (id,timermin) VALUES ('${message.author.id}', '${minutes}')`
  279. con.query(sql, console.log);
  280. }
  281. con.query(`SELECT * FROM timer WHERE id = '${message.author.id}'`, function (err, resultssssssssssss) {
  282. if (err) throw err;
  283. con.query(`SELECT * FROM timermin WHERE id = '${message.author.id}'`, function (err, resultssssssssssssssssssssssss) {
  284. if (err) throw err;
  285. if(minutes > resultssssssssssssssssssssssss[0].timermin){
  286. con.query(`UPDATE timermin SET timermin = '${minutes}' WHERE id = '${message.author.id}'`);
  287. con.query(`UPDATE timer SET timer = '0' WHERE id = '${message.author.id}'`);
  288. }
  289. con.query(`SELECT * FROM timer WHERE id = '${message.author.id}'`, function (err, resultssssssssssssssssssssssssssssssssssssssssssssssss) {
  290. if(seconds < resultssssssssssssssssssssssssssssssssssssssssssssssss[0].timer){
  291. RPGChannel2.send(message.author.username + ", veuillez attendre trois secondes entre chaque combat.\nCombats de nouveau disponible à: " + minutes + "m:" + resultssssssssssss[0].timer + "s");
  292. } else {
  293. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, function (err, result) {
  294. if (err) throw err;
  295. let sql;
  296. if(result.length < 1){
  297. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  298. con.query(sql, console.log);
  299. }
  300. if(result[0].started == 1){
  301. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  302. if (err) throw err;
  303. let SaintRole = message.guild.roles.find("name", "Saint");
  304. let AngeRole = message.guild.roles.find("name", "Ange");
  305. let DieuRole = message.guild.roles.find("name", "Dieu");
  306. let DiablotinRole = message.guild.roles.find("name", "Diablotin");
  307. let DémonRole = message.guild.roles.find("name", "Démon");
  308. let SatanRole = message.guild.roles.find("name", "Satan");
  309. if(message.member.roles.has(DieuRole.id)) {
  310. var Monster = "Bras-droit de Satan";
  311. } else if(message.member.roles.has(AngeRole.id)){
  312. var Monster = "Démon";
  313. } else if(message.member.roles.has(SaintRole.id)){
  314. var Monster = "Diablotin";
  315. } else if(message.member.roles.has(SatanRole.id)){
  316. var Monster = "Bras-droit de Dieu";
  317. } else if(message.member.roles.has(DémonRole.id)){
  318. var Monster = "Ange";
  319. } else if(message.member.roles.has(DiablotinRole.id)){
  320. var Monster = "Saint";
  321. }
  322. let min = resultrows[0].hp - 50;
  323. let max = resultrows[0].hp + 50;
  324. var HPMonster = Math.floor(Math.random() * (max - min + 1)) + min;
  325. if(HPMonster<resultrows[0].hp){
  326. var Winrate = Math.floor(Math.random() * (100 - 75 + 1)) + 75;
  327. }else if(HPMonster>=resultrows[0].hp){
  328. var Winrate = Math.floor(Math.random() * (95 - 40 + 1)) + 40;
  329. }
  330. var WinrateReel = Math.floor(Math.random() * 100);
  331. RPGChannel2.send("```Combattant: " + message.author.username + " (" + resultrows[0].hp + "hp)\nEnnemi: " + Monster + " (" + HPMonster + "hp)\n" + Winrate +"% de chance de victoire```");
  332. var datee = new Date();
  333. var secondss = datee.getSeconds();
  334. var minutess = datee.getMinutes();
  335. if((+secondss + 3) >= 59){
  336. con.query(`UPDATE timer SET timer = '0' WHERE id = '${message.author.id}'`);
  337. con.query(`UPDATE timermin SET timermin = '${minutess}' WHERE id = '${message.author.id}'`);
  338. } else {
  339. con.query(`UPDATE timer SET timer = '${+secondss + 3}' WHERE id = '${message.author.id}'`);
  340. con.query(`UPDATE timermin SET timermin = '${minutess}' WHERE id = '${message.author.id}'`);
  341. }
  342. if(WinrateReel < Winrate){
  343. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  344. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, function (err, results){
  345. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultsss){
  346. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss){
  347. if (err) throw err;
  348. con.query(`SELECT * FROM prevlvl WHERE id = '${message.author.id}'`, function (err, resultsssss){
  349. if (err) throw err;
  350. let sqll;
  351. if(resultsssss.length < 1){
  352. sqll = `INSERT INTO prevlvl (id,prevlvl) VALUES ('${message.author.id}', '${resultrowss[0].lvl - 1}')`
  353. con.query(sqll, console.log);
  354. }
  355. var WonCoins = Math.floor(Math.random() * (50 - 10 + 1)) + 10;
  356. var WonXpCalculate = Math.floor(Math.random() * (80 - 20 + 1)) + 20;
  357. var WonXp = WonXpCalculate + (+resultrowss[0].lvl * 6)
  358. let WonCoinsSQL = resultss[0].gold + WonCoins;
  359. let WonXpSQL = results[0].xp + WonXp;
  360. if(results[0].xp + WonXp < resultsss[0].maxxp){
  361. RPGChannel2.send("```Victoire de "+ message.author.username +" contre "+ Monster +"\navec "+ Winrate +"% de chance de victoire.\n \n"+ WonCoins +" pièces d'argent gagnées.\n"+ WonXp +" pts d'xp gagnés. ("+ WonXpCalculate + "bruts + "+ (+resultrowss[0].lvl * 6) +" bonus)\n"+ WonXpSQL +"/"+ resultsss[0].maxxp +" xp avant le prochain niveau.```");
  362. con.query(`UPDATE gold SET gold = '${WonCoinsSQL}' WHERE id = '${message.author.id}'`);
  363. con.query(`UPDATE xp SET xp = '${WonXpSQL}' WHERE id = '${message.author.id}'`);
  364. } else if (results[0].xp + WonXp >= resultsss[0].maxxp){
  365. var nextlevel = +resultrowss[0].lvl + 1;
  366. RPGChannel2.send("```Victoire de "+ message.author.username +" contre "+ Monster +"\navec "+ Winrate +"% de chance de victoire.\n \n"+ WonCoins +" pièces d'argent gagnées.\n"+ WonXp +" points d'expérience gagnés.\n"+ resultsss[0].maxxp + "/"+ resultsss[0].maxxp +" xp avant le prochain niveau.\nFélicitations! Level up au niveau "+ nextlevel +"```");
  367. con.query(`UPDATE gold SET gold = '${WonCoinsSQL}' WHERE id = '${message.author.id}'`);
  368. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  369. con.query(`UPDATE lvl SET lvl = '${resultsssss[0].prevlvl + 2}' WHERE id = '${message.author.id}'`);
  370. con.query(`UPDATE maxxp SET maxxp = '${resultsss[0].maxxp + 100}' WHERE id = '${message.author.id}'`);
  371. con.query(`UPDATE hp SET hp = '${resultrows[0].hp + 50}' WHERE id = '${message.author.id}'`);
  372. con.query(`UPDATE prevlvl SET prevlvl = '${resultsssss[0].prevlvl + 1}' WHERE id = '${message.author.id}'`);
  373. }
  374. })})})})})
  375. } else {
  376. var LostCoins = Math.floor(Math.random() * (30 - 5 + 1)) + 5;
  377. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  378. let LostCoinsSQL = resultss[0].gold - LostCoins;
  379. RPGChannel2.send("```Défaite de "+ message.author.username +" contre "+ Monster +"\navec "+ Winrate +"% de chance de victoire.\n"+ LostCoins +" pièces d'argent perdues.```");
  380. if(resultss[0].gold - LostCoins < 1){
  381. con.query(`UPDATE gold SET gold = '0' WHERE id = '${message.author.id}'`);
  382. } else {
  383. con.query(`UPDATE gold SET gold = '${LostCoinsSQL}' WHERE id = '${message.author.id}'`);
  384. }})}
  385. })
  386. } else {
  387. console.log(result[0].started);
  388. RPGChannel2.send("Vous n'avez pas encore commencé vôtre aventure, faites !stats pour la débuter.");
  389. }
  390. })
  391. }
  392. })})
  393. })})
  394. })
  395. }
  396. if(message.content.startsWith("!stats")){
  397. var args = message.content.toString().split(" ");
  398. if(args[1] != null){
  399. if(args[1].startsWith("<")){
  400. var mentionnedid = message.content = message.content.replace("!stats ", "").replace("<@!", "").replace(">", "");
  401. con.query(`SELECT * FROM lvl WHERE id = '${mentionnedid}'`, function (err, resultssssssssssss){
  402. if (err) throw err;
  403. if(resultssssssssssss.length < 1){
  404. RPGChannel2.send("Cette personne n'a pas encore commencé.");
  405. } else {
  406. var mentionnedid = message.content = message.content.replace("!stats ", "").replace("<@!", "").replace(">", "");
  407. if(mentionnedid == "391325576348303360"){
  408. RPGChannel2.send("```Les nombres sont trop importants pour être affichés.```");
  409. } else {
  410. con.query(`SELECT * FROM maxxp WHERE id = '${mentionnedid}'`, function (err, results){
  411. if (err) throw err;
  412. con.query(`SELECT * FROM xp WHERE id = '${mentionnedid}'`, function (err, resultsss){
  413. if (err) throw err;
  414. con.query(`SELECT * FROM stuff WHERE id = '${mentionnedid}'`, (err, rows) => {
  415. if(err) throw err;
  416. con.query(`SELECT * FROM hp WHERE id = '${mentionnedid}'`, function (err, resultrows){
  417. if (err) throw err;
  418. con.query(`SELECT * FROM lvl WHERE id = '${mentionnedid}'`, function (err, resultrowss){
  419. if (err) throw err;
  420. con.query(`SELECT * FROM gold WHERE id = '${mentionnedid}'`, function (err, resultssss){
  421. if (err) throw err;
  422. RPGChannel2.send("```Stats de " + message.mentions.users.first().username + "\n \nNiveau: " + resultrowss[0].lvl + "\nPoints d'XP: " + resultsss[0].xp + "/"+ results[0].maxxp +"\nPoints de vie: " + resultrows[0].hp + "\nArgent: "+ resultssss[0].gold + "\nArme: " + rows[0].arme + "\nArmure: " + rows[0].armure + "\n```");
  423. })})})})})})
  424. }}})
  425. } else return;
  426. } else {
  427. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowsssss){
  428. if (err) throw err;
  429. let sql;
  430. if(resultrowsssss.length < 1){
  431. sql = `INSERT INTO lvl (id,lvl) VALUES ('${message.author.id}', '0')`
  432. con.query(sql, console.log);
  433. }
  434. let SaintRolee = message.guild.roles.find("name", "Saint");
  435. let AngeRolee = message.guild.roles.find("name", "Ange");
  436. let DiablotinRolee = message.guild.roles.find("name", "Diablotin");
  437. let DémonRolee = message.guild.roles.find("name", "Démon");
  438. if(message.member.roles.has(SaintRolee.id)){
  439. if(resultrowsssss[0].lvl >= 5){
  440. message.member.addRole(AngeRolee.id)
  441. } else {
  442. return;
  443. }
  444. } else if(message.member.roles.has(DiablotinRolee.id)){
  445. if(resultrowsssss[0].lvl >= 5){
  446. message.member.addRole(DémonRolee.id)
  447. } else {
  448. return;
  449. }
  450. }
  451. })
  452. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultsss1){
  453. if (err) throw err;
  454. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, function (err, result1) {
  455. if (err) throw err;
  456. let sql;
  457. if(result1.length < 1){
  458. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  459. con.query(sql, console.log);
  460. }
  461. if(result1[0].started == 1){
  462. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, function (err, result1){
  463. if (err) throw err;
  464. let sql;
  465. if(result1.length < 1){
  466. sql = `INSERT INTO xp (id,xp) VALUES ('${message.author.id}', '0')`
  467. con.query(sql, console.log);
  468. }
  469. con.query(`SELECT * FROM stuff WHERE id = '${message.author.id}'`, (err, rows1) => {
  470. if(err) throw err;
  471. if(rows1.length < 1){
  472. sql = `INSERT INTO stuff (id,arme,armure) VALUES ('${message.author.id}', 'Aucune', 'Aucune')`
  473. con.query(sql, console.log);
  474. }
  475. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows1){
  476. if (err) throw err;
  477. let sql;
  478. if(resultrows1.length < 1){
  479. sql = `INSERT INTO hp (id,hp) VALUES ('${message.author.id}', '0')`
  480. con.query(sql, console.log);
  481. }
  482. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss1){
  483. if (err) throw err;
  484. let sql;
  485. if(resultrowss1.length < 1){
  486. sql = `INSERT INTO lvl (id,lvl) VALUES ('${message.author.id}', '0')`
  487. con.query(sql, console.log);
  488. }
  489. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss1){
  490. if (err) throw err;
  491. let sql;
  492. if(resultss1.length < 1){
  493. sql = `INSERT INTO gold (id,gold) VALUES ('${message.author.id}', '0')`
  494. con.query(sql, console.log);
  495. }
  496. con.query(`SELECT * FROM prevlvl WHERE id = '${message.author.id}'`, function (err, resultsssss1){
  497. if (err) throw err;
  498. let sqll;
  499. if(resultsssss1.length < 1){
  500. sqll = `INSERT INTO prevlvl (id,prevlvl) VALUES ('${message.author.id}', '${resultrowss1[0].lvl - 1}')`
  501. con.query(sqll, console.log);
  502. }
  503. if(result1[0].xp <= resultsss1[0].maxxp - 1 && resultrowss1[0].lvl == 1){
  504. con.query(`UPDATE maxxp SET maxxp = '100' WHERE id = '${message.author.id}'`);
  505. con.query(`UPDATE hp SET hp = '50' WHERE id = '${message.author.id}'`);
  506. } else if(result1[0].xp > resultsss1[0].maxxp - 1){
  507. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  508. con.query(`UPDATE lvl SET lvl = '${resultsssss1[0].prevlvl + 2}' WHERE id = '${message.author.id}'`);
  509. con.query(`UPDATE maxxp SET maxxp = '${resultsss1[0].maxxp + 100}' WHERE id = '${message.author.id}'`);
  510. con.query(`UPDATE hp SET hp = '${resultrows1[0].hp + 50}' WHERE id = '${message.author.id}'`);
  511. con.query(`UPDATE prevlvl SET prevlvl = '${resultsssss1[0].prevlvl + 1}' WHERE id = '${message.author.id}'`);
  512. }
  513. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultsss){
  514. if (err) throw err;
  515. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, function (err, result) {
  516. if (err) throw err;
  517. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, function (err, result){
  518. if (err) throw err;
  519. con.query(`SELECT * FROM stuff WHERE id = '${message.author.id}'`, (err, rows) => {
  520. if(err) throw err;
  521. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  522. if (err) throw err;
  523. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss){
  524. if (err) throw err;
  525. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  526. if (err) throw err;
  527. con.query(`SELECT * FROM prevlvl WHERE id = '${message.author.id}'`, function (err, resultsssss){
  528. if (err) throw err;
  529. RPGChannel2.send("```Stats de " + message.author.username + "\n \nNiveau: " + resultrowss[0].lvl + "\nPoints d'XP: " + result[0].xp + "/"+ resultsss[0].maxxp +"\nPoints de vie: " + resultrows[0].hp + "\nArgent: "+ resultss[0].gold + "\nArme: " + rows[0].arme + "\nArmure: " + rows[0].armure + "\n```");
  530. })})})})})})})})})})})})})})
  531. } else {
  532. RPGChannel2.send("Bienvenue dans ce monde où combattent démons et anges. Attrapez cette hache en métal, ce plastron de cuir et partez combattre avec la commande !fight des petites créatures sans défenses pour monter en niveaux.");
  533. con.query(`UPDATE started SET started = '1' WHERE id = '${message.author.id}'`);
  534. con.query(`UPDATE stuff SET arme = 'Hache en fer' WHERE id = '${message.author.id}'`);
  535. con.query(`UPDATE stuff SET armure = 'Plastron en cuir' WHERE id = '${message.author.id}'`);
  536. con.query(`UPDATE hp SET hp = '50' WHERE id = '${message.author.id}'`);
  537. con.query(`UPDATE lvl SET lvl = '1' WHERE id = '${message.author.id}'`);
  538. con.query(`UPDATE gold SET gold = '0' WHERE id = '${message.author.id}'`);
  539. con.query(`UPDATE MaxXP SET MaxXP = '100' WHERE id = '${message.author.id}'`);
  540. }})})}}
  541. } else {
  542. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  543. if (err) throw err;
  544. let sql;
  545. if(resultss.length < 1){
  546. sql = `INSERT INTO gold (id,gold) VALUES ('${message.author.id}', '0')`
  547. con.query(sql, console.log);
  548. }})
  549. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultss){
  550. if (err) throw err;
  551. let sql;
  552. if(resultss.length < 1){
  553. sql = `INSERT INTO maxxp (id,maxxp) VALUES ('${message.author.id}', '0')`
  554. con.query(sql, console.log);
  555. }})
  556. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  557. if (err) throw err;
  558. let sql;
  559. if(resultrows.length < 1){
  560. sql = `INSERT INTO hp (id,hp) VALUES ('${message.author.id}', '0')`
  561. con.query(sql, console.log);
  562. }})
  563. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss){
  564. if (err) throw err;
  565. let sql;
  566. if(resultrowss.length < 1){
  567. sql = `INSERT INTO lvl (id,lvl) VALUES ('${message.author.id}', '0')`
  568. con.query(sql, console.log);
  569. } else {
  570. let SatanRole = message.guild.roles.find("name", "Satan");
  571. let DieuRole = message.guild.roles.find("name", "Dieu");
  572. if(message.member.roles.has(SatanRole.id)){
  573. message.guild.members.get(message.author.id).setNickname(message.author.username + " [Lv ??]");
  574. } else if(message.member.roles.has(DieuRole.id)){
  575. message.guild.members.get(message.author.id).setNickname(message.author.username + " [Lv ??]");
  576. } else {
  577. message.guild.members.get(message.author.id).setNickname(message.author.username + " [Lv " + resultrowss[0].lvl + "]");
  578. }
  579. }
  580. })
  581. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, (err, rows) => {
  582. if(err) throw err;
  583. let sql;
  584. console.log(rows);
  585. if(rows.length < 1){
  586. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  587. con.query(sql, console.log);
  588. }});
  589. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, (err, rows) => {
  590. if(err) throw err;
  591. let sql;
  592. console.log(rows);
  593. if(rows.length < 1){
  594. sql = `INSERT INTO xp (id,xp) VALUES ('${message.author.id}', '0')`
  595. con.query(sql, console.log);
  596. }});
  597. con.query(`SELECT * FROM stuff WHERE id = '${message.author.id}'`, (err, rows) => {
  598. if(err) throw err;
  599. let sql;
  600. console.log(rows);
  601. if(rows.length < 1){
  602. sql = `INSERT INTO stuff (id,arme,armure) VALUES ('${message.author.id}', 'Aucune', 'Aucune')`
  603. con.query(sql, console.log);
  604. }});
  605. if(message.channel.type == "dm") return;
  606. if(message.channel.id == "391240210253348865"){
  607. if(message.content == "!rank démon"){
  608. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, (err, rows) => {
  609. if(err) throw err;
  610. let sql;
  611. console.log(rows);
  612. if(rows.length < 1){
  613. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  614. con.query(sql, console.log);
  615. }});
  616. let SaintRole = message.guild.roles.find("name", "Saint");
  617. let AngeRole = message.guild.roles.find("name", "Ange");
  618. let DieuRole = message.guild.roles.find("name", "Dieu");
  619. let DiablotinRole = message.guild.roles.find("name", "Diablotin");
  620. let DémonRole = message.guild.roles.find("name", "Démon");
  621. let SatanRole = message.guild.roles.find("name", "Satan");
  622. if(message.member.roles.has(DieuRole.id)) {
  623. RoleChannel.send("Impossible, vous êtes Dieu.")
  624. } else if(message.member.roles.has(AngeRole.id)){
  625. RoleChannel.send("Impossible, vôtre âme est liée à la nation des Anges.");
  626. } else if(message.member.roles.has(SaintRole.id)){
  627. RoleChannel.send("Impossible, vôtre âme est liée à la nation des Saints.");
  628. } else if(message.member.roles.has(SatanRole.id)){
  629. RoleChannel.send("Je pensais que Satan avait une bonne vue..");
  630. } else if(message.member.roles.has(DémonRole.id)){
  631. RoleChannel.send("Je pensais que les Démons avaient une bonne vue..");
  632. } else if(message.member.roles.has(DiablotinRole.id)){
  633. RoleChannel.send("Je pensais que les Diablotins avaient une bonne vue..");
  634. } else {
  635. message.member.addRole(DiablotinRole.id)
  636. RoleChannel.send("Pas si vite, pour devenir un démon confirmé, il faudra vous battre et monter en niveaux. En attendant, je vous met Diablotin.");
  637. }}
  638. if(message.content == "!rank gardien"){
  639. RoleChannel.send("Vous avez cru qu'il était possible de devenir dieu des deux mondes? Quel combattant naïf.");
  640. }
  641. if(message.content == "!rank ange"){
  642. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, (err, rows) => {
  643. if(err) throw err;
  644. let sql;
  645. console.log(rows);
  646. if(rows.length < 1){
  647. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  648. con.query(sql, console.log);
  649. }});
  650. let SaintRole = message.guild.roles.find("name", "Saint");
  651. let AngeRole = message.guild.roles.find("name", "Ange");
  652. let DieuRole = message.guild.roles.find("name", "Dieu");
  653. let DiablotinRole = message.guild.roles.find("name", "Diablotin");
  654. let DémonRole = message.guild.roles.find("name", "Démon");
  655. let SatanRole = message.guild.roles.find("name", "Satan");
  656. if(message.member.roles.has(DieuRole.id)) {
  657. RoleChannel.send("Je pensais que Dieu avait une bonne vue..")
  658. } else if(message.member.roles.has(AngeRole.id)){
  659. RoleChannel.send("Je pensais que les Anges avaient une bonne vue..");
  660. } else if(message.member.roles.has(SaintRole.id)){
  661. RoleChannel.send("Je pensais que les Saints avaient une bonne vue..");
  662. } else if(message.member.roles.has(SatanRole.id)){
  663. RoleChannel.send("Impossible, vous êtes Satan.");
  664. } else if(message.member.roles.has(DémonRole.id)){
  665. RoleChannel.send("Impossible, vôtre âme est liée à la nation des Démons.");
  666. } else if(message.member.roles.has(DiablotinRole.id)){
  667. RoleChannel.send("Impossible, vôtre âme est liée à la nation des Diablotins.");
  668. } else {
  669. message.member.addRole(SaintRole.id)
  670. RoleChannel.send("Pas si vite, pour devenir un ange confirmé, il faudra vous battre et monter en niveaux. En attendant, je vous met Saint.");
  671. }}
  672. } else if(message.channel.id == "391243914490806283"){
  673. if(message.content.startsWith("!shop")){
  674. var args = message.content.toString().split(" ");
  675. if(args[1] == ""){
  676. RPGChannel.send("Après choix, faites !buy ID de l'item.\nVeuillez spécifier armes ou armures après le !shop.");
  677. } else if(args[1] == "armes"){
  678. RPGChannel.send("```ID - Nom - Coût\n \na1 - Hache en fer - 0g\na2 - Gode - 500g\na3 - Sabre - 1000g\na4 - Katana très tranchant - 1500g\na5 - Sabre laser - 10000g```");
  679. } else if(args[1] == "armures"){
  680. RPGChannel.send("```ID - Nom - Coût\n \nb1 - Plastron en cuir - 0g\nb2 - Bretelles très élégantes - 500g\nb3 - Plastron en acier - 1000g```");
  681. }else {
  682. RPGChannel.send("Après choix, faites !buy ID de l'item.\nVeuillez spécifier armes ou armures après le !shop.");
  683. }
  684. }
  685. if(message.content.startsWith("!buy")){
  686. con.query(`SELECT * FROM stuff WHERE id = '${message.author.id}'`, function (err, resultrows){
  687. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultrowss){
  688. var args = message.content.toString().split(" ");
  689. if(args[1] == ""){
  690. RPGChannel.send("Faites !shop et choisissez un objet qui vous convient, puis retenez son ID.");
  691. } else if(args[1] == "a1"){
  692. if(resultrows[0].arme == "Hache en fer"){
  693. RPGChannel.send("Impossible, vous l'avez déjà.");
  694. } else if (resultrowss[0].gold - 0 >= 0){
  695. RPGChannel.send("```Achat d'une Hache en fer effectué.\nTotal: -0g\nArgent restant: "+ (+resultrowss[0].gold - 0) + "```");
  696. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 0}' WHERE id = '${message.author.id}'`);
  697. con.query(`UPDATE stuff SET arme = 'Hache en fer' WHERE id = '${message.author.id}'`);
  698. } else {
  699. RPGChannel.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  700. }
  701. } else if(args[1] == "a2"){
  702. if(resultrows[0].arme == "Gode"){
  703. RPGChannel.send("Impossible, vous l'avez déjà.");
  704. } else if (resultrowss[0].gold - 500 >= 0){
  705. RPGChannel.send("```Achat d'un Gode effectué.\nTotal: -500g\nArgent restant: "+ (+resultrowss[0].gold - 500) + "```");
  706. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 500}' WHERE id = '${message.author.id}'`);
  707. con.query(`UPDATE stuff SET arme = 'Gode' WHERE id = '${message.author.id}'`);
  708. } else {
  709. RPGChannel.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  710. }
  711. } else if(args[1] == "a3"){
  712. if(resultrows[0].arme == "Sabre"){
  713. RPGChannel.send("Impossible, vous l'avez déjà.");
  714. } else if (resultrowss[0].gold - 1000 >= 0){
  715. RPGChannel.send("```Achat d'un Sabre effectué.\nTotal: -1000g\nArgent restant: "+ (+resultrowss[0].gold - 1000) + "```");
  716. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 1000}' WHERE id = '${message.author.id}'`);
  717. con.query(`UPDATE stuff SET arme = 'Sabre' WHERE id = '${message.author.id}'`);
  718. } else {
  719. RPGChannel.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  720. }
  721. } else if(args[1] == "a4"){
  722. if(resultrows[0].arme == "Katana très tranchant"){
  723. RPGChannel.send("Impossible, vous l'avez déjà.");
  724. } else if (resultrowss[0].gold - 1000 >= 0){
  725. RPGChannel.send("```Achat d'un Katana très tranchant effectué.\nTotal: -1500g\nArgent restant: "+ (+resultrowss[0].gold - 1500) + "```");
  726. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 1500}' WHERE id = '${message.author.id}'`);
  727. con.query(`UPDATE stuff SET arme = 'Katana très tranchant' WHERE id = '${message.author.id}'`);
  728. } else {
  729. RPGChannel.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  730. }
  731. } else if(args[1] == "a5"){
  732. if(resultrows[0].arme == "Sabre laser"){
  733. RPGChannel2.send("Impossible, vous l'avez déjà.");
  734. } else if (resultrowss[0].gold - 10000 >= 0){
  735. RPGChannel.send("```Achat d'un Sabre Laser effectué.\nTotal: -10000g\nArgent restant: "+ (+resultrowss[0].gold - 10000) + "```");
  736. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 10000}' WHERE id = '${message.author.id}'`);
  737. con.query(`UPDATE stuff SET arme = 'Sabre Laser' WHERE id = '${message.author.id}'`);
  738. } else {
  739. RPGChannel2.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  740. }
  741. } else if(args[1] == "b1"){
  742. if(resultrows[0].armure == "Plastron en cuir"){
  743. RPGChannel.send("Impossible, vous l'avez déjà.");
  744. } else if (resultrowss[0].gold - 0 >= 0){
  745. RPGChannel.send("```Achat d'un Plastron en cuir effectué.\nArgent restant: "+ (+resultrowss[0].gold - 0) + "```");
  746. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 0}' WHERE id = '${message.author.id}'`);
  747. con.query(`UPDATE stuff SET armure = 'Plastron en cuir' WHERE id = '${message.author.id}'`);
  748. } else {
  749. RPGChannel.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  750. }
  751. } else if(args[1] == "b2"){
  752. if(resultrows[0].armure == "Bretelles très élégantes"){
  753. RPGChannel.send("Impossible, vous les avez déjà.");
  754. } else if (resultrowss[0].gold - 500 >= 0){
  755. RPGChannel.send("```Achat de Bretelles très élégantes effectué.\nArgent restant: "+ (+resultrowss[0].gold - 500) + "```");
  756. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 500}' WHERE id = '${message.author.id}'`);
  757. con.query(`UPDATE stuff SET armure = 'Bretelles très élégantes' WHERE id = '${message.author.id}'`);
  758. } else {
  759. RPGChannel.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  760. }
  761. } else if(args[1] == "b3"){
  762. if(resultrows[0].armure == "Plastron en acier"){
  763. RPGChannel.send("Impossible, vous l'avez déjà.");
  764. } else if (resultrowss[0].gold - 1000 >= 0){
  765. RPGChannel.send("```Achat d'un Plastron en acier effectué.\nArgent restant: "+ (+resultrowss[0].gold - 1000) + "```");
  766. con.query(`UPDATE gold SET gold = '${resultrowss[0].gold - 1000}' WHERE id = '${message.author.id}'`);
  767. con.query(`UPDATE stuff SET armure = 'Plastron en acier' WHERE id = '${message.author.id}'`);
  768. } else {
  769. RPGChannel.send("Vous n'avez pas assez d'argent pour acheter ceci.");
  770. }
  771. }else {
  772. RPGChannel.send("Faites !shop et choisissez un objet qui vous convient, puis retenez son ID.");
  773. }
  774. })
  775. })
  776. }
  777. if(message.content.startsWith("!pvp")){
  778. if(message.channel.id)
  779. var args = message.content.toString().split(" ");
  780. if(args[1] != null){
  781. if(args[1].startsWith("<")){
  782. var mentionnedid = message.content = message.content.replace("!pvp ", "").replace("<@!", "").replace(">", "");
  783. con.query(`SELECT * FROM lvl WHERE id = '${mentionnedid}'`, function (err, resultssssssssssss){
  784. if (err) throw err;
  785. if(resultssssssssssss.length < 1){
  786. RPGChannel.send("Cette personne n'a pas encore commencé.");
  787. } else {
  788. var mentionnedid = message.content = message.content.replace("!pvp ", "").replace("<@!", "").replace(">", "");
  789. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  790. if (err) throw err;
  791. con.query(`SELECT * FROM hp WHERE id = '${mentionnedid}'`, function (err, resultrowss){
  792. if (err) throw err;
  793. if(mentionnedid == "391325576348303360"){
  794. RPGChannel.send("Désintégration de " + message.author.username + " en cours..");
  795. RPGChannel.send("Désintégration terminée, remise au niveau 0 pour " + message.author.username);
  796. } else {
  797. var diffhp = resultrows[0].hp - resultrowss[0].hp;
  798. if(diffhp == 0){
  799. var Winrate = 50;
  800. }else if(diffhp >= 50 && diffhp < 99){
  801. var Winrate = Math.floor(Math.random() * (70 - 60 + 1)) + 60;
  802. }else if(diffhp >= 100 && diffhp < 199){
  803. var Winrate = Math.floor(Math.random() * (80 - 70 + 1)) + 70;
  804. }else if(diffhp >= 200 && diffhp < 499){
  805. var Winrate = Math.floor(Math.random() * (90 - 80 + 1)) + 80;
  806. }else if(diffhp >= 500 && diffhp < 999){
  807. var Winrate = Math.floor(Math.random() * (100 - 90 + 1)) + 90;
  808. }else if(diffhp >= 1000){
  809. var Winrate = 100;
  810. }else if(diffhp <= -50 && diffhp > -99){
  811. var Winrate = Math.floor(Math.random() * (40 - 30 + 1)) + 30;
  812. }else if(diffhp <= -100 && diffhp > -199){
  813. var Winrate = Math.floor(Math.random() * (30 - 20 + 1)) + 20;
  814. }else if(diffhp <= -200 && diffhp > -499){
  815. var Winrate = Math.floor(Math.random() * (20 - 10 + 1)) + 10;
  816. }else if(diffhp <= -500 && diffhp > -999){
  817. var Winrate = Math.floor(Math.random() * (10 - 0 + 1)) + 0;
  818. }else if(diffhp <= -1000){
  819. var Winrate = 0;
  820. }
  821. var WinrateReel = Math.floor(Math.random() * 100);
  822. RPGChannel.send("```Combattant: " + message.author.username + " (" + resultrows[0].hp + "hp)\nEnnemi: " + message.mentions.users.first().username + " (" + resultrowss[0].hp + "hp)\n" + Winrate +"% de chance de victoire```");
  823. if(WinrateReel < Winrate){
  824. RPGChannel.send("```Victoire de "+ message.author.username +" contre "+ message.mentions.users.first().username +"\navec "+ Winrate +"% de chance de victoire.\n```");
  825. } else {
  826. RPGChannel.send("```Défaite de "+ message.author.username +" contre "+ message.mentions.users.first().username +"\navec "+ Winrate +"% de chance de victoire.\n```");
  827. }
  828. }
  829. })
  830. })
  831. }
  832. })
  833. } else {
  834. RPGChannel.send("Veuillez mentionner quelqu'un.");
  835. }
  836. } else {
  837. RPGChannel.send("Veuillez mentionner quelqu'un.");
  838. }
  839. }
  840. if(message.content == "!fight"){
  841. var date = new Date();
  842. var hours = date.getHours();
  843. var minutes = date.getMinutes();
  844. var seconds = date.getSeconds();
  845. con.query(`SELECT * FROM timer WHERE id = '${message.author.id}'`, function (err, resultsssssssssssss) {
  846. if (err) throw err;
  847. let sql;
  848. if(resultsssssssssssss.length < 1){
  849. sql = `INSERT INTO timer (id,timer) VALUES ('${message.author.id}', '0')`
  850. con.query(sql, console.log);
  851. }
  852. con.query(`SELECT * FROM timermin WHERE id = '${message.author.id}'`, function (err, resultsssssssssssssssssssssssssssss) {
  853. if (err) throw err;
  854. let sql;
  855. if(resultsssssssssssssssssssssssssssss.length < 1){
  856. sql = `INSERT INTO timermin (id,timermin) VALUES ('${message.author.id}', '${minutes}')`
  857. con.query(sql, console.log);
  858. }
  859. con.query(`SELECT * FROM timer WHERE id = '${message.author.id}'`, function (err, resultssssssssssss) {
  860. if (err) throw err;
  861. con.query(`SELECT * FROM timermin WHERE id = '${message.author.id}'`, function (err, resultssssssssssssssssssssssss) {
  862. if (err) throw err;
  863. if(minutes > resultssssssssssssssssssssssss[0].timermin){
  864. con.query(`UPDATE timermin SET timermin = '${minutes}' WHERE id = '${message.author.id}'`);
  865. con.query(`UPDATE timer SET timer = '0' WHERE id = '${message.author.id}'`);
  866. }
  867. con.query(`SELECT * FROM timer WHERE id = '${message.author.id}'`, function (err, resultssssssssssssssssssssssssssssssssssssssssssssssss) {
  868. if(seconds < resultssssssssssssssssssssssssssssssssssssssssssssssss[0].timer){
  869. RPGChannel.send(message.author.username + ", veuillez attendre trois secondes entre chaque combat.\nCombats de nouveau disponible à: " + minutes + "m:" + resultssssssssssss[0].timer + "s");
  870. } else {
  871. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, function (err, result) {
  872. if (err) throw err;
  873. let sql;
  874. if(result.length < 1){
  875. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  876. con.query(sql, console.log);
  877. }
  878. if(result[0].started == 1){
  879. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  880. if (err) throw err;
  881. let SaintRole = message.guild.roles.find("name", "Saint");
  882. let AngeRole = message.guild.roles.find("name", "Ange");
  883. let DieuRole = message.guild.roles.find("name", "Dieu");
  884. let DiablotinRole = message.guild.roles.find("name", "Diablotin");
  885. let DémonRole = message.guild.roles.find("name", "Démon");
  886. let SatanRole = message.guild.roles.find("name", "Satan");
  887. if(message.member.roles.has(DieuRole.id)) {
  888. var Monster = "Bras-droit de Satan";
  889. } else if(message.member.roles.has(AngeRole.id)){
  890. var Monster = "Démon";
  891. } else if(message.member.roles.has(SaintRole.id)){
  892. var Monster = "Diablotin";
  893. } else if(message.member.roles.has(SatanRole.id)){
  894. var Monster = "Bras-droit de Dieu";
  895. } else if(message.member.roles.has(DémonRole.id)){
  896. var Monster = "Ange";
  897. } else if(message.member.roles.has(DiablotinRole.id)){
  898. var Monster = "Saint";
  899. }
  900. let min = resultrows[0].hp - 50;
  901. let max = resultrows[0].hp + 50;
  902. var HPMonster = Math.floor(Math.random() * (max - min + 1)) + min;
  903. if(HPMonster<resultrows[0].hp){
  904. var Winrate = Math.floor(Math.random() * (100 - 75 + 1)) + 75;
  905. }else if(HPMonster>=resultrows[0].hp){
  906. var Winrate = Math.floor(Math.random() * (95 - 40 + 1)) + 40;
  907. }
  908. var WinrateReel = Math.floor(Math.random() * 100);
  909. RPGChannel.send("```Combattant: " + message.author.username + " (" + resultrows[0].hp + "hp)\nEnnemi: " + Monster + " (" + HPMonster + "hp)\n" + Winrate +"% de chance de victoire```");
  910. var datee = new Date();
  911. var secondss = datee.getSeconds();
  912. var minutess = datee.getMinutes();
  913. if((+secondss + 3) >= 59){
  914. con.query(`UPDATE timer SET timer = '0' WHERE id = '${message.author.id}'`);
  915. con.query(`UPDATE timermin SET timermin = '${minutess}' WHERE id = '${message.author.id}'`);
  916. } else {
  917. con.query(`UPDATE timer SET timer = '${+secondss + 3}' WHERE id = '${message.author.id}'`);
  918. con.query(`UPDATE timermin SET timermin = '${minutess}' WHERE id = '${message.author.id}'`);
  919. }
  920. if(WinrateReel < Winrate){
  921. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  922. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, function (err, results){
  923. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultsss){
  924. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss){
  925. if (err) throw err;
  926. con.query(`SELECT * FROM prevlvl WHERE id = '${message.author.id}'`, function (err, resultsssss){
  927. if (err) throw err;
  928. let sqll;
  929. if(resultsssss.length < 1){
  930. sqll = `INSERT INTO prevlvl (id,prevlvl) VALUES ('${message.author.id}', '${resultrowss[0].lvl - 1}')`
  931. con.query(sqll, console.log);
  932. }
  933. var WonCoins = Math.floor(Math.random() * (50 - 10 + 1)) + 10;
  934. var WonXpCalculate = Math.floor(Math.random() * (80 - 20 + 1)) + 20;
  935. var WonXp = WonXpCalculate + (+resultrowss[0].lvl * 6)
  936. let WonCoinsSQL = resultss[0].gold + WonCoins;
  937. let WonXpSQL = results[0].xp + WonXp;
  938. if(results[0].xp + WonXp < resultsss[0].maxxp){
  939. RPGChannel.send("```Victoire de "+ message.author.username +" contre "+ Monster +"\navec "+ Winrate +"% de chance de victoire.\n \n"+ WonCoins +" pièces d'argent gagnées.\n"+ WonXp +" pts d'xp gagnés. ("+ WonXpCalculate + "bruts + "+ (+resultrowss[0].lvl * 6) +" bonus)\n"+ WonXpSQL +"/"+ resultsss[0].maxxp +" xp avant le prochain niveau.```");
  940. con.query(`UPDATE gold SET gold = '${WonCoinsSQL}' WHERE id = '${message.author.id}'`);
  941. con.query(`UPDATE xp SET xp = '${WonXpSQL}' WHERE id = '${message.author.id}'`);
  942. } else if (results[0].xp + WonXp >= resultsss[0].maxxp){
  943. var nextlevel = +resultrowss[0].lvl + 1;
  944. RPGChannel.send("```Victoire de "+ message.author.username +" contre "+ Monster +"\navec "+ Winrate +"% de chance de victoire.\n \n"+ WonCoins +" pièces d'argent gagnées.\n"+ WonXp +" points d'expérience gagnés.\n"+ resultsss[0].maxxp + "/"+ resultsss[0].maxxp +" xp avant le prochain niveau.\nFélicitations! Level up au niveau "+ nextlevel +"```");
  945. con.query(`UPDATE gold SET gold = '${WonCoinsSQL}' WHERE id = '${message.author.id}'`);
  946. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  947. con.query(`UPDATE lvl SET lvl = '${resultsssss[0].prevlvl + 2}' WHERE id = '${message.author.id}'`);
  948. con.query(`UPDATE maxxp SET maxxp = '${resultsss[0].maxxp + 100}' WHERE id = '${message.author.id}'`);
  949. con.query(`UPDATE hp SET hp = '${resultrows[0].hp + 50}' WHERE id = '${message.author.id}'`);
  950. con.query(`UPDATE prevlvl SET prevlvl = '${resultsssss[0].prevlvl + 1}' WHERE id = '${message.author.id}'`);
  951. }
  952. })})})})})
  953. } else {
  954. var LostCoins = Math.floor(Math.random() * (30 - 5 + 1)) + 5;
  955. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  956. let LostCoinsSQL = resultss[0].gold - LostCoins;
  957. RPGChannel.send("```Défaite de "+ message.author.username +" contre "+ Monster +"\navec "+ Winrate +"% de chance de victoire.\n"+ LostCoins +" pièces d'argent perdues.```");
  958. if(resultss[0].gold - LostCoins < 1){
  959. con.query(`UPDATE gold SET gold = '0' WHERE id = '${message.author.id}'`);
  960. } else {
  961. con.query(`UPDATE gold SET gold = '${LostCoinsSQL}' WHERE id = '${message.author.id}'`);
  962. }})}
  963. })
  964. } else {
  965. console.log(result[0].started);
  966. RPGChannel.send("Vous n'avez pas encore commencé vôtre aventure, faites !stats pour la débuter.");
  967. }
  968. })
  969. }
  970. })})
  971. })})
  972. })
  973. }
  974. } if(message.content.startsWith("!stats")){
  975. var args = message.content.toString().split(" ");
  976. if(args[1] != null){
  977. if(args[1].startsWith("<")){
  978. var mentionnedid = message.content = message.content.replace("!stats ", "").replace("<@!", "").replace(">", "");
  979. con.query(`SELECT * FROM lvl WHERE id = '${mentionnedid}'`, function (err, resultssssssssssss){
  980. if (err) throw err;
  981. if(resultssssssssssss.length < 1){
  982. RPGChannel.send("Cette personne n'a pas encore commencé.");
  983. } else {
  984. var mentionnedid = message.content = message.content.replace("!stats ", "").replace("<@!", "").replace(">", "");
  985. if(mentionnedid == "391325576348303360"){
  986. RPGChannel.send("```Les nombres sont trop importants pour être affichés.```");
  987. } else {
  988. con.query(`SELECT * FROM maxxp WHERE id = '${mentionnedid}'`, function (err, results){
  989. if (err) throw err;
  990. con.query(`SELECT * FROM xp WHERE id = '${mentionnedid}'`, function (err, resultsss){
  991. if (err) throw err;
  992. con.query(`SELECT * FROM stuff WHERE id = '${mentionnedid}'`, (err, rows) => {
  993. if(err) throw err;
  994. con.query(`SELECT * FROM hp WHERE id = '${mentionnedid}'`, function (err, resultrows){
  995. if (err) throw err;
  996. con.query(`SELECT * FROM lvl WHERE id = '${mentionnedid}'`, function (err, resultrowss){
  997. if (err) throw err;
  998. con.query(`SELECT * FROM gold WHERE id = '${mentionnedid}'`, function (err, resultssss){
  999. if (err) throw err;
  1000. RPGChannel.send("```Stats de " + message.mentions.users.first().username + "\n \nNiveau: " + resultrowss[0].lvl + "\nPoints d'XP: " + resultsss[0].xp + "/"+ results[0].maxxp +"\nPoints de vie: " + resultrows[0].hp + "\nArgent: "+ resultssss[0].gold + "\nArme: " + rows[0].arme + "\nArmure: " + rows[0].armure + "\n```");
  1001. })})})})})})
  1002. }}})
  1003. } else return;
  1004. } else {
  1005. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowsssss){
  1006. if (err) throw err;
  1007. let sql;
  1008. if(resultrowsssss.length < 1){
  1009. sql = `INSERT INTO lvl (id,lvl) VALUES ('${message.author.id}', '0')`
  1010. con.query(sql, console.log);
  1011. }
  1012. let SaintRolee = message.guild.roles.find("name", "Saint");
  1013. let AngeRolee = message.guild.roles.find("name", "Ange");
  1014. let DiablotinRolee = message.guild.roles.find("name", "Diablotin");
  1015. let DémonRolee = message.guild.roles.find("name", "Démon");
  1016. if(message.member.roles.has(SaintRolee.id)){
  1017. if(resultrowsssss[0].lvl >= 5){
  1018. message.member.addRole(AngeRolee.id)
  1019. } else {
  1020. return;
  1021. }
  1022. } else if(message.member.roles.has(DiablotinRolee.id)){
  1023. if(resultrowsssss[0].lvl >= 5){
  1024. message.member.addRole(DémonRolee.id)
  1025. } else {
  1026. return;
  1027. }
  1028. }
  1029. })
  1030. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultsss1){
  1031. if (err) throw err;
  1032. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, function (err, result1) {
  1033. if (err) throw err;
  1034. let sql;
  1035. if(result1.length < 1){
  1036. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  1037. con.query(sql, console.log);
  1038. }
  1039. if(result1[0].started == 1){
  1040. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, function (err, result1){
  1041. if (err) throw err;
  1042. let sql;
  1043. if(result1.length < 1){
  1044. sql = `INSERT INTO xp (id,xp) VALUES ('${message.author.id}', '0')`
  1045. con.query(sql, console.log);
  1046. }
  1047. con.query(`SELECT * FROM stuff WHERE id = '${message.author.id}'`, (err, rows1) => {
  1048. if(err) throw err;
  1049. if(rows1.length < 1){
  1050. sql = `INSERT INTO stuff (id,arme,armure) VALUES ('${message.author.id}', 'Aucune', 'Aucune')`
  1051. con.query(sql, console.log);
  1052. }
  1053. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows1){
  1054. if (err) throw err;
  1055. let sql;
  1056. if(resultrows1.length < 1){
  1057. sql = `INSERT INTO hp (id,hp) VALUES ('${message.author.id}', '0')`
  1058. con.query(sql, console.log);
  1059. }
  1060. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss1){
  1061. if (err) throw err;
  1062. let sql;
  1063. if(resultrowss1.length < 1){
  1064. sql = `INSERT INTO lvl (id,lvl) VALUES ('${message.author.id}', '0')`
  1065. con.query(sql, console.log);
  1066. }
  1067. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss1){
  1068. if (err) throw err;
  1069. let sql;
  1070. if(resultss1.length < 1){
  1071. sql = `INSERT INTO gold (id,gold) VALUES ('${message.author.id}', '0')`
  1072. con.query(sql, console.log);
  1073. }
  1074. con.query(`SELECT * FROM prevlvl WHERE id = '${message.author.id}'`, function (err, resultsssss1){
  1075. if (err) throw err;
  1076. let sqll;
  1077. if(resultsssss1.length < 1){
  1078. sqll = `INSERT INTO prevlvl (id,prevlvl) VALUES ('${message.author.id}', '${resultrowss1[0].lvl - 1}')`
  1079. con.query(sqll, console.log);
  1080. }
  1081. if(result1[0].xp <= resultsss1[0].maxxp - 1 && resultrowss1[0].lvl == 1){
  1082. con.query(`UPDATE maxxp SET maxxp = '100' WHERE id = '${message.author.id}'`);
  1083. con.query(`UPDATE hp SET hp = '50' WHERE id = '${message.author.id}'`);
  1084. } else if(result1[0].xp > resultsss1[0].maxxp - 1){
  1085. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  1086. con.query(`UPDATE lvl SET lvl = '${resultsssss1[0].prevlvl + 2}' WHERE id = '${message.author.id}'`);
  1087. con.query(`UPDATE maxxp SET maxxp = '${resultsss1[0].maxxp + 100}' WHERE id = '${message.author.id}'`);
  1088. con.query(`UPDATE hp SET hp = '${resultrows1[0].hp + 50}' WHERE id = '${message.author.id}'`);
  1089. con.query(`UPDATE prevlvl SET prevlvl = '${resultsssss1[0].prevlvl + 1}' WHERE id = '${message.author.id}'`);
  1090. }
  1091. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultsss){
  1092. if (err) throw err;
  1093. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, function (err, result) {
  1094. if (err) throw err;
  1095. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, function (err, result){
  1096. if (err) throw err;
  1097. con.query(`SELECT * FROM stuff WHERE id = '${message.author.id}'`, (err, rows) => {
  1098. if(err) throw err;
  1099. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  1100. if (err) throw err;
  1101. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss){
  1102. if (err) throw err;
  1103. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  1104. if (err) throw err;
  1105. con.query(`SELECT * FROM prevlvl WHERE id = '${message.author.id}'`, function (err, resultsssss){
  1106. if (err) throw err;
  1107. RPGChannel.send("```Stats de " + message.author.username + "\n \nNiveau: " + resultrowss[0].lvl + "\nPoints d'XP: " + result[0].xp + "/"+ resultsss[0].maxxp +"\nPoints de vie: " + resultrows[0].hp + "\nArgent: "+ resultss[0].gold + "\nArme: " + rows[0].arme + "\nArmure: " + rows[0].armure + "\n```");
  1108. })})})})})})})})})})})})})})
  1109. } else {
  1110. RPGChannel.send("Bienvenue dans ce monde où combattent démons et anges. Attrapez cette hache en métal, ce plastron de cuir et partez combattre avec la commande !fight des petites créatures sans défenses pour monter en niveaux.");
  1111. con.query(`UPDATE started SET started = '1' WHERE id = '${message.author.id}'`);
  1112. con.query(`UPDATE stuff SET arme = 'Hache en fer' WHERE id = '${message.author.id}'`);
  1113. con.query(`UPDATE stuff SET armure = 'Plastron en cuir' WHERE id = '${message.author.id}'`);
  1114. con.query(`UPDATE hp SET hp = '50' WHERE id = '${message.author.id}'`);
  1115. con.query(`UPDATE lvl SET lvl = '1' WHERE id = '${message.author.id}'`);
  1116. con.query(`UPDATE gold SET gold = '0' WHERE id = '${message.author.id}'`);
  1117. con.query(`UPDATE MaxXP SET MaxXP = '100' WHERE id = '${message.author.id}'`);
  1118. }})})}}}});
  1119. bot.login("token");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!