Помощ да ми направите 1 код да се страницира.

hustle102

Registered
може ли някой да ми направи този чат да се страницира да става на страници..

Благодаря ви предварително

PHP:
<?php 


$db_host = 'localhost'; // Host
$db_user = 'user'; // User
$db_password = 'password'; // Pass
$db_name = 'database'; // DB
mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());


if ($user->data['user_id'] == ANONYMOUS)
{
echo "";
}
else
{
$chat = addslashes(htmlspecialchars($_POST['chat'])); 
$avtor = $user->data['username']; 
$date = date("d/m/Y"); 
$ip = $_SERVER['REMOTE_ADDR']; 
if($chat == null || $avtor == null) 
{ 




}else{ 
if( preg_match("/(\burl\b|http|\bwww\.|\.(com|fr|us|net|bg||biz|info|org|ru|su)\b)/i", $_POST['chat']) ) 
{ 
echo 'Линковете не са позволени'; 
}else{ 
$sql = mysql_query("INSERT INTO shoutbox (chat,avtor,date,ip) VALUES ('$chat','$avtor','$date','$ip')") or die (mysql_error()); 
echo 'Добавено'; 
} 

} 
}

?> 



 
<script type="text/JavaScript">
function textCounter(field,counter,maxlimit,linecounter) {
// ??????? ?? ??????
var fieldWidth = parseInt(field.offsetWidth);
var charcnt = field.value.length;


if (charcnt > maxlimit) {
field.value = field.value.substring(0, maxlimit);
}

else {
//cs
var percentage = parseInt(+ 0  + (( maxlimit - charcnt) * 100)/maxlimit) ;
document.getElementById(counter).style.width = parseInt((fieldWidth*percentage)/100)+"px";
document.getElementById(counter).innerHTML="<b>"+percentage+"</b>"

setcolor(document.getElementById(counter),percentage,"0");
}
}

function setcolor(obj,percentage,prop){
obj.style[prop] = "rgb(100,"+(100-percentage)+","+(100-percentage)+")";
}

</script>




<form method="post" action="">

 <span id="kbs" name="kbs" style="position:relative;visibility:hidden"><input type="button" id="button"></span> <br />  
    <span style="position:relative;visibility:hidden" id="kbsLabel" name="kbsLabel"></span>

<table>
<tr>
<td>


</table>

<div style="margin-top:5px;">
<h4>
<?php if($user->data['is_registered']) { ?>
<form action='' method='post'>

<div style="margin-top:5px; display:none; border:none;">

</div>


<?php } else { ?>

<center><font size="2">Моля логнете се или се <a href='forum/ucp.php?mode=register'>регистрирайте</a>, за да пишете в чата</size></center>
<?php } ?>
</h4>

<script type="text/javascript">
 function addemo2(newemo){
 var emoid =  document.getElementById('styled').value;
 emoid = document.getElementById('styled').value+= newemo;
 document.getElementById('styled').focus();
 }
</script>

<script type="text/javascript">
function showContent(vThis)
{

// alert(vSibling.className + " " + vDef_Key);
vParent = vThis.parentNode;
vSibling = vParent.nextSibling;
while (vSibling.nodeType==3) { 
vSibling = vSibling.nextSibling;
};
if(vSibling.style.display == "none")
{
vThis.value = "Skrii emociite";
vSibling.style.display = "block";
} else {
vSibling.style.display = "none";
vThis.value = "Vij emociite";
}
return;
}
</script>


<?php 

