last visite member

[masterred]

hi

It is possible to add the day or date of the last visit of the user in the user profile or the day that update your profile

thanks

[thunderstrike]

// Step 1

In includes/functions.php file,

add in top ?>:

Code: [Select]

if (!function_exists('update_last_profile_visited')) {
function update_last_profile_visited($user_id, $profile_visited) {
global $site_db, $config;

$result = $site_db->query("UPDATE " . USERS_TABLE . " SET " . $profile_visited . " = '" . time() . "' WHERE " . get_user_table_field("", "user_id") . " = " . $user_id);
if ($result) {

$sql = "

SELECT " . $profile_visited . "
FROM " . USERS_TABLE . "
WHERE " . get_user_table_field("", "user_id") . " = " . $user_id;

$date_row = $site_db->query_firstrow($sql);
if (isset($date_row[$profile_visited]) && !empty($date_row[$profile_visited])) {
if (function_exists('get_universal_field_date')) {
return get_universal_field_date($profile_visited);
} else {
return format_date($config['date_format'] . " " . $config['time_format'], $profile_visited);
}
}
}
}
}

// Step 2

In includes/db_field_definitions.php file,

add in top ?>:

Code: [Select]

$additional_user_fields['last_time_profile_visited'] = array($lang['last_time_profile_visited'], "text", 0);

// Step 3

In member.php file,

find:

Code: [Select]

"user_last_action" => (isset($user_row['user_lastaction'])) ? format_date($config['date_format']." ".$config['time_format'], $user_row['user_lastaction']) : REPLACE_EMPTY,

add after:

Code: [Select]

"last_time_profile_visited" => (isset($user_row['last_time_profile_visited']) && !empty($user_row['last_time_profile_visited']) && function_exists('update_last_profile_visited')) ? update_last_profile_visited($user_row['user_id'], $user_row['last_time_profile_visited']) : "",
"lang_last_time_profile_visited => $lang['last_time_profile_visited'],

// Step 3

In lang/main.php file,

add in top ?>:

Code: [Select]

$lang['last_time_profile_visited'] = "Last time profile visited";

// Step 4

In templates/your_template/member_profile.html file, use: {if last_time_profile_visited}{lang_last_time_profile_visited}{last_time_profile_visited}{endif last_time_profile_visited} where you like.

// Step 5

In SQL patches (expert mode) - add:

Code: [Select]

ALTER TABLE `4images_users` ADD last_time_profile_visited INT(11) NOT NULL DEFAULT '0';

Finish.

[masterred]

Code: [Select]

