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)

Lionel 10-31-2004 06:52 PM

Some experience huh?

Swedie 10-31-2004 06:56 PM

StarBug, if he had not done that it would not show up at all. It has to do with the phrase not showing up for some weird reason.

StarBuG 10-31-2004 07:17 PM

Quote:

Originally Posted by Swedie
StarBug, if he had not done that it would not show up at all. It has to do with the phrase not showing up for some weird reason.

Na his problem was different.

Quote:

Originally Posted by rex_b
I don't even see the radio buttons. :(

I am no real phrase expert but I think you need to atleast add the phrase line twice like this:

INSERT INTO `phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'can_use_guestbook', 'Can use Guestbook?', 3);
INSERT INTO `phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'can_use_guestbook', 'Can use Guestbook?', 3);

Cause the problem is when you edit a phrase you have two boxes for text
(I have 2 languages installed so I have three. I don?t know if forums with only one laguage have the second box called "English (US) Translation") and you only enter the phrase text in the "Custom Phrase" field ( languageid = 0).
You need to add languageid = 1 also

His problem was the wrong location of:
Quote:

print_yes_no_row($vbphrase['can_use_guestbook'], 'usergroup[canuseguestbook]', $ug_bitfield['canuseguestbook']);
print_yes_no_row($vbphrase['can_use_webpage'], 'usergroup[canusewebpage]', $ug_bitfield['canusewebpage']);
If a user has a modified usergroup.php your line description for where to insert the code above doesn?t fit! And because the search text can be found in multiple places it?s easy to put the code in the wrong place.
That is why naming lines is not the way to use in install instructions ;)

He Propably put the code below
Quote:

if ($usergroupid > 7 OR $_REQUEST['do'] == 'add')
and above the "print_table_break();"

Greetings

StarBuG

Lionel 10-31-2004 07:56 PM

about the phrases, once you insert them, you have to go apply the update in CP by updating any phrase.

Swedie 10-31-2004 08:52 PM

Quote:

Originally Posted by Lionel
about the phrases, once you insert them, you have to go apply the update in CP by updating any phrase.

hmm, you sure? ... i gotta try this out.

Wordplay 10-31-2004 10:12 PM

yeah i had to do that too, but i had to do that on the other 2 hacks i installed that used new phrases as well. that's just the way to update all the phrases, by saving any.

StarBuG 11-01-2004 04:04 AM

Another nice litte feature addon would be if you could post a little image in the postbit if a user has a guestbook, like next to the IM Icons

Can you do that?

StarBuG

Swedie 11-01-2004 04:56 PM

Quote:

Originally Posted by StarBuG
Another nice litte feature addon would be if you could post a little image in the postbit if a user has a guestbook, like next to the IM Icons

Can you do that?

StarBuG

I'll write that down to include in a coming update.

Reeve of shinra 11-01-2004 05:25 PM

How customizable is this from a users perspective?

Loki12 11-01-2004 08:52 PM

I did a thorough test on the system today, and found that it is not completely working for me yet. :ermm:

The guestbook works perfectly, and shows on the member profile page.

The webpage does not work ... the edit page works, and it shows as an option in the usercp. But when I view the user profile after updating the webpage, I see nothing. Only the guestbook. :surprised:

Swedie 11-01-2004 09:12 PM

Quote:

Originally Posted by Loki12
I did a thorough test on the system today, and found that it is not completely working for me yet. :ermm:

The guestbook works perfectly, and shows on the member profile page.

The webpage does not work ... the edit page works, and it shows as an option in the usercp. But when I view the user profile after updating the webpage, I see nothing. Only the guestbook. :surprised:

The webpage works when you have it enabled or disabled where and when and why and such. I gotta know more.

Swedie 11-01-2004 09:15 PM

Hey everyone using this script. Take this new member.php script and overwrite what the current code with. There is a bug fixed (not removing last guestbook entry correctly).

Loki12 11-01-2004 09:52 PM

Quote:

Originally Posted by Swedie
The webpage works when you have it enabled or disabled where and when and why and such. I gotta know more.

It never works. It is enabled, and the editing page works through the usercp. But the webpage never shows on the profile page.

Wordplay 11-01-2004 11:23 PM

the webpage works perfectly fine on mine. u must've messed up loki.

oldfan 11-02-2004 10:52 PM

So its working now?

oldfan 11-03-2004 11:02 AM

