Nice DB rev8!

Results 1 to 7 of 7
  1. #1

    Nice DB rev8!

    Foreverbanned13 Package

    This DB, core, DBC is composed of Bloodshed2007,JULIAN_X, Channel49, zhangweizheng3 and terranets dev teams work. I just Slapped it together cause its a nice DB.:ninja:

    CORE 989 terranet rev8


    Change Logs (of the shit thats in it)

    Code:
    Quote Originally Posted by Bloodshed2007 View Post
    - Bloodshed Release - TWINK VENDOR well as the title says this download is a twink vendor for your server. im not sure if this has been done before, i searched on google but couldnt find anything I was looking channel_49's vendors and thought...'theres no twink vendor :(' so i thought why dont i make one. To spawn these - .npc spawn 123123123 If theres any items i missed out then jut post a reply saying what items.. -Bloodshed- README!:
    Code:
     _____________
    |             |
    |  BLOODSHED  |
    |             |
    |TWINK  VENDOR|
    |             |
    |  \    / /|  |
    |   \  /   |  |
    |    \/   _|_ |
    |_____________|
    -------
    RELEASE
    -------
    How to Install
    1. Extract the .sql file from the zip folder.
    2. Open up SQLYog or Navicat.
    3. Right-click on your database name.
    4. Select execute from batch file.
    5. Click the '...' button.
    6. Select the Twink_Vendor.sql
    7. Execute that file.
    8. ENJOY
    ------
    I dont mind people using my stuff aslong as you give me credit! Deposit Files
    Deposit Files
    Filebeam http://filebeam.com/5c7d37ff68717cc2d80221078cea5329
    [code]
    Code:
    [Julian_X;2504060]NOTE: Sorry I accidently Deleted the other (yes i'm an idiot)
    
    All I require from you is a vote:
    Vote
    ==========================================
    •••Downloads•••
    ==========================================
    ###Julianx's Repack V3###
    Filebeam
    Includes:
    • Ascent1023(with DBC Files)
    • TNPS8 DB
    • Ecko Tools V 1.4.2
    The Next Chapter on WoW Database Developing. SVN:
    Code:
    https://tools.assembla.com/svn/NCDB
    Changelog:
    Code:
    Changeset 10:
    - Rewrote weather table(Added Outland Weather, Added Weather for instance, rewrote all exiting weather).
    - New Fresh item Table by Dimen.
    Changeset 9:
    -Added Next-Chapter Website.
    Changeset 6:
    - Creature Damage fixes: 21287.
    - Creature Flag fixes: 18472, 19203, 19204, 19205, 18473, 18343, 19671, 18341, 18344.
    - Creature scale fixes: 18341, 18344.
    - Creature mana fixes: 18700, 10685.
    - Spawned Mana-Tombs phase 1.
    - Removed staticspawns.. they fucked up(teleporting to darkshore, huh?)
    Changeset 5:
    - Objectloot & Items cleanup.
    - Removed Lord Kazzak(creature_proto/names/spawns, ai_agent & loot).
    - NPC Faction: 22103,20611,21022, 20415, 594, 1726, 1727,14942, 347, 7427, 16695, 15006, 15007, 12198, 16694, 19905, 2858, 5047, 12777, 12782, 12792, sss12793, 14581, 14693, 15467, 15481, 15520, 15553, 15633, 15864, 15909, 15909, 16181, 16776, 16777, 16778, 17081, 17082, 17153, 17151, 17153, 17160, 17278, 17661, 18254, 18682, 18932, 19435, 19436, 19519, 19658, 20021, 20382, 20561, 20679, 20908, 21045, 21233, 21449, 21724, 21845, 21932, 22140, 22189, 22226, 22229, 22234, 22237, 22344, 11898, 19281, 14859 1720,15186, 16069, 3300, 2110, 2757, 17816, 17957, 17962, 17958, 17961, 17938, 21128, 17959, 17960, 17940, 21127, 13321, 17817, 23144, 22421, 1860, 17963, 17964, 17890, 17941, 17942, 17991, 18423,21904, 21891, 18328, 18325, 18322, 18326, 18321, 18319, 18320, 18311, 18309, 18317, 18313, 18331, 18312, 18314, 19307, 18315, 19306, 18503, 18500, 18498, 18499, 18501, 18556, 18559, 18506, 18524, 18521, 18702,14693, 17536, 17377, 18894, 17429, 17398, 17381, 17414, 19016, 17399, 17395, 17626, 17491, 17371, 17624, 17671, 17622, 17695, 16593, 17455, 17281, 17478, 17537, Fixed.
    - NPC Mana: 21723,15186,68.582,664,704,724,857,1429,1445,1446, 1447,707 Fixed.
    - NPC HP: 15186, 16069,8996,704 Fixed.
    - NPC Flag: 14842,1365 Fixed.
    - NPC Repawn: 22199 Fixed.
    - Fixed all tailoring quests.
    - Quest Description fixes: 5803,2747, 2750, 2749, 2748, 2747
    - Fixed Egg series quest chain (Extraordinary, Fine, good, bad)
    - Fixed Angler Fishing chain quest
    - Fixed Totem Stats.
    - Added missing spawns for skettis
    - Fixed Taming-Hunter Quest line.
    Changeset 4:
    - Medivh flag fixed.(Questgiver & Gossip).
    - Fixed Mana-tomb & mechanar trash mobs faction.
    - Fixed 2 PreviousQuestID for Tier 0.5 questline.
    - Fixed Firewing Signet & Sunfury Signet quests(required rep, repeaable).
    - Fixed Marks of Sargeras Marks of Kil'jaeden quests(required rep, repeaable).
    - Removed mana for mobs who shouldn't have mana(18988,22107,16584,16591,16600,17585,17637).
    - Fixed Subname for creatures(1574, 1575, 2404, 2796, 6776, 10370, 11338, 11583, 14465, 14466, 14637, 14751, 14752, 14822, 14823, 14834, 14860, 15198, 15309,
    
    15441, 15442, 15491, 15857, 15858, 15859, 15862, 15969, 15978, 20020, 22005).
    - Fixed mob type for creatures(21787, 15670, 19622, 20060, 20062, 20063, 20064, 21362, 21787, 22457)
    ###Julianx's Site### Filebeam Includes:
    • Homepage
    • Account Creation
    • Server Stats
    • Armory
    • WoW:WOTLK Ripped Site
    • Staff
    • Donations
    • phBB3 Forums
    Site Preview: Frosthold WoW Execute this in ascentlogon, so the armory works:
    Code:
    CREATE TABLE `item_cache` (
      `item_name` varchar(100) NOT NULL,
      `item_id` varchar(100) NOT NULL default '0',
      `item_lang` varchar(2) NOT NULL default 'en',
      `item_link` varchar(100) default NULL,
      `item_color` varchar(20) NOT NULL,
      `item_icon` varchar(50) NOT NULL,
      `item_html` text NOT NULL,
      PRIMARY KEY  (`item_name`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    ###SQLyog 6.05### SQLyog ###MySQL 5.0.45### MySQL ###Map Extractors### ad.exe deDE [Download] ad.exe enGB [Download] ad.exe enUS [Download] ad.exe frFR [Download] ad.exe spSP [Download] ad.exe esEs [Download] ###Ascent Compiled Revisions### NOTE:These Compile do Not Come With DBC Files, But there is a Download for Them Below the Compiles. [Ascent]Czark's Compiles: Board Message(You Need To Register) [Ascent]2.1.x DBC Files: Filebeam - Free Fast File Hosting ========================================== •••Server Set-up Guide••• ========================================== ###Step 1:Setting Up MySQL### 1) Open the MySQL 5.0.41 Essentials installer and click "Next"-Image 2) Choose "Typical" and click "Next"-Image 3) Click "Install"-Image 4) After installation, click "Next" twice, till the last tab of this wizard.-Image 5) Check the option "Configure the MySQL Server now" and click "Finish"-Image 6) Just click "Next"-Image 7) Choose "Standard Configuration" and click "Next"-Image 8) Check the options "Install As Windows Service" and "Launch the MySQL Service automatically", then click "Next"-Image 9) Check "Modify Security Settings" and create a password, then click "Next"-Image 10) Just click "Execute"-Image 11) Check that everything gone well and then click "Finish"-Image ###Step 2: Setting up SQLyog### 1) Start the SQLyog Comunity 6.04 installer and click "Next"-Image 2) Check "I accept the terms in the License Agreement", then click "Next"-Image 3) Select your favorite options, then click "Next"-Image 4)Choose a folder, then click "Install"-Image 5)Wait until the setup is completed succesfully, then click "Next"-Image 6) Check "Run SQLyog Comunity 6.04" and click "Finish"-Image 7)Just click "Continue..."-Image 8)Fill the Password cell with your MySQL root password (the password is the one you used during MySQL 5.0.41 Essentials configuration), then click "Connect"-Image 9)Agree and save your password in SQLyog connection manager-Image 10)Right click on "root@localhost" and select "Create Database..."-Image 11) Put "ascent" (without quotes) and click "Create" 12)Right click on "ascent" and select "Restore From SQL Dump..."-Image 13) Browse your "sql" folder and select the database "TNDB8". Click "Open" then "Execute" (you will have to extract the DB from the RAR file) NOTE: This will not take as long as other DB's it will be ready in 1-3 minutes tops. 14) Again, Right click on "root@localhost" and select "Create Database..."-Image 15) Put "ascentlogon" (without quotes) and click "Create" 16) Right click on "ascentlogon" and select "Restore From SQL Dump..." 17) Browse your "sql" folder and select the file"Character & Logonserver Tables". Click "open" then "Execute" (you will have to extract the file from the RAR file) 18) When the import is completed successfully, click "Close"-Image 19) Click on "Refresh Object Browser" , then select "accounts" table in your "ascentlogon" database. Now click on "Table Data" and you will see your "accounts" table data. 20) Fill the cells to whatever you want your acct to be. To make TBC go to very end of cells and change the flags to "8". To make self GM enter "az" into the GM cell. then click "Save Changes"-Image 21) Close SQLyog Comunity 6.04-Image ###Step 3: Editing Config Files### Note:Change all Written in Orange, to your info. 1) Ascent.conf
    Code:
    #######################################################################
    # Ascent Configuration File
    # Last updated at revision 880 by Burlex
    #######################################################################
    
    /********************************************************************************
     * How to use this config file:                                                 *
     * Config files are in a block->variable->setting format.                       *
     * A < signifies the opening of a block, the block name is expected after that. * 
     * After the block name, a space and then the settings sperated by = / ' '.     *
     *                                                                              *
     * e.g.                                                                         *
     * <block setting="0" someval = "1">                                            *
     *                                                                              *
     * Comments can be in C format, e.g. /* some stuff */, with a // at the start   *
     * of the line, or in shell format (#).                                         *
     ********************************************************************************/
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Database Section
    #
    #   Database.Host      - The hostname that the database is located on
    #   Database.Username  - The username used for the mysql connection
    #   Database.Password  - The password used for the mysql connection
    #   Database.Name      - The database name
    #   Database.Port      - Port that MySQL listens on. Usually 3306.
    #   Database.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <WorldDatabase Hostname = "127.0.0.1" Username = "root" Password = "MySQL Pass" Name = "Name of Main Database" Port = "3306" Type = "1">
    <CharacterDatabase Hostname = "127.0.0.1" Username = "root" Password = "MySQL Pass" Name = "Name of Logonserver Database" Port = "3306" Type = "1">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Listen Config
    #
    #    Host
    #        This is the address that the server will listen on.
    #        To listen on all addresses, set it to 0.0.0.0
    #        Default: 127.0.0.1 (localhost)
    #
    #    WorldServerPort
    #        This is the port that the world server listens on.
    #        It has to be the same as what is specified in the
    #        realms table in the LogonDatabase.
    #        Default: 8129
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <Listen Host = "0.0.0.0"
            WorldServerPort = "8129">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Log Level Setup
    #
    #    Console Logging Level
    #        This directive controls how much output the server will
    #        display in it's console. Set to 0 for none, or -1 to disable.
    #        -1 = Disabled; 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
    #        Default: 3
    #
    #    World server packet logging feature
    #        If this directive is turned on, a file called `world.log`
    #        will be created in the server's directory and all packets
    #        sent and received by clients will be dumped here in bfg
    #        format.
    #        Default: 0
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <LogLevel Screen="0" File="-1" World="0">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Server Settings
    #
    #    PlayerLimit
    #        This directive controls the amount of sessions that will be
    #        accepted by the server before it starts to add people to 
    #        the server queue.
    #        Default: 100
    #
    #    PlrUpdateDistance
    #        This directive controls the distance (internal yards) that the player can "see" up to
    #        and receieve updates for. For smaller servers, you can probably increase this number.
    #        Increasing this number will also increase the servers bandwidth consumption and CPU usage.
    #        Default: 80
    #
    #    Motd
    #        This message will be displayed by the server in the chat
    #        box every time any user logs on. Colors can be used in the
    #        standard WoW format.
    #        Default: "No MOTD specified
    #
    #    Send Build On Join
    #        This directive controls whether the server's internal revision
    #        will be sent to clients upon entering the world. Use it to help
    #        testers report bugs.
    #
    #    Send Stats On Join
    #        This directive controls whether the server will send the online player
    #        count to a cilent when it enters the world.
    #
    #    Breathing Setup
    #        If the breathing code is causing problems or you want to run a fun server, you can disable 
    #        water checks by enabling this directive.
    #        Default: 1
    #
    #    Speedhack detection
    #        If this directive is turned on, speedhack detection will be activated and speedhackers
    #        will be warned / kicked.
    #        Default: 0
    #
    #    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: 60
    #
    #    Expansion 1 Level Cap
    #       This variable does the same thing as Level Cap above, except it applies to those who
    #       have the first expansion: The Burning Crusade.
    #       Default: 70
    #
    #    Seperate Channels Control
    #        This directive controls whether horde and alliance chats will be seperated across channels.
    #        Set to 1 for blizzlike seperated channels, or 0 to allow horde/alliance to speak to each other
    #        across channels.
    #        Default: 0
    #
    #    Compression Threshold
    #        This directive controls the limit when update packets will be compressed using deflate.
    #        For lower-bandwidth servers use a lower value at the cost of cpu time.
    #        Default: 1000
    #
    #    Queue Update Rate
    #        This directive controls how many milliseconds (ms) between the updates
    #        that the queued players receieve telling them their position in the queue.
    #        Default: 5000 (5 seconds).
    #
    #    Kick AFK Players
    #        Time in milliseconds (ms) that a player will be kicked after they go afk.
    #        Default: 0 (disabled)
    #
    #    Connection Timeout
    #        This directive specifies the amount of seconds that the client will be disconnected
    #        after if no ping packet is sent. It is advised to leave it at the default.
    #        Default: 180
    #
    #    Realm Type
    #        This is the realm type that will be used by the server to handle world pvp.
    #        Default: 0 (pve)(RPPVE)
    #        Other values: 1(pvp)(RPPVP)
    #
    #    AdjustPriority
    #        Set the server to high process priority?
    #        Default: 0
    #
    #    RequireAllSignatures
    #        This directive controls whether the full 10 signatures will be required in order
    #        to turn in a petition. Smaller servers would be better off having it turned off.
    #        Default: off
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <Server PlayerLimit = "100"
            PlrUpdateDistance = "80"
            Motd = "No MOTD specified."        
            SendBuildOnJoin = "1"
            SendStatsOnJoin = "1"
            EnableBreathing = "1"
            SpeedhackProtection = "0"
            LevelCap = "60"
            Expansion1LevelCap = "70"
            SeperateChatChannels = "0"
            CompressionThreshold = "1000"
            QueueUpdateInterval = "5000"
            KickAFKPlayers = "0"
            ConnectionTimeout = "180"
            RealmType = "1"
            AdjustPriority = "0"
            RequireAllSignatures = "0">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Die Directive
    #
    #    If this triggers it means you didn't read your config file!
    #    Just comment it or remove it when you've read this.
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <die msg="I am a newb who didn't even read half my config file!">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Power regeneration multiplier setup
    # 
    #    These directives set up the multiplier in which regen values will be
    #    multiplied by every 2 seconds.
    #    Powers: 
    #        Power1 = Mana, Power2 = Rage, Power3 = Energy
    #    
    #    Reputation:
    #        Kill = Rep gained on kill, Quest = rep gained from quests
    #
    #    Honor:
    #        Honor = multiplier used to calculate honor per-kill.
    #
    #    PvP:
    #        PvPTimer = in ms, the timeout for pvp after turning it off. default: 5mins (300000)
    #
    #    XP:
    #        The xp that a player receives from killing a creature will be multiplied
    #        by this value in order to get his xp gain.
    #
    #    RestXP: 
    #        Value is the amount of rest XP a player will recieve per minute of rest time.
    #
    #    Drop:
    #        This value will be multiplied by any gold looted and the drop percentages of the
    #        items for creatures will also be multiplied for this to determine which items
    #        to drop.
    #
    #    Save:
    #        Value in milliseconds (ms) that will be between player autosaves.
    #        Default: 300000 (5 minutes)
    # 
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <Rates Health="1"
           Power1="1"
           Power2="1"
           Power3="1"
           QuestReputation="1"
           KillReputation="1"
           Honor="1"
           PvPTimer="300000"
           Compression="1"
           XP="1"
           QuestXP="1"
           RestXP="1"
           Drop="1"
           DropMoney="1"
           Save="300000">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # GM Client Channel
    #
    #   This should be set to 'gm_sync_channel' for the My_Master addon to work.
    #
    #   Default: gm_sync_channel
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <GMClient ReqGmClient = "0" GmClientChannel = "gm_sync_channel">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Terrain Configuration
    #
    #   Set the path to the map_xx.bin files and whether unloading should be enabled
    #   for the main world maps here. Unloading the main world maps when they go idle
    #   can save a great amount of memory if the cells aren't being activated/idled
    #   often. Instance/Non-main maps will not be unloaded ever.
    #
    #   Default:
    #      MapPath = "maps"
    #      UnloadMaps = 1
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <Terrain MapPath = "maps" UnloadMaps = "1">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Log Settings
    # 
    #    Cheaters:
    #        This directive sets up the cheater logging file, if turned on any
    #        cheat / packet exploit / speedhack attempts will be logged here.
    #
    #    GMCommands:
    #        These two directives set up the GM command logging fie. If turned on,
    #        most gm commands will be logged for this file for abuse investigation, etc.
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <Log Cheaters="0" GMCommands="0">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Mail System Setup
    #
    #    These directives control the limits and behaviour of the ingame mail system.
    #    All options must have Mail prefixed before them.
    #   
    #    ReloadDelay                 
    #        Controls the delay at which the database is "refreshed". Use it if you're
    #        inserting mail from an external source, such as a web-based interface.
    #        0 turns it off.
    #        Default: 0
    #
    #    DisablePostageCostsForGM 
    #        Enables/disables the postage costs for GM's. DisablePostageCosts overrides this.
    #        Default: 1
    #
    #    DisablePostageCosts
    #        Disables postage costs for all players.
    #        Default: 0
    #
    #    DisablePostageDelayItems
    #        Disables the one hour wait time when sending mail with items attached.
    #        Default: 1
    #
    #    DisableMessageExpiry
    #        Turns off the 30 day / 3 day after read message expiry time. 
    #        WARNING: A mailbox still cannot show more than 50 items at once
    #        (stupid limitation in client).
    #        Default: 0
    #
    #    EnableInterfactionMail
    #        Removes the faction limitation for sending mail messages. Applies to all players.
    #        Default: 1
    #
    #    EnableInterfactionMailForGM 
    #        Removes the faction limitation for sending mail messages, but only applies
    #        to GM's. EnableInterfactionMail overrides this.
    #        Default: 1
    #   
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <Mail ReloadDelay="0"
          DisablePostageCostsForGM="1"
          DisablePostageCosts="0"
          DisablePostageDelayItems="1"
          DisableMessageExpiry="0"
          EnableInterfactionMail="1"
          EnableInterfactionMailForGM="1">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Status Dumper Config
    #
    #        These directives set up the status dumper plugin. Filename is an
    #        absolute or relative path to the server binary. Interval is the
    #        time that the stats will be dumped to xml.
    #        Default: stats.xml / 120000 (2 minutes)
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <StatDumper FileName = "stats.xml" Interval = "120000">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Startup Options
    #
    #    Preloading
    #        This directive controls whether the entire world will be spawned at server
    #        startup or on demand. It is advised to leave it disabled unless you are a
    #        developer doing testing.
    #        Default: off
    #
    #    Background Loot Loading
    #        This directive controls whether loot will be loaded progressively during
    #        startup or in the background in a seperate thread. Turning it on will
    #        result in much faster startup times.
    #        Default: on
    #
    #    Multithreaded Startup
    #        This controls whether the server will spawn multiple worker threads to
    #        use for loading the database and starting the server. Turning it on
    #        increases the speed at which it starts up for each additional cpu in your
    #        computer.
    #        Default: on
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <Startup Preloading = "0"
             BackgroundLootLoading = "1"
             EnableMultithreadedLoading = "1">
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Flood Protection Setup
    #
    #    Lines
    #        This is the number of "messages" or lines that it will allow before stopping messages from
    #        being sent. This counter is reset every "Seconds" seconds.
    #        Default: 0 (disabled)
    #
    #    Seconds
    #        This is the number of seconds inbetween the Line counter being reset.
    #        Default: 0 (disabled)
    #
    #    SendMessage
    #        If this is enabled, a "Your message has triggered serverside flood protection. You can speak again in %u seconds."
    #        message will be sent upon flood triggering.
    #        Default: 0
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <FloodProtection Lines = "0" Seconds = "0" SendMessage = "0">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # LogonServer Setup
    #
    #    DisablePings   
    #        This directive controls whether pings will be sent to the logonserver to check
    #        if the connection is still "alive". Expect problems if it is disabled.
    #        Default: 0
    #
    #    RemotePassword
    #        This directive controls the password used to authenticate with the logonserver.
    #        It must be the same between the two configs. If it is not, your server will
    #        not register.
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <LogonServer DisablePings = "0"
                 RemotePassword = "Put anything you want">
    
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Die Directive
    #
    #    If this triggers it means you didn't read your config file!
    #    Just comment it or remove it when you've read this.
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <die2 msg="I read nearly all my config file, but not the whole thing!">
    2) Logonserver.conf
    Code:
    #######################################################################
    # Ascent Realms Configuration File
    # Last updated at revision 446 by Burlex
    #######################################################################
    
    /********************************************************************************
     * How to use this config file:                                                 *
     * Config files are in a block->variable->setting format.                       *
     * A < signifies the opening of a block, the block name is expected after that. * 
     * After the block name, a space and then the settings sperated by = / ' '.     *
     *                                                                              *
     * e.g.                                                                         *
     * <block setting="0" someval = "1">                                            *
     *                                                                              *
     * Comments can be in C format, e.g. /* some stuff */, with a // at the start   *
     * of the line, or in shell format (#).                                         *
     ********************************************************************************/
    
    # LogonDatabase Section
    #
    #    These directives are the location of the `realms` and `accounts`
    #    tables.
    #
    #    LogonDatabase.Host      - The hostname that the database is located on
    #    LogonDatabase.Username  - The username used for the mysql connection
    #    LogonDatabase.Password  - The password used for the mysql connection
    #    LogonDatabase.Name      - The database name
    #    LogonDatabase.Port      - Port that MySQL listens on. Usually 3306.
    #    LogonDatabase.Type      - Client to use. 1 = MySQL, 2 = PostgreSQL, 3 = Oracle 10g
    #
    
    <LogonDatabase Hostname = "127.0.0.1"
                   Username = "root"
                   Password = "MySQL Pass"
                   Name     = "Name of Logonserver Database"
                   Port     = "3306"
                   Type     = "1">
    
    
    # Host Directive
    #
    #    This is the address that the realmlist will listen on.
    #    To listen on all addresses, set it to 0.0.0.0
    #    Default: 127.0.0.1 (localhost)
    #
    #    Note: ISHost is the interserver communication listener.
    #
    
    <Listen Host = "0.0.0.0"
            ISHost = "0.0.0.0"
            RealmListPort = "3724"
            ServerPort = "8093">
    
    # Server console logging level
    #
    #    This directive controls how much output the server will
    #    display in it's console. Set to 0 for none.
    #    0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
    #    Default: 3
    #
    
    <LogLevel Screen = "0"
              File = "-1">
    
    # Account Refresh Time
    #
    #    This controls on which time interval accounts gets 
    #    refreshed. (In seconds)
    #    Default = 600
    #
    
    <Rates AccountRefresh = "600">
    
    # Accepted Build Range Setup
    #
    #    These two directives set up which clients will be
    #    allowed to authenticate with the realm list.
    #
    #    Set these to the same builds that the server was
    #    compiled for.
    #
    #    As of the last update, version 2.1.1 was build 6739.
    #
    
    <Client MinBuild = "6739"
            MaxBuild = "6898">
    
    # WorldServer Setup
    #
    #    This directive controls the password used to authenticate with the worldserver.
    #    It must be the same between the two configs. If it is not, your server will
    #    not register.
    #
    #    Default: "change_me_logon"
    #
    
    <LogonServer RemotePassword = "Same as Ascent Remote Pass">
    2) Realms.conf
    Code:
    #######################################################################
    # Ascent Realms Configuration File
    # Last updated at revision 446 by Burlex
    #######################################################################
    
    /********************************************************************************
     * How to use this config file:                                                 *
     * Config files are in a block->variable->setting format.                       *
     * A < signifies the opening of a block, the block name is expected after that. * 
     * After the block name, a space and then the settings sperated by = / ' '.     *
     *                                                                              *
     * e.g.                                                                         *
     * <block setting="0" someval = "1">                                            *
     *                                                                              *
     * Comments can be in C format, e.g. /* some stuff */, with a // at the start   *
     * of the line, or in shell format (#).                                         *
     ********************************************************************************/
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # LogonServer Section
    #
    #    Address:
    #        The address (no port) of the server.
    #
    #    Port:
    #        The port on which the logon server listens. (*** NOT 3724 ***)
    #
    #    Name:
    #        Not really relavant, but name the logon.
    #
    #    RealmCount:
    #        The number of realms in the next section.
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <LogonServer Address = "127.0.0.1"
                 Port = "8093"
                 Name = "Default Logon"
                 RealmCount = "1">
    
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    # Realm Section
    #
    #    Name:
    #        The name of the realm.
    #    
    #    Address:
    #        The address (and port) of that realm.
    #
    #    Icon:
    #        The type of realm (PVP, Normal, RPPVP, RP)
    #
    #    Colour:
    #        Realm colour in realm list display.
    #
    #    TimeZone:
    #        Time zone the realm is in.
    #
    #    Population:
    #        (0 = low, 1 = medium, 2 = high)
    #
    #-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
    
    <Realm1 Name = "Your Relam Name"
            Address = "External IP:8129"
            Icon = "PVP"
            Colour = "1"
            Population = "1.0"
            TimeZone = "1">
    Guideline: 1. Include Pictures of the Main Problem 2. Write a detailed description of the problem 3. Include all configs and please put
    Code:
     tage areound them, the 
    Code:
     tag button is .
    Follow this and I will help you as much I can
    Code:
    Code:
     ==========================================
     •••How-to Make Server Public Guides•••
    ==========================================
     
     No Router Set-up Guide: http://forum.ragezone.com/f114/tutor...amachi-273763/
     
    Router Set-up Guide and Hamachi: Board Message(you will have to Register for this Forum)
     
     ========================
    •••Credits•••
     ========================
    Thx To the Entire TeraNET and Project Silvermoon Team for the Main DB 
    Thx To Myself For the Repack
    Thx To Czark for All the Compiles 
    Thx To Panex for the Site, but for the tools thx to Emupedia and Emuchat.
    Thx To the DatabaseEVOLVED Team for their DB
    Thx To DarkID (walla!) and his awesome New DB team of "Next-Chapter" Database for their Database
    Note: There will be additions to the Guide within the Few days, Fixes, and more downloads, etc
    zsdf
    [/quote]
    Code:
    quote=channel_49;2507444]Version 3.0
     For version 3.0 to work, you have to get ascent 1132 or higher!
     
     Ascent 1132 requires you to update your tables:
     
    Code:
    ALTER TABLE creature_proto CHANGE health minhealth int(30) unsigned NOT NULL;
     ALTER TABLE creature_proto ADD column maxhealth int(30) unsigned NOT NULL AFTER minhealth;
     UPDATE creature_proto SET maxhealth = minhealth;
     ALTER TABLE creature_proto CHANGE level minlevel int(30) unsigned NOT NULL;
     ALTER TABLE creature_proto ADD column maxlevel int(30) unsigned NOT NULL AFTER minlevel;
     UPDATE creature_proto SET maxlevel = minlevel;
     ALTER TABLE creature_proto ADD column invisibility_type int(30) unsigned NOT NULL;
     ALTER TABLE creature_proto ADD column death_state int(30) unsigned NOT NULL;
    Requirements: Ascent Core 1132 or higher: Latest Ascent Core+Database - MMORPG Development Forums - RaGEZONE (sponsored by TFN.gr) TerraNet Public (Rev8): TerraNet WoW Forums -> Public Releases Installation: 1) Download and install TerraNet Public, other databases won't do. 2) Download and extract the attached zip file in this post. 3) Go to your sql manager, such as Navicat or SQLyog. 4) Right click your database and Execute Batch File (Navicat) or Restore From Sql Dump (SQLyog). 5) Run the extracted .sql file as a query. 6) After installing all these, restart your server. 7) Navigate to your WoW folder, and delete the cache folder. 8) Once ingame, type .npc spawn (ID) to spawn the vendors at your location. 9) The npc IDs can be found in this post, if you scroll down. Remember to delete CACHE folder from wow client after installing. Changelog: Version 2.5: Major ID change and cleanup. Version 2.6: New items in cloak, rings, trinkets New items in 100+ weapons, currency. Query now contains the buyprice "fix". Repacked for rev8, included custom_shop_buyprice.sql. Version 2.7: Changed displayids to blood elves >.>. Added keys vendor. Version 2.8: Resized vendors to same size as normal npcs. All vendors have been spawns in the HOUSE of GM Island. Added custom_shop_spawn.sql. WARNING: the spawn query will first delete ALL spawn of GM vendors, make sure you either back them up or just delete the first line of the query. Version 2.9: Added custom_shop_buyprice_extend.sql so people can get rid of itemextendedcost. Revised custom_shop_buyprice.sql so now it should run fast, and you won't get anymore freezes or wait time. Version 2.9a: Fixed a tiny bug in the custom_shop_buyprice_extend query. Version 3.0: Changed a few spawns around, removed recipe/reagent from spawns because they are taking too much space inside the house for future spawns. Not a lot of people need vendors that specific anyways, so if you want them spawn them yourself. Made vendors compatible with latest ascent core (1132 and higher), you will have to update your database with the query posted above. Added enchantment and off-hands vendors. Vendors (71): 50000 Armor Dungeon I 50001 Armor Dungeon II 50002 Armor Dungeon III 50003 Armor Raid Tier I 50004 Armor Raid Tier II 50005 Armor Raid Tier III 50006 Armor Raid Tier IV 50007 Armor Raid Tier V 50008 Armor Raid Tier VI 50009 Armor Wrist 50010 Armor Waist 50011 Armor Feet 50012 Armor Shield 50015 Weapon Level 50+ 50016 Weapon Level 60+ 50017 Weapon Level 65+ 50018 Weapon Level 75+ 50019 Weapon Level 100+ 50020 Armor Necklace 50021 Armor Rings 50022 Armor Trinket 50023 Armor Cloak 50024 Armor Shirt 50025 Armor Tabard 50026 Armor Miscellaneous 50028 Armor Off-Hands 50029 Armor Libram/Idol/Totem 50030 Arena Season I 50031 Arena Season I 50032 Arena Season I 50033 Arena Season II 50034 Arena Season II 50035 Arena Season II 50040 Misc Gemstone I 50041 Misc Gemstone II 50042 Misc Mount I 50043 Misc Mount II 50044 Misc Projectile 50045 Misc Container 50047 Misc Enchantment 50048 Misc Key 50049 Misc Currency 50050 Recipe Book A-Z 50051 Recipe Leather A-F 50052 Recipe Leather G-R 50053 Recipe Leather S-Z 50054 Recipe Tailor A-G 50055 Recipe Tailor H-Z 50056 Recipe Engineer A-Z 50057 Recipe Blacksmith A-F 50058 Recipe Blacksmith G-R 50059 Recipe Blacksmith S-Z 50060 Recipe Cooking A-Z 50061 Recipe Alchemy A-Z 50062 Recipe Enchant A-G 50063 Recipe Enchant H-Z 50064 Recipe Jeweler A-K 50065 Recipe Jeweler L-Z 50066 Reagent Leather I 50067 Reagent Leather II 50068 Reagent Tailor I 50069 Reagent Tailor II 50070 Reagent Engineer I 50071 Reagent Engineer II 50072 Reagent Blacksmith I 50073 Reagent Blacksmith II 50074 Reagent Cooking 50075 Reagent Alchemy 50076 Reagent Enchant 50077 Reagent Jeweler 50078 Reagent Miscellaneous Credits: Credits partially to AMVendor creators for their concept and Dungeon Set 1-3 and Tier 1-6, everything else (rings, trinkets, weapons, etc) I re-did or added, even the organization of the armor sets I revamped. I also moved the vendor IDs to 50000+ to avoid taking up important NPC ids, and changed other details.[/quote]

    Thanks and credit go to Bloodshed2007 , JULIAN_X , Channel49 , zhangweizheng3 and everybody at rage zone and terranet, for there hard work and help. lol i hope i don't get my head lobbed off. This Is A Funserver DB!
    :poster_be will be updating if thats ok....

    DB: DOWNLOAD NOW!
    CORE: DOWNLOAD NOW!
    DBC, MAPS:MEGAUPLOAD - The leading online storage and file delivery service
    Last edited by foreverbanned13; 15-12-07 at 11:00 PM.


  2. #2
    Sorcerer Supreme channel_49 is offline
    Member +Rank
    Jun 2007 Join Date
    385Posts

    Re: Nice DB rev8!

    If you're ever interested in developing db stuff, join our new TN public team :)

  3. #3

    Re: Nice DB rev8!

    hey i might but good place to upload?

  4. #4
    Sorcerer Supreme channel_49 is offline
    Member +Rank
    Jun 2007 Join Date
    385Posts

    Re: Nice DB rev8!

    Upload as in submit patches? Sure.

  5. #5

    Re: Nice DB rev8!

    well i will what stuff like weapons, armor, bags, npcs etc?

  6. #6
    Sorcerer Supreme channel_49 is offline
    Member +Rank
    Jun 2007 Join Date
    385Posts

    Re: Nice DB rev8!

    Anything really, anything you want to fix, just join up.

  7. #7

    Re: Nice DB rev8!

    ok
    :P



Advertisement