[2023-01-23] 4images 1.10 released
0 Members and 1 Guest are viewing this topic.
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); } } } }}
$additional_user_fields['last_time_profile_visited'] = array($lang['last_time_profile_visited'], "text", 0);
"user_last_action" => (isset($user_row['user_lastaction'])) ? format_date($config['date_format']." ".$config['time_format'], $user_row['user_lastaction']) : REPLACE_EMPTY,
"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'],
$lang['last_time_profile_visited'] = "Last time profile visited";
ALTER TABLE `4images_users` ADD last_time_profile_visited INT(11) NOT NULL DEFAULT '0';
[code][quote author=thunderstrike link=topic=20516.msg111620#msg111620 date=1202990932]// Step 1In 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); } } } }}
hi on this lineCode: [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]
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 10Unknown column 'u.last_time_profile_visited' in 'field list'
Code: [Select][code][quote author=thunderstrike link=topic=20516.msg111620#msg111620 date=1202990932]// Step 1In 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 2In 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 3In 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 3In lang/main.php file,add in top ?>:Code: [Select]$lang['last_time_profile_visited'] = "Last time profile visited";// Step 4In 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.
only add this " here "lang_last_time_profile_visited" => $lang['last_time_profile_visited'],i see
i have this problem in top.php because for
this is you step 5http://www.imagehosting.com/out.php/i1580919_dbcreate.jpg , add this in Db
the user profile trial and has no notification of when was the last time you edit or visit your profile does not date
work in localhost