function updateTable($inTableNode)
{
$myAttrList = $inTableNode->attributes();
$myTableName = $myAttrList["name"];
$myCmd = $myAttrList["command"];
echo "\n {$myCmd} table {$myTableName}";
$myRows = $inTableNode->xpath('Rows/Row');
$myRowCount = count($myRows);
if ($myRowCount > 0) {
foreach ($myRows as $myRow) {
if ($myCmd == "Delete") {
deleteRow($myTableName, $inTableNode, $myRow);
} else {
if (isRowFound($myTableName, $inTableNode, $myRow)) {
updateRow($myTableName, $inTableNode, $myRow);
} else {
insertRow($myTableName, $inTableNode, $myRow);
}
}
}
}
echo "\n------------------------------\n";
}
<?php
session_start();
$playlist_id = $_REQUEST['playlist_id'];
$content_id = $_REQUEST['content_id'];
$operation = $_REQUEST['operation'];
if (isset($_REQUEST['connection'])) {
$id_item = $_REQUEST['connection'];
}
if ($operation == 'add1') {
addToPlaylist($playlist_id, $content_id);
} else {
if ($operation == 'delete') {
deleteRow($playlist_id, $content_id);
} else {
if ($operation == 'moveUp') {
moveUp($playlist_id, $content_id, $id_item);
} else {
if ($operation == 'moveDown') {
moveDown($playlist_id, $content_id, $id_item);
}
}
}
}
function moveDown($playlist_id, $content_id, $id_item)
{
$isUp = false;
$servername = "localhost";
$username = "******";
$password = "******";
$dbname = "Doopy";
/**
* Expire an article
* @param integer ID of the article to expire
* @param integer ID of the level that will be expired
* @param integer ID of the variation to expire
*/
function expireArticle($articleId, $level, $variation)
{
global $db;
$articleIdTrans = translateState($articleId, $level, false);
clearArticleURL($articleIdTrans, $variation);
deleteRow("channel_articles", "ARTICLE_ID = {$articleIdTrans}");
expireCluster($articleId, $variation);
}
<?
include 'models/selects.php';
include 'models/deletes.php';
if(isset($_REQUEST['id'])){
if($_REQUEST['id'] == 'delete'){
$table = 'blog_form';
$where = 'id="'.$_REQUEST['id2'].'"';
$deleteData = deleteRow($table,$where,$db_location, $db_user,$db_pass,$db_db);
}
}
if(selectAll('blog_form',$db_location, $db_user,$db_pass,$db_db)){
$theData = selectAll('blog_form',$db_location, $db_user,$db_pass,$db_db);
foreach($theData as $value){
$ids[] = $value['id'];
$title[] = $value['title'];
}
}else{
$data['id'] = 'error';
}
?>
<div id="contact_container">
Admin Blog Page
<? if(isset($deleteData)){?>
<h2><?php
echo $deleteData;
?>
</h2>
<? }?>
<hr /><br />
/**
* Does nothing here. process must be done my developer.
*/
function process() {
global $page_state;
if ($page_state == "processing") {
$nextIndex = count($this->keys);
deleteRow($this->table, $this->row_identifier);
if (is_array($this->properties)) {
foreach ($this->properties as $key => $value) {
foreach ($value as $role) {
$is = $this->keys;
$is[$nextIndex][0] = $this->column2;
$is[$nextIndex][1] = $role;
$is[$nextIndex][2] = $this->column2_dt;
$is[$nextIndex + 1][0] = $this->column1;
$is[$nextIndex + 1][1] = $key;
$is[$nextIndex + 1][2] = $this->column1_dt;
$cs = new CreateSet($this->table);
for ($i = 0; $i < count($is); $i++) {
$cs->add($is[$i][0], $is[$i][1], $is[$i][2]);
}
$cs->execute();
}
}
}
}
}
/**
* @param $userid
* @param $weeklyid
* @return string
* This will check if a weekly id is still in use. If it is not, it will delete the weekly id.
*/
function checkIfWeeklyIdUsed($userid, $weeklyid)
{
$mysqli = new mysqli(Database::dbserver, Database::dbuser, Database::dbpass, Database::dbname);
$sql = "SELECT Count(WeeklyID) AS CountOfWeeklyID from tbl_time WHERE UserID = " . $userid . " AND WeeklyID = " . $weeklyid . " ";
$rs = $mysqli->query($sql);
while ($row = $rs->fetch_assoc()) {
$count = $row['CountOfWeeklyID'];
if ($count < 1) {
//we need to delete this weeklyid, it is no longer used.
deleteRow($userid, $weeklyid);
}
}
$rs->free();
$mysqli->close();
return $sql;
}
/**
* Save all back to the database
*/
function process() {
global $db, $oid;
deleteRow($this->table, $this->cond);
$ids = explode(",", value($this->table."selection", "NOSPACES"));
for ($i=0; $i < count($ids); $i++) {
$sql = "INSERT INTO $this->table ($this->idcolumn, $this->fkidcolumn, POSITION) VALUES (".$ids[$i].", $oid, ".($i+1).")";
$query = new query($db, $sql);
$query->free();
}
}
/**
* Destroy the ACL-Object permanently
*/
function destroy() {
deleteRow("acl_management", "GUID = " . $this->guid);
deleteRow("acl_relations", "GUID = " . $this->guid);
}
$inventoryQuery = "SELECT InventoryID, \tInventoryDescription, InventoryTypeID,\tPurchasePrice,\tPurchaseLocation,\tInventoryLocationID,\tInventoryOwnerID, Picture1Location, Picture2Location,\tDateSold, InventoryConditionID, UPC, CustomID from tInventory";
switch ($action) {
case "list":
break;
case "sort":
$listQuery = $listQuery . " ORDER BY {$value}";
break;
case "filter":
$listQuery = $listQuery . " WHERE {$columnName} = {$value}";
break;
case "like":
$listQuery = $listQuery . " WHERE {$columnName} like '%" . $value . "%'";
break;
case "delete":
$deleteQuery = "DELETE FROM tInventory WHERE InventoryID={$value}";
deleteRow("tInventory", $id, $deleteQuery);
break;
case "add":
if (getReturnValue("tInventory", "UPC", $upc, "ID") == null and getReturnValue("tInventory", "Description", $description, "ID") == null) {
$addQuery = "INSERT INTO tInventory (InventoryDescription, InventoryTypeID,\tPurchasePrice,\tPurchaseLocation,\tInventoryLocationID,\tInventoryOwnerID, Picture1Location, Picture2Location,\tDateSold, InventoryConditionID, UPC, CustomID) VALUES('{$description}','{$inventoryType}','{$purchasePrice}','{$purchaseLocation}','{$inventoryLocation}','{$inventoryOwner}','{$picture1}','{$picture2}','{$dateSold}','{$inventoryCondition}','{$upc}','{$customID}')";
if (!($result = mysql_query($addQuery))) {
echo "<p class='error'>Could not add {$value} " . mysql_error() . "</p>";
}
} else {
echo "<p class='error'>{$value} already exists</p>";
listData();
}
break;
case "select":
echo "<form id='edit' method='post' action='inventoryFunction.php' autocomplete='on' type='submit'>";
echo "<input type='hidden' id='InventoryID' name ='InventoryID' value='{$id}'>";
/**
* Delete a cluster node
* @param integer Cluster-Node-ID
* @param boolean also delete version?
*/
function deleteClusterNode($clnid, $recursiveLevels = true)
{
if ($recursiveLevels) {
deleteClusterNode(translateState($clnid, 10, false), false);
}
$clids = createDBCArray("cluster_variations", "CLID", "CLNID = {$clnid}");
if (count($clids) > 0) {
foreach ($clids as $clid) {
deleteCluster($clid);
}
}
deleteRow("cluster_variations", "CLNID = {$clnid}");
deleteRow("cluster_node", "CLNID = {$clnid}");
}
/**
* Delete the data in the plugins.
* @param integer ID of the content to delete
*/
function deleteReferencedItem($id)
{
deleteRow("centerstage", "STAGE_ID = {$id}");
}
//return $sql;
$result = ibase_query($sql);
if ($result) {
return true;
} else {
return false;
}
}
if ($_REQUEST['sender'] == "entri_penetapan_PajakWalet") {
if ($_REQUEST['action'] == 'edit') {
//edit
if (isset($_SESSION['delete_box'])) {
//delete process if box is not empty
foreach ($_SESSION['delete_box']['pwalet_id'] as $key => $id) {
$params = array('pwalet_id' => $id);
deleteRow('pendataan_pwalet', $params);
}
unset($_SESSION['delete_box']);
//print_r($_SESSION['delete_box']);
}
if (isset($_REQUEST['detail'])) {
//data detail
$id_rekening = getIdRekening($_REQUEST['rekening']);
if ($x = searchRow('pendataan_pwalet', 'pendataan_id', $_REQUEST['FK'], $_REQUEST['id'])) {
//ada id row, update
//echo $x;
$exception = array('pendataan_id', 'pwalet_id');
$other_request = array('dasar_pengenaan' => $_REQUEST['pengenaan'], 'persen_tarif' => $_REQUEST['persen'], 'id_rekening' => $id_rekening, 'dasar_tarif' => $_REQUEST['tarif'], 'nominal' => $_REQUEST['pajak']);
ibase_trans();
$str_where = " where pwalet_id =" . $_REQUEST['id'];
$b = $fbird->FBUpdate('pendataan_pwalet', $other_request, $exception, $str_where);
/**
* Deletes a sitepage master
*/
function deleteSitepageMaster($spm)
{
$deleteArray = array();
$deleteArray[] = $spm;
$deleteArray[] = translateState($spm, 10, false);
for ($i = 0; $i < count($deleteArray); $i++) {
deleteRow("sitepage_variations", "SPM_ID = " . $deleteArray[$i]);
deleteRow("sitepage_master", "SPM_ID = " . $deleteArray[$i]);
deleteRow("sitemap", "SPM_ID = " . $deleteArray[$i]);
$sitepages = createDBCArray("sitepage", "SPID", "SPM_ID = " . $deleteArray[$i]);
for ($j = 0; $j < count($sitepages); $j++) {
$da2 = array();
$da2[] = $sitepages[$j];
$da2[] = translateState($sitepages[$j], 10, false);
for ($k = 0; $k < count($da2); $k++) {
deleteRow("sitepage", "SPID = " . $da2[$k]);
deleteRow("sitepage_names", "SPID = " . $da2[$k]);
}
}
}
}
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<?php
include '../Functions/delete-function.php';
include '../Functions/dbconnect.php';
$id = filter_input(INPUT_GET, 'id');
if (deleteRow($id)) {
echo "Address Deleted, Redirecting you back to the view page in 5 seconds";
echo '<meta http-equiv="refresh" content="5;url=./index.php" />';
} else {
echo "Row not deleted, an error has occured";
}
?>
</body>
</html>
$al->tp->assign('title', 'List of users');
$al->tp->assign('selMenu', 'user');
$table = "users";
$tpl = "view_usertbl.tpl";
$isDeleted = deleteRow($table, $params[2], $al->db);
if ($isDeleted === false) {
break;
}
$al->tp->assign('rep', "The user with id = " . $params[2] . " has been deleted.");
} else {
if ($params[1] == "category") {
$al->tp->assign('title', 'List of users');
$al->tp->assign('selMenu', 'category');
$table = "categories";
$tpl = "view_cattbl.tpl";
$isDeleted = deleteRow($table, $params[2], $al->db);
if ($isDeleted === false) {
break;
}
$al->tp->assign('rep', "The category with id = " . $params[2] . " has been deleted.");
} else {
Errors::report("Second parameter of url: " . $params[1] . " is not valid.");
break;
}
}
}
if (!$al->tp->template_exists($tpl)) {
Errors::report("Template file: {$tpl} is missing.");
break;
}
$data = getTableData($table, $al->db);
$result2 = mysql_query($sql2);
if (mysql_num_rows($result2) > 0) {
while ($row2 = mysql_fetch_array($result2)) {
$stockName = $row2['stockname'];
$purchasePrice = $row2['purchaseprice'];
$currentClose = getClose($stockName);
$stopLoss = $row2['stoploss'];
$remaining = $row2['no_of_stocks'];
if ($remaining == 0) {
continue;
}
//echo $stockName . " " . $currentClose . " " . $stopLoss;
if ($currentClose < $stopLoss) {
$loss = ($currentClose - $purchasePrice) * $remaining;
modifyGain($loss, $doj, $username);
deleteRow($doj, $username, $purchasePrice, $stockName);
echo "{$stockName}";
exit(0);
}
}
}
echo "1";
exit(0);
function modifyGain($loss, $doj, $username)
{
$sql2 = "SELECT * FROM investments WHERE doj = '{$doj}' AND username = '******'";
$result2 = mysql_query($sql2);
if (mysql_num_rows($result2) > 0) {
while ($row2 = mysql_fetch_array($result2)) {
$gainLoss = $row2['GainLoss'];
$gainLoss = $gainLoss + $loss;
function deleteRecord($db, $modelName, $record, $roles)
{
if (!in_array("admin", $roles)) {
if ($modelName === "school") {
/* Check that there are no groups attached. We don't care anymore, and keep the groups.
$query = "SELECT count(`group`.`ID`) as `nbGroups` FROM `group` WHERE `group`.`schoolID` = :schoolID AND `group`.`userID` = :userID";
$stmt = $db->prepare($query);
$stmt->execute(array("schoolID" => $record["ID"], "userID" => $_SESSION["userID"]));
$row = $stmt->fetchObject();
if ((!$row) || ($row->nbGroups > 0)) {
return;
}
*/
$query = "SELECT `school_user`.`ID` FROM `school_user` WHERE `schoolID` = :schoolID AND `userID` = :userID";
$stmt = $db->prepare($query);
$stmt->execute(array("schoolID" => $record["ID"], "userID" => $_SESSION["userID"]));
$row = $stmt->fetchObject();
if (!$row) {
return;
}
deleteRow($db, "school_user", array("ID" => $row->ID));
return;
} else {
if ($modelName === "group") {
$query = "SELECT `group`.`userID`, count(`team`.`ID`) as `nbTeams` " . "FROM `group` LEFT JOIN `team` ON (`team`.`groupID` = `group`.`ID`) " . "WHERE `group`.`ID` = :ID GROUP BY `group`.`ID`";
$stmt = $db->prepare($query);
$stmt->execute(array("ID" => $record["ID"]));
$row = $stmt->fetchObject();
if (!$row || $row->userID !== $_SESSION["userID"] || $row->nbTeams > 0) {
return;
}
} else {
if ($modelName === "school_user") {
} else {
return;
}
}
}
}
if ($modelName === "team_view") {
// TODO : should not be necessary
$modelName = "team";
}
deleteRow($db, $modelName, $record);
//deleteRowDynamoDB($modelName, $record);
}
/**
* Delete a meta-template-figure
* @param integer GUID of the figure
*/
function deleteMetaTemplateFigure($id)
{
deleteRow("meta", "MTI_ID = {$id}");
deleteRow("meta_template_items", "MTI_ID = {$id}");
$id = translateState($id, 10, false);
deleteRow("meta", "MTI_ID = {$id}");
deleteRow("meta_template_items", "MTI_ID = {$id}");
}
/**
* Delete a meta-template-figure
* @param integer GUID of the figure
*/
function deleteClusterTemplateFigure($id)
{
deleteRow("cluster_template_items", "CLTI_ID = {$id}");
$id = translateState($id, 10, false);
deleteRow("cluster_template_items", "CLTI_ID = {$id}");
}
/**
* Launch the clusters in a compound-group
* @param integer $in CGID to find clusters from
* @param integer ID of the level to launch to.
*/
function launchCompoundGroupMembers($in, $level) {
global $db;
$cgidTrans = translateState($in, $level, false);
deleteRow("compound_group_members", "CGID = ".$cgidTrans);
$sql = "SELECT * FROM compound_group_members WHERE CGID = $in";
$query = new query($db, $sql);
while ($query->getrow()) {
$position = $query->field("POSITION");
$cgmid = $query->field("CGMID");
$variations = createDBCArray("cluster_variations", "VARIATION_ID", "CLNID = $cgmid");
for ($i=0; $i < count($variations); $i++) {
$cgmidTrans = launchCluster($cgmid, $level, $variation);
}
$sql = "INSERT INTO compound_group_members (CGID, CGMID, POSITION) VALUES($cgidTrans, $cgmidTrans, $position)";
$squery = new query($db, $sql);
$squery->free();
}
$query->free();
}
$cover = $row['art'];
}
// Add db columns
$parameters['art'] = basename($cover);
$parameters['listeners'] = $listenerString;
// DB record exists, overwrite
if ($row) {
updateRow($parameters);
} else {
insertRow($parameters);
}
// Save nowplaying info
$row = $parameters;
} else {
if ($firstPass) {
echo "Song unchanged from previous run. Updating playback only.\n";
}
updatePlayback($parameters['playback_time'], $parameters['paused'], $listenerString);
}
} else {
// Song was playing on last update
if (isset($row['title']) && strlen($row['title']) || isset($row[0])) {
deleteRow();
}
// Reset nowplaying info
$row = array();
}
$firstPass = false;
$com = null;
sleep($updateInterval);
}
//return $sql;
$result = ibase_query($sql);
if ($result) {
return true;
} else {
return false;
}
}
if ($_REQUEST['sender'] == "entri_penetapan_PajakRetribusi") {
if ($_REQUEST['action'] == 'edit') {
//edit
if (isset($_SESSION['delete_box']) && is_array($_SESSION['delete_box'])) {
//delete process if box is not empty
foreach ($_SESSION['delete_box']['retribusi_id'] as $key => $id) {
$params = array('retribusi_id' => $id);
deleteRow('pendataan_retrubusi', $params);
}
//print_r($_SESSION['delete_box']);
unset($_SESSION['delete_box']);
}
if (isset($_REQUEST['detail'])) {
//data detail
$id_rekening = getIdRekening($_REQUEST['rekening']);
if ($x = searchRow('pendataan_retrubusi', 'pendataan_id', $_REQUEST['FK'], $_REQUEST['id'])) {
//ada id row, update
//echo $x;
//$exception = array('nominal','pendataan_id','retribusi_id');
$exception = array('pendataan_id', 'retribusi_id');
$other_request = array('dasar_pengenaan' => $_REQUEST['pengenaan'], 'id_rekening' => $id_rekening, 'dasar_tarif' => $_REQUEST['tarif'], 'kode_rekening' => $_REQUEST['rekening'], 'nominal' => $_REQUEST['retribusi']);
ibase_trans();
$str_where = " where retribusi_id =" . $_REQUEST['id'];
<link rel="icon" type="image/png" href="favicon-32x32.png" sizes="32x32" />
<link rel="icon" type="image/png" href="favicon-16x16.png" sizes="16x16" />
</head>
<body bgcolor="666666">
<!-- Handle POST action / Display result or error -->
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
echo "<table cellpadding=2 width='100%' bgcolor='FFFFFF'><tr><td>\n";
echo "<font face='arial' color='red'>\n";
if ($_POST["insert"] == 'Submit') {
echo insertRow(addslashes($_POST["FortuneText"]));
} elseif ($_POST["update"] == 'Submit') {
echo updateRow($_POST["id"], addslashes($_POST["FortuneText"]));
} elseif ($_POST["delete"] == 'Delete') {
echo deleteRow($_POST["id"]);
}
echo "</font>\n</td></tr></table>";
}
?>
<font face="arial" color="FFFFFF">
<h1>Devops Fortune Cookie - Database Maintenance </h1>
</font>
<font face="arial" color="FFFFFF">
<h2>Current Fortune List</h2>
</font>
<!-- Display data table -->
<font face="arial" color="000000">
//return $sql;
$result = ibase_query($sql);
if ($result) {
return true;
} else {
return false;
}
}
if ($_REQUEST['sender'] == "entri_penetapan_PajakParkir") {
if ($_REQUEST['action'] == 'edit') {
//edit
if (isset($_SESSION['delete_box'])) {
//delete process if box is not empty
foreach ($_SESSION['delete_box']['pparkir_id'] as $key => $id) {
$params = array('pparkir_id' => $id);
deleteRow('pendataan_pparkir', $params);
}
unset($_SESSION['delete_box']);
//print_r($_SESSION['delete_box']);
}
if (isset($_REQUEST['detail'])) {
//data detail
$id_rekening = getIdRekening($_REQUEST['rekening']);
//$table = 'pendataan_pparkir';
//$params=array('pendataan_id'=>$_REQUEST['FK'],'pparkir_id'=>$_REQUEST['id']);
//$separators=array('AND');
if ($x = searchRow('pendataan_pparkir', 'pendataan_id', $_REQUEST['FK'], $_REQUEST['id'])) {
//if($x=searchRow($table,$params,$separators) ) {
//echo $x;
$exception = array('pparkir_alamat', 'pparkir_id_desa', 'pendataan_id', 'pparkir_id');
$other_request = array('dasar_pengenaan' => $_REQUEST['pengenaan'], 'persen_tarif' => $_REQUEST['persen'], 'id_rekening' => $id_rekening, 'nominal' => $_REQUEST['pajak']);
/**
* Remove a Function from a role
*
* @param string ID of the Function
* @param string Name of the role
*/
function removeFunctionFromRole($functionId, $roleName) {
$functionId = strtoupper($functionId);
$rlid = getDBCell("roles", "ROLE_ID", "UPPER(ROLE_NAME) = UPPER('$roleName')");
deleteRow("role_sys_functions", "ROLE_ID = $rlid AND FUNCTION_ID = '$functionId'");
}
