Snippets.PRO - RedOctober

PHP: Force the browser to download the file

07.05.2013 15:12 RedOctober PHP 1 Comments

Force the browser to download the file instead of opening it ... Reveal Code

$file_text = 'Some text here';

if (isset($_SERVER['HTTP_USER_AGENT']) and strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE'))
    Header('Content-Type: application/force-download');
else
    Header('Content-Type: application/octet-stream');

Header('Accept-Ranges: bytes');
Header('Content-Length: ' . strlen($file_text));
Header('Content-disposition: attachment; filename="downloaded_file.txt"');

echo $file_text;
exit();

779

PHP: Determination of the country by IP

08.05.2013 16:31 RedOctober PHP 1 Comments

Determination of the country by IP using geoplugin.net OR ipinfodb.com. Will return the country code in "Alpha-2 ISO 3166-1" format (a two-char code) ... Reveal Code

function get_country($ip_addr) {
    $curlopt_useragent = 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0';
    $url = 'http://www.geoplugin.net/php.gp?ip=' . $ip_addr;
    $ch1 = curl_init();
    curl_setopt($ch1, CURLOPT_URL, $url);
    curl_setopt($ch1, CURLOPT_RETURNTRANSFER, 1);
    $result = curl_exec($ch1);
    $geoplugin = unserialize($result);

    if ($geoplugin[geoplugin_countryCode] != '') {
        return $geoplugin[geoplugin_countryCode];
    } else {
        $url = 'http://ipinfodb.com/ip_locator.php?ip=' . urlencode($ip_addr);
        $ch = curl_init();

        $curl_opt = array(
            CURLOPT_FOLLOWLOCATION => 1,
            CURLOPT_HEADER => 0,
            CURLOPT_RETURNTRANSFER => 1,
            CURLOPT_USERAGENT => $curlopt_useragent,
            CURLOPT_URL => $url,
            CURLOPT_TIMEOUT => 1,
            CURLOPT_REFERER => 'http://' . $_SERVER['HTTP_HOST'],
        );
        curl_setopt_array($ch, $curl_opt);
        $content = curl_exec($ch);

        if (!is_null($curl_info)) {
            $curl_info = curl_getinfo($ch);
        }

        curl_close($ch);

        if (preg_match('{Country : ([^<]*)}i', $content, $regs))
            $country = $regs[1];

        return $country;
    }
}

527

PHP: Determination of the browser and its version

07.05.2013 03:29 RedOctober PHP 2 Comments

Determination of the browser and its version by user-agent string. ... Reveal Code

function user_browser($agent) {
    preg_match("/(MSIE|Opera|Firefox|Chrome|Version|Opera Mini|Netscape|Konqueror|SeaMonkey|Camino|Minefield|Iceweasel|K-Meleon|Maxthon)(?:\/| )([0-9.]+)/", $agent, $browser_info);
    list(, $browser, $version) = $browser_info;
    if (preg_match("/Opera ([0-9.]+)/i", $agent, $opera))
        return 'Opera|' . $opera[1];
    if ($browser == 'MSIE') {
        preg_match("/(Maxthon|Avant Browser|MyIE2)/i", $agent, $ie);
        if ($ie)
            return $ie[1] . ' based on IE|' . $version;
        return 'IE|' . $version;
    }
    if ($browser == 'Firefox') {
        preg_match("/(Flock|Navigator|Epiphany)\/([0-9.]+)/", $agent, $ff);
        if ($ff)
            return $ff[1] . '|' . $ff[2];
    }
    if ($browser == 'Opera' && $version == '9.80')
        return 'Opera|' . substr($agent, -5);
    if ($browser == 'Version')
        return 'Safari|' . $version;
    if (!$browser && strpos($agent, 'Gecko'))
        return 'Browser based on Gecko';
    return $browser . '|' . $version;
}

707

JavaScript: Texarea remaining characters counter

18.10.2013 00:57 RedOctober JavaScript 0 Comments

Texarea remaining characters counter ... Reveal Code

//event_description_counter - counter text
//event_description - textarea

$(document).ready(function() {
    var text_max = 100;
    $('#event_description_counter').html(text_max + ' characters remaining');
  
    $('#event_description').keyup(function() {
        var text_length = $('#event_description').val().length;
        var text_remaining = text_max - text_length;

        $('#event_description_counter').html(text_remaining + ' characters remaining');
    });
});

472

PHP: Make a thumbnail screenshot of the video

09.10.2013 01:22 RedOctober PHP 0 Comments

Make a thumbnail screenshot of the video using ffmpeg ... Reveal Code

$source_path = $_SERVER['DOCUMENT_ROOT'] . 'content/videos/my_video.mp4';
$dest_path = $_SERVER['DOCUMENT_ROOT'] . 'content/videos/my_video.jpg';

//"-10" means offset of 10 seconds from start
exec("ffmpeg  -itsoffset -10  -i $source_path -s 320x240 $dest_path");

550

PHP: Test a Password Strength

03.08.2013 09:24 RedOctober PHP 0 Comments

Test a Password Strength. Will return number (1-10), or a word ("Weak", "Normal", "Good", "Awesome"). ... Reveal Code

function PasswordStrength($password, $return_as_number = true) {
    if (strlen($password) == 0) {
        return 1;
    }

    $strength = 0;

    /* Get the length of the password */
    $length = strlen($password);

    /* Check if password is not all lower case */
    if (strtolower($password) != $password) {
        $strength += 1;
    }

    /* Check if password is not all upper case */
    if (strtoupper($password) == $password) {
        $strength += 1;
    }

    /* Check string length is 8-15 chars */
    if ($length >= 8 && $length <= 15) {
        $strength += 1;
    }

    /* Check if lenth is 16 - 35 chars */
    if ($length >= 16 && $length <= 35) {
        $strength += 2;
    }

    /* Check if length >35 chars */
    if ($length > 35) {
        $strength += 3;
    }

    /* Get the numbers in the password */
    preg_match_all('/[0-9]/', $password, $numbers);
    $strength += count($numbers[0]);

    /* Check for special chars */
    preg_match_all('/[|!@#$%&*\/=?,;.:\-_+~^\\\]/', $password, $specialchars);
    $strength += sizeof($specialchars[0]);

    /* Get the number of unique chars */
    $chars = str_split($password);
    $num_unique_chars = sizeof(array_unique($chars));
    $strength += $num_unique_chars * 2;

    /* Strength is a number 1-10 */
    $strength = $strength > 99 ? 99 : $strength;
    $strength = floor($strength / 10 + 1);

    /* Return number OR word */
    if ($return_as_number) {
        return $strength;
    } else {
        if (($strength >= 1) && ($strength < 3))
            return 'Weak';
        if (($strength >= 3) && ($strength < 6))
            return 'Normal';
        if (($strength >= 6) && ($strength < 8))
            return 'Good';
        if (($strength >= 8) && ($strength <= 10))
            return 'Awesome';
    }
}

1037

JavaScript: Get UNIX timestamp

16.07.2013 02:22 RedOctober JavaScript 0 Comments

Get UNIX timestamp via JavaScript. Analogue for PHP's time() function: http://php.net/manual/en/function.time.php ... Reveal Code

var unix_timestamp = Math.round((new Date()).getTime() / 1000);

1027

PHP: Inverse function for nl2br

14.07.2013 03:53 RedOctober PHP 0 Comments

The inverse function for the standard nl2br: http://php.net/manual/en/function.nl2br.php ... Reveal Code

function br2nl($str) {
    $str = preg_replace("/(\r\n|\n|\r)/", "", $str);
    return preg_replace("=
=i", "\n", $str);
}

1046

PHP: Class for encryption / decryption

02.07.2013 01:52 RedOctober PHP 0 Comments

Class for encryption / decryption. Found here: http://stackoverflow.com/a/2448441/1546928 ... Reveal Code

1019

MySQL: Vehicles (cars) database

24.06.2013 01:56 RedOctober MySQL 0 Comments

Vehicles database, two tables with vehicle's models and its marks ... Reveal Code

CREATE TABLE IF NOT EXISTS `list_vehicle_marks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mark` (`value`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=128 ;


INSERT INTO `list_vehicle_marks` (`id`, `value`) VALUES
(114, 'ZX'),
(113, 'Xin Kai'),
(112, 'Wiesmann'),
(111, 'Wartburg'),
(110, 'Volvo'),
(109, 'Volkswagen'),
(108, 'Vector'),
(107, 'TVR'),
(106, 'Trabant'),
(105, 'Toyota'),
(104, 'Tianye'),
(103, 'Tianma'),
(102, 'Tatra'),
(101, 'Suzuki'),
(100, 'Subaru'),
(99, 'SsangYong'),
(98, 'Spyker'),
(97, 'Smart'),
(96, 'Skoda'),
(95, 'ShuangHuan'),
(94, 'SEAT'),
(93, 'Scion'),
(92, 'Saturn'),
(91, 'Saleen'),
(90, 'Saab'),
(89, 'Rover'),
(88, 'Rolls-Royce'),
(87, 'Renault'),
(86, 'PUCH'),
(85, 'Proton'),
(84, 'Porsche'),
(83, 'Pontiac'),
(82, 'Plymouth'),
(81, 'Peugeot'),
(80, 'Pagani'),
(79, 'Opel'),
(78, 'Oldsmobile'),
(77, 'Nissan'),
(76, 'Morgan'),
(75, 'Mitsuoka'),
(74, 'Mitsubishi'),
(73, 'Mini'),
(72, 'Microcar'),
(71, 'MG'),
(70, 'Metrocab'),
(69, 'Mercury'),
(68, 'Mercedes-Benz'),
(67, 'Mazda'),
(66, 'Maybach'),
(65, 'Maserati'),
(64, 'Maruti'),
(63, 'Mahindra'),
(62, 'Lotus'),
(61, 'Lincoln'),
(60, 'Lifan'),
(59, 'Lexus'),
(58, 'Landwind'),
(57, 'Land Rover'),
(56, 'Lancia'),
(55, 'Lamborghini'),
(54, 'Koenigsegg'),
(53, 'Kia'),
(52, 'Jeep'),
(51, 'Jaguar'),
(50, 'JAC'),
(49, 'Isuzu'),
(48, 'Iran Khodro'),
(47, 'Infiniti'),
(46, 'Hyundai'),
(45, 'Hummer'),
(44, 'HuangHai'),
(43, 'Honda'),
(42, 'Hafei'),
(41, 'Great Wall'),
(40, 'GMC'),
(39, 'Geo'),
(38, 'Geely'),
(37, 'Ford'),
(36, 'Fiat'),
(35, 'Ferrari'),
(34, 'FAW'),
(33, 'Eagle'),
(32, 'Donkervoort'),
(31, 'Doninvest'),
(30, 'Dong Feng'),
(29, 'Dodge'),
(28, 'Derways'),
(27, 'Daimler'),
(26, 'Daihatsu'),
(25, 'Daewoo'),
(24, 'Dadi'),
(23, 'Dacia'),
(22, 'Coggiola'),
(21, 'Citroen'),
(20, 'Chrysler'),
(19, 'Chevrolet'),
(18, 'Chery'),
(17, 'ChangFeng'),
(16, 'Caterham'),
(15, 'Cadillac'),
(14, 'BYD'),
(13, 'Buick'),
(12, 'Bugatti'),
(11, 'Brilliance'),
(10, 'BMW'),
(9, 'Bentley'),
(8, 'Austin'),
(7, 'Audi'),
(6, 'Aston Martin'),
(5, 'Asia'),
(4, 'Aro'),
(3, 'Alpina'),
(2, 'Alfa Romeo'),
(1, 'Acura');

CREATE TABLE IF NOT EXISTS `list_vehicle_models` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mark_id` int(11) DEFAULT NULL COMMENT 'Link to `list_vehicle_marks`.`id`',
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mark_id` (`mark_id`,`value`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1546 ;


INSERT INTO `list_vehicle_models` (`id`, `mark_id`, `value`) VALUES
(1402, 114, 'Landmark'),
(1401, 114, 'GrandTiger'),
(1400, 113, 'SUV X3'),
(1399, 113, 'SR-V X3'),
(1398, 113, 'PICKUP X3'),
(1397, 112, 'Roadster'),
(1396, 112, 'GT'),
(1395, 111, '353'),
(1394, 110, 'XC90'),
(1393, 110, 'XC70'),
(1392, 110, 'V70'),
(1391, 110, 'V50'),
(1390, 110, 'V40 Kombi'),
(1389, 110, 'S90'),
(1388, 110, 'S80'),
(1387, 110, 'S70'),
(1386, 110, 'S60'),
(1385, 110, 'S40'),
(1384, 110, 'C70'),
(1383, 110, 'C30'),
(1382, 110, '960'),
(1381, 110, '940'),
(1380, 110, '850'),
(1379, 110, '780 Bertone'),
(1378, 110, '760'),
(1377, 110, '740'),
(1376, 110, '480 E'),
(1375, 110, '460 L'),
(1374, 110, '440 K'),
(1373, 110, '340-360'),
(1372, 110, '240'),
(1371, 110, '164'),
(1370, 109, 'Vento'),
(1369, 109, 'Touran'),
(1368, 109, 'Touareg'),
(1367, 109, 'Tiguan'),
(1366, 109, 'Taro'),
(1365, 109, 'Sharan'),
(1364, 109, 'Scirocco'),
(1363, 109, 'Santana'),
(1362, 109, 'Polo'),
(1361, 109, 'Pointer'),
(1360, 109, 'Phaeton'),
(1359, 109, 'Passat'),
(1358, 109, 'NEW Beetle'),
(1357, 109, 'Multivan'),
(1356, 109, 'Lupo'),
(1355, 109, 'Kaefer'),
(1354, 109, 'Jetta'),
(1353, 109, 'Golf Plus'),
(1352, 109, 'Golf'),
(1351, 109, 'Fox'),
(1350, 109, 'Eos'),
(1349, 109, 'Corrado'),
(1348, 109, 'Caddy'),
(1347, 109, 'Bora'),
(1346, 108, 'W8 Twin Turbo'),
(1345, 107, 'Griffith'),
(1344, 106, 'P 601'),
(1343, 105, 'Yaris Verso'),
(1342, 105, 'Yaris'),
(1341, 105, 'Wish'),
(1340, 105, 'Windom'),
(1339, 105, 'Will'),
(1338, 105, 'Voxy'),
(1337, 105, 'Voltz'),
(1336, 105, 'Vitz'),
(1335, 105, 'Vista'),
(1334, 105, 'Verossa'),
(1333, 105, 'Venza'),
(1332, 105, 'Vellfire'),
(1331, 105, 'Tundra'),
(1330, 105, 'Tercel'),
(1329, 105, 'Tacoma'),
(1328, 105, 'Supra'),
(1327, 105, 'Succeed'),
(1326, 105, 'Starlet'),
(1325, 105, 'Sprinter'),
(1324, 105, 'Sparky'),
(1323, 105, 'Solara'),
(1322, 105, 'Soarer'),
(1321, 105, 'Sienta'),
(1320, 105, 'Sienna'),
(1319, 105, 'Sera'),
(1318, 105, 'Sequoia'),
(1317, 105, 'Scepter'),
(1316, 105, 'Regius Ace'),
(1315, 105, 'Regius'),
(1314, 105, 'Regius'),
(1313, 105, 'Raum'),
(1312, 105, 'Ractis'),
(1311, 105, 'RAV 4'),
(1310, 105, 'Pronard'),
(1309, 105, 'Progres'),
(1308, 105, 'Probox'),
(1307, 105, 'Prius'),
(1306, 105, 'Previa'),
(1305, 105, 'Premio'),
(1304, 105, 'Porte'),
(1303, 105, 'Platz'),
(1302, 105, 'Picnic'),
(1301, 105, 'Passo'),
(1300, 105, 'Paseo'),
(1299, 105, 'Origin'),
(1298, 105, 'Opa'),
(1297, 105, 'Noah'),
(1296, 105, 'Nadia'),
(1295, 105, 'Matrix'),
(1294, 105, 'MasterAce'),
(1293, 105, 'Mark X'),
(1292, 105, 'Mark II'),
(1291, 105, 'MR-S'),
(1290, 105, 'MR 2'),
(1289, 105, 'Lite Ace'),
(1288, 105, 'Land Cruiser 80'),
(1287, 105, 'Land Cruiser 70'),
(1286, 105, 'Land Cruiser 200'),
(1285, 105, 'Land Cruiser 100'),
(1284, 105, 'Land Cruiser (90) Prado'),
(1283, 105, 'Land Cruiser (120) Prado'),
(1282, 105, 'Land Cruiser'),
(1281, 105, 'Kluger'),
(1280, 105, 'Ist'),
(1279, 105, 'Ipsum'),
(1278, 105, 'ISis'),
(1277, 105, 'Hilux Surf'),
(1276, 105, 'Hilux Pick Up'),
(1275, 105, 'Highlander'),
(1274, 105, 'Hiace'),
(1273, 105, 'Harrier'),
(1272, 105, 'Granvia'),
(1271, 105, 'Grand Hiace'),
(1270, 105, 'Gaia'),
(1269, 105, 'Funcargo'),
(1268, 105, 'Fortuner'),
(1267, 105, 'FJ Cruiser'),
(1266, 105, 'Estima'),
(1265, 105, 'Echo'),
(1264, 105, 'Duet'),
(1263, 105, 'Cynos'),
(1262, 105, 'Curren'),
(1261, 105, 'Crown Majesta'),
(1260, 105, 'Crown Athlete'),
(1259, 105, 'Crown'),
(1258, 105, 'Crown'),
(1257, 105, 'Cresta'),
(1256, 105, 'Cressida'),
(1255, 105, 'Corsa'),
(1254, 105, 'Corona'),
(1253, 105, 'Corolla Verso'),
(1252, 105, 'Corolla Spacio'),
(1251, 105, 'Corolla RunX'),
(1250, 105, 'Corolla Rumion'),
(1249, 105, 'Corolla Levin'),
(1248, 105, 'Corolla Fielder'),
(1247, 105, 'Corolla FX'),
(1246, 105, 'Corolla Ceres'),
(1245, 105, 'Corolla'),
(1244, 105, 'Corolla'),
(1243, 105, 'Chaser'),
(1242, 105, 'Celica'),
(1241, 105, 'Cavalier'),
(1240, 105, 'Carina ED'),
(1239, 105, 'Carina E'),
(1238, 105, 'Carina'),
(1237, 105, 'Carib'),
(1236, 105, 'Camry Solara'),
(1235, 105, 'Camry'),
(1234, 105, 'Cami'),
(1233, 105, 'Caldina'),
(1232, 105, 'Brevis'),
(1231, 105, 'BB'),
(1230, 105, 'Avensis Verso'),
(1229, 105, 'Avensis'),
(1228, 105, 'Avalon'),
(1227, 105, 'Auris'),
(1226, 105, 'Aurion'),
(1225, 105, 'Aristo'),
(1224, 105, 'Altezza'),
(1223, 105, 'Alphard'),
(1222, 105, 'Allion'),
(1221, 105, 'Allex'),
(1220, 105, '4runner'),
(1219, 104, 'Admiral'),
(1218, 103, 'Century'),
(1217, 102, 'T613'),
(1216, 101, 'XL7'),
(1215, 101, 'X-90'),
(1214, 101, 'Wagon R+'),
(1213, 101, 'Vitara'),
(1212, 101, 'Verona'),
(1211, 101, 'Swift'),
(1210, 101, 'Sidekick'),
(1209, 101, 'Samurai'),
(1208, 101, 'SX4'),
(1207, 101, 'MR Wagon'),
(1206, 101, 'Liana'),
(1205, 101, 'Kei'),
(1204, 101, 'Jimny'),
(1203, 101, 'Ignis'),
(1202, 101, 'Grand Vitara'),
(1201, 101, 'Forenza'),
(1200, 101, 'Every Landy'),
(1199, 101, 'Every'),
(1198, 101, 'Escudo'),
(1197, 101, 'Cultus Wagon'),
(1196, 101, 'Baleno'),
(1195, 101, 'Alto'),
(1194, 101, 'Aerio'),
(1193, 100, 'XT'),
(1192, 100, 'Vivio'),
(1191, 100, 'Tribeca'),
(1190, 100, 'Traviq'),
(1189, 100, 'Stella'),
(1188, 100, 'SVX'),
(1187, 100, 'R2'),
(1186, 100, 'Pleo'),
(1185, 100, 'Outback'),
(1184, 100, 'Libero'),
(1183, 100, 'Leone'),
(1182, 100, 'Legacy'),
(1181, 100, 'Justy'),
(1180, 100, 'Impreza WRX'),
(1179, 100, 'Impreza'),
(1178, 100, 'Forester'),
(1177, 100, 'Baja'),
(1176, 99, 'Tager'),
(1175, 99, 'Rodius'),
(1174, 99, 'Rexton'),
(1173, 99, 'Musso'),
(1172, 99, 'Kyron'),
(1171, 99, 'Korando'),
(1170, 99, 'Istana'),
(1169, 99, 'Family'),
(1168, 99, 'Chairman'),
(1167, 99, 'Actyon'),
(1166, 98, 'C8'),
(1165, 97, 'Roadster'),
(1164, 97, 'Fortwo'),
(1163, 97, 'Forfour'),
(1162, 97, 'Crossblade'),
(1161, 96, 'Superb'),
(1160, 96, 'Roomster'),
(1159, 96, 'Octavia Scout'),
(1158, 96, 'Octavia'),
(1157, 96, 'Felicia'),
(1156, 96, 'Favorit'),
(1155, 96, 'Fabia'),
(1154, 95, 'Sceo'),
(1153, 94, 'Toledo'),
(1152, 94, 'Ronda'),
(1151, 94, 'Malaga'),
(1150, 94, 'Leon'),
(1149, 94, 'Ibiza'),
(1148, 94, 'Cordoba'),
(1147, 94, 'Arosa'),
(1146, 94, 'Altea'),
(1145, 94, 'Alhambra'),
(1144, 93, 'xB'),
(1143, 93, 'xA'),
(1142, 93, 'tC'),
(1141, 92, 'VUE'),
(1140, 92, 'SL'),
(1139, 92, 'SC'),
(1138, 92, 'LS'),
(1137, 92, 'ION'),
(1136, 91, 'S7'),
(1135, 90, '9000'),
(1134, 90, '900'),
(1133, 90, '99'),
(1132, 90, '9-7X'),
(1131, 90, '9-5'),
(1130, 90, '9-3'),
(1129, 90, '9-2X'),
(1128, 89, 'Montego'),
(1127, 89, 'Mini MK'),
(1126, 89, 'Maestro'),
(1125, 89, '800'),
(1124, 89, '600'),
(1123, 89, '400'),
(1122, 89, '200'),
(1121, 89, '75'),
(1120, 89, '45'),
(1119, 89, '25'),
(1118, 88, 'Silver Spur'),
(1117, 88, 'Silver Seraph'),
(1116, 88, 'Phantom Drophead Coupe'),
(1115, 88, 'Phantom'),
(1114, 88, 'Corniche Cabrio'),
(1113, 87, 'Vel Satis'),
(1112, 87, 'Twingo'),
(1111, 87, 'Trafic'),
(1110, 87, 'Symbol'),
(1109, 87, 'Super 5'),
(1108, 87, 'Scenic RX'),
(1107, 87, 'Scenic'),
(1106, 87, 'Safrane'),
(1105, 87, 'Rapid'),
(1104, 87, 'Modus'),
(1103, 87, 'Megane'),
(1102, 87, 'Master'),
(1101, 87, 'Logan'),
(1100, 87, 'Laguna'),
(1099, 87, 'Kangoo Passenger'),
(1098, 87, 'Kangoo Express'),
(1097, 87, 'Grand Scenic'),
(1096, 87, 'Fuego'),
(1095, 87, 'Espace'),
(1094, 87, 'Clio Symbol'),
(1093, 87, 'Clio'),
(1092, 87, 'Avantime'),
(1091, 87, '25'),
(1090, 87, '21'),
(1089, 87, '20'),
(1088, 87, '19'),
(1087, 87, '18'),
(1086, 87, '11'),
(1085, 87, '9'),
(1084, 87, '5'),
(1083, 86, 'Pinzgauer'),
(1082, 86, 'G-modell'),
(1081, 85, 'Persona 400'),
(1080, 85, 'Persona 300 Compact'),
(1079, 84, 'Cayman'),
(1078, 84, 'Cayenne'),
(1077, 84, 'Carrera GT'),
(1076, 84, 'Boxster'),
(1075, 84, '968'),
(1074, 84, '944'),
(1073, 84, '928'),
(1072, 84, '924'),
(1071, 84, '911'),
(1070, 83, 'Vibe'),
(1069, 83, 'Trans Sport'),
(1068, 83, 'Sunfire'),
(1067, 83, 'Sunbird'),
(1066, 83, 'Solstige'),
(1065, 83, 'Phoenix'),
(1064, 83, 'Grand Prix'),
(1063, 83, 'Grand AM'),
(1062, 83, 'GTO'),
(1061, 83, 'Firebird'),
(1060, 83, 'Bonneville'),
(1059, 83, 'Aztec'),
(1058, 83, '6000'),
(1057, 82, 'Voyager'),
(1056, 82, 'Sundance'),
(1055, 82, 'Prowler'),
(1054, 82, 'Neon'),
(1053, 82, 'Laser'),
(1052, 82, 'Grand Voyager'),
(1051, 82, 'Breeze'),
(1050, 82, 'Acclaim'),
(1049, 81, '4007'),
(1048, 81, '1007'),
(1047, 81, '807'),
(1046, 81, '806'),
(1045, 81, '607'),
(1044, 81, '605'),
(1043, 81, '407'),
(1042, 81, '406'),
(1041, 81, '405'),
(1040, 81, '309'),
(1039, 81, '308'),
(1038, 81, '307'),
(1037, 81, '306'),
(1036, 81, '305'),
(1035, 81, '207'),
(1034, 81, '206'),
(1033, 81, '205'),
(1032, 81, '107'),
(1031, 81, '106'),
(1030, 80, 'Zonda C12'),
(1029, 79, 'Zafira'),
(1028, 79, 'Vita'),
(1027, 79, 'Vectra'),
(1026, 79, 'Tigra'),
(1025, 79, 'Speedster'),
(1024, 79, 'Sintra'),
(1023, 79, 'Signum'),
(1022, 79, 'Senator'),
(1021, 79, 'Rekord'),
(1020, 79, 'Omega'),
(1019, 79, 'Movano'),
(1018, 79, 'Monterey'),
(1017, 79, 'Meriva'),
(1016, 79, 'Manta'),
(1015, 79, 'Kadett'),
(1014, 79, 'GT'),
(1013, 79, 'Frontera'),
(1012, 79, 'Corsa OPC'),
(1011, 79, 'Corsa'),
(1010, 79, 'Commodore'),
(1009, 79, 'Combo'),
(1008, 79, 'Campo'),
(1007, 79, 'Calibra'),
(1006, 79, 'Astra OPC'),
(1005, 79, 'Astra'),
(1004, 79, 'Ascona'),
(1003, 79, 'Antara'),
(1002, 79, 'Agila'),
(1001, 78, 'Silhouette'),
(1000, 78, 'Cutlass'),
(999, 78, 'Bravada'),
(998, 78, 'Aurora'),
(997, 78, 'Alero'),
(996, 78, 'Achieva'),
(995, 77, 'X-Trail'),
(994, 77, 'X-Terra'),
(993, 77, 'Wingroad'),
(992, 77, 'Vanette'),
(991, 77, 'Urvan'),
(990, 77, 'Titan'),
(989, 77, 'Tino'),
(988, 77, 'Tiida'),
(987, 77, 'Terrano'),
(986, 77, 'Teana'),
(985, 77, 'Sunny'),
(984, 77, 'Stanza'),
(983, 77, 'Stagea'),
(982, 77, 'Skyline'),
(981, 77, 'Silvia'),
(980, 77, 'Serena'),
(979, 77, 'Sentra'),
(978, 77, 'Safari'),
(977, 77, 'Rogue'),
(976, 77, 'Rasheen'),
(975, 77, 'R Nessa'),
(974, 77, 'Quest'),
(973, 77, 'Qashqai'),
(972, 77, 'Pulsar'),
(971, 77, 'Primera'),
(970, 77, 'Presea'),
(969, 77, 'Presage'),
(968, 77, 'Prairie'),
(967, 77, 'Pick UP'),
(966, 77, 'Patrol'),
(965, 77, 'Pathfinder'),
(964, 77, 'Note'),
(963, 77, 'Navara'),
(962, 77, 'Murano'),
(961, 77, 'Moco'),
(960, 77, 'Mistral'),
(959, 77, 'Micra'),
(958, 77, 'Maxima'),
(957, 77, 'March'),
(956, 77, 'Lucino'),
(955, 77, 'Liberty'),
(954, 77, 'Leopard'),
(953, 77, 'Laurel'),
(952, 77, 'Largo'),
(951, 77, 'Lafesta'),
(950, 77, 'King Cab'),
(949, 77, 'Gloria'),
(948, 77, 'GT-R'),
(947, 77, 'Fuga'),
(946, 77, 'Frontier'),
(945, 77, 'Fairlady'),
(944, 77, 'Expert'),
(943, 77, 'Elgrand'),
(942, 77, 'Datsun'),
(941, 77, 'Cube'),
(940, 77, 'Cima'),
(939, 77, 'Cherry'),
(938, 77, 'Cefiro'),
(937, 77, 'Cedric'),
(936, 77, 'Bluebird'),
(935, 77, 'Bassara'),
(934, 77, 'Avenir'),
(933, 77, 'Armada'),
(932, 77, 'Altima'),
(931, 77, 'Almera Tino'),
(930, 77, 'Almera Classic'),
(929, 77, 'Almera'),
(928, 77, 'AD'),
(927, 77, '350Z'),
(926, 77, '300 ZX'),
(925, 77, '200 SX'),
(924, 77, '100 NX'),
(923, 76, 'Aero 8'),
(922, 75, 'Le-Seyde'),
(921, 75, 'Le-Sayde'),
(920, 75, 'Galue'),
(919, 74, 'i'),
(918, 74, 'Town BOX'),
(917, 74, 'Starion'),
(916, 74, 'Space Wagon'),
(915, 74, 'Space Star'),
(914, 74, 'Space Runner'),
(913, 74, 'Space Gear'),
(912, 74, 'Sigma'),
(911, 74, 'Sapporo'),
(910, 74, 'RVR'),
(909, 74, 'Pajero Sport'),
(908, 74, 'Pajero'),
(907, 74, 'Outlander'),
(906, 74, 'Montero Sport'),
(905, 74, 'Montero'),
(904, 74, 'Mirage'),
(903, 74, 'Minica'),
(902, 74, 'Libero'),
(901, 74, 'Legnum'),
(900, 74, 'Lancer Evolution'),
(899, 74, 'Lancer Cedia'),
(898, 74, 'Lancer'),
(897, 74, 'Lancer'),
(896, 74, 'L 200'),
(895, 74, 'Grandis'),
(894, 74, 'Galant'),
(893, 74, 'GTO'),
(892, 74, 'FTO'),
(891, 74, 'Endeavor'),
(890, 74, 'Emeraude'),
(889, 74, 'Eclipse'),
(888, 74, 'EK Wagon'),
(887, 74, 'Dion'),
(886, 74, 'Dingo'),
(885, 74, 'Diamante'),
(884, 74, 'Delica'),
(883, 74, 'Debonair'),
(882, 74, 'Colt'),
(881, 74, 'Chariot'),
(880, 74, 'Challenger'),
(879, 74, 'Carisma'),
(878, 74, 'Aspire'),
(877, 74, 'Airtrek'),
(876, 74, '3000 GT'),
(875, 73, 'One'),
(874, 73, 'Cooper'),
(873, 73, 'Clubman'),
(872, 72, 'MC1'),
(871, 71, 'ZT'),
(870, 71, 'ZR'),
(869, 71, 'TF'),
(868, 71, 'MGF'),
(867, 71, 'MGB'),
(866, 70, 'Taxi  (II -series)'),
(865, 69, 'Villager'),
(864, 69, 'Tracer'),
(863, 69, 'Topaz'),
(862, 69, 'Sable'),
(861, 69, 'Mystique'),
(860, 69, 'Mountaineer'),
(859, 69, 'Montego'),
(858, 69, 'Mariner'),
(857, 69, 'Grand Marquis'),
(856, 69, 'Cougar'),
(855, 69, 'Capri'),
(854, 68, 'Viano'),
(853, 68, 'Vaneo'),
(852, 68, 'V-klasse V 280'),
(851, 68, 'V-klasse V 230'),
(850, 68, 'V-klasse V 220'),
(849, 68, 'V-klasse V 200'),
(848, 68, 'SLR McLaren'),
(847, 68, 'SLK-klasse SLK 55 AMG'),
(846, 68, 'SLK-klasse SLK 350'),
(845, 68, 'SLK-klasse SLK 320'),
(844, 68, 'SLK-klasse SLK 32 AMG'),
(843, 68, 'SLK-klasse SLK 280'),
(842, 68, 'SLK-klasse SLK 230'),
(841, 68, 'SLK-klasse SLK 200'),
(840, 68, 'SL-klasse SL 65 AMG'),
(839, 68, 'SL-klasse SL 63 AMG'),
(838, 68, 'SL-klasse SL 600'),
(837, 68, 'SL-klasse SL 55 AMG'),
(836, 68, 'SL-klasse SL 500'),
(835, 68, 'SL-klasse SL 450'),
(834, 68, 'SL-klasse SL 420'),
(833, 68, 'SL-klasse SL 380'),
(832, 68, 'SL-klasse SL 350'),
(831, 68, 'SL-klasse SL 320'),
(830, 68, 'SL-klasse SL 300'),
(829, 68, 'SL-klasse SL 280'),
(828, 68, 'S-klasse S 65 AMG'),
(827, 68, 'S-klasse S 600'),
(826, 68, 'S-klasse S 560'),
(825, 68, 'S-klasse S 550'),
(824, 68, 'S-klasse S 55 AMG'),
(823, 68, 'S-klasse S 500'),
(822, 68, 'S-klasse S 450'),
(821, 68, 'S-klasse S 430'),
(820, 68, 'S-klasse S 420'),
(819, 68, 'S-klasse S 400'),
(818, 68, 'S-klasse S 380'),
(817, 68, 'S-klasse S 350'),
(816, 68, 'S-klasse S 320'),
(815, 68, 'S-klasse S 300'),
(814, 68, 'S-klasse S 280'),
(813, 68, 'S-klasse S 260'),
(812, 68, 'R-klasse R 500'),
(811, 68, 'R-klasse R 350'),
(810, 68, 'R-klasse R 320'),
(809, 68, 'R-klasse'),
(808, 68, 'Pullmann'),
(807, 68, 'M-klasse ML 63 AMG'),
(806, 68, 'M-klasse ML 55 AMG'),
(805, 68, 'M-klasse ML 500'),
(804, 68, 'M-klasse ML 430'),
(803, 68, 'M-klasse ML 400'),
(802, 68, 'M-klasse ML 350'),
(801, 68, 'M-klasse ML 320'),
(800, 68, 'M-klasse ML 280'),
(799, 68, 'M-klasse ML 270'),
(798, 68, 'M-klasse ML 230'),
(797, 68, 'GL-klasse GL 550'),
(796, 68, 'GL-klasse GL 500'),
(795, 68, 'GL-klasse GL 450'),
(794, 68, 'GL-klasse GL 420'),
(793, 68, 'GL-klasse GL 320'),
(792, 68, 'G-Klasse G 55 AMG'),
(791, 68, 'G-Klasse G 500'),
(790, 68, 'G-Klasse G 400'),
(789, 68, 'G-Klasse G 350'),
(788, 68, 'G-Klasse G 320'),
(787, 68, 'G-Klasse G 300'),
(786, 68, 'G-Klasse G 290'),
(785, 68, 'G-Klasse G 280'),
(784, 68, 'G-Klasse G 270'),
(783, 68, 'G-Klasse G 250'),
(782, 68, 'G-Klasse G 230'),
(781, 68, 'E-klasse E 63 AMG'),
(780, 68, 'E-klasse E 55 AMG'),
(779, 68, 'E-klasse E 500'),
(778, 68, 'E-klasse E 50 AMG'),
(777, 68, 'E-klasse E 430'),
(776, 68, 'E-klasse E 420'),
(775, 68, 'E-klasse E 400'),
(774, 68, 'E-klasse E 350'),
(773, 68, 'E-klasse E 320'),
(772, 68, 'E-klasse E 300'),
(771, 68, 'E-klasse E 290'),
(770, 68, 'E-klasse E 280'),
(769, 68, 'E-klasse E 270'),
(768, 68, 'E-klasse E 250'),
(767, 68, 'E-klasse E 240'),
(766, 68, 'E-klasse E 230'),
(765, 68, 'E-klasse E 220'),
(764, 68, 'E-klasse E 200'),
(763, 68, 'CLS-klasse CLS 63 AMG'),
(762, 68, 'CLS-klasse CLS 55 AMG'),
(761, 68, 'CLS-klasse CLS 500'),
(760, 68, 'CLS-klasse CLS 350'),
(759, 68, 'CLS-klasse CLS 320'),
(758, 68, 'CLK-klasse CLK 63 AMG'),
(757, 68, 'CLK-klasse CLK 55 AMG'),
(756, 68, 'CLK-klasse CLK 500'),
(755, 68, 'CLK-klasse CLK 430'),
(754, 68, 'CLK-klasse CLK 350'),
(753, 68, 'CLK-klasse CLK 320'),
(752, 68, 'CLK-klasse CLK 270'),
(751, 68, 'CLK-klasse CLK 240'),
(750, 68, 'CLK-klasse CLK 230'),
(749, 68, 'CLK-klasse CLK 220'),
(748, 68, 'CLK-klasse CLK 200'),
(747, 68, 'CLC-klasse CLC 220 CDI'),
(746, 68, 'CL-Klasse CL 65 AMG'),
(745, 68, 'CL-Klasse CL 63 AMG'),
(744, 68, 'CL-Klasse CL 600'),
(743, 68, 'CL-Klasse CL 55 AMG'),
(742, 68, 'CL-Klasse CL 500'),
(741, 68, 'CL-Klasse CL 420'),
(740, 68, 'C-klasse C 63 AMG'),
(739, 68, 'C-klasse C 55 AMG'),
(738, 68, 'C-klasse C 36 AMG'),
(737, 68, 'C-klasse C 350'),
(736, 68, 'C-klasse C 320'),
(735, 68, 'C-klasse C 32 AMG'),
(734, 68, 'C-klasse C 280'),
(733, 68, 'C-klasse C 270'),
(732, 68, 'C-klasse C 250'),
(731, 68, 'C-klasse C 240'),
(730, 68, 'C-klasse C 230'),
(729, 68, 'C-klasse C 220'),
(728, 68, 'C-klasse C 200'),
(727, 68, 'C-klasse C 180'),
(726, 68, 'B-klasse B 200'),
(725, 68, 'B-klasse B 180'),
(724, 68, 'B-klasse B 170'),
(723, 68, 'A-klasse A 210'),
(722, 68, 'A-klasse A 200'),
(721, 68, 'A-klasse A 190'),
(720, 68, 'A-klasse A 180'),
(719, 68, 'A-klasse A 170'),
(718, 68, 'A-klasse A 160'),
(717, 68, 'A-klasse A 150'),
(716, 68, 'A-klasse A 140'),
(715, 68, '500'),
(714, 68, '300'),
(713, 68, '280'),
(712, 68, '260'),
(711, 68, '250'),
(710, 68, '240'),
(709, 68, '230'),
(708, 68, '220'),
(707, 68, '200'),
(706, 68, '190'),
(705, 68, '/8'),
(704, 68, ' T-mod.'),
(703, 68, ' Coupe'),
(702, 68, ' Cabrio'),
(701, 67, 'Xedos 9'),
(700, 67, 'Xedos 6'),
(699, 67, 'Verisa'),
(698, 67, 'Tribute'),
(697, 67, 'Rx-8'),
(696, 67, 'Roadster'),
(695, 67, 'RX 7'),
(694, 67, 'Protege'),
(693, 67, 'Premacy'),
(692, 67, 'Mx-6'),
(691, 67, 'Mx-5'),
(690, 67, 'Mx-3'),
(689, 67, 'Millenia'),
(688, 67, 'Mazda 6 MPS'),
(687, 67, 'Mazda 6'),
(686, 67, 'Mazda 5'),
(685, 67, 'Mazda 3 MPS'),
(684, 67, 'Mazda 3'),
(683, 67, 'Mazda 2'),
(682, 67, 'MPV'),
(681, 67, 'Luce'),
(680, 67, 'Levante'),
(679, 67, 'Lantis'),
(678, 67, 'Familia'),
(677, 67, 'Eunos Cosmo'),
(676, 67, 'Eunos 500'),
(675, 67, 'E 2000,2200 Bus'),
(674, 67, 'Demio'),
(673, 67, 'Carol'),
(672, 67, 'Capella'),
(671, 67, 'CX-9'),
(670, 67, 'CX-7'),
(669, 67, 'Bongo'),
(668, 67, 'BT-50'),
(667, 67, 'B-serie'),
(666, 67, 'Az-wagon'),
(665, 67, 'Axela'),
(664, 67, 'Atenza'),
(663, 67, '929'),
(662, 67, '626'),
(661, 67, '323'),
(660, 67, '121'),
(659, 66, 'Maybach 57 и Maybach 62'),
(658, 66, 'Maybach 57 S и Maybach 62 S'),
(657, 65, 'Spyder'),
(656, 65, 'Quattroporte'),
(655, 65, 'GranTurismo'),
(654, 65, 'GranSport'),
(653, 65, 'Coupe'),
(652, 65, 'Biturbo'),
(651, 65, '4300 GT Coupe'),
(650, 65, '3200 GT'),
(649, 65, '228'),
(648, 64, 'Alto'),
(647, 63, 'Marshal'),
(646, 62, 'Super 7'),
(645, 62, 'Exige'),
(644, 62, 'Elise'),
(643, 61, 'Zephyr'),
(642, 61, 'Town Car'),
(641, 61, 'Navigator'),
(640, 61, 'Mark LT'),
(639, 61, 'Mark'),
(638, 61, 'MKZ'),
(637, 61, 'MKX'),
(636, 61, 'LS'),
(635, 61, 'Continental'),
(634, 61, 'Aviator'),
(633, 60, 'Breez (520)'),
(632, 59, 'SC 430'),
(631, 59, 'SC 400'),
(630, 59, 'SC 300'),
(629, 59, 'RX 400h'),
(628, 59, 'RX 350'),
(627, 59, 'RX 330'),
(626, 59, 'RX 300'),
(625, 59, 'LX 570'),
(624, 59, 'LX 470'),
(623, 59, 'LX 450'),
(622, 59, 'LS 600'),
(621, 59, 'LS 460'),
(620, 59, 'LS 430'),
(619, 59, 'LS 400'),
(618, 59, 'IS-F'),
(617, 59, 'IS 350'),
(616, 59, 'IS 300'),
(615, 59, 'IS 250'),
(614, 59, 'IS 200'),
(613, 59, 'GX'),
(612, 59, 'GS 460'),
(611, 59, 'GS 450h'),
(610, 59, 'GS 430'),
(609, 59, 'GS 400'),
(608, 59, 'GS 350'),
(607, 59, 'GS 300'),
(606, 59, 'ES 350'),
(605, 59, 'ES 330'),
(604, 59, 'ES 300'),
(603, 58, 'SUV'),
(602, 58, 'Double Gate'),
(601, 57, 'Range Rover Sport'),
(600, 57, 'Range Rover'),
(599, 57, 'Land Rover'),
(598, 57, 'Freelander'),
(597, 57, 'Discovery'),
(596, 57, 'Defender'),
(595, 57, '90/110'),
(594, 56, 'Y'),
(593, 56, 'Thesis'),
(592, 56, 'Thema'),
(591, 56, 'Phedra'),
(590, 56, 'Lybra'),
(589, 56, 'Kappa'),
(588, 56, 'Delta'),
(587, 56, 'Dedra'),
(586, 56, 'Beta'),
(585, 55, 'Murcielago'),
(584, 55, 'Gallardo'),
(583, 55, 'Espada'),
(582, 55, 'Diablo'),
(581, 54, 'CC'),
(580, 53, 'Visto'),
(579, 53, 'Sportage'),
(578, 53, 'Spectra'),
(577, 53, 'Sorento'),
(576, 53, 'Shuma'),
(575, 53, 'Sephia'),
(574, 53, 'Sedona'),
(573, 53, 'Rio'),
(572, 53, 'Retona'),
(571, 53, 'Pride'),
(570, 53, 'Pregio'),
(569, 53, 'Potentia'),
(568, 53, 'Picanto'),
(567, 53, 'Optima'),
(566, 53, 'Opirus'),
(565, 53, 'Magentis'),
(564, 53, 'Joice'),
(563, 53, 'Clarus'),
(562, 53, 'Cerato'),
(561, 53, 'Cee\'d'),
(560, 53, 'Carnival'),
(559, 53, 'Carens'),
(558, 53, 'Capital'),
(557, 53, 'Borrego'),
(556, 53, 'Besta'),
(555, 53, 'Avella'),
(554, 52, 'Wrangler'),
(553, 52, 'Patriot'),
(552, 52, 'Liberty'),
(551, 52, 'Grand Cherokee'),
(550, 52, 'Compass'),
(549, 52, 'Commander'),
(548, 52, 'Cherokee'),
(547, 52, 'CJ5 - CJ8'),
(546, 51, 'XKR'),
(545, 51, 'XK 8'),
(544, 51, 'XJSc Convertible'),
(543, 51, 'XJS Coupe'),
(542, 51, 'XJR'),
(541, 51, 'XJ'),
(540, 51, 'XF'),
(539, 51, 'X-type'),
(538, 51, 'S-type'),
(537, 51, 'E-type'),
(536, 50, 'Rein'),
(535, 50, 'Refine'),
(534, 49, 'Wizard'),
(533, 49, 'VehiCross'),
(532, 49, 'Trooper'),
(531, 49, 'Rodeo'),
(530, 49, 'Impulse'),
(529, 49, 'Gemini'),
(528, 49, 'Bighorn'),
(527, 49, 'Axiom'),
(526, 49, 'Aska'),
(525, 49, 'Ascender'),
(524, 48, 'Samand'),
(523, 47, 'QX56'),
(522, 47, 'QX4'),
(521, 47, 'Q45'),
(520, 47, 'M45'),
(519, 47, 'M35'),
(518, 47, 'J30'),
(517, 47, 'I35'),
(516, 47, 'I30'),
(515, 47, 'G37'),
(514, 47, 'G35'),
(513, 47, 'FX 50'),
(512, 47, 'FX 45'),
(511, 47, 'FX 35'),
(510, 47, 'EX'),
(509, 46, 'XG'),
(508, 46, 'Verna'),
(507, 46, 'Veracruz'),
(506, 46, 'Tuscani'),
(505, 46, 'Tucson'),
(504, 46, 'Trajet'),
(503, 46, 'Tiburon'),
(502, 46, 'Terracan'),
(501, 46, 'Sonata'),
(500, 46, 'Santamo'),
(499, 46, 'Santa FE'),
(498, 46, 'S-Coupe'),
(497, 46, 'Pony'),
(496, 46, 'NF'),
(495, 46, 'Matrix'),
(494, 46, 'Marcia'),
(493, 46, 'Lavita'),
(492, 46, 'H100'),
(491, 46, 'H-1 Starex'),
(490, 46, 'Grandeur'),
(489, 46, 'Getz'),
(488, 46, 'Galloper'),
(487, 46, 'Elantra'),
(486, 46, 'Coupe'),
(485, 46, 'Atos'),
(484, 46, 'Accent'),
(483, 45, 'Hummer H3'),
(482, 45, 'Hummer H2'),
(481, 45, 'Hummer H1'),
(480, 45, 'Hummer'),
(479, 44, 'Antelope'),
(478, 43, 'Z'),
(477, 43, 'Vigor'),
(476, 43, 'Vamos'),
(475, 43, 'Torneo'),
(474, 43, 'Stream'),
(473, 43, 'Stepwgn'),
(472, 43, 'Sm-x'),
(471, 43, 'Shuttle'),
(470, 43, 'Saber'),
(469, 43, 'S2000'),
(468, 43, 'Ridgeline'),
(467, 43, 'Rafaga'),
(466, 43, 'Prelude'),
(465, 43, 'Pilot'),
(464, 43, 'Passport'),
(463, 43, 'Partner'),
(462, 43, 'Orthia'),
(461, 43, 'Odyssey'),
(460, 43, 'NSX'),
(459, 43, 'Mobilio'),
(458, 43, 'Logo'),
(457, 43, 'Life'),
(456, 43, 'Legend'),
(455, 43, 'Jazz'),
(454, 43, 'Integra'),
(453, 43, 'Inspire'),
(452, 43, 'Insight'),
(451, 43, 'Hr-v'),
(450, 43, 'Fit Aria'),
(449, 43, 'FR-V'),
(448, 43, 'FIT'),
(447, 43, 'Element'),
(446, 43, 'Edix'),
(445, 43, 'Domani'),
(444, 43, 'Concerto'),
(443, 43, 'Civic Shuttle'),
(442, 43, 'Civic'),
(441, 43, 'City'),
(440, 43, 'Capa'),
(439, 43, 'CRX'),
(438, 43, 'CR-V'),
(437, 43, 'Avancier'),
(436, 43, 'Airwave'),
(435, 43, 'Accord'),
(434, 42, 'Simbo'),
(433, 42, 'Princip'),
(432, 42, 'Brio'),
(431, 41, 'Wingle'),
(430, 41, 'Socool'),
(429, 41, 'Sailor'),
(428, 41, 'Safe'),
(427, 41, 'SUV'),
(426, 41, 'Hover'),
(425, 41, 'Deer'),
(424, 40, 'suburban'),
(423, 40, 'Yukon'),
(422, 40, 'Sonoma'),
(421, 40, 'Sierra'),
(420, 40, 'Savana'),
(419, 40, 'Safari'),
(418, 40, 'Jimmy'),
(417, 40, 'Envoy'),
(416, 40, 'Acadia'),
(415, 39, 'Tracker'),
(414, 39, 'Storm'),
(413, 39, 'Prizm'),
(412, 39, 'Metro'),
(411, 38, 'Otaka'),
(410, 38, 'MK'),
(409, 37, 'Windstar'),
(408, 37, 'Tourneo Connect'),
(407, 37, 'Thunderbird'),
(406, 37, 'Tempo'),
(405, 37, 'Taurus'),
(404, 37, 'Taunus'),
(403, 37, 'Sierra'),
(402, 37, 'Shelby'),
(401, 37, 'Scorpio'),
(400, 37, 'S-MAX'),
(399, 37, 'Ranger'),
(398, 37, 'Puma'),
(397, 37, 'Probe'),
(396, 37, 'Orion'),
(395, 37, 'Mustang'),
(394, 37, 'Mondeo'),
(393, 37, 'Maverick'),
(392, 37, 'Kuga'),
(391, 37, 'KA'),
(390, 37, 'Granada (USA)'),
(389, 37, 'Granada'),
(388, 37, 'Galaxy'),
(387, 37, 'GT'),
(386, 37, 'Fusion (USA)'),
(385, 37, 'Fusion'),
(384, 37, 'Freestyle'),
(383, 37, 'Focus ST'),
(382, 37, 'Focus'),
(381, 37, 'Five Hundred'),
(380, 37, 'Fiesta ST'),
(379, 37, 'Fiesta'),
(378, 37, 'F-150'),
(377, 37, 'Explorer'),
(376, 37, 'Expedition'),
(375, 37, 'Excursion'),
(374, 37, 'Escort'),
(373, 37, 'Escape'),
(372, 37, 'Edge'),
(371, 37, 'Econoline'),
(370, 37, 'Crown Victoria'),
(369, 37, 'Cougar'),
(368, 37, 'Contour'),
(367, 37, 'Capri'),
(366, 37, 'C-MAX'),
(365, 37, 'Bronco'),
(364, 37, 'Aerostar'),
(363, 36, 'X 1/9'),
(362, 36, 'Ulysse'),
(361, 36, 'UNO'),
(360, 36, 'Tipo'),
(359, 36, 'Tempra'),
(358, 36, 'Stilo'),
(357, 36, 'Seicento'),
(356, 36, 'Sedici'),
(355, 36, 'Ritmo'),
(354, 36, 'Regata'),
(353, 36, 'Punto'),
(352, 36, 'Panda'),
(351, 36, 'Palio'),
(350, 36, 'New 500'),
(349, 36, 'Multipla'),
(348, 36, 'Marea'),
(347, 36, 'Fiorino'),
(346, 36, 'Doblo'),
(345, 36, 'Croma'),
(344, 36, 'Coupe'),
(343, 36, 'Cinquecento'),
(342, 36, 'Bravo'),
(341, 36, 'Brava'),
(340, 36, 'Barchetta'),
(339, 36, 'Albea'),
(338, 36, '131'),
(337, 35, 'Testarossa'),
(336, 35, 'Mondial'),
(335, 35, 'Maranello'),
(334, 35, 'F355'),
(333, 35, 'Enzo'),
(332, 35, 'California'),
(331, 35, '612 Scaglietti'),
(330, 35, '599'),
(329, 35, '430'),
(328, 35, '360'),
(327, 34, 'Vita'),
(326, 34, 'Jinn'),
(325, 34, 'Admiral'),
(324, 33, 'Vision'),
(323, 33, 'Talon'),
(322, 32, 'D8'),
(321, 31, 'Orion'),
(320, 31, 'Kondor'),
(319, 31, 'Assol'),
(318, 30, 'MPV'),
(317, 29, 'Viper'),
(316, 29, 'Stratus'),
(315, 29, 'Stealth'),
(314, 29, 'Spirit'),
(313, 29, 'Shadow'),
(312, 29, 'Ramcharger'),
(311, 29, 'RAM'),
(310, 29, 'Nitro'),
(309, 29, 'Neon'),
(308, 29, 'Magnum'),
(307, 29, 'Intrepid'),
(306, 29, 'Grand Caravan'),
(305, 29, 'Durango'),
(304, 29, 'Dakota'),
(303, 29, 'Charger'),
(302, 29, 'Challenger'),
(301, 29, 'Caravan'),
(300, 29, 'Caliber'),
(299, 29, 'Avenger'),
(298, 28, 'Shuttle'),
(297, 28, 'Plutus'),
(296, 28, 'Cowboy'),
(295, 28, 'Aurora'),
(294, 27, 'Limousine'),
(293, 27, '2.8 - 5.3'),
(292, 26, 'YRV'),
(291, 26, 'Terios'),
(290, 26, 'Storia'),
(289, 26, 'Sirion'),
(288, 26, 'Rocky'),
(287, 26, 'Pyzar'),
(286, 26, 'Move'),
(285, 26, 'Mira'),
(284, 26, 'Materia'),
(283, 26, 'Feroza'),
(282, 26, 'Esse'),
(281, 26, 'Cuore'),
(280, 26, 'Copen'),
(279, 26, 'Charade'),
(278, 26, 'Boon'),
(277, 26, 'Be-go'),
(276, 26, 'Atrai/extol'),
(275, 26, 'Applause'),
(274, 26, 'Altis'),
(273, 25, 'Tico'),
(272, 25, 'Tacuma'),
(271, 25, 'Rezzo'),
(270, 25, 'Racer'),
(269, 25, 'Prince'),
(268, 25, 'Nubira'),
(267, 25, 'Nexia'),
(266, 25, 'Matiz'),
(265, 25, 'Magnus'),
(264, 25, 'Leganza'),
(263, 25, 'Lanos'),
(262, 25, 'Lacetti'),
(261, 25, 'LE Mans'),
(260, 25, 'Kalos'),
(259, 25, 'Evanda'),
(258, 25, 'Espero'),
(257, 25, 'Damas'),
(256, 24, 'Shuttle'),
(255, 24, 'City Leading'),
(254, 23, '1410'),
(253, 22, 'T-Rex'),
(252, 21, 'ZX'),
(251, 21, 'Xsara Picasso'),
(250, 21, 'Xsara'),
(249, 21, 'Xantia'),
(248, 21, 'XM'),
(247, 21, 'Visa'),
(246, 21, 'Saxo'),
(245, 21, 'LNA'),
(244, 21, 'Jumpy'),
(243, 21, 'Jumper'),
(242, 21, 'Evasion'),
(241, 21, 'C8'),
(240, 21, 'C6'),
(239, 21, 'C5'),
(238, 21, 'C4 Picasso'),
(237, 21, 'C4'),
(236, 21, 'C3'),
(235, 21, 'C25'),
(234, 21, 'C2'),
(233, 21, 'Berlingo'),
(232, 21, 'BX'),
(231, 21, 'AX'),
(230, 20, 'Voyager'),
(229, 20, 'Vision'),
(228, 20, 'Tracker'),
(227, 20, 'Town & Country'),
(226, 20, 'Stratus'),
(225, 20, 'Sebring'),
(224, 20, 'Saratoga'),
(223, 20, 'Prowler'),
(222, 20, 'Pacifica'),
(221, 20, 'PT Cruiser'),
(220, 20, 'Neon'),
(219, 20, 'NEW Yorker'),
(218, 20, 'LHS'),
(217, 20, 'LE Baron'),
(216, 20, 'Intrepid'),
(215, 20, 'Grand Voyager'),
(214, 20, 'Fifth Avenue'),
(213, 20, 'Crossfire'),
(212, 20, 'Concorde'),
(211, 20, 'Cirrus'),
(210, 20, 'Aspen'),
(209, 20, '300M'),
(208, 20, '300C'),
(207, 19, 'Viva'),
(206, 19, 'Venture'),
(205, 19, 'Van'),
(204, 19, 'Uplander'),
(203, 19, 'Trailblazer'),
(202, 19, 'Tracker'),
(201, 19, 'Tahoe'),
(200, 19, 'Suburban'),
(199, 19, 'Starcraft'),
(198, 19, 'Spark'),
(197, 19, 'Silverado'),
(196, 19, 'Savana'),
(195, 19, 'SSR'),
(194, 19, 'Rezzo'),
(193, 19, 'Prizm'),
(192, 19, 'Niva'),
(191, 19, 'Metro'),
(190, 19, 'Lumina'),
(189, 19, 'Lanos'),
(188, 19, 'Lacetti'),
(187, 19, 'Impala'),
(186, 19, 'HHR'),
(185, 19, 'Geo Storm'),
(184, 19, 'Express'),
(183, 19, 'Evanda'),
(182, 19, 'Equinox'),
(181, 19, 'Epica'),
(180, 19, 'Corvette'),
(179, 19, 'Corsica'),
(178, 19, 'Colorado'),
(177, 19, 'Cobalt'),
(176, 19, 'Cavalier'),
(175, 19, 'Captiva'),
(174, 19, 'Caprice'),
(173, 19, 'Camaro'),
(172, 19, 'C-10'),
(171, 19, 'Blazer'),
(170, 19, 'Beretta'),
(169, 19, 'Aveo'),
(168, 19, 'Avalanche'),
(167, 19, 'Astro'),
(166, 19, 'Alero'),
(165, 18, 'Tiggo'),
(164, 18, 'Sweet (QQ)'),
(163, 18, 'QQ6 (S21)'),
(162, 18, 'Oriental Son'),
(161, 18, 'Kimo (A1)'),
(160, 18, 'Fora'),
(159, 18, 'Flagcloud'),
(158, 18, 'Amulet'),
(157, 17, 'SUV'),
(156, 17, 'Flying'),
(155, 16, 'Super Seven'),
(154, 15, 'XLR'),
(153, 15, 'Seville'),
(152, 15, 'STS'),
(151, 15, 'SRX'),
(150, 15, 'Fleetwood'),
(149, 15, 'Escalade'),
(148, 15, 'Eldorado'),
(147, 15, 'DE Ville'),
(146, 15, 'Catera'),
(145, 15, 'CTS'),
(144, 15, 'BLS'),
(143, 14, 'FLYER II'),
(142, 14, 'F3'),
(141, 13, 'Skylark'),
(140, 13, 'Roadmaster'),
(139, 13, 'Riviera'),
(138, 13, 'Rendezvous'),
(137, 13, 'Reatta'),
(136, 13, 'Park Avenue'),
(135, 13, 'LE Sabre'),
(134, 13, 'Enclave'),
(133, 13, 'Century'),
(132, 12, 'EB 16.4'),
(131, 12, '57 SC Atlantic'),
(130, 11, 'M2'),
(129, 11, 'M1'),
(128, 10, 'Z8'),
(127, 10, 'Z4 M'),
(126, 10, 'Z4'),
(125, 10, 'Z3 M'),
(124, 10, 'Z3'),
(123, 10, 'Z1'),
(122, 10, 'X6'),
(121, 10, 'X5'),
(120, 10, 'X3'),
(119, 10, 'M6'),
(118, 10, 'M5'),
(117, 10, 'M3'),
(116, 10, '8er 850'),
(115, 10, '7er 760'),
(114, 10, '7er 750'),
(113, 10, '7er 745'),
(112, 10, '7er 740'),
(111, 10, '7er 735'),
(110, 10, '7er 732'),
(109, 10, '7er 730'),
(108, 10, '7er 728'),
(107, 10, '7er 725'),
(106, 10, '6er 650'),
(105, 10, '6er 645'),
(104, 10, '6er 635'),
(103, 10, '6er 630'),
(102, 10, '6er 628'),
(101, 10, '5er 550'),
(100, 10, '5er 545'),
(99, 10, '5er 540'),
(98, 10, '5er 535'),
(97, 10, '5er 530'),
(96, 10, '5er 528'),
(95, 10, '5er 525'),
(94, 10, '5er 524'),
(93, 10, '5er 523'),
(92, 10, '5er 520'),
(91, 10, '5er 518'),
(90, 10, '3er 335'),
(89, 10, '3er 330'),
(88, 10, '3er 328'),
(87, 10, '3er 325'),
(86, 10, '3er 324'),
(85, 10, '3er 323'),
(84, 10, '3er 320'),
(83, 10, '3er 318'),
(82, 10, '3er 316'),
(81, 10, '3er 315'),
(80, 10, '1er 130'),
(79, 10, '1er 120'),
(78, 10, '1er 118'),
(77, 10, '1er 116'),
(76, 10, '02 (E10)'),
(75, 9, 'Turbo R'),
(74, 9, 'Mulsanne'),
(73, 9, 'Continental'),
(72, 9, 'Brooklands'),
(71, 9, 'Azure'),
(70, 9, 'Arnage'),
(69, 8, 'Montego'),
(68, 8, 'Mini MK'),
(67, 8, 'Metro'),
(66, 7, 'V8 (D11)'),
(65, 7, 'TT'),
(64, 7, 'S8'),
(63, 7, 'S6'),
(62, 7, 'S5'),
(61, 7, 'S4'),
(60, 7, 'S3'),
(59, 7, 'S2'),
(58, 7, 'RS6'),
(57, 7, 'RS4'),
(56, 7, 'R8'),
(55, 7, 'Quattro'),
(54, 7, 'Q7'),
(53, 7, 'Coupe'),
(52, 7, 'Cabriolet'),
(51, 7, 'Allroad'),
(50, 7, 'A8'),
(49, 7, 'A6'),
(48, 7, 'A5'),
(47, 7, 'A4'),
(46, 7, 'A3'),
(45, 7, 'A2'),
(44, 7, '200'),
(43, 7, '100'),
(42, 7, '90'),
(41, 7, '80'),
(40, 6, 'V8'),
(39, 6, 'V12 Vanquish'),
(38, 6, 'DBS'),
(37, 6, 'DB9'),
(36, 6, 'DB7'),
(35, 5, 'Rocsta'),
(34, 4, '24'),
(33, 4, '10'),
(32, 3, 'Roadster S'),
(31, 3, 'B7'),
(30, 3, 'B6'),
(29, 3, 'B3'),
(28, 3, 'B12'),
(27, 3, 'B11'),
(26, 2, 'Spider'),
(25, 2, 'Giulietta'),
(24, 2, 'GTV'),
(23, 2, 'GT'),
(22, 2, 'Brera'),
(21, 2, 'Alfetta'),
(20, 2, '166'),
(19, 2, '164'),
(18, 2, '159'),
(17, 2, '156'),
(16, 2, '155'),
(15, 2, '147'),
(14, 2, '146'),
(13, 2, '145'),
(12, 2, '75'),
(11, 2, '33'),
(10, 1, 'TSX'),
(9, 1, 'TL'),
(8, 1, 'RSX'),
(7, 1, 'RL'),
(6, 1, 'RDX'),
(5, 1, 'NSX'),
(4, 1, 'MDX'),
(3, 1, 'Integra'),
(2, 1, 'EL'),
(1, 1, 'CL');

1410

PHP: Get the user's age

23.06.2013 13:49 RedOctober PHP 0 Comments

Get the user's age by date of birth ... Reveal Code

function getAge($birth_date) {
    return floor((time() - strtotime($birth_date)) / 31556926);
}

938

PHP: Remove an empty array elements

23.06.2013 01:00 RedOctober PHP 0 Comments

Remove an empty array elements ... Reveal Code

$myArray = array_diff($myArray, array(''));

1071

MySQL: Removing of duplicates

20.06.2013 16:28 RedOctober MySQL 0 Comments

Removing of duplicates in a table ... Reveal Code

DELETE t1 FROM `my_table` t1, `my_table` t2 
WHERE t1.`my_field` = t2.`my_field` AND t1.`id` > t2.`id`

1060

MySQL: World countries database

20.06.2013 11:02 RedOctober MySQL 0 Comments

World countries and their ISO 3166-1 codes ... Reveal Code

DROP TABLE IF EXISTS `list_countries`;
CREATE TABLE `list_countries` (
  `id` int(11) NOT NULL auto_increment,
  `country_short_name` varchar(2) NOT NULL,
  `country_name` varchar(24) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Afghanistan', 'AF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Aland Islands', 'AX');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Albania', 'AL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Algeria', 'DZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('American Samoa', 'AS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Andorra', 'AD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Angola', 'AO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Anguilla', 'AI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Antarctica', 'AQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Antigua and Barbuda', 'AG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Argentina', 'AR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Armenia', 'AM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Aruba', 'AW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Australia', 'AU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Austria', 'AT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Azerbaijan', 'AZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bahamas', 'BS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bahrain', 'BH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bangladesh', 'BD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Barbados', 'BB');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Belarus', 'BY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Belgium', 'BE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Belize', 'BZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Benin', 'BJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bermuda', 'BM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bhutan', 'BT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bolivia', 'BO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bonaire Sint Eustatius and Saba', 'BQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bosnia and Herzegovina', 'BA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Botswana', 'BW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bouvet Island', 'BV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Brazil', 'BR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('British Indian Ocean Territory', 'IO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Brunei Darussalam', 'BN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Bulgaria', 'BG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Burkina Faso', 'BF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Burundi', 'BI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cambodia', 'KH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cameroon', 'CM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Canada', 'CA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cape Verde', 'CV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cayman Islands', 'KY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Central African Republic', 'CF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Chad', 'TD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Chile', 'CL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('China', 'CN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Christmas Island', 'CX');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cocos Islands', 'CC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Colombia', 'CO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Comoros', 'KM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Congo', 'CG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Congo', 'CD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cook Islands', 'CK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Costa Rica', 'CR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cote d\'Ivoire', 'CI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Croatia', 'HR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cuba', 'CU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Curacao', 'CW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Cyprus', 'CY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Czech Republic', 'CZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Denmark', 'DK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Djibouti', 'DJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Dominica', 'DM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Dominican Republic', 'DO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ecuador', 'EC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Egypt', 'EG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('El Salvador', 'SV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Equatorial Guinea', 'GQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Eritrea', 'ER');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Estonia', 'EE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ethiopia', 'ET');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Falkland Islands', 'FK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Faroe Islands', 'FO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Fiji', 'FJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Finland', 'FI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('France', 'FR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('French Guiana', 'GF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('French Polynesia', 'PF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('French Southern Territories', 'TF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Gabon', 'GA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Gambia', 'GM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Georgia', 'GE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Germany', 'DE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ghana', 'GH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Gibraltar', 'GI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Greece', 'GR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Greenland', 'GL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Grenada', 'GD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guadeloupe', 'GP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guam', 'GU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guatemala', 'GT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guernsey', 'GG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guinea', 'GN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guinea-Bissau', 'GW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Guyana', 'GY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Haiti', 'HT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Heard Island and McDonald Islands', 'HM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Vatican City', 'VA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Honduras', 'HN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Hong Kong', 'HK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Hungary', 'HU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Iceland', 'IS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('India', 'IN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Indonesia', 'ID');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Iran', 'IR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Iraq', 'IQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ireland', 'IE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Isle of Man', 'IM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Israel', 'IL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Italy', 'IT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Jamaica', 'JM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Japan', 'JP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Jersey', 'JE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Jordan', 'JO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kazakhstan', 'KZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kenya', 'KE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kiribati', 'KI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Korea', 'KP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('South Korea', 'KR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kuwait', 'KW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Kyrgyzstan', 'KG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Lao', 'LA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Latvia', 'LV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Lebanon', 'LB');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Lesotho', 'LS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Liberia', 'LR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Libya', 'LY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Liechtenstein', 'LI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Lithuania', 'LT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Luxembourg', 'LU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Macao', 'MO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Macedonia', 'MK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Madagascar', 'MG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Malawi', 'MW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Malaysia', 'MY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Maldives', 'MV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mali', 'ML');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Malta', 'MT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Marshall Islands', 'MH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Martinique', 'MQ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mauritania', 'MR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mauritius', 'MU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mayotte', 'YT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mexico', 'MX');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Micronesia', 'FM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Moldova', 'MD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Monaco', 'MC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mongolia', 'MN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Montenegro', 'ME');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Montserrat', 'MS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Morocco', 'MA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Mozambique', 'MZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Myanmar', 'MM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Namibia', 'NA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Nauru', 'NR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Nepal', 'NP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Netherlands', 'NL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('New Caledonia', 'NC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('New Zealand', 'NZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Nicaragua', 'NI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Niger', 'NE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Nigeria', 'NG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Niue', 'NU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Norfolk Island', 'NF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Northern Mariana Islands', 'MP');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Norway', 'NO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Oman', 'OM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Pakistan', 'PK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Palau', 'PW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Palestine', 'PS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Panama', 'PA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Papua New Guinea', 'PG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Paraguay', 'PY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Peru', 'PE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Philippines', 'PH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Pitcairn', 'PN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Poland', 'PL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Portugal', 'PT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Puerto Rico', 'PR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Qatar', 'QA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Reunion', 'RE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Romania', 'RO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Russian Federation', 'RU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Rwanda', 'RW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Barthelemy', 'BL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Helena Ascension and Tristan da Cunha', 'SH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Kitts and Nevis', 'KN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Lucia', 'LC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Martin (French part)', 'MF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Pierre and Miquelon', 'PM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saint Vincent and the Grenadines', 'VC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Samoa', 'WS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('San Marino', 'SM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sao Tome and Principe', 'ST');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Saudi Arabia', 'SA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Senegal', 'SN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Serbia', 'RS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Seychelles', 'SC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sierra Leone', 'SL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Singapore', 'SG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sint Maarten (Dutch part)', 'SX');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Slovakia', 'SK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Slovenia', 'SI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Solomon Islands', 'SB');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Somalia', 'SO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('South Africa', 'ZA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('South Georgia and the South Sandwich Islands', 'GS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('South Sudan', 'SS');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Spain', 'ES');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sri Lanka', 'LK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sudan', 'SD');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Suriname', 'SR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Svalbard and Jan Mayen', 'SJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Swaziland', 'SZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Sweden', 'SE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Switzerland', 'CH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Syrian Arab Republic', 'SY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Taiwan Province of China', 'TW');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tajikistan', 'TJ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tanzania', 'TZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Thailand', 'TH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Timor-Leste', 'TL');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Togo', 'TG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tokelau', 'TK');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tonga', 'TO');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Trinidad and Tobago', 'TT');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tunisia', 'TN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Turkey', 'TR');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Turkmenistan', 'TM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Turks and Caicos Islands', 'TC');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Tuvalu', 'TV');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Uganda', 'UG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Ukraine', 'UA');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('United Arab Emirates', 'AE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('United Kingdom', 'GB');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('United States', 'US');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('United States Minor Outlying Islands', 'UM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Uruguay', 'UY');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Uzbekistan', 'UZ');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Vanuatu', 'VU');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Venezuela', 'VE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Viet Nam', 'VN');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Virgin Islands British', 'VG');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Virgin Islands U.S.', 'VI');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Wallis and Futuna', 'WF');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Western Sahara', 'EH');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Yemen', 'YE');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Zambia', 'ZM');
