vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Webpage & Guestbook Script (https://vborg.vbsupport.ru/showthread.php?t=71065)

cdoyle 03-18-2005 10:13 PM

Quote:

Originally Posted by Swedie
Okay I am done with the admin edit feature. It is very simple, but it does its job. Nothing more. It is raw format edit. So this means you do not have the vBcode functions. It is not ment for admins to construct webpages while editing pages anyways. :)

I've named the feature "Quick Edit" and it is accessable straigth from the member's webpage (clickable button below page).

I'm not seeing this button, on my own page I made, or anyone elses?

any ideas?

Chris.

Flow Fusion 03-19-2005 05:04 AM

help...
I need to know how can I uninstall Table 'user_guestbook' already exists
Cause I need to remove and reinstall this hack.
Quote:

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Administrators',
description = '',
usertitle = 'Administrator',
opentag = '',
closetag = '',
passwordexpires = '180',
passwordhistory = '360',
canhaveguestbook = '1',
canhavewebpage = '1',
canviewguestbook = '1',
canviewwebpage = '1',
canpostguestbook = '1',
shoutmaxdaily = '0',
shouthierarchy = '1',
attachlimit = '0',
avatarmaxwidth = '120',
avatarmaxheight = '120',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '200',
pmsendmax = '0',
forumpermissions = '393215',
pmpermissions = '2',
calendarpermissions = '31',
wolpermissions = '31',
adminpermissions = '3',
genericpermissions = '5504959',
genericoptions = '31',
journalpermissions = '2047',
awrequest = '1',
shoutboxpermissions = '1023'
WHERE usergroupid=6
mysql error: Unknown column 'canhaveguestbook' in 'field list'

mysql error number: 1054

Date: Friday 18th of March 2005 10:50:36 PM
Script: http://giftedsouls.com/gs/admincp/usergroup.php
Referer: http://giftedsouls.com/gs/admincp/us...&usergroupid=6
Username: Flow Fusion

Lizard King 03-19-2005 11:57 AM

If you are planning to reinstall you have to drop both user_webpage and user_guestbook tables. If you have phpmyadmin just login to it select the table user_webpage and drop the table and then select user_guestbook and drop that also.
Before the installation process be sure to check your phrases. If you have all the phrases then remove all the INSERT INTO `phrase` from insert.sql before running it.

Flow Fusion 03-19-2005 02:38 PM

Quote:

Originally Posted by Lizard King
Before the installation process be sure to check your phrases. If you have all the phrases then remove all the INSERT INTO `phrase` from insert.sql before running it.

How do I do that?

Ok I dropped the tables now first off do I have to remove all of the phrases? And will the same error message occur cause I don't think the insert.iql file added the tables canviewwebpages and the canviewguestbook tables before.

Lizard King 03-19-2005 03:06 PM

Quote:

Originally Posted by Flow Fusion
How do I do that?

Ok I dropped the tables now first off do I have to remove all of the phrases? And will the same error message occur cause I don't think the insert.iql file added the tables canviewwebpages and the canviewguestbook tables before.

If you didn't remove the phrases just run the attached install.sql

Flow Fusion 03-19-2005 03:35 PM

Quote:

Error

SQL-query+:+


CREATE TABLE `user_guestbook` (
`userid` varchar( 100 ) NOT NULL default '',
`name` varchar( 100 ) default '',
`lastentry` varchar( 20 ) default '',
`status` char( 3 ) NOT NULL default 'on',
`usesmilies` smallint( 6 ) NOT NULL default '2',
`position` varchar( 10 ) NOT NULL default 'right',
`notification` varchar( 10 ) NOT NULL default 'no',
`showavatar` smallint( 6 ) NOT NULL default '0',
`text` text,
PRIMARY KEY ( `userid` )
) TYPE = MYISAM


MySQL said:


Table 'user_guestbook' already exists

Back
I tried to find it but I saw too many matches.

Flow Fusion 03-19-2005 07:40 PM

I figured it out. It was I had to add

'canpostownusernotes' => 32768,
'canpostothersusernotes' => 65536,
'caneditownusernotes' => 131072,
'canhaveguestbook' => 262144,
'canhavewebpage' => 524288,
'canviewwebpage' => 1045876,
'canviewguestbook' => 2097152,
'canpostguestbook' => 4194304,
'canseehiddencustomfields' => 8388608,

And do the math accordingly. Clicks install and thanks!

Someone needs to mention this in the first post.

Jag 03-20-2005 06:54 AM

You might want to make a mention that you have to edit the SQL file if you have a table prefix set.

Other than that, installed with no problems. :)

http://forums.4-jag.com/member.php?u=1

* Clicks Install

cdoyle 03-20-2005 02:17 PM

I still can't find the edit page button, but I do have another question/request.

Since most of our members most likely don't have a host for pictures for their pages. Is there anyway, that this hack could utilize the picture attachment feature of Vboard, to let them upload a photo to use on their page?

Thanks
Chris.

Nordinho 03-20-2005 05:40 PM

Quote:

Originally Posted by cdoyle
I still can't find the edit page button, but I do have another question/request.

Since most of our members most likely don't have a host for pictures for their pages. Is there anyway, that this hack could utilize the picture attachment feature of Vboard, to let them upload a photo to use on their page?

Thanks
Chris.

I would like to see that feature as well...


All times are GMT. The time now is 05:27 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.02424 seconds
  • Memory Usage 1,747KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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