View file blog.php

File size: 15.71Kb
<?
Error_Reporting(0);
header("Cache-Control: no-cache");
if ($ver=="wml")header ("Content-type:text/vnd.wap.wml; charset=utf-8");
else header("Content-Type:text/html; charset=UTF-8");

require("inc.php");
$link = connect_db();
list($row, $id, $ps, $fsize1, $fsize2) = check_login($link);
require("version.php");

$times = getmicrotime();

mysql_query ("Select * from bannlist WHERE (ip = '".$REMOTE_ADDR."')and(soft = '".$HTTP_USER_AGENT."')");
if ((mysql_affected_rows()!=0)&&($rm!=9)&&($row["level"]<7)) {
$re = mysql_query("SELECT name FROM rooms where rm = '9'"); 
$inam = mysql_fetch_array ($re); 
$nam = $inam["name"];
if ($ver=="wml"){
echo $xml;
echo $dtd;  
echo "<wml>\n";
echo "<head><meta http-equiv=\"Cache-Control\" content=\"no-cache\" forua=\"true\"/></head>\n";
echo "<card id=\"ban\" title=\"Стоп!\" ontimer=\"index.php?ver=$ver&amp;ref=$ref\"><timer value=\"300\"/>\n";
echo "<p align=\"left\">\n";
}else{
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">";
if($row["skin"]=="0"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css.css\"/>";}
if($row["skin"]=="1"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css1.css\"/>";}
if($row["skin"]=="2"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css2.css\"/>";}
if($row["skin"]=="3"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css3.css\"/>";}
echo "<title>Стоп!</title>";
echo "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"30; URL=index.php?ver=$ver&amp;ref=$ref\">";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/></head><body>";
echo "<div align=\"left\">";
}
echo $fsize1;
if ($ver=="xhtml"){echo"<div class='d2'>";}
echo "Вы забанены по связке ip+soft!!!<br/>\n";
echo "И доступ вам разрешен только в  <a href=\"chat.php?$ses&amp;rm=9&amp;ref=$ref\">".$nam."</a>\n";
if ($ver=="xhtml"){echo"</div>";}
echo $fsize2;
if ($ver=="wml")echo "</p></card></wml>";
else echo "</div></body></html>";
mysql_close($link);
exit;
}   


if ($ver=="wml"){
echo $xml;
echo $dtd;
echo "<wml>";
echo "<card id=\"cabinet\" title=\"*On-line Блог*\">";
echo "<p>";
}else{
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">";
if($row["skin"]=="0"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css.css\"/>";}
if($row["skin"]=="1"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css1.css\"/>";}
if($row["skin"]=="2"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css2.css\"/>";}
if($row["skin"]=="3"){
echo "<head><link rel=\"stylesheet\" type=\"text/css\" href=\"css/css3.css\"/>";}
echo "<title>*On-line Блог*</title>";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/></head><body>";
echo "<div align=\"left\">\n";
echo "<form method=\"POST\" action=\"blog.php?mode=add&amp;$ses&amp;ref=$ref\" name=\"auth\">\n";
}


$level=$row["level"];
$bv=$row["blog"];



if($level==0) $zap=50;
elseif($level==1) $zap=100;
elseif($level==2) $zap=150;
elseif($level==3) $zap=200;
elseif($level==4) $zap=250;
elseif($level==5) $zap=300;
elseif($level==6) $zap=350;
elseif($level==7) $zap=400;
elseif($level>7) $zap=500;

if ($ver=="wml"){
echo $divide;}

