Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.37 KB | None | 0 0
  1. sql.get(`SELECT * FROM scores WHERE userId ="${message.author.id}"`, (err,rows)=>{
  2.  
  3. sql.get(`SELECT * FROM scores WHERE userId ="${message.author.id}" AND guildId ="${message.guild.id}"`).then(rowguild => {
  4. if (!row || !rowguild) {
  5. sql.run(`INSERT INTO scores (
  6. userId, winNu ,
  7. loseNu,gamesNu,
  8. pointsFkk,points3oasm,
  9. pointslogo,pointsimoje,
  10. pointssr3h,pointsa3lam,
  11. xp , credit,
  12. level , like,
  13. ane , background,
  14. vcpoints, vclevel,
  15. guildId, xpguild
  16. ) VALUES (? ,? ,? ,? ,? ,? ,? ,? ,? ,?,?,?,?,?,?,?,?, ?, ? , ?)`, [message.author.id, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '$عني', 'default', 1, 0, message.guild.id, 0]);
  17. } else {
  18.  
  19. }
  20. }).catch((e) => {
  21. console.log(e);
  22. sql.run(`CREATE TABLE IF NOT EXISTS scores
  23. (userId TEXT,
  24. winNu INTEGER,
  25. loseNu INTEGER,
  26. gamesNu INTEGER,
  27. pointsFkk INTEGER,
  28. points3oasm INTEGER,
  29. pointslogo INTEGER,
  30. pointsimoje INTEGER ,
  31. pointssr3h INTEGER,
  32. pointsa3lam INTEGER,
  33. xp INTEGER,
  34. credit INTEGER,
  35. level INTEGER,
  36. like INTEGER,
  37. ane TEXT,
  38. background TEXT,
  39. vcpoints INTEGER,
  40. vclevel INTEGER,
  41. guildId TEXT,
  42. xpguild INTEGER
  43. )`).then(() => {
  44. sql.run(`INSERT INTO scores (
  45. userId, winNu ,
  46. loseNu,gamesNu,
  47. pointsFkk,points3oasm,
  48. pointslogo,pointsimoje,
  49. pointssr3h,pointsa3lam,
  50. xp , credit,
  51. level , like,
  52. ane , background,
  53. vcpoints, vclevel, guildId, xpguild
  54. ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`, [message.author.id, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '$set-info', 'default', 1, 0, message.guild.id, 0]);
  55. });
  56. });
  57.  
  58. }).then(row => {
  59. sql.get(`SELECT * FROM scores WHERE userId ="${message.author.id}" AND guildId ="${message.guild.id}"`).then(rowguild => {
  60. if (!row || !rowguild) {
  61. sql.run(`INSERT INTO scores (
  62. userId, winNu ,
  63. loseNu,gamesNu,
  64. pointsFkk,points3oasm,
  65. pointslogo,pointsimoje,
  66. pointssr3h,pointsa3lam,
  67. xp , credit,
  68. level , like,
  69. ane , background,
  70. vcpoints, vclevel,
  71. guildId, xpguild
  72. ) VALUES (? ,? ,? ,? ,? ,? ,? ,? ,? ,?,?,?,?,?,?,?,?, ?, ? , ?)`, [message.author.id, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '$عني', 'default', 1, 0, message.guild.id, 0]);
  73. } else {
  74.  
  75. }
  76. }).catch((e) => {
  77. console.log(e);
  78. sql.run(`CREATE TABLE IF NOT EXISTS scores
  79. (userId TEXT,
  80. winNu INTEGER,
  81. loseNu INTEGER,
  82. gamesNu INTEGER,
  83. pointsFkk INTEGER,
  84. points3oasm INTEGER,
  85. pointslogo INTEGER,
  86. pointsimoje INTEGER ,
  87. pointssr3h INTEGER,
  88. pointsa3lam INTEGER,
  89. xp INTEGER,
  90. credit INTEGER,
  91. level INTEGER,
  92. like INTEGER,
  93. ane TEXT,
  94. background TEXT,
  95. vcpoints INTEGER,
  96. vclevel INTEGER,
  97. guildId TEXT,
  98. xpguild INTEGER
  99. )`).then(() => {
  100. sql.run(`INSERT INTO scores (
  101. userId, winNu ,
  102. loseNu,gamesNu,
  103. pointsFkk,points3oasm,
  104. pointslogo,pointsimoje,
  105. pointssr3h,pointsa3lam,
  106. xp , credit,
  107. level , like,
  108. ane , background,
  109. vcpoints, vclevel, guildId, xpguild
  110. ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`, [message.author.id, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '$set-info', 'default', 1, 0, message.guild.id, 0]);
  111. });
  112. });
  113. }).catch((e) => {
  114. console.log(e);
  115. sql.run(`CREATE TABLE IF NOT EXISTS scores
  116. (userId TEXT,
  117. winNu INTEGER,
  118. loseNu INTEGER,
  119. gamesNu INTEGER,
  120. pointsFkk INTEGER,
  121. points3oasm INTEGER,
  122. pointslogo INTEGER,
  123. pointsimoje INTEGER ,
  124. pointssr3h INTEGER,
  125. pointsa3lam INTEGER,
  126. xp INTEGER,
  127. credit INTEGER,
  128. level INTEGER,
  129. like INTEGER,
  130. ane TEXT,
  131. background TEXT,
  132. vcpoints INTEGER,
  133. vclevel INTEGER,
  134. guildId TEXT,
  135. xpguild INTEGER
  136. )`).then(() => {
  137. sql.run(`INSERT INTO scores (
  138. userId, winNu ,
  139. loseNu,gamesNu,
  140. pointsFkk,points3oasm,
  141. pointslogo,pointsimoje,
  142. pointssr3h,pointsa3lam,
  143. xp , credit,
  144. level , like,
  145. ane , background,
  146. vcpoints, vclevel, guildId, xpguild
  147. ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`, [message.author.id, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '$set-info', 'default', 1, 0, message.guild.id, 0]);
  148. });
  149. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement