Setting $userinfo[newsletter] default to 'yes' for new users

Nuke Cadet Joined: Aug 24, 2003 Posts: 2

Any ideas on which file to hack and how?

Corporal Joined: Aug 20, 2003 Posts: 61

Open index.php in Your_Account. Look for:

Code:

function activate($username, $checknum....

Now scroll down till you see:

Code:

$result = $db->sql_query("INSERT INTO ".$user_prefix."_users....

After that line put in:

Code:

$res_id = $db -> sql_query("SELECT user_id FROM ".$user_prefix."_users ORDER BY user_id DESC");
list($new_uid) = $db -> sql_fetchrow($res_id);
$db -> sql_query("UPDATE ".$user_prefix."_users SET newsletter='1' WHERE user_id='$new_uid'");

--Hadron

Nuke Cadet Joined: Aug 24, 2003 Posts: 2

Worked a treat!
Much appreciated, Hadron.

Posted: Sun Aug 31, 2003 9:20 pm

What versions does this work on?

Support Mod Joined: Mar 19, 2003 Posts: 308

kjcdude wrote:

What versions does this work on?

6.0 and higher

Posted: Sun Aug 31, 2003 10:48 pm

I canot find

Code:

$result = $db->sql_query("INSERT INTO ".$user_prefix."_users

PHP-Nuke Version=6.8

But i do have some hacks.

Isnt there a way to do it in the database?