INSERT INTO `list_countries` (`country_name`, `country_short_name`) VALUES ('Zimbabwe', 'ZW');

1010

PHP: Convert the timestamp to human-readable format

04.06.2013 02:12 RedOctober PHP 0 Comments

Convert the timestamp to human-readable format like XX minutes ago or XX days ago. Was found here: http://stackoverflow.com/questions/2915864/php-how-to-find-the-time-elapsed-since-a-date-time ... Reveal Code

function humanTiming ($time)
{
        $time = strtotime($time);
    $time = time() - $time; // to get the time since that moment

    $tokens = array (
        31536000 => 'year',
        2592000 => 'month',
        604800 => 'week',
        86400 => 'day',
        3600 => 'hour',
        60 => 'minute',
        1 => 'second'
    );

    foreach ($tokens as $unit => $text) {
        if ($time < $unit) continue;
        $numberOfUnits = floor($time / $unit);
        return $numberOfUnits.' '.$text.(($numberOfUnits>1)?'s':'').' ago';
    }

}

$time = '2013-05-25 15:45:22';
echo 'Event happened '.humanTiming($time);

1114

Delphi: Give a new name if the file already exists

31.05.2013 01:52 RedOctober Delphi 0 Comments

Give a new name if the file already exists ... Reveal Code

function file_newname($path, $filename){
    if ($pos = strrpos($filename, '.')) {
           $name = substr($filename, 0, $pos);
           $ext = substr($filename, $pos);
    } else {
           $name = $filename;
    }

    $newpath = $path.'/'.$filename;
    $newname = $filename;
    $counter = 0;
    while (file_exists($newpath)) {
           $newname = $name .'_'. $counter . $ext;
           $newpath = $path.'/'.$newname;
           $counter++;
     }
    return $newname;
}

974

Delphi: Get MAC address

31.05.2013 01:49 RedOctober Delphi 0 Comments

Get MAC address for 1st network adapter ... Reveal Code

function GetMACAddress: string;
var
 AdapterList: TLanaEnum; 
 NCB: TNCB; 
begin 
 FillChar(NCB, SizeOf(NCB), 0); 
 NCB.ncb_command := Char(NCBENUM); 
 NCB.ncb_buffer := @AdapterList; 
 NCB.ncb_length := SizeOf(AdapterList); 
 Netbios(@NCB); 
 if Byte(AdapterList.length) > 0 then
   Result := GetAdapterInfo(AdapterList.lana[0]) 
end;

1062

PHP: Convert the date interval to human-readable format

27.05.2013 05:34 RedOctober PHP 0 Comments