switch($mode) {

default:
echo '<div class="d3">';
echo '<b>Блог - онлайн wap дневник.</b><br/>';
echo '</div>';

if ($ver=="wml"){
echo $divide;}

$select = @mysql_query ("Select id,user,blog from users where id='".$id."'");
$inf = mysql_fetch_array ($select);
$usid=$inf["id"];
////////////////////////////////////////////////////// 
echo '<div class="d1">';
if ($row["blog"]>0) echo "<b><a href=\"blog.php?mode=user&amp;$ses&amp;usid=$usid\">Ваш блог</a></b><br/>\n";
echo '</div>';

if ($ver=="wml"){
echo $divide;}
///////////////////////////////////////////////

echo '<div class="d1">';
$z = mysql_fetch_array(@mysql_query ("SELECT count(id) as num FROM users where blog !='0'"));
$blog = $z["num"];
echo "<a href=\"blog.php?mode=blogovi&amp;$ses&amp;ref=$ref\">Блоги пользователей</a> ($blog)<br/>\n";
$a = mysql_fetch_array(@mysql_query("select count(id) as num from blog"));
$all = $a["num"];
echo "<a href=\"blog.php?mode=read&amp;$ses&amp;ref=$ref\">Записи в блогах</a> ($all)<br/>\n";
$z = mysql_fetch_array(@mysql_query ("SELECT count(id) as num FROM users where blog !='0'"));
$blog = $z["num"];
echo "<a href=\"blog.php?mode=rating&amp;$ses&amp;ref=$ref\">Рейтинг авторов</a> ($blog)<br/>\n";
echo '</div>';

if ($ver=="wml"){
echo $divide;}

echo '<div class="d2">';
echo "<a href=\"blog.php?mode=add&amp;$ses&amp;ref=$ref\">Добавить запись</a><br/>";
if ($inf["blog"]>0) echo "<a href=\"blog.php?mode=del&amp;$ses&amp;ref=$ref\">Удалить запись</a><br/>";
echo '</div>';

if ($ver=="wml"){
echo $divide;}

echo '<div class="d1">';
$b = mysql_fetch_array(@mysql_query("select count(id) as num from blog where who='".$id."'"));
$my = $b["num"];
echo 'Ваших записей: '.$my.'<br/>
Записей доступно: '.$zap.'<br/>
Голосов за вас: '.$bv.'<br/>';
echo '</div>';
break;

case 'read':
echo '<div class="d3">';
echo "<b>Записи в блогах</b><br/>";
echo '</div>';

if ($ver=="wml"){
echo $divide;}

if(empty($page)) $page=0;
$query = mysql_query("select id from blog ORDER BY votes desc");
$num_of_rows=mysql_num_rows($query);
$total_mat_number=$num_of_rows;
$max = 10;
$total_pages=ceil($total_mat_number/$max);
$i = 1+$page;

if (mysql_affected_rows() == 0){
echo '<div class="d2">';
echo 'Нет записей :)<br/>';
echo '</div>';
} else {

$q = mysql_query("select topic,id,who,bdata,bread,votes from blog ORDER BY votes desc limit ".$page.",".($max).";");

echo '<div class="d1">';
while($arr=mysql_fetch_array($q)){
$topic=$arr['topic'];
$bid=$arr['id'];
$who=$arr['who'];
$date=$arr['bdata'];
$read=$arr['bread'];
$votes=$arr['votes'];
$nick = mysql_fetch_array(mysql_query("select user from users where id='".$who."'"));
echo ($i++).") <a href=\"blog.php?mode=view&amp;$ses&amp;mid=$bid\">$topic</a> от $nick[0] ($date) [$votes|$read]<br/>";
}
echo '</div>';

if ($ver=="wml"){
echo $divide;}

echo '<div class="d1">';
for ($num=0; $num<$total_pages; $num++){
$page_number=$num*$max;

if ($page_number!=$page) {
echo "<a href=\"blog.php?mode=read&amp;$ses&amp;page=$page_number&amp;ref=$ref\">".($num+1)."</a>|";
} else {
echo "".($num+1)."|";
}
}
echo '<br/>';
echo '</div>';

}
break;

case 'blogovi':

echo '<div class="d3">';
echo "<b>Блоги пользователей</b><br/>";
echo '</div>';


if ($ver=="wml"){
echo $divide;}

if(empty($page)) $page=0;
$query = mysql_query("select id FROM users where blog !='0' ORDER BY blog desc");
$num_of_rows=mysql_num_rows($query);
$total_mat_number=$num_of_rows;
$max = 10;
$total_pages=ceil($total_mat_number/$max);
$i = 1+$page;
if (mysql_affected_rows() == 0){
echo '<div class="d2">';
echo 'Блоги ещё не созданы :)<br/>';
echo '</div>';
} else {

$r2 = @mysql_query ("SELECT id,user,blog FROM users where blog !='0' ORDER BY blog desc limit ".$page.",".($max).";");

echo '<div class="d1">';
while ($a3 = mysql_fetch_array($r2))
{
echo ($i++).") <a href=\"blog.php?mode=user&amp;$ses&amp;usid=".$a3["id"]."\">*".$a3["user"]." - Блог*</a> (Голосов: ".$a3["blog"].')<br/>';
}
echo '</div>';

echo '<div class="d1">';
for ($num=0; $num<$total_pages; $num++){
$page_number=$num*$max;

if ($page_number!=$page) {
echo "<a href=\"blog.php?mode=blogovi&amp;$ses&amp;page=$page_number&amp;ref=$ref\">".($num+1)."</a>|";
} else {
echo "".($num+1)."|";
}
}
echo '<br/>';
echo '</div>';

}
break;


case 'view':
$bid=intval($bid);
$q = mysql_query("select * from blog where id='".$mid."'");

if (mysql_affected_rows() == 0){
echo '<div class="d2">';
echo 'Нет такой записи :(<br/>';
echo '</div>';
} else {
$arr=mysql_fetch_array($q);
$mid=$arr['id'];
$topic=$arr['topic'];
$text=$arr['text'];
$who=$arr['who'];
$date=$arr['bdata'];
$read=$arr['bread'];
$votes=$arr['votes'];
$nick = mysql_fetch_array(mysql_query("select user from users where id='".$who."'"));

echo '<div class="d1">';
echo "<b>$topic</b> - <a href=\"info.php?ver=$ver&amp;id=$id&amp;ps=$ps&amp;nk=$who&amp;ref=$ref\">$nick[0]</a><br/>";
echo '</div>';

if ($ver=="wml"){
echo $divide;}

echo '<div class="d1">';
echo $text.'<br/>';
echo '</div>';

if ($ver=="wml"){
echo $divide;}

echo '<div class="d2">';
echo 'Добавленно: '.$date.'<br/>';
mysql_query("update blog set bread=bread+'1' where id='".$mid."'");
echo 'Прочитанно: '.$read.' раз<br/>';

if ($arr["votes"]>0) {
echo "Голосов: <a href=\"blog.php?mode=who&amp;$ses&amp;mid=$mid\">".$votes.'</a><br/>';
} else {
echo "Голосов: ".$votes.'<br/>';
}

echo '</div>';

if ($ver=="wml"){
echo $divide;}

echo '<div class="d2">';
if($who==$id or $level > 5) echo "<a href=\"blog.php?mode=del&amp;act=del&amp;$ses&amp;mid=$mid\">Удалить</a><br/>";
if($who!=$id) echo "<a href=\"blog.php?mode=vote&amp;$ses&amp;mid=$mid\">Голосовать</a><br/>";
echo '</div>';
}
break;

case 'add':
$a = mysql_fetch_array(@mysql_query("select count(id) as num from blog where who='".$id."'"));
if ($a[0]<=$zap){
if (!$text){

echo '<div class="d3">';
echo '<b>Добавить запись:</b><br/>';
echo '</div>';

if ($ver=="wml"){
echo $divide;}

echo '<div class="d2">';
echo 'Тема:<br/>';
echo "<input name=\"topic\" maxlength=\"30\" value=\"$row[topic]\" title=\"infa\" emptyok=\"false\"/><br/>\n";

echo 'Текст:<br/>';
echo "<input name=\"text\" maxlength=\"1000\" value=\"$row[text]\" title=\"infa\" emptyok=\"false\"/><br/>\n";

if ($ver=="wml") {
echo "<anchor title=\"go\">Добавить<go href=\"blog.php?mode=add&amp;$ses&amp;ref=$ref\" method=\"post\">\n";
echo "<postfield name=\"topic\" value=\"$(topic)\"/>\n";
echo "<postfield name=\"text\" value=\"$(text)\"/>\n";
echo '</go></anchor><br/>';
} else if ($ver=="xhtml") {
echo "<form method=\"POST\" action=\"blog.php?mode=add&amp;$ses&amp;ref=$ref\" name=\"auth\">\n";
echo "<input type=\"submit\" value=\"Добавить\" name=\"enter\"><br/>\n";
}
echo '</div>';


} else {
$topic = substr(check($topic),0,60);
$text = substr(check($text),0,7000);

if ($row["translit"]==1){
$topic = trun_to_rus($topic);
$text = trun_to_rus($text);
}

if (empty($topic)) {
echo '<div class="d2">';
echo 'Поле Тема не заполненно<br/>';
echo '</div>';
} else {
$bdata = date("d.m.y H:m");
mysql_query("Insert into blog set who ='".$id."', text = '".$text."', topic = '".$topic."', bdata = '".$bdata."'");
mysql_query ("Update users set blog='1' where id ='".$id."'");
echo '<div class="d2">';
echo 'Запись успешно добавленна в ваш блог :)<br/>';
echo '</div>';
}
}
} else {
echo '<div class="d2">';
echo 'Вы не можите добавить '.$zap.' запись в блог :(<br/>
Но можите удалить некоторые не нужные записи :)<br/>';
echo '</div>';
}
break;

