Diablox
Members-
Posts
182 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
About Diablox
- Birthday 01/01/1
Diablox's Achievements
Advanced Member (3/3)
0
Reputation
-
[Help] What is best Windows or Linux for a server?
Diablox replied to tyrael's topic in OldGeneral discussion
Same here. -
Server hardware - Tegra2 based nettop box fast enough?
Diablox replied to a topic in OldGeneral support
Is it even possible to compile mangos for ARM? I think it could work with grid unload if you can compile and run. -
What DB are you using? I think those names come from pet_name_generation table in mangos DB (correct me if I'm wrong).
-
I prefer no.2 in all cases. It's easy to read (i write queries that way).
-
Set sessionkey, v, s fields to empty.
-
[HELP] Creating account with Visual Basic program (With PHP script)
Diablox replied to a topic in Old3rd party projects
https://gist.github.com/791445 Here it is then. -
https://github.com/mangos/mangos The link is a few lines above your question
-
[HELP] Creating account with Visual Basic program (With PHP script)
Diablox replied to a topic in Old3rd party projects
You didn't give a much info on what exactly should PHP script do. Just insert data in MySQL? Does it need to check if the username is free? Any other checks launcher didn't do? Link with GET requests should look like ?foo=something&bar=somethingElse http://12.34.56.789/launcher/register.php?username=USERNAME&password=PASSWORT&email=EMAIL -
Possible Bug - Players unable to delete characters properly
Diablox replied to antiroot's topic in OldBug reports
I don't see a reason to turn autocommit off. @antiroot Do you use CharDelete.Method = 1? Just curios. -
You didn't enable vmaps...
-
Happy new year to all !!!
-
Here is alternative way to delete old accounts DELETE FROM `realmd`.`account` WHERE DATE_SUB(CURDATE(),INTERVAL 365 DAY) > `last_login`; On the first look at your character_* query's you should do this one DELETE FROM `character_social` WHERE `friend` NOT IN( SELECT `guid` FROM `characters` ); Yours item delete query is very slow (at least for me). This is my version CREATE TABLE `tmp_table` ( `guid` bigint unsigned NOT NULL, PRIMARY KEY (`guid`) ) ENGINE=InnoDB; REPLACE INTO `tmp_table` SELECT `item` FROM `character_inventory`; REPLACE INTO `tmp_table` SELECT `itemguid` FROM `auction`; REPLACE INTO `tmp_table` SELECT `item_guid` FROM `guild_bank_item`; REPLACE INTO `tmp_table` SELECT `item_guid` FROM `mail_items`; REPLACE INTO `tmp_table` SELECT `item_guid` FROM `character_gifts`; DELETE FROM `item_instance` WHERE `guid` NOT IN( SELECT `guid` FROM `tmp_table` ); DROP TABLE IF EXISTS `tmp_table`;
-
Try reading the whole post not just parts...
-
Mobs should respawn in inactive grids.
Contact Us
To contact us
click here
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
Copyright © getMaNGOS. All rights Reserved.
This website is in no way associated with or endorsed by Blizzard Entertainment®
This website is in no way associated with or endorsed by Blizzard Entertainment®