[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