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]

Today at 05:32 PM Boofo said this in Post #20
Hey buddy.

I got this error this afternoon sometime.



and now the user is showing 23 of 22 messages.

Eureka.

Go to line 613 of your newrply.php and join the 2 lines and remove the backslash. The variable $bbuserinfo[postdirection] has the $ and bbuserinfo separated.

[snyx]

help all my new registered users dont have a post count?
they just sit at no number!! I want to remove the changes I made to mySQL in hopes it fixes this problem how would I do this?!

[Boofo]

It seems you get a db error when a new user tries to activate also. Apparently, we need to change something in the register.php file, too.

[DrunkenStud]

Today at 02:34 AM snyx said this in Post #22
help all my new registered users dont have a post count?
they just sit at no number!! I want to remove the changes I made to mySQL in hopes it fixes this problem how would I do this?!

yeah, shouldnt you have altered the posts column like this:

alter table user modify posts int(6) default 0 not null;

[Boofo]

Zzed, you need to change the following in the text file attached to the first post, too.

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

[Zzed]

done.

Thank you sir.

[Hobbes]

anyone know if this conflicts with bitsys's battle hack?


erm it does....sucks...


wouldve been nice