4e4c50dbbc6e94bb294d274118554ecc90e5f75b Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/04f5b4fb7de37a4dbf8fc48fd5d34da8e272f8dd 04f5b4fb7de37a4dbf8fc48fd5d34da8e272f8dd

2009-07-20T17:46:26-07:00

* Initial support for PostgreSQL. * SQL->replace now takes another argument listing the columns to match the replace on. * SQL->latest now requires a table name to be passed. * Fixed errors triggered by the installer failing. 10521afe699bdc51d80a5ab19dfdf62636214398 Alex Suraci i.am@toogeneric.com 453243904d2503903caf33e8daaa5830f279b24d Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/6ed13932f208cec9e16dae23268538014db23ac8 6ed13932f208cec9e16dae23268538014db23ac8

2009-06-28T08:12:02-07:00

* Renovated Route->url to accept a controller to handle the URL. * Tweaked QueryBuilder::build_order to use comma_sep. * Updated version number to 2.0. 8e244cce8a8ccbc2de4716f6dcb3cca31a17487d Alex Suraci i.am@toogeneric.com 1133ef7fa23cb9dca1d42dc23bf1ffc4f8a8757d Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/ab65143b9391f1624e41f657bc7b455b6a2d6dc6 ab65143b9391f1624e41f657bc7b455b6a2d6dc6

2009-02-18T11:21:57-08:00

Repeated previous fix for REPLACE INTO queries. 7647dddb399d77bfe1b66c7a649e657008247646 Alex Suraci i.am@toogeneric.com 6fb815554753ba90a9e6358c3a3b7705d0d067c7 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/1133ef7fa23cb9dca1d42dc23bf1ffc4f8a8757d 1133ef7fa23cb9dca1d42dc23bf1ffc4f8a8757d

2009-02-18T11:11:57-08:00

Fixed insert strings being affected by the prefix replacer (and any other filtering). e0982e3d2bb477b5a32fffc2383fd28035fbca92 Alex Suraci i.am@toogeneric.com e929cffc76b0d95f1cc477778bbadff7d82fe153 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/6fb815554753ba90a9e6358c3a3b7705d0d067c7 6fb815554753ba90a9e6358c3a3b7705d0d067c7

2009-02-18T07:07:52-08:00

Fixed attribute matching with periods in the match name with PDO/SQLite. 344a63a772cb302a29f4f32bbf907b3cce58f39f Alex Suraci i.am@toogeneric.com 7e8768b454fb3d5cf8cda1813524c80002b3584c Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/ad0af46a4d2b7b5ec8a63f3ac2962de14b6a0339 ad0af46a4d2b7b5ec8a63f3ac2962de14b6a0339

2008-11-19T19:29:37-08:00

* Fixed model object overloading trigger check glitch. * Added a fix for empty SimpleXML objects as a result of empty strings. * Added another preprocessing fix for WordPress' ass-backwards export format. * Fixed wordpress export generator validity check. * Comments module no longer uses left joins, in favor of cached dynamic attribute fetching. bf5026cc9ea2e469fa21fb24eb39639cfaf7acab Alex Suraci i.am@toogeneric.com bd73ccd06ceaee6c3f4a5ecf00e4f027b19a26c2 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/7266ecf9e8350a23eb169ace2817abfce6713520 7266ecf9e8350a23eb169ace2817abfce6713520

2008-11-15T11:46:38-08:00

* If the path given to upload() does not exist, it will be created. * Logic tweaks in Page->update() * Updated the unit tester * Tweaked post viewing to place an empty <li> in the comments <ol> so we can still have AJAX with valid XHTML strict. * Names can be quoted with backticks to bypass the auto-table-prefixer. ab16c22e6b27b61470edf38e6f6542af7984d9e7 Alex Suraci i.am@toogeneric.com 20855c0694e6b79e6ee9f8d87dc343fd9ca8c58f Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/458b57ca0fe5c0194d73cd0373a8e5799019621a 458b57ca0fe5c0194d73cd0373a8e5799019621a

2008-10-29T18:54:34-07:00