Convert the date/time interval in human-readable format ... Reveal Code

$startDate = 'now';
$endDate = '2013-08-12 14:30:00';

function date_diff($date1, $date2) {
    $diff = strtotime($date2) - strtotime($date1);
    return abs($diff);
}

function seconds2human($ss) {
    $s = $ss % 60;
    $m = floor(($ss % 3600) / 60);
    $h = floor(($ss) / 3600);

    return "$h hours, $m minutes, $s seconds";
}

echo "This file will expire in  ". seconds2human(date_diff($startDate,$endDate));

1290

PHP: Auto-crop the image

26.05.2013 23:52 RedOctober PHP 2 Comments

This class can be used to crop images by removing edges with same color. It can load a GIF, JPEG or PNG image and scans it to detect edges color, so it crops the image to remove the edge areas that have the same color around it. The cropped image is outputted in the same format as the original image. ... Reveal Code

 originalSource = $source;
            if($destination)
            {
                $this->destinationSource = $destination;
            }
            
            return $this->cropImage();
        }
        else return false;
    }
    
    /**
     * @return     boolean
     */
    private function cropImage()
    {
        // first we get the filetype
        $fileType = mime_content_type($this->originalSource);
        if(substr($fileType, 0, 5) == "image")
        {
            switch($fileType)
            {
                case "image/jpeg":
                    $this->originalImage = imagecreatefromjpeg($this->originalSource);
                    $this->destinationImage = imagecreatefromjpeg($this->originalSource);
                    break;
                
                case "image/gif":
                    $this->originalImage = imagecreatefromgif($this->originalSource);
                    $this->destinationImage = imagecreatefromgif($this->originalSource);
                    break;
                    
                case "image/png":
                    $this->originalImage = imagecreatefrompng($this->originalSource);
                    $this->destinationImage = imagecreatefrompng($this->originalSource);
                    break;
                    
                default:
                    return false;
                    break;
            }
            if($this->originalImage)
            {
                $this->imagecolorswap($this->destinationImage);
                $this->edge = $this->imageGetEdges($this->destinationImage, 250, 250, 250);
                imagedestroy($this->destinationImage);
                
                $newWidth = $this->edge[0]-$this->edge[2];
                $newHeight = $this->edge[1]-$this->edge[3];
                $this->destinationImage = imagecreatetruecolor($newWidth, $newHeight);
                imagecopyresized(
                    $this->destinationImage, 
                    $this->originalImage, 
                    0, 
                    0, 
                    $this->edge[2], 
                    $this->edge[3], 
                    $newWidth, 
                    $newHeight, 
                    $newWidth, 
                    $newHeight
                );
                
                return $this->outputImage();
            }
            else return false;
        }
        else return false;
    }
    
    /**
     * @return boolean
     */
    private function outputImage()
    {
        if(count($this->edge) == 4)
        {
            // output the image....as what?
            if($this->destinationSource)
            {    // save to file
                // get the destination extention so we know how to save this image
                $fileType = strtolower(substr($this->destinationSource,strripos($this->destinationSource, ".")));
                switch($fileType)
                {
                    case ".jpg":
                    case ".jpeg":
                        imagejpeg($this->destinationImage, $this->destinationSource);
                        break;
                        
                    case ".png":
                        imagepng($this->destinationImage, $this->destinationSource);
                        break;
                        
                    case ".gif":
                        imagegif($this->destinationImage, $this->destinationSource);
                        break;    
                }
            }
            else
            {    // inline display
                $fileType = mime_content_type($this->originalSource);
                header('Content-type: '.$fileType);
                switch($fileType)
                {
                    case "image/jpeg":
                        imagejpeg($this->destinationImage);
                        break;
                        
                    case "image/png":
                        imagepng($this->destinationImage);
                        break;
                        
                    case "image/gif":
                        imagegif($this->destinationImage);
                        break;    
                }
            }
            return true;
        }
        else return false;
    }
    
    /**
     * @param $img (image resource)
     * @param $red (color red)
     * @param $green (color green)
     * @param $blue (color blue)
     * @return array(X1, Y1, X2, Y2) (right, bottom, left, top)
     * @brief    X1,Y1 are the bottom right positions and X2,Y2 are the top left position
     */
    private function imageGetEdges(&$img, $red, $green, $blue)
    {
        // where the color starts thats te edge
        $margin = 30;
        $width = imagesx($img);
        $height = imagesy($img);
        
        $returnX = $this->margin;
        $returnY = $this->margin;
        $returnXmin = $width-($this->margin);
        $returnYmin = $height-($this->margin);
        $Xvalues = array();
        $Yvalues = array();
        
        $searchColor = imagecolorclosest($img, $red, $green, $blue);
        for($x = $margin; $x<($width-$this->margin); $x=$x+1)
        {
            for($y = $margin; $y<($height-$this->margin); $y=$y+1)
            {
                $color = imagecolorat($img, $x, $y);
                if($color != $searchColor)
                {
                    $aprocX = floor($x/$this->correction)*$this->correction;
                    $aprocY = floor($y/$this->correction)*$this->correction;
                    if(isset($Xvalues[$aprocX]))
                        $Xvalues[$aprocX] += 1;
                    else
                        $Xvalues[$aprocX] = 0;
                        
                    if(isset($Yvalues[$aprocY]))
                        $Yvalues[$aprocY] += 1;
                    else
                        $Yvalues[$aprocY] = 0;
                }
            }
        }
        // average X and Y
        $returnX = $this->margin;
        $returnY = $this->margin;
        $returnXmin = $width-($this->margin);
        $returnYmin = $height-($this->margin);
        foreach($Xvalues AS $X => $aantal)
        {
            if($X > $returnX && $aantal > 8)
            {
                $returnX = $X;
            }
            if($X < $returnXmin && $aantal > 8)
            {
                $returnXmin = $X;
            }
        }
        foreach($Yvalues AS $Y => $aantal)
        {
            if($Y > $returnY && $aantal > 8)
            {
                $returnY = $Y;
                $maxAantalY = $aantal;
            }
            if($Y < $returnYmin && $aantal > 8)
            {
                $returnYmin = $Y;
            }
        }
        
        $testmargin = $this->margin + $this->correction;
    
        if($returnX >= $width-($testmargin))
            $returnX = $width;
        else
            $returnX += $this->correction;
            
        if($returnY >= $height-($testmargin))
            $returnY = $height;
        else
            $returnY += $this->correction;
            
        if($returnXmin <= $testmargin)
            $returnXmin  = 0;
        else
            $returnXmin -= $this->correction;
            
        if($returnYmin <= $testmargin)
            $returnYmin = 0;
        else
            $returnYmin -= $this->correction;
            
        return array($returnX, $returnY, $returnXmin, $returnYmin);
    }
    
    private function imagecolorswap(&$img) 
    {    
        // First we remove the background
        imagefilter($img, IMG_FILTER_SMOOTH, 10);
        imagefilter($img, IMG_FILTER_EDGEDETECT);
        imagefilter($img, IMG_FILTER_CONTRAST, -90);
        imagefilter($img, IMG_FILTER_BRIGHTNESS, -20);
        //imagefilter($img, IMG_FILTER_BRIGHTNESS, -40);
        imagefilter($img, IMG_FILTER_CONTRAST, 20);
        
        // remove color: 120 120 120 TO 180 180 180
        if (!($t = imagecolorstotal($img))) 
        {
            $t = 250;
            imagetruecolortopalette($img, 1, $t);
        }
        for ($c = 0; $c < $t; $c++) 
        { 
            $cc = imagecolorclosest($img, 150, 150, 150);
            imagecolorset($img, $cc, 250, 250, 250);
        }
        imagefilter($img, IMG_FILTER_COLORIZE, 0, 0, 0);
    }
}
?>

