3,726
edits
Module:Tour stats: Difference between revisions
no edit summary
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
| Line 270: | Line 270: | ||
table.insert(wheres, "(" .. table.concat(songWheres, ' OR ') .. ")") | table.insert(wheres, "(" .. table.concat(songWheres, ' OR ') .. ")") | ||
end | end | ||
if options['acoustic'] then | if options['acoustic'] and options['acoustic'] ~= 'No' then | ||
table.insert(wheres, "live_songs.acoustic = 1") | table.insert(wheres, "live_songs.acoustic = 1") | ||
end | end | ||
if options['piano'] then | if options['piano'] and options['piano'] ~= 'No' then | ||
table.insert(wheres, "live_songs.piano = 1") | table.insert(wheres, "live_songs.piano = 1") | ||
end | end | ||
if options['soundcheck'] then | if options['soundcheck'] and options['soundcheck'] ~= 'No' then | ||
table.insert(wheres, "live_songs.soundcheck = 1") | table.insert(wheres, "live_songs.soundcheck = 1") | ||
end | end | ||
if options['prerecorded'] then | if options['prerecorded'] and options['prerecorded'] ~= 'No' then | ||
table.insert(wheres, "live_songs.prerecorded = 1") | table.insert(wheres, "live_songs.prerecorded = 1") | ||
end | end | ||
if options['vip'] then | if options['vip'] and options['vip'] ~= 'No' then | ||
table.insert(wheres, "live_songs.vip = 1") | table.insert(wheres, "live_songs.vip = 1") | ||
end | end | ||
if options['cover_artist'] then | if options['cover_artist'] and options['cover_artist'] ~= 'No' then | ||
table.insert(wheres, "live_songs.cover = \"" .. options['cover_artist'] .. "\"") | table.insert(wheres, "live_songs.cover = \"" .. options['cover_artist'] .. "\"") | ||
end | end | ||
| Line 329: | Line 329: | ||
table.insert(joins2, key .. ' = ' .. value) | table.insert(joins2, key .. ' = ' .. value) | ||
end | end | ||
local results = cargo.query( | local results = cargo.query( | ||