[X3 Release] Keazain`s Latest Compiles and Converted NCDB & Logon DB ready for use!

[vintvlad]

pls one mall and teleportar for mangos plss

[[Shon3m]]

NCDB is ascent yes its been awhile...

[keazain]

Soularis, nope, whydb is for ascent

vintvlad, i will make mall for mangos when im done fixing arcemu mall

NOTE! im right now fixing and re-ordering all NPC in fun/repack, so in next release i can promise you that absolutly everything is working and all tables is in DB.

All separated sql files to mall/npc/vendors/items/objects etc will be uploaded for all to download, so if you have a server and just want some of my stuff, you can get it

Keazain

[NitroMan]

hello keazain and i am using your repack i already am going to rep you so dont worry 1 thing : i need the complete list of all vendors cuz i want to make a separate mall ( 1 ally 1 horde .. ) i dont want to have all day long to stop pvp in mall .. can you give me the full list of vendors in the mall ? ill give you more rep for it

[Fugunsk]

People tell me what kind of base norwegian_db6
and how do I do with the server

[Sicco]

Keazain

Hi everybody,

I have a serious problem and it worries me ... I explain ... I have the latest core that works on my server. I have to place creatures in their area, make invalid id or I check the tables (creature_names - creature_proto) are so well and so they actually are in the db.

My question: how it was that even after 3 different core do the same thing?
the last core acemu 2010
Thank you to solve my problem

Good day

I understand this as: You don't know the ID's of the vendors.
Also, With updating you sometimes have to update the DB aswell.

Open up "creature_names" table in SQLyog/Navicat

(I'm using SQLyog)

Click "Show all" and let it load.
Once done, Click the "Entry" tab so that the HIGHEST number is at the top and the lowest at the bottom

There you should see the custom added NPC's

(700001-700030 & 900000-900047 (OBS: ALL NUMBERS IN THE SPECIFIED RANGE MAY NOT BE USED AND GIVE INVALID ID ERROR))
Trainers are @ 300030,300040,300060.

If this is not the answer you are looking for, Please try to make your question clearer and possibly alot easier to understand.

can you give me the full list of vendors in the mall ? ill give you more rep for it

There is a list of vendors somewhere in the folders, However, It does NOT match the Database ones.

Working on the list of vendors I have in my DB.
(x6 Fun)

--------Vendors---------

I don't wanted it to go too big, But copy this into a .txt document and you're set!

I did this for you Kea so that you can put more time into developing the awesomeness of yours
Keep up the good work! :wave:

.npc spawn <ID>
(Without the <>)

#Trainers.

300030 DK,Hunter & Pala trainer
300040 Rogue,Shaman & Warrior trainer
300050 Weapon trainer
300051 Riding Trainer
300052 GM Trainer
300053 Buff trainer
300060 Priest & Warlock Trainer

#New range, Random NPC's

700001 Rep NPC
700002 Buffer NPC
700003 Skill NPC
700004 MasterPorter NPC
700005 TalentReset NPC
700006 GuildHouse NPC
700007 Soundtrack NPC
700008 DK WeaponMaster NPC
700009 Instance NPC
700010 DK Morph NPC
700011 Healer NPc
700012 Lottery
700013 Gold Quest
700014 Sunwell Plateau
700015 Tier 7 Vendor
700016 PvPTitle NPC
700018 Welcomer
700019 Rewarder NPC
700020 Pay Npc
700021 Sexchange NPC
700022 LvlUp Token Trader
700029 Reward Npc
700030 Info Npc

#New Range, Twinks.

780000 Twink weapon
780001 Twink armor
780002 Twink Neck/Finger/Trinket
780004 Twink Back
780005 Twink mount

#New range, Vendors

900000 Tier 7 (1)(|)
900001 Tier 7 (2)(|)
900002 Season 5 (Arena)
900003 Weapons 200+ (Itemlevel 200+)
900004 Trinkets
900005 Tier7 (1)(||)
900006 Tier7 (2)(||)
900007 Weapon 200+ (ItemLevel200+)
900008 Trinket
900009 Rings
900010 Necklace
900011 Shields
900012 Tabard
900013 Season 5 (Arena)
900014 Relic
900015 Cloak
900016 Container (Bags)
900017 Glyph 1
900018 Glyph 2
900019 Wrist
900020 Book A-Z
900021 Leather A-Z
900022 Jewelcrafting A-Z
900023 Engineering/Enchanting A-Z
900024 Alchemy/Blacksmith/Tailoring A-Z
900026 Feet
900027 Heirloom
900028 Mounts
900029 Flying mount
900030 Enhancement Permanent
900031 Enhancement Temporary
900032 Enchanting
900033 Leatherworking
900034 Blacksmith
900035 Inscription
900036 Engineering
900037 Alchemy
900038 Tailoring
900039 General Goods
900040 Shirts
900041 Quiver/Ammo pouches/projectiles
900042 Offhands
900043 Currency
900047 Armor Tokens

[markbatt]

teleport locations are held in custom_teleporter table.

I have informed keazain about it.

also i would like him to add first aid trainer and the one called areana event generator to his builds

[keazain]

hi all

im making all new server and re-ordering all npc/vendors to server run perfectly. All .dll npc`s is fixed and vendors getting all fix also.
When im done later this night today, i will make a Huge update and ALL db as: t7 vendor, gold quest etc. etc. will be uploaded to you as single sql files, so if your patient, this will be the perfect final update for arcemu

[Sicco]

hi all

im making all new server and re-ordering all npc/vendors to server run perfectly. All .dll npc`s is fixed and vendors getting all fix also.
When im done later this night today, i will make a Huge update and ALL db as: t7 vendor, gold quest etc. etc. will be uploaded to you as single sql files, so if your patient, this will be the perfect final update for arcemu

Awesome (:

If you change the ID's ill remove/change the list aswell.

[senkin]

If I wanted to start a private server today, fresh. I already have MySQL ready as clean install. Which one of the links do you suggest me to use? I am sure I can figure out which files in it I need to use and how. I just wanted a suggestion on which server to use. I plan to start as a High-Rate Blizzlike Server then grow.

Thanks,
Aaron

(I know I look like a leecher, but I used to only use my lil' brother's mmowned account and got rep on there. zackorion15)

[keazain]

Sicco, almost ALL ID is different, i have cleaned all npc to work 100% and in order like in an archive in a office and this turned out to be more than perfect, now i can compile even MORE drivers into wow server

Im working on it still, but this night im making my huge update

senkin > i realy suggest you take arcemu, its the best for shure its the server most added !

[babos15]

WoW Arcemu has updated their SVN again

[keazain]

yes its 2018 now and im updating this night here

[keazain]

this new cleaning revision im making realy looks cool LOOL now i have added 20 .dll for npc
and 10 LUA npc loool this server GOT IT ALL!!!

[Sicco]

Sicco, almost ALL ID is different, i have cleaned all npc to work 100% and in order like in an archive in a office and this turned out to be more than perfect, now i can compile even MORE drivers into wow server

Awesome

Got some errors i experienced for you :P

The Guildhouse NPC does not respond to actions (Give me free house/Port me to my house)

And when i check the world (maybe was logon,didnt check,heh) gives the error that its wrong pass to DB.

How do you change that?

Oh, And custom items doesn't work, Still :/
NPC's work fine, But not items.