case 'del':
if (!$act){
echo '<div class="d3">';
echo '<b>Удаление записи</b><br/>';
echo '</div>';

if ($ver=="wml"){
echo $divide;}

$q = mysql_query("select id,topic from blog where who='".$id."'");

while($arr=mysql_fetch_array($q)){
echo '<div class="d1">';
echo "<a href=\"blog.php?mode=del&amp;$ses&amp;act=go&amp;mid=$arr[id]\">".$arr['topic']."</a><br/>";
echo '</div>';
}

if (mysql_affected_rows() == 0){
echo '<div class="d2">';
echo 'Нет не одной записи, что удалять хочеш? :)<br/>';
echo '</div>';
}
} else {
if ($level > 5) $zapros="delete from blog where id= '".$mid."'";
else $zapros="delete from blog where id= '".$mid."' and who='".$id."'";
if (mysql_query($zapros)){
echo '<div class="d2">';
echo 'Запись успешно удалена<br/>';
echo '</div>';
} else { 
echo '<div class="d2">';
echo '<b>Ошибка</b><br/>'; 
echo '</div>';
}
}
break;

case 'rating':
echo '<div class="d3">';
echo '<b>Рейтинг авторов</b><br/>';
echo '</div>';

if ($ver=="wml"){
echo $divide;}

