$gallery = \common\models\UtVideogallery::find()->select(['ut_videogallery.VideogalleryID',
                'ut_videogallery.Name_rus','ut_videogallery.TournamentID','ut_videogallery.MatchID', 'Slug',
                'ut_videogallery.Date','COUNT(ut_video_to_gallery.VideoToGalleryID) count','ut_matches_videos.Data',
                'm1.Data DataP'])
                ->leftJoin('ut_video_to_gallery','ut_video_to_gallery.VideogalleryID=ut_videogallery.VideogalleryID')
                ->leftJoin('ut_matches_videos','ut_matches_videos.VideoID=ut_video_to_gallery.VideoID')
                ->leftJoin('ut_matches_videos m1','m1.VideoID=ut_videogallery.PreviewID')
                ->where(['ut_videogallery.Active'=>1])
                //->andWhere(['TournamentID'=>$list['selected']])
                ->groupBy('ut_videogallery.VideogalleryID')
                ->orderBy('ut_videogallery.Date DESC')
                ->limit(self::$countPerPage)
                ->asArray()->all();
        foreach ($gallery as $key => $value) {
            if($value['count']==0) unset($gallery[$key]);
        }
        foreach($gallery as $k=>$v){
            if(isset($v['Data']))
                $v['Data'] = str_replace('http:','https:',$v['Data']);
            if(isset($v['DataP']))
                $v['DataP'] = str_replace('http:','https:',$v['DataP']);
            $gallery[$k]=$v;
        }
        $galleryCount = \common\models\UtVideogallery::find()->select(['ut_videogallery.VideogalleryID',
                'ut_videogallery.Name_rus','ut_videogallery.TournamentID','ut_videogallery.MatchID',
                'ut_videogallery.Date','COUNT(ut_video_to_gallery.VideoToGalleryID) count','ut_matches_videos.Data'])
                ->leftJoin('ut_video_to_gallery','ut_video_to_gallery.VideogalleryID=ut_videogallery.VideogalleryID')
                ->leftJoin('ut_matches_videos','ut_matches_videos.VideoID=ut_video_to_gallery.VideoID')
                ->leftJoin('ut_matches_videos m1','m1.VideoID=ut_videogallery.PreviewID')
                ->where(['ut_videogallery.Active'=>1])
                //->andWhere(['TournamentID'=>$list['selected']])
                ->groupBy('ut_videogallery.VideogalleryID')   
                ->orderBy('ut_videogallery.Date DESC')
                ->asArray()->all();
        foreach ($galleryCount as $key => $value) {
            if($value['count']==0) unset($galleryCount[$key]);
        }
        $pagination = new \yii\data\Pagination(
        [
            'totalCount' => count($galleryCount),
            'pageSize' => self::$countPerPage,

        ]);

Picasso of PHP

By chernomorets, 2017-03-03 11:26:18
if( %rightBtnCmd $= "noButtons" )
{
    //do nothing, as there are no buttons   
}

proprietary script language.

