Setup:
$ mongo
> use pubsub
> db.createCollection('messages', { capped: true, size: 100000 })
> db.messages.insert({})
CREATE TABLE `isimler` ( | |
`id` int(10) NOT NULL AUTO_INCREMENT, | |
`ad` varchar(255) COLLATE utf8_bin NOT NULL, | |
`cinsiyet` varchar(50) COLLATE utf8_bin NOT NULL, | |
PRIMARY KEY (`id`), | |
UNIQUE KEY `ad` (`ad`), | |
KEY `cinsiyet` (`cinsiyet`) | |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | |
history|awk '{print $2}'|awk 'BEGIN {FS="|"} {print $1}'|sort|uniq -c|sort -r |
/* Simple Memcached in Javascript | |
* @Author: Sun, Junyi | |
* @Email: ccnusjy@gmail.com | |
* @Date: 2012-8-3 | |
*/ | |
var net = require('net'); | |
var store = {} | |
function handle_header(header,crlf_len){ | |
var tup = header.split(" ") |
CREATE TABLE `isimler` ( | |
`id` int(10) NOT NULL AUTO_INCREMENT, | |
`ad` varchar(255) COLLATE utf8_bin NOT NULL, | |
`cinsiyet` varchar(50) COLLATE utf8_bin NOT NULL, | |
PRIMARY KEY (`id`), | |
UNIQUE KEY `ad` (`ad`), | |
KEY `cinsiyet` (`cinsiyet`) | |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; | |
<!-- country codes (ISO 3166) and Dial codes. --> | |
<select name="countryCode" id=""> | |
<option data-countryCode="GB" value="44" Selected>UK (+44)</option> | |
<option data-countryCode="US" value="1">USA (+1)</option> | |
<optgroup label="Other countries"> | |
<option data-countryCode="DZ" value="213">Algeria (+213)</option> | |
<option data-countryCode="AD" value="376">Andorra (+376)</option> | |
<option data-countryCode="AO" value="244">Angola (+244)</option> | |
<option data-countryCode="AI" value="1264">Anguilla (+1264)</option> | |
<option data-countryCode="AG" value="1268">Antigua & Barbuda (+1268)</option> |
<?php | |
function get_ip_address() { | |
$ip_keys = array('HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR', 'HTTP_X_FORWARDED', 'HTTP_X_CLUSTER_CLIENT_IP', 'HTTP_FORWARDED_FOR', 'HTTP_FORWARDED', 'REMOTE_ADDR'); | |
foreach ($ip_keys as $key) { | |
if (array_key_exists($key, $_SERVER) === true) { | |
foreach (explode(',', $_SERVER[$key]) as $ip) { | |
// trim for safety measures | |
$ip = trim($ip); | |
// attempt to validate IP | |
if (validate_ip($ip)) { |
This gist assumes:
DROP TABLE IF EXISTS `pk_il`; | |
CREATE TABLE `pk_il` ( | |
`il_id` int(2) NOT NULL COMMENT 'plaka kodu', | |
`il_adi` varchar(255) NOT NULL, | |
PRIMARY KEY (`il_id`), | |
KEY `il_adi` (`il_adi`) USING BTREE | |
) ENGINE=MyISAM; | |
-- ---------------------------- |