root/simpaty.php

<?php</span>
<span class="code-lang">$root_path = './';
require ($root_path . 'include/config.php');

$userdata = session_pagestart($user_ip);
init_userprefs($userdata);
loggedinorreturn();

$action = request_var('action', '');</span>
<span class="code-lang">
if ( $action == 'add' ) {
    require_once ($root_path . 'include/ajax.php');
    $JsHttpRequest = new JsHttpRequest();

    $db->sql_return_on_error(true);

    $current_time = time();
    $resp_type = request_var('type', 0);
    $targetid = request_var('targetid', 0);
    $state = request_var('state', 0);
    $current_reputation = request_var('current_reputation', '');

    if ( !isset($ranks) ) {
        $ranks = $cache->obtain_ranks();
    }

    foreach ( $ranks AS $rank_id => $rank_ary ) {
        if ( $rank_id == $userdata['user_rank_id'] ) {
            $rank_settings = $rank_ary;
            break;
        }
    }

    if ( $rank_settings['rank_simpaty_limit'] == 0 ) {
        return $_RESULT = array( 'status' => 'error', 'errorMessage' => $lang['no_simpaty_low_level'] );
    }

    $todayTime = strtotime('today');

    $sql = 'SELECT COUNT(*) AS resp_count
            FROM ' . SIMPATY_TABLE . '
            WHERE fromuserid = ' . $userdata['uid'] . ' AND respect_time >= ' . $todayTime;
    $result = $db->sql_query($sql);
    $count = ( $row = $db->sql_fetchrow($result) ) ? $row['resp_count'] : 0;

    if ( $count >= $rank_settings['rank_simpaty_limit'] ) {
        return $_RESULT = array( 'status' => 'error', 'errorMessage' => sprintf($lang['you_reached_simpaty_limit'], $rank_settings['rank_simpaty_limit'], create_date($todayTime + 1 * 24 * 60 * 60 + 1, 'Y-m-d H:i:s') )  );
    }

    $sql = 'SELECT COUNT(*) AS resp_count FROM ' . SIMPATY_TABLE . ' WHERE fromuserid = ' . $userdata['uid'] . ' AND simpid = ' . $targetid . ' AND type = ' . $resp_type;
    $result = $db->sql_query($sql);
    $count = ( $row = $db->sql_fetchrow($result) ) ? $row['resp_count'] : 0;
    if ( $count ) {
        return $_RESULT = array( 'status' => 'error', 'errorMessage' => $lang['already_simpaty']  );
    }

    $state_upd = ( $state == 1 ? 1 : -1 );

    switch ( $resp_type ) {
        case SIMPATY_COMMENT:
                $sql = 'SELECT comment_user AS user_id, user_reputation, user_reputation_level, user_rank_id, uid
                       FROM ' . COMMENTS_TABLE . ' c, ' . USERS_TABLE . ' u
                       WHERE c.comment_user = u.uid
                       AND comment_id = ' . $targetid;

                $sql_update_1 = 'UPDATE ' . COMMENTS_TABLE . ' SET comment_reputation = comment_reputation + ' . $state_upd . ' WHERE comment_id = ' . $targetid;
        break;

        case SIMPATY_FORUM_POST:
            $sql = 'SELECT poster_id AS user_id, user_reputation, user_reputation_level, user_rank_id, uid
                    FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u
                    WHERE p.poster_id = u.uid
                    AND post_id = ' . $targetid;

             $sql_update_1 = 'UPDATE ' . POSTS_TABLE . ' SET post_reputation = post_reputation + ' . $state_upd . ' WHERE post_id = ' . $targetid;
        break;
    }

    $result = $db->sql_query($sql);

    if ( !$row = $db->sql_fetchrow($result) ) {
        return $_RESULT = array( 'status' => 'error', 'errorMessage' => sprintf($lang['invalid_id'], $targetid)  );
    }
    else {
        if ( $row['user_id'] == $userdata['uid'] ) {
            return $_RESULT = array( 'status' => 'error', 'errorMessage' => $lang['no_simpaty_to_your_self'] );
        }
        if ( $row['user_id'] == ANONYMOUS ) {
            return $_RESULT = array( 'status' => 'error', 'errorMessage' => sprintf($lang['invalid_id'], $targetid) );
        }

        $db->sql_query($sql_update_1);

        update_reputation($row, $resp_type, $state);

        $ins_ary = array(
            'touserid' => $row['user_id'],
            'fromuserid' => $userdata['uid'],
            'simpaty' => $state,
            'type' => $resp_type,
            'simpid' => $targetid,
            'respect_time' => $current_time
        );

        $sql = 'INSERT INTO ' . SIMPATY_TABLE . ' ' . $db->sql_build_array('INSERT', $ins_ary);
        $db->sql_query($sql);

        $sql = 'SELECT s.simpaty, u.name, u.uid
                FROM ' . SIMPATY_TABLE . ' s, ' . USERS_TABLE . ' u
                WHERE s.fromuserid = u.uid
                AND simpid = ' . $targetid . '
                AND type = ' . $resp_type;
        $result = $db->sql_query($sql);

        $userslist = '';
        while ( $row = $db->sql_fetchrow($result) ) {
            $userslist .= ( $userslist ? ', ' : '' );

            // www.phpBB-SEO.com SEO TOOLKIT START
            $seo->set_user_url($row['name'], $row['uid']);
            // www.phpBB-SEO.com SEO TOOLKIT END

            $userslist .= '<a href="' . append_sid($root_path . 'userdetails.php?id=' . $row['uid'])  . '"><span class="' . ( $row['simpaty'] ? 'usergoodResp' : 'userbadResp' ) . '">' . $row['name'] . '</span></a>';
        }

        return $_RESULT = array( 'status' => 'ok', 'respCount' => $current_reputation + $state_upd, 'userList' => $userslist );
    }
}
else {
    trigger_error($lang['bad_type']);
}
?>