Hey all, i need some help...its a short form, but thigs just wont go right on it!
admin_mod.php
define('IN_PHPBB', 1);
if( !empty($setmodules) )
{
$filename = basename(FILE);
//$module['Users']['Permissions'] = $filename . "?mode=user";
//$module['Groups']['Permissions'] = $filename . "?mode=group";
return;
}
//
// Load default header
//
$no_page_header = TRUE;
$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
$params = array('mode' => 'mode', 'user_id' => POST_USERS_URL, 'group_id' => POST_GROUPS_URL, 'adv' => 'adv');
while( list($var, $param) = @each($params) )
{
if ( !empty($HTTP_POST_VARS[$param]) || !empty($HTTP_GET_VARS[$param]) )
{
$$var = ( !empty($HTTP_POST_VARS[$param]) ) ? $HTTP_POST_VARS[$param] : $HTTP_GET_VARS[$param];
}
else
{
$$var = "";
}
}
//
// Start Script - Defining Variables
// No Variables As Of Yet 😉
//
//
// Actions For Script
//
//
// Getting The Users Information 😉
//
$sql = "SELECT username, user_id FROM " . USERS_TABLE . " WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Couldn't obtain user/group information", "", LINE, FILE, $sql);
}
$userinfo = array();
while( $row = $db->sql_fetchrow($result) )
{
$userinfo = $row;
}
$db->sql_freeresult($result);
$username = $userinfo['username'];
//
// Did the Admin Click Sumbit.........
// Well then, lets Make The User A Moderator 😉
//
if ( isset($HTTP_POST_VARS['submit']) )
{
$sql = "SELECT username, user_id FROM " . USERS_TABLE . " WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Error #2", "", LINE, FILE, $sql);
}
$userinfo = array();
while( $row = $db->sql_fetchrow($result) )
{
$userinfo = $row;
}
$db->sql_freeresult($result);
$username = $userinfo['username'];
$sql_submit = "INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES ($group_id, $user_id, 0)";
if ( !($result = $db->sql_query($sql_submit)) )
{
message_die(GENERAL_ERROR, "Couldnt Place The User Into The Requested Group", "", __LINE__, __FILE__, $sql_submit);
}
$group_id = $HTTP_POST_VARS['modgroup'];
$user_id = $userinfo['user_id'];
}
//
// Did the Admin Click Remove.......
// Well then, lets get this peice of @!#$ outta here 😉
//
if ( isset($HTTP_POST_VARS['remove']) )
{
$sql = "SELECT username, user_id FROM " . USERS_TABLE . " WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Error #3", "", LINE, FILE, $sql);
}
$userinfo = array();
while( $row = $db->sql_fetchrow($result) )
{
$userinfo = $row;
}
$db->sql_freeresult($result);
$username = $userinfo['username'];
$sql_remove = "DELETE FROM phpbb_user_group WHERE group_id = '$group_id' AND user_id ='$user_id' AND user_pending='0'";
if ( !($result = $db->sql_query($sql_remove)) )
{
message_die(GENERAL_ERROR, "Couldnt Remove User From The Requested Group", "", __LINE__, __FILE__, $sql_remove);
}
$group_id = $HTTP_POST_VARS['modgroup'];
$user_id = $userinfo['user_id'];
}
//
// Dump in the page header ...
//
include('./page_header_admin.'.$phpEx);
$template->set_filenames(array(
"body" => 'admin/admin_mod_body.tpl')
);
//Assign Templates Variables - All Of Them
$template->assign_vars(array(
'L_USER_OR_GROUPNAME' => ( $mode == 'user' ) ? $lang['Username'] : $lang['Group_name'],
'L_AUTH_TITLE' => ( $mode == 'user' ) ? $lang['Auth_Control_User'] : $lang['Auth_Control_Group'],
'L_AUTH_EXPLAIN' => ( $mode == 'user' ) ? $lang['User_auth_explain'] : $lang['Group_auth_explain'],
'L_MODERATOR_STATUS' => $lang['Moderator_status'],
'L_PERMISSIONS' => $lang['Permissions'],
'L_SUBMIT' => $lang['Submit'],
'L_RESET' => $lang['Reset'],
'L_FORUM' => $lang['Forum'],
'U_USER_OR_GROUP' => append_sid("admin_mod.$phpEx"),
'U_SWITCH_MODE' => $u_switch_mode,
'S_COLUMN_SPAN' => $s_column_span,
'S_AUTH_ACTION' => append_sid("admin_mod.$phpEx"),
'S_HIDDEN_FIELDS' => $s_hidden_fields)
);
$template->assign_vars(array(
'USERNAME' => $username,
'USER_LEVEL' => $lang['User_Level'] . " : " . $s_user_type,
'USER_GROUP_MEMBERSHIPS' => $lang['Group_memberships'] . ' : ' . $t_usergroup_list)
);
$template->pparse('body');
include('./page_footer_admin.'.$phpEx);
?>
Form Template
<h1>{L_AUTH_TITLE}</h1>
<h2>Moderator Status For: {USERNAME}</h2>
<form method="post" action="{S_AUTH_ACTION}">
<br><br>
<table cellspacing="1" cellpadding="0" border="0" align="center" class="forumline">
<tr>
<th align="center" width="50%" class="thCornerL">Number</th>
<th align="center" width="50%%" class="thCornerL">Value</th>
</tr>
<tr>
<td colspan="{S_COLUMN_SPAN}" class="row1" align="center"> <span class="gensmall"><b>0</b></span></td>
<td colspan="{S_COLUMN_SPAN}" class="row2" align="center"> <span class="gensmall">Give Elite Access</span></td>
</tr>
<tr>
<td colspan="{S_COLUMN_SPAN}" class="row1" align="center"> <span class="gensmall"><b>1</b></span></td>
<td colspan="{S_COLUMN_SPAN}" class="row2" align="center"> <span class="gensmall">Give Admin Privelages</span></td>
</tr>
<tr>
<td colspan="{S_COLUMN_SPAN}" class="row1" align="center"> <span class="gensmall"><b>2</b></span></td>
<td colspan="{S_COLUMN_SPAN}" class="row2" align="center"> <span class="gensmall">Moderate All Forums</span></td>
</tr>
<tr>
<td colspan="{S_COLUMN_SPAN}" class="row1" align="center"> <span class="gensmall"><b>3</b></span></td>
<td colspan="{S_COLUMN_SPAN}" class="row2" align="center"> <span class="gensmall">Moderate Main Forums</span></td>
</tr>
<tr>
<td colspan="{S_COLUMN_SPAN}" class="row1" align="center"> <span class="gensmall"><b>4</b></span></td>
<td colspan="{S_COLUMN_SPAN}" class="row2" align="center"> <span class="gensmall">Moderate Elite Area</span></td>
</tr>
<tr>
<td colspan="{S_COLUMN_SPAN}" class="row1" align="center"> <span class="gensmall"><b>5</b></span></td>
<td colspan="{S_COLUMN_SPAN}" class="row2" align="center"> <span class="gensmall">Moderate Komunitta's Korner</span></td>
</tr>
<tr>
<td colspan="{S_COLUMN_SPAN}" class="row1" align="center"> <span class="gensmall"><b>6</b></span></td>
<td colspan="{S_COLUMN_SPAN}" class="row2" align="center"> <span class="gensmall">Moderate Filez/Proving Ground</span></td>
</tr>
<br>
</table>
<br>
<table cellspacing="1" cellpadding="4" border="0" align="center" class="forumline">
<tr>
<th align="center" width="30%" class="thCornerL">Moderator Status Input 😉</th>
</tr>
<tr>
<td colspan="50%" class="row1" align="center"> <span class="gensmall"><b>{USERNAME}'s</b> Moderation Group</span></td>
<td colspan="50%" class="row2" align="center"> <span class="gensmall"><INPUT type="text" style="width: 200px" name="modgroup" size="25" maxlength="20" value="Input Group Here!"></input></span></td>
</tr>
<br>
<tr align="center">
<td colspan="{S_COLUMN_SPAN}" class="catBottom" align="center">
<input align="center" type="submit" name="submit" value="Submit" class="mainoption" />
<input align="center" type="reset" name="remove" value="Remove" class="liteoption" />
</td>
</tr>
</table>
</form>
Hypothetically speaking, lets say i have a user whos name is MR.T! His User_id = 11
I click on admin_mod.php......it loads the template!
Everything is going grand.....i input a number from the 0 - 6 and click submit!
then i get an error
General Error
Couldnt obtain user/group information!
My point is that, it is going back to a query i dont need anymore!
I used the 1st SQL query to obtain the user_id for use in the 2nd OR 3rd query....therefore.....after i get the user_id, i dont need that query anymore...yet i keep gettin it!
Can any1 help me 🙂
