function node_AddMeta($id_a, $id_b, $type, $subtype, $data)
{
db_Connect();
db_Query("INSERT `" . CMW_TABLE_NODE_META . "` (" . "`id_a`," . "`id_b`," . "`type`," . "`subtype`," . "`data`" . ") " . "VALUES (" . $id_a . "," . $id_b . "," . "\"" . $type . "\"," . "\"" . $subtype . "\"," . "\"" . $data . "\"" . ");");
// TODO: do something on db_query error
return db_GetId();
}
function love_Remove(&$node, &$user = 0, &$ip = '0.0.0.0')
{
db_Connect();
db_Query("DELETE FROM `" . CMW_TABLE_NODE_LOVE . "` WHERE " . "`node`=" . $node . " AND " . "`user`=" . $user . " AND " . "`ip`=INET_ATON('" . $ip . "')" . ";");
// TODO: do something on db_query error
return !empty(db_AffectedRows());
}
function star_Remove(&$node, &$user)
{
db_Connect();
db_Query("DELETE FROM `" . CMW_TABLE_NODE_STAR . "` WHERE " . "`node`=" . $node . " AND " . "`user`=" . $user . ";");
// TODO: do something on db_query error
return !empty(db_AffectedRows());
}
function _global_Set($key, $value)
{
return db_Query("INSERT " . SH_TABLE_PREFIX . SH_TABLE_GLOBAL . " (\n\t\t\t`key`, `value`, `timestamp`\n\t\t)\n\t\tVALUES ( \n\t\t\t?, ?, NOW()\n\t\t);", $key, $value);
}
function _config_Set($key, $value)
{
return db_Query("INSERT " . CMW_TABLE_CONFIG . " (\n\t\t\t`key`, `value`, `timestamp`\n\t\t)\n\t\tVALUES ( \n\t\t\t?, ?, NOW()\n\t\t);", $key, $value);
}
function user_Add($id, $mail, $password)
{
db_Connect();
$password_hash = user_HashPassword($password);
db_Query("INSERT `" . CMW_TABLE_USER . "` (" . "`node`," . "`mail`," . "`hash`" . ") " . "VALUES (" . $id . "," . "\"" . $mail . "\"," . "\"" . $password_hash . "\"" . ");");
// TODO: do something on db_query error
return db_GetId();
}
function setData()
{
$value = $_REQUEST['value'];
$settingName = $_REQUEST['settingName'];
db_Query('UPDATE settings SET value="' . $value . '" WHERE name="' . $settingName . '"');
}
$content .= $rTotalBudget->sum;
} else {
$content .= $rGetAccounts->budget;
}
}
$content .= "</td></tr>";
}
// End while rGetAccounts
$content .= "<tr><td></td><td></td><td></td><td><b>{$total_budget}</b></td></tr>";
$content .= "</table>";
if ($acl == 'Admin') {
$content .= '<p>';
$content .= "<form method=POST action=?module=economy&action=addAccount>";
$content .= "<select name='mainAccount'>";
$content .= "<option value='0'>" . lang("Main account", "economy") . "</option>";
$qGetMainAccounts = db_Query("SELECT * FROM " . $sql_prefix . "_economy_accounts WHERE mainAccountNumber = 0 ORDER BY accountnumber ASC");
while ($rGetMainAccounts = db_fetch($qGetMainAccounts)) {
$content .= "<option value='{$rGetMainAccounts->accountnumber}'>{$rGetMainAccounts->accountnumber} - {$rGetMainAccounts->accountText}";
$content .= "</option>\n";
}
// End while
$content .= "</select>\n\n";
$content .= "<br><input type=text name='accountnumber' size=5 value='100'> " . lang("Accountnumber", "economy");
$content .= "<br><input type=text name='budget' size=5 value=0> " . lang("Amount", "economy");
$content .= "<br><input type=text name='accounttext' size=25> " . lang("Account description", "economy");
$content .= "<br><input type=submit value='" . lang("New account", "economy") . "'>";
$content .= "</form>";
}
// End if acl==Admin
} elseif ($action == "addAccount") {
$accountnumber = $_POST['accountnumber'];
