vb.org Archive - Miscellaneous Hacks - Rules and User Agreement Hack

Page 7 of 8

« First

Show 40 post(s) from this thread on one page

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)

Bison

12-22-2006 01:46 AM

The title table has been removed in vB 3.64 for some unknow reason. That's why this hack is broken. Unless your brave and like dibbling into the database, try creating a 'title' column under CRON table in your database.

clearchannel

12-23-2006 10:48 PM

I take it, it's not going to be possible to make this work in 3.6.4.

OK I've read the responses for those who do have it working, but apprently they are either unwilling to share or they don't actually have it working. Thats a shame.

I will contact the author of this script and offer to pay to port it into my fourms.

Aur-Phala.Com

12-26-2006 07:33 PM

anyone got this workin for 3.6??

Staxed

12-31-2006 01:42 AM

guess this still isn't working for 3.6?

Bison

12-31-2006 04:58 AM

still waiting for this one for 3.6.4 myself. One day someone will port this one over..

Smoothie

12-31-2006 02:36 PM

Quote:

Originally Posted by Bison (Post 1147898)

still waiting for this one for 3.6.4 myself. One day someone will port this one over..

yes, hopefully soon! Looks like a great add-on.

Desesperao

01-02-2007 11:39 AM

Anybody update this hack?

PLEASE, HELPPPPPPPPPPPPPPPP

LadyBeth

01-02-2007 11:40 AM

Waiting here also ;)

cagefighter

01-03-2007 01:45 AM

Quote:

Originally Posted by SnowBot (Post 788101)

WOW this looks great, i will give this a try. Thanks for your efforts :)

I get same error when trying to install

michaelk

01-06-2007 10:01 PM

Quote:

Originally Posted by Desesperao (Post 1136245)

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)

Working fine on vb 3.6.4

Open product-rulesagreement.xml

search 2x :

Code:

