Menu
▾
▴
[ModCVS] CVS: PN_phpBB_14/html/modules/phpBB_14/admin/modules phpBB_14_HonoraryRanksAssign.php,NONE,1.1 phpBB_14_HonoraryRanksAssignSave.php,NONE,1.1 honorary_assign.php,1.5,NONE
|
From: vladimir c. <ch...@us...> - 2002-01-23 12:01:36
|
Update of /cvsroot/pn-modules/PN_phpBB_14/html/modules/phpBB_14/admin/modules
In directory usw-pr-cvs1:/tmp/cvs-serv26396
Added Files:
phpBB_14_HonoraryRanksAssign.php
phpBB_14_HonoraryRanksAssignSave.php
Removed Files:
honorary_assign.php
Log Message:
Honorary Ranks assign moved to separate files
--- NEW FILE: phpBB_14_HonoraryRanksAssign.php ---
<?php // $Id: phpBB_14_HonoraryRanksAssign.php,v 1.1 2002/01/23 12:01:33 chv Exp $
if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); }
if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); }
modules_get_language();
include("modules/$ModName/phpBB_14tables.php");
function phpBB_14_HonoraryRanksAssign(){
global $pntable, $bbtable,$dbconn,$bgcolor2, $bgcolor3, $bgcolor1;
include("header.php");
GraphicAdmin($hlpfile);
opentable();
echo "<center><a class=\"pn-pagetitle\" href=\"admin.php?op=phpBB_14\">"._PHPBB_ADMINFORUMSPANEL."</a></center>";
closetable();
echo "<br>";
?>
<TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" ALIGN="CENTER" VALIGN="TOP" WIDTH="100%">
<TR><TD BGCOLOR="<?php echo $bgcolor2?>">
<TABLE BORDER="0" CELLPADDING="3" CELLSPACING="1" WIDTH="100%">
<TR bgcolor="<?php echo $bgcolor2; ?>" ALIGN="LEFT">
<TD ALIGN="CENTER" COLSPAN="4"><FONT class="pn-title"><?php echo $pagetitle; ?></font>
</td>
</tr>
<TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT">
<TD ALIGN="CENTER" COLSPAN="6">
<br>
Here you can individually assigned honorary ranks to specific users.<BR>
</TD>
</TR>
<TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT">
<TD ALIGN="CENTER"><FONT class="pn-normal"><b>User</b></FONT></TD>
<TD ALIGN="CENTER"><FONT class="pn-normal"><b>Honorary rank</b></FONT></TD>
<TD ALIGN="CENTER" colspan="2"><FONT class="pn-normal"><b>Actions</b></FONT></TD>
</TR>
<TR BGCOLOR="<?php echo $bgcolor3?>" ALIGN="LEFT">
<form action="admin.php?op=phpBB_14_HonoraryRanksAssignSave" method="post">
</TR>
<?php
$message = phpbb_14_users_menu();
if ($message !='')
{
?>
<TR BGCOLOR="<?php echo $bgcolor1?>" ALIGN="CENTER">
<TD><?php echo $message; ?>
</TD>
<?php
if (isset($m)){
$message=ranks_menu($m['rank_id']);
}else{
$message=ranks_menu('');
}
?>
<TD><?php echo $message; ?></TD>
<td>
<INPUT TYPE="SUBMIT" NAME="actiontype" VALUE="Add">
</TD>
<TD> </TD>
</FORM>
</TR>
<?php
}
$sql = "SELECT u.user_id,
p.uname,
r.rank_id,
r.rank_title,
r.rank_image,
r.rank_style
FROM ".$bbtable['ranks']." as r
LEFT JOIN ".$bbtable['users']." as u
ON r.rank_id=u.user_rank
LEFT JOIN ".$pntable['users']." as p
ON p.uid=u.user_id
WHERE (r.rank_special=1) and (u.user_id <>'') and (p.uname<>'')
ORDER BY p.uname";
if(!$r = mysql_query($sql)) {
error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error());
}
if($m = mysql_fetch_array($r)) {
do {
?>
<form action="admin.php?op=phpBB_14_HonoraryRanksAssignSave" method="post">
<?php
echo "<TR BGCOLOR=\"$bgcolor1\" ALIGN=\"CENTER\">\n";
echo "<TD BGCOLOR=\"$bgcolor3\" >".$m['uname']."</TD>\n";
$message=ranks_menu($m['rank_id']);
echo "<TD>".$message."</TD>\n";
$user_id = $m['user_id'];
echo "<TD>";
echo "<INPUT TYPE=\"HIDDEN\" NAME=\"user_id\" VALUE=\"$user_id\">\n";
echo "<INPUT TYPE=\"SUBMIT\" NAME=\"actiontype\" VALUE=\"Update\"></TD>\n";
echo "<TD><INPUT TYPE=\"SUBMIT\" NAME=\"actiontype\" VALUE=\"Delete\"></FORM></TD>\n";
echo "</TR>";
} while($m = mysql_fetch_array($r));
}else{
echo "<TR BGCOLOR=\"$bgcolor2\" ALIGN=\"CENTER\"><TD COLSPAN=\"7\"><font class=\"pn-normal\">No Special Ranks in the Database. You can add one by entering into the form below.</FONT></TD></TR>";
}
echo "</TABLE></TABLE>\n";
include("footer.php");
}
function ranks_menu($rank_id){
global $bbtable;
$message = '<SELECT NAME="rank_id">';
$sql = "SELECT rank_id, rank_title FROM ".$bbtable['ranks']."
WHERE rank_special=1
ORDER BY rank_title";
if(!$result = mysql_query($sql)) {
error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error());
}
$myrow = mysql_fetch_array($result);
$rank_count=0;
do {
$name = stripslashes($myrow['rank_title']);
$message .= "<OPTION VALUE= ".$myrow['rank_id'];
if ($rank_id==$myrow['rank_id'])
{
$message .= " selected>".$name."</OPTION>\n";
$selected_rank_id = $rank_id;
}else{
$message .= ">".$name."</OPTION>\n";
}
$rank_count++;
} while($myrow = mysql_fetch_array($result));
$message .= "</SELECT>";
$message .= '<input type="hidden" name="previous_rank" value="'.$selected_rank_id.'">';
return $message;
}
function phpbb_14_users_menu(){
global $bbtable,$pntable;
$sql = "SELECT u.user_id, p.uname
FROM ".$bbtable['users']." as u
LEFT JOIN ".$pntable['users']." as p
ON p.uid=u.user_id
WHERE (u.user_rank=0) and (p.uid<>1) and (u.user_id <> '')
ORDER BY p.uname";
if(!$result = mysql_query($sql)) {
error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error());
}
if (mysql_num_rows($result)>0) {
$message = '<SELECT NAME="user_id">';
$myrow = mysql_fetch_array($result);
$user_count = 0;
do {
$user_count++;
$name = stripslashes($myrow['uname']);
$message .= "<OPTION VALUE= ".$myrow['user_id'];
$message .= ">".$name."</OPTION>\n";
} while($myrow = mysql_fetch_array($result));
$message .= "</SELECT>";
return $message;
}else{
return "";
}
}
?>
--- NEW FILE: phpBB_14_HonoraryRanksAssignSave.php ---
<?php // $Id: phpBB_14_HonoraryRanksAssignSave.php,v 1.1 2002/01/23 12:01:33 chv Exp $
if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); }
if (!authorised(0, 'phpBB_14::', '::', ACCESS_ADMIN)) { die ("Access Denied"); }
include("modules/$ModName/phpBB_14tables.php");
function phpBB_14_HonoraryRanksAssignSave($user_id, $rank_id, $actiontype)
{
global $pntable, $bbtable,$dbconn;
switch($actiontype) {
case 'Add':
$sql = "UPDATE $bbtable[users]
SET user_rank='$rank_id'
WHERE user_id = '$user_id'";
if(!$r = mysql_query($sql)) {
error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error());
}
break;
case 'Update':
$sql = "UPDATE $bbtable[users]
SET user_rank='$rank_id'
WHERE user_id = '$user_id'";
if(!$r = mysql_query($sql)){
error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error());
}
break;
case 'Delete':
$sql = "UPDATE ".$bbtable['users']."
SET user_rank='0'
WHERE user_id = '$user_id'";
if(!$r = mysql_query($sql)) {
error_die(_PHPBB_ERROR_CONNECT,$sql,mysql_errno(),mysql_error());
}
break;
}
header("Location: admin.php?op=phpBB_14_HonoraryRanksAssign");
}
?>
--- honorary_assign.php DELETED ---
|