Ahhhhh!! No post count! Emergency!

ok well after installed the post increasment hack I think it really bunnged up my board. now another site just closed and we will have 100% of there traffic, and AHHHHH new users have no post count! I reverbed the hacked files but that didnt work, so I think its the DB changes made! plus another hint is when I try to update stars and such, I get this..

Invalid SQL: SELECT starlevel,starimg FROM stars WHERE minposts<= ORDER BY minposts DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY minposts DESC LIMIT 1' at line 1

could that be a clue to the problem?

now I wanna reverse the DB changes made, how would I do that when this is the changes I made?

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

thanks anyone who can even lend a few mins of help, its gunna be ugly tomrrow if I have 20-50 new registers and none have working post counts!!!

-myles

[snyx]

beauty boofo! just what it needed!
sweeeeeeeeeet..

thanks bro

[Boofo]

g-force2k2, if he runs the query I posted above, that will fix it. The original query did not have the "default 0 not null" appended to it, so it was not setting the newly registered user's post count. When the register.php was looking at those lines, it was saying <=0 but there was no post count to compare to it.

[Boofo]

Today at 01:58 PM snyx said this in Post #11
beauty boofo! just what it needed!
sweeeeeeeeeet..

thanks bro

No problem. Glad you got it working.