function create($name, $type, $version, $port, $path)
{
$q0 = get_link()->prepare('insert into ' . get_ini('BDD_PREFIX') . 'cmdb_db_instances (id_os,name,db_type,db_version,db_port,db_bin_path,audited,created_date,created_id,edited_date,edited_id,deleted_date,deleted_id) VALUES (:id_os,:name,:db_type,:db_version,:db_port,:db_bin_path,:audited,:created_date,:created_id,0,0,0,0)');
$q0->execute(array('id_os' => $this->idOs, 'name' => $name, 'db_type' => $type, 'db_version' => $version, 'db_port' => $port, 'db_bin_path' => $path, 'audited' => '-1', 'created_date' => time(), 'created_id' => $_SESSION['USER_ID']));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('cmdb_db_instances'), $this->getId($name));
return $this->getId($name);
}
function create($parentId, $name)
{
$q0 = get_link()->prepare('insert into ' . get_ini('BDD_PREFIX') . 'cmdb_environments (id_parent,name,created_date,created_id,edited_date,edited_id,deleted_date,deleted_id) VALUES (:id_parent,:name,:created_date,:created_id,0,0,0,0)');
$q0->execute(array('id_parent' => $parentId, 'name' => $name, 'created_date' => time(), 'created_id' => $_SESSION['USER_ID']));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('cmdb_environments'), $this->getId($name));
return $this->getId($name);
}
function create($type, $port)
{
$q0 = get_link()->prepare('insert into ' . get_ini('BDD_PREFIX') . 'cmdb_dev_os (id_device,os_type,os_name,os_port,os_install_date,os_last_boot_time,os_memory_size,created_date,created_id,edited_date,edited_id,deleted_date,deleted_id) VALUES (:id_device,:type,\'\',:port,0,0,0,:created_date,:created_id,0,0,0,0)');
$q0->execute(array('id_device' => $this->idDevice, 'type' => $type, 'port' => $port, 'created_date' => time(), 'created_id' => $_SESSION['USER_ID']));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('cmdb_dev_os'), $this->getId($type, $port));
return $this->getId($type, $port);
}
function create($name, $icon)
{
$q0 = get_link()->prepare('INSERT INTO ' . get_ini('BDD_PREFIX') . 'core_user_auth_methods (name,icon,created_id,created_date,edited_id,edited_date,deleted_id,deleted_date) VALUES (:name,:icon,:created_id,:created_date,0,0,0,0)');
$q0->execute(array('name' => $name, 'icon' => $icon, 'created_id' => $_SESSION['USER_ID'], 'created_date' => time()));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('core_user_auth_methods'), $this->getId($name));
// Return the id of this new group
return $this->getId($name);
}
function create($idPlugin, $page)
{
$q0 = get_link()->prepare('INSERT INTO ' . get_ini('BDD_PREFIX') . 'core_jobs (id_plugin,page,last_run_pid,last_run,created_id,created_date,edited_id,edited_date,deleted_id,deleted_date) VALUES (:id_plugin,:page,0,0,:created_id,:created_date,0,0,0,0)');
$q0->execute(array('id_plugin' => $idPlugin, 'page' => $page, 'created_id' => $_SESSION['USER_ID'], 'created_date' => time()));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('core_job'), $this->getId($idPlugin, $page));
// Return the id of this new group
return $this->getId($idPlugin, $page);
}
function create($name, $version)
{
$q0 = get_link()->prepare('INSERT INTO ' . get_ini('BDD_PREFIX') . 'core_plugins (name,version,activated,created_id,created_date,edited_id,edited_date,deleted_id,deleted_date) VALUES (:name,:version,0,:created_id,:created_date,0,0,0,0)');
$q0->execute(array('name' => $name, 'version' => $version, 'created_id' => $_SESSION['USER_ID'], 'created_date' => time()));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('core_plugins'), $this->getId($name));
// Return the id of this new page
return $this->getId($name);
}
function print_table_id($length = 8)
{
echo get_table_id($length);
}
function charger_args($args)
{
$args = explode('/', $args);
// cas ~id_auteur/
if ($args[0][0] == '~') {
$table = 'spip_auteurs';
$colid = array('id_auteur');
list($auteur, $colonne) = explode('@', array_shift($args));
if (count($auteur) > 1) {
$id = substr($auteur, 1);
} else {
$id = $GLOBALS['auteur_session'] ? $GLOBALS['auteur_session']['id_auteur'] : '';
}
// cas table:id/
// peut etre table:id:id/ si la table a 2 cles
} else {
list($table, $id) = explode(':', array_shift($args), 2);
list($table, $colonne) = explode('@', $table);
list($table, $colid) = get_table_id($table);
}
$this->param->cfg_id = $id;
$this->param->colonne = $colonne ? $colonne : 'cfg';
$this->param->table = $table ? $table : 'spip_auteurs';
$this->param->nom = array_shift($args);
if ($champ = array_pop($args)) {
$this->champs = array($champ => true);
}
$this->param->casier = implode('/', $args);
// renseigner les liens id=valeur
$id = explode(':', $id);
foreach ($colid as $n => $c) {
if (isset($id[$n])) {
$this->_id[$c] = $id[$n];
}
}
return true;
}
break;
case 'get_menu':
$keyword = $_GET['keyword'];
$data['menu_id'] = select_menu($keyword);
return $data;
break;
case 'delete_history':
$id = get_isset($_GET['id']);
$table_id = get_isset($_GET['table_id']);
delete_history($id);
header("Location: transaction_new.php?table_id={$table_id}&did=3");
break;
case 'delete_item':
$id = get_isset($_GET['id']);
$member_id = get_member_id($id);
$table_id = get_table_id($id);
delete_item($id);
header("Location: transaction_new.php?table_id={$table_id}&member_id={$member_id}&did=3");
break;
case 'delete_item_edit':
$id = get_isset($_GET['id']);
$table_id = get_isset($_GET['table_id']);
delete_item_edit($id);
header("Location: transaction_new.php?page=list_edit&table_id={$table_id}");
break;
case 'list_history':
//get_header($title);
$table_id = get_isset($_GET['table_id']);
$check_table = check_table($table_id);
if ($check_table > 0) {
$query_history = select_history($table_id);
</form>
';
$hint = array('Here you can change your personal information. Remember to press the \'Update\' button to store the changes.', 'Leave all password fields blank to keep your old password.');
if ($CFG_USEEMAIL) {
$hint[] = 'Enter a valid email address if you would like to be notified when your opponent makes a move. Leave blank otherwise.';
}
$html = get_item($contents, $hint);
break;
// ====================================================
// ====================================================
case 'admin':
if (true != $_SESSION['is_admin']) {
header('Location: index.php');
exit;
}
$table_id = get_table_id();
$contents .= '
<form name="Admin" action="index.php?page=admin" method="post">
<h2>Administration</h2>
Click the relevant box next to each user, then click on \'Admin\' below to affect those changes.
<table class="sort-table" id="' . $table_id . '">
<thead>
<tr>
<th>ID</th>
<th>Username</th>
<th>First</th>
<th>Last</th>
<th>Email</th>
<th>Create Date</th>
<th>Reset Pass ?</th>
<th>Admin ?</th>
function charger_args($args)
{
list($table, $id) = explode(':', $args, 2);
list($table, $colonne) = explode('@', $table);
list($table, $colid) = get_table_id($table);
$this->param->cfg_id = $id;
$this->param->champs = $colonne ? array($colonne => true) : '';
$this->param->table = $table ? $table : 'spip_cfg';
// renseigner les liens id=valeur
$id = explode(':', $id);
foreach ($colid as $n => $c) {
if (isset($id[$n])) {
$this->_id[$c] = $id[$n];
}
}
return true;
}
function user($id)
{
$this->id = $id;
// Get the user informations
$q0 = get_link()->prepare("SELECT \n\t\t\t\t\t\t\t\t\tusr.id AS ID,\n\t\t\t\t\t\t\t\t\tusr.name AS NAME,\n\t\t\t\t\t\t\t\t\tusr.avatar AS AVATAR,\n\t\t\t\t\t\t\t\t\tusr.mail AS MAIL,\n\t\t\t\t\t\t\t\t\tobj.id AS OBJECTID,\n\t\t\t\t\t\t\t\t\tusr.created_date AS CREATED_DATE,\n\t\t\t\t\t\t\t\t\tusr.created_id AS CREATED_ID,\n\t\t\t\t\t\t\t\t\tusr.edited_date AS EDITED_DATE,\n\t\t\t\t\t\t\t\t\tusr.edited_id AS EDITED_ID,\n\t\t\t\t\t\t\t\t\tusr.deleted_date AS DELETED_DATE,\n\t\t\t\t\t\t\t\t\tusr.deleted_id AS DELETED_ID\n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t" . get_ini('BDD_PREFIX') . "core_users usr,\n\t\t\t\t\t\t\t\t" . get_ini('BDD_PREFIX') . "core_objects obj\n\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\tusr.id=obj.id_ext AND\n\t\t\t\t\t\t\t\t\tobj.id_table=:id_table AND\n\t\t\t\t\t\t\t\t\tobj.deleted_date=0 AND\n\t\t\t\t\t\t\t\t\tusr.id=:id");
$q0->execute(array('id' => $id, 'id_table' => get_table_id('core_users')));
$r0 = $q0->fetch(PDO::FETCH_OBJ);
if (isset($r0->ID)) {
$this->name = _($r0->NAME);
$this->avatar = $r0->AVATAR;
$this->mail = $r0->MAIL;
$this->objectId = $r0->OBJECTID;
$this->createdDate = $r0->CREATED_DATE;
$this->createdID = $r0->CREATED_ID;
$this->editedDate = $r0->EDITED_DATE;
$this->editedId = $r0->EDITED_ID;
$this->deletedDate = $r0->DELETED_DATE;
$this->deltedId = $r0->DELETED_ID;
// Map user groups and get the object id
$this->groupIdArray = array();
$this->groupObjectIdArray = array();
$q1 = get_link()->prepare("SELECT \n\t\t\t\t\t\t\t\t\t\tobj.id AS OBJECTID,\n\t\t\t\t\t\t\t\t\t\tmap.group_id AS GROUPID\n\t\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t" . get_ini('BDD_PREFIX') . "core_groups_users_map map,\n\t\t\t\t\t\t\t\t\t\t" . get_ini('BDD_PREFIX') . "core_objects obj\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tobj.deleted_date=0 AND\n\t\t\t\t\t\t\t\t\t\tmap.deleted_date=0 AND\n\t\t\t\t\t\t\t\t\t\tmap.user_id = :id AND\n\t\t\t\t\t\t\t\t\t\tmap.group_id = obj.id_ext AND\n\t\t\t\t\t\t\t\t\t\tobj.id_table = :id_table\n\t\t\t\t\t\t\t\t\t");
$q1->execute(array('id' => $this->id, 'id_table' => get_table_id('core_groups')));
while ($r1 = $q1->fetch(PDO::FETCH_OBJ)) {
array_push($this->groupIdArray, $r1->GROUPID);
array_push($this->groupObjectIdArray, $r1->OBJECTID);
}
$q1->closeCursor();
} else {
if ($_SESSION['USER_ID'] == $id) {
unset($_SESSION);
session_destroy();
// TODO add log management
echo 'There is something wrong with your account. Try to refresh the page then contact your administator.';
exit(100);
} else {
// TODO add log management
echo 'The user does not exist.';
exit(100);
}
}
$q0->closeCursor();
}
function get_game_table($label, $no_data_label, $data, $type = 'full')
{
global $mysql;
global $CFG_CHESS960, $CFG_LONGDATE;
if (!is_array($data) || 0 == count($data)) {
$html = '<div class="notable">' . $no_data_label . '</div>';
} else {
$sort_c960 = $CFG_CHESS960 ? ' , StringCI' : '';
$sort_finished = 'finished' == $type ? ' , StringCI' : '';
$sort_invite = 'invite' == $type ? ' , None' : ' , LongDate';
$sort_moves = 'invite' == $type ? ' , StringCI' : ' , Number';
$sort_gameid = 'invite' == $type ? '' : 'Number , ';
$sort = $sort_gameid . 'StringCI , StringCI , StringCI ' . $sort_moves . $sort_c960 . $sort_finished . ' , LongDate ' . $sort_invite;
call($sort);
$table_id = get_table_id();
$link_table = 'invite' != $type ? ' link-table' : '';
$html = '<table class="sort-table' . $link_table . '" id="' . $table_id . '">
<caption>' . $label . '</caption>
<thead>
<tr>
';
if ('invite' != $type) {
$html .= '<th title="Game ID Number">Game</th>';
}
$html .= '
<th title="White\'s username">White</th>
<th title="Black\'s username">Black</th>
<th title="Who\'s turn it is">Turn</th>
';
if ('invite' != $type) {
$html .= '<th title="Moves">Moves</th>';
} else {
$html .= '<th title="Status">Status</th>';
}
if ($CFG_CHESS960) {
$html .= '<th title="Game Type">Type</th>';
}
if ('finished' == $type) {
$html .= '<th title="Game Result">Result</th>';
}
$html .= '
<th title="Start Date of the Game">Start Date</th>
';
if ('invite' != $type) {
$html .= '<th title="Date / Time of Last Move">Last Move</th>';
} else {
$html .= '<th title="Action">Action</th>';
}
$html .= '
</tr>
</thead>
<tbody>
';
$i = 0;
foreach ($data as $game) {
// we need some default values for some variables
$myturn = false;
$white = '';
$black = '';
$curMove = 0 == $game['num_moves'] % 2 ? 'white' : 'black';
switch ($type) {
case 'mine':
$link = ' onclick="loadGame(' . $game['g_id'] . ');"';
// based on number of moves, figure out who's turn it is
$color = $game['g_white_player_id'] == $_SESSION['player_id'] ? 'white' : 'black';
if ($curMove == $color) {
$myturn = true;
}
break;
case 'others':
$link = ' onclick="watchGame(' . $game['g_id'] . ');"';
break;
case 'finished':
$link = ' onclick="watchGame(' . $game['g_id'] . ');"';
if ($game['g_white_player_id'] == $_SESSION['player_id']) {
$link = ' onclick="loadGame(' . $game['g_id'] . ');"';
$white = ' class="notice"';
} elseif ($game['g_black_player_id'] == $_SESSION['player_id']) {
$link = ' onclick="loadGame(' . $game['g_id'] . ');"';
$black = ' class="notice"';
}
if (is_null($game['g_game_message'])) {
$result = '';
} else {
if ('Draw' == $game['g_game_message']) {
$result = '½-½';
} elseif ('Player Resigned' == $game['g_game_message']) {
$result = 'white' == $game['g_message_from'] ? '0-1' : '1-0';
$result .= ' <abbr title="Resignation">R</abbr>';
} elseif ('Checkmate' == $game['g_game_message']) {
$result = 'white' == $game['g_message_from'] ? '1-0' : '0-1';
$result .= ' <abbr title="Checkmate">CM</abbr>';
} else {
$result = '';
}
}
break;
case 'invite':
$link = '';
$from = $game['white_username'] == $_SESSION['username'] ? 'white' : 'black';
$status = substr($game['g_game_message'], strrpos(trim($game['g_game_message']), ' ') + 1);
$status = 'Declined' == $status ? '<span class="notice">' . $status . '</span>' : $status;
// based on which it is, outvite or invite, make the buttons
if (isset($game['invite'])) {
$buttons = '
<input class="tblbutton" type="button" value="Accept" onclick="sendresponse(\'accepted\',\'' . $from . '\',' . $game['g_id'] . ')" />
<input class="tblbutton" type="button" value="Decline" onclick="sendresponse(\'declined\',\'' . $from . '\',' . $game['g_id'] . ')" />
';
} else {
$buttons = '
<input class="tblbutton" type="button" value="Withdraw" onclick="withdrawrequest(' . $game['g_id'] . ')" />
';
}
break;
}
// end type switch
$alt = 0 == $i % 2 ? true : false;
call($myturn);
$class = '';
if ($myturn || $alt) {
$class = ' class="';
if ($myturn && $alt) {
$class .= 'myturn alt';
} elseif ($alt) {
$class .= 'alt';
} else {
$class .= 'myturn';
}
$class .= '"';
}
$html .= "<tr{$link}{$class}>\n";
if ('invite' != $type) {
$html .= "\t<td class=\"numeric\">{$game['g_id']}</td>\n";
}
$html .= "\t<td{$white}>{$game['white_username']}</td>\n";
$html .= "\t<td{$black}>{$game['black_username']}</td>\n";
$html .= "\t<td>" . ucfirst($curMove) . "</td>\n";
if ('invite' != $type) {
$html .= "\t<td class=\"numeric\">" . floor($game['num_moves'] / 2) . "</td>\n";
} else {
$html .= "\t<td>" . $status . "</td>\n";
}
if ($CFG_CHESS960) {
$gametype = 518 != $game['g_id960'] ? 'C960' : 'Normal';
$html .= "\t<td>{$gametype}</td>\n";
}
if ('finished' == $type) {
$html .= "\t<td>{$result}</td>\n";
}
$html .= "\t<td class=\"date\">" . date($CFG_LONGDATE, $game['u_date_created']) . "</td>\n";
if ('invite' != $type) {
$html .= "\t<td class=\"date\">" . date($CFG_LONGDATE, $game['u_last_move']) . "</td>\n";
} else {
$html .= "\t<td class=\"buttons\">" . $buttons . "</td>\n";
}
$html .= '</tr>';
++$i;
}
$html .= '
</tbody>
</table>
';
$html .= get_sorttable_script($table_id, $sort);
}
return $html;
}
