vb.org Archive - Webpage & Guestbook Script

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)

Quote:

Originally Posted by shortbus1662

the prefix is ostatesp_forum

Where are the experts when you need them? :rolleyes:

I'm not sure, but could your table prefix actually be ostatespnotostatesp_forum (it just seems like a rather odd prefix to me, butI'm no expert). If you go into your phpMyadmin, and look at the list oftables on the left, you'll see the name of the table you need to use inthequeries. For example, my test forum has the table prefix tvb3. So myphrase table is actually tvb3_phrase. Therefore, in the queries itwould look like:

Code:

DELETE FROM `tvb3_phrase`WHEREvarname= 'setting_allowguestbook_desc';

Am I making sense? Sobasically, in phpmyadmin, look for the phrase table, make a note ofwhat it's called and do a search replace on the insert.sql filereplacing phrase with yourprefix_phrase, (do the same for thesettingtable and the settinggroup table) save and re-run. (sorry I'mterrible at explaining things)

ostatesp_forum is the name of my database.

tables in that database are user_guestbook and user_webpage

all the other ones are vb_

that's all I know. I know nothing :disappointed:

help!

i am upgrading from 3.0.6 to 3.0.7 and when i try to run upgrade.sql i get the following error:

Code:

 SQL-query:



ALTER TABLE user_webpage DROP usevbcode



MySQL said: Documentation

#1091 - Can't DROP 'usevbcode'. Check that column/key exists

everything worked fine in 306. any reason i am getting this error?

thanks

do i have to re-install (run insert.sql) this and if so, will the previous data(webapges and guestbooks) remain?

I just upgraded to 3.0.7 and after the upgrade I just run the following queries and saved any guestbook phrases and now it is working again.

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

Working with 3.0.7

Quote:

Originally Posted by Oreamnos

do i have to re-install (run insert.sql) this and if so, will the previous data(webapges and guestbooks) remain?

If you didn't delete all guesbook and webpages data from your database then you dont have to re run the install.sql. Just make all the file edits and then run the queries I paste the previous post save any guestbook phrase , check your usergroup permissions and save them. After that you shall have the mod working again.

cool, thanks! up and running again in 3.0.7 :)

any know when comes new version with installer?

Is there anyway that I could make the webpage show up standalone? Such as the profile having a link to their webpage, then webpage.php?memberid=x would display their webpage and guestbook? That would make it much cleaner on their profile, then members could use the webpage as their "homepage" on the web :) If it hasn't been done yet, I'm sure I could do it. It would just take me a while, no its not that I'm lazy its just that I'm checking to see if its been done yet. ;)

Quote:

Originally Posted by Creed

That is something I am looking for if you will code it I may want to make some of the tests ;)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02324 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 (3)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: