site req: "barracks top tens" page for badges
BotB Academy Bulletins
 
 
112031
Level 27 Chipist
post #112031 :: 2019.06.24 10:42pm
  
  tonreihe and Melon liēkd this
(this is text i put so it'll let me post the thread)
 
 
112032
Level 27 Chipist
post #112032 :: 2019.06.24 10:43pm
  
  tonreihe, pandavova and kleeder liēkd this
wait no, i have a post. https://twitter.com/pandavova/status/1143393619686100992 panda says he is THE ONLY person with a panda badge. i wld like to know if this is true, and if it is, admire it longingly
 
 
112033
Level 23 Mixist
post #112033 :: 2019.06.24 10:43pm :: edit 2019.06.24 10:44pm
[This n00b ashamed of what written. - BotB]
 
 
112036
Level 28 Chipist
post #112036 :: 2019.06.25 1:26am
  
  tonreihe, sc and charlotte 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 29 Mixist
post #112083 :: 2019.06.26 8:06am
  
  Flaminglog, Modus Ponens, DCT Master and kleeder liēkd this
🤔
 
 
112085
Level 27 Hostist
post #112085 :: 2019.06.26 8:12am
  
  Flaminglog, argarak, YQN, charlotte 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 30 chipist
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 27 Hostist
post #112323 :: 2019.07.03 7:51am
  
  Sinc-X, Savestate, YQN and charlotte liēkd this
if anyone wants a preview where this is at its here --
http://battleofthebits.org/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;"
 
 
112324
Level 27 Chipist
post #112324 :: 2019.07.03 8:11am :: edit 2019.07.03 8:18am
  
  tonreihe and Sinc-X liēkd this
EDIT: oh wait. u only ordered by "count(`id`)" to search for the ids, right? mb u need to order it again once uve Got the ids
 
 
112332
Level 28 Chipist
post #112332 :: 2019.07.03 2:12pm
  
  charlotte and kleeder liēkd this
it is now working correctly ^_^
 
 
112333
Level 26 Chipist
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?
 
 
112352
Level 27 Chipist
post #112352 :: 2019.07.04 5:50am
  
  YQN, tonreihe, Sinc-X and kleeder liēkd this
hooray for mor things on the website!!!!
 
 
112600
Level 27 Hostist
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.org/barracks/BotBrBadges
also need an accessible link somewhere :thonk:
 
 
112601
Level 28 Chipist
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 29 Mixist
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!