Smash phoophS

smashphoops.33 pt4

2010-12-09T16:50:00.001-08:00

more dubstep!
http://goo.gl/I9x6e

19 - fine without you - Djmee remix
20 - blame ft. Camillia Marie - Star - Dr. P remix <- this tune is of the nuts hook.
21 - scary monsters and sprites - noisia
22 - kill everybody - bare noise remix
23 - piano Tune - bar 9
24 - shot me down - bare
25 - f double u - cookie monster
26 - power skism

smashphoops.33 pt2.

2010-12-02T17:01:00.000-08:00

Part 2 of 3 -> http://goo.gl/gLK2L

10. Ur dream - scream
11. all in - Dubba Jonny
12. afro jack ft. eva simmons - adam f. remix
13. i remember - deadmau5 caspa remix
14. chewie center - subscape ?
15. paranoid - dansette junior
16. follow - crystal fighters
17. delerium - silence - high rankin
18. haunt you - flux pavilion

smashphoops.33

2010-11-26T07:26:00.000-08:00

Gotcha!
+ dubstep
the originals for smashpooped.33. part 1 : http://goo.gl/gV1qQ
+ kion and murda - number 1 sound
+ flux pavilion - excuse me
+ dubtek - western dub
+ sukh knight - jewel theif
+ jakwob remix (katie melua) - the flood
+ john legend & magnetic man - getting nowhere
+ true tiger remix (macy gray) - lately
+ caspa remix (miike snow) - black and blue
+ a1 bassline & tek one - arrakis 97

getIdInsert

2010-04-13T19:26:00.000-07:00


$loadFile = "bxsc.trans.cards.dat";
$dbconn   = array("user"=>"djmornyc","host"=>"localhost","dbname"=>"mor_db");

if(!$conn   = getConn($dbconn))
        echo "connection failed\n";

$fp   = fopen($loadFile,"r");
$null = pg_query($conn,"BEGIN");

while($data = fgets($fp,4096))
{
        $cardnum = trim($data);
        $resInsert = pg_query($conn,getSqlInsertCard($cardnum));
        var_dump(pg_fetch_all($resInsert))."\n";
}

$null = pg_query($conn,"COMMIT");
$null = fclose($fp);
$null = pg_close($conn);

function getSqlInsertCard($cardnum)
{
        return "insert into bxsc_cards (cardnum) 
                        select '{$cardnum}' where not exists (select cardnum from bxsc_cards where cardnum = '$cardnum') returning id";

}

function getConn($dbconn)
{
$connStr = "";

        foreach($dbconn as $key => $value)
                $connStr.=" {$key}={$value} ";

return pg_connect($connStr);
}

?>

plpgsql style

2009-11-16T19:19:00.000-08:00



CREATE OR REPLACE function _getSchema(_table text) RETURNS integer AS $$

DECLARE

 _record RECORD;
 _column TEXT;
 _type TEXT;

BEGIN
 RAISE NOTICE 'select ';

FOR _record in 
 SELECT column_name,data_type from information_schema.columns where table_name = _table 
 
 LOOP

 _column := _record.column_name;
 _type := _record.data_type;

  IF
   _record.data_type = 'text'
  THEN
   RAISE NOTICE 'count(distinct(%)) as dist_%,', _column, _column;
  ELSIF
   _record.data_type = 'numeric' or _record.data_type = 'integer'
  THEN
   RAISE NOTICE 'sum (%) as sum_%,', _column, _column;
  END IF;

END LOOP;

 RAISE NOTICE 'count (*) as rows';
 RAISE NOTICE 'from % ', _table; 
 

 RETURN 0;

END;
$$ LANGUAGE 'plpgsql';

get basic stats from a table.

2009-11-14T11:42:00.001-08:00


        $arPgUser = array("user"=> "postgres","host"=>"localhost","dbname"=>"dev","password" => "i1m2a3p4o5o6p7e8r9");
        $connStr  = getConnStr($arPgUser);
        $conn     = pg_connect($connStr);
        $table    = "books";

        $sqlGetSchema = "select column_name,data_type from information_schema.columns where table_name = '{$table}'";
        $res          = pg_fetch_all(pg_query($conn,$sqlGetSchema));
        $columns      = array_map("sqlFieldStats",($res));

        $sqlBuildStats= sqlBuildStats($columns,$table);
        $res          = pg_fetch_all(pg_query($conn,$sqlBuildStats));
        print_r($res);

        pg_close($conn);

function sqlBuildStats($columns,$table){

        $sqlColumns = implode(",\n",$columns);
        $sql = "
        select
                $sqlColumns
        from
                $table
        ";
        echo "{$sql}\n";

return trim($sql);
}

function sqlFieldStats($arSchema){

        switch($arSchema['data_type']){

                case "text":
                        return "count(distinct({$arSchema['column_name']})) as dist_{$arSchema['column_name']}";
                break;

                case "numeric":
                        return "sum({$arSchema['column_name']}) as sum_{$arSchema['column_name']}";
                break;
        }
}


function getConnStr($arPgUser){

        $connStr = "";
        foreach ($arPgUser as $key => $value)
                $connStr.= "{$key} = {$value} ";

return $connStr;
}

Check the sound.

2009-10-02T20:19:00.001-07:00

poop!

What an electro day.

2009-02-16T14:12:00.000-08:00


A mash of 
    Tanya Stephen's - What a day
        and
          dutty dubz - Electro

Download

Smoking Wet.

2009-02-16T14:06:00.000-08:00


My Dnb playlist mixed.

(00:00) . Street Life : chase and status
(03:07) . Believe : chase and status
(06:18) . Take me away : chase and status
(11:05) . Can it be so simple : concept and shnek
(13:28) . Rumors : mutt
(15:43) . 2 strike back : zero tolerance and beta
(18:21) . Supastar : concept and shnek
(21:39) . Bedford avenue (feat dj. crum) concept and shnek
(24:35) . Try to get away : dj clart
(28.50) . These words : dj clart
(31:47) . The motions : mutt
(36:02) . La cinta : Utah jazz
(39.21) . Funkless life : Utah jazz
(41.33) . Feeling inside  : Utah jazz
(43:51) . In love (feat jenna) g : chase and status
(47:57) . Session and superking : Walk away
(51:10) . Soul musiq (feat. youngman) : atlantic connection
(54:18) . Here for you : Bassface sascha and franksen

Download -> http://www.sendspace.com/file/ay6rnl

The system told me.

2008-11-16T10:40:00.000-08:00


An stepping tune 
        of Joker's - Stuck in the system
  and the Killer's - Somebody told me.

Download