chiark / gitweb /
ypp-sc-tools.db-live.git
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'

14 years agoImprove installation instructions re git etc.
Ian Jackson [Tue, 20 Oct 2009 18:29:48 +0000 (19:29 +0100)]
Improve installation instructions re git etc.

14 years agoFix sort arrows on data age table
Ian Jackson [Sun, 18 Oct 2009 18:31:15 +0000 (19:31 +0100)]
Fix sort arrows on data age table

14 years agoPrintable plan: Put generation date near the top with the input questions
Ian Jackson [Sun, 18 Oct 2009 17:37:47 +0000 (18:37 +0100)]
Printable plan: Put generation date near the top with the input questions

14 years agoUse whole page with for printable tables (htmldoc is a bit odd)
Ian Jackson [Sun, 18 Oct 2009 17:35:06 +0000 (18:35 +0100)]
Use whole page with for printable tables (htmldoc is a bit odd)

14 years agoprintable trading plan now done
Ian Jackson [Sun, 18 Oct 2009 17:25:21 +0000 (18:25 +0100)]
printable trading plan now done

14 years agopctb.ilk.org was just down
Ian Jackson [Sun, 18 Oct 2009 17:25:00 +0000 (18:25 +0100)]
pctb.ilk.org was just down

14 years agoprintable routetrades: 2-up versions; fix up tbody
Ian Jackson [Sun, 18 Oct 2009 17:24:41 +0000 (18:24 +0100)]
printable routetrades: 2-up versions; fix up tbody

14 years agoprintable trading plans
Ian Jackson [Sun, 18 Oct 2009 16:49:02 +0000 (17:49 +0100)]
printable trading plans

14 years agoroutetrade: include data age summary
Ian Jackson [Sun, 18 Oct 2009 15:29:33 +0000 (16:29 +0100)]
routetrade: include data age summary

14 years agoroutetrade: put trades table below voyage plan; include toc
Ian Jackson [Sun, 18 Oct 2009 14:47:45 +0000 (15:47 +0100)]
routetrade: put trades table below voyage plan; include toc

14 years agoFor printable trading plan: formatting runes for htmldoc
Ian Jackson [Fri, 9 Oct 2009 17:42:59 +0000 (18:42 +0100)]
For printable trading plan: formatting runes for htmldoc

14 years agoFor printable trading plan: example fetch rune
Ian Jackson [Fri, 9 Oct 2009 17:24:53 +0000 (18:24 +0100)]
For printable trading plan: example fetch rune

14 years agoroutesearch: support circular routes
Ian Jackson [Sat, 17 Oct 2009 19:27:08 +0000 (20:27 +0100)]
routesearch: support circular routes

14 years agoroutesearch: prettify the search page and results; sort arrows; etc.
Ian Jackson [Sat, 17 Oct 2009 17:39:47 +0000 (18:39 +0100)]
routesearch: prettify the search page and results; sort arrows; etc.

14 years agoroutesearch: nice routesearch
Ian Jackson [Sat, 17 Oct 2009 17:05:32 +0000 (18:05 +0100)]
routesearch: nice routesearch

14 years agoroutesearch: link to full voyage plans
Ian Jackson [Sat, 17 Oct 2009 17:05:01 +0000 (18:05 +0100)]
routesearch: link to full voyage plans

14 years agoroutesearch: another feature we should have
Ian Jackson [Sat, 17 Oct 2009 16:40:07 +0000 (17:40 +0100)]
routesearch: another feature we should have

14 years agoroutesearch: proper titles and pretty up the results
Ian Jackson [Sat, 17 Oct 2009 16:39:46 +0000 (17:39 +0100)]
routesearch: proper titles and pretty up the results

14 years agoroutesearch: check for failure of routesearch and report XCPU specially
Ian Jackson [Sat, 17 Oct 2009 16:28:30 +0000 (17:28 +0100)]
routesearch: check for failure of routesearch and report XCPU specially

