8 Guides compilation! ( Asccent ) For Navicat or other databases menu

User Tag List

Results 1 to 9 of 9
  1. #1
    Romis's Avatar Contributor
    Reputation
    155
    Join Date
    Dec 2006
    Posts
    359
    Thanks G/R
    8/2
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    8 Guides compilation! ( Asccent ) For Navicat or other databases

    Hi everybody!

    Downloads:
    WoW Vendetta - Wage Your War
    All the WoW ID's
    --------------------------------


    This guide will help the noobs making their server better.

    Introduction:

    1 - Making a Custom NPC
    2 - Adding itemdrop to a NPC
    3 - Making a custom quest
    4 - Hot to add a quest to the NPC
    5 - Making custom items, and adding it
    6 - How to change maxlevel
    7 - How to make an Admin/GM account
    8 - How to change game object names
    9 - How to add a newly created item in-game without restarting the server



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

    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.

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


    5 Making a custom item and adding it.


    Go to WoW Vendetta - Wage Your War and create an account if you haven't already.
    After signup press the logos to make a spesific item.
    This time i'm gonna make an item.

    Name: The name of the Item
    Quality: The quality of the item
    Quote: The text underneith the stats.
    Display ID: The Display ID of the item, ( Download DisplayID here: WoW Vendetta - Wage Your War )
    Entry: The Entry ID of the item.
    You should be able to add the rest yourself.

    At the end press submit and download the Batch file.
    Go into your database, right click ascent and click Execute Batch File.

    Go in-game and write .additem <id>

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

    6 How to change maxlevel.

    Go into your Ascent files, open up the file called Ascent.
    Scroll down until you see this:

    Code:
    <Server PlayerLimit = "100"
    Motd = "Welcome to Armani funserver."
    SendBuildOnJoin = "1"
    SendStatsOnJoin = "1"
    EnableBreathing = "1"
    LevelCap = "99"
    GenLevelCap = "70"
    SeperateChatChannels = "0"
    CompressionThreshold = "1000"
    QueueUpdateInterval = "5000"
    KickAFKPlayers = "0"
    ConnectionTimeout = "180"
    RealmType = "1"
    AdjustPriority = "0"
    RequireAllSignatures = "0"
    ShowGMInWhoList = "1"
    MapUnloadTime="0"
    LimitedNames="1"
    UseAccountData="0">

    Change the green part to the level you want to be maxlevel.
    Then scrool up untill you find:
    Code:
    # Level Cap
    # This variable controls the level that stats will be generated up to internally.
    # Beyond this level players can still see a higher level visually but their stats won't
    # increase beyond this point.
    # Default: 99
    Once again, change the green numbers to your maxlevel.

    That's all, restart your server and login.

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

    7 How to make an Admin/GM account.

    Go into your database and click the ''Accounts'' table.
    Write in the table:

    Acct: The number of the account. Since it's your first your gonna want to add ''1'' there. (Without the '' )
    Login: The account name you will want to login with. I'm gonna put Romis here.
    Password: The password to the account. I don't wanna display mine here
    GM: Here is the tricky part.
    0 - No GM privelegies at all. Normal account.
    1 - Very few GM powers, only .summon and .appear.
    2 - More powers.
    3 - Full GM.
    4 - Admin, you have access to all the GM commands.

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

    8 - How to change game object names.

    First open your database, and go to the table called '' gameobject_names '' open it and search for the name of the item. In this guide I will change the name of Imperial Throne to Throne of Arthas.

    The entry id for Imperial Throne is 170592 .
    Your gonna want to find the '' Name '' column.
    Change the name to whatever you desire.
    Save, and exit. Go ingame and type .reloadtable gameobject_names . Then add the game object by typing .go spawn 170592 1 .

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

    9 - How to add a newly created item in-game without restarting the server.

    Go ingame and write .reloadtable <name of table here>
    i.e: .reloadtable items .

    There you go, you will have to remember, some tables can't be reloaded in this way.

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









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

    Thank you for reading the guide. Leave a (nice) comment if you liked it. And ofcourse, any problems; leave your comment and I will try to help you.

    Look at my guide on
    http://www.mmowned.com/forums/emulator-server-guides/92579-getting-sql-files-working-not-have-download-them-using-console.html (Getting SQL files working and not have to download them. ( Using Console ))
    How to load the item without downloading the SQL file.



    8 Guides compilation! ( Asccent ) For Navicat or other databases
  2. #2
    Appled's Avatar Contributor
    Reputation
    105
    Join Date
    Apr 2007
    Posts
    568
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You don't have to restart server when edited config file. Use .rehash or .server rehash I have no idea which one.
    On my server it is .server rehash

  3. #3
    Krushiev's Avatar Member
    Reputation
    2
    Join Date
    Jun 2008
    Posts
    18
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Pfft, good stuff man!

    I hope my +rep worked because this looks really comprehensive (going to test some of this stuff out).

    This guide was put together well. Thank you.

  4. #4
    Appled's Avatar Contributor
    Reputation
    105
    Join Date
    Apr 2007
    Posts
    568
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh and rep

  5. #5
    Romis's Avatar Contributor
    Reputation
    155
    Join Date
    Dec 2006
    Posts
    359
    Thanks G/R
    8/2
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you, guys. I will update later, when I have a chance



  6. #6
    Gosko's Avatar Member
    Reputation
    3
    Join Date
    Mar 2008
    Posts
    53
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is there anyway I could make this quest a repeatable one? +rep for guide ^^ helped me make quests

  7. #7
    Coffzor's Avatar Active Member
    Reputation
    44
    Join Date
    Oct 2007
    Posts
    100
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Romis View Post

    Change the green part to the level you want to be maxlevel.
    Then scrool up untill you find:
    Code:
    # Level Cap
    # This variable controls the level that stats will be generated up to internally.
    # Beyond this level players can still see a higher level visually but their stats won't
    # increase beyond this point.
    # Default: 99
    Once again, change the green numbers to your maxlevel.
    That part just tells you about it, and # Default: 99 just shows the default setting, 99 wont change anything

  8. #8
    jrnkosik's Avatar Member
    Reputation
    1
    Join Date
    Apr 2009
    Posts
    16
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    nice post, i will put this to use.

    Thanx Bro.

  9. #9
    XxCyanidexX's Avatar Member
    Reputation
    56
    Join Date
    Nov 2008
    Posts
    138
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Change the green part to the level you want to be maxlevel.
    Then scrool up untill you find:
    Code:
    # Level Cap
    # This variable controls the level that stats will be generated up to internally.
    # Beyond this level players can still see a higher level visually but their stats won't
    # increase beyond this point.
    # Default: 99
    Once again, change the green numbers to your maxlevel.

    That's all, restart your server and login.
    Don't you see that it's commented? It's not gonna do a thing.

Similar Threads

  1. [Tutorial] Class Guides COMPILATION for 4.0.1
    By Unholyshaman in forum World of Warcraft Guides
    Replies: 4
    Last Post: 10-23-2010, 06:47 PM
  2. [Guide] How to Compile ArcEmu (FOR NOOBS)
    By DarkFever in forum WoW EMU Guides & Tutorials
    Replies: 22
    Last Post: 03-02-2009, 01:15 PM
  3. [Guide] Model Editing: For Dummies
    By Krazzee in forum WoW ME Tools & Guides
    Replies: 240
    Last Post: 02-04-2008, 04:14 PM
  4. Guide compiling Ascent for windows
    By hardcore in forum WoW EMU Guides & Tutorials
    Replies: 1
    Last Post: 01-09-2008, 09:53 PM
  5. Jame's guide compilation (Horde/alliance + some other guides)
    By Snakehead in forum World of Warcraft Guides
    Replies: 6
    Last Post: 05-31-2007, 09:03 AM
All times are GMT -5. The time now is 05:49 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search