-- MySQL dump 8.22 -- -- Host: localhost Database: fleetwar --------------------------------------------------------- -- Server version 3.23.56 -- -- Table structure for table 'article' -- CREATE TABLE article ( article_id int(11) NOT NULL default '0', category_id int(11) NOT NULL default '0', author_id int(11) NOT NULL default '0', last_editor_id int(11) NOT NULL default '0', en_title varchar(50) NOT NULL default '', no_title varchar(50) NOT NULL default '', en_intro_text text NOT NULL, no_intro_text text NOT NULL, en_text text NOT NULL, no_text text NOT NULL, image text NOT NULL, urgent int(11) default NULL, pos bigint(20) NOT NULL default '0', english int(11) default NULL, norwegian int(11) default NULL, created_date datetime default NULL, editted_date datetime default NULL, PRIMARY KEY (article_id) ) TYPE=MyISAM; -- -- Dumping data for table 'article' -- INSERT INTO article VALUES (1,3,1,1,'fleetwar portal is open','','Fleetwar is the portal sister site for warfleet. News and announcements will be posted at fleetwar.','','fleetwar will also be an archive of articles that players can search through. It will be built by the players for the players.','','',0,76,0,0,'2003-03-19 12:08:00','2003-03-21 09:15:09'); INSERT INTO article VALUES (2,6,1,1,'warfleet galaxies','','This round players will be making their own 10-20 player galaxies!','','Galaxies will be about 10-20 players, and are password protected. They run until someone wins.
\r\n
\r\nThe tick speed is every hour.
\r\n
\r\nWho sets this? Well special galaxy administrators will be able to create 1 galaxy at a time. This person will have to apply to be accepted. They will also be responsible for organising the players in the galaxy.
\r\n
\r\nclick here to apply to be a galaxy admin guy','','',0,42,0,0,'2003-03-19 15:58:00','2003-05-20 17:53:17'); INSERT INTO article VALUES (11,3,1,1,'In game reward','','If you spot a spelling or grammer mistake I have made I will give you a free unit!','','I am awful at spelling and grammer. So from now on anyone who spots a grammer/spelling mistake I make, in the game itself or at fleetwar, will get 1 free unit of their choice (ANY civ type) in the game...
\r\n
\r\nJust email admin@warfleet.com with :
\r\n1) Your empire name
\r\n2) Your Galaxy name
\r\n3) the error found
\r\n4) The desired unit (any)
\r\n5) The planet you want it on
\r\n
\r\nNB: This does not include any forum posts I make or in-game intercoms I send. :-)','','',0,32,0,0,'2003-05-26 12:24:53','2003-05-26 23:06:17'); INSERT INTO article VALUES (12,3,1,1,'Empire screens work','','Empire Screens (where players can describe their empire) are working.','','If you go to the ranking screen you can click on the empire (if the player have entered some data) and read all about them.
\r\n
\r\nTo add data about your empire, login, and go to the [Alliances] screen, and click the [official screen] button.','','',0,31,1,0,'2003-05-28 15:36:55','2003-05-28 15:36:55'); INSERT INTO article VALUES (4,3,1,1,'Slip me some skin...','','Warfleet is now fully skinable. The \"classic\" interface remains, but now you can choose from 3 others too (screenshots).','','Here are what the skins look like:
\r\n(there is one per civ)
\r\n
\r\nIsolationist:
\r\n\r\n