14 years agoroutesearch: concurrency limit
Ian Jackson [Sat, 17 Oct 2009 16:19:24 +0000 (17:19 +0100)]
routesearch: concurrency limit

14 years agoroutesearch: show route distances
Ian Jackson [Sat, 17 Oct 2009 15:46:52 +0000 (16:46 +0100)]
routesearch: show route distances

14 years agoroutesearch: todo list items
Ian Jackson [Sat, 17 Oct 2009 15:42:46 +0000 (16:42 +0100)]
routesearch: todo list items

14 years agoroutesearch: make #define debug_flags work again, but still not faster
Ian Jackson [Sat, 17 Oct 2009 15:13:10 +0000 (16:13 +0100)]
routesearch: make #define debug_flags work again, but still not faster

14 years agoroutesearch: show 15 of each
Ian Jackson [Sat, 17 Oct 2009 15:00:15 +0000 (16:00 +0100)]
routesearch: show 15 of each

14 years agoroutesearch: fix up web performance parameterisation
Ian Jackson [Sat, 17 Oct 2009 14:49:55 +0000 (15:49 +0100)]
routesearch: fix up web performance parameterisation

14 years agoroutesearch: permit approxiation by disregarding trivial trades
Ian Jackson [Sat, 17 Oct 2009 14:25:42 +0000 (15:25 +0100)]
routesearch: permit approxiation by disregarding trivial trades

14 years agoroutesearch: use quick elim criterion separately per ap in bucketelim
Ian Jackson [Sat, 17 Oct 2009 12:03:29 +0000 (13:03 +0100)]
routesearch: use quick elim criterion separately per ap in bucketelim

14 years agoroutesearch: correct elim algorithms
Ian Jackson [Sat, 17 Oct 2009 11:55:13 +0000 (12:55 +0100)]
routesearch: correct elim algorithms

14 years agoroutesearch: improve arg parsing
Ian Jackson [Thu, 15 Oct 2009 20:10:41 +0000 (21:10 +0100)]
routesearch: improve arg parsing

14 years agoroutesearch: actually print number of routes requested, not one less
Ian Jackson [Thu, 15 Oct 2009 18:56:42 +0000 (19:56 +0100)]
routesearch: actually print number of routes requested, not one less

14 years agoroutesearch: rework some things, bugfixes
Ian Jackson [Thu, 15 Oct 2009 18:55:18 +0000 (19:55 +0100)]
routesearch: rework some things, bugfixes

Debugging: New value2 debug flag, new option -D1 for medium debug output, etc.
Rename PotentialResult to a Bucket of two OnePotentialResults (no intended
  change in behaviour for this)
Fix granularity full test to work correctly

14 years agoroutesearch: found another bug
Ian Jackson [Thu, 15 Oct 2009 18:07:50 +0000 (19:07 +0100)]
routesearch: found another bug

14 years agoroutesearch: found a bug
Ian Jackson [Wed, 14 Oct 2009 23:13:04 +0000 (00:13 +0100)]
routesearch: found a bug

14 years agoroutesearch: print results table
Ian Jackson [Wed, 14 Oct 2009 23:12:57 +0000 (00:12 +0100)]
routesearch: print results table

14 years agoroutesearch: parse output in query_routesearch
Ian Jackson [Wed, 14 Oct 2009 22:34:45 +0000 (23:34 +0100)]
routesearch: parse output in query_routesearch

14 years agoroutesearch: print highscore tables best first
Ian Jackson [Wed, 14 Oct 2009 20:38:00 +0000 (21:38 +0100)]
routesearch: print highscore tables best first

14 years agoroutesearch: abandon higher granuarities when tables become full
Ian Jackson [Wed, 14 Oct 2009 20:33:27 +0000 (21:33 +0100)]
routesearch: abandon higher granuarities when tables become full

14 years agoroutesearch: change granu to be higher for more specific (more granularity)
Ian Jackson [Wed, 14 Oct 2009 20:30:42 +0000 (21:30 +0100)]
routesearch: change granu to be higher for more specific (more granularity)