[Guide/Arcemu] Totem Vendor menu

These ads disappear when you log in.

Results 1 to 5 of 5
  1. #1
    marco1234's Avatar Master Sergeant
    Reputation
    46
    Join Date
    May 2008
    Posts
    137
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    [Guide/Arcemu] Totem Vendor

    Hello guys, everytime I make a new server.. With a Blizzlike DB, I need to make a vendor.. You guys also have the same problem? Or even don't know how to make one? Than look here. If you don't know how to import them than follow the guide below.

    DON'T FLAME ON ME LIKE THINGS: "Omfg every ****ing freak know how to make one"
    Just think, there many people even don't know how to create an Account on there server.. So this is may nicer for them and quicker!


    For the beginners guide, scroll down.


    MySQL IMPORT QUERY:
    INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
    VALUES (777799, 82, 82, 814, 67756, 67756, 5345, 1, 128, 1800, 150, 250, 1800, 500, 650, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
    INSERT INTO creature_names (entry, `name`, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unknown_float1, unknown_float2, Civilian, Leader, info_str)
    VALUES (777799,"Achmed the Dead Terrorist","Totem Vendor",0,7,0,0,0,NULL,24191,24191,1, 1,1,NULL, '');
    INSERT INTO vendors (entry, item, amount)
    VALUES (777799,5177,0);
    INSERT INTO vendors (entry, item, amount)
    VALUES (777799,5176,0);
    INSERT INTO vendors (entry, item, amount)
    VALUES (777799,5178,0);
    INSERT INTO vendors (entry, item, amount)
    VALUES (777799,5175,0);

    Beginners Guide if you use HeidiSQL:

    1.-) Start "HeidiSQL.exe" a window will appear, Hit- "Connect".

    2.-) Double click on you World Database (Default = "World")

    3.-) Near the top you'll see: "Host", "Database" and "Query" click on "Query"

    4.-) Copy the Query above ("MySQL IMPORT QUERY") and paste it there.

    5.-) Now you have to find a Blue ">" and click on it at the right top. or just hit "F9".

    6.-) If it's done, close HeidiSQL and (Re)start your server.

    7.-) Log-in and do this: /s .npc spawn 777799 Now your done!





    Beginners Guide if you use Navicat:

    1.-) Start "Navicat", Double click on your Database.

    2.-) Double click on your World database (Default = "World")

    3.-) Below the World DB name you have to find "Queries".

    4.-) Right click on "Queries" and hit "New Query".

    5.-) Copy the Query at the very top of the thread (MySQL IMPORT QUERY) and paste it in the Box at your Navicat.

    6.-) Hit "Run" and wait till it's done.

    7.-) Close Navicat and (Re)start Navicat.

    8.-) Log-in and do this: /s .npc spawn 777799 Now your done!



    Cya.
    I'm a proffesional DB Developer, worked for top servers like WoWScape, UberWoW etc. I can work for you aswell, add me on MSN: [email protected]
    Still looking for a host, be part of a great succes and earn much money. Add me on MSN.

    These ads disappear when you log in.

  2. #2
    EmiloZ's Avatar Flying Piggy Back
    CoreCoins User
    Reputation
    538
    Join Date
    Jun 2007
    Posts
    1,393
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Please make the text smaller!!!
    +Rep
    Why fill up a signature?

  3. #3
    marco1234's Avatar Master Sergeant
    Reputation
    46
    Join Date
    May 2008
    Posts
    137
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Originally Posted by EmiloZ View Post
    Please make the text smaller!!!
    +Rep
    I saw it. Changed it directly
    I'm a proffesional DB Developer, worked for top servers like WoWScape, UberWoW etc. I can work for you aswell, add me on MSN: [email protected]
    Still looking for a host, be part of a great succes and earn much money. Add me on MSN.

  4. #4
    abhorsenjay's Avatar Contributor
    Reputation
    254
    Join Date
    Sep 2008
    Posts
    329
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    I'll make sure to try this when I get mine public

  5. #5
    silverbg's Avatar Private
    Reputation
    1
    Join Date
    Mar 2009
    Posts
    7
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Thanks man ! Good job !

Similar Threads

  1. Guide to Make Vendors and Custom Items the Easy Way!!!
    By Jackie Moon in forum WoW EMU Guides & Tutorials
    Replies: 5
    Last Post: 05-22-2008, 02:23 PM
  2. [n00b Guide] Creating custom vendors. Very detailed.
    By c0ddingt0n in forum WoW EMU Guides & Tutorials
    Replies: 3
    Last Post: 04-23-2008, 10:41 PM
  3. Help me make a totem Vendor
    By Anarchy in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 02-16-2008, 08:49 PM
All times are GMT -5. The time now is 11:42 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search