Connect = mysql_connect( $Server, $User, $Password );
mysql_select_db( $DbName, $this->Connect );
$this->Debug = FALSE;
}
# **********************************************************
# 接続解除
# **********************************************************
function Close( ) {
mysql_close( $this->Connect );
}
# **********************************************************
# クエリー
# **********************************************************
function Query( $SqlQuery ) {
$ret = mysql_query( $SqlQuery,$this->Connect );
if ( $this->Debug ) {
if ( mysql_errno() != 0 ) {
print "" . mysql_error() . "
";
}
}
return $ret;
}
# **********************************************************
# フェッチ
# **********************************************************
function Fetch( $Result ) {
return mysql_fetch_array( $Result );
}
# **********************************************************
# クエリーとフェッチ
# **********************************************************
function QueryEx( $SqlQuery='' ) {
if ( $SqlQuery != '' ) {
$this->Result = $this->Query( $SqlQuery );
if ( !$this->Result ) {
return FALSE;
}
return $this->Fetch ( $this->Result );
}
else {
return $this->Fetch ( $this->Result );
}
}
# **********************************************************
# 実行
# **********************************************************
function Execute( $SqlExec ) {
$ret = mysql_query( $SqlExec,$this->Connect );
if ( $this->Debug ) {
if ( mysql_errno() != 0 ) {
print "" . mysql_error() . "
";
}
}
return $ret;
}
# **********************************************************
# バージョン文字列取得
# **********************************************************
function Version( ) {
$Field = $this->QueryEx( "show variables like 'version'" );
return $Field[1];
}
}
/*
function guser($pid){
$SQL = new DB( );
$Query = 'select * from '.TABLENAME.' where del = 0 and id = "'.$pid.'" ';
$Column = $SQL->QueryEx( $Query );
while( $Column ) {
$data .= "{$Column['userid']}";
$Column = $SQL->QueryEx( );
}
return $data;
//$SQL->Close( );
}
*/
if(SQLS=="mysql"){
require("libs/mysqlclass.php");
}
if(SQLS=="postgres"){
require("libs/postgresclass.php");
}
if(SQLS=="sqlite"){
require("libs/sqliteclass.php");
}
if(SQLS=="sqlite3"){
require("libs/sqlite3class.php");
}
class tests{
function tests(){
$eid ="1";
$SQL = new DB( );
$query="select * from mt_entry where entry_status = 2 and entry_id = ".$eid."";
$Column = $SQL->QueryEx( $query );
while( $Column ) {
$data .= "{$Column['entry_created_on']}";
$Column = $SQL->QueryEx( );
}
$data = preg_replace("/ \d\d:\d\d:\d\d/", "", $data);
return $data;
}
}
//ページクラス
class PAGE{
function SITEDESC2(){
$eid ="1";
$SQL = new DB( );
$query="select * from mt_entry";
$Column = $SQL->QueryEx( $query );
while( $Column ) {
$Column = $SQL->QueryEx( );
$data .= $Column['entry_created_on'];
}
print_r($data);
return $data;
}
//親カテゴリをチェックいれば親カテゴリのidを返す
function parentcheck($cid){
$SQL = new DB( );
$query="select * from mt_category where category_blog_id = ".blogid." and category_id = ".$cid."";
$Column = $SQL->QueryEx( $query );
while( $Column ) {
$data .= "{$Column['category_parent']}";
$Column = $SQL->QueryEx( );
}
return $data;
}
function entry_authored_on($eid){
$SQL = new DB( );
$query="select * from mt_entry where entry_status = 2 and entry_id = ".$eid."";
$Column = $SQL->QueryEx( $query );
while( $Column ) {
$data .= "{$Column['entry_authored_on']}";
$Column = $SQL->QueryEx( );
}
$data = preg_replace("/ \d\d:\d\d:\d\d/", "", $data);
return $data;
}
function entry_created_on($eid){
$SQL = new DB( );
$query="select * from mt_entry where entry_status = 2 and entry_id = ".$eid."";
$Column = $SQL->QueryEx( $query );
while( $Column ) {
$data .= "{$Column['entry_created_on']}";
$Column = $SQL->QueryEx( );
}
$data = preg_replace("/ \d\d:\d\d:\d\d/", "", $data);
return $data;
}
function entry_title($eid){
$SQL = new DB( );
$query="select * from mt_entry where entry_status = 2 and entry_id = ".$eid."";
$Column = $SQL->QueryEx( $query );
while( $Column ) {
$data .= "{$Column['entry_title']}";
$Column = $SQL->QueryEx( );
}
$data = convertenc($data);
return $data;
}
function entry_body($eid){
$SQL = new DB( );
$query="select * from mt_entry where entry_status = 2 and entry_id = ".$eid."";
$Column = $SQL->QueryEx( $query );
while( $Column ) {
$data .= "{$Column['entry_text']}";
$Column = $SQL->QueryEx( );
}
$data = checktext($data);
$data = convertenc($data);
return $data;
}
//カテゴリ名を取得（引数に0を与えるとカテゴリ一覧ページでは自分の名前を返す。）
function catename($gcid){
if($gcid==0){
global $cid;$gcid = $cid;
}
$SQL = new DB( );
$query="select * from mt_category where category_id = ".$gcid."";
$rs = DBSQL::queryexcute($query);
while( $recs = DBSQL::getfetcharray($rs) ) {
$categorylabel = strip_tags($recs['category_label']);
$categorydescription = strip_tags($recs['category_description']);
if(categoryname=="1"){
$name = $categorylabel;
}else{
$name =$categorydescription;
}
}
$name = checktext($name);
$name = kana($name,0);
$name = convertenc($name);
return $name;
}
function SITEDESC(){
global $eid;
if($eid>=1&&ENTRYDESC==1){
$SQL = new DB( );
$query="select * from mt_entry where entry_status = 2 and entry_id = ".$eid."";
$rs = DBSQL::queryexcute($query);
while( $recs = DBSQL::getfetcharray($rs) ) {
$data = strip_tags($recs['entry_excerpt']);
$entry_keywords = strip_tags($recs['entry_keywords']);
}
$data =convertenc($data);
}else{
$data = SITEDESC;
}
if($data==""){$data = SITEDESC;}
$data = convertenc($data);
return $data;
}
function SITEKEY(){
global $eid;
if($eid>=1&&ENTRYKEY==1){
$SQL = new DB( );
$query="select * from mt_entry where entry_status = 2 and entry_id = ".$eid."";
$rs = DBSQL::queryexcute($query);
while( $recs = DBSQL::getfetcharray($rs)) {
$data = strip_tags($recs['entry_keywords']);
}
$data = convertenc($data);
}else{
$data = SITEKEY;
}
if($data==""){$data = SITEKEY;}
$data = convertenc($data);
return $data;
}
//エントリのカテゴリ名を返す(引数エントリID)
function entrycategory($eid){
$SQL = new DB( );
$query="select * from mt_entry ,mt_placement, mt_category where entry_status = 2 and placement_entry_id = entry_id and entry_id = ".$eid." and placement_category_id = category_id and placement_is_primary = 1 order by entry_created_on desc";
$Column = $SQL->QueryEx( $query );
while( $Column ) {
$data .= "{$Column['placement_category_id']}";
$Column = $SQL->QueryEx( );
}
$data = convertenc($data);
return $data;
}
function cfield($keyword,$eid){
$SQL = new DB( );
$keyw = "field.".$keyword;
$query="select * from mt_entry_meta where (entry_meta_entry_id = '".$id."') and entry_meta_type = '".$keyw."' Group by entry_meta_entry_id LIMIT 1";
$rs = dbquery($query);
while( $rec2 = DBSQL::getfetcharray($rs) )
{
$data= $rec2['entry_meta_vchar_idx'];
break;
}
return $data;
}
}
//日付取得クラス
class GETTIME{
function today(){
$time = time();
$tdate = date("Y-m-d H:i:s", $time);
return $tdate;
}
function fday(){
$time = time();
$x = 60*60*24*10;
$now = time() + $x;
$tdate = date("Y-m-d H:i:s", $now);
return $tdate;
}
}
class CategoryItem{
function CategoryItem(){
$SQL = new DB( );
}
function MakeSql($cid,$bid,$limit,$type,$mode,$parent){
if($bid=="0"){$bid=blogid;}
if(SQLS=="postgres"){
$SQL = "select distinct ";
}else{
$SQL = "select ";
}
$SQL .= "* from mt_category, mt_placement where category_blog_id = ".$bid." and (category_id = placement_category_id) and (category_class = '".$mode."')";
$SQL .= " and (category_parent = ".$parent.")";
if(SQLS=="postgres"){
}else{
$SQL .= " Group By category_id order by category_label";
}
if($cid!="0"&&$cid!="new"){
$SQL="select * from mt_category,mt_placement where category_blog_id = ".blogid;
$SQL .=" and category_parent = ".$cid."";
$SQL .=" and (category_id = placement_category_id) and (category_class = '".$mode."') order by category_label";}
$SQL .= $SQLIMIT;
return $SQL;
}
}