function transferCategories()
 {
     $sSql = "SELECT \r\n        \t\t\t`CategoryID` AS `id`, \r\n        \t\t\t`CategoryName` AS `name`\r\n        \t\tFROM `ArticlesCategory`";
     $rResult = mysql_query($sSql, $this->rOldDb);
     $iCount = mysql_num_rows($rResult);
     while ($aCategory = mysql_fetch_assoc($rResult)) {
         if (get_mb_len($aCategory['name']) > 32) {
             $aCategory['name'] = get_mb_substr($aCategory['name'], 0, 32);
         }
         if ($this->existsCategory($aCategory['name'], 0, $this->_sType)) {
             continue;
         }
         //escape all values
         $aCategory['name'] = $this->oMigrationModule->_oDb->escape($aCategory['name']);
         $sSql = "INSERT INTO `sys_categories`(`Category`, `ID`, `Type`, `Owner`, `Status`, `Date`)\r\n            \t\t VALUES('" . $aCategory['name'] . "', '0', '" . $this->_sType . "', '0', 'active', NOW())";
         $iResult = (int) $this->oDolModule->_oDb->query($sSql);
         if ($iResult <= 0) {
             $this->setResultStatus('Database error. Cannot insert category in the database.');
             return MIGRATION_FAILED;
         }
     }
     return MIGRATION_SUCCESSFUL;
 }

 /**
  * Constructor
  * $sSystem - comments system name
  * $iId - obect id to be commented
  */
 function __construct($sSystem, $iId, $iInit = 1)
 {
     parent::__construct();
     $this->_aSystems = $this->getSystems();
     if (!isset($this->_aSystems[$sSystem])) {
         return;
     }
     $this->_sSystem = $sSystem;
     $this->_aSystem = $this->_aSystems[$sSystem];
     $this->_aSystem['table_images'] = 'sys_cmts_images';
     $this->_aSystem['table_images2entries'] = 'sys_cmts_images2entries';
     $this->_aSystem['table_ids'] = 'sys_cmts_ids';
     $this->_aSystem['is_browse_filter'] = (int) $this->_bBrowseFilter;
     $this->_iDpMaxLevel = (int) $this->_aSystem['number_of_levels'];
     $this->_sDisplayType = $this->_iDpMaxLevel == 0 ? BX_CMT_DISPLAY_FLAT : BX_CMT_DISPLAY_THREADED;
     $this->_sDpSessionKey = 'bx_' . $this->_sSystem . '_dp_';
     $this->_sBrowseType = $this->_aSystem['browse_type'];
     $this->_sBrowseFilter = BX_CMT_FILTER_ALL;
     $this->_sBpSessionKeyType = 'bx_' . $this->_sSystem . '_bpt_';
     $this->_sBpSessionKeyFilter = 'bx_' . $this->_sSystem . '_bpf_';
     $this->_aOrder = array('by' => BX_CMT_ORDER_BY_DATE, 'way' => BX_CMT_ORDER_WAY_ASC);
     list($mixedUserDp, $mixedUserBpType, $mixedUserBpFilter) = $this->_getUserChoice();
     if (!empty($mixedUserDp)) {
         $this->_sDisplayType = $mixedUserDp;
     }
     if (!empty($mixedUserBpType)) {
         $this->_sBrowseType = $mixedUserBpType;
     }
     if (!empty($mixedUserBpFilter)) {
         $this->_sBrowseFilter = $mixedUserBpFilter;
     }
     $this->_sViewUrl = BX_DOL_URL_ROOT . 'cmts.php';
     $this->_sBaseUrl = BxDolPermalinks::getInstance()->permalink($this->_aSystem['base_url']);
     if (get_mb_substr($this->_sBaseUrl, 0, 4) != 'http') {
         $this->_sBaseUrl = BX_DOL_URL_ROOT . $this->_sBaseUrl;
     }
     $this->_sListAnchor = "cmts-anchor-%s-%d";
     $this->_oQuery = new BxDolCmtsQuery($this);
     $this->_sFormObject = 'sys_comment';
     $this->_sFormDisplayPost = 'sys_comment_post';
     $this->_sFormDisplayEdit = 'sys_comment_edit';
     $this->_sConnObjFriends = 'sys_profiles_friends';
     $this->_sConnObjSubscriptions = 'sys_profiles_subscriptions';
     $this->_sMenuObjManage = 'sys_cmts_item_manage';
     $this->_sMenuObjActions = 'sys_cmts_item_actions';
     $this->_sMetatagsObj = 'sys_cmts';
     if ($iInit) {
         $this->init($iId);
     }
 }

