[Ascent] Very Useful Sql Files,Tools C++ Files And More =P

Heya,

well ive decided to make a thread updataed frequently that has lots of useful sql files, Lua scripte and C++ files, Gm Tools etc. (credits to jokerjokes for the idea) also alot of these files need winrar to extract them you can download that here http://www.rarlab.com/rar/wrar371.exe, also please leave a comment about what you think and/or what to add. Thanks


SQL FILES

Warp NPC (Teleporter)

Filebeam - Free Fast File Hosting
Filebeam - Free Fast File Hosting

Building and Big Game Objects
(credits to SectorSeven on mmowned)

Filebeam - Free Fast File Hosting

Building Gameobjects Reference:
750000-House
750001-Moonwell
750002-Ship
750003-Guard Tower
750004-Orc Tower
750005-Tank
750006-NE Ship
750007-Human Siege Tower
750008-Orc Barracks
750009-Gold Mine
750010-Bamboo Holding Pen
750011-Zeppelin
750012-God Altar
750013-Terrorkar Trees
750014-Dark Portal
750015-Stormwind [Might Crash]
750016-Elves Dock Start
750018-Elves Dock 2
750019-Westfall Tree
750020-Emerald Dream Tree
750021-Emerald Dream Tree
750022-Emerald Dream Tree
750023-Emerald Dream Tree
750024-Naxxramas

Project CIDS Teir 7
(Credits to Xcynic and Project CIDS)

Filebeam - Free Fast File Hosting

Working Warsong Gulch
(Credits to whoever made this)

Filebeam - Free Fast File Hosting

Go to Eye Of The Storm and Ashara Crater
(Credits to Illidan1 on mmowned)

Filebeam - Free Fast File Hosting
Filebeam - Free Fast File Hosting

Vendor Mouse-over Fix
(Credits to Whoever)

Filebeam - Free Fast File Hosting

A Whole New City!
(Credits to wowcomputer)

Filebeam - Free Fast File Hosting
screen shots
http://i33.photobucket.com/albums/d5...897/castle.jpg
http://i33.photobucket.com/albums/d5...7/sematary.jpg
http://i33.photobucket.com/albums/d5...lacksmiths.jpg
http://i33.photobucket.com/albums/d5...7/downtown.jpg
http://i33.photobucket.com/albums/d5...ghborhood2.jpg
http://i33.photobucket.com/albums/d5...ghborhood1.jpg
http://i33.photobucket.com/albums/d5...7/downtown.jpg
http://i33.photobucket.com/albums/d5...l897/ranch.jpg

A Sweet Mall!
(Credits to Vivoxity)

Filebeam - Free Fast File Hosting
Also Add this to your database

Code:

---

