Give Your Users a Custom Page on Your Site

This Extension for Vbulletin 3.5 offers forum members the ability to create a custom profile page (or pages) on your site.

Current Features

• List of Members with Personal Pages
• Individual Shoutbox/Guestbook on Each User's Personal Page
• An Archive of "Shouts" for Each User
• Moderators Can Delete Offensive Shouts
• Moderators Can Delete Personal Pages
• Users Can Report Offensive Pages
• Tracks Page Views to Each Personal Page
• Indicates When the Page Was Last Updated
• Usergroup based permissions
• Uses the VBulletin Editors. Understands BBCode and HTML.

Planned Features

• Show Users Currently Browsing User Pages
• Allow Users to Have More Than One Page
• Allow Users to Upload Files
• A File Manager for User Pages
• The Ability to Search User Page Content
• Links to Featured User Pages on Forum Home

FAQ

1. How do I configure what forum report threads should go to?
   At the top of userpage.php, there are several clearly documented variables that you can edit. One of these establishes the forumid that you want reported pages to be reported to.

Demonstration
http://www.eaforums.com/forums/userpage.php?do=list
http://www.eaforums.com/forums/userpage/amykhar.html
http://www.eaforums.com/forums/userp...inkerlady.html

Updates: https://vborg.vbsupport.ru/showpost....&postcount=970

-------------
This hack will always be free, however your donations are kindly accepted and will help towards further development. If you donate, please leave me some info (either your forum site or username at vB.org) so that I can thank you.

[waza]

@chris lang:
thx for posting all the fixes together!

[Chris Lang]

Shortly after I posted the list of updates, I had a bit of crisis myself. I was going to update the hack and somehow I managed to DROP all the tables in the database for this hack (tried to overwrite the product, then tried uninstall --- big mistake!).

I want to mention that I'm in no way a 'coder'. There is probably a much easier way of doing this. I'm simply putting down what I found by trial and error and about 8 hours of work:

This will be helpful for people who wish to cleanly uninstall the product if that process has already failed and you're stuck. (Stuck meaning, you're board is down because of missing MYSQL tables and fields brought on by an incomplete uninstall or a upgrade 'gone bad'). I want to mention that unless you had a backup prior to upgrading/re-installing this hack, any existing userpages and shouts are toast.

You will need the following:

A. PHPMYADMIN (Your dedicated box should have this, if not, don't bother reading on). Obviously you need the MYSQL username and password to use this.

B. Downloaded a fresh copy of the vBulletin Software with the same version you are running on your 'live board'

C. Room on your server for another copy of vBulletin.

D. Create a new database for the 'Dev Forum' you're going to set up. (call it 'forum2' if you prefer, but obviously don't use the existing database)

E. Backup your Database. Do it, now. (You didn't originally and that's why you're in this mess, along with me).

In PHPMYADMIN

1. First, Go to PHPMYADMIN and select your existing forum database. Check for the following tables: Userpage_rate, Usershout and Userpage. If any of these are missing, then its likely you've dropped them somehow and you can pretty much kiss them goodbye if you didn't have full backup for your database (like what happened to me!).

Next, go into Table 'usergroup' and see if the field 'userpagepermissions' is present. If it's missing, proceed to step 2.

2. This next step assumes that you have either corrupted, dropped or are otherwise missing some or all of your tables. At this point, you can drop any of the existing tables since the assumption now is that your existing userpages and shouts are gone and you're going for a fresh install/upgrade.

Save yourself some time and just leave PHPMYADMIN running for now.

In your Vbulletin AdminCP:

3. First, disable the Product (don't bother trying to delete it if you've already messed up tables). This will keep your board running. (You may want to take your board 'down' during this process).

2. This is a bit time consuming, but it'll be helpful down the road: Create a 'clean' DEV-Forum for yourself (basically a clean fresh forum install of the version you're running).

3. Install the Product on the new forums and follow the other instructions (rebuild bitfields, phrase edit, etc). Verify that its working normally.

