Помощ система за "Лични съобщения"

A

AbvTube

Registered
Трябва ми да вградя в сайта си размяна на лични съобщения между потребителите някой може ли да помогне
 
index.php - служи за кутия където са всички съобщения

Код: 
<?
include("твоят config.php");
$page = $_GET['page'];
if ($page == 0 || $page == NULL || $page < 0)
{
    $page = 1;
}
$pp = 10;
$start = ($page*$pp) - $pp;
$user = $_SESSION['username'];
$query = mysql_query("SELECT * FROM pms WHERE user='$user'") or die (mysql_error());
$broi = mysql_num_rows($query);
$total = ceil($broi/$pp);
$user = $_SESSION['username'];
$result = mysql_query(" SELECT * FROM pms WHERE user='$user' " .
" ORDER BY id DESC LIMIT $start,$pp");
echo '<div class="dataitem single">
					<table>
						<tbody><tr class="header">
							<td class="sender">
								 Потребител							</td>
							<td class="subject">
								 Заглавие							</td>
						</tr>';
while($row = mysql_fetch_array($result))
{
$visit = $row['author'];
$sql = mysql_query("SELECT * FROM users WHERE username='$visit'");
$r = mysql_fetch_array($sql);
$oactive = $r['oactive'];
if($oactive == "no")
{
$pic = 'wroot/no_photo.jpg';
}
else
{
$pic = $r['osnovna'];
}
if($row['procheteno'] == "no")
{
$rnew = 'new';
}
else
{
$rnew = '';
} 
echo '<tr class="row odd '.$rnew.'">

								<td class="sender"> 
								<a href="resize.php?img='.$pic.'" class="highslide" onclick="return hs.expand(this)"><img src="resize.php?img='.$pic.'" width="50" border="0"></а>
										<a href="'.$siteurl.$r[id].'"><br>'.$r[username].'</a>
								</td>
								<td class="subject">
								 <a href="index.php?p=inbox&a=read&id='.$row[id].'">'.$row[title].'</a>                                             
								</td>
							</tr>';
}
echo '					</tbody></table>';
echo "<br /><center>"; 
if ($page > 1) { 
$prev = ($page - 1); 
echo "<a href=\"index.php?p=inbox&page=$prev\" class='pages'>предишна</a> "; 
} 
else echo ""; 

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

if ($total < 10) { 
for($i=1 ; $i<=$total ; $i++) { 
if ( ($page)==$i ) { 
echo "<a class='pagesactive'> $i </a> "; 
} 
else { 
echo "<a href=\"index.php?p=inbox&page=".$i."\" class='pages'> ".$i." </a> "; 
} 
} 
} 
else { 
for($i=1 ; $i<=3 ; $i++) { 
if ( ($page)==$i ) { 
echo "<a class='pagesactive'> $i </a> "; 
} 
else { 
echo "<a href=\"index.php?p=inbox&page=".$i."\" class='pages'> ".$i." </a> "; 
} 
} 

if ($page <= 3) { 
if ($page == 3) echo " <a href=\"index.php?p=inbox&page=4\" class='pages'> 4 </a> "; 
echo " <a class='pages'> ... </a> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"index.php?p=inbox&page=".$i."\" class='pages'> ".$i."</a> "; 
} 
if ($page == 5) $parva.= " <a href=\"index.php?p=inbox&page=4\" class='pages'> 4 </a> "; 

if ( ($page == 4) or ($page == 5) ) { 
for ($i=$page; $i<=$page+1; $i++) { 
if ($page == $i) echo "<a class='pagesactive'> $i </a> "; 
else echo "<a href=\"index.php?p=inbox&page=".$i."\" class='pages'> ".$i." </a> "; 
} 
echo " <a class='pages'> ... </a> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"index.php?p=inbox&page=".$i."\" class='pages'> ".$i." </a> "; 
} 

if ( ($page > 5) and ($page < ($total - 4)) ) { 
echo " <a class='pages'> ... </a> "; 
for ($i=$page-1; $i<=$page+1; $i++) { 
if ($page == $i) echo "<a class='pagesactive'> $i </a> "; 
else echo "<a href=\"index.php?p=inbox&page=".$i."\" class='pages'> ".$i." </a> "; 
} 
echo " <a class='pagesactive'> ... </a> "; 
for ($i=$total-2; $i<=$total; $i++) 
echo "<a href=\"index.php?p=inbox&page=".$i."\" class='pages'> ".$i." </a> "; 
} 

if ( $page > ($total - 5) ) { 
echo " <a class='pages'> ... </a> "; 
for ($i=$total-5; $i<=$total; $i++) { 
if ($page == $i) echo "<a class='pagesactive'> $i </a> "; 
else echo "<a href=\"index.php?p=inbox&page=".$i."\" class='pages'> ".$i." </a> "; 
} 
} 
} 

