Mangos+YTDB Full Dual Spec + AH + AntiCheat

**katmiaugo** · 01-12-09

DB 11781 INSTALL

Download and Install Mysql - Navicat
MySql : HERE
Navicat : HERE
Microsift Visual 2010 : HERE

RELEASE
Core x32 Re-Building Hibryd.
Add Players Bot
Vehicles 90%
Dual Spec lvl40 100%
Fix Quest DK Fix 100%
Instances 100%
Battleground, PVP, Player bot
Ally&Horde in the same group
+ Add New Items
+ Fix the population
+ Fix Quests's scripts
+ Fix the [gossip]
+ Fix 80% spells for 3.3.5a

CREATE DB 11781

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

Restaured DB 11781 Full to archives:
characters.sql,mangos.sql, realmd.sql and scriptdev2.sql
and update archives to character & realmd.

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)
YOU ID;YOU PASS;3306;127.0.0.1;mangos;characters

CONFIG MANGOS 11781

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.5a and execute and wait.

OK RUN
mangosd.exe and reamld.exe

DOWNLOADS FULL 11781 MANGOS for Client 3.3.5a rev 12340

FULL DB 11781b : HERE

EMU for Client 3.3.5a rev 12340

Full Mangos 11781b : HERE

100% DB Server.

USE CLIENT 3.3.5a rev. 12340

Change realmlist.wtf to YOUR IP or 127.0.0.1

Pass: FoReVeR_RaGeZoNe

**MentaL**

Mangos+YTDB Full Dual Spec + AH + AntiCheat

**Quakes69** · 01-12-09

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** · 03-12-09

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** · 03-12-09

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

**pmiller863** · 03-12-09

Thanks but you are missing scriptdev2.sql

**cubansephiroth** · 03-12-09

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** · 03-12-09

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** · 03-12-09

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** · 06-12-09

Ulduar and TOC are not working :(

**katmiaugo** · 14-12-09

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** · 15-12-09

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


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.


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

Code:

-- ----------------------------
-- 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** · 17-12-09

Correction to DB

Download : HERE

**cubansephiroth** · 18-12-09

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** · 18-12-09

ad.exe not exist

edit--------

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

**Quakes69** · 19-12-09

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

Code:

-- ----------------------------
-- 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

Code:

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';

Mangos+YTDB Full Dual Spec + AH + AntiCheat

Thread Tools

Mangos + YTDB Full + Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Re: Mangos+YTDB Full Dual Spec + AH + AntiCheat

Advertisement