function uriGenerate($s, $sTable, $sField, $iMaxLen = 255)
{
    $s = uriFilter($s);
    if (uriCheckUniq($s, $sTable, $sField)) {
        return $s;
    }
    // try to add date
    if (get_mb_len($s) > 240) {
        $s = get_mb_substr($s, 0, 240);
    }
    $s .= '-' . date('Y-m-d');
    if (uriCheckUniq($s, $sTable, $sField)) {
        return $s;
    }
    // try to add number
    for ($i = 0; $i < 999; ++$i) {
        if (uriCheckUniq($s . '-' . $i, $sTable, $sField)) {
            return $s . '-' . $i;
        }
    }
    return rand(0, 999999999);
}

function uriGenerate($s, $sTable, $sField, $iMaxLen = 255)
{
    //$s = get_mb_replace ('/[^\pL^\pN]+/u', '-', $s); // unicode characters
    $s = get_mb_replace('/([^\\d^\\w]+)/', '-', $s);
    // latin characters
    $s = get_mb_replace('/([-^]+)/', '-', $s);
    if (uriCheckUniq($s, $sTable, $sField)) {
        return $s;
    }
    // try to add date
    if (get_mb_len($s) > 240) {
        $s = get_mb_substr($s, 0, 240);
    }
    $s .= '-' . date('Y-m-d');
    if (uriCheckUniq($s, $sTable, $sField)) {
        return $s;
    }
    // try to add number
    for ($i = 0; $i < 999; ++$i) {
        if (uriCheckUniq($s . '-' . $i, $sTable, $sField)) {
            return $s . '-' . $i;
        }
    }
    return rand(0, 999999999);
}

function uriGenerate($s, $sTable, $sField, $sEmpty = '-')
{
    $s = uriFilter($s, $sEmpty);
    if (uriCheckUniq($s, $sTable, $sField)) {
        return $s;
    }
    // cut off redundant part
    if (get_mb_len($s) > 240) {
        $s = get_mb_substr($s, 0, 240);
    }
    // try to add date
    $s .= '-' . date('Y-m-d');
    if (uriCheckUniq($s, $sTable, $sField)) {
        return $s;
    }
    // try to add number
    for ($i = 0; $i < 999; ++$i) {
        if (uriCheckUniq($s . '-' . $i, $sTable, $sField)) {
            return $s . '-' . $i;
        }
    }
    return rand(0, 999999999);
}

 function getCorrectUri($sCaption, $iOwnerId = 0, $bCheck = true)
 {
     $sUri = uriFilter($sCaption);
     if (!$sUri) {
         $sUri = '-';
     }
     if (!$bCheck) {
         return $sUri;
     }
     if ($this->checkUriUniq($sUri, $iOwnerId)) {
         return $sUri;
     }
     if (get_mb_len($sUri) > 240) {
         $sUri = get_mb_substr($sUri, 0, 240);
     }
     $sUri .= '-' . date('Y-m-d');
     if ($this->checkUriUniq($sUri, $iOwnerId)) {
         return $sUri;
     }
     for ($i = 0; $i < 999; ++$i) {
         if ($this->checkUriUniq($sUri . '-' . $i, $iOwnerId)) {
             return $sUri . '-' . $i;
         }
     }
     return time();
 }