\r\nCapitalist (also \"classic\"):
\r\n\r\n

\r\nMarauder:
\r\n\r\n

\r\nTyrant:
\r\n\r\n

\r\nAnd no.. you DONT have to be the civ to use the skin...','','',0,55,0,0,'2003-04-09 16:48:32','2003-05-02 14:40:32'); INSERT INTO article VALUES (13,6,1,1,'Unit Balance','','Some units have been tweaked. Read on to find out exactly what has been changed.','',':TONED UP:
\r\nRight now, Conscripts cost ZERO upkeep, but as a compromise they take an extra tick to make. They are useless anyway, and only function to reduce casualties in more useful units.
\r\n
\r\n:TONED DOWN:
\r\nI have made the captalists units better work together, and complement each other. Massing units of one type no longer works that well. Don\'t worry, an army laced with Combat Droids will take a hammering, but (for example) Chemelions on their own are easily damaged.','','',0,26,0,0,'2003-05-28 15:43:50','2003-05-28 15:45:53'); INSERT INTO article VALUES (14,3,1,1,'Names GONE','','The names of some ships/planets have ben wiped by me by accident!','','I accidentally updated the database (I was #trimming# \"long\" names becasue the long planet/ship names actually screw up the map).\r\n\r\nSo I was in there to \"trim\" the names that were too long -- but I deleted them instead (whoops). To make up for it you can manually enter a new name in the VIEW screen if you are affected. \r\n

\r\nSo it should be ok.','','',0,22,0,0,'2003-06-04 14:49:18','2003-06-04 15:38:01'); INSERT INTO article VALUES (7,5,1,1,'Apply for a GALAXY','','Warfleet wants players to apply for a galaxy. ','','The role of the galaxy is fully explained here.
\r\n
\r\nBasically warfleet need galaxies of 10 to 20 players that will run for a predefined length of time, with a password.
\r\n
\r\nClick here to apply for galaxy admin status now!\r\n','','images/galaxy.jpg',0,40,0,0,'2003-05-19 08:48:03','2003-05-19 09:29:10'); INSERT INTO article VALUES (8,3,1,1,'Round 3 is GO GO GO','','Warfleet IS LIVE!!!. Sign up to play a single player demo NOW or join somones galaxy!!','','Warfleet IS LIVE!!!. Sign Up to play a single player demo NOW or join a galaxy in the forums!!','','',1,30,0,0,'2003-05-19 09:44:06','2003-05-19 11:08:11'); INSERT INTO article VALUES (9,6,1,1,'new email warning option','','warfleet now has the option to auto-email you when you get attacked.','','Click on the [empire] screen and choose [settings] and then you can alter your email address as well as specifiy you want a warning (default = off)','','',0,38,1,0,'2003-05-19 16:00:43','2003-05-19 16:00:43'); INSERT INTO article VALUES (10,6,1,1,'New : email when finished','','There is a new feature in warfleet, now when you have built a building or a unit you can flag that construction to email you when its finished.','','Its a really handy feature that is usually \"off\" but now there is a checkbox in the [CONSTRUCT] tab on each planet that has an option to auto send an email to you when the construction is finished.
\r\n
\r\nHope it helps!','','',0,35,0,0,'2003-05-20 16:13:31','2003-05-20 16:13:51'); INSERT INTO article VALUES (15,4,1,1,'Exposing the Marauder Civ','','In the first of such articles, the game author tries to blow the lid off the MARAUDER civ.','','\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Marauders  
 Outlander(Marauder level 1)
 Brigand(Marauder level 2)
 Raider(Marauder level 3)
 Kraken(Marauder level 4)
\r\n
\r\n
\r\nThe Marauder civ has arguably the best army in the game. Their production is appropriate to their needs, and they are best used if you want to expand your empire without stopping. Their main advantage is that they attack really well in deep space, as well as being great in planet attack.
\r\n
\r\nThe compromise is that they need a biggish empire (with lots of planets) to sustain them, and they also are easy to counter attack.
\r\n
\r\nAnother disadvantage is that Marauders have no bullet catcher units. (ie low evasion/ high armour units ) -- remember any units with low evasion are \"more likely\" to get shot at, so low evasion units protect (soak up shots for) high evasion units in your army.
\r\n
\r\nA counter attack is tricky, but effective. In it, a defender gives up the planet under attack and then quickly re-invading it from space. Now the Marauders are fighting using their \"planet_defence\" ability rather than being allowed to battle with their units \"planet_attack\" score.
\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Clansmen
adcehaihsu
63576354011
metalscarbonsfuelticks
1201401404
Keltguard
adcehaihsu
67656445012
metalscarbonsfuelticks
2202001806
Wardancer
adcehaihsu
84877396024
metalscarbonsfuelticks
2602702708
War Track
adcehaihsu
55185565014
metalscarbonsfuelticks
1501001004
Kraken
adcehaihsu
95997688024
metalscarbonsfuelticks
44050048012
','','',0,14,0,0,'2003-06-04 14:57:44','2003-06-04 15:26:08'); INSERT INTO article VALUES (16,3,1,1,'Game was down','','The game is in disarray after I went on holiday right after a server attack.','','I am thinking of closing down and resetting the galaxies. A better solution would be to generate new ones and everyone can still keep the old ones for fun.
\r\n
\r\nPlease go to this post in the forum and say what you think

\r\nCheers Admin.\r\n

\r\nPS: in future, please email me if the site goes down. Very often the mailserver stays up when the website is down. Then I can do something about it usually (though this last time it would not have made any difference!)
','','',0,13,1,0,'2003-07-11 16:19:18','2003-07-11 16:19:18'); INSERT INTO article VALUES (17,3,1,1,'warfleet running well!','','There are hundreds of players all running seperate demo galaxies at the moment.','','I haven\'t made a post in ages so sorry about that :-) warfleet is doing really well since it went down 2 months ago. Although we lost the confidence of a lot of players the game seems to be in great shape actually
\r\n
\r\nEvery day warfleet receives more and more applications for demo games.
\r\n
\r\nPlayers should note that demo galaxies are single player, and you can organise multi-player galxies but posting intrest in the forums.
\r\n
\r\nLets keep this game going, lets keep it free.
\r\n
\r\ngl all.','','',0,11,0,0,'2003-08-07 09:19:21','2003-08-07 09:20:13'); INSERT INTO article VALUES (18,3,1,1,'warfleet needs a daddy','','warfleet needs a champion daddy to get galaxies going, keep the forum posted on and be an over all DADDY','','If you feel you could spare the time you can apply for the position.
\r\n
\r\nThe daddy will need:\r\n\r\n

\r\nThe successfull applicant will receive the email account: daddy@warfleet.com.
\r\n
\r\nEmail me at admin@warfleet.com to apply.','','',0,7,0,0,'2003-08-07 09:26:01','2003-08-07 09:28:18'); INSERT INTO article VALUES (19,6,1,1,'Galaxy List Added to Fleetwar','','New players wanting to join a galaxy can go to this link so they can email galaxy admins and ask to join their galaxies.','','There has been a lot of confusion about the role of a galaxy in warfleet. It is better to think of it as a descrete playing field, that groups players onto the same \"pitch\". A player in a different galaxy is impossible to reach, only players in your galaxy are accessable.
\r\n
\r\nAlthough I envisaged warfleet for between 20-50 players per galaxy, the upper limit of players is over 250 players, so there is no risk of a galaxy being too small.
\r\n
\r\nThe idea was also create league for round 4 where the best players played in a high-skill galaxy.','','',0,4,0,0,'2003-08-28 10:30:36','2003-08-28 13:36:15'); INSERT INTO article VALUES (20,3,1,1,'Exposing the Isolationist Civ','','In the next in the seies, the game author gives hints on the ISOLATIONIST civ..','','\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Isolationists
Settler(Isolationist level 1)
Founder(Isolationist level 2)
Bureaucrat(Isolationist level 3)
Preserve(Isolationist level 4)
\r\n
\r\n
\r\nAn Isolationist army has the defence in the game. They also get the Siege Tank - these steel behemoths have the highest defensive \"attack\" in the game. AND THEY HAVE THREE SHOTS PER TURN!!! Not to mention they are also VERY cheap.
\r\n
\r\nAs a civ their production is perhaps low, but their units are not expensive, considering their ability in combat.
\r\n
\r\nAs a Isolationist player you will be slightly short of cash, and numerically low on units, but you will able to hold planets easily, and retaliate in strength..
\r\n
\r\nIsolationist soldiers are well trained and capable, the compromise is that they find it hard to attack. But did I mention that siege tank yet?
\r\n
\r\nIsolationists are all effective endurance units. They sustain lots of damage well.
\r\n
\r\nAn effective tactic to attack them with is to land with a huge invasion force and wipe them out fast. Isolationists are extremely hard to wear down and can usually build units about as fast as they are die (allowing a planet to keep reinforced - without warfleet support - for a long time).
\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Guardsmen
adcehaihsu
35213433012
metalscarbonsfuelticks
2202001804
Iron Wolves
adcehaihsu
45734637013
metalscarbonsfuelticks
26032030012
Defender
adcehaihsu
69496565014
metalscarbonsfuelticks
36040044012
Avenger
adcehaihsu
88468668014
metalscarbonsfuelticks
7006506508
Siege Tank
adcehaihsu
28229485035
metalscarbonsfuelticks
1602002008
','','',0,1,0,0,'2003-08-28 14:13:14','2003-08-28 14:17:54'); -- -- Table structure for table 'category' -- CREATE TABLE category ( category_id int(11) NOT NULL default '0', en_name varchar(50) default NULL, no_name varchar(50) default NULL, image text, PRIMARY KEY (category_id) ) TYPE=MyISAM; -- -- Dumping data for table 'category' -- INSERT INTO category VALUES (3,'announcements','',''); INSERT INTO category VALUES (4,'general','',''); INSERT INTO category VALUES (5,'community','',''); INSERT INTO category VALUES (6,'developments','',''); -- -- Table structure for table 'login' -- CREATE TABLE login ( user_id int(11) NOT NULL default '0', username varchar(16) default NULL, name varchar(16) default NULL, email varchar(50) NOT NULL default '', phone varchar(50) NOT NULL default '', password varchar(50) NOT NULL default '', PRIMARY KEY (user_id) ) TYPE=MyISAM; -- -- Dumping data for table 'login' -- INSERT INTO login VALUES (1,'admin','admin','admin@warfleet.com','just drop me a line','6a64ff54fdfa49f113070916076ac684'); -- -- Table structure for table 'regular' -- CREATE TABLE regular ( regular_id int(11) NOT NULL default '0', en_title varchar(50) NOT NULL default '', no_title varchar(50) NOT NULL default '', en_text text NOT NULL, no_text text NOT NULL, image text NOT NULL, PRIMARY KEY (regular_id) ) TYPE=MyISAM; -- -- Dumping data for table 'regular' -- INSERT INTO regular VALUES (1,'newbie guide','','

First visit to WARFLEET??

\r\n\r\nYou might want to know:\r\n\r\n','',''); INSERT INTO regular VALUES (2,'in the beginning...','','

In the early years that followed his first walk into space, man did not see he was alone.

\r\n\r\n

Since that first feeble step into the night sky, mankind had had a yearning hope to reach across the blackness and find life on another world.

\r\n\r\n

But mankind could not find any other life out there. So fearful of being all there was, of being the the first and the last, he pushed deeper an deeper into the stars. All the while empty in his loneliness.

\r\n\r\n

The mathematicians were the first to say it: \"We are alone\". The scholars dumped wave after wave of statistical proof onto the table of public debate. But the status quo shouted the scientists down. Whole generations scorned the logic. Could there ever be final proof? Even one galaxy is enormous, surely in the billions of galaxies of the entire universe there had to be something! But when the number of eligible surveyed worlds exceeded the population of humankind itself, everyone began to agree.

\r\n\r\n

There were too many perfect worlds out there, too many vacant lots. There really was nothing special about earth – life had just happened there and it really should not have done. Billions of near identical planets had been found, and each in turn was nothing but dust and wind.

\r\n\r\n

So with a heavy heart they landed on sterile edens, they planted and they harvested. They were born, they raised their families, and they died. Under a countless number alien skies a countless number of stories were played out. And a silent melancholy drifted with mankind wherever he went.

\r\n\r\n

Equipping his outreach was his technology. Phage-genes would alter his DNA by the mere swallowing of a pill. His machines built themselves and lumbered as a silent army of slaves. He laboured, he built, but nothing really changed, and history chased him begging him to repeat himself.

\r\n\r\n

In his eagerness to race he pushed his brother down, and he cared not at all. So envy and greed went with him on his travels, and he was too busy to see. Things went on like they always had, and the same old play still spun itself out - again and again.

\r\n\r\n

But one day something happened, and everything changed.

\r\n\r\n

The spark of change occured on a minor outer rim planet. It too was nothing special. Yet it was the place where human civilisation – one that had endured for fifty thousand years - killed itself.

\r\n \r\n

It was on this simple planet that the first of the disappearances happened. One day, the citizens of high society were there, the next day the very rich were gone. Thousands just evaporated without trace overnight. The planet was paralised and tempoarily leaderless. And in the wake of the dissappearances many people had been murdered. The slain outnumbered the dissappeared.

\r\n\r\n

Even though the social and political vaccuum was quickly filled, it proved impossible to discover anything at all for sure. These people had, quite simply, gone.

\r\n\r\n

But soon isolated communities of the well off on neighbouring planets disappeared too. An influential politician here, a media mogul there, and with it an accompaniment of murders.

\r\n\r\n

This oddity rippled through the surrounding inhabited worlds. And ridiculous explanations started. Some said it was religious cult. Some said an attempt to start utopia. But the persistent rumour stood out, and it was terrifying.

\r\n\r\n

What he had made should never have been made, and the price man would pay would be in his own blood. For someone had cracked the code that ought not to be broken, they had unravelled an enigma that was not to be read. Man had become immortal. His genes had been tamed - and that was a discovery that could not be reversed.

\r\n\r\n

He had learned to cheat death forever and stay forever young. Instead of sharing this technology with all his brethren he demanded phenomenal sums and swore his fellow conspiritors to silence. The profits would come and such immortality was to be paid for. And those that would not pay or would not keep the secret were killed

\r\n\r\n

The war to end all wars started - it was over everlasting life - and it was the largest ever seen. Men fought machines and machines fought men; a million skies were painted the colour of blood as the underprivileged fought for the elixiar denied to them.

\r\n\r\n

Whole armies were bribbed with the gift of eternal youth, and they fought to defend those who held the key. A genocide borne of jealousy took hold of mankind, and nobody was spared.

\r\n\r\n

\"Once they had ruled it all, now there is nothing\"

\r\n\r\n

The great war happened over 10,000 years ago.

\r\n\r\n

After the war few people were left alive, and those that did survive were scattered thinly. Their technology was quickly forgotten in only a few generations man reverted into tribalism. He forgot his past, and turned his back on the stars. History became story and story became fable and fable was forgotten during those 10,000 years, on endless worlds, man slept.

\r\n\r\n

But right now the first cultures begin to climb to the stars again. Individual planets emerge slowly into space even as we speak. Contact is being re-established and some planets are no longer ignorant of each other.

\r\n\r\n

Maybe they will meet in peace. Maybe they will war.

','',''); INSERT INTO regular VALUES (3,'tour','','

Here are some screens.

\r\n
\r\n
\r\nStandard War Map Screen. This grid is only 12k with no plugins required.
\r\n
\r\n
\r\n
\r\nClicking on your Home World shows the context sensitive menus in action
\r\n
\r\n
\r\n
\r\n\r\nDrill down to see you Home world In more detail
\r\n
\r\n\r\n

Warfleet is the ONLY fully interactive 2D-map-in-browser based game that uses integrated menus and needs no plugins. It is free with no banners.

','',''); INSERT INTO regular VALUES (4,'faq','','

What is warfleet/fleetwar?

\r\n

\r\nWarfleet (game found at warfleet.com, with the portal site at fleetwar.com) is a Multi Player Online Game (MPOG) designed to let the user play on a 2D graphical gameplay area. The player can observe his colonies\r\nand expansions, and see his neighbours, go to war, harvest materials and build armies etc etc. This was hard to achieve using only a browser, but it has been done on IE6 and being developed for mozilla/netscape6 (it works with earlier versions of IE too but IE6 is best).
\r\n
\r\nThe clock in warfleet never stops. Even while you sleep you opponent may attack, so you defenses must be well prepared. The game never ends, and you must stay vigilant.\r\n

\r\n\r\n

Is it free?

\r\n

\r\nWarfleet is a completely and utterly free. You will never recieve any spam from us, nor will you ever get a popup or a banner. Nothing. This game is a labour of love for me and I want to keep it that way. Enjoy :)\r\n

