Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sql.get(`SELECT * FROM scores WHERE userId ="${message.author.id}"`, (err,rows)=>{
- sql.get(`SELECT * FROM scores WHERE userId ="${message.author.id}" AND guildId ="${message.guild.id}"`).then(rowguild => {
- if (!row || !rowguild) {
- sql.run(`INSERT INTO scores (
- userId, winNu ,
- loseNu,gamesNu,
- pointsFkk,points3oasm,
- pointslogo,pointsimoje,
- pointssr3h,pointsa3lam,
- xp , credit,
- level , like,
- ane , background,
- vcpoints, vclevel,
- guildId, xpguild
- ) VALUES (? ,? ,? ,? ,? ,? ,? ,? ,? ,?,?,?,?,?,?,?,?, ?, ? , ?)`, [message.author.id, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '$عني', 'default', 1, 0, message.guild.id, 0]);
- } else {
- }
- }).catch((e) => {
- console.log(e);
- sql.run(`CREATE TABLE IF NOT EXISTS scores
- (userId TEXT,
- winNu INTEGER,
- loseNu INTEGER,
- gamesNu INTEGER,
- pointsFkk INTEGER,
- points3oasm INTEGER,
- pointslogo INTEGER,
- pointsimoje INTEGER ,
- pointssr3h INTEGER,
- pointsa3lam INTEGER,
- xp INTEGER,
- credit INTEGER,
- level INTEGER,
- like INTEGER,
- ane TEXT,
- background TEXT,
- vcpoints INTEGER,
- vclevel INTEGER,
- guildId TEXT,
- xpguild INTEGER
- )`).then(() => {
- sql.run(`INSERT INTO scores (
- userId, winNu ,
- loseNu,gamesNu,
- pointsFkk,points3oasm,
- pointslogo,pointsimoje,
- pointssr3h,pointsa3lam,
- xp , credit,
- level , like,
- ane , background,
- vcpoints, vclevel, guildId, xpguild
- ) 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]);
- });
- });
- }).then(row => {
- sql.get(`SELECT * FROM scores WHERE userId ="${message.author.id}" AND guildId ="${message.guild.id}"`).then(rowguild => {
- if (!row || !rowguild) {
- sql.run(`INSERT INTO scores (
- userId, winNu ,
- loseNu,gamesNu,
- pointsFkk,points3oasm,
- pointslogo,pointsimoje,
- pointssr3h,pointsa3lam,
- xp , credit,
- level , like,
- ane , background,
- vcpoints, vclevel,
- guildId, xpguild
- ) VALUES (? ,? ,? ,? ,? ,? ,? ,? ,? ,?,?,?,?,?,?,?,?, ?, ? , ?)`, [message.author.id, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, '$عني', 'default', 1, 0, message.guild.id, 0]);
- } else {
- }
- }).catch((e) => {
- console.log(e);
- sql.run(`CREATE TABLE IF NOT EXISTS scores
- (userId TEXT,
- winNu INTEGER,
- loseNu INTEGER,
- gamesNu INTEGER,
- pointsFkk INTEGER,
- points3oasm INTEGER,
- pointslogo INTEGER,
- pointsimoje INTEGER ,
- pointssr3h INTEGER,
- pointsa3lam INTEGER,
- xp INTEGER,
- credit INTEGER,
- level INTEGER,
- like INTEGER,
- ane TEXT,
- background TEXT,
- vcpoints INTEGER,
- vclevel INTEGER,
- guildId TEXT,
- xpguild INTEGER
- )`).then(() => {
- sql.run(`INSERT INTO scores (
- userId, winNu ,
- loseNu,gamesNu,
- pointsFkk,points3oasm,
- pointslogo,pointsimoje,
- pointssr3h,pointsa3lam,
- xp , credit,
- level , like,
- ane , background,
- vcpoints, vclevel, guildId, xpguild
- ) 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]);
- });
- });
- }).catch((e) => {
- console.log(e);
- sql.run(`CREATE TABLE IF NOT EXISTS scores
- (userId TEXT,
- winNu INTEGER,
- loseNu INTEGER,
- gamesNu INTEGER,
- pointsFkk INTEGER,
- points3oasm INTEGER,
- pointslogo INTEGER,
- pointsimoje INTEGER ,
- pointssr3h INTEGER,
- pointsa3lam INTEGER,
- xp INTEGER,
- credit INTEGER,
- level INTEGER,
- like INTEGER,
- ane TEXT,
- background TEXT,
- vcpoints INTEGER,
- vclevel INTEGER,
- guildId TEXT,
- xpguild INTEGER
- )`).then(() => {
- sql.run(`INSERT INTO scores (
- userId, winNu ,
- loseNu,gamesNu,
- pointsFkk,points3oasm,
- pointslogo,pointsimoje,
- pointssr3h,pointsa3lam,
- xp , credit,
- level , like,
- ane , background,
- vcpoints, vclevel, guildId, xpguild
- ) 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]);
- });
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement