jquery.php

Go to the documentation of this file.

<?php
require('../../../../mainfile.php');
require(XOOPS_ROOT_PATH.'/header.php');

if (!defined('XOOPS_ROOT_PATH')) { die('Error'); }

if ( !is_object($xoopsUser) || !is_object($xoopsModule) || !$xoopsUser->isAdmin($xoopsModule->mid()) ) exit( _NOPERM );

if (isset($_REQUEST["op"])) {
        $op = $_REQUEST["op"];
} else {
        @$op = "default";
}

switch ($op) {

        // Display post
        case 'display_post': 
                global $xoopsDB;
        
        $GLOBALS['xoopsLogger']->activated = false;
        
                include_once XOOPS_ROOT_PATH . '/include/comment_constants.php';
                include_once XOOPS_ROOT_PATH . '/kernel/module.php';
        include_once XOOPS_ROOT_PATH . '/modules/system/include/functions.php';
                                
                $tables = array();
                // Count comments (approved only: com_status == XOOPS_COMMENT_ACTIVE)           
                $tables[] = array ('table_name' => 'xoopscomments', 'uid_column' => 'com_uid', 'criteria' => new Criteria('com_status', XOOPS_COMMENT_ACTIVE));
                // Count forum posts
                if (XoopsModule::getByDirname("newbb")) {
                        $tables[] = array ('table_name' => 'bb_posts', 'uid_column' => 'uid');
                }
                $uid = system_CleanVars($_REQUEST, 'uid', int);
                $total_posts = 0;
                foreach ($tables as $table) 
                {
                        $criteria = new CriteriaCompo();
                        $criteria->add (new Criteria($table['uid_column'], $uid ));
                        if (!empty($table['criteria'])) {
                                $criteria->add ($table['criteria']);
                        }
                        $sql = "SELECT COUNT(*) AS total FROM ".$xoopsDB->prefix($table['table_name']) . ' ' . $criteria->renderWhere();
                        if ( $result = $xoopsDB->query($sql) ) {
                                if ($row = $xoopsDB->fetchArray($result)) {
                                        $total_posts = $total_posts + $row['total'];
                                }
                        }
                }

                $sql = "UPDATE ".$xoopsDB->prefix("users")." SET posts = '".$total_posts."' WHERE uid = '".$uid."'";
                if ( !$result = $xoopsDB->queryF($sql) ) {
                        redirect_header("admin.php?fct=users",1,_AM_SYSTEM_USERS_CNUUSER);
                } else {
                        echo $total_posts;
                }
           break;
}

?>