HUGE UPDATE

[Guest]

Welcome, Guest. Please login or register.
Did you miss your activation email?

1 Hour 1 Day 1 Week 1 Month Forever

Login with username, password and session length

Getting Started

Rules

Character Mover

Optimization Guide

EZ Wiki

EZ Guide

Magelo

Zone List

Spell Recipes

T10.5 Spell Recipes

Crafting Recipes

Donate

EZ Player Discord

[EZ Server Files]

EZ Server Files

EZ Client Downloads

Custom UF MiniMap

Custom UF Inventory

EQEmu Server Status

EQEmulator Home

Allakhazam Home

UFMissingFilesList

TwitchTV

[Hunter]

Some major updates in last 2 months esp the one posted today.

Go to test locally on my test server and if it works fine then I'll update EZ Server with the new source code.

This will include some major changes such as the loot system. May be better or worse, we'll fine out when its put in. But its todays changes that makes me want to update now.

http://projecteqemu.googlecode.com/svn/trunk/EQEmuServer/changelog.txt

If we use the updates possible in the next 24 hour then I'll post about it. EZ Server would probably be down for a little bit too, maybe 1 hour.

Code:

==11/27/2012==
Sorvani: fix for newly created items with unlmiited charges to actually be usable.
Sorvani: (Uleat) Lore check is now made for items inside bags being trade before the trade completes.
Akkadius: Started first works of implementing QueryServ for what it was meant to be used
Akkadius: Moved QueryServ to it's own configuration block in the eqemu_config.xml (example):
	<qsdatabase>
		<host>localhost</host>
		<port>3306</port>
		<username>root</username>
		<password>password</password>
		<db>queryserv</db>
	</qsdatabase>
Akkadius: QueryServ can now be used on a separate server and can use an entirely separate database as it was meant to
Akkadius: Added 'loottable_id` to NPC::ModifyNPCStat which also changes quest::ModifyNPCStat(identifier, newValue); as well
Akkadius: Fixed heap corruption in quest_globals that would occur if a value over 64 bytes was created
Akkadius: Changed value size in qglobals from 64 bytes to 128 bytes
Akkadius: Added #reloadworld - This command will reload every single zones Perl quests and reboot them

Perl Changes:
Akkadius: Added EVENT_DISCONNECT to global_player.pl/player.pl - Event that triggers whenever a character disconnects from the world
Akkadius: Added EVENT_CONNECT to global_player.pl/player.pl - Event that triggers whenever a character connects to the world
Akkadius: Added EVENT_TASK_UPDATE to global_player.pl/player.pl - Event that triggers whenever a donecount is incremented in a task, exports variables: $donecount, $activity_id and $task_id
Akkadius: Added EVENT_TASK_COMPLETE to global_player.pl/player.pl - Event that triggers whenever a task is complete, this can sort of be checked in EVENT_TASK_STAGE_COMPLETED already but this is more finite, exports variables: $donecount, $activity_id and $task_id
Akkadius: Added EVENT_TASK_FAIL to global_player.pl/player.pl - Event that triggers whenever a task has failed, exports variables: $task_id
Akkadius: Added $client->SignalClient($data), it uses the client as the initiator and the client that gets sent the data, good for entity_list iterations through client
Akkadius: Exported $client->AddAlternateCurrencyValue(currency_id, amount); originally created by KLS
Akkadius: Added quest::gettaskactivitydonecount(task, activity); which obviously will get the amount done in a task based on task and activity
Akkadius: Added cross zone client signalling capability by character ID: quest::crosszonesignalclientbycharid(char_id, data);
Akkadius: Added cross zone client signalling capability by character Name: quest::crosszonesignalclientbyname(Name, data);
Akkadius: Added cross zone client messaging capability by character Name: quest::crosszonemessageplayerbyname(Type, Name, Message);
Akkadius: Added the ability to flow #commands through Perl, by flow meaning if the command doesn't process through the traditional command system, it will dump the output to EVENT_SAY in player.pl/global_player.pl based on rule Chat:FlowCommandstoPerl_EVENT_SAY

QueryServ Changes:
* I plan on adding much more logging to this server, but for now I've started with the following:
* QueryServ requires rules to be enabled before packets get sent to QueryServ, otherwise World/Zone doesn't need to even craft the packets for logging
Akkadius: Logging all player kills through QueryServ, you need to have QueryServ:PlayerLogNPCKills Rule Enabled, type: 0 = Solo, 1 = Group, 2 = Raid
Akkadius: Player trades logging started but definitely not finished
Akkadius: Removed the rules system from QueryServ, rules should only be read from World/Zone

REQUIRED SQL: utils/sql/queryserv/2268_QueryServ.sql

Database Changes:
Akkadius: Added a field in `character_` called `firstlogon` that will essentially be booled true when a player logs on, it handles a characters online status between world and zone and ultimately gets used in EVENT_CONNECT
Akkadius: Completely dropped the `id` column in `quest_globals`, the (`charid`, `npcid`, `zoneid`, `name`) fields will act as the primary keys, tested and working fine. This solves capping out on ID's as they are unecessary.
Akkadius: Changed value size of `quest_globals` field `value` from 64 bytes to 128 bytes
Akkadius: Removed an AA that was causing heap corruption

REQUIRED SQL: utils/sql/svn/2268_required_updates.sql

[Strix]

Divine Intervention baseline is now correctly set to 8000HP (from 50k) (RULE: DivineInterventionHeal)

