Test101

From SWGANH Wiki
Jump to: navigation, search
test



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

Test1

ID Label Handler Unpack Pack Class System Status
ObjController071 DataTransform 00B4B000 00AD4860 00AD4810 NetworkController Movement
ObjController0CC CombatAction 006E5210 0119C330 0119C230 ClientController Combat
ObjController0DD StartNpcConversation 0062AA10 00B12F20 00B12E70 PlayerCreatureController NPCConverse
ObjController0DE StopNpcConversation 0062AA10 00B12BD0 00B12BB0 PlayerCreatureController NPCConverse
ObjController0DF NpcConversationMessage 0062AA10 00B14FF0 00B14FD0 PlayerCreatureController NPCConverse
ObjController0E0 NpcStringList 0062AA10 00B123A0 00B12300 PlayerCreatureController NPCConverse
ObjController0E3 OpponentInfo 006E5210 00B14C60 00B14BF0 ClientController Combat
ObjController0EA HarvesterResourceData 0062AA10 00B17F00 00B17DD0 PlayerCreatureController Harvester
ObjController0EE EmptyHarvesterResponse 006E5210 00B191F0 00B191D0 ClientController Harvester
ObjController0F1 DataTransformWithParent 00B4B000 00AD43B0 00AD4360 NetworkController Movement
ObjController0F2 String 006392E0 00B12880 00B12810 CreatureController Animation
ObjController0F4 SpatialChat 0062AA10 00AEF2C0 00AEF2A0 PlayerCreatureController Spatial Chat
ObjController0F8 MissionDetailsResponse 0062AA10 00B17160 00B17120 PlayerCreatureController Missions
ObjController0FA AcceptMissionResponse 0062AA10 00B165D0 00B165B0 PlayerCreatureController Missions
ObjController0FC RemoveMissionResponse 0062AA10 00B165D0 00B165B0 PlayerCreatureController Missions
ObjController102 DraftSchematics 006E5210 00AF6D00 00AF6C70 ClientController Crafting
ObjController103 DraftSlots 006E5210 00AF7280 00AF7190 ClientController Crafting
ObjController10C CraftingIntResponse 006E5210 00B193B0 00B19390 ClientController Crafting
ObjController113 ExperimentationResponse 006E5210 00B193B0 00B19390 ClientController Crafting
ObjController115 SecureTrade 0062AA10 00AE3060 00AE3010 PlayerCreatureController Trade
ObjController117 CommandQueueRemove 0062AA10 00AE3850 00AE37E0 PlayerCreatureController Commands
ObjController12E Social 0062AA10 00AF3E70 00AF3E50 PlayerCreatureController Player Emote
ObjController131 Posture 006392E0 00B11F50 00B12090 CreatureController Posture
ObjController134 CombatSpam 0062AA10 00AEED70 00AEED50 PlayerCreatureController Combat
ObjController13B SitOnObject 006392E0 00ACE300 00ACE2E0 CreatureController Sit On Object
ObjController140 WeaponRanges 006E5210 00B11BB0 00B11B30 ClientController Combat
ObjController142 AbortMission 0062AA10 00ADE520 00ADE500 PlayerCreatureController Missions
ObjController147 ObjectMenuResponse 0062AA10 00AF35F0 00AF3510 PlayerCreatureController Radial Menu
ObjController166 SetupSwgSharedNetworkMessages 006392E0 01194F20 01194EE0 CreatureController Entertainer
ObjController167 SetupSwgSharedNetworkMessages 0062AA10 01195040 01194FF0 PlayerCreatureController Commands
ObjController1BD ShowFlyText 006E5210 00B13280 00B13260 ClientController Combat
ObjController1BE NextStageResponse 006E5210 00B193B0 00B19390 ClientController Crafting
ObjController1BF DraftSlotsQueryResponse 0062AA10 00B19CB0 00B19BF0 PlayerCreatureController Crafting
ObjController1C2 EndCraftingSession 006E5210 011951C0 01195180 ClientController Crafting
ObjController1DB BiographyUpdateMessage 0062AA10 01196180 01196130 PlayerCreatureController Biography
ObjController1E7 PlayerSearchResponse 0062AA10 01196340 011962B0 PlayerCreatureController Player Search
ObjController1FC StartingLocationsList 0062AA10 011967B0 01196720 PlayerCreatureController Starting Location
ObjController1FD SetupSwgSharedNetworkMessages 0062AA10 011965B0 01196530 PlayerCreatureController Starting Location
ObjController207 ResourceWeights 0062AA10 00B13C30 00B13A90 PlayerCreatureController Crafting
ObjController229 AddPlayerBuffMessage 006392E0 00AC81C0 00AC8190 CreatureController Buffs
ObjController22A RemovePlayerBuffMessage 006392E0 00AC80C0 00AC80A0 CreatureController Buffs
ObjController22B SetupSharedNetworkMessages 006E5210 00AC8310 00AC8300 ClientController Radial
ObjController22C SetupSharedNetworkMessages 006E5210 00AC8310 00AC8300 ClientController Radial
ObjController238 ImageDesignChangeMessage 0062AA10 00B0B990 00B0B620 PlayerCreatureController Image Design
ObjController239 ImageDesignEndMessage 0062AA10 00B0B990 00B0B620 PlayerCreatureController Image Design
ObjController23A ImageDesignStartMessage 0062AA10 00B11260 00B111C0 PlayerCreatureController Image Design
ObjController3E8 SetupSwgSharedNetworkMessages 0062AA10 01196180 01196130 PlayerCreatureController ??
ObjController3F5 SetupSharedNetworkMessages 0061C740 00AC8340 00AC8320 PlayerShipController JTL
ObjController3F6 SetupSwgSharedNetworkMessages 0062AA10 01196CD0 01196C20 PlayerCreatureController ??
ObjController3F8 ShipHit 00618850 00AC8420 00AC8400 ShipController JTL
ObjController3F9 EnvironmentalHit 00618850 00AC84C0 00AC84A0 ShipController JTL
ObjController3FE SetupSwgSharedNetworkMessages 0062AA10 01195B30 01195A70 PlayerCreatureController ??
ObjController401 SetupSharedNetworkMessages 0062AA10 00AC85C0 00AC8540 PlayerCreatureController Mediator UI
ObjController412 SetupSwgSharedNetworkMessages 0061C740 01195890 01195850 PlayerShipController JTL
ObjController413 SetupSwgSharedNetworkMessages 0061C740 01195890 01195850 PlayerShipController JTL
ObjController41D PlayerShipsList 0062AA10 01196A60 01196980 PlayerCreatureController JTL
ObjController42D JumpToSpace 0062AA10 01195B30 01195A70 PlayerCreatureController JTL
ObjController42E SetupSwgSharedNetworkMessages 0062AA10 01197240 01197230 PlayerCreatureController JTL
ObjController42F SetupSwgSharedNetworkMessages 0062AA10 01197240 01197230 PlayerCreatureController JTL
ObjController432 NebulaLightningHit 00618850 00B107A0 00B10730 ShipController JTL
ObjController437 SetupSwgSharedNetworkMessages 0062AA10 01195890 01195850 PlayerCreatureController ??
ObjController439 SetupSwgSharedNetworkMessages 0062AA10 01196EE0 01196EB0 PlayerCreatureController ??
ObjController43C SetupSwgSharedNetworkMessages 0062AA10 01195890 01195850 PlayerCreatureController Group Lottery
ObjController43D SetupSwgSharedNetworkMessages 0062AA10 01195890 01195850 PlayerCreatureController Group Lotter
ObjController440 QuestTaskCounterMessage 0062AA10 00B0F6F0 00B0F630 PlayerCreatureController Quests
ObjController441 QuestTaskTimerMessage 0062AA10 00B0F0D0 00B0F020 PlayerCreatureController Quests

