Diablox
Members-
Posts
182 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
Content Type
Profiles
Bug Tracker
Wiki
Release Notes
Forums
Downloads
Blogs
Events
Everything posted by Diablox
-
if( $val["extra_flags"]%2) $chars["gmState"] = true; But this will give notices in php
-
High Performance Tips
Diablox replied to Auntie Mangos's topic in OldInstallation, configuration & upgrades
Stop mysql server change that setting and then delete ib_logfile0 and ib_logfile1 from mysql data folder. It should work -
High Performance Tips
Diablox replied to Auntie Mangos's topic in OldInstallation, configuration & upgrades
Let it run for a while. If it runs go with this. When mysql starts to act slow then go to your config and start changing. Only thing i can point out is innodb settings innodb_buffer_pool_size=1G innodb_additional_mem_pool_size=128M innodb_log_file_size=128M innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=1 But i think that DB for 600 testers online is a little bigger then 1gb. -
Missing Table? characters.auction
Diablox replied to Morgan's topic in OldInstallation, configuration & upgrades
When you recompile your mangos you need to check all 3 databases for updates ( or start mangos and he will check it for you ). -
|PHP| Interesting Scripts for your Website
Diablox replied to Auntie Mangos's topic in Old3rd party projects
I wanted to create a simple website for MaNGOS but im very stupid when it comes to design. If someone could work out some cool design i can work on php part and create small cms for mangos -
Missing Table? characters.auction
Diablox replied to Morgan's topic in OldInstallation, configuration & upgrades
Characters.sql should be always at latest reversion but sometimes devs forget to update it . Since you are starting with mangos my advice is to compile the latest version and then try to run mangos and it will tell you what you need to apply from updates folder if there is any to apply (just read slowly). Another way is to take a look at characters DB character_db_version table where you will see what was the latest sql update file imported in your char db. Just start importing every file after that. And one more thing http://github.com/mangos/mangos/blob/master/sql/updates/README for more info -
I think he is asking where did you get the formula !?
-
High Performance Tips
Diablox replied to Auntie Mangos's topic in OldInstallation, configuration & upgrades
Only thing you need on your SSD is mysql data folder. -
|PHP| Interesting Scripts for your Website
Diablox replied to Auntie Mangos's topic in Old3rd party projects
That query only gets number of aly online. You need another one for horde. And you have double echo $total. <? require_once ( 'config.php'); $conn = mysql_connect($host, $user, $pass) or die('Connection failed: ' . mysql_error()); mysql_select_db($mangoscharacters, $conn) or die('Select DB failed: ' . mysql_error()); $query = mysql_query('SELECT race FROM characters WHERE online = 1 '); $horde = 0; $aly = 0; while($data = mysql_fetch_array($query)) { if(in_array($data['race'], array(1, 3, 4, 7, 11))) $aly ++; else $horde ++; } echo 'Horde Online: '.$horde.' Aliance Online: '.$aly; ?> -
My own contribution to this uge project : need some little help
Diablox replied to a topic in OldGeneral support
Is it just me or words Server and user friendly don't go together. -
Maybe this can help http://udbwiki.webhop.net/index.php/Item_template#AllowableClass
-
Isn't that separate db caled realmd db ?
-
Everything after connected is handled by mangosd and i think your answer are session_key, v, s rows in account table. Or i was wrong all this time
-
Here is SQL if you need it. It will extend auction time for 2 weeks. UPDATE `auctionhouse` SET `time` = `time` + 172800;
-
My players are sure it is happening when you received a heal and deadly blow in the same moment. I was unable to reproduce but i just think i was unlucky with matching those two. Anyway i can confirm this bug
-
FunkyBit i can't understand why do you need 2 new tables with so many fields. Can you put some light on that idea if you want? thx
-
.ban ftw There is no good anticheat for mangos. They all just do more harm then good.
-
Heidisql How to share the databse with someone else?
Diablox replied to a topic in OldGeneral support
I found out the answer to first question. From heidisql.com HeidiSQL - a free MySQL front-end. /on topic I think ghalan is trying to connect to remote MySQL server. Did you check is your user allowed to connect from remote hosts ? -
High Performance Tips
Diablox replied to Auntie Mangos's topic in OldInstallation, configuration & upgrades
Because the people who make Linux wants to make high-quality stable and secure OS for free, while MS just wants to earn money. -
realmd DB account_banned table
-
Divide GM commands in groups. Give each group a unique id in this order 1, 2, 4, 8, 16... and then just add sum of all group id's you want to give to one account in account table. You can easily add more command groups and even make commands repeat in some groups.
-
What are you using to compile?
-
implemented .reload creature_template.
Diablox replied to Auntie Mangos's topic in OldCore modifications
Even reloading a single NPC in some cases can lead to same problems. For example if NPC is spawned on many places and some players interact with them while you reload that single NPC.
Contact Us
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
This website is in no way associated with or endorsed by Blizzard Entertainment®