CREATE TABLE IF NOT EXISTS `dtt_players` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` bigint(20) NOT NULL,
`team` int(5) NOT NULL,
`ip` bigint(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `dtt_results` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`frags_blue` int(11) NOT NULL,
`frags_red` int(11) NOT NULL,
`towers_blue` int(11) NOT NULL,
`towers_red` int(11) NOT NULL,
`data` varchar(255) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
`hora` varchar(255) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL...
CREATE TABLE IF NOT EXISTS `dtt_players` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` bigint(20) NOT NULL,
`team` int(5) NOT NULL,
`ip` bigint(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `dtt_results` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`frags_blue` int(11) NOT NULL,
`frags_red` int(11) NOT NULL,
`towers_blue` int(11) NOT NULL,
`towers_red` int(11) NOT NULL,
`data` varchar(255) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
`hora` varchar(255) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
dtt_players
(dtt_players
( id
int(11) NOT NULL AUTO_INCREMEN' at line 1dtt_players
(started
for its date and not begin
etc.DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin`
guild_wars
WHERE status
= 0 AND begin
< 1590856869; - MYSQL ERROR: Unknown column 'begin' in 'where clause' (1054)CREATE TABLE `guild_wars` (
`id` int(11) NOT NULL,
`guild1` int(11) NOT NULL DEFAULT '0',
`guild2` int(11) NOT NULL DEFAULT '0',
`name1` varchar(255) NOT NULL,
`name2` varchar(255) NOT NULL,
`status` tinyint(2) NOT NULL DEFAULT '0',
`started` bigint(15) NOT NULL DEFAULT '0',
`ended` bigint(15) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
I don't have access to the older otx code but look at globalevents\scripts and look for a startup script
you are looking for the code
change begin to startedLua:DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin`