Tell me about it, for 3.0.3 to .4 to .5 and now to .6.

Thank God, it did't take me more than 2 hours to do all my hacks and I have about 20 of them installed (little and biggies).

Rgds

Blocking open proxies from registering would be a nice addon.
https://vborg.vbsupport.ru/showthread.php?t=72442 :D

It's hard to keep banned users out when all they have to do is add the proxy extension to firefox.

I am sorry, but this is not something related to the AWS. It's a different issue all together. Also, I do not have the knowledge to address it.

Sorry :-(

there is no way to detect anonymous proxys so .... impossible todo proxy server pass variables if those variables aren't passes php doesn't know it's a proxy does it ? what you could do to keep banned users out is create a custom usergroup with no rights ...

I've got a lean miss in my F-150 that I can't find...

Well, this is what happens when you get an F-150 only. Why not the F-350? Much more macho and you can have it with a diesel which does not run lean!!! LoL

My old Cherokee is producing all kind of pinging sounds, I learned not to pay too much attention to them. And don't you dare call it a ricer, because it's tires are 5" taller than standard!

Rgds

hey.. I am still running the old one .. I was wondering have you fixed the PM popup
box when they receive a warning now?

Because when the user receives a warning they don't get a popup box saying they
have a new PM waiting :)

Well, I was not aware of it, but now (version 3.1.2) it is corrected. A pop-up window is activated if the user has defined this option in his user CP.

Rgds
---------

John

Your last 3 instructions in the upgradetolatest from 3.1.1 => 3.1.2 are duplicates of already done edits.

Yes, you are correct, but I say in the beginning "Start with a vB original file", so there!

Rgds

O, I didnt notice that.
Then I gotta say that's not very good... First of all I just avoided doing those edits and everything works fine. Second, do you seriously think your hack is the only one that modifies the private.php? I can think of 3 or so without actually checking.
If you want us to remove some code there, tell us that instead of saying "right, now redo every single hack you ever done to private.php" :P

And you are right Sir, I'll try to change the instructions. The reason I did that, was because I am not sure at which version the users are, so they might not be able to find the code they need to change. Stupid of me, I assume.

Let me see if I can rephrase those instructions.

Can someone who is still using AWS Version 3.1.1 (hasn't yet upgraded to 3.1.2) send me a section of his private.php file?

I need the section which starts from:

// check for valid users

and ends with:

// query recipients

I would appreciate that, either post it here, or send it at my e-mail or via PM.

Tnx

uhm.. no-backup philosophy? ^^

:) here

Well, my backups are going back to 3.0.0, but in the mean time, I also got involved in a vB upgrade, which eventually left me in a state of confusion. So in order to avoid giving out false instructions, I think it is better to ask for some help.

Sorry JimpsEd, that, I have (as I said, back to 3.0.0), what I need is that section of the private.php file.

Rgds

Ah ok.. I thought this could be taken from your instructions. I'll find the file when I get home and try get the code :)

Hi sv1cec is it possible to change the warn and the view text in the postbit in two nice buttons. Or maby added it to the thread tools menu.

I could make a couple of buttons, but they will be something like "Warn User" and "View User Warnings", without the name of the user. vB produces a button, with whatever text you want in there, but I haven't the faintest idea how they make it, it's a "class" thing, and I do not even know where classes are stored in the files.

If that's OK with you, let me know.

No, I am no coder hehe.
I wondered myself it was possible to do.
Thnx anyway

If you do not mind the fact that the button will not say "Warn John" but "Warn User" (without the user name), I can do it for you

Rgds

Can someone send me that part of the private.php file, I asked for, a couple of posts back?

Rgds

Yes why not, when you press on the button you can see the user who you warned , ;)

Hello, I've just installed AWS "by the book", version 3.1.2
I get the following errors in admincp:
When clicking Statistics - Bans per User:

/admincp/admin_warn.php

Database error in vBulletin 3.0.6:

Invalid SQL: select b.*, u.*, a.username AS warner, w.*, wt.* from ban_dates as b
LEFT JOIN user AS u ON(u.userid = b.banned_user)
LEFT JOIN user AS a ON(a.userid = b.banned_by)
LEFT JOIN warnings AS w ON(w.wid = b.banned_warning)
LEFT JOIN warning_types AS wt ON(wt.tid = w.warned_warning_id)
ORDER BY b.banned_user, b.banned_ban LIMIT 0,
mysql error: You have an error in your SQL syntax.

When clicking Statistics - Warnings per User

/admincp/admin_warn.php

Invalid SQL: select * from
user u where warnings>0 ORDER BY userid ASC LIMIT 0,
mysql error: You have an error in your SQL syntax.

Looks like the $perpage variable isn't set for some reason, see LIMIT 0,
A bug?
What should I check for?
Thanks for any info :)

no that can't be a bug why ? because it works in here probably you have a typo somewhere also if you have bans already already you must run the included update_bandates.php script

Already run /admincp/update_ban_dates.php before.

This is weird, if I add this row, just before the code you specified above:
$perpage = 10;

it works!!!

so the $perpage does indeed loose its value somewhere...maybe a typo, I don't know.

$perpage=$warn_opts['warnings_per_page'];
echo "warnings_per_page=".$warn_opts['warnings_per_page']."<br>";

Told me that $warn_opts['warnings_per_page'] is empty. Where is this variable declared, assigned?

Any other ideas?

I do not think it is a bug, and I do not think it is a typo, the reason is that admin_warn.php is not a file the user edits, it is in the zip file. And it can't by a bug, because, as Delphi says, it works elsewhere.

Check your warning_options table in your database to see what value it has in that column. If it has nothing, set it from the AWS Options and check again.

BUT: I would strongly advise that you download and install the latest version. Use the uninstaller to uninstall the previous one, and then run the install_warn.php file again, from the newest version (I'll be uploading version 3.1.3 in a few minutes).

Hmm...wtf?!? :)
My warning_options table is empty...how could that be...gaaaah!!!

I'll try reinstalling it.

EDIT: thanks for the help :)

Allrighty...now it works...must have missed some part in the installation.
But the installationprocedure was no picknick, a lot of messing around in the code :) , and I'm no newbie...it would be great to have a more simple installation. Anyway, thanks for the help.

What would be the "upgrade" procedure to apply the latest patch? I just got done installing this on 5 forums, and like the idea of the buttons instead of the text.

Can I just drop a few files in, or do I need to hack some more files?

you haven't put the attachment on yet

Splendid sv1cec the buttons option, but it is Tuesday today :laugh:
Oke I installed 3.1.3 now, when de attachment is comming :squareeyed:

where's the new zip ?

That's what's happening when two babies start yelling together. You update something then leave something else out. Thank God they were asleep when I did the coding work.

OK, I just upload the zip and corrected the day LoL.

Now, the upgrade procedure is described in a file called "UpgradeToLatestVersion.txt" in the zip file. In reality, it's a couple of files you have to edit, two templates and run a query. The file edits are done in files you have already edited.

No biggie.

Rgds

I just installed this truly wonderful hack yesterday. Very impressive; kudos to all who have contributed to it.

And today, a new addition, LOL.

But, I'm trying to upgrade, and, the first part of the instructions:
leads to this error, for me:The install of 3.1.2 yesterday, was flawless, and the hack works perfectly.

I have a warning_options table, but, my vbulletin does not use prefixes, as it is an upgrade from an old 2.xx version.

Am I missing something here?

Thanks,
rich

Hey, John:

When you update the 1st post, can you add the version # so that we can tell where we are w/ what we have installed vs what is posted here?

:)

Thanks!

people,

ALWAYS store a "working" version of the modified files BEFORE you try to upgrade so you can get everything back up and running with a minimum of "no working" time

sv1cec,

in your upgradetolatestversion.txt instructions are two database querys

1) this query updates the AWS version number (obviously)
2) that query will add a column in the warning_options table called textbutoption

i'm not sure since i see other querys here are that all database querys whe need to run to upgrade to the latest version ? i don't use that other system i always used your AWS i'm on 3.1.2 and no we cannot stop butter you with questions but when it's working i'll send you some coffee lol :D

edit

my links in the memberinfo info template disapperd ??

my links in the postbit template are gone to :S

Hi...

I have a question

Im goingto upgrade from 3.0.3 this week and was wondering am I going to
loose the info or anything from the users that have warnings

- Upload new files
- Run datebase update
- Download all new mods
- Re-add all mods/check through

I don't have to use upgrade on the mods? just do it as new install?

Remove the ".TABLE_PREFIX.", if you are not using a table prefix.

Rgds