type.php
29 lines
| 683 B
| text/x-php
|
PhpLexer
/ include / type.php
| r1 | <?php | |||
| /* Types */ | ||||
| function get_typeByID( $id ) { | ||||
| r34 | global $dbConnection; | |||
| r1 | $id = (int)$id; | |||
| r34 | $stmt = $dbConnection->executeQuery('SELECT id, name, description FROM strip_t WHERE id = ?', array($id)); | |||
| $r = $stmt->fetch(); | ||||
| $r->meta = $dbConnection->fetchAll('SELECT meta AS id FROM meta WHERE type = ?', array($id)); | ||||
| r1 | return $r; | |||
| } | ||||
| function get_allTypes() { | ||||
| r34 | global $dbConnection; | |||
| $stmt = $dbConnection->executeQuery('SELECT id, name, description, meta FROM strip_t'); | ||||
| return $stmt->fetch(); | ||||
| r1 | } | |||
| function get_allMetaTypes() { | ||||
| r34 | global $dbConnection; | |||
| return $dbConnection->fetchAll('SELECT id, name FROM meta_t'); | ||||
| r1 | } | |||
| function _getMetaNameFromObject($obj) { | ||||
| return $obj->name; | ||||
| } | ||||
| r7 | ?> | |||
