[Release](Ascent)Smlwrnc's PvP Rewards System Including S3-S4 Vendors!

[Devilsadvocate]

---------------------------------------------------
Smlwrnc's Ascent PvP Rewards System
---------------------------------------------------

Here is a PvP system for earning S3 and S4 gear that works by having 4 quests that you exchange Marks of Honor for Badges of Justice used to purchase the Season 3 and Season 4 gear. Also I included an Arena Season 3 - 4 Vendors SQL file because I have noticed it's something everyone wants but don't want to do themselves.

Basically, I believe that using this system on your PvP server will boost Battleground Activity since your actually having to work for your gear.

(Please don't be harsh. This is my first release [or atleast attempt at one.])

-------------------
How To Install:
-------------------

1.) Execute the "ItemExtendedCost.sql", "PvPQuests.sql", "PvPQuestsNPC.sql", "S3-S4Vendors.sql" <---(Optional) Into your "world" databse.

(((((NOTE: If you have any "extended costed items" in your database you wish to keep make a back-up of your "items_extendedcost" table otherwise the data will be lost.)))))

2.) Spawn the quest NPC and that's it!

------------
Features:
------------

1.) Brutal Gladiator's Armor Sets and Weapons will now cost "60" Badges of Justice.

2.) Guardian's Gear will now cost "30" Badges of Justice.

3.) Vengeful Gladiator's Armor Sets and Weapons will now cost "25" Badges of Justice.

4.) Vindicator's Gear will now cost "15" Badges of Justice.

5.) Quests to exchange "x-amount" Mark of Honor for "x-amount" Badge of Justice.

6.) NPC with these quests pre-made.

7.) Included Arena Season 3-4 Vendors!

---------------------
Things To Know:
---------------------

1.) PvP Quests NPC Spawn ID is "999888"

2.) Arena Season Vendor Spawn ID's are as follow's; (Edit these if you wish.)

a.) Season 4 Armor Sets = "60017"
b.) Season 4 Weapons = "60018"
c.) Guardian's Gear = "60019"
d.) Season 3 Armor Sets = "60014"
e.) Season 3 Weapons = "60015"
f.) Vindicator's Gear = "60016"

3.) As an extra pvp incentive I would enable PvP Tokens via the "arcemu-optional.conf" and set the PvP Token ID to "29434" <-- (Badge of Justice)

----------
Credits:
----------

SQLs - Me of course. Took a while to make all this too I might add.

--------------
Download:
--------------

Smlwrnc's PvP Rewards System.zip

Feedback is always welcome!

[soul02]

here a cookie for u

[Jrgamespot]

Thanx, really nice. +2reps since i been looking for this for while

[Devilsadvocate]

Thanks for the rep guys.....
Im still working on my RePack which will include this as well as a new Raiding Rewards system.
If anyone has any special requests or would like me to add certain featrures to this for there own servers please don't hesitate to ask.

Will be releasing a Shattrath, Stormwind, and Orgimmar Mall Soon!

[Devilsadvocate]

Hmmm 76 views but only 2 members reply.........

[alj03]

Pretty cool.

[Kalle200000]

It doesnt work for me, i get error when im trying to execute the batch file. Please help me.
Here is the error:

SELECT VERSION()
SET NAMES latin1
SHOW VARIABLES
SHOW /*!50002 GLOBAL */ STATUS
SHOW DATABASES
SHOW TABLE STATUS FROM `World`
USE `World`
INSERT INTO `creature_names` VALUES ('60017', 'Arena', 'Season 4 Armor Sets', '', '0', '7', '0', '0', '0', null, '22929', '22929', '0', '0', '1', '1', '1', null)
/* SQL Error: Duplicate entry '60017' for key 1 */

[Lord-kapser]

looking great will try it sometime when my server is up


-Lord-kapser

[Devilsadvocate]

Kalle = It's not working because you have creatures in your database with the same Creature IDs. I suggest you go in and edit your "creature_names" and "creature_proto" so you have 60014-60019 free


Send me a PM on MSN and ill go morer in depth with you if you need.
my MSN is [email protected]

[Reflection]

Nice release.

Kalle, you already got an entry with that id in your database.

[Moaradin]

nice.. i might dl but is there a s1 and s2 vendor??if not i recommend adding those so like its 10 for s1 and 20 for s2.. and make starter gear for lvl 70 blues.. anyways nice

[Devilsadvocate]

im not going to do that because im actually hours away from releasing my Ultimate PvP repack which will include this system, a fully spawned mall, and some extra goddies.
And the starter gear will be s2 but i been thinking about going down to s1 and extending cost on s2.
Just be watching the Releases for it.

It's gonna be called "Blood Thirst Ultimate PvP RePack v1.0"

[Moaradin]

k cool. looking forward too it.