Welcome to Geeklog, Anonymous Thursday, December 26 2024 @ 10:38 am EST
Geeklog Forums
Digests for all new users
Status: offline
marcelw
Forum User
Newbie
Registered: 09/04/05
Posts: 12
Allthough $emailstoriesperdefault is set to 1 my new users do not get Daily digests.
Is suspect the next lines in lib-user.php:
DB_query ("INSERT INTO {$_TABLES['userprefs']} (uid) VALUES ($uid)");
if ($_CONF['emailstoriesperdefault'] == 1) {
DB_query ("INSERT INTO {$_TABLES['userindex']} (uid) VALUES ($uid)");
} else {
DB_query ("INSERT INTO {$_TABLES['userindex']} (uid,etids) VALUES ($uid, '-')");
}
In lib-common.php the users for digests are selected as such:
// Get users who want stories emailed to them
$usersql = "SELECT username,email,etids,{$_TABLES['users']}.uid AS uuid "
. "FROM {$_TABLES['users']}, {$_TABLES['userindex']} "
. "WHERE {$_TABLES['users']}.uid > 1 AND {$_TABLES['userindex']}.uid = {$_TABLES['users']}.uid AND (etids '-') ORD
ER BY {$_TABLES['users']}.uid";
As in lib-user.php -values have been created in etids the SQL-query does not find these users in the statement (etids '-').
It seems to me lib-user.php should create an empty field:
(uid,etids) VALUES ($uid, '')
Is suspect the next lines in lib-user.php:
DB_query ("INSERT INTO {$_TABLES['userprefs']} (uid) VALUES ($uid)");
if ($_CONF['emailstoriesperdefault'] == 1) {
DB_query ("INSERT INTO {$_TABLES['userindex']} (uid) VALUES ($uid)");
} else {
DB_query ("INSERT INTO {$_TABLES['userindex']} (uid,etids) VALUES ($uid, '-')");
}
In lib-common.php the users for digests are selected as such:
// Get users who want stories emailed to them
$usersql = "SELECT username,email,etids,{$_TABLES['users']}.uid AS uuid "
. "FROM {$_TABLES['users']}, {$_TABLES['userindex']} "
. "WHERE {$_TABLES['users']}.uid > 1 AND {$_TABLES['userindex']}.uid = {$_TABLES['users']}.uid AND (etids '-') ORD
ER BY {$_TABLES['users']}.uid";
As in lib-user.php -values have been created in etids the SQL-query does not find these users in the statement (etids '-').
It seems to me lib-user.php should create an empty field:
(uid,etids) VALUES ($uid, '')
10
10
Quote
All times are EST. The time is now 10:38 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content