3.6.1/2 Optional Fixes

[Sutz]

Fix the lottery "Total Tickets" 3.6.1 will just count all total tickets but you can change the query to only count that weeks sales.

Edit core.php and search for:
$query4 = sprintf("SELECT count(:index) FROM %s.t_lottery", $LC_LCDb );
 
Change to:
 
$query4 = sprintf("SELECT count(:index) FROM %s.t_lottery WHERE a_week_num = (SELECT max(a_week_num) FROM %s.t_lottery)", $LC_LCDb, $LC_LCDb );

Fix the top voters block ranks, this is bugged and wont list the highest voters right.

Open navi cat an edit the table t_votes_history change a_complete from varchar to int

----

!!THIS IS A FIX LIST ONLY NOT CHAT!!

ONLY REPLY WITH YOUR FIXES YOU DONE!

IF YOU WANT TO SAY THANKS HIT THE LIKE

 

Thankyou