[Spartansp]

Ok ill start the guide adding some links to programs you need to have

MySQL 5.0 entreprise- [Only registered and activated users can see links. ]
Navicat 8.0- [Only registered and activated users can see links. ]
No-IP - [Only registered and activated users can see links. ]

lets continue with guide after you downloaded all the previes stuff you need to install MySQL 5.0 to your computer following the setup of next images:



Click Next then youll see this:


Click on Standard configuration and click Next


Check the "instal as windows service" option and click next



You will see only two text boxes as you are installing it for first time just type a password in both (the same) and remember it then click next let Mysql to installed and check no error is found.

Install Navicat 8.0 then see image below



Right click and choose "New Database" option a pop up will come

Name the database as spdb and click OK
then right click on the new created database and choose "execute batch file" option then a popup window will come up press the "..." button and search for Spartansp repackV3 folder

Select character.sql and open it... let navicat finish and do same process with spdb.sql after done that you will see something like the following:

double click your "accounts" table and a new popup will come up add the following information:

where it says whatever is whatever you like to log in.... scroll all the way to the right until you see the following:

set flags column to "8" to enable Burning Crusade Expansion
then open your logon-ascent.conf file using notepad and edit the red marked text with your MYsql password (remember i told you to memorize it )

then open ascent-world.conf and edit also the red marked text with MYsql password


Open ascent-realms.conf and edit also the following with 127.0.0.1 so it looks like that


After this is all done you can execute ascent-logon.exe and ascent-world.exe and start wow... if you want to create a public server then follow this instructions

Do all steps above and then sign up in No-Ip.com
then after logged in click on add host in the left panel


after that the following will appear just edit the things marked with a red rectangle

and click create host then go to Start/all programs/No-ip/No-Ip Duc and execute it

Open the following Internet address to know your public IP
[Only registered and activated users can see links. ]
then copy big numbers in the top

After done with that go into your C:/Windows/system32/drivers/etc/ folder and open with notepad the file named hosts and add the following

127.0.0.1 localhost
publicipthatyoujustcopy NO-IP DNS (ex. spartanwow.servegame.com)

After done with that open your ascent-realms.conf again and edit the red marked with your NO-IP DNS


execute ascent-logon and ascent-world and your done remember to change your realmlist.WTF to whatever you put in your ascent-realms.conf

REPACK INFORMATION


#############################################
#################MADE BYSPARTANSP##############
###YOU CANT REDISTRIBUTE THIS WITHOUT MY PERMISSION###
#########ANY COMMENTS AT [Only registered and activated users can see links. ]####
#####SPECIAL THANKS TO GASTRIC FOR THE LUA GUIDES#####
#######AND LEX FOR THE TRAILER VIDEO OF REPACK########
#############################################
#############################################

Setup:
just run the character.sql in a new database then in the
same database execute SPDB after done with that just edit
your config files, ascent.conf logonserver.conf and
realms.conf, accordingly at your needs, the remote password
has already been changed so you dont need to edit that also
the die messages were removed, after finishing editing the
configs, open your account table and make a new account for you,
then execute logonserver.exe and ascent.exe and you are done
if you get something wrong check MMowned.com for guides or
Email me with subject SPDB.

[Only registered and activated users can see links. ]

Features of the repack:
horde and aliance malls with portals
main city with portals and teleporter(with custom zones added)
bounty hunter npc
portable teleporter and morpher
custom lua portal event (description below)
custom quests (the search of spartans, the vanquishing of traitors,
winter holiday quest (not spawned cause winter has already passed)
The evil yeti, the redemption of the wicked, MMOwned fun quest and a lot more) [descriptions below]
custom items (a lot not going to write them all)
custom T7 with correct stats and class restriction
3 custom instances (2 lua scripted 1 not)
custom mobs bosses and trashmobs
custom GO's
custom mount (epona)
donator items (trinket of donator libram of donator glaive of donator)
admins and GM equips
lolboxes
Fan Tabard Vendor with rock and pop bands
mystery tickets inside boxes around azeroth for exchanging whatever you want
custom spartan locations
main city go's like benches anvils forges etc.
Goldensun City [description below]
Obstacle Course
Leveling area
and a lot much more

Spartan LUA portal Event:

[Only registered and activated users can see links. ]

so you can understande the event what i posted in MMowned:
Ok finally i finish making my Portal event it consist in some portals hidden
as gameobjects, they are placed in unreachable places so players of your server dont cheat also i have to mention that this was done in my server so all Failed portals will redirect you to my main city... ok continuing with the post, There are 10 portals and a lot of loopback portals (fake or wrong portals) to my main city and to previews portals basically is looking for the correct one so you advance and at the end you can spawn a vendor with custom things i put in this pack a vendor with Portable Teleporter and Morpher made by Aldaus no credits for those for me, but you can change what he sells anytime...in your vendors table, i included in the .rar file the .LUA scripts you need to have in your scripts folder (best used in ascent rev 2884 by gastric), the .DLL file of the portableteleporter
(made by aldaus) and the sqls also with readme files.. DONT FORGET TO READ THE README,
ill put here a video of moreless whats the event thig i am telling you about hope you enjoy this (it was really hard working *sigh*)

