[問題]資料加上生日、星座、生肖的資訊~疑問

[夜楓]

問題外掛：Birthday Mod 1.4.21 資料加上生日、星座、生肖的資訊
連結 http://www.phpbbhacks.com/viewhack.php?id=187
使用版本：phpBB 2.0.8
狀況描述：
有一些疑問

第一個問題:
他這個不用SQL嘛?
壓縮檔裡找不到...說明檔也沒有
導致我點文章時出現錯誤

代碼: 選擇全部

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_birthday' in 'field list'

SELECT u.username, pt.pay_money, pt.pay_user, pt.pay_see, pt.pay_gotmoney, u.user_money, u.user_id, u.user_posts, u.user_level, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_birthday, u.user_next_birthday_greeting, u.user_robfail, u.rpg_level, u.rpg_cur_hp, u.rpg_max_hp, u.rpg_cur_mp, u.rpg_max_mp, u.rpg_cur_exp, u.rpg_max_exp, u.rpg_attack, u.rpg_defense, u.rpg_magic, u.rpg_speed, u.rpg_medals, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 11 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 396
File : c:\appserv\www\viewtopic.php

第2個問題:
再更改個人資料時
我用1987年 他說不行 1970年就可以...
Sorry, this site, does not accept user older than 0 years old
對不起，這一個位置，不接受使用者資深者超過 0 歲
真奇怪..是我哪裡改錯了嗎??
還有這個不是說有星座、生肖的資訊嘛??怎麼都沒看到??

[clpl]

run birthday_dp_update.php

[夜楓]

輸入\r
http://網址/birthday_db_update.php

我用好以後出現\r

代碼: 選擇全部

This list is a result of the SQL queries needed for the additional mods in the pre-moded pack


Birthday PART 1 Mod
[Added/Updated] line: 1 , ALTER TABLE phpbb_users ADD user_birthday INT DEFAULT "999999" not null 
[Added/Updated] line: 2 , ALTER TABLE phpbb_users ADD user_next_birthday_greeting INT DEFAULT "0" not null 


Birthday PART 2 Mod
[Added/Updated] line: 3 , INSERT INTO phpbb_config (config_name, config_value) VALUES ("birthday_required", "0")
[Added/Updated] line: 4 , INSERT INTO phpbb_config (config_name, config_value) VALUES ("birthday_greeting", "1")
[Added/Updated] line: 5 , INSERT INTO phpbb_config (config_name, config_value) VALUES ("max_user_age", "100")
[Added/Updated] line: 6 , INSERT INTO phpbb_config (config_name, config_value) VALUES ("min_user_age", "5")
[Added/Updated] line: 7 , INSERT INTO phpbb_config (config_name, config_value) VALUES ("birthday_check_day", "7")

已經OK了~~謝謝^^