Jump to content

filo

Members
 View Profile  See their activity

  • Posts

    40

  • Joined

  • Last visited

    Never

  • Donations

    0.00 GBP 

 Content Type 

Posts posted by filo

  1. World of Warcraft Armory

    in Old3rd party projects

    Posted

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

  3. Separate string

    in OldC / C++

    Posted

    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.

  8. GM Log - additem

    in OldGeneral support

    Posted

    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 :-/.

  17. include files for script work

    in OldC / C++

    Posted

    Yes, you're right, Vladimir is genius respect him ;-).

    But back to my problem:

    Thanks Vladimir, but how can I use this function? Whats files I need include in my script?

    Sorry for noob question, but there is no manual for mangos source and I'm still learning mangos source.

    Thanks for a lot for help ;-).

  20. tsecurity & psecurity

    in OldC / C++

    Posted

    Becouse I create new account type (sec_donator = 1), and I need edit code for it.

    Becouse, when I disable two side interraction chat in config, accounts with gmlevel 1 (sec_donator), will be able to chat with opposite side, and this I do not want.

    OK, I edit code like this:

    Player *player = objmgr.GetPlayer(to.c_str());
           uint32 tSecurity = GetSecurity();
           uint32 pSecurity = player ? player->GetSession()->GetSecurity() : SEC_PLAYER;
           if (!player || (tSecurity <= SEC_MODERATOR && pSecurity > SEC_PLAYER && !player->isAcceptWhispers()))
           {
               WorldPacket data(SMSG_CHAT_PLAYER_NOT_FOUND, (to.size()+1));
               data<<to;
               SendPacket(&data);
               return;
           }

           if (!sWorld.getConfig(CONFIG_ALLOW_TWO_SIDE_INTERACTION_CHAT) && tSecurity <= SEC_MODERATOR && pSecurity == SEC_PLAYER )
           {
               uint32 sidea = GetPlayer()->GetTeam();
               uint32 sideb = player->GetTeam();

    Its true?

  21. tsecurity & psecurity

    in OldC / C++

    Posted

    Hello, I need clarify different between psecurity & tsecurity:

    Player *player = objmgr.GetPlayer(to.c_str());
           uint32 tSecurity = GetSecurity();
           uint32 pSecurity = player ? player->GetSession()->GetSecurity() : SEC_PLAYER;
           if (!player || (tSecurity == SEC_PLAYER && pSecurity > SEC_PLAYER && !player->isAcceptWhispers()))
           {
               WorldPacket data(SMSG_CHAT_PLAYER_NOT_FOUND, (to.size()+1));
               data<<to;
               SendPacket(&data);
               return;
           }

           if (!sWorld.getConfig(CONFIG_ALLOW_TWO_SIDE_INTERACTION_CHAT) && tSecurity == SEC_PLAYER && pSecurity == SEC_PLAYER )
           {
               uint32 sidea = GetPlayer()->GetTeam();
               uint32 sideb = player->GetTeam();
               if( sidea != sideb )
               {
                   WorldPacket data(SMSG_CHAT_PLAYER_NOT_FOUND, (to.size()+1));
                   data<<to;
                   SendPacket(&data);
                   return;
               }
           }

    Becouse I create these account types:

    0-sec_player

    1-sec_donator

    2-sec_moderator

    ...

    ->I must replace tSecurity == SEC_PLAYER for tSecurity <= SEC_MODERATOR its true?

    Thanks a lot ;-)

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • 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