Last vizit
Scris: 05-Apr-2007, 11:16:53
This list is a result of the SQL queries needed for MOD
Last Visit PART 1 Mod
[Already added] line: 1 , ALTER TABLE phpbb_users ADD user_lastlogon INT (11) DEFAULT "0" not null
[Added/Updated] line: 2 , UPDATE phpbb_users SET user_lastlogon=user_lastvisit WHERE user_lastlogon="0"
Last Visit PART 2 Mod
[Already added] line: 3 , INSERT INTO phpbb_config (config_name, config_value) VALUES ("hidde_last_logon", "0")
Last Visit PART 4 Mod
[Already added] line: 4 , ALTER TABLE phpbb_users ADD user_totaltime INT (11) DEFAULT "0"
[Already added] line: 5 , ALTER TABLE phpbb_users ADD user_totallogon INT (11) DEFAULT "0"
[Already added] line: 6 , ALTER TABLE phpbb_users ADD user_totalpages INT (11) DEFAULT "0"
[Added/Updated] line: 7 , UPDATE phpbb_users SET user_totaltime=(user_session_time-user_lastlogon) WHERE user_totaltime="0" AND user_lastlogon>0
[Added/Updated] line: 8 , UPDATE phpbb_users SET user_totallogon=1 WHERE user_totallogon="0" AND user_session_time<>"0"
ma pune sa fac upload la last_visit_update.php
si apoi sal rulez si imi zice asta de sus ce trebuie sa fac ?
Last Visit PART 1 Mod
[Already added] line: 1 , ALTER TABLE phpbb_users ADD user_lastlogon INT (11) DEFAULT "0" not null
[Added/Updated] line: 2 , UPDATE phpbb_users SET user_lastlogon=user_lastvisit WHERE user_lastlogon="0"
Last Visit PART 2 Mod
[Already added] line: 3 , INSERT INTO phpbb_config (config_name, config_value) VALUES ("hidde_last_logon", "0")
Last Visit PART 4 Mod
[Already added] line: 4 , ALTER TABLE phpbb_users ADD user_totaltime INT (11) DEFAULT "0"
[Already added] line: 5 , ALTER TABLE phpbb_users ADD user_totallogon INT (11) DEFAULT "0"
[Already added] line: 6 , ALTER TABLE phpbb_users ADD user_totalpages INT (11) DEFAULT "0"
[Added/Updated] line: 7 , UPDATE phpbb_users SET user_totaltime=(user_session_time-user_lastlogon) WHERE user_totaltime="0" AND user_lastlogon>0
[Added/Updated] line: 8 , UPDATE phpbb_users SET user_totallogon=1 WHERE user_totallogon="0" AND user_session_time<>"0"
ma pune sa fac upload la last_visit_update.php
si apoi sal rulez si imi zice asta de sus ce trebuie sa fac ?