wow-masters

Hello,

I recently found lua for mangos. i thaught it would be a good idea to update it a bit more, this will never go into the repo but a good addon for everyone, since lua is a well used thing amongst private servers etc.

Todo:

Fix Script Reloading command,

Add more functions for latest lua scripts that are out there.

Fix Stability of the LUA Engine.

SVN: http://svn2.assembla.com/svn/magos-lua/

I give full credit to derex

-- Generate a new guid

ALTER TABLE item_instance ADD COLUMN guid_new INT(11) UNSIGNED AUTO_INCREMENT UNIQUE AFTER guid/*, AUTO_INCREMENT = 1000*/;

-- Item data field

UPDATE item_instance SET DATA = CONCAT(guid_new, ' ', RIGHT(DATA, LENGTH(DATA)-LENGTH(SUBSTRING_INDEX(DATA, ' ', 1))-1));

-- auctionhouse

UPDATE auctionhouse AS ah, item_instance AS it SET ah.itemguid = it.guid_new WHERE ah.itemguid = it.guid;

-- character_gifts

UPDATE character_gifts AS cg, item_instance AS it SET cg.item_guid = it.guid_new WHERE cg.item_guid = it.guid;

-- character_inventory

UPDATE character_inventory AS ci, item_instance AS it SET ci.bag = it.guid_new WHERE ci.bag = it.guid;

UPDATE character_inventory AS ci, item_instance AS it SET ci.item = it.guid_new WHERE ci.item = it.guid;

-- guild_bank_item

UPDATE guild_bank_item AS gb, item_instance AS it SET gb.item_guid = it.guid_new WHERE gb.item_guid = it.guid;

-- mail_items

UPDATE mail_items AS mi, item_instance AS it SET mi.item_guid = it.guid_new WHERE mi.item_guid = it.guid;

-- petition

UPDATE petition AS p, item_instance AS it SET p.petitionguid = it.guid_new WHERE p.petitionguid = it.guid;

-- petition_sign

UPDATE petition_sign AS ps, item_instance AS it SET ps.petitionguid = it.guid_new WHERE ps.petitionguid = it.guid;

-- Put the new guid in place

UPDATE item_instance SET guid = guid_new;

Who wrote this,

not me someone else did but would be a good idea to use it in extras.

Add to branch

Hello,

Yes it should work with the AHbot,

If compile does not work please post back here. or any errors you have got.

Hello,

I think there should be, a new section for patch updates, like core modifications. but for patches that need to be redone etc, just like under review so then people can post them, sorry more like for people to post there patches if they need work for it to cleanup under review.

Hello,

How is it possiable to add mutex locks into mangos code. i know how arcemu do it etc,

I have recently coded a multi threaded auction house for Mangos.

Wat does this do?

It will improve your performance rating if there is a lot more auctions.

V1: http://pastebin.com/DgABpwU4

V2: http://pastebin.com/fS68MwgF Added Some More Mutex Locks // clean up

V3 http://pastebin.com/rpvuDDsZ Compile Fix // More Mutex Locks

To do!

Add mutex locks.

Please reply anything else that needs doing to this patch.

Works perfectly please apply.

Hello,

I am going to try the patch myself and update you.

Should be applied.

Very important thins like this should be worked on fully!!!!

Hello,

Works perfectly

comfirmed works perfectly with latest 3.3.3 checkout.

mangos>SESSION: received unexpected opcode CMSG_GUILD_ROSTER (0x0089) the player has not logged in yet

SESSION: received not allowed opcode CMSG_LFD_PLAYER_LOCK_INFO_REQUEST (0x036E)

SESSION: received not allowed opcode CMSG_LFD_PLAYER_LOCK_INFO_REQUEST (0x036E)

SESSION: received not allowed opcode CMSG_LFD_PLAYER_LOCK_INFO_REQUEST (0x036E)

SESSION: received not allowed opcode CMSG_LFD_PARTY_LOCK_INFO_REQUEST (0x0371)

Rev: 9599

Bump,

Tested works fine

works perfectly fine,

you should try,

find + FillRaidOrPartyHealthPriorityTargets(targetUnitMap, m_caster, m_caster, radius, 3, true, false, true);

replace + FillRaidOrPartyHealthPriorityTargets(targetUnitMap, m_caster, m_caster, radius, 2, true, false, true);