vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Require Users to Sign a Contract Before Posting in an Individual Forum (https://vborg.vbsupport.ru/showthread.php?t=91867)

cruelio 08-07-2005 12:09 AM

Quote:

Originally Posted by amykhar
It's working on RC2 as well. At least from what I can see.

thanks for the quick replies everyone :)

works great on my site and the mods LOVE it! our off-topic section was really getting out of hand and people were just claiming they didn't know about the rules.

is there a query that i could run in case i wanna make it so that everyone has to re-agree to the rules in case i change them etc?

amykhar 08-07-2005 02:08 PM

There's a query you can use if you only have one forum that requires a contract. But, if you have more than one, you're going to need a script.

Boofo 08-07-2005 02:17 PM

Do they only sign the contract only once, or every time they post in the forum?

amykhar 08-07-2005 03:19 PM

Once.

Brinnie 08-08-2005 01:34 PM

i like it alot. would be cool if you could define which page to put in on :)

jlaine 08-10-2005 11:25 AM

Having issues with new thread redirects just going back to forum/index.php - and having multiple forums with a contract nets this db error...

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

UPDATE user
SET contracts = 50,45
WHERE userid = 3143;

MySQL Error : You have an error in your SQL syntax near '45
WHERE userid = 3143
' at line 3
Error Number : 1064

I've eliminated every other modification to try and isolate this - does this fix apply to the current version? As that seems to eliminate that issue, but still trying to understand why the redirects aren't working.

Bad Bunny 08-16-2005 02:43 AM

I think there is a phrase that was overlooked in the instructions. There is only two phrases that it says to turn into global phrases.

amykhar 08-16-2005 02:51 AM

The other phrases are installed by the product.

amykhar 08-16-2005 02:55 AM

Quote:

Originally Posted by jlaine
Having issues with new thread redirects just going back to forum/index.php - and having multiple forums with a contract nets this db error...

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:

UPDATE user
SET contracts = 50,45
WHERE userid = 3143;

MySQL Error : You have an error in your SQL syntax near '45
WHERE userid = 3143
' at line 3
Error Number : 1064

I've eliminated every other modification to try and isolate this - does this fix apply to the current version? As that seems to eliminate that issue, but still trying to understand why the redirects aren't working.

Yes. That fix resolves the problem. I though it was included in the lastest download?

Amy

Mu5icMan 08-16-2005 08:00 AM

Is there a log file or something for when users accept the contract.

amykhar 08-16-2005 01:34 PM

No. Feel free to add that in if you so desire.

Mu5icMan 08-16-2005 01:47 PM

i have no idea where to start for adding a log file. Is there a coder here who can add it?

Bad Bunny 08-16-2005 03:49 PM

Quote:

Originally Posted by amykhar
The other phrases are installed by the product.

I had a blank tcat because it wasn't a global phrase. So I looked in the template, and found the phrase used, and changed it to global.

Bad Bunny 08-19-2005 12:49 PM

It seemed to work fine, until I added a contract to a new forum, and tried to sign it, and got this error.

Quote:

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

UPDATE user
SET contracts = 10,11
WHERE userid = 1;

MySQL Error : 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 '11
WHERE userid = 1' at line 2
Error Number : 1064

amykhar 08-19-2005 01:19 PM

Bunny, get the new zip. I was sure I had fixed that in the zip file, but I guess I didn't.

Reupload contracts.php and tickets.php

Amy

Bad Bunny 08-19-2005 01:58 PM

Quote:

Originally Posted by amykhar
Bunny, get the new zip. I was sure I had fixed that in the zip file, but I guess I didn't.

Reupload contracts.php and tickets.php

Amy

Will do. Thanks.

Bad Bunny 08-19-2005 02:06 PM

Quote:

Originally Posted by Bad Bunny
Will do. Thanks.

Unfortunately, I did delete my copy of the zip, and downloaded the new zip, and uploaded, overwriting my files on the server, and I still have the same exact error. Maybe I have to clear my cache on this site.
[high]* Bad Bunny goes to do that and try again
[/high]

EDIT>>
I deleted the folder yet again, cleared my cache, downloaded the zip, overwrote my files, and I still have the same error.

amykhar 08-19-2005 02:31 PM

When I look in the zip, I see the correct file. I reuploaded it again though. Try one more time.

Bad Bunny 08-19-2005 02:34 PM

Quote:

Originally Posted by amykhar
When I look in the zip, I see the correct file. I reuploaded it again though. Try one more time.

How can I know if it is the right file?

amykhar 08-19-2005 02:35 PM

It will have this in it.

Code:

                            $db->query_write("
                        UPDATE " . TABLE_PREFIX . "user
                        SET contracts = '$contractlist'
                        WHERE userid = " . $vbulletin->userinfo['userid']."
                ");


Bad Bunny 08-19-2005 02:41 PM

Quote:

Originally Posted by amykhar
It will have this in it.

Code:

                            $db->query_write("
                        UPDATE " . TABLE_PREFIX . "user
                        SET contracts = '$contractlist'
                        WHERE userid = " . $vbulletin->userinfo['userid']."
                ");


Yeah, this time it had it. And now it works. You're the best. Sorry to have bothered you with this. :)

jlaine 08-20-2005 09:15 PM

Quote:

Originally Posted by amykhar
Yes. That fix resolves the problem. I though it was included in the lastest download?

Amy

I grabbed/installed it the same day so it must not have been present at that time.

This system seems to create an inherent issue with using quick reply - is there perhaps a way to disable quick reply in forums that have a contract until it is signed? I've had new users try to post a reply with the quick reply box, then get the contract agreement page, then they get forwarded to the index page and lose the post they tried to enter. Makes for some irritated members after it happens a few times. :)

The other situation I seem to have is that it won't pull the URL through after you sign the contract - guys get forwarded back to bburl/index.php instead of either the new reply to the thread they were going to quote, or new thread if that is what they chose to do...

*edit - nevermind on the URL situation - firewall blocking referral url apparently is the issue there...*

May want to find a way to disable the quick reply still though - as if a user uses it, hits submit, then agrees to the contract, they are brought to bburl/newreply.php and gets the default message of "Sorry! This forum is not accepting new posts." and sort of throws them for some confusion.

Bad Bunny 08-21-2005 06:46 AM

Quote:

Originally Posted by jlaine
I grabbed/installed it the same day so it must not have been present at that time.

This system seems to create an inherent issue with using quick reply - is there perhaps a way to disable quick reply in forums that have a contract until it is signed? I've had new users try to post a reply with the quick reply box, then get the contract agreement page, then they get forwarded to the index page and lose the post they tried to enter. Makes for some irritated members after it happens a few times. :)

The other situation I seem to have is that it won't pull the URL through after you sign the contract - guys get forwarded back to bburl/index.php instead of either the new reply to the thread they were going to quote, or new thread if that is what they chose to do...

*edit - nevermind on the URL situation - firewall blocking referral url apparently is the issue there...*

May want to find a way to disable the quick reply still though - as if a user uses it, hits submit, then agrees to the contract, they are brought to bburl/newreply.php and gets the default message of "Sorry! This forum is not accepting new posts." and sort of throws them for some confusion.

It has happened to me several times, too. lol I will work on a conditional for it soon. See if I can do it that way.

CMilne 08-22-2005 06:10 AM

Quote:

Originally Posted by amykhar
Yes, you could do it. If you go to the code in contract.php that writes the contract signature to the database, you could have it write the contract for all 6 forums when the user agrees to any of the group. The easiest way would be for you to hard code the forum ids into the code.

Any way to make this so a user cant even view posts in the forum unless they agree to terms? I am making a new board with a few 18+ only sections which includes content that I would get into serious trouble if people under 18 where able to easily view.

amykhar 08-22-2005 01:49 PM

Yes. As posted in the very first post of the thread, there is. Basically, you just add the same code that's in the new thread and new reply hooks to the forumdisplay or showthread hooks.

I haven't tried it because I don't need it, but that's how you would go about it.

jlaine 09-09-2005 06:39 PM

Quote:

Originally Posted by Bad Bunny
It has happened to me several times, too. lol I will work on a conditional for it soon. See if I can do it that way.

You ever find a way to make a conditional?

If not I should start looking into it - we keep getting complaints about this.

I'll send the data your way if I get a chance - I managed to forget my server login so I've got to wait before I can get started on it... hehe

Bubble #5 10-06-2005 01:36 AM

Is there another way to handle the phrases other than changing them to global? This could cause a lot of problems down the line when people upgrade their forums and the phrases get overwritten and reverted back to where they were before, leaving this hack with no phrases :(

Just wondering if there is another way...

amykhar 10-06-2005 02:35 AM

Create your own product until I have time to redo it. Then you can have the phrases in your product and no conflict worries.

vbtester33 10-06-2005 03:57 AM

any way to make it so after 3 tickets the user can't even view the forum at all?

silurius 11-12-2005 04:31 AM

I love this. Any idea why it might collide with Abe's form hack?

silurius 12-02-2005 09:16 PM

Hi Amy. I really like this hack, but I had to disable it when I realized it was interfering with Abe's Forms Hack. What would you recommend in terms of getting these two hacks to play well together?

dsotmoon 12-17-2005 11:18 PM

how are they interfering? i added forms hack today and was getting ready to add this one?

Smiry Kin's 12-22-2005 09:34 PM

seems to work on 3.5.2

awaiting for some ones birday first :P


*Install

silurius 12-22-2005 09:43 PM

Quote:

Originally Posted by dsotmoon
how are they interfering? i added forms hack today and was getting ready to add this one?

https://vborg.vbsupport.ru/showpost....&postcount=196
https://vborg.vbsupport.ru/showpost....&postcount=210

Eagle Creek 01-10-2006 09:44 PM

*GREAT* hack!

Will it work at 3.5.3?

And by the way; can people VIEW the forum without signing the contract?

EDIT:
Quote:

YOU may easily extend this idea to make readers sign a contract before reading a certain forum. I do not need this feature and will not be adding it at this time.
I see ;).

=======

But still, 3.5.3 :p? It should get out of beta soon ;).

amykhar 01-11-2006 02:23 PM

I haven't upgraded to 3.5.3 due to lack of time. This needs to be made into a product, but it's been running for months at my site.

Eagle Creek 01-11-2006 08:06 PM

Quote:

Originally Posted by amykhar
I haven't upgraded to 3.5.3 due to lack of time. This needs to be made into a product, but it's been running for months at my site.

Ok then!

Can't wait to see it ;).

Can you post a screenshot of giving a ticket?

ConKien 01-21-2006 07:59 PM

Quote:

Originally Posted by Smiry Kin's
seems to work on 3.5.2

awaiting for some ones birday first :P


*Install

Did you have [Quick Reply] on or off Smiry?

SIINSI 02-04-2006 09:34 PM

Quote:

Originally Posted by amykhar
I haven't upgraded to 3.5.3 due to lack of time. This needs to be made into a product, but it's been running for months at my site.

That would be terrific!

M

wArDoG 03-06-2006 01:49 PM

Nevermind I figured it out.


All times are GMT. The time now is 10:08 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.01365 seconds
  • Memory Usage 1,829KB
  • 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
  • (2)bbcode_code_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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