if ($page < $total) { 
$next = ($page + 1); 
echo "<a href=\"index.php?p=inbox&page=$next\" class='pages'>следваща</a>"; 
} 
print "<br /> Страница $page от $total</center>	</div>
			</div>";

?>

следва read.php - служи за преглед на съобщението

Код: 
<?
include("твоят config.php");
$id = $_GET['id'];
$user = $_SESSION['username'];
$sql = mysql_query("SELECT * FROM pms WHERE id='$id' and user='$user'");
if (mysql_num_rows($sql)>0)
{
$r = mysql_fetch_array($sql);
$author = $r['author'];
$sql2 = mysql_query("SELECT * FROM users WHERE username='$author'");
$row = mysql_fetch_array($sql2);
$pmid = $r['id'];
$sql3 = mysql_query("UPDATE pms SET procheteno='yes' WHERE id='$pmid'");
$post = $r[post];

$post = htmlspecialchars("$post", ENT_QUOTES);
$bbcode_regex = array(
0 => '/\[b\](.+?)\[\/b\]/s',
1 => '/\[i\](.+?)\[\/i\]/s',
2 => '/\[u\](.+?)\[\/u\]/s',
3 => '/\[quote\](.+?)\[\/quote\]/s',
4 => '/\[quote\=(.+?)](.+?)\[\/quote\]/s',
5 => '/\[url\](.+?)\[\/url\]/s',
6 => '/\[url\=(.+?)\](.+?)\[\/url\]/s',
7 => '/\[img\](.+?)\[\/img\]/s',
8 => '/\[color\=(.+?)\](.+?)\[\/color\]/s',
9 => '/\[size\=(.+?)\](.+?)\[\/size\]/s',
10 => '/\[code\](.+?)\[\/code\]/s',
11 => '/\[vbox\]http:\/\/vbox7.com\/play:(.+?)\[\/vbox\]/s',
12 => '/\[youtube\]http:\/\/www.youtube.com\/watch\?v=(.+?)\[\/youtube\]/s',
); 
$post = $r['post']; 
$post= nl2br($post); 
$bbcode_replace = array(
0 => '<b>$1</b>',
1 => '<i>$1</i>',
2 => '<u>$1</u>',
3 => '<div class="bb-quote">$1</div>',
4 => '<div class="bb-quote"><font color="red">$1</font>:<br>$2</div>',
5 => '<a href="$1">$1</a>',
6 => '<a href="$1" target="_blank">$2</a>',
7 => '<a href="$1" onclick="return openYouTube(this)" class="highslide"><img width="50" height="50" src="$1" alt="Image"/></a>',
8 => '<span style="color:$1">$2</span>',
9 => '<span style="font-size:$1pt">$2</span>',
10 => '<div class="bb-code">$1</div>',
11 => '<a href="http://i48.vbox7.com/player/ext.swf?vid=$1" onclick="return openYouTube(this)" class="highslide">Прикачен видеоклип от Vbox7</a> ',
12 => '<a href="http://www.youtube.com/v/$1&hl=en_US&fs=1&" onclick="return openYouTube(this)" class="highslide">Прикачен видеоклип от Youtube</a> ',
);
ksort($bbcode_regex);
ksort($bbcode_replace); 
$post = preg_replace($bbcode_regex, $bbcode_replace, $post); 
$post = str_replace(":)","<img src='emot/smile.gif' title='Усмивка' alt='Усмивка' border='0'>",$post);
$post = str_replace(":D","<img src='emot/icon_biggrin.gif' alt='Смях' border='0'>",$post);
$post = str_replace(":(","<img src='emot/icon_sad.gif' title='Тъжно лице' alt='Тъжно лице' border='0'>",$post);
$post = str_replace(":O","<img src='emot/icon_surprised.gif' title='Изненада' alt='Изненада' border='0'>",$post);
$post = str_replace(":shock:","<img src='emot/icon_eek.gif' title='Шокиран' alt='Шокиран' border='0'>",$post);
$post = str_replace("::?","<img src='emot/icon_confused.gif' title='Кофти' alt='Кофти' border='0'>",$post);
$post = str_replace("8)","<img src='emot/icon_cool.gif' title='Пич' alt='Пич' border='0'>",$post);
$post = str_replace(":lol:","<img src='emot/icon_lol.gif' title='Ха-ха-ха' alt='Ха-ха-ха' border='0'>",$post);
$post = str_replace(":x","<img src='emot/icon_mad.gif' title='Набурсучен' alt='Набурсучен' border='0'>",$post);
$post = str_replace(":P","<img src='emot/icon_razz.gif' title='Плезлио' alt='Плезлио' border='0'>",$post);
$post = str_replace("оoops:","<img src='emot/icon_redface.gif' title='Срам' alt='Срам' border='0'>",$post);
$post = str_replace(":cry:","<img src='emot/icon_cry.gif' title='Плач' alt='Плач' border='0'>",$post);
$post = str_replace(";)","<img src='emot/icon_wink.gif' title='Мигване' alt='Мигване' border='0'>",$post);
$post = str_replace("(inlove)","<img src='emot/inlove.gif' title='Влюбване' alt='Влюбване' border='0'>",$post);
$post = str_replace("(no)","<img src='emot/no.gif' title='Не' alt='Не' border='0'>",$post);
$post = str_replace("(yes)","<img src='emot/yes.gif' title='Да' alt='Да' border='0'>",$post);
$post = str_replace("(party)","<img src='emot/party.gif' title='Купон' alt='Купон' border='0'>",$post);
$post = str_replace("(smile)","<img src='emot/smile.gif' title='Усмихване' alt='Усмихване' border='0'>",$post);
$post = str_replace("|-)","<img src='emot/sleepy.gif' title='Заспиване' alt='Заспиване' border='0'>",$post);
$post = str_replace(":*","<img src='emot/kiss.gif' title='Целувка' alt='Целувка' border='0'>",$post);

$post = str_replace("(devil)","<img src='emot/devil.gif' title='Дявол' alt='Дявол' border='0'>",$post);
$post = str_replace("(clap)","<img src='emot/clapping.gif' title='Ръкопляскане' alt='Ръкопляскане' border='0'>",$post);
$post = str_replace("(nod)","<img src='emot/nod.gif' title='Кимане' alt='Кимане' border='0'>",$post);
$post = str_replace("(skype)","<img src='emot/skype.gif' title='Skype' alt='Skype' border='0'>",$post);

$post = str_replace("(sun)","<img src='emot/sun.gif' title='Слънце' alt='Слънце' border='0'>",$post);
$post = str_replace("(time)","<img src='emot/time.gif' title='Време' alt='Време' border='0'>",$post);
$post = str_replace("(^)","<img src='emot/cake.gif' title='Торта' alt='Торта' border='0'>",$post);
$post = str_replace("(beer)","<img src='emot/beer.gif' title='Бира' alt='Бира' border='0'>",$post);

$post = str_replace("(d)","<img src='emot/drink.gif' title='Питие' alt='Питие' border='0'>",$post);
$post = str_replace("(*)","<img src='emot/star.gif' title='Звезда' alt='Звезда' border='0'>",$post);
$post = str_replace("(smoke)","<img src='emot/smoke.gif' title='Пушене' alt='Пушене' border='0'>",$post);
$post = str_replace("(rock)","<img src='emot/rock.gif' title='Рок' alt='Рок' border='0'>",$post);

$post = bbcode($post);

$oactive = $row['oactive'];
if($oactive == "no")
{
$pic = 'wroot/no_photo.jpg';
}
else
{
$pic = $row['osnovna'];
}
echo '
<table border="0">
<tr>
<td><b>Заглавие:</b></td>
<td>'.$r[title].'</td>
</tr>
<tr>
<td><b>Автор:</b></td>
<td><a href="'.$siteurl.$r[id].'">'.$r[author].'</a></td>
</tr>
<tr>
<td><b>Изпратено на:</b></td>
<td>'.$r[date].'</td>
</tr>
<tr>
<td colspan="2"><a href="index.php?p=inbox&a=delete&id='.$r[id].'"><b>[изтрий това съобщение]</b></a></td>
</tr>
<tr>
<td colspan="2"><div id="info_message">'.$post.'</div></td>
</tr>
</table>';
}
else
{
echo 'Нямате право да четете това съобщение!';
}
?>

