If you frequent my site, you'll notice that I
update it and the projects I create quite a bit. Due to size and
scope, updates are scattered all around. This listing serves as a
quick reference for those who only want to look at the newest changes.
By default, the latest 15 updates are listed below (with links to the
changed or added content). If you are looking for a specific area of the
site, use the search field above or use the site nav links in the top
right and bottom right of the page. Area specific links are typically on the
left side
[ /sean/code/cats ] :: (cats.php) v4.17-claude. Ran cats.php thru Claude Code and it addressed a number of issues that are outlined in the script itself. New file is posted in here or by clicking on the source icon in the Cats area.
[
edit
]
[ /sean/code/cats ] :: (cats.php) Multiple search terms were being treated as AND conditions without '+' operator. Non-operator prefaced term searches are now OR based. 'foo bar' (foo OR bar) vs 'foo +bar (foo AND bar)
[
edit
]
[ /sean/code/cats ] :: (update.php, files.php, caption.php) These plugins have been updated. Use the Source link in the navbar to download the new plugins. No site modifications are needed, simply replace your existing plugins with these.
[
edit
]
[ /sean/code/cats ] :: (cats.php) Rewrite of search_and_sort() function to be more robust and handle multiple fields (primary, secondary, ...) when defining [order].
[
edit
]
[ /sean/code/cats/files/plugins ] :: (csv.php) Created a CSV file importer. Plugin can be viewed in the plugins folder link. Here is a raw output sample page pulling in the latest '/sean/datasets/YoY_pct_10y.csv' file (~3000 records). Here is a link to the same file showing only those tickers with a positive gains Streak >=5 years sorted by Streak,AVG% (overall 10y) in desc order (~100 records).
[
edit
]
[ /sean/code/cats/files/plugins ] :: (update.php) Saw a strange reaction where the first record in the data array was omitting the 'value-added' cols on the first record causing the returned array to be missing its complete header row. This resulted in search-and-replace functions skipping those added values during token replacement. I've modified it so all array rows are built at array construction time versus being appended later. This solved the issue on my end. Simply replace your update.php with the newer file. No other changes are needed.
[
edit
]
[ /sean/code/cats ] :: [where] is now a "server side" protected parameter (if user tries to overwrite or NULL the parameter via the query string, it is ignored). This allows webmasters to filter recordsets prior to passing [DATA] to the user to view and start doing searches on. Ultimately, the best place to do filtering is in a plugin but this gives a more flexible option for when it's needed instead of creating multiple plugins that require redundant coding.
[
edit
]
[ /sean/code/cats ] :: RECORD2,3,4 parameters are now depreciated and no longer supported. Never used these and really can't see a situation where multiple record templates would be needed. Site documentation updated.
[
edit
]
[ /sean/code/cats ] :: Added sort on CATS [search] operators, gives the following order of operation: - (not include), + (must include), none (or), ^ (case sensitive or), " (phrase or) which allows me to halt additional processing on multi term search strings if NOT or AND conditions are not met first (OR conditions skipped).
[
edit
]
[ /sean/code/cats ] :: Recordnum counter was not respecting actual record number when displayed as part of a [limit] set, was resetting to '1' on page 2, 3, etc. Adding $aRecordset['start'] to $iRecord fixed this.
[
edit
]
[ /sean/code/cats ] :: [in] parameter now handles user defined field(s) selection for [search] and provides more robust filtering options using conditional operators (+/-/"/^). Going forward, the following SQL parameters are deprecated and no longer used with CATS directly (can still be used by plugins): [select], [from], [group], [sql].
[
edit
]
[ /sean/code/cats ] :: Optimization; [search] bails out when conditions do not match user requested terms. This will greatly decrease search times on large data sets. Added '^' for defining a case sensitive search term as all other searches case insensitive (fuzzy). Version rev 4.12.
[
edit
]
[ /sean/code/cats ] :: Added code to use $aScript['subdomain'] to create cyclical link between 'local.[domainname]' and 'www.[domainname]' to allow for 1 click switching between development server and live server
[
edit
]
