Skip to content

Instantly share code, notes, and snippets.

View mustangostang's full-sized avatar

Vlad Andersen mustangostang

View GitHub Profile
SELECT
*
FROM
(SELECT
PlayerId,
SUM(GKSave) AS GKSave,
SUM(GKReflex) AS GKReflex,
SUM(GKExit) AS GKExit,
SUM(GKSave + 3 * GKReflex + 0.2 * GKExit + 1) / SUM(
2 * GoalAgainst + GKSave + GKReflex + 1
name=Brescia+Calcio&userId=93153&cerebrumGroupId=200&subgroupId=1529&events%5B0%5D%5BmatchId%5D=2327681&events%5B0%5D%5BmatchVersion%5D=0&events%5B0%5D%5BstartSec%5D=1110&events%5B0%5D%5BendSec%5D=1123&events%5B0%5D%5BcustomName%5D=G.+Pinzi+%E2%80%94+Free+kick%2C+Lost+challenge&events%5B0%5D%5Banalysis%5D%5B0%5D%5BpngSource%5D=iVBORw0KGgoAAAANSUhEUgAAAtAAAAGVCAYAAADXKsbeAAAgAElEQVR4Xu3dB7RtVXm38edVURRRLKiAigoSRcRYUFHBGiuWxM%2BuQbHEjr2XWLBLEmPviWJBRbEgii12RBHEBgrSDCp2RRAh7zfefedmnHs4996z7tl17WeNcQZy7tprzvmbK%2BS%2F533XXIGHAgoooIACCiiggAIKrFogVn2mJyqggAIKKKCAAgoooAAGaG8CBRRQQAEFFFBAAQU6CBigO2B5qgIKKKCAAgoooIACBmjvAQUUUEABBRRQQAEFOggYoDtgeaoCCiiggAIKKKCAAgZo7wEFFFBAAQUUUEABBToIGKA7YHmqAgoooIACCiiggAIGaO8BBRRQQAEFFFBAAQU6CBigO2B5qgIKKKCAAgoooIACBmjvAQUUUEABBRRQQAEFOggYoDtgeaoCCiiggAIKKKCAAgZo7wEFFFBAAQUUUEABBToIGKA7YHmqAgoooIACCiiggAIGaO8BBRRQQAEFFFBAAQU6CBigO2B5qgIKKKCAAgoooIACBmjvAQUUUEABBRRQQAEFOggYoDtgeaoCCiiggAIKKKCAAgZo7wEFFFBAAQUUUEABBToIGKA7YHmqAgoooIACCiiggAIGaO8BBRRQQAEFFFBAAQU6CBigO2B5qgIKKKCAAgoooIACB
{label: 'Argentina. Prim B Nacional', value: 88},
{label: 'Australia. A League', value: 283},
{label: 'Austria. Bundesliga', value: 49, flag: 'AUT'},
{label: 'Austria. 1 Liga', value: 50, flag: 'AUT'},
{label: 'Azerbaijan. Premyer Liqa', value: 106},
{label: 'Belarus. Premier League', value: 66},
{label: 'Belgium. First Division A', value: 24},
{label: 'Bosnia. Premier Liga', value: 64, flag: 'BIH'},
{label: 'Brazil. Serie A', value: 26},
{label: 'Brazil. Serie B', value: 89},
{"key":"d81635357203e5a5f42ec76c150e961f","callText":"Куда: На море\u0017\nЖелаемые даты вылета: 20 июля — 3 августа\u0017\nСколько ночей: 5 - 11\u0017\nКто едет: 2 взрослых\u0017\nПожелания: ","warning":"","searchId":15617071,"searchKey":"d81635357203e5a5f42ec76c150e961f","searchTitle":"Туры на Бали","searchUrl":"http://www.onlinetours.ru/tours/d81635357203e5a5f42ec76c150e961f?from=form","activeTime":0,"nextPageOffset":14,"results":[{"tour_id":"bg:406159:6b051a3a346a8598859a6f1013f52bdc","cheapestOffer":{"startDate":"2015-07-22","duration":7,"mealType":739},"offerCount":7,"id":406159,"title":"Kadriye Sarp","gtm_url":"/oteli/turkey/belek/sarp-hotel?adults=2\u0026depart_city_id=20001\u0026duration_from=5\u0026duration_to=11\u0026kids=0\u0026start_from=2015-07-20\u0026start_to=2015-08-03","url":"/oteli/turkey/belek/sarp-hotel?adults=2\u0026cache_time=1436970947\u0026depart_city_id=20001\u0026duration_from=5\u0026duration_to=11\u0026expired_before=1436974547\u0026from=form\u0026include_tickets=true\u0026kids=0\u
{"key":"47707d8bb76af58c7e4759e650233f22","callText":"Куда: Турция\u0017\nЖелаемые даты вылета: 8—9 августа\u0017\nСколько ночей: 7 - 10\u0017\nКто едет: 2 взрослых\u0017\nПожелания: ","warning":"","searchId":15617586,"searchKey":"47707d8bb76af58c7e4759e650233f22","searchTitle":"Туры в Турцию","searchUrl":"http://www.onlinetours.ru/tours/47707d8bb76af58c7e4759e650233f22?from=form","activeTime":0,"nextPageOffset":14,"results":[{"id":34302,"title":"Экономь и радуйся! Турция, отели Larissa, Всё включено!","gtm_url":"/special_offers/34302?from=form","url":"/special_offers/34302?from=form","stars":null,"location":"Турция","images":["http://static1.onlinetours.ru/system/uploads/special_offer_photo/image/6073/preview_8787519_l.jpg","http://static2.onlinetours.ru/system/uploads/special_offer_photo/image/6012/preview_Handsome_man_having_wife_a_piggyback_on_the_beach.jpg"],"price":"63 800","dat
Задача: написать приложение на Ruby on Rails, в котором:
На эндпойнт /incoming/ приходят POST-запросом данные в следующем формате:
<?xml version="1.0" encoding="UTF-8"?>
<data>
<players>
<player id="19489" name="Юрий" surname="Лодыгин" birthday="26.05.1990" height="185" weight="82" />
<player id="3779" name="Доменико" surname="Кришито" birthday="30.12.1986" height="183" weight="75" />
<player id="6796" name="Эсекьель" surname="Гарай" birthday="10.10.1986" height="188" weight="85" />
traceroute to de1.instatfootball.tv (78.47.168.62), 64 hops max, 52 byte packets
1 192.168.1.254 (192.168.1.254) 1.623 ms 3.335 ms 1.343 ms
2 10.81.24.1 (10.81.24.1) 9.073 ms 8.527 ms 8.575 ms
3 10.1.229.26 (10.1.229.26) 8.387 ms 7.785 ms 8.266 ms
4 10.251.179.201 (10.251.179.201) 7.724 ms 9.363 ms 8.441 ms
5 10.251.174.36 (10.251.174.36) 8.289 ms 8.530 ms 8.472 ms
6 10.251.175.1 (10.251.175.1) 9.941 ms 8.362 ms 10.709 ms
7 10.251.179.186 (10.251.179.186) 12.021 ms
10.251.179.226 (10.251.179.226) 9.214 ms
10.251.179.218 (10.251.179.218) 8.221 ms
08:09:03.259 [search-backend-akka.actor.default-dispatcher-23] ERROR akka.actor.OneForOneStrategy - key not found: key
akka.actor.ActorInitializationException: exception during creation
at akka.actor.ActorInitializationException$.apply(Actor.scala:218) ~[akka-actor_2.10-2.2.3.jar:2.2.3]
at akka.actor.ActorCell.create(ActorCell.scala:578) ~[akka-actor_2.10-2.2.3.jar:2.2.3]
at akka.actor.ActorCell.invokeAll$1(ActorCell.scala:425) ~[akka-actor_2.10-2.2.3.jar:2.2.3]
at akka.actor.ActorCell.systemInvoke(ActorCell.scala:447) ~[akka-actor_2.10-2.2.3.jar:2.2.3]
at akka.dispatch.Mailbox.processAllSystemMessages(Mailbox.scala:262) ~[akka-actor_2.10-2.2.3.jar:2.2.3]
at akka.dispatch.Mailbox.run(Mailbox.scala:218) ~[akka-actor_2.10-2.2.3.jar:2.2.3]
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:386) [akka-actor_2.10-2.2.3.jar:2.2.3]
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) [scala-library-2.10.4.jar:na]
@mustangostang
mustangostang / gist:8bd8c52e02d4288fb9bf
Last active August 29, 2015 14:19
unused templates
api/sugar_crm/debug.slim
api/v1/special_offers/index.json.jbuilder
asides/_call.slim
asides/_responds.slim
asides/_search.slim
asides/_why_we_region.slim
cms/landing/pages/_block.slim
comments/_comment.slim
comments/_form.slim
comments/create.js.erb
@mustangostang
mustangostang / windows-1251-convert.sh
Last active November 21, 2022 14:24
Convert windows-1251 to utf-8
#!/bin/zsh
for file in ./**/*.php
do
iconv -f windows-1251 -t UTF-8 "$file" > "${file%.php}-utf8.php"
rm $file
mv ${file%.php}-utf8.php $file
done