vb.org Archive - Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar/ Picture

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

aahh that sounds great. Any idea on time scale. I am only asking as i will ununistall this and install the new one when its out.

I installed this on a 3.0.3 installation; after following all the instructions etc, I was able to get the menu to appear; but when I click warn user, the new window comes out blank! Is this hack compatiable with 3.0.3? Did I do something wrong?

Ok, here's what I found out after some reading...

The code is looking for "warn" template, which I did not add because it was NOT included in the package. Can someone please kindly post the warn/warning template that we're suppose to add?

I have had the excact samt problem. But was a little confused about the post from "Zero Tolerance". Here the hole edited code-section. I hope this can help others:

Quote:

$getthreadids = $DB_site->query("
SELECT " . iif($sortfield == 'voteavg', $votequery) . " threadid, " . TABLE_PREFIX . "user.usergroupid AS usergroupid
FROM " . TABLE_PREFIX . "thread AS thread
$deljoin LEFT JOIN " . TABLE_PREFIX . "user ON " . TABLE_PREFIX . "user.userid = postuserid
WHERE forumid = $foruminfo[forumid]
AND sticky = 0
AND visible = 1
AND usergroupid<>24
$globalignore
$datecut
$limitothers
$delthreadlimit
ORDER BY sticky DESC, $sqlsortfield $sqlsortorder
LIMIT $limitlower, $perpage
");

Quote:

Originally Posted by Zero Tolerance

Someone else has had this error, and im getting it too

Code:

Database error in vBulletin 3.0.0 Release Candidate 4:



Invalid SQL:  

        SELECT  threadid, user.usergroupid AS usergroupid 

        FROM vb3_thread AS thread 

          LEFT JOIN vb3_user ON user.userid = postuserid 

        WHERE forumid = 5 

            AND sticky = 0 

            AND visible = 1 

            AND usergroupid&lt;&gt;17 

             

            AND thread.lastpost &gt;= 1075634033 

             

             

        ORDER BY sticky DESC, thread.lastpost DESC 

        LIMIT 0, 20 

    

mysql error: Unknown table 'user' in field list

Ive redone edits for all files, still didn't work, maybe if you could point out the exact edit that fixes this that might help, but i dont see any ive missed and ive gone through them all

Edit:

I fixed it, in the code i changed user. (2 times) to

PHP Code:


		
			
" . TABLE_PREFIX . "user.

Seems those with a prefix may have trouble with this ;)

There are missing som "TABLE_PREFIX" lines ind the file warn.php

Here are my code-section (that works for me)

Code:

if ($action == "doadd") {

$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=$warnfield+1 WHERE userid='$newuser'");

if ($warnings >= $warnpoints) {

$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET usergroupid=$banusergroupid, usertitle='Banned' WHERE userid='$newuser'");



}

$error = "<b>Message:</b> You have warned this member!";

        $show['closewindow'] = true;

}

if ($action == "dominus") {

$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=$warnfield-1 WHERE userid='$newuser'");

$error = "<b>Message:</b> You have warned this member!";

        $show['closewindow'] = true;



}

if ($action == "doreset") {

$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET $warnfield=0 WHERE userid='$newuser'");

$error = "<b>Message:</b> You have warned this member!";

        $show['closewindow'] = true;

for some reason I am getting a 500 error on this now. i think it was the 3.02 upgrade, but not sure when it happened

This was my first attempt at installing a hack and I apparantly blew it. When I click on a users name I only get the default option instead of the hack options to ban, warn, etc.

Anyone have any idea what I did wrong. I was very careful and deliberate as I went through the instructions but must have missed something.

Thanks,

Erwin...

1) Does this hack work for vB3.0.3?

2) Did you get your "proper warning" code added?

Thanks!

Quote:

Originally Posted by Dennis Olson

Erwin...

1) Does this hack work for vB3.0.3?

2) Did you get your "proper warning" code added?

Thanks!

It works for 3.0.3 - actually, I installed integrated my hack with the other warning hack, and added a whole bunch of stuff including PM user on thread delete/ closure/ move, email user on ban, a whole lot of stuff. :) This hack is actually redundant. I can't release my current system as I'm using code from the other warning hack.

Quote:

Originally Posted by Erwin

I know you can not release the whole hack as like you said you used some code from it, but anychance you may release add-ons for it :) So we have the best of both? I love this hack but i was hanging around for the updates.

X vBulletin 3.8.12 by vBS Debug 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 (1)bbcode_php_printable (4)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01312 seconds Memory Usage 1,751KB 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 (1)bbcode_php_printable (4)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
Messages: