Здравеите . Писах на бързо едно скриптче за добавяне на сървъри и днес реших да ги побликувам тук лично на мен ми харесва за 1 скрип е добро ето
подобни
http://cs-bg.info/servers_16.php
http://online-bg.info/menu/servers
Използвал сам търсачка от уроците на jooorooo и странициране
Състои се от :
sql.sql
config.php
add_server.php
info.php
search.php
servers.php
admin.php
del.php
login.php
Нека започнем с файловете:
sql.sql
config.php
add_server.php
info.php
search.php
servers.php
admin.php
del.php
login.php
Еми това е от мен дани ви е полезно и дано хората се осазнаят и да махнат е107 от сайтовете не от сичи но станаха мн такива за цс :Х
ето и линк http://www.wikiupload.com/middle_page.php?id=104875[/u]
подобни
http://cs-bg.info/servers_16.php
http://online-bg.info/menu/servers
Използвал сам търсачка от уроците на jooorooo и странициране
Състои се от :
sql.sql
config.php
add_server.php
info.php
search.php
servers.php
admin.php
del.php
login.php
Нека започнем с файловете:
sql.sql
Код:
CREATE TABLE IF NOT EXISTS `servers` (
`id` bigint(255) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`port`text NOT NULL,
`cheat`text NOT NULL,
`type`text NOT NULL,
`author`text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1;
config.php
Код:
<?
$username = "root";
$pass = "";
$host = "localhost";
$db = "servers";
$conn = mysql_connect($host, $username, $pass);
mysql_select_db($db, $conn);
?>
add_server.php
Код:
<?php
session_start();
if (!isset($_SESSION['dostap'])) {
header("Location: login.php");
}
// тук останалия код от файла :)
?>
<form method="post" action="">
Име<br /><input name="name" type="text" size="30" /><br />
Ип<br /><input name="ip" type="text" size="30" /><br />
Порт<br /><input name="port" type="text" size="30" /><br>
Anti-Cheat<br />
<select name="cheat">
<option value="" selected="selected">Посочи</option>
<option value="Няма">Няма</option>
<option value="Cheating-Death">Cheating-Death</option>
<option value=">MyAC">MyAC</option>
<option value="sXe Injected">sXe Injected</option>
<option value="HLGuard">HLGuard</option>
<option value="DonT Lie">DonT Lie</option>
<option value="Flex">Flex</option>
<option value="Друг">Друг</option>
</select><br>
Тип<br />
<select name="type">
<option value="" selected="selected">Посочи</option>
<option value="Classic">Classic</option>
<option value="Hide N Seek">Hide N Seek</option>
<option value="Kreedz">Kreedz</option>
<option value="Warcraft 3 / FT">Warcraft 3 / FT</option>
<option value="Zombie">Zombie</option>
<option value="Deathmatch">Deathmatch</option>
<option value="Cups">Cups</option>
<option value="5on5">5on5</option>
<option value="Massive">Massive</option>
<option value="Aim">Aim</option>
<option value="SuperHero">SuperHero</option>
<option value="GunGame">GunGame</option>
<option value="Deathrun">Deathrun</option>
<option value="PaintBall">PaintBall</option>
<option value="Respawn">Respawn</option>
</select><br>
Автор<br /><input name="author" type="text" size="30" />
<br /><br />
<input name="submit" type="submit" value="Добави" />
</form>
<?php
include("config.php");
if($_POST['submit'])
{
$name = htmlspecialchars(addslashes($_POST['name']));
$ip = htmlspecialchars(addslashes($_POST['ip']));
$port = htmlspecialchars(addslashes($_POST['port']));
$cheat = htmlspecialchars(addslashes($_POST['cheat']));
$type = htmlspecialchars(addslashes($_POST['type']));
$author = htmlspecialchars(addslashes($_POST['author']));
if(empty($name) || empty($ip))
{
echo 'Има празно поле';
}
else
{
$sql = mysql_query("INSERT into `servers` (`id`,`name`,`ip`,`port`,`cheat`,`type`,`author`) VALUES ('','$name','$ip','$port','$cheat','$type','$author')") or die(mysql_error());
if($sql) { echo "Сървърът е добавена"; }
}
}
?>
info.php
Код:
<?php
session_start();
include("config.php");
$id = htmlspecialchars($_GET['id']);
$sql = mysql_query("SELECT * from `servers` WHERE `id`='$id'");
while($row = mysql_fetch_array($sql)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$ips= "$ip";
$ports= "$port";
$vt_ip = "$ips"; // Server IP
$vt_port = "$ports"; // Port
$output = @fsockopen("udp://$vt_ip", $vt_port, $errno, $errstr, 0.25);
@socket_set_timeout($output, 1);
@socket_set_blocking($output, 1);
@fwrite($output, "\xFF\xFF\xFF\xFF\x54\x53\x6F\x75\x72\x63\x65\x20\x45\x6E\x67\x69\x6E\x65\x20\x51\x75\x65\x72\x79\x00");
$buffer = @fread($output, 4096);
if (!$buffer) {
echo "<center>
<table align='center bgcolor='#FFFF00' width='20%' border='1px'>
<tr>
<td align='left' width='50%'>
$name <br />$ip:$port
</td><td align='left' width='20%'> e офлаин</td>
";
} else {
echo "<table align='center' bgcolor='#FFFF00' width='20%' border='1px'>
<tr>
<td align='left' width='50%'>
$name <br />$ip:$port
</td><td align='left' width='20%'>e онлаин</td>";
}
}
exit;
?>
Код:
<?php
$tarsene = $_GET['search'];
$server = "localhost";
$dbusername = "root";
$dbpassword = "";
$db_name = "servers";
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$query = " SELECT * FROM servers WHERE name LIKE '%$tarsene%'";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_numrows($result);
echo "<center>Намерени резултати за: <b><i>$tarsene</i></b>";
echo "<br />";
while($row = mysql_fetch_array($result))
{
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];
echo "<table align='center' bgcolor='#FFFF00' width='50%' border='1px'>
<tr>
<td align='left' width='50%'>
$name <br />$ip:$port
</td>
<td align='left' width='30%'>
AC : $cheat
</td>
</td>
<td align='center' width='40%'>
Tuka linka
</td>
</tr>
</table>";
}
?>
servers.php
Код:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
</head>
<form method="GET" align="center" action="search.php">
<table align='center' cellpadding="0" cellspacing="0" width="300px" >
<tr>
<td align="center" width="200px"><input type="text" name="search" size="30"></td>
<td align="center" width="100px"><input type="submit" value="Търси"></td>
</tr>
</table>
</form>
<?php
//server connfigure
$server = "localhost";
$dbusername = "root";
$dbpassword = "";
$db_name = "servers";
$table_name = "servers";
//server connfigure
//колко резултата на страница
$pp = "5";
//колко резултата на страница
$page=$_GET['page']; //присвояваме стойността на page
if(!$_GET['page']) //ако не е взета page да върне 1-ца
{
$page="1";
}
$limit = ($pp*$page)-$pp; //определяме лимитирането
mysql_connect($server, $dbusername, $dbpassword)or die("1111");
@mysql_select_db($db_name) or die("2222");
$redove=mysql_query("SELECT * FROM $table_name");
$max=mysql_numrows($redove); //преброяваме редовете
$total=ceil($max/$pp); //пресмятаме броя на страниците
mysql_connect($server, $dbusername, $dbpassword)or die("3333");
@mysql_select_db($db_name) or die("4444");
$query="SELECT * FROM $table_name ORDER BY `id` DESC LIMIT $limit,$pp";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while($row = mysql_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];
echo "<table align='center' bgcolor='#FFFF00' width='50%' border='1px'>
<tr>
<td align='left' width='50%'>
$name <br />$ip:$port
</td>
<td align='left' width='30%'>
AC : $cheat
</td>
</td>
<td align='center' width='40%'>
<a href='info.php?id=$id'>Инфо</a>
</td>
</tr>
</table><center>";
$i++;
}
echo "";
//от тук започва кода за показването на страниците
if ($page > 1) {
$prev = ($page - 1);
echo "<a href=\"?page=$prev\"><font face=\"Trebuchet MS\">Предишна страница</font></a> ";
}
else echo "<font face=\"Trebuchet MS\">Предишна страница</font> ";
if (!$page or ($page > $total)) {
$page="1";
}
if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b>$i</b> ";
}
else {
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b>$i</b> ";
}
else {
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
}
if ($page <= 3) {
if ($page == 3) echo "<a href=\"?page=4\">4</a> ";
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
if ($page == 5) $parva.= "<a href=\"?page=4\">4</a> ";
if ( ($page == 4) or ($page == 5) ) {
for ($i=$page; $i<=$page+1; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
if ( ($page > 5) and ($page < ($total - 4)) ) {
echo "... ";
for ($i=$page-1; $i<=$page+1; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
if ( $page > ($total - 5) ) {
echo "... ";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
}
}
if ($page < $total) {
$next = ($page + 1);
echo "<a href=\"?page=$next\"><font face=\"Trebuchet MS\">Следваща страница</font></a> ";
}
else echo "<font face=\"Trebuchet MS\">Следваща страница</font>";
?>
admin.php
Код:
<?php
session_start();
if (!isset($_SESSION['dostap'])) {
header("Location: login.php");
}
// тук останалия код от файла :)
?>
<?
require "config.php";
if ($action == 'delete') {
$sql = mysql_query("DELETE FROM servers WHERE id = '$nom'") or die(mysql_error());
header("Location: admin.php");
}
if($_GET['id']){
$lyricid = $_GET['id'];
$query1 = "SELECT * FROM `servers` where id = '$lyricid'";
$result1=mysql_query($query1);
while($row = mysql_fetch_array($result1)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];
echo '
Име<br /><input name="name" value='.$name.' type="text" size="30" /><br />
Ип<br /><input name="ip" value='.$ip.' type="text" size="30" /><br />
Порт<br /><input name="port" value='.$port.' type="text" size="30" /><br>
Anti-Cheat<br />
<select name="cheat">
<option value="" selected="selected">Посочи</option>
<option value="Няма">Няма</option>
<option value="Cheating-Death">Cheating-Death</option>
<option value=">MyAC">MyAC</option>
<option value="sXe Injected">sXe Injected</option>
<option value="HLGuard">HLGuard</option>
<option value="DonT Lie">DonT Lie</option>
<option value="Flex">Flex</option>
<option value="Друг">Друг</option>
</select><br>
Тип<br />
<select name="type">
<option value="" selected="selected">Посочи</option>
<option value="Classic">Classic</option>
<option value="Hide N Seek">Hide N Seek</option>
<option value="Kreedz">Kreedz</option>
<option value="Warcraft 3 / FT">Warcraft 3 / FT</option>
<option value="Zombie">Zombie</option>
<option value="Deathmatch">Deathmatch</option>
<option value="Cups">Cups</option>
<option value="5on5">5on5</option>
<option value="Massive">Massive</option>
<option value="Aim">Aim</option>
<option value="SuperHero">SuperHero</option>
<option value="GunGame">GunGame</option>
<option value="Deathrun">Deathrun</option>
<option value="PaintBall">PaintBall</option>
<option value="Respawn">Respawn</option>
</select><br>
Автор<br /><input name="author" value='.$author.' type="text" size="30" />
<br /><br />
<input name="submit" type="submit" value="Добави" />
</form>
';
if($_POST['editl']){
$name = htmlspecialchars(addslashes($_POST['name']));
$ip = htmlspecialchars(addslashes($_POST['ip']));
$port = htmlspecialchars(addslashes($_POST['port']));
$cheat = htmlspecialchars(addslashes($_POST['cheat']));
$type = htmlspecialchars(addslashes($_POST['type']));
$author = htmlspecialchars(addslashes($_POST['author']));
if(empty($izpulnitel) or empty($pesen) or empty($text) or empty($link)){
//Това го показва, когато някой не е попълнил всички полета
echo "Попълни всички полета!";
}
else {
$query = mysql_query("INSERT into `servers` (`id`,`name`,`ip`,`port`,`cheat`,`type`,`author`) VALUES ('','$name','$ip','$port','$cheat','$type','$author' WHERE id = '$_GET[id]' ")
or die(mysql_error());
//Това го показва, когато текста е добавен успешно
echo "Текстът е редактиран!";
echo "<meta http-equiv=Refresh content=0;url=admin.php>";
}
}
}
}
else {
$query = "SELECT * FROM `servers` ORDER BY id DESC";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$author = $row['author'];
echo "<a href='admin.php?id=$id'><table align='center' bgcolor='#FFFF00' width='50%' border='1px'>
<tr>
<td align='left' width='50%'>
$name <br />$ip:$port
</td>
<td align='left' width='30%'>
AC : $cheat
</td>
</td>
<td align='center' width='40%'>
<a href='info.php?id=$id'>Инфо</a>
</td>
</tr>
</table><center>edit</a>
<a title=\"Изтрийте песента: $izpulnitel - $pesen\" href=\"javascript:;\"
onClick=\"cf=confirm('Сигурен ли сте че искате да изтриете песента: $izpulnitel - $pesen ?!?!');
if (cf)window.location='del.php?id=$id';
return false;\" valign='top'>Изтрий</a><br>";
}
}
?>
del.php
Код:
<?php
session_start();
if (!isset($_SESSION['dostap'])) {
header("Location: login.php");
}
// тук останалия код от файла :)
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<?PHP {
include("config.php");
$id = $_GET['id'];
if(!$id){echo"Изберете текст , който да триете!";}else{
$result = mysql_query("DELETE FROM servers WHERE id='$id' ");
echo "<meta http-equiv=\"refresh\" content=\"1; url=admin.php\">Успешно!";}}
?>
login.php
Код:
<?php
session_start();
if (!isset($_SESSION['dostap']) && isset($_POST['submit']) && $_POST['nick'] == 'demo' && $_POST['pass'] == 'demo') {
$_SESSION['dostap'] = TRUE;
}
if (!isset($_SESSION['dostap'])) {
?>
<form action="" method="post">
<table align="center" class="e">
<caption><b>Контрол Панел</b></caption>
<tr>
<td>Име: </td> <td><input type="text" name="nick" size="20" class="user"></td>
</tr>
<br />
<tr>
<td>Парола:</td> <td><input type="password" name="pass" size="20" class="pass"></td>
</tr>
<br />
<tr>
<td></td> <td><input type="submit" name="submit" value="Влез" class="button"></td>
</tr>
</form>
<?php
exit;
}
?>
<center>
<div class='navigmenu'>
<a href="admin.php">Админ панел</a>
<div class='hr'></div>
<a href="add_server.php">Добавяне сървър</a>
<div class='hr'></div></center>
ето и линк http://www.wikiupload.com/middle_page.php?id=104875[/u]