public function getProduct($product_id) {
		$query = $this->db->query("SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM " . DB_PREFIX . "product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM " . DB_PREFIX . "product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM " . DB_PREFIX . "product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "') AS reward, (SELECT ss.name FROM " . DB_PREFIX . "stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '" . (int)$this->config->get('config_language_id') . "') AS stock_status, (SELECT wcd.unit FROM " . DB_PREFIX . "weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS weight_class, (SELECT lcd.unit FROM " . DB_PREFIX . "length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '" . (int)$this->config->get('config_language_id') . "') AS length_class, (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM " . DB_PREFIX . "review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '" . (int)$product_id . "' AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "'");
		/* ... */

Opencart's Product model

By opencart, 2017-12-12 12:52:34
if ($getCount) {
    foreach ($all_items as $item) {
        $item_arr[$item->id] = 0;
    }
    
    return count($item_arr);
}
By Anonymous, 2020-01-08 22:15:04
int i=0;

                        for (i=0; i<msg.length;i++){

                            switch (i){

                                  case 0:

                                  case 1:

                                  case 2:

                                  case 3:

                                  case 4:

                                  case 5:

                                  case 6:

                                  case 7:

                                  case 8:

                                  case 9:

                                  case 10:

                                  case 11:

                                  case 18:

                                  case 19:

                                  case 26:

                                  case 27:

                                  case 34:

                                  case 35:

                                  case 42:

                                  case 43:

                                  case 50:

                                  case 51:

                                  case 52:

                                  case 53:

                                  case 54:

                                  case 55:

                                  case 58:

                                  case 59:

                                  case 62:

                                  case 63: log.debug("******** TRAZA-BEA: autenticacion ntlm. mensaje[" + i + "]: " + msg[i] + " SINSIGNO: " + (int)(msg[i] & 0x00ff) + "   " + new String(msg,i,1, "UTF-16LE")); break;

                                  case 12:

                                  case 14:

                                  case 16:

                                  case 20:

                                  case 22:

                                  case 24:

                                  case 28:

                                  case 30:

                                  case 32:

                                  case 36:

                                  case 38:

                                  case 40:

                                  case 44:

                                  case 46:

                                  case 48:

                                  case 56:

                                  case 60:log.debug("******** TRAZA-BEA: autenticacion ntlm. mensaje[" + i + "]: " + msg[i] + " SINSIGNO: " + (int)(msg[i] & 0x00ff) + "   " + new String(msg,i,2, "UTF-16LE")); break;

                                  case 13:

                                  case 15:

                                  case 17:

                                  case 21:

                                  case 23:

                                  case 25:

                                  case 29:

                                  case 31:

                                  case 33:

                                  case 37:

                                  case 39:

                                  case 41:

                                  case 45:

                                  case 47:

                                  case 49:

                                  case 57:

Why not case 60? LOL

By Pabs, 2017-12-26 14:03:33
if (!empty($tickets)) {
    if (count($tickets)) {

        $c_start = strtotime($convetion_details['start']);
        $c_end   = strtotime($convetion_details['end']);

        $i = 0;

        while ($c_start <= $c_end) {
            if (is_int($i / 4) && $i > 0) $convetion_days_html .= '</tr><tr>';
            $convetion_days_html .= '<td>' . date('d.m', $c_start) . ' ' . __t($days_of_week[date('w', $c_start)]) . ' &nbsp;&nbsp;&nbsp;&nbsp;<img src="' . str_replace('https', 'http', TEMPLATE_WWWPATH) . '/images/checkbox.png"/></td>';
            $c_start             = strtotime('+1 day', $c_start);
            $i++;
        }
        
        //...

legacy code from 2007 indians

By seyfer, 2017-07-11 10:23:00
    if (SelectionAndTimeData[1] < 2000 or \
        SelectionAndTimeData[2] < 1 or SelectionAndTimeData[2] > 12 or \
        SelectionAndTimeData[3] < 1 or SelectionAndTimeData[3] > 31 or \
        SelectionAndTimeData[4] < 0 or SelectionAndTimeData[4] > 24 or \
        SelectionAndTimeData[5] < 0 or SelectionAndTimeData[5] > 60 or \
        SelectionAndTimeData[2] < 0 or SelectionAndTimeData[2] >60):   
        
        print('***************************************************************************')
        print(' Entered date is not valid')
        print('****************************************************************************')
By loopyroberts, 2017-12-12 22:55:56
<?
function null($null) {
    return null;   
}
By SH2, 2018-02-20 11:31:33
<?php
$now = time();

while ($now + 10 > time()) {
    
    // Just chill...smoke a blunt
}

echo "Done.\n";
By Sobak, 2015-07-21 12:30:55
Long timestamp = Instant.now().toEpochMilli(); // fallback
if (oTimestamp instanceof Integer)
    timestamp = (Integer) oTimestamp *1L;
else
    if (oTimestamp instanceof Long)
        timestamp = (Long) oTimestamp * 1L;
By Anonymous, 2017-12-12 08:13:40
static NSInteger const CBBIndexOne =  1;
static NSInteger const CBBIndexTwo =  2;
static NSInteger const CBBIndexThree =  3;
static NSInteger const CBBIndexFour =  4;
static NSInteger const CBBIndexSix =  6;
static NSInteger const CBBIndexSeven =  7;
static NSInteger const CBBIndexEight =  8;

static NSInteger const CBBRowHeightFifty =  50;
static NSInteger const CBBRowHeightSixtySix =  66;
static NSInteger const CBBRowHeightSixtyTwo =  62;
static NSInteger const CBBRowHeightOneTen =  110;
static NSInteger const CBBRowHeightOneEightEight =  188;
static NSInteger const CBBRowHeightTwoHundred =  200;
static NSInteger const CBBRowHeightThirtySix =  36;
By sulthan, 2019-08-15 10:55:57
zipped_file.extractall(f'{file_path}')
zipped_file.close()
By Anonymous, 2017-12-19 10:29:52
for x,x1 in enumerate(hack):
 
        if hack[x] in letters:
            exception +=1

ffs why

By just why, 2018-02-05 01:25:30
if((substr($onefile, -4) == ".Mp3") OR 
    (substr($onefile, -4) == ".ogg") OR 
    (substr($onefile, -4) == ".OGG") OR 
    (substr($onefile, -4) == ".oGG") OR 
    (substr($onefile, -4) == ".OGg") OR 
    (substr($onefile, -4) == ".Ogg") OR 
    (substr($onefile, -4) == ".OgG") OR 
    (substr($onefile, -4) == ".mP3") OR 
    (substr($onefile, -4) == ".MP3") OR 
    (substr($onefile, -4) == ".mp3")){
    
    // do stuff
} 

gotta make sure you account for capitalization

By Kyuunex, 2018-07-02 04:58:09
date('Y-m-d').'T'.date("H:i:s", strtotime("- 1 hour")).'Z'

Back to the future

By loutre, 2018-12-19 15:37:45
file = fopen(argv[1], "r");

if (file == NULL){}
    exit(EXIT_FAILURE);

Those silly curly braces.

By Anonymous, 2017-12-14 05:47:47
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