By Anonymous, 2017-12-14 19:52:22
#48 PHP +50
<?php
private function redirectFromOldSlug($pSlug, $pLanguageCode)
{
    /*
    $redirectArray[3][1] = 'beauty-young';
    $redirectArray[3][2] = 'beauty-and-rejuvenation';
    $redirectArray[3][3] = 'beauty-young';
    $redirectArray[3][4] = 'beauty-young';
    $redirectArray[2][1] = 'beauty-slim';
    $redirectArray[2][2] = 'beauty-slim';
    $redirectArray[2][3] = 'beauty-slim';
    $redirectArray[2][4] = 'beauty-slim';
    $redirectArray[18][1] = 'white-smile---2-dniowy-pakiet';
    $redirectArray[18][2] = 'white-smile-2---day-package-hilton-hotel';
    $redirectArray[18][3] = 'white-smile';
    $redirectArray[18][4] = 'white-smile---2---day-package';
    $redirectArray[17][1] = 'zdrowie-z-pieknem';
    $redirectArray[17][2] = 'healthy-and-beauty-2---day-with-dentist-botox';
    $redirectArray[17][3] = 'gesundheit-von-schonheit-2-tage';
    $redirectArray[17][4] = 'vard-av-skonhet-2-dagar';
    $redirectArray[19][1] = 'beauty-care';
    $redirectArray[19][2] = 'beauty-care';
    $redirectArray[19][3] = 'beauty-care';
    $redirectArray[19][4] = 'beauty-care';
    $redirectArray[21][1] = 'luksus-spa---hilton-w-gdasku';
    $redirectArray[21][2] = 'spa-in-hilton-hotel';
    $redirectArray[21][3] = 'spa-im-hilton---fur-sie';
    $redirectArray[21][4] = 'spa-pa-hilton---for-dig';
    $redirectArray[26][1] = 'zabiegi-implantacji-w-sea-tower';
    $redirectArray[26][2] = 'implant-treatments-in-the-sea-tower';
    $redirectArray[26][3] = 'implantate-in-der-sea-tower';
    $redirectArray[26][4] = 'implantat-i-sea-tower';
    $redirectArray[23][1] = 'mezoterapia-peeling-lipoliza-botox-hialuron';
    $redirectArray[23][2] = 'beauty-med';
    $redirectArray[23][3] = 'beauty-med';
    $redirectArray[23][4] = 'beauty-med';
    $redirectArray[34][1] = 'paski-brzuch-w-8-dni';
    $redirectArray[34][2] = 'special-abdomen-programme';
    $redirectArray[34][3] = 'das-speziell-gestaltete-und-vorbereitete-programm';
    $redirectArray[34][4] = 'ett-speciellt-utformat-program';
    $redirectArray[27][1] = 'zdrowy-kregosup';
    $redirectArray[27][2] = 'healthy-spine-clinic';
    $redirectArray[27][3] = 'wirbelsaule-ist-die-basis';
    $redirectArray[27][4] = 'frisk-ryggrad';
    $redirectArray[5][1] = 'pakiet-stomatologiczny-hotel-hilton';
    $redirectArray[5][2] = 'healthy-smile-2-day-dental-package-hilton-hotel';
    $redirectArray[5][3] = 'healthy-smile-2---day---dental-package-hotel-hilton';
    $redirectArray[5][4] = 'healthy-smile-2---day---dental-package-hotel-hilton';
    $redirectArray[16][1] = 'beauty-calming--anti-redness-2-dni';
    $redirectArray[16][2] = 'beauty-calming--anti-redness-2-days';
    $redirectArray[16][3] = 'beauty-calming--anti-redness';
    $redirectArray[16][4] = 'beauty-calming--anti-redness';
    $redirectArray[22][1] = 'stomatolog-na-twoja-kiesze';
    $redirectArray[22][2] = 'dentist-for-every-pocket';
    $redirectArray[22][3] = 'zahnarzt-fur-jedes-budget';
    $redirectArray[22][4] = 'tandlakare-for-varje-budget';
    $redirectArray[25][1] = 'przeglad-stomatologiczny-wybielanie-zebow';
    $redirectArray[25][2] = 'teeth-whitening';
    $redirectArray[25][3] = 'zahnaufhellung';
    $redirectArray[25][4] = 'tandblekning';
    $redirectArray[24][1] = 'implant-w-dwa-dni';
    $redirectArray[24][2] = 'lifelong-guarantee-for-implants';
    $redirectArray[24][3] = 'lebenslange-garantie-fur-implantate';
    $redirectArray[24][4] = 'livslangt-garanti-for-implantat';
    $redirectArray[39][1] = 'nogi-bez-zylakow';
    $redirectArray[39][2] = 'varicose';
    $redirectArray[39][3] = 'das-venefit-verfahren';
    $redirectArray[39][4] = 'forfarande-venefit';
    $redirectArray[36][1] = 'rehabilitacja-narzadu-ruch';
    $redirectArray[36][2] = 'locomotor-system-14-day-stay-in-the-health-resort';
    $redirectArray[36][3] = 'rehabilitation-14-tage-aufenthalt-im-sanatorium';
    $redirectArray[36][4] = 'rorelseapparaten---rehabiliteringsemester';
    $redirectArray[35][1] = 'zdrowe-serce-14-dniowy-program';
    $redirectArray[35][2] = 'cardiology-14-day-stay-in-the-health-resort';
    $redirectArray[35][3] = 'kardiologie---14-tage-aufenthalt-im-sanatorium';
    $redirectArray[35][4] = 'kardiologi---rehabiliteringsemester';
    $redirectArray[37][1] = 'stomatolog-w-szczecinie';
    $redirectArray[37][2] = 'dentist-in-szczecin';
    $redirectArray[37][3] = 'zahnarzt-in-szczecin';
    $redirectArray[37][4] = 'tandlakare-i-szczecin';
    $redirectArray[32][1] = 'sanatorium-z-rehabilitacja-narza';
    $redirectArray[32][2] = 'physical-medicine-and-rehabilita';
    $redirectArray[32][3] = 'rehabilitation-bewegungs';
    $redirectArray[32][4] = 'rehabilitation-behandlingar';
     *
     */
    $redirectArray = array();
    $redirectArray['beauty-young']['pl'] = 3;
    $redirectArray['beauty-slim']['pl'] = 2;
    $redirectArray['white-smile---2-dniowy-pakiet']['pl'] = 18;
    $redirectArray['zdrowie-z-pieknem']['pl'] = 17;
    $redirectArray['beauty-care']['pl'] = 19;
    $redirectArray['luksus-spa---hilton-w-gdasku']['pl'] = 21;
    $redirectArray['zabiegi-implantacji-w-sea-tower']['pl'] = 26;
    $redirectArray['mezoterapia-peeling-lipoliza-botox-hialuron']['pl'] = 23;
    $redirectArray['paski-brzuch-w-8-dni']['pl'] = 34;
    $redirectArray['zdrowy-kregosup']['pl'] = 27;
    $redirectArray['pakiet-stomatologiczny-hotel-hilton']['pl'] = 5;
    $redirectArray['beauty-calming--anti-redness-2-dni']['pl'] = 16;
    $redirectArray['stomatolog-na-twoja-kiesze']['pl'] = 22;
    $redirectArray['przeglad-stomatologiczny-wybielanie-zebow']['pl'] = 25;
    $redirectArray['implant-w-dwa-dni']['pl'] = 24;
    $redirectArray['nogi-bez-zylakow']['pl'] = 39;
    $redirectArray['rehabilitacja-narzadu-ruch']['pl'] = 36;
    $redirectArray['zdrowe-serce-14-dniowy-program']['pl'] = 35;
    $redirectArray['stomatolog-w-szczecinie']['pl'] = 37;
    $redirectArray['sanatorium-z-rehabilitacja-narza']['pl'] = 32;
    $redirectArray['beauty-and-rejuvenation']['en'] = 3;
    $redirectArray['beauty-slim']['en'] = 2;
    $redirectArray['white-smile-2---day-package-hilton-hotel']['en'] = 18;
    $redirectArray['healthy-and-beauty-2---day-with-dentist-botox']['en'] = 17;
    $redirectArray['beauty-care']['en'] = 19;
    $redirectArray['spa-in-hilton-hotel']['en'] = 21;
    $redirectArray['implant-treatments-in-the-sea-tower']['en'] = 26;
    $redirectArray['beauty-med']['en'] = 23;
    $redirectArray['special-abdomen-programme']['en'] = 34;
    $redirectArray['healthy-spine-clinic']['en'] = 27;
    $redirectArray['healthy-smile-2-day-dental-package-hilton-hotel']['en'] = 5;
    $redirectArray['beauty-calming--anti-redness-2-days']['en'] = 16;
    $redirectArray['dentist-for-every-pocket']['en'] = 22;
    $redirectArray['teeth-whitening']['en'] = 25;
    $redirectArray['lifelong-guarantee-for-implants']['en'] = 24;
    $redirectArray['varicose']['en'] = 39;
    $redirectArray['locomotor-system-14-day-stay-in-the-health-resort']['en'] = 36;
    $redirectArray['cardiology-14-day-stay-in-the-health-resort']['en'] = 35;
    $redirectArray['dentist-in-szczecin']['en'] = 37;
    $redirectArray['physical-medicine-and-rehabilita']['en'] = 32;
    $redirectArray['beauty-young']['de'] = 3;
    $redirectArray['beauty-slim']['de'] = 2;
    $redirectArray['white-smile']['de'] = 18;
    $redirectArray['gesundheit-von-schonheit-2-tage']['de'] = 17;
    $redirectArray['beauty-care']['de'] = 19;
    $redirectArray['spa-im-hilton---fur-sie']['de'] = 21;
    $redirectArray['implantate-in-der-sea-tower']['de'] = 26;
    $redirectArray['beauty-med']['de'] = 23;
    $redirectArray['das-speziell-gestaltete-und-vorbereitete-programm']['de'] = 34;
    $redirectArray['wirbelsaule-ist-die-basis']['de'] = 27;
    $redirectArray['healthy-smile-2---day---dental-package-hotel-hilton']['de'] = 5;
    $redirectArray['beauty-calming--anti-redness']['de'] = 16;
    $redirectArray['zahnarzt-fur-jedes-budget']['de'] = 22;
    $redirectArray['zahnaufhellung']['de'] = 25;
    $redirectArray['lebenslange-garantie-fur-implantate']['de'] = 24;
    $redirectArray['das-venefit-verfahren']['de'] = 39;
    $redirectArray['rehabilitation-14-tage-aufenthalt-im-sanatorium']['de'] = 36;
    $redirectArray['kardiologie---14-tage-aufenthalt-im-sanatorium']['de'] = 35;
    $redirectArray['zahnarzt-in-szczecin']['de'] = 37;
    $redirectArray['rehabilitation-bewegungs']['de'] = 32;
    $redirectArray['beauty-young']['sv'] = 3;
    $redirectArray['beauty-slim']['sv'] = 2;
    $redirectArray['white-smile---2---day-package']['sv'] = 18;
    $redirectArray['vard-av-skonhet-2-dagar']['sv'] = 17;
    $redirectArray['beauty-care']['sv'] = 19;
    $redirectArray['spa-pa-hilton---for-dig']['sv'] = 21;
    $redirectArray['implantat-i-sea-tower']['sv'] = 26;
    $redirectArray['beauty-med']['sv'] = 23;
    $redirectArray['ett-speciellt-utformat-program']['sv'] = 34;
    $redirectArray['frisk-ryggrad']['sv'] = 27;
    $redirectArray['healthy-smile-2---day---dental-package-hotel-hilton']['sv'] = 5;
    $redirectArray['beauty-calming--anti-redness']['sv'] = 16;
    $redirectArray['tandlakare-for-varje-budget']['sv'] = 22;
    $redirectArray['tandblekning']['sv'] = 25;
    $redirectArray['livslangt-garanti-for-implantat']['sv'] = 24;
    $redirectArray['forfarande-venefit']['sv'] = 39;
    $redirectArray['rorelseapparaten---rehabiliteringsemester']['sv'] = 36;
    $redirectArray['kardiologi---rehabiliteringsemester']['sv'] = 35;
    $redirectArray['tandlakare-i-szczecin']['sv'] = 37;
    $redirectArray['rehabilitation-behandlingar']['sv'] = 32;

    if (!empty($redirectArray[$pSlug][$pLanguageCode]))
    {
        $packageId = $redirectArray[$pSlug][$pLanguageCode];
        $package = $this->packagesInstance->getPackageByIdAndLang($packageId, $pLanguageCode);
        if (!empty($package))
        {
            $this->redirect('package/'.$package['slug'], array('code' => 301));
        }
    }
}
By Kadet, 2015-07-30 02:01:37
<?php