$xxx = $db->query("INSERT INTO " . TABLE_PREFIX . "cron (weekday, day, hour, minute, filename, loglevel, title )

and replace 2x :

Code:

$xxx = $db->query("INSERT INTO " . TABLE_PREFIX . "cron (weekday, day, hour, minute, filename, loglevel, varname )

Only, if mySQL 5 one uses:

Implement the following Querry:

Code:

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

SEARCH in all files of the Hacks:

"repeat" and replace with "repeated"

have fun ;)

Veer	01-07-2007 12:17 PM

Please update this hack for 3.6.4 as soon as possible.

Bubble #5

01-09-2007 12:05 AM

This 'used to be' the best rules hack around. Funny how one day it's fine and then when a new version of vb comes out it's worthless. Doesn't look like the author is around anymore either, so I guess we'll have to hope that someone else releases a rules hack for 3.6.x. :( It was a nice hack while it was working though...

socalsoccer

01-09-2007 02:53 AM

Can you make this pop up before you enter the main forum everytime someone comes to your site? This way they have to accept before they even see your forum.

socalsoccer

01-09-2007 04:03 AM

How can you make this pop up when posting a reply everytime, in any section?

Thanks

stwilson

01-13-2007 05:27 AM

Tried to get this working on 3.6.4 with MySQL 5 but no-go. Anyone have it working? I tried to follow michaelk's instructions but could not get to work.

ST

ArchangelX

01-14-2007 11:19 PM

Great hack! Thanks for protecting our booties!

echamberlain

01-26-2007 08:48 PM

I ran into an error installing the 3.6.x zipped fix, here was my workaround, incase others have this problem.

The symptom was that the Importing Product task bar would keep growing and not stop. The error log had the following entry:

PHP Fatal error: Cannot use object of type mysqli_result as array in /var/www/html/vBulletin/admincp/plugin.php(1941) : eval()'d code on line 35, referer: https://xxxxxx/admincp/plugin.php?do=productadd

To fix this error, I modified product-rulesagreement.xml and removed the if statement in the install code, by changing the code from

PHP Code:


		
			
$xx = $db->query("select * from " .  TABLE_PREFIX . "user");

    if ($xx[agreedrule]=='')

     {

$db->query("ALTER TABLE " .  TABLE_PREFIX . "user ADD agreedrule TEXT NOT NULL ");

      }

$db->query("DELETE FROM " . TABLE_PREFIX . "cron WHERE filename like '%cron/cron_ruleshack.php'");

PHP Code:


		
			
$xx = $db->query("select * from " .  TABLE_PREFIX . "user");

$db->query("ALTER TABLE " .  TABLE_PREFIX . "user ADD agreedrule TEXT NOT NULL ");

$db->query("DELETE FROM " . TABLE_PREFIX . "cron WHERE filename like '%cron/cron_ruleshack.php'");

This is a manual workaround, so make sure the agreedrule column does not exist (select agreedrule from vb_users) before making this change.

stwilson

01-27-2007 05:47 AM

I tried this on 3.6.4 with MySQL 5 and all I get is this:

Quote:

input->clean_array_gpc('r', array('forumid' => TYPE_INT, 'title' => TYPE_STR, 'ruletext' => TYPE_STR, 'ruleurl' => TYPE_STR, 'userids' => TYPE_STR, 'usernames' => TYPE_STR, 'usergroup_all' => TYPE_INT, 'groupids' => TYPE_ARRAY_INT, 'memberids' => TYPE_ARRAY_INT, 'firstnewthread' => TYPE_INT, 'postmore' => TYPE_INT, 'postless' => TYPE_INT, 'joindateafter' => TYPE_STR, 'joindatebefore' => TYPE_STR, 'lastactiveafter' => TYPE_STR, 'lastactivebefore' => TYPE_STR, 'lastpostafter' => TYPE_STR, 'lastpostbefore' => TYPE_STR, 'active' => TYPE_INT, 'conditions' => TYPE_INT, 'action' => TYPE_STR, 'limitstart' => TYPE_INT, 'ruleid' => TYPE_INT, 'allowbbcode' => TYPE_INT, 'repeated' => TYPE_INT, 'childforum' => TYPE_INT, 'newthread' => TYPE_INT, 'newreply' => TYPE_INT, 'viewforum' => TYPE_INT, 'fileurl' => TYPE_STR, 'exactmatch' => TYPE_INT)); if ($vbulletin->GPC['action'] != 'kill') print_cp_header(); if ($_REQUEST['do'] == 'rule') { print_cp_header($vbphrase['ruleshack_rules_manager']); print_form_header('rulesagreement', 'submitrule'); construct_hidden_code('action', 'newrule'); print_table_header($vbphrase['ruleshack_rules_add']); print_input_row($vbphrase['ruleshack_rules_title'], 'title'); print_textarea_row($vbphrase['ruleshack_rules_text'], 'ruletext', ''); print_input_row($vbphrase['ruleshack_rules_url'], 'ruleurl', ''); print_description_row('', 0, 2, 'thead'); print_yes_no_row($vbphrase['allow_bbcode'], 'allowbbcode', 0); print_yes_no_row($vbphrase['ruleshack_rules_repeated'

Any thoughts????

SimCityForum

01-29-2007 01:43 PM

I implemented the modifications suggested in https://vborg.vbsupport.ru/showpost....&postcount=250 and then reinstalled this mod according to the instructions in the readme.txt and it is now working correctly for me on v3.6.1 running on PHP5 and MySQL5

Mr_Snob

02-01-2007 05:20 AM

i have this one ported for 3.6.4 and many features added if you would i release it at vb.org :)

stwilson

02-01-2007 03:17 PM

Quote:

Originally Posted by Mr_Snob (Post 1171818)

i have this one ported for 3.6.4 and many features added if you would i release it at vb.org :)

That would be nice! I have not been able to get this one working on 3.6.4. Can't wait.

Jurg	02-02-2007 11:57 AM

Can I also please request that you release the port for 3.64?

I'd be most grateful!:D

Merriweather

02-03-2007 03:33 AM

I would love to see it for 3.6.4 as well! :)

dutchbb

02-10-2007 10:35 PM

Mr_Snob: please do :)

Eagle Creek

02-11-2007 06:29 PM

3.6.4 please!

Black Widow

02-11-2007 08:15 PM

Attached is the updated hack which works on 3.6.4 and MYSQL 5.

Enjoy...

fixed 1 bug.
Download again.

dutchbb

02-11-2007 09:39 PM

Tried to make a rule and got this:

Quote:

Database error in vBulletin 3.6.4:

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, repeat, childforum, newthread, newreply, viewforum, fileurl, exactmatch)
values ('25', 'test', 'test', '', '0',
'6', '', '', '', '0',
'0', UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), UNIX_TIMESTAMP(''),
UNIX_TIMESTAMP(''), '0', '1', '1', '0', '0', '0', '0', '1', '',
'0');

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 'repeat, childforum, newthread, newreply, viewforum, fileurl, exactmatch)
' at line 5
Error Number : 1064
Date : Monday, February 12th 2007 @ 12:54:56 AM
Script : http://forum.domain.com/admincp/rule...?do=submitrule
Referrer : http://forum.domain.com/admincp/rule...nt.php?do=rule
IP Address : -
Username : dutchbb
Classname : vB_Database