$sql = mysql_query("SELECT * FROM shoutbox ORDER BY id DESC LIMIT 5000") or die (mysql_error()); 
while($row = mysql_fetch_assoc($sql)){ 
$text = generate_text_for_display($row['chat'], $uid, $bitfield, $options);

$chat = htmlspecialchars($row['chat']);

$chat = str_replace(':)','<img src="images/1.gif">',$chat); // Smile
$chat = str_replace(':D','<img src="images/2.gif">',$chat); // Smile
$chat = str_replace(':good:','<img src="images/3.gif">',$chat); // Smile
$chat = str_replace(':cry:','<img src="images/4.gif">',$chat); // Smile
$chat = str_replace(':music:','<img src="images/5.gif">',$chat); // Smile
$chat = str_replace(':king:','<img src="images/6.gif">',$chat); // Smile
$chat = str_replace(':cool:','<img src="images/7.gif">',$chat); // Smile
$chat = str_replace(':rofl:','<img src="images/8.gif">',$chat); // Smile
$chat = str_replace(':dance:','<img src="images/9.gif">',$chat); // Smile
$chat = str_replace(':ysure:','<img src="images/10.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile

$chat = str_replace('(ai)','<img src="images/smiles/ai.gif" border="0">',$chat); // Smile

$chat = str_replace('(af)','<img src="images/smiles/af.gif" border="0">',$chat); // Smile

$chat = str_replace('(curssing)','<img src="images/smiles/curssing.gif" border="0">',$chat); // Smile

$chat = str_replace('(fuck)','
<img src="images/smiles/fuck.gif" border="0">',$chat); // Smile

$chat = str_replace(' (exclaim)','
<img src="images/smiles/exclaim.gif" border="0">',$chat); // Smile

$chat = str_replace(' (lol)','
<img src="images/smiles/lol.gif" border="0">',$chat); // Smile

$chat = str_replace(' (ra)','
<img src="images/smiles/ra.gif" border="0">',$chat); // Smile

$chat = str_replace(' (razz)','
<img src="images/smiles/razz.gif" border="0">',$chat); // Smile

$chat = str_replace(' (rolleyes) ','
<img src="images/smiles/rolleyes.gif" border="0">',$chat); // Smile

$chat = str_replace(' (hand)','
<img src="images/smiles/hand.gif" border="0">',$chat); // Smile

$chat = str_replace(' (sarcastic_hand)','
<img src="images/smiles/sarcastic_hand.gif" border="0">',$chat); // Smile

$chat = str_replace(' (smile)','
<img src="images/smiles/smile.gif" border="0">',$chat); // Smile

$chat = str_replace(' (thumbsdown)','
<img src="images/smiles/thumbsdown.gif" border="0">',$chat); // Smile

$chat = str_replace(' (thumbsup)','
<img src="images/smiles/thumbsup.gif" border="0">',$chat); // Smile

$chat = str_replace(' (sbogom)','
<img src="images/smiles/sbogom.gif" border="0">',$chat); // Smile

$chat = str_replace(' (punish)','
<img src="images/smiles/punish.gif" border="0">',$chat); // Smile

$chat = str_replace(' (notworthy)','
<img src="images/smiles/notworthy.gif" border="0">',$chat); // Smile

$chat = str_replace(' (Nono)','
<img src="images/smiles/nono.gif" border="0">',$chat); // Smile

$chat = str_replace(' (inlove)','

<img src="images/smiles/inlove.gif" border="0">',$chat); // Smile

$chat = str_replace(' (wink)','
<img src="images/smiles/wink.gif" border="0">',$chat); // Smile

$chat = str_replace(' (coffee)','
<img src="images/smiles/coffee.gif" border="0">',$chat); // Smile

$chat = str_replace(' (flowers)','
<img src="images/smiles/flowers.gif" border="0">',$chat); // Smile

$chat = str_replace(' (Piqnici)','
<img src="images/smiles/Piqnici.gif" border="0">',$chat); // Smile








echo " 
<table><center><tr><td style=' background:; height:40px; width:620px; border:1px solid #b0b0b0; padding:1px;'><img src='images/chatbox.gif' align='left' /><font size=1><font color=#000><b> $row[avtor] 
 </b>
</ br></ br> </font><br /><font-color='#585858'><p style=' font-size: 10px;'>$row[date]</p></font><p style=' font-size:13px;'><font color=#383838>$chat</font></font></td></tr></center></table>

"; 
} 
?>
 
hustle102 каза:
PHP:
<?php 


$db_host = 'localhost'; // Host
$db_user = 'user'; // User
$db_password = 'password'; // Pass
$db_name = 'database'; // DB
mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());


if ($user->data['user_id'] == ANONYMOUS)
{
echo "";
}
else
{
$chat = addslashes(htmlspecialchars($_POST['chat'])); 
$avtor = $user->data['username']; 
$date = date("d/m/Y"); 
$ip = $_SERVER['REMOTE_ADDR']; 
if($chat == null || $avtor == null) 
{ 




}else{ 
if( preg_match("/(\burl\b|http|\bwww\.|\.(com|fr|us|net|bg||biz|info|org|ru|su)\b)/i", $_POST['chat']) ) 
{ 
echo 'Линковете не са позволени'; 
}else{ 
$sql = mysql_query("INSERT INTO shoutbox (chat,avtor,date,ip) VALUES ('$chat','$avtor','$date','$ip')") or die (mysql_error()); 
echo 'Добавено'; 
} 

} 
}

?> 



 
<script type="text/JavaScript">
function textCounter(field,counter,maxlimit,linecounter) {
// ??????? ?? ??????
var fieldWidth = parseInt(field.offsetWidth);
var charcnt = field.value.length;


if (charcnt > maxlimit) {
field.value = field.value.substring(0, maxlimit);
}

else {
//cs
var percentage = parseInt(+ 0  + (( maxlimit - charcnt) * 100)/maxlimit) ;
document.getElementById(counter).style.width = parseInt((fieldWidth*percentage)/100)+"px";
document.getElementById(counter).innerHTML="<b>"+percentage+"</b>"

setcolor(document.getElementById(counter),percentage,"0");
}
}

function setcolor(obj,percentage,prop){
obj.style[prop] = "rgb(100,"+(100-percentage)+","+(100-percentage)+")";
}

</script>




<form method="post" action="">

 <span id="kbs" name="kbs" style="position:relative;visibility:hidden"><input type="button" id="button"></span> <br />  
    <span style="position:relative;visibility:hidden" id="kbsLabel" name="kbsLabel"></span>

<table>
<tr>
<td>


</table>

<div style="margin-top:5px;">
<h4>
<?php if($user->data['is_registered']) { ?>
<form action='' method='post'>

<div style="margin-top:5px; display:none; border:none;">

</div>


<?php } else { ?>

<center><font size="2">Моля логнете се или се <a href='forum/ucp.php?mode=register'>регистрирайте</a>, за да пишете в чата</size></center>
<?php } ?>
</h4>

<script type="text/javascript">
 function addemo2(newemo){
 var emoid =  document.getElementById('styled').value;
 emoid = document.getElementById('styled').value+= newemo;
 document.getElementById('styled').focus();
 }
</script>

<script type="text/javascript">
function showContent(vThis)
{

// alert(vSibling.className + " " + vDef_Key);
vParent = vThis.parentNode;
vSibling = vParent.nextSibling;
while (vSibling.nodeType==3) { 
vSibling = vSibling.nextSibling;
};
if(vSibling.style.display == "none")
{
vThis.value = "Skrii emociite";
vSibling.style.display = "block";
} else {
vSibling.style.display = "none";
vThis.value = "Vij emociite";
}
return;
}
</script>


<?php 
$page = $_GET['page'];
if ($page == 0 || $page == NULL || $page < 0)
{
    $page = 1;
}
$pp = 5;
$start = ($page*$pp) - $pp;
$query = mysql_query("SELECT * FROM shoutbox") or die (mysql_error());
$broi = mysql_num_rows($query);
$total = ceil($broi/$pp);
$result= mysql_query("SELECT * FROM shoutbox" .
" ORDER BY id DESC LIMIT $start,$pp");
while($row = mysql_fetch_assoc($result)){ 
$text = generate_text_for_display($row['chat'], $uid, $bitfield, $options);

$chat = htmlspecialchars($row['chat']);

$chat = str_replace(':)','<img src="images/1.gif">',$chat); // Smile
$chat = str_replace(':D','<img src="images/2.gif">',$chat); // Smile
$chat = str_replace(':good:','<img src="images/3.gif">',$chat); // Smile
$chat = str_replace(':cry:','<img src="images/4.gif">',$chat); // Smile
$chat = str_replace(':music:','<img src="images/5.gif">',$chat); // Smile
$chat = str_replace(':king:','<img src="images/6.gif">',$chat); // Smile
$chat = str_replace(':cool:','<img src="images/7.gif">',$chat); // Smile
$chat = str_replace(':rofl:','<img src="images/8.gif">',$chat); // Smile
$chat = str_replace(':dance:','<img src="images/9.gif">',$chat); // Smile
$chat = str_replace(':ysure:','<img src="images/10.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile
$chat = str_replace(':bad:','<img src="images/11.gif">',$chat); // Smile

$chat = str_replace('(ai)','<img src="images/smiles/ai.gif" border="0">',$chat); // Smile

$chat = str_replace('(af)','<img src="images/smiles/af.gif" border="0">',$chat); // Smile

$chat = str_replace('(curssing)','<img src="images/smiles/curssing.gif" border="0">',$chat); // Smile

$chat = str_replace('(fuck)','
<img src="images/smiles/fuck.gif" border="0">',$chat); // Smile

$chat = str_replace(' (exclaim)','
<img src="images/smiles/exclaim.gif" border="0">',$chat); // Smile

$chat = str_replace(' (lol)','
<img src="images/smiles/lol.gif" border="0">',$chat); // Smile

$chat = str_replace(' (ra)','
<img src="images/smiles/ra.gif" border="0">',$chat); // Smile

$chat = str_replace(' (razz)','
<img src="images/smiles/razz.gif" border="0">',$chat); // Smile

$chat = str_replace(' (rolleyes) ','
<img src="images/smiles/rolleyes.gif" border="0">',$chat); // Smile

$chat = str_replace(' (hand)','
<img src="images/smiles/hand.gif" border="0">',$chat); // Smile

$chat = str_replace(' (sarcastic_hand)','
<img src="images/smiles/sarcastic_hand.gif" border="0">',$chat); // Smile

$chat = str_replace(' (smile)','
<img src="images/smiles/smile.gif" border="0">',$chat); // Smile

$chat = str_replace(' (thumbsdown)','
<img src="images/smiles/thumbsdown.gif" border="0">',$chat); // Smile

$chat = str_replace(' (thumbsup)','
<img src="images/smiles/thumbsup.gif" border="0">',$chat); // Smile

$chat = str_replace(' (sbogom)','
<img src="images/smiles/sbogom.gif" border="0">',$chat); // Smile

$chat = str_replace(' (punish)','
<img src="images/smiles/punish.gif" border="0">',$chat); // Smile

$chat = str_replace(' (notworthy)','
<img src="images/smiles/notworthy.gif" border="0">',$chat); // Smile

$chat = str_replace(' (Nono)','
<img src="images/smiles/nono.gif" border="0">',$chat); // Smile

$chat = str_replace(' (inlove)','

<img src="images/smiles/inlove.gif" border="0">',$chat); // Smile

$chat = str_replace(' (wink)','
<img src="images/smiles/wink.gif" border="0">',$chat); // Smile

$chat = str_replace(' (coffee)','
<img src="images/smiles/coffee.gif" border="0">',$chat); // Smile

$chat = str_replace(' (flowers)','
<img src="images/smiles/flowers.gif" border="0">',$chat); // Smile

$chat = str_replace(' (Piqnici)','
<img src="images/smiles/Piqnici.gif" border="0">',$chat); // Smile



echo " 
<table><center><tr><td style=' background:; height:40px; width:620px; border:1px solid #b0b0b0; padding:1px;'><img src='images/chatbox.gif' align='left' /><font size=1><font color=#000><b> $row[avtor] 
 </b>
</ br></ br> </font><br /><font-color='#585858'><p style=' font-size: 10px;'>$row[date]</p></font><p style=' font-size:13px;'><font color=#383838>$chat</font></font></td></tr></center></table>

"; 
} 
echo"<table><tr>";
if ($page > 1) { 
$prev = ($page - 1); 
echo "<td class='mbord'><a href="chat.php&page=$prev">Предишна</a></td> "; 
} 
else echo ""; 

if (!$page or ($page > $total)) { 
$page="1"; 
} 

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<td class='mbord'>$i</td>"; 
} 
else { 
echo "<td class='mbord'><a href="chat.php&page=$i">".$i."</a></td> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<td class='mbord'>$i</td> "; 
} 
else { 
echo "<td class='mbord'><a href="chat.php&page=$i" >".$i."</a></td> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo " <td class='mbord'> <a href="chat.php&page=4">4</a></td> "; 
echo " <td class='mbord'>...</td> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<td class='mbord'><a href="chat.php&page=$i">".$i."</a></td>"; 
} 
if ($page == 5) $parva.= " <td class='mbord'><a href="chat.php&page=$i">4</a></td>"; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<td class='mbord'>$i</td> "; 
else echo "<td class='mbord'> <a href="chat.php&page=$i">".$i."</a></td>"; 
} 
echo "<td class='mbord'> ...</td> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<td class='mbord'><a href="chat.php&page=$i">".$i."</a></td>"; 
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo " <td class='mbord'>...</td> "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<td class='mbord'>$i</td> "; 
else echo "<td class='mbord'><a href="chat.php&page=$i">".$i."</a></td>"; 
} 
echo " <td class='mbord'> ...</td> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<td class='mbord'> <a href="chat.php&page=$i">".$i."</a></td> "; 
} 

if ( $page > ($total - 5) ) { 
echo " <td class='mbord'> ... </td>"; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<td class='mbord'> $i</td> "; 
else echo "<td class='mbord'> <a href="chat.php&page=$i">".$i."</a></td> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<td class='mbord'>  <a href="chat.php&page=$next">Следваша</a></td>"; 
} 
print "</tr></table><table><tr><td class='mbord'>  Страница $page от $total</td></tr></table>";
?>
 

Back
Горе