Mangos + YTDB + Scriptdev2 + Changelog

**Apple** · 31-03-10, 10:10 AM

great , keep it up DJ =]

› See More: Mangos + YTDB + Scriptdev2 + Changelog

**rcpike** · 31-03-10, 02:03 PM

Nice! keep up the good work.

**delreyjr** · 31-03-10, 10:54 PM

nice!

**treetree** · 01-04-10, 10:36 AM

nice

tree

**DjAligator** · 03-04-10, 11:59 AM

YTDB 314
+ all fixes from forum;
+ spawn;
+ quest scripts
+ mob's gossip menues;
+ new templates from WDB;
+ fix spawn: Blackrock Depths
+ fix spawn: Lower Blackrock Spire
+ fix spawn: Upper Blackrock Spire
+ fix spawn: Stratholme
+ mounts models fix;
+ fix quest conditions;
+ fix some vendors;
+ fix loot;
+ mob's stats fix;
+ filling "quest_poi" and "quest_poi_points" (Thanks Blizzy) ;
+ processed 265 caches (3.3.2) - last;
+ processed 28 caches (3.3.3);

Mangos 9650 - 9667
Some corpse related clean ups.

Old bones remove code anyway was dead, so remove it.
Correct code for quest points of interest.

Adjusting field names and type, and send data accordingly to avoid client
crash not using auto-generated id.

Due to the nature of the primary keys, two tables are truncated. Be sure
to make backup if you have data you do now want to loose.

In addition, speed up load times of data from quest_poi_points, thanks
Hunuza for helping out.
Avoid corpse save at arenas also, small cleanups.
Correctly update talent free points in diff cases.

Before at .unlearn or .learn all_mytalents commands free talent points not
updated correctly.
Same for .learn all_mypettalents.
Restore action bar proper content show at spec switch.
Fixed bug with possible double remove spell.

In case when saved in DB spell remove triggering by
dependendences chain self remove attempt.
Implement '.list talents' command.

Command show really know by selected player talent ranks,
including bugged cases like 2 rank same talent known and etc.
Also command claculated count of talents and total used talent
points cost of known talent ranks.

Can be helpful in bug debuging and cheating cases.
Not include in .list talents disabled spells

Also some more cleanups in free talent points update calls.
Remove SPELL_EFFECT_TITAN_GRIP flag at related spell remove.

This let have correct state for flag at .unlearn related spell and etc.
Not only at full talent reset.
Simplify resetTalent code.

Currently all code related to deepndent spells unlern exist in removeSpell

so not need do it in special way in talentReset.
Simplify talents reset for pet case.
Implement dual talent specializations in talent switch part.

* Implement talent specs switch functionality.
* Only gossip part still not implemented.
* At update server to this commit or later character talents will be reset

with some spam in logs about wrong places talents in character_spell.
It can be ignored as part of conversion to new table support.

Thanks to all getmangos.com community members who take part
in creating and updating original dual spec patch.
Use the db-user 'mangos' instead of 'root' in the config file.

Change done for consistence with 'mangos' created in sql/create_mysql.sql

NOTE: for secirity reason better not use this user name (and password)
in real configs/MySQL.
Include entry of gameobject in gobject near command
Fix what author of [9663] messed up, and include the changes in
mangos.sql
Add another exception to IsNoStackSpellDueToSpell.
Check max. honor points on characteacter login.
Implement 57849 and ranks.

**Happymeal** · 03-04-10, 01:55 PM

Thanks Man

**atome13** · 05-04-10, 11:53 AM

thanks

**DjAligator** · 06-04-10, 05:58 AM

Mangos 9668 - 9678
Add .DS_Store to gitignore.
Restore build at some old GCC versions

Old GCC hash_map::erase not return next iterator point
Add dummy effect of spell 55364.
fix resilience applying to periodic leech auras
Add some research for spell attributes.
Updated OpenSSL to version 1.0.0.
Fixed few typos.

Conflicts:

src/game/Unit.cpp
Renamed HMACSHA1 to something that will not conflict with feature
HMACSHA256 and HMACSHA512.

Conflicts:

src/shared/Auth/AuthCrypt.cpp
src/shared/Auth/HMACSHA1.cpp
Small backport from other branch.

Conflicts:

src/game/Player.cpp
src/game/SharedDefines.h
src/game/UpdateFields.h
src/realmd/AuthCodes.h
src/shared/Auth/AuthCrypt.cpp
src/shared/Auth/HMACSHA1.cpp
Updated AuthResult enum.
Added some info about realm list and auth response packets.
Added few dbc structs and updated related enums.
Fixed realm flags enum.
Implemented SMSG_BUY_BANK_SLOT_RESULT opcode.
Fixed console spam.
How this happened?
Added one more git ignore.
Fixed VS2010 build after commits:
Commit 2e4a3ca5e6f3cb11cce5d70f45f997f158d8f908 to mangos's mangos - GitHub
8f908
Commit 0833a9c56673966e0dc2b1f4517e9bcc310c5aa1 to mangos's mangos - GitHub
c5aa1
Fix crash in ActivateSpec
Fix SPELL_DAMAGE_CLASS_NONE hit result
Not counting gems at broken item for meta gem requirements.

This is fit as cleint show meta gem state and fix cheating with gems at
broken items.
Implement ITEM_MOD_BLOCK_VALUE support in item stat mods and
enhantments.
Some comments for realmd data.

**DjAligator** · 09-04-10, 12:10 PM

Code:

Mangos 9679 - 9709
Some more research on spell attributes.
Create new table character_stats for external tools.

Added new config value to define whether it should be updated.

This table will only be updated on logout, not on periodic save.
Add config to decide whether character stats should only be saved 
on logout.
Fixed random base poinst part calculation

0 - unused, 1 -> always +1, other in ranges (rand...1) or (1..rand)
Update I***plicitDiscoverySpell/IsLootCraftingSpell and related code.
Clarify areatrigger related tables loading errors.
Clarify areatrigger related tables loading errors.

(based on 330 commit 71c1d67)
Implement AURA_252
Drop dead code in 3.x for spell 29801. 
Add helper function to check if a string is numeric

(based on DasBlub's repo commit 1d5b209)
Remove outdated spell proc data and update code for 44394 and ranks.
Code style cleanups in quest code.
Implement support weekly quests cooldowns.

Part code provided by zhenya.
Add to mangos.conf options for daily/weekly reset time.

* Quests.Daily.ResetHour (0..23) for daily quests
* Quests.Weekly.ResetWeekDay (0..6) and Quests.Weekly.ResetHour (0..23) 
for weekly quests.
* Drop time from character_queststatus_daily and use same way as weekly 
quest reset time store.
Fixed typo in daily quest reset time init.
Merge branch 'master' into 330
Fixed typo in daily/weekly flags conflict check.
fix item 47670 spell proc event
Up to date mangos_spell_check old data and add some new.
Merge branch 'master' into 330
Now BG honor marks not reawrded in BG

* And related spells not create items.
* Update code for allow creat marks for single existed case: outfield bg
  that not yet implemented in mangos.
Switch to support client 3.3.3a (build 11723)

Merge branch '330'

You need regenerate dbc/map/vmap files.

Thanks to TOM_RUS who make most work for adding 3.3.3 support. ;)
Update spell 6572 and ranks for 3.3.3
Not crash in case unknown spell expected to be learned at spec 
switch.

It will output error insteed and continue.
Fixed typo in error output string.
Fix 16972 and ranks.

Thanks to vdpqtc and darkstalker.
Include changes from [9692] to characters.sql

mangos.sql part already updated.
Fixed .pdump work after 'data' drop.

Also add `character_talent` including to pdump
Also drop save `item_text` as not used in items/mails now after switch to 
3.3.3
Drop item text ids generation.

Now item text not used as independent object (real item texts associated 
with item guid)
Update comments for two quest flags.
Fix basepoints calculation
Drop now redundent `item_text` table.

* In beggining bad news: at 3.3.3 switch has been forgoted 
item_instance.data field chnage.
  In result items with texts (mail copy in to inventory, some other) lost 
  text content.
