function build($argv) { global $_plugin; global $success; global $error; global $errors; prompt('WARNING: Building fixtures clear all data from your table; are you sure you want to do this?') or $error = $errors['aborted']; if (!$error) { require_once $_plugin['dir']['fixtures'] . $argv[3] . '.php'; # Let's get connected! db_connect(); use_db(); # Truncate table. echo 'Truncating ' . $argv[3] . ' table...' . "\n\n"; $query = mysql_query('TRUNCATE ' . $argv[3]); foreach ($_fixtures as $_fixture) { $query = ' INSERT INTO ' . $argv[3] . ' (' . implode(',', array_keys($_fixture)) . ') VALUES (' . implode(',', array_values(enquote($_fixture))) . ') '; //add option to display this? echo 'Running the following query:'; echo "\n" . $query . "\n\n"; if (mysql_query($query)) { $success = 'fixtures for the table: ' . $argv[3] . ' have been succesfully built!'; } else { $error = mysql_error(); } } } }
function build($argv) { global $_plugin; global $success; global $error; global $errors; plugin_is_installed($_plugin['name']) or $error = $error['not_installed']; isset($argv[3]) or $error = $errors['usage']; prompt('WARNING: Building a table from a definition will clear all data from your table; are you sure you want to do this?') or $error = $errors['aborted']; if (!$error) { # Let's get connected! db_connect(); use_db(); # Get definition config. $_definition = get_plugin_config('definitions'); # At this point, $_definition is overwritten with the defined $_definition in the require. require $_definition['dir']['definitions'] . $argv[3] . '.php'; # Drop the current table. Should really be its own script, no? # Check for table existence. if (mysql_query('SELECT * FROM ' . $_definition['name'])) { mysql_query('DROP TABLE ' . $_definition['name']); } # Let's build this noise! $query = 'CREATE TABLE ' . $_definition['name'] . '(' . "\n"; # We'll foreach through the table def and build the SQL string as needed. foreach ($_definition['fields'] as $field => $data) { $query .= $field . ' ' . strtoupper($data['type']); if ($data['length']) { $query .= '(' . $data['length'] . ')'; } if (!$data['null']) { $query .= ' NOT NULL'; } if ($data['auto_inc']) { $query .= ' AUTO_INCREMENT'; } # Add a comma and line break. $query .= ",\n"; # Output relational data. if (isset($data['relation'])) { $query .= 'INDEX ' . $data['relation']['name'] . '_rel(' . $data['relation']['name'] . '_id)'; $query .= ',' . "\n" . 'FOREIGN KEY(' . $data['relation']['name'] . '_id) REFERENCES ' . $data['relation']['name'] . '(id) ON DELETE CASCADE'; $query .= ",\n"; } } if ($_definition['primary']) { $query .= 'PRIMARY KEY(' . $_definition['primary'] . ')'; } # End query here. $query .= "\n" . ')'; //add option to display this! echo 'Executing the following query:' . "\n" . $query . "\n\n"; if (mysql_query($query)) { //$success = 'Created ' . $_definition['name'] . ' with the following query: ' . "\n" . $query; $success = 'Created "' . $_definition['name'] . '"'; } else { $error = mysql_error(); } } }
<?php require 'lib/system.config.php'; require 'lib/system.functions.php'; require 'user/plugins/functions/base/user.php'; db_connect(); use_db(); $user = new user_base(1); //echo $user->get_name(); //echo "\n\n"; //echo $user->get_clan()->name; //echo "\n\n"; echo "\n\n"; $comments = $user->get_comments(); echo $comments[1]['comment']; echo "\n\n"; //print_r($clan); //echo $clan->name;