diff -r 8f6143115bf5 -r a8a21e1c7afa punbb/admin_ranks.php --- a/punbb/admin_ranks.php Wed Jul 11 21:28:39 2007 -0400 +++ b/punbb/admin_ranks.php Thu Jul 12 01:04:01 2007 -0400 @@ -26,12 +26,15 @@ // Tell header.php to use the admin template define('PUN_ADMIN_CONSOLE', 1); -define('PUN_ROOT', './'); -require PUN_ROOT.'include/common.php'; +//define('PUN_ROOT', './'); +//require PUN_ROOT.'include/common.php'; + +global $pun_db, $pun_user, $pun_config, $lang_common; + require PUN_ROOT.'include/common_admin.php'; -if ($pun_user['g_id'] > PUN_ADMIN) +if ($pun_user['g_id'] < PUN_ADMIN) message($lang_common['No permission']); @@ -50,17 +53,17 @@ message('Minimum posts must be a positive integer value.'); // Make sure there isn't already a rank with the same min_posts value - $result = $db->query('SELECT 1 FROM '.$db->prefix.'ranks WHERE min_posts='.$min_posts) or error('Unable to fetch rank info', __FILE__, __LINE__, $db->error()); - if ($db->num_rows($result)) + $result = $pun_db->query('SELECT 1 FROM '.$pun_db->prefix.'ranks WHERE min_posts='.$min_posts) or error('Unable to fetch rank info', __FILE__, __LINE__, $pun_db->error()); + if ($pun_db->num_rows($result)) message('There is already a rank with a minimun posts value of '.$min_posts.'.'); - $db->query('INSERT INTO '.$db->prefix.'ranks (rank, min_posts) VALUES(\''.$db->escape($rank).'\', '.$min_posts.')') or error('Unable to add rank', __FILE__, __LINE__, $db->error()); + $pun_db->query('INSERT INTO '.$pun_db->prefix.'ranks (rank, min_posts) VALUES(\''.$pun_db->escape($rank).'\', '.$min_posts.')') or error('Unable to add rank', __FILE__, __LINE__, $pun_db->error()); // Regenerate the ranks cache require_once PUN_ROOT.'include/cache.php'; generate_ranks_cache(); - redirect('admin_ranks.php', 'Rank added. Redirecting …'); + pun_redirect('admin_ranks.php', 'Rank added. Redirecting …'); } @@ -81,17 +84,17 @@ message('Minimum posts must be a positive integer value.'); // Make sure there isn't already a rank with the same min_posts value - $result = $db->query('SELECT 1 FROM '.$db->prefix.'ranks WHERE id!='.$id.' AND min_posts='.$min_posts) or error('Unable to fetch rank info', __FILE__, __LINE__, $db->error()); - if ($db->num_rows($result)) + $result = $pun_db->query('SELECT 1 FROM '.$pun_db->prefix.'ranks WHERE id!='.$id.' AND min_posts='.$min_posts) or error('Unable to fetch rank info', __FILE__, __LINE__, $pun_db->error()); + if ($pun_db->num_rows($result)) message('There is already a rank with a minimun posts value of '.$min_posts.'.'); - $db->query('UPDATE '.$db->prefix.'ranks SET rank=\''.$db->escape($rank).'\', min_posts='.$min_posts.' WHERE id='.$id) or error('Unable to update rank', __FILE__, __LINE__, $db->error()); + $pun_db->query('UPDATE '.$pun_db->prefix.'ranks SET rank=\''.$pun_db->escape($rank).'\', min_posts='.$min_posts.' WHERE id='.$id) or error('Unable to update rank', __FILE__, __LINE__, $pun_db->error()); // Regenerate the ranks cache require_once PUN_ROOT.'include/cache.php'; generate_ranks_cache(); - redirect('admin_ranks.php', 'Rank updated. Redirecting …'); + pun_redirect('admin_ranks.php', 'Rank updated. Redirecting …'); } @@ -102,13 +105,13 @@ $id = intval(key($_POST['remove'])); - $db->query('DELETE FROM '.$db->prefix.'ranks WHERE id='.$id) or error('Unable to delete rank', __FILE__, __LINE__, $db->error()); + $pun_db->query('DELETE FROM '.$pun_db->prefix.'ranks WHERE id='.$id) or error('Unable to delete rank', __FILE__, __LINE__, $pun_db->error()); // Regenerate the ranks cache require_once PUN_ROOT.'include/cache.php'; generate_ranks_cache(); - redirect('admin_ranks.php', 'Rank removed. Redirecting …'); + pun_redirect('admin_ranks.php', 'Rank removed. Redirecting …'); } @@ -153,8 +156,8 @@
query('SELECT id, rank, min_posts FROM '.$db->prefix.'ranks ORDER BY min_posts') or error('Unable to fetch rank list', __FILE__, __LINE__, $db->error()); -if ($db->num_rows($result)) +$result = $pun_db->query('SELECT id, rank, min_posts FROM '.$pun_db->prefix.'ranks ORDER BY min_posts') or error('Unable to fetch rank list', __FILE__, __LINE__, $pun_db->error()); +if ($pun_db->num_rows($result)) { ?> @@ -169,7 +172,7 @@ fetch_assoc($result)) + while ($cur_rank = $pun_db->fetch_assoc($result)) echo "\t\t\t\t\t\t\t\t".' '."\n"; ?>