settings.js 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402
  1. const cheerio = require('cheerio');
  2. const {MessageEmbed, Util, MessageActionRow, MessageButton} = require('discord.js');
  3. const {defaultSettings} = require('../util/default.json');
  4. const {got} = require('../util/functions.js');
  5. const Lang = require('../util/i18n.js');
  6. const allLangs = Lang.allLangs();
  7. const Wiki = require('../util/wiki.js');
  8. var db = require('../util/database.js');
  9. /**
  10. * Processes the "settings" command.
  11. * @param {Lang} lang - The user language.
  12. * @param {import('discord.js').Message} msg - The Discord message.
  13. * @param {String[]} args - The command arguments.
  14. * @param {String} line - The command as plain text.
  15. * @param {Wiki} wiki - The wiki for the message.
  16. */
  17. function cmd_settings(lang, msg, args, line, wiki) {
  18. if ( !msg.isAdmin() ) return msg.reactEmoji('❌');
  19. db.query( 'SELECT channel, wiki, lang, role, inline, prefix FROM discord WHERE guild = $1 ORDER BY channel DESC NULLS LAST', [msg.guildId] ).then( ({rows}) => {
  20. var guild = rows.find( row => !row.channel );
  21. if ( !guild ) guild = Object.assign({
  22. role: null, inline: null,
  23. prefix: process.env.prefix
  24. }, defaultSettings);
  25. var prefix = guild.prefix;
  26. var inlinepage = ( lang.localNames.page || 'page' );
  27. var button = null;
  28. var components = [];
  29. if ( process.env.dashboard ) {
  30. button = new MessageButton().setLabel(lang.get('settings.button')).setEmoji('<:wikibot:588723255972593672>').setStyle('LINK').setURL(new URL(`/guild/${msg.guildId}/settings`, process.env.dashboard).href);
  31. components.push(new MessageActionRow().addComponents(button));
  32. }
  33. var text = lang.get('settings.missing', '`' + prefix + 'settings lang`', '`' + prefix + 'settings wiki`');
  34. if ( rows.length ) {
  35. text = lang.get('settings.current');
  36. if ( button ) text += `\n<${button.url}>`;
  37. text += '\n' + lang.get('settings.currentlang') + ' `' + allLangs.names[guild.lang] + '` - `' + prefix + 'settings lang`';
  38. if ( patreons[msg.guildId] ) text += '\n' + lang.get('settings.currentprefix') + ' `' + prefix + '` - `' + prefix + 'settings prefix`';
  39. text += '\n' + lang.get('settings.currentrole') + ' ' + ( guild.role ? `<@&${guild.role}>` : '@everyone' ) + ' - `' + prefix + 'settings role`';
  40. text += '\n' + lang.get('settings.currentinline') + ' ' + ( guild.inline ? '~~' : '' ) + '`[[' + inlinepage + ']]`' + ( guild.inline ? '~~' : '' ) + ' - `' + prefix + 'settings inline`';
  41. text += '\n' + lang.get('settings.currentwiki') + ' ' + guild.wiki + ' - `' + prefix + 'settings wiki`';
  42. text += '\n' + lang.get('settings.currentchannel') + ' `' + prefix + 'settings channel`\n';
  43. if ( rows.length === 1 ) text += lang.get('settings.nochannels');
  44. else text += rows.filter( row => row !== guild ).map( row => '<#' + row.channel.replace( /^#/, '' ) + '>: ' + ( patreons[msg.guildId] ? '`' + allLangs.names[row.lang] + '` - ' : '' ) + '<' + row.wiki + '>' + ( patreons[msg.guildId] ? ' - ' + ( row.role ? `<@&${row.role}>` : '@everyone' ) + ' - ' + ( row.inline ? '~~' : '' ) + '`[[' + inlinepage + ']]`' + ( row.inline ? '~~' : '' ) : '' ) ).join('\n');
  45. }
  46. if ( !args.length ) {
  47. return Util.splitMessage( text ).forEach( textpart => msg.replyMsg( {content: textpart, components}, true ) );
  48. }
  49. var channelId = ( msg.channel.isThread() ? msg.channel.parentId : msg.channelId );
  50. var prelang = '';
  51. args[0] = args[0].toLowerCase();
  52. if ( args[0] === 'channel' ) {
  53. prelang = 'channel ';
  54. if ( !rows.length ) return Util.splitMessage( text ).forEach( textpart => msg.replyMsg( {content: textpart, components}, true ) );
  55. var channel = rows.find( row => row.channel === channelId );
  56. if ( !channel ) channel = Object.assign({}, rows.find( row => {
  57. return ( row.channel === '#' + msg.channel.parentId );
  58. } ) || guild, {channel: channelId});
  59. text = lang.get('settings.channel current');
  60. button?.setURL(new URL(`/guild/${msg.guildId}/settings/${channelId}`, button.url).href);
  61. if ( button ) text += `\n<${button.url}>`;
  62. if ( patreons[msg.guildId] ) {
  63. text += '\n' + lang.get('settings.currentlang') + ' `' + allLangs.names[channel.lang] + '` - `' + prefix + 'settings channel lang`';
  64. text += '\n' + lang.get('settings.currentrole') + ' ' + ( channel.role ? `<@&${channel.role}>` : '@everyone' ) + ' - `' + prefix + 'settings channel role`';
  65. text += '\n' + lang.get('settings.currentinline') + ' ' + ( channel.inline ? '~~' : '' ) + '`[[' + inlinepage + ']]`' + ( channel.inline ? '~~' : '' ) + ' - `' + prefix + 'settings channel inline`';
  66. }
  67. text += '\n' + lang.get('settings.currentwiki') + ' ' + channel.wiki + ' - `' + prefix + 'settings channel wiki`';
  68. if ( !args[1] ) return msg.replyMsg( {content: text, components}, true );
  69. args[0] = args[1].toLowerCase();
  70. args[1] = args.slice(2).join(' ').toLowerCase().trim().replace( /^<\s*(.*)\s*>$/, '$1' );
  71. }
  72. else args[1] = args.slice(1).join(' ').toLowerCase().trim().replace( /^<\s*(.*)\s*>$/, '$1' );
  73. if ( args[0] === 'wiki' ) {
  74. prelang += 'wiki';
  75. var wikihelp = '\n' + lang.get('settings.wikihelp', prefix + 'settings ' + prelang);
  76. if ( !args[1] ) {
  77. if ( !rows.length ) return msg.replyMsg( {content: lang.get('settings.wikimissing') + wikihelp, components}, true );
  78. else return msg.replyMsg( {content: lang.get('settings.' + prelang) + ' ' + ( channel || guild ).wiki + wikihelp, components}, true );
  79. }
  80. if ( process.env.READONLY ) return msg.replyMsg( lang.get('general.readonly') + '\n' + process.env.invite, true );
  81. var wikinew = Wiki.fromInput(args[1]);
  82. if ( !wikinew ) {
  83. let wikisuggest = lang.get('settings.wikiinvalid') + wikihelp;
  84. //wikisuggest += '\n\n' + lang.get('settings.foundwikis') + '\n' + sites.map( site => site.wiki_display_name + ': `' + site.wiki_domain + '`' ).join('\n');
  85. return Util.splitMessage( wikisuggest ).forEach( textpart => msg.replyMsg( {content: textpart, components}, true ) );
  86. }
  87. return msg.reactEmoji('⏳', true).then( reaction => {
  88. got.get( wikinew + 'api.php?&action=query&meta=siteinfo&siprop=general&format=json', {
  89. responseType: 'text'
  90. } ).then( response => {
  91. try {
  92. response.body = JSON.parse(response.body);
  93. }
  94. catch (error) {
  95. if ( response.statusCode === 404 && typeof response.body === 'string' ) {
  96. let api = cheerio.load(response.body)('head link[rel="EditURI"]').prop('href');
  97. if ( api ) {
  98. wikinew = new Wiki(api.split('api.php?')[0], wikinew);
  99. return got.get( wikinew + 'api.php?action=query&meta=siteinfo&siprop=general&format=json' );
  100. }
  101. }
  102. }
  103. return response;
  104. } ).then( response => {
  105. var body = response.body;
  106. if ( response.statusCode !== 200 || body?.batchcomplete === undefined || !body?.query?.general ) {
  107. console.log( '- ' + response.statusCode + ': Error while testing the wiki: ' + body?.error?.info );
  108. if ( reaction ) reaction.removeEmoji();
  109. if ( body?.error?.info === 'You need read permission to use this module.' ) {
  110. return msg.replyMsg( {content: lang.get('settings.wikiinvalid_private') + wikihelp, components}, true );
  111. }
  112. msg.reactEmoji('nowiki', true);
  113. return msg.replyMsg( {content: lang.get('settings.wikiinvalid') + wikihelp, components}, true );
  114. }
  115. wikinew.updateWiki(body.query.general);
  116. var embed;
  117. if ( !wikinew.isFandom() ) {
  118. var notice = [];
  119. if ( body.query.general.generator.replace( /^MediaWiki 1\.(\d\d).*$/, '$1' ) < 30 ) {
  120. console.log( '- This wiki is using ' + body.query.general.generator + '.' );
  121. notice.push({
  122. name: 'MediaWiki',
  123. value: lang.get('test.MediaWiki', '[MediaWiki 1.30](https://www.mediawiki.org/wiki/MediaWiki_1.30)', body.query.general.generator)
  124. });
  125. }
  126. if ( notice.length ) {
  127. embed = new MessageEmbed().setAuthor( body.query.general.sitename ).setTitle( lang.get('test.notice') ).addFields( notice );
  128. }
  129. }
  130. var sql = 'UPDATE discord SET wiki = $1 WHERE guild = $2 AND wiki = $3';
  131. var sqlargs = [wikinew.href, msg.guildId, guild.wiki];
  132. if ( !rows.length ) {
  133. sql = 'INSERT INTO discord(wiki, guild, main, lang) VALUES($1, $2, $2, $3)';
  134. sqlargs[2] = lang.lang;
  135. }
  136. else if ( channel ) {
  137. sql = 'UPDATE discord SET wiki = $1 WHERE guild = $2 AND channel = $3';
  138. sqlargs[2] = channelId;
  139. if ( !rows.includes( channel ) ) {
  140. if ( channel.wiki === wikinew.href ) {
  141. if ( reaction ) reaction.removeEmoji();
  142. return msg.replyMsg( {content: lang.get('settings.' + prelang + 'changed') + ' ' + channel.wiki + wikihelp, embeds: [embed], components}, true );
  143. }
  144. sql = 'INSERT INTO discord(wiki, guild, channel, lang, role, inline, prefix) VALUES($1, $2, $3, $4, $5, $6, $7)';
  145. sqlargs.push(guild.lang, guild.role, guild.inline, guild.prefix);
  146. }
  147. }
  148. return db.query( sql, sqlargs ).then( () => {
  149. console.log( '- Settings successfully updated.' );
  150. if ( channel ) channel.wiki = wikinew.href;
  151. else {
  152. rows.forEach( row => {
  153. if ( row.channel && row.wiki === guild.wiki ) row.wiki = wikinew.href;
  154. } );
  155. guild.wiki = wikinew.href;
  156. }
  157. if ( channel || !rows.some( row => row.channel === channelId ) ) wiki = new Wiki(wikinew);
  158. if ( reaction ) reaction.removeEmoji();
  159. msg.replyMsg( {content: lang.get('settings.' + prelang + 'changed') + ' ' + wikinew + wikihelp, embeds: [embed], components}, true );
  160. var channels = rows.filter( row => row.channel && row.lang === guild.lang && row.wiki === guild.wiki && row.prefix === guild.prefix && row.role === guild.role && row.inline === guild.inline ).map( row => row.channel );
  161. if ( channels.length ) db.query( 'DELETE FROM discord WHERE channel IN (' + channels.map( (row, i) => '$' + ( i + 1 ) ).join(', ') + ')', channels ).then( () => {
  162. console.log( '- Settings successfully removed.' );
  163. }, dberror => {
  164. console.log( '- Error while removing the settings: ' + dberror );
  165. } );
  166. }, dberror => {
  167. console.log( '- Error while editing the settings: ' + dberror );
  168. msg.replyMsg( {content: lang.get('settings.save_failed'), embeds: [embed], components}, true );
  169. if ( reaction ) reaction.removeEmoji();
  170. } );
  171. }, ferror => {
  172. if ( reaction ) reaction.removeEmoji();
  173. if ( ferror.message?.startsWith( 'connect ECONNREFUSED ' ) || ferror.message?.startsWith( 'Hostname/IP does not match certificate\'s altnames: ' ) || ferror.message === 'certificate has expired' || ferror.message === 'self signed certificate' ) {
  174. console.log( '- Error while testing the wiki: No HTTPS' );
  175. return msg.replyMsg( {content: lang.get('settings.wikiinvalid_http') + wikihelp, components}, true );
  176. }
  177. console.log( '- Error while testing the wiki: ' + ferror );
  178. if ( ferror.message === `Timeout awaiting 'request' for ${got.defaults.options.timeout.request}ms` ) {
  179. return msg.replyMsg( {content: lang.get('settings.wikiinvalid_timeout') + wikihelp, components}, true );
  180. }
  181. msg.reactEmoji('nowiki', true);
  182. return msg.replyMsg( {content: lang.get('settings.wikiinvalid') + wikihelp, components}, true );
  183. } );
  184. } );
  185. }
  186. if ( args[0] === 'lang' || args[0] === 'language' ) {
  187. if ( channel && !patreons[msg.guildId] ) return msg.replyMsg( lang.get('general.patreon') + '\n<' + process.env.patreon + '>', true );
  188. prelang += 'lang';
  189. var langhelp = '\n' + lang.get('settings.langhelp', prefix + 'settings ' + prelang) + ' `' + Object.values(allLangs.names).join('`, `') + '`';
  190. if ( !args[1] ) {
  191. return msg.replyMsg( {content: lang.get('settings.' + prelang) + ' `' + allLangs.names[( channel || guild ).lang] + '`' + langhelp, files: ( msg.uploadFiles() ? [`./i18n/widgets/${( channel || guild ).lang}.png`] : [] ), components}, true );
  192. }
  193. if ( process.env.READONLY ) return msg.replyMsg( lang.get('general.readonly') + '\n' + process.env.invite, true );
  194. if ( !allLangs.map.hasOwnProperty(args[1]) ) {
  195. return msg.replyMsg( {content: lang.get('settings.langinvalid') + langhelp, components}, true );
  196. }
  197. var sql = 'UPDATE discord SET lang = $1 WHERE guild = $2 AND lang = $3';
  198. var sqlargs = [allLangs.map[args[1]], msg.guildId, guild.lang];
  199. if ( !rows.length ) {
  200. sql = 'INSERT INTO discord(lang, guild, main) VALUES($1, $2, $2)';
  201. sqlargs.pop();
  202. }
  203. else if ( channel ) {
  204. sql = 'UPDATE discord SET lang = $1 WHERE guild = $2 AND channel = $3';
  205. sqlargs[2] = channelId;
  206. if ( !rows.includes( channel ) ) {
  207. if ( channel.lang === allLangs.map[args[1]] ) {
  208. return msg.replyMsg( {content: lang.get('settings.' + prelang + 'changed') + ' `' + allLangs.names[channel.lang] + '`' + langhelp, files: ( msg.uploadFiles() ? [`./i18n/widgets/${channel.lang}.png`] : [] ), components}, true );
  209. }
  210. sql = 'INSERT INTO discord(lang, guild, channel, wiki, role, inline, prefix) VALUES($1, $2, $3, $4, $5, $6, $7)';
  211. sqlargs.push(guild.wiki, guild.role, guild.inline, guild.prefix);
  212. }
  213. }
  214. return db.query( sql, sqlargs ).then( () => {
  215. console.log( '- Settings successfully updated.' );
  216. if ( channel ) channel.lang = allLangs.map[args[1]];
  217. else {
  218. rows.forEach( row => {
  219. if ( row.channel && row.lang === guild.lang ) row.lang = allLangs.map[args[1]];
  220. } );
  221. guild.lang = allLangs.map[args[1]];
  222. if ( voice[msg.guildId] ) voice[msg.guildId] = guild.lang;
  223. }
  224. if ( channel || !patreons[msg.guildId] || !rows.some( row => row.channel === channelId ) ) lang = new Lang(allLangs.map[args[1]]);
  225. msg.replyMsg( {content: lang.get('settings.' + prelang + 'changed') + ' `' + allLangs.names[allLangs.map[args[1]]] + '`\n' + lang.get('settings.langhelp', prefix + 'settings ' + prelang) + ' `' + Object.values(allLangs.names).join('`, `') + '`', files: ( msg.uploadFiles() ? [`./i18n/widgets/${allLangs.map[args[1]]}.png`] : [] ), components}, true );
  226. var channels = rows.filter( row => row.channel && row.lang === guild.lang && row.wiki === guild.wiki && row.prefix === guild.prefix && row.role === guild.role && row.inline === guild.inline ).map( row => row.channel );
  227. if ( channels.length ) db.query( 'DELETE FROM discord WHERE channel IN (' + channels.map( (row, i) => '$' + ( i + 1 ) ).join(', ') + ')', channels ).then( () => {
  228. console.log( '- Settings successfully removed.' );
  229. }, dberror => {
  230. console.log( '- Error while removing the settings: ' + dberror );
  231. } );
  232. }, dberror => {
  233. console.log( '- Error while editing the settings: ' + dberror );
  234. msg.replyMsg( {content: lang.get('settings.save_failed'), components}, true );
  235. } );
  236. }
  237. if ( args[0] === 'role' ) {
  238. if ( channel && !patreons[msg.guildId] ) return msg.replyMsg( lang.get('general.patreon') + '\n<' + process.env.patreon + '>', true );
  239. prelang += 'role';
  240. var rolehelp = '\n' + lang.get('settings.rolehelp', prefix + 'settings ' + prelang);
  241. if ( !args[1] ) {
  242. return msg.replyMsg( {content: lang.get('settings.' + prelang) + ' ' + ( ( channel || guild ).role ? `<@&${( channel || guild ).role}>` : '@everyone' ) + rolehelp, components}, true );
  243. }
  244. if ( process.env.READONLY ) return msg.replyMsg( lang.get('general.readonly') + '\n' + process.env.invite, true );
  245. var role = null;
  246. if ( /^\d+$/.test(args[1]) ) role = msg.guild.roles.cache.get(args[1]);
  247. if ( !role ) role = msg.guild.roles.cache.find( gc => gc.name.toLowerCase() === args[1].replace( /^@/, '' ) );
  248. if ( !role && ['everyone', 'here', 'none', 'all'].includes( args[1].replace( /^@/, '' ) ) ) {
  249. role = msg.guild.roles.cache.get(msg.guildId);
  250. }
  251. if ( !role ) {
  252. return msg.replyMsg( {content: lang.get('settings.roleinvalid') + rolehelp, components}, true );
  253. }
  254. role = ( role.id === msg.guildId ? null : role.id );
  255. var sql = 'UPDATE discord SET role = $1 WHERE guild = $2';
  256. var sqlargs = [role, msg.guildId];
  257. if ( !rows.length ) {
  258. sql = 'INSERT INTO discord(role, guild, main, lang) VALUES($1, $2, $2, $3)';
  259. sqlargs.push(lang.lang);
  260. }
  261. else if ( channel ) {
  262. sql = 'UPDATE discord SET role = $1 WHERE guild = $2 AND channel = $3';
  263. sqlargs.push(channelId);
  264. if ( !rows.includes( channel ) ) {
  265. if ( channel.role === role ) {
  266. return msg.replyMsg( {content: lang.get('settings.' + prelang + 'changed') + ' ' + ( channel.role ? `<@&${channel.role}>` : '@everyone' ) + rolehelp, components}, true );
  267. }
  268. sql = 'INSERT INTO discord(role, guild, channel, wiki, lang, inline, prefix) VALUES($1, $2, $3, $4, $5, $6, $7)';
  269. sqlargs.push(guild.wiki, guild.lang, guild.inline, guild.prefix);
  270. }
  271. }
  272. else if ( guild.role ) {
  273. sql += ' AND role = $3';
  274. sqlargs.push(guild.role);
  275. }
  276. else sql += ' AND role IS NULL';
  277. return db.query( sql, sqlargs ).then( () => {
  278. console.log( '- Settings successfully updated.' );
  279. if ( channel ) channel.role = role;
  280. else {
  281. rows.forEach( row => {
  282. if ( row.channel && row.role === guild.role ) row.role = role;
  283. } );
  284. guild.role = role;
  285. }
  286. msg.replyMsg( {content: lang.get('settings.' + prelang + 'changed') + ' ' + ( role ? `<@&${role}>` : '@everyone' ) + rolehelp, components}, true );
  287. var channels = rows.filter( row => row.channel && row.lang === guild.lang && row.wiki === guild.wiki && row.prefix === guild.prefix && row.role === guild.role && row.inline === guild.inline ).map( row => row.channel );
  288. if ( channels.length ) db.query( 'DELETE FROM discord WHERE channel IN (' + channels.map( (row, i) => '$' + ( i + 1 ) ).join(', ') + ')', channels ).then( () => {
  289. console.log( '- Settings successfully removed.' );
  290. }, dberror => {
  291. console.log( '- Error while removing the settings: ' + dberror );
  292. } );
  293. }, dberror => {
  294. console.log( '- Error while editing the settings: ' + dberror );
  295. msg.replyMsg( {content: lang.get('settings.save_failed'), components}, true );
  296. } );
  297. }
  298. if ( args[0] === 'prefix' && !channel ) {
  299. if ( !patreons[msg.guildId] ) {
  300. return msg.replyMsg( lang.get('general.patreon') + '\n<' + process.env.patreon + '>', true );
  301. }
  302. var prefixhelp = '\n' + lang.get('settings.prefixhelp', prefix + 'settings prefix');
  303. args[1] = args[1].replace( /(?<!\\)_$/, ' ' ).replace( /\\([_\W])/g, '$1' );
  304. if ( !args[1].trim() ) {
  305. return msg.replyMsg( {content: lang.get('settings.prefix') + ' `' + prefix + '`' + prefixhelp, components}, true );
  306. }
  307. if ( process.env.READONLY ) return msg.replyMsg( lang.get('general.readonly') + '\n' + process.env.invite, true );
  308. if ( args[1].includes( '`' ) || args[1].includes( '\\' ) || args[1].length > 100 ) {
  309. return msg.replyMsg( {content: lang.get('settings.prefixinvalid') + prefixhelp, components}, true );
  310. }
  311. if ( args[1] === 'reset' || args[1] === 'default' ) args[1] = process.env.prefix;
  312. var sql = 'UPDATE discord SET prefix = $1 WHERE guild = $2';
  313. var sqlargs = [args[1], msg.guildId];
  314. if ( !rows.length ) {
  315. sql = 'INSERT INTO discord(prefix, guild, main, lang) VALUES($1, $2, $2, $3)';
  316. sqlargs.push(lang.lang);
  317. }
  318. return db.query( sql, sqlargs ).then( () => {
  319. console.log( '- Settings successfully updated.' );
  320. guild.prefix = args[1];
  321. msg.client.shard.broadcastEval( (discordClient, evalData) => {
  322. global.patreons[evalData.guild] = evalData.prefix;
  323. }, {context: {guild: msg.guildId, prefix: args[1]}} );
  324. msg.replyMsg( {content: lang.get('settings.prefixchanged') + ' `' + args[1] + '`\n' + lang.get('settings.prefixhelp', args[1] + 'settings prefix'), components}, true );
  325. }, dberror => {
  326. console.log( '- Error while editing the settings: ' + dberror );
  327. msg.replyMsg( {content: lang.get('settings.save_failed'), components}, true );
  328. } );
  329. }
  330. if ( args[0] === 'inline' ) {
  331. if ( channel && !patreons[msg.guildId] ) return msg.replyMsg( lang.get('general.patreon') + '\n<' + process.env.patreon + '>', true );
  332. prelang += 'inline';
  333. var toggle = 'inline ' + ( ( channel || guild ).inline ? 'disabled' : 'enabled' );
  334. var inlinehelp = '\n' + lang.get('settings.' + toggle + '.help', prefix + 'settings ' + prelang + ' toggle', inlinepage);
  335. if ( args[1] !== 'toggle' ) {
  336. return msg.replyMsg( {content: lang.get('settings.' + toggle + '.' + prelang) + inlinehelp, components}, true );
  337. }
  338. if ( process.env.READONLY ) return msg.replyMsg( lang.get('general.readonly') + '\n' + process.env.invite, true );
  339. var value = ( ( channel || guild ).inline ? null : 1 );
  340. var sql = 'UPDATE discord SET inline = $1 WHERE guild = $2';
  341. var sqlargs = [value, msg.guildId];
  342. if ( !rows.length ) {
  343. sql = 'INSERT INTO discord(inline, guild, main, lang) VALUES($1, $2, $2, $3)';
  344. sqlargs.push(lang.lang);
  345. }
  346. else if ( channel ) {
  347. sql = 'UPDATE discord SET inline = $1 WHERE guild = $2 AND channel = $3';
  348. sqlargs.push(channelId);
  349. if ( !rows.includes( channel ) ) {
  350. sql = 'INSERT INTO discord(inline, guild, channel, wiki, lang, role, prefix) VALUES($1, $2, $3, $4, $5, $6, $7)';
  351. sqlargs.push(guild.wiki, guild.lang, guild.role, guild.prefix);
  352. }
  353. }
  354. return db.query( sql, sqlargs ).then( () => {
  355. console.log( '- Settings successfully updated.' );
  356. if ( channel ) channel.inline = value;
  357. else {
  358. rows.forEach( row => {
  359. if ( row.channel && row.inline === guild.inline ) row.inline = value;
  360. } );
  361. guild.inline = value;
  362. }
  363. toggle = 'inline ' + ( ( channel || guild ).inline ? 'disabled' : 'enabled' );
  364. msg.replyMsg( {content: lang.get('settings.' + toggle + '.' + prelang + 'changed') + '\n' + lang.get('settings.' + toggle + '.help', prefix + 'settings ' + prelang + ' toggle', inlinepage), components}, true );
  365. var channels = rows.filter( row => row.channel && row.lang === guild.lang && row.wiki === guild.wiki && row.prefix === guild.prefix && row.role === guild.role && row.inline === guild.inline ).map( row => row.channel );
  366. if ( channels.length ) db.query( 'DELETE FROM discord WHERE channel IN (' + channels.map( (row, i) => '$' + ( i + 1 ) ).join(', ') + ')', channels ).then( () => {
  367. console.log( '- Settings successfully removed.' );
  368. }, dberror => {
  369. console.log( '- Error while removing the settings: ' + dberror );
  370. } );
  371. }, dberror => {
  372. console.log( '- Error while editing the settings: ' + dberror );
  373. msg.replyMsg( {content: lang.get('settings.save_failed'), components}, true );
  374. } );
  375. }
  376. return Util.splitMessage( text ).forEach( textpart => msg.replyMsg( {content: textpart, components}, true ) );
  377. }, dberror => {
  378. console.log( '- Error while getting the settings: ' + dberror );
  379. msg.reactEmoji('error', true);
  380. } );
  381. }
  382. module.exports = {
  383. name: 'settings',
  384. everyone: true,
  385. pause: true,
  386. owner: false,
  387. run: cmd_settings
  388. };