#2
B]manage_titan.php:
<?
ob_start();
include"header.php";
$no=1;
$sp=0;
$qpage="select *, titan.date as display_date from titan, member
WHERE titan.member_id=member.member_id
order by titan_id";
$rs_page=mysql_query($qpage);
$cnt=mysql_num_rows($rs_page);
$totalpage=ceil($cnt/10);
if(isset($_GET['pageno']))
$no=$_GET['pageno'];
$sp=($no*10)-10;
if(!$by) {
$by = 'titan_id';
}
//echo $sortby;
$sql="SELECT *, titan.date as display_date, titan.status as display_status FROM titan, member
WHERE titan.member_id=member.member_id
order by $by $sort
limit $sp,10 ";
//$sql= "select * from site_user where type!='admin'order by pk_id limit $sp,10";
$result=mysql_query($sql);
?><head>
<script>
function chkDel(getId)
{
if(confirm("Are you sure want to delete this user?"))
{
location.href="delete_titan.php?id="+getId;
}
}
</script>
</head> <table align="center" border="0" cellpadding="0" cellspacing="0" width="850">
<tbody><tr>
<td class="border" bgcolor="#ffffff" valign="top" width="850"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="196" align="left" valign="top"><?
include"left_nav.php";
?></td>
<td valign="top">
<form name="form" action="crm_submit.php" enctype="multipart/form-data" method="post">
<table align="center" bgcolor="#ffffff" border="0" cellpadding="2" cellspacing="2" width="95%">
<tbody>
<tr>
<td valign="top" bgcolor="#666666"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><span class="style3"><strong>Manage Titan Poker </strong></span></td>
<td><div align="right"><a href="add_customer.php" class="menu"></a></div></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top" width="68%"><table width="100%" border="0" class="buttons" align="center" cellspacing="1" bgcolor="#f5f5f5" style="border:#999999 solid 1px;">
<tr align="left" valign="middle">
<?
if($sort=="asc")
{
$newsort = 'desc';
} else {
$newsort ="asc";
}
?>
<td width="11%" height="23" >Sl.No.</td>
<td width="15%" >
<a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan_username">Titan User Name</a>
</td>
<td width="18%" >
<a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan_name">Titan Screenname</a>
</td>
<td width="16%" >
<a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan_email">Titan Email</a>
</td>
<td width="16%" >
<a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan.date">Date</a>
</td>
<td width="11%" >
<a href="manage_titan.php?sort=<? echo $newsort; ?>&by=member_email">Username</a>
</td>
<td width="11%" >
<a href="manage_titan.php?sort=<? echo $newsort; ?>&by=ip">Ip</a>
</td>
<td width="11%" >
<a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan.status">Status</a>
</td>
<td width="11%" >Action</td>
</tr>
<?
$i=0;
while ($rs = mysql_fetch_array($result))
{
$i++;
if($i%2 == 0)
$bgcolor = "#f6f6f6";
else
$bgcolor = "#DBDBDB";
?>
<tr>
<td class="bodytext" bgcolor="<?=$bgcolor?>" height="23">
<?=$i;?>. </td>
<td class="bodytext" bgcolor="<?=$bgcolor?>">
<?=$rs['titan_username'];?> </td>
<td class="bodytext" bgcolor="<?=$bgcolor?>">
<?=$rs['titan_name'];?> </td>
<td width="16%" class="bodytext" bgcolor="<?=$bgcolor?>">
<a href="mailto:<?=$rs[titan_email]?>"> <?=$rs['titan_email'];?></a></td>
<td width="16%" class="bodytext" bgcolor="<?=$bgcolor?>">
<?=$rs['display_date'];?></td>
<td width="11%" bgcolor="<?=$bgcolor?>">
<?
//$member_id=$rs['member_id'];
//$sql_site="select * from member where member_id=$member_id";
//$result_site=mysql_query($sql_site);
//$rs_site=mysql_fetch_array($result_site);
?><a href="view_customer.php?id=<?=$rs['member_id'];?>"><? echo $rs['member_email'];?></a></td>
<td width="16%" class="bodytext" bgcolor="<?=$bgcolor?>">
<?=$rs['ip'];?></td>
<td width="16%" class="bodytext" bgcolor="<?=$bgcolor?>">
<?
if($rs['display_status']==1)
echo "Accepted";
else if($rs['display_status']==2)
echo "Declined";
else
echo"Pending";
?></td>
<td width="11%" class="bodytext" bgcolor="<?=$bgcolor?>"><a class="red_small_links" href="edit_titan.php?id=<?=$rs['titan_id'];?>">Edit</a>
/<a class="red_small_links" href="#" onClick="chkDel('<?=$rs[titan_id]?>');">
Delete </a></td>
</tr>
<?
}
?>
</table></td>
</tr>
<tr>
<td valign="top" align="center">
Pages
<?
if($totalpage > 9) {
if(!isset($_GET['pageno'])) {
$_GET['pageno'] = 1;
}
if($_GET['pageno'] <> 1) {
echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=" . ($_GET['pageno'] - 1) . "' class='bodytext'>Previous</a>";
echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=1' class='bodytext'><<</a>";
}
if($_GET['pageno'] > 4 AND $_GET['pageno'] < $totalpage-4) {
for($i=$_GET['pageno']-4;$i<=$_GET['pageno']+4;$i++)
{
if($i==@$_GET['pageno'])
{
echo $_GET['pageno'];
}
else
{
echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=$i' class='bodytext'>".$i."</a>";
}
}
} else if($_GET['pageno'] <= 4) {
for($i=1;$i<=9;$i++)
{
if($i==@$_GET['pageno'])
{
echo $_GET['pageno'];
}
else
{
echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=$i' class='bodytext'>".$i."</a>";
}
}
} else if($_GET['pageno'] >= $totalpage-4) {
for($i=$totalpage-8;$i<=$totalpage;$i++)
{
if($i==@$_GET['pageno'])
{
echo $_GET['pageno'];
}
else
{
echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=$i' class='bodytext'>".$i."</a>";
}
}
}
if($_GET['pageno'] <> $totalpage) {
echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=" . ($totalpage) . "' class='bodytext'>>></a>";
echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=" . ($_GET['pageno'] + 1) . "' class='bodytext'>Next</a>";
}
} else {
///-----------------------------------
všeč(0)
ni všeč(0)
spam(0)
#
Lep pozdrav.
Pred kratkim so mi eni mozje sprogramiral stran in tud admin ki je v php-ju. Imam naslednji problem:
Na strani imam admin, kjer so clani strani. Na managetitan.php je liste vseh clanov(10 na stran), kjer je tudi opcija edit(edittitan.php), kjer spreminjam njihove statuse(pending,approved,declined). Problem je naslednji:
Recimo da odprem stran 5 in kliknem na clana XXX -edit(edit_titan.php?id=xxx) , kjer nastvim njegov status in kliknem "Submit". Ko je status spremenjen, me vedno po tem vrne na stran 1. Rad bi pa naredil tako da ko spremenim temu uporabniku status, da me vrze nazaj na istro stran kjer je leta bil(v tem primeru stran 5). Ce kdo ve kako se to naredi, bi bil zelo hvalezen ce lahko opise.
všeč(0)
ni všeč(0)
spam(0)
#2
Hvala, to sem uspel popravit.
Zanima me še, kako bi popravil isto napako pri "pozabil geslo", kjer v emailu kjer dobiš posredovane prijavne podatke manjkajo tudi tam šumniki.
lp
všeč(0)
ni všeč(0)
spam(0)
#
Lp
Na spletni strani www.pokercash4free.com/slo se ne prikazujejo šumniki na index.php oziroma se zamenjajoz nekimi čudnimi črkami. Isto je na left_nav.php ampak tam je trenutno brez šumnikov.
Kak nasvet?
všeč(0)
ni všeč(0)
spam(0)