Last Post

G_Man · 01-05-2007, 10:19 PM

Here is a cron I am running, Code Monkey.

PHP Code:


			
<?php

if (!is_object($vbulletin->db))
{
    exit;
}

$days = 7;
$points = 5;
$minpointlevel = 100;

$cutoff = TIMENOW - (86400 * $days);

$vbulletin->db->query_write("
    UPDATE ".TABLE_PREFIX."user
    SET reputation = reputation - $points 
    WHERE lastactivity < $cutoff  AND reputation > $minpointlevel
");  


?>

You think you could take a minute and tell me what I would put in place of lastactivity to make it the last post time??

I am thinking it is simply lastpost, but I'd love your opinion/help.

Code Monkey · 01-05-2007, 10:48 PM

Yes it would be lastpost. However, you may have a problem if there are no posts for the user.

G_Man · 01-05-2007, 10:54 PM

Quote:

Originally Posted by Code Monkey

Yes it would be lastpost. However, you may have a problem if there are no posts for the user.

ah... I didn't think about that, but it makes perfect sense. I wonder if you could set up a conditional of sorts to check for no last post... but then what....

Oh thanks... now I have to figure that out too!!! LOL

Code Monkey · 01-05-2007, 11:06 PM

Quote:

Originally Posted by G_Man

but then what....

Then you would use lastactivity.

G_Man · 01-05-2007, 11:10 PM

Quote:

Originally Posted by Code Monkey

Then you would use lastactivity.

oh, duh... That would work perfectly, too...

Okay, then...

How would I set up a conditional to do use the code I have if there is NO lastpost and use lastpost if there is?

Code Monkey · 01-05-2007, 11:26 PM

This may work

PHP Code:


			
if (!is_object($vbulletin->db))
{
    exit;
}

$days = 7;
$points = 5;
$minpointlevel = 100;

$cutoff = TIMENOW - (86400 * $days);

$vbulletin->db->query_write("
    UPDATE ".TABLE_PREFIX."user
    SET reputation = reputation - $points
    WHERE IF(lastpost=0, lastactivity, lastpost) < $cutoff  AND reputation > $minpointlevel
");

G_Man · 01-05-2007, 11:28 PM

Cool. Thanks Mate.

I am off to bed. Early day driving in the snow tomorrow. blech. I will try this out after I get home. Have a good night, boss.

Code Monkey · 01-07-2007, 08:21 PM

"still waiting patiently to find out if the hack functions or not*

G_Man · 01-07-2007, 08:29 PM

Quote:

Originally Posted by Code Monkey

"still waiting patiently to find out if the hack functions or not*

Yeah, yeah...

I am trying to calculate the numbers, the way is sits. I need to Determine the numbers I want to use. Odd problem is that if I run this then my members lose points, so I don't want to run 20 times in a row!! LOL

Code Monkey · 01-07-2007, 08:52 PM

You say that as if I have any inkling of what you are trying to do with it.

G_Man · 01-07-2007, 09:52 PM

Quote:

Originally Posted by Code Monkey

You say that as if I have any inkling of what you are trying to do with it.

LMAO! Literally.

*wipes tear from eye*

Anyway...

Replaced the code and ran the job. Seems to be working just fine.

Thanks, Code Monkey.

Code Monkey · 01-07-2007, 10:01 PM

That's good to hear. Let me know if you have any problems or need a laugh.