مشکل فارسی در فایل Scroll.php

sanecity

Member
مشکل فارسی در فایل Scroll.php برای نشان دادن آخرین ارسالهای انجمن

با سلام خدمت اساتید
لطفا به این آدرس یه سر بزنید
http://www.sanecity.net/forum/scroll.php
چرا فونت فارسی رو علامت سئوال نشون میده؟

اینم کدش

PHP:
<?php

$lang['ENCODING'] = 'UTF-8';
$lang['DIRECTION'] = "rtl";
$lang['LEFT'] = "right";
$lang['RIGHT'] = "left";
//
// Basic Configuration
// How Many Topics you want to display?
$topicnumber = 20;
// Scrolling towards up or down?
$scroll = "up";
// Change this to your phpBB path


$urlPath = "http://www.sanecity.net/forum";



// Database Configuration (Where your phpBB config.php file is located
include 'config.php';

// Connecting & Selecting Databases
$table_topics = $table_prefix. "topics";
$table_forums = $table_prefix. "forums";
$table_posts = $table_prefix. "posts";
$table_users = $table_prefix. "users";
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
mysql_select_db("$dbname") or die("Could not select database");

// Perform Sql Query
$query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
WHERE t.topic_id = p.topic_id AND
f.forum_id = t.forum_id AND
t.topic_status <> 2 AND
t.forum_id <> 30 AND
t.forum_id <> 41 AND
p.post_id = t.topic_last_post_id AND
p.poster_id = u.user_id
ORDER BY p.post_id DESC LIMIT $topicnumber";
$result = mysql_query($query) or die("Query failed");

// Outcome of the HTML
// Be carefull when you edit these!


print "<marquee dir=\"rtl\" align=\"center\" id=\"recent_topics\" behavior=\"scroll\" direction=\"$scroll\" height=\"150\" width=\"100%\"  scrolldelay=\"100\" scrollamount=\"2\" onMouseOver=\"document.all.recent_topics.stop()\" onMouseOut=\"document.all.recent_topics.start()\">";
print "<div align=\"center\">";
print "<table cellpadding='3' cellSpacing='2' >";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo  "<tr valign='top'><td><font face=\"Tahoma\" size=\"1\"><font color=\"#FFCC00\"><b> <a href=\"$urlPath/viewtopic.php?p=$row[topic_last_post_id]#$row[topic_last_post_id]\"> <span style=\"text-decoration: none\">" .
$row["topic_title"] .
"</span></a></td></font></b><td><font face=\"Tahoma\" size=\"1\"><font color=\"#C0C0C0\">by : <a href=\"$urlPath/profile.php?mode=viewprofile&u=$row[user_id]\">" .
$row["username"] .
"</td><td><font face=\"Tahoma\" size=\"1\"><font color=\"#C0C0C0\">" .

"</td></tr></font>";
}
print "</table></div></marquee>";


// Free Result
mysql_free_result($result);

// Close the Connection
mysql_close($link);
?>
 

sanecity

Member
در ضمن من از PHPBB 3 استفاده میکنم

اگه میشه بگید کدی که باید تو فایل INDEX وارد کنم تا Scroll رو نشون بده چیه؟ و کجا قرار بدم؟
 
بسم الله الرحمن الرحيم
با سلام
دوست عزيز به جاي آن كدي كه در پست اول است ، اين كد زير را قرار بدهيد.

کد:
<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>

<body>
<?php

$lang['ENCODING'] = 'UTF-8';
$lang['DIRECTION'] = "rtl";
$lang['LEFT'] = "right";
$lang['RIGHT'] = "left";
//
// Basic Configuration
// How Many Topics you want to display?
$topicnumber = 20;
// Scrolling towards up or down?
$scroll = "up";
// Change this to your phpBB path


$urlPath = "http://www.sanecity.net/forum";



// Database Configuration (Where your phpBB config.php file is located
include 'config.php';

// Connecting & Selecting Databases
$table_topics = $table_prefix. "topics";
$table_forums = $table_prefix. "forums";
$table_posts = $table_prefix. "posts";
$table_users = $table_prefix. "users";
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
mysql_select_db("$dbname") or die("Could not select database");

// Perform Sql Query
$query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
WHERE t.topic_id = p.topic_id AND
f.forum_id = t.forum_id AND
t.topic_status <> 2 AND
t.forum_id <> 30 AND
t.forum_id <> 41 AND
p.post_id = t.topic_last_post_id AND
p.poster_id = u.user_id
ORDER BY p.post_id DESC LIMIT $topicnumber";
$result = mysql_query($query) or die("Query failed");

// Outcome of the HTML
// Be carefull when you edit these!