Black Widow

02-12-2007 10:58 AM

You have MySQL 5 installed.
use the zip file i uploaded just above your post.
It will work then.

dutchbb

02-12-2007 11:19 AM

Sure, I used that file, uploaded everything.

Black Widow

02-12-2007 04:23 PM

Quote:

Originally Posted by dutchbb (Post 1180543)

Sure, I used that file, uploaded everything.

i fixed something there.
download and upload again.

DPSR	02-13-2007 02:03 AM

Quote:

Originally Posted by Black Widow (Post 1180756)

i fixed something there.
download and upload again.

Working just fine on my vb3.6.4 :D

Thanks a lot Black Widow :up:

stwilson

02-13-2007 12:55 PM

Still a no-go for me. Here is what I get when I access the Rules CP

Quote:

stwilson

02-13-2007 12:56 PM

Almost forgot. I am on MySQL 5 and 3.6.4. Basically, I uninstalled, reinstalled and got the above error.

s0lidgr0und

02-13-2007 02:15 PM

Any thoughts?

Quote:

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 : Tuesday, February 13th 2007 @ 10:10:39 AM

dutchbb

02-13-2007 03:41 PM

Quote:

Originally Posted by Black Widow (Post 1180756)

i fixed something there.
download and upload again.

Thanks! Nog bugs or problems so far with this one :)

poprulz

02-14-2007 12:32 PM

I am using vB 3.6.1

I tried installing the original version attached with this thread and it gave me a itle filed eror. So i downloaded the patched 1 with variable name.

When i import product. nothing happens...the bar remains as such and nothing seems to work.

Please provide me with a working version for 3.6.1.

butty

02-14-2007 12:47 PM

thanks to uae for the hack and thanks to black widow for posting the patch for 3.6.4 got it working perfectly great stuff :)

BigJimTheLug

02-21-2007 04:37 AM

So this does work on 3.6.4?

f!nal

02-28-2007 04:53 PM

I have a problem , i have vb version 3.6.4 and when i import the xml file, i become a error:

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

i have the german forum is this the problem?

jadkar

02-28-2007 09:00 PM

Quote:

Originally Posted by jadkar (Post 1101602)

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

Nobody has an answer to this......please!!

All times are GMT. The time now is 11:40 PM.

Page 7 of 8

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01789 seconds Memory Usage 1,839KB 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 (2)bbcode_php_printable (12)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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
Messages: