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)

Swedie 03-01-2005 06:05 PM

Quote:

Originally Posted by laeth
http://gothtopic.com/forum/member.php?userid=2

Is there anyway to set how large the tables are? They seem to be larger than what we have the forum set to, and it looks out of place.

Thanks.

Requires registration...

Acido 03-02-2005 05:58 PM

After Upgrade to 3.0.7 i loss the Option (Under Vbulletín Options) "Guestbook / Webpage Preferences" and the hack is not working.

I'm sure that all templates, and files edits are OK. Can you tell me what query i need run again to have this hack working ?

Thanx in advance.

Lizard King 03-02-2005 07:44 PM

Quote:

Originally Posted by Acido
After Upgrade to 3.0.7 i loss the Option (Under Vbullet?n Options) "Guestbook / Webpage Preferences" and the hack is not working.

I'm sure that all templates, and files edits are OK. Can you tell me what query i need run again to have this hack working ?

Thanx in advance.

Run this queries
Code:

INSERT INTO `settinggroup` (grouptitle, displayorder, volatile) VALUES ('guestbookwebpage', 199, 1);

INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('allowguestbook', 'guestbookwebpage', '1', '1', 'yesno', 10, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('allowwebpage', 'guestbookwebpage', '1', '1', 'yesno', 20, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('guestbooksmilies', 'guestbookwebpage', '1', '1', 'yesno', 30, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpageallowvbcode', 'guestbookwebpage', '1', '1', 'yesno', 40, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpageallowhtml', 'guestbookwebpage', '1', '0', 'yesno', 50, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpagesmilies', 'guestbookwebpage', '1', '1', 'yesno', 60, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpagevbcodeorhtml', 'guestbookwebpage', 'vbcode', '1', '<select name=\\"setting[$setting[varname]]\\" tabindex=\\"1\\" class=\\"bginput\\">\n<option value=\\"vbcode\\" " . iif($setting[\'value\']==\'vbcode\',\'selected="selected"\') . ">$vbphrase[wg_vbcode]</option>\n<option value=\\"html\\" " . iif($setting[\'value\']==\'html\',\'selected="selected"\') . ">$vbphrase[wg_html]</option>\n</select>', 70, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('allowedhtmltags', 'guestbookwebpage', '<hr><a><br><b><h1><h2><h3><h4><i><img><li><ol><p><strong><table><tr><td><th><u><ul><font><b><div><center>', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><strong><table><tr><td><th><u><ul><font><b><div><center>', 'textarea', 80, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('webpageadvanced', 'guestbookwebpage', '1', '1', 'yesno', 90, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('gb_notification', 'guestbookwebpage', 'pm', 'pm', '<select name=\\"setting[$setting[varname]]\\" tabindex=\\"1\\" class=\\"bginput\\">\n<option value=\\"no\\" " . iif($setting[\'value\']==\'no\',\'selected="selected"\') . ">$vbphrase[wg_no]</option>\n<option value=\\"pm\\" " . iif($setting[\'value\']==\'pm\',\'selected="selected"\') . ">$vbphrase[wg_sendpm]</option>\n<option value=\\"email\\" " . iif($setting[\'value\']==\'email\',\'selected="selected"\') . ">$vbphrase[wg_sendemail]</option>\n</select>', 100, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('gb_showavatar', 'guestbookwebpage', '1', '0', 'yesno', 110, 0, 1);
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('gb_avatarheight', 'guestbookwebpage', '50', '50', '<input name=\\"setting[gb_avatarheight]\\" size=1 class=\\"bginput\\" value=\\"".$setting[\'value\']."\\">', 120, 0, 1);


Acido 03-02-2005 08:33 PM

That's Work Perfectly.

Thanx Amigo :)

cdoyle 03-05-2005 12:11 AM

I'm trying to install it, and when I run the insert.sql this is the error I get

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL

Does anyone know what I"m doing wrong?

cdoyle 03-05-2005 11:55 PM

Anyone have any ideas why I keep getting that error?

Swedie 03-06-2005 08:20 PM

Quote:

Originally Posted by cdoyle
I'm trying to install it, and when I run the insert.sql this is the error I get


An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL



Does anyone know what I"m doing wrong?

The insert should look like this:
Quote:

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL default '0',
`name` varchar(100) default '',
`description` varchar(255) default '',
`text` text,
`lastupdate` varchar(20) default '',
`bordersize` smallint(6) NOT NULL default '5',
`bordercolor` varchar(10) NOT NULL default '#EDF0FF',
`bgcolor` varchar(10) default '#FFFFFF',
`fontface` varchar(100) NOT NULL default 'Arial, Helvetica',
`fontcolor` varchar(10) NOT NULL default '#000000',
`fontsize` char(3) NOT NULL default '2',
`vbcodeorhtml` varchar(10) NOT NULL default 'vbcode',
`usesmilies` smallint(6) NOT NULL default '1',
`hits` int(11) NOT NULL default '5',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;
What are you running this SQL command through? I hope it is not the vBulletin area.

Swedie 03-06-2005 08:22 PM

I have identified a bug with the current version. If you post a ' (that character) and tries to post anything again in that guestbook it won't enter, so don't do that for now. The new version will have this issue resolved.

I am testing version 1.0.2 on my own site and I'm just collceting a bit more input before releasing it to you all.

cdoyle 03-06-2005 10:22 PM

Ya I was trying to use the admin area, I used myphp and got it to work.

but doh, just noticed your post about hte bug in 1.01.
Hopefully it will be easy to upgrade from 1.0.1 to 1.0.2

thanks again for this hack, it's great!!

Swedie 03-07-2005 09:48 AM

Quote:

Originally Posted by cdoyle
Ya I was trying to use the admin area, I used myphp and got it to work.

but doh, just noticed your post about hte bug in 1.01.
Hopefully it will be easy to upgrade from 1.0.1 to 1.0.2

thanks again for this hack, it's great!!

Yes, very easy. Just a few replacement codes and new templates.


All times are GMT. The time now is 01:14 PM.

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.02187 seconds
  • Memory Usage 1,757KB
  • 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
  • (5)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