[MOD DB][2.0.6-2.0.4] Profile Control Panel v 2.0.0

morpheus2matrix · Post by **morpheus2matrix** » Wed Dec 10, 2003 3:28 pm

Foulplay wrote: Are you saying go back through includes/functions.php and check the modifications I have made are correct according to the instructions?

Yes, it is what he want to say

Foulplay · Post by **Foulplay** » Wed Dec 10, 2003 3:33 pm

That seems to have done the trick.
Now the forum is working again but.....

I have to use the SubSilver template for everything to work.
Is there a way to get this new mod working with the Vereor Men In Black template?

Thanks for all the help so far.

FP.

morpheus2matrix · Post by **morpheus2matrix** » Wed Dec 10, 2003 4:34 pm

Foulplay wrote: Is there a way to get this new mod working with the Vereor Men In Black template?

you will need to modify the files of this template according to the installation file

Foulplay · Post by **Foulplay** » Wed Dec 10, 2003 4:38 pm

The mod kit includes the following files.

templates/subSilver/admin/*.tpl
templates/subSilver/profilcp/*.tpl
templates/subSilver/images/*.gif
templates/subSilver/images/lang_english/*.gif
templates/subSilver/images/profilcp/*.gif

Am I wrong to think these files will not work with the Vereor MIB template?

Foulplay · Post by **Foulplay** » Thu Dec 11, 2003 11:18 am

I don't see anyway of using this mod for the vereor Men In Black template.
Can anyone advise please? Or do I just need to stay with SubSilver?

Also, please can somone explain how to use this PCP. I need to add a new field in the profiles. It needs to be a mandatory field and the information needs to be displayed on the forum just below each user's avatar.

Thanks again,

Lee.

Ptirhiik · Post by **Ptirhiik** » Thu Dec 11, 2003 11:24 am

Check the demo board, there is a special forums for PCP tutorials.

Foulplay · Post by **Foulplay** » Thu Dec 11, 2003 12:01 pm

OK, will do.

Any advice on the MIB template question?

Cheers,

Lee.

playerfr · Post by **playerfr** » Thu Dec 11, 2003 12:43 pm

you just install it as advise in the Installation Guide, Just when they say to modify the Template file of subliver , instead of subliver you modify MIB tpl's. Same thing when copying files to template folder.

Foulplay · Post by **Foulplay** » Thu Dec 11, 2003 12:49 pm

Problem is,

Where it says find (for example)
[ {L_WHOSONLINE_ADMIN} ]   [ {L_WHOSONLINE_MOD} ]

That line doesn't exist in the MIB equivalent TPL.

Foulplay · Post by **Foulplay** » Thu Dec 11, 2003 5:28 pm

I've been working through the tutorial and getting an idea of how to use the PCP.

Now I've tried deleting the user_birthday field from the fields list and as a result, I'm now getting all kinds of "cannot find" errors when I go to the forum.

(see below)

Could not read user table to get birthday today info

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_birthday' in 'where clause'

SELECT u.*, (CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore, (CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend, (CASE WHEN b.buddy_visible = 1 THEN 1 ELSE 0 END) AS user_visible FROM ((phpbb_users AS u LEFT JOIN phpbb_buddy AS b ON b.user_id=u.user_id AND b.buddy_id=3) LEFT JOIN phpbb_buddy AS i ON i.user_id=3 AND i.buddy_id=u.user_id) WHERE u.user_id <> -1 AND u.user_birthday <> 0 AND u.user_birthday <> '' and RIGHT(u.user_birthday, 4) = 1211 ORDER BY username

Line : 691
File : /homepages/16/d67038748/htdocs/wsc67038743/PHP_BB/includes/page_header.php
???

Ptirhiik · Post by **Ptirhiik** » Thu Dec 11, 2003 5:32 pm

You have to clean up from page_header the references to this field, as it is used outside the maps to display the today's birthdays.

Foulplay · Post by **Foulplay** » Thu Dec 11, 2003 5:38 pm

I just ran the SQL "birthday" queries again in the mod.

Thanks anyway.

Foulplay · Post by **Foulplay** » Thu Dec 11, 2003 7:06 pm

I thought I could delete an entire map to remove the "buddy" references.
Now when I go to the memberlist, I get the following message.

Could not read user informations

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7

SELECT DISTINCT
u.*

FROM (
phpbb_users AS u)
WHERE u.user_id <> -1
ORDER BY

Line : 906
File : /homepages/16/d67038748/htdocs/wsc67038743/PHP_BB/profilcp/profilcp_buddy.php

How can I fix this?

Sorry to be such a pain, I'm still learning.

Ptirhiik · Post by **Ptirhiik** » Fri Dec 12, 2003 1:07 am

There also you are trying to remove functionalities that are used elsewhere than in the PCP. If you want to remove the buddy list (it will also emove the member list by the way, as it is a member list), you just have to delete the profilcp_buddy.php.

Foulplay · Post by **Foulplay** » Fri Dec 12, 2003 9:11 am

Is there a way for me to restore the memberlist, but lose all of the "buddy" references?

Lee.