function punktesystem_install()
{
global $db;
$db->write_query("ALTER TABLE `".TABLE_PREFIX."users` ADD `punkte` INT(10) NULL DEFAULT '100';");
}
function punktesystem_is_installed()
{
global $db;
if($db->num_rows($db->query("SHOW COLUMNS FROM `".TABLE_PREFIX."users` LIKE 'punkte';")) != 0)
{
return true;
}
return false;
}
function punktesystem_uninstall()
{
global $db;
$db->write_query("ALTER TABLE `".TABLE_PREFIX."users` DROP `punkte`;");
}
function punktesystem_activate()
{
require "../inc/adminfunctions_templates.php";
find_replace_templatesets("member_profile", '#{\$warning_level}#', '{\$warning_level}<tr><td class="trow1"><strong>Punkte:</strong></td><td class="trow1">xxxxxxx</td></tr>');
}
function punktesystem_deactivate()
{
require "../inc/adminfunctions_templates.php";
find_replace_templatesets("member_profile", '#<tr><td class="trow1"><strong>Punkte:</strong></td><td class="trow1">xxxxxxx</td></tr>#', '', 0);
}
find_replace_templatesets("member_profile", '#'.preg_quote('{punktesystem}').'#', '', 0);
}
function punktesystem_thread()
{
global $db, $mybb;
$query = $db->simple_select('users', 'punkte', "uid='".$mybb->user['uid']."'", 1);
$row = $db->fetch_array($query);
$neu = array(
'punkte' => $row["punkte"] + 15
);
$db->update_query('users', $neu, "uid='".$mybb->user['uid']."'", 1);
}
function punktesystem_reply()
{
global $db, $mybb;
$query = $db->simple_select('users', 'punkte', "uid='".$mybb->user['uid']."'", 1);
$row = $db->fetch_array($query);
$neu = array(
'punkte' => $row["punkte"] + 10
);
$db->update_query('users', $neu, "uid='".$mybb->user['uid']."'", 1);
}