следва write.php - служи за изпращане на съобщение

Код: 
<?php 
include("твоят config.php");
if($_POST['submit']) 
{ 
$title = htmlspecialchars($_POST['title']); 
$author = $_SESSION['username']; 
$user = htmlspecialchars($_POST['for']); 
$after7hours = time()+7*60*60; 
$date = date("d/m/Y H:i:s", $after7hours); 
$post = $_POST['post']; 
$proverka = mysql_query("SELECT * FROM users WHERE username='$user'"); 
if($author == $user) 
{ 
echo '<div id="info_message">Не може да изпращате съобщения до себе си</div>'; 
} 
else if(mysql_num_rows($proverka) == 0) 
{ 
echo '<div id="info_message"> Няма такъв потребител</div>'; 
} 
else 
{ 
$sql = mysql_query("INSERT pms (title, user, date, author, post, procheteno) VALUES ('$title', '$user', '$date', '$author', '$post', 'no')"); 
echo '<div id="info_message">Съобщението е изпратено успешно!</div>'; 
} 
} 
?>

	<div class="outter page_account_friends_requests">
<div class="sidebox_wrap"><div class="homepage">
	<h3 class="members">Ново Съобщение</h3></div></div>
			<div class="typepage pmbox">
<form action="" method="POST" onsubmit="return validate()">
<b>Заглавие:</b>
<br>
<input type="text" class="text" size="35" id="title" name="title"><br>
<b>Получател:</b>
<br>
<input type="text" class="text" size="35" id="for" name="for" value="<? echo $_GET['for']; ?>">
<br>
<b>Съобщение:</b><br><textarea class="textarea textarea_full" id="field_comment_body" cols="40" rows="5" name="post"></textarea>
<br>
<div class="subtitle">	<center>
<a href='javascript:addemo(" :)");' title='Усмивка'><img src='emot/smile.gif' alt='Усмивка' border='0'></a>
<a href='javascript:addemo(" :D");' title='Смях'><img src='emot/icon_biggrin.gif' alt='Смях' border='0'></a>
<a href='javascript:addemo(" :(");' title='Тъжно лице'><img src='emot/icon_sad.gif' alt='Тъжно лице' border='0'></a>
<a href='javascript:addemo(" :O");' title='Изненада'><img src='emot/icon_surprised.gif' alt='Изненада' border='0'></a>
<a href='javascript:addemo(" :shock:");' title='Шокиран'><img src='emot/icon_eek.gif' alt='Шокиран' border='0'></a>
<a href='javascript:addemo(" ::?");' title='Кофти'><img src='emot/icon_confused.gif' alt='Кофти' border='0'></a>
<a href='javascript:addemo(" 8)");' title='Пич'><img src='emot/icon_cool.gif' alt='Пич' border='0'></a>
<a href='javascript:addemo(" :lol:");' title='Ха-ха-ха'><img src='emot/icon_lol.gif' alt='Ха-ха-ха' border='0'></a>
<a href='javascript:addemo(" :x");' title='Набурсучен'><img src='emot/icon_mad.gif' alt='Набурсучен' border='0'></a>
<a href='javascript:addemo(" :P");' title='Плезлио'><img src='emot/icon_razz.gif' alt='Плезлио' border='0'></a>
<a href='javascript:addemo(" оoops:");' title='Срам'><img src='emot/icon_redface.gif' alt='Срам' border='0'></a>
<a href='javascript:addemo(" :cry:");' title='Плач'><img src='emot/icon_cry.gif' alt='Плач' border='0'></a>
<a href='javascript:addemo(" ;)");' title='Мигване'><img src='emot/icon_wink.gif' alt='Мигване' border='0'></a>
<a href='javascript:addemo(" (inlove)");' title='Влюбване'><img src='emot/inlove.gif' alt='Влюбване' border='0'></a>
<a href='javascript:addemo(" (no)");' title='Не'><img src='emot/no.gif' alt='Не' border='0'></a>
<a href='javascript:addemo(" (yes)");' title='Да'><img src='emot/yes.gif' alt='Да' border='0'></a>
<a href='javascript:addemo(" (party)");' title='Купон'><img src='emot/party.gif' alt='Купон' border='0'></a>
<a href='javascript:addemo(" (smile)");' title='Усмихване'><img src='emot/smile.gif' alt='Усмихване' border='0'></a>
<a href='javascript:addemo(" |-)");' title='Заспиване'><img src='emot/sleepy.gif' alt='Заспиване' border='0'></a>
<a href='javascript:addemo(" :*");' title='Целувка'><img src='emot/kiss.gif' alt='Целувка' border='0'></a>
<a href='javascript:addemo(" (devil)");' title='Дявол'><img src='emot/devil.gif' alt='Дявол' border='0'></a>
<a href='javascript:addemo(" (clap)");' title='Ръкопляскане'><img src='emot/clapping.gif' alt='Ръкопляскане' border='0'></a>
<a href='javascript:addemo(" (nod)");' title='Кимане'><img src='emot/nod.gif' alt='Кимане' border='0'></a>
<a href='javascript:addemo(" (skype)");' title='Skype'><img src='emot/skype.gif' alt='Skype' border='0'></a>
<a href='javascript:addemo(" (sun)");' title='Слънце'><img src='emot/sun.gif' alt='Слънце' border='0'></a>
<a href='javascript:addemo(" (time)");' title='Време'><img src='emot/time.gif' alt='Време' border='0'></a>
<a href='javascript:addemo(" (^)");' title='Торта'><img src='emot/cake.gif' alt='Торта' border='0'></a>
<a href='javascript:addemo(" (beer)");' title='Бира'><img src='emot/beer.gif' alt='Бира' border='0'></a>
<a href='javascript:addemo(" (d)");' title='Питие'><img src='emot/drink.gif' alt='Питие' border='0'></a>
<a href='javascript:addemo(" (*)");' title='Звезда'><img src='emot/star.gif' alt='Звезда' border='0'></a>
<a href='javascript:addemo(" (smoke)");' title='Пушене'><img src='wroot/emot/smoke.gif' alt='Пушене' border='0'></a>
<a href='javascript:addemo(" (rock)");' title='Рок'><img src='emot/rock.gif' alt='Рок' border='0'></a>
										   </center>
										   </div>