$payload = '{ "products": [';
foreach ($products as $product) {
    $payload .= $product->toJson() . ',';
}
$payload = substr($payload, 0, \strlen($payload) - 1);
$payload .= ']}';
By sijolas, 2019-03-15 14:47:06
#29 PHP +49
<?php 
foreach (array_keys($values['services']) as $serviceId) {
    $service = $this->_em->find('\cut\Entity\Service', $serviceId);

    //\Doctrine\Common\Util\Debug::print_r($service); exit();
    //$reservation->addService($this->_em->find('\cut\Entity\Service', $serviceId));
    $this->view->serviceDeposits[$serviceId] = $service->getDeposit();
}
# checkign if clinic want's bill
$notifications = array();
$reservationServices = array();
foreach (array_keys($values['services']) as $serviceId) {
    $reservationServices[$serviceId] = new \cut\Entity\ReservationService();
    $service                         = $this->_em->find('\cut\Entity\Service', $serviceId);
    //\Doctrine\Common\Util\Debug::print_r($service); exit();
    $reservationServices[$serviceId]->setService($service);
    $reservationServices[$serviceId]->setReservation($reservation);
    $reservationServices[$serviceId]->setPatient($this->_helper->LoggedUser());

    switch ($service->getDeposit()) {
        case 'yes':
            $reservationServices[$serviceId]->setBillStatus(\cut\Entity\ReservationService::BILL_STATUS_NOT_PAID);
            break;
        default:
            $reservationServices[$serviceId]->setBillStatus(\cut\Entity\ReservationService::BILL_STATUS_NOT_WANTED);
    }

    $this->view->serviceDeposits[$serviceId] = $service->getDeposit();
}
By Anonymous, 2015-07-20 21:12:05
o.isInsured = function ()
{ return !!this.insured; }

