Counter-Strike 1.6
CS1.BG | DUST2 NOSHTA GARMI [RANKED PLAY] #1
45.144.155.113:27015
de_dust2
Играчи: 30/32
de_dust2
Counter-Strike 1.6
Cs-PlovdiV.com - Aim Attack 93.123.16.4:27022 aim_aztec Играчи: 0/16

Проблем със СМС система, Field `active` doesn't have default value

PHP, MySQL, JavaScript, HTML, CSS и др.
Аватар
KILLARA
Извън линия
Потребител
Потребител
Мнения: 40
Регистриран на: 15 Ное 2016, 08:57
Обратна връзка:

Проблем със СМС система, Field `active` doesn't have default value

Мнение от KILLARA » 01 Мар 2017, 15:07

Имам проблем със това ще ми кажете ли от какво е мисля, че е от таблицата Изображение
Последно промяна от TheRedShoko на 01 Мар 2017, 16:08, променено общо 1 път.
Причина: Редактирано заглавие.

Аватар
hackera457
Извън линия
Потребител
Потребител
Мнения: 768
Регистриран на: 01 Ное 2016, 09:46
Местоположение: София
Се отблагодари: 1 път
Получена благодарност: 124 пъти
Обратна връзка:

Re: Проблем !

Мнение от hackera457 » 01 Мар 2017, 15:32

Полето `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"){
}  


Аватар
KILLARA
Извън линия
Потребител
Потребител
Мнения: 40
Регистриран на: 15 Ное 2016, 08:57
Обратна връзка:

Re: Проблем със СМС система, Field `active` doesn't have default value

Мнение от KILLARA » 01 Мар 2017, 17:18

Как да го задам трябва ли да сложа някакви цифри или нещо друго ?

edit: Оправих се намерих което ми каза стана благодаря но имам още проблем със добавяне на сървъри !

Изображение

Аватар
JustyleR
Извън линия
Модератор
Модератор
Мнения: 560
Регистриран на: 24 Фев 2017, 18:59
Се отблагодари: 33 пъти
Получена благодарност: 132 пъти
Обратна връзка:

Re: Проблем със СМС система, Field `active` doesn't have default value

Мнение от JustyleR » 02 Мар 2017, 00:32

Дай да видя самата таблица.
Дай да видя заявката от скрипта.

Научете се да давате малко повече информация за проблема..
Discord сървър, чрез който можете да се свържете с мен.


Аватар
KILLARA
Извън линия
Потребител
Потребител
Мнения: 40
Регистриран на: 15 Ное 2016, 08:57
Обратна връзка:

Re: Проблем със СМС система, Field `active` doesn't have default value

Мнение от KILLARA » 02 Мар 2017, 14:34

Ето ти таблицата

Код за потвърждение: Избери целия код

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

Мнение от JustyleR » 03 Мар 2017, 01:18

Пробвай така, ако пак не стане значи проблема идва от друго място (мисля, че знам от къде).

Само да попитам, някакви логове в 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 -->
Discord сървър, чрез който можете да се свържете с мен.


Аватар
KILLARA
Извън линия
Потребител
Потребител
Мнения: 40
Регистриран на: 15 Ное 2016, 08:57
Обратна връзка:

Re: Проблем със СМС система, Field `active` doesn't have default value

Мнение от KILLARA » 05 Мар 2017, 14:40

Не става пак е същото и нямам error log !

Публикувай отговор
  • Подобни теми
    Отговори
    Преглеждания
     Последно мнение

Обратно към “Уеб Програмиране”

Кой е на линия

Потребители разглеждащи този форум: Bing [Bot] и 0 госта