vb.org Archive
Page 27 of 105 « First 172526 27 28293777 Last »
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)
-   -   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/showthread.php?t=71992)

TRStealth 12-12-2004 05:16 PM
I'm getting a problem:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: update warning_options set
hierarchical='No',
automatic='No',
automaticpm='No',
warner='1',
automatic_warner='1',
banned_limit='5',
points_before_banned='10',
banned_usergroup_id='8',
troll_usergroup_id='8',
protected_usergroups='5|6|7|11|14|5|6|9|13|15|12|10',
aprotected_usergroups='11|14|5|6|9|13|15|12|10',
restore_groupid='',
incr_ban_days='Yes',
max_no_bans='2',
viewoption='Mgm',
multiple_per_post='No',
send_pm_warning='Yes',
send_em_warning='No',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='30'
 where oid='1'
mysql error: Unknown column 'automaticpm' in 'field list'

mysql error number: 1054

Date: Sunday 12th of December 2004 07:14:35 PM
Script: http://www.enclave1.net/forums/admincp/admin_warn.php
Referer: http://www.enclave1.net/forums/admincp/admin_warn.php?act=manageoptions
Username: Stealth
IP Address: xx.xx.xx.xx
Also, when I go to Warn.php?do=ViewMyWarnings , it just comes out as a blank page.

sv1cec 12-12-2004 07:48 PM
Quote:
Originally Posted by Shack Networks
OK I have been thinking and had another idea lol

Would it not be able to be adapted to detect duplicate posts and possibly add a warning point to the offending member ?

Just a little idea to keep you busy over xmas lol

Thanks a lot for this hack, I can not start to express my gratitude enough.

H
If I am not mistaken, if you try to enter the same exact post twice, vB is telling you you are not allowed to do that. Maybe I can check that code and see how it is done, and adapt it. The think is, I am quite overbooked for Christmas, Revan just send me his version of this hack, which is using the vboptions for the warning options (I am not exactly sure what the benefits are), and I have a couple of ideas I want to incorporate before Christmas. Oh yes, I also do not know if the nursery schools have Christmas vacations like normal schools do, if they do have, forget me for the duration of the Holidays Season. I'll be too busy taking care of the twins.

LoL

Delphiprogrammi 12-12-2004 08:27 PM
hi,

allright i got a version number at the upper right corner but not tin the warning template probably i'm doing something wrong gonna leave it alone for a while now before i screw up out of "nervosity"

sv1cec 12-13-2004 04:05 AM
Quote:
Originally Posted by Delphiprogrammi
hi,

allright i got a version number at the upper right corner but not tin the warning template probably i'm doing something wrong gonna leave it alone for a while now before i screw up out of "nervosity"
Just make the start of your template look like this:

HTML Code:
<form action="Warn.php" method="post">
<input type="hidden" name="do" value="DoWarnUser">
<input type="hidden" name="id" value="{$_GET['id']}">
<input type="hidden" name="post" value="{$_GET['post']}">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tfoot" colspan="2">Advanced Warning System - Version $warn_opts[version]</td>
</tr>
<tr>
        <td class="tcat" colspan="2">Warning User $user[username]<div class="smallfont">All links below, will open a new browser window, close it to return here.</div></td>
</tr>
Mind you the templates changes were in 2.3.1, but that shouldn't make any difference.

Rgds

Delphiprogrammi 12-13-2004 11:38 AM
it's working :rolleyes:


:D

sv1cec 12-13-2004 12:09 PM
Quote:
Originally Posted by Delphiprogrammi
it's working :rolleyes:


:D
I am glad you got it working.

Rgds

Curzon564 12-13-2004 09:24 PM
This hack is really great!

Most things seem to work now on my board but there is still one problem I can't fix.

Quote:
Datenbankfehler in vBulletin 3.0.3:
Ung?ltiger SQL String: insert into vb_warnings values('','1222','1','1102977604','','25841','2',' N','A','','')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
I can't find any error in my warnings table

Quote:
wid int(15) Nein auto_increment
warned_user int(15) Nein 0
warned_by int(15) Nein 0
warned_time int(15) Nein 0
warned_reason text Nein
warned_post int(15) Nein 0
warned_warning_id int(15) Nein 0
warned_status char(1) Ja NULL
removed_by int(15) Ja NULL
removed_date int(15) Ja NULL
Any solution for this?

sv1cec 12-14-2004 03:39 AM
Quote:
Originally Posted by Curzon564
This hack is really great!

Most things seem to work now on my board but there is still one problem I can't fix.



I can't find any error in my warnings table



Any solution for this?
Yes, you have not run the query that adds the "caused_ban" column in your warnings table. Run it now:

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id

Rgds

SamirDarji 12-14-2004 03:49 AM
Quote:
Originally Posted by sv1cec
Yes, you have not run the query that adds the "caused_ban" column in your warnings table. Run it now:

ALTER TABLE `".TABLE_PREFIX."warnings` ADD COLUMN `caused_ban` char(1) AFTER warned_warning_id

Rgds
Hey John, wanna start fixing this hack? ;)

sv1cec 12-14-2004 03:52 AM
Quote:
Originally Posted by SamirDarji
Hey John, wanna start fixing this hack? ;)
What you mean "fix this hack"? I am doing my best!!!

Rgds


All times are GMT. The time now is 09:32 AM.
Page 27 of 105 « First 172526 27 28293777 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.01508 seconds
  • Memory Usage 1,756KB
  • 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
  • (1)bbcode_html_printable
  • (8)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