Why don't be like normal people and use bool() cast?

By Anonymous, 2018-09-22 14:31:37
17 *	* * *	root	[[ $(ping -c1 8.8.8.8 | tail -n2 | head -n1 | cut -d"," -f2 | cut -d" " -f2) != "1" ]] && { { /etc/init.d/networking restart && /etc/init.d/network-manager restart && curl "https://api.telegram.org/XXX:XXX/sendMessage?chat_id=XXX&text=\%22networking\%20and\%20network-manager\%20restarted\%22" ;} && { wget -O /dev/null -o /dev/null https://nyifiles.pfsense.org/mirror/downloads/pfSense-CE-2.3.5-RELEASE-2g-i386-nanobsd.img.gz && curl "https://api.telegram.org/XXX:XXX/sendMessage?chat_id=XXX&text=\%22wget\%20download\%20OK\%22" || curl "https://api.telegram.org/XXX:XXX/sendMessage?chat_id=XXX&text=\%22wget\%20download\%20KO\%22" ;} ;}

With me! Sing! It's gonna ping! If not it's gonna restart the net! If yes is gonna send you a text! And then is gonna download a file, just to check!

By AnonimaBazhi, 2018-12-04 19:33:23
for x,x1 in enumerate(hack):
 
        if hack[x] in letters:
            exception +=1

ffs why

By just why, 2018-02-05 01:25:30
extern "C"
{
	#include "gz.cpp"
	#include "md4.cpp"
	#include "socket.cpp"
	#include "tdlini.cpp"
	#include "tdlfs.cpp"

}

:(

By Anonymous, 2017-10-01 04:08:55
zipped_file.extractall(f'{file_path}')
zipped_file.close()
By Anonymous, 2017-12-19 10:29:52
CREATE FUNCTION [dbo].[get_number_of_workers] 
(
     @number_of_workers varchar(10)
 
)
RETURNS int
AS
BEGIN
 
 
set @number_of_workers = replace(replace(replace(replace(LTRIM(RTRIM(@number_of_workers)), char(9), ''), char(10), ''), char(13),''), char(13)+char(10), '')
 
DECLARE @temp varchar(10)
 
SELECT
    @temp = number_of_workers 
FROM
    (SELECT LTRIM(RTRIM(@number_of_workers)) as number_of_workers) as temp
WHERE
       number_of_workers like  '[0-9]'
    or number_of_workers like  '[0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
    or number_of_workers like  '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
     
     
RETURN CONVERT(INT, @temp)
 
END
By Anonymous, 2015-07-22 14:59:09
#274 PHP +46
foreach ($k as $kk) {
    foreach ($kk as $kkk) {
    }
}
By Anonymous, 2018-04-05 14:50:22
#35 HTML +46
<div id="header">
 <ul>
 <li id="current"><a href="index.php">Strona Główna</a></li>
 <li id="current"><a href="index.php?cmd=1">Aktualności</a></li>
 <li id="current"><a href="index.php?cmd=2">Strony Serwisu</a></li>
 <li id="current"><a href="index.php?cmd=10">Artykuly</a></li>
 <li id="current"><a href="index.php?cmd=3">Linki</a></li>
 <li id="current"><a href="index.php?cmd=4">Księga Gości</a></li>
 <li id="current"><a href="index.php?cmd=5">Newsletter</a></li>
 <li id="current"><a href="index.php?cmd=6">Użytkownicy</a></li>
 <li id="current"><a href="index.php?cmd=8">Menu</a></li>
 <li id="current"><a href="index.php?cmd=12">Bannery</a></li>
 <li id="current"><a href="index.php?cmd=11">Pliki</a></li>
 <li id="current"><a href="index.php?cmd=7">Forum</a></li>
 <li id="current"><a href="index.php?cmd=13">Ban</a></li>
 <li id="current"><a href="index.php?cmd=9">Konfiguracja</a></li>
</ul></div>
By Sobak, 2015-07-21 12:35:41
const errorHandler = () => {
  throw new Error();
};
By Anonymous, 2018-10-08 19:35:38
try {
	$order->addItem($item);
} catch (Exception $ex) {
	throw $ex;
}
By baueri, 2019-04-10 16:49:46