API tools faq
paste
Advertisement
Guest User

xd

a guest
Dec 23rd, 2017
125
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.13 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: "localhost",
  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. console.log("DemonVsAnge Bot 0.1")
  16. console.log("Bot started.")
  17. con.connect(err => {
  18. if(err) throw err;
  19. console.log("Connected to database.");
  20. })});
  21.  
  22.  
  23. bot.on('message', (message) => {
  24. if(message.author.bot) return;
  25. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  26. if (err) throw err;
  27. let sql;
  28. if(resultss.length < 1){
  29. sql = `INSERT INTO gold (id,gold) VALUES ('${message.author.id}', '0')`
  30. con.query(sql, console.log);
  31. }})
  32. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultss){
  33. if (err) throw err;
  34. let sql;
  35. if(resultss.length < 1){
  36. sql = `INSERT INTO maxxp (id,maxxp) VALUES ('${message.author.id}', '0')`
  37. con.query(sql, console.log);
  38. }})
  39. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  40. if (err) throw err;
  41. let sql;
  42. if(resultrows.length < 1){
  43. sql = `INSERT INTO hp (id,hp) VALUES ('${message.author.id}', '0')`
  44. con.query(sql, console.log);
  45. }})
  46. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss){
  47. if (err) throw err;
  48. let sql;
  49. if(resultrowss.length < 1){
  50. sql = `INSERT INTO lvl (id,lvl) VALUES ('${message.author.id}', '0')`
  51. con.query(sql, console.log);
  52. }})
  53. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, (err, rows) => {
  54. if(err) throw err;
  55. let sql;
  56. console.log(rows);
  57. if(rows.length < 1){
  58. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  59. con.query(sql, console.log);
  60. }});
  61. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, (err, rows) => {
  62. if(err) throw err;
  63. let sql;
  64. console.log(rows);
  65. if(rows.length < 1){
  66. sql = `INSERT INTO xp (id,xp) VALUES ('${message.author.id}', '0')`
  67. con.query(sql, console.log);
  68. }});
  69. con.query(`SELECT * FROM stuff WHERE id = '${message.author.id}'`, (err, rows) => {
  70. if(err) throw err;
  71. let sql;
  72. console.log(rows);
  73. if(rows.length < 1){
  74. sql = `INSERT INTO stuff (id,arme,armure) VALUES ('${message.author.id}', 'Aucune', 'Aucune')`
  75. con.query(sql, console.log);
  76. }});
  77. if(message.channel.type == "dm") return;
  78. if(message.channel.id == "391240210253348865"){
  79. if(message.content == "!rank démon"){
  80. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, (err, rows) => {
  81. if(err) throw err;
  82. let sql;
  83. console.log(rows);
  84. if(rows.length < 1){
  85. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  86. con.query(sql, console.log);
  87. }});
  88. let SaintRole = message.guild.roles.find("name", "Saint");
  89. let AngeRole = message.guild.roles.find("name", "Ange");
  90. let DieuRole = message.guild.roles.find("name", "Dieu");
  91. let DiablotinRole = message.guild.roles.find("name", "Diablotin");
  92. let DémonRole = message.guild.roles.find("name", "Démon");
  93. let SatanRole = message.guild.roles.find("name", "Satan");
  94. if(message.member.roles.has(DieuRole.id)) {
  95. RoleChannel.send("Impossible, vous êtes Dieu.")
  96. } else if(message.member.roles.has(AngeRole.id)){
  97. RoleChannel.send("Impossible, vôtre âme est liée à la nation des Anges.");
  98. } else if(message.member.roles.has(SaintRole.id)){
  99. RoleChannel.send("Impossible, vôtre âme est liée à la nation des Saints.");
  100. } else if(message.member.roles.has(SatanRole.id)){
  101. RoleChannel.send("Je pensais que Satan avait une bonne vue..");
  102. } else if(message.member.roles.has(DémonRole.id)){
  103. RoleChannel.send("Je pensais que les Démons avaient une bonne vue..");
  104. } else if(message.member.roles.has(DiablotinRole.id)){
  105. RoleChannel.send("Je pensais que les Diablotins avaient une bonne vue..");
  106. } else {
  107. message.member.addRole(DiablotinRole.id)
  108. 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.");
  109. }}
  110. if(message.content == "!rank gardien"){
  111. RoleChannel.send("Vous avez cru qu'il était possible de devenir dieu des deux mondes? Quel combattant naïf.");
  112. }
  113. if(message.content == "!rank ange"){
  114. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, (err, rows) => {
  115. if(err) throw err;
  116. let sql;
  117. console.log(rows);
  118. if(rows.length < 1){
  119. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  120. con.query(sql, console.log);
  121. }});
  122. let SaintRole = message.guild.roles.find("name", "Saint");
  123. let AngeRole = message.guild.roles.find("name", "Ange");
  124. let DieuRole = message.guild.roles.find("name", "Dieu");
  125. let DiablotinRole = message.guild.roles.find("name", "Diablotin");
  126. let DémonRole = message.guild.roles.find("name", "Démon");
  127. let SatanRole = message.guild.roles.find("name", "Satan");
  128. if(message.member.roles.has(DieuRole.id)) {
  129. RoleChannel.send("Je pensais que Dieu avait une bonne vue..")
  130. } else if(message.member.roles.has(AngeRole.id)){
  131. RoleChannel.send("Je pensais que les Anges avaient une bonne vue..");
  132. } else if(message.member.roles.has(SaintRole.id)){
  133. RoleChannel.send("Je pensais que les Saints avaient une bonne vue..");
  134. } else if(message.member.roles.has(SatanRole.id)){
  135. RoleChannel.send("Impossible, vous êtes Satan.");
  136. } else if(message.member.roles.has(DémonRole.id)){
  137. RoleChannel.send("Impossible, vôtre âme est liée à la nation des Démons.");
  138. } else if(message.member.roles.has(DiablotinRole.id)){
  139. RoleChannel.send("Impossible, vôtre âme est liée à la nation des Diablotins.");
  140. } else {
  141. message.member.addRole(SaintRole.id)
  142. RoleChannel.send("Pas si vite, pour devenir un ange confirmé, il faudra vous battre et monter en niveaux. En attendant, je vous met Saint.");
  143. }}
  144. } else if(message.channel.id == "391243914490806283"){
  145. if(message.content == "!fight"){
  146. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, function (err, result) {
  147. if (err) throw err;
  148. let sql;
  149. if(result.length < 1){
  150. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  151. con.query(sql, console.log);
  152. }
  153. if(result[0].started == 1){
  154. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  155. if (err) throw err;
  156. let SaintRole = message.guild.roles.find("name", "Saint");
  157. let AngeRole = message.guild.roles.find("name", "Ange");
  158. let DieuRole = message.guild.roles.find("name", "Dieu");
  159. let DiablotinRole = message.guild.roles.find("name", "Diablotin");
  160. let DémonRole = message.guild.roles.find("name", "Démon");
  161. let SatanRole = message.guild.roles.find("name", "Satan");
  162. if(message.member.roles.has(DieuRole.id)) {
  163. var Monster = "Diablotin";
  164. } else if(message.member.roles.has(AngeRole.id)){
  165. var Monster = "Diablotin";
  166. } else if(message.member.roles.has(SaintRole.id)){
  167. var Monster = "Diablotin";
  168. } else if(message.member.roles.has(SatanRole.id)){
  169. var Monster = "Saint";
  170. } else if(message.member.roles.has(DémonRole.id)){
  171. var Monster = "Saint";
  172. } else if(message.member.roles.has(DiablotinRole.id)){
  173. var Monster = "Saint";
  174. }
  175. let min = resultrows[0].hp - 20;
  176. let max = resultrows[0].hp + 25;
  177. var HPMonster = Math.floor(Math.random() * (max - min + 1)) + min;
  178. if(HPMonster<resultrows[0].hp){
  179. var Winrate = Math.floor(Math.random() * (100 - 90 + 1)) + 90;
  180. }else if(HPMonster>=resultrows[0].hp){
  181. var Winrate = Math.floor(Math.random() * (95 - 60 + 1)) + 60;
  182. }
  183. RPGChannel.send("```Combattant: " + message.author.username + " (" + resultrows[0].hp + "hp)\nEnnemi: " + Monster + " (" + HPMonster + "hp)\n" + Winrate +"% de chance de victoire```");
  184. if(Winrate>80){
  185. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss){
  186. if (err) throw err;
  187. if(result[0].xp <= 99 && resultrowss[0].lvl == 1){
  188. con.query(`UPDATE MaxXP SET MaxXP = '100' WHERE id = '${message.author.id}'`);
  189. con.query(`UPDATE hp SET hp = '50' WHERE id = '${message.author.id}'`);
  190. } else if(result[0].xp <= 199 && resultrowss[0].lvl == 2){
  191. con.query(`UPDATE MaxXP SET MaxXP = '200' WHERE id = '${message.author.id}'`);
  192. con.query(`UPDATE hp SET hp = '100' WHERE id = '${message.author.id}'`);
  193. } else if(result[0].xp <= 299 && resultrowss[0].lvl == 3){
  194. con.query(`UPDATE MaxXP SET MaxXP = '300' WHERE id = '${message.author.id}'`);
  195. con.query(`UPDATE hp SET hp = '150' WHERE id = '${message.author.id}'`);
  196. } else if(result[0].xp <= 399 && resultrowss[0].lvl == 4){
  197. con.query(`UPDATE MaxXP SET MaxXP = '400' WHERE id = '${message.author.id}'`);
  198. con.query(`UPDATE hp SET hp = '200' WHERE id = '${message.author.id}'`);
  199. } else if(result[0].xp <= 499 && resultrowss[0].lvl == 5){
  200. con.query(`UPDATE MaxXP SET MaxXP = '500' WHERE id = '${message.author.id}'`);
  201. con.query(`UPDATE hp SET hp = '250' WHERE id = '${message.author.id}'`);
  202. } else if(result[0].xp <= 599 && resultrowss[0].lvl == 6){
  203. con.query(`UPDATE MaxXP SET MaxXP = '600' WHERE id = '${message.author.id}'`);
  204. con.query(`UPDATE hp SET hp = '300' WHERE id = '${message.author.id}'`);
  205. } else if(result[0].xp <= 699 && resultrowss[0].lvl == 7){
  206. con.query(`UPDATE MaxXP SET MaxXP = '700' WHERE id = '${message.author.id}'`);
  207. con.query(`UPDATE hp SET hp = '350' WHERE id = '${message.author.id}'`);
  208. } else if(result[0].xp <= 799 && resultrowss[0].lvl == 8){
  209. con.query(`UPDATE MaxXP SET MaxXP = '800' WHERE id = '${message.author.id}'`);
  210. con.query(`UPDATE hp SET hp = '400' WHERE id = '${message.author.id}'`);
  211. } else if(result[0].xp <= 899 && resultrowss[0].lvl == 9){
  212. con.query(`UPDATE MaxXP SET MaxXP = '900' WHERE id = '${message.author.id}'`);
  213. con.query(`UPDATE hp SET hp = '450' WHERE id = '${message.author.id}'`);
  214. } else if(result[0].xp <= 999 && resultrowss[0].lvl == 10){
  215. con.query(`UPDATE MaxXP SET MaxXP = '1000' WHERE id = '${message.author.id}'`);
  216. con.query(`UPDATE hp SET hp = '500' WHERE id = '${message.author.id}'`);
  217. } else if(result[0].xp > 99 && resultrowss[0].lvl == 1){
  218. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  219. con.query(`UPDATE lvl SET lvl = '2' WHERE id = '${message.author.id}'`);
  220. con.query(`UPDATE maxxp SET maxxp = '200' WHERE id = '${message.author.id}'`);
  221. con.query(`UPDATE hp SET hp = '100' WHERE id = '${message.author.id}'`);
  222. } else if(result[0].xp > 199 && resultrowss[0].lvl == 2){
  223. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  224. con.query(`UPDATE lvl SET lvl = '3' WHERE id = '${message.author.id}'`);
  225. con.query(`UPDATE maxxp SET maxxp = '300' WHERE id = '${message.author.id}'`);
  226. con.query(`UPDATE hp SET hp = '150' WHERE id = '${message.author.id}'`);
  227. } else if(result[0].xp > 299 && resultrowss[0].lvl == 3){
  228. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  229. con.query(`UPDATE lvl SET lvl = '4' WHERE id = '${message.author.id}'`);
  230. con.query(`UPDATE maxxp SET maxxp = '400' WHERE id = '${message.author.id}'`);
  231. con.query(`UPDATE hp SET hp = '200' WHERE id = '${message.author.id}'`);
  232. } else if(result[0].xp > 399 && resultrowss[0].lvl == 4){
  233. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  234. con.query(`UPDATE lvl SET lvl = '5' WHERE id = '${message.author.id}'`);
  235. con.query(`UPDATE maxxp SET maxxp = '500' WHERE id = '${message.author.id}'`);
  236. con.query(`UPDATE hp SET hp = '250' WHERE id = '${message.author.id}'`);
  237. } else if(result[0].xp > 499 && resultrowss[0].lvl == 5){
  238. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  239. con.query(`UPDATE lvl SET lvl = '6' WHERE id = '${message.author.id}'`);
  240. con.query(`UPDATE maxxp SET maxxp = '600' WHERE id = '${message.author.id}'`);
  241. con.query(`UPDATE hp SET hp = '300' WHERE id = '${message.author.id}'`);
  242. } else if(result[0].xp > 599 && resultrowss[0].lvl == 6){
  243. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  244. con.query(`UPDATE lvl SET lvl = '7' WHERE id = '${message.author.id}'`);
  245. con.query(`UPDATE maxxp SET maxxp = '700' WHERE id = '${message.author.id}'`);
  246. con.query(`UPDATE hp SET hp = '350' WHERE id = '${message.author.id}'`);
  247. } else if(result[0].xp > 699 && resultrowss[0].lvl == 7){
  248. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  249. con.query(`UPDATE lvl SET lvl = '8' WHERE id = '${message.author.id}'`);
  250. con.query(`UPDATE maxxp SET maxxp = '800' WHERE id = '${message.author.id}'`);
  251. con.query(`UPDATE hp SET hp = '400' WHERE id = '${message.author.id}'`);
  252. } else if(result[0].xp > 799 && resultrowss[0].lvl == 8){
  253. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  254. con.query(`UPDATE lvl SET lvl = '9' WHERE id = '${message.author.id}'`);
  255. con.query(`UPDATE maxxp SET maxxp = '900' WHERE id = '${message.author.id}'`);
  256. con.query(`UPDATE hp SET hp = '450' WHERE id = '${message.author.id}'`);
  257. } else if(result[0].xp > 899 && resultrowss[0].lvl == 9){
  258. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  259. con.query(`UPDATE lvl SET lvl = '10' WHERE id = '${message.author.id}'`);
  260. con.query(`UPDATE maxxp SET maxxp = '1000' WHERE id = '${message.author.id}'`);
  261. con.query(`UPDATE hp SET hp = '500' WHERE id = '${message.author.id}'`);
  262. }
  263. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  264. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, function (err, results){
  265. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultsss){
  266. var WonCoins = Math.floor(Math.random() * (50 - 10 + 1)) + 10;
  267. var WonXp = Math.floor(Math.random() * (80 - 20 + 1)) + 20;
  268. let WonCoinsSQL = resultss[0].gold + WonCoins;
  269. let WonXpSQL = results[0].xp + WonXp;
  270. 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"+ WonXpSQL +"/"+ resultsss[0].maxxp +" xp avant le prochain niveau.```");
  271. con.query(`UPDATE gold SET gold = '${WonCoinsSQL}' WHERE id = '${message.author.id}'`);
  272. con.query(`UPDATE xp SET xp = '${WonXpSQL}' WHERE id = '${message.author.id}'`);
  273. })
  274. })
  275. })
  276. })
  277. } else if(Winrate<90){
  278. var LostCoins = Math.floor(Math.random() * (30 - 5 + 1)) + 5;
  279. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  280. let LostCoinsSQL = resultss[0].gold - LostCoins;
  281. RPGChannel.send("```Défaite de "+ message.author.username +" contre "+ Monster +"\navec "+ Winrate +"% de chance de victoire.\n"+ LostCoins +" pièces d'argent perdues.```");
  282. if(resultss[0].gold - LostCoins < 1){
  283. return;
  284. } else {
  285. con.query(`UPDATE gold SET gold = '${LostCoinsSQL}' WHERE id = '${message.author.id}'`);
  286. }})}
  287. })
  288. } else {
  289. console.log(result[0].started);
  290. RPGChannel.send("Vous n'avez pas encore commencé vôtre aventure, faites !stats pour la débuter.");
  291. }
  292. })
  293. }
  294. } if(message.content == "!stats"){
  295. con.query(`SELECT * FROM maxxp WHERE id = '${message.author.id}'`, function (err, resultsss){
  296. if (err) throw err;
  297. con.query(`SELECT * FROM started WHERE id = '${message.author.id}'`, function (err, result) {
  298. if (err) throw err;
  299. let sql;
  300. if(result.length < 1){
  301. sql = `INSERT INTO started (id,started) VALUES ('${message.author.id}', '0')`
  302. con.query(sql, console.log);
  303. }
  304. if(result[0].started == 1){
  305. con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, function (err, result){
  306. if (err) throw err;
  307. let sql;
  308. if(result.length < 1){
  309. sql = `INSERT INTO xp (id,xp) VALUES ('${message.author.id}', '0')`
  310. con.query(sql, console.log);
  311. }
  312. con.query(`SELECT * FROM stuff WHERE id = '${message.author.id}'`, (err, rows) => {
  313. if(err) throw err;
  314. if(rows.length < 1){
  315. sql = `INSERT INTO stuff (id,arme,armure) VALUES ('${message.author.id}', 'Aucune', 'Aucune')`
  316. con.query(sql, console.log);
  317. }
  318. con.query(`SELECT * FROM hp WHERE id = '${message.author.id}'`, function (err, resultrows){
  319. if (err) throw err;
  320. let sql;
  321. if(resultrows.length < 1){
  322. sql = `INSERT INTO hp (id,hp) VALUES ('${message.author.id}', '0')`
  323. con.query(sql, console.log);
  324. }
  325. con.query(`SELECT * FROM lvl WHERE id = '${message.author.id}'`, function (err, resultrowss){
  326. if (err) throw err;
  327. let sql;
  328. if(resultrowss.length < 1){
  329. sql = `INSERT INTO lvl (id,lvl) VALUES ('${message.author.id}', '0')`
  330. con.query(sql, console.log);
  331. }
  332. con.query(`SELECT * FROM gold WHERE id = '${message.author.id}'`, function (err, resultss){
  333. if (err) throw err;
  334. let sql;
  335. if(resultss.length < 1){
  336. sql = `INSERT INTO gold (id,gold) VALUES ('${message.author.id}', '0')`
  337. con.query(sql, console.log);
  338. }
  339. if(result[0].xp <= 99 && resultrowss[0].lvl == 1){
  340. con.query(`UPDATE MaxXP SET MaxXP = '100' WHERE id = '${message.author.id}'`);
  341. con.query(`UPDATE hp SET hp = '50' WHERE id = '${message.author.id}'`);
  342. } else if(result[0].xp <= 199 && resultrowss[0].lvl == 2){
  343. con.query(`UPDATE MaxXP SET MaxXP = '200' WHERE id = '${message.author.id}'`);
  344. con.query(`UPDATE hp SET hp = '100' WHERE id = '${message.author.id}'`);
  345. } else if(result[0].xp <= 299 && resultrowss[0].lvl == 3){
  346. con.query(`UPDATE MaxXP SET MaxXP = '300' WHERE id = '${message.author.id}'`);
  347. con.query(`UPDATE hp SET hp = '150' WHERE id = '${message.author.id}'`);
  348. } else if(result[0].xp <= 399 && resultrowss[0].lvl == 4){
  349. con.query(`UPDATE MaxXP SET MaxXP = '400' WHERE id = '${message.author.id}'`);
  350. con.query(`UPDATE hp SET hp = '200' WHERE id = '${message.author.id}'`);
  351. } else if(result[0].xp <= 499 && resultrowss[0].lvl == 5){
  352. con.query(`UPDATE MaxXP SET MaxXP = '500' WHERE id = '${message.author.id}'`);
  353. con.query(`UPDATE hp SET hp = '250' WHERE id = '${message.author.id}'`);
  354. } else if(result[0].xp <= 599 && resultrowss[0].lvl == 6){
  355. con.query(`UPDATE MaxXP SET MaxXP = '600' WHERE id = '${message.author.id}'`);
  356. con.query(`UPDATE hp SET hp = '300' WHERE id = '${message.author.id}'`);
  357. } else if(result[0].xp <= 699 && resultrowss[0].lvl == 7){
  358. con.query(`UPDATE MaxXP SET MaxXP = '700' WHERE id = '${message.author.id}'`);
  359. con.query(`UPDATE hp SET hp = '350' WHERE id = '${message.author.id}'`);
  360. } else if(result[0].xp <= 799 && resultrowss[0].lvl == 8){
  361. con.query(`UPDATE MaxXP SET MaxXP = '800' WHERE id = '${message.author.id}'`);
  362. con.query(`UPDATE hp SET hp = '400' WHERE id = '${message.author.id}'`);
  363. } else if(result[0].xp <= 899 && resultrowss[0].lvl == 9){
  364. con.query(`UPDATE MaxXP SET MaxXP = '900' WHERE id = '${message.author.id}'`);
  365. con.query(`UPDATE hp SET hp = '450' WHERE id = '${message.author.id}'`);
  366. } else if(result[0].xp <= 999 && resultrowss[0].lvl == 10){
  367. con.query(`UPDATE MaxXP SET MaxXP = '1000' WHERE id = '${message.author.id}'`);
  368. con.query(`UPDATE hp SET hp = '500' WHERE id = '${message.author.id}'`);
  369. } else if(result[0].xp > 99 && resultrowss[0].lvl == 1){
  370. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  371. con.query(`UPDATE lvl SET lvl = '2' WHERE id = '${message.author.id}'`);
  372. con.query(`UPDATE maxxp SET maxxp = '200' WHERE id = '${message.author.id}'`);
  373. } else if(result[0].xp > 199 && resultrowss[0].lvl == 2){
  374. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  375. con.query(`UPDATE lvl SET lvl = '3' WHERE id = '${message.author.id}'`);
  376. con.query(`UPDATE maxxp SET maxxp = '300' WHERE id = '${message.author.id}'`);
  377. } else if(result[0].xp > 299 && resultrowss[0].lvl == 3){
  378. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  379. con.query(`UPDATE lvl SET lvl = '4' WHERE id = '${message.author.id}'`);
  380. con.query(`UPDATE maxxp SET maxxp = '400' WHERE id = '${message.author.id}'`);
  381. } else if(result[0].xp > 399 && resultrowss[0].lvl == 4){
  382. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  383. con.query(`UPDATE lvl SET lvl = '5' WHERE id = '${message.author.id}'`);
  384. con.query(`UPDATE maxxp SET maxxp = '500' WHERE id = '${message.author.id}'`);
  385. } else if(result[0].xp > 499 && resultrowss[0].lvl == 5){
  386. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  387. con.query(`UPDATE lvl SET lvl = '6' WHERE id = '${message.author.id}'`);
  388. con.query(`UPDATE maxxp SET maxxp = '600' WHERE id = '${message.author.id}'`);
  389. } else if(result[0].xp > 599 && resultrowss[0].lvl == 6){
  390. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  391. con.query(`UPDATE lvl SET lvl = '7' WHERE id = '${message.author.id}'`);
  392. con.query(`UPDATE maxxp SET maxxp = '700' WHERE id = '${message.author.id}'`);
  393. } else if(result[0].xp > 699 && resultrowss[0].lvl == 7){
  394. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  395. con.query(`UPDATE lvl SET lvl = '8' WHERE id = '${message.author.id}'`);
  396. con.query(`UPDATE maxxp SET maxxp = '800' WHERE id = '${message.author.id}'`);
  397. } else if(result[0].xp > 799 && resultrowss[0].lvl == 8){
  398. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  399. con.query(`UPDATE lvl SET lvl = '9' WHERE id = '${message.author.id}'`);
  400. con.query(`UPDATE maxxp SET maxxp = '900' WHERE id = '${message.author.id}'`);
  401. } else if(result[0].xp > 899 && resultrowss[0].lvl == 9){
  402. con.query(`UPDATE xp SET xp = '0' WHERE id = '${message.author.id}'`);
  403. con.query(`UPDATE lvl SET lvl = '10' WHERE id = '${message.author.id}'`);
  404. con.query(`UPDATE maxxp SET maxxp = '1000' WHERE id = '${message.author.id}'`);
  405. }
  406. 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```");
  407. con.query(`UPDATE started SET started = '1' WHERE id = '${message.author.id}'`);
  408. })})})})})
  409. } else {
  410. 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.");
  411. con.query(`UPDATE started SET started = '1' WHERE id = '${message.author.id}'`);
  412. con.query(`UPDATE stuff SET arme = 'Hache en fer' WHERE id = '${message.author.id}'`);
  413. con.query(`UPDATE stuff SET armure = 'Plastron en cuir' WHERE id = '${message.author.id}'`);
  414. con.query(`UPDATE hp SET hp = '50' WHERE id = '${message.author.id}'`);
  415. con.query(`UPDATE lvl SET lvl = '1' WHERE id = '${message.author.id}'`);
  416. con.query(`UPDATE gold SET gold = '0' WHERE id = '${message.author.id}'`);
  417. con.query(`UPDATE MaxXP SET MaxXP = '100' WHERE id = '${message.author.id}'`);
  418. }})})}})
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!