示例#1
0
/**
* параметры:
* $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();
}
示例#2
0
 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();
 }
示例#3
0
        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);
示例#4
0
	/**
	 * 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 != 'Нету') {
示例#6
0
	/**
	 * 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;
}
示例#8
0
</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'])) {
示例#10
0
<?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");
示例#13
0
         }
         $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`"));
示例#14
0
	/**
	 * 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'])) {
示例#16
0
/**
 * 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;
}
示例#17
0
<?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';
示例#18
0
    }
} 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&amp;duree={$duree}&amp;rowlimit=" . "{$rowlimit}&amp;offsetrow={$offsetrow}&amp;offsettable={$offsettable}&amp;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;
示例#19
0
	/**
	 * 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>
<?
	}
示例#20
0
// 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();
示例#21
0
<?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;
}
示例#22
0
	</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'];
    ?>
" /> 
示例#24
0
<?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>&nbsp;</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");