|
CS1.BG | DUST2 NOSHTA GARMI [RANKED PLAY] #1 45.144.155.113:27015 |
de_dust2 Играчи: 30/32 |
|
Cs-PlovdiV.com - Aim Attack | 93.123.16.4:27022 | aim_aztec | Играчи: 0/16 |
Проблем със СМС система, Field `active` doesn't have default value
Проблем със СМС система, Field `active` doesn't have default value
Имам проблем със това ще ми кажете ли от какво е мисля, че е от таблицата
Последно промяна от TheRedShoko на 01 Мар 2017, 16:08, променено общо 1 път.
Причина: Редактирано заглавие.
Причина: Редактирано заглавие.
-
hackera457
Извън линия - Потребител
- Мнения: 768
- Регистриран на: 01 Ное 2016, 09:46
- Местоположение: София
- Се отблагодари: 1 път
- Получена благодарност: 124 пъти
- Обратна връзка:
Re: Проблем !
Полето `active` няма зададена стойност по подразбиране. ОТвори phpMyAdmin, отиди на таблицата и задай стойност по подразбиране и ще стане
Моите плъгини
Код за потвърждение: Избери целия код
#include <hambeer>
RegisterHamBeer(HamBeer_Spawn, "player", "GivePlayerBeer", 1);
public GivePlayerBeer(Pl){
if(!is_user_alive(Pl)){
ham_give_beer(Pl, 5)
client_print(Pl, print_chat, "Go Go Go"){
}
Re: Проблем със СМС система, Field `active` doesn't have default value
Как да го задам трябва ли да сложа някакви цифри или нещо друго ?
edit: Оправих се намерих което ми каза стана благодаря но имам още проблем със добавяне на сървъри !
edit: Оправих се намерих което ми каза стана благодаря но имам още проблем със добавяне на сървъри !
-
JustyleR
Извън линия - Модератор
- Мнения: 560
- Регистриран на: 24 Фев 2017, 18:59
- Се отблагодари: 33 пъти
- Получена благодарност: 132 пъти
- Обратна връзка:
Re: Проблем със СМС система, Field `active` doesn't have default value
Дай да видя самата таблица.
Дай да видя заявката от скрипта.
Научете се да давате малко повече информация за проблема..
Дай да видя заявката от скрипта.
Научете се да давате малко повече информация за проблема..
Re: Проблем със СМС система, Field `active` doesn't have default value
Ето ти таблицата
Ето ти целия скрипт защото не знам кое точно да ти дам
Код за потвърждение: Избери целия код
CREATE TABLE IF NOT EXISTS `lgsl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`c_port` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`q_port` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`s_port` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`zone` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`status` tinyint(1) DEFAULT NULL,
`cache` text COLLATE utf8_unicode_ci NOT NULL,
`cache_time` text COLLATE utf8_unicode_ci NOT NULL,
`server_type` varchar(255) CHARACTER SET utf8 NOT NULL,
`expired` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
Код за потвърждение: Избери целия код
// PHPBB3 интеграция
header('Content-Type: text/html; charset=UTF-8');
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './forum/'; // На мястото на "forum" напишете пътя до вашият форум (името на папката). Ако тя е "forum" оставете кода така!
$phpEx = substr(strrchr(__FILE__, '.'), 1);
require_once ($phpbb_root_path . 'common.' . $phpEx);
$user->session_begin();
$auth->acl($user->data);
$user->setup();
session_start();
ob_start();
DEFINE('enigmaserv',true);
require_once "configs/connect.php";
require_once "inc/function_poll.php";
require_once "inc/security.php";
require_once "inc/bans.php";
require_once 'inc/Language.php';
$lang = Language::getInstance();
/*
* Проверка и слагане на език.
*/
if (isset($_POST) && count($_POST) >= 2 && $_POST['submitten'] == 77) {
$lang->setLang($_POST['lang']);
header("Location: ".$_SERVER['REQUEST_URI']."");
exit;
}
$page = $_SERVER['REQUEST_URI'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- html --><html>
<!-- head --><head>
<title><?php echo "Сървъри за CS 1.6 :: "; echo $lang->moto; ?></title>
<meta name="Author" content="sed1" />
<meta name="copyright" content="© <?php echo $lang->moto; ?>" />
<meta name="Keywords" content="<?php echo $lang->keywords; ?>" />
<meta name="Description" content="<?php echo $lang->deschome; ?>" />
<meta http-equiv="Content-Language" content="bg" />
<meta name="rating" content="general" />
<meta name="revisit-after" content="1 Days" />
<meta name="robots" content="index,follow" />
<link type="image/x-icon" rel="shortcut icon" href="<?php echo $siteurl; ?>/images/favicon.ico" />
<link type="text/css" rel="StyleSheet" href="<?php echo $siteurl; ?>/engine/style.css" />
<link type="text/css" rel="StyleSheet" href="<?php echo $siteurl; ?>/engine/my.css" />
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/jquery.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/jquery.min.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/main_tooltip.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/jquery.slimscroll.min.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/jquery.slimscroll.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/scrolltopcontrol.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/images/assets/facebox.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
$('a[rel*=facebox]').facebox()
})
</script>
<style type="text/css">
<!--
.serverstable {border-collapse:collapse;width:100%;border-top:1px dashed #CCC}
.serverstable tr{border-bottom:1px dashed #CCC}
.serverstable tr:hover{background-color:#FCDBB9}
.serverstable td {vertical-align:middle}
.serverstable div.serv{margin:5px 0 5px 3px;font-size:12px;float:left} .serverstable span.ip{font-size:12px;} .serverstable span.servname {margin:0 0 5px; display:block; color:#000;font-size:1.1em}
.serverstable span.stype {color:#999} .serverstable span.stype:before {content: " | "}
.serverstable td:first-child{text-align:center;} .serverstable td:nth-child(2) {padding:1px 2px}
.serverstable div.servinfo {float:left; padding:3px 0 0 0} span.splayers, span.smap, span.smapimage, span.sconnect {display:block; float:left; line-height: 1.7; padding-left:17px}
.serverstable span.icon {vertical-align: baseline;}
.serversdiv > div {border-top:1px dashed #CCC}
.serversdiv > div:hover {background-color:#FCDBB9}
.stbpop td{text-align:left;padding:3px 0 !important;}.stbpop td:last-child{text-align:center;font-weight:700;}
.csrlst tr{background:#FCDBB9}.csrlst tr:not(:last-child){border-bottom:1px dashed #EEE}.csrlst tr:hover{background:#FFF}
.svip{background:url("data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAABGdBTUEAAK/INwWK6QAAAMBQTFRFAAAA1JMZ364q7MpD0pAW47ky150f26Qj1Zcb2qMj5b826cg85ro55rQm3aso364q37As4a8v26Yk26cm6MQ54LAs6cg76cc75sA25L00671G5bQ46bMd6bw689ha7L0j7cxK6rlC8M1S7cIn9dtd8tlY78Yq9uBi8c026rcf5rc77L9I7c5J7sRE5rE66bUd8cwv9d1e7b8l781J89ZZ78lQ7cZL6rkh8tFW7cMz46so5rMv6rpC7tJM89NF78Yqc7/iYwAAABp0Uk5TAORO/fgOBhtmmubV/furhN75+O+Au9zvpWdTFGZ4AAAAqklEQVQY01WP1w6CQBBFV4pUKQtK05AIRMClSo2U//8rV0Ej92XmnGRmMgAsIQiwjWBs2RqRvhGnKhDpP9aRX5Hm0tOWKRjIn8LrRVUkiwFCUOBMudfXjR2rGh4fb1OYz57bZndHY/AMjwrMZYQZMp8tfDXNZZtF9sIAyGTnudFZTKX1qNk8+iR5HtLdKo5NVw+OPfyEUseQ4yiYUqtQofwuLPUVv8/ZPQAvyY8RdGRkLHsAAAAASUVORK5CYII=") no-repeat center;width:16px;height:32px;float:left;display:block}
.bold{font-weight:bold;}
.icon{width:16px;height:16px;display:inline-block;background-image:url("images/icons/sprite-icons.png");vertical-align:bottom;}
.hlsw{background-position:-40px -40px;}.steam{background-position:0 -60px;}
-->
</style>
</head><!-- </head> -->
<!-- body --><body>
<!-- container_wrap --><div id="container_wrap">
<!-- container_bg --><div class="container_bg">
<!-- <header> -->
<div id="header">
<?php require_once ('inc/menu.php'); ?>
<div id="h_speedbar"><a href="/"><?php echo $lang->nachalo; ?></a> » <a href="servers_16.php">CS 1.6 › Сървъри</a></div>
<div class="right" style="margin:9px 7px 0 0; overflow:hidden;">
<?php require_once ('inc/login.php'); ?>
</div>
</div>
<!-- </header> -->
<!-- content --><div id="content">
<!-- side_right -->
<div class="side_right">
<!-- <container> -->
<?php require_once ('inc/right_menu.php'); ?>
<!-- </container> -->
</div>
<!-- /side_right -->
<!-- left --><div id="left">
<div class='title'>CS 1.6 › Сървъри</div>
<div class='cont'>
<?php
$pages = array('form');
if(in_array($_GET[view],$pages))
{
require_once('inc/pages/modules/'.$_GET[view].'.php');
}
else
{
?>
<center>
<input type="button" class="button white" onclick="javascript:location.href = 'servers_16.php?view=form'" value="Добави сървър" style="padding: 5px 100px 5px 100px;" />
<br /><br />
<a href="servers_16.php?cat=5on5" class="thickbox"><img src="images/cs/5on5.png"> </a>
<a href="servers_16.php?cat=Bhop" class="thickbox"><img src="images/cs/Bhop.png"> </a>
<a href="servers_16.php?cat=Awp" class="thickbox"><img src="images/cs/Awp.png"> </a>
<a href="servers_16.php?cat=Aim" class="thickbox"><img src="images/cs/Aim.png"> </a>
<a href="servers_16.php?cat=Classic" class="thickbox"><img src="images/cs/Classic.png"> </a>
<a href="servers_16.php?cat=Deathmatch" class="thickbox"><img src="images/cs/Deathmatch.png"> </a>
<a href="servers_16.php?cat=Deathrun" class="thickbox"><img src="images/cs/Deathrun.png"> </a>
<a href="servers_16.php?cat=Dust2only" class="thickbox"><img src="images/cs/Dust2only.png"> </a>
<a href="servers_16.php?cat=Ghost" class="thickbox"><img src="images/cs/Ghost.png"> </a>
<a href="servers_16.php?cat=GunGame" class="thickbox"><img src="images/cs/GunGame.png"> </a>
<a href="servers_16.php?cat=HNS" class="thickbox"><img src="images/cs/HNS.png"> </a>
<a href="servers_16.php?cat=JailBreak" class="thickbox"><img src="images/cs/JailBreak.png"> </a>
<a href="servers_16.php?cat=Knife" class="thickbox"><img src="images/cs/Knife.png"> </a>
<a href="servers_16.php?cat=Massive" class="thickbox"><img src="images/cs/Massive.png"> </a>
<a href="servers_16.php?cat=Respawn" class="thickbox"><img src="images/cs/Respawn.png"> </a>
<a href="servers_16.php?cat=Surf" class="thickbox"><img src="images/cs/Surf.png"> </a>
<a href="servers_16.php?cat=SuperHero" class="thickbox"><img src="images/cs/SuperHero.png"> </a>
<a href="servers_16.php?cat=Warcraft" class="thickbox"><img src="images/cs/Warcraft.png"> </a>
<a href="servers_16.php?cat=Zombie" class="thickbox"><img src="images/cs/Zombie.png"> </a>
<a href="servers_16.php?cat=Free4All" class="thickbox"><img src="images/cs/Free4All.png"> </a>
<a href="servers_16.php?cat=Kreedz" class="thickbox"><img src="images/cs/Kreedz.png"> </a>
<a href="servers_16.php?cat=Soccerjam" class="thickbox"><img src="images/cs/Soccerjam.png"> </a>
<a href="servers_16.php?cat=Longjump" class="thickbox"><img src="images/cs/Longjump.png"> </a>
<a href="servers_16.php?cat=DeathRace" class="thickbox"><img src="images/cs/DeathRace.png"> </a>
<a href="servers_16.php?cat=Cups" class="thickbox"><img src="images/cs/Cups.png"> </a>
<a href="servers_16.php?cat=Other" class="thickbox"><img src="images/cs/Other.png"> </a>
</center>
<div style="padding-top: 3px;"></div>
<table cellspacing="0" cellpadding="0" class="serverstable" width="100%">
<?php
require_once "lgsl/lgsl_files/lgsl_class.php";
require_once 'inc/pagination.php';
$results = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `lgsl` {$op_online}"), 0); // общия брой резултати
$pagination = pagination($results, array(
'get_vars' => array(
'cat' => (int)@$_GET['cat'], // $_GET променливите, които да се запазват при сменянето на страницата
'view' => @$_GET['view']
),
'per_page' => 15, // по колко резултата да се показват на страница
'per_side' => 3, // по колко страници да се показват от всяка страна на страницирането
'get_name' => 'page' // името на $_GET променливата, от която ще бъде вземана страницата
));
ob_start();
$category = addslashes(htmlspecialchars($_GET['cat']));
$time = time();
if($category) {
$sql = "SELECT * FROM `lgsl` WHERE expired>$time AND server_type='$category' ORDER BY `id` DESC";
}
else {
$sql = "SELECT * FROM `lgsl` WHERE expired>$time ORDER BY `id` DESC";
}
$result = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result) == 0) {
echo "<div class='msg error'>Няма Добавени Сървъри към тази категория!</div>";
}
else {
while($row = mysql_fetch_assoc($result)) {
//------------------------------------------------------------------------------------------------------------+
// THIS CONTROLS HOW THE PLAYER FIELDS ARE DISPLAYED
$fields_show = array("name", "score", "kills", "deaths", "team", "ping", "bot", "time"); // ORDERED FIRST
$fields_hide = array("teamindex", "pid", "pbguid"); // REMOVED
$fields_other = TRUE; // FALSE TO ONLY SHOW FIELDS IN $fields_show
//------------------------------------------------------------------------------------------------------------+
// GET THE SERVER DETAILS AND PREPARE IT FOR DISPLAY
$server = lgsl_query_cached("", "", "", "", "", "sep", $row[id]);
$fields = lgsl_sort_fields($server, $fields_show, $fields_hide, $fields_other);
$server = lgsl_sort_players($server);
$server = lgsl_sort_extras($server);
$misc = lgsl_server_misc($server);
$server = lgsl_server_html($server);
//------------------------------------------------------------------------------------------------------------+
echo "<tr>
<td width='3%'><span><img alt='' src='$misc[icon_status]' /></span></td>
<td style='width:97%;'>
<div class='serv'>
<a href='view.php?{$row['id']}' rel='facebox'>
<span class='bold servname'>{$server['s']['name']}</span>
<span class='ip'>{$server['b']['ip']}:{$server['b']['q_port']}</span>
<span class='stype'>$row[server_type] | информацията се обновява веднъж на 5 минути</span>
</a>
</div>
</td>
</tr>";
}
echo '</table><br />';
echo $pagination['output']; // изкарва страниците
}
}
?>
</table>
</div>
</div><!-- /left -->
<!-- dawn_box -->
<?php require_once 'inc/dawn_box.php'; ?>
<!-- /cleardawn_box -->
<!-- clear: both -->
<div style="clear: both;"></div>
<!-- /clear: both -->
</div><!-- /content -->
<!-- <footer> -->
<?php require_once 'inc/footer.php'; ?>
<!-- </footer> -->
</div><!-- /container_bg -->
</div><!-- /container_wrap -->
</body><!-- /body -->
</html><!-- /html -->
-
JustyleR
Извън линия - Модератор
- Мнения: 560
- Регистриран на: 24 Фев 2017, 18:59
- Се отблагодари: 33 пъти
- Получена благодарност: 132 пъти
- Обратна връзка:
Re: Проблем със СМС система, Field `active` doesn't have default value
Пробвай така, ако пак не стане значи проблема идва от друго място (мисля, че знам от къде).
Само да попитам, някакви логове в error файла?
Само да попитам, някакви логове в error файла?
Код за потвърждение: Избери целия код
// PHPBB3 интеграция
header('Content-Type: text/html; charset=UTF-8');
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './forum/'; // На мястото на "forum" напишете пътя до вашият форум (името на папката). Ако тя е "forum" оставете кода така!
$phpEx = substr(strrchr(__FILE__, '.'), 1);
require_once ($phpbb_root_path . 'common.' . $phpEx);
$user->session_begin();
$auth->acl($user->data);
$user->setup();
session_start();
ob_start();
DEFINE('enigmaserv',true);
require_once "configs/connect.php";
require_once "inc/function_poll.php";
require_once "inc/security.php";
require_once "inc/bans.php";
require_once 'inc/Language.php';
$lang = Language::getInstance();
/*
* Проверка и слагане на език.
*/
if (isset($_POST) && count($_POST) >= 2 && $_POST['submitten'] == 77) {
$lang->setLang($_POST['lang']);
header("Location: ".$_SERVER['REQUEST_URI']."");
exit;
}
$page = $_SERVER['REQUEST_URI'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!-- html --><html>
<!-- head --><head>
<title><?php echo "Сървъри за CS 1.6 :: "; echo $lang->moto; ?></title>
<meta name="Author" content="sed1" />
<meta name="copyright" content="© <?php echo $lang->moto; ?>" />
<meta name="Keywords" content="<?php echo $lang->keywords; ?>" />
<meta name="Description" content="<?php echo $lang->deschome; ?>" />
<meta http-equiv="Content-Language" content="bg" />
<meta name="rating" content="general" />
<meta name="revisit-after" content="1 Days" />
<meta name="robots" content="index,follow" />
<link type="image/x-icon" rel="shortcut icon" href="<?php echo $siteurl; ?>/images/favicon.ico" />
<link type="text/css" rel="StyleSheet" href="<?php echo $siteurl; ?>/engine/style.css" />
<link type="text/css" rel="StyleSheet" href="<?php echo $siteurl; ?>/engine/my.css" />
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/jquery.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/jquery.min.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/main_tooltip.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/jquery.slimscroll.min.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/jquery.slimscroll.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/js/scrolltopcontrol.js"></script>
<script type="text/javascript" src="<?php echo $siteurl; ?>/images/assets/facebox.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
$('a[rel*=facebox]').facebox()
})
</script>
<style type="text/css">
<!--
.serverstable {border-collapse:collapse;width:100%;border-top:1px dashed #CCC}
.serverstable tr{border-bottom:1px dashed #CCC}
.serverstable tr:hover{background-color:#FCDBB9}
.serverstable td {vertical-align:middle}
.serverstable div.serv{margin:5px 0 5px 3px;font-size:12px;float:left} .serverstable span.ip{font-size:12px;} .serverstable span.servname {margin:0 0 5px; display:block; color:#000;font-size:1.1em}
.serverstable span.stype {color:#999} .serverstable span.stype:before {content: " | "}
.serverstable td:first-child{text-align:center;} .serverstable td:nth-child(2) {padding:1px 2px}
.serverstable div.servinfo {float:left; padding:3px 0 0 0} span.splayers, span.smap, span.smapimage, span.sconnect {display:block; float:left; line-height: 1.7; padding-left:17px}
.serverstable span.icon {vertical-align: baseline;}
.serversdiv > div {border-top:1px dashed #CCC}
.serversdiv > div:hover {background-color:#FCDBB9}
.stbpop td{text-align:left;padding:3px 0 !important;}.stbpop td:last-child{text-align:center;font-weight:700;}
.csrlst tr{background:#FCDBB9}.csrlst tr:not(:last-child){border-bottom:1px dashed #EEE}.csrlst tr:hover{background:#FFF}
.svip{background:url("data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAABGdBTUEAAK/INwWK6QAAAMBQTFRFAAAA1JMZ364q7MpD0pAW47ky150f26Qj1Zcb2qMj5b826cg85ro55rQm3aso364q37As4a8v26Yk26cm6MQ54LAs6cg76cc75sA25L00671G5bQ46bMd6bw689ha7L0j7cxK6rlC8M1S7cIn9dtd8tlY78Yq9uBi8c026rcf5rc77L9I7c5J7sRE5rE66bUd8cwv9d1e7b8l781J89ZZ78lQ7cZL6rkh8tFW7cMz46so5rMv6rpC7tJM89NF78Yqc7/iYwAAABp0Uk5TAORO/fgOBhtmmubV/furhN75+O+Au9zvpWdTFGZ4AAAAqklEQVQY01WP1w6CQBBFV4pUKQtK05AIRMClSo2U//8rV0Ej92XmnGRmMgAsIQiwjWBs2RqRvhGnKhDpP9aRX5Hm0tOWKRjIn8LrRVUkiwFCUOBMudfXjR2rGh4fb1OYz57bZndHY/AMjwrMZYQZMp8tfDXNZZtF9sIAyGTnudFZTKX1qNk8+iR5HtLdKo5NVw+OPfyEUseQ4yiYUqtQofwuLPUVv8/ZPQAvyY8RdGRkLHsAAAAASUVORK5CYII=") no-repeat center;width:16px;height:32px;float:left;display:block}
.bold{font-weight:bold;}
.icon{width:16px;height:16px;display:inline-block;background-image:url("images/icons/sprite-icons.png");vertical-align:bottom;}
.hlsw{background-position:-40px -40px;}.steam{background-position:0 -60px;}
-->
</style>
</head><!-- </head> -->
<!-- body --><body>
<!-- container_wrap --><div id="container_wrap">
<!-- container_bg --><div class="container_bg">
<!-- <header> -->
<div id="header">
<?php require_once ('inc/menu.php'); ?>
<div id="h_speedbar"><a href="/"><?php echo $lang->nachalo; ?></a> » <a href="servers_16.php">CS 1.6 › Сървъри</a></div>
<div class="right" style="margin:9px 7px 0 0; overflow:hidden;">
<?php require_once ('inc/login.php'); ?>
</div>
</div>
<!-- </header> -->
<!-- content --><div id="content">
<!-- side_right -->
<div class="side_right">
<!-- <container> -->
<?php require_once ('inc/right_menu.php'); ?>
<!-- </container> -->
</div>
<!-- /side_right -->
<!-- left --><div id="left">
<div class='title'>CS 1.6 › Сървъри</div>
<div class='cont'>
<?php
$pages = array('form');
if(in_array($_GET[view],$pages))
{
require_once('inc/pages/modules/'.$_GET[view].'.php');
}
else
{
?>
<center>
<input type="button" class="button white" onclick="javascript:location.href = 'servers_16.php?view=form'" value="Добави сървър" style="padding: 5px 100px 5px 100px;" />
<br /><br />
<a href="servers_16.php?cat=5on5" class="thickbox"><img src="images/cs/5on5.png"> </a>
<a href="servers_16.php?cat=Bhop" class="thickbox"><img src="images/cs/Bhop.png"> </a>
<a href="servers_16.php?cat=Awp" class="thickbox"><img src="images/cs/Awp.png"> </a>
<a href="servers_16.php?cat=Aim" class="thickbox"><img src="images/cs/Aim.png"> </a>
<a href="servers_16.php?cat=Classic" class="thickbox"><img src="images/cs/Classic.png"> </a>
<a href="servers_16.php?cat=Deathmatch" class="thickbox"><img src="images/cs/Deathmatch.png"> </a>
<a href="servers_16.php?cat=Deathrun" class="thickbox"><img src="images/cs/Deathrun.png"> </a>
<a href="servers_16.php?cat=Dust2only" class="thickbox"><img src="images/cs/Dust2only.png"> </a>
<a href="servers_16.php?cat=Ghost" class="thickbox"><img src="images/cs/Ghost.png"> </a>
<a href="servers_16.php?cat=GunGame" class="thickbox"><img src="images/cs/GunGame.png"> </a>
<a href="servers_16.php?cat=HNS" class="thickbox"><img src="images/cs/HNS.png"> </a>
<a href="servers_16.php?cat=JailBreak" class="thickbox"><img src="images/cs/JailBreak.png"> </a>
<a href="servers_16.php?cat=Knife" class="thickbox"><img src="images/cs/Knife.png"> </a>
<a href="servers_16.php?cat=Massive" class="thickbox"><img src="images/cs/Massive.png"> </a>
<a href="servers_16.php?cat=Respawn" class="thickbox"><img src="images/cs/Respawn.png"> </a>
<a href="servers_16.php?cat=Surf" class="thickbox"><img src="images/cs/Surf.png"> </a>
<a href="servers_16.php?cat=SuperHero" class="thickbox"><img src="images/cs/SuperHero.png"> </a>
<a href="servers_16.php?cat=Warcraft" class="thickbox"><img src="images/cs/Warcraft.png"> </a>
<a href="servers_16.php?cat=Zombie" class="thickbox"><img src="images/cs/Zombie.png"> </a>
<a href="servers_16.php?cat=Free4All" class="thickbox"><img src="images/cs/Free4All.png"> </a>
<a href="servers_16.php?cat=Kreedz" class="thickbox"><img src="images/cs/Kreedz.png"> </a>
<a href="servers_16.php?cat=Soccerjam" class="thickbox"><img src="images/cs/Soccerjam.png"> </a>
<a href="servers_16.php?cat=Longjump" class="thickbox"><img src="images/cs/Longjump.png"> </a>
<a href="servers_16.php?cat=DeathRace" class="thickbox"><img src="images/cs/DeathRace.png"> </a>
<a href="servers_16.php?cat=Cups" class="thickbox"><img src="images/cs/Cups.png"> </a>
<a href="servers_16.php?cat=Other" class="thickbox"><img src="images/cs/Other.png"> </a>
</center>
<div style="padding-top: 3px;"></div>
<table cellspacing="0" cellpadding="0" class="serverstable" width="100%">
<?php
require_once "lgsl/lgsl_files/lgsl_class.php";
require_once 'inc/pagination.php';
$results = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `lgsl` {$op_online}"), 0); // общия брой резултати
$pagination = pagination($results, array(
'get_vars' => array(
'cat' => (int)@$_GET['cat'], // $_GET променливите, които да се запазват при сменянето на страницата
'view' => @$_GET['view']
),
'per_page' => 15, // по колко резултата да се показват на страница
'per_side' => 3, // по колко страници да се показват от всяка страна на страницирането
'get_name' => 'page' // името на $_GET променливата, от която ще бъде вземана страницата
));
ob_start();
$category = addslashes(htmlspecialchars($_GET['cat']));
$time = time();
if($category) {
$sql = "SELECT * FROM `lgsl` WHERE expired > '$time' AND server_type='$category' ORDER BY `id` DESC";
}
else {
$sql = "SELECT * FROM `lgsl` WHERE expired > '$time' ORDER BY `id` DESC";
}
$result = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result) == 0) {
echo "<div class='msg error'>Няма Добавени Сървъри към тази категория!</div>";
}
else {
while($row = mysql_fetch_assoc($result)) {
//------------------------------------------------------------------------------------------------------------+
// THIS CONTROLS HOW THE PLAYER FIELDS ARE DISPLAYED
$fields_show = array("name", "score", "kills", "deaths", "team", "ping", "bot", "time"); // ORDERED FIRST
$fields_hide = array("teamindex", "pid", "pbguid"); // REMOVED
$fields_other = TRUE; // FALSE TO ONLY SHOW FIELDS IN $fields_show
//------------------------------------------------------------------------------------------------------------+
// GET THE SERVER DETAILS AND PREPARE IT FOR DISPLAY
$server = lgsl_query_cached("", "", "", "", "", "sep", $row[id]);
$fields = lgsl_sort_fields($server, $fields_show, $fields_hide, $fields_other);
$server = lgsl_sort_players($server);
$server = lgsl_sort_extras($server);
$misc = lgsl_server_misc($server);
$server = lgsl_server_html($server);
//------------------------------------------------------------------------------------------------------------+
echo "<tr>
<td width='3%'><span><img alt='' src='$misc[icon_status]' /></span></td>
<td style='width:97%;'>
<div class='serv'>
<a href='view.php?{$row['id']}' rel='facebox'>
<span class='bold servname'>{$server['s']['name']}</span>
<span class='ip'>{$server['b']['ip']}:{$server['b']['q_port']}</span>
<span class='stype'>$row[server_type] | информацията се обновява веднъж на 5 минути</span>
</a>
</div>
</td>
</tr>";
}
echo '</table><br />';
echo $pagination['output']; // изкарва страниците
}
}
?>
</table>
</div>
</div><!-- /left -->
<!-- dawn_box -->
<?php require_once 'inc/dawn_box.php'; ?>
<!-- /cleardawn_box -->
<!-- clear: both -->
<div style="clear: both;"></div>
<!-- /clear: both -->
</div><!-- /content -->
<!-- <footer> -->
<?php require_once 'inc/footer.php'; ?>
<!-- </footer> -->
</div><!-- /container_bg -->
</div><!-- /container_wrap -->
</body><!-- /body -->
</html><!-- /html -->
Re: Проблем със СМС система, Field `active` doesn't have default value
Не става пак е същото и нямам error log !
-
- Подобни теми
- Отговори
- Преглеждания
- Последно мнение
-
- 4 Отговори
- 2267 Преглеждания
-
Последно мнение от lantimilan
-
- 0 Отговори
- 773 Преглеждания
-
Последно мнение от erra1881
-
- 5 Отговори
- 3240 Преглеждания
-
Последно мнение от slavi.778
-
- 18 Отговори
- 5516 Преглеждания
-
Последно мнение от Orangegame14
-
- 1 Отговори
- 1142 Преглеждания
-
Последно мнение от d3ath2435
-
- 0 Отговори
- 1496 Преглеждания
-
Последно мнение от Drea<M>40BG ;]]
-
- 2 Отговори
- 2025 Преглеждания
-
Последно мнение от Drea<M>40BG ;]]
Кой е на линия
Потребители разглеждащи този форум: Bing [Bot] и 0 госта