[Release]Arcemu r301 stats bugg fixed + teleporter npc

[soul02]

Screenshot:


Download:
Filebeam - Free Fast File Hosting

NPC ID 55555

Password: soul02

SQL update..

ALTER TABLE playerpets ADD COLUMN reset_time int(10) unsigned NOT NULL DEFAULT 0;
ALTER TABLE playerpets ADD COLUMN reset_cost int(10) NOT NULL DEFAULT 0;

ALTER TABLE `gm_tickets` DROP PRIMARY KEY;
ALTER TABLE `gm_tickets` CHANGE COLUMN `guid` `playerGuid` INTEGER NOT NULL;
ALTER TABLE `gm_tickets` ADD COLUMN `guid` INTEGER NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`guid`);
ALTER TABLE `gm_tickets` MODIFY COLUMN `guid` INTEGER NOT NULL UNIQUE;
ALTER TABLE `gm_tickets` ADD COLUMN `deleted` BIT NOT NULL DEFAULT 0;
ALTER TABLE `gm_tickets` ADD COLUMN `assignedto` INTEGER NOT NULL DEFAULT 0;
ALTER TABLE `gm_tickets` ADD COLUMN `comment` TEXT NOT NULL DEFAULT '';

credits:
Hardbass from arcemu for the code..
Sufa for sending me the patch..
Metalivo for bringing up the idea of the old old repack got stats bug fixed..
me(Soul02) for applying, edit and recompile the core

[Pedregon]

this is a very old rev = /