vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Give Your Users a Custom Page on Your Site (https://vborg.vbsupport.ru/showthread.php?t=91903)

shiva 07-20-2005 10:35 PM

Okay thanks for the answers. I won't nag either. :)

arurcard 07-20-2005 11:19 PM

I have no link in my profile to create my page, nor any edit links for anyone else's pages. Yes i set the permissions. What'd i miss? :disappointed:

Here is a screen hsot of my page (admin)

http://uploads.drift-forums.com/files/123456.jpg

amykhar 07-20-2005 11:23 PM

I'm not seeing two things on your page. The default phrase that your page isn't created yet and the footer with the create and moderate link.

Did you add all the phrases and templates?

arurcard 07-20-2005 11:24 PM

Quote:

Originally Posted by amykhar
I'm not seeing two things on your page. The default phrase that your page isn't created yet and the footer with the create and moderate link.

Did you add all the phrases and templates?

yes i did

amykhar 07-20-2005 11:34 PM

For the record, you picked a lousy time to do a fresh install. I'm preparing the upgrade as we speak. ;)

Did you change any code in userpage.php?

arurcard 07-20-2005 11:35 PM

Quote:

Originally Posted by amykhar
For the record, you picked a lousy time to do a fresh install. I'm preparing the upgrade as we speak. ;)

Did you change any code in userpage.php?

no i did'nt
What will i have to change to do the upgrade?

Aslo, i saw you on my forums ill add you to a usergroup with permission

amykhar 07-20-2005 11:40 PM

Thank you. I'll try to see what I can see on your site. A lot of phrases are added in the upgrade, and more templates and changes to the old templates. Don't bother editing your existing templates. The new ones should replace them.

arurcard 07-20-2005 11:40 PM

Quote:

Originally Posted by amykhar
Thank you. I'll try to see what I can see on your site. A lot of phrases are added in the upgrade, and more templates and changes to the old templates. Don't bother editing your existing templates. The new ones should replace them.

ok i'll sit tight and wait for the upgrade

amykhar 07-20-2005 11:48 PM

I resolved Rob's problem. He hadn't added all the templates. One was skipped.

arurcard 07-20-2005 11:51 PM

Quote:

Originally Posted by amykhar
I resolved Rob's problem. He hadn't added all the templates. One was skipped.

yeah thanks alot, possible ETA on the upgraded version? Im going to wait for it before i announce the current one on my forum

amykhar 07-21-2005 12:33 AM

I am trying to put together an install script that will work on the darn phrases. There are just too darn many of them to ask y'all to do them manually.

I'll be working throughout the night. Not sure when it will be done.

Amy

Sovereign 07-21-2005 02:31 AM

YAY! Improved hack! Prepares to upgrade!

amykhar 07-21-2005 02:43 AM

OK. I need a couple of brave souls to try out the new upgrade and install scripts before I announce this update to the general world please.

Amy

arurcard 07-21-2005 03:10 AM

Quote:

Originally Posted by amykhar
OK. I need a couple of brave souls to try out the new upgrade and install scripts before I announce this update to the general world please.

Amy

ill try out an install on my test site

arurcard 07-21-2005 04:29 AM

i get a 404 error when i click upgrade and i get the following sql error when i click on user profile (goes with 404)

Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:
SELECT * FROM usershout WHERE ownerid = 1 ORDER BY shoutid DESC LIMIT 5;

MySQL Error : Table 'vb.usershout' doesn't exist
Error Number : 1146
Date : Thursday, July 21st 2005 @ 12:28:28 AM
Script : http://forums.drift-forums.com/userpage.php?userid=1
Referrer : http://forums.drift-forums.com/member.php?u=1
IP Address : 69.152.227.1
Username : Rob
Classname : vb_database

john1744 07-21-2005 05:22 AM

I do not see an option in the Usergroup manager to allow access to the page. When I try to manually access the page: http://www.yoursite.com/forum/userpage.php?userid=1

then it gives me the old, "You do not have permission to access this page" error.

cecdah 07-21-2005 12:01 PM

How do I rebuild/update the bitfields?

cecdah 07-21-2005 12:27 PM

I figured it out. :)

