Need help with some stuff

[jordy]

hi there , i just started a private serevr ( non public yet ) using navicat as my " db edit " now i wanted to know how to create a npc , welcome npc , and how to get the whole honor , badge costs of my items so people can buy them with money , or if i can add some sql files to my db that has all of those custom vendors like : currency , lvl 50 - 100 weapons , ring , trinket etc etc and how to get that into my db ( like i said its first server so i need to find out how to do it etc .. )


for the peopel that could help me = + rep , peopel with a sql etc i would rep a lot xD


btw this is for version 2.4.2 build 8278 using the apple ascent core and the sp fundb v2


if i need more question i will add and highlight them in my first post !



thnx in advance !

[jordy]

ok i found a tut on how to make a custom npc

1 Let's get started! - Making a Custom NPC

Open your Database, it could be Navicat, SQLyog or Heidi SQL.

Go to the one called Creature_names, open it and press the last page button. Scroll down, and click the + .

Entry: The ID you want to enter to add the NPC, I will put 600029.
Name: The name of the NPC. I will put Welcome NPC.
Subname: The name underneith the NPC's name, you don't have to add anything here, but it looks better with a subname. I will put Welcome to the server!
Info_str: Set this to 0
Flags1: set this to 0 as well. ( 3 is hostile mob )
Type: 3 or 7. I'm gonna put 7.
Family: If the NPC belongs to a family. I'm gonna put 0 here.
Rank: The rank of the NPC ( Elite, Rare Elite etc ) i'm gonna put 4 here.
4 is the strongest, 1 is the weakest. This has no affect on the damage or anything like that though. So it doesn't matter.
Unk4: Needs to be set at 0.
SpelldataID: If you want the NPC to use a spell. I'm gonna put 0 here.
Male_displayID: This is the tricky part, you will have to know the Display ID of the NPC. I'm gonna put 19386 (picture: )
Female_displayID: if you want the NPC to have a girl model as well.
Male_displayID2: Needs to be 0
Female_displayID2: Needs to be 0
Unknown_float1: Default 1
Unknown_float2: Default 1
Civilan: If the NPC is gonna be a civilian. I'm gonna put 1 here.
Leader: if the NPC is a leader. I'm gonna put 1 here.

( Download DisplayID here: WoW Vendetta - Wage Your War )

Then go to the Creature_proto table.

Entry: the entry ID you made for the last NPC. Wich was 600029.
Minlevel: The minlevel, since i'm gonna have the same level all the time i'm gonna put 100 for both minlevel and maxlevel.
Maxlevel: The max level for the creature. I'm gonna put 100.
Faction: 37=hostile , 1741= Neutral.
Minhealth: The minimum amount of health pf the NPC. I'm gonna put 100000 for both minhealth and maxhealth.
Maxhelath: The max amount of health of the NPC. I'm gonna put 100000
Mana: The Mana of the npc. i'm gonna put 100000
Scale: The scale of the NPC. I'm gonna put 1. Wich is the normal size if the NPC hasn't been modified. Like Onyxia, if you .modify scale 1 that it will shrink from it's normal size.
NPCflags: 128= Talkable NPC Vendor
Attacktime: I will set it as 2700 ( 2,7 sec between each hit )
Attacktype: Leave it at 0
Mindamage: The minimumdamage: I'm gonna set 50000
Maxdamage: The maxdamag. i'm gonna put 100000
Rangedattacktime: 0
Rangedmindamage: 0
Rangedmaxdamage: 0
- Everything from Mountdisplay to Respawntime set to 0. -
Respawntime: 1
Armor: 0
Resistance 1-6: 0
Combat Reach: 1
Bounding Radius: 1
Auras: Leave at 0
Boss: If it is a boss ( skull at any level ) leave at 1.
Money: The money the NPC drop.
Invisibility_type: 0
DeathState: 1
Wealk speed: Default at 2,5
Runspeed: 8
Flyspee: 14
Extra a9 Flags: Leave at 0

Save it and close it, then go ingame and do the command: .npc spawn 600029 ( change 600029 to the Entry ID of your NPC )

And you are finished!  

-------------------

2 Adding items to a NPC

Open up Creatureloot.

Index: Anything above 4 000 000 will work.
EntryID: The EntryID of the NPC.
ItemID: The itemID of the item you want the NPC to drop.
Percentchance: Any number will do, even 1 equals EVERY SINGLE time you kill that npc.
Heroicpercentchance: leave at 0
Mincount: the min muber for the item to drop.
Maxcount: The maximum number for the item to drop per NPC.
Ffa_loot: leave at 0