770

HTML: List of US states

26.05.2013 16:04 RedOctober HTML 0 Comments

List of US states with USPS official abbreviations ... Reveal Code

232

CSS: Different links style

22.05.2013 14:54 RedOctober CSS 0 Comments

Different links style depending on the type of these links ... Reveal Code

/* External links */
a[href^="http://"]{
    text-decoration: underline;
}

/* Emails */
a[href^="mailto:"]{
    border-bottom: 1px dotted #0080FF;
}
/* PDF files */
a[href$=".pdf"]{
    padding-right: 20px;
    background: url(images/pdf_icon.png) no-repeat center right;
}

211

jQuery: Growl-like messages

21.05.2013 14:25 RedOctober jQuery 0 Comments

Simple Growl-like messages (top-right corner of a page) ... Reveal Code




    




Click me!

232

PHP: Find all the links on a page

17.05.2013 02:09 RedOctober PHP 0 Comments

Find all the links on a page (except of dummy links like "#") ... Reveal Code

$html = file_get_contents('https://snippets.pro');
$dom = new DOMDocument();
@$dom->loadHTML($html);
$xpath = new DOMXPath($dom);
$links = $xpath->evaluate("/html/body//a");

for ($i = 0; $i < $links->length; $i++) {
    $link = $links->item($i);
    $url = $link->getAttribute('href');
    if (strpos($url, '#') === false)
        echo $url . '
';
}

