chiark / gitweb /
ypp-sc-tools.db-test.git
14 years agoTrading plan commodity names are links to commod prices
Ian Jackson [Sun, 22 Nov 2009 13:42:59 +0000 (13:42 +0000)]
Trading plan commodity names are links to commod prices

14 years agoSupport Specific Destination route search
Ian Jackson [Sun, 22 Nov 2009 13:31:29 +0000 (13:31 +0000)]
Support Specific Destination route search

14 years agoMinimum trade value feature
Ian Jackson [Sun, 22 Nov 2009 13:13:45 +0000 (13:13 +0000)]
Minimum trade value feature

14 years agoMerge branch 'stable-5.x' 6.1
Ian Jackson [Sat, 21 Nov 2009 17:06:06 +0000 (17:06 +0000)]
Merge branch 'stable-5.x'

14 years agoNew standing "Proficient" 5.8
Ian Jackson [Sat, 21 Nov 2009 16:49:55 +0000 (16:49 +0000)]
New standing "Proficient"

14 years agoMerge branch 'stable-5.x' 6.0
Ian Jackson [Sat, 21 Nov 2009 13:44:21 +0000 (13:44 +0000)]
Merge branch 'stable-5.x'

14 years agoMake shifted keys actually work. Modifier map contains codes, not syms 5.7
Ian Jackson [Wed, 18 Nov 2009 23:31:01 +0000 (23:31 +0000)]
Make shifted keys actually work.  Modifier map contains codes, not syms

14 years agoTry en_US.UTF-8 as well as en_GB.UTF-8 and en.UTF-8
Ian Jackson [Wed, 18 Nov 2009 21:36:40 +0000 (21:36 +0000)]
Try en_US.UTF-8 as well as en_GB.UTF-8 and en.UTF-8

14 years agoBugfixes and debugging for sending shifted keys etc.; now works
Ian Jackson [Wed, 18 Nov 2009 21:33:04 +0000 (21:33 +0000)]
Bugfixes and debugging for sending shifted keys etc.; now works

14 years agomake shifted keys work - untested, but compiles
Ian Jackson [Wed, 18 Nov 2009 21:10:07 +0000 (21:10 +0000)]
make shifted keys work - untested, but compiles

14 years agoMerge branch 'ceb'
Ian Jackson [Sun, 15 Nov 2009 18:33:55 +0000 (18:33 +0000)]
Merge branch 'ceb'

14 years agoAdded and edited commodity ordering.
ceb [Sun, 15 Nov 2009 18:27:55 +0000 (18:27 +0000)]
Added and edited commodity ordering.

14 years agoMerge branch 'stable-5.x'
Ian Jackson [Sat, 14 Nov 2009 17:29:52 +0000 (17:29 +0000)]
Merge branch 'stable-5.x'

14 years agoApprove client "jpctb greenend"
Ian Jackson [Sat, 14 Nov 2009 17:29:33 +0000 (17:29 +0000)]
Approve client "jpctb greenend"

14 years agoMerge branch 'stable-5.x'
Ian Jackson [Sat, 14 Nov 2009 17:16:48 +0000 (17:16 +0000)]
Merge branch 'stable-5.x'

14 years agoAllow computing and using dest stall poe limit
Ian Jackson [Sat, 14 Nov 2009 17:13:41 +0000 (17:13 +0000)]
Allow computing and using dest stall poe limit

14 years agoMake first datarow be pale rather than dark
Ian Jackson [Sat, 14 Nov 2009 16:27:05 +0000 (16:27 +0000)]
Make first datarow be pale rather than dark

14 years agoMore clearly explain [?] for location codes
Ian Jackson [Sat, 14 Nov 2009 16:00:10 +0000 (16:00 +0000)]
More clearly explain [?] for location codes

14 years agoCommodity location in deciles
Ian Jackson [Sat, 14 Nov 2009 15:55:59 +0000 (15:55 +0000)]
Commodity location in deciles

14 years agoMerge branch 'refs/remote/t.fa.mason' into stable-5.x 5.6
Ian Jackson [Sat, 14 Nov 2009 15:24:47 +0000 (15:24 +0000)]
Merge branch 'refs/remote/t.fa.mason' into stable-5.x

14 years agoCope with ship names with spaces in
Ian Jackson [Sat, 14 Nov 2009 15:21:07 +0000 (15:21 +0000)]
Cope with ship names with spaces in

