site req: "barracks top tens" page for badges
BotB Academy Bulletins
 
 
112033
Level 24 Mixist
Cessor Safari
 
 
 
 
post #112033 :: 2019.06.24 10:43pm :: edit 2019.06.24 10:44pm
[This n00b ashamed of what written. - BotB]
 
 
112036
Level 32 Chipist
kleeder
 
 
 
post #112036 :: 2019.06.25 1:26am
  
  tonreihe and sc liēkd this
a site like this would be really helpful.

regarding the panda badge: it is true. ... we checked manually by looking at every panda entry ever uploaded and counting 20+ entries by botbrs
 
 
112083
Level 30 Mixist
Baron Knoxburry
 
 
 
post #112083 :: 2019.06.26 8:06am
  
  Flaminglog, Modus Ponens, DCT Master and kleeder liēkd this
🤔
 
 
112085
Level 29 Hostist
puke7
 
 
 
post #112085 :: 2019.06.26 8:12am
  
  Flaminglog, argarak, YQN and kleeder liēkd this
This actually wouldn't be that hard. Might take a while to come up with the queries to iterate over all the formats. The page will need to be cached, obviously. Showing BotBrs with the most badges would probably require a new table field.
 
 
112091
Level 31 chipist
Chip Champion
 
 
 
post #112091 :: 2019.06.26 11:10am
  
  Melon, Lia, sc, Savestate, argarak, Baron Knoxburry, YQN, Sinc-X and kleeder liēkd this
we could all use a chip champ appreciation page imo :3
 
 
112323
Level 29 Hostist
puke7
 
 
 
post #112323 :: 2019.07.03 7:51am
  
  Sinc-X, Savestate and YQN liēkd this
if anyone wants a preview where this is at its here --
http://battleofthebits.com/barracks/BotBrBadges

currently having problems with my SQL ordering the results by badge count -- prolly should ask on stackoverflow :shrug:
SELECT * FROM `botbr` WHERE `id` IN (select `botbr_id` from `entry` where `format_token` = '$f->token' && `score` >= 20 group by `botbr_id` having count(`id`) >= 7 order by count(`id`) desc) limit 10;"
 
 
112332
Level 29 Chipist
Sinc-X
 
 
 
post #112332 :: 2019.07.03 2:12pm
  
  kleeder liēkd this
it is now working correctly ^_^
 
 
112333
Level 28 Chipist
KungFuFurby
 
 
 
post #112333 :: 2019.07.03 2:15pm :: edit 2019.07.03 2:19pm
  
  kleeder liēkd this
That's surprisingly interesting that nobody has a Famitracker badge... at least as far as the test page goes.

If nobody has a badge for the format, should it indicate who is the closest to getting a badge instead?
 
 
112600
Level 29 Hostist
puke7
 
 
 
post #112600 :: 2019.07.11 3:37pm
  
  YQN liēkd this
still don't have Top 10 by Badge Count
but it looks the part now
http://battleofthebits.com/barracks/BotBrBadges
also need an accessible link somewhere :thonk:
 
 
112601
Level 32 Chipist
kleeder
 
 
 
post #112601 :: 2019.07.11 3:44pm
what about adding a box above the "Recent Visits" Box with a menu for all the barracks-subpages
 
 
112602
Level 30 Mixist
Baron Knoxburry
 
 
 
post #112602 :: 2019.07.11 3:54pm
  
  kleeder liēkd this
that could be quick, dirty fix!
 
 

LOGIN or REGISTER to add your own comments!