Skip to content

Instantly share code, notes, and snippets.

View alexcharlie's full-sized avatar

Alexander Le alexcharlie

View GitHub Profile
869,2404,4345,200243,202359,203837,205136,207440,207559,207611,209174,209730,213586,215181,217754,219284,219492,219493,223761,502666,600487,601185,601901,603674,609483,612438,615860,700103,700240,800689,803245,814970,1200006,1200246,1200725,1200752,1200849,1202610,1203227,1203598,1205541,1207654,1207872,1210682,1214419,1214528,1218568,1230847,1232224,1232388,1232755,1236081,1238868,1240564,1502940,1506714,1511767,1514587,1800314,1807232,2202051,2240416,2249669,2502436,2502602,2502884,2503524,2504551,2505786,2505831,2508781,2509183,2511398,2511713,2513224,2514353,2516452,2519107,2527190,2528404,2534093,2537863,2729569,2900395,2900526,2900569,2900959,2901163,2902027,3006114,3200218,3202669,3205241,3212719,3222650,3300204,3300229,3300252,3300572,3300806,3302115,3302165,3302239,3302807,3303055,3303365,3304784,3305987,3307657,3307727,3308164,3309010,3309089,3310562,3310571,3313554,3313959,3318165,3318322,3318369,3326963,3400087,3400171,3401111,3409473,3416311,3502094,3701126,3900570,4100641,4709556,4800072,4800233
mysql> select s.name, count(*), RPAD('', count(*), '*') from skill_rewards as sr join skills as s on sr.skill_id = s.id group by sr.skill_id;
+-------------------+----------+-------------------------+
| name | count(*) | RPAD('', count(*), '*') |
+-------------------+----------+-------------------------+
| Sabotage | 1 | * |
| First Aid | 1 | * |
| Vehicle Operation | 2 | ** |
| Seduction | 3 | *** |
| Tracking | 2 | ** |
| Interrogation | 1 | * |
mysql> select s.name, sum(sp.points), RPAD('', sum(sp.points) / 1000, '#') as bar from (skill_progresses as sp join users as u on sp.user_id = u.id) join skills s on sp.skill_id = s.id where u.level > 10 group by sp.skill_id;
+-------------------+----------------+------------------------------------------------------------------------------------------------------------+
| name | sum(sp.points) | bar |
+-------------------+----------------+------------------------------------------------------------------------------------------------------------+
| Sabotage | 2411 | ## |
| First Aid | 16928 | ################# |
| Vehicle Operation | 27540 | #################
mysql> select s.name, sum(sp.points) from (skill_progresses as sp join users as u on sp.user_id = u.id) join skills s on sp.skill_id = s.id where u.level > 10 group by sp.skill_id;
+-------------------+----------------+
| name | sum(sp.points) |
+-------------------+----------------+
| Sabotage | 2411 |
| First Aid | 16918 |
| Vehicle Operation | 27540 |
| Fast Talk | 1060 |
| Seduction | 105563 |
| Tracking | 52910 |
mysql> select s.name, sum(points) from skill_progresses as sp join skills as s on sp.skill_id = s.id group by sp.skill_id;
+-------------------+-------------+
| name | sum(points) |
+-------------------+-------------+
| Sabotage | 7691 |
| First Aid | 22598 |
| Vehicle Operation | 73513 |
| Fast Talk | 6500 |
| Seduction | 150121 |
| Tracking | 109792 |
def do_damage(options={})
actual_damage = self.attacker.jitter_damage
actual_damage *= 2 if options[:crit]
# damage reduction
self.damage = (actual_damage * (1.00 - normalize(self.armor * 0.001)))).round
self.defender.health -= self.damage
end
-I wish Google Maps had an "Avoid Ghetto" routing option.
-More often than not, when someone is telling me a story all I can
think about is that I can't wait for them to finish so that I can tell
my own story that's not only better, but also more directly involves
me.
-Nothing sucks more than that moment during an argument when you
realize you're wrong.
Hi, my name is ByunTae from South Korea. I have been playing Starcraft since 1998 and I was born and raised in Korea. I'm 100% full blooded Korean, meaning I have been gifted with unparallel talent to master any video game, particularly, Starcraft: Brood War. I'm also experienced in Counter-Strike, I am able to perform bunny hops, my best score on a public 32 player game was 171-2 with 170 kill streak. I'm offering my expertise in Starcraft to be taught to non-Koreans that wishes to have the skill of a Korean player. I have advised and coached many professional gamers such as Im Jae Dong, Park Myung Soo, Ma Jae Yoon, and more. Boxer and I were great friends until he started using my dropships to gain his fame. I started training other players to be on par with Boxer and eventually surpassing Boxer. He is no longer the best player thanks to my contribution to rest of the players. I did not compete in pro gaming because they KTF did not agree with my seven figure contract demand.
Things I will be teaching in
index = 0
max = 100
begin
puts index
index += 2
end while (index < max)
#fast
band_a.members.length.times { |i| band_a.members[i].clear_buff(self.round); band_b.members[i].clear_buff(self.round) }
#slow
(band_a.members + band_b.members).each { |i| i.clear_buff(self.round) }