[05/02/07] Profile guestbook

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Post Reply

Rating:

Excellent!
17
59%
Very Good
8
28%
Good
3
10%
Fair
1
3%
Poor
0
No votes
 
Total votes: 29

User avatar
noth
Registered User
Posts: 2487
Joined: Fri Jan 07, 2005 7:10 pm
Location: North Surrey
Contact:

Post by noth »

paul999 wrote: @For that weird chars, does they stands in usercp_register.php or profile_add_body.tpl?


there is no trace of them in either and yet they have just appeared top left of the profile edit page :x

well apart from that I must say this guest book mod is very good

your english may be a little off Paul but your programming is most definitely full on !! congratulations on such a great achievement :D
User avatar
noth
Registered User
Posts: 2487
Joined: Fri Jan 07, 2005 7:10 pm
Location: North Surrey
Contact:

Post by noth »

whoops double post, please remove
Last edited by noth on Sun Jul 09, 2006 2:20 pm, edited 1 time in total.
User avatar
noth
Registered User
Posts: 2487
Joined: Fri Jan 07, 2005 7:10 pm
Location: North Surrey
Contact:

Post by noth »

whoops double post, please remove
Last edited by noth on Sun Jul 09, 2006 2:20 pm, edited 1 time in total.
User avatar
noth
Registered User
Posts: 2487
Joined: Fri Jan 07, 2005 7:10 pm
Location: North Surrey
Contact:

Post by noth »

whoops double post, please remove
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26730
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Post by Paul »

double and triple post you mean :lol:
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development
smedia
Registered User
Posts: 45
Joined: Sat May 27, 2006 5:53 am

Post by smedia »

i created the tables... now...

how do you do this?

INSERT INTO `phpbb_profile_guestbook` VALUES (1, 2, 2, 'dd7850a9d8', 1119444611, 'Test message', 'If you see this, it works :D','');
ALTER TABLE `phpbb_users` ADD `user_email_new_gb` TINYINT( 1 ) DEFAULT '1' NOT NULL;
ALTER TABLE `phpbb_users` ADD `user_can_gb` TINYINT( 1 ) DEFAULT '1' NOT NULL;
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('allow_guests_gb', '1');
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('gb_posts', '500');
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('gb_quick', '1');
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26730
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Post by Paul »

Run it in phpmyadmin :) (Tab SQL at the top of the page)
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development
smedia
Registered User
Posts: 45
Joined: Sat May 27, 2006 5:53 am

Post by smedia »

so i change....

SELECT * FROM `phpbb_config` WHERE 1

to...

INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('allow_guests_gb', '1');

?
smedia
Registered User
Posts: 45
Joined: Sat May 27, 2006 5:53 am

Post by smedia »

do I just delete

SELECT * FROM `phpbb_config` WHERE 1

and put the other stuff in?
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26730
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Post by Paul »

Yes, you delete that SELECT * from that textfield, and paste all other querys there. Then you press start.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development
smedia
Registered User
Posts: 45
Joined: Sat May 27, 2006 5:53 am

Post by smedia »

I did everything except add this stuff...

because I dont know how
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('allow_guests_gb', '1');
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('gb_posts', '500');
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('gb_quick', '1');



Everything seems to work prefect except this is what I get when I view the profile...
The cache isn't writeable. Please chmod him to 777!
Your version is NOT uptodate. Your version is 0.0.10, the newest version is 1.0.7. Please visit http://www.phpbb.com/phpBB/viewtopic.ph ... 54#2165954 for the latest info.
smedia
Registered User
Posts: 45
Joined: Sat May 27, 2006 5:53 am

Post by smedia »

this is what I get when I try to put this into the SQL
INSERT INTO `phpbb_profile_guestbook` VALUES (1, 2, 2, 'dd7850a9d8', 1119444611, 'Test message', 'If you see this, it works :D','');


I know I didnt already put it in so what happened?

Error

SQL query:

INSERT INTO `phpbb_profile_guestbook`
VALUES ( 1, 2, 2, 'dd7850a9d8', 1119444611, 'Test message', 'If you see this, it works :D', '' ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26730
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Post by Paul »

smedia wrote: I did everything except add this stuff...

because I dont know how
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('allow_guests_gb', '1');
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('gb_posts', '500');
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('gb_quick', '1');



Everything seems to work prefect except this is what I get when I view the profile...
The cache isn't writeable. Please chmod him to 777!
Your version is NOT uptodate. Your version is 0.0.10, the newest version is 1.0.7. Please visit http://www.phpbb.com/phpBB/viewtopic.ph ... 54#2165954 for the latest info.
Also add it to the SQL tab, and press start :). For the wrong versionumber, see first page. For the cache problem, see page before the :)
smedia wrote: this is what I get when I try to put this into the SQL
INSERT INTO `phpbb_profile_guestbook` VALUES (1, 2, 2, 'dd7850a9d8', 1119444611, 'Test message', 'If you see this, it works :D','');


I know I didnt already put it in so what happened?

Error

SQL query:

INSERT INTO `phpbb_profile_guestbook`
VALUES ( 1, 2, 2, 'dd7850a9d8', 1119444611, 'Test message', 'If you see this, it works :D', '' ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1
Then it is already in that table, you can skip that entry.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development
smedia
Registered User
Posts: 45
Joined: Sat May 27, 2006 5:53 am

Post by smedia »

ok thanks a ton for your time.

However, it is still saying the version i installed it outdated even though it is not. Is this a known problem than can be fixed?

Also, where can I find the file where I can change the appearance of the comments that are posted in the profile... or is that simply just the posting_body.tpl?
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26730
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Post by Paul »

Thats a known bug, see first page for fix :).
For the template file, thats is: gb_view.tpl :) (Posting is gb_post.tpl)
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development
Post Reply

Return to “[2.0.x] MOD Database Releases”