* That why in current commit item_text droped without convertion. In 
result all itesm with texts
  will lost text. Sorry for this as i think small porblem :(
* Now text stored in item itself.
Include in pdumps more tables.

* character_account_data and then will partly included macros/settings 
local for character.
       Mostyl used account wide macros not included.
* character_declinedname
* character_equipmentsets
* character_glyphs
* character_pet_declinedname
Add to achievement_reward support gender dependent rewards.

For example for achievement 1793
Fixed typo.

This fixes assert in Player::AddQuest when quest log is full.
Correctly update next daily quest reset timestamp in DB after 
reset.
Fixed typo added by Vladimir to patch in [9704].
Also add check to prevent have NONE gender with some other for same entry
in `achievement_reward` and `locales_achievement_reward`.
Compile fix under GCC.
 change case 0 handle for basepoints calculation


YTDB316
+ All fixes from forum;
+ spawn;
+ quest scripts;
+ mob's gossip menues;
+ new templates from WDB;
+ fix fields "item_template" by WDB;
+ fix fields "quest_template" by WDB;
+ fix spawn: The Violet Hold;
+ fix spawn: The Obsidian Sanctum;
+ fix spawn: Utgarde Pinnacle;
+ processed 56 caches (3.3.3);
- last for 3.3.2;

**DjAligator** · 14-04-10, 12:37 PM

Code:

Mangos 9710 - 9748
Add gm possibilities reset talents for all specs.

* At login reset '.reset all talents' will reset all spec talents.
* New command '.reset specs' will reset its online/offline.
* Command '.reset talents' now not support offline player case.
Include in 9692_02_characters_mail.sql convertor for items.

It included in swith time sql update for use in cases not converted yes 
characters DB.
It can be not 100% safe used for already used in 3.3.3 mode chaarcters 
data.
BUT if you want you can use it at own choice ofc.

Fixed durability problem after switch. Converted non-bag items only.
Bags not have normally item text and durability.
Use enum for effect index
Update future release info in NEWS
Replace tab with spaces, just to make at least one push today.
Implement required basic elements for dual spec learn gossips.

Required DB data for real work. This is final part required at core side 
for support.

Also note that commit include

* generic implementation money cost gossip menu items so let
  implement in DB many money cost gossip operations with _fixed_ cost.
* useful CONDITION_SPELL that let implemtn menu item visible if specific
  spell known/don't known also wide used case for diff gossips.
Allow to vendor have same items in list with different extanded 
price.
Fixed [9716] sql update.
Grr... git_id tool corrupt old sql update (it drop sometime all except 
guards)
and i copy old not fixed version for restore :/
Use proper index for character_pet_declinedname in pdump code.
Drop very old item amount calculation hack code.

Use pre-calculated normal effect value as amount.
This also must fix recent item amount crafted items.
Implement Glyph of Siphon Life and fix Siphon Life proc
Updated high guids. Renamed few files. Added some comments.
Please include spell names in comments in code and and avoid its 
used in commit notes.
Finaly cleanup usage ventorslot values.

This is also fix recent showup problem buy items
from vendors in case when some items usable (and then show in list)
only for some class/races.
Temporary back to 0 player highguid.

This is resolve "none from players see each other" problem.
Please, reapply non-0 player guid only with or after this problem resolve.


Some ObjectGuid use cleanups added while reseach porblem source.
removed PlayerNotifier and related Map::UpdatePlayerVisibility 
function, used UpdateObjectVisibility instead

(based on SilverIce's repo commit e226019)
Note: this changes not affect in any good/bad way recent problem with 
player guids.
Restore map outdated format protection and copyright years.

Tom, please update in UpdateFields.h generator 2009->2010 ;)
Build equiped item data only for item's owner

This is must decrease amount of data send to network
at player enter to visibility radius for another player.

(based on SilverIce's repo commit 8c60a80)
Correct icon for one option in default gossip menu
Client not like vendor slot 0 so restore send slots counted from 1

This is must fix not selling first item in list by vendor.
Mail send related fixes in recent code.

* Avoid use explicit MailReciever/MailSender where not need.
  Types specially added for autoconvertion from common cases.

* Prevent allow copy text auction mails. It anyway store encoded data.
  Same for some another non-player mails.
Cleanup in skil steps code.

* Move step arg in SetSkill to end for make possible for it default value.

* Merge GetSkillStep function to SetSkill, base at fact that old 
GetSkillStep
  code can be != 0 only for already known spell, so at update
Remove another case hardcoded set skill step.

We not have currently way set proper set skill step at loading,
but this not required, because important only for new learned rank have 
different step.
Also drop outdated (as tested) comment.
Make Replenishment only affect its caster in arena
Removed outdated code for 33702,33697,20572
Fix proc for 53709 and ranks
Added more usable interface for grid visits

(based on SilverIce's repo commit f20f01e)
Fix number of ticks calculation for 53209 (1978 and ranks part)
Restore build on *nix

Also fix my typo in Unit::SelectRandomUnfriendlyTarget
Use local var value instead recalculation.
Update in comment indexes for SpellEntry

No real code changes.
Implement DOT related part of 54049 and ranks
Final cleanup in non proper now EffectBasePoints use.
fix spell_check.sql
Prevent adding .vsp files from VS10 to repo
Update equipment at aura transform apply/remove for creature case
Implement show realm version and build in realm list.

* Rename `realmlist`.`color` field to `realmflags`

* Client 2.x and later support show in realm list supported
  client version for specific realm.

  For client 1.x this implemented by adding version to name
  in similar way as it look in more recent clients.

  For enable version show each affected realm must have in `realmflags` 
  set
  flag 4.

  For realm work with not officially supported builds (build > last 
  suported)
  will show version 0.0.0 and correct build value.
Fixed bg template max/min per team values
Fixed startup problems after recent realmd DB.