Difference between revisions of "Test101"

From SWGANH Wiki
Jump to: navigation, search
Line 20: Line 20:
 
* http://paste.swganh.org/viewp.php?id=20080601222834-a8107ccf289592429b26b302e2263a1e
 
* http://paste.swganh.org/viewp.php?id=20080601222834-a8107ccf289592429b26b302e2263a1e
 
* http://paste.swganh.org/viewp.php?id=20080601213447-4e682ae1bf0f047958658b4433b06751
 
* http://paste.swganh.org/viewp.php?id=20080601213447-4e682ae1bf0f047958658b4433b06751
 +
 +
<pre>
 +
SELECT DISTINCT
 +
  `draft_schematic_item_link`.schematic_id,
 +
  `item_types`.id,
 +
  `item_types`.object_string
 +
FROM
 +
  `item_types`
 +
  INNER JOIN `draft_schematic_item_link` ON (`item_types`.id = `draft_schematic_item_link`.item_type),
 +
  `item_family_attribute_defaults`
 +
WHERE `item_types`.object_string like '%wearable%' AND `item_types`.object_string not like '%armor%' AND `draft_schematic_item_link`.item_family = 0 ORDER BY `item_types`.object_string;
 +
</pre>
  
  

Revision as of 01:17, 9 June 2008


SELECT DISTINCT
  `draft_schematic_item_link`.schematic_id,
  `item_types`.id,
  `item_types`.object_string
FROM
  `item_types`
  INNER JOIN `draft_schematic_item_link` ON (`item_types`.id = `draft_schematic_item_link`.item_type),
  `item_family_attribute_defaults`
WHERE `item_types`.object_string like '%wearable%' AND `item_types`.object_string not like '%armor%' AND `draft_schematic_item_link`.item_family = 0 ORDER BY `item_types`.object_string;




To-Do List for Preview

Entertainer: 

- add visual effects
- possibly add mind buffs
- add /registerlocation

General: 

- fix constant 'angry' mood upon login
- add burstrun
- add flybys to all cities
- add welcome / starting email
- add banks
- add mission population
- add survey missions
- add delivery missions
- fix /who /friend issues
- shuttle timer seems to be off by a few seconds, ie delay exists when the flap hits the ground to when you can actually use ticket
- implement backpacks
- make blue frog item selection a dynamic one (possibly tie to a table in the db where we can control what's on the frog, tying back to the item_type table)
- fix weather script to be more random
- fix schematics display in crafting tool / datapad after learning a new skill, seems to be tied to waypoints somehow.
- fix survey / sampling (wounds, proper yields, existing bugs)
- add badges for mastering professions
- region maps for bazaar search

Chat: 

- add group chat commands
- possibly implement remainder of chat packets

Crafting: 

- add Artisan schematics
- add the feature where clicking a crafting station launches the crafting session
Retrieved from "http://wiki.swganh.org/index.php?title=Test101&oldid=35415"