Reo fucked around with this message at 18:38 on Mar 19, 2011

Reo fucked around with this message at 19:52 on Mar 19, 2011

SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '$database' AND TABLE_NAME = '$table' AND COLUMN_NAME = '$field'

ENUM ('Lemons','Apples','Houston, we have a problem')

array( 'Lemons',
       'Apples',
       'Houston',
       ' we have a problem'
       )

function get_enum_list ($database, $table, $field) {
    $sql = "SELECT
                COLUMN_TYPE
            FROM
                INFORMATION_SCHEMA.COLUMNS
            WHERE
                TABLE_SCHEMA = '$database' AND
                TABLE_NAME = '$table' AND
                COLUMN_NAME = '$field'";
    $query = $this->db->query($sql);
    if ($query) {
        $row = $query->row();
        $list = substr($row->COLUMN_TYPE, 6, -2);
        return explode("','", $list);
    } else {
        return FALSE;
    }
}

Hammerite fucked around with this message at 19:27 on Mar 20, 2011

========
GAME
========
game_id
round_id
venue_id
game_date

========
TEAMGAME
========
tega_id
team_id
game_id
tega_home
tega_score

========
TEAM
========
team_id
team_name

========
GAME
========
game_id
game_date
teams
- ['home']
-- ['team_id']
-- ['team_name']
-- ['score']
- ['away']
-- ['team_id']
-- ['team_name']
-- ['score']
venue
- ['venue_id']
- ['venue_name']

putin is a cunt fucked around with this message at 03:02 on Mar 23, 2011

GAME
====
id (int, primary key)
venue (int, is the VENUE id)
homeTeam (int, is the home team's id)
awayTeam (int, is a team id)
RoundId (int? not sure what this is)
date_played (datetime)
homeScore (int (or float if you have half points =))
awayScore (int)

VENUE
===
id (int, primary key)
name (varchar)

TEAM
===
id (int, primary key)
name (varchar)

<?
class Team extends CI_Model {

    var $name   = '';

    function __construct()
    {
        parent::__construct();
    }

   function get_team_list()
   {
      $query = $this->db->get('teams');
      return $query->result();
   }
    
    function add_team()
    {
        $this->name   = $_POST['name']; // lol, security
        $this->db->insert('teams', $this);
    }

    function get_team_name($id)
    {
       $query = $this->db->select('name')->where('id', $id)->get('teams');
        return $query->result();
    }

}
?>

Lumpy fucked around with this message at 05:47 on Mar 23, 2011

The
Big
Red
House
The Big
Big Red
Red House
The Big Red
Big Red House
The Big Red House

cLin fucked around with this message at 00:17 on Mar 25, 2011

$data = file_get_contents(FILE_PATH.$fname);

header('Content-type: '.getFileExtension($fname));
header("Content-Disposition: attachment; filename=$fname");
echo $data;

Elias_Maluco fucked around with this message at 03:45 on Mar 25, 2011

<?
    function array_power_set(Array $input) {
    
        $output = array(array());
        
        foreach($input as $element) {
            foreach($output as $combination) {
                array_push($output, array_merge($combination, array($element)));
            }
        }        
        
        return $output;
    
    }
    
    function dump(Array $input) {
        foreach($input as $combination) {
            echo implode(" ", $combination)."\n";
        }
    }


    $input = "The Big Red House";
    
    $words = explode(' ', $input);
    $output = array_power_set($words);
    
    dump($output);
?>

The
Big
The Big
Red
The Red
Big Red
The Big Red
House
The House
Big House
The Big House
Red House
The Red House
Big Red House
The Big Red House

KuruMonkey fucked around with this message at 11:26 on Mar 25, 2011

Xenos fucked around with this message at 14:28 on Mar 25, 2011

<?
    function array_contiguous_subselections(Array $data) {
        $output = array();
        $limit = count($data);
        for($i=1; $i<=$limit; $i++) {
            for($j=0; $j<=($limit-$i); $j++) {
                $output[] = array_slice($data, $j, $i);
            }
        }
        return $output;
    }
?>

KuruMonkey fucked around with this message at 17:19 on Mar 25, 2011

Hammerite fucked around with this message at 16:10 on Mar 26, 2011

function idleping() {
		$sesid = $_SESSION['id'];
		SQL::dbconnect();
		$pingvar = time();
		$pingquery = 'UPDATE chat.userlist SET ping="' . $pingvar . '" WHERE sessionid="' . $sesid . '"';
		mysql_query ($pingquery);
		SQL::dbclose();
	}

function regcheck() {
		SQL::dbconnect();
		$xtime = time();
		$xtime -= 10;
		$checkarray =  mysql_query('SELECT * from chat.userlist WHERE ping <' . '"' . $xtime . '"');
		while ($tmpar = mysql_fetch_array($checkarray)) {
			$exited = '<span class="blue"> *** ' . $tmpar[1] . ' has left the room<br /></span>';
			mysql_query("INSERT INTO chat.chatlog(chat) VALUES('$exited')");
			$delq = 'DELETE FROM chat.userlist WHERE username = \'' . $tmpar[1] . '\'';
			mysql_query($delq);
		}
		SQL::dbclose();
	}

revmoo fucked around with this message at 04:27 on Mar 28, 2011