معرفة عدد الرسائل الخاصة في قاعدة البيانات
--------------------------------------------------------------
###
افتح ملف ال
admin/index.php
###
وابحث عن:
makenavoption("Referrals","user.php?action=referrers","<br>");
وتحت ه اضف هذا الكود
makenavoption("pm stats","pmstats.php?","<br>");
###
admin الى الادمن index.php و pmstats.php والان نزل الملفين
الصق ما دون في ملف وسمه pmstats.php
--
<?php
//################### INSTALL ###################
// PM Stats Hack 1.0 for vB 2.0 RC1 or higher
// by The_Sisko (cd@kowtun.de) | 20.04.2001
// Just change the to lines with $limit and
// $pmquotacolor and upload pmstats.php to
// your vBulletin /admin/ folder. Make a link to
// pmstats.php and enjoy. That's all!
//################### Config ###################
$limit = 30; // how many users to show per page
$pmquotacolor = "red"; // color for users with more then 90% of PM quota
require('./global.php');
cpheader();
//################### create pages ###################
$offset = preg_replace("/\D/", "", $offset);
$sitesql = "SELECT userid, count(*) as count FROM privatemessage group by userid";
$seiten = $DB_site->query("$sitesql");
$total = mysql_num_rows($seiten);
if(!$offset) {
$offset = 0;
} elseif($offset >= $total) {
$offset = $total - $limit;
}
//---------------------------------------------------------------------
// Link zu vorherigen Seiten
//---------------------------------------------------------------------
if($offset <= 0) {
$prevUrl = "<<";
} elseif($offset < $limit && $offset > 0) {
$prevUrl = "<a href=\"pmstats.php?s=$session[sessionhash]&offset=0\"><<</a>";
} else {
$prev = $offset - $limit;
$prevUrl = "<a href=\"pmstats.php?s=$session[sessionhash]&&offset=$prev\"><<</a>";
}
echo "<p><center><b>".$prevUrl;
//---------------------------------------------------------------------
// einfuegen Seitenlinks
//---------------------------------------------------------------------
$numberOfPages = ceil($total / $limit);
for($i=0; $i<$numberOfPages; $i++)
{
if($i * $limit == $offset)
{
$res = ($i + 1);
print "<font color=\"red\"><b>$res </b></font>";
}
else
{
print "<a href=\"pmstats.php?s=$session[sessionhash]&offset=".($i * $limit)."\">".($i + 1)."</a> ";
}
}
//---------------------------------------------------------------------
// Link zu den naechsten Seiten
//--------------------------------------------------------------------
$next = $offset + $limit;
if($next >= $total) {
$nextUrl = ">>";
} else {
$nextUrl = "<a href=\"pmstats.php?s=$session[sessionhash]&offset=$next\">>></a>";
}
echo $nextUrl."</b></center></p>";
//--------------------------------------------------------------------
//################### pm stats ###################
$pmquota = ($pmquota/10)*9;
$numpms = $DB_site->query("SELECT * FROM privatemessage");
$numpm = mysql_num_rows($numpms);
if($total > 0) {
$pmaverage = round($numpm/$total);
} else {
$pmaverage = 0;
}
$outset = ($offset+$limit);
if($outset <= $total) {
$outset = $outset;
} else {
$outset = $total;
}
echo "<table cellpadding='1' cellspacing='0' border='0' align='center' width='70%' class='tblborder'>
<tr>
<div align=center>
<center>
<table>
<td>
<table cellpadding='4' cellspacing='0' border='0' width='100%'>
<tr class='tblhead'>
<td colspan='3'>
<table width='100%' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td>
<p align=center><b><span class='tblhead'>الرسائل الخاصه ".$pmmax."</span></b></p>
</td>
<td>
<div align='right'>
<p align=center><b><span class='tblhead'><font size='-2'>عدد الرسائل ".$offset." من ".$outset." الى ".$total."</font></span></b></div>
</td>
</tr>
</table>
</td>
</tr>
<tr class=firstalt>
<td>
<div align=center>
<p align=center>عدد الرسائل الموجوده في قاعدة البيانات</div>
</td>
<td>
<div align=center>
<p align=center>عدد الرسائل المقروئه</div>
</td>
<td>
<div align=center>
<p align=center>معدل الرسائل</div>
</td>
</tr>
<tr class=secondalt>
<td>
<p align=center><b>".$numpm."</b></p>
</td>
<td>
<p align='center'><b>".$total."</b></p>
</td>
<td>
<p align='center'><b>~".$pmaverage."</b></p>
</td>
</tr>
</table>
</td>
<tr class=tblhead>
<td>
<p align=center></td>
</tr>
</table></center>
</div>
<p align=center><br>
";
//################### pm counts ###################
$pmusers = $DB_site->query("$sitesql ORDER by count desc limit $offset, $limit");
echo "<table cellpadding='1' cellspacing='0' border='0' align='center' width='70%' class='tblborder'><tr><td>
<table cellpadding='4' cellspacing='0' border='0' width='100%'>
<tr class='tblhead'>
<td width='40%'>
<p><b><span class='tblhead'>اسم العضو</span></b></p>
</td>
<td width='20%'>
<div align='center'><b><span class='tblhead'>عدد الرسائل الاجمالي</span></b></div>
</td>
<td width='20%'>
<p align='center'><b><span class='tblhead'>رسائل جديده</span></b></p>
</td>
<td width='20%'>
<p align='center'><b><span class='tblhead'>رسائل غير مقروئه</span></b></p>
</td>
</tr>";
while ($pmuser = $DB_site->fetch_array($pmusers))
{
$newpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$pmuser[userid] AND dateline>$bbuserinfo[lastvisit] AND folderid=0");
$unreadpm=$DB_site->query_first("SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=$pmuser[userid] AND messageread=0 AND folderid=0");
$user = $DB_site->query_first("SELECT * FROM user WHERE userid=$pmuser[userid]");
if ($counter%2==0) {
echo "<tr class='firstalt'>";
} else {
echo "<tr class='secondalt'>";
}
$counter++;
/*
if (bcmod($a,2) == 0) {
echo " <tr class='firstalt'>";
} else {
echo "<tr class='secondalt'>";
}
$a++;
*/
$unreadpm = $unreadpm[messages];
if ($unreadpm > 0) {
$unreadpm = "<b>".$unreadpm."</b>";
}
$newpm = $newpm[messages];
if ($newpm > 0) {
$newpm = "<b>".$newpm."</b>";
}
$pmuser = $pmuser[count];
if ($pmuser > $pmquota) {
$pmuser = "<font color='".$pmquotacolor."'><b>".$pmuser."</b></font>";
}
echo " <td width='40%'><p>".$user[username]."</p></td>
<td width='20%'><p align='center'>".$pmuser."</p></td>
<td width='20%'><p align='center'>".$newpm."</p></td>
<td width='20%'><p align='center'>".$unreadpm."</p></td>
</tr>";
}
echo " </table></td></tr><tr class='tblhead'><td><p align='right'><b><span class='tblhead'>PM Stats Hack 1.0 by <a href='mailto:cd@kowtun.de'><font color='#D0D0D0'>The_Sisko</font></a></span></b></p></td></tr></table>";
cpfooter();
echo " </table></td></tr><tr class='tblhead'><td><p align='right'><b><span class='tblhead'>تحياتي للجميع <a href=http://awm88.com><font color='#D0D0D0'></font></a></span></b></p></td></tr></table>";
cpfooter();
?>
---
تعريب العزيز بو خليفه
__________________
الحياة مليئة بالحجارة..فلا تتعثر بها بل اجمعها وابن بها سّلماتصعد به نحو النجاح