مرجع پارسی MyBB

نسخه‌ی کامل: درخواست چک کردن کد کوئری
شما درحال مشاهده‌ی نسخه‌ی متنی این صفحه می‌باشید. مشاهده‌ی نسخه‌ی کامل با قالب‌بندی مناسب.
سلام
والا من هر جا گشتم درست نگفته بودن کوئری چیه چطور میگیرن. رفتم از اینور اونور این کد ها رو چسبوندم

یه برترین ارسال کننده ها با مدار دارم درست میکنم که کدهاش ایناست:
کد:
<?php

// by hamid
echo '
<html xmlns="http://www.w3.org/1999/xhtml" dir="rtl" lang="fa-IR">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
';

## CUSTOMIZE SETTINGS FOR YOUR SITE ##
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "sdsd"; // Change this to the name of your database.
$db_user = "sdsd"; // Change this to your database username.
$db_pw = "sdsdsd"; // Change this to your database password.
$db_pre = "mybb_"; // Tables prefix
$forum_url = "http://www.cniran.com/Forums/"; // Change this to reflect to your forum's URL. like http://www.cniran.com/Forums  or http://www.cniran.com  no / in end!
$limit = "20"; // Number of posts displayed.
$txtlimit = "100"; // This is the character limit.
$ShowMedal = "1"; /// Baraye Neshoon Dadane Medal Ha Rooye 1 va Baraye Neshoon Nadadan Rooye 0

#######################################
// Connecting to your database
mysql_select_db($db_name);
mysql_connect($db_host, $db_user, $db_pw );

mysql_query("SET NAMES utf8");

$a = 1;
    $topp=sql_query("SELECT uid, username, postnum, avatar FROM ".$db_pre."users ORDER BY postnum DESC LIMIT $limit");
    while($topposters= mysql_fetch_array($topp)) {
$uidi = $topposters['uid'];
$usernam = $topposters['username'];
$usernamber = $topposters['postnum'];
$avatars = $topposters['avatar'];
    $i = $i + 1;
    
if ($ShowMedal== "1") {    
    if ($i== 1) {
$images_top = "<img alt src=\"$forum_url/images/top_gold.gif\" border =\"0\">";
} else
if ($i== 2 | $i== 3) {
$images_top = "<img alt src=\"$forum_url/images/top_silver.gif\" border =\"0\">";
} else
if ($i== 4 | $i== 5 | $i== 6) {
$images_top = "<img alt src=\"$forum_url/images/rank3.gif\" border =\"0\">";
}
else
if ($i== 7 | $i== 8) {
$images_top = "<img alt src=\"$forum_url/images/rank4.gif\" border =\"0\">";
}
else
if ($i== 9 | $i== 10) {
$images_top = "<img alt src=\"$forum_url/images/rank5.gif\" border =\"0\">";
}
else {
$images_top = "";
}
}

///if ($user_level=="2" | $user_level== "3") {
$content="$content";

////} else {

$content = "$content<div align=\"center\"><table cellpadding=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" cellspacing=\"1\" border=\"0\"><tr class=\"even\" vAlign=\"center\"><td align=\"center\">";

if ($avatars=="") {

$content = "$content&nbsp;&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uidi\"><img alt src=\"$forum_url/images/default_avatar.gif\" border =\"0\" width=\"54\"></a></td><td align=\"middle\">&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uidi\"><b>$usernam</b></a>&nbsp;<br>&nbsp;<a href=\"http://www.cniran.com/Forums/search.php?action=finduser&uid=$uidi\">ارسالها:$usernamber</a></td><td align=\"middle\">$images_top</td></tr></table></div><hr>";

}
else
if (eregi("http://", $avatars)) {
$content = "$content&nbsp;&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uidi\"><img alt src=\"$avatars\" border =\"0\" width=\"54\"></a></td><td align=\"middle\">&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uidi\"><b>$usernam</b></a>&nbsp;<br>&nbsp;<a href=\"http://www.cniran.com/Forums/search.php?action=finduser&uid=$uidi\">ارسالها:$usernamber</a>/td><td align=\"middle\">$images_top</td></tr></table></div><hr>";
}
else
$content = "$content&nbsp;&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uidi\"><img alt src=\"$forum_url/uploads/avatars/$avatars\" border =\"0\" width=\"54\"></a></td><td align=\"middle\">&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uidi\"><b>$usernam</b></a>&nbsp;<br>&nbsp;<a href=\"http://www.cniran.com/Forums/search.php?action=finduser&uid=$uidi\">ارسالها:$usernamber</a></td><td align=\"middle\">$images_top</td></tr></table></div><hr>";
}
///}
?>

