[MOD] - Welcome PM MOD after register (free)

[thunderstrike]

This is MOD for welcome PM after user register (show 1 time for new user).

// Step 1

In register.php file,

find:

Code: [Select]

$sql = "INSERT INTO ".USERS_TABLE."
            (".get_user_table_field("", "user_id").get_user_table_field(", ", "user_level").get_user_table_field(", ", "user_name").get_user_table_field(", ", "user_password").get_user_table_field(", ", "user_email").get_user_table_field(", ", "user_showemail").get_user_table_field(", ", "user_allowemails").get_user_table_field(", ", "user_invisible").get_user_table_field(", ", "user_joindate").get_user_table_field(", ", "user_activationkey").get_user_table_field(", ", "user_lastaction").get_user_table_field(", ", "user_lastvisit").get_user_table_field(", ", "user_comments").get_user_table_field(", ", "user_homepage").get_user_table_field(", ", "user_icq").$additional_field_sql.")
            VALUES
            ($user_id, $user_level, '$user_name', '".md5($user_password)."', '$user_email', $user_showemail, $user_allowemails, $user_invisible, $current_time, '$activationkey', $current_time, $current_time, 0, '$user_homepage', '$user_icq'".$additional_value_sql.")";

replace:

Code: [Select]

$sql = "INSERT INTO ".USERS_TABLE."
            (".get_user_table_field("", "user_id").get_user_table_field(", ", "user_level").get_user_table_field(", ", "user_name").get_user_table_field(", ", "user_password").get_user_table_field(", ", "user_email").get_user_table_field(", ", "user_showemail").get_user_table_field(", ", "user_allowemails").get_user_table_field(", ", "user_invisible").get_user_table_field(", ", "user_joindate").get_user_table_field(", ", "user_activationkey").get_user_table_field(", ", "user_lastaction").get_user_table_field(", ", "user_lastvisit").get_user_table_field(", ", "user_comments").get_user_table_field(", ", "user_homepage").get_user_table_field(", ", "user_icq"). ", welcome_pm_status" . $additional_field_sql.")
            VALUES
            ($user_id, $user_level, '$user_name', '".md5($user_password)."', '$user_email', $user_showemail, $user_allowemails, $user_invisible, $current_time, '$activationkey', $current_time, $current_time, 0, '$user_homepage', '$user_icq', '1'".$additional_value_sql.")";

// Step 2

In includes/sessions.php file,

find:

Code: [Select]

$this->set_cookie_data("userid", $this->user_info['user_id']);

add after:

Code: [Select]

$sql = "
   
    SELECT welcome_pm_status
    FROM " . USERS_TABLE . "
    WHERE " . get_user_table_field("", "user_id") . " = " . $this->user_info['user_id'] . " AND welcome_pm_status = 1";
   
    if ($site_db->not_empty($sql)) {
        if (function_exists('welcome_pm_random_key') && $key = welcome_pm_random_key()) {
            redirect("pm_welcome.php?key=" . $key);
            unset ($key);
        }
    }

// Step 3

In lang/english/main.php file,

add in top ?>:

Code: [Select]

$lang['welcome_pm_mod_title'] = "Welcome message";
$lang['welcome_pm_mod_text'] = "Welcome to <b>{site_name}</b> gallery <b>{user_name}</b>";

// Step 4

In ROOT_PATH, create file: pm_welcome.php .

Add:

Code: [Select]

<?php

$main_template = "pm_welcome";

define('ROOT_PATH', './');
include(ROOT_PATH . 'global.php');
require(ROOT_PATH . 'includes/sessions.php');
@include_once(ROOT_PATH . 'includes/page_header.php');

if ($user_info['user_level'] < USER) {
    redirect($url);
}
    
if (!isset($HTTP_GET_VARS['key'])) {
    redirect($url);
}
$site_db->query("UPDATE " . USERS_TABLE . " SET welcome_pm_status = 0 WHERE " . get_user_table_field("", "user_id") . " = " . $user_info['user_id']);            

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$clickstream = "<a href=\"" . $site_sess->url(ROOT_PATH . "index.php") . "\">" . $lang['home'] . "</a>" . $config['category_separator'] . $lang['welcome_pm_mod_title'];

$site_template->register_vars(array(
"clickstream" => trim($clickstream),
"lang_welcome_pm_mod_title" => $lang['welcome_pm_mod_title'],
"lang_welcome_pm_mod_text" => preg_replace("/" . $site_template->start . "user_name" . $site_template->end . "/siU", format_text(trim($user_info['user_name']), 2), $lang['welcome_pm_mod_text'])
));
$site_template->print_template($site_template->parse_template($main_template));
unset ($HTTP_GET_VARS['key']);