Sovereign 07-21-2005 12:29 PM

The upgrade script (upgradeuserpage.php) calls to installuserpage.php! This was not mentioned in the directions for upgrading, you might want to change that. I get SQL errors because the upgrade script does not install the shout tables, nor does it install some phrases. Thus, I had to do more manual queries! Also, you may want to create a dynamic link that can tell whether a user has a userpage or not. The link is userpage.php?do=create, which causes a DB error if you already have a userpage. Is there a way to tell (maybe based off userpage.php?do=list) whether a user has a page? If they do, display "Edit Userpage," but if they do not, display "Create Userpage?" Other than that, good work!

cecdah 07-21-2005 12:34 PM

Quote:

Originally Posted by Sovereign
The upgrade script (upgradeuserpage.php) calls to installuserpage.php! This was not mentioned in the directions for upgrading, you might want to change that. I get SQL errors because the upgrade script does not install the shout tables. Also, you may want to create a dynamic link that can tell whether a user has a userpage or not. The link is userpage.php?do=create, which causes a DB error if you already have a userpage. Is there a way to tell (maybe based off userpage.php?do=list) whether a user has a page? If they do, display "Edit Userpage," but if they do not, display "Create Userpage?" Other than that, good work!

I was about to ask the same. I cannot edit my personal page after creating it, get a databaseerror. The link points to userpage.php?do=create, which causes a DB error if you already have a userpage. I cannot access my userpage after creating it because there are no link to the personal page exept for this. Furthermore, how to access other members userpages?

Sovereign 07-21-2005 01:02 PM

Oh and one more thing: the installer script is full of duplicate phrases. I don't know why they are there as they cause duplicate key names etc. Like:
Code:


$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', -1, 'kill_userpage', 'Delete This User\'s Page',1 ,'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 1, 'kill_userpage', 'Delete This User\'s Page',1 ,'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', -1, 'shoutbox_archive', 'Shoutbox Archive',1 ,'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 1, 'shoutbox_archive', 'Shoutbox Archive',1 ,'vbulletin')");         
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 1,'page_reported', 'Page Reported', 1, 'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 0, 'page_reported','Page Reported', 1, 'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 1, 'shouts_deleted','Shouts Deleted', 1, 'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 0, 'shouts_deleted','Shouts Deleted', 1, 'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 1, 'shout_posted','Shout Posted', 1, 'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 0, 'shout_posted','Shout Posted', 1, 'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 1, 'page_views','Page Views', 1, 'vbulletin')");
$db->query_write("INSERT INTO ".TABLE_PREFIX."phrase VALUES ('', 0, 'page_views','Page Views', 1, 'vbulletin')");

Every one is duplicated. I have to reinstall cause the upgrade did not work. So for my own sanity I am rewriting the queries in the install script so that I can run them. In addition, the phrase deletion queries in the installer are incomplete, they leave phrases behind!

amykhar 07-21-2005 01:51 PM

ok hold up a bit. Let me fix the upgrade script errors and move on to the other problems.

amykhar 07-21-2005 01:59 PM

Sovereign, the phrases are duplicated for a reason. One is the default language. One is English. They will run as written.

amykhar 07-21-2005 02:01 PM

Quote:

Originally Posted by john1744
I do not see an option in the Usergroup manager to allow access to the page. When I try to manually access the page: http://www.yoursite.com/forum/userpage.php?userid=1

then it gives me the old, "You do not have permission to access this page" error.

There is no access in the usergroup manager to the pages. There will not be because that would require code mods because there are no hooks in the admincp.

Put a link somewhere on your site to the list of personal pages. Where you put the link to the list is up to you.

amykhar 07-21-2005 02:20 PM

Quote:

