hYn77NBm

1const Discord = require("discord.js");
2const client = new Discord.Client();
3const sql = require('sqlite');
4const path = require('path');
5const ms = require('parse-ms');
6const prefix = "!";
7const yes = "<a:lima7washmok:651123727932588032>"
8const no = "<a:li7wamok:651123754558291988>"
9sql.open(path.join(__dirname, 'credits.sql')) // read sql file
10.then(() => { // then ?
11    console.log('Opened') // if the sql opened
12    sql.run(`CREATE TABLE IF NOT EXISTS creditSysteme (id VARCHAR(30), credits BIGINT, timeDaily BIGINT)`) // create new table if the table does'nt exosts
13})
14.catch(err => console.error(err)) // if the sql file does'nt exists
15client.on("message", async msg => { // event message
16    if(!msg.channel.guild) return; // channel guild
17    let men = msg.mentions.users.first() || msg.author; // the mention or the author
18    let prize =  msg.content.split(" ").slice(2).join(" ") // prize
19 
20    if(msg.content.startsWith(prefix+"credits")) { // if the message content credits do
21        if(!men || !men === undefined) return msg.channel.send("** :interrobang: | "+men.username+", I can't find "+men.username+"!**"); // undefind user
22        if(!prize) {
23        sql.get(`SELECT * FROM creditSysteme WHERE id = '${men.id}'`).then(res => { // select user from table
24            if(!res) sql.run(`INSERT INTO creditSysteme VALUES ('${men.id}', 0, 0)`) // if the user does'nt exisit in table
25            if(res) { // if user exsist
26                    msg.channel.send("**"+men.username+" :credit_card: balance is ``"+res.credits+"$``.**") // reply
27            }
28        })
29        }else{ // else ?
30            if(isNaN(prize)) return msg.channel.send(" :interrobang: | "+msg.author.username+", type the credit you need to transfer!"); // is nan :)
31            if(parseFloat(prize) === NaN) return msg.channel.send(" :interrobang: | "+msg.author.username+", type the credit you need to transfer!"); // if nan :))
32            if(men === msg.author) return; // if the men = author
33            let authorRes = await sql.get(`SELECT * FROM creditSysteme WHERE id = '${msg.author.id}'`) // select from sql
34            let userRes = await sql.get(`SELECT * FROM creditSysteme WHERE id = '${men.id}'`) // select from sql
35            if(!authorRes) sql.run(`INSERT INTO creditSysteme VALUES ('${msg.author.id}', 0, 0)`) // if !user create new col
36            if(!userRes) sql.run(`INSERT INTO creditSysteme VALUES ('${men.id}', 0, 0)`) // if !user create new col
37            let authorCredits = authorRes.credits; // credits before transfer
38            let userCredits = userRes.credits; // credits before transfer
39            let tprize = Math.floor(prize - (prize * 5/100))
40            if(prize <= 5) tprize = prize
41            if(parseFloat(prize) > authorCredits) return msg.channel.send("** :thinking: | "+msg.author.username+", Your balance is not enough for that!**"); // if the balance hight then prize
42            sql.run(`UPDATE creditSysteme SET credits = ${authorCredits - parseInt(prize)} WHERE id = '${msg.author.id}'`); // uptade credits for the author
43            sql.run(`UPDATE creditSysteme SET credits = ${userCredits + parseInt(tprize)} WHERE id = '${men.id}'`); // update credits for the mentions user
44            msg.channel.send("**:moneybag: | "+msg.author.username+", has transferred ``$"+tprize+"`` to "+men.toString()+"**") // the message :)
45            men.send(`:atm:  |  Transfer Receipt\n\`\`\`You have received $ ${tprize} from user ${msg.author.username} (ID: ${msg.author.id})\`\`\``) // the dm message :)
46        }
47    } else if(msg.content.startsWith(prefix+"daily")) {  // if the message content daily do
48        let daily = 86400000; // 24h
49        let amount = Math.floor((Math.random() * 500) + 1) // Money
50        let res = await sql.get(`SELECT * FROM creditSysteme WHERE id = '${msg.author.id}'`) // select from sql
51        if(!res) sql.run(`INSERT INTO creditSysteme VALUES ('${men.id}', 0, 0)`) // if !user create new col
52        let time = res.timeDaily; // select last daily
53        let credits = res.credits; // credits before daily
54        if(time != null && daily - (Date.now() - time) > 0) { // if already climed the daily in same day
55            let fr8 = ms(daily - (Date.now() - time)); // the remining time
56            msg.channel.send("**:stopwatch: | "+msg.author.username+", your daily :yen: credits refreshes in "+fr8.hours+" hours and "+fr8.seconds+" seconds. **") //reply
57        }else{ // if does'nt clim her daily in 24h
58            msg.channel.send("**:atm:  |  "+msg.author.username+", you received your :yen: "+amount+" daily credits!**"); // reply
59            sql.run(`UPDATE creditSysteme SET credits = ${credits + amount}, timeDaily = ${Date.now()} WHERE id = '${msg.author.id}'`); // add amount to the credits before daily
60        }
61    } else if(msg.content.startsWith(prefix+"setC")) {
62        var sacredits = msg.content.split(" ").slice(1).join(" ")
63        var sucredits = msg.content.split(" ").slice(2).join(" ")
64        var mentioned = msg.mentions.users.first().id
65        if(msg.author.bot || !msg.channel.guild || isNaN(sucredits) || parseFloat(sucredits) === NaN || isNaN(sucredits) || parseFloat(sucredits) === NaN || sucredits > 100000000 ) return msg.channel.send(no+"**Type The Amount You Want To Set!**");
66        client.fetchUser(mentioned).then((user) => {
67            userid = user
68            if(mentioned) {
69                sql.run(`UPDATE creditSysteme SET credits = '${sucredits}' WHERE id = '${mentioned}'`).then(msg.channel.send(yes+"**Donne...**"))
70            }
71            if(!mentioned) {
72                sql.run(`UPDATE creditSysteme SET credits = '${sacredits}' WHERE id = '${msg.author.id}'`).then(msg.channel.send(yes+"**Donne...**"))
73            }
74        })
75    }
76});