Index: temp/test-xoops.ec-cube.net/html/modules/newbb/test/kakinaka/class/SC_DbConn.php =================================================================== --- temp/test-xoops.ec-cube.net/html/modules/newbb/test/kakinaka/class/SC_DbConn.php (revision 989) +++ temp/test-xoops.ec-cube.net/html/modules/newbb/test/kakinaka/class/SC_DbConn.php (revision 989) @@ -0,0 +1,198 @@ +connection) || $new) { + if($dsn != "") { + $objDbConn = DB::connect($dsn, $options); + $this->dsn = $dsn; + } else { + if(defined('DEFAULT_DSN')) { + $objDbConn = DB::connect(DEFAULT_DSN, $options); + $this->dsn = DEFAULT_DSN; + } else { + return; + } + } + } + $this->conn = $objDbConn; + $this->error_mail_to = DB_ERROR_MAIL_TO; + $this->error_mail_title = DB_ERROR_MAIL_SUBJECT; + $this->err_disp = $err_disp; + } + + // ¥¯¥¨¥ê¤Î¼Â¹Ô + function query($n ,$arr = "", $ignore_err = false){ + if ( $arr ) { + $result = $this->conn->query($n, $arr); + } else { + $result = $this->conn->query($n); + } + + if ($this->conn->isError($result) && !$ignore_err){ + $this->send_err_mail ($result, $n); + } + + $this->result = $result; + return $this->result; + } + + // °ì·ï¤Î¤ß¼èÆÀ + function getOne($n, $arr = ""){ + + // mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë + if (DB_TYPE == "mysql") $n = sfChangeMySQL($n); + + if ( $arr ) { + $result = $this->conn->getOne($n, $arr); + } else { + $result = $this->conn->getOne($n); + } + if ($this->conn->isError($result)){ + $this->send_err_mail ($result ,$n); + } + $this->result = $result; + + return $this->result; + } + + function getRow($n, $arr = ""){ + + // mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë + if (DB_TYPE == "mysql") $n = sfChangeMySQL($n); + + if ( $arr ) { + $result = $this->conn->getRow($n, $arr); + } else { + $result = $this->conn->getRow($n); + } + if ($this->conn->isError($result)){ + $this->send_err_mail ($result ,$n); + } + $this->result = $result; + return $this->result; + } + + // SELECTʸ¤Î¼Â¹Ô·ë²Ì¤òÁ´¤Æ¼èÆÀ + function getAll($n, $arr = ""){ + + // mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë + if (DB_TYPE == "mysql") $n = sfChangeMySQL($n); + + if(PEAR::isError($this->conn)) { + sfErrorHeader("DB¤Ø¤ÎÀܳ¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£:" . $this->dsn); + return 0; + } + + if ( $arr ){ + $result = $this->conn->getAll($n, $arr, DB_FETCHMODE_ASSOC); + } else { + $result = $this->conn->getAll($n, DB_FETCHMODE_ASSOC); + } + + if ($this->conn->isError($result)){ + $this->send_err_mail ($result, $n); + } + $this->result = $result; + + return $this->result; + } + + function autoExecute($table_name, $fields_values, $sql_where = null){ + + if ( $sql_where ) { + $result = $this->conn->autoExecute( $table_name, $fields_values, DB_AUTOQUERY_UPDATE, $sql_where); + } else { + $result = $this->conn->autoExecute( $table_name, $fields_values, DB_AUTOQUERY_INSERT); + } + + if ($this->conn->isError($result)){ + $this->send_err_mail ($result, $n); + } + $this->result = $result; + return $this->result; + } + + + function prepare($n){ + global $sql; + $sql = $n; + $result = $this->conn->prepare($n); + $this->result = $result; + return $this->result; + } + + function execute($n, $obj){ + global $sql; + $sql = $n; + $result = $this->conn->execute($n, $obj); + $this->result = $result; + return $this->result; + } + + function reset(){ + $this->conn->disconnect(); + } + + function send_err_mail( $result, $sql ){ + + if ($this->err_disp) { + if ($_SERVER['HTTPS'] == "on") { + $url = "https://"; + } else { + $url = "http://"; + } + $url.= $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; + + $errmsg = $url."\n\n"; + $errmsg.= "REMOTE_ADDR:" . $_SERVER['REMOTE_ADDR'] . "\n"; + $errmsg.= "USER_AGENT:" . $_SERVER['HTTP_USER_AGENT'] . "\n\n"; + $errmsg.= $sql . "\n"; + $errmsg.= $result->message . "\n\n"; + $errmsg.= $result->userinfo . "\n\n"; + + $arrRbacktrace = array_reverse($result->backtrace); + + foreach($arrRbacktrace as $backtrace) { + if($backtrace['class'] != "") { + $func = $backtrace['class'] . "->" . $backtrace['function']; + } else { + $func = $backtrace['function']; + } + + $errmsg.= $backtrace['file'] . " " . $backtrace['line'] . ":" . $func . "\n"; + } + + mb_send_mail(DB_ERROR_MAIL_TO, DB_ERROR_MAIL_SUBJECT, $errmsg); + + exit; + } + } +} + +?> Index: temp/test-xoops.ec-cube.net/html/modules/newbb/test/kakinaka/templates/topic_list.html =================================================================== --- temp/test-xoops.ec-cube.net/html/modules/newbb/test/kakinaka/templates/topic_list.html (revision 987) +++ temp/test-xoops.ec-cube.net/html/modules/newbb/test/kakinaka/templates/topic_list.html (revision 987) @@ -0,0 +1,110 @@ + +
+ + + + + + +
<{$arrCat.cat_title}> > <{$forum_name}>
+ + + + + + + + + + + + + + + +
+ + + + +
<{$forum_name}>
+
+ + + + +
¿·µ¬¥¹¥ì¥Ã¥É¤òÄɲ乤ë
+ + + + + + +
<{$forum_pagenav}>
+ + +
+ + + + + + + + + + + + + + + + <{foreach item=topic from=$topics}> + "> + + + + + + + + + <{/foreach}> + + + + +
  <{$lang_topic}><{$lang_response}><{$lang_replies}><{$lang_poster}><{$lang_views}><{$lang_date}>
