竹貓星球

代碼: 選擇全部

 Authors Notes: 
## 
## Instead of runing the SQL commands your self, I have also included a db_update.php file
## if you are loged in as ADMIN, you can run this file, witch will do the neasessary changes to the DB
## the file will by it self put prefix on your tables, else 
## if you are using a prefix to you DB tabels then you have to add this to 
## the [ADD SQL] commands, e.g. "phpbb_users" instead of just "users" - ONLY 
## in the initial [ADD SQL] commands, not in the php code ! 
##
## 
## The most important thing to keep in mind is, take your time, make 
## sure you are finding the correct lines to modify, then take care to paste the new code. 
## Please also keep in mind, if you are using more than one language file or theme at your 
## site, you will need to edit the corrosponding files for each occurrence.  Good Luck! 
################################################################# 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
## and the Database
################################################################# 


# 
#-----[ ADD SQL ]------------------------------------------ 
# 
SQL-query: 
ALTER TABLE users ADD user_lastlogon INT (11) DEFAULT '0' 

# 
#-----[ ADD SQL ]------------------------------------------ 
# 
SQL-query: 
UPDATE users SET user_lastlogon=user_lastvisit 

# 
#-----[ ADD SQL ]------------------------------------------ 
# 
SQL-query: 
INSERT INTO config (config_name, config_value) VALUES ('hidde_last_logon', '0') 

###############################################################