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:
[sql]UPDATE user SET ppd=posts/((UNIX_TIMESTAMP(NOW())-joindate)/86400)[/sql]

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!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

It works fine!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Keep in touch!
Antonio

[Xenon]

you're welcome