Test2

ID Label Handler Unpack Pack Class System Status
ObjController071? DataTransform 00B3D250 00AD4860 00AD4810 Movement 14,2B
ObjController0ED? ResourceEmptyHopper 0099DB90 00AF6340 00AF6320 Harvesters 83
ObjController0F1? DataTransformWithParent 00B3D250 00AD43B0 00AD4360 Movement 14
ObjController0F5 MissionListRequest 00979340 00AF4980 00AF4930 Mission 83
ObjController0F9? MissionAcceptRequest 009797A0 00AF51B0 00AF5190 Mission 83
ObjController106? CraftExperiment 0098CF20 00AF5E60 00AF5DF0 Crafting 83
ObjController107? CraftFillSlot 00701AC0 00AEC2A0 00AEC240 Crafting 83
ObjController108? CraftEmptySlot 0098C190 00AF5480 00AF5430 Crafting 83
ObjController115? SecureTrade 005E13F0 00AE3060 00AE3010 Trade 23
ObjController116? CommandQueueEnqueue 0062CB50 00AE3EF0 00AE3E80 Commands 23
ObjController117? CommandQueueRemove 0062CBD0 00AE3850 00AE37E0 Commands 23
ObjController126 UseObject 00618930 00ADE520 00ADE500 Radial 83
ObjController13F? TeleportAck 0061C310 00AE3500 00AE34E0 JTL 23
ObjController142? AbortMission 00979960 00ADE520 00ADE500 Missions 83
ObjController146? ObjectMenuRequest 009698C0 00AF35F0 00AF3510 Radial 23
ObjController15A? CraftCustomization 0098C570 00AF5860 00AF57B0 Crafting 83
ObjController238? ImageDesignChangeMessage 00D9E780 00B0B990 00B0B620 Image Design 23
ObjController239? ImageDesignEndMessage 00D9D360 00B0B990 00B0B620 Image Design 23
ObjController3FA? SetupSwgSharedNetworkMessages 006189A0 01194F20 01194EE0 JTL 83
ObjController41C? RequestPlayerShips 00E29EE0 01195890 01195850 JTL 83
ObjController435? DroidCommandProgrammingMessage 00DFCED0 00B10020 00B0FEF0 JTL 23
ObjController436? SetupSwgSharedNetworkMessages 00E00570 01195890 01195850 User Interface 23
ObjController438? SetupSwgSharedNetworkMessages 00652630 01196EE0 01196EB0 JTL 23
ObjController43C? SetupSwgSharedNetworkMessages 00E35280 01195890 01195850 Group Lottery 0B
ObjController43F? SetupSwgSharedNetworkMessages 00F121F0 01197040 01196FE0 Group Lottery 23