Е ся ще напиша нов.
Eто ти sql
Код:
CREATE TABLE `comments` (
`id` int(4) NOT NULL auto_increment,
`uid` text NOT NULL,
`author` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Ето ти и кода за добавяне на коментари
Код:
<?
if (eregi("modules/uroci/add_comment.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
if(!$_SESSION['username'])
{
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=index.php?m=error\">";
}
?>
<script language="javascript" type="text/javascript">
</script>
<?
$id = $_GET['id'];
if($_POST['message'])
{
$msg = $_POST['message'];
$author = $_SESSION['username'];
$date = date("d.m.Y - H:i:s");
$sql = mysql_query("INSERT comments (uid, author, date, comment) VALUES ('$id', '$author', '$date', '$msg')");
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=index.php?m=uroci&ext=view&id=$id\">";
}
?>
<div class="com_er"><b><form action="" name="addform" method="POST">
<input type="button" value="[b]" onclick="javascript:areatext('[b]Text[/b]');">
<input type="button" value="[i]" onclick="javascript:areatext('[i]Text[/i]');">
<input type="button" value="[u]" onclick="javascript:areatext('[u]Text[/u]');">
<input type="button" value="Color" onclick="javascript:areatext('[color=]Text[/color]');">
<input type="button" value="Size" onclick="javascript:areatext('[size=0]Text[/size]');">
<input type="button" value="Img" onclick="javascript:areatext('[img]Address[/img]');">
<input type="button" value="URL" onclick="javascript:areatext('[url=Address]Name[/url]');">
<input type="button" value="Code" onclick="javascript:areatext('[code]
');"><br/>
<a href="javascript:areatext('smile');" border="0"><img src="images/smiles/icon_smile.gif" border="0"></a>
<a href="javascript:areatext('arrow');" border="0"><img src="images/smiles/icon_arrow.gif" border="0"></a>
<a href="javascript:areatext('biggrin');" border="0"><img src="images/smiles/icon_biggrin.gif" border="0"></a>
<a href="javascript:areatext('confused');" border="0"><img src="images/smiles/icon_confused.gif" border="0"></a>
<a href="javascript:areatext('cool');" border="0"><img src="images/smiles/icon_cool.gif" border="0"></a>
<a href="javascript:areatext('cry');" border="0"><img src="images/smiles/icon_cry.gif" border="0"></a>
<a href="javascript:areatext('eek');" border="0"><img src="images/smiles/icon_eek.gif" border="0"></a>
<a href="javascript:areatext('evil');" border="0"><img src="images/smiles/icon_evil.gif" border="0"></a>
<a href="javascript:areatext('exclaim');" border="0"><img src="images/smiles/icon_exclaim.gif" border="0"></a>
<a href="javascript:areatext('frown');" border="0"><img src="images/smiles/icon_frown.gif" border="0"></a>
<a href="javascript:areatext('idea');" border="0"><img src="images/smiles/icon_idea.gif" border="0"></a><br/>
<a href="javascript:areatext('lol');" border="0"><img src="images/smiles/icon_lol.gif" border="0"></a>
<a href="javascript:areatext('mad');" border="0"><img src="images/smiles/icon_mad.gif" border="0"></a>
<a href="javascript:areatext('mrgreen');" border="0"><img src="images/smiles/icon_mrgreen.gif" border="0"></a>
<a href="javascript:areatext('neutral');" border="0"><img src="images/smiles/icon_neutral.gif" border="0"></a>
<a href="javascript:areatext('razz');" border="0"><img src="images/smiles/icon_razz.gif" border="0"></a>
<a href="javascript:areatext('redface');" border="0"><img src="images/smiles/icon_redface.gif" border="0"></a>
<a href="javascript:areatext('rolleyes');" border="0"><img src="images/smiles/icon_rolleyes.gif" border="0"></a>
<a href="javascript:areatext('sad');" border="0"><img src="images/smiles/icon_sad.gif" border="0"></a>
<a href="javascript:areatext('surprised');" border="0"><img src="images/smiles/icon_surprised.gif" border="0"></a>
<a href="javascript:areatext('twisted');" border="0"><img src="images/smiles/icon_twisted.gif" border="0"></a>
<a href="javascript:areatext('wink');" border="0"><img src="images/smiles/icon_wink.gif" border="0"></a><br/>
<textarea rows="7" cols="55" name="message"<? if(isset($_POST[message])) echo $_POST[message]; ?></textarea><br><br>
<input type="submit" class="btn" value="Добави">
</form></b></div><br><br>
[/code]
Значи трябва да си създадеш папка images и в нея друга папка smiles
И в нея да добавиш емотиконите.
А ето ти и settings.php
Код:
<?
if (eregi("settings.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
?>
<?php
$host = "Хост";
$dbusername = "Потребител";
$dbpassword = "Парола";
$db = "База дани";
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("unable to connect to the database");
mysql_select_db("$db", $db_conn) or die("unable to select the database");
mysql_query("SET CHARACTER SET UTF-8");
session_start();
$duser = $_SESSION['username'];
$sql123 = "SELECT * FROM pm WHERE user='$duser' and procheteno='ne'";
$ress = @mysql_query($sql123) or die(mysql_error());
$num = mysql_num_rows($ress);
function bbcode($text){
$text=preg_replace(":smile:", '<img src=images/smiles/icon_smile.gif>',$text);
$text=preg_replace(":arrow:", '<img src=images/smiles/icon_arrow.gif>',$text);
$text=preg_replace(":biggrin:", '<img src=images/smiles/icon_biggrin.gif>',$text);
$text=preg_replace(":confused:", '<img src=images/smiles/icon_confused.gif>',$text);
$text=preg_replace(":cool:", '<img src=images/smiles/icon_cool.gif>',$text);
$text=preg_replace(":cry:", '<img src=images/smiles/icon_cry.gif>',$text);
$text=preg_replace(":eek:", '<img src=images/smiles/icon_eek.gif>',$text);
$text=preg_replace(":evil:", '<img src=images/smiles/icon_evil.gif>',$text);
$text=preg_replace(":exclaim:", '<img src=images/smiles/icon_exclaim.gif>',$text);
$text=preg_replace(":frown:", '<img src=images/smiles/icon_frown.gif>',$text);
$text=preg_replace(":idea:", '<img src=images/smiles/icon_idea.gif>',$text);
$text=preg_replace(":lol:", '<img src=images/smiles/icon_lol.gif>',$text);
$text=preg_replace(":mad:", '<img src=images/smiles/icon_mad.gif>',$text);
$text=preg_replace(":mrgreen:", '<img src=images/smiles/icon_mrgreen.gif>',$text);
$text=preg_replace(":neutral:", '<img src=images/smiles/icon_neutral.gif>',$text);
$text=preg_replace(":razz:", '<img src=images/smiles/icon_razz.gif>',$text);
$text=preg_replace(":redface:", '<img src=images/smiles/icon_redface.gif>',$text);
$text=preg_replace(":rolleyes:", '<img src=images/smiles/icon_rolleyes.gif>',$text);
$text=preg_replace(":sad:", '<img src=images/smiles/icon_sad.gif>',$text);
$text=preg_replace(":surprised:", '<img src=images/smiles/icon_surprised.gif>',$text);
$text=preg_replace(":twisted:", '<img src=images/smiles/icon_twisted.gif>',$text);
$text=preg_replace(":wink:", '<img src=images/smiles/icon_wink.gif>',$text);
$text = nl2br($text);
return $text;
}
?>
Надявам се да стане.