Originally Posted by cecdah
I was about to ask the same. I cannot edit my personal page after creating it, get a databaseerror. The link points to userpage.php?do=create, which causes a DB error if you already have a userpage. I cannot access my userpage after creating it because there are no link to the personal page exept for this. Furthermore, how to access other members userpages?

I fixed the usercp link so that if you have a page, it shows the edit link. If you don't have a page, it shows the create link.

I fixed the upgrade script and updated the install and upgrade instructions as well.

If you have already installed last night's version, all you need to do is re-import the plugin and make the usercpshell template edit again.

Later today, I will put a wrapper around the query so that if you have already created the page, it won't try to do it again. That will stop that one database error.

john1744 07-21-2005 03:15 PM

Hmm, I must not understand, I cannot access any Userpages, or the list of pages, as it gives me an error that I the admin cannot access the page due to insufficient privelages.

*Goes to install update*

amykhar 07-21-2005 03:26 PM

NO! If you have done a fresh install, don't try to install the update. Hold on a minute and let's try to figure out what you are missing.

john1744 07-21-2005 03:29 PM

haha ok Amy.

john1744 07-21-2005 03:30 PM

I'm really not sure what the deal could be, as it seems the features are all there, and it was a very simple install, I just am not able to access these features.

amykhar 07-21-2005 03:31 PM

Send me a link to your site please. I hate trying to debug in the dark. But, if I had to guess, I'd say you didn't update the bitfields. That would make the usergroup permissions not stick.

amykhar 07-21-2005 04:02 PM

OK. We got John sorted out. :) He forgot to upload bitfield_userpage.xml and set his permissions.

Sovereign 07-21-2005 04:26 PM

Quote:

Originally Posted by amykhar
Sovereign, the phrases are duplicated for a reason. One is the default language. One is English. They will run as written.

I always get "Duplicate Key" even when I uninstalled everything...

amykhar 07-21-2005 04:38 PM

If you have a problem with them, just zap one instance.

Amy

Sovereign 07-21-2005 04:42 PM

I did, I know what you're doing (languages) but MySQL on my server keeps whining about duplicate keys.

amykhar 07-21-2005 04:45 PM

Quote:

Originally Posted by Sovereign
I did, I know what you're doing (languages) but MySQL on my server keeps whining about duplicate keys.

In the next release, I'll just stick with the default language.

Amy

arurcard 07-21-2005 08:02 PM

When i get to the upgrade i get to the step "The next step is to perform the necessary queries." I click proceed and get a 404 not found.

amykhar 07-21-2005 08:06 PM

Quote:

Originally Posted by arurcard
When i get to the upgrade i get to the step "The next step is to perform the necessary queries." I click proceed and get a 404 not found.

Redownload the zip. Get the update script, upload it and run it again with do=queries

arurcard 07-21-2005 08:12 PM

found the problem, it goes to upgraduserpage.php instead of upgradeuserpage.php

arurcard 07-21-2005 08:15 PM

Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:
ALTER TABLE usergroup ADD userpagepermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'userpagepermissions'
Error Number : 1060
Date : Thursday, July 21st 2005 @ 04:14:55 PM
Script : http://forums.drift-forums.com/admin...aduserpage.php
Referrer : http://forums.drift-forums.com/admin...deuserpage.php
IP Address : 69.153.2.97
Username : Rob
Classname : vb_database








amy help!1

amykhar 07-21-2005 08:26 PM

No problem. You already ran that query. Just skip it. Do these manually and you're done. Fix the table prefix part, of course, before you run them. I'm updating the zip now.

Code:

       
      $db->query_write("ALTER TABLE ".TABLE_PREFIX."userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ");
      $db->query_write("ALTER TABLE ".TABLE_PREFIX."userpage ADD views INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ");
      $db->query_write("ALTER TABLE ".TABLE_PREFIX."userpage ADD numvotes INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ");
      $db->query_write("ALTER TABLE ".TABLE_PREFIX."userpage ADD votetotal INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ");



All times are GMT. The time now is 03:31 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01769 seconds
  • Memory Usage 1,831KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete