UPDATED: Approved Akka's Repack Update 8-26-2015

[Rainne]

I tried this on a new install and got the following errors.

I can log into my world and create a character.

Should I be concerned?

Running Update: 9062 - 2014_12_15_multiple_table_updates.sql
ERROR 1060 (42S21) at line 16: Duplicate column name 'aug_6'
Running Update: 9063 - 2014_12_24_npc_types_update.sql
Running Update: 9064 - 2014_12_24_npc_types_table_update.sql
Running Update: 9065 - 2014_12_26_merc_weaponinfo_table_update.sql
ERROR 1051 (42S02) at line 2: Unknown table 'vwmercnpctypes'
Running Update: 9066 - 2014_12_31_npc_types_default_values_update.sql
Reading manifest...

DB up to date with: 9000 - '2013_02_18_Merc_Rules_and_Tables.sql'
DB up to date with: 8000 - 'mercs.sql'

No updates need to be run...
Setting Database to Binary Version (9075
[Crash] EXCEPTION_ACCESS_VIOLATION) if not already...

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[Crash] EXCEPTION_ACCESS_VIOLATION' at line 2

[Akkadius]

Delete your db_version table in your database and start over. I don't know how in the hell you ran into that.

DROP TABLE `db_version`;

[Rainne]

I dropped the table and updates ran through with no errors. I guess I'm good to go.

I just want to add my thanks for this. I tried to manually building my own emu and the database updates were a nightmare to understand. I now have a nice base to play from.

[Akkadius]

UPDATED with 2-13-2015 stable:

http://wiki.eqemulator.org/l/wa/file...015-stable.rar

Follow same procedure in first post.

Various issues and fixes have been made since the 2-5-2015 build so I would recommend updating your repack's and servers with it.

Ran and tested on EZ and PEQ for a solid week with very very few issues.

[aoneone81]

@Akkadius, Hello do you have a readme.txt or can you list what changes/fixes you made for this 2-13-15 update? Thanks and cheers.

[Akkadius]

Originally Posted by aoneone81

@Akkadius, Hello do you have a readme.txt or can you list what changes/fixes you made for this 2-13-15 update? Thanks and cheers.

There were un-noted fixes that actually were spamming a ton of packets, I would update regardless.

== 02/09/2015 ==
Trevius: (RoF+) Setting Alt flag on characters in the Guild Management Window is now saved and functional for filtering.
Trevius: (RoF+) Guild Invites between RoF+ and previous Clients is now functional.

== 02/08/2015 ==
Kayen: Implemented npc specialability (44) COUNTER_AVOID_DAMAGE which when applied to the ATTACKING NPC will make their attacks more difficult to be avoided by riposte/dodge/parry/block.
Parama0: Negative modifer value that affects ALL avoid damage types dodge/parry/riposte/block) chance on defender. Ie (44,50 = 50 pct reduction to ALL)
Parama1: Negative modifer value that affects RIPOSTE chance on defender. Ie (44,1,0,50 = 50 pct reduction to riposte chance)
Parama2: Negative modifer value that affects PARRY chance on defender. Ie (44,1,0,0,50 = 50 pct reduction to parry chance)
Parama3: Negative modifer value that affects BLOCK chance on defender. Ie (44,1,0,0,0,50 = 50 pct reduction to block chance)
Parama4: Negative modifer value that affects DODGE chance on defender. e (44,1,0,0,0,0,50 = 50 pct reduction to dodge chance)
Example of usage: Player has Improved Dodge V (+50 pct dodge chance), you want to negate this bonus you would set 44,1,0,0,0,0,50 on your NPC.

== 02/07/2015 ==
Akkadius: Reduced #repop time dramatically by taking down hundreds of individual SELECT/DELETE/INSERT queries in routines and bringing it down to very few
See: https://www.youtube.com/watch?v=9kSFbyTBuAk

== 02/06/2015 ==
Uleat: Updated returns for Inventory and ItemInst const iterators. (const == const)
Uleat: Replaced 'iter_inst' and 'iter_contents' typedefs with their stl definitions
Uleat: Removed 'limbo' from the 'HasItem' series of checks - including lore checks. The client excludes this range and it causes issues when performing item searches - dupe lore checks were added to account for this.
Uleat: Updated command #iteminfo to show light source information and a few other things

== 02/05/2015 ==
Trevius: Fixed Environmental Damage for RoF2.

[aoneone81]

Thank you!! ^^