Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

TravianZ "4294967296" troops "bug" explained

InCube

InCube

Divine Celestial
Joined
Feb 25, 2013
Messages
808
Reaction score
343
Hello.

Today I will try to explain to all of you.

Firstly I want to say this is not a bug and it is only a coders mistake.
As you can see here:
You must be registered to see links
every single numeric value is unsigned witch is the biggest mistake done in a Travian(Z, X etc) clone.
In order to fix this, one must convert this sql from unsigned to signed integer values.

Here is a table comparing these two:
TypeStorageMinimum ValueMaximum Value
(Bytes)(Signed/Unsigned)(Signed/Unsigned)
TINYINT1-128127
0255
SMALLINT2-3276832767
065535
MEDIUMINT3-83886088388607
016777215
INT4-21474836482147483647
04294967295
BIGINT8-92233720368547758089223372036854775807
018446744073709551615




As you can see, unsigned has minimum value of ZERO (NULL, 0) and if it goes below 0 it will go to max value 4294967295 - OVERFLOWED_VALUE , this is why you have many troops.
Looking at PHP doc's (
You must be registered to see links
), Unsigned integer is NOT supported but can be parsed.
Code: 
function parse_unsigned_int($string) {
$x = (float)$string;
if ($x > (float)2147483647)
$x -= (float)"4294967296";
return (int)$x;
}

But this is dirty work right ? So best option would be just checking for values that go below 0 => make them to NULL and change unsigned to signed data type.
This is the main reason why no one is developing Travian, only few private developers understand this. Someone will make a patch for the SQL that could fix everything, but I just don't want to get my hands dirty on TravianZ.

Hopefully if some developers read this, there might be a chance for some of developers comeback.

Good luck.
 
The Best DDoS Protected Servers
cata7007

cata7007

Skilled Illusionist
Joined
Mar 9, 2011
Messages
391
Reaction score
120
This is the solution ?
 
Last edited:
InCube

InCube

Divine Celestial
Joined
Feb 25, 2013
Messages
808
Reaction score
343
cata7007 said:
This is the solution ?

