$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
if( %rightBtnCmd $= "noButtons" )
{
//do nothing, as there are no buttons
}
proprietary script language.
<?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));
}
}
}
<?php
$payload = '{ "products": [';
foreach ($products as $product) {
$payload .= $product->toJson() . ',';
}
$payload = substr($payload, 0, \strlen($payload) - 1);
$payload .= ']}';
<?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();
}
o.isInsured = function ()
{ return !!this.insured; }
Why don't be like normal people and use bool() cast?
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!
for x,x1 in enumerate(hack):
if hack[x] in letters:
exception +=1
ffs why
extern "C"
{
#include "gz.cpp"
#include "md4.cpp"
#include "socket.cpp"
#include "tdlini.cpp"
#include "tdlfs.cpp"
}
:(
zipped_file.extractall(f'{file_path}')
zipped_file.close()
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
<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>
const errorHandler = () => {
throw new Error();
};
try {
$order->addItem($item);
} catch (Exception $ex) {
throw $ex;
}