function AddRow() { global $conn, $Language, $Security, $bookpost; $rsnew = array(); // name $bookpost->name->SetDbValueDef($rsnew, $bookpost->name->CurrentValue, "", FALSE); // cata $bookpost->cata->SetDbValueDef($rsnew, $bookpost->cata->CurrentValue, "", FALSE); // author $bookpost->author->SetDbValueDef($rsnew, $bookpost->author->CurrentValue, NULL, FALSE); // publisher $bookpost->publisher->SetDbValueDef($rsnew, $bookpost->publisher->CurrentValue, NULL, FALSE); // info $bookpost->info->SetDbValueDef($rsnew, $bookpost->info->CurrentValue, "", FALSE); // code $bookpost->code->SetDbValueDef($rsnew, $bookpost->code->CurrentValue, NULL, FALSE); // pic $bookpost->pic->SetDbValueDef($rsnew, $bookpost->pic->CurrentValue, NULL, FALSE); // useremail $bookpost->useremail->SetDbValueDef($rsnew, $bookpost->useremail->CurrentValue, "", FALSE); // price $bookpost->price->SetDbValueDef($rsnew, $bookpost->price->CurrentValue, 0, FALSE); // datatime $bookpost->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate()); $rsnew['datatime'] =& $bookpost->datatime->DbValue; // hidden $bookpost->hidden->SetDbValueDef($rsnew, $bookpost->hidden->CurrentValue, NULL, FALSE); // Call Row Inserting event $bInsertRow = $bookpost->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($bookpost->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($bookpost->CancelMessage != "") { $this->setMessage($bookpost->CancelMessage); $bookpost->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { $bookpost->bookid->setDbValue($conn->Insert_ID()); $rsnew['bookid'] = $bookpost->bookid->DbValue; // Call Row Inserted event $bookpost->Row_Inserted($rsnew); } return $AddRow; }
function AddRow() { global $conn, $Language, $Security, $order; $rsnew = array(); // bookid $order->bookid->SetDbValueDef($rsnew, $order->bookid->CurrentValue, 0, FALSE); // orderstatus $order->orderstatus->SetDbValueDef($rsnew, $order->orderstatus->CurrentValue, 0, FALSE); // email $order->zemail->SetDbValueDef($rsnew, $order->zemail->CurrentValue, "", FALSE); // datatime $order->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate()); $rsnew['datatime'] =& $order->datatime->DbValue; // Call Row Inserting event $bInsertRow = $order->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($order->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($order->CancelMessage != "") { $this->setMessage($order->CancelMessage); $order->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { $order->orderid->setDbValue($conn->Insert_ID()); $rsnew['orderid'] = $order->orderid->DbValue; // Call Row Inserted event $order->Row_Inserted($rsnew); } return $AddRow; }
function EditRow() { global $conn, $Security, $Language, $userinfo; $sFilter = $userinfo->KeyFilter(); $userinfo->CurrentFilter = $sFilter; $sSql = $userinfo->SQL(); $conn->raiseErrorFn = 'ew_ErrorFn'; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; if ($rs === FALSE) { return FALSE; } if ($rs->EOF) { $EditRow = FALSE; // Update Failed } else { // Save old values $rsold =& $rs->fields; $rsnew = array(); // email $userinfo->zemail->SetDbValueDef($rsnew, $userinfo->zemail->CurrentValue, "", FALSE); // firstname $userinfo->firstname->SetDbValueDef($rsnew, $userinfo->firstname->CurrentValue, "", FALSE); // lastname $userinfo->lastname->SetDbValueDef($rsnew, $userinfo->lastname->CurrentValue, "", FALSE); // password $userinfo->password->SetDbValueDef($rsnew, $userinfo->password->CurrentValue, "", FALSE); // facebook $userinfo->facebook->SetDbValueDef($rsnew, $userinfo->facebook->CurrentValue, 0, FALSE); // logintime $userinfo->logintime->SetDbValueDef($rsnew, ew_CurrentDateTime(), NULL); $rsnew['logintime'] =& $userinfo->logintime->DbValue; // block $userinfo->block->SetDbValueDef($rsnew, $userinfo->block->CurrentValue, NULL, FALSE); // Call Row Updating event $bUpdateRow = $userinfo->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($userinfo->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($userinfo->CancelMessage != "") { $this->setMessage($userinfo->CancelMessage); $userinfo->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("UpdateCancelled")); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $userinfo->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function EditRow() { global $conn, $Security, $Language, $order; $sFilter = $order->KeyFilter(); $order->CurrentFilter = $sFilter; $sSql = $order->SQL(); $conn->raiseErrorFn = 'ew_ErrorFn'; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; if ($rs === FALSE) { return FALSE; } if ($rs->EOF) { $EditRow = FALSE; // Update Failed } else { // Save old values $rsold =& $rs->fields; $rsnew = array(); // bookid $order->bookid->SetDbValueDef($rsnew, $order->bookid->CurrentValue, 0, FALSE); // orderstatus $order->orderstatus->SetDbValueDef($rsnew, $order->orderstatus->CurrentValue, 0, FALSE); // email $order->zemail->SetDbValueDef($rsnew, $order->zemail->CurrentValue, "", FALSE); // datatime $order->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate()); $rsnew['datatime'] =& $order->datatime->DbValue; // Call Row Updating event $bUpdateRow = $order->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($order->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($order->CancelMessage != "") { $this->setMessage($order->CancelMessage); $order->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("UpdateCancelled")); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $order->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function EditRow() { global $conn, $Security, $Language, $bookpost; $sFilter = $bookpost->KeyFilter(); $bookpost->CurrentFilter = $sFilter; $sSql = $bookpost->SQL(); $conn->raiseErrorFn = 'ew_ErrorFn'; $rs = $conn->Execute($sSql); $conn->raiseErrorFn = ''; if ($rs === FALSE) { return FALSE; } if ($rs->EOF) { $EditRow = FALSE; // Update Failed } else { // Save old values $rsold =& $rs->fields; $rsnew = array(); // name $bookpost->name->SetDbValueDef($rsnew, $bookpost->name->CurrentValue, "", FALSE); // cata $bookpost->cata->SetDbValueDef($rsnew, $bookpost->cata->CurrentValue, "", FALSE); // author $bookpost->author->SetDbValueDef($rsnew, $bookpost->author->CurrentValue, NULL, FALSE); // publisher $bookpost->publisher->SetDbValueDef($rsnew, $bookpost->publisher->CurrentValue, NULL, FALSE); // info $bookpost->info->SetDbValueDef($rsnew, $bookpost->info->CurrentValue, "", FALSE); // code $bookpost->code->SetDbValueDef($rsnew, $bookpost->code->CurrentValue, NULL, FALSE); // pic $bookpost->pic->SetDbValueDef($rsnew, $bookpost->pic->CurrentValue, NULL, FALSE); // useremail $bookpost->useremail->SetDbValueDef($rsnew, $bookpost->useremail->CurrentValue, "", FALSE); // price $bookpost->price->SetDbValueDef($rsnew, $bookpost->price->CurrentValue, 0, FALSE); // datatime $bookpost->datatime->SetDbValueDef($rsnew, ew_CurrentDateTime(), ew_CurrentDate()); $rsnew['datatime'] =& $bookpost->datatime->DbValue; // hidden $bookpost->hidden->SetDbValueDef($rsnew, $bookpost->hidden->CurrentValue, NULL, FALSE); // Call Row Updating event $bUpdateRow = $bookpost->Row_Updating($rsold, $rsnew); if ($bUpdateRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $EditRow = $conn->Execute($bookpost->UpdateSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($bookpost->CancelMessage != "") { $this->setMessage($bookpost->CancelMessage); $bookpost->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("UpdateCancelled")); } $EditRow = FALSE; } } // Call Row_Updated event if ($EditRow) { $bookpost->Row_Updated($rsold, $rsnew); } $rs->Close(); return $EditRow; }
function AddRow() { global $conn, $Language, $Security, $userinfo; $rsnew = array(); // email $userinfo->zemail->SetDbValueDef($rsnew, $userinfo->zemail->CurrentValue, "", FALSE); // firstname $userinfo->firstname->SetDbValueDef($rsnew, $userinfo->firstname->CurrentValue, "", FALSE); // lastname $userinfo->lastname->SetDbValueDef($rsnew, $userinfo->lastname->CurrentValue, "", FALSE); // password $userinfo->password->SetDbValueDef($rsnew, $userinfo->password->CurrentValue, "", FALSE); // facebook $userinfo->facebook->SetDbValueDef($rsnew, $userinfo->facebook->CurrentValue, 0, TRUE); // logintime $userinfo->logintime->SetDbValueDef($rsnew, ew_CurrentDateTime(), NULL); $rsnew['logintime'] =& $userinfo->logintime->DbValue; // block $userinfo->block->SetDbValueDef($rsnew, $userinfo->block->CurrentValue, NULL, FALSE); // Call Row Inserting event $bInsertRow = $userinfo->Row_Inserting($rsnew); if ($bInsertRow) { $conn->raiseErrorFn = 'ew_ErrorFn'; $AddRow = $conn->Execute($userinfo->InsertSQL($rsnew)); $conn->raiseErrorFn = ''; } else { if ($userinfo->CancelMessage != "") { $this->setMessage($userinfo->CancelMessage); $userinfo->CancelMessage = ""; } else { $this->setMessage($Language->Phrase("InsertCancelled")); } $AddRow = FALSE; } if ($AddRow) { $userinfo->zuserid->setDbValue($conn->Insert_ID()); $rsnew['userid'] = $userinfo->zuserid->DbValue; // Call Row Inserted event $userinfo->Row_Inserted($rsnew); } return $AddRow; }