14 years agoShow commod class in voyage plan too
Ian Jackson [Fri, 13 Nov 2009 12:50:07 +0000 (12:50 +0000)]
Show commod class in voyage plan too

14 years agoBetter caveats re posinclass
Ian Jackson [Thu, 12 Nov 2009 18:36:33 +0000 (18:36 +0000)]
Better caveats re posinclass

14 years agoPut definitions of TT etc. (for posinclass) in docs
Ian Jackson [Thu, 12 Nov 2009 18:34:38 +0000 (18:34 +0000)]
Put definitions of TT etc. (for posinclass) in docs

14 years agoNew way of showing position in list info
Ian Jackson [Thu, 12 Nov 2009 18:20:16 +0000 (18:20 +0000)]
New way of showing position in list info

14 years agoshow game UI location for commodities in trading plan; UI could be improved
Ian Jackson [Thu, 5 Nov 2009 17:14:46 +0000 (17:14 +0000)]
show game UI location for commodities in trading plan; UI could be improved

14 years agoMerge branch 'stable-5.x' into web
Ian Jackson [Thu, 5 Nov 2009 16:33:19 +0000 (16:33 +0000)]
Merge branch 'stable-5.x' into web

14 years agoMerge branch 'dict-test' into stable-5.x
Ian Jackson [Thu, 5 Nov 2009 16:31:21 +0000 (16:31 +0000)]
Merge branch 'dict-test' into stable-5.x

14 years agoDo only a quick referential integrity check on market data updates
Ian Jackson [Thu, 5 Nov 2009 16:27:42 +0000 (16:27 +0000)]
Do only a quick referential integrity check on market data updates

14 years agoRework of commodity classes and ordering
Ian Jackson [Thu, 5 Nov 2009 16:13:52 +0000 (16:13 +0000)]
Rework of commodity classes and ordering

 * Commodity classes in source-info.txt have _'s in not -'s, in
   case in the future we have classes which actually have _'s.
 * Table dumping functionality used by referential integrity check
   error reporter broken out into new functions dumptab_*
 * Complete rework of the commodclass and ordering schema
 * Multiple -D options on db-idempotent-populate increase trace level
 * Table recreation overhauled and improved:
    - temporary table now contains all columns of intended table
      (but with NOT NULL, PRIMARY KEY and UNIQUE constraints removed)
    - copy-back deferred until we have finished updating info;
      general info update works on the temporary table; this is
      so we can add a column which is NOT NULL
    - db-idempotent-update's index creation and first referential
      integrity check are deferred until after all new data has been
      incorporated
    - id compaction temporary table has a different name to the
      table recreation temporary table just in case of future
      accidents
    - table recreation copy-back dumps the entire data for the
      temporary table if the copy-back insert fails
    - all table creation in schema setup is done with table()
    - index creation is deferred until
 * Fix bugs in commodity class system

14 years agoCope with exponential notation in row output from glpsol
Ian Jackson [Thu, 5 Nov 2009 16:10:01 +0000 (16:10 +0000)]
Cope with exponential notation in row output from glpsol

14 years agoClock skew is only if timestamp is > now
Ian Jackson [Wed, 4 Nov 2009 11:19:17 +0000 (11:19 +0000)]
Clock skew is only if timestamp is > now

14 years agoBetter error messages from commod-update-receiver
Ian Jackson [Mon, 2 Nov 2009 18:15:02 +0000 (18:15 +0000)]
Better error messages from commod-update-receiver

14 years agoCan compact ids and remove obsolete commodities
Ian Jackson [Mon, 2 Nov 2009 17:55:38 +0000 (17:55 +0000)]
Can compact ids and remove obsolete commodities

14 years agoMidnight has some Lime dye; Cobalt has some Navy dye
Ian Jackson [Mon, 2 Nov 2009 17:51:16 +0000 (17:51 +0000)]
Midnight has some Lime dye; Cobalt has some Navy dye

14 years agoReady to write id compacter
Ian Jackson [Mon, 2 Nov 2009 16:50:42 +0000 (16:50 +0000)]
Ready to write id compacter

14 years agoDo referential integrity check on every incoming update
Ian Jackson [Mon, 2 Nov 2009 15:57:32 +0000 (15:57 +0000)]
Do referential integrity check on every incoming update

14 years agoAdd commodclasses even for un-ordval'd commods
Ian Jackson [Mon, 2 Nov 2009 15:56:31 +0000 (15:56 +0000)]
Add commodclasses even for un-ordval'd commods

14 years agoMove referential integrity check into CommodsDatabase
Ian Jackson [Mon, 2 Nov 2009 15:51:34 +0000 (15:51 +0000)]
Move referential integrity check into CommodsDatabase

14 years agoDo some referential integrity checking
Ian Jackson [Mon, 2 Nov 2009 15:41:52 +0000 (15:41 +0000)]
Do some referential integrity checking

14 years agoDatabase schema improvements
Ian Jackson [Mon, 2 Nov 2009 03:25:23 +0000 (03:25 +0000)]
Database schema improvements

* Do not create columns as AUTOINCREMENT (doesn't work well with
    INSERT OR IGNORE).  We still need to fix existing databases.

* Allow automatically adding columns to schema.

* Add various columns to commods, and commodclasses table, for ordering etc.

14 years agoSome fixes already done
Ian Jackson [Mon, 2 Nov 2009 03:23:49 +0000 (03:23 +0000)]
Some fixes already done

14 years agoMerge branch 'stable-5.x'
Ian Jackson [Sat, 31 Oct 2009 20:32:21 +0000 (20:32 +0000)]
Merge branch 'stable-5.x'

14 years agoFix name in copyright notices 5.5
Ian Jackson [Sat, 31 Oct 2009 20:28:42 +0000 (20:28 +0000)]
Fix name in copyright notices

14 years agoSpelling fixes etc.
Ian Jackson [Sat, 31 Oct 2009 20:27:03 +0000 (20:27 +0000)]
Spelling fixes etc.

14 years agoMinor layout fixes
Ian Jackson [Sat, 31 Oct 2009 20:20:32 +0000 (20:20 +0000)]
Minor layout fixes

14 years agoUseability enhancesments and spelling fixes
Ian Jackson [Sat, 31 Oct 2009 20:18:13 +0000 (20:18 +0000)]
Useability enhancesments and spelling fixes

14 years agoFix spelling error in intro
Ian Jackson [Sat, 31 Oct 2009 19:33:15 +0000 (19:33 +0000)]
Fix spelling error in intro

14 years agoMinor intro page fixes 5.4
Ian Jackson [Sat, 31 Oct 2009 19:31:17 +0000 (19:31 +0000)]
Minor intro page fixes

14 years agoFix ISO quote lossage to be HTML 3.2 compatible
Ian Jackson [Sat, 31 Oct 2009 19:28:46 +0000 (19:28 +0000)]
Fix ISO quote lossage to be HTML 3.2 compatible

14 years agoProperly quote various error messages
Ian Jackson [Sat, 31 Oct 2009 19:09:50 +0000 (19:09 +0000)]
Properly quote various error messages

14 years agoReorganise docs to include new howto material in intro etc.
Ian Jackson [Sat, 31 Oct 2009 18:33:41 +0000 (18:33 +0000)]
Reorganise docs to include new howto material in intro etc.

14 years agoWIP improve intro etc. - howto page from Naath
Ian Jackson [Sat, 31 Oct 2009 17:30:33 +0000 (17:30 +0000)]
WIP improve intro etc. - howto page from Naath

14 years agocommodity ordering: more comprehensive output
Ian Jackson [Sat, 31 Oct 2009 16:08:30 +0000 (16:08 +0000)]
commodity ordering: more comprehensive output

14 years agocommodity ordering: use @..+ in main entries too
Ian Jackson [Sat, 31 Oct 2009 16:08:11 +0000 (16:08 +0000)]
commodity ordering: use @..+ in main entries too

14 years agocommodity ordering: support @..+ in main entries too
Ian Jackson [Sat, 31 Oct 2009 16:07:59 +0000 (16:07 +0000)]
commodity ordering: support @..+ in main entries too

14 years agocommodity ordering: more data and fixed formatting
Ian Jackson [Sat, 31 Oct 2009 15:52:01 +0000 (15:52 +0000)]
commodity ordering: more data and fixed formatting

14 years agocommodity ordering: support @..+ syntax in % defs
Ian Jackson [Sat, 31 Oct 2009 15:51:45 +0000 (15:51 +0000)]
commodity ordering: support @..+ syntax in % defs

14 years agocommodity ordering: new "commodsinorder" mode
Ian Jackson [Sat, 31 Oct 2009 15:51:30 +0000 (15:51 +0000)]
commodity ordering: new "commodsinorder" mode

