56ddd78b385ce8756e8398d6a2000603be34cb4a Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/c7a6cafafda7466de2598ba5a3ca5d07c0795711 c7a6cafafda7466de2598ba5a3ca5d07c0795711

2003-07-21T08:39:36-07:00

Straightened out FOREIGN KEYs. The old schema as written had serious problems creating its foreign keys, which often stymied the very installation of a slashsite. Now all the FOREIGN KEYs are created with ALTER TABLEs *after* all tables are created. And MySQL has some problems in that FOREIGN KEYs have to be precisely the same as the columns they reference, which creates problems when pointing to a foreign primary key that's AUTO_INCREMENT -- so the keys that cause problems are commented out until I can figure out how best to handle this. This is a big complex change and I may have missed something -- in any case it shouldn't affect already established sites, this only affects install. Added querylog. This checks for the presence of a file at /usr/local/slash/querylog every minute or so, and if present, starts logging ALL SQL queries into the table 'querylog'. Should be very useful for debugging but be careful using it on a running production site! (Which of course is where it's most useful!) To maximize querylog utility, many sqlDo()s were converted into their respective sqlInsert(), sqlUpdate(), sqlDelete(), etc. Note that some shenanigans had to be done with LAST_INSERT_ID for querylog; I believe all the bugs there are squashed. Added "rand" vmethod for scalars for templates, e.g. [% x=1000; x.rand %] 7bdf23866734d9f32bd32d7792072f03750e92f5 Jamie McCarthy jamie@mccarthy.vg 3a594a5cf60f788ab1db8170972fd580079b56c0 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/56ddd78b385ce8756e8398d6a2000603be34cb4a 56ddd78b385ce8756e8398d6a2000603be34cb4a

2003-07-21T08:22:44-07:00

I'm a Slash author too! 34740f0b041201aef3cb314018e4fc74accae8a4 Jamie McCarthy jamie@mccarthy.vg 4e5630142615012819954e7c1d65d33e85e8e972 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/3a594a5cf60f788ab1db8170972fd580079b56c0 3a594a5cf60f788ab1db8170972fd580079b56c0

2003-07-20T21:28:48-07:00

This commit authored by HumorBot 5.0. 5f917c21aecb5b053ec09aec9dec2c1dc04c2474 Jamie McCarthy jamie@mccarthy.vg db3d05c01e99576ffe562e5722cf787794b3aed3 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/4e5630142615012819954e7c1d65d33e85e8e972 4e5630142615012819954e7c1d65d33e85e8e972

2003-07-20T09:30:28-07:00

Tips for humans on how to install the libraries and perl modules that this plugin requires. 5e9336966745f02b729392763bd57729639ff9db Jamie McCarthy jamie@mccarthy.vg 6c059760011a02b3ed579a07e9a120be5a4c91ab Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/db3d05c01e99576ffe562e5722cf787794b3aed3 db3d05c01e99576ffe562e5722cf787794b3aed3

2003-07-17T23:31:28-07:00

Debug log fix. 6af7c97c18880e9ea9da19dd407f7eef3b66b3af Jamie McCarthy jamie@mccarthy.vg 4a49dddc1eddb4e915b81f8fc0a12e0ed14d5f70 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/6c059760011a02b3ed579a07e9a120be5a4c91ab 6c059760011a02b3ed579a07e9a120be5a4c91ab

2003-07-17T21:55:16-07:00

Run more often. bd85731eaca827c15346b17e5ea0f0dfdee55377 Jamie McCarthy jamie@mccarthy.vg dbda55abe3abd84f20847b80bfa4df115037bd24 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/4a49dddc1eddb4e915b81f8fc0a12e0ed14d5f70 4a49dddc1eddb4e915b81f8fc0a12e0ed14d5f70

2003-07-17T21:44:55-07:00

I overestimated how much sleeping needed to be done. c6a312e288fe2122347c7478aaa15428a08dd263 Jamie McCarthy jamie@mccarthy.vg 7aad5edba5cd815aa3980d728342048f190d1b40 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/dbda55abe3abd84f20847b80bfa4df115037bd24 dbda55abe3abd84f20847b80bfa4df115037bd24

2003-07-17T21:08:33-07:00

updateStoriesCounts is now done by tasks/counthits.pl 7ba22d0fc84ffe50b00412bb6e06acbc4e9c2358 Jamie McCarthy jamie@mccarthy.vg 4341b46b10add0d62092e1ade7be9fef49fc617e Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/7aad5edba5cd815aa3980d728342048f190d1b40 7aad5edba5cd815aa3980d728342048f190d1b40

2003-07-17T20:48:11-07:00

Note counthits task. df263bbdcb3f5f7cfef0e017b923ff92e2ffb145 Jamie McCarthy jamie@mccarthy.vg 02580491e7848ae6bf74291e422e70a9b4bb5938 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/4341b46b10add0d62092e1ade7be9fef49fc617e 4341b46b10add0d62092e1ade7be9fef49fc617e

2003-07-17T20:46:58-07:00

Don't use memcached on the cid that was asked for. 60df7999b4144b26f521eb650b932a959dfe9f5f Jamie McCarthy jamie@mccarthy.vg aa37db81ef47353215b2ba6764b9ff2dd55c4efb Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/02580491e7848ae6bf74291e422e70a9b4bb5938 02580491e7848ae6bf74291e422e70a9b4bb5938

2003-07-17T20:45:30-07:00

Count stories hits throughout the day. d1c3b3f0226144a4bacd61605a551b4c4983d6b4 Jamie McCarthy jamie@mccarthy.vg 9fc8f26174a3d64dc4055b74beffddd431ee8785 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/aa37db81ef47353215b2ba6764b9ff2dd55c4efb aa37db81ef47353215b2ba6764b9ff2dd55c4efb

2003-07-17T20:40:19-07:00

Add var counthits_lastmaxid for counthits task, and note T tag. d2001771b61af8a2395044cbb032a31763c9127f Jamie McCarthy jamie@mccarthy.vg c47380dc14baab8f9ec668734db8324f84088102 pudge projects@pudge.net http://github.com/scc/slash/commit/9fc8f26174a3d64dc4055b74beffddd431ee8785 9fc8f26174a3d64dc4055b74beffddd431ee8785

2003-07-17T16:36:37-07:00

Help message if no graph ... 97b792a96bf93cf8c005d447c48e7f13c496833c pudge projects@pudge.net 98a180d4dc6279fd1e957be055901d0584cd2f44 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/c47380dc14baab8f9ec668734db8324f84088102 c47380dc14baab8f9ec668734db8324f84088102

2003-07-16T19:49:10-07:00

Let's try writing the same key that we read. That would be good. aa49568052ea4b498db6f17e5eabf08b42c6bf28 Jamie McCarthy jamie@mccarthy.vg 03c2a8e5cc927980e4417aad3b9e73581410f9b5 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/98a180d4dc6279fd1e957be055901d0584cd2f44 98a180d4dc6279fd1e957be055901d0584cd2f44

2003-07-16T18:14:11-07:00

memcached_prefix 6ba04ad81526a350578ba3b845fb35e9aa0be3f5 Jamie McCarthy jamie@mccarthy.vg f6162e6c56213c75d9a7f7d5effb74b464f41864 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/03c2a8e5cc927980e4417aad3b9e73581410f9b5 03c2a8e5cc927980e4417aad3b9e73581410f9b5

2003-07-15T16:35:16-07:00

domaintags default change, required for Memcached. 964a2d352e60b8cd6cef454a330134efceeb08b3 Jamie McCarthy jamie@mccarthy.vg e07fd8f85fd1b305997ab5b24fca04b4388b6725 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/f6162e6c56213c75d9a7f7d5effb74b464f41864 f6162e6c56213c75d9a7f7d5effb74b464f41864

2003-07-15T16:28:17-07:00

Default cids_needed_ar to empty arrayref instead of undef. 6623c6b1befdb6e7f4351cb2412a8ef3736e91e7 Jamie McCarthy jamie@mccarthy.vg 74b746aaf3aa13919e55d7765cbc54db0dc13857 pudge projects@pudge.net http://github.com/scc/slash/commit/e07fd8f85fd1b305997ab5b24fca04b4388b6725 e07fd8f85fd1b305997ab5b24fca04b4388b6725

2003-07-15T15:59:12-07:00

useperl update 9ed770d5ef8b2f4c70208cacb1b3017839e45e23 pudge projects@pudge.net 16d3147f8e2722cc2d6c7162d0effb1462c64c08 pudge projects@pudge.net http://github.com/scc/slash/commit/74b746aaf3aa13919e55d7765cbc54db0dc13857 74b746aaf3aa13919e55d7765cbc54db0dc13857

2003-07-15T15:49:32-07:00

s/use/require/ MemCachedClient 6c98d75ed58ef87ac9ac40d011083aa55e5e60c2 pudge projects@pudge.net a9e0a9d9fe1c0e3f78e33985967acaef2dbf2bd9 pudge projects@pudge.net http://github.com/scc/slash/commit/16d3147f8e2722cc2d6c7162d0effb1462c64c08 16d3147f8e2722cc2d6c7162d0effb1462c64c08

2003-07-15T15:35:30-07:00

i am not comfortable with "or" there; does it even work? i didn't find docs on it ... changing it to something i KNOW will work .... and fixing whitespace :-) 7112b051dd5491f86eb23a3a9b1d29cc4572fd87 pudge projects@pudge.net ee82c4bfe076ed2d70819744db34890a64a12854 pudge projects@pudge.net http://github.com/scc/slash/commit/a9e0a9d9fe1c0e3f78e33985967acaef2dbf2bd9 a9e0a9d9fe1c0e3f78e33985967acaef2dbf2bd9

2003-07-15T15:32:11-07:00

aight 1eb6e5683cb746d5c62883f7dbeb8ae9888157dc pudge projects@pudge.net c06b67c4fa9c525a1d4e7c0e1a00ef24d09bd194 pudge projects@pudge.net http://github.com/scc/slash/commit/ee82c4bfe076ed2d70819744db34890a64a12854 ee82c4bfe076ed2d70819744db34890a64a12854

2003-07-15T15:30:06-07:00

white diddly-ite! 3eb0554c54984df874fec7ff6b279ffdf0d60fe1 pudge projects@pudge.net fb57da1c8ff4e5e59f422dc622a65cf45f420818 pudge projects@pudge.net http://github.com/scc/slash/commit/c06b67c4fa9c525a1d4e7c0e1a00ef24d09bd194 c06b67c4fa9c525a1d4e7c0e1a00ef24d09bd194

2003-07-15T15:25:13-07:00

white white white! 58d41b0e1057e0b1c457506552a021cdee197e0c pudge projects@pudge.net 4be162b98728ff0d2be0fc68367273c54e8d2e2a pudge projects@pudge.net http://github.com/scc/slash/commit/fb57da1c8ff4e5e59f422dc622a65cf45f420818 fb57da1c8ff4e5e59f422dc622a65cf45f420818

2003-07-15T15:23:40-07:00

the white! 8f5d66932522f32cb69140ad3dc7ea92ebd9f76c pudge projects@pudge.net 514009fd5a0fed9b50572acbbe89adf92d997ac0 pudge projects@pudge.net http://github.com/scc/slash/commit/4be162b98728ff0d2be0fc68367273c54e8d2e2a 4be162b98728ff0d2be0fc68367273c54e8d2e2a

2003-07-15T15:15:07-07:00

Add slashProf f6ef60f6171182c3221b7113b74286d15854387b pudge projects@pudge.net 20f618927fa319504eb9a3f562b39894454cce3a Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/514009fd5a0fed9b50572acbbe89adf92d997ac0 514009fd5a0fed9b50572acbbe89adf92d997ac0

2003-07-15T14:33:15-07:00

Memcached. 3c5a9f89f89b01fe192fea96534a1f73d4f34bcc Jamie McCarthy jamie@mccarthy.vg ceee0b31a7710437391b731e1770f686edc26ed2 Jamie McCarthy jamie@mccarthy.vg http://github.com/scc/slash/commit/20f618927fa319504eb9a3f562b39894454cce3a 20f618927fa319504eb9a3f562b39894454cce3a

2003-07-15T14:22:14-07:00

Memcached! (Also whitespace.) b3f8ca16dc2ab14069d750f63b42539ff8a7f676 Jamie McCarthy jamie@mccarthy.vg ed57f69b117143e761ce82ad5fd4047d275b8cce Tim Vroom vroom@blockstackers.com http://github.com/scc/slash/commit/ceee0b31a7710437391b731e1770f686edc26ed2 ceee0b31a7710437391b731e1770f686edc26ed2

2003-07-15T13:11:35-07:00

Schema changes ee2de8265125ce4c6b3d810b606374946b5c0cb2 Tim Vroom vroom@blockstackers.com 4c1b20ee37cb304808443f204b640199fdfbb07a Tim Vroom vroom@blockstackers.com http://github.com/scc/slash/commit/ed57f69b117143e761ce82ad5fd4047d275b8cce ed57f69b117143e761ce82ad5fd4047d275b8cce

2003-07-15T12:44:58-07:00

Added logic to hide not yet active poll a7b8fcc05913761a016b75963aba0e0ee4b00c28 Tim Vroom vroom@blockstackers.com d72b2da11eee5e0df71998f791aa92aa5ddda6cf Tim Vroom vroom@blockstackers.com http://github.com/scc/slash/commit/4c1b20ee37cb304808443f204b640199fdfbb07a 4c1b20ee37cb304808443f204b640199fdfbb07a

2003-07-15T12:10:40-07:00

Update to add plum for subscribers to exclude more topics 30f3b81a2e01c70c5ef88b26cefa9a5e86e41647 Tim Vroom vroom@blockstackers.com