source: branches/dev/data/include/module.inc @ 8

<?php

// ¥¿¥°½ÐÎÏÍÑ¥¯¥é¥¹
class LC_EbisPage {
    function LC_EbisPage() {
        $this->tpl_mainpage = MODULE_PATH . "ebis_tag_text.tpl";
    }
}

// ¥¨¥Ó¥¹¥¿¥°¤Îȯ¹Ô
function sfPrintEbisTag($pid = "") {
    $objQuery = new SC_Query();
    $arrRet = $objQuery->select("sub_data", "dtb_module", "module_id = ?", array(EBIS_TAG_MID));
    $arrSubData = unserialize($arrRet[0]['sub_data']);
    $arrEbis = array();
    
    if($arrSubData['cid'] != "") {
        $arrEbis['cid'] = $arrSubData['cid'];
    } else {
        return;
    }
    
    // ¡Ö/¡×¤¬½ÅÊ£¤·¤Æ¤¤¤ë¤â¤Î¤Ø¤ÎÂбþ
    $php_self = ereg_replace("[/]+", "/", $_SERVER['PHP_SELF']);
    // PHP¥Õ¥¡¥¤¥ë¤Î¸å¤í¤Ë¡Ö/¡×¤¬¤Ä¤¤¤Æ¤·¤Þ¤Ã¤Æ¤¤¤ë¤â¤Î¤Ø¤ÎÂбþ
    $php_self = ereg_replace(".php[/]+$", ".php", $php_self);
    
    if(!is_array($pid) && $pid != "") {
        if(!ereg(".tpl$", $pid)) {
            // ¥Ú¡¼¥¸ID¤ò¾å½ñ¤­¤¹¤ë
            $arrEbis['pid'] = $pid;
        } else {
            // ¥Æ¥ó¥×¥ì¡¼¥È¤Î¥Ñ¥¹¤¬Í¿¤¨¤é¤ì¤Æ¤¤¤ë¾ì¹ç
            $temp_id = ereg_replace(HTML_PATH,"",$pid);         
            $temp_id = ereg_replace("^[/]+","",$temp_id);
            $temp_id = ereg_replace(".tpl$","",$temp_id);
            $temp_id = ereg_replace("[\./]","_",$temp_id);
            $arrEbis['pid'] = $temp_id;
        }
    }   
    
    // ¾¦ÉÊ°ìÍ÷¥Ú¡¼¥¸¤Ï¡¢ÆüìID¤òȯ¹Ô
    if(ereg("/products/list.php\?category_id=[0-9]+$", $_SERVER["REQUEST_URI"])) {
        $filename = basename($_SERVER["REQUEST_URI"]);
        $arrEbis['pid'] = ereg_replace("list.php\?category_id=", "list-c", $filename);
    }
    
    // ¾¦Éʾܺ٥ڡ¼¥¸¤Ï¡¢ÆüìID¤òȯ¹Ô
    if(ereg("/products/detail.php\?product_id=[0-9]+$", $_SERVER["REQUEST_URI"])) {
        $filename = basename($_SERVER["REQUEST_URI"]);
        $arrEbis['pid'] = ereg_replace("detail.php\?product_id=", "detail-p", $filename);
    }
    
    // ID³ä¤êÅö¤Æ¤µ¤ì¤Æ¤¤¤Ê¤¤¥Ú¡¼¥¸¤Ï¡¢¼«Æ°Åª¤ËÀ¸À®¤¹¤ë¡£
    if($arrEbis['pid'] == "") {             
        $temp_id = ereg_replace("^[/]+","",$_SERVER['PHP_SELF']);
        $temp_id = ereg_replace(".php$","",$temp_id);
        $temp_id = ereg_replace("[\./]","_",$temp_id);
        $arrEbis['pid'] = $temp_id;
    }
            
    // ¥Ú¡¼¥¸ID¤¬ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤Î¤ß¥¿¥°¤ò½ÐÎϤ¹¤ë¡£
    if($arrEbis['pid'] != "") {
        $objSubPage = new LC_EbisPage();
        $objSubPage->arrEbis = $arrEbis;
        $objSubView = new SC_SiteView();
        $objSubView->assignobj($objSubPage);
        $objSubView->display($objSubPage->tpl_mainpage);
    }
}

// ¥³¥ó¥Ð¡¼¥¸¥ç¥ó¥¿¥°¤Îȯ¹Ô
function sfPrintAffTag($conv_page, $option) {
    if(is_numeric($conv_page)) {
        // sub_data¤è¤ê¥¿¥°¾ðÊó¤òÆɤ߹þ¤à
        $objQuery = new SC_Query();
        $arrRet = $objQuery->select("sub_data", "dtb_module", "module_id = ?", array(AFF_TAG_MID));
        $arrSubData = unserialize($arrRet[0]['sub_data']);
        $aff_tag = $arrSubData[$conv_page];
        
        $array = split("\|", $option);
        
        // ÆÃÄêʸ»ú¤ÎÃÖ¤­´¹¤¨
        foreach($array as $each) {
            list($key, $value) = split("=", $each);
            $aff_tag = ereg_replace("\[\[" . $key . "\]\]", $value, $aff_tag);
        }
        print($aff_tag);        
    }
}

// dtb_payment¤ËÈÆÍѹàÌܤ¬Â¸ºß¤·¤Æ¤¤¤Ê¤±¤ì¤ÐÄɲ乤ë
function sfAlterMemo(){
    $objQuery = new SC_Query();
    
    // ÈÆÍѹàÌܤθºß¥Á¥§¥Ã¥¯
    if(!sfColumnExists("dtb_payment", "memo01")){
        
        // ¥â¥¸¥å¡¼¥ëID¤òÄɲÃ
        $objQuery->query("alter table dtb_payment add module_id int4;");
        
        // ¥â¥¸¥å¡¼¥ë¥Ñ¥¹¤òÄɲÃ
        $objQuery->query("alter table dtb_payment add module_path text;");
        
        // ÈÆÍѹàÌܤò10¸ÄÄɲÃ
        for($i=1; $i<=9; $i++){
            $objQuery->query("alter table dtb_payment add memo0".$i." text;");
        }
        $objQuery->query("alter table dtb_payment add memo10 text;");
    }
}

?>