<?php
include('les/conf.php');
$getid = $_GET['id'];
//make the connection to the database
$connection = mysql_connect(localhost, $user,$pass) or die("Не мога да се свържа с SQL");
$db = @mysql_select_db($db,$connection)or die("Не мога да намеря базата данни");
$sql = "SELECT * FROM uroci WHERE id = '$getid'";
$result = @mysql_query($sql,$connection) or die(mysql_error());
while ($sql = mysql_fetch_object($result))
{
$zaglavie = $sql -> zaglavie;
$urok = $sql -> urok;
$avtor= $sql -> avtor;
$kategoria = $sql -> kategoria;
$urok = str_replace(":)",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_smile.gif[/img]',$urok);
$urok = str_replace(":(",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_sad.gif[/img]',$urok);
$urok = str_replace(":arrow:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_arrow.gif[/img]',$urok);
$urok = str_replace(":D",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_biggrin.gif[/img]',$urok);
$urok = str_replace(":?",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_confused.gif[/img]',$urok);
$urok = str_replace("8)",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_cool.gif[/img]',$urok);
$urok = str_replace(";(",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_cry.gif[/img]',$urok);
$urok = str_replace(":shock:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_eek.gif[/img]', $urok);
$urok = str_replace(":evil:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_evil.gif[/img]', $urok);
$urok = str_replace(":!:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_exclaim.gif[/img]', $urok);
$urok = str_replace(":idea:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_idea.gif[/img]', $urok);
$urok = str_replace(":lol:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_lol.gif[/img]', $urok);
$urok = str_replace(":x",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_mad.gif[/img]', $urok);
$urok = str_replace(":?:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_question.gif[/img]', $urok);
$urok = str_replace(":P",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_razz.gif[/img]', $urok);
$urok = str_replace(":oops:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_redface.gif[/img]', $urok);
$urok = str_replace(":roll:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_rolleyes.gif[/img]', $urok);
$urok = str_replace(":o",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_surprised.gif[/img]', $urok);
$urok = str_replace(":wink:",'[img]http://bgnet.mybgweb.com/uroci/images/smilies/icon_wink.gif[/img]', $urok);
$urok1 = htmlspecialchars("$urok", 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');
$bbcode_replace = array( 0 => '<b>$1</b>',
1 => '<i>$1</i>',
2 => '<u>$1</u>',
3 => '<table class="quote" width="100%" border="0"><tr><td>Öèòàò:</td></tr><tr><td class="quote_box" width="100%" style="border:solid 1px black">$1</td></tr></table>',
4 => '<table class="quote" width="100%" border="0"><tr><td>$1 êàçà:</td></tr><tr><td class="quote_box" width="100%" style="border:solid 1px black">$2</td></tr></table>',
5 => '<a href="$1">$1</a>',
6 => '<a href="$1">$2</a>',
7 => '<img src="$1" alt="User submitted image" title="User submitted image"/>',
8 => '<span style="color:$1">$2</span>',
9 => '<span style="font-size:$1">$2</span>',
10 => '<table width="95%" border="0" align="center"><tr><td class="blue"><font size="2">Êîä:</font></td></tr><tr><td class="code" width="100%">$1</td></tr></table>');
ksort($bbcode_regex);
ksort($bbcode_replace);
$post_bbcode_treated = preg_replace($bbcode_regex, $bbcode_replace, $urok1);
$urok = nl2br($post_bbcode_treated);
}?>