sql

[Fixed] Armor encumbrance affecting buffs.

[Fixed] @warpTo command to be more accurate.

[Fixed] @mutePlayer - now mutes emotes and group chat.

[Added] @immune gm command - makes gm immune to attacks.

[Added] Statepacks (Dizzy/Stunned/Intimidated/Blinded)

[Added] Statepacks to BlueFrog.

[Database] consentList table in database - will wipe consentlists.

[Updated] consentlists now deleted when character deleted.

[Added] Groundwork for encumbranceDeltas

[TODO] Change changeArmor method to send encumbranceDeltas instead of Baselines.

LootManager object creation is now tied into ItemManagerImplementation

Added "max_drop_from_this_group" sql field to the loot manager

Deleted unneeded fields in the loottable

MAKE SURE YOU APPLY THE INCLUDED SQL updates

r601_loottable.sql

r601_lootgroup_weight.sql

LootTableManagerImplementation: Memory leak fix

[Updated] Current Creatures Loot.

[Updated] lootgroups.xls

NOTE: Devs, remember to always update swgsql.sql when ever you add an sql patch.

Added: New lootGroup_weight table. Now, each lootgroup has its own "weight" incase a creature belongs to multiple lootGroups.

Added/changed: Format LUA script line lootGroup = "0,5,56", <- creature can be in multiple lootgroups now. Each lootgroup has its own weight.

The loottable overhead has been reduced and the vectorMaps optimized. Almost no iterating anymore.

• Extended @buff command for CSRs, accepting a value now, for example: @buff 15000 for 15K buff to avoid CSRs/Devs getting in trouble

Please note that beginning from 100.000 HAM you cant equip armor anymore (msg: not enough pool points)

Fixed:

@killArea is not killing privileged player anymore

@muteChat is not muting privileged player anymore

(Re-) added:

SQL Update script with table/index optimizations.

We missed them when we changed the sql-update directory structure with Rev. 554

Farmer John

Fix: Bug where CSR command @summon will not dismount a player from vehicle leaving him at vehicle speed.

Addition: @summon works cross planet now

Fix (critical): Forbids @map to zones > 10. If a player logs in a zone > 10, the server crashes if the player logs in after the server was restarted, since the managers are not initialized for zones >10. I added zone 10 now (see next line).

Addition: CSR command @warpPlayer accepts now the target word "punish". A offending/rule violating player can be warped to zone 10 (Space) and parked there till he gets summoned back by a CSR. Dont forget to also use @mutePlayer ...

Dont forget to add the SQL scripts in the update folder (sql subdir)

Dont forget to "make config" when compiling!

Farmer John

[Updated] New sql/updates folder.

ALL NEW SQL UPDATE FILES MUST BE IN THIS FORMAT!

update_name_startRev#.sql

Ex: update_consentlist_startRev535.sql

[fixed] /consent, /unconsent, /haveconsent can now be accessed while dead.

[updated] Consent Lists are now persistent.

[required] Database update required - update_consentlist.sql. Does not require a wipe. Players without consent lists will be assigned one after logging in for the first time.

[updated] some localization strings

[added] You can now purchase round trip tickets

[added] The ability to set taxes on shuttles

[added] The ability to mark a shuttle as a starport (they're all marked that way for now until shuttleports are implemented)

[added] When buying tickets credits are now deducted

[fixed] some compiler warnings

[update] Wounds and battle fatigue are now persistent.

[database] Required - update_secondarywounds.sql - Does not require a wipe.

[added] Clone SuiBox

[added] Rezpacks

[fixed] various bugs

1. New Lua scripts

(CURRENTLY SOME CREATURES WILL BE COMMENTED OUT UNTIL I CAN FINISH THE REST OF THEM UP.)

[LET ME KNOW (KELLINA) IF YOU GET CREATURE ERRORS.]

and partly:

1. addignore <name>

2. removeignore <name>

Ignorelist is saving to the database and loading from there on login, so make sure, the attached

mySQL-script is applied !

Ignorelist works without problems for igoring tells but its not ignoring the toon

on spatial chat nor email. We iron it out...

Bugfixes:

• CRITICAL: A bug where findFriend could crash the server (malformed command like /findFriend /target name in one line)

• Findfriend Status Messages (Friend Online/Offline)

• Air-Spawn Bug: No more spawning floating in the air

• Bug where your HAM bar isnt updating (visuell) after cloning

• Some typos (Useage -> Usage)

Additions:

GM Command: warpToWP <waypoint name>

GM Command: getCords (for the cave dev team)

Changed Waypoint command (you can use /waypoint X Y <name> now, like it was in live)

(Farmer_John,Kyle,Kellina)

[sqlupdate] I updated the db. You may have to run each command in update_admin.sql manually, since I didn't know how to make an automated update that changes specific data

[updated] Admin system now can recognize different admin groups

[fixed] some compiler warnings

[Added] Secondary HAM Wounds Stubs - not hooked up to combat yet

[Added] [Image Design] : All ID functionality should work (but something inevitably will be broken - please tell me!)

[Updated] [Image Design Skill Reques] : All ID skills should now follow patch 14 skill points required)

[Added] [Stat Migration] - per post Patch 8 Rules - need an ID to make it go

[Todo] Image Designer Halo Emotes + Client but not showing updates of HairObject

[Special Thanks]: a number of people on the forums that helped collect data - you know who you are thanks!

SoapSud helped identify the long for the Image ID tent - hugely helpful!

SWG ANH: helped with a packet StatMigrationTargetsMessage - thanks a lot guys!