Code: Select all
global $db,$HTTP_GET_VARS; $start = (isset($HTTP_GET_VARS['start'])) ? intval($HTTP_GET_VARS['start']) : 0; $sql = "SELECT * FROM ".PROFILE_GUESTBOOK_TABLE." g, ".USERS_TABLE." u WHERE g.user_id = ".$this->uid." AND g.poster_id = u.user_id ORDER BY g.gb_time DESC LIMIT $start, 10";
Code: Select all
global $db,$HTTP_GET_VARS; $start = (isset($HTTP_GET_VARS['start'])) ? intval($HTTP_GET_VARS['start']) : 0; $sql = "SELECT * FROM ".PROFILE_GUESTBOOK_TABLE." g, ".USERS_TABLE." u WHERE g.user_id = ".$this->uid." AND g.poster_id = u.user_id ORDER BY g.gb_time ASC LIMIT $start, 10";
You must run the SQL query's from the mod.conner85 wrote: I tried installing it on mine, and nothin happened. None of the options changed on my profile or on my ACP. But when I changed my template on my profile, it said:
Could not update users table
SQL Error : 1054 Unknown column 'user_email_new_gb' in 'field list'
UPDATE phpbb_users SET user_email = 'email@example.com', user_icq = '', user_website = 'http://www.metalheadquarters.org', user_occ = 'Musician, Webmaster, Guitar Junkie', user_from = 'Albion, IL', user_interests = 'Long walks on the beach, candle li.... wait. Music, webpage designing and graphics design.', user_sig = 'Whoever appeals to the law of his fellow man is either a fool or a coward. Whoever cannot take care of himself without that law is both. For a wounded man shall say to his assailant, \"If I live, I will kill you. If I die, you are forgiven.\" Such is the rule of honor.', user_sig_bbcode_uid = '17f6343d76', user_viewemail = 1, user_aim = 'JKConner85', user_yim = 'sixstringsamuri_01', user_msnm = 'firstname.lastname@example.org', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = -6, user_dateformat = 'd M Y h:i a', user_lang = 'english', user_style = 1, user_email_new_gb = 1, user_active = 1, user_actkey = '' WHERE user_id = 2
Line : 523
File : usercp_register.php
What just happened?
It isn't very simple to do that. Will try to write a mod for it later. At this moment i has not enough time for it.deejaybet wrote:deejaybet wrote:how would i go about making this on a separate page as i am making the profiles have a menu
edit profile > view profile > guestbook
Included in next version.Toho_NL wrote: Is it possible (perpahs for a next version) to only show it to members? Now guests can see / read the guestbooks, but I would like to see an option (don't know whether this is technically possible) that I can disable the guestbook for guests (so that one should register / log-in).
Do you think this is possible?
This is weeman profile guestbook. You can post here message to him.
If you want to delete ALL items, click here.
The cache isn't writeable. Please chmod him to 777!
Your version is uptodate. Your version is 1.0.7. Please visit http://www.phpbb.com/phpBB/viewtopic.ph ... 54#2165954 for the latest info.