Skip to content

Instantly share code, notes, and snippets.

View alxfv's full-sized avatar

Alexander Fedorov alxfv

View GitHub Profile
<?php
class AppController extends Controller
{
/**
* @Route("/test-collection-form", name="test-collection-form")
* @Template()
*/
public function testCollectionFormAction(Request $request)
{
select
td.tid, td.name, count(n.nid) as cnt
from `term_data` as td
inner join `content_field_author` ca on ca.field_author_value = td.tid
inner join node n on n.nid = ca.nid
where (td.vid = 2 and n.type = 'article')
and (n.created >= 1396310400 and n.created <= 1398816000)
group by n.nid
order by cnt desc;
<?php
/**
* @Route("/test", name="test")
* @Template()
*/
public function testAction(Request $request)
{
/** @var User $user */
$user = $this->getUser();
History.Adapter.bind(window, 'statechange',function(){ // Note: We are using statechange instead of popstate
var State = History.getState(); // Note: We are using History.getState() instead of event.state
if (State.data.state !== undefined) {
var url = State.url;
$.ajax({
url: url
}).done(function(data) {
$('.content').html(data);
<?php
session_start();
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (!empty($_SESSION['favourite'])) {
unset($_SESSION['favourite']);
$text = 'Добавить в избранное';
}
else {
mysql> select * from km_sms order by rand() limit 20;
+------+------------+------------+--------+--------------+------------------------------------------------------------------------------------------+
| id | service_id | timestamp | sender | phone | msg |
+------+------------+------------+--------+--------------+------------------------------------------------------------------------------------------+
| 2947 | 773392969 | 1382691123 | | +89032711209 | V10-NIKA3-ICMP |
| 919 | 269962847 | 1348358343 | | +79250354848 | Checking http://knigi.km.ru failed: code 502 size 173 response time 0.001959 |
| 274 | 249776054 | 1343652422 | | +79250354848 | Checking http://vkrugudruzei.ru/ failed: code 302 size 145 response time 0.028719 |
| 1592 | 385108759 | 1359709957 | | +89162180882 | BACKUP1-
<?php
$address_list = <<<ADDRESS_LIST
",<\"\"FJI\"'<>[]," <[email protected]>, "sdfsdf" <[email protected]>, "SDFsdf\")@(*$@!#" <[email protected]>, <[email protected]>
ADDRESS_LIST;
$address_list = rcube_mime::decode_address_list($address_list);
print '<pre>';
print_r($address_list);
@alxfv
alxfv / gist:6523189
Last active December 22, 2015 19:59
JSON formats for uploading files
var yandex1 = {
"write_attachment": {
"id": "qODQAJDkJn89UwyIlDBdOTBZSTRAD1LMn6y36QJOlhFH%2F%2FESrlRgYknmeF39ttRt4XiQDayc2G4%3D",
"previewUrl": "https://webattach.mail.yandex.net/message_part_real/?sid=qODQAJDkJn89UwyIlDBdOTBZSTRAD1LMn6y36QJOlhFH%2F%2FESrlRgYknmeF39ttRtGdj2%2A%2FVPrWs%3D&thumb=y", "viewLargeUrl": "https://webattach.mail.yandex.net/message_part_real/?sid=qODQAJDkJn89UwyIlDBdOTBZSTRAD1LMn6y36QJOlhFH%2F%2FESrlRgYknmeF39ttRtGdj2%2A%2FVPrWs%3D&no_disposition=y", "downloadUrl": "https://webattach.mail.yandex.net/message_part_real/?sid=qODQAJDkJn89UwyIlDBdOTBZSTRAD1LMn6y36QJOlhFH%2F%2FESrlRgYknmeF39ttRtGdj2%2A%2FVPrWs%3D&name=mermaid_by_pascalblanche.jpg",
"contentType": "image/jpeg",
"attachmentType": "image",
"timer_logic": "272597"
}
};
{"write_attachment":{"id":"qODQAJDkJn89UwyIlDBdOTBZSTRAD1LMn6y36QJOlhFH%2F%2FESrlRgYknmeF39ttRt4XiQDayc2G4%3D","previewUrl":"https://webattach.mail.yandex.net/message_part_real/?sid=qODQAJDkJn89UwyIlDBdOTBZSTRAD1LMn6y36QJOlhFH%2F%2FESrlRgYknmeF39ttRtGdj2%2A%2FVPrWs%3D&thumb=y","viewLargeUrl":"https://webattach.mail.yandex.net/message_part_real/?sid=qODQAJDkJn89UwyIlDBdOTBZSTRAD1LMn6y36QJOlhFH%2F%2FESrlRgYknmeF39ttRtGdj2%2A%2FVPrWs%3D&no_disposition=y","downloadUrl":"https://webattach.mail.yandex.net/message_part_real/?sid=qODQAJDkJn89UwyIlDBdOTBZSTRAD1LMn6y36QJOlhFH%2F%2FESrlRgYknmeF39ttRtGdj2%2A%2FVPrWs%3D&name=mermaid_by_pascalblanche.jpg","contentType":"image/jpeg","attachmentType":"image","timer_logic":"272597"}}
@alxfv
alxfv / gist:6219456
Last active December 21, 2015 00:19
$(function() {
(function() {
$('form').submit(function() {
$.ajax({
url: '/app_dev.php/users/510a702aa3d0b4f0c9dbf10b/edit',
data: $('form').serialize(),
type: 'POST',
dataType: 'json',
success: function(data, textStatus, jqXHR ) {
if (data.status == 'invalid') {