How to update a ArcEmu DB to 3.3.5 (ArcEmu) GRiM Tuts! [HD]

[zsityesorban]

hey man i got problem when i try login in the server wow nothing show the realm list its empty i put 127.0.0.1 in my MSQL and Wtf file in th wow how fix it plz help

[Azilla53hearts]

Hi there.

Hamachi Server 3.3.5

this is a testing server. everyone who is boring, now you can join!!

you are a gm with full commands!

Network ID: spacekick

Password: 123

[zetto23]

this is the content of "3464_death_state.sql". you can execute as query with 2 clicks in heidi:

ALTER TABLE `creature_spawns` ADD `death_state` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `standstate`;

ALTER TABLE `creature_staticspawns` ADD `death_state` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `standstate`;

UPDATE creature_spawns cs INNER JOIN creature_proto cp ON cs.Entry = cp.Entry SET cs.death_state = cp.death_state;

ALTER TABLE `creature_proto` DROP `death_state`;

[BreatzBoy]

@zetto23 cool they made one! :D I made this before that was made.

[zetto23]

nice video. BUT:

to fix the walking speeds and other issues, instead of following this video

1. get the latest arcemu from their svn :

arcemu info/wiki/index php?title=Getting_the_source_c­ode

2. locate the folder ..\sql\world_updates

3. execute all the updates you need into your world db. (you will at least need "3464_death_state.sql" and everything after that.). you can use navicat, heidi-sql or whatever you want.

4. done. walking speed working fine

[Meganoob1992]

i have an arcemu server.

i have a couple of problems,

1. i can´t spawn items with the ; .additem . why?

2. no enemys in instance. why?

how can if fix that? pls help me

[AroundBLiIx]

awsome repack just all npcs are so fast there are running with a big speed and they are running not walking how can i fix this i know i can but im not a db pro xd :D plz for responce^^

[wowaccpass]

Hey m8:) i have the version 4.6 of ur repack and i was wondering how to remove the bugged haste, cuz even if a wep have 2.90 speed and the char hav e 0.00% haste it still hits like 1 hit per second:S Help please ps i subed.

[BloodyAssassin69]

hi mate i wanna know if u can invite people 2 ur server plz reply

[escaladordewow]

hi i need some help cause i cant add custom items to my arcemu server 3.3.5

[SuperUnderpantsgnome]

ur the man. with your help, i actually got through this with minimal effort. hurry it up with that v5.

[xXDevilFromHeaven]

How do you get thoose extra buttons in the window corner? Please tell me! Looks cool. xD

[BreatzBoy]

@xXDevilFromHeaven

get two monitors and download ultramon

[xXDevilFromHeaven]

@BreatzBoy Okej xD

[turk1burk]

Hi mate, can i get your email please?

[DobriTM]

ALTER TABLE `creature_spawns` ADD COLUMN `death_state` tinyint(3) unsigned NOT NULL default '0' after `standstate` ;

[BreatzBoy]

@DobriTM ummmmm thx...?

but this will teach them how to edit the DB without sql. you can make your own video though! LoL:P

[Coldod23]

like ur accent

[Coldod23]

yay!

[cellvian106]

How soon is soon because........ hurry hurry with the new repack =P

[Coldod23]

thumbs down for the high quality

[InglouriousGamer2009]

GRIM sounds sexy