245

PHP: Check availability of a website

17.05.2013 02:00 RedOctober PHP 1 Comments

Check availability of a website ... Reveal Code

function checkUrl($url) {
    $agent = "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0";
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_USERAGENT, $agent);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_VERBOSE, false);
    curl_setopt($ch, CURLOPT_TIMEOUT, 5);
    $page = curl_exec($ch);
    $resp = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);
    if (($resp >= 200) && ($resp < 310))
        return true;
    else
        return false;
}

if (checkUrl("http://microsoft.com"))
    echo "Website UP
";
else
    echo "Website DOWN
";

if (checkUrl("http://microsoft1234567.com"))
    echo "Website UP
";
else
    echo "Website DOWN
";

249

JavaScript: Send a POST request

16.05.2013 13:47 RedOctober JavaScript 0 Comments

Send a POST request in the same way as it does form's submit. Was found here: http://stackoverflow.com/questions/133925/javascript-post-request-like-a-form-submit ... Reveal Code

352

jQuery: Enable the button when there is text in the text field

16.05.2013 00:49 RedOctober jQuery 0 Comments

Enable the button ("Submit" or other) when there is text in the text field ... Reveal Code

$('#myTextField').keyup(function() {
   $('#myButton').attr('disabled', !$('#myTextField').val());
});

254

PHP: Parse XML

15.05.2013 16:00 RedOctober PHP 0 Comments

Parse XML via SimpleXML ... Reveal Code

$xml_string = " 
     
        
          John Doe 
          
        
        
          Joanna Doe 
          
        
    ";
$xml = simplexml_load_string($xml_string);

foreach ($xml->user as $user) {
    //Get "id" and "status" attributes
    echo $user['id'].' ('.$user['status'].')
';
    //Get subnodes
    echo $user->username. '
';
    echo $user->useremail. '
';
}

257

jQuery: Scroll to top

15.05.2013 14:10 RedOctober jQuery 0 Comments

Scroll the page to its top ... Reveal Code

$("a[href='#top']").click(function() {
  $("html, body").animate({ scrollTop: 0 }, "fast");
  return false;
});

338

PHP: Send an HTML formatted email

15.05.2013 14:05 RedOctober PHP 0 Comments

Send an HTML formatted email. Supports all HTML formatting ... Reveal Code

$messagetext = 'Message body
with HTML formatting';
$mail_to = '';
$subject = 'My Subject';
$headers = "Content-type: text/html; charset=utf8 \r\n";
$headers .= "From:  <>\r\n";
mail($mail_to, $subject, $messagetext, $headers);

277

htaccess: Own error pages

15.05.2013 11:30 RedOctober htaccess 0 Comments

Own error pages via .htaccess ... Reveal Code

ErrorDocument 400 / 400.html
ErrorDocument 401 / 401.html
ErrorDocument 403 / 403.html
ErrorDocument 404 / 404.html
ErrorDocument 500 / 500.html

192

CSS: Cross-browser transparency

15.05.2013 05:28 RedOctober CSS 0 Comments

Cross-browser transparency. Works equally well in IE, FF, Chrome, Safari and Opera. ... Reveal Code

.transp-element {
    filter: alpha(opacity=80);  /* IE */
    -khtml-opacity: 0.8;  /* Safari (old) */
    -moz-opacity: 0.8;  /* FF */
    opacity: 0.8;  /* FF, Safari, Opera */
}

352

htaccess: Rewrite URLs

15.05.2013 01:58 RedOctober htaccess 0 Comments

Rewrite URLs with .htaccess. If you use it then URL like "http://mydomain.com/user.php?show=JohnDoe" will be equivalent to "http://mydomain.com/user/JohnDoe/". ... Reveal Code

RewriteEngine on
RewriteRule ^user/([-a-zA-Z0-9_]+)/? user.php?&show=$1 [L]

220

PHP: Execution time of the script

15.05.2013 01:19 RedOctober PHP 0 Comments

Execution time of the script. Shows the text like this: "The script has been executed in 0.0090 sec." ... Reveal Code

$time_start = microtime(true);

// your PHP code here

$time_end = microtime(true);
$time = $time_end - $time_start;

echo 'This script has been executed in ' . $time . ' sec.';

236

PHP: Allow only numbers and letters

08.05.2013 02:07 RedOctober PHP 4 Comments

Allow only numbers and letters using preg_match ... Reveal Code

if (!preg_match("/^[a-zA-Z0-9-\s]{3,24}$/", $_REQUEST[user_name])) {
    $errormsg .= "Use only letters and numbers";
}

455

08.05.2013 01:58 RedOctober JavaScript

Tracking the Facebook comments: creating and removing. You can use it to count the FB comments in the local database. ... Reveal Code

JavaScript: Email validation

08.05.2013 01:36 RedOctober JavaScript 0 Comments

Validation of the entered email using regex ... Reveal Code

function IsEmail(email) {
    var regex = /^([a-zA-Z0-9_\.\-\+])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/;
    return regex.test(email);
}

306

PHP: Make a clickable text

08.05.2013 01:31 RedOctober PHP 0 Comments

Make a clickable text: replace all the URLs with tag ... Reveal Code

function makeClickable($text) {
    $text = preg_replace("/(^|[\n ])([\w]*?)((ht|f)tp(s)?:\/\/[\w]+[^ \,\"\n\r\t<]*)/is", "$1$2$3", $text);
    $text = preg_replace("/(^|[\n ])([\w]*?)((www|ftp)\.[^ \,\"\t\n\r<]*)/is", "$1$2$3", $text);
    $text = preg_replace("/(^|[\n ])([a-z0-9&\-_\.]+?)@([\w\-]+\.([\w\-\.]+)+)/i", "$1$2@$3", $text);
    return($text);
}

246

Delphi: Get temp directory

08.05.2013 01:22 RedOctober Delphi 0 Comments

Get Windows temp directory. Will return something like this: C:UsersMyUserNameAppDataLocalTemp ... Reveal Code

function GetTempDir: WideString; stdcall;
var
  Buffer: array[0..MAX_PATH] of Char;
begin
  GetTempPath((SizeOf(Buffer) div SizeOf(Char)) - 1, Buffer);
  Result := Buffer;
end;

procedure TForm1.btn1Click(Sender: TObject);
begin
  ShowMessage(GetTempDir);
end;

310

Delphi: Open URL in a default browser

08.05.2013 01:17 RedOctober Delphi 0 Comments

Open URL in a default browser ... Reveal Code

uses Winapi.ShellAPI;
...

procedure OpenURL(url:string);
begin
  ShellExecute(Handle, 'open', pChar(url), nil, nil, SW_NORMAL);
end;

458

Delphi: Clear the IE cache

08.05.2013 01:13 RedOctober Delphi 0 Comments

Completely clean the IE cache ... Reveal Code

procedure ClearIECache;
var
  lpEntryInfo: PInternetCacheEntryInfo;
  hCacheDir: LongWord;
  dwEntrySize: LongWord;
begin
  dwEntrySize := 0;
  FindFirstUrlCacheEntry(nil, TInternetCacheEntryInfo(nil^), dwEntrySize);
  GetMem(lpEntryInfo, dwEntrySize);
  if dwEntrySize > 0 then
    lpEntryInfo^.dwStructSize := dwEntrySize;
  hCacheDir := FindFirstUrlCacheEntry(nil, lpEntryInfo^, dwEntrySize);
  if hCacheDir <> 0 then
  begin
    repeat
      DeleteUrlCacheEntry(lpEntryInfo^.lpszSourceUrlName);
      FreeMem(lpEntryInfo, dwEntrySize);
      dwEntrySize := 0;
      FindNextUrlCacheEntry(hCacheDir, TInternetCacheEntryInfo(nil^),
        dwEntrySize);
      GetMem(lpEntryInfo, dwEntrySize);
      if dwEntrySize > 0 then
        lpEntryInfo^.dwStructSize := dwEntrySize;
    until not FindNextUrlCacheEntry(hCacheDir, lpEntryInfo^, dwEntrySize);
  end;
  FreeMem(lpEntryInfo, dwEntrySize);
  FindCloseUrlCache(hCacheDir);
end;

213

Delphi: Bytes formatting

08.05.2013 01:07 RedOctober Delphi 0 Comments

Formatting byte values to a more readable values ... Reveal Code

function FormatByteSize(const bytes: Longint): string;
const
  B = 1; //byte
  KB = 1024 * B; //kilobyte
  MB = 1024 * KB; //megabyte
  GB = 1024 * MB; //gigabyte
begin
  if bytes > GB then
    result := FormatFloat('#.## Gb', bytes / GB)
  else if bytes > MB then
    result := FormatFloat('#.## Mb', bytes / MB)
  else if bytes > KB then
    result := FormatFloat('#.## Kb', bytes / KB)
  else
    result := FormatFloat('#.## bytes', bytes);
end;

203

PHP: Determination of the OS

07.05.2013 03:31 RedOctober PHP 1 Comments

Determination of the OS by user-agent string ... Reveal Code

function user_os($userAgent) {
    $oses = array(
        'iPhone' => '(iPhone)',
        'Windows 3.11' => 'Win16',
        'Windows 95' => '(Windows 95)|(Win95)|(Windows_95)',
        'Windows 98' => '(Windows 98)|(Win98)',
        'Windows 2000' => '(Windows NT 5.0)|(Windows 2000)',
        'Windows XP' => '(Windows NT 5.1)|(Windows XP)',
        'Windows 2003' => '(Windows NT 5.2)',
        'Windows Vista' => '(Windows NT 6.0)|(Windows Vista)',
        'Windows 7' => '(Windows NT 6.1)|(Windows 7)',
        'Windows NT 4.0' => '(Windows NT 4.0)|(WinNT4.0)|(WinNT)|(Windows NT)',
        'Windows ME' => 'Windows ME',
        'Open BSD' => 'OpenBSD',
        'Sun OS' => 'SunOS',
        'Linux' => '(Linux)|(X11)',
        'Safari' => '(Safari)',
        'Mac OS' => '(Mac_PowerPC)|(Macintosh)',
        'QNX' => 'QNX',
        'BeOS' => 'BeOS',
        'OS/2' => 'OS/2',
        'Search Bot' => '(nuhk)|(Googlebot)|(Yammybot)|(Openbot)|(Slurp/cat)|(msnbot)|(ia_archiver)'
    );
    foreach ($oses as $os => $pattern) {
        if (eregi($pattern, $userAgent)) {
            return $os;
        }
    }
    return 'Unknown';
}

