[katmiaugo]

DB 9560 INSTALL

Download and Install Mysql - Navicat
MySql : HERE
Navicat : HERE

RELEASE
Vehicle
Dual Spec lvl40 100%
Fix Quest DK
Honor ranks
Guildhouse Keeper (ScriptDev2)
Ally&Horde in the same group
+ Add new Items
+ Fix the population
+ Fix Quests's scripts
+ Fix the [gossip]
+ Fix “npc_text” for 3.3.2

CREATE DB 9560
Execute Navicat and Create New Tabla: characters, mangos, realmd and scriptdev2.Format [Utf8][general_ci]

Restaured DB 9560 Full to archives:
characters.sql,mangos.sql, realmd.sql and scriptdev2.sql

Change reamlist for connect to server in DB:
View Table: realmd -> reamlist ->(address)(Dbinfo)
conten change:

(address)
YOU IP or 127.0.0.1
(Dbinfo)
root;YOU PASS;3306;127.0.0.1;mangos;characters

CONFIG MANGOS 9560

Changes IP: 0.0.0.0 in mangosd.conf-reamd.conf
YOU IP LAN or 127.0.0.1

Changes User and Password in mangosd.conf-reamd.conf-scriptdev2:

;root;mangos;

;YOU USER;YOU PASS;

For Extract DBC and Maps:
Copy ad.exe in game client 3.3.2 and execute and wait.


OK RUN
mangosd.exe and reamld.exe

DOWNLOADS FULL 9560 MANGOS for Client 3.3.2 rev 11403

FULL DB 9560 : HERE
FULL DB 9321 : HERE FIX Characters DB HERE


Client 3.3.2 rev 11403

EMU Mangos 9560 : HERE
EMU Mangos 9321 : HERE



100% DB Server.

USE CLIENT 3.3.2 rev. 11403

Change realmlist.wtf to YOUR IP or 127.0.0.1

Pass: ragezoneRZ

[Quakes69]

Originally Posted by katmiaugo

Changes IP: 0.0.0.0 in mangosd.conf-reamd.conf YOU IP LAN

I've been using your script compiles for the last few days now and they work good. As for this new release, I'm yet to see if they are ok. The only problem is is that if I changed what you said of the (Changes IP: 0.0.0.0 in mangosd.conf-reamd.conf) config files I could NOT connect to my own server from another computer. I left them 0.0.0.0 and I could connect fine. Others out side my Net have no troubles connecting also. Just a heads up.

Quake

[katmiaugo]

Update 8902 SD2 of rev1513

*Dual Of talent Of specializations 100%
*Anticheat
*Heroic Of fury
*Lava Of burst
*Championship
*Aura 262 (realizing 6 [spelov])
*Heirloom of items XP of bonus

[cubansephiroth]

Congratulations for this post, the last update includes the AH????

[pmiller863]

Thanks but you are missing scriptdev2.sql

[cubansephiroth]

Where is the auctionhousebot table,
This is the error i´ve got

ERROR:SQL: SELECT minitems FROM auctionhousebot WHERE auctionhouse = 2
2000-12-03 15:18:51 ERROR:query ERROR: Table 'characters.auctionhousebot' doesn't exist

In the DB Full 8902 there is only the mangos.sql.

[katmiaugo]

Originally Posted by cubansephiroth

Where is the auctionhousebot table, This is the error i´ve got ERROR:SQL: SELECT minitems FROM auctionhousebot WHERE auctionhouse = 2 2000-12-03 15:18:51 ERROR:query ERROR: Table 'characters.auctionhousebot' doesn't exist In the DB Full 8902 there is only the mangos.sql.

Execute SQL File in you Navicat
Update you DB in characters:


FIX AH : HERE

[cubansephiroth]

Thanks katmiaugo but the link seems to be offline, it doesn´t work

Now this is the error

El archivo al que está intentando acceder está temporalmente desactivado.

The Link it´s working Now!!!!!!!!!

[wowcusco]

