]>
ruin.nu Git - ndwebbie.git/log
Michael Andreen [Sat, 7 Aug 2010 20:58:13 +0000 (22:58 +0200)]
Def page format changed
Michael Andreen [Sat, 7 Aug 2010 13:39:43 +0000 (15:39 +0200)]
Empty fleets aren't like normal fleets..
Michael Andreen [Fri, 6 Aug 2010 23:57:39 +0000 (01:57 +0200)]
Remove attack groups
Michael Andreen [Fri, 6 Aug 2010 23:56:25 +0000 (01:56 +0200)]
Update fleet parsing for r38, launch confirmation and fleet update is combined
Michael Andreen [Tue, 3 Aug 2010 19:16:18 +0000 (21:16 +0200)]
Rename the shipname attribute
Michael Andreen [Tue, 3 Aug 2010 18:30:52 +0000 (20:30 +0200)]
Merge updates from new catalyst.pl
Michael Andreen [Wed, 28 Jul 2010 19:46:34 +0000 (21:46 +0200)]
Only show unread link for logged in users
Michael Andreen [Wed, 28 Jul 2010 19:45:25 +0000 (21:45 +0200)]
Fix to use valid html
Michael Andreen [Sat, 3 Jul 2010 20:12:40 +0000 (22:12 +0200)]
Show value percentage for defenders on call page
Michael Andreen [Sun, 20 Jun 2010 14:42:39 +0000 (16:42 +0200)]
Show recevied and sent value on def leeches page
Michael Andreen [Wed, 2 Jun 2010 20:11:34 +0000 (22:11 +0200)]
Remove the old stats automatically when parsing
Michael Andreen [Tue, 30 Mar 2010 08:42:37 +0000 (10:42 +0200)]
Update to jquery 1.4
Michael Andreen [Sun, 21 Mar 2010 09:25:21 +0000 (09:25 +0000)]
Format for scans has changed to include commas in numbers
Michael Andreen [Sat, 6 Feb 2010 12:05:08 +0000 (13:05 +0100)]
Use escape string literal
Michael Andreen [Tue, 2 Feb 2010 16:06:50 +0000 (17:06 +0100)]
Fix in case planets happens to be 0
Michael Andreen [Fri, 22 Jan 2010 13:21:09 +0000 (14:21 +0100)]
Reorganized menu a bit, moving covop and bc menus a bit down
Michael Andreen [Fri, 22 Jan 2010 12:56:00 +0000 (13:56 +0100)]
Report incs through webbie
Michael Andreen [Wed, 13 Jan 2010 19:07:47 +0000 (20:07 +0100)]
Added the ndreport script and updated ndmail so it uses DB.pm
Michael Andreen [Sat, 26 Dec 2009 11:53:33 +0000 (12:53 +0100)]
Only require fleet paste for raids and launch confirmation
Michael Andreen [Wed, 4 Nov 2009 12:05:01 +0000 (13:05 +0100)]
Replace the retal cron job with a web page
Michael Andreen [Sat, 31 Oct 2009 08:38:05 +0000 (09:38 +0100)]
Use new url for stats
Michael Andreen [Mon, 19 Oct 2009 15:54:24 +0000 (17:54 +0200)]
Possible to mark threads unread from a specific post
Michael Andreen [Mon, 19 Oct 2009 15:26:23 +0000 (17:26 +0200)]
Possible to mark threads as unread
Michael Andreen [Sun, 4 Oct 2009 08:32:59 +0000 (10:32 +0200)]
Update retal raid script for the new infrastructure
Michael Andreen [Sun, 4 Oct 2009 08:28:44 +0000 (10:28 +0200)]
Make the tick range inclusive instead of exclusive
Michael Andreen [Tue, 22 Sep 2009 11:02:28 +0000 (13:02 +0200)]
Show an error if password wasn't changed
Michael Andreen [Sun, 20 Sep 2009 13:06:02 +0000 (15:06 +0200)]
Restructured launch confirmation and made it slightly more intelligent
Michael Andreen [Sat, 19 Sep 2009 11:27:37 +0000 (13:27 +0200)]
Remove a warning
Michael Andreen [Sun, 13 Sep 2009 20:26:05 +0000 (22:26 +0200)]
Let everyone access the calc redirects
Michael Andreen [Sun, 13 Sep 2009 16:04:26 +0000 (18:04 +0200)]
Also signal bots on launch confirmations
Michael Andreen [Sun, 13 Sep 2009 14:15:51 +0000 (16:15 +0200)]
Added calc link for fleets on member's main page
Michael Andreen [Fri, 11 Sep 2009 22:01:52 +0000 (00:01 +0200)]
Show pnick in user list
Michael Andreen [Wed, 9 Sep 2009 09:58:13 +0000 (11:58 +0200)]
Also show incoming missions from newsies
Michael Andreen [Sat, 5 Sep 2009 08:49:42 +0000 (10:49 +0200)]
List defenders using fake defend mission
Michael Andreen [Thu, 3 Sep 2009 09:53:43 +0000 (11:53 +0200)]
Fixed the parsing of incoming fleets on news scans
Michael Andreen [Thu, 3 Sep 2009 08:59:59 +0000 (10:59 +0200)]
Add the pid so we can use that for log messages
Michael Andreen [Thu, 3 Sep 2009 08:19:54 +0000 (10:19 +0200)]
Hide warning about uninitialized value
Michael Andreen [Thu, 3 Sep 2009 08:15:41 +0000 (10:15 +0200)]
Adding coords and tick to intel messages
Michael Andreen [Wed, 2 Sep 2009 16:26:48 +0000 (18:26 +0200)]
Use pid instead of planet
Michael Andreen [Mon, 31 Aug 2009 21:51:03 +0000 (23:51 +0200)]
Update calc links for new structure
Michael Andreen [Sat, 29 Aug 2009 11:21:53 +0000 (13:21 +0200)]
Use left join so the view can be used before a user has entered coords, also update to new structure
Michael Andreen [Fri, 28 Aug 2009 16:27:30 +0000 (18:27 +0200)]
Updated the cleanup script
Michael Andreen [Thu, 27 Aug 2009 19:14:57 +0000 (21:14 +0200)]
Remove unused variables
Michael Andreen [Thu, 27 Aug 2009 19:14:30 +0000 (21:14 +0200)]
Need to signal ndbot.pl instead of irssi
Michael Andreen [Wed, 26 Aug 2009 20:50:14 +0000 (22:50 +0200)]
Add links to previous and next galaxy
Michael Andreen [Wed, 26 Aug 2009 18:26:34 +0000 (20:26 +0200)]
Better error messages when inputing coords
Michael Andreen [Wed, 26 Aug 2009 13:23:58 +0000 (15:23 +0200)]
Support for planet tags
Michael Andreen [Tue, 25 Aug 2009 16:31:25 +0000 (18:31 +0200)]
Keep the favicon alias to keep ie happy
Michael Andreen [Tue, 25 Aug 2009 14:15:56 +0000 (16:15 +0200)]
Add support for attack group
Michael Andreen [Tue, 25 Aug 2009 08:01:10 +0000 (10:01 +0200)]
Fix for a bug 4906 in pg 8.4.0
Michael Andreen [Sat, 22 Aug 2009 17:51:40 +0000 (19:51 +0200)]
Replaced intelquery function with a view
Michael Andreen [Sat, 22 Aug 2009 14:04:59 +0000 (16:04 +0200)]
Don't need List::Util for min()
Michael Andreen [Sat, 22 Aug 2009 13:04:21 +0000 (15:04 +0200)]
Move favicon to static, so expire headers are set
Michael Andreen [Fri, 14 Aug 2009 23:19:31 +0000 (01:19 +0200)]
Change infrastructure for users, groups and channels
Dropping surrogate keys for groups, channels and channel flags. Instead
use the following changes.
* groups.flag changes name to groups.gid and is used as primary key.
Also attributes referencing this attribute with foreign keys are named
gid.
* channels.name changes name to channels.channel and is used as primary
key.
* channel_flags gets a flag attribute used as primary key.
Change username, pnick and hostaname to use the citext type, also use
normal unique constraints instead of functional indexes on lower().
Since ships_home has to be dropped and recreated, also change this view and
available_ships to use the new infrastructure.
Michael Andreen [Thu, 30 Jul 2009 15:27:10 +0000 (17:27 +0200)]
Change the calls and incomings structure
Rename the call id to call, and the incoming id to inc, so it is unique
within the database and thus can be used in natural join and join ..
using.
Remove covered and open variables and replace with a status. Different
statuses can be added to call_statuses table, but at the moment only
Open, Covered and Ignored is supported.
Michael Andreen [Sun, 12 Jul 2009 16:57:09 +0000 (18:57 +0200)]
List of members with their ranks
Michael Andreen [Tue, 28 Jul 2009 00:51:51 +0000 (02:51 +0200)]
Change database structure for planets and alliances + PG 8.4 changes
Change the id for planets from id to pid. Similar change for alliances where
id is changed to aid. This makes them unique in the database, which
makes it possible to replace several 'JOIN .. ON' with 'JOIN .. USING'
or 'NATURAL JOIN'.
Also, use the real alliance name as foreign key instead of the
surrogate key.
Some bigger queries are moved into views, mainly defense calls and
alliance resource estimation.
Together with this, use some new PostgreSQL 8.4 features.
* CTE and Window function for alliance resource estimate, so only the
top60 planets are picked.
* Use the new array_agg() instead of the custom array_accum()
Also, since 0000 is not a valid year anymore, raid.js is changed to use
0001 instead.
Michael Andreen [Sat, 25 Jul 2009 16:07:13 +0000 (18:07 +0200)]
Use the new defprio view for calls
Michael Andreen [Sat, 25 Jul 2009 15:49:14 +0000 (17:49 +0200)]
Add defprio to main and top members
Michael Andreen [Sat, 25 Jul 2009 13:58:07 +0000 (15:58 +0200)]
Added page to list def channels and alliance for planets
Michael Andreen [Wed, 22 Jul 2009 20:10:56 +0000 (22:10 +0200)]
Fix, make the planet scan parsing stricter
Michael Andreen [Wed, 15 Jul 2009 21:19:32 +0000 (23:19 +0200)]
Faster query for counting unread posts
Michael Andreen [Fri, 5 Jun 2009 19:42:00 +0000 (21:42 +0200)]
Convert messy pl/perl functions into cleaner pl/pgsql functions.
Michael Andreen [Sun, 12 Jul 2009 11:37:39 +0000 (13:37 +0200)]
Show when the gal was last raided
Michael Andreen [Wed, 8 Jul 2009 20:18:58 +0000 (22:18 +0200)]
Add a title attribute showing the target id
Michael Andreen [Wed, 8 Jul 2009 12:10:14 +0000 (14:10 +0200)]
Bugfix, so recall fleets work at eta 1
Michael Andreen [Mon, 6 Jul 2009 19:35:24 +0000 (21:35 +0200)]
Updated Catalyst::Devel files to 1.19
Michael Andreen [Thu, 2 Jul 2009 18:06:20 +0000 (20:06 +0200)]
Need to pick channel before sending
Michael Andreen [Thu, 2 Jul 2009 17:56:55 +0000 (19:56 +0200)]
Fix, for really tiny players
Michael Andreen [Mon, 29 Jun 2009 08:24:13 +0000 (10:24 +0200)]
Use filter instead of having to stash the function everywhere
Michael Andreen [Mon, 29 Jun 2009 08:02:21 +0000 (10:02 +0200)]
Add support for variable cap
Michael Andreen [Sun, 21 Jun 2009 20:43:49 +0000 (22:43 +0200)]
Move markitup to an include file and use for both board and thread
Michael Andreen [Wed, 22 Apr 2009 15:29:59 +0000 (17:29 +0200)]
Don't use hardcoded width
Michael Andreen [Sun, 5 Apr 2009 19:17:00 +0000 (21:17 +0200)]
Use markitup editor on forum
Michael Andreen [Sun, 5 Apr 2009 19:17:39 +0000 (21:17 +0200)]
Make size bbcode tag use percent instead of arbitrary scale
Michael Andreen [Sat, 13 Jun 2009 15:42:05 +0000 (17:42 +0200)]
Convert to catalyst 5.8
Michael Andreen [Sun, 7 Jun 2009 18:31:33 +0000 (20:31 +0200)]
Make the email field wider
Michael Andreen [Fri, 5 Jun 2009 21:30:21 +0000 (23:30 +0200)]
Let users change email address
Michael Andreen [Sun, 31 May 2009 21:39:38 +0000 (23:39 +0200)]
Infrastructure to handle sms relaying.
Michael Andreen [Tue, 26 May 2009 15:05:47 +0000 (17:05 +0200)]
Bugfix, spaces not appreciated in urls
Michael Andreen [Fri, 22 May 2009 18:46:16 +0000 (20:46 +0200)]
Make it possible to set calc through webbie
Michael Andreen [Mon, 18 May 2009 18:12:57 +0000 (20:12 +0200)]
Fixed typo
Michael Andreen [Mon, 4 May 2009 08:52:22 +0000 (10:52 +0200)]
Bugfix, accept empty gal name
Michael Andreen [Mon, 4 May 2009 08:51:51 +0000 (10:51 +0200)]
Updated clean script
Michael Andreen [Mon, 4 May 2009 08:44:23 +0000 (10:44 +0200)]
No real need to vacuum every tick, autovacuum works fine
Michael Andreen [Thu, 16 Apr 2009 19:04:35 +0000 (21:04 +0200)]
Set cache-control to public for static content
Michael Andreen [Thu, 26 Mar 2009 06:29:50 +0000 (07:29 +0100)]
Show nick when pasting coords
Michael Andreen [Sat, 21 Mar 2009 17:49:47 +0000 (18:49 +0100)]
Add race to text export of alliance listing
Michael Andreen [Thu, 19 Mar 2009 18:30:06 +0000 (19:30 +0100)]
Use top60 members to calculate estimated score
Michael Andreen [Fri, 13 Mar 2009 09:51:03 +0000 (10:51 +0100)]
Show members available ships on def calls
Michael Andreen [Thu, 12 Mar 2009 19:13:05 +0000 (20:13 +0100)]
Update to jquery 1.3.2
Michael Andreen [Sun, 25 Jan 2009 18:45:50 +0000 (19:45 +0100)]
Switch to Parse::BBCode
Michael Andreen [Thu, 12 Mar 2009 19:58:59 +0000 (20:58 +0100)]
Tweaked covop sorting and output
Michael Andreen [Thu, 12 Mar 2009 19:24:17 +0000 (20:24 +0100)]
Bigger text box for irc requests
Michael Andreen [Fri, 27 Feb 2009 20:38:18 +0000 (21:38 +0100)]
Show both total calls and defended calls for def leeches
Michael Andreen [Thu, 26 Feb 2009 21:15:54 +0000 (22:15 +0100)]
Bugfix, only use target-specific waves if it's higher than raid waves
Michael Andreen [Fri, 20 Feb 2009 16:43:26 +0000 (17:43 +0100)]
Bash limit for score is actually 60%
Michael Andreen [Fri, 20 Feb 2009 16:42:13 +0000 (17:42 +0100)]
Updated covop view to account for extra resources since scan and different sorting
Michael Andreen [Thu, 19 Feb 2009 22:17:42 +0000 (23:17 +0100)]
Show available ships
Michael Andreen [Wed, 18 Feb 2009 08:55:41 +0000 (09:55 +0100)]
List all fleets for defenders