[ABD] Profile Control Panel

[JustinS]

here's a link to the mod.
http://www.phpbbhacks.com/download/3270
Also, I don't know if you can, but could you tell me if I set those tables up correctly?

in phpbb_config:
registration_status; char(0)
registration_closed; text

edit: the command in the .txt document for it is:
#
#-----[ SQL ]----------------------------------------------
#

INSERT INTO `phpbb_config` VALUES ('registration_status', '0');
INSERT INTO `phpbb_config` VALUES ('registration_closed', '');

Also, I'd pretty much prefer to have to activate all new members before their accounts become valid. It makes it easier for me, and I can limit the permission forms that I'll have to give out.

[Riamus]

I take it you never got any feedback on this?
This mod is nice but the developer has flown the coop its totaly unsupported except by people trying to help, but many don't understand the coding model used and its not documented.

By the way, I have never been able to get changes to map definitions made in ACP to 'stick' and I installed this by hand.

Nope, no feedback on it. Oh well.

I used to get all that to stick when I installed previously using easymod 0.1.3 (I think that was it)... but I had to reset up my board after the host died and I used 0.2.0a to install everything. Now, I can't get various things to stick. For example, I can't manage to change my online time mod in Configuration... it just never sets. Hm...

[MrDSL]

My problems revolve around not being able to make changes in my maps definitions from the ACP.

Have you done this from the install file?

Code: Select all

##	_________________________________________________________________________________________
##
##
##	  / \
##	 / ! \	The next CHMODs are required to allow the editing of the mentioned files by the ACP tools
##	/_____\
##
##
##	CHMOD 666 to apply :
##
##		profilcp/def/def_userfields.php
##		profilcp/def/def_usermaps.php
##
##	COPY to each of your language installed directories (ie: languages/lang_english/) and
##	CHMOD 666 those files :
##		COPY mod-lang_settings/lang_extend.php TO language/lang_*/lang_extend.php
##
############################################################## 

[MrDSL]

here's a link to the mod.
http://www.phpbbhacks.com/download/3270
Also, I don't know if you can, but could you tell me if I set those tables up correctly?

in phpbb_config:
registration_status; char(0)
registration_closed; text

edit: the command in the .txt document for it is:
#
#-----[ SQL ]----------------------------------------------
#

INSERT INTO `phpbb_config` VALUES ('registration_status', '0');
INSERT INTO `phpbb_config` VALUES ('registration_closed', '');

Also, I'd pretty much prefer to have to activate all new members before their accounts become valid. It makes it easier for me, and I can limit the permission forms that I'll have to give out.

Open profilcp/profilcp_register.php

FIND

Code: Select all

$unhtml_specialchars_match = array('#>#', '#<#', '#"#', '#&#');
$unhtml_specialchars_replace = array('>', '<', '"', '&');

AFTER ADD

Code: Select all

// BEGIN Disable Registration MOD
if( $board_config['registration_status'] && !$userdata['session_logged_in'] )
{
  if( $board_config['registration_closed'] == '' )
  {
    message_die(GENERAL_MESSAGE, 'registration_status', 'Information');
  }
  else
  {
    message_die(GENERAL_MESSAGE, $board_config['registration_closed'], 'Information'); 
  }  
}
// END Disable Registration MOD

That should work..

[allanhardy]

In regards to the Last Visit thing,

In research it appears that the intent of the Last Visit was data for the member to look at to see when they were last there. Hence it appears to us as one behind.

(as opposed us wanting to look at and see when they were last there when we would want it to be the very last)

It makes sense perhaps Im just not explaining it well,

I found this mod which seems to add a last login field with up to date info.
I have not yet installed or tested and may not get to it for a wekk since I'm about to do vacation.

http://ggweb-fr.com/download/phpbb/addo ... cp-101.zip

[Riamus]

MrDSL -- Thanks. That was it. I knew I forgot to do something.

[tlavery]

Well, it appears that I solved my problem. I deleted the table php_buddy and altered the SQL query I was supposed to run to show the new table name as buddy instead of php_buddy and it WORKS!! WOO HOO!! Thanks so much for everyone's help!!