I gave it a try and I got errors when I tried to install the tables :(

Benj 11-03-2004 11:06 AM

same here key 1 taken or something

oldfan 11-03-2004 11:50 AM

Ok i got it to work, BUT when I go into my profile and click on Webpage Content or
Guestbook Settings.
I get a blank page :(
Any clues why?

rex_b 11-03-2004 01:16 PM

Quote:

Originally Posted by oldfan
Ok i got it to work, BUT when I go into my profile and click on Webpage Content or
Guestbook Settings.
I get a blank page :(
Any clues why?

That sounds like either you don't have the permissions set up or the templates haven't been installed.

StarBuG 11-03-2004 03:21 PM

Another suggestion:

It would be good to let people know when a new entry in the guestbook was made.
Like the pm notification or a pm for each new entry!?

StarBuG

Wordplay 11-03-2004 05:17 PM

first off, yeah the hack works perfectly fine if you install it correctly. i don't get how so many of y'all messed this up. i had a completely easy install, and everything worked form the start.

onlything that didn't work was deleting guestbook entries. but we got a fix for that now. thanks!

hey this is a completely out of the blue question. is it possible to count add every guestbook entry made to a user's post count. or what would be even better. i've got this shoutbox installed. it would be even better to add the count to that, but i guess you wouldn't want to go through all the trouble of making that possible since not everybody has the shoutbox installed.

oldfan 11-03-2004 09:19 PM

I've got the templates install and have set the permissions like the install says.
Everytime I got in admins permissions the webpage/guestbook are on "No", I then set it to "yes" and hit update.
The samething happens everything

look what I mean

http://bbs.metallifukinca.com/index.php?

test/test

Lionel 11-03-2004 09:33 PM

you probably have other hacks installed that are using the same bitfields number. Go back to init.php and verify that. If so, double the homepage bitfields values so they could be unique.

oldfan 11-03-2004 10:32 PM

Quote:

Originally Posted by Lionel
you probably have other hacks installed that are using the same bitfields number. Go back to init.php and verify that. If so, double the homepage bitfields values so they could be unique.

thanks just tried that, I'm still getting the blank page :(

Lionel 11-03-2004 10:34 PM

But does it hold the permissions at least? Try to update them directly in mysql

oldfan 11-04-2004 12:03 AM

Quote:

Originally Posted by Lionel
But does it hold the permissions at least? Try to update them directly in mysql

huh, what?
this is the tables is installed



Quote:

# This creates all the database related
# tables and fields required for the
# webpage & guestbook script
#

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',
`text` text,
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

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) default '5',
`bordercolor` varchar(10) default '#ECECEC',
`bgcolor` varchar(10) default '#FFFFFF',
`font` varchar(100) default 'Arial, Helvetica',
`fontcolor` varchar(10) default '#000000',
`fontsize` char(3) default '2',
`usehtml` smallint(6) NOT NULL default '1',
`usesmilies` smallint(6) NOT NULL default '1',
`usevbcode` smallint(6) NOT NULL default '1',
`hits` int(11) NOT NULL default '5',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

ALTER TABLE vB3usergroup ADD canuseguestbook SMALLINT NOT NULL;
ALTER TABLE vB3usergroup ADD canusewebpage SMALLINT NOT NULL;

UPDATE vB3usergroup SET canuseguestbook = '1';
UPDATE vB3usergroup SET canusewebpage = '1';

INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_title', 'Enable Guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowwebpage_title', 'Enable Webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowwebpage_desc', 'Allow users to create their own webpage using HTML (on their profile page)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'settinggroup_guestbookwebpage', 'Guestbook / Webpage Preferences', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagevbcode_desc', 'Allow vBcode on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_guestbooksmilies_desc', 'Allow smilies in guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagevbcode_title', 'Webpage vBcode?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagesmilies_title', 'Webpage Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_guestbooksmilies_title', 'Guestbook Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagesmilies_desc', 'Allow Smilies on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagehtml_title', 'Webpage HTML?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_webpagehtml_desc', 'Allow HTML on webpage? Be aware that this CAN cause security issues and "hacking" attempts.', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'can_use_guestbook', 'Can use Guestbook?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'can_use_webpage', 'Can use Webpage?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowedhtmltags_title', 'Webpage HTML tags allowed', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowedhtmltags_desc', 'Which HTML tags do you want to allow? (Leave empty to allow all)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'edit_webpage_content', 'Webpage Content', 1);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'edit_guestbook_settings', 'Guestbook Settings', 1);

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

INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowwebpage', '1', 'yesno', 20, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('guestbooksmilies', '1', 'yesno', 30, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagevbcode', '0', 'yesno', 40, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagesmilies', '0', 'yesno', 50, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagehtml', '1', 'yesno', 60, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowedhtmltags', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><str ong><table><tr><td><th><u><ul><font><b><div>', 'textarea', 70, 'guestbookwebpage', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><str ong><table><tr><td><th><u><ul><font><b><div>', 0, 1);

Lionel 11-04-2004 12:06 AM

By looking at that db, I guess you'll have to read the posts. Your problem was addressed

oldfan 11-04-2004 02:32 AM

Quote:

Originally Posted by Lionel
By looking at that db, I guess you'll have to read the posts. Your problem was addressed


Really? I most have missed it :(
Could you point out the page please/thank you ?

Swedie 11-04-2004 09:04 AM

Quote:

Originally Posted by oldfan
Really? I most have missed it :(
Could you point out the page please/thank you ?

oldfan, you're using rex_b's SQL file. Where did you get that from? Download the latest .ZIP file and use the correct insert.SQL file. That will do the job.

Delete user_guestbook and user_webpage before you run the the SQL file though.

Mickie D 11-04-2004 09:33 AM

you dont think this maybe dangerous to give members html access ?

Code:


<a href="./../../../../../password/passwords.txt">click me</a>

just a thought ?

but then again i cant understand sweedish screenshots :( so i dunno what they all do ?

oldfan 11-04-2004 10:47 AM

Quote:

Originally Posted by Swedie
oldfan, you're using rex_b's SQL file. Where did you get that from? Download the latest .ZIP file and use the correct insert.SQL file. That will do the job.

Delete user_guestbook and user_webpage before you run the the SQL file
though.


oh fart!
HOw do I remove the one I installed now?
Thanks for clearing that up :)

StarBuG 11-04-2004 11:16 AM

Quote:

Originally Posted by oldfan
oh fart!
HOw do I remove the one I installed now?
Thanks for clearing that up :)

Go into your phpmyadmin (if you don?t have it yet get it at phpmyadmin.net) select your db, then the table. Mark both entries and at the bottom select delete ;)

StarBuG

rex_b 11-04-2004 02:23 PM

Quote:

Originally Posted by oldfan
oh fart!
HOw do I remove the one I installed now?
Thanks for clearing that up :)

I feel somewhat to blame :disappointed:

oldfan 11-04-2004 08:41 PM

I can delete the guestbook and webpage no problem, but how do I delete the "INSERT INTO" ones?

oldfan 11-04-2004 09:00 PM

I tried install this

Quote:

# This creates all the database related
# tables and fields required for the
# webpage & guestbook script
#

CREATE TABLE `vB3user_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',
`text` text,
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

CREATE TABLE `vB3user_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) default '5',
`bordercolor` varchar(10) default '#ECECEC',
`bgcolor` varchar(10) default '#FFFFFF',
`font` varchar(100) default 'Arial, Helvetica',
`fontcolor` varchar(10) default '#000000',
`fontsize` char(3) default '2',
`usehtml` smallint(6) NOT NULL default '1',
`usesmilies` smallint(6) NOT NULL default '1',
`usevbcode` smallint(6) NOT NULL default '1',
`hits` int(11) NOT NULL default '5',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;

ALTER TABLE vB3usergroup ADD canuseguestbook SMALLINT NOT NULL;
ALTER TABLE vB3usergroup ADD canusewebpage SMALLINT NOT NULL;

UPDATE vB3usergroup SET canuseguestbook = '1';
UPDATE vB3usergroup SET canusewebpage = '1';

INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowguestbook_desc', 'Allow the guestbook in your users profile?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowguestbook_title', 'Enable Guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowwebpage_title', 'Enable Webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowwebpage_desc', 'Allow users to create their own webpage using HTML (on their profile page)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'settinggroup_guestbookwebpage', 'Guestbook / Webpage Preferences', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagevbcode_desc', 'Allow vBcode on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_guestbooksmilies_desc', 'Allow smilies in guestbook?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagevbcode_title', 'Webpage vBcode?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagesmilies_title', 'Webpage Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_guestbooksmilies_title', 'Guestbook Smilies?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagesmilies_desc', 'Allow Smilies on webpage?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagehtml_title', 'Webpage HTML?', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_webpagehtml_desc', 'Allow HTML on webpage? Be aware that this CAN cause security issues and "hacking" attempts.', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'can_use_guestbook', 'Can use Guestbook?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'can_use_webpage', 'Can use Webpage?', 3);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowedhtmltags_title', 'Webpage HTML tags allowed', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'setting_allowedhtmltags_desc', 'Which HTML tags do you want to allow? (Leave empty to allow all)', 5000);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'edit_webpage_content', 'Webpage Content', 1);
INSERT INTO `vB3phrase` (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '1', 'edit_guestbook_settings', 'Guestbook Settings', 1);

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

INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowwebpage', '1', 'yesno', 20, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('guestbooksmilies', '1', 'yesno', 30, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagevbcode', '0', 'yesno', 40, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagesmilies', '0', 'yesno', 50, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('webpagehtml', '1', 'yesno', 60, 'guestbookwebpage', '1', 0, 1);
INSERT INTO `vB3setting` (varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile) VALUES ('allowedhtmltags', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><str ong><table><tr><td><th><u><ul><font><b><div>', 'textarea', 70, 'guestbookwebpage', '<a><br><b><h1><h2><h3><h4><i><img><li><ol><p><str ong><table><tr><td><th><u><ul><font><b><div>', 0, 1);

now I'm getting this error :(

MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2

StarBuG 11-04-2004 09:02 PM

you need to remove ALL entries by the script!
This error means that this entry is already in the database.
Go through each query and remove everything or add the missing querys ;)

StarBuG

oldfan 11-04-2004 10:09 PM

I was afraid you were going to say that :(

oldfan 11-04-2004 10:36 PM

ELETE FROM `vB3phrase` (
phraseid,
languageid,
varname,
text,
phrasetypeid
) VALUES (
'', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000
)

MySQL said:
#1064 - You have an error in your SQL syntax near '( phraseid,
languageid,
varname,
text,
phrasetypeid ) VALUES ( '', '0', 'sett' at line 1

oldfan 11-04-2004 10:53 PM

I'm tying to reverse the install of these "INSERT INTO"
Could someone please show me how to do it with the I pasted below.
I'm getting mixed up with the commands :(

INSERT INTO `vB3phrase`WHERE (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000);

thanks

Swedie 11-05-2004 11:40 AM

Quote:

Originally Posted by oldfan
I'm tying to reverse the install of these "INSERT INTO"
Could someone please show me how to do it with the I pasted below.
I'm getting mixed up with the commands :(

INSERT INTO `vB3phrase`WHERE (phraseid, languageid, varname, text, phrasetypeid) VALUES ('', '0', 'setting_allowguestbook_desc', 'Allow guestbook in your users guestbooks?', 5000);

thanks

oldfan! STOP!! right now! dude. what you doing. If you don't know how to do it, then please don't make your own attempts of "reversing" it with your guessing.

Run this .SQL and all YOU installed (using vB3 prefix on everything by mistake) will be erased. Then after that, you run the proper .SQL file coming with the .ZIP file in my first post.

PHP Code:

DROP TABLE `user_guestbook`; 
DROP TABLE `user_webpage`; 

ALTER TABLE vb3usergroup DROP canuseguestbook;
ALTER TABLE vb3usergroup DROP canusewebpage;

DELETE FROM vb3phrase WHERE varname 'setting_allowguestbook_desc' OR varname 'setting_allowguestbook_title' OR varname 'setting_allowwebpage_title' OR varname 'setting_allowwebpage_desc' AND varname 'settinggroup_guestbookwebpage' OR varname 'setting_webpagevbcode_desc' OR varname 'setting_guestbooksmilies_desc' OR varname 'setting_webpagevbcode_title' OR varname 'setting_webpagesmilies_title' OR varname 'setting_guestbooksmilies_title' OR varname 'setting_webpagesmilies_desc' OR varname 'setting_webpagehtml_title' OR varname 'setting_webpagehtml_desc' OR varname 'can_use_guestbook' OR varname 'can_use_webpage' OR varname 'setting_allowedhtmltags_title' OR varname 'setting_allowedhtmltags_desc' OR varname 'edit_webpage_content' OR varname 'edit_guestbook_settings';

DELETE FROM vb3settinggroup WHERE grouptitle 'guestbookwebpage';

DELETE FROM vb3setting WHERE grouptitle 'guestbookwebpage'



All times are GMT. The time now is 11:11 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.02262 seconds
  • Memory Usage 1,899KB
  • 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
  • (1)bbcode_php_printable
  • (19)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