[code][quote author=thunderstrike link=topic=20516.msg111620#msg111620 date=1202990932]
// Step 1

In includes/functions.php file,

add in top ?>:

[code]
if (!function_exists('update_last_profile_visited')) {
function update_last_profile_visited($user_id, $profile_visited) {
global $site_db, $config;

$result = $site_db->query("UPDATE " . USERS_TABLE . " SET " . $profile_visited . " = '" . time() . "' WHERE " . get_user_table_field("", "user_id") . " = " . $user_id);
if ($result) {

$sql = "

SELECT " . $profile_visited . "
FROM " . USERS_TABLE . "
WHERE " . get_user_table_field("", "user_id") . " = " . $user_id;

$date_row = $site_db->query_firstrow($sql);
if (isset($date_row[$profile_visited]) && !empty($date_row[$profile_visited])) {
if (function_exists('get_universal_field_date')) {
return get_universal_field_date($profile_visited);
} else {
return format_date($config['date_format'] . " " . $config['time_format'], $profile_visited);
}
}
}
}
}

// Step 2

In includes/db_field_definitions.php file,

add in top ?>:

Code: [Select]

$additional_user_fields['last_time_profile_visited'] = array($lang['last_time_profile_visited'], "text", 0);

// Step 3

In member.php file,

find:

Code: [Select]

"user_last_action" => (isset($user_row['user_lastaction'])) ? format_date($config['date_format']." ".$config['time_format'], $user_row['user_lastaction']) : REPLACE_EMPTY,

add after:

Code: [Select]

"last_time_profile_visited" => (isset($user_row['last_time_profile_visited']) && !empty($user_row['last_time_profile_visited']) && function_exists('update_last_profile_visited')) ? update_last_profile_visited($user_row['user_id'], $user_row['last_time_profile_visited']) : "",
"lang_last_time_profile_visited => $lang['last_time_profile_visited'],

// Step 3

In lang/main.php file,

add in top ?>:

Code: [Select]

$lang['last_time_profile_visited'] = "Last time profile visited";

// Step 4

In templates/your_template/member_profile.html file, use: {if last_time_profile_visited}{lang_last_time_profile_visited}{last_time_profile_visited}{endif last_time_profile_visited} where you like.

Finish.
[/quote]

hi on this line

Code: [Select]

"last_time_profile_visited" => (isset($user_row['last_time_profile_visited']) && !empty($user_row['last_time_profile_visited']) && function_exists('update_last_profile_visited')) ? update_last_profile_visited($user_row['user_id'], $user_row['last_time_profile_visited']) : "",
"lang_last_time_profile_visited => $lang['last_time_profile_visited'],

modify to  this

[/code]"last_time_profile_visited" => (isset($user_row['last_time_profile_visited']) && !empty($user_row['last_time_profile_visited']) && function_exists('update_last_profile_visited')) ? update_last_profile_visited($user_row['user_id'], $user_row['last_time_profile_visited']) : "",
"lang_last_time_profile_visited" => $lang['last_time_profile_visited'],
[/code]

only add this " here

"lang_last_time_profile_visited" => $lang['last_time_profile_visited'],

i see

[masterred]

hi

i have this problem in top.php because for ?

DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_rating, i.image_votes, c.cat_name, u.user_name , u.user_hobbies, u.last_time_profile_visited FROM (4images_images i, 4images_categories c) LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND i.cat_id = c.cat_id ORDER BY i.image_votes DESC, i.image_name ASC LIMIT 10
Unknown column 'u.last_time_profile_visited' in 'field list'
 

i need create table on DB?

[thunderstrike]

Code: [Select]

[code][quote author=thunderstrike link=topic=20516.msg111620#msg111620 date=1202990932]
// Step 1

In includes/functions.php file,

add in top ?>:

[code]
if (!function_exists('update_last_profile_visited')) {
function update_last_profile_visited($user_id, $profile_visited) {
global $site_db, $config;

$result = $site_db->query("UPDATE " . USERS_TABLE . " SET " . $profile_visited . " = '" . time() . "' WHERE " . get_user_table_field("", "user_id") . " = " . $user_id);
if ($result) {

$sql = "

SELECT " . $profile_visited . "
FROM " . USERS_TABLE . "
WHERE " . get_user_table_field("", "user_id") . " = " . $user_id;

$date_row = $site_db->query_firstrow($sql);
if (isset($date_row[$profile_visited]) && !empty($date_row[$profile_visited])) {
if (function_exists('get_universal_field_date')) {
return get_universal_field_date($profile_visited);
} else {
return format_date($config['date_format'] . " " . $config['time_format'], $profile_visited);
}
}
}
}
}

// Step 2

In includes/db_field_definitions.php file,

add in top ?>:

Code: [Select]

$additional_user_fields['last_time_profile_visited'] = array($lang['last_time_profile_visited'], "text", 0);

// Step 3

In member.php file,

find:

Code: [Select]

"user_last_action" => (isset($user_row['user_lastaction'])) ? format_date($config['date_format']." ".$config['time_format'], $user_row['user_lastaction']) : REPLACE_EMPTY,

add after:

Code: [Select]

"last_time_profile_visited" => (isset($user_row['last_time_profile_visited']) && !empty($user_row['last_time_profile_visited']) && function_exists('update_last_profile_visited')) ? update_last_profile_visited($user_row['user_id'], $user_row['last_time_profile_visited']) : "",
"lang_last_time_profile_visited => $lang['last_time_profile_visited'],

// Step 3

In lang/main.php file,

add in top ?>:

Code: [Select]

$lang['last_time_profile_visited'] = "Last time profile visited";

// Step 4

In templates/your_template/member_profile.html file, use: {if last_time_profile_visited}{lang_last_time_profile_visited}{last_time_profile_visited}{endif last_time_profile_visited} where you like.

Finish.

hi on this line

Code: [Select]

"last_time_profile_visited" => (isset($user_row['last_time_profile_visited']) && !empty($user_row['last_time_profile_visited']) && function_exists('update_last_profile_visited')) ? update_last_profile_visited($user_row['user_id'], $user_row['last_time_profile_visited']) : "",
"lang_last_time_profile_visited => $lang['last_time_profile_visited'],

modify to  this

[/code]"last_time_profile_visited" => (isset($user_row['last_time_profile_visited']) && !empty($user_row['last_time_profile_visited']) && function_exists('update_last_profile_visited')) ? update_last_profile_visited($user_row['user_id'], $user_row['last_time_profile_visited']) : "",
"lang_last_time_profile_visited" => $lang['last_time_profile_visited'],
[/code]

only add this " here

"lang_last_time_profile_visited" => $lang['last_time_profile_visited'],

i see

and ... problem for this post ?

i have this problem in top.php because for

[edit] - I find problem. I add step 5.

[masterred]

hi

Because already modify and create the entire table in the database and nothing, I did not see anything, nor visitandolo offline or online, I created a user test to check and nothing without results.

thank

[thunderstrike]

You add step 5 ? If so, is no possible for empty result ...

[masterred]

hi

yes add step 5 and nothing

data base



member_profile.html




i see

the install is clean no more MOD

[thunderstrike]

I no see in my step for where add change in SQL line. Please read step 5.

For top.php file, please post SQL query for this problem:

DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_rating, i.image_votes, c.cat_name, u.user_name , u.user_hobbies, u.last_time_profile_visited FROM (4images_images i, 4images_categories c) LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND i.cat_id = c.cat_id ORDER BY i.image_votes DESC, i.image_name ASC LIMIT 10
Unknown column 'u.last_time_profile_visited' in 'field list'

[masterred]

hi

Look, the error of the DB or sql, salio to make changes in the files that I indicastes In includes / functions.php file, In includes / db_field_definitions.php file, In member.php file, In lang / main.php file , and that mistake member_profile.html me salio in top.php because it is not, when I put you indicated to me the error in top.php of SQL, we indicated that if it was missing create the table on the basis of data. After modificastes and agregastes step five, once we have the table disappeared in the judgement error sql. But even so it does not show results in the file member_profile.html, modification was made in a new gallery, without further modification.

this is you step 5

http://www.imagehosting.com/out.php/i1580919_dbcreate.jpg , add this in Db

NOTE error appeared before the added step 5

i see

[thunderstrike]

Again - what is source code for SQL in top.php file ? Please post query - I check.

this is you step 5

http://www.imagehosting.com/out.php/i1580919_dbcreate.jpg , add this in Db

Again - I no see change in step 5. Is no my instruction. I say for ALTER table and add - no use of change nowhere.

[masterred]

hi

you post date (« Reply #1 on: 14-02-2008, 05:08:52 ») The modification was performed perfectly with all five steps. Only that it has no results, entered as a user entered as evidence after admin revisit the user profile trial and has no notification of when was the last time you edit or visit your profile does not date

[thunderstrike]

the user profile trial and has no notification of when was the last time you edit or visit your profile does not date

No, this is right ... user is no get email for notify ... is load of send email for server ... host is no like this but if say you no see date update for each visit, please post URL to member profile and I check.

[masterred]

hi

work in localhost

[thunderstrike]

work in localhost

Ok ... ?