$r2 = @mysql_query ("SELECT id,user,blog FROM users where blog !='0' ORDER BY blog desc LIMIT 0,10;");
$i = 1;

echo '<div class="d1">';
while ($a3 = mysql_fetch_array($r2))
{
echo ($i++).") <a href=\"blog.php?mode=user&amp;$ses&amp;usid=".$a3["id"]."\">".$a3["user"]."</a> - ".$a3["blog"].'<br/>';
}
echo '</div>';
break;

case 'user':
$r = mysql_fetch_array(@mysql_query ("SELECT user from users where id='".$usid."' LIMIT 1;"));
echo '<div class="d3">';
echo '<b>'.$r[0].' - Блог</b><br/>';
echo '</div>';

if ($ver=="wml"){
echo $divide;}

if(empty($page)) $page=0;
$query = mysql_query("select id from blog where who='".$usid."'");
$num_of_rows=mysql_num_rows($query);
$total_mat_number=$num_of_rows;
$max = 10;
$total_pages=ceil($total_mat_number/$max);
$i = 1+$page;

$q = mysql_query("select id,topic,bdata,bread,votes from blog where who='".$usid."' ORDER BY votes desc limit ".$page.",".($max).";");


if (mysql_affected_rows() == 0){
echo '<div class="d2">';
echo 'Нет записей :(<br/>';
echo '</div>';

} else {
echo '<div class="d1">';
while($arr=mysql_fetch_array($q)){
$topic=$arr['topic'];
$bid=$arr['id'];
$date=$arr['bdata'];
$read=$arr['bread'];
$votes=$arr['votes'];

echo ($i++).") <a href=\"blog.php?mode=view&amp;$ses&amp;act=go&amp;mid=$bid\">$topic</a> ($date) [$votes|$read]<br/>";}
echo '</div>';

if ($ver=="wml"){
echo $divide;}

echo '<div class="d1">';
for ($num=0; $num<$total_pages; $num++){
$page_number=$num*$max;

if ($page_number!=$page) {
echo "<a href=\"blog.php?mode=user&amp;$ses&amp;usid=$usid&amp;page=$page_number&amp;ref=$ref\">".($num+1)."</a>|";
} else {
echo "".($num+1)."|";
}
}
echo '</div>';

}
break;




case 'vote':
$query = mysql_query("select who from blog where id = '".$mid."' LIMIT 1");
if (mysql_affected_rows() == 0) {
echo '<div class="d2">';
echo "Нет голосов<br/>";
echo '</div>';

echo '</p></card></wml>';
mysql_close ($link);
exit;
}
$arr = @mysql_fetch_array($query);
$usid=$arr["who"];
if ($id==$usid){
echo '<div class="d2">';
echo 'Вы не можите голосовать сами за себя :D <br/>';
echo '</div>';
}else{
mysql_query ("Select * from blogvote where id='".$mid."' and who='".$id."'");
if (mysql_affected_rows() == 0) {
mysql_query("INSERT INTO blogvote SET id = '".$mid."', who = '".$id."'");
mysql_query("update blog set votes=votes+'1' where id = '".$mid."'");
mysql_query("update users set blog=blog+'1' where id='".$usid."'");
echo '<div class="d2">';
echo 'Ваш голос принят<br/>';
echo '</div>';
} else {
echo '<div class="d2">';
echo 'Вы уже голосовали за эту запись :)<br/>';
echo '</div>';
}
}
break;

case 'who':
$query = mysql_query("select who from blogvote where id = '".$mid."'");
if (mysql_affected_rows() == 0) {
echo '<div class="d2">';
echo "Нет голосов<br/>";
echo '</div>';
mysql_close ($link);
exit;
} else {
echo '<div class="d2">';
echo '<b>Кто отдал голос:</b><br/>';
echo '</div>';

if ($ver=="wml"){
echo $divide;}

$i = 1;

echo '<div class="d1">';
while($arr=mysql_fetch_array($query)){
$r = mysql_fetch_array(@mysql_query ("SELECT user from users where id='".$arr[0]."' LIMIT 1;"));
echo ($i++).') '.$r[0].'<br/>';
}
echo '</div>';

}
break;

}

if ($ver=="wml"){
echo $divide;}

if($mode) {
echo '<div class="d3">';
echo "<a href=\"blog.php?$ses&amp;ref=$ref\">Блог</a><br/>\n";
echo '</div>';
}

echo '<div class="d3">';
echo "<a href=\"enter.php?$ses&amp;ref=$ref\">Прихожая</a><br/>";
echo '</div>';

if ($ver=="wml"){
echo $divide;}

if ($ver=="wml")echo "</p></card></wml>";
else echo "</div></body></html>";
mysql_close($link);
?>