//
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
// Author: phppp (D.J.) //
// URL: http://xoopsforge.com, http://xoops.org.cn //
// ------------------------------------------------------------------------- //
//include_once 'cp_functions.php';
include_once('./../../../include/cp_header.php');
xoops_cp_header();
include(dirname(__FILE__) . '/../wp-includes/version.php');
echo "
";
echo " ";
$xp_prefix = $GLOBALS['xoopsModule']->getInfo('dirname');
if ($xp_prefix == 'wordpress'){
$xp_prefix = 'wp';
}
$prefix = $xoopsDB->prefix($xp_prefix . '_');
$sql = "SELECT COUNT(DISTINCT post_author) AS count_author, COUNT(*) AS count_article FROM ".$prefix . "posts WHERE post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')";
$result = $xoopsDB->query($sql);
if($myrow = $xoopsDB->fetchArray($result)){
$count_article = $myrow["count_article"];
$count_author = $myrow["count_author"];
}
if ($wp_db_version < 6124){
$sql = "SELECT COUNT(*) AS count_category FROM ".$xoopsDB->prefix($xp_prefix . "_categories");
} else {
$sql = "SELECT COUNT(*) AS count_category FROM ".$xoopsDB->prefix($xp_prefix . "_term_taxonomy") . " WHERE taxonomy = 'category'";
}
$result = $xoopsDB->query($sql);
if($myrow = $xoopsDB->fetchArray($result)){
$count_category = $myrow["count_category"];
}
echo "";
xoops_cp_footer();
?>