SQL escaping fixes. [#254 state:resolved] 06df08ddbd7c28eaa9bd2af8c1500720e109a446 Alex Suraci i.am@toogeneric.com 19e7f177f1295f6bbfffdd51a1dc026cef7dd0d4 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/9c685c8b2cb9013203907ed3fbde81ebca19bd27 9c685c8b2cb9013203907ed3fbde81ebca19bd27

2008-10-27T19:57:02-07:00

Added some basic protection against troublesome column names. e5ece3dcf184763c358a71361792939b62168ff4 Alex Suraci i.am@toogeneric.com ed7cb896a843c9fed543fdcc4963d6b562b1f269 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/171ba00bbf6c0ec0e1376766638dd76ce05836ac 171ba00bbf6c0ec0e1376766638dd76ce05836ac

2008-10-26T10:27:02-07:00

When building update values, say " = ''", not " IS NULL" when the value is null. ad7551789f5b2746c6975334c4a0c205eb3d80da Alex Suraci i.am@toogeneric.com 4bcf918517f2b8c3624929018c8e41656f201eba Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/1242d5f215f1f4e6304d19feb30d8fd5cf559d6a 1242d5f215f1f4e6304d19feb30d8fd5cf559d6a

2008-10-25T20:54:43-07:00

Documentation, l10n, and triggers list updates. d19e8abfdfd8468d15546cd7ed403035ae9d2306 Alex Suraci i.am@toogeneric.com efb81da283710c4dedec5727c7fbac209161620e Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/9f2d5a2b3a1cdc57dd549f7d3432cc728106dc51 9f2d5a2b3a1cdc57dd549f7d3432cc728106dc51

2008-10-24T16:16:28-07:00

* Tweaked oneof to be a bit smarter with types. * Added "like all", which uses "AND" instead of "OR". e3e1871deb9c2d6827c135a42fcfaa420ec82747 Alex Suraci i.am@toogeneric.com 9f55a9418f16192ad53cb87298c31f208d38f098 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/f9b55483e31c0d9f5091232ee3507306d77be78c f9b55483e31c0d9f5091232ee3507306d77be78c

2008-10-24T15:21:18-07:00

Added viewing multiple tags, as well as a list_notate function and allowing 'foo like' => array('%foo%', '%bar') (and 'foo not like' => array) in the SQL interface. [#250 state:resolved] 4ba7b67dd7a526ffaa2bbd6bc9ad575a9029f5c5 Alex Suraci i.am@toogeneric.com deab1e4bba0907cdb9aa23ba3af4353d89d4077e Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/41f9a2f35d57c3b4e328ce5770e78fad3e1fad60 41f9a2f35d57c3b4e328ce5770e78fad3e1fad60

2008-10-19T08:17:06-07:00

Model cleanups. * The old object is now the second the argument for the update_* functions (options is moved to the third arg for post updating). * The current object is updated with the new attributes. * Code organization. ffeada86688449174133c93827829926cac2e2fa Alex Suraci i.am@toogeneric.com 4de55f73319bf0aa89958ed6a496b751f0b1721d Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/62817e5fbb30fa8d5336dc91cbf57a17a8f584b8 62817e5fbb30fa8d5336dc91cbf57a17a8f584b8

2008-10-19T06:28:03-07:00

* Fixed SQL UPDATE queries not being logged. * Fixed improper escaping of parameter backslashes. e8fe73038fd8308734bc9e3728ad2665a0e56930 Alex Suraci i.am@toogeneric.com 41a1020e0eef774114039497a2a5c1178ab02a70 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/e083f221522de0bfb754180e31df756fc5e491a4 e083f221522de0bfb754180e31df756fc5e491a4

2008-10-05T11:27:07-07:00

* QueryBuilder and SQL escaping fixes/cleanups/reorganizations. * If the Visitor's group cannot be found, use the default group. * If GD is not installed, thumb.php will exit with a message. 6c4228840233a53c99825b3b1b521a21571a0811 Alex Suraci i.am@toogeneric.com b498a546d2eaba62b15b3e3fef8e88ca6deb31e3 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/3ca898d565866e590f4dcf8f810c2b42c98f1c3c 3ca898d565866e590f4dcf8f810c2b42c98f1c3c

2008-09-28T20:44:22-07:00

Tabs to 4-width spaces. 43c54960e68fdff6e22809c7505b9ea8f79a5504 Alex Suraci i.am@toogeneric.com 8aabb1d31cbc81adb52075ce50332501f0446184 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/1566dd3fc416b03fa43568c84ec26d7fdc310c9f 1566dd3fc416b03fa43568c84ec26d7fdc310c9f

2008-09-20T09:35:23-07:00

Prettified SQL queries some more. c763067f737ada9f811d416bc46fe2425557554b Alex Suraci i.am@toogeneric.com 9af8a92219e3a58d762df7786d5def49b2be249d Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/719e395b5e881d83725f0d574492c5ce7d10b6d3 719e395b5e881d83725f0d574492c5ce7d10b6d3

2008-09-20T09:21:11-07:00

* Improved model caching method. * Grab the visitor's group with a LEFT JOIN instead of its own query. 074f437bee87fd797385f3efa1cc39497d475231 Alex Suraci i.am@toogeneric.com 016e507d0adf9394fc6b99a4e75db307313823ea Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/96f7dbd96f32ae75816738294296d2a4ded081e4 96f7dbd96f32ae75816738294296d2a4ded081e4

2008-09-16T21:52:00-07:00

Documentation tweaks and cleanups. 045a10833e8bb22d14d0fda490858f8db98c74b5 Alex Suraci i.am@toogeneric.com cdbeb6c994953f6027dc95c63110fb12a854c3e4 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/e98b9a38671635ebf735fad1c0644a4def546430 e98b9a38671635ebf735fad1c0644a4def546430

2008-09-16T16:49:40-07:00

* Added a visual debugger. * Cache Post->next()/prev(). * Increased the spread size of the tag cloud. * Minor SQL generating tweaks. 9f647ddfbf59b640879056abfa965099a67d6121 Alex Suraci i.am@toogeneric.com 2d22607d3a7cddeb6b6210e5b23a1744560acd37 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/bbe6163e6aa457e648b52a152a3cca83deae4ede bbe6163e6aa457e648b52a152a3cca83deae4ede

2008-09-13T23:22:08-07:00

* Controller refactoring. * Most everything is handled directly by the Main Controller now, as it should be™. * index.php switch statement is removed. * If a route was successfully displayed, set Route->success to `true`. * If anything gets displayed from MainController, set MainController->displayed to `true`. * Fixed `Route->action` being set to null at the end of Route->init(). * There was the explicit one and the accidental one at the beginning. * Fixed some accidental GhettoGrammar. 7da2942aaa451d6bea4f44caf97786bc9d123661 Alex Suraci i.am@toogeneric.com ac351f808073f35406d98143b38a981a54c83d69 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/c71daaba73c6538dc94d64108eadc3f47c6f7b5f c71daaba73c6538dc94d64108eadc3f47c6f7b5f

2008-09-03T17:47:32-07:00

2008-09-03T17:46:48-07:00

* Fixed the installer. [#204 state:resolved] * Added docs for QueryBuilder::build_conditions(). * Fixed SQL->replace() not working like SQL->insert() does with build_conditions(). 8b8fec67f457899ed39365e4695a8a3d2130d612 Alex Suraci i.am@toogeneric.com 12a1e446d0674cb95c26b4a44296d94684a4ed15 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/78eaa182ebd2761dd7dfd29aa524c3fe8a6b1911 78eaa182ebd2761dd7dfd29aa524c3fe8a6b1911

2008-09-02T19:26:21-07:00

* Fixed SQL query values with 0 length * You can now use custom operators with SQL interfacing in the form of array("foo >" => $bar); 320600d0d971b3e552efd0ba6f73668f62645f5e Alex Suraci i.am@toogeneric.com af7fc7e2ca49b0d56dfb023d164259831e87d0c4 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/303cba317d4ec3af39c8b45a66a761da0369bb4b 303cba317d4ec3af39c8b45a66a761da0369bb4b

2008-09-02T14:28:18-07:00

More SQL interfacing touch-ups. 1d2503685eb52649d4f290dfb7bbeed3a8d88afd Alex Suraci i.am@toogeneric.com 6ba4d25d3cd5486c520df83dfe3d5bdfbeb60a14 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/51ec5454e0d661b5bf1083689d4da1736f7ddc6b 51ec5454e0d661b5bf1083689d4da1736f7ddc6b

2008-09-01T16:14:48-07:00

* Fixed unclickable areas when both disabling/enabling a Feather, or if conflicts fail to draw. * Simplified the begin/end points on conflict/dependency lines to just use full circles. * Fixed labels with input fields in them being improperly aligned * Fixed insert/replace queries * Fixed redirecting to a draft post after you create it. a60d6b1e0baa89bc1d0f035fb7b05e4c97338414 Alex Suraci i.am@toogeneric.com 79592f602d99c0782f4cdbcc834728df075026cc Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/0a83e618df461db5a1dc6aedf397251ee67fcbf7 0a83e618df461db5a1dc6aedf397251ee67fcbf7

2008-09-01T11:22:48-07:00

* Prettified some QueryBuilder code. * Store user comments in their session. [#199 state:resolved] 88fe6c2ba8c44a2998291b924865107f3573566d Alex Suraci i.am@toogeneric.com 0ab14775db15b0805c1f2192b79edcc6247ad196 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/5563f88b0bc792af119d65e58943ccc949705f19 5563f88b0bc792af119d65e58943ccc949705f19

2008-09-01T10:39:40-07:00

* More SQL interfacing improvements * Use condition building for update/insert queries * $tables arg is now optional in QueryBuilder::build_conditions 41b198d7cce6475afd6ff99065cd5555a2b527ed Alex Suraci i.am@toogeneric.com 836e49726831a263f49b0cab82ad1a9ba2ca42e9 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/a7f35ec512c10340723dacfb6f141c0f42a42749 a7f35ec512c10340723dacfb6f141c0f42a42749

2008-09-01T08:38:00-07:00

* Vastly improved SQL interfacing. [#200 state:resolved] * Moved `escape` function from Query class to SQL class. Also, it now auto-quotes the value like PDO does. 6d188879ca0b09c16c21c986427bc96ed1e4acd1 Alex Suraci i.am@toogeneric.com 4e3143b9f0a2f79b46f8610c0b76a55b25c1291f Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/0cc451cb80d46308c6e9c1b89fe03287f84c68e4 0cc451cb80d46308c6e9c1b89fe03287f84c68e4

2008-08-30T09:49:31-07:00

* Removed feather viewing. * Tweaked the tablefy function to do some of the logic in the regexp. 5f9fb8832d6f5b0f6e0c2df19357f737b1162c67 Alex Suraci i.am@toogeneric.com 2fdb1c6d7d7857473a9a983074a9a4aa80b12aef Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/6402f05fe81108f9c140124e2612e8635fd87cc8 6402f05fe81108f9c140124e2612e8635fd87cc8

2008-08-19T19:10:44-07:00

Tablefy and Video feather fixes f1cc30b6db775c53e7fed9724ed78b41ed7352bf Alex Suraci i.am@toogeneric.com da79e4332cc16b55d1eef89641f558d5cbd2f168 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/6c6042bd0cbd1173baab72f0bea5e2ad0245d2b5 6c6042bd0cbd1173baab72f0bea5e2ad0245d2b5

2008-07-29T11:46:46-07:00

Fixed foo.* not being tablefied fdb4a5f63b1b37ffc90c1c8df9099b862bb1cb57 Alex Suraci i.am@toogeneric.com f77a49643c05263ca6578906f8ffff22db9a1d26 Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/da8f7f91844fa0052e80ac025a11744d7d6cfc12 da8f7f91844fa0052e80ac025a11744d7d6cfc12

2008-07-29T10:57:25-07:00

Tweaked the 'first' filter in Twig. e88ce6474439c5c54cb6cecaa054aa86c747f501 Alex Suraci i.am@toogeneric.com d45d50744eabb6776cb6ce31fe077be0d11135ed Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/e3988e4b6cc94388f820094394c1e9c9a27c3d25 e3988e4b6cc94388f820094394c1e9c9a27c3d25

2008-07-28T23:49:50-07:00

* "ORDER BY" statements should be tablefied * Various SQLite fixes dc486b1a264d72749263e0f146c344d12a2aa60b Alex Suraci i.am@toogeneric.com 2883f9b7103bbda2ac47794af9d013a5f6ce0d8d Alex Suraci i.am@toogeneric.com http://github.com/vito/chyrp/commit/ac632a0fb0d98483863429eafaaae86174563467 ac632a0fb0d98483863429eafaaae86174563467

2008-07-26T19:35:06-07:00

* Increased the awesomeness and flexibility of the RSS Aggregator module by approximately 1298%. * Slight fix for the tablefy function in QueryBuilder. 1c45f3d7665133d5d57a1ac944c2c7cf1ed958bb Alex Suraci i.am@toogeneric.com