Jump to content

filo

Members
  • Posts

    40
  • Joined

  • Last visited

    Never
  • Donations

    0.00 GBP 

filo's Achievements

Advanced Member

Advanced Member (3/3)

0

Reputation

  1. xD5: I have this problem too, problem is in FULL SQL packages, it isnt correct ( I dont know if all, but most of them :-( ), but I found correct package: wowarmory_rc1_r214.7z, unpack it, apply it, and after you must apply next updates from updates folder, so: armory_r215_armory_achievement_criteria.sql, armory_r221_armory_instance_template.sql, etc...Its working for me now ;-) I hope it will help you ;-) For All: Tooltips and talents page works, but not on Google Chrome :-/. EDIT: Shadez, there is patch for fix table prefix (tested, OK): diff --git a/character-model.php b/character-model.php index c0fbf34..9795731 100644 --- a/character-model.php +++ b/character-model.php @@ -158,14 +158,14 @@ $subtexture_data = array(); /** MAIN TEXTURES **/ /* TEXTURE NAME STRUCTURE: - *_au - ARM UPPER `armory_itemdisplayinfo`.`texture_2` - *_al - ARM LOWER `armory_itemdisplayinfo`.`visual_1` - *_ha - HANDS `armory_itemdisplayinfo`.`visual_2` - *_tu - TORSO UPPER `armory_itemdisplayinfo`.`visual_3` - *_tl - TORSO LOWER `armory_itemdisplayinfo`.`visual_4` - *_lu - LEG UPPER `armory_itemdisplayinfo`.`visual_5` - *_ll - LEG LOWER `armory_itemdisplayinfo`.`visual_6` - *_fo - FOOT `armory_itemdisplayinfo`.`visual_7` + *_au - ARM UPPER `ARMORYDBPREFIX_itemdisplayinfo`.`texture_2` + *_al - ARM LOWER `ARMORYDBPREFIX_itemdisplayinfo`.`visual_1` + *_ha - HANDS `ARMORYDBPREFIX_itemdisplayinfo`.`visual_2` + *_tu - TORSO UPPER `ARMORYDBPREFIX_itemdisplayinfo`.`visual_3` + *_tl - TORSO LOWER `ARMORYDBPREFIX_itemdisplayinfo`.`visual_4` + *_lu - LEG UPPER `ARMORYDBPREFIX_itemdisplayinfo`.`visual_5` + *_ll - LEG LOWER `ARMORYDBPREFIX_itemdisplayinfo`.`visual_6` + *_fo - FOOT `ARMORYDBPREFIX_itemdisplayinfo`.`visual_7` */ $tmpid = 0; if($tmpid = $characters->GetCharacterEquip('shirt')) { diff --git a/includes/armory_loader.php b/includes/armory_loader.php index 7f477f7..6182db6 100644 --- a/includes/armory_loader.php +++ b/includes/armory_loader.php @@ -104,7 +104,7 @@ if(!defined('skip_utils_class')) { $utils = new Utils($armory); /** * Check realm data - * This will automaticaly add missing realms to `armory_realm_data` table (if MySQL user have "INSERT" access to Armory database) + * This will automaticaly add missing realms to `ARMORYDBPREFIX_realm_data` table (if MySQL user have "INSERT" access to Armory database) **/ $utils->CheckConfigRealmData(); // Check $_GET variable diff --git a/includes/classes/class.characters.php b/includes/classes/class.characters.php index a503576..2bd2232 100644 --- a/includes/classes/class.characters.php +++ b/includes/classes/class.characters.php @@ -394,11 +394,11 @@ Class Characters { // Get race and class strings $race_class = $this->armory->aDB->selectRow(" SELECT - `armory_races`.`name_%s` AS `race`, - `armory_classes`.`name_%s` AS `class` - FROM `ARMORYDBPREFIX_races` AS `armory_races` - LEFT JOIN `armory_classes` AS `armory_classes` ON `armory_classes`.`id`=%d - WHERE `armory_races`.`id`=%d", $this->armory->GetLocale(), $this->armory->GetLocale(), $player_data['class'], $player_data['race']); + `ARMORYDBPREFIX_races`.`name_%s` AS `race`, + `ARMORYDBPREFIX_classes`.`name_%s` AS `class` + FROM `ARMORYDBPREFIX_races` AS `ARMORYDBPREFIX_races` + LEFT JOIN `ARMORYDBPREFIX_classes` AS `ARMORYDBPREFIX_classes` ON `ARMORYDBPREFIX_classes`.`id`=%d + WHERE `ARMORYDBPREFIX_races`.`id`=%d", $this->armory->GetLocale(), $this->armory->GetLocale(), $player_data['class'], $player_data['race']); if(!$race_class) { $this->armory->Log()->writeError('%s : unable to find class/race text strings for player %d (name: %s, race: %d, class: %d)', __METHOD__, $player_data['guid'], $player_data['name'], $player_data['race'], $player_data['class']); unset($player_data); diff --git a/includes/classes/class.search.php b/includes/classes/class.search.php index 2db715e..2c8af56 100644 --- a/includes/classes/class.search.php +++ b/includes/classes/class.search.php @@ -216,12 +216,12 @@ Class SearchMgr { $this->armory->Log()->writeLog('%s : current ExtendedCost key: %s', __METHOD__, $this->get_array['dungeon']); $item_extended_cost = $this->armory->aDB->selectCell("SELECT `item` FROM `ARMORYDBPREFIX_item_sources` WHERE `key`='%s' LIMIT 1", $this->get_array['dungeon']); if(!$item_extended_cost) { - $this->armory->Log()->writeError('%s : this->get_array[dungeon] is ExtendedCost key (%s) but data for this key is missed in `armory_item_sources`', __METHOD__, $this->get_array['dungeon']); + $this->armory->Log()->writeError('%s : this->get_array[dungeon] is ExtendedCost key (%s) but data for this key is missed in `ARMORYDBPREFIX_item_sources`', __METHOD__, $this->get_array['dungeon']); return false; } $extended_cost = $this->armory->aDB->select("SELECT `id` FROM `ARMORYDBPREFIX_extended_cost` WHERE `item1`=%d OR `item2`=%d OR `item3`=%d OR `item4`=%d OR `item5`=%d", $item_extended_cost, $item_extended_cost, $item_extended_cost, $item_extended_cost, $item_extended_cost); if(!$extended_cost) { - $this->armory->Log()->writeError('%s : this->get_array[dungeon] is ExtendedCost (key: %s, id: %d) but data for this id is missed in `armory_extended_cost`', __METHOD__, $this->get_array['dungeon'], $item_extended_cost); + $this->armory->Log()->writeError('%s : this->get_array[dungeon] is ExtendedCost (key: %s, id: %d) but data for this id is missed in `ARMORYDBPREFIX_extended_cost`', __METHOD__, $this->get_array['dungeon'], $item_extended_cost); return false; } $cost_ids = array(); diff --git a/includes/classes/class.utils.php b/includes/classes/class.utils.php index eb00db6..c5e6daf 100644 --- a/includes/classes/class.utils.php +++ b/includes/classes/class.utils.php @@ -207,7 +207,7 @@ Class Utils { } /** - * Removes all characters from `armory_login_characters` table. + * Removes all characters from `ARMORYDBPREFIX_login_characters` table. * @category Utils class * @access public * @param $allow = false @@ -222,7 +222,7 @@ Class Utils { } /** - * Add character to `armory_login_characters` table. + * Add character to `ARMORYDBPREFIX_login_characters` table. * @category Utils class * @access public * @param array $char_data @@ -322,14 +322,14 @@ Class Utils { } return $this->armory->aDB->selectRow(" SELECT - `armory_login_characters`.`guid`, - `armory_login_characters`.`name`, - `armory_login_characters`.`race`, - `armory_login_characters`.`realm_id`, - `armory_realm_data`.`name` AS `realmName` - FROM `ARMORYDBPREFIX_login_characters` AS `armory_login_characters` - LEFT JOIN `armory_realm_data` AS `armory_realm_data` ON `armory_realm_data`.`id`=`armory_login_characters`.`realm_id` - WHERE `armory_login_characters`.`account`=%d AND `armory_login_characters`.`selected`=1 LIMIT 1 + `ARMORYDBPREFIX_login_characters`.`guid`, + `ARMORYDBPREFIX_login_characters`.`name`, + `ARMORYDBPREFIX_login_characters`.`race`, + `ARMORYDBPREFIX_login_characters`.`realm_id`, + `ARMORYDBPREFIX_realm_data`.`name` AS `realmName` + FROM `ARMORYDBPREFIX_login_characters` AS `ARMORYDBPREFIX_login_characters` + LEFT JOIN `ARMORYDBPREFIX_realm_data` AS `ARMORYDBPREFIX_realm_data` ON `ARMORYDBPREFIX_realm_data`.`id`=`ARMORYDBPREFIX_login_characters`.`realm_id` + WHERE `ARMORYDBPREFIX_login_characters`.`account`=%d AND `ARMORYDBPREFIX_login_characters`.`selected`=1 LIMIT 1 ", $_SESSION['accountId']); } @@ -450,7 +450,7 @@ Class Utils { return false; } $char_data['realmUrl'] = sprintf('r=%s&cn=%s', urlencode($realmName), urlencode($name)); - $this->armory->aDB->query("INSERT IGNORE INTO `armory_bookmarks` VALUES (%d, '%s', %d, %d, '%s', '%s')", $_SESSION['accountId'], $char_data['name'], $char_data['classId'], $char_data['level'], $realmName, $char_data['realmUrl']); + $this->armory->aDB->query("INSERT IGNORE INTO `ARMORYDBPREFIX_bookmarks` VALUES (%d, '%s', %d, %d, '%s', '%s')", $_SESSION['accountId'], $char_data['name'], $char_data['classId'], $char_data['level'], $realmName, $char_data['realmUrl']); return true; } @@ -1338,7 +1338,7 @@ Class Utils { * Returns array with latest news. * To add new item, you need to execute simple query to armory DB: * =========== - * INSERT INTO `armory_news` + * INSERT INTO `ARMORYDBPREFIX_news` * (`date`, `title_en_gb`, `title_*`, `text_en_gb`, `text_*` `display`) * VALUES * (UNIXTIMESTAMP_HERE, 'Title (ENGB)', 'Title (ANY Locale)', 'Text ENGB', 'Text (ANY Locale)', 1); @@ -1401,7 +1401,7 @@ Class Utils { } /** - * Checks all realms for correct configs (in configuration.php and `armory_realm_data` table) + * Checks all realms for correct configs (in configuration.php and `ARMORYDBPREFIX_realm_data` table) * and inserts data to DB if something missing. * @category Utils class * @access public @@ -1416,9 +1416,9 @@ Class Utils { foreach($this->armory->realmData as $myRealm) { $tmpData = $this->armory->aDB->selectRow("SELECT `id`, `name`, `type` FROM `ARMORYDBPREFIX_realm_data` WHERE `name`='%s' LIMIT 1", $myRealm['name']); if((!$tmpData || !is_array($tmpData)) || ($tmpData['id'] != $myRealm['id'] || $tmpData['name'] != $myRealm['name'] || $tmpData['type'] == UNK_SERVER)) { - $replace = $this->armory->aDB->query("REPLACE INTO `armory_realm_data` (`id`, `name`, `type`) VALUES (%d, '%s', %d)", $myRealm['id'], $myRealm['name'], self::GetServerTypeByString($myRealm['type'])); + $replace = $this->armory->aDB->query("REPLACE INTO `ARMORYDBPREFIX_realm_data` (`id`, `name`, `type`) VALUES (%d, '%s', %d)", $myRealm['id'], $myRealm['name'], self::GetServerTypeByString($myRealm['type'])); if($replace) { - $this->armory->Log()->writeLog('%s : realm data for realm "%s" was successfully added to `armory_realm_data` table.', __METHOD__, $myRealm['name']); + $this->armory->Log()->writeLog('%s : realm data for realm "%s" was successfully added to `ARMORYDBPREFIX_realm_data` table.', __METHOD__, $myRealm['name']); } else { $this->armory->Log()->writeError('%s : realm data for realm "%s" was not added to `%s_realm_data` table. Please, execute this query manually: "REPLACE INTO `%s_realm_data` (`id`, `name`, `type`) VALUES (%d, \\'%s\\', %d);"', __METHOD__, $myRealm['name'], $this->armory->armoryconfig['db_prefix'], $this->armory->armoryconfig['db_prefix'], $myRealm['id'], $myRealm['name'], self::GetServerTypeByString($myRealm['type']));
  2. filo

    Separate string

    Yes, I found it too, but I dont know how can I edit it for use it for IF clause like example above, can you help me?
  3. Hi, I need help with separate string from config, something like this (example): config: areas = "5442,1024,3054,246" player.cpp: std::string areas = sWorld.getConfig(CONFIG_STRING_CUSTOM_AREAS); if (pPlayer->GetAreaId() == areas) { ...some code here... } but i dont know, how can I separate areas string for IF clause. Thanks for help with this.
  4. filo

    Time function

    Thanks, it works nice ;-).
  5. filo

    Time function

    Hi, I need help with function in BattlegroundMgr.cpp: time_t curtime = time(NULL); How can I specify time (only time; day,month and year will be equal to TODAY). For example TODAY 15:00.
  6. Shadez, there is option for set table prefix?
  7. Hi, I remeber that I think hanuza commit function similiar to additem for external scripts (scriptdev2) use, whats name of this function is it? I cannot find it :-/. Thanks
  8. Hi, On my server I have problem with GM's and command additem. When GM type .additem ID -50 (for example) from one character, and after .additem ID 50 to another character (some item transaction from char to char), BUT in gm log you can see, even if he doesn't have item count - you cannot identify support :-/. Command: .additem ITEM -1 [...] So, where can I modify, that command dont print to gm log, if player doesn't specify item count? = Its solution for my problem, becouse after this modify, I will be able to see only .additem ID 50, but not .additem ID -50 =>SUPPORT :-). I know, I can disable command additem for GM, but I checking GM logs every day, thats not problem for me, but for this command, you cannot identify support :-/.
  9. Ah, I think, there is some "default" icon for tabs, instead this "?" red icon. Thanks for your explain ;-).
  10. Hi, Look at this picture: http://i50.tinypic.com/2yziek1.jpg Guild Vault Tab icons is bugged with "?" red icon. I have newest mangos revision, udb and I havent any custom addons. Anybody has same problem?
  11. Why you replaced WUPDATE_COUNT = 7 with WUPDATE_BROADCAST = 7, and added WUPDATE_COUNT = 8 after custom WUPDATE_BROADCAST = 7? I think WUPDATE_EVENTS = 6, WUPDATE_COUNT = 7, WUPDATE_BROADCAST = 8 is better? I'm not sure if it somehow affects the running of the script, but I think that the original takes precedence over custom script
  12. filo

    Datetime

    Thanks, I used your tips and now its works perfect ;-).
  13. filo

    Datetime

    Is there any function for print formatted datetime in MaNGOS? Or any another way, how can I print datetime (if you have code, please include it). Thanks a lot
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use