selector

so easy and simple....

Core: 10271 DB: YTDB 557 http://pastebin.com/raw.php?i=7Qa3SXbW Crashed every hour with ~100ppl. Core isn't clear. Added some custom patches, but no-one related to Unit::MeleeDamageBonusTaken

I mean in core part, not in sql

First test. changerace works like charm. All is perfect changefaction with updated Warlord123's data works good, but need to add quests table and remake rep. table. And ofc to add more id's.

diff --git a/src/game/CharacterHandler.cpp b/src/game/CharacterHandler.cpp index 7a7dabc..c763a7b 100644 --- a/src/game/CharacterHandler.cpp +++ b/src/game/CharacterHandler.cpp @@ -1249,9 +1249,9 @@ void WorldSession::HandleCharFactionOrRaceChange(WorldPacket& recv_data) // Reset homebind CharacterDatabase.PExecute("DELETE FROM `character_homebind` WHERE guid = '%u'",GUID_LOPART(guid)); if(team == BG_TEAM_ALLIANCE) - CharacterDatabase.PExecute("INSERT INTO `character_homebind` VALUES ('%u','0', '1519', '-8867.68', '673.373', '97.9034'",GUID_LOPART(guid)); + CharacterDatabase.PExecute("INSERT INTO `character_homebind` VALUES ('%u','0','1519','-8867.68','673.373','97.9034')",GUID_LOPART(guid)); else - CharacterDatabase.PExecute("INSERT INTO `character_homebind` VALUES ('%u','1', '1637', '1633.33', '-4439.11', '15.7588'",GUID_LOPART(guid)); + CharacterDatabase.PExecute("INSERT INTO `character_homebind` VALUES ('%u','1','1637','1633.33','-4439.11','15.7588')",GUID_LOPART(guid)); // Achievement conversion if(QueryResult *result2 = WorldDatabase.Query("SELECT alliance_id, horde_id FROM player_factionchange_achievements")) Several Typo fixes

No,flyght paths should be changed:

http://www.wow-europe.com/en/info/faction-change/index.xml you ned to read this(about reputation change). convert Human to Undead: Darnassus <-> Orgrimmar Exodar <-> Silvermoon City Gnomeregan Exiles <-> Thunder Bluff Ironforge <-> Darkspear Trolls Stormwind <-> Undercity And human to Troll: Darnassus <-> Undercity Exodar <-> Silvermoon City Gnomeregan Exiles <-> Thunder Bluff Ironforge <-> Orgrimmar Stormwind <--> Darkspear Trolls

diff --git a/src/game/CharacterHandler.cpp b/src/game/CharacterHandler.cpp index e44610a..7a7dabc 100644 --- a/src/game/CharacterHandler.cpp +++ b/src/game/CharacterHandler.cpp @@ -1254,7 +1254,7 @@ void WorldSession::HandleCharFactionOrRaceChange(WorldPacket& recv_data) CharacterDatabase.PExecute("INSERT INTO `character_homebind` VALUES ('%u','1', '1637', '1633.33', '-4439.11', '15.7588'",GUID_LOPART(guid)); // Achievement conversion - if(QueryResult *result2 = WorldDatabase.Query("SELECT alliance_id, horde_id FROM player_changefaction_achievements")) + if(QueryResult *result2 = WorldDatabase.Query("SELECT alliance_id, horde_id FROM player_factionchange_achievements")) { do { @@ -1268,7 +1268,7 @@ void WorldSession::HandleCharFactionOrRaceChange(WorldPacket& recv_data) } // Item conversion - if(QueryResult *result2 = WorldDatabase.Query("SELECT alliance_id, horde_id FROM player_changefaction_items")) + if(QueryResult *result2 = WorldDatabase.Query("SELECT alliance_id, horde_id FROM player_factionchange_items")) { do { @@ -1285,7 +1285,7 @@ void WorldSession::HandleCharFactionOrRaceChange(WorldPacket& recv_data) } // Spell conversion - if(QueryResult *result2 = WorldDatabase.Query("SELECT alliance_id, horde_id FROM player_changefaction_spells")) + if(QueryResult *result2 = WorldDatabase.Query("SELECT alliance_id, horde_id FROM player_factionchange_spells")) { do { @@ -1299,7 +1299,7 @@ void WorldSession::HandleCharFactionOrRaceChange(WorldPacket& recv_data) } // Reputation conversion - if(QueryResult *result2 = WorldDatabase.Query("SELECT alliance_id, horde_id FROM player_changefaction_spells")) + if(QueryResult *result2 = WorldDatabase.Query("SELECT alliance_id, horde_id FROM player_factionchange_reputations")) { do { Fixes.

hmmm. where is code ? seem that many codes where lost after maintenance