14 years agoCorrect link to test website source code 5.3
Ian Jackson [Sat, 31 Oct 2009 14:13:12 +0000 (14:13 +0000)]
Correct link to test website source code

14 years agoget_source=1: Actually print the header
Ian Jackson [Sat, 31 Oct 2009 14:07:37 +0000 (14:07 +0000)]
get_source=1: Actually print the header

14 years agoMerge branch 'refs/remote/t.fa.dict.test' into stable-5.x
Ian Jackson [Sat, 31 Oct 2009 13:59:58 +0000 (13:59 +0000)]
Merge branch 'refs/remote/t.fa.dict.test' into stable-5.x

14 years agoMake new "tree-info.txt" file not in revision control for locally approved clients...
Ian Jackson [Sat, 31 Oct 2009 13:58:55 +0000 (13:58 +0000)]
Make new "tree-info.txt" file not in revision control for locally approved clients etc.

14 years agoAllow downloading of database tree source code via dictup CGI scripts
Ian Jackson [Sat, 31 Oct 2009 13:52:15 +0000 (13:52 +0000)]
Allow downloading of database tree source code via dictup CGI scripts

14 years agoWIP commod ordering improvements
Ian Jackson [Sat, 31 Oct 2009 12:29:46 +0000 (12:29 +0000)]
WIP commod ordering improvements

14 years agoMore commodity orders in source-info.txt
Ian Jackson [Sat, 31 Oct 2009 12:09:26 +0000 (12:09 +0000)]
More commodity orders in source-info.txt

14 years agoUseful website UI suggestions from #chiark
Ian Jackson [Fri, 30 Oct 2009 14:55:36 +0000 (14:55 +0000)]
Useful website UI suggestions from #chiark

14 years agoWIP commodity sorting: syntactic improvements
Ian Jackson [Fri, 30 Oct 2009 14:17:59 +0000 (14:17 +0000)]
WIP commodity sorting: syntactic improvements

14 years agoTell emacs to edit source-info.txt in fundamental mode
Ian Jackson [Fri, 30 Oct 2009 14:14:11 +0000 (14:14 +0000)]
Tell emacs to edit source-info.txt in fundamental mode

14 years agoCope with commas in numerical fields from the scraper; deal properly with qty in... 5.2
Ian Jackson [Thu, 29 Oct 2009 20:07:32 +0000 (20:07 +0000)]
Cope with commas in numerical fields from the scraper; deal properly with qty in hold

14 years agoUnticking trades _does_ seem to work. Bogus bug report I think.
Ian Jackson [Thu, 29 Oct 2009 19:19:02 +0000 (19:19 +0000)]
Unticking trades _does_ seem to work.  Bogus bug report I think.

14 years agoMerge branch 'wip.commodclass'
Ian Jackson [Thu, 29 Oct 2009 19:12:45 +0000 (19:12 +0000)]
Merge branch 'wip.commodclass'

14 years agoMerge branch 'stable-3.x' 5.1
Ian Jackson [Thu, 29 Oct 2009 18:59:43 +0000 (18:59 +0000)]
Merge branch 'stable-3.x'

14 years agoMerge branch 'refs/remote/t.fa.mason'
Ian Jackson [Thu, 29 Oct 2009 18:57:44 +0000 (18:57 +0000)]
Merge branch 'refs/remote/t.fa.mason'

14 years agoWIP class and ordering data fixes
Ian Jackson [Thu, 29 Oct 2009 18:36:27 +0000 (18:36 +0000)]
WIP class and ordering data fixes

14 years agoWIP new class and ordering data
Ian Jackson [Thu, 29 Oct 2009 18:16:16 +0000 (18:16 +0000)]
WIP new class and ordering data

14 years agoImprove comments about extending source-info.txt
Ian Jackson [Thu, 29 Oct 2009 17:26:06 +0000 (17:26 +0000)]
Improve comments about extending source-info.txt

14 years agoAdd copyright licence notices to rs*.c (and appropriate notes in README and Makefile)
Ian Jackson [Thu, 29 Oct 2009 16:37:04 +0000 (16:37 +0000)]
Add copyright licence notices to rs*.c (and appropriate notes in README and Makefile)

14 years agoDelete obsolete notes file
Ian Jackson [Thu, 29 Oct 2009 16:36:43 +0000 (16:36 +0000)]
Delete obsolete notes file

14 years agoMake colourful pages pass W3C HTML and CSS validators
Ian Jackson [Thu, 29 Oct 2009 15:58:40 +0000 (15:58 +0000)]
Make colourful pages pass W3C HTML and CSS validators

