Diablox

Any GNU/Linux is fine. I like Ubuntu, but I also use CentOS and it's fine.

Same here.

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.

https://gist.github.com/791445

Here it is then.

https://github.com/mangos/mangos

The link is a few lines above your question

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

With START TRANSACTION, autocommit remains disabled until you end the transaction with COMMIT or ROLLBACK. The autocommit mode then reverts to its previous state.

From http://dev.mysql.com/doc/refman/5.1/en/commit.html

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 !!!

--includedir=/home/necroshroom/mangos/dep/include

Why do you need this?

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`;

Mozilla's management technique doesn't suck donkey balls.

Try reading the whole post not just parts...

i got a question bout this: how are we supposed to test? what is the expected result before->after?

Mobs should respawn in inactive grids.

Maybe he is talking about Blood Prince Council. They are dead by default and they need a script to come to life.

It looks like this discussion is pointless. Mangos team will not change the way they do and i hope they don't change (also the sheep will go berserk and kill all devs. We don't want that ). If they did then mangos will be same as every other project. And trinity will run out of things to do if mangos just accepts every single patch that show up on the forums.

P.S. This is way offtopic

It's not character copy, it's character transfer, wich means old owner will not have it anymore!

Somehow i got from your post that you plan on slowly copying char from one account to another.

Anyway i have the same thing on my server and its very simple current char owner just type in username of account where he wants to move the character and its done and ofc a simple log for GM's (you never now what can go wrong).

Why do you want to copy char from one account to another? You just need to change one field in characters table...

been trying this out today/tonight and very very good starting spot. I do have trouble with the donation / voting system so far with it crashing the core when i try to send something to a player. but as far as looks and function its an amazing piece of work. ya theres small things that are buggy but if your running your own server i think you should be able to handle fixing some php and sql issues as they arrise.

Thank You

https://github.com/mangos/mangos/commit/735f5bf806a1bcb2284db4c8a9b0de6002cb0965

Opera 9.63 Same problem.

What is/was project silvermoon? :rolleyes:

DB for mangos if i'm not wrong

screen -A -m -d -S MaNGOS ./mangos-worldd

screen -A -m -d -S Realmd ./mangos-realmd

Any news & opcodes are welcome! good job mate, anyways I spoke with cromon about that...

Blizz made a new patch so they implemented new opcodes.

If you have opcode in 4.0.1, it's very easy to convert it for 4.0.3.

So there is some pattern in changes?

Unset it at the end of each loop.