<?php $num = 0; $connection = new PDO('mysql:host=db.abppro.ru;dbname=csgo_lvl_new', 'csgo', 'Lq4bZCv76c5DwdvW'); $connection->exec('SET CHARACTER SET utf8_general_ci'); foreach($connection->query("SELECT name, value, CONCAT(playtime/60/60 DIV 1, ' ч.'), FROM_UNIXTIME(lastconnect) FROM lvl_base WHERE `steam` LIKE '$user->steam_id'") as $row) { print "

\n"; print ""; print ""; $sth = $connection->prepare("SELECT count(*)+1 FROM lvl_base WHERE value>(SELECT `value` from lvl_base where `steam`='$user->steam_id')"); $sth->execute(); $result = $sth->fetchColumn(); print "\t\t\n"; for ($i=0;$i<=3;$i++) { print "\t\t\n"; } print "\t\n"; print "

Профиль Level Ranks
Место	Никнейм	Кол-во очков	Время	Последнее подключение
$result	$row[$i]

\n

---

"; $num = $num+1; } if ($num == 0) { print "
Ваш SteamID $user->steam_id не найден в базе.
Возможно вы не играли на наших серверах или не правильно указали SteamID в профиле.

---

"; } ?><?php //RankMePublic $connection = new PDO('mysql:host=db.abppro.ru;dbname=csgo_rankme_server1', 'csgo', 'Lq4bZCv76c5DwdvW'); $connection->exec('SET CHARACTER SET utf8_general_ci'); foreach($connection->query("SELECT name, score, kills, deaths, round(kills/deaths,2), shots, hits FROM rankme WHERE `steam` LIKE '$user->steam_id'") as $row) { print "\n"; print ""; print ""; print "\t\n"; $sth = $connection->prepare("SELECT count(*)+1 FROM rankme WHERE score>(SELECT `score` from rankme where `steam`='$user->steam_id')"); $sth->execute(); $result = $sth->fetchColumn(); print("\t\t\n"); for ($i=0;$i<=6;$i++) { print "\t\t\n"; } print "\t\n"; print "

RankMe Public
Место	Никнейм	Очки	Убийства	Смерти	У/С	Выстрелов	Попаданий
$result	$row[$i]

\n

---

"; } //rankme2000 $connection = new PDO('mysql:host=db.abppro.ru;dbname=csgo_rankme_server2', 'csgo', 'Lq4bZCv76c5DwdvW'); $connection->exec('SET CHARACTER SET utf8_general_ci'); foreach($connection->query("SELECT name, score, kills, deaths, round(kills/deaths,2), shots, hits FROM rankme WHERE `steam` LIKE '$user->steam_id'") as $row) { print "\n"; print ""; print ""; print "\t\n"; $sth = $connection->prepare("SELECT count(*)+1 FROM rankme WHERE score>(SELECT `score` from rankme where `steam`='$user->steam_id')"); $sth->execute(); $result = $sth->fetchColumn(); print("\t\t\n"); for ($i=0;$i<=6;$i++) { print "\t\t\n"; } print "\t\n"; print "

RankMe 2000Only
Место	Никнейм	Очки	Убийства	Смерти	У/С	Выстрелов	Попаданий
$result	$row[$i]

\n

---

"; } //rankmeawp $connection = new PDO('mysql:host=db.abppro.ru;dbname=csgo_rankme_server3', 'csgo', 'Lq4bZCv76c5DwdvW'); $connection->exec('SET CHARACTER SET utf8_general_ci'); foreach($connection->query("SELECT name, score, kills, deaths, round(kills/deaths,2), shots, hits FROM rankme WHERE `steam` LIKE '$user->steam_id'") as $row) { print "\n"; print ""; print ""; print "\t\n"; $sth = $connection->prepare("SELECT count(*)+1 FROM rankme WHERE score>(SELECT `score` from rankme where `steam`='$user->steam_id')"); $sth->execute(); $result = $sth->fetchColumn(); print("\t\t\n"); for ($i=0;$i<=6;$i++) { print "\t\t\n"; } print "\t\n"; print "

RankMe AWP-Only
Место	Никнейм	Очки	Убийства	Смерти	У/С	Выстрелов	Попаданий
$result	$row[$i]

\n

---

"; } //rankmearena $connection = new PDO('mysql:host=db.abppro.ru;dbname=csgo_rankme_server9', 'csgo', 'Lq4bZCv76c5DwdvW'); $connection->exec('SET CHARACTER SET utf8_general_ci'); foreach($connection->query("SELECT name, score, kills, deaths, round(kills/deaths,2), shots, hits FROM rankme WHERE `steam` LIKE '$user->steam_id'") as $row) { print "\n"; print ""; print ""; print "\t\n"; $sth = $connection->prepare("SELECT count(*)+1 FROM rankme WHERE score>(SELECT `score` from rankme where `steam`='$user->steam_id')"); $sth->execute(); $result = $sth->fetchColumn(); print("\t\t\n"); for ($i=0;$i<=6;$i++) { print "\t\t\n"; } print "\t\n"; print "

RankMe 1v1Arena
Место	Никнейм	Очки	Убийства	Смерти	У/С	Выстрелов	Попаданий
$result	$row[$i]

\n

---

"; } ?>