Got Issues? Hall of Fame! Ran by SherpDaWerp.An old issue a little wonky or not working as expected? Help us fix old issues!.Want to write your own issue / see your name in here? Head on down to How-to Write an Issue!.This thread is for issue reporting, but we do have an inquiry thread for unusual issue effects right here!.Trotterdam's list with effect lines and stats.Features lots of information, including several issues, options, and their effect lines.
REALM GRINDER FACELESS CHALLENGE 1 FREE
Also feel free to look here, run by Minoa, who works somewhat closely with this thread.You may find a list of several options that we still need here!.This post is specifically for links and macros, industries, and names used in the issues. This thread is not for general questions or for requests for changes to issues.
Though it is not a necessity if you can't figure it out or feel lazy. If you could report these before each option, you'd greatly help us identify if there are any alternative options,
In place of # is the option number minus one: So, "choice-0" is option 1, "choice-1" is option 2, etc.
You should find this in the upper-right box: with the macros below please keep onto names, though.Ĥ) Try to keep italics they're tricky, I know, but if you feel like going the extra mile, please do keep them.ĥ) Right click every "accept" button and click "inspect". WHERE u.id IN (SELECT c.id FROM card AS c INNER JOIN face AS f ON c.id = f.2) Place the number, name, author and editor above the rest of the issue as such: #(number): (name) ģ) Replace things such as your capital, religion, leader, nation, currency, animal, person, people, adjective, etc. GROUP_CONCAT(CONCAT(fo.name, ':', cl.legality)) AS legalities SUM(CASE WHEN cl.format_id = 34 THEN 1 ELSE 0 END) > 0 AS pd_legal, SELECT c.id, c.layout, f.mana_cost, f.cmc, f.power, f.toughness, f.loyalty, f.type, f.text, f.search_text, f.image_name, f.hand, f.life, f.starter, f.position, f.name_ascii, f.card_id, f.name AS face_name, GROUP_CONCAT(face_name SEPARATOR '|') AS names, GROUP_CONCAT(name_ascii SEPARATOR ' // ' )ĪS name_ascii, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`card_id` ELSE '' END SEPARATOR '') AS `card_id`, GROUP_CONCAT(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN name_ascii ELSE '' END SEPARATOR '') GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN name_ascii ELSE '' END SEPARATOR '') ') AS `search_text`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`image_name` ELSE '' END SEPARATOR '') AS `image_name`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`hand` ELSE '' END SEPARATOR '') AS `hand`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`life` ELSE '' END SEPARATOR '') AS `life`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`starter` ELSE '' END SEPARATOR '') AS `starter`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`position` ELSE '' END SEPARATOR '') AS `position`, ') AS `text`, GROUP_CONCAT(`u`.`search_text` SEPARATOR ' SUM(CASE WHEN `u`.position = 1 THEN `u`.cmc ELSE 0 END)ĪS cmc, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`power` ELSE '' END SEPARATOR '') AS `power`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`toughness` ELSE '' END SEPARATOR '') AS `toughness`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`loyalty` ELSE '' END SEPARATOR '') AS `loyalty`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`type` ELSE '' END SEPARATOR '') AS `type`, GROUP_CONCAT(`u`.`text` SEPARATOR ' WHEN layout = 'split' OR layout = 'aftermath' THEN GROUP_CONCAT(face_name SEPARATOR ' // ' )ĪS name, GROUP_CONCAT(`u`.`mana_cost` SEPARATOR '|') AS `mana_cost`, GROUP_CONCAT(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN face_name ELSE '' END SEPARATOR '') GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN face_name ELSE '' END SEPARATOR '') WHEN layout = 'double-faced' OR layout = 'flip' THEN Reported on decksite by Failed to execute `INSERT INTO card_legality (format_id, card_id, legality)
0 kommentar(er)