Code: 
CREATE TABLE IF NOT EXISTS `%PREFIX%units` (
  `vref` int(11) signed NULL,
  `u1` int(11) signed NULL DEFAULT '0',
  `u2` int(11) signed NULL DEFAULT '0',
  `u3` int(11) signed NULL DEFAULT '0',
  `u4` int(11) signed NULL DEFAULT '0',
  `u5` int(11) signed NULL DEFAULT '0',
  `u6` int(11) signed NULL DEFAULT '0',
  `u7` int(11) signed NULL DEFAULT '0',
  `u8` int(11) signed NULL DEFAULT '0',
  `u9` int(11) signed NULL DEFAULT '0',
  `u10` int(11) signed NULL DEFAULT '0',
  `u11` int(11) signed NULL DEFAULT '0',
  `u12` int(11) signed NULL DEFAULT '0',
  `u13` int(11) signed NULL DEFAULT '0',
  `u14` int(11) signed NULL DEFAULT '0',
  `u15` int(11) signed NULL DEFAULT '0',
  `u16` int(11) signed NULL DEFAULT '0',
  `u17` int(11) signed NULL DEFAULT '0',
  `u18` int(11) signed NULL DEFAULT '0',
  `u19` int(11) signed NULL DEFAULT '0',
  `u20` int(11) signed NULL DEFAULT '0',
  `u21` int(11) signed NULL DEFAULT '0',
  `u22` int(11) signed NULL DEFAULT '0',
  `u23` int(11) signed NULL DEFAULT '0',
  `u24` int(11) signed NULL DEFAULT '0',
  `u25` int(11) signed NULL DEFAULT '0',
  `u26` int(11) signed NULL DEFAULT '0',
  `u27` int(11) signed NULL DEFAULT '0',
  `u28` int(11) signed NULL DEFAULT '0',
  `u29` int(11) signed NULL DEFAULT '0',
  `u30` int(11) signed NULL DEFAULT '0',
  `u31` int(11) signed NULL DEFAULT '0',
  `u32` int(11) signed NULL DEFAULT '0',
  `u33` int(11) signed NULL DEFAULT '0',
  `u34` int(11) signed NULL DEFAULT '0',
  `u35` int(11) signed NULL DEFAULT '0',
  `u36` int(11) signed NULL DEFAULT '0',
  `u37` int(11) signed NULL DEFAULT '0',
  `u38` int(11) signed NULL DEFAULT '0',
  `u39` int(11) signed NULL DEFAULT '0',
  `u40` int(11) signed NULL DEFAULT '0',
  `u41` int(11) signed NULL DEFAULT '0',
  `u42` int(11) signed NULL DEFAULT '0',
  `u43` int(11) signed NULL DEFAULT '0',
  `u44` int(11) signed NULL DEFAULT '0',
  `u45` int(11) signed NULL DEFAULT '0',
  `u46` int(11) signed NULL DEFAULT '0',
  `u47` int(11) signed NULL DEFAULT '0',
  `u48` int(11) signed NULL DEFAULT '0',
  `u49` int(11) signed NULL DEFAULT '0',
  `u50` int(11) signed NULL DEFAULT '0',
  `u99` int(11) signed NULL DEFAULT '0',
  `u99o` int(11) signed NULL DEFAULT '0',
  `hero` int(11) signed NULL DEFAULT '0',
  PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Click to expand...

Remove "signed" and make this for all tables, also change ENGINE to InnoDB
 
cata7007

cata7007

Skilled Illusionist
Joined
Mar 9, 2011
Messages
391
Reaction score
120
@InCube : could you tell me how can i change ENGINE to InnoDB.

Thanks and regards

PS : this is good ?

Code: 
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 21, 2011 at 02:49 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%a2b`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%a2b` (
 `id` int(11) NULL AUTO_INCREMENT,
 `ckey` varchar(255) NULL,
 `time_check` int(11) NULL DEFAULT '0',
 `to_vid` int(11) NULL,
 `u1` int(11) NULL,
 `u2` int(11) NULL,
 `u3` int(11) NULL,
 `u4` int(11) NULL,
 `u5` int(11) NULL,
 `u6` int(11) NULL,
 `u7` int(11) NULL,
 `u8` int(11) NULL,
 `u9` int(11) NULL,
 `u10` int(11) NULL,
 `u11` int(11) NULL,
 `type` smallint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%a2b`
--

--
-- Table structure for table `%PREFIX%links`
--

CREATE TABLE `%PREFIX%links` (
 `id` INT( 25 ) NULL AUTO_INCREMENT PRIMARY KEY ,
 `userid` INT( 25 ) NULL ,
 `name` VARCHAR( 50 ) NULL ,
 `url` VARCHAR( 150 ) NULL ,
 `pos` INT( 10 ) NULL
) ENGINE = MYISAM;

--
-- Dumping data for table `%PREFIX%links`
--

-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%abdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%abdata` (
 `vref` int(11) NULL,
 `a1` tinyint(2) NULL DEFAULT '0',
 `a2` tinyint(2) NULL DEFAULT '0',
 `a3` tinyint(2) NULL DEFAULT '0',
 `a4` tinyint(2) NULL DEFAULT '0',
 `a5` tinyint(2) NULL DEFAULT '0',
 `a6` tinyint(2) NULL DEFAULT '0',
 `a7` tinyint(2) NULL DEFAULT '0',
 `a8` tinyint(2) NULL DEFAULT '0',
 `b1` tinyint(2) NULL DEFAULT '0',
 `b2` tinyint(2) NULL DEFAULT '0',
 `b3` tinyint(2) NULL DEFAULT '0',
 `b4` tinyint(2) NULL DEFAULT '0',
 `b5` tinyint(2) NULL DEFAULT '0',
 `b6` tinyint(2) NULL DEFAULT '0',
 `b7` tinyint(2) NULL DEFAULT '0',
 `b8` tinyint(2) NULL DEFAULT '0',
 PRIMARY KEY (`vref`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%abdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%activate`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%activate` (
 `id` int(255) NULL AUTO_INCREMENT,
 `username` varchar(100) NULL,
 `password` varchar(100) NULL,
 `email` text NULL,
 `tribe` tinyint(1) NULL,
 `access` tinyint(1) NULL DEFAULT '1',
 `act` varchar(10) NULL,
 `timestamp` int(11) NULL DEFAULT '0',
 `location` text NULL,
 `act2` varchar(10) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%activate`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%active`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%active` (
 `username` varchar(100) NULL,
 `timestamp` int(11) NULL,
 PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%PREFIX%active`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%admin_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%admin_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `user` text NULL,
 `log` text NULL,
 `time` int(25) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=80 ;

--
-- Dumping data for table `%PREFIX%admin_log`
--


-- --------------------------------------------------------
--
-- Table structure for table `%PREFIX%allimedal`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%allimedal` (
 `id` int(11) NULL AUTO_INCREMENT,
 `allyid` int(11) NULL,
 `categorie` int(11) NULL,
 `plaats` int(11) NULL,
 `week` int(11) NULL,
 `points` bigint(255) NULL,
 `img` varchar(255) NULL,
 `del` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%artefacts`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%artefacts` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `owner` int(11) NULL,
 `type` tinyint(2) NULL,
 `size` tinyint(1) NULL,
 `conquered` int(11) NULL,
 `name` varchar(100) NULL,
 `desc` text NULL,
 `effect` varchar(100) NULL,
 `img` varchar(20) NULL,
 `active` tinyint(1) NULL,
 `kind` tinyint(1) NULL,
 `bad_effect` tinyint(1) NULL,
 `effect2` tinyint(2) NULL,
 `lastupdate` int(11) NULL, 
 PRIMARY KEY (`id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Table structure for table `s1_artefacts`
--
-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%alidata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%alidata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `name` varchar(100) NULL,
 `tag` varchar(100) NULL,
 `leader` int(11) NULL,
 `coor` int(11) NULL,
 `advisor` int(11) NULL,
 `recruiter` int(11) NULL,
 `notice` text NULL,
 `desc` text NULL,
 `max` tinyint(2) NULL,
 `ap` bigint(255) NULL DEFAULT '0',
 `dp` bigint(255) NULL DEFAULT '0',
 `Rc` bigint(255) NULL DEFAULT '0',
 `RR` bigint(255) NULL DEFAULT '0',
 `Aap` bigint(255) NULL DEFAULT '0',
 `Adp` bigint(255) NULL DEFAULT '0',
 `clp` bigint(255) NULL DEFAULT '0',
 `oldrank` bigint(255) NULL DEFAULT '0',
 `forumlink` varchar(150) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%alidata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%ali_invite`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ali_invite` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `alliance` int(11) NULL,
 `sender` int(11) NULL,
 `timestamp` int(11) NULL,
 `accept` int(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%ali_invite`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%ali_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ali_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `aid` int(11) NULL,
 `comment` text NULL,
 `date` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%ali_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%ali_permission`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ali_permission` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `alliance` int(11) NULL,
 `rank` varchar(100) NULL,
 `opt1` int(1) NULL DEFAULT '0',
 `opt2` int(1) NULL DEFAULT '0',
 `opt3` int(1) NULL DEFAULT '0',
 `opt4` int(1) NULL DEFAULT '0',
 `opt5` int(1) NULL DEFAULT '0',
 `opt6` int(1) NULL DEFAULT '0',
 `opt7` int(1) NULL DEFAULT '0',
 `opt8` int(1) NULL DEFAULT '0',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%ali_permission`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%attacks`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%attacks` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `t1` int(11) NULL,
 `t2` int(11) NULL,
 `t3` int(11) NULL,
 `t4` int(11) NULL,
 `t5` int(11) NULL,
 `t6` int(11) NULL,
 `t7` int(11) NULL,
 `t8` int(11) NULL,
 `t9` int(11) NULL,
 `t10` int(11) NULL,
 `t11` int(11) NULL,
 `attack_type` tinyint(1) NULL,
 `ctar1` int(11) NULL, 
 `ctar2` int(11) NULL,
 `spy` int(11) NULL, 
 `b1` tinyint(1) NULL, 
 `b2` tinyint(1) NULL, 
 `b3` tinyint(1) NULL, 
 `b4` tinyint(1) NULL, 
 `b5` tinyint(1) NULL, 
 `b6` tinyint(1) NULL, 
 `b7` tinyint(1) NULL, 
 `b8` tinyint(1) NULL, 
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%attacks`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%banlist`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%banlist` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `name` varchar(100) NULL,
 `reason` varchar(30) NULL,
 `time` int(11) NULL,
 `end` varchar(10) NULL,
 `admin` int(11) NULL,
 `active` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%banlist`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%bdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%bdata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `field` tinyint(2) NULL,
 `type` tinyint(2) NULL,
 `loopcon` tinyint(1) NULL,
 `timestamp` int(11) NULL,
 `master` tinyint(1) NULL,
 `level` tinyint(3) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%bdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%build_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%build_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%build_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%chat`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%chat` (
 `id` int(20) NULL AUTO_INCREMENT,
 `id_user` int(11) NULL,
 `name` varchar(255) NULL,
 `alli` varchar(255) NULL,
 `date` varchar(255) NULL,
 `msg` varchar(255) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%chat`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%config`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%config` (
 `lastgavemedal` int(11) NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `%PREFIX%config` VALUES (0);

--
-- Dumping data for table `%prefix%config`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%deleting`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%deleting` (
 `uid` int(11) NULL,
 `timestamp` int(11) NULL,
 PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%deleting`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%demolition`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%demolition` (
 `vref` int(11) NULL,
 `buildnumber` int(11) NULL DEFAULT '0',
 `lvl` int(11) NULL DEFAULT '0',
 `timetofinish` int(11) NULL,
 PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%demolition`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%diplomacy`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%diplomacy` (
 `id` int(11) NULL AUTO_INCREMENT,
 `alli1` int(11) NULL,
 `alli2` int(11) NULL,
 `type` tinyint(1) NULL,
 `accepted` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `%prefix%diplomacy`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%enforcement`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%enforcement` (
 `id` int(11) NULL AUTO_INCREMENT,
 `u1` int(11) NULL DEFAULT '0',
 `u2` int(11) NULL DEFAULT '0',
 `u3` int(11) NULL DEFAULT '0',
 `u4` int(11) NULL DEFAULT '0',
 `u5` int(11) NULL DEFAULT '0',
 `u6` int(11) NULL DEFAULT '0',
 `u7` int(11) NULL DEFAULT '0',
 `u8` int(11) NULL DEFAULT '0',
 `u9` int(11) NULL DEFAULT '0',
 `u10` int(11) NULL DEFAULT '0',
 `u11` int(11) NULL DEFAULT '0',
 `u12` int(11) NULL DEFAULT '0',
 `u13` int(11) NULL DEFAULT '0',
 `u14` int(11) NULL DEFAULT '0',
 `u15` int(11) NULL DEFAULT '0',
 `u16` int(11) NULL DEFAULT '0',
 `u17` int(11) NULL DEFAULT '0',
 `u18` int(11) NULL DEFAULT '0',
 `u19` int(11) NULL DEFAULT '0',
 `u20` int(11) NULL DEFAULT '0',
 `u21` int(11) NULL DEFAULT '0',
 `u22` int(11) NULL DEFAULT '0',
 `u23` int(11) NULL DEFAULT '0',
 `u24` int(11) NULL DEFAULT '0',
 `u25` int(11) NULL DEFAULT '0',
 `u26` int(11) NULL DEFAULT '0',
 `u27` int(11) NULL DEFAULT '0',
 `u28` int(11) NULL DEFAULT '0',
 `u29` int(11) NULL DEFAULT '0',
 `u30` int(11) NULL DEFAULT '0',
 `u31` int(11) NULL DEFAULT '0',
 `u32` int(11) NULL DEFAULT '0',
 `u33` int(11) NULL DEFAULT '0',
 `u34` int(11) NULL DEFAULT '0',
 `u35` int(11) NULL DEFAULT '0',
 `u36` int(11) NULL DEFAULT '0',
 `u37` int(11) NULL DEFAULT '0',
 `u38` int(11) NULL DEFAULT '0',
 `u39` int(11) NULL DEFAULT '0',
 `u40` int(11) NULL DEFAULT '0',
 `u41` int(11) NULL DEFAULT '0',
 `u42` int(11) NULL DEFAULT '0',
 `u43` int(11) NULL DEFAULT '0',
 `u44` int(11) NULL DEFAULT '0',
 `u45` int(11) NULL DEFAULT '0',
 `u46` int(11) NULL DEFAULT '0',
 `u47` int(11) NULL DEFAULT '0',
 `u48` int(11) NULL DEFAULT '0',
 `u49` int(11) NULL DEFAULT '0',
 `u50` int(11) NULL DEFAULT '0',
 `hero` tinyint(1) NULL DEFAULT '0',
 `from` int(11) NULL DEFAULT '0',
 `vref` int(11) NULL DEFAULT '0',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%enforcement`
--

-- --------------------------------------------------------

--
-- Table structure for table `%prefix%farmlist`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%farmlist` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wref` int(11) NULL,
 `owner` int(11) NULL,
 `name` varchar(100) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%farmlist`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%fdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%fdata` (
 `vref` int(11) NULL,
 `f1` tinyint(2) NULL DEFAULT '0',
 `f1t` tinyint(2) NULL DEFAULT '0',
 `f2` tinyint(2) NULL DEFAULT '0',
 `f2t` tinyint(2) NULL DEFAULT '0',
 `f3` tinyint(2) NULL DEFAULT '0',
 `f3t` tinyint(2) NULL DEFAULT '0',
 `f4` tinyint(2) NULL DEFAULT '0',
 `f4t` tinyint(2) NULL DEFAULT '0',
 `f5` tinyint(2) NULL DEFAULT '0',
 `f5t` tinyint(2) NULL DEFAULT '0',
 `f6` tinyint(2) NULL DEFAULT '0',
 `f6t` tinyint(2) NULL DEFAULT '0',
 `f7` tinyint(2) NULL DEFAULT '0',
 `f7t` tinyint(2) NULL DEFAULT '0',
 `f8` tinyint(2) NULL DEFAULT '0',
 `f8t` tinyint(2) NULL DEFAULT '0',
 `f9` tinyint(2) NULL DEFAULT '0',
 `f9t` tinyint(2) NULL DEFAULT '0',
 `f10` tinyint(2) NULL DEFAULT '0',
 `f10t` tinyint(2) NULL DEFAULT '0',
 `f11` tinyint(2) NULL DEFAULT '0',
 `f11t` tinyint(2) NULL DEFAULT '0',
 `f12` tinyint(2) NULL DEFAULT '0',
 `f12t` tinyint(2) NULL DEFAULT '0',
 `f13` tinyint(2) NULL DEFAULT '0',
 `f13t` tinyint(2) NULL DEFAULT '0',
 `f14` tinyint(2) NULL DEFAULT '0',
 `f14t` tinyint(2) NULL DEFAULT '0',
 `f15` tinyint(2) NULL DEFAULT '0',
 `f15t` tinyint(2) NULL DEFAULT '0',
 `f16` tinyint(2) NULL DEFAULT '0',
 `f16t` tinyint(2) NULL DEFAULT '0',
 `f17` tinyint(2) NULL DEFAULT '0',
 `f17t` tinyint(2) NULL DEFAULT '0',
 `f18` tinyint(2) NULL DEFAULT '0',
 `f18t` tinyint(2) NULL DEFAULT '0',
 `f19` tinyint(2) NULL DEFAULT '0',
 `f19t` tinyint(2) NULL DEFAULT '0',
 `f20` tinyint(2) NULL DEFAULT '0',
 `f20t` tinyint(2) NULL DEFAULT '0',
 `f21` tinyint(2) NULL DEFAULT '0',
 `f21t` tinyint(2) NULL DEFAULT '0',
 `f22` tinyint(2) NULL DEFAULT '0',
 `f22t` tinyint(2) NULL DEFAULT '0',
 `f23` tinyint(2) NULL DEFAULT '0',
 `f23t` tinyint(2) NULL DEFAULT '0',
 `f24` tinyint(2) NULL DEFAULT '0',
 `f24t` tinyint(2) NULL DEFAULT '0',
 `f25` tinyint(2) NULL DEFAULT '0',
 `f25t` tinyint(2) NULL DEFAULT '0',
 `f26` tinyint(2) NULL DEFAULT '0',
 `f26t` tinyint(2) NULL DEFAULT '0',
 `f27` tinyint(2) NULL DEFAULT '0',
 `f27t` tinyint(2) NULL DEFAULT '0',
 `f28` tinyint(2) NULL DEFAULT '0',
 `f28t` tinyint(2) NULL DEFAULT '0',
 `f29` tinyint(2) NULL DEFAULT '0',
 `f29t` tinyint(2) NULL DEFAULT '0',
 `f30` tinyint(2) NULL DEFAULT '0',
 `f30t` tinyint(2) NULL DEFAULT '0',
 `f31` tinyint(2) NULL DEFAULT '0',
 `f31t` tinyint(2) NULL DEFAULT '0',
 `f32` tinyint(2) NULL DEFAULT '0',
 `f32t` tinyint(2) NULL DEFAULT '0',
 `f33` tinyint(2) NULL DEFAULT '0',
 `f33t` tinyint(2) NULL DEFAULT '0',
 `f34` tinyint(2) NULL DEFAULT '0',
 `f34t` tinyint(2) NULL DEFAULT '0',
 `f35` tinyint(2) NULL DEFAULT '0',
 `f35t` tinyint(2) NULL DEFAULT '0',
 `f36` tinyint(2) NULL DEFAULT '0',
 `f36t` tinyint(2) NULL DEFAULT '0',
 `f37` tinyint(2) NULL DEFAULT '0',
 `f37t` tinyint(2) NULL DEFAULT '0',
 `f38` tinyint(2) NULL DEFAULT '0',
 `f38t` tinyint(2) NULL DEFAULT '0',
 `f39` tinyint(2) NULL DEFAULT '0',
 `f39t` tinyint(2) NULL DEFAULT '0',
 `f40` tinyint(2) NULL DEFAULT '0',
 `f40t` tinyint(2) NULL DEFAULT '0',
 `f99` tinyint(2) NULL DEFAULT '0',
 `f99t` tinyint(2) NULL DEFAULT '0',
 `wwname` varchar(100) NULL DEFAULT 'World Wonder',
 PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

--
-- Dumping data for table `%prefix%fdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_cat`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_cat` (
 `id` int(11) NULL AUTO_INCREMENT,
 `owner` varchar(255) NULL,
 `alliance` varchar(255) NULL,
 `forum_name` varchar(255) NULL,
 `forum_des` text NULL,
 `forum_area` varchar(255) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_cat`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_edit`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_edit` (
 `id` int(11) NULL AUTO_INCREMENT,
 `alliance` varchar(255) NULL,
 `result` varchar(255) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_edit`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_post`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_post` (
 `id` int(11) NULL AUTO_INCREMENT,
 `post` longtext NULL,
 `topic` varchar(255) NULL,
 `owner` varchar(255) NULL,
 `date` varchar(255) NULL,
 `alliance0` int(11) NULL,
 `player0` int(11) NULL,
 `coor0` int(11) NULL,
 `report0` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_post`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_survey`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_survey` (
 `topic` int(11) NULL,
 `title` varchar(255) NULL,
 `option1` varchar(255) NULL,
 `option2` varchar(255) NULL,
 `option3` varchar(255) NULL,
 `option4` varchar(255) NULL,
 `option5` varchar(255) NULL,
 `option6` varchar(255) NULL,
 `option7` varchar(255) NULL,
 `option8` varchar(255) NULL,
 `vote1` int(11) NULL DEFAULT '0',
 `vote2` int(11) NULL DEFAULT '0',
 `vote3` int(11) NULL DEFAULT '0',
 `vote4` int(11) NULL DEFAULT '0',
 `vote5` int(11) NULL DEFAULT '0',
 `vote6` int(11) NULL DEFAULT '0',
 `vote7` int(11) NULL DEFAULT '0',
 `vote8` int(11) NULL DEFAULT '0',
 `voted` text NULL,
 `ends` int(11) NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_survey`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_topic`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_topic` (
 `id` int(11) NULL AUTO_INCREMENT,
 `title` varchar(255) NULL,
 `post` longtext NULL,
 `date` varchar(255) NULL,
 `post_date` varchar(255) NULL,
 `cat` varchar(255) NULL,
 `owner` varchar(255) NULL,
 `alliance` varchar(255) NULL,
 `ends` varchar(255) NULL,
 `close` varchar(255) NULL,
 `stick` varchar(255) NULL,
 `alliance0` int(11) NULL,
 `player0` int(11) NULL,
 `coor0` int(11) NULL,
 `report0` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_topic`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%general`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%general` (
 `id` int(11) NULL AUTO_INCREMENT,
 `casualties` int(11) NULL,
 `time` int(11) NULL,
 `shown` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%general`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%gold_fin_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%gold_fin_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%gold_fin_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%hero`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%hero` (
 `heroid` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `unit` smallint(2) NULL,
 `name` tinytext NULL,
 `wref` int(11) NULL,
 `level` tinyint(3) NULL,
 `points` int(3) NULL,
 `experience` int(11) NULL,
 `dead` tinyint(1) NULL,
 `health` float(12,9) NULL,
 `attack` tinyint(3) NULL,
 `defence` tinyint(3) NULL,
 `attackbonus` tinyint(3) NULL,
 `defencebonus` tinyint(3) NULL,
 `regeneration` tinyint(3) NULL,
 `autoregen` int(2) NULL,
 `lastupdate` int(11) NULL,
 `trainingtime` int(11) NULL,
 `inrevive` tinyint(1) NULL,
 `intraining` tinyint(1) NULL,
 PRIMARY KEY (`heroid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Dumping data for table `%prefix%hero`
--



-- --------------------------------------------------------

--
-- Table structure for table `%prefix%illegal_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%illegal_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `user` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%illegal_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%login_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%login_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `ip` varchar(15) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%login_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%market`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%market` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `gtype` tinyint(1) NULL,
 `gamt` int(11) NULL,
 `wtype` tinyint(1) NULL,
 `wamt` int(11) NULL,
 `accept` tinyint(1) NULL,
 `maxtime` int(11) NULL,
 `alliance` int(11) NULL,
 `merchant` tinyint(2) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%market`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%market_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%market_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%market_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%mdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%mdata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `target` int(11) NULL,
 `owner` int(11) NULL,
 `topic` varchar(100) NULL,
 `message` text NULL,
 `viewed` tinyint(1) NULL,
 `archived` tinyint(1) NULL,
 `send` tinyint(1) NULL,
 `time` int(11) NULL DEFAULT '0',
 `deltarget` int(11) NULL,
 `delowner` int(11) NULL,
 `alliance` int(11) NULL,
 `player` int(11) NULL,
 `coor` int(11) NULL,
 `report` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%mdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%medal`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%medal` (
 `id` int(11) NULL AUTO_INCREMENT,
 `userid` int(11) NULL,
 `categorie` int(11) NULL,
 `plaats` int(11) NULL,
 `week` int(11) NULL,
 `points` varchar(15) NULL,
 `img` varchar(10) NULL,
 `del` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%medal`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%movement`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%movement` (
 `moveid` int(11) NULL AUTO_INCREMENT,
 `sort_type` tinyint(4) NULL DEFAULT '0',
 `from` int(11) NULL DEFAULT '0',
 `to` int(11) NULL DEFAULT '0',
 `ref` int(11) NULL DEFAULT '0',
 `ref2` int(11) NULL DEFAULT '0',
 `starttime` int(11) NULL DEFAULT '0',
 `endtime` int(11) NULL DEFAULT '0',
 `proc` tinyint(1) NULL DEFAULT '0',
 `send` tinyint(1) NULL,
 `wood` int(11) NULL,
 `clay` int(11) NULL,
 `iron` int(11) NULL,
 `crop` int(11) NULL,
 PRIMARY KEY (`moveid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%movement`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%ndata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ndata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `toWref` int(11) NULL,
 `ally` int(11) NULL,
 `topic` text NULL,
 `ntype` tinyint(1) NULL,
 `data` text NULL,
 `time` int(11) NULL,
 `viewed` tinyint(1) NULL,
 `archive` tinyint(1) NULL,
 `del` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%ndata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%odata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%odata` (
 `wref` int(11) NULL,
 `type` tinyint(2) NULL,
 `conqured` int(11) NULL,
 `wood` int(11) NULL,
 `iron` int(11) NULL,
 `clay` int(11) NULL,
 `maxstore` int(11) NULL,
 `crop` int(11) NULL,
 `maxcrop` int(11) NULL,
 `lastupdated` int(11) NULL,
 `lastupdated2` int(11) NULL,
 `loyalty` float(9,6) NULL DEFAULT '100',
 `owner` int(11) NULL DEFAULT '2',
 `name` varchar(32) NULL DEFAULT 'Unoccupied Oasis',
 `high` tinyint(1) NULL,
 PRIMARY KEY (`wref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%odata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%online`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%online` (
 `name` varchar(32) NULL,
 `uid` int(11) NULL,
 `time` varchar(32) NULL,
 `sit` tinyint(1) NULL,
 UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%online`
--

-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%prisoners`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%prisoners` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wref` int(11) NULL,
 `from` int(11) NULL,
 `t1` int(11) NULL,
 `t2` int(11) NULL,
 `t3` int(11) NULL,
 `t4` int(11) NULL,
 `t5` int(11) NULL,
 `t6` int(11) NULL,
 `t7` int(11) NULL,
 `t8` int(11) NULL,
 `t9` int(11) NULL,
 `t10` int(11) NULL,
 `t11` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%prisoners`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%raidlist`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%raidlist` (
 `id` int(11) NULL AUTO_INCREMENT,
 `lid` int(11) NULL,
 `towref` int(11) NULL,
 `x` int(11) NULL,
 `y` int(11) NULL,
 `distance` varchar(5) NULL DEFAULT '0',
 `t1` int(11) NULL,
 `t2` int(11) NULL,
 `t3` int(11) NULL,
 `t4` int(11) NULL,
 `t5` int(11) NULL,
 `t6` int(11) NULL,
 `t7` int(11) NULL,
 `t8` int(11) NULL,
 `t9` int(11) NULL,
 `t10` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%raidlist`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%research`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%research` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `tech` varchar(3) NULL,
 `timestamp` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%research`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%route`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%route` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `wid` int(11) NULL,
 `from` int(11) NULL,
 `wood` int(5) NULL,
 `clay` int(5) NULL,
 `iron` int(5) NULL,
 `crop` int(5) NULL,
 `start` tinyint(2) NULL,
 `deliveries` tinyint(1) NULL,
 `merchant` int(11) NULL,
 `timestamp` int(11) NULL,
 `timeleft` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%route`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%send`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%send` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wood` int(11) NULL,
 `clay` int(11) NULL,
 `iron` int(11) NULL,
 `crop` int(11) NULL,
 `merchant` tinyint(2) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%send`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%tdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%tdata` (
 `vref` int(11) NULL,
 `t2` tinyint(1) NULL DEFAULT '0',
 `t3` tinyint(1) NULL DEFAULT '0',
 `t4` tinyint(1) NULL DEFAULT '0',
 `t5` tinyint(1) NULL DEFAULT '0',
 `t6` tinyint(1) NULL DEFAULT '0',
 `t7` tinyint(1) NULL DEFAULT '0',
 `t8` tinyint(1) NULL DEFAULT '0',
 `t9` tinyint(1) NULL DEFAULT '0',
 `t12` tinyint(1) NULL DEFAULT '0',
 `t13` tinyint(1) NULL DEFAULT '0',
 `t14` tinyint(1) NULL DEFAULT '0',
 `t15` tinyint(1) NULL DEFAULT '0',
 `t16` tinyint(1) NULL DEFAULT '0',
 `t17` tinyint(1) NULL DEFAULT '0',
 `t18` tinyint(1) NULL DEFAULT '0',
 `t19` tinyint(1) NULL DEFAULT '0',
 `t22` tinyint(1) NULL DEFAULT '0',
 `t23` tinyint(1) NULL DEFAULT '0',
 `t24` tinyint(1) NULL DEFAULT '0',
 `t25` tinyint(1) NULL DEFAULT '0',
 `t26` tinyint(1) NULL DEFAULT '0',
 `t27` tinyint(1) NULL DEFAULT '0',
 `t28` tinyint(1) NULL DEFAULT '0',
 `t29` tinyint(1) NULL DEFAULT '0',
 `t32` tinyint(1) NULL DEFAULT '0',
 `t33` tinyint(1) NULL DEFAULT '0',
 `t34` tinyint(1) NULL DEFAULT '0',
 `t35` tinyint(1) NULL DEFAULT '0',
 `t36` tinyint(1) NULL DEFAULT '0',
 `t37` tinyint(1) NULL DEFAULT '0',
 `t38` tinyint(1) NULL DEFAULT '0',
 `t39` tinyint(1) NULL DEFAULT '0',
 `t42` tinyint(1) NULL DEFAULT '0',
 `t43` tinyint(1) NULL DEFAULT '0',
 `t44` tinyint(1) NULL DEFAULT '0',
 `t45` tinyint(1) NULL DEFAULT '0',
 `t46` tinyint(1) NULL DEFAULT '0',
 `t47` tinyint(1) NULL DEFAULT '0',
 `t48` tinyint(1) NULL DEFAULT '0',
 `t49` tinyint(1) NULL DEFAULT '0',
 PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%tdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%tech_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%tech_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%tech_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%training`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%training` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `unit` tinyint(2) NULL,
 `amt` int(11) NULL,
 `pop` int(11) NULL,
 `timestamp` int(11) NULL,
 `eachtime` int(11) NULL,
 `timestamp2` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%training`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%units`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%units` (
 `vref` int(11) NULL,
 `u1` int(11) NULL DEFAULT '0',
 `u2` int(11) NULL DEFAULT '0',
 `u3` int(11) NULL DEFAULT '0',
 `u4` int(11) NULL DEFAULT '0',
 `u5` int(11) NULL DEFAULT '0',
 `u6` int(11) NULL DEFAULT '0',
 `u7` int(11) NULL DEFAULT '0',
 `u8` int(11) NULL DEFAULT '0',
 `u9` int(11) NULL DEFAULT '0',
 `u10` int(11) NULL DEFAULT '0',
 `u11` int(11) NULL DEFAULT '0',
 `u12` int(11) NULL DEFAULT '0',
 `u13` int(11) NULL DEFAULT '0',
 `u14` int(11) NULL DEFAULT '0',
 `u15` int(11) NULL DEFAULT '0',
 `u16` int(11) NULL DEFAULT '0',
 `u17` int(11) NULL DEFAULT '0',
 `u18` int(11) NULL DEFAULT '0',
 `u19` int(11) NULL DEFAULT '0',
 `u20` int(11) NULL DEFAULT '0',
 `u21` int(11) NULL DEFAULT '0',
 `u22` int(11) NULL DEFAULT '0',
 `u23` int(11) NULL DEFAULT '0',
 `u24` int(11) NULL DEFAULT '0',
 `u25` int(11) NULL DEFAULT '0',
 `u26` int(11) NULL DEFAULT '0',
 `u27` int(11) NULL DEFAULT '0',
 `u28` int(11) NULL DEFAULT '0',
 `u29` int(11) NULL DEFAULT '0',
 `u30` int(11) NULL DEFAULT '0',
 `u31` int(11) NULL DEFAULT '0',
 `u32` int(11) NULL DEFAULT '0',
 `u33` int(11) NULL DEFAULT '0',
 `u34` int(11) NULL DEFAULT '0',
 `u35` int(11) NULL DEFAULT '0',
 `u36` int(11) NULL DEFAULT '0',
 `u37` int(11) NULL DEFAULT '0',
 `u38` int(11) NULL DEFAULT '0',
 `u39` int(11) NULL DEFAULT '0',
 `u40` int(11) NULL DEFAULT '0',
 `u41` int(11) NULL DEFAULT '0',
 `u42` int(11) NULL DEFAULT '0',
 `u43` int(11) NULL DEFAULT '0',
 `u44` int(11) NULL DEFAULT '0',
 `u45` int(11) NULL DEFAULT '0',
 `u46` int(11) NULL DEFAULT '0',
 `u47` int(11) NULL DEFAULT '0',
 `u48` int(11) NULL DEFAULT '0',
 `u49` int(11) NULL DEFAULT '0',
 `u50` int(11) NULL DEFAULT '0',
 `u99` int(11) NULL DEFAULT '0',
 `u99o` int(11) NULL DEFAULT '0',
 `hero` int(11) NULL DEFAULT '0',
 PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%units`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%users`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%users` (
 `id` int(11) NULL AUTO_INCREMENT,
 `username` varchar(100) NULL,
 `password` varchar(100) NULL,
 `email` text NULL,
 `tribe` tinyint(1) NULL,
 `access` tinyint(1) NULL DEFAULT '1',
 `gold` int(9) NULL DEFAULT '0',
 `gender` tinyint(1) NULL DEFAULT '0',
 `birthday` date NULL DEFAULT '0000-00-00',
 `location` text NULL,
 `desc1` text NULL,
 `desc2` text NULL,
 `plus` int(11) NULL DEFAULT '0',
 `goldclub` int(11) NULL DEFAULT '0',
 `b1` int(11) NULL DEFAULT '0',
 `b2` int(11) NULL DEFAULT '0',
 `b3` int(11) NULL DEFAULT '0',
 `b4` int(11) NULL DEFAULT '0',
 `sit1` int(11) NULL DEFAULT '0',
 `sit2` int(11) NULL DEFAULT '0',
 `alliance` int(11) NULL DEFAULT '0',
 `sessid` varchar(100) NULL,
 `act` varchar(10) NULL,
 `timestamp` int(11) NULL DEFAULT '0',
 `ap` int(11) NULL DEFAULT '0',
 `apall` int(11) NULL DEFAULT '0',
 `dp` int(11) NULL DEFAULT '0',
 `dpall` int(11) NULL DEFAULT '0',
 `protect` int(11) NULL,
 `quest` tinyint(2) NULL,
 `quest_time` int(11) NULL,
 `gpack` varchar(255) NULL DEFAULT 'gpack/travian_default/',
 `cp` float(14,5) NULL DEFAULT '1',
 `lastupdate` int(11) NULL,
 `RR` int(255) NULL DEFAULT '0',
 `Rc` int(255) NULL DEFAULT '0',
 `ok` tinyint(1) NULL DEFAULT '0',
 `clp` bigint(255) NULL DEFAULT '0',
 `oldrank` bigint(255) NULL DEFAULT '0',
 `regtime` int(11) NULL DEFAULT '0',
 `invited` int(11) NULL DEFAULT '0',
 `friend0` int(11) NULL,
 `friend1` int(11) NULL,
 `friend2` int(11) NULL,
 `friend3` int(11) NULL,
 `friend4` int(11) NULL,
 `friend5` int(11) NULL,
 `friend6` int(11) NULL,
 `friend7` int(11) NULL,
 `friend8` int(11) NULL,
 `friend9` int(11) NULL,
 `friend10` int(11) NULL,
 `friend11` int(11) NULL,
 `friend12` int(11) NULL,
 `friend13` int(11) NULL,
 `friend14` int(11) NULL,
 `friend15` int(11) NULL,
 `friend16` int(11) NULL,
 `friend17` int(11) NULL,
 `friend18` int(11) NULL,
 `friend19` int(11) NULL,
 `friend0wait` int(11) NULL,
 `friend1wait` int(11) NULL,
 `friend2wait` int(11) NULL,
 `friend3wait` int(11) NULL,
 `friend4wait` int(11) NULL,
 `friend5wait` int(11) NULL,
 `friend6wait` int(11) NULL,
 `friend7wait` int(11) NULL,
 `friend8wait` int(11) NULL,
 `friend9wait` int(11) NULL,
 `friend10wait` int(11) NULL,
 `friend11wait` int(11) NULL,
 `friend12wait` int(11) NULL,
 `friend13wait` int(11) NULL,
 `friend14wait` int(11) NULL,
 `friend15wait` int(11) NULL,
 `friend16wait` int(11) NULL,
 `friend17wait` int(11) NULL,
 `friend18wait` int(11) NULL,
 `friend19wait` int(11) NULL,
 `maxevasion` mediumint(3) NULL,
 `village_select` bigint(20) DEFAULT NULL,
 `vac_time` varchar(255) NULL,
 `vac_mode` int(2) NULL DEFAULT '0',
 `vactwoweeks` varchar(255) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `%prefix%users`
--

INSERT INTO `%PREFIX%users` (`id`, `username`, `password`, `email`, `tribe`, `access`, `gold`, `gender`, `birthday`, `location`, `desc1`, `desc2`, `plus`, `b1`, `b2`, `b3`, `b4`, `sit1`, `sit2`, `alliance`, `sessid`, `act`, `timestamp`, `ap`, `apall`, `dp`, `dpall`, `protect`, `quest`, `gpack`, `cp`, `lastupdate`, `RR`, `Rc`, `ok`) VALUES
(5, 'Multihunter', '', 'multihunter@travianx.mail', 0, 9, 0, 0, '0000-00-00', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'gpack/travian_default/', 1, 0, 0, 0, 0),
(1, 'Support', '', 'support@travianx.mail', 0, 8, 0, 0, '0000-00-00', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'gpack/travian_default/', 1, 0, 0, 0, 0),
(2, 'Nature', '', 'support@travianx.mail', 4, 8, 0, 0, '0000-00-00', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'gpack/travian_default/', 1, 0, 0, 0, 0),
(4, 'Taskmaster', '', 'support@travianx.mail', 0, 8, 0, 0, '0000-00-00', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'gpack/travian_default/', 1, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `%prefix%vdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%vdata` (
`wref` int(11) NULL,
`owner` int(11) NULL,
`name` varchar(100) NULL,
`capital` tinyint(1) NULL,
`pop` int(11) NULL,
`cp` int(11) NULL,
`celebration` int(11) NULL DEFAULT '0',
`type` int(11) NULL DEFAULT '0',
`wood` float(12,2) NULL,
`clay` float(12,2) NULL,
`iron` float(12,2) NULL,
`maxstore` int(11) NULL,
`crop` float(12,2) NULL,
`maxcrop` int(11) NULL,
`lastupdate` int(11) NULL,
`lastupdate2` int(11) NULL, 
`loyalty` float(9,6) NULL DEFAULT '100',
`exp1` int(11) NULL,
`exp2` int(11) NULL,
`exp3` int(11) NULL,
`created` int(11) NULL,
`natar` tinyint(1) NULL,
`starv` int(11) NULL,
`starvupdate` int(11) NULL,
`evasion` tinyint(1) NULL,
PRIMARY KEY (`wref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%vdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%wdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%wdata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `fieldtype` tinyint(2) NULL,
 `oasistype` tinyint(2) NULL,
 `x` int(11) NULL,
 `y` int(11) NULL,
 `occupied` tinyint(1) NULL,
 `image` varchar(3) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%wdata`
--

-- --------------------------------------------------------
--
-- Table structure for table `%prefix%password`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%password` (
 `uid` int(11) NULL,
 `npw` varchar(100) NULL,
 `cpw` varchar(100) NULL,
 `used` tinyint(1) NULL DEFAULT '0',
 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `%prefix%password`
--

-- --------------------------------------------------------
--
-- Table structure for table `%prefix%ww_attacks`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ww_attacks` (
 `vid` int(25) NULL,
 `attack_time` int(25) NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `%prefix%password`
--

-- --------------------------------------------------------
 
Last edited:
InCube

InCube

Divine Celestial
Joined
Feb 25, 2013
Messages
808
Reaction score
343
Yeah. Without the unsigned, it shouldn't go to these numbers.
Now what you need to do is patch everything that goes below 0. (Do from db_mysql.php)
cata7007 said:
@InCube : could you tell me how can i change ENGINE to InnoDB.

Thanks and regards

PS : this is good ?

Code: 
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 21, 2011 at 02:49 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @[I][B][URL="https://forum.ragezone.com/members/1333464006.html"]old[/URL][/B][/I]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @[I][B][URL="https://forum.ragezone.com/members/1333464006.html"]old[/URL][/B][/I]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @[I][B][URL="https://forum.ragezone.com/members/1333464006.html"]old[/URL][/B][/I]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%a2b`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%a2b` (
 `id` int(11) NULL AUTO_INCREMENT,
 `ckey` varchar(255) NULL,
 `time_check` int(11) NULL DEFAULT '0',
 `to_vid` int(11) NULL,
 `u1` int(11) NULL,
 `u2` int(11) NULL,
 `u3` int(11) NULL,
 `u4` int(11) NULL,
 `u5` int(11) NULL,
 `u6` int(11) NULL,
 `u7` int(11) NULL,
 `u8` int(11) NULL,
 `u9` int(11) NULL,
 `u10` int(11) NULL,
 `u11` int(11) NULL,
 `type` smallint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%a2b`
--

--
-- Table structure for table `%PREFIX%links`
--

CREATE TABLE `%PREFIX%links` (
 `id` INT( 25 ) NULL AUTO_INCREMENT PRIMARY KEY ,
 `userid` INT( 25 ) NULL ,
 `name` VARCHAR( 50 ) NULL ,
 `url` VARCHAR( 150 ) NULL ,
 `pos` INT( 10 ) NULL
) ENGINE = MYISAM;

--
-- Dumping data for table `%PREFIX%links`
--

-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%abdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%abdata` (
 `vref` int(11) NULL,
 `a1` tinyint(2) NULL DEFAULT '0',
 `a2` tinyint(2) NULL DEFAULT '0',
 `a3` tinyint(2) NULL DEFAULT '0',
 `a4` tinyint(2) NULL DEFAULT '0',
 `a5` tinyint(2) NULL DEFAULT '0',
 `a6` tinyint(2) NULL DEFAULT '0',
 `a7` tinyint(2) NULL DEFAULT '0',
 `a8` tinyint(2) NULL DEFAULT '0',
 `b1` tinyint(2) NULL DEFAULT '0',
 `b2` tinyint(2) NULL DEFAULT '0',
 `b3` tinyint(2) NULL DEFAULT '0',
 `b4` tinyint(2) NULL DEFAULT '0',
 `b5` tinyint(2) NULL DEFAULT '0',
 `b6` tinyint(2) NULL DEFAULT '0',
 `b7` tinyint(2) NULL DEFAULT '0',
 `b8` tinyint(2) NULL DEFAULT '0',
 PRIMARY KEY (`vref`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%abdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%activate`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%activate` (
 `id` int(255) NULL AUTO_INCREMENT,
 `username` varchar(100) NULL,
 `password` varchar(100) NULL,
 `email` text NULL,
 `tribe` tinyint(1) NULL,
 `access` tinyint(1) NULL DEFAULT '1',
 `act` varchar(10) NULL,
 `timestamp` int(11) NULL DEFAULT '0',
 `location` text NULL,
 `act2` varchar(10) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%activate`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%active`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%active` (
 `username` varchar(100) NULL,
 `timestamp` int(11) NULL,
 PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%PREFIX%active`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%admin_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%admin_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `user` text NULL,
 `log` text NULL,
 `time` int(25) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=80 ;

--
-- Dumping data for table `%PREFIX%admin_log`
--


-- --------------------------------------------------------
--
-- Table structure for table `%PREFIX%allimedal`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%allimedal` (
 `id` int(11) NULL AUTO_INCREMENT,
 `allyid` int(11) NULL,
 `categorie` int(11) NULL,
 `plaats` int(11) NULL,
 `week` int(11) NULL,
 `points` bigint(255) NULL,
 `img` varchar(255) NULL,
 `del` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%artefacts`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%artefacts` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `owner` int(11) NULL,
 `type` tinyint(2) NULL,
 `size` tinyint(1) NULL,
 `conquered` int(11) NULL,
 `name` varchar(100) NULL,
 `desc` text NULL,
 `effect` varchar(100) NULL,
 `img` varchar(20) NULL,
 `active` tinyint(1) NULL,
 `kind` tinyint(1) NULL,
 `bad_effect` tinyint(1) NULL,
 `effect2` tinyint(2) NULL,
 `lastupdate` int(11) NULL, 
 PRIMARY KEY (`id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Table structure for table `s1_artefacts`
--
-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%alidata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%alidata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `name` varchar(100) NULL,
 `tag` varchar(100) NULL,
 `leader` int(11) NULL,
 `coor` int(11) NULL,
 `advisor` int(11) NULL,
 `recruiter` int(11) NULL,
 `notice` text NULL,
 `desc` text NULL,
 `max` tinyint(2) NULL,
 `ap` bigint(255) NULL DEFAULT '0',
 `dp` bigint(255) NULL DEFAULT '0',
 `Rc` bigint(255) NULL DEFAULT '0',
 `RR` bigint(255) NULL DEFAULT '0',
 `Aap` bigint(255) NULL DEFAULT '0',
 `Adp` bigint(255) NULL DEFAULT '0',
 `clp` bigint(255) NULL DEFAULT '0',
 `oldrank` bigint(255) NULL DEFAULT '0',
 `forumlink` varchar(150) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%alidata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%ali_invite`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ali_invite` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `alliance` int(11) NULL,
 `sender` int(11) NULL,
 `timestamp` int(11) NULL,
 `accept` int(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%ali_invite`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%ali_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ali_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `aid` int(11) NULL,
 `comment` text NULL,
 `date` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%ali_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%ali_permission`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ali_permission` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `alliance` int(11) NULL,
 `rank` varchar(100) NULL,
 `opt1` int(1) NULL DEFAULT '0',
 `opt2` int(1) NULL DEFAULT '0',
 `opt3` int(1) NULL DEFAULT '0',
 `opt4` int(1) NULL DEFAULT '0',
 `opt5` int(1) NULL DEFAULT '0',
 `opt6` int(1) NULL DEFAULT '0',
 `opt7` int(1) NULL DEFAULT '0',
 `opt8` int(1) NULL DEFAULT '0',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%ali_permission`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%attacks`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%attacks` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `t1` int(11) NULL,
 `t2` int(11) NULL,
 `t3` int(11) NULL,
 `t4` int(11) NULL,
 `t5` int(11) NULL,
 `t6` int(11) NULL,
 `t7` int(11) NULL,
 `t8` int(11) NULL,
 `t9` int(11) NULL,
 `t10` int(11) NULL,
 `t11` int(11) NULL,
 `attack_type` tinyint(1) NULL,
 `ctar1` int(11) NULL, 
 `ctar2` int(11) NULL,
 `spy` int(11) NULL, 
 `b1` tinyint(1) NULL, 
 `b2` tinyint(1) NULL, 
 `b3` tinyint(1) NULL, 
 `b4` tinyint(1) NULL, 
 `b5` tinyint(1) NULL, 
 `b6` tinyint(1) NULL, 
 `b7` tinyint(1) NULL, 
 `b8` tinyint(1) NULL, 
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%attacks`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%banlist`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%banlist` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `name` varchar(100) NULL,
 `reason` varchar(30) NULL,
 `time` int(11) NULL,
 `end` varchar(10) NULL,
 `admin` int(11) NULL,
 `active` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%banlist`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%bdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%bdata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `field` tinyint(2) NULL,
 `type` tinyint(2) NULL,
 `loopcon` tinyint(1) NULL,
 `timestamp` int(11) NULL,
 `master` tinyint(1) NULL,
 `level` tinyint(3) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%bdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%build_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%build_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%build_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%chat`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%chat` (
 `id` int(20) NULL AUTO_INCREMENT,
 `id_user` int(11) NULL,
 `name` varchar(255) NULL,
 `alli` varchar(255) NULL,
 `date` varchar(255) NULL,
 `msg` varchar(255) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%chat`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%config`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%config` (
 `lastgavemedal` int(11) NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `%PREFIX%config` VALUES (0);

--
-- Dumping data for table `%prefix%config`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%deleting`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%deleting` (
 `uid` int(11) NULL,
 `timestamp` int(11) NULL,
 PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%deleting`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%demolition`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%demolition` (
 `vref` int(11) NULL,
 `buildnumber` int(11) NULL DEFAULT '0',
 `lvl` int(11) NULL DEFAULT '0',
 `timetofinish` int(11) NULL,
 PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%demolition`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%diplomacy`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%diplomacy` (
 `id` int(11) NULL AUTO_INCREMENT,
 `alli1` int(11) NULL,
 `alli2` int(11) NULL,
 `type` tinyint(1) NULL,
 `accepted` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `%prefix%diplomacy`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%enforcement`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%enforcement` (
 `id` int(11) NULL AUTO_INCREMENT,
 `u1` int(11) NULL DEFAULT '0',
 `u2` int(11) NULL DEFAULT '0',
 `u3` int(11) NULL DEFAULT '0',
 `u4` int(11) NULL DEFAULT '0',
 `u5` int(11) NULL DEFAULT '0',
 `u6` int(11) NULL DEFAULT '0',
 `u7` int(11) NULL DEFAULT '0',
 `u8` int(11) NULL DEFAULT '0',
 `u9` int(11) NULL DEFAULT '0',
 `u10` int(11) NULL DEFAULT '0',
 `u11` int(11) NULL DEFAULT '0',
 `u12` int(11) NULL DEFAULT '0',
 `u13` int(11) NULL DEFAULT '0',
 `u14` int(11) NULL DEFAULT '0',
 `u15` int(11) NULL DEFAULT '0',
 `u16` int(11) NULL DEFAULT '0',
 `u17` int(11) NULL DEFAULT '0',
 `u18` int(11) NULL DEFAULT '0',
 `u19` int(11) NULL DEFAULT '0',
 `u20` int(11) NULL DEFAULT '0',
 `u21` int(11) NULL DEFAULT '0',
 `u22` int(11) NULL DEFAULT '0',
 `u23` int(11) NULL DEFAULT '0',
 `u24` int(11) NULL DEFAULT '0',
 `u25` int(11) NULL DEFAULT '0',
 `u26` int(11) NULL DEFAULT '0',
 `u27` int(11) NULL DEFAULT '0',
 `u28` int(11) NULL DEFAULT '0',
 `u29` int(11) NULL DEFAULT '0',
 `u30` int(11) NULL DEFAULT '0',
 `u31` int(11) NULL DEFAULT '0',
 `u32` int(11) NULL DEFAULT '0',
 `u33` int(11) NULL DEFAULT '0',
 `u34` int(11) NULL DEFAULT '0',
 `u35` int(11) NULL DEFAULT '0',
 `u36` int(11) NULL DEFAULT '0',
 `u37` int(11) NULL DEFAULT '0',
 `u38` int(11) NULL DEFAULT '0',
 `u39` int(11) NULL DEFAULT '0',
 `u40` int(11) NULL DEFAULT '0',
 `u41` int(11) NULL DEFAULT '0',
 `u42` int(11) NULL DEFAULT '0',
 `u43` int(11) NULL DEFAULT '0',
 `u44` int(11) NULL DEFAULT '0',
 `u45` int(11) NULL DEFAULT '0',
 `u46` int(11) NULL DEFAULT '0',
 `u47` int(11) NULL DEFAULT '0',
 `u48` int(11) NULL DEFAULT '0',
 `u49` int(11) NULL DEFAULT '0',
 `u50` int(11) NULL DEFAULT '0',
 `hero` tinyint(1) NULL DEFAULT '0',
 `from` int(11) NULL DEFAULT '0',
 `vref` int(11) NULL DEFAULT '0',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%enforcement`
--

-- --------------------------------------------------------

--
-- Table structure for table `%prefix%farmlist`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%farmlist` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wref` int(11) NULL,
 `owner` int(11) NULL,
 `name` varchar(100) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%farmlist`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%fdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%fdata` (
 `vref` int(11) NULL,
 `f1` tinyint(2) NULL DEFAULT '0',
 `f1t` tinyint(2) NULL DEFAULT '0',
 `f2` tinyint(2) NULL DEFAULT '0',
 `f2t` tinyint(2) NULL DEFAULT '0',
 `f3` tinyint(2) NULL DEFAULT '0',
 `f3t` tinyint(2) NULL DEFAULT '0',
 `f4` tinyint(2) NULL DEFAULT '0',
 `f4t` tinyint(2) NULL DEFAULT '0',
 `f5` tinyint(2) NULL DEFAULT '0',
 `f5t` tinyint(2) NULL DEFAULT '0',
 `f6` tinyint(2) NULL DEFAULT '0',
 `f6t` tinyint(2) NULL DEFAULT '0',
 `f7` tinyint(2) NULL DEFAULT '0',
 `f7t` tinyint(2) NULL DEFAULT '0',
 `f8` tinyint(2) NULL DEFAULT '0',
 `f8t` tinyint(2) NULL DEFAULT '0',
 `f9` tinyint(2) NULL DEFAULT '0',
 `f9t` tinyint(2) NULL DEFAULT '0',
 `f10` tinyint(2) NULL DEFAULT '0',
 `f10t` tinyint(2) NULL DEFAULT '0',
 `f11` tinyint(2) NULL DEFAULT '0',
 `f11t` tinyint(2) NULL DEFAULT '0',
 `f12` tinyint(2) NULL DEFAULT '0',
 `f12t` tinyint(2) NULL DEFAULT '0',
 `f13` tinyint(2) NULL DEFAULT '0',
 `f13t` tinyint(2) NULL DEFAULT '0',
 `f14` tinyint(2) NULL DEFAULT '0',
 `f14t` tinyint(2) NULL DEFAULT '0',
 `f15` tinyint(2) NULL DEFAULT '0',
 `f15t` tinyint(2) NULL DEFAULT '0',
 `f16` tinyint(2) NULL DEFAULT '0',
 `f16t` tinyint(2) NULL DEFAULT '0',
 `f17` tinyint(2) NULL DEFAULT '0',
 `f17t` tinyint(2) NULL DEFAULT '0',
 `f18` tinyint(2) NULL DEFAULT '0',
 `f18t` tinyint(2) NULL DEFAULT '0',
 `f19` tinyint(2) NULL DEFAULT '0',
 `f19t` tinyint(2) NULL DEFAULT '0',
 `f20` tinyint(2) NULL DEFAULT '0',
 `f20t` tinyint(2) NULL DEFAULT '0',
 `f21` tinyint(2) NULL DEFAULT '0',
 `f21t` tinyint(2) NULL DEFAULT '0',
 `f22` tinyint(2) NULL DEFAULT '0',
 `f22t` tinyint(2) NULL DEFAULT '0',
 `f23` tinyint(2) NULL DEFAULT '0',
 `f23t` tinyint(2) NULL DEFAULT '0',
 `f24` tinyint(2) NULL DEFAULT '0',
 `f24t` tinyint(2) NULL DEFAULT '0',
 `f25` tinyint(2) NULL DEFAULT '0',
 `f25t` tinyint(2) NULL DEFAULT '0',
 `f26` tinyint(2) NULL DEFAULT '0',
 `f26t` tinyint(2) NULL DEFAULT '0',
 `f27` tinyint(2) NULL DEFAULT '0',
 `f27t` tinyint(2) NULL DEFAULT '0',
 `f28` tinyint(2) NULL DEFAULT '0',
 `f28t` tinyint(2) NULL DEFAULT '0',
 `f29` tinyint(2) NULL DEFAULT '0',
 `f29t` tinyint(2) NULL DEFAULT '0',
 `f30` tinyint(2) NULL DEFAULT '0',
 `f30t` tinyint(2) NULL DEFAULT '0',
 `f31` tinyint(2) NULL DEFAULT '0',
 `f31t` tinyint(2) NULL DEFAULT '0',
 `f32` tinyint(2) NULL DEFAULT '0',
 `f32t` tinyint(2) NULL DEFAULT '0',
 `f33` tinyint(2) NULL DEFAULT '0',
 `f33t` tinyint(2) NULL DEFAULT '0',
 `f34` tinyint(2) NULL DEFAULT '0',
 `f34t` tinyint(2) NULL DEFAULT '0',
 `f35` tinyint(2) NULL DEFAULT '0',
 `f35t` tinyint(2) NULL DEFAULT '0',
 `f36` tinyint(2) NULL DEFAULT '0',
 `f36t` tinyint(2) NULL DEFAULT '0',
 `f37` tinyint(2) NULL DEFAULT '0',
 `f37t` tinyint(2) NULL DEFAULT '0',
 `f38` tinyint(2) NULL DEFAULT '0',
 `f38t` tinyint(2) NULL DEFAULT '0',
 `f39` tinyint(2) NULL DEFAULT '0',
 `f39t` tinyint(2) NULL DEFAULT '0',
 `f40` tinyint(2) NULL DEFAULT '0',
 `f40t` tinyint(2) NULL DEFAULT '0',
 `f99` tinyint(2) NULL DEFAULT '0',
 `f99t` tinyint(2) NULL DEFAULT '0',
 `wwname` varchar(100) NULL DEFAULT 'World Wonder',
 PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

--
-- Dumping data for table `%prefix%fdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_cat`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_cat` (
 `id` int(11) NULL AUTO_INCREMENT,
 `owner` varchar(255) NULL,
 `alliance` varchar(255) NULL,
 `forum_name` varchar(255) NULL,
 `forum_des` text NULL,
 `forum_area` varchar(255) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_cat`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_edit`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_edit` (
 `id` int(11) NULL AUTO_INCREMENT,
 `alliance` varchar(255) NULL,
 `result` varchar(255) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_edit`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_post`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_post` (
 `id` int(11) NULL AUTO_INCREMENT,
 `post` longtext NULL,
 `topic` varchar(255) NULL,
 `owner` varchar(255) NULL,
 `date` varchar(255) NULL,
 `alliance0` int(11) NULL,
 `player0` int(11) NULL,
 `coor0` int(11) NULL,
 `report0` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_post`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_survey`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_survey` (
 `topic` int(11) NULL,
 `title` varchar(255) NULL,
 `option1` varchar(255) NULL,
 `option2` varchar(255) NULL,
 `option3` varchar(255) NULL,
 `option4` varchar(255) NULL,
 `option5` varchar(255) NULL,
 `option6` varchar(255) NULL,
 `option7` varchar(255) NULL,
 `option8` varchar(255) NULL,
 `vote1` int(11) NULL DEFAULT '0',
 `vote2` int(11) NULL DEFAULT '0',
 `vote3` int(11) NULL DEFAULT '0',
 `vote4` int(11) NULL DEFAULT '0',
 `vote5` int(11) NULL DEFAULT '0',
 `vote6` int(11) NULL DEFAULT '0',
 `vote7` int(11) NULL DEFAULT '0',
 `vote8` int(11) NULL DEFAULT '0',
 `voted` text NULL,
 `ends` int(11) NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_survey`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%forum_topic`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%forum_topic` (
 `id` int(11) NULL AUTO_INCREMENT,
 `title` varchar(255) NULL,
 `post` longtext NULL,
 `date` varchar(255) NULL,
 `post_date` varchar(255) NULL,
 `cat` varchar(255) NULL,
 `owner` varchar(255) NULL,
 `alliance` varchar(255) NULL,
 `ends` varchar(255) NULL,
 `close` varchar(255) NULL,
 `stick` varchar(255) NULL,
 `alliance0` int(11) NULL,
 `player0` int(11) NULL,
 `coor0` int(11) NULL,
 `report0` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%forum_topic`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%general`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%general` (
 `id` int(11) NULL AUTO_INCREMENT,
 `casualties` int(11) NULL,
 `time` int(11) NULL,
 `shown` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%general`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%gold_fin_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%gold_fin_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%gold_fin_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%hero`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%hero` (
 `heroid` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `unit` smallint(2) NULL,
 `name` tinytext NULL,
 `wref` int(11) NULL,
 `level` tinyint(3) NULL,
 `points` int(3) NULL,
 `experience` int(11) NULL,
 `dead` tinyint(1) NULL,
 `health` float(12,9) NULL,
 `attack` tinyint(3) NULL,
 `defence` tinyint(3) NULL,
 `attackbonus` tinyint(3) NULL,
 `defencebonus` tinyint(3) NULL,
 `regeneration` tinyint(3) NULL,
 `autoregen` int(2) NULL,
 `lastupdate` int(11) NULL,
 `trainingtime` int(11) NULL,
 `inrevive` tinyint(1) NULL,
 `intraining` tinyint(1) NULL,
 PRIMARY KEY (`heroid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Dumping data for table `%prefix%hero`
--



-- --------------------------------------------------------

--
-- Table structure for table `%prefix%illegal_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%illegal_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `user` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%illegal_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%login_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%login_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `ip` varchar(15) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%login_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%market`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%market` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `gtype` tinyint(1) NULL,
 `gamt` int(11) NULL,
 `wtype` tinyint(1) NULL,
 `wamt` int(11) NULL,
 `accept` tinyint(1) NULL,
 `maxtime` int(11) NULL,
 `alliance` int(11) NULL,
 `merchant` tinyint(2) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%market`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%market_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%market_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%market_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%mdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%mdata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `target` int(11) NULL,
 `owner` int(11) NULL,
 `topic` varchar(100) NULL,
 `message` text NULL,
 `viewed` tinyint(1) NULL,
 `archived` tinyint(1) NULL,
 `send` tinyint(1) NULL,
 `time` int(11) NULL DEFAULT '0',
 `deltarget` int(11) NULL,
 `delowner` int(11) NULL,
 `alliance` int(11) NULL,
 `player` int(11) NULL,
 `coor` int(11) NULL,
 `report` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%mdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%medal`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%medal` (
 `id` int(11) NULL AUTO_INCREMENT,
 `userid` int(11) NULL,
 `categorie` int(11) NULL,
 `plaats` int(11) NULL,
 `week` int(11) NULL,
 `points` varchar(15) NULL,
 `img` varchar(10) NULL,
 `del` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%medal`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%movement`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%movement` (
 `moveid` int(11) NULL AUTO_INCREMENT,
 `sort_type` tinyint(4) NULL DEFAULT '0',
 `from` int(11) NULL DEFAULT '0',
 `to` int(11) NULL DEFAULT '0',
 `ref` int(11) NULL DEFAULT '0',
 `ref2` int(11) NULL DEFAULT '0',
 `starttime` int(11) NULL DEFAULT '0',
 `endtime` int(11) NULL DEFAULT '0',
 `proc` tinyint(1) NULL DEFAULT '0',
 `send` tinyint(1) NULL,
 `wood` int(11) NULL,
 `clay` int(11) NULL,
 `iron` int(11) NULL,
 `crop` int(11) NULL,
 PRIMARY KEY (`moveid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%movement`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%ndata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ndata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `toWref` int(11) NULL,
 `ally` int(11) NULL,
 `topic` text NULL,
 `ntype` tinyint(1) NULL,
 `data` text NULL,
 `time` int(11) NULL,
 `viewed` tinyint(1) NULL,
 `archive` tinyint(1) NULL,
 `del` tinyint(1) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%ndata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%odata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%odata` (
 `wref` int(11) NULL,
 `type` tinyint(2) NULL,
 `conqured` int(11) NULL,
 `wood` int(11) NULL,
 `iron` int(11) NULL,
 `clay` int(11) NULL,
 `maxstore` int(11) NULL,
 `crop` int(11) NULL,
 `maxcrop` int(11) NULL,
 `lastupdated` int(11) NULL,
 `lastupdated2` int(11) NULL,
 `loyalty` float(9,6) NULL DEFAULT '100',
 `owner` int(11) NULL DEFAULT '2',
 `name` varchar(32) NULL DEFAULT 'Unoccupied Oasis',
 `high` tinyint(1) NULL,
 PRIMARY KEY (`wref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%odata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%online`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%online` (
 `name` varchar(32) NULL,
 `uid` int(11) NULL,
 `time` varchar(32) NULL,
 `sit` tinyint(1) NULL,
 UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%online`
--

-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%prisoners`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%prisoners` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wref` int(11) NULL,
 `from` int(11) NULL,
 `t1` int(11) NULL,
 `t2` int(11) NULL,
 `t3` int(11) NULL,
 `t4` int(11) NULL,
 `t5` int(11) NULL,
 `t6` int(11) NULL,
 `t7` int(11) NULL,
 `t8` int(11) NULL,
 `t9` int(11) NULL,
 `t10` int(11) NULL,
 `t11` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%PREFIX%prisoners`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%raidlist`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%raidlist` (
 `id` int(11) NULL AUTO_INCREMENT,
 `lid` int(11) NULL,
 `towref` int(11) NULL,
 `x` int(11) NULL,
 `y` int(11) NULL,
 `distance` varchar(5) NULL DEFAULT '0',
 `t1` int(11) NULL,
 `t2` int(11) NULL,
 `t3` int(11) NULL,
 `t4` int(11) NULL,
 `t5` int(11) NULL,
 `t6` int(11) NULL,
 `t7` int(11) NULL,
 `t8` int(11) NULL,
 `t9` int(11) NULL,
 `t10` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%raidlist`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%research`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%research` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `tech` varchar(3) NULL,
 `timestamp` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%research`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%route`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%route` (
 `id` int(11) NULL AUTO_INCREMENT,
 `uid` int(11) NULL,
 `wid` int(11) NULL,
 `from` int(11) NULL,
 `wood` int(5) NULL,
 `clay` int(5) NULL,
 `iron` int(5) NULL,
 `crop` int(5) NULL,
 `start` tinyint(2) NULL,
 `deliveries` tinyint(1) NULL,
 `merchant` int(11) NULL,
 `timestamp` int(11) NULL,
 `timeleft` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%route`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%send`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%send` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wood` int(11) NULL,
 `clay` int(11) NULL,
 `iron` int(11) NULL,
 `crop` int(11) NULL,
 `merchant` tinyint(2) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%send`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%tdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%tdata` (
 `vref` int(11) NULL,
 `t2` tinyint(1) NULL DEFAULT '0',
 `t3` tinyint(1) NULL DEFAULT '0',
 `t4` tinyint(1) NULL DEFAULT '0',
 `t5` tinyint(1) NULL DEFAULT '0',
 `t6` tinyint(1) NULL DEFAULT '0',
 `t7` tinyint(1) NULL DEFAULT '0',
 `t8` tinyint(1) NULL DEFAULT '0',
 `t9` tinyint(1) NULL DEFAULT '0',
 `t12` tinyint(1) NULL DEFAULT '0',
 `t13` tinyint(1) NULL DEFAULT '0',
 `t14` tinyint(1) NULL DEFAULT '0',
 `t15` tinyint(1) NULL DEFAULT '0',
 `t16` tinyint(1) NULL DEFAULT '0',
 `t17` tinyint(1) NULL DEFAULT '0',
 `t18` tinyint(1) NULL DEFAULT '0',
 `t19` tinyint(1) NULL DEFAULT '0',
 `t22` tinyint(1) NULL DEFAULT '0',
 `t23` tinyint(1) NULL DEFAULT '0',
 `t24` tinyint(1) NULL DEFAULT '0',
 `t25` tinyint(1) NULL DEFAULT '0',
 `t26` tinyint(1) NULL DEFAULT '0',
 `t27` tinyint(1) NULL DEFAULT '0',
 `t28` tinyint(1) NULL DEFAULT '0',
 `t29` tinyint(1) NULL DEFAULT '0',
 `t32` tinyint(1) NULL DEFAULT '0',
 `t33` tinyint(1) NULL DEFAULT '0',
 `t34` tinyint(1) NULL DEFAULT '0',
 `t35` tinyint(1) NULL DEFAULT '0',
 `t36` tinyint(1) NULL DEFAULT '0',
 `t37` tinyint(1) NULL DEFAULT '0',
 `t38` tinyint(1) NULL DEFAULT '0',
 `t39` tinyint(1) NULL DEFAULT '0',
 `t42` tinyint(1) NULL DEFAULT '0',
 `t43` tinyint(1) NULL DEFAULT '0',
 `t44` tinyint(1) NULL DEFAULT '0',
 `t45` tinyint(1) NULL DEFAULT '0',
 `t46` tinyint(1) NULL DEFAULT '0',
 `t47` tinyint(1) NULL DEFAULT '0',
 `t48` tinyint(1) NULL DEFAULT '0',
 `t49` tinyint(1) NULL DEFAULT '0',
 PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%tdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%tech_log`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%tech_log` (
 `id` int(11) NULL AUTO_INCREMENT,
 `wid` int(11) NULL,
 `log` text NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%tech_log`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%training`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%training` (
 `id` int(11) NULL AUTO_INCREMENT,
 `vref` int(11) NULL,
 `unit` tinyint(2) NULL,
 `amt` int(11) NULL,
 `pop` int(11) NULL,
 `timestamp` int(11) NULL,
 `eachtime` int(11) NULL,
 `timestamp2` int(11) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%training`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%units`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%units` (
 `vref` int(11) NULL,
 `u1` int(11) NULL DEFAULT '0',
 `u2` int(11) NULL DEFAULT '0',
 `u3` int(11) NULL DEFAULT '0',
 `u4` int(11) NULL DEFAULT '0',
 `u5` int(11) NULL DEFAULT '0',
 `u6` int(11) NULL DEFAULT '0',
 `u7` int(11) NULL DEFAULT '0',
 `u8` int(11) NULL DEFAULT '0',
 `u9` int(11) NULL DEFAULT '0',
 `u10` int(11) NULL DEFAULT '0',
 `u11` int(11) NULL DEFAULT '0',
 `u12` int(11) NULL DEFAULT '0',
 `u13` int(11) NULL DEFAULT '0',
 `u14` int(11) NULL DEFAULT '0',
 `u15` int(11) NULL DEFAULT '0',
 `u16` int(11) NULL DEFAULT '0',
 `u17` int(11) NULL DEFAULT '0',
 `u18` int(11) NULL DEFAULT '0',
 `u19` int(11) NULL DEFAULT '0',
 `u20` int(11) NULL DEFAULT '0',
 `u21` int(11) NULL DEFAULT '0',
 `u22` int(11) NULL DEFAULT '0',
 `u23` int(11) NULL DEFAULT '0',
 `u24` int(11) NULL DEFAULT '0',
 `u25` int(11) NULL DEFAULT '0',
 `u26` int(11) NULL DEFAULT '0',
 `u27` int(11) NULL DEFAULT '0',
 `u28` int(11) NULL DEFAULT '0',
 `u29` int(11) NULL DEFAULT '0',
 `u30` int(11) NULL DEFAULT '0',
 `u31` int(11) NULL DEFAULT '0',
 `u32` int(11) NULL DEFAULT '0',
 `u33` int(11) NULL DEFAULT '0',
 `u34` int(11) NULL DEFAULT '0',
 `u35` int(11) NULL DEFAULT '0',
 `u36` int(11) NULL DEFAULT '0',
 `u37` int(11) NULL DEFAULT '0',
 `u38` int(11) NULL DEFAULT '0',
 `u39` int(11) NULL DEFAULT '0',
 `u40` int(11) NULL DEFAULT '0',
 `u41` int(11) NULL DEFAULT '0',
 `u42` int(11) NULL DEFAULT '0',
 `u43` int(11) NULL DEFAULT '0',
 `u44` int(11) NULL DEFAULT '0',
 `u45` int(11) NULL DEFAULT '0',
 `u46` int(11) NULL DEFAULT '0',
 `u47` int(11) NULL DEFAULT '0',
 `u48` int(11) NULL DEFAULT '0',
 `u49` int(11) NULL DEFAULT '0',
 `u50` int(11) NULL DEFAULT '0',
 `u99` int(11) NULL DEFAULT '0',
 `u99o` int(11) NULL DEFAULT '0',
 `hero` int(11) NULL DEFAULT '0',
 PRIMARY KEY (`vref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `%prefix%units`
--


-- --------------------------------------------------------

--
-- Table structure for table `%PREFIX%users`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%users` (
 `id` int(11) NULL AUTO_INCREMENT,
 `username` varchar(100) NULL,
 `password` varchar(100) NULL,
 `email` text NULL,
 `tribe` tinyint(1) NULL,
 `access` tinyint(1) NULL DEFAULT '1',
 `gold` int(9) NULL DEFAULT '0',
 `gender` tinyint(1) NULL DEFAULT '0',
 `birthday` date NULL DEFAULT '0000-00-00',
 `location` text NULL,
 `desc1` text NULL,
 `desc2` text NULL,
 `plus` int(11) NULL DEFAULT '0',
 `goldclub` int(11) NULL DEFAULT '0',
 `b1` int(11) NULL DEFAULT '0',
 `b2` int(11) NULL DEFAULT '0',
 `b3` int(11) NULL DEFAULT '0',
 `b4` int(11) NULL DEFAULT '0',
 `sit1` int(11) NULL DEFAULT '0',
 `sit2` int(11) NULL DEFAULT '0',
 `alliance` int(11) NULL DEFAULT '0',
 `sessid` varchar(100) NULL,
 `act` varchar(10) NULL,
 `timestamp` int(11) NULL DEFAULT '0',
 `ap` int(11) NULL DEFAULT '0',
 `apall` int(11) NULL DEFAULT '0',
 `dp` int(11) NULL DEFAULT '0',
 `dpall` int(11) NULL DEFAULT '0',
 `protect` int(11) NULL,
 `quest` tinyint(2) NULL,
 `quest_time` int(11) NULL,
 `gpack` varchar(255) NULL DEFAULT 'gpack/travian_default/',
 `cp` float(14,5) NULL DEFAULT '1',
 `lastupdate` int(11) NULL,
 `RR` int(255) NULL DEFAULT '0',
 `Rc` int(255) NULL DEFAULT '0',
 `ok` tinyint(1) NULL DEFAULT '0',
 `clp` bigint(255) NULL DEFAULT '0',
 `oldrank` bigint(255) NULL DEFAULT '0',
 `regtime` int(11) NULL DEFAULT '0',
 `invited` int(11) NULL DEFAULT '0',
 `friend0` int(11) NULL,
 `friend1` int(11) NULL,
 `friend2` int(11) NULL,
 `friend3` int(11) NULL,
 `friend4` int(11) NULL,
 `friend5` int(11) NULL,
 `friend6` int(11) NULL,
 `friend7` int(11) NULL,
 `friend8` int(11) NULL,
 `friend9` int(11) NULL,
 `friend10` int(11) NULL,
 `friend11` int(11) NULL,
 `friend12` int(11) NULL,
 `friend13` int(11) NULL,
 `friend14` int(11) NULL,
 `friend15` int(11) NULL,
 `friend16` int(11) NULL,
 `friend17` int(11) NULL,
 `friend18` int(11) NULL,
 `friend19` int(11) NULL,
 `friend0wait` int(11) NULL,
 `friend1wait` int(11) NULL,
 `friend2wait` int(11) NULL,
 `friend3wait` int(11) NULL,
 `friend4wait` int(11) NULL,
 `friend5wait` int(11) NULL,
 `friend6wait` int(11) NULL,
 `friend7wait` int(11) NULL,
 `friend8wait` int(11) NULL,
 `friend9wait` int(11) NULL,
 `friend10wait` int(11) NULL,
 `friend11wait` int(11) NULL,
 `friend12wait` int(11) NULL,
 `friend13wait` int(11) NULL,
 `friend14wait` int(11) NULL,
 `friend15wait` int(11) NULL,
 `friend16wait` int(11) NULL,
 `friend17wait` int(11) NULL,
 `friend18wait` int(11) NULL,
 `friend19wait` int(11) NULL,
 `maxevasion` mediumint(3) NULL,
 `village_select` bigint(20) DEFAULT NULL,
 `vac_time` varchar(255) NULL,
 `vac_mode` int(2) NULL DEFAULT '0',
 `vactwoweeks` varchar(255) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `%prefix%users`
--

INSERT INTO `%PREFIX%users` (`id`, `username`, `password`, `email`, `tribe`, `access`, `gold`, `gender`, `birthday`, `location`, `desc1`, `desc2`, `plus`, `b1`, `b2`, `b3`, `b4`, `sit1`, `sit2`, `alliance`, `sessid`, `act`, `timestamp`, `ap`, `apall`, `dp`, `dpall`, `protect`, `quest`, `gpack`, `cp`, `lastupdate`, `RR`, `Rc`, `ok`) VALUES
(5, 'Multihunter', '', 'multihunter@travianx.mail', 0, 9, 0, 0, '0000-00-00', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'gpack/travian_default/', 1, 0, 0, 0, 0),
(1, 'Support', '', 'support@travianx.mail', 0, 8, 0, 0, '0000-00-00', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'gpack/travian_default/', 1, 0, 0, 0, 0),
(2, 'Nature', '', 'support@travianx.mail', 4, 8, 0, 0, '0000-00-00', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'gpack/travian_default/', 1, 0, 0, 0, 0),
(4, 'Taskmaster', '', 'support@travianx.mail', 0, 8, 0, 0, '0000-00-00', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'gpack/travian_default/', 1, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `%prefix%vdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%vdata` (
`wref` int(11) NULL,
`owner` int(11) NULL,
`name` varchar(100) NULL,
`capital` tinyint(1) NULL,
`pop` int(11) NULL,
`cp` int(11) NULL,
`celebration` int(11) NULL DEFAULT '0',
`type` int(11) NULL DEFAULT '0',
`wood` float(12,2) NULL,
`clay` float(12,2) NULL,
`iron` float(12,2) NULL,
`maxstore` int(11) NULL,
`crop` float(12,2) NULL,
`maxcrop` int(11) NULL,
`lastupdate` int(11) NULL,
`lastupdate2` int(11) NULL, 
`loyalty` float(9,6) NULL DEFAULT '100',
`exp1` int(11) NULL,
`exp2` int(11) NULL,
`exp3` int(11) NULL,
`created` int(11) NULL,
`natar` tinyint(1) NULL,
`starv` int(11) NULL,
`starvupdate` int(11) NULL,
`evasion` tinyint(1) NULL,
PRIMARY KEY (`wref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%vdata`
--


-- --------------------------------------------------------

--
-- Table structure for table `%prefix%wdata`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%wdata` (
 `id` int(11) NULL AUTO_INCREMENT,
 `fieldtype` tinyint(2) NULL,
 `oasistype` tinyint(2) NULL,
 `x` int(11) NULL,
 `y` int(11) NULL,
 `occupied` tinyint(1) NULL,
 `image` varchar(3) NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `%prefix%wdata`
--

-- --------------------------------------------------------
--
-- Table structure for table `%prefix%password`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%password` (
 `uid` int(11) NULL,
 `npw` varchar(100) NULL,
 `cpw` varchar(100) NULL,
 `used` tinyint(1) NULL DEFAULT '0',
 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `%prefix%password`
--

-- --------------------------------------------------------
--
-- Table structure for table `%prefix%ww_attacks`
--

CREATE TABLE IF NOT EXISTS `%PREFIX%ww_attacks` (
 `vid` int(25) NULL,
 `attack_time` int(25) NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

--
-- Dumping data for table `%prefix%password`
--

-- --------------------------------------------------------
Click to expand...
 
cata7007

cata7007

Skilled Illusionist
Joined
Mar 9, 2011
Messages
391
Reaction score
120
@InCube : can you give me an example for this : Now what you need to do is patch everything that goes below 0. (Do from db_mysql.php)

I`m not am developer , it`s just a hobby , i try to do my best.

Thanks
 
InCube

InCube

Divine Celestial
Joined
Feb 25, 2013
Messages
808
Reaction score
343
You must be registered to see links


Fixed looks like something this:
Mostly it comes from Automation.php but doing it from db_mysql should do the trick.
Code: 
	function modifyUnit($vref, $array_unit, $array_amt, $array_mode){
		$i = -1;
		$units='';
		$number = count($array_unit);
		foreach($array_unit as $unit){
			if($unit == 230){$unit = 30;}
			if($unit == 231){$unit = 31;}
			if($unit == 120){$unit = 20;}
			if($unit == 121){$unit = 21;}
			if($unit =="hero"){$unit = 'hero';}
			else{$unit = 'u' . $unit;}
			++$i;
// Fixed
$array_amt[$i] = $array_amt[$i] < 0 ? 0 : $array_amt[$i];
//


			$units .= $unit.' = '.$unit.' '.(($array_mode[$i] == 1)? '+':'-').'  '.$array_amt[$i].(($number > $i+1) ? ', ' : '');
		}
		$q = "UPDATE ".TB_PREFIX."units set $units WHERE vref = $vref";
		return mysql_query($q, $this->connection);
	}
 
cata7007

cata7007

Skilled Illusionist
Joined
Mar 9, 2011
Messages
391
Reaction score
120
Should I do this for all function or only for function that have units in code ? (modifyEnforce)

Code: 
	function modifyEnforce($id, $unit, $amt, $mode) {
		if($unit != 'hero') { $unit = 'u' . $unit; }
		if(!$mode) {
		// Fixed
		$amt[$i] = $amt[$i] < 0 ? 0 : $amt[$i];
		//
			$q = "UPDATE " . TB_PREFIX . "enforcement set $unit = $unit - $amt where id = $id";
		} else {
			$q = "UPDATE " . TB_PREFIX . "enforcement set $unit = $unit + $amt where id = $id";
		}
		mysql_query($q, $this->connection);
	}

Thank you again.

PS : after change database, reports don`t appear , show me the green icon that i have a report but when i click : There are no reports available.

PPS : this is the real git :
You must be registered to see links


That version is an old version , that is not updated.
 
Last edited:
A

Amanda Cheney

Initiate Mage
Joined
May 30, 2013
Messages
2
Reaction score
0
advocaite posted this years ago just no one bother to fix the issue.

and people still using
mysql_query

is disgusting use mysqli or PDO wrapper
 
cata7007

cata7007

Skilled Illusionist
Joined
Mar 9, 2011
Messages
391
Reaction score
120
Show me his topic. 1 year ago we still working on travian (ronix , me , etc.)

None bother to make an update on github just tell : WE WANT MONEY , MONEY , MONEY !!!!
ALL WANT MONEY !!!
 
InCube

InCube

Divine Celestial
Joined
Feb 25, 2013
Messages
808
Reaction score
343
lol advocaite posted a topic ? Are you for real ? To be honest he doesn't even give a crap about Travian..
 
cata7007

cata7007

Skilled Illusionist
Joined
Mar 9, 2011
Messages
391
Reaction score
120
On understand you want to dirty your hands , but if i ask for another part of code ( a little not all function) , not all , just a part to understand batter.

Thank you

For example in here appear a negative
 
Last edited:
InCube

InCube

Divine Celestial
Joined
Feb 25, 2013
Messages
808
Reaction score
343
cata7007 said:
On understand you want to dirty your hands , but if i ask for another part of code ( a little not all function) , not all , just a part to understand batter.

Thank you

For example in here appear a negative

Code: 
    function getUnitsNumber($vid) {
        $q = "SELECT * from " . TB_PREFIX . "units where vref = $vid";
        $result = mysql_query($q, $this->connection);
        $dbarray = mysql_fetch_assoc($result);
        $totalunits = 0;
        $movingunits = $this->getVillageMovement($vid);
        for($i=1;$i<=50;$i++){
        $totalunits += $dbarray['u'.$i];
        }
        $totalunits += $dbarray['hero'];
        $movingunits = $this->getVillageMovement($vid);
        $reinforcingunits = $this->getEnforceArray($vid,1);
        $owner = $this->getVillageField($vid,"owner");
        $ownertribe = $this->getUserField($owner,"tribe",0);
        $start = [B]($ownertribe-1)[/B]*10+1;
        $end = ($ownertribe*10);
        for($i=$start;$i<=$end;$i++){
        $totalunits += $movingunits['u'.$i];
        $totalunits += $reinforcingunits['u'.$i];
        }
        $totalunits += $movingunits['hero'];
        $totalunits += $reinforcingunits['hero'];
        return $totalunits;
    }
Click to expand...
that's not negative, that is tribe ID.

(1-1) * 10 + 1 = 1
(2-1) * 10 + 1 = 11
(3-1) * 10 + 1 = 21
 
cata7007

cata7007

Skilled Illusionist
Joined
Mar 9, 2011
Messages
391
Reaction score
120
InCube said:
that's not negative, that is tribe ID.

(1-1) * 10 + 1 = 1
(2-1) * 10 + 1 = 11
(3-1) * 10 + 1 = 21
Click to expand...

That value are for tribes , understand.

I didn`t fond any other negative value
 
InCube

InCube

Divine Celestial
Joined
Feb 25, 2013
Messages
808
Reaction score
343
cata7007 said:
That value are for tribes , understand.

I didn`t fond any other negative value
Click to expand...
You didn't ? When I was reworking battle for my new game I found a lot of negaties in catapults and other.

You need to filter these values:
You must be registered to see links


This is only for defender and still not properly coded:
You must be registered to see links


This part goes also below 0 if u have a lot of catapults
You must be registered to see links


Useless variable:
You must be registered to see links



There are much more.. Just too lazy to dig.
 
cata7007

cata7007

Skilled Illusionist
Joined
Mar 9, 2011
Messages
391
Reaction score
120
Ahh , thank you for your patience but i`m not the proper knowledge to know how to code all that parts ... hope ronix or someone ...

Again thanks
 
advocaite

advocaite

Depths of hell...
500 Posts 10 Happy Years
Joined
May 15, 2009
Messages
799
Reaction score
558
Show me his topic. 1 year ago we still working on travian (ronix , me , etc.)
Click to expand...
lol advocaite posted a topic ? Are you for real ? To be honest he doesn't even give a crap about Travian..
Click to expand...

someone mention my name let me see.. yes i did mention this ages ago let me check for you a good search can be awesome tool
https://forum.ragezone.com/f582/received-4294967295-soldier-795144-post6658421/#post6658421

this one is the best just after you posted incube

https://forum.ragezone.com/f583/fixes-travianz-943032-post7681007/#post7681007

and your right I have not had time to do anything travian related sorry about that people.

but yes I did explain this issue and how to fix many times
 
InCube

InCube

Divine Celestial
Joined
Feb 25, 2013
Messages
808
Reaction score
343
advocaite said:
someone mention my name let me see.. yes i did mention this ages ago let me check for you a good search can be awesome tool
https://forum.ragezone.com/f582/received-4294967295-soldier-795144-post6658421/#post6658421

this one is the best just after you posted incube

https://forum.ragezone.com/f583/fixes-travianz-943032-post7681007/#post7681007

and your right I have not had time to do anything travian related sorry about that people.

but yes I did explain this issue and how to fix many times
Click to expand...

This is what happens when you try to explain for 4 years and only now **SOME** people starting to listen. :D
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
184
Guests online
3,270
Total visitors
3,454
Totals may include hidden visitors.

Forum statistics

Threads
428,895
Messages
4,589,258
Members
279,657
Latest member
laruleuliti
Most visitors online was 8830 , on 6 Feb 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top