<?php
$bot_data = db::get_string_all("SELECT `ID`,`BOT_GUESTBOOK_ONLINE` FROM `USERS` WHERE `BOT_GUESTBOOK` = ?", [1]);
while ($bot = $bot_data->fetch()) {
$bot_base = db::get_string_all("SELECT * FROM `GUESTBOOK_BOTS` WHERE `BOT_ID` = ?", [$bot['ID']]);
while ($blist = $bot_base->fetch()) {
if ($blist['JTIME'] < TM && str($blist['REPLY']) == 0) {
db::get_add("INSERT INTO `COMMENTS` (`USER_ID`, `OBJECT_TYPE`, `OBJECT_ID`, `TIME`, `MESSAGE`, `REPLY`, `REPLY_USER_ID`, `REPLY_USER`, `SUB_OBJECT_ID`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", [$blist['BOT_ID'], 'guestbook_comments', 0, (TM - 1), $blist['MESSAGE'], 0, 0, 0, 1]);
db::get_set("UPDATE `GUESTBOOK_BOTS` SET `JTIME` = ? WHERE `ID` = ? LIMIT 1", [(TM + $blist['SEC']), $blist['ID']]);
if ($bot['BOT_GUESTBOOK_ONLINE'] == 1) {
db::get_set("UPDATE `USERS` SET `DATE_VISIT` = ? WHERE `ID` = ? LIMIT 1", [TM, $bot['ID']]);
}
}
if (str($blist['REPLY']) > 0) {
$comments = db::get_string("SELECT `ID`,`USER_ID`,`TIME`,`MESSAGE`,`SUB_OBJECT_ID` FROM `COMMENTS` WHERE `OBJECT_TYPE` = ? AND `MESSAGE` LIKE ? AND `SUB_OBJECT_ID` != ? ORDER BY `TIME` DESC LIMIT 1", ['guestbook_comments', '%'.$blist['REPLY'].'%', 1]);
if (isset($comments['USER_ID']) && $comments['TIME'] < TM - 7 && $comments['SUB_OBJECT_ID'] != 2) {
db::get_add("INSERT INTO `COMMENTS` (`USER_ID`, `OBJECT_TYPE`, `OBJECT_ID`, `TIME`, `MESSAGE`, `REPLY`, `REPLY_USER_ID`, `REPLY_USER`, `SUB_OBJECT_ID`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", [$blist['BOT_ID'], 'guestbook_comments', 0, (TM - 1), '[b]'.user::login_mini($comments['USER_ID']).'[/b], '.$blist['MESSAGE'], 0, 0, 0, 1]);
db::get_set("UPDATE `COMMENTS` SET `SUB_OBJECT_ID` = ? WHERE `ID` = ? LIMIT 1", [2, $comments['ID']]);
if ($bot['BOT_GUESTBOOK_ONLINE'] == 1) {
db::get_set("UPDATE `USERS` SET `DATE_VISIT` = ? WHERE `ID` = ? LIMIT 1", [TM, $bot['ID']]);
}
}
}
}
}