Hi, Khách!
![]() | ![]() ![]() ![]() ![]() |
1. Nhập data sau vào CSDL:
--
-- Table structure for table `forum_thank`
--
DROP TABLE IF EXISTS `forum_thank`;
CREATE TABLE `forum_thank` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`topic` int(11) NOT NULL,
`userthank` int(11) NOT NULL,
`chude` int(11) NOT NULL,
`time` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Copy code
-- Table structure for table `forum_thank`
--
DROP TABLE IF EXISTS `forum_thank`;
CREATE TABLE `forum_thank` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`topic` int(11) NOT NULL,
`userthank` int(11) NOT NULL,
`chude` int(11) NOT NULL,
`time` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Copy code
và
ALTER TABLE `users` ADD `thank_di` VARCHAR( 100 ) NOT NULL;
ALTER TABLE `users` ADD `thank_duoc` VARCHAR( 100 ) NOT NULL;
ALTER TABLE `users` ADD `thank` VARCHAR( 100 ) NOT NULL;
ALTER TABLE `users` ADD `unthank` VARCHAR( 100 ) NOT NULL;
Copy code
ALTER TABLE `users` ADD `thank_duoc` VARCHAR( 100 ) NOT NULL;
ALTER TABLE `users` ADD `thank` VARCHAR( 100 ) NOT NULL;
ALTER TABLE `users` ADD `unthank` VARCHAR( 100 ) NOT NULL;
Copy code
2. Mở forum/index.php tìm:
<?php
// Если тема помечена для удаления, разрешаем доступ только администрации
if ($rights < 6 && $type1['close' == 1) {
echo '<div class="rmenu"><p>' . $lng_forum['topic_deleted' . '<br /><a href="?id=' . $type1['refid' . '">' . $lng_forum['to_section' . '</a></p></div>';
require('../incfiles/end.php');
exit;
}
?>
Copy code
// Если тема помечена для удаления, разрешаем доступ только администрации
if ($rights < 6 && $type1['close' == 1) {
echo '<div class="rmenu"><p>' . $lng_forum['topic_deleted' . '<br /><a href="?id=' . $type1['refid' . '">' . $lng_forum['to_section' . '</a></p></div>';
require('../incfiles/end.php');
exit;
}
?>
Copy code
Thêm đoạn code sau vào ngay bên dưới code vừa tìm được:
<?php
##############Thanks submit đê
$checkthankdau = mysql_query('SELECT COUNT(*) FROM `forum_thank` WHERE `userthank` = "' . $user_id . '" and `topic` = "' . $_GET['thanks' . '" and `user` = "' . $_GET['user' . '"');
if ($user_id && $user_id != $_GET['user' && (mysql_result($checkthankdau, 0) < 1)) {
if ((isset ($_GET['thank'))&&(isset ($_GET['user'))&&(isset ($_GET['thanks'))) {
echo '<div class="rmenu" id="thanksyou"><b>Bạn đã cảm ơn bài viết thành công.Cảm ơn bạn.</b></div>';
mysql_query("INSERT INTO `forum_thank` SET
`user` = '".trim($_GET['user')."',
`topic` = '".trim($_GET['thanks')."' ,
`time` = '$realtime',
`userthank` = '$user_id',
`chude` = '".$_GET["id"."'
");
$congcamon=mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id` = "' . trim($_GET['user') . '"'));
mysql_query("UPDATE `users` SET `thank_duoc`='" . ($congcamon['thank_duoc' + 1) . "' WHERE `id` = '" . trim($_GET['user') . "'");
mysql_query("UPDATE `users` SET `thank_di`='" . ($datauser['thank_di' + 1) . "' WHERE `id` = '" . $user_id . "'");
}
}
///hết phần thANKS//
?>
Copy code
##############Thanks submit đê
$checkthankdau = mysql_query('SELECT COUNT(*) FROM `forum_thank` WHERE `userthank` = "' . $user_id . '" and `topic` = "' . $_GET['thanks' . '" and `user` = "' . $_GET['user' . '"');
if ($user_id && $user_id != $_GET['user' && (mysql_result($checkthankdau, 0) < 1)) {
if ((isset ($_GET['thank'))&&(isset ($_GET['user'))&&(isset ($_GET['thanks'))) {
echo '<div class="rmenu" id="thanksyou"><b>Bạn đã cảm ơn bài viết thành công.Cảm ơn bạn.</b></div>';
mysql_query("INSERT INTO `forum_thank` SET
`user` = '".trim($_GET['user')."',
`topic` = '".trim($_GET['thanks')."' ,
`time` = '$realtime',
`userthank` = '$user_id',
`chude` = '".$_GET["id"."'
");
$congcamon=mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id` = "' . trim($_GET['user') . '"'));
mysql_query("UPDATE `users` SET `thank_duoc`='" . ($congcamon['thank_duoc' + 1) . "' WHERE `id` = '" . trim($_GET['user') . "'");
mysql_query("UPDATE `users` SET `thank_di`='" . ($datauser['thank_di' + 1) . "' WHERE `id` = '" . $user_id . "'");
}
}
///hết phần thANKS//
?>
Copy code
3. Thống kê like:
thêm và chỗ thích hợp
<?php
/////////////
#############Thống kê số người thanks
$thongkethank = mysql_query("SELECT COUNT(*) from `forum_thank` where `topic`='" . $res["id" . "'");
$thongkethanks = mysql_result($thongkethank, 0);
// $thongkethanks=mysql_result(mysql_query('SELECT COUNT(*) FROM `forum_thank` WHERE `topic` = "' . $res['id' . '"')), 0);
$thongkea= @mysql_query("select * from `forum_thank` where `topic` = '" . $res['id' . "'");
$thongke=mysql_fetch_array($thongkea);
$idthongke=trim($_GET['idthongke');
if($thongkethanks>0&&(empty($_GET['idthongke')))
{echo'<div id="'.$idthongke.'" class="func"><font color="red"><img src="/images/likes.png" title="Thống Kê Like"/> <b>'.$thongkethanks.'</b></font>:';
$thongkeaa= @mysql_query("select * from `forum_thank` where `topic` = '" . $res['id' . "'");
while ($thongkea = mysql_fetch_array($thongkeaa))
{
{
$dentv=mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id` = "'.$thongkea['userthank'.'"'));
echo '<a href="/users/profile.php?user='.$thongkea['userthank'.'">'.nick($dentv['id').'</a>, ';
}
++$f;
}
echo'</div>';}
####### xong thống kê thanhk//
?>
Copy code
/////////////
#############Thống kê số người thanks
$thongkethank = mysql_query("SELECT COUNT(*) from `forum_thank` where `topic`='" . $res["id" . "'");
$thongkethanks = mysql_result($thongkethank, 0);
// $thongkethanks=mysql_result(mysql_query('SELECT COUNT(*) FROM `forum_thank` WHERE `topic` = "' . $res['id' . '"')), 0);
$thongkea= @mysql_query("select * from `forum_thank` where `topic` = '" . $res['id' . "'");
$thongke=mysql_fetch_array($thongkea);
$idthongke=trim($_GET['idthongke');
if($thongkethanks>0&&(empty($_GET['idthongke')))
{echo'<div id="'.$idthongke.'" class="func"><font color="red"><img src="/images/likes.png" title="Thống Kê Like"/> <b>'.$thongkethanks.'</b></font>:';
$thongkeaa= @mysql_query("select * from `forum_thank` where `topic` = '" . $res['id' . "'");
while ($thongkea = mysql_fetch_array($thongkeaa))
{
{
$dentv=mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id` = "'.$thongkea['userthank'.'"'));
echo '<a href="/users/profile.php?user='.$thongkea['userthank'.'">'.nick($dentv['id').'</a>, ';
}
++$f;
}
echo'</div>';}
####### xong thống kê thanhk//
?>
Copy code
4. Nút like:
Thêm vào chỗ thích hợp.
<?php
//Nút thank
$checkthank = mysql_query('SELECT COUNT(*) FROM `forum_thank` WHERE `userthank` = "' . $user_id . '" and `topic` = "' . $res['id' . '" and `user` = "' . $res['user_id' . '"');
if ($user_id && $user_id != $res['user_id' && (mysql_result($checkthank, 0) < 1)) {
echo '<table width="100%" cellpadding="0" cellspacing="0"><tr><td width="auto" align="right"><a href="index.php?id=' . $id . '&thanks=' . $res['id' . '&user=' . $res['user_id' . '&start=' . $start . '&thank#thanksyou" id="btn" title="Cảm ơn bài viết của nick ' .($res['user_id'). '">Thanks';
echo '</a> ';
}
echo (mysql_result($checkthank, 0) == 1 ? '<table width="100%" cellpadding="0" cellspacing="0"><tr><td width="auto" align="right"><a href="index.php?id=' . $id . '&unthanks=' . $res['id' . '&user=' . $res['user_id' . '&start=' . $start . '&unthank" id="btn" title="Không thích bài viết của ' .$res['from'. '">Dislike!</a> ' : ' ');
echo '</td></tr></table>';
echo '</td></tr></table>';
?>
Copy code
//Nút thank
$checkthank = mysql_query('SELECT COUNT(*) FROM `forum_thank` WHERE `userthank` = "' . $user_id . '" and `topic` = "' . $res['id' . '" and `user` = "' . $res['user_id' . '"');
if ($user_id && $user_id != $res['user_id' && (mysql_result($checkthank, 0) < 1)) {
echo '<table width="100%" cellpadding="0" cellspacing="0"><tr><td width="auto" align="right"><a href="index.php?id=' . $id . '&thanks=' . $res['id' . '&user=' . $res['user_id' . '&start=' . $start . '&thank#thanksyou" id="btn" title="Cảm ơn bài viết của nick ' .($res['user_id'). '">Thanks';
echo '</a> ';
}
echo (mysql_result($checkthank, 0) == 1 ? '<table width="100%" cellpadding="0" cellspacing="0"><tr><td width="auto" align="right"><a href="index.php?id=' . $id . '&unthanks=' . $res['id' . '&user=' . $res['user_id' . '&start=' . $start . '&unthank" id="btn" title="Không thích bài viết của ' .$res['from'. '">Dislike!</a> ' : ' ');
echo '</td></tr></table>';
echo '</td></tr></table>';
?>
Copy code
done!
Chỉnh sửa lúc 2016-05-10 18:28 bởi Pham_loi

Trực Tuyến:
Khách: 1