<{$topic.topic_icon}> [<{$topic.fix}>:<{$topic.topic_number}>]<{$topic.topic_title}><{$topic.topic_page_jump}> + <{ $arrResponse[$topic.topic_response]|default:'???' }> + <{if $arrResponse[$topic.topic_response] != ""}> (<{$topic.topic_response_user|default:'¥²¥¹¥È'}>) <{/if}> + <{* + +
+ + *}> + + 		<{$topic.topic_replies}><{$topic.topic_poster}><{$topic.topic_views}><{$topic.topic_last_posttime}>
<{$lang_by}> <{$topic.topic_last_poster}>
<{$lang_sortby}> <{$forum_selection_sort}> <{$forum_selection_order}> <{$forum_selection_since}>
+
+ + + + + + + + +
<{$forum_pagenav}>
+ + + + + +
<{$forum_jumpbox}>
+ +
+ +
Index: temp/test-xoops.ec-cube.net/html/modules/newbb/test/kakinaka/topic_list.php =================================================================== --- temp/test-xoops.ec-cube.net/html/modules/newbb/test/kakinaka/topic_list.php (revision 993) +++ temp/test-xoops.ec-cube.net/html/modules/newbb/test/kakinaka/topic_list.php (revision 993) @@ -0,0 +1,23 @@ +prefix('bb_topics'); +if ( !$result = $xoopsDB->query($sql) ) { + redirect_header(XOOPS_URL.'/',1,_MD_ERROROCCURED); + exit(); +} + +while ( $myrow = $xoopsDB->fetchArray($result) ) { + //echo mb_detect_encoding($myrow) . "
"; + $myrow = mb_convert_encoding($myrow["topic_title"], "euc-jp"); + print($myrow); + print("
"); +} + +// Âбþ¾õ¶· +$xoopsTpl->assign('arrResponse', $arrResponse); + +?>