Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ```js
- async function processRetriveDataFromDB(rows){
- let subscriptions = new Discord.Collection()
- let ctr = 1, sql = '', description = ''
- console.log('in processRetriveDataFromDB')
- for (row of rows){
- let guildId = row.guild_id
- serverData.guilds.set(guildId, {
- id: guildId,
- name: row.name,
- stats: {
- webhooksStats: JSON.parse(row.stats_webhooks),
- reactionsStats: JSON.parse(row.stats_reactions)
- },
- welcomeMessage: row.welcome_messag,
- welcomeMessageEnable: row.welcome_message_enabled,
- defualtRoles: row.auto_roles,
- autoRolesEnable: row.auto_roles_enabled,
- botEnable: row.bot_enabled,
- premiumEnable: row.premium_enabled,
- partnersEnable: row.partners_enabled,
- emojisEnable: row.emojis_enabled,
- aemojisEnable: row.aemojis_enabled,
- members: JSON.parse(row.members),
- subscriptions: JSON.parse(row.subscriptions)
- })
- if (serverData.guilds.get(guildId).members === null || isEmpty(serverData.guilds.get(guildId).members)) {
- sql = initMembers(guildId)
- }
- }
- console.log('ready to send sql command...')
- description = 'populate DATABASE with MEMBERS data'
- sendSql(sql, description)
- function initMembers(guildId) {
- // console.log(`in initMembers`)
- serverData.guilds.get(guildId).members = new Discord.Collection()
- for (let member of client.guilds.get(guildId).members){
- let memberId = member[0]
- serverData.guilds.get(guildId).members.set(memberId, new Member(member[1]))
- let serverMember = serverData.guilds.get(guildId).members.get(memberId)
- console.log(serverMember.displayName)
- buildSql(serverMember, memberId, guildId, ctr++)
- //for debuggin purposes to limit output
- if (ctr === 2) return sql
- if (ctr === 3) return sql
- if (ctr === 4) return sql
- if (ctr === 5) return sql
- }
- function buildSql(serverMember, memberId, guildId, ctr){
- console.log(ctr)
- sql += `INSERT INTO members VALUES (${ctr}, '${memberId}', '${guildId}', '${escape(serverMember.displayName)}', '${escape(serverMember.avatarURL)}', 0, '${escape(serverMember.firstJoinedAt)}', '${escape(serverMember.joinedAt)}', 0, '${escape(serverMember.roles.toString())}', NULL);\n\n`
- function escape(value){
- if (typeof value === 'string') return value.replace(/'/g, "''")
- else return value
- }
- }
- return sql
- }
- }
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement