Скрипты
Diyvol Дата: Середа, 08.12.2010, 20:51 | Сообщение # 1
ЗлОй-АйТИшник
Центурион
Группа: Best of the Best user Wow-info
Доброго времени суток уважаемые форумчане вот сделал для вас темку кторая думаю будет очень актуальна Пример конфигурационного файла:
Code
<?
Максимальный онлайн за время работы сервера
Code
Смена пароля
Code
<?php
if($_POST['ok'])
{
if(!ereg("^[a-zA-Z0-9]+$", $_POST["login"]))
{
$err[] = '<b>Имя аккуанта:</b> введены запрещенные символы или поле пустое.';
}
if(empty($_POST["oldpass"]))
{
$err[] = '<b>Старый пароль:</b> поле пустое.';
}
if(empty($_POST["newpass"]))
{
$err[] = '<b>Новый пароль:</b> поле пустое.';
}
if(empty($_POST["newspasss"]))
{
$err[] = '<b>Новый пароль ещё:</b> поле пустое.';
}
$login = $_POST["login"];
$pass = $_POST["oldpass"];
$newpass = $_POST["newpass"];
$newpasss = $_POST["newspasss"];
$hashpass = sha1(strtoupper($login).":".strtoupper($pass));
$query = mysql_query("SELECT `username`,`sha_pass_hash` FROM `account` WHERE `username`='".$login."'");
$arr = mysql_fetch_array($query);
if($arr['username'] != $login){
$err[] = 'Введён неверный логин';
}
if($hashpass != $arr['sha_pass_hash']){
$err[] = 'Введён невеный старый пароль';
}
if($newpass != $newpasss){
$err[] = 'Введённые пароли не совподают';
}
if(count($err) == 0){
mysql_query("UPDATE `account` set sha_pass_hash = SHA1(CONCAT(UPPER('$login'),':',UPPER('$newpass'))) where username = \"".$login."\";");
header("location: ?change=ok");
}else{
$err[] = $error;
}
}
foreach ($err as $error){
echo '<div align="center">'.$error."</div>";
}
if( $_GET["change"] == null ){
echo '<form method="POST" enctype="multipart/form-data">
<table align="center" border="0" width="" cellpadding="0" cellspacing="0">
<tr><td>Имя аккуанта:</td></tr>
<tr><td align="center"><input type="text" name="login" align="center"></td></tr>
<tr><td>Старый пароль:</td></tr>
<tr><td align="center"><input type="password" name="oldpass" align="center"></td></tr>
<tr><td>Новый пароль:</td></tr>
<tr><td align="center"><input type="password" name="newpass" align="center"></td></tr>
<tr><td>Новый пароль ещё:</td></tr>
<tr><td align="center"><input type="password" name="newspasss" align="center"></td></tr>
<tr><td align="center"><input type="submit" name="ok" value="Сменить пароль"></td></tr>
</table>
</form>';
}else{
echo "<meta http-equiv=\"refresh\" content=\"5; url=test.php\" />";
echo '<div align="center" style="color: green; font-weight: bold;" >Пароль сменён успешно !</div>';
}
?>
Время работы сервера
Code
Cтатистика по расам и классам
Code
Бан Лист
Code
<?php
echo "<TABLE>";
echo "<TR><TD colSpan=5>Список заблокированных</TD></TR>";
echo "<TR><TD width=10%>Аккаунт</TD><TD>Забанил</TD><TD>Причина</TD><TD>Был забанен</TD><TD>Будет разбанен</TD></TR>";
$getban = mysql_query("SELECT * FROM account_banned WHERE active='1'");
while($banid = mysql_fetch_array($getban))
{
$id = "".$banid['id']."";
$who = "".$banid['bannedby']."";
$unbandate = date("d.m.Y", $banid['unbandate']);
$bandate = date("d.m.Y", $banid['bandate']);
$reason = "".$banid['banreason']."";
$getbanned = mysql_query("SELECT username FROM account WHERE id='$id'");
while($banned = mysql_fetch_array($getbanned))
{
$acc = "".$banned['username']."";
echo "<TR><TD width=10%>$acc</TD><TD>$who</TD><TD width=45%>$reason</TD><TD width=20%>$bandate</TD><TD width=25%>$unbandate</TD></TR>";
}
}
echo "</TABLE>";
?>
Картинка-Статус для какого-либо сервера.
Code
Проверка статуса сервера.
Code
Кол-во аккаунтов, персонажей, орды и т.д.
Code
Список:Кто Onlain
Code
<table border="0">
<tr>
<td><strong>Имя:</strong></td>
<td><strong>Раса:</strong></td>
<td><strong>Класс:</strong></td>
<td><strong>Уровень:</strong></td>
</tr>
<?
mysql_selectdb ("$cdb");
mysql_query ('set names cp1251');
$result = mysql_query ("select name, race, class, data from characters where online = 1");
$class = array
(1=>"Воин",2=>"Паладин",3=>"Охотник",4=>"Разбойник",5=>"Жрец",6=>"Рыцарь Смерти",7=>"Шаман",8=>"Маг",9=>"Чернокнижник",11=>"Друид");
$race = array
(1=>"Человек",2=>"Орк",3=>"Дворф",4=>"Ночной Эльф",5=>"Нежить",6=>"Таурен",7=>"Гном",8=>"Тролль",10=>"Эльф Крови",11=>"Дреней");
while ($row = mysql_fetch_array ($result))
{
$ch_name = $row['name'];
$ch_race = $row['race'];
$ch_class = $row['class'];
$char_data = explode(' ',$row['data']);
$ch_lvl = $char_data[53];
echo "<tr><td><strong>$ch_name</strong></td>";
echo "<td><strong>$race[$ch_race]</strong></td>";
echo "<td><strong>$class[$ch_class]</strong></td>";
echo "<td><strong>$ch_lvl</strong></td></tr>";
}
?>
</table>
Информация о Арена Командах
Code
Quote
$rdb - логин база
Code
топ Задротов сервера
Автор: Desperado Code
<?php
define("DBHOST", "localhost");
define("DBUSER", "root");
define("DBPASS", "mangos");
define("COLLATE", "utf8");
define("CDB", "characters");
function conventNormTime($nSec) {
$d = floor( $nSec / (3600*24) );
$nSec = ($nSec - $d * 3600 * 24);
$h = floor( $nSec / 3600 );
$nSec = ($nSec - $h * 3600);
$m = floor( $nSec / 60 );
return "{$d}д. {$h}ч. {$m}м.";
}
$class = array (
1=>"Воин",
2=>"Паладин",
3 = >"Охотник",
4=>"Разбойник",
5=>"Жрец",
6 =>"Рыцарь Смерти",
7=>"Шаман",
8=>"Маг",
9=>"Чернок нижник ",
11=>"Друид"
);
$race = array (
1=>"Человек",
2=>"Орк",
3=>"Д ворф",
4=>"Ночной Эльф",
5=>"Нежить",
6=>"Таурен",
7=>"Гном ",
8 =>"Тролль",
10=>"Эльф Крови",
11=>"Дреней"
);
$sMySql = mysql_connect(DBHOST, DBUSER, DBPASS); // Соединяемся с базой
mysql_query("SET NAMES COLLATE"); // Устанавливаем кодировку соединения
mysql_select_db(CDB, $sMySql);
$aSql = mysql_query("SELECT `name`, `race`, `class`, `totaltime` FROM `characters` ORDER BY `totaltime` DESC LIMIT 0 , 15", $sMySql);
$szContent .= "<br /><table width='98%' border='1' align='center'><tr>
<td align='center' width='20%'><font color='green'>Персонаж</font></td>
<td align='center' width='20%'><font color='green'>Сыгранное время</font></td>
<td align='center' width='20%'><font color='green'>Класс</font></td>
<td align='center' width='20%'><font color='green'>Раса</font></td>
</tr></table>";
while ($row = mysql_fetch_array($aSql))
{
$name = $row['name'];
$totaltime = conventNormTime($row['totaltime']);
$show_race = $race[$row['race']];
$show_class = $class[$row['class']];
$szContent .= "<table width='98%' border='1' align='center'><tr>
<td align='center' width='20%'>".$name."</td>
<td align='center' width='20%'>".$totaltime."</td>
<td align='center' width='20%'>".$show_class."</td>
<td align='center' width='20%'>".$show_race."</td>
</tr></table>";
}
mysql_close($sMySql); // Закрываем соединение mysql
echo $szContent;
?>
Скрипт регистрации:
Code
<?php
// Configuration.
// Realm database.
$r_db = "Realmd";
// IP (and port).
$ip = "127.0.0.1:3306";
// Username.
$user = "trinity";
// Password.
$pass = "trinity";
// Site title.
$title = "Registration Form";
$title2 = "Server name";
// End config.
$page = '<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>' . $title . '</title>
</head>
<body style="background-color:black;color:yellow;font-family:verdana;">
<form method="post" action="' . $_SERVER["SCRIPT_NAME"] . '">
<p style="text-align:center;">
<strong>' . $title2 . ' - ' . $title . '</strong>
<br /><br /><br />
Login:
<br /><input name="username" type="text" maxlength="14" /><br />
Password:
<br /><input name="password" type="password" maxlength="12" /><br />
Email:
<br /><input name="email" type="text" maxlength="50" />
<br /><input name="tbc" type="checkbox" checked="checked" /> WotLK<br /><br /><br />
<button type="submit">Registration</button>
</p>
</form>
</body>
</html>';
function error_s ($text) {
echo("<p style=\"background-color:black;color:yellow;font-family:verdana;\">" . $text);
echo("<br /><br /><a style=\"color:orange;\" href=\"" . $_SERVER["SCRIPT_NAME"] . "\">Go back...</a></p>");
};
$user_chars = "#[^a-zA-Z0-9_\-]#";&
Сообщение отредактировал Diyvol - Середа, 08.12.2010, 20:49
Darkensand Дата: Неділя, 13.03.2011, 22:02 | Сообщение # 2
Главный Админ
Лучший из лучших
Группа: Администратор
Скрипт статуса сервера:
Code
<?
Скрипт по классам и расам:
Code
<?
Код для общего онлайна:
Code
<?
Скрипт регистрации Mangos и Trinity
Code
<?php
$config = array (
// Names of DBs
'wname' => 'mangos', // база мира
'rname' => 'realmd', // база реалмов
'cname' => 'characters', // база чаров
// DB settings
'host' => '127.0.0.1', // адрес БД
'user' => 'mangos', // логин к БД
'pass' => 'mangos', // пароль к БД
'port' => '3306', // порт к БД
);
$db1 = "realmd";
$db2 = "mangos";
$db3 = "characters";
$host = "localhost";
$user = "mangos";
$pass = "mangos";
$port = "3306";
$tbc = 2;
$database_encoding = 'CP1251';
$realmd = mysql_connect("$host:$port", "$user", "$pass", True);
mysql_selectdb("$db1", $realmd);
$world = mysql_connect("$host:$port", "$user", "$pass", True);
mysql_selectdb("$db2", $world);
$characters = mysql_connect("$host:$port", "$user", "$pass", True);
mysql_selectdb("$db3", $characters);
echo "
<script type=\"text/javascript\">
function isAlphaNumeric(value)
{
if (value.match(/^[a-zA-Z0-9_]+$/))
return true;
return false;
}
function checkform(f)
{
if (f.account.value == \"\")
{
alert(\"Введите логин\");
return false;
}
if (!isAlphaNumeric(f.account.value))
{
alert(\"Запрещенные символы в логине\");
return false;
}
if (f.password.value==\"\")
{
alert(\"Введите пароль\");
return false;
}
if (!isAlphaNumeric(f.password.value))
{
alert(\"Запрещенные символы в пароле\");
return false;
}
if (f.password2.value==\"\")
{
alert(\"Вы не ввели повтор пароля\");
return false;
}
if (f.password.value != f.password2.value)
{
alert(\"Пароли не совпадают\");
return false;
}
if (f.email.value==\"\")
{
alert(\"Вы не ввели e-mail\");
return false;
}
}
</script>";
echo "
<font color=#00CC00>
</font>
<center>
<form method=post action=register.php onsubmit=\"return checkform(this)\">
<table>
<tr>
<td>Login:
<input type=text name=account maxlength=20></td>
</tr>
<tr>
<td> Password:
<input type=password name=password maxlength=20></td>
</tr>
<tr>
<td> Confirm Password:
<input type=password name=password2 maxlength=20></td>
</tr>
<tr>
<td> e-mail:
<input type=text name=email maxlength=32></td>
</tr>
<tr>
<td colspan=2 style=\"text-align: center;\">
<input type=submit value=Зарегистрироваться></td>
</tr>
</table>
</form></center>";
if (isset($_POST['account'])) {
if ($_POST['account'] && strlen($_POST['account'])<=20 && strlen($_POST['account'])>=3 && strlen($_POST['password'])>=3 && $_POST['password'] && $_POST['password2'] && $_POST['password']==$_POST['password2']) {
if (!eregi("^[a-zA-Z0-9_]+$", $_POST['account']))
die ("
Error: SQL-Injection</p>");
if (!eregi("^[a-zA-Z0-9_]+$", $_POST['password']))
die ("
Error: SQL-Injection</p>");
$pass = ($_POST['password']);
$username = ($_POST['account']);
$result = mysql_query("SELECT * FROM account WHERE username='".$_POST['account']."' AND sha_pass_hash='$pass'", $realmd);
if (mysql_num_rows($result) != 0) {
echo "<center>
<font color=#CC0000>[b]Такой аккаунт уже есть![/b]</font></p></center>";
} else {
if (!mysql_query("INSERT INTO account (username, sha_pass_hash, gmlevel, email, expansion) VALUES ('$username', SHA1(CONCAT(UPPER('$username'),':',UPPER('$pass'))), 0, '".$_POST['email']."', $tbc)", $realmd)) {echo "<center>
<font color=#CC0000>[b]Ошибка[/b]</font></p></center>";} else {echo "<center>
<font color=#00CC00>[b]Аккаунт успешно зарегестрирован! [/b]</font></p></center>";}
}
} else {
echo "<center>
<font color=#CC0000>[b]Проверьте правильность ввода![/b]</font></p></center>";
}
}
?>
Имя, Уровень ,Звани в Гильдии , Раса , Класс - таблица
Code
<?php
$realm = $realmdDB -> selectrow("SELECT * FROM `realmlist` WHERE `id` = ?d;", $CONF['realmID']);
$realmOnline = testRealm($realm);
if ($realmOnline) {
if (isset($_GET['id'])) {
$guild = $charactersDB -> selectrow(
"SELECT `c`.`name` as `lname`, `g`.`name`, `g`.`createdate`, `g`.`BankMoney`, `g`.`info`, `g`.`motd` ".
"FROM `guild` as `g` ".
"LEFT JOIN `characters` as `c` ON `c`.`guid` = `g`.`leaderguid` ".
"WHERE `g`.`guildid` = ?d;", $_GET['id']);
$members = $charactersDB -> select(
"SELECT `c`.`name`, `c`.`race`, `c`.`class`, `c`.`account`, `g_m`.`pnote`, `g_m`.`offnote`, `g_r`.`rname`, ".
"CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`c`.`data`, ' ', 54), ' ', -1) AS UNSIGNED) as `level`, ".
"CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`c`.`data`, ' ', 23), ' ', -1) AS UNSIGNED) as `gender` ".
"FROM `guild_member` as `g_m` ".
"LEFT JOIN `characters` as `c` ON `c`.`guid` = `g_m`.`guid` ".
"LEFT JOIN `guild_rank` as `g_r` ON (`g_r`.`rid` = `g_m`.`rank` AND `g_r`.`guildid` = `g_m`.`guildid`) ".
"WHERE `g_m`.`guildid` = ?d", $_GET['id']);
?>
<table cellpadding = "0" cellspacing = "0" style="{ border-collapse: collapse; margin: 3px; }" class="table">
<tr>
<td class="top">Название: </td>
<td><?php echo $guild['name']; ?></td>
</tr>
<tr>
<td class="top">Гильдмастер: </td>
<td><?php echo $guild['lname']; ?></td>
</tr>
<tr>
<td class="top">Дата создания: </td>
<td><?php echo date("d.m.Y H:m", $guild['createdate']); ?></td>
</tr>
<tr>
<td class="top">Денег в банке: </td>
<td><?php echo gold($guild['BankMoney']); ?></td>
</tr>
<tr>
<td class="top">Информация: </td>
<td><?php echo $guild['info']; ?></td>
</tr>
<tr>
<td class="top">Девиз: </td>
<td><?php echo $guild['motd']; ?></td>
</tr>
</table>
<h2>Участники гильдии:</h2>
<table cellpadding = "0" cellspacing = "0" style="{ border-collapse: collapse; margin: 3px; }" class="table">
<tr>
<td class="top">#</td>
<td class="top">Имя</td>
<td class="top">Уровень</td>
<td class="top">Звание в гильдии</td>
<td class="top">Раса</td>
<td class="top">Класс</td>
</tr>
<?php
$i = 1;
foreach ($members as $member) {
$member['aname'] = $realmdDB -> selectcell("SELECT `username` FROM `account` WHERE `id` = ?d;", $member['account']);
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $member['name']; ?></td>
<td><?php echo $member['level']; ?></td>
<td><?php echo $guild['lname']==$member['name']?"Guild Master":$member['rname']; ?></td>
<td><?php echo "<img src=\"./img/".$member['race']."-".gender($member['gender']).".gif\" alt=\"".$CONF['races'][$member['race']]."\">"; ?></td>
<td><?php echo "<img src=\"./img/".$member['class'].".gif\" alt=\"".$CONF['classes'][$member['class']]."\">"; ?></td>
</tr>
<?php
$i++;
}
echo "</table>\n";
} else {
!isset($_GET['sb'])? $_GET['sb'] = 'name': $_GET['sb'];
!isset($_GET['sc'])? $_GET['sc'] = 'ASC': $_GET['sc'];
if ($_GET['sc'] != 'ASC' && $_GET['sc'] != 'DESC') $_GET['sc'] = 'DESC';
$guilds = $charactersDB -> select(
"SELECT `c`.`name` as `lname`, `g`.`name`, `g`.`createdate`, `g`.`BankMoney`, `g`.`guildid` ".
"FROM `guild` as `g` ".
"LEFT JOIN `characters` as `c` ON `c`.`guid` = `g`.`leaderguid` ".
"ORDER BY ?# ".$_GET['sc'].";", $_GET['sb']);
$i = 1;
?>
<table cellpadding = "0" cellspacing = "0" style="{ border-collapse: collapse; margin: 3px; }" class="table">
<tr>
<td class="top">#</td>
<td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=name&sc=".(($_GET['sc']=='ASC' && $_GET['sb']=="name")? "DESC": "ASC");?>">Название</a></td>
<td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=lname&sc=".(($_GET['sc']=='ASC' && $_GET['sb']=="lname")? "DESC": "ASC");?>">Гильдмастер</a></td>
<td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=createdate&sc=".(($_GET['sc']=='DESC' && $_GET['sb']=="createdate")? "ASC": "DESC");?>">Дата создания</a></td>
<td class="top"><a href="?<?php echo "page=".$_GET['page']."&sb=BankMoney&sc=".(($_GET['sc']=='DESC' && $_GET['sb']=="BankMoney")? "ASC": "DESC");?>">Денег в банке</a></td>
</tr>
<?php
foreach ($guilds as $guild) {
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo "<a href=\"?page=guilds&id=".$guild['guildid']."\">".$guild['name']."</a>"; ?></a></td>
<td><?php echo $guild['lname']; ?></td>
<td><?php echo date("d.m.Y H:m", $guild['createdate']); ?></td>
<td><?php echo gold($guild['BankMoney']); ?></td>
</tr>
<?php
$i++;
}
echo "</table>\n";
}
} else {
echo $realm['name']." выключен.
\n";
}
?>
Максимальный онлайн
Code
<?
Bullko Дата: Неділя, 13.03.2011, 22:16 | Сообщение # 3
Капрал
Группа: Пользователи
HeisenBeRG , Спасибо забрал пару
Olivers Дата: Середа, 16.03.2011, 18:03 | Сообщение # 4
Рыцарь
Группа: Пользователи
Статистика арены 2х2
$select_db = mysql_select_db('characters');
$select_arena_ratings = mysql_query("SELECT rating,arenateamid FROM `characters`.`arena_team_stats` ORDER BY rating DESC");
$i = 1;
echo "<table border=1 align=center>";
echo "<td width=190px>Название команды</td>";
echo "<td width=130px>Очки</td>";
echo "<td width=130px>Состав</td>";
echo "</table>";
while($select_arena_rating = mysql_fetch_array($select_arena_ratings)) {
$select_arena_tnames = mysql_query("SELECT * FROM `characters`.`arena_team` WHERE type=2 && arenateamid='".$select_arena_rating[arenateamid]."'");
while($select_arena_tname = mysql_fetch_array($select_arena_tnames)) {
$select_member_names = mysql_query("SELECT * FROM `characters`.`arena_team_member` WHERE arenateamid = '".$select_arena_tname[arenateamid]."'");
$select_member_rows = mysql_num_rows($select_member_names);
if($select_member_rows == 2) {
echo "<table border=1 align=center>";
echo "<td width=190px><dic style='width:110px;'><a>".$select_arena_tname['name']."</a></div></td>";
echo "<td width=130px><dic style='width:110px;'><a>".$select_arena_rating['rating']."</a></div></td>";
echo "<td width=130px>";
while($select_member_name = mysql_fetch_array($select_member_names)) {
$result_name_members = mysql_query("SELECT * FROM `characters`.`characters` WHERE guid = '".$select_member_name[guid]."'");
$result_name_member = mysql_fetch_array($result_name_members);
echo "<div style='width:110px;'><a>".$result_name_member['name']."</a></div>";
}
echo "</td>";
}
echo "</table>";
$i++;
}
}
Статистика арены 3х3
$select_db = mysql_select_db('characters');
$select_arena_ratings = mysql_query("SELECT rating,arenateamid FROM `characters`.`arena_team_stats` ORDER BY rating DESC");
$i = 1;
echo "<table border=1 align=center>";
echo "<td width=190px>Название команды</td>";
echo "<td width=130px>Очки</td>";
echo "<td width=130px>Состав</td>";
echo "</table>";
while($select_arena_rating = mysql_fetch_array($select_arena_ratings)) {
$select_arena_tnames = mysql_query("SELECT * FROM `characters`.`arena_team` WHERE type=3 && arenateamid='".$select_arena_rating[arenateamid]."'");
while($select_arena_tname = mysql_fetch_array($select_arena_tnames)) {
$select_member_names = mysql_query("SELECT * FROM `characters`.`arena_team_member` WHERE arenateamid = '".$select_arena_tname[arenateamid]."'");
$select_member_rows = mysql_num_rows($select_member_names);
if($select_member_rows == 3) {
echo "<table border=1 align=center>";
echo "<td width=190px><dic style='width:110px;'><a>".$select_arena_tname['name']."</a></div></td>";
echo "<td width=130px><dic style='width:110px;'><a>".$select_arena_rating['rating']."</a></div></td>";
echo "<td width=130px>";
while($select_member_name = mysql_fetch_array($select_member_names)) {
$result_name_members = mysql_query("SELECT * FROM `characters`.`characters` WHERE guid = '".$select_member_name[guid]."'");
$result_name_member = mysql_fetch_array($result_name_members);
echo "<div style='width:110px;'><a>".$result_name_member['name']."</a></div>";
}
echo "</td>";
}
echo "</table>";
$i++;
}
}
Статистика арены 5х5
$select_db = mysql_select_db('characters');
$select_arena_ratings = mysql_query("SELECT rating,arenateamid FROM `characters`.`arena_team_stats` ORDER BY rating DESC");
$i = 1;
echo "<table border=1 align=center>";
echo "<td width=190px>Название команды</td>";
echo "<td width=130px>Очки</td>";
echo "<td width=130px>Состав</td>";
echo "</table>";
while($select_arena_rating = mysql_fetch_array($select_arena_ratings)) {
$select_arena_tnames = mysql_query("SELECT * FROM `characters`.`arena_team` WHERE type=5 && arenateamid='".$select_arena_rating[arenateamid]."'");
while($select_arena_tname = mysql_fetch_array($select_arena_tnames)) {
$select_member_names = mysql_query("SELECT * FROM `characters`.`arena_team_member` WHERE arenateamid = '".$select_arena_tname[arenateamid]."'");
$select_member_rows = mysql_num_rows($select_member_names);
if($select_member_rows == 5) {
echo "<table border=1 align=center>";
echo "<td width=190px><dic style='width:110px;'><a>".$select_arena_tname['name']."</a></div></td>";
echo "<td width=130px><dic style='width:110px;'><a>".$select_arena_rating['rating']."</a></div></td>";
echo "<td width=130px>";
while($select_member_name = mysql_fetch_array($select_member_names)) {
$result_name_members = mysql_query("SELECT * FROM `characters`.`characters` WHERE guid = '".$select_member_name[guid]."'");
$result_name_member = mysql_fetch_array($result_name_members);
echo "<div style='width:110px;'><a>".$result_name_member['name']."</a></div>";
}
echo "</td>";
}
echo "</table>";
$i++;
}
}
Сообщение отредактировал Olivers - Середа, 16.03.2011, 18:08
Darkensand Дата: Понеділок, 28.03.2011, 16:15 | Сообщение # 5
Главный Админ
Лучший из лучших
Группа: Администратор
Добовляем скрипты полезные
TiTaN-WoW Дата: Понеділок, 28.03.2011, 17:06 | Сообщение # 6
Чемпион
Группа: Пользователи
=(
Alo Дата: Понеділок, 28.03.2011, 17:13 | Сообщение # 7
Сержант
Группа: Пользователи
TiTaN-WoW , они везде одинаковые, просто надо изменить логин и пароль, базы и все
CataclysmOff Дата: Понеділок, 28.03.2011, 19:39 | Сообщение # 8
Скаут
Группа: Пользователи
вапше классные скрипты всем кто добавил плюс...
[RIP]Epic-WoW [RIP]WoW-Extrim
TiTaN-WoW Дата: Вівторок, 05.04.2011, 22:37 | Сообщение # 9
Чемпион
Группа: Пользователи
Кулл спасибо! + дал
[FaNaT1K] Дата: Вівторок, 05.04.2011, 23:32 | Сообщение # 10
Fan Guf_ZM Nation™
Командир
Группа: V.I.P
Diyvol не работает таблица банов вот что пишет Code
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in Y:\home\109.87.80.88\www\modules\ban.php on line 6
Мечтаете о собственном проекте?!
Darkensand Дата: Вівторок, 05.04.2011, 23:56 | Сообщение # 11
Главный Админ
Лучший из лучших
Группа: Администратор
CataclysmOff , Ждемс сайт
Czarj Дата: Вівторок, 26.04.2011, 21:35 | Сообщение # 12
Скаут
Группа: Пользователи
Очень кстати скрипты спосибо большое
Ну што сказать то?
Diyvol Дата: Вівторок, 26.04.2011, 22:21 | Сообщение # 13
ЗлОй-АйТИшник
Центурион
Группа: Best of the Best user Wow-info
[FaNaT1K] ,
booyoods Дата: Субота, 28.05.2011, 04:57 | Сообщение # 14
Старший Маршал
Группа: V.I.P
Статистика сервера:
Code
<?php
Скрипт регистрации [Trinity]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-us" xml:lang="en-us">
<head>
<title>Register An Account!</title>
<style type="text/css">
body{
background:#f4f4f4;
color:black;
font-family:Trajan Pro;
font-size:12px;
}
#main{
}
#reg{
background:#f4f4f4;
border:1px solid #abadb3;
}
#reg:focus
{
outline: none;
border:1px solid black;
}
#q{
width:153px;
height:22px;
background:#f4f4f4;
border:1px solid #abadb3;
}
#q:focus
{
outline: none;
border:1px solid black;
}
</style>
</head>
<body>
<?php error_reporting(0);
$string="";
$length = 12;
$characters = '012345678910ABCDEFGHIJKLMNOPQRSTUVWXYZ';
for ($p = 0; $p < $length; $p++) {
$string .= $characters[mt_rand(0, strlen($characters))];
}
function register(){
if(!include "./config.php")
{print"<br/>404 Script Error: <b>Config.php</b> can't be found.";}
else{
if(!isset($_POST['register'])){}else{
//Check If Input Fields Were Empty.
if(empty($_POST['username'])){print'<br/>Invalid Username.';}else{}
if(empty($_POST['password'])){print'<br/>Invalid Password.';}else{}
if(empty($_POST['cpass'])){print'<br/>You Must Confirm Your Password.';}else{}
if(empty($_POST['email'])){print'<br/>Invalid Email Address.';}else{}
if(empty($_POST['cemail'])){print'<br/>You Must Confirm Your Email Address.';}else{}
if(empty($_POST['a'])){print'<br/>Invalid Answer For Your Security Question.';}else{}
if(empty($_POST['2'])){print'<br/>Invalid Anti Bot Code.';}else{}
//Input Fields Were Full.
if(!empty($_POST['username']) && !empty($_POST['password']) && !empty($_POST['cpass']) && !empty($_POST['email']) && !empty($_POST['cemail']) && !empty($_POST['a']) && !empty($_POST['2'])){
//Post Input Data.
$username = mysql_real_escape_string(stripslashes(htmlentities($_POST['username'])));
$password = mysql_real_escape_string(stripslashes(htmlentities($_POST['password'])));
$cpass = mysql_real_escape_string(stripslashes(htmlentities($_POST['cpass'])));
$email = mysql_real_escape_string(stripslashes(htmlentities($_POST['email'])));
$cemail = mysql_real_escape_string(stripslashes(htmlentities($_POST['cemail'])));
$a = mysql_real_escape_string(stripslashes(htmlentities($_POST['a'])));
$_1 = mysql_real_escape_string(stripslashes(htmlentities($_POST['1'])));
$_2 = mysql_real_escape_string(stripslashes(htmlentities($_POST['2'])));
//Caps Username & Email.
$username = ucfirst($username); $email = ucfirst($email); $cemail = ucfirst($cemail);
//Check If Username Is In Use.
$check_account = mysql_query("SELECT * FROM account WHERE username='$username'");
$checked_account = mysql_num_rows($check_account);
if($checked_account == 1){print'<br/>'.$username.' Is Already Taken.';}
//Check if Email Is In Use & Valid.
if(!filter_var($email, FILTER_VALIDATE_EMAIL))
{
print'<br/>That Is Not A Valid Email Address.';
}
$check_email = mysql_query("SELECT * FROM account WHERE email='$email'");
$checked_email = mysql_num_rows($check_email);
if($checked_email == 1){print'<br/>That Email Address Is Alread In Use.';}
//Check If Email = Email Confirm.
if($email != "$cemail"){print'<br/>The Confirmed Email Address Doesn\'t Match The Email Address You Entered.';}
//Check If Password = Password Confirm.
if($password != "$cpass"){print'<br/>The Confirmed Password Doesn\'t Match The Password You Entered.';}
//Hash Password.
$check_pass = sha1(strtoupper($username) . ":" . strtoupper($password));
$password = strtoupper($check_pass);
$check_cpass = sha1(strtoupper($username) . ":" . strtoupper($cpass));
$cpass = strtoupper($check_cpass);
//Anti - Bot.
if($_1 != "$_2"){print'<br/>Invalid Anti Bot Code.';}else{}
//Check All.
if($checked_account != 1 && $checked_email != 1 && $email == "$cemail" && $password == "$cpass" && filter_var($email, FILTER_VALIDATE_EMAIL) && $_1 == "$_2"){
$insert_account = mysql_query("INSERT INTO account (username, sha_pass_hash, email, expansion, security_question) VALUES ('$username', '$password', '$email', '2', '$a')");
if(!$insert_account){print'<br/>Account Creation Failed.';}else{print'<br/>The Account "'.$username.'" Was Created.';}
}}}}}
?>
<table align="center" id="main">
<form action="" method="post">
<tr><td>Username:</td> <td><input type="text" name="username" id="reg" autocomplete="off"></td></tr>
<tr><td>Password:</td> <td><input type="password" name="password" id="reg"></td></tr>
<tr><td>Confirm Password:</td> <td><input type="password" name="cpass" id="reg"></td></tr>
<tr><td>Email Address:</td> <td><input type="text" name="email" id="reg" autocomplete="off"></td></tr>
<tr><td>Confirm Email:</td> <td><input type="text" name="cemail" id="reg" autocomplete="off"></td></tr>
<tr><td>Security Question:</td> <td align="center"><select name="q" id="q">
<option value="1">Favorite Pet?</option>
<option value="2">Best Friend?</option>
<option value="3">Home Town?</option>
<option value="4">Favorite Movie?</option>
</select></td></tr>
<tr><td>Question Answer:</td> <td><input type="password" name="a" id="reg" autocomplete="off"></td></tr>
<tr><td><input type="hidden" name="1" value="<?php print $string; ?>"><?php print $string; ?></td> <td><input type="text" name="2" id="reg" autocomplete="off"></td></tr>
<tr><td></td> <td align="center"><input type="submit" name="register" value="Create Account"></td></tr>
</form>
</table>
<center><?php register(); ?></center>
</body>
</html>
Сообщение отредактировал booyoods - Субота, 28.05.2011, 05:09
booyoods Дата: Субота, 28.05.2011, 05:07 | Сообщение # 15
Старший Маршал
Группа: V.I.P
Скрипт регистрации
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-us" xml:lang="en-us">
<head>
<title>Register An Account</title>
</head>
<body>
<table align="center"><form action="" method="post">
<tr><td>Username:</td> <td><input type="text" name="username"></td></tr>
<tr><td>Password:</td> <td><input type="password" name="password"></td></tr>
<tr><td>Email:</td> <td><input type="text" name="email"></td></tr>
<tr><td></td> <td align="center"><input type="submit" value="Register" name="register"></td></tr>
</form></table><br/><center>
<?php error_reporting(0);
//-- Config --\\
$host = "localhost";//Your Database Host. Default = localhost $user = "root";//Your Database Username. Default = root $pass = "ascent";//Your Database Password. Default = ascent $dbar = "";//ArcEmu Logon Database. $dbtc = "";//Trinity Auth Database. //-- End Config --\\
//-- Do Not Edit Below --\\
$con = mysql_connect("$host","$user","$pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if(isset($_POST['register'])){
if(!empty($_POST['username'])){$username = mysql_real_escape_string(stripslashes(htmlentities($_POST['username'])));}else{print'You must enter a username.<br/>';}
if(!empty($_POST['password'])){$password[0] = mysql_real_escape_string(stripslashes(htmlentities($_POST['password'])));}else{print'You must enter a password.<br/>';}
if(!empty($_POST['email'])){$email = mysql_real_escape_string(stripslashes(htmlentities($_POST['email'])));}else{print'You must enter a email address.<br/>';}
$username = ucfirst($username); $email = ucfirst($email);
$ar_use = mysql_query("SELECT * FROM $dbar.accounts WHERE login='$username'");
$ause = mysql_num_rows($ar_use);
$tc_use = mysql_query("SELECT * FROM $dbtc.account WHERE username='$username'");
$tuse = mysql_num_rows($tc_use);
if($ause == 1 || $tuse == 1){print'"'.$username.'" is already in use.<br/>';}
//Start Create
$password[1] = sha1(strtoupper($username) . ":" . strtoupper($password[0]));
$password[2] = strtoupper($password[1]);//Trinity Password
if(empty($_POST['username'])==false && empty($_POST['password'])==false && empty($_POST['email'])==false && $ause == 0 && $tuse == 0){
//Trinity
mysql_query("INSERT INTO $dbtc.account (username, sha_pass_hash, email, expansion)
VALUES ('$username', '$password[2]', '$email', '2')");
//ArcEmu
mysql_query("INSERT INTO $dbar.accounts (login, password, email, flags)
VALUES ('$username', '$password[0]', '$email', '24')");
print'The account "'.$username.'" was created.';
}}else{}
mysql_close($con);
?>
</center>
</body>
</html>
booyoods Дата: Четвер, 09.06.2011, 06:34 | Сообщение # 16
Старший Маршал
Группа: V.I.P
Code
<!--Begin Bar Graph-->
<?php /*Script By Azer / Script For Realm Character Online Graph*/
$db_host="localhost";//Character Db Host
$db_user="root";//Character Db User
$db_pass="ascent";//Character Db Pass
$db_db="characters";//Character Db
$con = mysql_connect("$db_host","$db_user","$db_pass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("$db_db", $con);
$bar_width="100";//Graph Width
$max_online="500";//Max Allowed Players Online
$border_color="#6cc02c";//Graph Border COlor
$graph_fill="#2fa4f3";//Fill Color
$right_border="#6cc02c";//Right Fill Border Color
print'
<div style="width:'.$bar_width.'px; border:1px solid '.$border_color.'; height:18px; position:relative;margin-left:5px;text-align:left; background-repeat:repeat-x;">
<div style="position:absolute; z-index:50; width:100%; height:18px; text-align:center;color:white;">
<div style="margin-top:1px;">';
$sql = "SELECT SUM(online) FROM characters";
$sqlquery = mysql_query($sql) or die(mysql_error());
$memb = mysql_result($sqlquery,0,0);
echo $memb;
$number = $memb / $max_online;
$total_number = $number * $bar_width;
?> / <?php echo"$max_online"; ?>
</div></div>
<div style="width:<?php echo"$total_number"; ?>%; background:<?php echo"$graph_fill"; ?>; background-repeat:repeat-x; height:18px;border-right:1px solid <?php echo"$right_border"; ?>;">
</div></div><!--End Bar Graph-->
booyoods Дата: Четвер, 09.06.2011, 12:35 | Сообщение # 17
Старший Маршал
Группа: V.I.P
топ 5 самых активных Code
<?php
$conn=mysql_connect('localhost', 'root', 'ascent') or die();
mysql_select_db('forum');
$news_id = $_GET['user_id'];
$news = $_GET['user_posts'];
$i=0;
$query_news=mysql_query("SELECT user_posts, username, user_id FROM phpbb_users ORDER BY user_posts DESC LIMIT 5") or die (mysql_error());
$num_news=mysql_num_rows($query_news);
mysql_close($conn);
?>
<?php while($fetch_news=mysql_fetch_array($query_news)) { $news_id = $fetch_news['user_id']; $i++?>
<?php
$uid = $fetch_news['user_id'];
?>
<li>
<?php print(sprintf("<a href=\"http://localhost/community/memberlist.php?mode=viewprofile&u=%s\">", (string)$uid));?>
<strong class="explore-caption"><?php print $fetch_news['username']; ?></strong>
<?php print $fetch_news['user_posts']; ?> posts</a>
</li>
<?php }?>
Самая популярная тема на форуме Code
<?php
$conn=mysql_connect('localhost', 'root', 'ascent') or die();
mysql_select_db('forum');
$forum_id = $_GET['topic_id'];
$forum = $_GET['topic_title'];
$i=0;
$query_forum=mysql_query("SELECT topic_views, topic_title, topic_id, forum_id FROM phpbb_topics ORDER BY topic_views DESC LIMIT 5") or die (mysql_error());
$num_forum=mysql_num_rows($query_forum);
mysql_close($conn);
?>
<?php while($fetch_forum=mysql_fetch_array($query_forum)) { $forum_id = $fetch_forum['topic_id']; $i++?>
<?php
$fid = $fetch_forum['forum_id'];
$tid = $fetch_forum['topic_id'];
?>
<li><?php print(sprintf("<a href=\"http://localhost/community/viewtopic.php?f=%s&t=%s\">", (string)$fid, (string)$tid));?><?php print $fetch_forum['topic_title'];?></a></li>
<?php } ?>
booyoods Дата: Четвер, 09.06.2011, 12:41 | Сообщение # 18
Старший Маршал
Группа: V.I.P
Этот срипт показывает 5 убийц седня и вобшем Code
<?php
![[FaNaT1K]](/img/noava.jpg "[FaNaT1K]")
