settings.js 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515
  1. const cheerio = require('cheerio');
  2. const {defaultSettings} = require('../util/default.json');
  3. const Lang = require('../util/i18n.js');
  4. const allLangs = Lang.allLangs();
  5. const Wiki = require('../util/wiki.js');
  6. const {got, db, sendMsg, hasPerm} = require('./util.js');
  7. const fieldset = {
  8. channel: '<label for="wb-settings-channel">Channel:</label>'
  9. + '<select id="wb-settings-channel" name="channel" required></select>',
  10. wiki: '<label for="wb-settings-wiki">Default Wiki:</label>'
  11. + '<input type="url" id="wb-settings-wiki" name="wiki" required>',
  12. //+ '<button type="button" id="wb-settings-wiki-search" class="collapsible">Search wiki</button>'
  13. //+ '<fieldset style="display: none;">'
  14. //+ '<legend>Wiki search</legend>'
  15. //+ '</fieldset>',
  16. lang: '<label for="wb-settings-lang">Language:</label>'
  17. + '<select id="wb-settings-lang" name="lang" required>'
  18. + Object.keys(allLangs.names).map( lang => {
  19. return `<option id="wb-settings-lang-${lang}" value="${lang}">${allLangs.names[lang]}</option>`
  20. } ).join('\n')
  21. + '</select>',
  22. role: '<label for="wb-settings-role">Minimal Role:</label>'
  23. + '<select id="wb-settings-role" name="role"></select>',
  24. prefix: '<label for="wb-settings-prefix">Prefix:</label>'
  25. + '<input type="text" id="wb-settings-prefix" name="prefix" pattern="^\\s*[^\\s`\\\\]{1,100}\\s*$" required>'
  26. + '<br>'
  27. + '<label for="wb-settings-prefix-space">Prefix ends with space:</label>'
  28. + '<input type="checkbox" id="wb-settings-prefix-space" name="prefix_space">',
  29. inline: '<label for="wb-settings-inline">Inline commands:</label>'
  30. + '<input type="checkbox" id="wb-settings-inline" name="inline">',
  31. save: '<input type="submit" id="wb-settings-save" name="save_settings">',
  32. delete: '<input type="submit" id="wb-settings-delete" name="delete_settings">'
  33. };
  34. /**
  35. * Create a settings form
  36. * @param {import('cheerio')} $ - The response body
  37. * @param {String} header - The form header
  38. * @param {Object} settings - The current settings
  39. * @param {Boolean} settings.patreon
  40. * @param {String} settings.channel
  41. * @param {String} settings.wiki
  42. * @param {String} settings.lang
  43. * @param {String} settings.role
  44. * @param {Boolean} settings.inline
  45. * @param {String} settings.prefix
  46. * @param {Object[]} guildRoles - The guild roles
  47. * @param {String} guildRoles.id
  48. * @param {String} guildRoles.name
  49. * @param {Object[]} guildChannels - The guild channels
  50. * @param {String} guildChannels.id
  51. * @param {String} guildChannels.name
  52. * @param {Number} guildChannels.userPermissions
  53. */
  54. function createForm($, header, settings, guildRoles, guildChannels = []) {
  55. var readonly = ( process.env.READONLY ? true : false );
  56. if ( settings.channel && guildChannels.userPermissions === 0 && guildChannels.name === 'UNKNOWN' ) {
  57. readonly = true;
  58. }
  59. var fields = [];
  60. if ( settings.channel ) {
  61. let channel = $('<div>').append(fieldset.channel);
  62. channel.find('#wb-settings-channel').append(
  63. ...guildChannels.map( guildChannel => {
  64. return $(`<option id="wb-settings-channel-${guildChannel.id}">`).val(guildChannel.id).text(`${guildChannel.id} – #${guildChannel.name}`)
  65. } )
  66. );
  67. if ( guildChannels.length === 1 ) {
  68. channel.find(`#wb-settings-channel-${settings.channel}`).attr('selected', '');
  69. if ( !hasPerm(guildChannels[0].userPermissions, 'VIEW_CHANNEL', 'SEND_MESSAGES') ) {
  70. readonly = true;
  71. }
  72. }
  73. else channel.find('#wb-settings-channel').prepend(
  74. $(`<option id="wb-settings-channel-default" selected>`).val('').text('-- Select a Channel --')
  75. );
  76. fields.push(channel);
  77. }
  78. let wiki = $('<div>').append(fieldset.wiki);
  79. wiki.find('#wb-settings-wiki').val(settings.wiki);
  80. fields.push(wiki);
  81. if ( !settings.channel || settings.patreon ) {
  82. let lang = $('<div>').append(fieldset.lang);
  83. lang.find(`#wb-settings-lang-${settings.lang}`).attr('selected', '');
  84. fields.push(lang);
  85. let role = $('<div>').append(fieldset.role);
  86. role.find('#wb-settings-role').append(
  87. ...guildRoles.map( guildRole => {
  88. return $(`<option id="wb-settings-role-${guildRole.id}">`).val(guildRole.id).text(`${guildRole.id} – @${guildRole.name}`)
  89. } ),
  90. $(`<option id="wb-settings-role-everyone">`).val('').text(`@everyone`),
  91. );
  92. if ( settings.role ) role.find(`#wb-settings-role-${settings.role}`).attr('selected', '');
  93. else role.find(`#wb-settings-role-everyone`).attr('selected', '');
  94. fields.push(role);
  95. let inline = $('<div>').append(fieldset.inline);
  96. if ( !settings.inline ) inline.find('#wb-settings-inline').attr('checked', '');
  97. fields.push(inline);
  98. }
  99. if ( settings.patreon && !settings.channel ) {
  100. let prefix = $('<div>').append(fieldset.prefix);
  101. prefix.find('#wb-settings-prefix').val(settings.prefix.trim());
  102. if ( settings.prefix.endsWith( ' ' ) ) {
  103. prefix.find('#wb-settings-prefix-space').attr('checked', '');
  104. }
  105. fields.push(prefix);
  106. }
  107. fields.push($(fieldset.save).val('Save'));
  108. if ( settings.channel && settings.channel !== 'new' ) {
  109. fields.push($(fieldset.delete).val('Delete').attr('onclick', `return confirm('Are you sure?');`));
  110. }
  111. var form = $('<fieldset>').append(...fields);
  112. if ( readonly ) {
  113. form.find('input').attr('readonly', '');
  114. form.find('input[type="checkbox"], option').attr('disabled', '');
  115. form.find('input[type="submit"]').remove();
  116. }
  117. return $('<form id="wb-settings" method="post" enctype="application/x-www-form-urlencoded">').append(
  118. $('<h2>').text(header),
  119. form
  120. );
  121. }
  122. /**
  123. * Let a user change settings
  124. * @param {import('http').ServerResponse} res - The server response
  125. * @param {import('cheerio')} $ - The response body
  126. * @param {import('./util.js').Guild} guild - The current guild
  127. * @param {String[]} args - The url parts
  128. */
  129. function dashboard_settings(res, $, guild, args) {
  130. db.all( 'SELECT channel, wiki, lang, role, inline, prefix, patreon FROM discord WHERE guild = ? ORDER BY channel ASC', [guild.id], function(dberror, rows) {
  131. if ( dberror ) {
  132. console.log( '- Dashboard: Error while getting the settings: ' + dberror );
  133. $('#text .description').text('Failed to load the settings!');
  134. $('.channel#settings').addClass('selected');
  135. let body = $.html();
  136. res.writeHead(200, {'Content-Length': body.length});
  137. res.write( body );
  138. return res.end();
  139. }
  140. $('#text .description').text(`These are the settings for "${guild.name}":`);
  141. if ( !rows.length ) {
  142. $('.channel#settings').addClass('selected');
  143. createForm($, 'Server-wide Settings', Object.assign({
  144. prefix: process.env.prefix
  145. }, defaultSettings), guild.roles).attr('action', `/guild/${guild.id}/settings/default`).appendTo('#text');
  146. let body = $.html();
  147. res.writeHead(200, {'Content-Length': body.length});
  148. res.write( body );
  149. return res.end();
  150. }
  151. let isPatreon = rows.some( row => row.patreon );
  152. let channellist = rows.filter( row => row.channel ).map( row => {
  153. let channel = guild.channels.find( channel => channel.id === row.channel );
  154. return ( channel || {id: row.channel, name: 'UNKNOWN', userPermissions: 0} );
  155. } ).sort( (a, b) => {
  156. return guild.channels.indexOf(a) - guild.channels.indexOf(b);
  157. } );
  158. $('#channellist #settings').after(
  159. ...channellist.map( channel => {
  160. return $('<a class="channel">').attr('id', `channel-${channel.id}`).append(
  161. $('<img>').attr('src', '/src/channel.svg'),
  162. $('<div>').text(channel.name)
  163. ).attr('href', `/guild/${guild.id}/settings/${channel.id}`).attr('title', channel.id);
  164. } ),
  165. ( process.env.READONLY || !guild.channels.filter( channel => {
  166. return ( hasPerm(channel.userPermissions, 'VIEW_CHANNEL', 'SEND_MESSAGES') && !rows.some( row => row.channel === channel.id ) );
  167. } ).length ? '' :
  168. $('<a class="channel" id="channel-new">').append(
  169. $('<img>').attr('src', '/src/channel.svg'),
  170. $('<div>').text('New channel overwrite')
  171. ).attr('href', `/guild/${guild.id}/settings/new`) )
  172. );
  173. if ( args[4] === 'new' ) {
  174. $('.channel#channel-new').addClass('selected');
  175. createForm($, 'New Channel Overwrite', Object.assign({}, rows.find( row => !row.channel ), {
  176. patreon: isPatreon,
  177. channel: 'new'
  178. }), guild.roles, guild.channels.filter( channel => {
  179. return ( hasPerm(channel.userPermissions, 'VIEW_CHANNEL', 'SEND_MESSAGES') && !rows.some( row => row.channel === channel.id ) );
  180. } )).attr('action', `/guild/${guild.id}/settings/new`).appendTo('#text');
  181. }
  182. else if ( channellist.some( channel => channel.id === args[4] ) ) {
  183. let channel = channellist.find( channel => channel.id === args[4] );
  184. $(`.channel#channel-${channel.id}`).addClass('selected');
  185. createForm($, `#${channel.name} Settings`, Object.assign({}, rows.find( row => {
  186. return row.channel === channel.id;
  187. } ), {
  188. patreon: isPatreon
  189. }), guild.roles, [channel]).attr('action', `/guild/${guild.id}/settings/${channel.id}`).appendTo('#text');
  190. }
  191. else {
  192. $('.channel#settings').addClass('selected');
  193. createForm($, 'Server-wide Settings', rows.find( row => !row.channel ), guild.roles).attr('action', `/guild/${guild.id}/settings/default`).appendTo('#text');
  194. }
  195. let body = $.html();
  196. res.writeHead(200, {'Content-Length': body.length});
  197. res.write( body );
  198. return res.end();
  199. } );
  200. }
  201. /**
  202. * Change settings
  203. * @param {Function} res - The server response
  204. * @param {import('./util.js').Settings} userSettings - The settings of the user
  205. * @param {String} guild - The id of the guild
  206. * @param {String} type - The setting to change
  207. * @param {Object} settings - The new settings
  208. * @param {String} [settings.channel]
  209. * @param {String} settings.wiki
  210. * @param {String} [settings.lang]
  211. * @param {String} [settings.role]
  212. * @param {String} [settings.inline]
  213. * @param {String} [settings.prefix]
  214. * @param {String} [settings.prefix_space]
  215. * @param {String} [settings.save_settings]
  216. * @param {String} [settings.delete_settings]
  217. */
  218. function update_settings(res, userSettings, guild, type, settings) {
  219. if ( type !== 'default' && type !== 'new' && type !== settings.channel ) {
  220. return res(`/guild/${guild}/settings?save=failed`);
  221. }
  222. if ( !settings.save_settings === !settings.delete_settings ) {
  223. return res(`/guild/${guild}/settings/${type}?save=failed`);
  224. }
  225. if ( settings.save_settings ) {
  226. if ( !settings.wiki || ( settings.lang && !( settings.lang in allLangs.names ) ) ) {
  227. return res(`/guild/${guild}/settings/${type}?save=failed`);
  228. }
  229. if ( settings.channel && !userSettings.guilds.isMember.get(guild).channels.some( channel => {
  230. return ( channel.id === settings.channel );
  231. } ) ) return res(`/guild/${guild}/settings/${type}?save=failed`);
  232. if ( settings.role && !userSettings.guilds.isMember.get(guild).roles.some( role => {
  233. return ( role.id === settings.role );
  234. } ) ) return res(`/guild/${guild}/settings/${type}?save=failed`);
  235. }
  236. if ( settings.delete_settings && ( type === 'default' || type === 'new' ) ) {
  237. return res(`/guild/${guild}/settings/${type}?save=failed`);
  238. }
  239. sendMsg( {
  240. type: 'getMember',
  241. member: userSettings.user.id,
  242. guild: guild,
  243. channel: ( type === settings.channel ? type : undefined )
  244. } ).then( response => {
  245. if ( !response ) {
  246. userSettings.guilds.notMember.set(guild, userSettings.guilds.isMember.get(guild));
  247. userSettings.guilds.isMember.delete(guild);
  248. return res(`/guild/${guild}?save=failed`);
  249. }
  250. if ( response === 'noMember' || !hasPerm(response.userPermissions, 'MANAGE_GUILD') ) {
  251. userSettings.guilds.isMember.delete(guild);
  252. return res('/?save=failed');
  253. }
  254. if ( response.message === 'noChannel' ) return db.run( 'DELETE FROM discord WHERE guild = ? AND channel = ?', [guild, type], function (delerror) {
  255. if ( delerror ) {
  256. console.log( '- Dashboard: Error while removing the settings: ' + delerror );
  257. return res(`/guild/${guild}/settings?save=failed`);
  258. }
  259. console.log( `- Dashboard: Settings successfully removed: ${guild}#${type}` );
  260. if ( settings.delete_settings ) return res(`/guild/${guild}/settings?save=success`);
  261. else return res(`/guild/${guild}/settings?save=failed`);
  262. } );
  263. if ( type === settings.channel && !hasPerm(response.userPermissions, 'VIEW_CHANNEL', 'SEND_MESSAGES') ) {
  264. return res(`/guild/${guild}/settings/${type}?save=failed`);
  265. }
  266. if ( settings.delete_settings ) return db.get( 'SELECT main.lang mainlang, main.patreon, main.lang mainwiki, main.role mainrole, main.inline maininline, old.wiki, old.lang, old.role, old.inline FROM discord main LEFT JOIN discord old ON main.guild = old.guild AND old.channel = ? WHERE main.guild = ? AND main.channel IS NULL', [type, guild], function(dberror, row) {
  267. db.run( 'DELETE FROM discord WHERE guild = ? AND channel = ?', [guild, type], function (delerror) {
  268. if ( delerror ) {
  269. console.log( '- Dashboard: Error while removing the settings: ' + delerror );
  270. return res(`/guild/${guild}/settings/${type}?save=failed`);
  271. }
  272. console.log( `- Dashboard: Settings successfully removed: ${guild}#${type}` );
  273. res(`/guild/${guild}/settings?save=success`);
  274. if ( dberror ) {
  275. console.log( '- Dashboard: Error while notifying the guild: ' + dberror );
  276. return;
  277. }
  278. if ( !row || row.wiki === null ) return;
  279. var lang = new Lang(row.mainlang);
  280. var text = lang.get('settings.dashboard.removed', `<@${userSettings.user.id}>`, `<#${type}>`);
  281. if ( row.wiki !== row.mainwiki ) text += `\n${lang.get('settings.currentwiki')} <${row.wiki}>`;
  282. if ( row.patreon ) {
  283. if ( row.lang !== row.mainlang ) text += `\n${lang.get('settings.currentlang')} \`${allLangs.names[row.lang]}\``;
  284. if ( row.role !== row.mainrole ) text += `\n${lang.get('settings.currentrole')} ` + ( row.role ? `<@&${row.role}>` : '@everyone' );
  285. if ( row.inline !== row.maininline ) text += `\n${lang.get('settings.currentinline')} ${( row.inline ? '~~' : '' )}\`[[${inlinepage}]]\`${( row.inline ? '~~' : '' )}`;
  286. }
  287. text += `\n<${new URL(`/guild/${guild}/settings`, process.env.dashboard).href}>`;
  288. sendMsg( {
  289. type: 'notifyGuild', guild, text
  290. } ).catch( error => {
  291. console.log( '- Dashboard: Error while notifying the guild: ' + error );
  292. } );
  293. } );
  294. } );
  295. var wiki = Wiki.fromInput(settings.wiki);
  296. return got.get( wiki + 'api.php?&action=query&meta=siteinfo&siprop=general|extensions&format=json' ).then( fresponse => {
  297. if ( fresponse.statusCode === 404 && typeof fresponse.body === 'string' ) {
  298. let api = cheerio.load(fresponse.body)('head link[rel="EditURI"]').prop('href');
  299. if ( api ) {
  300. wiki = new Wiki(api.split('api.php?')[0], wiki);
  301. return got.get( wiki + 'api.php?action=query&meta=siteinfo&siprop=general|extensions&format=json' );
  302. }
  303. }
  304. return fresponse;
  305. } ).then( fresponse => {
  306. return new Promise( function (resolve, reject) {
  307. db.get( 'SELECT lang, wiki, role, inline, prefix FROM discord WHERE guild = ? AND channel IS NULL', [guild], function(error, row) {
  308. if ( error ) {
  309. console.log( '- Dashboard: Error while getting the settings: ' + error );
  310. reject();
  311. }
  312. var body = fresponse.body;
  313. if ( fresponse.statusCode !== 200 || !body?.query?.general || !body?.query?.extensions ) {
  314. console.log( '- Dashboard: ' + fresponse.statusCode + ': Error while testing the wiki: ' + body?.error?.info );
  315. if ( row?.wiki === wiki.href ) resolve(row);
  316. reject();
  317. }
  318. wiki.updateWiki(body.query.general);
  319. resolve(row, body.query);
  320. } );
  321. } );
  322. }, error => {
  323. console.log( '- Dashboard: Error while testing the wiki: ' + error );
  324. return Promise.reject();
  325. } ).then( (row, query) => {
  326. var lang = new Lang(( type === 'default' && settings.lang || row.lang ));
  327. var embed;
  328. if ( !wiki.isFandom() && query ) {
  329. let notice = [];
  330. if ( query.general.generator.replace( /^MediaWiki 1\.(\d\d).*$/, '$1' ) <= 30 ) {
  331. console.log( '- Dashboard: This wiki is using ' + query.general.generator + '.' );
  332. notice.push({
  333. name: 'MediaWiki',
  334. value: lang.get('test.MediaWiki', '[MediaWiki 1.30](https://www.mediawiki.org/wiki/MediaWiki_1.30)', query.general.generator)
  335. });
  336. }
  337. if ( !query.extensions.some( extension => extension.name === 'TextExtracts' ) ) {
  338. console.log( '- Dashboard: This wiki is missing Extension:TextExtracts.' );
  339. notice.push({
  340. name: 'TextExtracts',
  341. value: lang.get('test.TextExtracts', '[TextExtracts](https://www.mediawiki.org/wiki/Extension:TextExtracts)')
  342. });
  343. }
  344. if ( !query.extensions.some( extension => extension.name === 'PageImages' ) ) {
  345. console.log( '- Dashboard: This wiki is missing Extension:PageImages.' );
  346. notice.push({
  347. name: 'PageImages',
  348. value: lang.get('test.PageImages', '[PageImages](https://www.mediawiki.org/wiki/Extension:PageImages)')
  349. });
  350. }
  351. if ( notice.length ) {
  352. embed = {
  353. author: {name: query.general.sitename},
  354. title: lang.get('test.notice'),
  355. fields: notice
  356. }
  357. }
  358. }
  359. if ( type === 'default' ) {
  360. if ( settings.channel || !settings.lang || ( !response.patreon && settings.prefix ) ) {
  361. return res(`/guild/${guild}/settings?save=failed`);
  362. }
  363. if ( settings.prefix ) {
  364. if ( !/^\s*[^\s`\\]{1,100}\s*$/.test(settings.prefix) ) {
  365. return res(`/guild/${guild}/settings?save=failed`);
  366. }
  367. settings.prefix = settings.prefix.trim().toLowerCase();
  368. if ( settings.prefix_space ) settings.prefix += ' ';
  369. }
  370. if ( !row ) return db.run( 'INSERT INTO discord(wiki, lang, role, inline, prefix, guild, main) VALUES(?, ?, ?, ?, ?, ?)', [wiki.href, settings.lang, ( settings.role || null ), ( settings.inline ? null : 1 ), ( settings.prefix || process.env.prefix ), guild, guild], function(dberror) {
  371. if ( dberror ) {
  372. console.log( '- Dashboard: Error while saving the settings: ' + dberror );
  373. return res(`/guild/${guild}/settings?save=failed`);
  374. }
  375. console.log( '- Dashboard: Settings successfully saved: ' + guild );
  376. res(`/guild/${guild}/settings?save=success`);
  377. var text = lang.get('settings.dashboard.updated', `<@${userSettings.user.id}>`);
  378. text += '\n' + lang.get('settings.currentwiki') + ` <${wiki.href}>`;
  379. text += '\n' + lang.get('settings.currentlang') + ` \`${allLangs.names[settings.lang]}\``;
  380. text += '\n' + lang.get('settings.currentrole') + ( settings.role ? ` <@&${settings.role}>` : ' @everyone' );
  381. if ( response.patreon ) {
  382. text += '\n' + lang.get('settings.currentprefix') + ` \`${settings.prefix.replace( /\\/g, '\\$&' )}\``;
  383. }
  384. text += '\n' + lang.get('settings.currentinline') + ` ${( settings.inline ? '' : '~~' )}\`[[${( lang.localNames.page || 'page' )}]]\`${( settings.inline ? '' : '~~' )}`;
  385. text += `\n<${new URL(`/guild/${guild}/settings`, process.env.dashboard).href}>`;
  386. sendMsg( {
  387. type: 'notifyGuild', guild, text, embed
  388. } ).catch( error => {
  389. console.log( '- Dashboard: Error while notifying the guild: ' + error );
  390. } );
  391. } );
  392. var diff = [];
  393. if ( row.wiki !== wiki.href ) {
  394. diff.push(lang.get('settings.currentwiki') + ` ~~<${row.wiki}>~~ → <${wiki.href}>`);
  395. }
  396. if ( row.lang !== settings.lang ) {
  397. diff.push(lang.get('settings.currentlang') + ` ~~\`${allLangs.names[row.lang]}\`~~ → \`${allLangs.names[settings.lang]}\``);
  398. }
  399. if ( response.patreon && row.prefix !== settings.prefix ) {
  400. diff.push(lang.get('settings.currentprefix') + ` ~~\`${row.prefix.replace( /\\/g, '\\$&' )}\`~~ → \`${settings.prefix.replace( /\\/g, '\\$&' )}\``);
  401. }
  402. if ( row.role !== ( settings.role || null ) ) {
  403. diff.push(lang.get('settings.currentrole') + ` ~~${( row.role ? `<@&${row.role}>` : '@everyone' )}~~ → ${( settings.role ? `<@&${settings.role}>` : '@everyone' )}`);
  404. }
  405. if ( row.inline !== ( settings.inline ? null : 1 ) ) {
  406. let inlinepage = ( lang.localNames.page || 'page' );
  407. diff.push(lang.get('settings.currentinline') + ` ${( row.inline ? '~~' : '' )}\`[[${inlinepage}]]\`${( row.inline ? '~~' : '' )} → ${( settings.inline ? '' : '~~' )}\`[[${inlinepage}]]\`${( settings.inline ? '' : '~~' )}`);
  408. }
  409. if ( diff.length ) return db.run( 'UPDATE discord SET wiki = ?, lang = ?, role = ?, inline = ?, prefix = ? WHERE guild = ? AND channel IS NULL', [wiki.href, settings.lang, ( settings.role || null ), ( settings.inline ? null : 1 ), ( settings.prefix || process.env.prefix ), guild], function(dberror) {
  410. if ( dberror ) {
  411. console.log( '- Dashboard: Error while saving the settings: ' + dberror );
  412. return res(`/guild/${guild}/settings?save=failed`);
  413. }
  414. console.log( '- Dashboard: Settings successfully saved: ' + guild );
  415. res(`/guild/${guild}/settings?save=success`);
  416. var text = lang.get('settings.dashboard.updated', `<@${userSettings.user.id}>`);
  417. text += '\n' + diff.join('\n');
  418. text += `\n<${new URL(`/guild/${guild}/settings`, process.env.dashboard).href}>`;
  419. sendMsg( {
  420. type: 'notifyGuild', guild, text, embed,
  421. prefix: settings.prefix, voice: settings.lang
  422. } ).catch( error => {
  423. console.log( '- Dashboard: Error while notifying the guild: ' + error );
  424. } );
  425. } );
  426. return res(`/guild/${guild}/settings?save=success`);
  427. }
  428. if ( !row || !settings.channel || settings.prefix ||
  429. ( !response.patreon && ( settings.lang || settings.role || settings.inline ) ) ) {
  430. return res(`/guild/${guild}/settings?save=failed`);
  431. }
  432. if ( row.wiki === wiki.href && ( !response.patreon ||
  433. ( row.lang === settings.lang && row.inline === ( settings.inline ? null : 1 ) && row.role === ( settings.role || null ) ) ) ) {
  434. if ( type === 'new' ) {
  435. return res(`/guild/${guild}/settings/${type}?save=failed`);
  436. }
  437. return db.run( 'DELETE FROM discord WHERE guild = ? AND channel = ?', [guild, type], function (delerror) {
  438. if ( delerror ) {
  439. console.log( '- Dashboard: Error while removing the settings: ' + delerror );
  440. return res(`/guild/${guild}/settings/${type}?save=failed`);
  441. }
  442. console.log( `- Dashboard: Settings successfully removed: ${guild}#${type}` );
  443. res(`/guild/${guild}/settings?save=success`);
  444. var text = lang.get('settings.dashboard.removed', `<@${userSettings.user.id}>`, `<#${type}>`);
  445. text += `\n<${new URL(`/guild/${guild}/settings`, process.env.dashboard).href}>`;
  446. sendMsg( {
  447. type: 'notifyGuild', guild, text
  448. } ).catch( error => {
  449. console.log( '- Dashboard: Error while notifying the guild: ' + error );
  450. } );
  451. } );
  452. }
  453. return db.get( 'SELECT lang, wiki, role, inline FROM discord WHERE guild = ? AND channel = ?', [guild, settings.channel], function(curerror, channel) {
  454. if ( curerror ) {
  455. console.log( '- Dashboard: Error while getting the channel settings: ' + curerror );
  456. return res(`/guild/${guild}/settings/${type}?save=failed`);
  457. }
  458. if ( !channel ) channel = row;
  459. var diff = [];
  460. if ( channel.wiki !== wiki.href ) {
  461. diff.push(lang.get('settings.currentwiki') + ` ~~<${channel.wiki}>~~ → <${wiki.href}>`);
  462. }
  463. if ( response.patreon && channel.lang !== settings.lang ) {
  464. diff.push(lang.get('settings.currentlang') + ` ~~\`${allLangs.names[channel.lang]}\`~~ → \`${allLangs.names[settings.lang]}\``);
  465. }
  466. if ( response.patreon && channel.role !== ( settings.role || null ) ) {
  467. diff.push(lang.get('settings.currentrole') + ` ~~${( channel.role ? `<@&${channel.role}>` : '@everyone' )}~~ → ${( settings.role ? `<@&${settings.role}>` : '@everyone' )}`);
  468. }
  469. if ( response.patreon && channel.inline !== ( settings.inline ? null : 1 ) ) {
  470. let inlinepage = ( lang.localNames.page || 'page' );
  471. diff.push(lang.get('settings.currentinline') + ` ${( channel.inline ? '~~' : '' )}\`[[${inlinepage}]]\`${( channel.inline ? '~~' : '' )} → ${( settings.inline ? '' : '~~' )}\`[[${inlinepage}]]\`${( settings.inline ? '' : '~~' )}`);
  472. }
  473. if ( !diff.length ) {
  474. return res(`/guild/${guild}/settings/${settings.channel}?save=success`);
  475. }
  476. let sql = 'UPDATE discord SET wiki = ?, lang = ?, role = ?, inline = ? WHERE guild = ? AND channel = ?';
  477. let sqlargs = [wiki.href, ( settings.lang || channel.lang ), ( response.patreon ? ( settings.role || null ) : channel.role ), ( response.patreon ? ( settings.inline ? null : 1 ) : channel.inline ), guild, settings.channel];
  478. if ( channel === row ) {
  479. sql = 'INSERT INTO discord(wiki, lang, role, inline, guild, channel, prefix) VALUES(?, ?, ?, ?, ?, ?)';
  480. sqlargs.push(row.prefix);
  481. }
  482. return db.run( sql, sqlargs, function(dberror) {
  483. if ( dberror ) {
  484. console.log( '- Dashboard: Error while saving the settings: ' + dberror );
  485. return res(`/guild/${guild}/settings/${type}?save=failed`);
  486. }
  487. console.log( `- Dashboard: Settings successfully saved: ${guild}#${settings.channel}` );
  488. res(`/guild/${guild}/settings/${settings.channel}?save=success`);
  489. var text = lang.get('settings.dashboard.channel', `<@${userSettings.user.id}>`, `<#${settings.channel}>`);
  490. text += '\n' + diff.join('\n');
  491. text += `\n<${new URL(`/guild/${guild}/settings/${settings.channel}`, process.env.dashboard).href}>`;
  492. sendMsg( {
  493. type: 'notifyGuild', guild, text, embed
  494. } ).catch( error => {
  495. console.log( '- Dashboard: Error while notifying the guild: ' + error );
  496. } );
  497. } );
  498. } );
  499. }, () => {
  500. return res(`/guild/${guild}/settings/${type}?save=failed`);
  501. } );
  502. }, error => {
  503. console.log( '- Dashboard: Error while getting the member: ' + error );
  504. return res(`/guild/${guild}/settings/${type}?save=failed`);
  505. } );
  506. }
  507. module.exports = {
  508. get: dashboard_settings,
  509. post: update_settings
  510. };