331

PHP: Format a date received from MySQL

06.05.2013 14:58 RedOctober PHP 0 Comments

Format a date/time received from MySQL in a more readable (user-friendly) form. ... Reveal Code

//$row[create_datetime] == '2013-05-06 03:14:43';
//$formatted_datetime == '06.05.2013 03:14';

define('SHORTDATETIME', 'd.m.Y H:i');
$formatted_datetime = date_format(date_create($row[create_datetime]), SHORTDATETIME);

293

PHP: Get a single value from DB

06.05.2013 02:40 RedOctober PHP 0 Comments

Get a single value from DB as a variable. ... Reveal Code

$my_variable = mysql_result(mysql_query("SELECT COUNT(id) FROM my_table"), 0);

253

PHP: Email validation

06.05.2013 01:25 RedOctober PHP 3 Comments

Validation of the entered email using preg_match ... Reveal Code

if (!preg_match('/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,6})$/', $_REQUEST[user_email])) {
    $errmsg .= "Please enter a valid email address
";
}

247

PHP: Create a permalink based on the text entered

05.05.2013 17:48 RedOctober PHP 0 Comments

Simple PHP-function allows to create a permalink based on the text entered. Was found on stackoverflow.com. ... Reveal Code

function make_permalink($title) {
    $result = strtolower($title);
    // strip all non word chars
    $result = preg_replace('/\W/', ' ', $result);
    // replace all white space sections with a dash
    $result = preg_replace('/\ +/', '-', $result);
    // trim dashes
    $result = preg_replace('/\-$/', '', $result);
    $result = preg_replace('/^\-/', '', $result);
    return $result;
}

166

Delphi: Замена подстроки в сторке

05.05.2013 17:48 RedOctober Delphi 0 Comments

Замена всех подстрок в данной строке. Функция была использована от Delphi 7 до Delphi XE3. ... Reveal Code

function ReplaceSub(str, sub1, sub2: string): string;
var
  aPos: Integer;
  rslt: string;
begin
  aPos := pos(sub1, str);
  rslt := '';
  while (aPos <> 0) do
  begin
    rslt := rslt + Copy(str, 1, aPos - 1) + sub2;
    Delete(str, 1, aPos + Length(sub1) - 1);
    aPos := pos(sub1, str);
  end;
  result := rslt + str;
end;

procedure TForm1.btn1Click(Sender: TObject);
var
  my_str: string;
begin
  my_str := 'My cool string is very cool!';
  ShowMessage(ReplaceSub(my_str, 'cool', 'awesome'));
end;

290

Delphi: Add a message to log

05.05.2013 16:29 RedOctober Delphi 0 Comments

Add a message to TRichEdit based log. Message will be in a format: [CURRENT_DATE CURRENT_TIME]: MESSAGE_TEXT ... Reveal Code

function timetolog(reqdate: TdateTime): string;
var
  Y, m, d, hh, mm, ss, ms: WORD;
  newy, newm, newd, newhh, newmm, newss: string;
begin
  DecodeDate(reqdate, Y, m, d);
  DecodeTime(reqdate, hh, mm, ss, ms);
  newy := inttostr(Y);
  newm := inttostr(m);
  newd := inttostr(d);
  newhh := inttostr(hh);
  newmm := inttostr(mm);
  newss := inttostr(ss);
  if length(newm) = 1 then
    newm := '0' + newm;
  if length(newd) = 1 then
    newd := '0' + newd;
  if length(newhh) = 1 then
    newhh := '0' + newhh;
  if length(newmm) = 1 then
    newmm := '0' + newmm;
  if length(newss) = 1 then
    newss := '0' + newss;
  Result := '[' + newd + '.' + newm + '.' + newy + ' ' + newhh + ':' + newmm +
    ':' + newss + '] ';
end;

procedure AddLog(ARichEdit: TRichEdit; AText: string);
var
  Count: Integer;
begin
  AText := timetolog(now) + AText;
  Count := pos(']', AText) + 1;
  if pos('ERROR', AText) > 0 then
  begin
    ARichEdit.Lines.Add(AText);
    ARichEdit.SelStart := length(ARichEdit.Text);
    ARichEdit.SelStart := ARichEdit.SelStart - length(AText) - 1;
    ARichEdit.SelLength := Count;
    ARichEdit.SelAttributes.Style := [fsbold];
    ARichEdit.SelAttributes.Color := rgb(180, 10, 10);
    ARichEdit.SelStart := ARichEdit.SelStart + Count;
    ARichEdit.SelLength := length(AText) - Count;
    ARichEdit.SelAttributes.Style := [];
    ARichEdit.SelAttributes.Color := rgb(180, 10, 10);
    ARichEdit.SelLength := 0;
  end
  else
  begin
    ARichEdit.Lines.Add(AText);
    ARichEdit.SelStart := length(ARichEdit.Text);
    ARichEdit.SelStart := ARichEdit.SelStart - length(AText) - 1;
    ARichEdit.SelLength := Count;
    ARichEdit.SelAttributes.Style := [fsbold];
    ARichEdit.SelStart := ARichEdit.SelStart + Count;
    ARichEdit.SelLength := length(AText) - Count;
    ARichEdit.SelAttributes.Style := [];
    ARichEdit.SelLength := 0;
  end;
  SendMessage(ARichEdit.Handle, EM_SCROLL, SB_LINEDOWN, 0);
  try
    ARichEdit.SetFocus;
    ARichEdit.SelStart := ARichEdit.GetTextLen;
    ARichEdit.Perform(EM_SCROLLCARET, 0, 0);
    CreateCaret(ARichEdit.handle, 0, 0, 0);
  except
    //
  end;
  application.ProcessMessages;
end;


procedure TForm1.btn1Click(Sender: TObject);
begin
  AddLog(Form1.RichEdit1, 'ERROR: Something Wrong!'); //Error Message
  AddLog(Form1.RichEdit1, 'Some text here'); //Regular Message
end;

246

MySQL: The number of records for yesterday

05.05.2013 16:19 RedOctober MySQL 0 Comments

The number of records in the table for yesterday ... Reveal Code

SELECT COUNT(id) FROM my_table WHERE created_datetime >= (DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 DAY), '%Y-%m-%d')) AND created_datetime < (DATE_FORMAT(NOW(), '%Y-%m-%d'))

274

Delphi: Get MD5 value

05.05.2013 15:26 RedOctober Delphi 0 Comments

Get MD5 value, in the same way as it PHP does. ... Reveal Code

Uses IdHashMessageDigest;

function getmd5(SourceString: string): string;
var
  md5: TIdHashMessageDigest5;
begin
  result := '';
  md5 := TIdHashMessageDigest5.Create;
  try
    result := AnsiLowerCase(md5.HashStringAsHex(SourceString));
  finally
    FreeAndNil(md5);
  end;
end;

procedure TForm1.btn1Click(Sender: TObject);
begin
  ShowMessage(getmd5('Hash, darling!'));
end;

382

MySQL: The number of records for the current month

05.05.2013 15:09 RedOctober MySQL 0 Comments

The number of records in a table for the current month (from 1st to current day) ... Reveal Code

SELECT COUNT(id) FROM my_table WHERE date_format(created_datetime, '%Y%m') = date_format(now(), '%Y%m')

299

PHP: Bytes formatting

05.05.2013 13:36 RedOctober PHP 0 Comments

Formatting byte values to a more readable values ... Reveal Code

function byte_format($num) {
    if ($num >= 1000000000000) {
        $num = round($num / 1099511627776, 1);
        $unit = "Tb";
    } elseif ($num >= 1000000000) {
        $num = round($num / 1073741824, 1);
        $unit = "Gb";
    } elseif ($num >= 1000000) {
        $num = round($num / 1048576, 1);
        $unit = "Mb";
    } elseif ($num >= 1000) {
        $num = round($num / 1024, 1);
        $unit = "Kb";
    } else {
        $unit = "Bytes";
        return number_format($num) . ' ' . $unit;
    } return number_format($num, 1) . ' ' . $unit;
}

180

Delphi: Get the version of a file

05.05.2013 13:10 RedOctober Delphi 0 Comments

Get the version of a file. The function was used from Delphi 7 to Delphi XE3. ... Reveal Code

function GetFileVersion(const FileName: string): string;
type
  PDWORD = ^dword;
  PLangAndCodePage = ^TLangAndCodePage;
  TLangAndCodePage = packed record
    wLanguage: word;
    wCodePage: word;
  end;
  PLangAndCodePageArray = ^TLangAndCodePageArray;
  TLangAndCodePageArray = array[0..0] of TLangAndCodePage;
var
  loc_InfoBufSize: dword;
  loc_InfoBuf: PChar;
  loc_VerBufSize: dword;
  loc_VerBuf: PChar;
  cbTranslate: dword;
  lpTranslate: PDWORD;
  i: dword;
begin
  result := '';
  if (Length(FileName) = 0) or (not Fileexists(FileName)) then
    exit;
  loc_InfoBufSize := GetFileVersionInfoSize(PChar(FileName), loc_InfoBufSize);
  if loc_InfoBufSize > 0 then
  begin
    loc_VerBuf := nil;
    loc_InfoBuf := AllocMem(loc_InfoBufSize);
    try
      if not GetFileVersionInfo(PChar(FileName), 0, loc_InfoBufSize, loc_InfoBuf)
        then
        exit;
      if not VerQueryValue(loc_InfoBuf, '\\VarFileInfo\\Translation',
        Pointer(lpTranslate), dword(cbTranslate)) then
        exit;
      for i := 0 to (cbTranslate div SizeOf(TLangAndCodePage)) - 1 do
      begin
        if VerQueryValue(loc_InfoBuf,
          PChar(Format('StringFileInfo\0x\FileVersion',
          [PLangAndCodePageArray(lpTranslate)[i].wLanguage,
          PLangAndCodePageArray(lpTranslate)[i].wCodePage])),
            Pointer(loc_VerBuf), dword(loc_VerBufSize)) then
        begin
          result := loc_VerBuf;
          Break;
        end;
      end;
    finally
      FreeMem(loc_InfoBuf, loc_InfoBufSize);
    end;
  end;
end;

procedure TForm1.btn1Click(Sender: TObject);
begin
  ShowMessage(GetFileVersion(Application.ExeName));
end;

282

CSS: Box shadow

22.05.2013 15:05 RedOctober CSS 0 Comments

Cross-browser CSS box shadow ... Reveal Code

-webkit-box-shadow: 0 3px 4px rgba(0, 0, 0, 0.4);
-moz-box-shadow: 0 3px 4px rgba(0, 0, 0, 0.4);
box-shadow: 0 3px 4px rgba(0, 0, 0, 0.4);

294

CSS: Rounded corners

22.05.2013 15:04 RedOctober CSS 1 Comments

Cross-browser CSS rounded corners ... Reveal Code

-webkit-border-radius: 6px;
-moz-border-radius: 6px;
border-radius: 6px;

364

PHP: Custom social sharing URLs

19.05.2013 09:45 RedOctober PHP 0 Comments

Custom social sharing URLs for the most popular social networks ... Reveal Code

$facebook_link = "http://www.facebook.com/sharer.php?u=" . urlencode($URL) . "&t=" . urlencode($TITLE) . "&src=sp";
$twitter_link = "http://twitter.com/home/?status=" . urlencode($URL . " - " . $TITLE);
$googleplus_link = "https://plusone.google.com/_/+1/confirm?hl=en&url=" . urlencode($URL);
$reddit_link = "http://reddit.com/submit?url=" . urlencode($URL) . "&title=" . urlencode($TITLE);
$vkontakte_link = "http://vkontakte.ru/share.php?url=" . urlencode($URL) . "&title=" . urlencode($TITLE);

378

Visual Studio: Visual Studio sample snippet

10.05.2013 16:32 RedOctober Visual Studio 2 Comments

A snippet sample in VS2005 format ... Reveal Code



    
        
            Event with custom delegate
            evnt2
            Code snippet for event
            Romashka
            
                Expansion
            
        
        
            
                
                    EventName
                    Event name
                    OnSomethingHappens
                
                
                    args
                    Event arguments
                    CustomEventArgs
                
                
                    sender
                    Event sender
                    sender
                
                
                    args_desc
                    EventArgs description
                    arguments
                
                
                    param_type
                    EventArgs param type
                    int
                
                
                    param_name
                    EventArgs param name
                    id
                
                
                    param_desc
                    EventArgs param description
                    id of something
                
                
                    description
                    Event description
                    something happens
                
            
            
            
                    /// Delegate for $EventName$ event
                    /// 
                    /// $sender$
                    /// $args_desc$
                    public delegate void $EventName$EventHandler(object sender, $args$ e);
                    #endregion

                    #region public event $EventName$EventHandler $EventName$;
                    /// 
                    /// Raised when $description$
                    /// 
                    public event $EventName$EventHandler $EventName$;
                    #endregion

                    #region protected void On$EventName$($param_type$ $param_name$)
                    /// 
                    /// Raise $EventName$ event
                    /// 
                    /// $param_desc$
                    protected void On$EventName$($param_type$ $param_name$)
                    {
                        if ($EventName$ != null)
                            $EventName$(this, new $EventName$EventArgs($param_name$));
                    }
                    #endregion
                    #endregion
            ]]>

353

PHP: Convert a date from SQL to RFC822 format

10.05.2013 11:59 RedOctober PHP 2 Comments

Convert a date from SQL to RFC822 format. It may be useful for creating RSS-feed. ... Reveal Code

function sql_to_rfc822($sql_date_str) {
    $d1 = explode(" ", $sql_date_str);
    $d2 = explode("-", $d1[0]);
    $d3 = explode(":", $d1[1]);
    $rfc822_date_str = date("D, d M Y H:i:s", mktime($d3[0], $d3[1], $d3[2], $d2[1], $d2[2], $d2[0])) . "  GMT";
    return $rfc822_date_str;
}

359

HTML: Empty table layout

08.05.2013 16:05 RedOctober HTML 0 Comments

Empty table layout (3 columns, 2 rows) ... Reveal Code

288

jQuery: Fade in then fade out

08.05.2013 11:09 RedOctober jQuery 1 Comments

Fade in the hidden element, wait a little bit, then fade out id. Simple but useful. ... Reveal Code

$("#error_box").fadeIn(500).delay(3000).fadeOut(500);

348

PHP: Generate a random password

08.05.2013 01:29 RedOctober PHP 1 Comments

Generate a random password with an arbitrary length ... Reveal Code

function generatePassword($length = 8) {
    $chars = 'abdefhiknrstyzABDEFGHKNQRSTYZ23456789';
    $numChars = strlen($chars);
    $string = '';
    for ($i = 0; $i < $length; $i++) {
        $string .= substr($chars, rand(1, $numChars) - 1, 1);
    }
    return $string;
}

269

PHP: Crop the image to a square

07.05.2013 01:32 RedOctober PHP 0 Comments

Crop the image to a square, This function can take care of jpg, png and gif. The size of the image and the jpg-quality can be set separately, ... Reveal Code

function square_crop($src_image, $dest_image, $thumb_size = 60, $jpg_quality = 90) {
    $image = getimagesize($src_image);
    if ($image[0] <= 0 || $image[1] <= 0)
        return false;
    $image['format'] = strtolower(preg_replace('/^.*?\//', '', $image['mime']));
    switch ($image['format']) {
        case 'jpg':
        case 'jpeg':
            $image_data = imagecreatefromjpeg($src_image);
            break;
        case 'png':
            $image_data = imagecreatefrompng($src_image);
            break;
        case 'gif':
            $image_data = imagecreatefromgif($src_image);
            break;
        default:
            return false;
            break;
    }
    if ($image_data == false)
        return false;
    if ($image[0] & $image[1]) {
        $x_offset = ($image[0] - $image[1]) / 2;
        $y_offset = 0;
        $square_size = $image[0] - ($x_offset * 2);
    } else {
        $x_offset = 0;
        $y_offset = ($image[1] - $image[0]) / 2;
        $square_size = $image[1] - ($y_offset * 2);
    }
    $canvas = imagecreatetruecolor($thumb_size, $thumb_size);
    if (imagecopyresampled(
                    $canvas, $image_data, 0, 0, $x_offset, $y_offset, $thumb_size, $thumb_size, $square_size, $square_size
            )) {
        switch (strtolower(preg_replace('/^.*\./', '', $dest_image))) {
            case 'jpg':
            case 'jpeg':
                return imagejpeg($canvas, $dest_image, $jpg_quality);
                break;
            case 'png':
                return imagepng($canvas, $dest_image);
                break;
            case 'gif':
                return imagegif($canvas, $dest_image);
                break;
            default:
                return false;
                break;
        }
    } else {
        return false;
    }
}

475

PHP: Simple pagination

06.05.2013 02:52 RedOctober PHP 0 Comments

Simple PHP pagination uses a Twitter Bootstrap layout ... Reveal Code

$targetpage = "search.php";
$limit = 50; //Records per page
$total_pages = $total_count; //Total number of the records to paginate

$stages = 3;
$page = mysql_escape_string($_REQUEST['page']);
if ($page) {
    $start = ($page - 1) * $limit;
} else {
    $start = 0;
}
if ($page == 0) {
    $page = 1;
}
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages / $limit);
$LastPagem1 = $lastpage - 1;

$paginate = '';
if ($lastpage > 1) {

    $paginate .= "";
    if ($page > 1) {
        $paginate.= "«";
    } else {
        $paginate.= "«";
    }
    if ($lastpage < 7 + ($stages * 2)) {
        for ($counter = 1; $counter <= $lastpage; $counter++) {
            if ($counter == $page) {
                $paginate.= "$counter";
            } else {
                $paginate.= "$counter";
            }
        }
    } elseif ($lastpage > 5 + ($stages * 2)) {
        if ($page < 1 + ($stages * 2)) {
            for ($counter = 1; $counter < 4 + ($stages * 2); $counter++) {
                if ($counter == $page) {
                    $paginate.= "$counter";
                } else {
                    $paginate.= "$counter";
                }
            }

            $paginate.= "...";
            $paginate.= "$LastPagem1";
            $paginate.= "$lastpage";
        } elseif ($lastpage - ($stages * 2) > $page && $page > ($stages * 2)) {
            $paginate.= "1";
            $paginate.= "2";
            $paginate.= "...";
            for ($counter = $page - $stages; $counter <= $page + $stages; $counter++) {
                if ($counter == $page) {
                    $paginate.= "$counter";
                } else {
                    $paginate.= "$counter
";
                }
            }
            $paginate.= "
...";
            $paginate.= "$LastPagem1";
            $paginate.= "$lastpage";
        } else {
            $paginate.= "1";
            $paginate.= "2";
            $paginate.= "...";



            for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++) {
                if ($counter == $page) {
                    $paginate.= "$counter";
                } else {
                    $paginate.= "$counter";
                }
            }
        }
    }

    if ($page < $counter - 1) {
        $paginate.= "»";
    } else {
        $paginate.= "»";
    }

    $paginate.= "";
}
echo $paginate;

754

1C 7.7: Получить название месяца

30.05.2013 04:44 mdbm 1C 7.7 0 Comments

Получить название месяца ... Reveal Code

Функция ПолучитьНазваниеМесяца(НомерМесяца=0)
        Если (НомерМесяца<=0) ИЛИ (НомерМесяца>12) тогда
                Возврат "";
        Иначе
                Возврат Формат(Дата(1980,НомерМесяца,1),"ДММММ");
        КонецЕсли;
КонецФункции //ПолучитьНазваниеМесяца

739

jQuery: Display file sizes next to download links

12.05.2013 15:47 grun jQuery 0 Comments

«jQuery Trickshots» by tutorialzine.com ... Reveal Code

// Loop all .fetchSize links
$('a.fetchSize').each(function(){
 
  // Issue an AJAX HEAD request for each one
    var link = this;
 
    $.ajax({
        type: 'HEAD',
        url: link.href,
        complete: function(xhr){
            var size = humanize(xhr.getResponseHeader('Content-Length'));
 
            // Append the filesize to each
            $(link).append(' (' + type + ')');
        }
    });
});
 
function humanize(size){
    var units = ['bytes','KB','MB','GB','TB','PB'];
 
    var ord = Math.floor( Math.log(size) / Math.log(1024) );
    ord = Math.min( Math.max(0,ord), units.length-1);
 
    var s = Math.round((size / Math.pow(1024,ord))*100)/100;
    return s + ' ' + units[ord];
}
 
// html
// First Trickshot
// This Trickshot
// Ball.png

932

1C 7.7: FTP-Обмен файлами

31.05.2013 05:09 mdbm 1C 7.7 0 Comments

Для отправки файла из 1С на фтп-сервер и обратно можно использовать бесплатную консольную программу ncftp
Страница загрузки: http://www.ncftp.com/download/
Скачать установщик фтп-клиента для Windows и установить. (там же есть исходники)
Описание параметров для PUT http://www.ncftp.com/ncftp/doc/ncftpput.html
Описание параметров для GET http://www.ncftp.com/ncftp/doc/ncftpget.html ... Reveal Code

Процедура ОтправитьФайл()
        Если флПоказыватьЛог=1 Тогда
                ПутьЛогФайла = "stdout";
        Иначе
                ПутьЛогФайла = ""+КаталогОбмена+"ftplog_put.txt";
        КонецЕсли;

        КомандаСистемы("ncftpput -S .tmp -d "+ПутьЛогФайла+" -o useFEAT=0,useCLNT=0,useMLST=0,usePASV=1 -u "+USER+" -p "+PASS+" "+FTP+" / "+ПутьКФайлуДляОтправки);

КонецПроцедуры;




Процедура ПолучитьФайл()
                Если флПоказыватьЛог=1 Тогда
                        ПутьЛогФайла = "stdout";
                Иначе
                        ПутьЛогФайла = ""+КаталогПриемник+"ftplog_get.txt";
                КонецЕсли;

                КомандаСистемы("ncftpget.exe -d "+ПутьЛогФайла+" -o useFEAT=0,useCLNT=0,useMLST=0,usePASV=1 -u "+USER+" -p "+PASS+" "+FTP+" "+КаталогПриемник+" /"+ИмяФайла);

КонецПроцедуры

1162

C++: StopForumSpam

17.05.2013 07:33 AncientDragon C++ 2 Comments

This is a complete console program compiled with Microsoft Visual Studio 2012 that demonstrates how to access the api from (SFS). The program sends a list of ip address to SFS and gets a reply that indicates which ones have been reported as spammers. The list of IP addresses is obtained from a tab deliminated file which was generated from a vBulletin forum web site. You can easily modify the program to get the list of ip address from some other stream.\r\n ... Reveal Code

#include "Socket.h"
#include 
#include  // required for SHGetSpecialFolderPath()
#include 
#include 
#include 
#include 
#include 
#pragma comment(lib, "Shell32.lib")

using namespace std;

// used by  to do case-insensitive comparison of keys
struct classcomp {
  bool operator() (const string& lhs, const string& rhs) const
  {
          return stricmp(lhs.c_str(),rhs.c_str()) < 0;
  }
};

//  required for SHGetSpecialFolderPath()
char buf[MAX_PATH] = {0};

// maximum number of ip addresses that can be sent 
// to www.stopforumspam.com at one time.
const int MaxCount = 15;


// extract ip address from a string in the form "1.1.1.1"
string finditem(string line, string s, int pos1)
{
        int pos2;
        // find end of text " by location the '>' character
        for(; line[pos1] != '>'; pos1++)
                ;
        // now find ""
        pos2= line.find(s);
        // cut out what's inbetween  and 
        line = line.substr(pos1+1,pos2-pos1-1);
        return line;
}

// write final results to data file.
void save(ofstream& out, map& gooditems)
{
        map::iterator it = gooditems.begin();
        for(; it != gooditems.end(); it++)
        {
                out << it->first << '\t' << it->second << '\n';
        }
}

// optional parameter to main() is the input filename, which may NOT contain
// path.  Files are expected to be located in "Libraries/Documents" folder.
int main(int argc, char* argv[]) {

        char* filename = NULL;
        map items;
        map gooditems;
        string line;
        if( argc == 2)
                filename = argv[1];
        else
                filename = "registrations.txt";
        // get full path to libraries/Documents folder
        BOOL b = SHGetSpecialFolderPath(0,buf,CSIDL_MYDOCUMENTS,0);
        // open both input and output files
        string fname = buf;
        fname += "//";
        fname += filename;
        ifstream in(fname.c_str());
        if( !in.is_open() )
        {
                cout << "Can't open file " << filename << '\n';
                return 1;
        }
        fname = buf;
        fname += "\\spam.txt";
        ofstream out(fname.c_str());
        if( !out.is_open() )
        {
                cout << "Can not open output file\n";
                return 1;
        }
        string uname,email,ip,s1,s2,s3;
        // read all the inputfile into vector.  The input file consists of six tab deliminated columns
        // user name, email address, ip address, and three more columns that we don't use.  The data
        // is derived from vBulletin's admin control panel Search Users Waiting Moderation.  Just highlight
        // the list, copy to clipboard, past into Notepad, then write to a file in Libraries/Documents folder.
        while( getline(in,uname,'\t') ) //in >> uname >> email >> ip >> s1 >> s2 >> s3 )
        {
                getline(in,email,'\t');
                getline(in,ip,'\t');
                getline(in,line);
                items[ip] = uname;
        }
        in.close();
        map::iterator it = items.begin();
        size_t pos;
        // Send the IP addresses to wwsw.stopforumspam.com who will return the number of times
        // the ip has been reported for spamming.  Ips can be batch processed, a maximum of 15
        // IPs batch processed at a time.  The socket is closed after each call, so we have to
        // reopen the socket every time we make a request.
        //
        // Requests are in HTM format, such as
        // GET /api?ip[] = 111.111&ip[]=222.222.222.222&ip{}=333.333.333.333, etc for up to 15 addresses
        //
        while( it != items.end() )
        {
                string cmd = "GET /api?";
                int counter = 0;
                do
                {
                        cmd += "ip[]=" + it->first + "&";
                        it++;7
                        counter++;
                } while( it != items.end() && counter < MaxCount);
                if(cmd[cmd.length()-1] == '&')
                        cmd = cmd.substr(0,cmd.length()-1);

                SocketClient s("www.stopforumspam.com", 80);
                s.SendLine(cmd.c_str());
                // stopforumspam.com is going to send back a whole bunch of worthless stuff
                // all we want is ipaddress and number times
                // If the  value is 0 that means the ip has NOT been reported for
                // spamming, and it will be saved in the output file that this program creates.
                while (1) {
                        string l = s.ReceiveLine();
                        if (l.empty()) break;
                        //out << l << '\n';
                        if( (pos = l.find("")) != string::npos)
                        {
                                ip = finditem(l,"",pos);
                                uname = items[ip];
                        }
                        if( l.find("0") != std::string::npos)
                        {
                                cout << uname << '\t' << ip << '\n';
                                // we want the gooditems list to be sorted by username instead
                                // of ip, so uname is used as the key.  We already know the ip 
                                // is unuque in the file, so by definition the uname will also be
                                // unique.  
                                gooditems[uname] = ip;
                        }
                }
    }
        save(out, gooditems);

}

583

JavaScript: Dumping tools and alias for development

11.05.2013 16:32 Shara JavaScript 0 Comments

Use it for easy dumping variables
q() is alias for console.log()
w() is function, that displaying colorfull variable data like "var_export" to popup transparent div
based on this helpfull comment http://stackoverflow.com/a/7220510/2236189

Example: http://jsfiddle.net/ymmsA/
... Reveal Code

// Browser's console dump
function q(i) {
  console.log(i);
}

// DOM's console dump
function w(obj) {
        function syntaxHighlight(json) {
            json = json.replace(/&/g, '&').replace(//g, '>');
            return json.replace(/("(\\u[a-zA-Z0-9]{4}|\\[^u]|[^\\"])*"(\s*:)?|\b(true|false|null)\b|-?\d+(?:\.\d*)?(?:[eE][+\-]?\d+)?)/g, function (match) {
                var cls = 'number';
                if (/^"/.test(match)) {
                    if (/:$/.test(match)) {
                        cls = 'key';
                    } else {
                        cls = 'string';
                    }
                } else if (/true|false/.test(match)) {
                    cls = 'boolean';
                } else if (/null/.test(match)) {
                    cls = 'null';
                }
                return '' + match + '';
            });
        }

        var json = JSON.stringify(obj, undefined, 4);

        $("#console pre").show().html(syntaxHighlight(json));
}

var consoleDiv = '';

var css = '';

$(document).ready(function() {
        $('head').append(css);
        $('body').append(consoleDiv);
});

502

HTML: Allowing Internet Explorer 8 (and older) to render HTML5 documents

11.05.2013 00:06 KARPOLAN HTML 1 Comments

Fix for Internet Explorer 5.5/6/7/8 to render HTML5 documents and websites normally. Place this code into the of document. ... Reveal Code


...



...

1038

Delphi: Delay without blocking of the main thread

10.05.2013 23:24 KARPOLAN Delphi 0 Comments

Function delays program logic execution for a number of miliseconds, The GUI and Windows messages will continue to work. ... Reveal Code

//------------------------------------------------------------------------------
// Provides a waiting (delay) for a given count of MSec (Sec*10^-3). 
// The message processing will continue to work.

procedure Delay(MSec: Cardinal);
var
  BeginTime: Cardinal;
begin
  BeginTime := GetTickCount;
  repeat
    Application.ProcessMessages;
  until Cardinal(Abs(GetTickCount - BeginTime)) >= MSec;
end;

588

jQuery: Get data via Ajax

06.05.2013 03:14 TestUser jQuery 0 Comments

Get some data via Ajax, calling to a php-script and receiving a data. ... Reveal Code

$.ajax({
    url: "ajax.php",
    type: "POST",
    data: "id=" + id_value + "&mode=" + mode_value,
    cache: false,
    success: function(data) {
        $('#ajax_result').html($.trim(data))
    }
});

461

SQL: Select Duplicates

24.09.2013 05:24 stalin SQL 0 Comments

Select Duplicates ... Reveal Code

select field1,field2,field3, count(*)
  from table_name
  group by field1,field2,field3
  having count(*) > 1

677

JavaScript: Declension of number (Склонение числительных)

13.05.2013 14:03 Shara JavaScript 0 Comments

Example http://jsfiddle.net/v5nWh/ ... Reveal Code

// declension of number
function declOfNum(number, titles) {
    cases = [2, 0, 1, 1, 1, 2];
    return titles[ (number%100>4 && number%100<20)? 2 : cases[(number%10<5)?number%10:5] ];
}

declOfNum(number, ['Число', 'Числа', 'Чисел']);

354

Location:	Prague, Czech Republic
Website:	https://snippets.pro
Has joined us:	5th May 2013, 04:57
Last visit:	18th October 2013, 00:53
Profile views:	1,661

Have a Snippet?

RedOctober

687