And you are finished! The NPC will now drop the new item.

-------------------------------------------

3 Making a custom quest!

Open up the Quests table.

Entry: The entry ID of the quest, the entryid of the quest to add to the NPC.
ZoneID: leave at 0
Sort: leave at 0
Flags: 4= Chain quest, 8= one time only quest.
Minlevel: the minimumlevel to be able to accept the quest. i'm gonna put 1. As it's a welcome quest.
Questlevel: The level of the quest. I'm gonna put 80
Type: Leave at 0
Required Race: Leave at 0
Required Class: Leave at 0
Required Tradeskill: Leave at 0
Required Rep Faction: Leave at 0
Required Rep Value: Leave at 0
Limit time: Leave at 0
Prev Quest ID: The Previous Quest ID. I'm gonna put 0, as it's not a chain quest.
Next Quest ID: the next Quest ID. I'm gonna put 0, as it's not a chain quest.
ScrItem: Leave at 0
ScrItemCount: Leave at 0
Title: The Title of the quest. I'm gonna put Welcome Message.
Details: The quest details. I left a message to new players there.
Objectives: The quest objectives. I'm gonna put Return to the Welcome Panda.
Completion Text: The text at the end of the quest after completion. I'm gonna put Welcome to the server!
IncompleteQuest: Leave blank if you don't want to have anything here.
EndText: Leave blank if you don't want to have anything here.
ObjectiveText 1 - 4: Leave the same on all. I'm not gonna put anything there.
ReqItemID1: I'm gonna put 0, since it's a talk quest.
ReqItemID 2 - 4: Leave blank, or add the ID if you want several required items.
ReqItemcount: Leave 1 if you only need one of the item, or put more if you want to do that. I'm gonna leave blank.
ReqitemCount 2-4: i'm gonna put blank.
Reqkillmoborgoid1 and Reqkillmoborgocount: Leave at 0.
- Leave the rest until RewMoney at 0 -
Rewmoney: how much gold you will be rewarded. I'm gonna put 50000 ( 5g )
RewXP: how much XP you get from the quest. i'm gonna put 0.
RewSpell: If you want to add a Spell reward to the quest.
- Leave the rest at 0 -

And you are finished! Look below to know how to add it to a NPC!

-----------------------------------------------------------------------

4 How to add quest to a NPC!


Target the NPC and type .quest addstart <id>
And to the finish NPC: Type .quest addfin <id>

Then open the server and add the quest.

but then i tried :

4 How to add quest to a NPC!


Target the NPC and type .quest addstart <id>
And to the finish NPC: Type .quest addfin <id>

Then open the server and add the quest

and i get this as message on the server :

Unit is not a valid quest giver ...

the npc id is 600000 and on the proto table its the same i made everything liek the tut says to do ... but sill get that message some one got a solution for that ??

[Mythers]

Flags: 4= Chain quest, 8= one time only quest

You're sure you put 8 or an 4 at the npc?

Might solve the problem, if it dosen't. I'll give it a look

Edit: Download all the vendors: Vendor Project V3.0 - AIDS - AC Web

[jordy]

i did put an 8 there .. i dont think that has anything to do cause the quest starts and ends with the same npc so .. is a welcome text for the new people ...

and about the vendors : jus execute the batch in my wolrd db ? and are they 2.4.2 ?

[jordy]

k that vendor pack doesnt work for my i executed the batc file in my world db , it gave a lot of errors ..

[Greeko]

I can post one "welcome npc" sql w8 one sek..

EDIT: Here is the link: http://www.mediafire.com/?yjigl4my5mt

[jordy]

that sql welcome npc doesnt have a creature_proto so doesnt work .. cant spawn him

[rahburt33]

you can use the program "ascent database editor" to make npc's and items, make quests, edit npcs drops, and some more stuff

just search for ade or ascent database editor

[jordy]

i got that but do u know how much time it would take to make all custom npc's with every weapon like axe 2h axe etc ... i mean a vendor for each weapon , reagent , piece of gear ...

[rahburt33]

like, a while

if your looking to make a mall, you may want to search for a mall sql

[jordy]

yeah im looking for one but cant find one for 2.4.2 ... that actually works ..

[rahburt33]

lol thats what im doing to
what ascent/database are you using?
hey if you do find one can you tell me?

[jordy]

im using the core from apple's ascent pack .. but i got another db in it ..

[rahburt33]

well, im just gonna make my own mall
got mad looking for stuff that worked, and what im making works, so its all good

[jordy]

well im still looking but cant find on ..if ur done can u let me know bout it ?