vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Advanced Warning System (Beta Version) (https://vborg.vbsupport.ru/showthread.php?t=95921)

[Stryder] 09-17-2005 11:24 PM

Where do you set up the warning types, I can't find it.

Andreas 09-17-2005 11:28 PM

ACP / Advanced Warning System

Xplorer4x4 09-17-2005 11:53 PM

When T instal the product XML there is a Phrase Error even thought it updates all the templates.

Parse error: parse error, unexpected ';' in /forums/admincp/plugin.php(1192) : eval()'d code on line 12

The hack also caused a DB error whenever I tried to edit a user.

Andreas 09-18-2005 12:22 AM

Which product Version did you try to install?

Xplorer4x4 09-18-2005 03:38 AM

I had an old product version, but still having a database problem when I try to edit a user. I uploaded the new PHP files just to be safe. It does not happen if I disable this hack.

PHP Code:

 Database error in vBulletin 3.5.0 Release Candidate 3Invalid SQL:
UPDATE user SET
### Bitfield: user.options ###
options = IF(options 8options 8options),
options = IF(options 1024optionsoptions 1024),
options = IF(options 16optionsoptions 16),
options = IF(options 256options 256options),
options = IF(options 512options 512options),
options = IF(options 32options 32options),
options = IF(options 2048optionsoptions 2048),
options = IF(options 4096options 4096options),
options = IF(options 1optionsoptions 1),
options = IF(options 2optionsoptions 2),
options = IF(options 4optionsoptions 4),
options = IF(options 64optionsoptions 64),
options = IF(options 128options 128options),
options = IF(options 32768options 32768options),
usertitle 'Wrestling Student',
customtitle 0,
username 'Mika',
email '',
languageid 1,
homepage '',
birthday_search '1972-01-18',
birthday '01-18-1972',
icq '',
aim '',
yahoo '',
msn '',
parentemail '',
posts 101,
referrerid 0,
ipaddress '***.***.***.***',
ucash '1838.59',
vbookie_cash 500,
alerts 0,
warnings 0,
warning_level 0,
warning_bans 0,
usergroupid 13,
reputationlevelid 5,
reputation 20,
pmpopup 1,
autosubscribe = -1,
threadedmode 0,
showvbcode 1,
styleid 0,
timezoneoffset '-6',
daysprune 0,
joindate 1125405420,
lastactivity 1127005860,
lastpost 1127005860,
membergroupids ''
WHERE userid 125MySQL Error Unknown column 'alerts' in 'field list'
Error Number 1054
Date         
SaturdaySeptember 17th 2005 11:27:07 PM
Script     
: /forums/admincp/user.php
Referrer     
: /forums/admincp/user.php?do=edit&u=125
IP Address 

Username     Xplorer4x4
Classname    
vb_database 

I am still getting a completley white DB error page(not just the main frame) when I click Statistics - Warnings Per User.
PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:
Invalid SQL:
SELECT COUNT(*) AS users FROM user AS user where warnings>OR alerts>0;
MySQL Error Unknown column 'warnings' in 'where clause'
Error Number 1054
Date         
SaturdaySeptember 17th 2005 11:35:18 PM
Script     
http://www.xtremepain.net/forums/admincp/admin_warn.php?act=viewwarnedusers&type=warnings
Referrer     http://www.xtremepain.net/forums/admincp/index.php
IP Address 
Username     Xplorer4x4
Classname    
vb_database 

I am also noticing that if a user has entered a yahoo ID, 2 vertical columned yahoo icons apear under the typical horizontal row of online icons.

I also have a cutom profile field on my postbit_legacy. This has changed the font of it as well.

NOTE That I have not installed any template mods yet.

Any idea how to fix this? Thanks Kirby.

Andreas 09-18-2005 05:51 AM

Did you use the 3.0 Version and still have old Data (warnings, etc.) in your database?
If not I suggest to uninstall and then import the XML again.

There is no way your Templates can be affected if you did not apply Template Edits yet.

SkyShadow 09-18-2005 09:37 AM

I have installed a old version of AWS. I mean it was 3.4.10.

Is it possible to use the old databases with the 3.5. version of this hack?

Andreas 09-18-2005 10:01 AM

Yes, should work just fine.
To be 100% safe, I suggest to backup AWS tables (warnings, warn_notes, pmtext_warned, ban_dates; maybe also user and userban) first.

Xplorer4x4 09-18-2005 04:56 PM

Quote:

Originally Posted by KirbyDE
Did you use the 3.0 Version and still have old Data (warnings, etc.) in your database?
If not I suggest to uninstall and then import the XML again.

There is no way your Templates can be affected if you did not apply Template Edits yet.

I uploaded the latest XML and PHP files. It erassed all the previous warning data.

As far as the Yahoo icon problem goes, well I only installed two hacks yesterday and I uninstalled the other(PayPal Donations Hack).

Thanks.

Chad F. 09-18-2005 06:29 PM

When I try to delete a warning type it says "Unable To Find Warning Type [ Go Back ]"


All times are GMT. The time now is 07:45 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.02008 seconds
  • Memory Usage 1,779KB
  • 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_php_printable
  • (1)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