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

[Lich King]

woot finally!

[Spartansp]

Spartan, Your upload rate must be terrible. To upload that 15MB should of only taken 5~10 minutes.

YEA I KNOW MY INTERNET IS SHIT THATS WHY IM NOT HOSTING A SERVER LOL

Hey, sorry to break some bad news. But i tried to make the server public so me and my mate could play. Dident work. I tried everything in my power, so please help me man.

FOLLOW MY GUIDE AND TRY ALSO TO FORWARD PORTS

BTW DOWNLOAD LINK HAS NOW FIXED DB AND SOME RESTARTERS, you just need to make database again with new character.sql and with new spdb.sql in that new download

[parlow]

YEA I KNOW MY INTERNET IS SHIT THATS WHY IM NOT HOSTING A SERVER LOL



FOLLOW MY GUIDE AND TRY ALSO TO FORWARD PORTS

BTW DOWNLOAD LINK HAS NOW FIXED DB AND SOME RESTARTERS, you just need to make database again with new character.sql and with new spdb.sql in that new download

So we just execute fullspdb.sql since you merged the two sqls?
So that makes the character.sql in the folder useless?

[Spartansp]

yes practically you just execute fullspdb.sql (it was not supposed to be that way... i uploded the incorrect file again) but yes just execute fullspdb into your database and youre done

[parlow]

yes practically you just execute fullspdb.sql (it was not supposed to be that way... i uploded the incorrect file again) but yes just execute fullspdb into your database and youre done

Works pretty well, Though there are a few things awkward.
Portals not at spawn points (When you create a character)
When you make a new character it always shows blood elf mage robe on.
Although you can take it off it still unequips all your beginner ones.
And is that what the official tier 7 is gonna look like?
If so, Holy ****ing awesomeness.

[Spartansp]

Works pretty well, Though there are a few things awkward.
Portals not at spawn points (When you create a character)
When you make a new character it always shows blood elf mage robe on.
Although you can take it off it still unequips all your beginner ones.
And is that what the official tier 7 is gonna look like?
If so, Holy ****ing awesomeness.

Portals are not supposed to be on starting points ..... they are supposed to spawn in main cities... orgrimmar stormwind silvermoon and so on... so you actually need to explore a bit :P
the character creation i dont know why it happens though
its not the way official T7 looks like that is MY customm T7

[parlow]

Portals are not supposed to be on starting points ..... they are supposed to spawn in main cities... orgrimmar stormwind silvermoon and so on... so you actually need to explore a bit :P
the character creation i dont know why it happens though
its not the way official T7 looks like that is MY customm T7

Oh, I got all excited over thinking it was the real T7. :3

[Spartansp]

Lol Btw I Edited Main Post With Two Diferent Download Links
1.-separated Character.sql And Spdb
2.-character And Spdb.sql Merged In Only One
Finally Im Foing This Correctly

[Wayde418]

Hmm, I can't get my server public, should i edit all the other files other than the ascent-realms?

One last question, is my No IP DNS? Is that the name of the No-Ip thing I made?

[Spartansp]

no, you just need to change ascent-realms every other ip must remain as it is.

YEA no-ip DNS is the one you make in No-ip.com and remember to put also your PUBLIC ip

[thelord12345]

hmm... spartansp

Its because
When you try to... like mount with a wolf or something...
It does nothing.

[Spartansp]

thats really weird... mount should work properly they work for me... its probably some thing in spells or items table... ill check them out i promise

[thelord12345]

and... I got some Other REALLY Weird problems...

[Spartansp]

like???...................

[Wayde418]

no, you just need to change ascent-realms every other ip must remain as it is.

YEA no-ip DNS is the one you make in No-ip.com and remember to put also your PUBLIC ip

Alright thank you, and one last thing.
With this method is there no need for Hamachi or opening ports?

Edit: also should it be set realmlist (No-IP DNS)?