public function createdb()
{
if (!$this->dropdb()) {
return false;
}
if (!$this->db->query(repository::sql())) {
return false;
}
if (!$this->db->query(package::sql())) {
return false;
}
if (!$this->db->query(filelist::sql())) {
return false;
}
if (!$this->db->query(guestbook::sql())) {
return false;
}
if (!$this->db->query("\n\t\t CREATE TABLE IF NOT EXISTS #__mixed (\n\t\t field VARCHAR( 255 ) NOT NULL ,\n value VARCHAR( 255 ) NULL ,\n PRIMARY KEY ( field )\n\t\t ) ENGINE = MyISAM;\n\t\t")) {
return false;
}
if (!$this->db->query("\n\t\t CREATE TABLE IF NOT EXISTS #__searches (\n\t\t dt DATETIME,\n\t\t sname VARCHAR(50),\n\t\t sdesc VARCHAR(50),\n\t\t sfile VARCHAR(50),\n\t\t ip VARCHAR(15),\n\t\t srepo INT,\n\t\t results INT,\n\t\t duration INT\n\t\t ) ENGINE = MyISAM;\n\t ")) {
return false;
}
$this->db->query("INSERT INTO #__mixed (field,value) value ('count_visits','1');");
$this->db->query("INSERT INTO #__mixed (field,value) value ('count_searches','1');");
$this->db->query("INSERT INTO #__mixed (field,value) value ('count_srctxt','1');");
$this->db->query("INSERT INTO #__mixed (field,value) value ('count_srcxml','1');");
return true;
}
/**
* Profile guestbook hook for phpBB.
*
* @author Paul Sohier <*****@*****.**>
* @param phpbb_hook $hook
* @return void
*/
function hook_profile_guestbook(&$hook)
{
global $template, $user;
// Make sure we only run this hook once, else we get the most weird errors :).
if (defined('HOOK_RUNNED')) {
return;
}
define('HOOK_RUNNED', true);
global $phpbb_root_path, $phpEx;
if (!class_exists('guestbook')) {
include "{$phpbb_root_path}includes/class_guestbook.{$phpEx}";
}
if (!defined('GUESTBOOK_TABLE')) {
include "{$phpbb_root_path}includes/constants_guestbook.{$phpEx}";
}
$gb = new guestbook();
$gb->run();
}
function display_entries()
{
global $GB_PG, $ModName;
include_once LAZ_INCLUDE_PATH . '/lib/gb.class.php';
$gb = new guestbook(LAZ_INCLUDE_PATH);
$GB_PG['base_url'] = $gb->db->VARS['base_url'];
$GB_PG['index'] = $gb->db->VARS['laz_url'] . '&op=modload&file=index';
$GB_PG['admin'] = $gb->db->VARS['base_url'] . '/admin.php';
$GB_PG['comment'] = $gb->db->VARS['laz_url'] . '&op=modload&file=index&agbook=comment';
$GB_PG['addentry'] = $gb->db->VARS['laz_url'] . '&op=modload&file=index&agbook=addentry';
$entry = isset($_GET['entry']) ? $_GET['entry'] : 0;
$entry = isset($_POST['entry']) ? $_POST['entry'] : $entry;
$entry = intval($entry) < 0 ? 0 : intval($entry);
$gb->searchfield = isset($_GET['searchfield']) ? trim($_GET['searchfield']) : '';
$gb->searchtext = isset($_GET['searchtext']) ? trim(urldecode($_GET['searchtext'])) : '';
$gb->searchfield = isset($_POST['searchfield']) ? trim($_POST['searchfield']) : $gb->searchfield;
$gb->searchtext = isset($_POST['searchtext']) ? trim(urldecode($_POST['searchtext'])) : $gb->searchtext;
echo $gb->show_entries($entry);
$gb->db->close_db();
}
public static function getInstance() {
if (!self::$me) {
$class=new guestbook();
self::$me=$class;
}
return self::$me;
}
<div class="c_item">
<div class="c_head"><strong>Администратор:</strong> <span class="c_info"><?php
echo system::show_data($obj->updated_at);
?>
</span></div>
<div class="c_content"><?php
echo $obj->answer;
?>
</div>
</div>
<?php
}
?>
</div>
<?php
}
?>
</div>
<?php
// pager
echo guestbook::count_guestbook() > GUESTBOOK_AT_PAGE ? pager::pager_J("guestbook", GUESTBOOK_AT_PAGE, guestbook::count_guestbook(), intval($_GET['page'])) : '';
?>
<?php
// добавление отзыва
echo system::show_tpl(array(), '/frontend/guestbook/add.php');
$gb_post->preview = isset($_POST["gb_preview"]) ? 1 : 0;
$gb_post->private = isset($_POST["gb_private"]) ? 1 : 0;
$gb_post->token = isset($_POST["gb_token"]) ? $_POST["gb_token"] : '';
$gb_post->gb_captcha = isset($_POST["gb_captcha"]) ? $_POST["gb_captcha"] : '';
echo $gb_post->process($_POST["gb_action"]);
} else {
echo $gb_post->process();
}
$gb_post->db->close_db();
break;
default:
require_once $include_path . "/lib/vars.class.php";
require_once $include_path . "/lib/gb.class.php";
$gb = new guestbook($include_path);
$entry = isset($_GET["entry"]) ? $_GET["entry"] : 0;
$entry = isset($_POST["entry"]) ? $_POST["entry"] : $entry;
echo $gb->show_entries(intval($entry));
$gb->db->close_db();
}
ob_end_flush();
$base_path = dirname(dirname($include_path));
chdir("{$base_path}");
include "{$base_path}/footer.php";
} else {
require_once $include_path . "/lib/vars.class.php";
require_once $include_path . "/lib/gb.class.php";
$gb = new guestbook($include_path);
$entry = isset($_GET["entry"]) ? $_GET["entry"] : 0;
$entry = isset($_POST["entry"]) ? $_POST["entry"] : $entry;
echo $gb->show_entries(intval($entry));
}
<script>
var wait=document.getElementById('wait1');
wait.style.color="white";
var wait=document.getElementById('wait2');
wait.style.color="white";
</script>
<?php
}
if ($newsearch) {
$db->addsearch($_SERVER["REMOTE_ADDR"], $name, $desc, $file, $repo, time(), $nres, $duration);
}
if (!($name or $desc or $file)) {
echo "<br><table width=100% style='border-top:1px dotted #000000;border-bottom:1px dotted #000000;'>";
echo "<tr>";
echo "<td width='50%'>";
$gb = new guestbook();
echo "<a href='gb.php'>Guest Book</a>: you can <a href='gb.php'>post comments</a>, suggests, bug/repository reports, or just your signature.<br><br>";
$mm = 5;
echo tables(array("", "", ""), 1, " class='gb' ");
echo tables(array("Date", "Nick", "Message"), 1, " class='gb' ");
while ($message = $gb->fetch() and $mm-- > 0) {
echo tables(array("<sup>{$message['date']}</sup>", "<font color='red'>" . $message['nick'] . "</font> ", "" . $message['message']));
}
echo tables();
echo "<a href='gb.php'>show all</a>";
echo "<nobr><form action='gb.php' method='post'><br>Nick: ";
echo "<input name=nick size=10 maxlenght=15 ";
if (isset($_SESSION['slakhomelinuxguestbooknick'])) {
echo "value='{$_SESSION['slakhomelinuxguestbooknick']}'";
}
echo "> -message: <br>";
***************************************************************************************/
global $_str;
// check for crack!
if (isset($_GET['page'])) {
system::count_parametr(4);
system::isset_numeric($_GET['page']);
} else {
system::count_parametr(3);
$_GET['page'] = 1;
}
// добавление новости
if (system::IsPost()) {
if (!captcha::check_captcha()) {
//выводим сообщение
Message::GetMessage(0, v::getI18n('message_error_captcha'));
} else {
// пишем в базу
Forms::MultyInsertForm('guestbook', 0);
// очищаем POST
unset($_POST);
// выводим мообщение
Message::GetMessage(1, v::getI18n('message_add_comment_to_guestbook'));
}
}
// check for count gallery at page
guestbook::count_guestbook_at_page();
// get limit
$limit = pager::pager_limit(guestbook::count_guestbook(), GUESTBOOK_AT_PAGE);
// выводим
$_str .= guestbook::get_guestbook($limit, '/frontend/guestbook/list.php');
$_str = array('_str' => $_str, 'title' => $title->get_title(), 'keywords' => $title->get_keywords(), 'description' => $title->get_description(), 'h1' => $title->get_h1());
<?php
$moduleid = 3;
require 'common.inc.php';
$need_captcha = $MOD['guestbook_captcha'] ? 1 : 0;
if (isset($_POST['ok'])) {
$captcha = isset($captcha) ? convert(input_trim($captcha), 'UTF-8', DT_CHARSET) : '';
$msg = captcha($captcha, $need_captcha, true);
if ($msg) {
exit('captcha');
}
$TYPE = explode('|', trim($MOD['guestbook_type']));
require DT_ROOT . '/include/post.func.php';
require DT_ROOT . '/module/extend/guestbook.class.php';
$do = new guestbook();
$post = array();
$content = convert($content, 'UTF-8', DT_CHARSET);
$post['content'] = $content . "\n" . $L['guestbook_from'] . "\n" . $L['guestbook_info'] . $_SERVER['HTTP_USER_AGENT'];
if ($do->pass($post)) {
$post['type'] = '';
if ($_userid) {
$user = userinfo($_username);
$post['truename'] = $user['truename'];
$post['telephone'] = $user['telephone'] ? $user['telephone'] : $user['mobile'];
$post['email'] = $user['mail'] ? $user['mail'] : $user['email'];
$post['qq'] = $user['qq'];
$post['msn'] = $user['msn'];
$post['ali'] = $user['ali'];
$post['skype'] = $user['skype'];
}
$do->add($post);
<?php
defined('IN_DESTOON') or exit('Access Denied');
require MD_ROOT . '/guestbook.class.php';
$do = new guestbook();
$menus = array(array('留言列表', '?moduleid=' . $moduleid . '&file=' . $file), array('模块设置', '?moduleid=' . $moduleid . '&file=setting#' . $file));
if ($_catids || $_areaids) {
require DT_ROOT . '/admin/admin_check.inc.php';
}
if (in_array($action, array('', 'check'))) {
$sfields = array('按条件', '留言标题', '会员名', '联系人', '联系电话', '电子邮件', 'QQ', '阿里旺旺', 'MSN', 'Skype', '留言IP', '留言内容', '回复内容');
$dfields = array('title', 'title', 'username', 'truename', 'telephone', 'email', 'qq', 'ali', 'msn', 'skype', 'ip', 'content', 'reply');
$sorder = array('结果排序方式', '留言时间降序', '留言时间升序', '回复时间降序', '回复时间升序');
$dorder = array('itemid DESC', 'addtime DESC', 'addtime ASC', 'edittime DESC', 'edittime ASC');
isset($fields) && isset($dfields[$fields]) or $fields = 0;
isset($order) && isset($dorder[$order]) or $order = 0;
$fields_select = dselect($sfields, 'fields', '', $fields);
$order_select = dselect($sorder, 'order', '', $order);
$condition = '1';
if ($_areaids) {
$condition .= " AND areaid IN (" . $_areaids . ")";
}
//CITY
if ($keyword) {
$condition .= " AND {$dfields[$fields]} LIKE '%{$keyword}%'";
}
if ($areaid) {
$condition .= $ARE['child'] ? " AND areaid IN (" . $ARE['arrchildid'] . ")" : " AND areaid={$areaid}";
}
}
switch ($action) {
<?php
defined('IN_DESTOON') or exit('Access Denied');
require DT_ROOT . '/module/' . $module . '/common.inc.php';
$MOD['guestbook_enable'] or dheader(DT_PATH);
$TYPE = explode('|', trim($MOD['guestbook_type']));
require DT_ROOT . '/include/post.func.php';
require MD_ROOT . '/guestbook.class.php';
$do = new guestbook();
$destoon_task = rand_task();
if ($submit) {
captcha($captcha, $MOD['guestbook_captcha']);
if ($do->pass($post)) {
$post['areaid'] = $cityid;
$do->add($post);
message($L['gbook_success'], $EXT['guestbook_url']);
} else {
message($do->errmsg);
}
} else {
$type = '';
$condition = "status=3 AND reply<>''";
if ($keyword) {
$condition .= " AND content LIKE '%{$keyword}%'";
}
if ($cityid) {
$condition .= $AREA[$cityid]['child'] ? " AND areaid IN (" . $AREA[$cityid]['arrchildid'] . ")" : " AND areaid={$cityid}";
}
$lists = $do->get_list($condition);
$head_title = $L['gbook_title'];
$content = isset($content) ? dhtmlspecialchars(stripslashes($content)) : '';
<br>message:
<textarea name=message cols=70 rows=3></textarea>
<input type=submit><br></form>
<a href='gb.php'>Reload</a> <?php
if (isset($_POST['message'])) {
if (isset($_SESSION['slakhomelinuxguestbookmsg'])) {
if ($_SESSION['slakhomelinuxguestbookmsg'] == $_POST['message']) {
$gb = new guestbook();
} else {
$_SESSION['slakhomelinuxguestbookmsg'] = $_POST['message'];
$gb = new guestbook($_POST['message'], $_SESSION['slakhomelinuxguestbooknick']);
}
} else {
$_SESSION['slakhomelinuxguestbookmsg'] = $_POST['message'];
$gb = new guestbook($_POST['message'], $_SESSION['slakhomelinuxguestbooknick']);
}
} else {
$gb = new guestbook();
}
echo "<br><br>";
echo tables(array("", "", ""), 1, " class='gb' ");
//echo tables(array("Date","Nick","Message"),1," class='gb' ");
while ($message = $gb->fetch()) {
echo tables(array("<sup>{$message['date']}</sup>", "<font color='red'>" . $message['nick'] . "</font>", $message['message']));
}
echo tables();
echo "</pre>";
?>
</body>
</html>
