Ultimate WOTLK Repack - Deathknights, Achievments, Barbershops Exotic mounts + More!

[Sajakain]

are you using Wrath of the Lich King -Update 1 arcemu_world.sql?
i modified my db and these commands stopped working for me too.

Yes. I'm using the Update 1 that was supplied in the 1st post.

[krymzy]

sorry then i really dont remember what did i do to get these things
but rep for you i got my quests working thanks to you

[cernykral]

Ok.. I dont have WOTLK spawns LOL What i meant by "working" was that everything that is fixed thus far and working from Arcemu works Ie the quests and spells passed 70 and mounts and such. So no, i dont have any Northrend Spawns or anything. Check this link for the Sqls to fix Quests..

Filebeam - Free Fast File Hosting

Hmm the arc is password protected which makes this link kinda well... you get the idea.

Can you pleae post the password or just show us the sql, thanx

Can some one please post a fix for the Quest, I care more than the DK is that I can play the game solo with proper quests that work, thanks.

[cernykral]

Thanks for the repack.

Please post Quest fix for Reg and BC, thanks.

[Giedon]

hey, i have one problem, and its probably because i did something wrong on the configs. when i try to start arcemu-logonserver, it crashes immediatly. any ideas?

[predalix]

Sorry cannot create new class dark

thanks

[kreegoth]

Sorry about the Password its not my file its a link taken from Bong25's post about it.. The pass is 25gnob.. or it shoudl be.. All credits go to him for that not myself,,

For the person who cant get the mount/pets working its because the mount is a SPELL not a skill .. So no you wouldnt use Learnskill it would simply be .char learn 62404 not .char learnskill

[Moaradin]

Nicely said. Btw, I am adding frostwyrm next update which was a pain to get a hold of!

[Sajakain]

Sorry about the Password its not my file its a link taken from Bong25's post about it.. The pass is 25gnob.. or it shoudl be.. All credits go to him for that not myself,,

For the person who cant get the mount/pets working its because the mount is a SPELL not a skill .. So no you wouldnt use Learnskill it would simply be .char learn 62404 not .char learnskill

That was me and it was because the original person gave me the wrong spell number. They provided 60242. They got two numbers backwards. I'll try 62404 now and see if that works.

- Sajakain

=======================
=======================

Edit:

.char learn 62404 -- Did not put the pets tab in my character window.

[kreegoth]

Well if the numbers dont work from me.. it might be im wrong since i gave those ones off the top of my head.. i was just commenting on how the command used was wrong:P..

[Sajakain]

Yeah. I'm not totally sure either. Nether spell ID worked and I did a .lookup spell mount and that came up with two exact matches (among others mind you) labeled strictly "mount" and both were in the 22K area of spell IDs lol. Neither of which, btw, gave me the pets window on my character screen. /sigh

- Sajakain

[Sajakain]

I apologize for the double post, but I thought I'd put this out there too.

===============

I directly downloaded the "Update 1". I have unzipped it to the desktop and while setting up the database and the server and such, I noticed something. There are two world SQL files included.

The 1st is located in:

Wrath of the Lich King -Update 1/Database(needed)

And its file name is "arcemu_world"



The 2nd is located in:

Wrath of the Lich King -Update 1/Server/Database

And its file name is "WotLK_World"

===============

I point this out because the 1st sql file, "arcemu_world", when I put it to the world database comes up with an error around 97% and it states this:

Query:
INSERT INTO `trainer_spells` VALUES @'@'ä
'0', '4', '0', '0')

Error occured at:2008-11-20 22:25:29
Line no.:1174736
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@'@'ä
'0', '4', '0', '0')' at line 1

Query:
INSERT INTO `trainer_spells` VALUES @'@'ä
'0', '4', '0', '0')

Error occured at:2008-11-22 00:04:19
Line no.:1174736
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@'@'ä
'0', '4', '0', '0')' at line 1

I realize I'm completely new to this hosting a server thing, but the issue that I'm having is that the 2nd database, "WotLK_World" loads and executes just fine.

Which of these two is the actual SQL file I'm supposed to use for the world database? If it's the "arcemu_world" sql file, how do I go about fixing the error that's provided?

- Sajakain

[farter]

Ascent GM Stuff |
ascent/arcemu # CreatureID
# GM Commands
# Itemlist
# Mount ID's
# Object ID's
# Portal ID's
# Skills
# Vendors
# WoW Spells
# Worldport Locations List
i always have this site open while playing lol just click on list and ctl-f to search is what i do

[farter]

oh and this is the worldport to northrend .worldport 571 0 0 0 puts u out in sea but just .cheat fly and go to shore. i usually find a spot i like and set a recall port location

[denisz11]

I get an error when inserting the db:

Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@'@'ä
'0', '4', '0', '0')' at line 1

i think is from this:

INSERT INTO `trainer_spells` VALUES @'@'ä DH @¼( ø¼( @½( $**( ì0 4 0 | 0 ÔO' P' 0 \0 pO' ¤0 $ï. lï. ´ï. 8s0 €s0 Ès0 ôþ' <ÿ' „ÿ' à½( <©/ €©/ Ä©/ ª/ Ôi( j( dj( |J' ÀJ' K' PK' k( Hk( k( Øk( ت/ «/ h«/ °«/ Dl( Œl( Ôl( m( 0’' x’' À’' ôt0 <u0 „u0 Ìu0 d,# ¬,# ô,# <-# HÑ'ä K 9 ('7315', '0', '100', '100', '0', '0', '0', '4', '0', '0') 'J 9 ('3153', '0', '100', '100', '0', '0', '0', '4', '0', '0') 'J 9 ('1229', '0', '100', '100', '0', '0', '0', '4', '0', '0') ' j( j(4 ('3598', '0', '100', '100', '0', '0'4 ¿ è¨% P|' l&# È.# `Ä' j' j' j' j' j' j' ü®% ü®% ü®% ü®% ü®% P*% ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ( ðÏ(

but wtf those are numbers??