print "<marquee dir=\"rtl\" align=\"center\" id=\"recent_topics\" behavior=\"scroll\" direction=\"$scroll\" height=\"150\" width=\"100%\"  scrolldelay=\"100\" scrollamount=\"2\" onMouseOver=\"document.all.recent_topics.stop()\" onMouseOut=\"document.all.recent_topics.start()\">";
print "<div align=\"center\">";
print "<table cellpadding='3' cellSpacing='2' >";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo  "<tr valign='top'><td><font face=\"Tahoma\" size=\"1\"><font color=\"#FFCC00\"><b> <a href=\"$urlPath/viewtopic.php?p=$row[topic_last_post_id]#$row[topic_last_post_id]\"> <span style=\"text-decoration: none\">" .
$row["topic_title"] .
"</span></a></td></font></b><td><font face=\"Tahoma\" size=\"1\"><font color=\"#C0C0C0\">by : <a href=\"$urlPath/profile.php?mode=viewprofile&u=$row[user_id]\">" .
$row["username"] .
"</td><td><font face=\"Tahoma\" size=\"1\"><font color=\"#C0C0C0\">" .

"</td></tr></font>";
}
print "</table></div></marquee>";


// Free Result
mysql_free_result($result);

// Close the Connection
mysql_close($link);
?> 
</body>

</html>

با تشكر
 

sanecity

Member
ممنونم دوست عزیز
ولی بازم کار نکرد
همشون ؟؟؟؟؟؟؟؟؟؟؟؟ دیده میشه
----------------------------------
حالا چه کدی رو باید تو index.php بزنم تا اینو نشون بده
البته کد رو دارم نمیدونم کجاش بزارم
فکر کنم تو PHPBB 3 کمی متفاوت است

با تشکر
 
آخرین ویرایش:
بسم الله الرحمن الرحيم
با سلام
دوست عزيز آنطور كه من مي دانم بايد در فايل زير بگذاريد overall_header.html
و در آدرس styles\prosilver\template
كه به جاي prosilver قالب فعلي شما است.
با تشكر
 

sanecity

Member
با سلام
دوست عزیز درستش اینه
HTML:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>آخرین ارسالهای انجمن</title>
</head>

<body dir="rtl">
<?php 

$lang['ENCODING'] = 'UTF-8'; 
$lang['DIRECTION'] = "rtl"; 
$lang['LEFT'] = "right"; 
$lang['RIGHT'] = "left"; 
// 
// Basic Configuration 
// How Many Topics you want to display? 
$topicnumber = 15; 
// Scrolling towards up or down? 
$scroll = "up"; 
// Change this to your phpBB path 


$urlPath = "http://www.sanecity.net/forum"; 

// Database Configuration (Where your phpBB config.php file is located 
include 'config.php'; 

// Connecting & Selecting Databases 
$table_topics = $table_prefix. "topics"; 
$table_forums = $table_prefix. "forums"; 
$table_posts = $table_prefix. "posts"; 
$table_users = $table_prefix. "users"; 
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect"); 
mysql_select_db("$dbname") or die("Could not select database"); 
mysql_query("SET NAMES 'utf8'", $link);
mysql_query("SET character_set_connection = 'utf8'", $link);

// Perform Sql Query 
$query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username 
FROM $table_topics t, $table_forums f, $table_posts p, $table_users u 
WHERE t.topic_id = p.topic_id AND 
f.forum_id = t.forum_id AND 
t.topic_status <> 2 AND 
t.forum_id <> 30 AND 
t.forum_id <> 41 AND 
p.post_id = t.topic_last_post_id AND 
p.poster_id = u.user_id 
ORDER BY p.post_id DESC LIMIT $topicnumber"; 
$result = mysql_query($query) or die("Query failed"); 

// Outcome of the HTML 
// Be carefull when you edit these! 


print "<marquee dir=\"rtl\" align=\"center\" id=\"recent_topics\" behavior=\"scroll\" direction=\"$scroll\" height=\"150\" width=\"100%\"  scrolldelay=\"100\" scrollamount=\"2\" onMouseOver=\"document.all.recent_topics.stop()\" onMouseOut=\"document.all.recent_topics.start()\">"; 
print "<div align=\"center\">"; 
print "<table cellpadding='3' cellSpacing='2' >"; 
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { 
echo  "<tr valign='top'><td><font face=\"Tahoma\" size=\"1\"><font color=\"#FFCC00\"><b> <a href=\"$urlPath/viewtopic.php?p=$row[topic_last_post_id]#$row[topic_last_post_id]\"> <span style=\"text-decoration: none\">" . 
$row["topic_title"] . 
"</span></a></td></font></b><td><font face=\"Tahoma\" size=\"1\"><font color=\"#C0C0C0\">by : <a href=\"$urlPath/profile.php?mode=viewprofile&u=$row[user_id]\">" . 
$row["username"] . 
"</td><td><font face=\"Tahoma\" size=\"1\"><font color=\"#C0C0C0\">" . 

"</td></tr></font>"; 
} 
print "</table></div></marquee>"; 


// Free Result 
mysql_free_result($result); 

// Close the Connection 
mysql_close($link); 
?>
</body>
</html>
 

m_maj2004

Member
مشکل فارسی

دوستان این سایت ما هم همین مشکل رو داره
کد بالا رو ریختم اما دائم به همریخته نشون می ده.
http://download.iranupload.net
البته ورژن من 3 نیست و قدیمی تر هست.
آخرین نسخه فارسی شده رو که استاندارد هست ریختم
 

جدیدترین ارسال ها

بالا