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'];