vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Warnings System Hack v2.1 (https://vborg.vbsupport.ru/showthread.php?t=43265)

Chris M 09-07-2002 05:49 PM

Is it necessary to upgrade to 2.1 if we have 2.0 working?

Satan

Brandon 09-07-2002 06:00 PM

Yeah, the links show up for me, but they dont have the options like shown in the screenshots :eek: ... 2.1 fixed the blank-screen issue I had though :)

N9ne 09-07-2002 06:15 PM

OMMMMMMMMMFG G-FORCE!!!! TOO MANY FEATURES, FEATURE OVERLOAD!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

WOW, This is DEFINITELY getting my vote for HOTM [unless you release something god-like again lol]

Simply AWESOME work!

Okiewan 09-07-2002 06:16 PM

"can warn" or whatever the permissions are for who can see and post warnings, has nothing to do with my problem... I logged-in as every usergroup... the "warn user" (and other warn links) do not show-up in postpit. ( I added "$post[warnlink]" to postbit )

The Realist 09-07-2002 06:44 PM

Im getting the following DB error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL:
SELECT logid, username, userid, target, targetid, timestamp, type, postid, comment
FROM warnings_log
ORDER BY logid
LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Saturday 07th of September 2002 08:41:41 PM

Any help!

Buddha 09-07-2002 06:54 PM

same here.
no white screen anymore, but no warnlink either.
???

Okiewan 09-07-2002 07:01 PM

You are getting that error when trying to view the logs from the CP, correct? Same thing here.

The Realist 09-07-2002 07:05 PM

Also I have put in place in the postbit template the following:

<p align="right"><smallfont><a href="report.php?s=$session[sessionhash]&postid=$post[postid]">Report this post to a moderator</a> | $post[iplogged]<br>$post[warnlink]</smallfont></p>

But the warnlink is not showing on the forum?

Buddha 09-07-2002 07:08 PM

when i ran the install_warning.php again (as per upgrade instructions), got this error

Quote:

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: ALTER TABLE user ADD warninglvl int(10) NOT NULL DEFAULT '0'
mysql error: Duplicate column name 'warninglvl'

mysql error number: 1060

Date: Saturday 07th of September 2002 02:04:41 PM
Script: http://www.fulldvdreview.com/admin/i...ing.php?step=2
Referer: http://www.fulldvdreview.com/admin/install_warning.php
don't know enough about this stuff to know if the script will continue even if there is an error, or just stop.
the duplicate column wouldn't be a big deal, but if the script stops when an error occurs, then there may be a problem.

Okiewan 09-07-2002 07:10 PM

Quote:

Originally posted by Buddha
when i ran the install_warning.php again (as per upgrade instructions), got this error


Because it was already there from your previous install... if you delete that in the user table, you won't get the error. It will continue to make duplicate templates though.

Buddha 09-07-2002 07:13 PM

well, hopefully this will be fixed, as it looks fantastic and would be useful... but i can't even see it in the admin cp right now, let alone the warn link.

*fixed part of the problem... can at least see it in admin cp now*

Buddha 09-07-2002 07:16 PM

i'm curious... installation text says to change warnconfig and upload.... upgrade install says delete it.
is it needed?

Okiewan 09-07-2002 07:30 PM

Quote:

Originally posted by Buddha
i'm curious... installation text says to change warnconfig and upload.... upgrade install says delete it.
is it needed?

Not if you upgrade to 2.1, the permissions are written directly in the admin/functions.php file with 2.1, where it was in warnconfig.php in 2.0. The problem is with 2.1, I can't figure-out where to set the various usergroup permissions now, pretty sure that's why it's (the warn link) not showing-up in postbit, but that's just a guess.

snyx 09-07-2002 07:30 PM

intense bro. nice.

Chris M 09-07-2002 07:33 PM

Warnconfig.php is needed for 2.0...

I dunno about 2.1...

Satan

g-force2k2 09-07-2002 07:34 PM

Notice: you must submit the vbulletin options update for everthing to become active... that will fix all the problems as stated in the thread... regards...

Edit: hellsatan is correct... hellsatan if 2.0 works good then cool :) no probs... bu 2.1 requires no warnconfig.php and requires you to UPDATE your VBULLETIN OPTIONS... regards... hope this solves all the issue :)

g-force2k2

Okiewan 09-07-2002 07:41 PM

Uhhhhh ? There's supposed to be something about this hack in vBulletin Options? Maybe I shouldn't be trying to install a hack today, because I'm seriously lost at this point :ermm:

If I simply open vB options and submit it... still nothing.
Where does someone set usergroup permissions in 2.1? ie; which can warn, seen warnings, etc., etc.

g-force2k2 09-07-2002 07:43 PM

In the Admin CP you need to update the vBulletin Options... regards...

g-force2k2

Okiewan 09-07-2002 07:45 PM

Been there, done that. Nada.

g-force2k2 09-07-2002 07:50 PM

The new v2.1 install automatically inserts all of the settings into the vBulletin Options and that's where all of the options are... That's why you need to configure and update the vBulletin Options... Have to go to work... If problems persist I will support tonight when I get home... regards...

g-force2k2

Buddha 09-07-2002 07:52 PM

Quote:

Originally posted by Okiewan
Been there, done that. Nada.
same.
still get the error when viewing the logs, and no link.

Buddha 09-07-2002 07:53 PM

the new install btw, gives errors... as i mentioned in a prior post... do you have a workaround for that?

Okiewan 09-07-2002 07:55 PM

Quote:

Originally posted by Buddha
the new install btw, gives errors... as i mentioned in a prior post... do you have a workaround for that?
Yes... remove the warnlvl line from the user table.

Odd, the new install inserted nothing in the vB options. Oh well, will try later I guess :(

Vivi Ornitier 09-07-2002 08:09 PM

well i seem to have installed the hack fine cause all my pages are working and the install problem went out without a glitch. Now, it wouldn't display the warning links and level in the postbit.

In the old version it was this:

$post[warnings]

The new one is:

$post[warnlink]

But in the forum, it doesn't show up anything at all. Can u add the links and warning level manually??

So instead of putting $post[warnlink] u can add the links and all the code in the postbit template?

Chris M 09-07-2002 08:14 PM

I havent tested it, but this file below should insert the stuff into the settings...

Disclaimer: - I have just modified a file, in order to help out g-force on this occasion...I take no credit for any of the work...

Please Note: This file is ONLY to be used if you have not got the settings installed to your vB Options, AND are running Version 2.1 of this hack...

Satan

Buddha 09-07-2002 08:21 PM

booyeah.
thank you hellsatan!
everything seems to work now.
much appreciated!

*clicks installed*

Buddha 09-07-2002 08:30 PM

well, played around with everything, and it works great.

excellent hack... thanks for all the hard work.

Chris M 09-07-2002 08:34 PM

Lol...

@g-force - If you keep getting reports of this problem, I recommend adding the "install_settings.php" file to your .zip file:)

It seems to have worked for Buddha:)

@Okiewan - I think you should try it:) See if it helps you:)

Satan

The Realist 09-08-2002 12:16 AM

Found problem with below. There was a , at the end of the query when there should not have been.

Still looking into the warning link and why it will not show.

L8tr

Quote:

Originally posted by The Realist
Im getting the following DB error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL:
SELECT logid, username, userid, target, targetid, timestamp, type, postid, comment
FROM warnings_log
ORDER BY logid
LIMIT 0,
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Saturday 07th of September 2002 08:41:41 PM

Any help!


The Realist 09-08-2002 01:24 AM

Found problem with warning link not showing as well :)

Go to VB options and setup what usergroups have access to what and all is fine.

The reason I could not see it was that I did not have admin usergroup ID listed as one of the groups who can see the link.

Do that and all is fine :)

L8tr

hypedave 09-08-2002 04:21 AM

dude you rock !!!!! you installed the email feature woo hoooo
thanks man keep up the good additions

g-force2k2 09-08-2002 06:53 AM

yeah thanks hellsatan... in my upgrade directions it does say to uninstall and then rerun the installer... but either way is fine ;) regards... thanks for the help btw...

g-force2k2

wooolF[RM] 09-08-2002 09:00 AM

]everything works except I can't see $post[warnlink] ... it just give me blank space... :(

yes, i have edited all files, runned all queries and edited all templates... :/

and I have edited settings in the admin panel and saved them

Erwin 09-08-2002 09:09 AM

One tip - for those with many hacks that uses the settingid's, you may want to use a higher settingid than 40 - otherwise you get a db error. You don't actually have to set a settingid - the variables are auto-incremental. If people are getting errors, replace all the 40 with 140 which shouldn't interfere with other hacks that uses settingids.

Otherwise, the hack is brilliant. I just had to tidy up the profile a bit, but it works great. Thanks!

wooolF[RM] 09-08-2002 09:11 AM

]good tip, lemme try :D

wooolF[RM] 09-08-2002 09:16 AM

]Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO setting VALUES (NULL,240, 'No Warning Usergroups', 'NOwarn', '6', 'The usergroupids for the usergroups that can\'t be warned! (seperate each usergroupid by a comma)', '', 5,)
mysql error: You have an error in your SQL syntax near ')' at line 1

mysql error number: 1064


:(((((((((((((((((((((((((

wooolF[RM] 09-08-2002 09:21 AM

I have changed all "40" to "140"... error...
then changed to "240" ... same error...

I have updated my admin cp, tried hellsatan's install_settings.php + tried to do it with mysqladmin...

<-- LOST

wooolF[RM] 09-08-2002 09:34 AM

]now I have deleted all values that have been imported in the DB in setting and settinggroup tables...

tried file by hellsatan again... no luck ...

argh... :(

wooolF[RM] 09-08-2002 09:45 AM

]script DOES insert these values into DB (checked)

Code:

200 140 Warning Logs Per Page WLOGSpp 20 The number of warning logs to show per page!  1
Edit  Delete  201 140 Register Group REGgroup 2 The usergroupid for the registered usergroup!  2
Edit  Delete  202 140 Maximum Ban Limit BANtot 25 The total amount of warning points before user is ...  3
Edit  Delete  203 140 Banned by Warnings Group BANgroup 16 The usergroupid for the banned by warnings usergro...  4

+ it makes group in settinggropu table as
140 Warnings System 140

after this I get error in the script :
Code:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO setting VALUES (NULL,140, 'No Warning Usergroups', 'NOwarn', '6', 'The usergroupids for the usergroups that cant be warned! (seperate each usergroupid by a comma)', '', 5,)
mysql error: You have an error in your SQL syntax near ')' at line 1

mysql error number: 1064

:(

Chris M 09-08-2002 10:22 AM

Hmmm...

Erwin has found out why you have got errors - Conflicting Setting Ids...

Im not sure how to help:(

Satan


All times are GMT. The time now is 05:35 PM.

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.01761 seconds
  • Memory Usage 1,821KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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