@include_once(ROOT_PATH . 'includes/page_footer.php');    
?>

// Step 5

In templates/your_template - create file: pm_welcome.html .
(Note: I use ULM) .

Add:

Code: [Select]

{header}
{ste_layout_top}
{ste_layout_left}

<span class="title">{site_name}</span>
<br /><br />

{if lang_welcome_pm_title}
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" class="head1">{lang_welcome_pm_mod_title}</td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" class="row2">&nbsp;</td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" class="row2" align="center" />{lang_welcome_pm_mod_text}</td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" class="row2">&nbsp;</td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" class="head1">&nbsp;</td>
</tr>
</table>
</td>
</tr>
</table>
{endif lang_welcome_pm_title}

{ste_layout_below}
{footer}

// Step 6

In admin/users.php file,

find:

Code: [Select]

      $sql = "INSERT INTO ".USERS_TABLE."
              (".get_user_table_field("", "user_id").get_user_table_field(", ", "user_level").get_user_table_field(", ", "user_name").get_user_table_field(", ", "user_password").get_user_table_field(", ", "user_email").get_user_table_field(", ", "user_showemail").get_user_table_field(", ", "user_allowemails").get_user_table_field(", ", "user_invisible").get_user_table_field(", ", "user_joindate").get_user_table_field(", ", "user_activationkey").get_user_table_field(", ", "user_lastaction").get_user_table_field(", ", "user_lastvisit").get_user_table_field(", ", "user_comments").get_user_table_field(", ", "user_homepage").get_user_table_field(", ", "user_icq").$additional_field_sql.")
              VALUES
              ($user_id, $user_level, '$user_name', '$user_password', '$user_email', $user_showemail, $user_allowemails, $user_invisible, $current_time, '$activationkey', $current_time, $current_time, 0, '$user_homepage', '$user_icq'".$additional_value_sql.")";

replace:

Code: [Select]

      $sql = "INSERT INTO ".USERS_TABLE."
              (".get_user_table_field("", "user_id").get_user_table_field(", ", "user_level").get_user_table_field(", ", "user_name").get_user_table_field(", ", "user_password").get_user_table_field(", ", "user_email").get_user_table_field(", ", "user_showemail").get_user_table_field(", ", "user_allowemails").get_user_table_field(", ", "user_invisible").get_user_table_field(", ", "user_joindate").get_user_table_field(", ", "user_activationkey").get_user_table_field(", ", "user_lastaction").get_user_table_field(", ", "user_lastvisit").get_user_table_field(", ", "user_comments").get_user_table_field(", ", "user_homepage").get_user_table_field(", ", "user_icq"). ", welcome_pm_status" . $additional_field_sql.")
              VALUES
              ($user_id, $user_level, '$user_name', '$user_password', '$user_email', $user_showemail, $user_allowemails, $user_invisible, $current_time, '$activationkey', $current_time, $current_time, 0, '$user_homepage', '$user_icq', '1'".$additional_value_sql.")";

/ Step 7

In includes/functions.php file,

add in top ?>:

Code: [Select]

if (!function_exists('welcome_pm_random_key')) {
    function welcome_pm_random_key() {
       
        mt_srand((double) microtime() * 1000000);
        $puddle = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
        $random_key = "";
        for ($i = 0; $i < 8; $i++) {
            $random_key .= substr($puddle, (mt_rand()%(strlen($puddle))), 1);
        }
        return $random_key;                   
    }
}

// Step 8

Use in ACP - > SQL Patches (expert mode) -

Code: [Select]

ALTER TABLE `4images_users` ADD welcome_pm_status int(1) NOT NULL DEFAULT '0';

Finish.

[thunderstrike]

I edit step 1 of first post.

[flyfreak]

I get this error message:

An unexpected error occured. Please try again later.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /customers/flyfreak.dk/flyfreak.dk/httpd.www/foto/includes/db_mysql.php on line 171

Warning: Cannot modify header information - headers already sent by (output started at /customers/flyfreak.dk/flyfreak.dk/httpd.www/foto/includes/db_mysql.php:192) in /customers/flyfreak.dk/flyfreak.dk/httpd.www/foto/includes/functions.php on line 127

[thunderstrike]

includes/functions.php on line 127

Please post from line 125 to line 130.