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)

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
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

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.

cecdah 07-22-2005 12:22 AM

It was the userpage-plugins.xml right? Not the userpage.xml located in the admincpfolder?

amykhar 07-22-2005 12:36 AM

Right. and if you look in your plugin manager, you should see a plugin for Userpage usercp link

arurcard 07-22-2005 12:42 AM

no help for me? :(

amykhar 07-22-2005 01:25 AM

Quote:

Originally Posted by arurcard
no help for me? :(

Sorry, I missed your question.
Code:

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

As I said before - zap the ".TABLE_PREFIX." I did it for you in the code block above.

arurcard 07-22-2005 01:46 AM

Quote:

Originally Posted by amykhar
Sorry, I missed your question.
Code:

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

As I said before - zap the ".TABLE_PREFIX." I did it for you in the code block above.

thanks

arurcard 07-22-2005 01:48 AM

Error

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 @ 4
STR: ->
SQL: $db->query_write("ALTER TABLE userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ")

SQL-query:

$db->query_write("ALTER TABLE 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 userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0'' at line 1

im using phpmyadmin btw

amykhar 07-22-2005 02:03 AM

Code:

ALTER TABLE userpage ADD rating INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE userpage ADD views INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE userpage ADD numvotes INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE userpage ADD votetotal INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;


arurcard 07-22-2005 02:23 AM

thanks again

arurcard 07-22-2005 02:28 AM

that fixed it works perfectly, excpet i see no link in the user cp

arurcard 07-22-2005 02:49 AM

Also I have a few ideas for your next release.

I see we both use coppermine. I was thinking of having a navigation box like you have on your forum, but only appears on the user's page. They can put whatever links they want in there, but also it has a link to their coppermine image gallery.


Also the ability to create more than one page. Like they can have an option to "add new page" or something (which also adds to the navigation box).

Just a few ideas.


Heres a ++++ty photoshop of my idea http://uploads.drift-forums.com/files/cappyps.jpg

chanhlinh 07-22-2005 04:28 AM

Quote:

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 598
I can not set permission for usergroup :( and how to rebuild bitfields?

Thanks in advanced!
Chanhlinh

Annapurna 07-22-2005 06:53 AM

Quote:

Originally Posted by arurcard
They can put whatever links they want in there, but also it has a link to their coppermine image gallery.
Also the ability to create more than one page. Like they can have an option to "add new page" or something (which also adds to the navigation box).

I also would appreciate this. Multiple pages and the shout box / guestbook should be on an extra page too.
One more thing: Users should be able to delete / alter shouts in their shoutbox, so that there is no need to contact the mods/admins.

Andreas

cecdah 07-22-2005 08:19 AM

I have the pluginlink, but still no link in usercp.

I might go around this by adding a link in the navbar named "Blog", and place submenus with "Users with blog" + Edit blog + create blog

cecdah 07-22-2005 08:22 AM

Quote:

Originally Posted by chanhlinh
I can not set permission for usergroup :( and how to rebuild bitfields?

Thanks in advanced!
Chanhlinh

To rebuid bitfields change the domainname in this link to your domain and paste it into your browser, hit enter and your done.:

http://yourforum.com/forum/admincp/i...buildbitfields

:)

cecdah 07-22-2005 08:31 AM

Quote:

Originally Posted by chanhlinh
I can not set permission for usergroup :( and how to rebuild bitfields?

Thanks in advanced!
Chanhlinh

You have to translate the phrases to your boards mainlanguage.

Go to admincp, languages and phrases, phraseadministration I think (have another translation). Check page by page that every phrase has a translation in your default language.

This worked for me when I couldnt see the alternatives for permissions.

cecdah 07-22-2005 08:48 AM

Amykhar: I finally got it right, deleted the links in pluginpage, and imported the xmlfile fresh!

Everything is working like a charm.

http://72.34.32.133/~hemmelig/forum/...s/lykkelig.gif

chanhlinh 07-22-2005 09:40 AM

Thank you very much. It's done :)

cecdah 07-22-2005 02:44 PM

Personalpagetip for inserting images:

I find no IMG tag in the editbox, but basic html works great.
Like this:
<img src="http://www.swapmeetdave.com/Humor/Blonde.jpg">

:)

amykhar 07-22-2005 02:47 PM

The img tag is there for me. :confused: Which style of editor are you using in your account? I am using the WYSIWYG.

cecdah 07-22-2005 02:52 PM

I am using the WYSIWYG, but no IMG tag.

cecdah 07-22-2005 02:59 PM

:ermm:

amykhar 07-22-2005 03:10 PM

OK. Let me look at the parameters passed into the editor again. BRB.

amykhar 07-22-2005 03:18 PM

Dumb question, does the img tag show up for you on your posting and PM templates? From what I've read in the code, it checks to see if you have img bbcode enabled and then shows the button.

Amy

sabret00the 07-22-2005 03:34 PM

this is a very sweet mod and open to expansion too :)

amykhar 07-22-2005 03:35 PM

Quote:

Originally Posted by sabret00the
this is a very sweet mod and open to expansion too :)

Thank you :)

cecdah 07-22-2005 03:39 PM

Quote:

Originally Posted by amykhar
Dumb question, does the img tag show up for you on your posting and PM templates? From what I've read in the code, it checks to see if you have img bbcode enabled and then shows the button.

Amy

Yes, I naturally thought of that because this is a brand new install of vb. ;)
However, I will check some more before blaiming it on the hack. :)

amykhar 07-22-2005 04:20 PM

Is there anywhere that you don't allow images? signatures, private messages, etc?

arurcard 07-22-2005 06:14 PM

yo amy did you read my ideas? I'm interested to know what you think.

arurcard 07-23-2005 10:55 PM

are you supposed to delete the old plugin before you run the new one?

Dream 07-23-2005 11:18 PM

Quote:

Originally Posted by arurcard
are you supposed to delete the old plugin before you run the new one?

yes, vBulletin doesnt ovewrite plugins


All times are GMT. The time now is 03:32 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.01951 seconds
  • Memory Usage 1,829KB
  • 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
  • (4)bbcode_code_printable
  • (12)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