Edit:

I came across one bug. When I try and delete any pm's in the in box, out box, sent box, or saved box I get a General Error "Invalid_session". I get the same error when trying to send a PM too. Any ideas??

Well, I logged out and back in and now it seems to be working just fine.

I am afraid this is not correct, as this will make you change a lot of codes from the files provided by PCP. to avoid this, just expend the time in SQL. (make sure you know what you are doing and what needs to be drop off, if not dont bother, as it can mess up badly)

Go back to SQL and create the phpbb_buddy again and drop of those you did b4.

Like this

Code: Select all

CREATE TABLE phpbb3_buddy ( 
  user_id mediumint(8) NOT NULL default '0', 
  buddy_id mediumint(8) NOT NULL default '0', 
  buddy_ignore tinyint(1) NOT NULL default '0', 
  buddy_visible tinyint(1) NOT NULL default '0', 
  PRIMARY KEY  (user_id, buddy_id) 
) TYPE=MyISAM; 

In order to make the phpbb3_users one, use the phpbb_buddy as an example:

Code: Select all

CREATE TABLE phpbb3_users (
  ADD user_realname VARCHAR(25) NOT NULL; 
  ADD user_gender TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL; 
  ADD user_birthday VARCHAR(8) DEFAULT '0' NOT NULL; 
  ADD user_last_birthday INT(11) UNSIGNED DEFAULT '0' NOT NULL; 
  ADD user_home_phone VARCHAR(20); 
  ADD user_home_fax VARCHAR(20); 
  ADD user_work_phone VARCHAR(20); 
  ADD user_work_fax VARCHAR(20); 
  ADD user_cellular VARCHAR(20); 
  ADD user_pager VARCHAR(20); 
  ADD user_summer_time TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL; 
  ADD user_list_option VARCHAR(255); 
  ADD user_allow_email TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_allow_website TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_allow_messanger TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_allow_real TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_allow_sig TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewpm TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewwebsite TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewmessanger TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewreal TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewavatar TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewsig TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_viewimg TINYINT(1) DEFAULT '1' NOT NULL; 
  ADD user_buddy_friend_display TINYINT(1) DEFAULT '1'; 
  ADD user_buddy_ignore_display TINYINT(1) DEFAULT '1'; 
  ADD user_buddy_friend_of_display TINYINT(1) DEFAULT '1'; 
  ADD user_buddy_ignored_by_display TINYINT(1) DEFAULT '1'; 
  ADD user_watched_topics_per_page SMALLINT(3) DEFAULT '15'; 
  ADD user_privmsgs_per_page SMALLINT(3) DEFAULT '5'; 

Last but not least for the last two sessions

Code: Select all

CREATE TABLE phpbb3_ranks (
   ADD rank_title VARCHAR(255) NOT NULL; 
   ADD rank_max MEDIUMINT(8) NOT NULL AFTER rank_min;

Code: Select all

CREATE TABLE phpbb3_sessions (
   ADD session_robot VARCHAR(32);

Dont forget to check if your SQL is running as phpbb_ (version 1 or 2 or 3) I assume yours at moment is phpbb3.

i am not sure why you dont have phpbb_users, but never mind. This will definately do the trick.

OK I'm not sure why I am having such a problem. I tried to create the php_rank, php_users, and php_sessions, but everytime I got an error. I'm not sure why you want the 3 in there. I have 3 databases. The one for the ghost board happens to be named dishinstallers_net_-_phpbb3.

I tried to add all the tables as you suggested and got these errors:

Code: Select all

SQL-query: 

CREATE TABLE phpbb_users(

ADD user_realname VARCHAR( 25 ) NOT NULL 

MySQL said:  

#1064 - You have an error in your SQL syntax near 'ADD user_realname VARCHAR(25) NOT NULL' at line 2

Code: Select all

SQL-query: 

CREATE TABLE phpbb_ranks(

ADD rank_title VARCHAR( 255 ) NOT NULL 

MySQL said:  

#1064 - You have an error in your SQL syntax near 'ADD rank_title VARCHAR(255) NOT NULL' at line 2 

Code: Select all

SQL-query: 

CREATE TABLE phpbb_sessions(

ADD session_robot VARCHAR( 32 ) 

MySQL said:  

#1064 - You have an error in your SQL syntax near 'ADD session_robot VARCHAR(32)' at line 2 

I have the phpbb3_buddy table installed and I deleted the table named buddy. But now I get this error:

Code: Select all

General Error 
  
Could not obtain buddys information.

DEBUG MODE

SQL Error : 1146 Table 'dishinstallers_net_-_phpbb3.buddy' doesn't exist

SELECT * FROM buddy WHERE user_id=3 and buddy_id in (3)

Line : 216
File : page_header.php 
 

It looks like it is looking for a table named buddy not php3_buddy......What do you suggest at this point? I reinstalled the table named buddy and it seems to work fine, but I guess maybe I am missing something. I have tried to use this MOD and don't see any errors as of yet. I have no idea what to do at this point. Any suggestions?

[ninosportif]

lol tvalry,

Ok seems you cant copy and paste in... so do it manually...

are you using phpmyadmin or something else to make your SQL?

all you need to do is create a phpbb_users
Then inside phpbb_users, create a field. copy and paste the name like this (depends what you using:

'user_realname'
Follow scroll down into 'VARCHAR'
Follow scroll down into 'NOT NUll'
Input in Default '0'

This is how you input it manually one field by one.

the reason you receive this kind of error is because the SQL files aren't parsing properly.

I know if you use buddy and create those field in would work, though but i am pretty sure this is not correct at all... and it may cause you later not be able for users to edit their profile properly.

[tlavery]

OK I added all the tables with the php_ prefix. I have some questions.....the default in the NULL column was NOT NULL, but some of the lines did not specify NULL or NOT NULL. Should I just leave it at NOT NULL???

Now am I supposed to delete the entries that were made in Users, Sessions, Ranks, and the entire Buddy table? The Sessions section of the SQL changes said that it was supposed to change one and add one (with a specification on where it was supposed to go.) So I am not really sure what to do about the table sessions.

Now what?

[mjatas]

someone help me I still have a blank main page!!!!!!!!
www.obseti.com/phpBB2 or www.speedcore.info

[egingell]

This mod is far from user friendly in adding and removing fields.

[mjatas]

that's why a lot of people are having trouble with it.

[ninosportif]

hehehe

Well, its quite time consuming, but the author did explain everything clearly there. just abit more practice that will do the trick.

Anyway, you will need to manually add the SQL, as EM of any version, would not be able t create or alter those tables.

Also dont forget to CHMOD those files mention at the start of the install.txt. This is important as this is needed to when a user change their profile.

[songdove]

This may have been asked before, with over 150 pages I wasn't going to read through them all however.

I want to add the usual basic ranking to my phpbb2, however I noticed that with PCP installed, the rank I created doesn't show up. How do I get PCP to show the ranks, or get the ranks plugged back into the showtopic file?

I noticed that PCP appears to make use of positional rank colors, such as user/mod/admin/board founder, and those are welcome to stay. But I'd like to use post ranking too.

[tlavery]

OK I added all the tables with the php_ prefix. I have some questions.....the default in the NULL column was NOT NULL, but some of the lines did not specify NULL or NOT NULL. Should I just leave it at NOT NULL???

Now am I supposed to delete the entries that were made in Users, Sessions, Ranks, and the entire Buddy table? The Sessions section of the SQL changes said that it was supposed to change one and add one (with a specification on where it was supposed to go.) So I am not really sure what to do about the table sessions.

Now what?

I wanted to add this....I haven't done anything since I posted this and someone went to check out the site with this mod and said that they got an error about the sessions table when they tried to send a PM.

Also I never got an answer about what the heck a chmod is? I haven't done that part of the install because I don't know what it is

Thanks so much for the help!!