DROP TABLE IF EXISTS `mail_external`; CREATE TABLE `mail_external` ( `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, `receiver` bigint(20) UNSIGNED NOT NULL, `subject` varchar(200) DEFAULT 'Support Message', `message` varchar(500) DEFAULT 'Support Message', `money` int(20) UNSIGNED NOT NULL DEFAULT '0', `item` int(20) UNSIGNED NOT NULL DEFAULT '0', `item_count` int(20) UNSIGNED NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; no changes^( Still auto replace into 0 after entering name

When i enter char name into `recevier` it automaticaly changes to 0. Any Ideas?

Hello everybody. Need some help with 'mass mail'. I need to send mail to many players(let's say 50) and have there names in needed easy format. Getting `guid` from name i solved with Select `guid` from `characters` where `name` IN (name1, name2, name3, ...) But got a problem with executing sql command. It simply insert only 1 row(only for name1) but I need for many names(name1, name2, name3, ...). I din't use `id` cuz it filled by self. INSERT INTO `mail_external`( `receiver`, `subject`, `message`, `money`, `item`, `item_count`) VALUES ((Select `guid` from `characters` where ( characters.name IN ('name1', 'name2', 'name3')) ), 'message', 'text', 1, 0, 0) Any ideas how to solve it. Sory for my very bad English, hope you understand my problem and help me.

mangos 9134 (3.2.2a last) + insider patches System - Fedora 12

checking for _InterlockedIncrement... no checking for _InterlockedDecrement... no checking for _InterlockedExchangeAdd... no checking for access... yes checking for alphasort... yes checking for asctime... yes checking for asctime_r... yes checking for alarm... yes checking for bsearch... yes ../../../dep/ACE_wrappers/configure: line 35635: syntax error near unexpected token `fi' ../../../dep/ACE_wrappers/configure: line 35635: `fi' configure: error: ../../../dep/ACE_wrappers/configure failed for dep/ACE_wrappers while config mangos. From configure file: #ifndef _REENTRANT # define _REENTRANT #endif #ifndef ACE_LACKS_PWD_H # include <pwd.h> #endif #ifndef ACE_LACKS_SYS_TYPES_H # include <sys/types.h> #endif int main () { const char * name; struct passwd * pwent; char * buffer; int buflen; struct passwd * result; int status = getpwnam_r (name, pwent, buffer, buflen, &result); ; return 0; } _ACEOF if ac_fn_cxx_try_compile "$LINENO"; then : if test "$ace_user_enable_reentrant_funcs" = yes; then $as_echo "#define ACE_HAS_POSIX_GETPWNAM_R 1" >>confdefs.h fi else fi rm -f core conftest.err conftest.$ac_objext conftest.$ac_ext else $as_echo "#define ACE_LACKS_PWD_REENTRANT_FUNCTIONS 1" >>confdefs.h fi ac_fn_cxx_check_func "$LINENO" "ctime_r" "ac_cv_func_ctime_r" if test "x$ac_cv_func_ctime_r" = x""yes; then : fi ac_fn_cxx_check_func "$LINENO" "localtime_r" "ac_cv_func_localtime_r" if test "x$ac_cv_func_localtime_r" = x""yes; then : fi ac_fn_cxx_check_func "$LINENO" "gmtime_r" "ac_cv_func_gmtime_r" if test "x$ac_cv_func_gmtime_r" = x""yes; then : fi ac_fn_cxx_check_func "$LINENO" "asctime_r" "ac_cv_func_asctime_r" if test "x$ac_cv_func_asctime_r" = x""yes; then : fi ac_fn_cxx_check_func "$LINENO" "getprotobyname_r" "ac_cv_func_getprotobyname_r" if test "x$ac_cv_func_getprotobyname_r" = x""yes; then : fi ac_fn_cxx_check_func "$LINENO" "getprotobynumber_r" "ac_cv_func_getprotobynumber_r" if test "x$ac_cv_func_getprotobynumber_r" = x""yes; then : fi ac_fn_cxx_check_func "$LINENO" "gethostbyaddr_r" "ac_cv_func_gethostbyaddr_r" if test "x$ac_cv_func_gethostbyaddr_r" = x""yes; then : fi ac_fn_cxx_check_func "$LINENO" "gethostbyname_r" "ac_cv_func_gethostbyname_r" if test "x$ac_cv_func_gethostbyname_r" = x""yes; then : fi This line fi rm -f core conftest.err conftest.$ac_objext conftest.$ac_ext

Hi. I see your's core based on insider and you have Vehicles. I spend about week to work them properly but couldn't. If it's not a big trouble for you, plz make diff with you vehicle patches. Sorry for my bad English^)