3.6.1/2 Optional Fixes
#1

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 Smile



Messages In This Thread
[No subject] - by Sutz - 01-21-2014, 04:29 AM
[No subject] - by Sutz - 01-27-2014, 11:28 AM
[No subject] - by LikeToMove - 01-27-2014, 04:32 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)