14 years agoDitch sanity check triggered by insane subpixel antialiasing
Ian Jackson [Thu, 29 Oct 2009 00:20:43 +0000 (00:20 +0000)]
Ditch sanity check triggered by insane subpixel antialiasing

14 years agoWIP colouring in
Ian Jackson [Wed, 28 Oct 2009 22:20:14 +0000 (22:20 +0000)]
WIP colouring in

14 years agofound a bug
Ian Jackson [Wed, 28 Oct 2009 22:19:37 +0000 (22:19 +0000)]
found a bug

14 years agoFix reference to PCTB testing server
Ian Jackson [Wed, 28 Oct 2009 15:32:31 +0000 (15:32 +0000)]
Fix reference to PCTB testing server

14 years agoFix another case sensitivity error
Ian Jackson [Wed, 28 Oct 2009 15:32:20 +0000 (15:32 +0000)]
Fix another case sensitivity error

14 years agoFix capacity strings to be more case-insensitive
Ian Jackson [Tue, 27 Oct 2009 16:11:10 +0000 (16:11 +0000)]
Fix capacity strings to be more case-insensitive

14 years agoFix error message for ambiguous vessels in capacities
Ian Jackson [Tue, 27 Oct 2009 16:08:08 +0000 (16:08 +0000)]
Fix error message for ambiguous vessels in capacities

14 years agoquery_routesearch: Properly propagate %baseqf (so we don't reset ocean etc.)
Ian Jackson [Tue, 27 Oct 2009 01:31:42 +0000 (01:31 +0000)]
query_routesearch: Properly propagate %baseqf (so we don't reset ocean etc.)

14 years agoMerge branch 'master' into stable-5.x 5.0
Ian Jackson [Sun, 25 Oct 2009 12:24:52 +0000 (12:24 +0000)]
Merge branch 'master' into stable-5.x

14 years agoroutetrade: Fix suppresed trades: suppress by removing from @subflows
Ian Jackson [Sun, 25 Oct 2009 12:19:55 +0000 (12:19 +0000)]
routetrade: Fix suppresed trades: suppress by removing from @subflows

14 years agoroutetrade: WIP fix unticked trades
Ian Jackson [Sun, 25 Oct 2009 12:07:38 +0000 (12:07 +0000)]
routetrade: WIP fix unticked trades

14 years agoypp-chart-memshow: new ypp-sc-tools script
Ian Jackson [Sat, 24 Oct 2009 13:48:27 +0000 (14:48 +0100)]
ypp-chart-memshow: new ypp-sc-tools script

14 years agoFix up 2abd3537 to rename connect_core everywhere
Ian Jackson [Wed, 21 Oct 2009 23:22:20 +0000 (00:22 +0100)]
Fix up 2abd3537 to rename connect_core everywhere

14 years agoNotice if $expected_total_profit parsing failed; don't break if it is an integer
Ian Jackson [Wed, 21 Oct 2009 23:10:33 +0000 (00:10 +0100)]
Notice if $expected_total_profit parsing failed; don't break if it is an integer

14 years agoIf routetrade query is arbitrage search only, mention this fact
Ian Jackson [Wed, 21 Oct 2009 23:05:18 +0000 (00:05 +0100)]
If routetrade query is arbitrage search only, mention this fact

14 years agoMerge branch 'stable-3.x'
Ian Jackson [Wed, 21 Oct 2009 22:48:36 +0000 (23:48 +0100)]
Merge branch 'stable-3.x'

Conflicts:

yarrg/TODO

14 years agocheck for unexpected mouse pointer motion 4.3
Ian Jackson [Wed, 21 Oct 2009 22:46:03 +0000 (23:46 +0100)]
check for unexpected mouse pointer motion

14 years agoUnclear UI bug report
Ian Jackson [Tue, 20 Oct 2009 19:51:19 +0000 (20:51 +0100)]
Unclear UI bug report

14 years agopager: cap screenshot interval at 1s to avoid problems at volatile markets
Ian Jackson [Tue, 20 Oct 2009 18:36:41 +0000 (19:36 +0100)]
pager: cap screenshot interval at 1s to avoid problems at volatile markets

14 years agoMerge branch 'stable-3.x'
Ian Jackson [Tue, 20 Oct 2009 18:32:15 +0000 (19:32 +0100)]
Merge branch 'stable-3.x'