lost and confused

[NZWraith]

hey guys i am the local noob in need of help

ok my brother and i had this clever idea to do a wow server for our lan partys we have ( 3 days of gaming with a few friends) we have the server and got it going but wot we want to do now is change all the instances and raids in outland so u can go in alone with out a key and so on so basicly u can go anywhere and here is the twister neither of us know anything about any of these emu's infact i am surprised we even got it going to be honest lol so if u know how this is done plz pretend u r talkin to a couple of 4 year olds with instructions lol

also we would love it if someone could help us with changing the raids and instances mobs ingame lvls and so on

plan is ( if possible) ingame on a gm account go to all the outland instances and raids and change all the lvls health mana and spells damage and so on so we can also have a funserver with lvl 200 cap and actually b able to go places and do damage and actually get exp but still be challanged lol

we really would prefur to do all this in game if possible as all these scripts and db's are giving us a headach and as i said we are pretty much morons nad dont wanna break anything


thanks
your friendly local noob

[pooooo132]

this is all possible look arround for guides i think you will be able to find one and most of the things you are asking are not very difficult either. and no this would require DB editing you cant do it all in game.

[Power of Illuminati]

To change the mobs in the instances, you need to do it be yourself. And I do not recomend it.

To remove so you don't need a key or such, you need to remove it from the database

Open Navicat(or what you got)
Go to the world database and find the table named 'worldmap_info', open it
Find your location (ctr + f and then write in the name) of your instance you want to remove the required item from.

It's 2x fields that has the name
'required_quest' and 'required_item'
The first one is the so called "Pre quest". Remove it on your choisen instance.

Or just run this sql update (insert your instance name (Caps sensitive) and it should remove if you enter it right

UPDATE worldmapinfo SET required_quest = '0' AND required_item ='0' WHERE area_name ='%Insert%';

To remove all pre quest and such, run this sql update

UPDATE worldmapinfo SET required_quest = '0' AND required_item ='0';

[NZWraith]

ok i got the instances to work with out keys and things ( kara and bt no pre req or key needed) now one last dumb question

is there a script or something out there that will allow me to go thru a instance and click on a critter / mob and up it's lvl stats and everything by say 10% or a simple way to do it ( keep in mind it took me a day and a bit to figure out the instance problem

also i use apples server and i am having one problem with it now it wont save my characters and things they always end up naked and unarmed and i am a little confused on how to fix this

[Power of Illuminati]

I bet you could somehow make a sql code for that, like you only put in the entry of the mob and then it saves it all

I will take a look on it when I comes home later tonight.

[**Sweeny**]

is there a script or something out there that will allow me to go thru a instance and click on a critter / mob and up it's lvl stats and everything by say 10% or a simple way to do it

Find your creature_proto table in your db and search for the monsters name you want to modify i.e. health, mobs damage. Try using this guide http://www.mmowned.com/forums/ascent...-creature.html
Or wait for the guy above me to give you a script or sumthing.

[NZWraith]

thanks heaps for the help guys and Power of Illuminati if this works i will owe u big this is going to sve me a real headache now i just have to solve the save problem