[Guide] set up your server with Spartansp Repack V3 (public)

[belladonn]

hey it workt grt server is up only bug is mounts dont show and when i when into the mall's there where no armor vendor's

[Spartansp]

hey it workt grt server is up only bug is mounts dont show and when i when into the mall's there where no armor vendor's

if you read previews post you will notice like 40 posts regarding mount bug also another 20 regarding armor and weapon vendors so i kindly ask you read all post before posting something already answered a lot of times before

[playboyys]

Awsome guide, got it up and running in no time at all.

[Spartansp]

glad it helped you out

[LampShade]

Here is a screenshot of the error i get whenever I try to Execute spdb.sql into Navicat:

[LampShade]

Also wanted to add, when I try to execute this same sql into SQLylog, it gives me this error:


Query:
CREATE TABLE `wordfilter_character_names` (
`regex_match` varchar(500) NOT NULL,
`regex_ignore_if_matched` varchar(500) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Error occured at:2008-02-21 09:22:59
Line no.:1550
Error Code: 1074 - Column length too big for column 'regex_ignore_if_matched' (max = 255); use BLOB or TEXT instead

[Spartansp]

that didnt hapened to me never neither the test compueters where i executed them... you must change in the SQL that varchar to 255

[LampShade]

Alrighty, I went in to change those numbers from 500 to 255. Now when I execute the sql, it will show the time elapsing, but the Queries, Processed, and Errors numbers stay at 0.

[Spartansp]

Alrighty, I went in to change those numbers from 500 to 255. Now when I execute the sql, it will show the time elapsing, but the Queries, Processed, and Errors numbers stay at 0.

then you may be doing something wrong mate try to redownload

[Koest]

Certain +rep! All the features... and this is one reason why I actually play on my own private servers more than live

Many, many thanks, Spartan, got it up in virtually no time... just ran into a little Sql problem.

[Spartansp]

glad you liked it and get it to work trying to do my best

[Lord_yami]

Some bugs i found:

no level up command

if you are above the quest level, it dissapears

[Deathed One]

Whenever i try to make a character i get Disconnected does anybody know how to fix this?

[Syplex23]

to get armor vendors just go to gm island
if u want uber gm gear do:
.npc spawn 100002
if you want to fix the mount bug just make your own custom mount vendor i did that with the bread vendor in westfall that might save the the next person who posts without reading

o btw

Whenever i try to make a character i get Disconnected does anybody know how to fix this?

in the repack theres a file called sql execute all of them (thats what i did at least) and i had no problems

although you can't get duel wield for some reason

[xaf]

Spartansp
I got some little problems with your repack. The instance onyxia, has 3 spawned onyxia in there, and when you kill one of them or all of them, they respawn directly after. And some mobs are bugged, there are ghosts, and bats for example in Durotar. And as a hunter I tried to tame a pet, in durotar, a lvl 3, pig... I don't exactly remember the names of the pigs outside orgrimmar but I think you know, and when I did that it became a bat instead.