<br>
<input type="submit" name="submit" class="submit" value="Изпрати">
</form>
</div>

следва delete.php - служи за изтриване на съобщение

Код: 
<?
include("твоят config.php");
$id = $_GET['id'];
$user = $_SESSION['username'];
$sql = mysql_query("SELECT * FROM pms WHERE id='$id' and user='$user'");
if (mysql_num_rows($sql)>0)
{
$sql2 = mysql_query("DELETE FROM pms WHERE id='$id'");
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=index.php?p=inbox\">";
}
else
{
echo 'Нямате право да триете това съобщение!';
}
?>

следва pms.sql

Код: 
CREATE TABLE `pms` ( 
`id` int(4) NOT NULL auto_increment, 
`title` text NOT NULL,
`user` varchar(255) NOT NULL, 
`date` varchar(255) NOT NULL, 
`author` varchar(255) NOT NULL, 
`post` text NOT NULL, 
`procheteno` varchar(255) NOT NULL default 'no', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

емотиконите може да свалиш от тук emot.rar
Увеличете...
това устройва ли те ?
 
Редактирах си мнението :) просто добави в началото на всеки код <? include("твоят config.php"); във index.php, read.php, write.php, delete.php

също така добави в твоят config.php следният код

Код: 
if($_SESSION['username'])
{
$pmsql = mysql_query("SELECT * FROM pms WHERE user='$useraaa' and procheteno='no'");
$numpm = mysql_num_rows($pmsql);
}

после където ти е менюто Съобщения ('.$numpm.') в зависимост ако е вътре в php <?
if(!$_SESSION['username']) твоята сесия на логнатия потребител
{
echo 'Съобщения';
}
else
{
echo 'Съобщения ('.$numpm.')';
?>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе