Posts per day HACK!

[hardwareirc.com]

Hi,
I need a script that sorts users by their "Posts per day" ratio, someone could help me???

It's very important.....

Please relply!

[Xenon]

I've also searched that some time ago, didn't find an comfortable way till now.

but there is a way you can do so with a temporary field in the usertable.

make a float field in table user called ppd
then run this query:
UPDATE user SET ppd=posts/((UNIX_TIMESTAMP(NOW())-joindate)/86400)

replace the nowtime with the sql-code to get the actual time, i don't know it now ;)

and then sort users by ppd.

As i said, not very nice work, but i think it should work

[hardwareirc.com]

I'm not very experienced with mysql... :)

However, now i'm in phpmyadmin, in the users db, what is a float field? How do I create it?

Could you try to find the "nowtime" string?

Ah, and after this, when I'll open the ppd sub-db I'll see the users sorted by posts per day?

Let me know ASAP,
Antonio

[hardwareirc.com]

it's the _sysdate code?

HELP!

[Xenon]

check the query again, i think this is the correct function :)

after that you can sort your table BY ppd in your scripts.

be sure to always run this query again before sorting by ppd, so it'll be the latest state :)

i said it isn't perfect ;)

[hardwareirc.com]

Thanks,
but when I execute the query I obtain this error:

You have an error in your SQL syntax near '[high]UNIX_TIMESTAMP[endhigh](NOW())-joindate)/86400)' at line 1

Even if I insert the #9393F2 code, I have a similar error.... HELP!

[hardwareirc.com]

If I execute this:

UPDATE user SET ppd=posts/((NOW())-joindate)


I have no errors, but the sorting is incorrect.... HELP! :(

[Xenon]

hmm, don't know why the board has corupted the query, i'll post it to chen

use this query:UPDATE user SET ppd=posts/((UNIX_TIMESTAMP(NOW())-joindate)/86400)

[hardwareirc.com]

Dear Xenon,

THANK YOU VERY MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :) :D

It works fine!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :)

Keep in touch!
Antonio

[Xenon]

you're welcome :)

[hardwareirc.com]

If you're european come on my forum, I'm organizing a giveaway contest, the prizes will be ATI vga cards and some motherboards :)

[Neo]

You can do this without having to add a extra query you know.

[hardwareirc.com]

really?

however, I need it just for the contest, so for me this query works more than well :)

[Neo]

Its all good man. Where are you showing the posts per day at?