quote:
Originally posted by Chris Boulton
quote:
Originally posted by Regexp
I thought we were being hosted by C2Media and didn't have server problems anymore...
The servers are hosted by EV1Servers. They are provided by C2Media. Big difference.quote:
Originally posted by Regexp
query "select * from mybb_reps where id={$id}"
while(array = mysql_fetch_assoc(query)) {
today_begin = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
today_end = today_begin + 86400;
if(array['lastrep'] >= today_begin && array['lastrep'] <= today_end) {
todayreps_total++;
todayreps_points += array['reppoint'];
}
}
# etc.
# echo
Go through every single reputation for the user? 
This would probably work
code:
$query = $db->query("SELECT COUNT(r.rid) AS rep_total, SUM(IF(r.dateline>'$mybbuser[lastvisit]',reputation,'0')) AS reps_new FROM reputations r WHERE r.uid='$mybb[uid]' GROUP BY r.uid");
$rep = $db->fetch_array($query);
That would show since last visit too..
However I agree with Wj.
Why do you people make such a big deal out of the reputation system? Furthermore, what's with the useless suggestions here recently?
Oh, I see!
Looks interesting. I don't know so much SQL.
I'll write that down and study. It might save me some trouble.
Meh, I liked the coding challenge. That's the only reason I kept posting. I couldn't care less about the reps.
/ 
