[geeklog-users] User Topic Subscription - MDigest

- Ed - e at marinx.com
Sat Jan 31 13:38:40 EST 2004


I needed to change many users' Topic Email Subscriptions and struggled to
find where this is in the tables.
Then, the RESET button in  /admin/mdigest/search.php  gave me the clue!
Line 166
DB_query ("UPDATE {$_TABLES['userindex']} SET etids = '-' WHERE uid =
'{$uid}'");


Ok great, so I go to the table to look up      etids

To my horror, it's all text values stored in there of the actual Topic
Names.
This seems highly inefficient, but more importantly, I wonder, what happens
when a Topic Name is changed by the Admin?  Is there a routine to update all
this stuff?
Or maybe I'm clueless and this index is built on the fly somehow.
>From a data normalization standpoint I don't think it makes sense.

Just thought I'd throw it out here, hope this is not out of order.




More information about the geeklog-users mailing list