Aleksey kolyadin
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"objects":[{"id":1,"name":"\u0424\u0438\u043b\u044f","type":"shop","address":"\u041a\u0438\u0440\u043e\u0447\u043d\u0430\u044f \u0443\u043b, 7\u0430","phone":"8 (812) 272 48 31","fax":null,"operationTime":null,"info":null,"latitude":59.943832466281,"longitude":30.353669604911,"city":1,"metro":[1]},{"id":2,"name":"\u0421\u043e\u0431\u0430\u0447\u044c\u044f \u0436\u0438\u0437\u043d\u044c","type":"clinic","address":"\u0422\u0430\u0432\u0440\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u0443\u043b. \u0414. 27","phone":null,"fax":null,"operationTime":null,"info":null,"latitude":59.945299404861,"longitude":30.379030689566,"city":1,"metro":[1]},{"id":3,"name":"\u0415\u043d\u043e\u0442","type":"clinic","address":"8-\u044f \u043b\u0438\u043d\u0438\u044f,\u0412.\u041e. \u0434. 57","phone":null,"fax":null,"operationTime":null,"info":null,"latitude":59.944055405492,"longitude":30.274689604911,"city":1,"metro":[2]},{"id":4,"name":"\u0426\u0435\u043d\u0442\u0440 \u0441\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"objects":[{"id":1,"name":"\u0424\u0438\u043b\u044f","type":"shop","address":"\u041a\u0438\u0440\u043e\u0447\u043d\u0430\u044f \u0443\u043b, 7\u0430","phone":"8 (812) 272 48 31","fax":null,"operationTime":null,"info":null,"latitude":59.943832466281,"longitude":30.353669604911,"city":1,"metro":[1]},{"id":2,"name":"\u0421\u043e\u0431\u0430\u0447\u044c\u044f \u0436\u0438\u0437\u043d\u044c","type":"clinic","address":"\u0422\u0430\u0432\u0440\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u0443\u043b. \u0414. 27","phone":null,"fax":null,"operationTime":null,"info":null,"latitude":59.945299404861,"longitude":30.379030689566,"city":1,"metro":[1]},{"id":3,"name":"\u0415\u043d\u043e\u0442","type":"clinic","address":"8-\u044f \u043b\u0438\u043d\u0438\u044f,\u0412.\u041e. \u0434. 57","phone":null,"fax":null,"operationTime":null,"info":null,"latitude":59.944055405492,"longitude":30.274689604911,"city":1,"metro":[2]},{"id":4,"name":"\u0426\u0435\u043d\u0442\u0440 \u0441\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f 2 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [{"id":5,"name":"\u0412\u0435\u0442\u0435\u0440\u0438\u043d\u0430\u0440\u043d\u0430\u044f \u043a\u043b\u0438\u043d\u0438\u043a\u0430","type":"clinic","address":"\u0426\u0432\u0435\u0442\u043d\u043e\u0439 \u0431-\u0440, \u0434\u043e\u043c \u2116 11, \u043a\u043e\u0440\u043f\u0443\u0441 1","phone":null,"info":null,"latitude":55.769781849016,"longitude":37.61935128282,"createdAt":{"date":"2015-02-04 13:24:43.000000","timezone_type":3,"timezone":"Europe\/Moscow"},"updatedAt":{"date":"2015-02-04 13:24:43.000000","timezone_type":3,"timezone":"Europe\/Moscow"}},{"id":3,"name":"\u0415\u043d\u043e\u0442","type":"clinic","address":"8-\u044f \u043b\u0438\u043d\u0438\u044f,\u0412.\u041e. \u0434. 57","phone":null,"info":null,"latitude":59.944055405492,"longitude":30.274689604911,"createdAt":{"date":"2015-02-04 11:47:51.000000","timezone_type":3,"timezone":"Europe\/Moscow"},"updatedAt":{"date":"2015-02-04 13:21:59.000000","timezone_type":3,"timezone":"Europe\/Moscow"}},{"id":6,"name":"\u041f\u0438\u0442\u043e\u043c\u043d\u |
kolyadin
/ ImportUserCommand.php
Created
January 21, 2015 08:55
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| namespace Popcorn\UserBundle\Command; | |
| use Doctrine\DBAL\DriverManager; | |
| use Doctrine\ORM\Id\AssignedGenerator; | |
| use Doctrine\ORM\Mapping\ClassMetadata; | |
| use Doctrine\ORM\QueryBuilder; | |
| use Popcorn\GeoBundle\Entity\Country; | |
| use Popcorn\ImageBundle\Entity\NullImage; |
kolyadin
/ ImportUserCommand.php
Created
January 12, 2015 10:17
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $user = (new User()) | |
| ->setId($table['id']) | |
| ->setEnabled(true) | |
| ->setEmail($table['email']) | |
| ->setPlainPassword($table['pass']) | |
| ->addGroup($em->getRepository('UserBundle:Group')->findOneBy(['name' => 'user'])) | |
| ->setNick($table['nick']) | |
| ->setUsername($table['nick']) | |
| ->setAvatar(null) | |
| ->setRating((int)$table['rating']) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CRM_Query_DigestUnsubscribe Object | |
| ( | |
| [url:protected] => https://felix-services.directcrm.ru/v2/customers/current/ticket | |
| [method:protected] => POST | |
| [config:CRM_Query2:private] => Config_Group Object | |
| ( | |
| [_parent_instance:protected] => Config Object | |
| ( | |
| [_sources:protected] => Array | |
| ( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CRM_Query_DigestUnsubscribe Object | |
| ( | |
| [url:protected] => https://felix-services.directcrm.ru/v2/customers/current/ticket | |
| [method:protected] => POST | |
| [config:CRM_Query2:private] => Config_Group Object | |
| ( | |
| [_parent_instance:protected] => Config Object | |
| ( | |
| [_sources:protected] => Array | |
| ( |
kolyadin
/ deny index
Created
December 18, 2014 09:17
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| User-agent: * | |
| Disallow: / |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| IF(user.sex='m','Mr','Mrs') AS 'Title', | |
| user.username AS 'First Name', | |
| user.lastname AS 'Surname', | |
| '' AS 'AddressLine1', | |
| '' AS 'AddressLine2', | |
| '' AS 'AddressLine3', | |
| '' AS 'AddressLine4', | |
| '' AS 'AddressLine5', | |
| '' AS 'Town', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT COUNT(distinct id) FROM `flx__games` where uid!=0 and created between '2014-01-15' and '2014-10-26 23:59:59' |