\r\n\r\n

How come it is free?

\r\n

\r\nI am a proffesional IT developer making warfleet as a hobby so I pay everything myself and keep it up and\r\nrunning. Don\'t not worry about having to make a financial contribution or anything.\r\n

\r\n\r\n

Is this a Open Source Project?

\r\n

\r\nNo. Maybe one day. I would like to make this game available to as many people as possible, but I fear that\r\nsome central control might be lost. I am not against open source community projects, not one bit! I completely\r\nsupport the work that is done, its just this project will have (for the time being) a different angle.\r\n

\r\n\r\n

Is there a down side?

\r\n

\r\nNot really. However each map has a limited number of players at any one time. The game is written with map geography being essential. All players have a fixed number of immediate neighbours. Anyone quitting will leave a \"hole\" in the map that will effect gameplay balance for others. I have solved this problem by requiring players to be invited to play in a galaxy. Only invited players can join a galaxy.

\r\n \r\n

What is the game?

\r\n

\r\nYou play a forgotten human settlement on a lost planet re-emerging into the stars after ten thousand years of forced dark age.
\r\n
\r\nOther human settlements (equally forgotten) exist on other planets around you somewhere and they are controled by the other players. Some players will have already expanded into space before you started to play, so your civilsation will start as \"pioneers\" - pioneer troops have amazing defense, but cannot leave the home world. For this reason you will not be bashed at the start, but you have real neighbours in this game that do not ever move so try to keep things friendly. You will not want to fight everyone on every border.
\r\n
\r\nYou must choose from 4 completely different civs (There are 4 civilisations: Marauder, Isolationist, Capitalist, and Tyrant), each with 4 levels. Choose to become an ultra capitalist, or play as a Isolationist culture dogged in defence. Maybe you want your citizens on all out offensive as Marauders, or maybe you want to preside over them in the totalitrian regieme of a Tyrant. With completely different units for each culture and 4 levels to each civilisation you will have an amazing 17 different cultures you can play as, all with distinct advantages and disadvantages!\r\n