Ulduar and TOC are not working :(

[katmiaugo]

UPDATE Mangos and YTDB 8990 for Client 3.2.2a

Patch Mangos :
*Vehicles (it partially realizes the work of technology)
*Dual Of talent Of specialization's (it realizes [dvoinuyu] special-ALization)
*Earthen Of power (force of the Earth)
*Aura Of mastery (master of auras)

Scriptdev2:
*Improvements in of scripts of for of raid of instance Of naxxramas
*Added of scripts of for of raid of instance Of vault of Of archavon
*Added of script of for of npc of teleporter
*Added of script of for of npc of arena-honor of exchanger
*Some of improvements of for of boss Of supremus in of raid of instance Of black
Temple
*Disabled of one of spell of for of boss Of mother Of shahraz in of raid of instance
Black Of temple to of prevent a of server of crash
*Added of scripts of for of raid of instance Of ulduar
*Added of script of for of experience of eliminator. Required Of mangos of core
with [of patch 199]
*Added of support of for of spell Of dancing Of rune Of weapon. Requires of core of with
[patch 219]

[Quakes69]

OK katmiaugo, This 8990 Updates aren't working properly. So I went and did the Fix. Link above this post.

<!-- Edit -->
The mangos fix has errors in the health of foes. I've provided the update sql's to the errors of the health for foes.
SQL Fix Removed: MangosFix below takes care of the Foe Errors. Thanks.
<!-- End Edit -->

Also for some reason I can't get the buttons to show when spec is taken out of the `character_action`

-- ----------------------------
-- Table structure for character_action
-- ----------------------------
DROP TABLE IF EXISTS `character_action`;
CREATE TABLE `character_action` (
  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
--
  `spec` tinyint(3) unsigned NOT NULL default '0',
--
  `button` tinyint(3) unsigned NOT NULL default '0',
  `action` int(11) unsigned NOT NULL default '0',
  `type` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`guid`,`button`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';

This was also from the last update too. 8902 I could not get the buttons to return. If I replaced the buttons back to the way they were. they would not return after a relogin.

[katmiaugo]

Correction to DB

Download : HERE

[cubansephiroth]

Does the AH works in this new core 8990??? , I was using the 8902 and everything goes well, but the AH it´s not working now.

HELP.....

[ronisbr]

ad.exe not exist

edit--------

table characters Erro Unknown colunn 'speccount' in 'field list'

[Quakes69]

Originally Posted by cubansephiroth

Does the AH works in this new core 8990??? , I was using the 8902 and everything goes well, but the AH it´s not working now. HELP.....

Not sure, I haven't figured out how to enable the Bot yet. If you know, Tell me and I'll enable it and see. I'm running the 8990.

Originally Posted by ronisbr

ad.exe not exist edit-------- table characters Erro Unknown colunn 'speccount' in 'field list'

Depending what you installed. Here are the SQL codes.
speccount, activespec - REMOVED

-- ----------------------------
-- Table structure for characters
-- ----------------------------
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
  `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
  `data` longtext,
  `name` varchar(12) NOT NULL default '',
  `race` tinyint(3) unsigned NOT NULL default '0',
  `class` tinyint(3) unsigned NOT NULL default '0',
  `gender` tinyint(3) unsigned NOT NULL default '0',
  `level` tinyint(3) unsigned NOT NULL default '0',
  `xp` int(10) unsigned NOT NULL default '0',
  `money` int(10) unsigned NOT NULL default '0',
  `playerBytes` int(10) unsigned NOT NULL default '0',
  `playerBytes2` int(10) unsigned NOT NULL default '0',
  `playerFlags` int(10) unsigned NOT NULL default '0',
  `position_x` float NOT NULL default '0',
  `position_y` float NOT NULL default '0',
  `position_z` float NOT NULL default '0',
  `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
  `dungeon_difficulty` tinyint(1) unsigned NOT NULL default '0',
  `orientation` float NOT NULL default '0',
  `taximask` longtext,
  `online` tinyint(3) unsigned NOT NULL default '0',
  `cinematic` tinyint(3) unsigned NOT NULL default '0',
  `totaltime` int(11) unsigned NOT NULL default '0',
  `leveltime` int(11) unsigned NOT NULL default '0',
  `logout_time` bigint(20) unsigned NOT NULL default '0',
  `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
  `rest_bonus` float NOT NULL default '0',
  `resettalents_cost` int(11) unsigned NOT NULL default '0',
  `resettalents_time` bigint(20) unsigned NOT NULL default '0',
  `trans_x` float NOT NULL default '0',
  `trans_y` float NOT NULL default '0',
  `trans_z` float NOT NULL default '0',
  `trans_o` float NOT NULL default '0',
  `transguid` bigint(20) unsigned NOT NULL default '0',
  `extra_flags` int(11) unsigned NOT NULL default '0',
  `stable_slots` tinyint(1) unsigned NOT NULL default '0',
  `at_login` int(11) unsigned NOT NULL default '0',
  `zone` int(11) unsigned NOT NULL default '0',
  `death_expire_time` bigint(20) unsigned NOT NULL default '0',
  `taxi_path` text,
  `arena_pending_points` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`guid`),
  KEY `idx_account` (`account`),
  KEY `idx_online` (`online`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';

With speccount and, activespec

DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
  `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
  `data` longtext,
  `name` varchar(12) NOT NULL default '',
  `race` tinyint(3) unsigned NOT NULL default '0',
  `class` tinyint(3) unsigned NOT NULL default '0',
  `gender` tinyint(3) unsigned NOT NULL default '0',
  `level` tinyint(3) unsigned NOT NULL default '0',
  `xp` int(10) unsigned NOT NULL default '0',
  `money` int(10) unsigned NOT NULL default '0',
  `playerBytes` int(10) unsigned NOT NULL default '0',
  `playerBytes2` int(10) unsigned NOT NULL default '0',
  `playerFlags` int(10) unsigned NOT NULL default '0',
  `position_x` float NOT NULL default '0',
  `position_y` float NOT NULL default '0',
  `position_z` float NOT NULL default '0',
  `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
  `dungeon_difficulty` tinyint(1) unsigned NOT NULL default '0',
  `orientation` float NOT NULL default '0',
  `taximask` longtext,
  `online` tinyint(3) unsigned NOT NULL default '0',
  `cinematic` tinyint(3) unsigned NOT NULL default '0',
  `totaltime` int(11) unsigned NOT NULL default '0',
  `leveltime` int(11) unsigned NOT NULL default '0',
  `logout_time` bigint(20) unsigned NOT NULL default '0',
  `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
  `rest_bonus` float NOT NULL default '0',
  `resettalents_cost` int(11) unsigned NOT NULL default '0',
  `resettalents_time` bigint(20) unsigned NOT NULL default '0',
  `trans_x` float NOT NULL default '0',
  `trans_y` float NOT NULL default '0',
  `trans_z` float NOT NULL default '0',
  `trans_o` float NOT NULL default '0',
  `transguid` bigint(20) unsigned NOT NULL default '0',
  `extra_flags` int(11) unsigned NOT NULL default '0',
  `stable_slots` tinyint(1) unsigned NOT NULL default '0',
  `at_login` int(11) unsigned NOT NULL default '0',
  `zone` int(11) unsigned NOT NULL default '0',
  `death_expire_time` bigint(20) unsigned NOT NULL default '0',
  `taxi_path` text,
  `arena_pending_points` int(10) unsigned NOT NULL default '0',
  `speccount` tinyint(3) unsigned NOT NULL default '1',
  `activespec` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`guid`),
  KEY `idx_account` (`account`),
  KEY `idx_online` (`online`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';

[cubansephiroth]

Quake, in the 8902 the Ahbot works perfect, to enable it you need to edit your mangos.conf and look for


AuctionHouseBot.EnableSeller = 0 // You should put 1
AuctionHouseBot.EnableBuyer = 0 // You should put 1
AuctionHouseBot.Account = 0 //The id of the account you have created for the AH, look for in your realm database

AuctionHouseBot.GUID = 0//The GUID of the account you have created for the AH, look for in your characters database

You can leave the rest in the default way.

AuctionHouseBot.VendorItems = 0
AuctionHouseBot.LootItems = 1
AuctionHouseBot.OtherItems = 0
AuctionHouseBot.No_Bind = 1
AuctionHouseBot.Bind_When_Picked_Up = 0
AuctionHouseBot.Bind_When_Equipped = 1
AuctionHouseBot.Bind_When_Use = 1
AuctionHouseBot.Bind_Quest_Item = 0
AuctionHouseBot.ItemsPerCycle = 200
AuctionHouseBot.UseBuyPriceForSeller = 0
AuctionHouseBot.UseBuyPriceForBuyer = 0

Now i think i´ve discovered why the AH doesn´t work in 8990, it´s because wasnt compiled, mangos.conf miss the AH part,

[Quakes69]

Originally Posted by cubansephiroth

Quake, in the 8902 the Ahbot works perfect, to enable it you need to edit your mangos.conf and look for AuctionHouseBot.EnableSeller = 0 // You should put 1 AuctionHouseBot.EnableBuyer = 0 // You should put 1 AuctionHouseBot.Account = 0 //The id of the account you have created for the AH, look for in your realm database AuctionHouseBot.GUID = 0//The GUID of the account you have created for the AH, look for in your characters database You can leave the rest in the default way. AuctionHouseBot.VendorItems = 0 AuctionHouseBot.LootItems = 1 AuctionHouseBot.OtherItems = 0 AuctionHouseBot.No_Bind = 1 AuctionHouseBot.Bind_When_Picked_Up = 0 AuctionHouseBot.Bind_When_Equipped = 1 AuctionHouseBot.Bind_When_Use = 1 AuctionHouseBot.Bind_Quest_Item = 0 AuctionHouseBot.ItemsPerCycle = 200 AuctionHouseBot.UseBuyPriceForSeller = 0 AuctionHouseBot.UseBuyPriceForBuyer = 0 Now i think i´ve discovered why the AH doesn´t work in 8990, it´s because wasnt compiled, mangos.conf miss the AH part,

You are right. Totally missing from boot of the server.

[Quakes69]

Is waiting on new releases? Anytime soon? 3.3.* ???

[neotwo]

mmm... for 3.3 still are working

[katmiaugo]

New Update Mangos 9113 + YTDB Full

Fix to converter 3.2.2a to 3.3.0a in characters

Download : HERE

Note.- back to complete what still missing from the emulator and database

[koastore]

Hello,

Got the password for the YTDB 9113 by any chance?

Thanks

[katmiaugo]

UPDATE EMU 9225 + YTDB

Assembled the stable nucleus Of mangos 9225
Into complete set enter ONLY the files of server and the renovation of the base from the [patche] in the nucleus

+Fix to the trunks (after [luta] of trunks they they disappear, problem not in the base and in the nucleus)
+Fix SD2
+[nebolshoy] fixed price on the baggers
+Fix ytdb 330 not yet appeared is the assembling by [patchey] on the base db.

[DJAloneAtNight]

SQL: SELECT required_9222_01_mangos_playercreateinfo_spell FROM db_version LIMIT
1
query ERROR: Unknown column 'required_9222_01_mangos_playercreateinfo_spell' in
'field list'
Table `db_version` have field `required_8988_01_mangos_spell_proc_event` but exp
ected `required_9222_01_mangos_playercreateinfo_spell`! Not all sql updates appl
ied?

errrr what am i missing? i have double checked everything.

Edit: Nevermind, fixed it.

[katmiaugo]

UPDATE EMU 9321 + YTDB
For Client 3.3.2 rev. 11403
Dual Spc + Fix Qust DK

[Synistah]

Removed.