vb.org Archive - Give Your Users a Custom Page on Your Site

Page 17 of 136

« First

117

Last »

Show 40 post(s) from this thread on one page

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)

arurcard

07-21-2005 08:27 PM

Quote:

Originally Posted by amykhar

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 ");

great thanks ill let you knowhow it works out

arurcard

07-21-2005 08:28 PM

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 10
STR: ->
SQL: $db->query_write("ALTER TABLE ".TABLE_PREFIX."userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ")

SQL-query:

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

MySQL said: Documentation
#1064 - You have an error in your SQL syntax near '$db->query_write("ALTER TABLE ".TABLE_PREFIX."userpage ADD rating INT( 10 ) UNSI' at line 1

arurcard

07-21-2005 08:31 PM

it seems to work but i seem to have some template screw ups http://forums.drift-forums.com/userpage.php?do=list
yeah now that i look at it theres no user cp link, and the link in their profile causes a db error likey because of the above post

amykhar

07-21-2005 08:47 PM

Quote:

Originally Posted by arurcard

Ron, as I said, you have to alter the table prefix part. You need to get rid of the ".TABLE_PREFIX." in each query and put in the table prefix that you actually use.

Amy

arurcard

07-21-2005 09:27 PM

Quote:

Originally Posted by amykhar

Ron, as I said, you have to alter the table prefix part. You need to get rid of the ".TABLE_PREFIX." in each query and put in the table prefix that you actually use.

Amy

oh yeah lol, whats default?
btw, its Rob

arurcard

07-21-2005 09:48 PM

nvm found it, i dont have one

arurcard

07-21-2005 09:50 PM

ok so if i was to run this queries in phpmyadmin what would i put?

Sovereign

07-21-2005 10:36 PM

The WOL is messed up, I'm shown as "Unknown Location
/vb/userpage.php?do=main&userid=1"...

cecdah

07-21-2005 11:51 PM

I updated and now there are no links in usercpmenu. Tested with a new user, and even the create personal page is gone. The USERCP_SHELL update:

<if condition="$show['createuserpagelink']">
<tr>
<td class="$navclass[signature]" nowrap="nowrap"><a class="smallfont" href="userpage.php?$session[sessionurl]do=create">Create Your Userpage</a></td>
</tr>
</if>
<if condition="$show['edituserpagelink']">
<tr>
<td class="$navclass[signature]" nowrap="nowrap"><a class="smallfont" href="userpage.php?$session[sessionurl]do=edit">Edit Your Userpage</a></td>
</tr>
</if>

is not working. I have gone through the steps and nothing brings new links in the usercp menu.

I can access my personal page via url, and also get a listing via url, have added a link in the navbar using :

<if condition="$show['member']">
<td class="vbmenu_control"><a href="userpage.php?$session[sessionurl]do=list">$vbphrase[users_blog]</a></td>
</if>

, but I dont want both edit and create personal page in my navbar.

How do I add the links to usercp?

amykhar

07-22-2005 12:19 AM

cecdah, did you install the plugin? That sets it up so the links will show in the usercp.

Regarding the who's online I may need to add more locations in the plugin. I'll look into it, Sovereign.

All times are GMT. The time now is 07:38 AM.

Page 17 of 136

« First

117

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02094 seconds Memory Usage 1,746KB 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 (1)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: