Change a user's post incrementation factor...

This hach was requested by nintendo: https://vborg.vbsupport.ru/showthrea...threadid=49637

This hack allows you to set the direction and the incrementation factor for user posts.
The default incrementation factor is 1. With this hack you can freeze a user's post
count by setting the incrementation factor to 0, or you can make it go backwards by
setting it to -1. Of course, you are not limitet to -1, 0, or 1. You can set it to
any positive or negative number and that users post caount will increment or decrement
by the specified number each time that user makes a post.

Tables affected by this hack: user, usertitle
Files affected by this hack: newthread.php, newreply.php, admin/user.php

To begin with this hack you must allow for negative post counts, and you need an
additional field in the user table.

Execute the following statements at the MySQL prompt:

alter table user add postdirection smallint(5) DEFAULT 1 NOT NULL;
alter table user modify posts int(6) default 0 NOT NULL;
alter table usertitle modify minposts int(6);

Note: If you have installed this hack and are not able to set the post incrementation factor to a negative number execute the following statement.

alter table user modify postdirection smallint(5) default 1 not null;

I apologize for this mixup. I have already updated the instruction file.

[Zzed]

I am not familiar with the star hack.

What errors are you getting?

Can you Email me your newthread.php and newreply.php files?

My Email is edwink@seebeyond.com

[snyx]

I shot ya over an email yesterday..

[snyx]

hello zzed?

[Zzed]

Sorry snyx, I will take a look tonight and get back to you.

[snyx]

no problem, thx mate

[Boofo]

Zzed, I just installed this and I changed my incrementation to -1 but when I go into my user setting to look at it, for some reason it is showing 0 now. Any ideas what might be causing this?

[Zzed]

Today at 05:26 PM Boofo said this in Post #16
Zzed, I just installed this and I changed my incrementation to -1 but when I go into my user setting to look at it, for some reason it is showing 0 now. Any ideas what might be causing this?

You need to alter your user and usertitle tables. Post counts are unsigned integers, the following code will make them signed integers.


alter table user modify posts int(6) DEFAULT 0 NOT NULL;

alter table usertitle modify minposts int(6);


Also look at my post count in my profile.

http://www.ls1.com/forums/member.php...fo&userid=4112

[Boofo]

Here are the queries I ran according to your install instructions.

alter table user add postdirection smallint(5) unsigned DEFAULT 1 NOT NULL;
alter table user modify posts int(6);
alter table usertitle modify minposts int(6);

[Zzed]

I just executed this SQL query in your Admin CP:

alter table user modify postdirection smallint(5) default 1 not null;

Then went ahead and set your post incrementation factor to -1.

It worked.

[Boofo]

Hey buddy.

I got this error this afternoon sometime.

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT title FROM usertitle WHERE minposts<=22+ $\
bbuserinfo[postdirection] ORDER BY minposts DESC LIMIT 1
mysql error: You have an error in your SQL syntax near '\
bbuserinfo[postdirection] ORDER BY minposts DESC LIMIT 1' at line 1

mysql error number: 1064

Date: Friday 28th of March 2003 03:09:54 PM
Script: http://www.bearfacts2.com/forum/forum/newreply.php
Referer: http://www.bearfacts2.com/forum/show...=&threadid=311

and now the user is showing 23 of 22 messages.