vb.org Archive
Page 5 of 28 « First 34 5 6715 Last »
Show 40 post(s) from this thread on one page

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)

hasan2k 11-05-2004 06:27 PM
Hey Swedie

I have not heard from you. I sent two emails. Please respond.

Swedie 11-05-2004 08:53 PM
Quote:
Originally Posted by hasan2k
Hey Swedie

I have not heard from you. I sent two emails. Please respond.
If everyone remember, I had a date a while ago. And well, she's been here at my place for the last week. I've been "busy" with all of what that means. :p

Lionel 11-05-2004 08:57 PM
way to go swedie :up:

relax all you can and come back with some more hacks. :lick:

Benj 11-06-2004 08:15 AM
Quote:
Originally Posted by Lionel
way to go swedie :up:

relax all you can and come back with some more hacks. :lick:
cheeky bugger :banana: :laugh:

Wordplay 11-06-2004 09:11 AM
swedie how is that update coming?

Andreas 11-06-2004 09:22 AM
Some things I'd like to see
  • Full-featured editor
  • Guestbook-entries on a separate page, with pagination
  • Possibility to edit entries
  • Notification when there is a new entry (PM/eMail)
  • Moer usergroup permissions: Can post in other guestbooks, Can edit own guestbook, Can edit own entries, Can edit other users guestbooks, Can delete own entries, Can delete entries in own guestbook, Can delete entries in other users guestbooks

Loki12 11-06-2004 10:37 AM
I deleted everything the first sql query did via phpMyadmin, and re-run the queries. Now it is working, and everything showing up. :)

*Loki12 clicks install!

oldfan 11-07-2004 01:04 AM
I did what you said and I got this error :(
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2




Quote:
Originally Posted by Swedie
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' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';

DELETE FROM vb3settinggroup WHERE grouptitle = 'guestbookwebpage';

DELETE FROM vb3setting WHERE grouptitle = 'guestbookwebpage'; 

Loki12 11-07-2004 09:51 AM
Quote:
Originally Posted by oldfan
I did what you said and I got this error :(
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2
Then it probably means you have not ran this command Swedie gave:


Quote:
DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';
Remember that your table will not necessarily be called "vb3phrase". Mine is simply called "phrase". I suggest going into the "phrase" table via phpMyadmin, and manually delete the specific phrase, then try again.

oldfan 11-07-2004 10:00 PM
I did run that command...

Quote:
ALTER TABLE vB3usergroup DROP canuseguestbook;# Affected rows:9
ALTER TABLE vB3usergroup DROP canusewebpage;# Affected rows:9
DELETE FROM vB3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3settinggroup WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3setting WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).

I got the error when I tried the install the sql in the new zip

Quote:
Originally Posted by Loki12
Then it probably means you have not ran this command Swedie gave:




Remember that your table will not necessarily be called "vb3phrase". Mine is simply called "phrase". I suggest going into the "phrase" table via phpMyadmin, and manually delete the specific phrase, then try again.
Quote:
ALTER TABLE vB3usergroup DROP canuseguestbook;# Affected rows:9
ALTER TABLE vB3usergroup DROP canusewebpage;# Affected rows:9
DELETE FROM vB3phrase WHERE varname = 'setting_allowguestbook_desc' AND varname = 'setting_allowguestbook_title' AND varname = 'setting_allowwebpage_title' AND varname = 'setting_allowwebpage_desc' AND varname = 'settinggroup_guestbookwebpage' AND varname = 'setting_webpagevbcode_desc' AND varname = 'setting_guestbooksmilies_desc' AND varname = 'setting_webpagevbcode_title' AND varname = 'setting_webpagesmilies_title' AND varname = 'setting_guestbooksmilies_title' AND varname = 'setting_webpagesmilies_desc' AND varname = 'setting_webpagehtml_title' AND varname = 'setting_webpagehtml_desc' AND varname = 'can_use_guestbook' AND varname = 'can_use_webpage' AND varname = 'setting_allowedhtmltags_title' AND varname = 'setting_allowedhtmltags_desc' AND varname = 'edit_webpage_content' AND varname = 'edit_guestbook_settings';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3settinggroup WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM vB3setting WHERE grouptitle = 'guestbookwebpage';# MySQL returned an empty result set (i.e. zero rows).

oldfan 11-07-2004 10:10 PM
this is crazy, I run swedies command and tried to the sql in the zip and I get this error :)

Originally Posted by oldfan
I did what you said and I got this error
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2

What I'm I doing wrong now :(

seangworld 11-07-2004 11:58 PM
wow, didn't know you released it. ok, time for me to try this bad boy out! :)

Loki12 11-08-2004 11:31 AM
Quote:
Originally Posted by oldfan
this is crazy, I run swedies command and tried to the sql in the zip and I get this error :)

Originally Posted by oldfan
I did what you said and I got this error
MySQL said:
#1062 - Duplicate entry 'setting_allowguestbook_desc-1-5000' for key 2

What I'm I doing wrong now :(
It means you'll have to delete the old sql entries on your database before re-running the script again.

Loki12 11-08-2004 11:31 AM
Quote:
Originally Posted by seangworld
wow, didn't know you released it. ok, time for me to try this bad boy out! :)
Good luck... you'll need it! ;)

oldfan 11-08-2004 11:58 AM
Isn't what this does?

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

Quote:
Originally Posted by Loki12
It means you'll have to delete the old sql entries on your database before re-running the script again.

Marco van Herwaarden 11-08-2004 12:17 PM
Well this would only delete a row if in 1 row the field 'varname' would have the value 'setting_allowguestbook_desc' AND 'setting_allowguestbook_title' AND ..... at the same time.

This will never be the case.

Think you might be better of replacing those 'AND's by 'OR'. :D

Swedie 11-08-2004 01:49 PM
Quote:
Originally Posted by Wordplay
swedie how is that update coming?
Only received one donation so far. I aint busting anything to update. But I will look at it some time this week.

Swedie 11-08-2004 01:50 PM
Quote:
Originally Posted by KirbyDE
Some things I'd like to see
  • Full-featured editor
  • Guestbook-entries on a separate page, with pagination
  • Possibility to edit entries
  • Notification when there is a new entry (PM/eMail)
  • Moer usergroup permissions: Can post in other guestbooks, Can edit own guestbook, Can edit own entries, Can edit other users guestbooks, Can delete own entries, Can delete entries in own guestbook, Can delete entries in other users guestbooks
When you pay me $100.

Swedie 11-08-2004 01:52 PM
Quote:
Originally Posted by MarcoH64
Well this would only delete a row if in 1 row the field 'varname' would have the value 'setting_allowguestbook_desc' AND 'setting_allowguestbook_title' AND ..... at the same time.

This will never be the case.

Think you might be better of replacing those 'AND's by 'OR'. :D
oh crap! that's right. Sorry oldfan. This is what it should look like:

Quote:
DELETE FROM vb3phrase WHERE varname = 'setting_allowguestbook_desc' OR varname = 'setting_allowguestbook_title' OR varname = 'setting_allowwebpage_title' OR varname = 'setting_allowwebpage_desc' OR 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';

oldfan 11-08-2004 06:03 PM
I'm going to donate as soon as I get this working :)
Everything was going good until I hit this error :(


Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE vB3usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'xxxxxxx',
description = 'xxxxx:)',
usertitle = 'xxxxx:)',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
attachlimit = '0',
avatarmaxwidth = '80',
avatarmaxheight = '80',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '5',
uttstore_discount = '0',
forumpermissions = '61555',
pmpermissions = '0',
calendarpermissions = '16',
wolpermissions = '0',
adminpermissions = '0',
genericpermissions = '4162',
genericoptions = '30',
arcadepermissions = '1'
WHERE usergroupid=2
mysql error: Unknown column 'pmpermissions' in 'field list'

mysql error number: 1054

Date: Monday 08th of November 2004 01:03:55 PM
Script: http://xxxxxxxx/admincp/usergroup.php
Referer: http://xxx/xxx/xxxxxx/usergroup.php?...&usergroupid=2
Username: xxxxxxx
IP Address: xxxxxxxx

Swedie 11-08-2004 06:41 PM
it means that your table called pmpermissions has been removed. maybe you went into your database manually and started removing tables? (trying to blame you.. ;) j/k)

oldfan 11-08-2004 07:18 PM
dohhhhhhh....
can this be fixed?

Marco van Herwaarden 11-08-2004 07:54 PM
Quote:
Originally Posted by Swedie
it means that your table called pmpermissions has been removed. maybe you went into your database manually and started removing tables? (trying to blame you.. ;) j/k)
Not the table but the column.

Swedie 11-08-2004 08:34 PM
Quote:
Originally Posted by MarcoH64
Not the table but the column.
stop it, you're making me look bad :D

yeah. it is just names! it is of course column.

Swedie 11-08-2004 08:39 PM
Quote:
Originally Posted by oldfan
dohhhhhhh....
can this be fixed?
yes, use this SQL command:

ALTER TABLE vB3usergroup ADD pmpermissions SMALLINT NOT NULL DEFAULT '0';

Then go into your Usergroup Manager and add PM permissions again for all the usersgroups you wish to allow it for.

oldfan 11-09-2004 12:53 AM
[high]* oldfan clicks install and paypal buttons :)[/high]

Wordplay 11-09-2004 01:59 PM
is there anyway to change the time of the posts in the guestbook. apperently i can't get that to change, because it's all wrong.

Marco van Herwaarden 11-09-2004 03:25 PM
Quote:
Originally Posted by Swedie
stop it, you're making me look bad :D

yeah. it is just names! it is of course column.
Sorry Swedie,

Never ment to make you look bad ;)

HarryBO 11-09-2004 04:14 PM
Hi!

I have read the complete Instructions very often, but I have the same error as many persons before!

Here is a screenshot! https://vborg.vbsupport.ru/attachmen...chmentid=21434

Otherwise I can?t see a webpage or a guestbook in my profile!

Must I changethe SQL File? Sorry I don?t understand all Posts here, because I came from Germany. It?s very hard to translate all the Postings!

I hope someone can help!

Ist hier vll. jemand deutschsprachiges, der den Hack zum Laufen bekommen hat?

Andreas 11-09-2004 04:21 PM
Quote:
Originally Posted by Swedie
When you pay me $100.
Too much ... 10, maybe 15.
But for 100 bucks i'm gonna code that myself :)

Benj 11-10-2004 06:13 AM
ill give you 50 bucks if you can tell me how i can but the guestbook part of your script on a page of its own which i can link to from member.php like comments.php?u=8 dont have a use for the web page :/

Swedie 11-10-2004 08:18 AM
Quote:
Originally Posted by benj
ill give you 50 bucks if you can tell me how i can but the guestbook part of your script on a page of its own which i can link to from member.php like comments.php?u=8 dont have a use for the web page :/
send 50 bucks first to swedie@wheeliepimp.com and I'll have that done for you right now. No problem.

Swedie 11-10-2004 08:20 AM
Quote:
Originally Posted by Wordplay
is there anyway to change the time of the posts in the guestbook. apperently i can't get that to change, because it's all wrong.
Well, you mean the date formatting? I can make it a setting in a future release.

I've started a new project and it is taking all my attention.

Wordplay 11-10-2004 09:32 AM
Quote:
Originally Posted by Swedie
Well, you mean the date formatting? I can make it a setting in a future release.

I've started a new project and it is taking all my attention.
just curious where it's getting the time from. because my site isn't located in the usa, and that guest book is using usa time.

my site does promotion for asian parties, there are 3 parties i know of already i'll be promoting in december, i actually get alot of money for the promotion, and they'll pay the second the month starts. without your hack i wouldn't be able to have gotten so many hits i believe, because some ++++s just sit around practically chatting to each other on that guestbook. and man the next page button says nastra sida or something along those... letters. that's confusing. can't be in the templates, cause i searched through all those. but no biggy. just lettin you know, i'll get that donation to you the second i get payed, because until 2005 i intend to use all the money that comes in for the site anyways, i'll probably have a quick 50 bucks for you then.

but you know that, full featured ++++ for 100 bucks for a couple of features got me insanely curious. what would you pull off for 50 bucks? and you guys said paypal charges what an extra 14 bucks just for the transaction? so i'd be paying 64 bucks. that's still alright. let me know, whether you'd be willing to have some updates up for this for 50 bucks.

Swedie 11-10-2004 07:17 PM
money decides. I thought I was gonna get more out of this. But I am also aware that I rushed the release by mistake. I should've waited and bug-fixed everything before releasing. Maybe that would have more people interested in donating.

I'm making an ads script right now that is quite nice. I'll show it off later.

Benj 11-11-2004 07:47 AM
swedie dont get payed till next thu will pay then :) cheers

PranK 11-11-2004 08:35 AM
/me clicks install.

Thanks swedie!

Snatch 11-11-2004 10:17 AM
Sorry but i can not find everything about Phrases in your instruction text. Am I blind ?

Benj 11-11-2004 11:20 AM
the phrases are added in the insert.sql sql dump

idslamyou 11-11-2004 03:21 PM
I am getting this error when I am trying to execute the sql query in VB admin section:

Quote:
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 near ';

CREATE TABLE `user_webpage` (
`userid` int(11) NOT NULL default '0',
' at line 15
Can anyone help?


All times are GMT. The time now is 11:12 AM.
Page 5 of 28 « First 34 5 6715 Last »
Show 40 post(s) from this thread on one page

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.02192 seconds
  • Memory Usage 1,865KB
  • 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_php_printable
  • (25)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