Welcome e-mail after approval?

[Rafael_XCX]

Hi! Please... On my gallery I use the hack to approve the accounts manually. The user register and the e-mail confirmation with the code to approve comes to me instead of the user, so then I can check his informations and approve by myself. After that, is there a way to the user receive an e-mail saying that his account was approved and show his login informations plus a few messages? 

Thanks!

[Nibbler]

This is a standard feature of 1.4. Update!

[Rafael_XCX]

This is a standard feature of 1.4. Update!

Do you know how to do it on 1.3?
Also, I have another question please. I saw a code you did here for someone to list all the registered e-mails:

Code Select Expand

<?php

define('IN_COPPERMINE', 1);
require 'include/init.inc.php';

$test = db_query("SELECT DISTINCT(user_email) FROM {$CONFIG['TABLE_USERS']} WHERE user_email <> ''");

while ($row = mysql_fetch_assoc($test))
echo $row['user_email'] . "<br />";

?>

Can you please adapt it to show the username, e-mail and location? Like this:

John
john@hotmail.com
England

Bob
bob@hotmail.com
USA

....

Can you please post the code here?

[Joachim Müller]

We have a "one question per thread" policy you agreed to respect whehn signing up. Do so in the future. Custom hacks/mods go unsupported. That's why Nibbler told you to upgrade. Support for cpg1.3.x is running out anyway.

[Rafael_XCX]

Ops! Sorry!