/** * параметры: * $product_id Ц идентификатор товара * $count Ц количество добавл¤емого товара, по умолчанию 1, */ function add_to_cart($product_id, $count = 1) { $db = new DB(); //провер¤ем, не был ли добавлен товар в корзину ранее: if (!empty($_SESSION['products'][$product_id])) { //увеличиваем количество на единицу, если товар уже добавлен: $_SESSION['products'][$product_id]['count']++; } else { //создаем пустой массив, на вс¤кий случай, можно и без него. $_SESSION['products'][$product_id] = array(); //извлекаем цену товара из базы данных: $q = "SELECT ID FROM catalog WHERE id='{$product_id}'"; //разбиваем результат запроса в массив: $add_product = $db->fetch_assoc($db->query($q)); //можно и так, если не умеем работать с объектами: //$add_product=mysql_fetch_assoc(mysql_query($q)); //добавл¤ем товар в корзину: $_SESSION['products'][$product_id]['coast'] = $add_product['price']; $_SESSION['products'][$product_id]['count'] = $count; } /* вызываем функции дл¤ подсчета стоимости корзины и количества товаров. здесь ¤ оп¤ть внесу изменение, будем считать не количество товаров в корзине, а количество самих товаров, т.е. если в корзине 5 единиц товара 1, и 2 Ц товара 2, то товаров в корзине Ц 2, а не 7. » еще один момент, лучше всего объединить в одну функцию подсчет суммы корзины и количества товаров в ней: update_cart() */ update_cart(); }
static function Send($title, $message_text, $reciver, $is_system = 2) { if (!is_numeric($reciver)) { return; } $title = TextSave($title); $message_text = TextSave($message_text, 2); $db = new DB(); $db->connect("PM"); $Row = $db->fetch_assoc($db->execute("SELECT `login` FROM `users` WHERE `id` = '{$reciver}'")); if (empty($Row['login'])) { return; } if ($is_system == 2) { global $player; //AuthReset(); $sender = $player['id']; } else { $sender = 0; } $db->execute("INSERT INTO `pm` (`title`,`message`,`reciver`,`sender`,`time`) VALUES ('{$title}','{$message_text}','{$reciver}'," . $sender . "," . time() . ")"); $db->close(); }
MessageSend(3, 'Сообщение отправлено!'); } else { if (isset($_GET['id']) && is_numeric($_GET['id'])) { $reciver = IDToLogin($_GET['id']); } else { $reciver = ""; } ob_start(); include SITE_ROOT . 'style/pm/send.html'; $content_main = ob_get_clean(); } } elseif (isset($_GET['do']) && $_GET['do'] == "view" && isset($_GET['id'])) { $id = (int) $_GET['id']; $db = new DB(); $db->connect(); $Row = $db->fetch_assoc($db->execute("SELECT * FROM `pm` WHERE `id` = {$id}")); if (empty($Row['id']) or $Row['reciver'] != $player['id']) { $db->close(); exit(header("Location: /pm/")); } $db->execute("UPDATE `pm` SET `readed` = '2' WHERE `id` = '{$id}'"); $db->close(); ob_start(); include SITE_ROOT . 'style/pm/see.html'; $content_main = ob_get_clean(); } else { $pm_on_page = 10; $db = new DB(); $db->connect(); $pm_count = $db->fetch_array($db->execute("SELECT COUNT(id) FROM `pm`")); $total = ceil($pm_count[0] / $pm_on_page);
/** * count voters for all ballots */ private function update_voters_cache() { $sql = "SELECT id FROM ballot WHERE period=".intval($this->id); $result = DB::query($sql); while ( $row = DB::fetch_assoc($result) ) { $sql = "SELECT COUNT(1) FROM offlinevoter WHERE ballot=".intval($row['id']); $count = DB::fetchfield($sql); $sql = "UPDATE ballot SET voters=".intval($count)." WHERE id=".intval($row['id']); DB::query($sql); } }
$referals .= '<a href="/profile/' . $data['id'] . '/">' . $data['login'] . '</a>, '; } } if ($referals != 'Нету') { $referals = rtrim($referals, ", ") . '.'; } $user = array('id' => $Row['id'], 'login' => $Row['login'], 'group' => $Row['group'], 'reg_date' => $Row['reg_date'], 'last_online' => $Row['last_online']); $title = $user['login']; $my_profile = false; $referal_html = ''; } else { Access(1); $db = new DB(); $db->connect("MY-PROFILE"); $referals_cache = $db->execute("SELECT `id`,`login` FROM `users` WHERE `referal` = '" . $player['id'] . "'"); $HiTechOT = $db->fetch_assoc($db->execute("SELECT `onlinetime` FROM `playtime` WHERE `username` = '" . $player['login'] . "'")); if (empty($HiTechOT['onlinetime'])) { $HT_TotalTime = "0 мин."; } else { $HT_TotalTime = $HiTechOT['onlinetime'] . ' мин.'; } $db->close(); $referals = 'Нету'; while ($data = $db->fetch_assoc($referals_cache)) { if ($referals == 'Нету') { $referals = '<a href="/profile/' . $data['id'] . '/">' . $data['login'] . '</a>, '; } else { $referals .= '<a href="/profile/' . $data['id'] . '/">' . $data['login'] . '</a>, '; } } if ($referals != 'Нету') {
/** * get the current notification settings * * @return array */ public function notification_settings() { $notify = Notification::$default_settings; $sql = "SELECT * FROM notify WHERE member=".intval($this->id); $result = DB::query($sql); while ( $row = DB::fetch_assoc($result) ) { foreach (Notification::$default_settings['all'] as $type => $dummy) DB::to_bool($row[$type]); $notify[$row['interest']] = $row; } return $notify; }
function LoginToId($login) { $login = $login; $db = new DB(); $db->connect("LOGINTOID"); $Row = $db->fetch_assoc($db->execute("SELECT `id` FROM `users` WHERE `login` = '{$login}'")); if (empty($Row['id'])) { $id = '0'; } else { $id = $Row['id']; } return $id; }
</th> <? } ?> </tr> <? if ($entitled) { $sql = "SELECT area.*, participant.activated FROM area LEFT JOIN participant ON area.id = participant.area AND participant.member=".intval(Login::$member->id); } else { $sql = "SELECT area.* FROM area"; } $sql .= " WHERE ngroup = ".intval($ngroup->id)." ORDER BY area.name, area.id"; $result = DB::query($sql); while ($row = DB::fetch_assoc($result)) { ?> <tr class="<?php echo stripes(); ?> "> <td><?php echo $row['name']; ?> </td> <td class="center"><?php echo $row['participants']; ?> </td> <? if ($entitled) { ?>
} if ($Row['Item_id'] == 'premium') { $db->execute("UPDATE `users` SET `group` = '4' WHERE `id` = '" . $player['id'] . "'"); } } elseif ($Row['type'] == 1) { $db->execute("INSERT INTO `shopcart` (`type`,`item`,`player`,`amount`,`server`) VALUES ('item','" . $Row['Item_id'] . "','" . $player['login'] . "',1,1)"); } $db->execute("UPDATE `money` SET `realmoney` = `realmoney` - '" . $Row['price'] . "' WHERE `username` = '" . $player['login'] . "'"); $db->close(); PM::SEND('Магазин', 'Товар ' . $Row['name'] . ', за ' . $Row['price'] . 'р. успешно приобретён!', $player['id'], 2); MessageSend(3, 'Товар успешно приобретён!'); } else { $ID = (int) $_GET['buy']; $db = new DB(); $db->connect(); $Row = $db->fetch_assoc($db->execute("SELECT * FROM `shop` WHERE `id` = '{$ID}'")); $db->close(); if (empty($Row['id'])) { MessageSend(1, 'Товар не найден!'); } ob_start(); include SITE_ROOT . 'style/shop/buy.html'; $content_main = ob_get_clean(); } } else { $db = new DB(); $db->connect(); $items_on_page = 20; $items_count = $db->fetch_array($db->execute("SELECT COUNT(id) FROM `shop`")); $total = ceil($items_count[0] / $items_on_page); if (empty($_GET['p'])) {
<?php require $_SERVER['DOCUMENT_ROOT'] . '/system.php'; if ($_POST['LMI_PREREQUEST'] == 1) { if ($_POST['LMI_PAYEE_PURSE'] == 'R317832667477') { echo 'YES'; } } else { $key = $_POST['LMI_PAYEE_PURSE'] . $_POST['LMI_PAYMENT_AMOUNT'] . $_POST['LMI_PAYMENT_NO'] . $_POST['LMI_MODE'] . $_POST['LMI_SYS_INVS_NO'] . $_POST['LMI_SYS_TRANS_NO'] . $_POST['LMI_SYS_TRANS_DATE'] . 'd61v5CU80M7toDxZP38M2JXv5V3YD8' . $_POST['LMI_PAYER_PURSE'] . $_POST['LMI_PAYER_WM']; if (strtoupper(hash('sha256', $key)) != $_POST['LMI_HASH']) { exit('DDD'); } /////// $ID = TextSave($_POST['SUID']); AuthReset(); $db = new DB(); $db->connect("WebMoneyPayment"); if ($_SESSION['USER_LOGGED'] == false) { $Row = $db->fetch_assoc($db->execute("SELECT `id` FROM `users` WHERE `id` = '{$ID}'")); if (!empty($Row['id'])) { $amount = $_POST['LMI_PAYMENT_AMOUNT']; $db->execute("INSERT INTO `money_log` (`user_id`,`amount`,`payer`,`date`) VALUES ('{$ID}',{$amount},'WebMoney','" . time() . "')"); $db->execute("UPDATE `money` SET `realmoney` = `realmoney` + " . $_POST['LMI_PAYMENT_AMOUNT'] . " WHERE `id` = '{$ID}'"); } } else { if ($player['id'] != $ID) { $ID = $player['id']; } } $db->close(); }
$_SESSION['RESET_PASSWORD'] = '******'; $_SESSION['RESET_USER'] = $code[0]; $db->close(); ob_start(); include SITE_ROOT . 'style/reset-password_input_new.html'; $content_main = ob_get_clean(); } elseif (isset($_POST['submit-new-pass']) && isset($_POST['newpass'])) { if (isset($_SESSION['RESET_PASSWORD']) && $_SESSION['RESET_PASSWORD'] == 'YES') { $password = TextSave($_POST['newpass']); if (empty($password) or !preg_match("/^[a-zA-Z0-9_-]+\$/", $password) or strlen($password) > 30 or strlen($password) < 5) { ob_start(); include SITE_ROOT . 'style/reset-password.html'; $content_main = ob_get_clean(); } else { $db = new DB(); $db->connect(); $password = ToPass($password); $Row = $db->fetch_assoc($db->execute("SELECT `reset-pass` FROM `users` WHERE `id` = '" . $_SESSION['RESET_USER'] . "'")); $db->execute("UPDATE `users` SET `passw` = '{$password}',`reset-pass` = 'NULL' WHERE `id` = '" . $_SESSION['RESET_USER'] . "'"); unset($_SESSION['RESET_PASSWORD']); unset($_SESSION['RESET_USER']); MessageSend(3, 'Пароль успешно изменён!', '/'); } } else { MessageSend(1, 'Ошибка! [3]', '/reset-pass/'); } } else { ob_start(); include SITE_ROOT . 'style/reset-password.html'; $content_main = ob_get_clean(); }
if (!empty($Row['streamer'])) { $db->close(); MessageSend(1, 'Возможно создать только 1 стрим!'); } $db->execute("INSERT INTO `streams` (`streamer`,`title`,`about`,`creator`) VALUES ('{$streamStreamer}','{$streamTitle}','{$streamAbout}','" . $player['id'] . "')"); $db->close(); MessageSend(3, 'Вы успешно добавили свой стрим!', '/streams/'); } ob_start(); include SITE_ROOT . 'style/streams/stream_add.html'; $content_main = ob_get_clean(); } elseif (isset($_GET['view'])) { $db = new DB(); $db->connect("STREAMS_VIEW"); $streamer = (int) TextSave($_GET['view']); $Row = $db->fetch_assoc($db->execute("SELECT * FROM `streams` WHERE `creator` = '{$streamer}'")); $db->close(); if (empty($Row['streamer'])) { MessageSend(1, 'Стрим не найден!', '/streams/'); } if ($Row['creator'] != $player['id'] && $Row['status'] == 1) { if ($player['group'] < 16) { MessageSend(1, 'Стрим на модерации!', '/streams/'); } } ob_start(); include SITE_ROOT . 'style/streams/stream_view.html'; $content_main = ob_get_clean(); } else { $db = new DB(); $db->connect("STREAMS_LIST");
} $db->execute("UPDATE `streams` SET `title` = '{$stream_title}', `about` = '{$stream_about}' WHERE `id` = '{$streamID}'"); if (isset($_REQUEST['stream-blocked'])) { $db->execute("UPDATE `streams` SET `status` = '5' WHERE `id` = '{$streamID}'"); } $db->close(); Log::Write(UserGroup($player['group']) . " " . $player['login'] . ", изменил стрим #" . $Row['streamID']); MessageSend(3, 'Изменения сохранены!'); } elseif (isset($_GET['stream_id'])) { $stream_id = (int) $_GET['stream_id']; if (empty($stream_id)) { MessageSend(1, 'Стрим не найден!'); } $db = new DB(); $db->connect(); $Row = $db->fetch_assoc($db->execute("SELECT * FROM `streams` WHERE `id` = '{$stream_id}'")); $db->close(); if (empty($Row['id'])) { MessageSend(1, 'Стрим не найден!'); } ob_start(); include SITE_ROOT . 'style/admin/streams/edit.html'; $content_main = ob_get_clean(); } else { MessageSend(1, 'Стрим не найден!'); } } else { $streams_on_page = 22; $db = new DB(); $db->connect(); $streams_count = $db->fetch_array($db->execute("SELECT COUNT(creator) FROM `streams`"));
/** * make lists of supporters and proponents and find out if the logged in member is supporter or proponent * * @return array */ public function supporters() { $supporters = array(); // list of supporters as strings $proponents = array(); // list of proponents (also unconfirmed) as objects of class member $is_supporter = false; // if the logged in member is supporter $is_proponent = false; // if the logged in member is confirmed proponent $is_valid = false; // if the logged in member is valid supporter $sql = "SELECT member, anonymous, proponent, proponent_confirmed, ".$this->sql_supporter_valid()." AS valid FROM supporter WHERE proposal=".intval($this->id); $result = DB::query($sql); while ( $row = DB::fetch_assoc($result) ) { DB::to_bool($row['proponent_confirmed']); DB::to_bool($row['valid']); $expired = $row['valid'] ? "" : " expired"; $member = new Member($row['member']); if (Login::$member and $member->id==Login::$member->id) { if ($row['proponent_confirmed']) { $is_proponent = true; $is_supporter = true; $supporters[] = '<span class="self'.$expired.'">'.content2html($row['proponent']).' <i>('._("proponent").')</i></span>'; } elseif ($row['anonymous']===DB::value_true) { $is_supporter = "anonymous"; $supporters[] = '<span class="self'.$expired.'">'._("anonymous").'</span>'; } else { $is_supporter = true; $supporters[] = '<span class="self'.$expired.'">'.$member->link().'</span>'; } $is_valid = $row['valid']; } else { if ($row['proponent_confirmed']) { if ($row['valid']) $supporters[] = $row['proponent'].' <i>('._("proponent").')</i>'; else $supporters[] = '<span class="expired">'.content2html($row['proponent']).' <i>('._("proponent").')</i></span>'; } elseif ($row['anonymous']===DB::value_true) { if ($row['valid']) $supporters[] = _("anonymous"); else $supporters[] = '<span class="expired">'._("anonymous").'</span>'; } else { if ($row['valid']) $supporters[] = $member->link(); else $supporters[] = '<span class="expired">'.$member->link().'</span>'; } } if ($row['proponent']!==null) { $member->proponent_name = $row['proponent']; $member->proponent_confirmed = $row['proponent_confirmed']; $proponents[] = $member; } } return array($supporters, $proponents, $is_supporter, $is_proponent, $is_valid); }
} if (strlen($pass) < 5) { MessageSend(1, 'Пароль должен содержать не менее 5 символов.', '/register/'); } if (empty($email)) { MessageSend(1, 'E-Mail слишком короткий или он не введён!'); } if (!preg_match("/^[a-zA-Z0-9_-]+\$/", $login)) { MessageSend(1, 'Логин может содержать только английские буквы/цифры, и некоторые символы!', '/register/'); } if (!preg_match("/^[a-zA-Z0-9_-]+\$/", $pass)) { MessageSend(1, 'Пароль может содержать только английские буквы/цифры!', '/register/'); } $db = new DB(); $db->connect("REGISTER"); $Row = $db->fetch_assoc($db->execute("SELECT `login`,`email` FROM `users` WHERE `login` = '{$login}'")); if (!empty($Row['login'])) { $db->close(); MessageSend(1, 'Пользователь с введенным Логином уже зарегистрирован!'); } /* if(!empty($Row['email'])){ $db->close(); MessageSend(1,'Пользователь с введенным Эл. Адресом уже зарегистрирован!'); }*/ $Row = $db->fetch_assoc($db->execute("SELECT `login`,`email` FROM `users` WHERE `email` = '{$email}'")); /*if(!empty($Row['login'])){ $db->close(); MessageSend(1,'Пользователь с введенным Логином уже зарегистрирован!'); }*/ if (!empty($Row['email'])) {
/** * avoid more than one execution of cron() at the same time * * @return boolean */ function cron_lock() { $pid = getmypid(); $ps = explode(PHP_EOL, `ps -e | awk '{print $1}'`); DB::transaction_start(); $result = DB::query("SELECT pid FROM cron_lock"); if ( $row = DB::fetch_assoc($result) ) { // check if process is still running if (in_array($row['pid'], $ps)) { DB::transaction_commit(); return false; } // remove lock for no longer running process cron_unlock(); } DB::query("INSERT INTO cron_lock (pid) VALUES (".intval($pid).")"); DB::transaction_commit(); return true; }
<?php if (isset($_GET['news_id'])) { $id = TextSave($_GET['news_id']); if (!is_numeric($id)) { MessageSend(1, 'ID новости должен быть числом!', '/'); } if (empty($id)) { MessageSend(1, 'Новость не найдена!', '/'); } $db = new DB(); $db->connect(); $result = $db->fetch_assoc($db->execute("SELECT * FROM `news` WHERE `id` = '{$id}'")); $db->close(); if (empty($result['id'])) { MessageSend(1, 'Новость не найдена!'); } $title = $result['title']; ob_start(); include SITE_ROOT . 'style/news/full.html'; $content_main = ob_get_clean(); } else { $title = 'Новости'; $menu_id = 'main'; $news_on_page = 6; $db = new DB(); $db->connect(); $news_count = $db->fetch_array($db->execute("SELECT COUNT(id) FROM `news`")); $total = ceil($news_count[0] / $news_on_page); if (empty($_GET['p'])) { $_GET['p'] = '1';
} } else { $percent = 0; } $conv_utf8 = false; $complete_utf8 = true; $config_table = "glpi_config"; if (TableExists("glpi_configs")) { $config_table = "glpi_configs"; } if (!FieldExists($config_table, "utf8_conv", false)) { $conv_utf8 = true; } else { $query = "SELECT `utf8_conv`\n FROM `{$config_table}`\n WHERE `id` = '1'"; $result = $DB->query($query); $data = $DB->fetch_assoc($result); if ($data["utf8_conv"]) { $complete_utf8 = false; } } if ($offsettable >= 0 && $complete_utf8) { if ($percent >= 0) { Html::displayProgressBar(400, $percent); echo "</div></div></body></html>"; Html::glpi_flush(); } if (UpdateContent($DB, $duree, $rowlimit, $conv_utf8, $complete_utf8)) { echo "<br><a href='update_content.php?dump=1&duree={$duree}&rowlimit=" . "{$rowlimit}&offsetrow={$offsetrow}&offsettable={$offsettable}&cpt={$cpt}'>" . __('Automatic redirection, else click') . "</a>"; echo "<script language='javascript' type='text/javascript'>\n window.location=\"update_content.php?dump=1&duree={$duree}&rowlimit={$rowlimit}&offsetrow=" . "{$offsetrow}&offsettable={$offsettable}&cpt={$cpt}\";</script>"; Html::glpi_flush(); exit;
/** * display a list of voting mode votes * * @param resource $result * @param string $token (optional) token of the logged in member for highlighting */ public static function display_votingmode_votes($result, $token="") { ?> <table class="votes"> <tr><th><?=_("Vote token")?></th><th><?=_("Voting time")?></th><th><?=_("Demands offline voting")?></th></tr> <? // votes $previous_token = null; while ( $row = DB::fetch_assoc($result) ) { DB::to_bool($row['demand']); ?> <tr class="<?=stripes(); // highlight votes of the logged in member if ($token == $row['token']) { ?> self<? } // strike through votes, which have been overridden by a later vote if ($row['token'] == $previous_token) { ?> overridden<? } else $previous_token = $row['token']; ?>"><td><?=$row['token']?></td><? ?><td class="tdc"><?=date(VOTETIME_FORMAT, strtotime($row['votetime']))?></td><? ?><td><? display_checked($row['demand']) ?></td><? ?></tr> <? } ?> </table> <? }
// Transfer old data - START function forumtree_array($temp, $sub) { foreach ($temp as $cid => $boards) { foreach ($boards as $bid => $arr) { if (isset($sub[$bid])) { $sub[$bid] = forumtree_array($sub[$bid], $sub); $temp[$cid][$bid] = $sub[$bid]; } } } return $temp; } $parent = $sub = $empty = $full = $data = array(); $result = $db->query("SELECT b.id, b.bid, b.cid FROM {$db->pre}cat AS b LEFT JOIN {$db->pre}categories AS c ON c.id = b.cid ORDER BY c.c_order, c.id, b.c_order, b.id", __LINE__, __FILE__); while ($row = $db->fetch_assoc($result)) { if ($row['bid'] == 0) { $parent[$row['cid']][$row['id']] = array(); } else { $sub[$row['bid']][$row['cid']][$row['id']] = array(); } $full[] = $row['cid']; } $result = $db->query("SELECT id FROM {$db->pre}categories ORDER BY c_order, id", __LINE__, __FILE__); while ($row = $db->fetch_assoc($result)) { $empty[] = $row['id']; } $empty = array_diff($empty, $full); $data = forumtree_array($parent, $sub); foreach ($empty as $row) { $data[$row] = array();
<?php require $_SERVER['DOCUMENT_ROOT'] . '/system.php'; if (isset($_GET['login']) && isset($_GET['passwd'])) { $login = TextSave($_GET['login']); $passw = TextSave($_GET['passwd']); if (empty($login) or empty($passw)) { exit; } $db = new DB(); $db->connect("LauncherAuth"); $Row = $db->fetch_assoc($db->execute("SELECT `passw` FROM `users` WHERE `login` = '{$login}'")); if (empty($Row['passw'])) { exit("Пользователь не найден!"); } if (ToPass($passw) != $Row['passw']) { exit("Неверный пароль!"); } exit("OK:" . $login); } else { exit; }
</tr> <?php $path = 'package/' . $package . '/db/'; $tables = $db->list_tables(); $dh = opendir($path); while (($file = readdir($dh)) !== false) { $info = pathinfo($path . $file); if ($info['extension'] == 'sql') { $basename = substr($info['basename'], 0, -(strlen($info['extension']) + ($info['extension'] == '' ? 0 : 1))); $t = $db->pre . $basename; unset($counter); $select = array(); if (in_array($t, $tables)) { $exists = '<span class="hl_false">Yes</span>'; $result = $db->query('SELECT COUNT(*) AS c FROM ' . $t); $counter = $db->fetch_assoc($result); $entries = $counter['c']; $select[] = '<option value="3" selected="selected">Delete and recreate table</option>'; $select[] = '<option value="2">Do not change table</option>'; if ($counter['c'] > 0) { $select[] = '<option value="1">Clear table</option>'; } } else { $exists = '<span class="hl_true">No</span>'; $entries = '-'; $select[] = '<option value="0" selected="selected">Recreate table</option>'; } ?> <tr> <td><?php echo $db->pre;
session_start(); include 'include/db.class.php'; $db = new DB(); include 'include/cart.php'; ?> <? include_once("include/head.php");?> <? include_once("include/left_menu.php");?> <script language="javascript" type="text/javascript" src="js/functions.js"></script> <?print_r($_SESSION['products']);?> <div id="cart_interface"> <table cellpadding="4"> <?php foreach ($_SESSION['products'] as $key => $value) { $q = "SELECT * FROM catalog WHERE ID='{$key}'"; $product = $db->fetch_assoc($db->query($q)); ?> <tr> <td><?php echo $product['name']; ?> </td> <td> количество: <input type="text" size="2" id="product_count_<?php echo $key; ?> " value="<?php echo $_SESSION['products'][$key]['count']; ?> " />
<?php require $_SERVER['DOCUMENT_ROOT'] . '/system.php'; $db = new DB(); $db->connect("NEWS_Launcher"); $query = $db->execute("SELECT * FROM `news` ORDER BY `id` DESC LIMIT 10"); $db->close(); $html = ''; while ($data = $db->fetch_assoc($query)) { $html .= '<div class="news-block"><div class="news-title"><a target="_blank" href="/news/id/' . $data['id'] . '/">' . $data['title'] . '</a><p class="date">' . ToNTime($data['date']) . '</p></div> <div class="news-text">' . $data['text'] . '</div><div class="news-bottom"><p class="left">Автор: <a target="_blank" href="/profile/' . $data['author_id'] . '/">' . IDToLogin($data['author_id']) . '</a></p> <p class="right"><a target="_blank" href="/news/id/' . $data['id'] . '/">Подробнее...</a></p></div></div>'; } if (empty($html)) { $html = "<center style='color:#FFF'>Новостей нет :c</center>"; } ?> <!DOCTYPE html> <html> <head> <title>DarkMine Новости</title> <meta charset="utf-8"> <style type="text/css"> *{ margin: 0px; } a:visited { color: #2980b9; } a { color: #2980b9;
<?php error_reporting(E_ALL); require $_SERVER['DOCUMENT_ROOT'] . '/system.php'; $db = new DB(); $db->connect("STREAMS-CRON"); $empty = true; $list = $db->execute("SELECT * FROM `streams`"); while ($data = $db->fetch_assoc($list)) { if ($data['status'] != 1 && $data['status'] != 4 && $data['status'] != 5) { $json_array = json_decode(file_get_contents('https://api.twitch.tv/kraken/streams/' . $data['streamer'] . '/'), true); if ($json_array['stream'] != NULL) { //$json_array['stream']['created_at']; $dur = gmdate("H:i:s", time() - strtotime(date('d.m.Y H:i', strtotime($json_array['stream']['created_at'])))); $viewers = $json_array['stream']['viewers']; $db->execute("UPDATE `streams` SET `totaldur` = `totaldur` + 300,`status` = 2,`duration` = '{$dur}',`viewers` = '{$viewers}' WHERE `id` = '" . $data['id'] . "'"); if ($data['totaldur'] >= 172800 && $data['bonus_given'] == 1) { $db->execute("UPDATE `money` SET `realmoney` = `realmoney`+90 WHERE `username` = '" . IDToLogin($data['creator']) . "'"); $db->execute("UPDATE `streams` SET `bonus_given` = 2 WHERE `creator` = '" . $data['creator'] . "'"); PM::Send("Спасибо за ваши стримы!", '<h4>Вашими стримами вы помагаете проекту набрать популярность.</h4><p>Каждому стримеру который отстримит на нашем проекте 48 часов даються <strong>90 рублей</strong>.</p><p>На эти деньги вы можете купить/продлить свою VIP либо потратить эти деньги в магазине за покупку игровых предметов!</p><p> </p><p style="text-align: right;"><em><strong>Спасибо за поддержку проекта!</strong></em></p>', $data['creator'], 2); } } else { $db->execute("UPDATE `streams` SET `status` = 3 WHERE `id` = '" . $data['id'] . "'"); } } $empty = false; //echo $data['streamer']; } $db->close(); if ($empty == true) { exit("EMPTY");