\r\n \r\n

Units

\r\n

\r\nThere are various Units specific to each civilisation, they are balanced tested with special abilities and unique profiles. Each civilisation has different units, they are built on planets and can be moved around the map by warfleets.\r\n

','',''); INSERT INTO regular VALUES (8,'what are galaxies?','','In a new and different system to last round, warfleet will revolve around galaxies. Every player can apply for status as a galaxy administrator. This is a special role that will allow that user to create one galaxy of his own - one at a time - so he/she can let his/her friends play in it.
\r\n
\r\nGalaxy administrators will have the option to create one galaxy at a time (for \"galaxy\" read: \"map\"). He/She will specify a limited number of players (from 10 to 20) and set the frequency of ticks and whether the galaxy has a \"tick freeze\" period during the normal daily 24 hour cycle.
\r\n
\r\nThe Galaxies will typically last from between 6 to 12 weeks (or until someone is declared the winner through conquest)
\r\n
\r\nOnce set the galaxy details cannot be altered. Galaxy players will be asked to register with the galaxy password.
\r\n
\r\nA players starting position will be determined by a archimedes spiral - with additional players joining the map at equidistant intervals along the curve.
\r\n
\r\nThe galaxy administrator may also be promoted to post articles on fleetwar.com, but they don\'t need to have any special role once the game is underway.
\r\n
\r\napply now','','images/galaxy.jpg');