vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/showthread.php?t=71992)

sv1cec 01-06-2005 06:11 AM

Refering to the warned post being marked, I was thinking about this and I want to share those thoughts with you.

At the moment, the only place where the warned postid is stored, is in the table warnings. If we were to have a "red flag" for posts that have been warned, that means that I should add a query, which will read the warnings table, for each post. Too much server overload I think.

The alternative would be, to mark the post as "warned" in the "post" table. In that way, when the post is read, to be displayed, the warned red flag is read as well. But, that means that almost all files that issue "post-related" warnings, will have to be edited (off my head right now, I would say that these are three or four files, but maybe I can make it less).

I think I should do it that way, otherwise I know one member here, whose hair will stand up, if we add another query per shown post.

Rgds

Viol8or 01-06-2005 10:04 AM

I like the alternative option. Doesn't have to be included right away, if done in a next release I would be more than happy :)
Thanks for being so cooperative and active responding!

Viol8or 01-06-2005 10:10 AM

Maybe another possibility (but hey I'm just a php/mysql noob) ... just give a pop up or warning to the moderator when they try to give a second warning to an already warned post.
That why I think you only got to store the id's of the marked posts and query them when a new warning is been issued.
But then again, I'm just a noob in these things.

sv1cec 01-06-2005 12:09 PM

Well folks, here is what I've done. I added a column in the post table. Every time a post is warned, I add 1 to that column. Every time a warning is removed, I subtract 1 from that column. If that column is >0, then there is at least one warning for that post. If this is so, a large stop-like sign appears in the postbit, in that post.

I just uploaded 3.0.6.

One more thing. If there are any users who still have problems with 3.0.5 or any previous release, please let me know now.

Thanks and Rgds

Rhoads 01-06-2005 02:55 PM

Thnx, works fine, but :

In users management, still it just takes me to a blank screen with a Internal Server Error when I selecting Warn User.

sv1cec 01-06-2005 04:04 PM

Quote:

Originally Posted by drl2005
Thnx, works fine, but :

In users management, still it just takes me to a blank screen with a Internal Server Error when I selecting Warn User.

Do you also get an error when trying to warn someone from their Profile?

Rgds

Rhoads 01-06-2005 05:11 PM

Quote:

Originally Posted by sv1cec
Do you also get an error when trying to warn someone from their Profile?

Rgds

No, than is works fine, the link brings me to example : http://www.mysite.nl/forum/Warn.php?...erNoPost&id=61

From the users management the link brings me nowhere.

Maby it's a problem of my forum DIR, I have my home page in the root en than a forum DIR.

mikaelweb1 01-06-2005 05:47 PM

Database error in vBulletin 3.0.4:

Invalid SQL: insert into warnings values('','30','1','1105040863','','256','2','N',' A','','')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

sv1cec 01-06-2005 06:54 PM

Quote:

Originally Posted by mikaelweb1
Database error in vBulletin 3.0.4:

Invalid SQL: insert into warnings values('','30','1','1105040863','','256','2','N',' A','','')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Not very helpful, I need more info to help you out. Where you get that, under what conditions, what options you use etc. Try to be more descriptive.

sv1cec 01-06-2005 06:59 PM

Quote:

Originally Posted by drl2005
No, than is works fine, the link brings me to example : http://www.mysite.nl/forum/Warn.php?...erNoPost&id=61

From the users management the link brings me nowhere.

Maby it's a problem of my forum DIR, I have my home page in the root en than a forum DIR.

If your forum directory is one level up from the admincp directory, it should work fine.

Do this test. While you are in your admincp, go to the address bar of your browser and enter this :

http://www.mysite.nl/forum/admincp/../Warn.php?$session[sessionurl]do=WarnUserNoPost&return=user&id=61

Does that bring you anything?

Rgds


All times are GMT. The time now is 03:48 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.01681 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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