Portrait frame: Difference between revisions
>Vinifera7 mNo edit summary |
|||
| Line 7: | Line 7: | ||
|tables=stackables | |tables=stackables | ||
|join=items._pageID=stackables._pageID | |join=items._pageID=stackables._pageID | ||
|where=items. | |where=items.class_id="Microtransaction" AND stackables.cosmetic_type="Social Frame" | ||
|q_limit=2000 | |q_limit=2000 | ||
|description=1 | |description=1 | ||
Revision as of 10:46, 10 September 2020
Social frames are cosmetic effects applied to the character that alter the appearance of the frame around their portrait. They are included with supporter packs.
List of social frames
The following is a list of social frames.
Lua error: Error 1054: Unknown column 'cargo__stackables.cosmetic_type' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`description` AS `items.description` FROM `cargo__items` LEFT OUTER JOIN `cargo__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) LEFT OUTER JOIN `cargo__stackables` ON ((`cargo__items`.`_pageID`=`cargo__stackables`.`_pageID`)) WHERE (`cargo__items`.`drop_enabled` = true
AND (`cargo__items`.`release_version` IS NULL OR `cargo__items`.`release_version` IS NOT NULL AND `cargo__versions`.`release_date` < 20240613112831 ) AND `cargo__items`.`base_item` IS NULL AND `cargo__items`.`base_item_id` IS NULL AND `cargo__items`.`base_item_page` IS NULL AND (`cargo__items`.`class_id`="Microtransaction" AND `cargo__stackables`.`cosmetic_type`="Social Frame")) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 2000
.