Здравейте!
Някой може ли да ми каве къде е грешката в този sql код ?
Някой може ли да ми каве къде е грешката в този sql код ?
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- База данных:
--
-- --------------------------------------------------------
--
-- Структура таблицы `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
`gid` tinyint(4) NOT NULL auto_increment,
`gname` varchar(50) default NULL,
PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
--
-- Дамп данных таблицы `groups`
--
INSERT INTO `groups` (`gid`, `gname`) VALUES
(1, 'Classic'),
(2, 'Gungame'),
(3, 'Arena'),
(4, 'Zombie'),
(5, 'ClanWar'),
(6, 'War3FT'),
(7, 'Hide''n''Seek '),
(8, 'SoccerJam'),
(9, 'SuperHero'),
(10, 'Kz Jump'),
(11, 'Rune'),
(12, 'DM FFA'),
(13, 'Surf'),
(14, 'CTF'),
(15, 'Other');
-- --------------------------------------------------------
--
-- Структура таблицы `lgsl`
--
CREATE TABLE IF NOT EXISTS `lgsl` (
`id` int(11) NOT NULL auto_increment,
`status` tinyint(1) NOT NULL default '0',
`ip` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`q_port` varchar(5) collate utf8_unicode_ci NOT NULL default '0',
`c_port` varchar(5) collate utf8_unicode_ci NOT NULL default '0',
`s_port` varchar(5) collate utf8_unicode_ci NOT NULL default '0',
`type` varchar(50) collate utf8_unicode_ci NOT NULL default '',
`cache` text collate utf8_unicode_ci NOT NULL,
`cache_time` text collate utf8_unicode_ci NOT NULL,
`zone` tinyint(1) NOT NULL default '0',
`disabled` tinyint(1) NOT NULL default '0',
`group` tinyint(4) default NULL,
`vip` tinyint(4) default '2',
`rating` int(11) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
--
-- Триггеры `lgsl`
--
DROP TRIGGER IF EXISTS `lgsl_after_upd_tr`;
DELIMITER //
CREATE TRIGGER `lgsl_after_upd_tr` AFTER UPDATE ON `lgsl`
FOR EACH ROW BEGIN
DECLARE server_exists INT;
IF (new.status = 0 and new.disabled = 0) THEN
select server_id into server_exists from offline where server_id = new.id;
if (server_exists is null) then
INSERT INTO offline SET server_id=new.id, server_timestamp=UNIX_TIMESTAMP(CURRENT_TIMESTAMP);
end if;
END IF;
IF (new.status = 1) THEN
DELETE FROM offline WHERE server_id=new.id /*and 2=1*/;
END IF;
update offline SET time_later = UNIX_TIMESTAMP(now())-server_timestamp;
update offline SET del = 1 where UNIX_TIMESTAMP(now())-server_timestamp >= 432000 and UNIX_TIMESTAMP(now())-server_timestamp < 604800;
update offline SET del = 2 where UNIX_TIMESTAMP(now())-server_timestamp > 604800 ;
END
//
DELIMITER ;
--
-- Дамп данных таблицы `lgsl`
--
INSERT INTO `lgsl` (`id`, `status`, `ip`, `q_port`, `c_port`, `s_port`, `type`, `cache`, `cache_time`, `zone`, `disabled`, `group`, `vip`, `rating`) VALUES
(1, 1, 'redacid.org.ua', '27014', '27014', '0', 'halflife', 'a:5:{s:1:"b";a:7:{s:2:"ip";s:14:"redacid.org.ua";s:6:"q_port";s:5:"27014";s:6:"c_port";s:5:"27014";s:6:"s_port";s:1:"0";s:4:"type";s:8:"halflife";s:7:"request";s:1:"s";s:6:"status";i:1;}s:1:"o";a:1:{s:2:"id";s:1:"1";}s:1:"s";a:6:{s:4:"name";s:28:"Redacid.org.ua - .:Gungame:.";s:3:"map";s:7:"gg_snox";s:4:"game";s:7:"cstrike";s:7:"players";i:9;s:10:"playersmax";i:22;s:8:"password";i:0;}s:1:"e";a:102:{s:35:"_tutor_bomb_viewable_check_interval";s:3:"0.5";s:18:"_tutor_debug_level";s:1:"0";s:19:"_tutor_examine_time";s:3:"0.5";s:25:"_tutor_hint_interval_time";s:4:"10.0";s:17:"_tutor_look_angle";s:2:"10";s:20:"_tutor_look_distance";s:3:"200";s:49:"_tutor_message_character_display_time_coefficient";s:4:"0.07";s:35:"_tutor_message_minimum_display_time";s:1:"1";s:22:"_tutor_message_repeats";s:1:"5";s:20:"_tutor_view_distance";s:4:"1000";s:16:"allow_spectators";s:1:"1";s:20:"amx_client_languages";s:1:"1";s:11:"amx_nextmap";s:11:"gg_33_circa";s:12:"amx_timeleft";s:5:"42:14";s:15:"amxbans_version";s:3:"5.0";s:15:"amxmodx_version";s:10:"1.8.1.3711";s:4:"coop";s:1:"0";s:10:"deathmatch";s:1:"1";s:14:"decalfrequency";s:2:"60";s:12:"edgefriction";s:1:"2";s:10:"gg_version";s:4:"2.12";s:13:"hostage_debug";s:1:"0";s:12:"hostage_stop";s:1:"0";s:16:"humans_join_team";s:3:"any";s:15:"max_queries_sec";s:1:"1";s:22:"max_queries_sec_global";s:1:"1";s:18:"max_queries_window";s:1:"1";s:15:"metamod_version";s:4:"1.19";s:16:"mp_allowmonsters";s:1:"0";s:11:"mp_autokick";s:1:"1";s:18:"mp_autoteambalance";s:1:"0";s:10:"mp_buytime";s:3:"0.5";s:10:"mp_c4timer";s:2:"25";s:11:"mp_chattime";s:2:"10";s:14:"mp_consistency";s:1:"1";s:14:"mp_fadetoblack";s:1:"0";s:13:"mp_flashlight";s:1:"1";s:12:"mp_footsteps";s:1:"1";s:14:"mp_forcecamera";s:1:"0";s:16:"mp_forcechasecam";s:1:"1";s:12:"mp_fragsleft";s:1:"0";s:13:"mp_freezetime";s:1:"1";s:15:"mp_friendlyfire";s:1:"0";s:17:"mp_ghostfrequency";s:3:"0.1";s:17:"mp_hostagepenalty";s:1:"3";s:14:"mp_kickpercent";s:4:"0.66";s:13:"mp_limitteams";s:1:"2";s:12:"mp_logdetail";s:1:"0";s:10:"mp_logfile";s:1:"1";s:14:"mp_logmessages";s:1:"1";s:15:"mp_mapvoteratio";s:4:"0.66";s:12:"mp_maxrounds";s:1:"0";s:15:"mp_mirrordamage";s:1:"0";s:11:"mp_playerid";s:1:"0";s:12:"mp_roundtime";s:1:"3";s:13:"mp_startmoney";s:3:"800";s:11:"mp_timeleft";s:1:"0";s:12:"mp_timelimit";s:2:"45";s:11:"mp_tkpunish";s:1:"0";s:16:"mp_windifference";s:1:"1";s:11:"mp_winlimit";s:1:"0";s:8:"pausable";s:1:"0";s:13:"sv_accelerate";s:1:"5";s:6:"sv_aim";s:1:"0";s:16:"sv_airaccelerate";s:2:"10";s:10:"sv_airmove";s:1:"0";s:14:"sv_allowupload";s:1:"0";s:10:"sv_alltalk";s:1:"0";s:9:"sv_bounce";s:1:"1";s:9:"sv_cheats";s:1:"0";s:14:"sv_clienttrace";s:1:"1";s:11:"sv_clipmode";s:1:"0";s:10:"sv_contact";s:21:"http://redacid.org.ua";s:11:"sv_friction";s:1:"4";s:10:"sv_gravity";s:3:"800";s:12:"sv_logblocks";s:1:"0";s:10:"sv_maxrate";s:5:"25000";s:11:"sv_maxspeed";s:3:"900";s:10:"sv_minrate";s:5:"20000";s:11:"sv_password";s:1:"0";s:10:"sv_proxies";s:1:"1";s:9:"sv_region";s:2:"-1";s:10:"sv_restart";s:1:"0";s:15:"sv_restartround";s:1:"0";s:11:"sv_stepsize";s:2:"18";s:12:"sv_stopspeed";s:2:"75";s:12:"sv_uploadmax";s:3:"0.5";s:14:"sv_voiceenable";s:1:"0";s:18:"sv_wateraccelerate";s:2:"10";s:16:"sv_waterfriction";s:1:"1";s:11:"description";s:14:"Counter-Strike";s:7:"netcode";i:47;s:9:"dedicated";s:1:"d";s:2:"os";s:1:"l";s:12:"mod_url_info";s:22:"www.counter-strike.net";s:16:"mod_url_download";s:0:"";s:11:"mod_version";i:1;s:8:"mod_size";i:184000000;s:15:"mod_server_side";i:0;s:14:"mod_custom_dll";i:1;s:9:"anticheat";i:0;s:4:"bots";i:0;}s:1:"p";a:0:{}}', '1245697117_1245378082_1245378082', 1, 0, 2, 1, 0),
(2, 1, 'redacid.org.ua', '27015', '27015', '0', 'halflife', 'a:5:{s:1:"b";a:7:{s:2:"ip";s:14:"redacid.org.ua";s:6:"q_port";s:5:"27015";s:6:"c_port";s:5:"27015";s:6:"s_port";s:1:"0";s:4:"type";s:8:"halflife";s:7:"request";s:1:"s";s:6:"status";i:1;}s:1:"o";a:1:{s:2:"id";s:1:"2";}s:1:"s";a:6:{s:4:"name";s:28:"Redacid.org.ua - .:Classic:.";s:3:"map";s:8:"de_aztec";s:4:"game";s:7:"cstrike";s:7:"players";i:10;s:10:"playersmax";i:22;s:8:"password";i:0;}s:1:"e";a:104:{s:35:"_tutor_bomb_viewable_check_interval";s:3:"0.5";s:18:"_tutor_debug_level";s:1:"0";s:19:"_tutor_examine_time";s:3:"0.5";s:25:"_tutor_hint_interval_time";s:4:"10.0";s:17:"_tutor_look_angle";s:2:"10";s:20:"_tutor_look_distance";s:3:"200";s:49:"_tutor_message_character_display_time_coefficient";s:4:"0.07";s:35:"_tutor_message_minimum_display_time";s:1:"1";s:22:"_tutor_message_repeats";s:1:"5";s:20:"_tutor_view_distance";s:4:"1000";s:16:"allow_spectators";s:1:"1";s:20:"amx_client_languages";s:1:"1";s:11:"amx_nextmap";s:7:"de_nuke";s:15:"amx_ptb_version";s:5:"1.8b3";s:12:"amx_timeleft";s:5:"28:52";s:15:"amxbans_version";s:3:"5.0";s:15:"amxmodx_version";s:10:"1.8.1.3711";s:12:"atac_version";s:5:"3.0.1";s:4:"coop";s:1:"0";s:10:"deathmatch";s:1:"1";s:14:"decalfrequency";s:2:"60";s:12:"edgefriction";s:1:"2";s:13:"hostage_debug";s:1:"0";s:12:"hostage_stop";s:1:"0";s:16:"humans_join_team";s:3:"any";s:15:"max_queries_sec";s:1:"1";s:22:"max_queries_sec_global";s:1:"1";s:18:"max_queries_window";s:1:"1";s:15:"metamod_version";s:4:"1.19";s:16:"mp_allowmonsters";s:1:"0";s:11:"mp_autokick";s:1:"0";s:18:"mp_autoteambalance";s:1:"0";s:10:"mp_buytime";s:3:"0.5";s:10:"mp_c4timer";s:2:"35";s:11:"mp_chattime";s:2:"10";s:14:"mp_consistency";s:1:"1";s:14:"mp_fadetoblack";s:1:"0";s:13:"mp_flashlight";s:1:"1";s:12:"mp_footsteps";s:1:"1";s:14:"mp_forcecamera";s:1:"0";s:16:"mp_forcechasecam";s:1:"1";s:12:"mp_fragsleft";s:1:"0";s:13:"mp_freezetime";s:1:"1";s:15:"mp_friendlyfire";s:1:"1";s:17:"mp_ghostfrequency";s:3:"0.1";s:17:"mp_hostagepenalty";s:1:"3";s:14:"mp_kickpercent";s:4:"0.66";s:13:"mp_limitteams";s:1:"0";s:12:"mp_logdetail";s:1:"3";s:10:"mp_logfile";s:1:"1";s:14:"mp_logmessages";s:1:"1";s:15:"mp_mapvoteratio";s:4:"0.66";s:12:"mp_maxrounds";s:1:"0";s:15:"mp_mirrordamage";s:1:"0";s:11:"mp_playerid";s:1:"0";s:12:"mp_roundtime";s:1:"2";s:13:"mp_startmoney";s:3:"800";s:11:"mp_timeleft";s:1:"0";s:12:"mp_timelimit";s:2:"40";s:11:"mp_tkpunish";s:1:"0";s:16:"mp_windifference";s:1:"1";s:11:"mp_winlimit";s:1:"0";s:8:"pausable";s:1:"0";s:13:"sv_accelerate";s:1:"5";s:6:"sv_aim";s:1:"0";s:16:"sv_airaccelerate";s:2:"10";s:10:"sv_airmove";s:1:"0";s:14:"sv_allowupload";s:1:"0";s:10:"sv_alltalk";s:1:"0";s:9:"sv_bounce";s:1:"1";s:9:"sv_cheats";s:1:"0";s:14:"sv_clienttrace";s:1:"1";s:11:"sv_clipmode";s:1:"0";s:10:"sv_contact";s:21:"http://redacid.org.ua";s:11:"sv_friction";s:1:"4";s:10:"sv_gravity";s:3:"800";s:12:"sv_logblocks";s:1:"0";s:10:"sv_maxrate";s:5:"25000";s:11:"sv_maxspeed";s:3:"900";s:10:"sv_minrate";s:5:"20000";s:11:"sv_password";s:1:"0";s:10:"sv_proxies";s:1:"1";s:9:"sv_region";s:2:"-1";s:10:"sv_restart";s:1:"0";s:15:"sv_restartround";s:1:"0";s:11:"sv_stepsize";s:2:"18";s:12:"sv_stopspeed";s:2:"75";s:12:"sv_uploadmax";s:3:"0.5";s:14:"sv_voiceenable";s:1:"0";s:18:"sv_wateraccelerate";s:2:"10";s:16:"sv_waterfriction";s:1:"1";s:12:"zeta_version";s:8:"1.65lite";s:11:"description";s:14:"Counter-Strike";s:7:"netcode";i:47;s:9:"dedicated";s:1:"d";s:2:"os";s:1:"l";s:12:"mod_url_info";s:22:"www.counter-strike.net";s:16:"mod_url_download";s:0:"";s:11:"mod_version";i:1;s:8:"mod_size";i:184000000;s:15:"mod_server_side";i:0;s:14:"mod_custom_dll";i:1;s:9:"anticheat";i:0;s:4:"bots";i:0;}s:1:"p";a:1:{i:0;a:4:{s:3:"pid";i:1;s:4:"name";s:6:"DOKTOR";s:5:"score";i:0;s:4:"time";s:8:"00:00:13";}}}', '1245697117_1245305713_1245305713', 2, 0, 1, 1, 0),
(3, 1, 'redacid.org.ua', '27016', '27016', '0', 'halflife', 'a:5:{s:1:"b";a:7:{s:2:"ip";s:14:"redacid.org.ua";s:6:"q_port";s:5:"27016";s:6:"c_port";s:5:"27016";s:6:"s_port";s:1:"0";s:4:"type";s:8:"halflife";s:7:"request";s:1:"s";s:6:"status";i:1;}s:1:"o";a:1:{s:2:"id";s:1:"3";}s:1:"s";a:6:{s:4:"name";s:26:"Redacid.org.ua - .:Arena:.";s:3:"map";s:9:"aim_aztec";s:4:"game";s:7:"cstrike";s:7:"players";i:1;s:10:"playersmax";i:14;s:8:"password";i:0;}s:1:"e";a:104:{s:35:"_tutor_bomb_viewable_check_interval";s:3:"0.5";s:18:"_tutor_debug_level";s:1:"0";s:19:"_tutor_examine_time";s:3:"0.5";s:25:"_tutor_hint_interval_time";s:4:"10.0";s:17:"_tutor_look_angle";s:2:"10";s:20:"_tutor_look_distance";s:3:"200";s:49:"_tutor_message_character_display_time_coefficient";s:4:"0.07";s:35:"_tutor_message_minimum_display_time";s:1:"1";s:22:"_tutor_message_repeats";s:1:"5";s:20:"_tutor_view_distance";s:4:"1000";s:16:"allow_spectators";s:1:"1";s:20:"amx_client_languages";s:1:"1";s:11:"amx_nextmap";s:8:"awp_city";s:15:"amx_ptb_version";s:5:"1.8b3";s:12:"amx_timeleft";s:5:"24:17";s:15:"amxbans_version";s:3:"5.0";s:15:"amxmodx_version";s:10:"1.8.1.3711";s:12:"atac_version";s:5:"3.0.1";s:4:"coop";s:1:"0";s:10:"deathmatch";s:1:"1";s:14:"decalfrequency";s:2:"60";s:12:"edgefriction";s:1:"2";s:13:"hostage_debug";s:1:"0";s:12:"hostage_stop";s:1:"0";s:16:"humans_join_team";s:3:"any";s:15:"max_queries_sec";s:1:"1";s:22:"max_queries_sec_global";s:1:"1";s:18:"max_queries_window";s:1:"1";s:15:"metamod_version";s:4:"1.19";s:16:"mp_allowmonsters";s:1:"0";s:11:"mp_autokick";s:1:"0";s:18:"mp_autoteambalance";s:1:"0";s:10:"mp_buytime";s:3:"0.5";s:10:"mp_c4timer";s:2:"35";s:11:"mp_chattime";s:2:"10";s:14:"mp_consistency";s:1:"1";s:14:"mp_fadetoblack";s:1:"0";s:13:"mp_flashlight";s:1:"1";s:12:"mp_footsteps";s:1:"1";s:14:"mp_forcecamera";s:1:"0";s:16:"mp_forcechasecam";s:1:"1";s:12:"mp_fragsleft";s:1:"0";s:13:"mp_freezetime";s:1:"0";s:15:"mp_friendlyfire";s:1:"1";s:17:"mp_ghostfrequency";s:3:"0.1";s:17:"mp_hostagepenalty";s:1:"3";s:14:"mp_kickpercent";s:4:"0.66";s:13:"mp_limitteams";s:1:"0";s:12:"mp_logdetail";s:1:"0";s:10:"mp_logfile";s:1:"1";s:14:"mp_logmessages";s:1:"1";s:15:"mp_mapvoteratio";s:4:"0.66";s:12:"mp_maxrounds";s:1:"0";s:15:"mp_mirrordamage";s:1:"0";s:11:"mp_playerid";s:1:"0";s:12:"mp_roundtime";s:1:"2";s:13:"mp_startmoney";s:3:"800";s:11:"mp_timeleft";s:1:"0";s:12:"mp_timelimit";s:2:"25";s:11:"mp_tkpunish";s:1:"0";s:16:"mp_windifference";s:1:"1";s:11:"mp_winlimit";s:1:"0";s:8:"pausable";s:1:"0";s:13:"sv_accelerate";s:1:"5";s:6:"sv_aim";s:1:"0";s:16:"sv_airaccelerate";s:2:"10";s:10:"sv_airmove";s:1:"0";s:14:"sv_allowupload";s:1:"0";s:10:"sv_alltalk";s:1:"0";s:9:"sv_bounce";s:1:"1";s:9:"sv_cheats";s:1:"0";s:14:"sv_clienttrace";s:1:"1";s:11:"sv_clipmode";s:1:"0";s:10:"sv_contact";s:21:"http://redacid.org.ua";s:11:"sv_friction";s:1:"4";s:10:"sv_gravity";s:3:"800";s:12:"sv_logblocks";s:1:"0";s:10:"sv_maxrate";s:5:"25000";s:11:"sv_maxspeed";s:3:"900";s:10:"sv_minrate";s:5:"20000";s:11:"sv_password";s:1:"0";s:10:"sv_proxies";s:1:"1";s:9:"sv_region";s:2:"-1";s:10:"sv_restart";s:1:"0";s:15:"sv_restartround";s:1:"0";s:11:"sv_stepsize";s:2:"18";s:12:"sv_stopspeed";s:2:"75";s:12:"sv_uploadmax";s:3:"0.5";s:14:"sv_voiceenable";s:1:"0";s:18:"sv_wateraccelerate";s:2:"10";s:16:"sv_waterfriction";s:1:"1";s:12:"zeta_version";s:8:"1.65lite";s:11:"description";s:14:"Counter-Strike";s:7:"netcode";i:47;s:9:"dedicated";s:1:"d";s:2:"os";s:1:"l";s:12:"mod_url_info";s:22:"www.counter-strike.net";s:16:"mod_url_download";s:0:"";s:11:"mod_version";i:1;s:8:"mod_size";i:184000000;s:15:"mod_server_side";i:0;s:14:"mod_custom_dll";i:1;s:9:"anticheat";i:0;s:4:"bots";i:0;}s:1:"p";a:2:{i:0;a:4:{s:3:"pid";i:1;s:4:"name";s:28:"LeaDeR.tm | =K@ZANTIP=[1-st]";s:5:"score";i:1;s:4:"time";s:8:"00:02:36";}i:1;a:4:{s:3:"pid";i:2;s:4:"name";s:6:"madoxx";s:5:"score";i:1;s:4:"time";s:8:"00:01:34";}}}', '1245697117_1245236243_1245236243', 3, 0, 3, 1, 0);
-- --------------------------------------------------------
--
-- Структура таблицы `offline`
--
CREATE TABLE IF NOT EXISTS `offline` (
`server_id` int(11) default NULL,
`server_timestamp` int(11) default NULL,
`time_later` int(11) default NULL,
`del` tinyint(4) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `offline`
--
-- --------------------------------------------------------
--
-- Структура таблицы `status`
--
CREATE TABLE IF NOT EXISTS `status` (
`sid` smallint(6) NOT NULL auto_increment,
`sname` varchar(20) default NULL,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Дамп данных таблицы `status`
--
INSERT INTO `status` (`sid`, `sname`) VALUES
(1, 'Yes'),
(2, 'No');
-- --------------------------------------------------------
--
-- Структура таблицы `voting`
--
CREATE TABLE IF NOT EXISTS `voting` (
`id` int(11) NOT NULL auto_increment,
`server_id` int(10) NOT NULL,
`vote_ip` varchar(15) collate utf8_unicode_ci NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `voting`
--