SpartanCustom quests:

The search of the spartans: chain quest that you need to find diferent npc all around azeroth and outland.The vanquishing of the traitors: first (non lua) instance quest you need to kill the lastfour members of the exiled.winter holiday quest: moreless the same as the search of the spartans (chain quest) with mobkilling requirement and item delivery
the evil yeti: kill evil yeti in dun morog near mistypine refuge
the redemption of the wicked: second instance (lua scripted) quest, need to kill satan and bring his head back to reya reya can be found in the spartan exiled warriors instance inside a hut.

[Only registered and activated users can see links. ]

Fun MMOwned quest: this is a fun quest involving all important people in MMOwned server

Spartan Obstacle Course

Avery fun jumping event to get into another point of the map with rewards

Spartan Custom Goldensun City and quests

Ok im still working on this City / Instance, its name is Goldensun this city has a mall with vendors and tents, trainers, custom quests more than 10, custom GO's and cool lua scripts.
The instance one has 4 Bosses Lua Scripted and trash mobs, supposed to be a 5 man raid with the following backstory:
Goldensun was a peaceful city for all the blood elf anscetor's.They Lived in Harmony With one another.Till Now.A Evil and Corrupted Bloodelf named Kil'Dezan after being Shamelessly Bansihed From Goldensun. Joined Forces With the The Twisted and Mighty Illidan Stormrage.They Have Gained Controlled of Undead Forces from a underground city near Goldensun .
Only brave warriors are supposed to be allowed to see this ancient city, and now you can see and help this people from being slaughtered.
video:

[Only registered and activated users can see links. ]

AND LOTS OF MORE FUN YEY

REV2
added quests
added custom city
added instances
added items
fix all database problems
fix maxbuild and level cap
fix questlog

REV3

added more quests
added custom lua things
added obsacle course
added more items
added vendors
Fix mailboz_insert_queue
Fix max build and level cap
Know bug questlog >_< AGAIN!!!

FIX ADDED and also some restarters!!!
--------------Download it here------------
[Only registered and activated users can see links. ]
this one has spdb.sql and character.sql separated

[Only registered and activated users can see links. ]
and this one has fullspdb with character included in same .sql

[Anarchy [RD]]

WOOO first post! anyway this i 1337!

i will when i can

[Spartansp]

thanks dylan glad you found this usefull

[parlow]

What are all the .recall locations?
You should of included something about that, And T7 still drop from .recall port instance1?
I hope you fixed the db error with the trainers and vendors.
Updating my DB now, Will give feedback after testing :3

[Spartansp]

recall locations are same but i dont know why you want them if there are portals though....
any way...
main city---->.rec p spartan
hordemall---->.rec p hordemall
aliance mall-->.rec p alimall
T7 instance-->.rec p gm2
1st lua instance---->.rec p instance1
2nd lua instance---->.rec p instance2 or 3
all places with not rec ports are in portals and/or teleporter
also quests were changed to english and fixed some teleporter bugs

[JoetheDruid]

+rep,goodjob, very unique.

[parlow]

Originally Posted by spartansp

recall locations are same but i dont know why you want them if there are portals though....
any way...
main city---->.rec p spartan
hordemall---->.rec p hordemall
aliance mall-->.rec p alimall
T7 instance-->.rec p gm2
1st lua instance---->.rec p instance1
2nd lua instance---->.rec p instance2 or 3
all places with not rec ports are in portals and/or teleporter
also quests were changed to english and fixed some teleporter bugs

Alright thanks, Cause the portals don't show up for me in V2. But i'll see about v3.

[parlow]

Just ran into first problem, When creating a character, Once you click create, After doing everything. You d/c.
Any fix?

[Spartansp]

that didnt happened to me mate.... are you sure you followed my guide entirely?? also errase your cache folder

[parlow]

Originally Posted by spartansp

that didnt happened to me mate.... are you sure you followed my guide entirely?? also errase your cache folder

I followed everything, And i deleted my cache folder.
Still d/cs at creation.

[Spartansp]

sorry youre right it was my mistake i added the incorrect character.sql im editing my original post in a few minutes... sorry and thanks for telling me

[parlow]

Originally Posted by spartansp

sorry youre right it was my mistake i added the incorrect character.sql im editing my original post in a few minutes... sorry and thanks for telling me

Thanks, I'm always glad to do bug reports, So expect more to come.
I love testing for bugs, I did it as an internship for a game company :3

[Spartansp]

lol well to make things easier i created just one sql. so you just need to execute one not 2

[parlow]

Originally Posted by spartansp

lol well to make things easier i created just one sql. so you just need to execute one not 2

Haha alright, Tell me when you upload it.

[Lich King]

nice repack for u