... | ... | |
---|
11 | 11 | }}} |
---|
12 | 12 | 막힌거 확인 |
---|
13 | 13 | |
---|
| 14 | {{{#!syntax javascript |
---|
| 15 | router.get(/^\/contribution\/(ip|author)\/(.+)\/edit_request$/, async function EditRequestList(req, res) { |
---|
| 16 | const ismember = req.params[0]; |
---|
| 17 | const username = req.params[1]; |
---|
| 18 | var moredata = []; |
---|
| 19 | |
---|
| 20 | var data = await curs.execute("select flags, title, namespace, rev, time, changes, log, iserq, erqnum, advance, ismember, username, loghider from history \ |
---|
| 21 | where cast(time as integer) >= ? and ismember = ? " + (username.replace(/\s/g, '') ? "and lower(username) = ?" : "and (lower(username) like '%' || ?)") + " order by cast(time as integer) desc", [ |
---|
| 22 | Number(getTime()) - 2592000000, ismember, username.toLowerCase() |
---|
| 23 | ]); |
---|
| 24 | }}} |
---|
| 25 | |
---|
| 26 | 렌더링 의외로 잘 되는듯 |
---|
| 27 | |
---|