settings.js 21 KB

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