تست که میکنم صفحه وردپرس سفید میاد میشه یه نگاهی بندازید ببینید درست نوته شده یا نه؟ البته اینم هست که کد قبلیه اون بالایی بود
کد:
<?php
// by hamid
echo '
<html xmlns="http://www.w3.org/1999/xhtml" dir="rtl" lang="fa-IR">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
';

## CUSTOMIZE SETTINGS FOR YOUR SITE ##
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "name data base ro inja"; // Change this to the name of your database.
$db_user = "usere data base ro inja"; // Change this to your database username.
$db_pw = "pass inja"; // Change this to your database password.
$db_pre = "mybb_"; // Tables prefix
$forum_url = "http://www.cniran.com/Forums/"; // Change this to reflect to your forum's URL. like http://www.cniran.com/Forums  or http://www.cniran.com  no / in end!
$limit = "20"; // Number of posts displayed.
$txtlimit = "100"; // This is the character limit.
$ShowMedal = "1"; /// Baraye Neshoon Dadane Medal Ha Rooye 1 va Baraye Neshoon Nadadan Rooye 0

#######################################
// Connecting to your database
mysql_select_db($db_name);
mysql_connect($db_host, $db_user, $db_pw );

mysql_query("SET NAMES utf8");

$a = 1;
    $topp=sql_query("SELECT uid, username, postnum, avatar FROM ".$db_pre."users ORDER BY postnum DESC LIMIT $limit");
    while(list($uid, $username, $postnum, $avatar) = sql_fetch_row($topp)) {
    
    $i = $i + 1;
    
if ($ShowMedal== "1") {    
    if ($i== 1) {
$images_top = "<img alt src=\"$forum_url/images/top_gold.gif\" border =\"0\">";
} else
if ($i== 2 | $i== 3) {
$images_top = "<img alt src=\"$forum_url/images/top_silver.gif\" border =\"0\">";
} else
if ($i== 4 | $i== 5 | $i== 6) {
$images_top = "<img alt src=\"$forum_url/images/rank3.gif\" border =\"0\">";
}
else
if ($i== 7 | $i== 8) {
$images_top = "<img alt src=\"$forum_url/images/rank4.gif\" border =\"0\">";
}
else
if ($i== 9 | $i== 10) {
$images_top = "<img alt src=\"$forum_url/images/rank5.gif\" border =\"0\">";
}
else {
$images_top = "";
}
}

///if ($user_level=="2" | $user_level== "3") {
$content="$content";

////} else {

$content = "$content<div align=\"center\"><table cellpadding=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" cellspacing=\"1\" border=\"0\"><tr class=\"even\" vAlign=\"center\"><td align=\"center\">";

if ($avatar=="") {

$content = "$content&nbsp;&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uid\"><img alt src=\"$forum_url/images/default_avatar.gif\" border =\"0\" width=\"54\"></a></td><td align=\"middle\">&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uid\"><b>$username</b></a>&nbsp;<br>&nbsp;<a href=\"http://www.cniran.com/Forums/search.php?action=finduser&uid=$uid\">ارسالها:$postnum</a></td><td align=\"middle\">$images_top</td></tr></table></div><hr>";

}
else
if (eregi("http://", $avatar)) {
$content = "$content&nbsp;&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uid\"><img alt src=\"$avatar\" border =\"0\" width=\"54\"></a></td><td align=\"middle\">&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uid\"><b>$username</b></a>&nbsp;<br>&nbsp;<a href=\"http://www.cniran.com/Forums/search.php?action=finduser&uid=$uid\">ارسالها:$postnum</a>/td><td align=\"middle\">$images_top</td></tr></table></div><hr>";
}
else
$content = "$content&nbsp;&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uid\"><img alt src=\"$forum_url/uploads/avatars/$avatar\" border =\"0\" width=\"54\"></a></td><td align=\"middle\">&nbsp;<a href=\"$forum_url/member.php?action=profile&uid=$uid\"><b>$username</b></a>&nbsp;<br>&nbsp;<a href=\"http://www.cniran.com/Forums/search.php?action=finduser&uid=$uid\">ارسالها:$postnum</a></td><td align=\"middle\">$images_top</td></tr></table></div><hr>";
}
///}
?>

دوستان اگر مشکلی داره لطفا" بگید تا اصلاح کنم. خیلی خوشکل میشه برای وردپرس ساخته بشه . اگر این ردیف بشه کم کم بقیه امکانات هم مچ میکنم با دوتا سیستم.

پ.ن: این کد ها هیچ ربطی به وردپرس نداره لطفا" نگید برو توی انجمن وردپرس!!


دوستان طرحی نظری؟اشکالی؟درست تنظیم شده اصلا" ؟