Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- onst sql = require('sqlite') // npm i sqlite
- sql.open("users.sqlite");
- // سو ملف اسمه users.sqlite
- client.on("ready" , () => {
- sql.run('CREATE TABLE `users` (userid TEXT , guild TEXT,xp TEXT, level TEXT)', function(err) {
- if (err) {
- return console.log("Data is relode");
- }
- console.log(`Table Created.`);
- });
- });
- // مولد اكس بي
- client.on("message" , message => {
- if(!message.guild) return;
- if(message.author.bot) return;
- sql.all('SELECT * FROM `users` WHERE `userid` = '+message.author.id+' AND `guild` = '+message.guild.id+' ').then(rows => {
- if(rows.length == 0){
- const INSERT = sql.run("INSERT INTO `users` (`userid`,`guild`,xp,`level`) VALUES ("+message.author.id+","+message.guild.id+",'5','1')");
- if (!INSERT){
- console.log("Error on inser.")
- }
- // جميع الحقوق محفوظة لدى سيرفر الفا
- // By AboKhalil , AlphaCodes -- 12.7.2020
- }else{
- var mathing = Math.floor(Math.random() * 5) + 1;
- var xpnow = Math.floor(rows[0].xp)
- var xpall = mathing+xpnow;
- var userlevel = Math.floor(rows[0].level);
- const update = sql.run("UPDATE `users` SET `xp` = "+(xpall)+" WHERE userid = "+message.author.id+" AND guild = "+message.guild.id+" ")
- if(!update) return console.log("i cant update");
- // نظام الليفلات
- // مجرد امثلة انت رتب ليفيلاتك
- if(xpall > 50 && userlevel == 1){ // level 2
- const update = sql.run("UPDATE `users` SET `level` = "+(userlevel+1)+" WHERE userid = "+message.author.id+" AND guild = "+message.guild.id+" ")
- if(!update) return console.log("i cant update");
- message.reply("New Level !! , your level now : "+(userlevel+1))
- }
- if(xpall > 150 && userlevel == 2){ // level 3
- const update = sql.run("UPDATE `users` SET `level` = "+(userlevel+1)+" WHERE userid = "+message.author.id+" AND guild = "+message.guild.id+" ")
- if(!update) return console.log("i cant update");
- message.reply("New Level !! , your level now : "+(userlevel+1))
- }
- if(xpall > 300 && userlevel == 3){ // level 4
- const update = sql.run("UPDATE `users` SET `level` = "+(userlevel+1)+" WHERE userid = "+message.author.id+" AND guild = "+message.guild.id+" ")
- if(!update) return console.log("i cant update");
- message.reply("New Level !! , your level now : "+(userlevel+1))
- }
- // جميع الحقوق محفوظة لدى سيرفر الفا
- // By AboKhalil , AlphaCodes -- 12.7.2020
- }
- })
- });
- // عرض الاكس بي حقك
- client.on("message" , message => {
- var args = message.content.split(" ");
- if (!message.guild)
- if(message.author.bot) return;
- var command = args[0];
- if (command == prefix+"xp"){
- let user = message.mentions.users.first() || client.users.cache.find(m => m.id == args[1]);
- if (!user){
- user = message.author;
- }
- sql.all('SELECT * FROM `users` WHERE `userid` = '+user.id+' AND `guild` = '+message.guild.id+' ').then(rows => {
- if(rows.length == 0){
- return message.channel.send("**لم نتمكن من العثور على اي بيانات عن الشخص**");
- }
- // جميع الحقوق محفوظة لدى سيرفر الفا
- // By AboKhalil , AlphaCodes -- 12.7.2020
- message.channel.send(`**${user.tag} have `+"`"+rows[0].xp+"`"+` xp**`)
- });
- }
- });
- // كود التوب - معدل عليه فقط ,
- client.on("message", message =>{
- var args = message.content.split(" ");
- if (!message.guild)
- if(message.author.bot) return;
- if (args[0] == prefix + "top"){
- sql.all('SELECT * FROM `users` WHERE `guild` = '+message.guild.id+' ORDER BY `xp` DESC LIMIT 5 ').then(rows => {
- let _textPointer = 1
- let _textArray = Object.values(rows);
- let _topText = _textArray.slice(0, 5).map(r =>`**`.${_textPointer++}` | <@${r.userid}> `XP: ${r.xp}`**`).sort((a, b) => a > b).join('n');
- let embed = new Discord.MessageEmbed()
- .setTitle(' 📋Guild Score Leaderboards')
- .addField(`**TOP 5 TEXT 💬**`, _topText, true)
- .setFooter(message.author.tag)
- .setColor("RANDOM")
- message.channel.send(embed).catch(e => { if(e) return message.channel.send(`**. Error; `${e.message}`**`);
- });
- });
- }
- });
- client.on("message", message => {
- var args = message.content.split(" ")
- if (!message.guild)
- if(message.author.bot) return;
- if(args[0] == prefix + "rank"){
- var rank = 1;
- var rank1;
- // جميع الحقوق محفوظة لدى سيرفر الفا
- // By AboKhalil , AlphaCodes -- 12.7.2020
- var xp = 0;
- let user = message.mentions.users.first() || client.users.cache.find(m => m.id == args[1]);
- if(!user){
- user = message.author;
- }
- sql.all('SELECT * FROM `users` WHERE `guild` = '+message.guild.id+' ORDER BY `xp` DESC ').then(rows => {
- rows.forEach(function (row) {
- if(row.userid == user.id){
- rank1 = rank;
- // جميع الحقوق محفوظة لدى سيرفر الفا
- // By AboKhalil , AlphaCodes -- 12.7.2020
- }else{
- rank += 1
- }
- });
- sql.all('SELECT * FROM `users` WHERE `userid` = '+user.id+' AND `guild` = '+message.guild.id+' ').then(rowss => {
- if(rowss.length == 0){
- return message.channel.send("**لم نتمكن من العثور على اي بيانات عن الشخص**");
- }
- let embed = new Discord.MessageEmbed()
- .setTitle('User info:')
- .addField(`**Username**`, user.tag)
- .addField(`**Rank : **`, `#${rank1} of ${rows.length} `)
- .addField(`**xp : **`, `${rowss[0].xp}`)
- .addField(`**Level : **`, `${rowss[0].level}`)
- .setFooter(" Request By : "+message.author.tag)
- message.channel.send(embed);
- // جميع الحقوق محفوظة لدى سيرفر الفا
- // By AboKhalil , AlphaCodes -- 12.7.2020
- });
- })
- }
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement