vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - Rules and User Agreement Hack (https://vborg.vbsupport.ru/showthread.php?t=97699)

Lionel 08-19-2006 03:16 PM

How can I make those rules bilingual?

Cibox.de 08-20-2006 04:42 PM

Doesn't work with 3.6.
Is there an update planned?

Whissi 08-20-2006 05:45 PM

What's the problem?

Chicago_VLNU_4s 08-20-2006 10:05 PM

how come it's not working when i try to test post a new message? i have it aimed to the proper thread and i selected the Rules to show up by clicking yes for all options and the only rules screen i get is the first time visiting that thread.... any ideas?

Aaron RV 08-21-2006 05:21 AM

work on vb 3.6.0?

dethfire 08-24-2006 02:38 PM

no it doesn't work yet, really need though

COBRAws 08-25-2006 09:48 PM

Quote:

Originally Posted by moonclamp
My webhost recently upgraded our version of mySQL to 5.0.21

Ever since then I have been getting the following error email:

It doesn't seem to affect anyone, just getting loads of emails telling me about the error.

None of my rules reset themselves, is it safe to just turn off the cron?

I have the same problem, posted in reply #172

No help provided yet. :S ill have to un-install this hack.
For the old rules it works great, but when trying to set up new ones, it doesnt.

Ntfu2 08-29-2006 06:08 AM

Fix for 3.6 attached. Basically just changed the title in cron to varname

I did this on a fresh install of the modifciation on 3.6 and worked fine. I can not assume the same for previous installs, so please test on your test board first.

alfaowner 08-29-2006 09:31 PM

Should this work on a file location as my example: http://www.xyz.com/forum/classifieds/index.php ?? As currently I cannot get it to work for url's. I am running 3.5.4

steven s 08-29-2006 10:24 PM

Quote:

Originally Posted by alfaowner
Should this work on a file location as my example: http://www.xyz.com/forum/classifieds/index.php ?? As currently I cannot get it to work for url's. I am running 3.5.4

Yes it should. I use this before someone can view myforum/newthread.php?do=hpde
Also check your usergroups.

heyitsjeremy 09-10-2006 06:10 AM

great mod. but could a countdown timer be done for this as well ? so before anyone can proceed, he/she has to wait for the timer to countdown ?

and other then making it to appear in different forums/sub forums, could i make it appear for specific threads ?

alfaowner 09-16-2006 12:07 PM

Quote:

Originally Posted by 1996 328ti
Yes it should. I use this before someone can view myforum/newthread.php?do=hpde
Also check your usergroups.

Thanks for the reply 1996 328ti,

What would I check in usergroups exactly? Sorry for being a bit dim here.

Kriminal 09-16-2006 04:57 PM

Quote:

Originally Posted by moonclamp
My webhost recently upgraded our version of mySQL to 5.0.21

Ever since then I have been getting the following error email:

It doesn't seem to affect anyone, just getting loads of emails telling me about the error.

None of my rules reset themselves, is it safe to just turn off the cron?

The word repeat is reserved for MySQL 5, and cannot be used as field name
http://dev.mysql.com/doc/refman/5.0/...ved-words.html

I'm trying to bypass this error renaming the field name or doing something with the query; when I get any solution I'll post it here.

Simplicity 09-16-2006 05:30 PM

What would need to be edited for version 3.6, from what I can see the ruleshack table wouldnt be created, any other problems in the other files?

The Realist 09-17-2006 10:16 AM

Working fine with 3.6.0 using https://vborg.vbsupport.ru/showpost....&postcount=208

Laters

Kriminal 09-18-2006 11:22 AM

Quote:

Originally Posted by Simplicity
What would need to be edited for version 3.6, from what I can see the ruleshack table wouldnt be created, any other problems in the other files?

I think it wolud be the same problem: "repeat" could not be a field name in MySQL 5
I finally made a modification to original plugin, changing repeat for repeated everywhere it appears.
PLEASE, backup before using this. It's working for me, but it doesn't means that it would work for everybody.

alfaowner 09-18-2006 06:13 PM

what can be checked if it is not protecting forum/classifieds/index.php

many thanks

nimonogi 09-22-2006 09:02 AM

Quote:

Originally Posted by Kriminal
I think it wolud be the same problem: "repeat" could not be a field name in MySQL 5
I finally made a modification to original plugin, changing repeat for repeated everywhere it appears.
PLEASE, backup before using this. It's working for me, but it doesn't means that it would work for everybody.

The installation process was successfull but when i'm trying to Add New Rule i'm getting a mysql error.

Code:

Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO ruleshack
                                    (forumid, ruletitle, ruletext, ruleurl, firstnewthread, groupids, memberids, userids,
                                    usernames, postmore, postless, joindateafter, joindatebefore,
                                    lastactiveafter, lastactivebefore, lastpostafter, lastpostbefore,
                                conditions, allowbbcode, active, repeated, childforum, newthread, newreply, viewforum, fileurl, exactmatch)
                                    values ('6', 'Text', 'Text[/b]', '', '0',
                                    '2', '', '', '', '0',
                                    '10', UNIX_TIMESTAMP(''),
                                    UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
                                    UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
                                    UNIX_TIMESTAMP(''), '1', '1', '1', '1', '1', '1', '0', '0', '',
                                    '0');

MySQL Error  : Unknown column 'repeated' in 'field list'
Error Number : 1054
Date        : Friday, September 22nd 2006 @ 05:55:25 AM
Script      : http://www.domain.com/admincp/rulesagreement.php?do=submitrule
Referrer    : http://www.domain.com/login.php?do=login
IP Address  : ***
Username    : ***
Classname    : vb_database


Kriminal 09-22-2006 10:46 AM

Quote:

Originally Posted by nimonogi
The installation process was successfull but when i'm trying to Add New Rule i'm getting a mysql error.

Code:

Database error in vBulletin 3.6.1:

Invalid SQL:
INSERT INTO ruleshack
                                    (forumid, ruletitle, ruletext, ruleurl, firstnewthread, groupids, memberids, userids,
                                    usernames, postmore, postless, joindateafter, joindatebefore,
                                    lastactiveafter, lastactivebefore, lastpostafter, lastpostbefore,
                                conditions, allowbbcode, active, repeated, childforum, newthread, newreply, viewforum, fileurl, exactmatch)
                                    values ('6', 'Text', 'Text[/b]', '', '0',
                                    '2', '', '', '', '0',
                                    '10', UNIX_TIMESTAMP(''),
                                    UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
                                    UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
                                    UNIX_TIMESTAMP(''), '1', '1', '1', '1', '1', '1', '0', '0', '',
                                    '0');

MySQL Error  : Unknown column 'repeated' in 'field list'
Error Number : 1054
Date        : Friday, September 22nd 2006 @ 05:55:25 AM
Script      : http://www.domain.com/admincp/rulesagreement.php?do=submitrule
Referrer    : http://www.domain.com/login.php?do=login
IP Address  : ***
Username    : ***
Classname    : vb_database


If you have installed this hack previously, yo must alter table manually and change field repeat as repeated.
You may run this query:

Code:

alter table `ruleshack` change `repeat` `repeated` smallint (1)  DEFAULT '0' NOT NULL

nimonogi 09-22-2006 10:54 AM

Thanks a lot!

COBRAws 09-25-2006 05:33 PM

Quote:

Originally Posted by Kriminal
I think it wolud be the same problem: "repeat" could not be a field name in MySQL 5
I finally made a modification to original plugin, changing repeat for repeated everywhere it appears.
PLEASE, backup before using this. It's working for me, but it doesn't means that it would work for everybody.

Hey Kirminal, never saw you around ;)
Cheers

Kriminal 09-25-2006 06:52 PM

Quote:

Originally Posted by COBRAws
Hey Kirminal, never saw you around ;)
Cheers

Because psico was in charge to support the forum; but now I assumed all technical task... and the first one is moving a hardly hacked 3.010 to 3.61. :nervous:

So, thanks for noticing and sorry for my english.

trackpads 10-05-2006 08:42 PM

Mega thanks for getting this to run in 3.6! I will try it out tonight!!

Thanks!!!

-Jason

oldfan 10-10-2006 03:49 AM

anyone get the template "memberinfo" too work?

Silver_Seagull 10-16-2006 04:00 PM

I'm running 3.5.4 and this hack isn't applying the rules to the usergroups I select. It is applying them to everyone, regardless of usergroups selected.

It is also randomly only applying the rule display to only Replies, or only New Threads....despite having First Time Posting a Thread in this Forum, New Thread Posting and New Reply Posting checked.

Is this broken?

sduckie2k5 10-16-2006 08:11 PM

^^^ Same here, chose all usergroups except mods and admin and it still applies to them as well.

cyberbeggar 10-17-2006 12:43 AM

I am getting this error message after accepting the rules:

Quote:

Method Not Allowed
The requested method POST is not allowed for the URL /index.html.


--------------------------------------------------------------------------------

