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

Page 10 of 28

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

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

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

- - Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar/ Picture (https://vborg.vbsupport.ru/showthread.php?t=59718)

Dan	02-10-2004 10:37 AM

With Erwin's Permision I've made an HTL Version of this hack.

[high]Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar[/high]
Version: 1.1
vB-version: 3.0.0 Release Candidate 3
Developer: Dr. Erwin Loh
Install-difficulty: Medium
File-edits: 8
Template-edits: 2

[high]Description of the Hack:[/high]
Okay, this is my private forum's custom warning/ suspension/ banning system and postbit moderator system. This is a fairly involved hack, so it is crucial that you follow the instructions closely. It would benefit experienced hackers the most. The following instructions are for an unhacked board. If you have hacked your board, or use different moderator usergroups, just make the appropriate changes.

dano	02-10-2004 10:08 PM

If all I want to do is make it so that I have a Troll banned members group, what sections of this code would I have to use? I dont really need the rest, but I do want to be able to ban people and make their posts invisable etc.

Dan	02-11-2004 10:38 AM

Quote:

Originally Posted by Erwin

[b][color=yellow]
HTL version (thanks to Dano) here:

Attached Fileshttps://vborg.vbsupport.ru/Warning_System_Automatic_Ban_Make_Posts_Invisible_ Edit_Signature_Avatar.htl

*cough* dan *cough*

kernel16

02-11-2004 05:55 PM

Quote:

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL:
SELECT threadid, user.usergroupid AS usergroupid
FROM vb3_thread AS thread
LEFT JOIN vb3_user ON user.userid = postuserid
WHERE forumid = 147
AND sticky = 0
AND visible = 1
AND usergroupid<>14

AND thread.lastpost >= 1073937141

ORDER BY sticky DESC, thread.lastpost DESC
LIMIT 0, 10

mysql error: Unknown table 'user' in field list

mysql error number: 1109

k what could have i done wrong?

dano	02-13-2004 03:21 PM

Quote:

Originally Posted by dano

Anyone?

Erwin

02-14-2004 01:06 AM

Quote:

Originally Posted by kernel16

k what could have i done wrong?

You didn't make all the modifications in the instructions.

Sonic625

02-17-2004 02:27 AM

Adding a suggesstion, Is there anyway to get the warning level incorporated in the postbit without viewing the profile like by the "report" and "IP" buttons?
Like someone else said its a great hack but doesn't really warn people unless you manually warn them.
Thanks

Zelda-King

02-17-2004 07:06 AM

Well he did say he wouldn't customise the hack for us. It doesn't look like he's interested in having it that way for whatever reason. Actually I really don't mind the manual warnings as automated ones don't really get to the point of the individual occasion anyway unless an input field is applied. Replace the word 'warning' with the word 'strike' perhaps...

mOdEtWo

02-18-2004 10:26 AM

Erwin, thanks for a great hack.

I'm having a problem tho. Whenever I try to access a forum, I get a MySQL error message (however, the forum home (index.php) is fine).

Code:

Database error in vBulletin 3.0.0 Release Candidate 4:



Invalid SQL: 

                SELECT COUNT(*) AS threads,

                // [START HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar' AUTHOR='Dr. Erwin Loh' VERSION='1.1' CHANGEID= 4 ]

SUM(IF(thread.lastpost>=1077102501 AND open<>10,1,0)) AS newthread

// [END HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar' AUTHOR='Dr. Erwin Loh' VERSION='1.1' CHANGEID= 4 ]

                FROM thread AS thread

                

                WHERE forumid = 4

                        AND sticky = 0

                        AND visible = 1

                        

                        

                        

                        

        

mysql error: You have an error in your SQL syntax near '// [START HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signat' at line 3



mysql error number: 1064

What have I done?

Zelda-King

02-18-2004 12:47 PM

That's because you've used the HTL. It automatically puts in that "START HACK/END HACK" lark and it's INSIDE the query. Remove those lines.

All times are GMT. The time now is 11:19 AM.

Page 10 of 28

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01316 seconds Memory Usage 1,746KB 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 (1)bbcode_code_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: