vb.org Archive
Page 27 of 29 « First 172526 27 2829
Show 40 post(s) from this thread on one page

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)

sv1cec 07-12-2006 08:38 AM
Phiber, you are not reading the proper instructions. The part that you posted above, is from the instructions on how to add the Notes capability, in an already installed AWS. Check the instructions included in the AWS zip file.

AzzidReign 07-12-2006 02:39 PM
I think I figured out my problem...I just dont know how to fix it. There is a glitch with the signature tag (at least in firefox, I havent tested in IE). When there is no signature, the post will be made centered vertically.

Do you know how to fix them sv1cec?

sv1cec 07-12-2006 05:38 PM
Start with a new template and edit it according to the instructions.

phiber 07-16-2006 09:33 AM
sv1cec thanks for your previous answer!

And now another... xD, yesterday I had a "problem" with a Moderator because he remove accidentaly my warn to a user... How can I avoid that? How can only a Mod remove their own? And SMods their own and Moderators ones, and Admins all? or SMods and Admins all...

Thanks in advance!

Edit: Oh, I have just seen and answer for that problem, but for unable the remove warning to mods and smods... How to remove only for mods? And there you said only "fake" remove, but not delete... How to restore a Warn removed by a Mod?

Thanks again, and sorry my English!

sv1cec 07-16-2006 11:39 AM
It's doable, but you have to run an SQL query, and since this can mess up your database, I would not like to give you more details. You'd better remove the warning all together, and explain the member that if he does the same, he is doomed.

phiber 07-16-2006 11:44 AM
LOL, Ok, Thanks ^^

Delphiprogrammi 07-16-2006 01:54 PM
how about a permission control the admin can set "can issue warnings" to yes and "can remove warnings" to no .... that would solve his problem

Restoring a removed warning is possible but like John already said it's kind of risky.

1)open /includes/xml/bitfield_aws.xml and find

Code:
<bitfield name="canviewwarnings" group="awspermissions" phrase="canview_warnings">8</bitfield>
below that add

Code:
<bitfield name="canremovewarnings" group="awspermissions" phrase="canremove_warns">16</bitfield>
save this file and upload it to /includes/xml folder

2)go into your admincp and add a new phrase

varname:canremove_warns
text:can remove warnings ?
phrasetype:permissions
product:aws

save the phrase

3)open Warn.php and find

PHP Code:
if($_GET['do'] == "RemoveWarning")
{
$vbulletin->input->clean_array_gpc('g',array(
        'id'      => TYPE_INT,
        'post'    => TYPE_INT,
        'do'      => TYPE_STR,
        'return'  => TYPE_STR,
    )); 
just below that

PHP Code:
if (!($vbulletin->userinfo['permissions']['awspermissions'] & $vbulletin->bf_ugp_awspermissions['canremovewarnings']))
    {
        RunErrorAws("you do not have permission to remove warnings");
    } 
4) edit your usergroups where you want to enable / disable the new permission usergroups => edit also remember to rebuild the vbulletin bitfieldcache you can do this by pointing your browser to

http://www.yourserver.com/forums/adm...buildbitfields

that should do it if not give me a yell

barca4ever 07-16-2006 09:43 PM
Is there's a way to prevent super-moderators and moderators from removing warnings?

In other words, I want only administrators can remove a warning

Thanks in advance ;)

bigM 07-17-2006 08:16 AM
I have forgotten to refresh the AdminCP. Problem has been fixed ;)

Delphiprogrammi 07-17-2006 09:02 PM
Quote:
Originally Posted by barca4ever
Is there's a way to prevent super-moderators and moderators from removing warnings?

In other words, I want only administrators can remove a warning

Thanks in advance ;)
here hint set that permission to no for moderators and supermoderators

FatalBreeze 07-21-2006 02:52 PM
i like your hack very much thanks :)
i just have a little comment: in the install file (txt), in a template modification, you spelled $vbphase[...] instead of $vbphrase.
im sorry but i dont remember exactly where it is, but use ctrl+f.

GoTTi 07-22-2006 09:40 AM
for some reason, when a user gets warned, the post they are warned on gets all wierd looking.

attached is a example.

what is causing this?

EdQ 07-26-2006 12:54 PM
Quote:
Originally Posted by Delphiprogrammi
hi people,

I'm still alive.My site is upgraded to 3.6 but i don't understand how the "infractions" system works to complacated if you ask me.SOw i'm thingking of getting aws to 3.6 some changes needed for this through

That would be great! I am still using your Mod on 3.6.0

Delphiprogrammi 07-27-2006 06:02 AM
Quote:
Originally Posted by GoTTi
for some reason, when a user gets warned, the post they are warned on gets all wierd looking.

attached is a example.

what is causing this?
yes you edited that template incorrectly ... or does it only happen when you use the this hack ? then i would check the code involved on postbit & postbit_legacy template

shockx5 07-27-2006 09:12 PM
So I have 3.5.4 and am using the version before the current AWS...do i just upload all the files again and the product to update? Or do I need to uninstall the product and reinstall the new one along with uploading the new files. The original version has been acting screwy with people not being banned when the correct number of warnings is reached etc.

Gaileypoo 07-30-2006 07:01 PM
I tried a test run on a regsitered user account, and when i tried to view my warnings it came up with this "You do not have permissions to view warnings information"

What happened? :\ I set it to "ALL" to viewing warnings.

Delphiprogrammi 07-30-2006 08:17 PM
Quote:
Originally Posted by Gaileypoo
I tried a test run on a regsitered user account, and when i tried to view my warnings it came up with this "You do not have permissions to view warnings information"

What happened? :\ I set it to "ALL" to viewing warnings.
A normal user cannot view warnings unless the warning issued to themself the setting you refer to is for mods and up

Gaileypoo 07-30-2006 09:23 PM
Oh.. I see. Thank you.

I have another problem though. =\ I set up "auto warns" for obscene words , but for some reason, it's not working. I set up the right ID and everything. Created a warning type "ObsceneWords" I did a test on this too and the warning didn't show up on me.

Also.. if I uninstall and reinstall AWS, will I lose all warnings and bans made through AWS?

Thanks for the info~

Delphiprogrammi 07-31-2006 08:47 AM
Quote:
Originally Posted by Gaileypoo
Oh.. I see. Thank you.

I have another problem though. =\ I set up "auto warns" for obscene words , but for some reason, it's not working. I set up the right ID and everything. Created a warning type "ObsceneWords" I did a test on this too and the warning didn't show up on me.

Also.. if I uninstall and reinstall AWS, will I lose all warnings and bans made through AWS?

Thanks for the info~
did you enable automatic warnings ? also did you enable your forum censor and enter some words to be censored for example enter "++++" "pussy" into that box when a user trys to use one of these words in a post (and automatic warnings are on) then he is busted ....

you will not loose the warnings information if you create a backup of it through phpMyAdmin

Also make sure 'ObsceneWords' warningtype is set to "Auth"(short for automatic)

engedi05 08-01-2006 10:01 AM
in the readme text.. it said, Upload the Files in Folder upload to the appropriate Directories.

what is the appropriate Directories?

engedi05 08-01-2006 10:18 AM
excuse me.. how do i import the xml detail? is this a plug in xml?

Delphiprogrammi 08-01-2006 04:57 PM
Quote:
Originally Posted by engedi05
in the readme text.. it said, Upload the Files in Folder upload to the appropriate Directories.

what is the appropriate Directories?
just follow the vbulletin directory structory upload the contents from /includes to /forum/includes etc :knockedout:

Delphiprogrammi 08-01-2006 04:58 PM
Quote:
Originally Posted by engedi05
excuse me.. how do i import the xml detail? is this a plug in xml?
admincp => plugins & products => manage products => add (as a product)

Delphiprogrammi 08-01-2006 05:13 PM
news,

aws is running on my 3.6.0 RC 3 system.Since these are my first tests the system isn't quite ready ready "enough" for a public release nut it's running good so far

sv1cec 08-02-2006 05:48 AM
Great news Delphi! Great news.

outlaw621 08-02-2006 10:17 AM
Yes. Great news indeed. Cant wait for an updated release. This was the most valuable hack I had installed.

Delphiprogrammi 08-02-2006 11:24 AM
hi people,

I am building the admincp interface.I gotta start all over and build a product file in 3.6.x format (jelsoft changed some stuff in the products system)The phrases part needs some changes to since the phrasetypeid field is removed(phrases are identified through there fieldname)So far it's running good a MySQL error here and there but therefor i am doing tests to catch and fix them

i changed the warnings field in the user table to warns because vbulletin's new infraction system also uses a field called warnings there (avoid conflicts)

the sourcefiles will need to be updated to use the new field

/me goes of to have a beer

updated
John,

Wouldn't it be beter to just leave the "warnings" in place in the user table (and remove the code from the install / uninstall )

vbulletin only uses that field if you use the infraction system so to save some work (and have a system ready earlier) i'm *thinking* about this don't know if this is good through need some advise

eilrahC 08-04-2006 10:27 PM
will this work on 3.5.4 ? or is there another Warnign system for 3.5.4 ?

sv1cec 08-05-2006 05:39 AM
Well, if vB is using one of AWS columns, you'd better create new ones. You never know if a user will activate both the AWS and vB's infractions together.

Also, maybe it is a good time to change the names in the program. I have found that some people get frustrated when "warned". Those types who ask you "Are you threatening me?" when you just tell them they did something silly or against the rules. Maybe we should change the "warning" to "ticket" ? I do not know, I can't think of another word.

Also, one more thing.

In the admin_warn.php, there is a small bug. Consider this situation:

- a member has received a warning for 4 points.
- the moderator who warned him made a mistake and issued the wrong warning type.
- since the moderator is not very experienced he "removes" the warning and then issues a new one let's say for 3 points.
- the administrator sees that and decides to completely remove the first warning, since it shouldn't be in the user's record.
- The "Complete Remove" code removes the first warning, but also removes 4 more points from the user, thus the user ends up with zero points. In other words, the Complete Remove code does not separate between deleting an active warning and an inactive one.

A small piece of code in the form of:

Code:
                if ($warn['warned_status']=='A')
                {
                        $level=($warn['warning_level']-$warn['warn_points']);
                }
                elseif ($warn['warned_status']=='I')
                {
                        $level=($warn['warning_level']);
                }
is needed in the "completeremove" section of admin_warn.php, to separate between removing active and inactive warnings.

Another good idea is to change the wording for remove and complete remove. Maybe the "Remove Warning" should be renamed to "Mature Warning"??

Email me if you want to discuss these further.

Rgds

Delphiprogrammi 08-05-2006 07:25 AM
Quote:
Originally Posted by eilrahC
will this work on 3.5.4 ? or is there another Warnign system for 3.5.4 ?
Yes it will work but be advised jelsoft released 3.5.5 because 3.5.4 contains a hole

Delphiprogrammi 08-05-2006 07:28 AM
hi people,

If you use this system availible right now on a vbulletin 3.6.x system (whatever version) the "view banned users" in the aws menu will not work

reason = jelsoft changed the isbannedgroup permission to isnotbannedgroup

I fixed this already...

Delphiprogrammi 08-05-2006 07:37 AM
Quote:
Originally Posted by sv1cec
Well, if vB is using one of AWS columns, you'd better create new ones. You never know if a user will activate both the AWS and vB's infractions together.
Allright that will mean new fields because the infractions system cannot be disabled.You can only take away permissions to give or view them.Jelsoft stole our field lol

MajorFm.com 08-05-2006 10:17 AM
Ok small problem, just installed, i had the previous version already installed on my previous version of vb, so i want to keep all existing warn data, so i assume i don't delete existing tables etc...

I got this error when importing the product:

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

                                INSERT INTO setting
                                (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
                                VALUES
                                (
                                        'warn_hierarchical',
                                        'warning',
                                        '1',
                                        '1',
                                        'free',
                                        'yesno',
                                        2,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_automatic',
                                        'warning',
                                        '0',
                                        '1',
                                        'free',
                                        'yesno',
                                        3,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_automaticpm',
                                        'warning',
                                        '0',
                                        '0',
                                        'free',
                                        'yesno',
                                        4,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_autocomments',
                                        'warning',
                                        '0',
                                        '0',
                                        'free',
                                        'yesno',
                                        5,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_automatic_warner',
                                        'warning',
                                        '11223',
                                        '1',
                                        'free',
                                        '',
                                        6,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_warner',
                                        'warning',
                                        '0',
                                        '0',
                                        'free',
                                        '',
                                        7,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_collector',
                                        'warning',
                                        '1',
                                        '1',
                                        'free',
                                        '',
                                        8,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_banned_limit',
                                        'warning',
                                        '7',
                                        '7',
                                        'free',
                                        '',
                                        9,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_points_before_banned',
                                        'warning',
                                        '90',
                                        '10',
                                        'free',
                                        '',
                                        10,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_warnings_before_banned',
                                        'warning',
                                        '3',
                                        '10',
                                        'free',
                                        '',
                                        11,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_banned_usergroup_id',
                                        'warning',
                                        '8',
                                        '8',
                                        'free',
                                        '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
                                        12,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_protected_usergroups',
                                        'warning',
                                        '6',
                                        '',
                                        'free',
                                        '',
                                        13,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_troll_usergroup_id',
                                        'warning',
                                        '8',
                                        '9',
                                        'free',
                                        '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
                                        14,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_restore_groupid',
                                        'warning',
                                        '0',
                                        '2',
                                        'free',
                                        '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">(COPPA) Users Awaiting Moderation(id4)</option>\r\n<option value=\\\"6\\\" \" . iif($setting[\'value\']==\'6\',\'selected=\"selected\"\') . \">Administrators(id6)</option>\r\n<option value=\\\"7\\\" \" . iif($setting[\'value\']==\'7\',\'selected=\"selected\"\') . \">Moderators(id7)</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==\'2\',\'selected=\"selected\"\') . \">Registered Users(id2)</option>\r\n<option value=\\\"5\\\" \" . iif($setting[\'value\']==\'5\',\'selected=\"selected\"\') . \">Super Moderators(id5)</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==\'1\',\'selected=\"selected\"\') . \">Unregistered / Not Logged In(id1)</option>\r\n<option value=\\\"4\\\" \" . iif($setting[\'value\']==\'4\',\'selected=\"selected\"\') . \">Users Awaiting Email Confirmation(id3)</option>\r\n<option value=\\\"8\\\" \" . iif($setting[\'value\']==\'8\',\'selected=\"selected\"\') . \">Banned Users(id8)</option>\r\n<option value=\\\"9\\\" \" . iif($setting[\'value\']==\'9\',\'selected=\"selected\"\') . \">Permanent_Ban(id9)</option>\r\n</select>',
                                        15,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_incr_ban_days',
                                        'warning',
                                        '1',
                                        '1',
                                        'free',
                                        'yesno',
                                        16,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_max_no_bans',
                                        'warning',
                                        '3',
                                        '3',
                                        'free',
                                        '',
                                        17,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_bans_mature',
                                        'warning',
                                        '0',
                                        '0',
                                        'free',
                                        '',
                                        18,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_viewoption',
                                        'warning',
                                        'Mgm',
                                        'Mgm',
                                        'free',
                                        '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n<option value=\\\"Mgm\\\" \" . iif($setting[\'value\']==\'Mgm\',\'selected=\"selected\"\') . \">Mgm</option>\r\n</select>',
                                        19,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_multiple_per_post',
                                        'warning',
                                        '0',
                                        '1',
                                        'free',
                                        'yesno',
                                        20,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_send_em_warning',
                                        'warning',
                                        '1',
                                        '1',
                                        'free',
                                        'yesno',
                                        21,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_send_pm_warning',
                                        'warning',
                                        '1',
                                        '0',
                                        'free',
                                        'yesno',
                                        22,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_email_on_ban',
                                        'warning',
                                        '1',
                                        '1',
                                        'free',
                                        'yesno',
                                        23,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_historical',
                                        'warning',
                                        '1',
                                        '1',
                                        'free',
                                        'yesno',
                                        24,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_allowoffpost',
                                        'warning',
                                        '1',
                                        '1',
                                        'free',
                                        'yesno',
                                        25,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_warnings_per_page',
                                        'warning',
                                        '0',
                                        '15',
                                        'free',
                                        '',
                                        26,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_textbutoption',
                                        'warning',
                                        'Text',
                                        'Text',
                                        'free',
                                        '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Text\\\" \" . iif($setting[\'value\']==\'Text\',\'selected=\"selected\"\') . \">Text</option>\r\n<option value=\\\"Buttons\\\" \" . iif($setting[\'value\']==\'Buttons\',\'selected=\"selected\"\') . \">Buttons</option>\r\n</select>',
                                        26,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_modoption',
                                        'warning',
                                        'All',
                                        'Own',
                                        'free',
                                        '<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"Own\\\" \" . iif($setting[\'value\']==\'Own\',\'selected=\"selected\"\') . \">Own</option>\r\n<option value=\\\"All\\\" \" . iif($setting[\'value\']==\'All\',\'selected=\"selected\"\') . \">All</option>\r\n</select>',
                                        28,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_sig_thresshold',
                                        'warning',
                                        '0',
                                        '0',
                                        'free',
                                        '',
                                        29,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_avatar_thresshold',
                                        'warning',
                                        '0',
                                        '0',
                                        'free',
                                        '',
                                        30,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_aprotected_usergroups',
                                        'warning',
                                        '',
                                        '',
                                        'free',
                                        '',
                                        31,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_pmcutoff',
                                        'warning',
                                        '0',
                                        '0',
                                        'free',
                                        '',
                                        32,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_admingroups',
                                        'warning',
                                        '6',
                                        '',
                                        'free',
                                        '',
                                        33,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_smodgroups',
                                        'warning',
                                        '5',
                                        '',
                                        'free',
                                        '',
                                        34,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_modgroups',
                                        'warning',
                                        '7',
                                        '',
                                        'free',
                                        '',
                                        35,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_includepost',
                                        'warning',
                                        '1',
                                        '0',
                                        'free',
                                        'yesno',
                                        36,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_savecopy',
                                        'warning',
                                        '1',
                                        '0',
                                        'free',
                                        'yesno',
                                        37,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_savecopyalert',
                                        'warning',
                                        '1',
                                        '0',
                                        'free',
                                        'yesno',
                                        38,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_savecopyforum',
                                        'warning',
                                        '166',
                                        '',
                                        'free',
                                        '',
                                        39,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_allowalerts',
                                        'warning',
                                        '1',
                                        '0',
                                        'free',
                                        'yesno',
                                        40,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_allowalertscomment',
                                        'warning',
                                        '1',
                                        '0',
                                        'free',
                                        'yesno',
                                        41,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_alertslifetime',
                                        'warning',
                                        '30',
                                        '0',
                                        'free',
                                        '',
                                        42,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_allownotes',
                                        'warning',
                                        '1',
                                        '1',
                                        'free',
                                        'yesno',
                                        43,
                                        0,
                                        1,
                                        'aws'
        ),
        (
                                        'warn_version',
                                        'warning',
                                        '3.4.16',
                                        '3.5.4',
                                        'free',
                                        '',
                                        44,
                                        0,
                                        1,
                                        'aws'
        );

MySQL Error  : Duplicate entry 'warn_hierarchical' for key 1
Error Number : 1062
Date        : Saturday, August 5th 2006 @ 11:16:40 AM
Script      : http://www.majorfm.com/forum/admincp/plugin.php
Referrer    : http://www.majorfm.com/forum/admincp...?do=productadd
IP Address  : 82.25.***.***
Username    : AJ
Classname    : vb_database
Please advise what do to, in done everything else but see no changes on my forum!

Hornstar 08-06-2006 11:44 AM
I've now upgraded to VB3.6 uninstalled this hack to use the infractions (may install this again if it becomes supported for 3.6 but until then am trying to get used to infractions lol.)

however I just got a database error and i think part of the code is not removed in the database. How do I uninstall it completely?

Thanks

Delphiprogrammi 08-06-2006 12:45 PM
Quote:
Originally Posted by MajorFm.com
Ok small problem, just installed, i had the previous version already installed on my previous version of vb, so i want to keep all existing warn data, so i assume i don't delete existing tables etc...

I got this error when importing the product:



Please advise what do to, in done everything else but see no changes on my forum!
previous version ? the vb 3 version ? then you must run uninstall.php before you install the 3.5.x version.You must create a back from this tables
  • user
  • warnings
  • warning_types
  • pmtext_warned
  • warn_notes
  • ban_dates
  • post

then you can restore this later on .....I suggest you start with clean 3.5.x files you can try to run this

Code:
SELECT * FROM " . TABLE_PREFIX . "setting WHERE varname like 'warn_%';
that will return all the settings used by the system.If you don't want them any longer

Code:
DELETE  FROM " . TABLE_PREFIX . "setting WHERE varname like 'warn_%';
allthrough be carefull with this and keep tableprefixex in mind

Delphiprogrammi 08-06-2006 12:45 PM
Quote:
Originally Posted by hornstar1337
I've now upgraded to VB3.6 uninstalled this hack to use the infractions (may install this again if it becomes supported for 3.6 but until then am trying to get used to infractions lol.)

however I just got a database error and i think part of the code is not removed in the database. How do I uninstall it completely?

Thanks
and what would the database error be ?

d2sector 08-07-2006 08:09 AM
I have un-installed it to use the vb 3.6.0 infraction system and im getting this error. ?

Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE user SET
        ### Bitfield: user.options ###
                options = IF(options & 8, options - 8, options),
                options = IF(options & 1024, options, options + 1024),
                options = IF(options & 16, options, options + 16),
                options = IF(options & 256, options - 256, options),
                options = IF(options & 512, options - 512, options),
                options = IF(options & 32, options, options + 32),
                options = IF(options & 2048, options, options + 2048),
                options = IF(options & 4096, options, options + 4096),
                options = IF(options & 1, options, options + 1),
                options = IF(options & 2, options, options + 2),
                options = IF(options & 4, options, options + 4),
                options = IF(options & 64, options - 64, options),
                options = IF(options & 128, options - 128, options),
                options = IF(options & 32768, options - 32768, options),
        ### Bitfield: user.adminoptions ###
                adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
                adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
        usertitle = 'GFX Freak and SuperMod',
        customtitle = 2,
        username = 'FrogMan',
        email = '',
        languageid = 0,
        homepage = '',
        birthday_search = '1983-08-16',
        birthday = '08-16-1983',
        showbirthday = 2,
        icq = '',
        aim = '',
        yahoo = '',
        msn = '',
        skype = '',
        parentemail = '',
        referrerid = 0,
        ipaddress = '196.25.255.210',
        posts = 1979,
        usergroupid = 6,
        displaygroupid = 0,
        reputationlevelid = 5,
        reputation = 32,
        warnings = 0,
        infractions = 0,
        ipoints = 0,
        autosubscribe = 0,
        threadedmode = 0,
        showvbcode = 2,
        styleid = 0,
        timezoneoffset = '2',
        daysprune = 0,
        joindate = 1125867720,
        lastactivity = 1154904420,
        lastpost = 1154904360,
        membergroupids = ''
WHERE userid = 10184;

MySQL Error  : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date        : Monday, August 7th 2006 @ 04:08:00 AM

Delphiprogrammi 08-07-2006 08:35 AM
Quote:
Originally Posted by d2sector
I have un-installed it to use the vb 3.6.0 infraction system and im getting this error. ?

Code:

Database error in vBulletin 3.6.0:
 
Invalid SQL:
UPDATE user SET
    ### Bitfield: user.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 1024, options, options + 1024),
        options = IF(options & 16, options, options + 16),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 512, options - 512, options),
        options = IF(options & 32, options, options + 32),
        options = IF(options & 2048, options, options + 2048),
        options = IF(options & 4096, options, options + 4096),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options, options + 2),
        options = IF(options & 4, options, options + 4),
        options = IF(options & 64, options - 64, options),
        options = IF(options & 128, options - 128, options),
        options = IF(options & 32768, options - 32768, options),
    ### Bitfield: user.adminoptions ###
        adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'GFX Freak and SuperMod',
    customtitle = 2,
    username = 'FrogMan',
    email = '',
    languageid = 0,
    homepage = '',
    birthday_search = '1983-08-16',
    birthday = '08-16-1983',
    showbirthday = 2,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = '196.25.255.210',
    posts = 1979,
    usergroupid = 6,
    displaygroupid = 0,
    reputationlevelid = 5,
    reputation = 32,
    warnings = 0,
    infractions = 0,
    ipoints = 0,
    autosubscribe = 0,
    threadedmode = 0,
    showvbcode = 2,
    styleid = 0,
    timezoneoffset = '2',
    daysprune = 0,
    joindate = 1125867720,
    lastactivity = 1154904420,
    lastpost = 1154904360,
    membergroupids = ''
WHERE userid = 10184;
 
MySQL Error  : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date        : Monday, August 7th 2006 @ 04:08:00 AM
that's normal since both systems use a database field called "warnings" and when you uninstall aws that field will be deleted ...... run

Code:
ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0';
keep TABLE_PREFIX in mind.....

this error will be gone now

Hornstar 08-07-2006 11:32 AM
That was the database error I have above.

I tried
Code:
ALTER TABLE user ADD vb3_warnings INT UNSIGNED NOT NULL DEFAULT '0';
But got this error

Code:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'gamerzne_backup.user' doesn't exist
What should I try now?

Hornstar 08-07-2006 11:51 AM
ALTER TABLE vb3_user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0'; I had the table prefix in the wrong spot.

Thanks.


All times are GMT. The time now is 11:33 PM.
Page 27 of 29 « First 172526 27 2829
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.03017 seconds
  • Memory Usage 2,047KB
  • 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
  • (11)bbcode_code_printable
  • (2)bbcode_php_printable
  • (12)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
  • (40)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