Apache/1.3.34 Server at www.mysite.com Port 80

cyberbeggar 10-19-2006 11:07 PM

Quote:

Originally Posted by cyberbeggar
I am getting this error message after accepting the rules:


Anyone?

jadkar 10-21-2006 08:22 PM

I installed vBSEO after this hack has been running for about a year and now it's dead. Does anyone have any expirence using this with vBSEO??

My problem is that as soon as a user agrees to the rules and clicks submit it bounces them back to the main forum index page. :(:(

This hack was instrumental on my site if this can't work does anyone know of a similar one??

Please help :)

Greek Wizard 11-01-2006 01:12 PM

Quote:

Originally Posted by Ntfu2
Fix for 3.6 attached. Basically just changed the title in cron to varname

I did this on a fresh install of the modifciation on 3.6 and worked fine. I can not assume the same for previous installs, so please test on your test board first.

Thanks for that.

Installed on a decently modified 3.6.2 and seems to work perfectly.

tamborinegal 11-04-2006 01:29 AM

Thanks so much, this is a great hack! Just what I needed.

Thanks! :)

Clancy

VietPirates 11-06-2006 05:00 AM

Quote:

Originally Posted by sduckie2k5
^^^ Same here, chose all usergroups except mods and admin and it still applies to them as well.

Same here. It applies to every usergroup.

MrPHD 12-03-2006 03:47 PM

Installed and working fine on 3.6.4. Thanks

Desesperao 12-11-2006 10:19 AM

Quote:

Originally Posted by MrPHD (Post 1130898)
Installed and working fine on 3.6.4. Thanks

Working fine on 3.6.4?.

I have installed it and it does not work :(

I have imported the product but it gives me error. Any idea?

(vBulletin 3.6.4)
Quote:

Warning: Invalid argument supplied for foreach() in /includes/functions_cron.php on line 95

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO cron (weekday, day, hour, minute, filename, loglevel, title )
VALUES (-1, -1, 0, 'a:1:{i:0;i:-1;}', './includes/cron/cron_ruleshack.php', 1,
'Rules and User Agreement Hack Reset');

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Monday, December 11th 2006 @ 01:23:56 PM
Script : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/plugin.php?do=productimport
Referrer : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/admincp/plugin.php?do=productadd
IP Address : xxxxxxxxxxxx
Username : xxxxxxxxxxx
Classname : vb_database

egyptsons 12-11-2006 12:21 PM

looks good

TMAC 12-11-2006 02:12 PM

I would pay for this hack if it was not available free. Thank you again.

Desesperao 12-11-2006 09:22 PM

Please, I need help

https://vborg.vbsupport.ru/showpost....&postcount=234

Desesperao 12-15-2006 09:37 PM

anybody? :(

bradyb 12-15-2006 10:33 PM

Hi all,

I can see this mod is coded for the 3.x.x. version but I get this message when I execute the installer from the admincp on my 3.6.4 forums:

Fatal error: Call to a member function query_first() on a non-object in /home/XXXXX/public_html/admincp/newthread_rules_install_1_00.php on line 138

Any ideas?

DPSR 12-17-2006 01:27 AM

Anybody update this hack please as it is giving error while adding new rules :(:(


All times are GMT. The time now is 04:28 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.01835 seconds
  • Memory Usage 1,837KB
  • 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
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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