INSERT INTO `gameobject_names` VALUES ('137137137', '14', '7463', 'Big House', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

---

screen shots
http://i205.photobucket.com/albums/b...hyy1/Good1.jpg
http://i205.photobucket.com/albums/b...hyy1/Good2.jpg
http://i205.photobucket.com/albums/b...hyy1/Good3.jpg
http://i205.photobucket.com/albums/b...hyy1/Good0.jpg
http://i205.photobucket.com/albums/b...708_165924.jpg
http://i205.photobucket.com/albums/b...hyy1/Good1.jpg

To get to the mall type .recall port ViVoMall or .recall port ViVomall

Season 3 Vendors =P
(Credits to Vivoxity)

Filebeam - Free Fast File Hosting

Mail_box_insert_queue Fix
(Credits to Whoever)

Filebeam - Free Fast File Hosting

Grave Yard Fix (99.9% of all graveyards work)
(Credits to evil0z)

make a back up of the database first.
first run this query

Code:

---

DELETE FROM creature_spawns where entry=6491;

---

then run these
Filebeam - Free Fast File Hosting
Filebeam - Free Fast File Hosting

Custom Vendors
(Credits to channel_49)

http://forum.ragezone.com/attachment..._shop_3.1a.rar

PaintBall!!
(Credits to pooooo132 for the awesome idea)

it comes with the gun and paintballs, also a vendor

Filebeam - Free Fast File Hosting


TOOLS

GM Handbook
http://lavos.razakel.co.uk/GM%20Handbook.xls
You need Excel

Ascent Database Editor
(Credits to Whoever)

Ok this tool has to be the MOST USEFUL thing ive ever used
Features

• Complete NPCs, items, quests and items pages editing, creating and exporting.
• Import settings from Ascent configurations file.
• Automatic updater.
• No need to know ID of anything (NPCs, items, quests, bonuses, etc).
• Option to log the queries (for making patches).
• Automatic structure problems fixer.
• Option to change quests starters and finishers.
• Ability to change vendors' items and quests.
• Very easy to use GUI.
• Edit loot of:
  • Creatures
  • Fishing
  • Items
  • GameObjects
  • Pickpocketing
  • Prospecting
  • Skinning

Filebeam - Free Fast File Hosting

WebSites

Too much to explain(how to set up etc) so ive just given links.

WebCMS
(Credites to noriac)

Board Message

Simple Account Creation, SPORA
(Credits to andyman)

Board Message

SiPex

Basically Like the database editor with some more feature also one of the best ive used

Includes

Server Restater

Account Creator/Editor
Portal Creator
Quick Query Executor
In-game Mail sender
Weapon Creator
Character and Account Back Maker - Makes a backup of the character and account tables
For More Info Board Message

SiPex Tools 0.69 BETA.rar - SiPex, Tools, 0.69, BETA, Release, Ascent, Tools


Ecko Tools
(Credits to Ecko007)

Auto Restarter, Auto Backup, Database Editing tools, Announcement Tools

Again basically like Database Editor and SiPex

Filebeam - Free Fast File Hosting

GM/Ticket Addons

Install them into your wow directory inside the interface/addons folder

Ticket Tracker

1. If you have not yet used Ticket Tracker for the first time, log in to your character and type "/ticketchannel <Your ticket channel name here>". This will set the channel the addon listens on for tickets.
2. To view the Ticket Tracker, type "/tt". You can put this in a macro and place the button on your action bar if you wish.
3. To refresh tickets, press the Refresh button. This isn't always necessary.
4. To scroll through the ticket list, use the Prev or Next buttons.
5. To view a ticket, press the View button.
6. To delete a ticket, press the Delete button in the Ticket View dialog.

Filebeam - Free Fast File Hosting


My Master, Good Ticket Addon

Filebeam - Free Fast File Hosting

Ragezone GM Addon

A good gm addon that gives you a sidebar ui that saves you time instead of typeing GM commands etc also includes a ticket addon

Antrix Admin

Features-
Teleporter - Allows easy teleportation to any coordinate, player, areatrigger, or instance.
Object Manager - Allows you to add items (with more than one!), itemsets, manage spells, and morph your model.
Server Manager - Easily lets you broadcast in both widescreen and text, manage bans, and manage the server.
WhisperWall - A tool for handling multiple whispers.

RapidShare: 1-Click Webhosting


C++

First you need to know how to compile you can learn here(takes a while to learn but it gets easy,Board Message

MY MOST FAVORITE THING IN THE WORLD, PvP Ranks
(Credits to Juggalo90 =P)
Board Message03

Heal NPC
Board Message

GM Login Announcer
Filebeam - Free Fast File Hosting

Bounty Hunter
Board Message

Kill PvP'ers
Board Message

Buff NPC
Board Message

Repacks

Cosa Nostra -
(Credits to Rouslan)

This repack contains:

Compiled Ascent 3.5 Stable with 1006 NCDB

- Vindicator Gear
- 2 Malls ( Org for Horde and SW for alliance)
- Both malls are protected by gaurds (Alliance and Horde) (remove if you want)
- everyting is already spawned and ready to go
- All starting areas have portals and Warp Npcs
- Warp NPC
- Premade Enchants / Premade Enchants Vendor
- Custom trainers (credits to Knaur)
- Custom Vendors ( everything sold, tier 6, 100+ weapons, e.t.c)
- Voting reward vendor ( i use to reward for Votes)
- 10 new items i made for Voting rewards
- Custom gaurds for Alliance And Horde
- All factions, arena and honor points requirements < -- > removed
- Custom NPC Quest Giver to level you to 70 instantly
- Portals and Quest NPC at all starting areas
- New Vendor Added (that sells head pieces and other cool items)
- New vendor that sells Flasks/Reagents/Soul Shards/ feathers
- Proffession trainers spawned at Training area for Both Alliance and Horde

Filebeam - Free Fast File Hosting

Project Silvermoon -
(Credits to latruwski)

Features:
- Dance Club (starting area in the Caverns of Time) *Imperium, Laila and Utsjitimmie*
- Portals to the dance club at the begin areas *Utsjitimmie*
- Skypad (in Zangarmarsh, a place to relax) *Imperium and Laila*
- Turtle Racetrack (around the Dance Club) *Imperium and Laila*
- 3 custom vendors who sell party items (party clothes, fireworks, drinks and more) *Imperium*
- Some special new items like [Project Silvermoon Snowball!] and [Project Silvermoon's Backpack of Endless Space] *Utsjitimmie*
- A lottery *Utsjitimmie*
- A lot of new and old vendors who sell armor and weapons at the PVP Area *Utsjitimmie and Underseas*
- Dance Floor (in The Stormspire in Netherstorm) *Utsjitimmie*
- PVP Area (at the Arena of Nagrand, spawned vendors, xp-bombs, trainers etc.) *Utsjitimmie*
- Maarten's Magical Obstacle Course (in Tirisfal Glades) *Kunamo*
- Obstacle Course 2: The Cauldron Run (in Wetlands) *Kunamo*
- Snowball Fight Area (at Ironforge Airport) *Utsjitimmie*
- Obstacle Course 3: The Tower (outside Karazhan) *Utsjitimmie and Kunamo*
- The Frozen Throne (at the end of OC3) *Utsjitimmie*
- The Stairs of Eternity *Utsjitimmie*
- The Emerald Dream Maze (use .recall port maze to go there) *Utsjitimmie*
- New! The Park (a place to relax) *Underseas* [75% done]
- New! Fully pimped GM Island *Utsjitimmie, Kunamo, Underseas and Technique*
- New! A LUA script for GM Island *Utsjitimmie and Underseas*
- New! A LUA script for custom portals *Utsjitimmie*
- New! Obstacle Course 4: The Way of the Blacksmith *Kunamo*
- New! 2 custom villages *Illidan1 from MMOwned.com*
- New! A custom instance, Scarlet's Hand (lua scripts included) *Illidan1 from MMOwned.com*
- New! A custom instance, Deathwing's Lair (lua script included) *Meltoor from MMOwned.com*
- New! Illidan's 2.3.2 Custom Weapons *Illidan1 from MMOwned.com*
- New! WORKING FIREWORKS!!! *Utsjitimmie and Underseas*
- New! Pimped GM Cube (you'll find a portal inside the GM Island house) *Utsjitimmie*
- New! A bunch of custom Gameobjects *Underseas and clain from ac-web.org*

Filebeam - Free Fast File Hosting

Wanna See More? [Release] Project Silvermoon FunRepack rev7 - NEW FEATURES [Release Date: 17/02/08] - MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides

SpartanSP V3!!
(Credits to 1337Equillbrium/ Spartansp)

IF YOU WANT V4 [Release] Spartansp Repack V4 ascent 3940 - MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides

Features:

-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)
-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!

Ac-Web Ultimate Repack 7.6
(Credites to Jargs)

This is prob the easiest to start a server beacuse it contains the mysql already made and ready to go.

* Ascent 3.8 Stable
* NCDB Revision 1093
* Control Panel Update


Full Feature List:

* Supports Patch 2.3.3
* Comes with teleporter NPC
* Easy to use repack, No setup required
* MySQL and Apache installed within Repack
* Comes with Ascent revision 3.5 Stable
* The latest database from NCDB
* Account tables separated from game database for easy organization
* Control Panel for easy server startup
* Map extractors for US and EU clients
* Latest DBCs
* Lots of LUA scripts
* Anti hacking security
* Config files already setup
* Over 80 Custom Vendors
* All necessary instructions in readme
* Supports latest wow patches/clients
* Full TBC support
* Normal WoW support (for you people without TBC)
* Alot of custom gamemonkey scripts
* Comes with fully customizable Joomla website
* PHPBB 3 forum integrated into website
* Stats Page
* Account Creation Page

RapidShare: 1-Click Webhosting






Well This will be updated daily

Hope this Thread helps =P

took me a while to write lol

good gathering, just that many of them are outdated and dont work with latest cores, like bounty hunter :d

WoW ncie dud you rock i was searching for some files and you have found them ! thnx

np, and pretty much all of them work with the latest core i think the bounty hunter is a fix

how to get to the mall?

can you tell the sql of WarpNpc ?

Quote:

---

Originally Posted by Yesilmen46

can you tell the sql of WarpNpc ?

---

what do you mean,

and to get to the mall type .recall port ViVomall or .recall port ViVoMall

bump added vendors and the ports to the mall

EDIT: also paintball and winrar

How about giving me (Brae) credit for the PVP Ranks?
=]
Also, you should post the source for the "working" WSG

Nice Job Right Now I Am Fixing THe RZ GM Addon Which I released It Was Originally An Antrix GM Addon Unless This Is A Fixed One From My Release But I Am Working On it And Adding More

Quote:

---

Originally Posted by Juggalo90

How about giving me (Brae) credit for the PVP Ranks?
=]
Also, you should post the source for the "working" WSG

---

kk will do

bump

hmm... i have a question :PP
i'm new here and can someone tell me how to add sql files to my ascent?
i want warp npc and paintball

plz answer :P

NPC Warp Download Link doesn't work... please fix it .. :X

WSG and Warp NPC scripts are not wokirng, GJ....

reup NPC WARP :
DOWNLOAD NOW!

but can someone tell me how to use it on my server?

I think it should be .npc spawn and the ID of the NPC warp

Sorry if i ask..why stormwind might crash ?

Quote:

---

Originally Posted by 1byq1

reup NPC WARP :
DOWNLOAD NOW!

but can someone tell me how to use it on my server?

---

ok you have to execute this into your database and place the .dll file in the script_bin file in your ascent

Quote:

---

Originally Posted by spajdR

WSG and Warp NPC scripts are not wokirng, GJ....

---

the warp npc works fine for me but ill put another one up

Quote:

---

Originally Posted by magickal

NPC Warp Download Link doesn't work... please fix it .. :X

---

yes it does?

Quote:

---

Originally Posted by spajdR

WSG and Warp NPC scripts are not wokirng, GJ....

---

try the new warp npc, the first link, i cant fix the WSG caz i didnt make it lol

Quote:

---

Originally Posted by plnt8

ok you have to execute this into your database and place the .dll file in the script_bin file in your ascent

---

and how to spawn him in the game?

type .npc spawn 822334 (you have to have gm powers)

Added a new section!! Repacks!!!!!!!!

"MY MOST FAVORITE THING IN THE WORLD, PvP Ranks" link is broken :(

plnt8 can u change NPC WARP to .sql file... cuz i can't spawn him

Quote:

---

Originally Posted by Bloodshed2007

"MY MOST FAVORITE THING IN THE WORLD, PvP Ranks" link is broken :(

---

click the small 03 lol

Paintball seems broken.
Vendor has no spawn texture.
Vendor, weapon, and paintballs have spelling errors on text.
Clicking to equip gun causes player to 'learn' languages, daggers, crossbows, etc..., then gun shows "Already Known" on mouseover.
Paintballs dont stack in inventory.
Paintballs just look like regular bullets, plus do damage.

Pretty sure this isnt working as intended by the creator. Neat idea though.
Possibly someone can look into re-doing this one?
Or maybe it just doesnt work with my setup? (running ascent 4263 / ncdb 1176)

bump!

someone got link for compiled PvP Ranks dll plz?

Quote:

---

A Sweet Mall!
(Credits to Vivoxity)

Filebeam - Free Fast File Hosting
Also Add this to your database
Code:

INSERT INTO `gameobject_names` VALUES ('137137137', '14', '7463', 'Big House', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

screen shots
http://i205.photobucket.com/albums/b...hyy1/Good1.jpg
http://i205.photobucket.com/albums/b...hyy1/Good2.jpg
http://i205.photobucket.com/albums/b...hyy1/Good3.jpg
http://i205.photobucket.com/albums/b...hyy1/Good0.jpg
Image hosting, free photo sharing & video sharing at Photobucket
http://i205.photobucket.com/albums/b...hyy1/Good1.jpg

To get to the mall type .recall port ViVoMall or .recall port ViVomall

---

Cant execute into NCDB 1195 ?

what error are you getting?

*moved to new thread*

there seems to be a problem with the custom city game object spawns... i looked at it and for the coords it isnt just 'x' 'y' 'z' it has to be 'position_x' etc... please fix, i cant go through around 300 of those... ill die please!!! fix!!!

EDIT!: also it cant be o1, o2 ect for orientations.... it has to be orientation 1, orientation 2, etc etc...
EDIT2!: none of the t7 items work cuz of sql errors, like unknow extended item cost or w/e... im realy frustrated right now with all these frickin bugs!

This thread is DEAD... Also if you want pvp ranks use Aspire..

damn, i really wanted that fricken city....

Make one your self o.O

i dunno how ...
ill just search the web for a working one

A Whole New City!
(Credits to wowcomputer)

Filebeam - Free Fast File Hosting
screen shots
http://i33.photobucket.com/albums/d5...897/castle.jpg
http://i33.photobucket.com/albums/d5...7/sematary.jpg
http://i33.photobucket.com/albums/d5...lacksmiths.jpg
http://i33.photobucket.com/albums/d5...7/downtown.jpg
http://i33.photobucket.com/albums/d5...ghborhood2.jpg
http://i33.photobucket.com/albums/d5...ghborhood1.jpg
http://i33.photobucket.com/albums/d5...7/downtown.jpg
http://i33.photobucket.com/albums/d5...l897/ranch.jpg



I wondered:

Where is the city going to be???
I really need to know : / TY
For sharing!!!! :D

Is this thread still in use by anyone or not? (outdated?) As it may be in for being locked if it isn't being used, seeing as it was bumped back to life.

Great post m8

Brilliant links!!
Especially the Tools,
Thanks a million

erm in new btw the sql files just go in the main database or database and inside one of the files ?