Flousedid

In /sql/mangos.sql :

DROP TABLE IF EXISTS `creature_template`;
CREATE TABLE `creature_template` (
 `entry` mediumint(8) unsigned NOT NULL default '0',
 `difficulty_entry_1` mediumint(8) unsigned NOT NULL default '0',
 `difficulty_entry_2` mediumint(8) unsigned NOT NULL default '0',
 `difficulty_entry_3` mediumint(8) unsigned NOT NULL default '0',
 `KillCredit1` int(11) unsigned NOT NULL default '0',
 `KillCredit2` int(11) unsigned NOT NULL default '0',
 `modelid_1` mediumint(8) unsigned NOT NULL default '0',
 `modelid_2` mediumint(8) unsigned NOT NULL default '0',
 `modelid_3` mediumint(8) unsigned NOT NULL default '0',
 `modelid_4` mediumint(8) unsigned NOT NULL default '0',
 `name` char(100) NOT NULL default '0',
 `subname` char(100) default NULL,
 `IconName` char(100) default NULL,
 `gossip_menu_id` mediumint(8) unsigned NOT NULL default '0',
 `minlevel` tinyint(3) unsigned NOT NULL default '1',
 `maxlevel` tinyint(3) unsigned NOT NULL default '1',
 `minhealth` int(10) unsigned NOT NULL default '0',
 `maxhealth` int(10) unsigned NOT NULL default '0',
 `minmana` int(10) unsigned NOT NULL default '0',
 `maxmana` int(10) unsigned NOT NULL default '0',
 `armor` mediumint(8) unsigned NOT NULL default '0',
 `faction_A` smallint(5) unsigned NOT NULL default '0',
 `faction_H` smallint(5) unsigned NOT NULL default '0',
 `npcflag` int(10) unsigned NOT NULL default '0',
 `speed_walk` float NOT NULL default '1' COMMENT 'Result of 2.5/2.5, most common value',
 `speed_run` float NOT NULL default '1.14286' COMMENT 'Result of 8.0/7.0, most common value',
 `scale` float NOT NULL default '1',
 `rank` tinyint(3) unsigned NOT NULL default '0',
 `mindmg` float NOT NULL default '0',
 `maxdmg` float NOT NULL default '0',
 `dmgschool` tinyint(4) NOT NULL default '0',
 `attackpower` int(10) unsigned NOT NULL default '0',
 `dmg_multiplier` float NOT NULL default '1',
 `baseattacktime` int(10) unsigned NOT NULL default '0',
 `rangeattacktime` int(10) unsigned NOT NULL default '0',
 `unit_class` tinyint(3) unsigned NOT NULL default '0',
 `unit_flags` int(10) unsigned NOT NULL default '0',
 `dynamicflags` int(10) unsigned NOT NULL default '0',
 `family` tinyint(4) NOT NULL default '0',
 `trainer_type` tinyint(4) NOT NULL default '0',
 `trainer_spell` mediumint(8) unsigned NOT NULL default '0',
 `trainer_class` tinyint(3) unsigned NOT NULL default '0',
 `trainer_race` tinyint(3) unsigned NOT NULL default '0',
 `minrangedmg` float NOT NULL default '0',
 `maxrangedmg` float NOT NULL default '0',
 `rangedattackpower` smallint(5) unsigned NOT NULL default '0',
 `type` tinyint(3) unsigned NOT NULL default '0',
 `type_flags` int(10) unsigned NOT NULL default '0',
 `lootid` mediumint(8) unsigned NOT NULL default '0',
 `pickpocketloot` mediumint(8) unsigned NOT NULL default '0',
 `skinloot` mediumint(8) unsigned NOT NULL default '0',
 `resistance1` smallint(5) NOT NULL default '0',
 `resistance2` smallint(5) NOT NULL default '0',
 `resistance3` smallint(5) NOT NULL default '0',
 `resistance4` smallint(5) NOT NULL default '0',
 `resistance5` smallint(5) NOT NULL default '0',
 `resistance6` smallint(5) NOT NULL default '0',
 `spell1` mediumint(8) unsigned NOT NULL default '0',
 `spell2` mediumint(8) unsigned NOT NULL default '0',
 `spell3` mediumint(8) unsigned NOT NULL default '0',
 `spell4` mediumint(8) unsigned NOT NULL default '0',
 `PetSpellDataId` mediumint(8) unsigned NOT NULL default '0',
 `mingold` mediumint(8) unsigned NOT NULL default '0',
 `maxgold` mediumint(8) unsigned NOT NULL default '0',
 `AIName` char(64) NOT NULL default '',
 `MovementType` tinyint(3) unsigned NOT NULL default '0',
 `InhabitType` tinyint(3) unsigned NOT NULL default '3',
 `unk16` float NOT NULL default '1',
 `unk17` float NOT NULL default '1',
 `RacialLeader` tinyint(3) unsigned NOT NULL default '0',
 `questItem1` int(11) UNSIGNED DEFAULT '0' NOT NULL,
 `questItem2` int(11) UNSIGNED DEFAULT '0' NOT NULL,
 `questItem3` int(11) UNSIGNED DEFAULT '0' NOT NULL,
 `questItem4` int(11) UNSIGNED DEFAULT '0' NOT NULL,
 `questItem5` int(11) UNSIGNED DEFAULT '0' NOT NULL,
 `questItem6` int(11) UNSIGNED DEFAULT '0' NOT NULL,
 `movementId` int(11) UNSIGNED DEFAULT '0' NOT NULL,
 `RegenHealth` tinyint(3) unsigned NOT NULL default '1',
 `vehicle_id` mediumint(8) unsigned NOT NULL default '0',
 `equipment_id` mediumint(8) unsigned NOT NULL default '0',
 `trainer_id` mediumint(8) unsigned NOT NULL default '0',
 `vendor_id` mediumint(8) unsigned NOT NULL default '0',
 `mechanic_immune_mask` int(10) unsigned NOT NULL default '0',
 `flags_extra` int(10) unsigned NOT NULL default '0',
 `ScriptName` char(64) NOT NULL default '',
 PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';

There is 85 fiels !! Not 90 !

Is mangos-team forgot to publish sql file after code change ? (I don't believe this)

Hi !

Today, i'm trying to make clean install.

I use RSA branch and YTDB.

I install clean BDD with ALL updates.

And i've got this error on startup :

ERROR:Error in creature_template table, probably sql file format was updated (there should be 90 fields in sql).

WTF ? There is only 85 fields in original mangos.sql !!

Here is my Server.log :

http://pastebin.com/sUEGffHj

Thanks by advance.

Hi !

I'm using this branch :

https://github.com/faramir118/mangos/tree/mmaps_clean

I have problems with all the mobs which fly. Some bosses, as the lich king, move under the map when we attack them.

Am I alone with this problem?

Thanks by advance

Actually, there is a missing function.

Player::CompletedAchievement()

So, i merge with RSA. I fix compile error and i will give you gist file.

Unable to compile on clean install with rsa's ScriptDev2.

Git repo :

git://github.com/faramir118/mangos.git

Commit ID

a886b0cba2a413df1653

Cmake :

cmake version 2.8.4

uname -a

Linux trinity 2.6.26-2-amd64 #1 SMP Tue Jan 25 05:59:43 UTC 2011 x86_64 GNU/Linux

Error :

[ 49%] Building CXX object src/game/CMakeFiles/game.dir/Spell.cpp.o
/home/mangos/src/mangos/src/game/vmap/WorldModel.cpp: In member function 'bool VMAP::WmoLiquid::GetLiquidHeight(const G3D::Vector3&, float&) const':
/home/mangos/src/mangos/src/game/vmap/WorldModel.cpp:153: warning: comparison of unsigned expression < 0 is always false
/home/mangos/src/mangos/src/game/vmap/WorldModel.cpp:156: warning: comparison of unsigned expression < 0 is always false
/home/mangos/src/mangos/src/game/vmap/WorldModel.cpp: At global scope:
/home/mangos/src/mangos/src/game/vmap/WorldModel.cpp:347: warning: unused parameter 'pStopAtFirstHit'
In file included from /home/mangos/src/mangos/src/game/Spell.cpp:23:
/home/mangos/src/mangos/src/game/GridNotifiers.h:48: warning: unused parameter 'm'
/home/mangos/src/mangos/src/game/GridNotifiers.h: In constructor 'MaNGOS::NearestGameObjectEntryInPosRangeCheck::NearestGameObjectEntryInPosRangeCheck(const WorldObject&, uint32, float, float, float, float)':
/home/mangos/src/mangos/src/game/GridNotifiers.h:716: warning: 'MaNGOS::NearestGameObjectEntryInPosRangeCheck::i_z' will be initialized after
/home/mangos/src/mangos/src/game/GridNotifiers.h:715: warning:   'uint32 MaNGOS::NearestGameObjectEntryInPosRangeCheck::i_entry'
/home/mangos/src/mangos/src/game/GridNotifiers.h:694: warning:   when initialized here
/home/mangos/src/mangos/src/game/GridNotifiers.h: In constructor 'MaNGOS::GameObjectEntryInPosRangeCheck::GameObjectEntryInPosRangeCheck(const WorldObject&, uint32, float, float, float, float)':
/home/mangos/src/mangos/src/game/GridNotifiers.h:745: warning: 'MaNGOS::GameObjectEntryInPosRangeCheck::i_z' will be initialized after
/home/mangos/src/mangos/src/game/GridNotifiers.h:744: warning:   'uint32 MaNGOS::GameObjectEntryInPosRangeCheck::i_entry'
/home/mangos/src/mangos/src/game/GridNotifiers.h:727: warning:   when initialized here
/home/mangos/src/mangos/src/game/GridNotifiers.h: In member function 'bool MaNGOS::NearestCreatureEntryWithLiveStateInObjectRangeCheck::operator()(Creature*)':
/home/mangos/src/mangos/src/game/GridNotifiers.h:1121: warning: suggest parentheses around && within ||
In file included from /home/mangos/src/mangos/src/game/GridNotifiersImpl.h:28,
                from /home/mangos/src/mangos/src/game/Spell.cpp:24:
/home/mangos/src/mangos/src/game/SpellAuras.h: At global scope:
/home/mangos/src/mangos/src/game/SpellAuras.h:436: warning: type qualifiers ignored on function return type
/home/mangos/src/mangos/src/game/Spell.cpp: In member function 'void Spell::DoAllEffectOnTarget(Spell::TargetInfo*)':
/home/mangos/src/mangos/src/game/Spell.cpp:1052: warning: enumeral and non-enumeral type in conditional expression
/home/mangos/src/mangos/src/game/Spell.cpp:1087: warning: enumeral and non-enumeral type in conditional expression
/home/mangos/src/mangos/src/game/Spell.cpp:1131: warning: enumeral and non-enumeral type in conditional expression
/home/mangos/src/mangos/src/game/Spell.cpp: In member function 'bool Spell::IsTriggeredSpellWithRedundentData() const':
/home/mangos/src/mangos/src/game/Spell.cpp:6631: warning: suggest parentheses around && within ||
Linking CXX static library libgame.a
[ 49%] Built target game
make: *** [all] Erreur 2

Thank you very much

Hi everybody,

I wast my last hour to search how to activate crash logs on Linux !

And apparently I'm alone in asking this question..

So I guess the answer is obvious?

I work on debian, with RSA branch.

Thanks by advance

Ok i see ^^

We are in the same point.

I'm working on it !

How did you fix SpellAuras.cpp ?

Could you post your version ?

EDIT : Maybe i did'nt understand your post and your SpellAuras.cpp is still bug ?

How did you fix the first problem please ?

In MovementHandler.cpp : http://pastebin.ca/1947425

6>..\\..\\src\\game\\MovementHandler.cpp(171): error C2664: 'World::BanAccount'*: impossible de convertir le paramètre 3 de 'std::string' en 'uint32'
6>          Aucun opérateur de conversion définie par l'utilisateur disponible qui puisse effectuer cette conversion, ou l'opérateur ne peut pas être appelé
6>..\\..\\src\\game\\MovementHandler.cpp(175): error C2065: 'loginDatabase'*: identificateur non déclaré
6>..\\..\\src\\game\\MovementHandler.cpp(175): error C2228: la partie gauche de '.PQuery' doit avoir un class/struct/union
6>          le type est ''unknown-type''
6>..\\..\\src\\game\\MovementHandler.cpp(183): error C2664: 'World::BanAccount'*: impossible de convertir le paramètre 3 de 'std::string' en 'uint32'
6>          Aucun opérateur de conversion définie par l'utilisateur disponible qui puisse effectuer cette conversion, ou l'opérateur ne peut pas être appelé

In SpellAuras.cpp : http://pastebin.ca/1947428

..\\..\\src\\game\\SpellAuras.cpp(7461): error C2065: 'm_target'*: undeclared identificator

Errors like this > 100 = Fatal error

Hi everybody, sorry for my english : i'm french =)

So today, i test to apply patch to my mangos core (10430) :

git apply --check ../wow_armory_patches_10116.patch

And i get :

fatal: corrupt patch at line 235

I'm noob, and i want to know if my method is correct ? Or just if patch is not made for my core version ?

Thanks for your attention (and your very great work !) =)