With the latest update I get this display error on top of the xperience.php.
Quote:
stats ORDER BY get_award_community DESC LIMIT 0,3"); if ($vbulletin->db->num_rows($award_communityq)>0){ $i=0; while ($award_community = $vbulletin->db->fetch_array($award_communityq)) { $i++; $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "xperience_stats SET award_community=$i WHERE userid=".$award_community['userid']); //64 - community 1 //128 - community 2 //256 - community 3 switch ($i) { case 1: $Bit=64; break; case 2: $Bit=128; break; case 3: $Bit=256; break; } $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET xperience_awards=xperience_awards + ".$Bit." WHERE userid=".$award_community['userid']); } } $award_helpfulq =$vbulletin->db->query_read("SELECT userid, points_post_thanks AS get_award_helpful FROM " . TABLE_PREFIX . "xperience_stats ORDER BY get_award_helpful DESC LIMIT 0,3"); if ($vbulletin->db->num_rows($award_helpfulq)>0){ $i=0; while ($award_helpful = $vbulletin->db->fetch_array($award_helpfulq)) { $i++; $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "xperience_stats SET award_helpful=$i WHERE userid=".$award_helpful['userid']); //512 - helpful 1 //1024 - helpful 2 //2048 - helpful 3 switch ($i) { case 1: $Bit=512; break; case 2: $Bit=1024; break; case 3: $Bit=2048; break; } $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET xperience_awards=xperience_awards + ".$Bit." WHERE userid=".$award_helpful['userid']); } } } } ?>
|