daily pastebin goal
17%
SHARE
TWEET

Untitled

a guest Mar 21st, 2019 43 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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.     });
RAW Paste Data
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
 
Top