[extension release] pun_karma

<?php

if (!defined('FORUM_ROOT'))
    define('FORUM_ROOT', './');
require FORUM_ROOT.'include/common.php';

@set_time_limit(0);

$forum_db->add_field('posts', 'karma', 'INT(10)', TRUE);

$pun_karma_query = array(
    'SELECT'    =>    'post_id, SUM(mark) AS sum_mark',
    'FROM'        =>    'pun_karma',
    'GROUP BY'    =>    'post_id'
);
$pun_karma_res = $forum_db->query_build($pun_karma_query) or error(__FILE__, __LINE__);

while ($cur_karma = $forum_db->fetch_assoc($pun_karma_res))
{
    $pun_karma_query = array(
        'UPDATE'    =>    'posts',
        'SET'        =>    'karma = '.$cur_karma['sum_mark'],
        'WHERE'        =>    'id = '.$cur_karma['post_id']
    );
    $forum_db->query_build($pun_karma_query) or error(__FILE__, __LINE__);
}

$forum_db->add_field('users', 'karma', 'INT(10)', TRUE);
$pun_karma_query = array(
    'SELECT'    =>    'poster_id, SUM(mark) AS user_karma',
    'FROM'        =>    $forum_db->prefix.'posts AS p, '.$forum_db->prefix.'pun_karma AS pk',
    'WHERE'        =>    'p.id = pk.post_id',
    'GROUP BY'    =>    'poster_id',
    'PARAMS'    =>    array(
        'NO_PREFIX'    =>    true
    )
);
$pun_karma_res = $forum_db->query_build($pun_karma_query) or error(__FILE__, __LINE__);

if ($forum_db->num_rows($pun_karma_res) > 0)
{
    while ($cur_karma = $forum_db->fetch_assoc($pun_karma_res))
    {
    $pun_karma_update_query = array(
        'UPDATE'    =>    'users',
        'SET'        =>    'karma = '.$cur_karma['user_karma'],
        'WHERE'        =>    'id = '.$cur_karma['poster_id']
       );
       $forum_db->query_build($pun_karma_update_query) or error(__FILE__, __LINE__);
    }
}

echo 'Done.';
?>