naxpweb
-
Posts
3 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
Content Type
Profiles
Bug Tracker
Wiki
Release Notes
Forums
Downloads
Blogs
Events
Posts posted by naxpweb
-
-
Hey For anyone who is more comfortable with SVN I have a SVN setup with a Mirror updated Daily and Some extra tools that may come in handy.
Feel free to use it, and if you would like any other tools in there let me know.
I do apologize if I posted this in the wrong section it appeared to be the best topic.
Additionally this is not an official Mirror , It is a Mirror I have setup and do not claim to have permission
or been authorized to do so from the Mangos Dev Team , but I do not think there is anything against it.
Best Regards,
Naxp
[REMOVED]
-
This is http://paste2.org/p/111951
ALTER TABLE `realmcharacters` ADD COLUMN `gmlevel` tinyint(3) unsigned NOT NULL default '0' AFTER `acctid`; UPDATE TABLE `realmcharacters`, SET `realmcharacters`.`gmlevel` = `account`.`gmlevel` WHERE `account`.`id` = `realmcharacters`.`acctid`; ALTER TABLE `account` DROP COLUMN `gmlevel`;
Also not tested. Adding this feature will slowdown server so i not sure that this good for adding.
Im getting a syntax error when running the above query other than that , the performance does not seem to be affected , i had to manually assign the gm levels since I could not figure out what was wrong with the sql above , I thinking somethings out of date but its probably something silly I just dont see it
Other than that works like a charm except in the case you ahve a realm locked to a certain level , it will only allow you in if all your characters on all realms have gm levels...
Any updates would be appreciated.
[patch] BotAI
in OldCore modifications
Posted
Why not post it here for everyone?