4. Go to PHPMYADMIN (because you left it open, right?) and select the NEW database 'forum2' or whatever you decided to name it. Choose and select one the following three tables (choose 'Browse, or just double click on them in the left-hand listing)

Userpage
Userpage_rate
Usershout

Choose EXPORT and export the table structure to a MYSQL file, select "save" and save it on your desktop or someplace handy (be sure to name the file accordingly, so you can keep track of which one is which). Repeat the process for each table above.

You should now have 3 MYSQL files on your desktop (or someplace handy).

Now, Using PHPMYADMIN, select your OLD forum database and then Click STRUCTURE. The listing of tables will appear. Verify that the 3 tables you're going to import are indeed DROPPED (gone).

Scroll down past the listing in STRUCTURE to the bottom dialog where its asking for a filename to use. Click Browse, select one of your three MYSQL files from your desktop (or your oh-so-handy-place). Import all three files in the same manner. 3 Tables will be created (I know, you're asking about that missing field 'userpagepermissions', we're getting to that).

PROPER UNINSTALLATION:

Now we're going to go back and uninstall the Product on your OLD board correctly. Go into your ADMIN CP, go to your Product Manager and UNINSTALL the product. At this point, the product should uninstall without any issue. If not, you may have missed a table somewhere. The uninstallation will also take care of that pesky 'Userpagepermissions' table, too, if it was in your database.

Now that the product is uninstalled, you're going to simply re-install the product, making sure you're using the latest ZIP version and follow the instructions carefully.

What happened in the above sequences was this; we created blank entries (tables) using a new forum, exported the instructions to create them into 3 MYSQL files, imported them into your old database, ran the uninstall, which can now run properly because it has found all the database entries it needs to to properly uninstall, and then we just re-installed.

Now, that wasn't too bad was it? And you've just learned some things about MYSQL, PHPMYADMIN and you've got a brand-spankin' new DEV forum you can screw up to your heart's content.

Was this helpful? Please let me know!

[NineToez]

For all of you guys that have successfully uninstalled this product, just how did you drop the table and not get your board to crash? If I manually dropped the userpage SQL table and uninstall the product from the AdminCP, the DB still looks for the table and crashes the whole board. Can someone instead of just saying that they did it manually actually help out and recommend how they did it to help those of us that want to uninstall this? Thanks in advance.

[Keyser S?ze]

a quick edit, i would like to make an If statement so that if they dont have a user page this link doesnt show up, but i cant seem to get that to work, so here u go

this adds a link in the postbit menu, (so users viewing a post can use the dropdown to get to the users page)

Find

PHP Code:

<if condition="$post['userid'] AND $show['member']">
    <tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=addlist&amp;userlist=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>
    </if> 


BELOW Add

PHP Code:

<tr><td class="vbmenu_option"><a href="userpage.php?do=main&userid=$post[userid]">View My User Page</a></td></tr> 


u must do this in postbit and postbit_legacy

[djnth]

Anyone know where I could find info on how to do this or who I should ask, I'm hitting a dead end here.

Thanks.

Originally Posted by djnth

Is there a way that I can have one of the user's custom profile fields displayed instead of their user name on the list of user pages?

My userpages are for DJs and I'm using it for DJ Profiles but I would like their DJ Name displayed instead of their user name.

Thanks!!

[Chris Lang]

Originally Posted by NineToez

For all of you guys that have successfully uninstalled this product, just how did you drop the table and not get your board to crash? If I manually dropped the userpage SQL table and uninstall the product from the AdminCP, the DB still looks for the table and crashes the whole board. Can someone instead of just saying that they did it manually actually help out and recommend how they did it to help those of us that want to uninstall this? Thanks in advance.

Nine, the point here is that you probably need to re-install those tables (as mentioned about two posts back) and run the uninstall again. If you manually dropped the tables out you will never get the uninstall to work properly.

The other option is to put the Product on 'disable' and leave it as-is, but I don't recommend this.

[rinkrat]

I just uninstalled this product and now it crashed my board:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM userpage WHERE userid=1;

MySQL Error : Table 'booyah.userpage' doesn't exist
Error Number : 1146
Date : Thursday, March 2nd 2006 @ 05:53:56 PM
Script : http://www.letsgokings.com/bbs/
Referrer :
IP Address : 24.182.38.110
Username : rinkrat
Classname : vb_database




Any help? I'd appreciate it!

[???`S?LV?R???`]

Originally Posted by Chris Lang

In answer to a post, I've put together a list of the important updates, fixes and work-arounds for this hack. These are links to posts in this thread, and obviously if they get edited or deleted, they may not show up. If you've already installed the product from the first page, you can use the following threads to help you sort things out. Although it's not officially part of the Hack, I recommend WAZA'S UPDATE (See Updates Below for the link) which gives you some additional functionality.

That's awesome to see that someone has acted on it, I applaud your effort and helpful nature.

[ImportPassion]

man, if this hack causes all these problems, it should prolly be taken down?

[amykhar]

Every time somebody has complained about not being able to find the table, it's because they didn't install the product. A lot of bug reports have been from people who didn't upload files, didn't follow the install directions and update their bitfields, etc. Not much I can do about operator error unfortunately. The mod has been running since the early betas of 3.5 on my site with no problems other than minor tweaks.

[MissKalunji]

same here

[ImportPassion]

should it not be taken out of beta?

[amykhar]

No. Not yet. There are some things like file uploads that I still want to add to it when I get time.

[Chris Lang]

Originally Posted by rinkrat

I just uninstalled this product and now it crashed my board:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM userpage WHERE userid=1;

MySQL Error : Table 'booyah.userpage' doesn't exist
Error Number : 1146
Date : Thursday, March 2nd 2006 @ 05:53:56 PM
Script : http://www.letsgokings.com/bbs/
Referrer :
IP Address : 24.182.38.110
Username : rinkrat
Classname : vb_database




Any help? I'd appreciate it!

Try following the instructions in this thread:

https://vborg.vbsupport.ru/showpost....&postcount=977

If the product is still installed, you can try DISABLE and see if that temporarily gets your board back. I'm guessing you ran the uninstall and were unsuccessful?

[Chris Lang]

Originally Posted by 7thgenCivic.Com

man, if this hack causes all these problems, it should prolly be taken down?

7th, normally I'd agree, but it IS listed as Beta, so it's obviously not finished yet. Installing a Beta mod comes at your own peril and hopefully people are installing and trying this out on a Dev board and not their 'live forums'