Pagina 1 din 1

Last vizit

Scris: 05-Apr-2007, 11:16:53
de BLACKzone
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 ?

Scris: 05-Apr-2007, 11:24:44
de Aliniuz
Nimic, iti continui instalarea MODului .

Scris: 05-Apr-2007, 11:45:32
de BLACKzone
l-am instalat da acum uite cum apare, dai in jos pe forumul http://www.fdns.ro/blackzone/index.php zimi putin ce nam facut bine

Scris: 05-Apr-2007, 11:47:00
de BLACKzone
l-am instalat da acum uite cum apare, dai in jos pe forumul http://www.fdns.ro/blackzone/index.php zimi putin ce nam facut bine

Scris: 05-Apr-2007, 11:53:14
de Aliniuz
In index_body.tpl cauta rowspan si mareste valoarea din ghilimele cu 2 .

Scris: 05-Apr-2007, 11:56:52
de BLACKzone
la mine era 3, cred ca dupa instalare am pus 2 si tot asta ( am pus si 1 )

---------
am pus 10 si merge :D