Wow - that's a LOT of changes!!  How does an update like this affect EZ's custom values?  DI being set to 8000HP (for example) will effectively make the spell useless on EZ with players who have HPs into the millions.  Does the server retain all its custom content or would this update overwrite a heap of things?

[Hunter]

That update was on 8/16 and we have that source already.

Update is going to be from loot drop changes and up.

[Natedog]

Sorvani: Tabasco sent in this bugfix: Ranged attack crash
It doesn't happen every time, but if an NPC is flagged for ranged attacks and they kill their target, the AIProcess function continues on under the assumption that the target is still available.

No wonder when my wizard gets 1 shot from Ranged it would crash the zone!! lol

[Hunter]

Everything went well with testing the new updates.

Charm Upgrades that are suppose to be 1/666 are showing chance of 0.0015 which is correct.

Everything else working as well. Going to bring down EZ Server to install new source.

Thanks Akkadius for all the really good updates!

[Camric]

Has Akkadius or others done performance testing for the new tools, such as, QueryServ?   With limited resources both in hardware and bandwidth it would be of value for Hunter to know the potential impact and the scalability for these tools prior to implementing.

Thanks for the update

[Hunter]

Updates are mostly working except NPC's can't see your qglobals which is the table that stores your flags.

I might have to revert back to our old server code if I can't figure this out.

[Secrets]

Updates are mostly working except NPC's can't see your qglobals which is the table that stores your flags.

I might have to revert back to our old server code if I can't figure this out.

I got this, don't worry!

Check out r2771.

[Hunter]

Checking now. BIG THANKS!

Will update

[Hunter]

I see 2268_required_updates.sql was updated when doing scv update but I can't see what changed, no need to run that one again?

[Secrets]

I see 2268_required_updates.sql was updated when doing scv update but I can't see what changed, no need to run that one again?

Shouldn't need to update that one, at least I don't think so. Akkadius may have added some last minute changes, at this point I would run this query:

REPLACE INTO `rule_values` VALUES ('1', 'Chat:FlowCommandstoPerl_EVENT_SAY', 'true', '');
REPLACE INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'QueryServ:PlayerLogNPCKills', 'false', '');
REPLACE INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'QueryServ:PlayerLogTrades', 'false', '');

There were only code changes after those updates. They were just so the rule appears in your database. Should boot without it but meh, up to you!

[Hunter]

Works now! Thanks secrets!

#globalview doesn't show 0 anymore, instead it gives me a list

My qglobal testing NPC's showing that they see the values too.

[Secrets]

Works now! Thanks secrets!

#globalview doesn't show 0 anymore, instead it gives me a list

My qglobal testing NPC's showing that they see the values too.

Awesome, glad to hear! If there's anything else broken you know where to contact me

[Hunter]

Oh, I'm sure I'll break stuff in the future. This current fix saved me 24 hours of hair pulling. Thanks for fast response and quick debug.

Server will probably be unlocked soon, just doing final test before unlocking.

[wolfegunr]

T6 trash mobs are dropping augs almost 80% of the time.  Something is out of whack. Also I hear HOH mobs are dropping tokens 80% of the time.

Advanced search

• Unable to log in by Chieftan [November 23, 2024, 07:04:51 am]
• Everquest Tweaks and Sett... by Pubis [November 18, 2024, 11:18:15 am]
• Broken Stuff Repair Shop ... by Draca [November 12, 2024, 08:47:03 am]
• Update to Halls of Honor by Sarthin [November 10, 2024, 04:57:40 pm]
• Halloween 2024 by clbreastmilk [November 04, 2024, 07:55:17 am]
• Some T12 Questions by Miriya [October 28, 2024, 01:38:59 pm]
• HW 2024 by Raygan [October 21, 2024, 08:03:01 am]
• Ninja Looting by zefirus [October 20, 2024, 04:55:10 pm]
• Official Guild Creation R... by Tylperion [September 15, 2024, 11:54:54 am]
• T11 Feedback Thread by Sarthin [August 28, 2024, 12:45:01 pm]
• What's next for the rest ... by Mixlor [August 27, 2024, 02:01:07 pm]
• Hard Mode NPC by Mixlor [August 06, 2024, 09:37:00 am]
• Looking for some advice (... by Draca [July 31, 2024, 10:55:17 am]
• 4th of July Event by orkiho [July 12, 2024, 07:35:22 pm]
• New Server update causing... by Mixlor [June 02, 2024, 01:01:54 am]
• Memorial Day Event by wachna [May 30, 2024, 01:52:28 pm]
• EZServer Rules by Sarthin [May 30, 2024, 01:10:12 pm]
• Fear Itself, testing week... by torotornot [May 24, 2024, 09:29:42 am]
• Fear Itself, the new Even... by kendiian [April 26, 2024, 11:48:38 pm]
• Recent & Upcoming Changes by Dokplayer2 [April 23, 2024, 10:48:30 pm]
• Issue with my epic by fangzy [April 22, 2024, 07:32:32 pm]
• Few Changes - T11, VP, Gu... by clbreastmilk [April 10, 2024, 11:32:33 am]
• Combine HoH tokens macro.... by Dbeast [April 04, 2024, 05:10:46 pm]
• Warlock self buffs by Fecs [April 04, 2024, 03:56:08 pm]

Members

• Total Members: 6156
• Latest: Rin1

Stats

• Total Posts: 65127
• Total Topics: 5066
• Online Today: 298
• Online Ever: 8678
• (December 19, 2022, 02:32:09 pm)

Users Online

Users: 0
Guests: 311
Total: 311