vb.org Archive
Page 22 of 30 « First 122021 22 2324 Last »
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)

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!


All times are GMT. The time now is 09:12 PM.
Page 22 of 30 « First 122021 22 2324 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.02660 seconds
  • Memory Usage 1,754KB
  • 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
  • (5)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
  • (10)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