<?php
/*
CODE GENERATED BY: GRAFXSOFTWARE CODE GENERATOR
http://www.grafxsoftware.com
======================================
CLASS MADE BY: {AUTHOR}
DATE: {DATE}
PROJECT: {PROJECT_NAME}
PHP: version 4.x
======================================
*/
/*
${CLASSVAR}=new {NAME}();
<!-- BEGIN DYNAMIC BLOCK: getfunctionsvar -->
${CLASSVAR}->get{FUNC_NAME}();
<!-- END DYNAMIC BLOCK: getfunctionsvar -->
<!-- BEGIN DYNAMIC BLOCK: setfunctionsvar -->
${CLASSVAR}->set{FUNC_NAME}();
<!-- END DYNAMIC BLOCK: setfunctionsvar -->
${CLASSVAR}->save();
*/
/**
*
* @author - {AUTHOR}
* @desc -
* @vers - 1.0
*/
class {NAME}
{
var $where_clause;
var $enable_undo={ENABLE_UNDO};
var $id_key='id';
var $history_table='{HISTORY_TABLE}';
var $valid=false; //do not modify
var $where_mode=false;//do not modify
<!-- BEGIN DYNAMIC BLOCK: row -->
var ${VARIABLES};
<!-- END DYNAMIC BLOCK: row -->
/**
* @author - {AUTHOR}
* @type - public
* @desc - Constructor
* @param - string ${IDCLASS} - the ID
* @return - mixed rewrite array
* @vers - 1.0
* @Mod -
**/
function {NAME}(${IDCLASS})
{
if ((is_int($id)&&($id==0))||(is_string($id)&&($id=="0"))) {
$this->valid=true;
$this->where_mode=false;
return;
};
$this->{IDCLASS} = ${IDCLASS};
if ((is_string($id))&&(stristr($id,"where"))) {
$this->where_clause=$id;
$this->where_mode=true;
}else {
$this->where_clause=" WHERE `id`='".$this->id."'";
$this->where_mode=false;
};
$SQL = " SELECT {LIST} FROM {DBNAME} ".$this->where_clause;
$retid = mysql_query($SQL) or die(mysql_error());
if ($row = mysql_fetch_array($retid))
{
$this->valid=true;
<!-- BEGIN DYNAMIC BLOCK: value -->
$this->{FIELD_NAME} = $row["{FIELD_NAME}"];
<!-- END DYNAMIC BLOCK: value -->
}
else
{
$this->valid=false;
<!-- BEGIN DYNAMIC BLOCK: nullvalue -->
$this->{FIELD_NAME} = "";
<!-- END DYNAMIC BLOCK: nullvalue -->
}
}//end constructor {NAME}
<!-- BEGIN DYNAMIC BLOCK: getfunctions -->
/**
* @author - {AUTHOR}
* @type - public
* @desc - get $this->{VAR_NAME}
* @return - string
* @vers - 1.0
* @Mod -
**/
function get{FUNC_NAME}()
{
return $this->{VAR_NAME};
} // end get{FUNC_NAME}()
<!-- END DYNAMIC BLOCK: getfunctions -->
<!-- BEGIN DYNAMIC BLOCK: setfunctions -->
/**
* @author - {AUTHOR}
* @type - public
* @desc - set $this->{VAR_NAME} to ${VAR_NAME}
* @param - string ${VAR_NAME}
* @return - void
* @vers - 1.0
* @Mod -
**/
function set{FUNC_NAME}(${VAR_NAME})
{
$this->{VAR_NAME}=${VAR_NAME};
} // end set{FUNC_NAME}()
<!-- END DYNAMIC BLOCK: setfunctions -->
/**
* @author - {AUTHOR}
* @type - public
* @desc - check if the data is valid
* @return - void
* @vers - 1.0
* @Mod -
**/
function is_valid() {
return $this->valid;
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - saves data into database
* @return - void
* @vers - 1.0
* @Mod -
**/
function save() {
if (!$this->valid) return;
//$this->slashesAdd ();
if ((($this->{IDCLASS})==0)&&(!$this->where_mode))
{
$SQL = "INSERT INTO {DBNAME} ({LIST})";
$SQL .= " VALUES({LIST_INSERT})";
$retid = mysql_query($SQL);
if (!$retid) { echo( mysql_error()); }
$this->{IDCLASS} = mysql_insert_id();
if ($this->enable_undo) {
$this->write_insert_undo($this->{IDCLASS});
};
}
else
{
if ($this->enable_undo){
$this->write_update_undo();
}
$SQL = "UPDATE {DBNAME} SET {LIST_UPDATE}";
$SQL .= $this->where_clause;
$retid = mysql_query($SQL);
if (!$retid) { echo( mysql_error()); }
}
}//end save()
/**
* @author - {AUTHOR}
* @type - public
* @desc - delete ${IDCLASS} from database
* @return - void
* @vers - 1.0
* @Mod -
**/
function delete(${IDCLASS})
{
if (is_int(${IDCLASS})) $where_clause="WHERE `{IDCLASS}`='".${IDCLASS}."'";
else $where_clause=${IDCLASS};
if ($this->enable_undo){
$this->write_delete_undo($where_clause);
};
$SQL = "DELETE FROM {DBNAME} ".$where_clause;
$retid = mysql_query($SQL);
if (!$retid) { echo( mysql_error()); }
} // end delete()
/**
* @author - {AUTHOR}
* @type - public
* @desc - write undo into history table
* @return - void
* @vers - 1.0
* @Mod -
**/
/*
//--- create a history table from this SQL
CREATE TABLE `{HISTORY_TABLE}` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`tablename` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`command` text COLLATE utf8_bin,
`date` datetime DEFAULT NULL,
`userid` int(11) DEFAULT NULL,
`valid` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
*/
function write_undo($item_id,$sql_text){
if ((!$this->enable_undo)||($sql_text=="")) return;
$sql_text=base64_encode($sql_text);
$userid=0;
$tablename="{DBNAME}";
$SQL="INSERT INTO `$this->history_table` (`item_id`,`tablename`,`command`,`date`,`userid`,`valid`)";
$SQL.=" VALUES('".$item_id."','".$tablename."','".$sql_text."',NOW(),'".$userid."','1');";
$retid = mysql_query($SQL);
if (!$retid) { echo( mysql_error()); }
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - write undo for UPDATE
* @return - void
* @vers - 1.0
* @Mod -
**/
function write_update_undo(){
$this->make_replace_row_sql($this->where_clause);
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - write INSERT
* @return - void
* @vers - 1.0
* @Mod -
**/
function write_insert_undo(${IDCLASS}){
$this->make_sql_for_insert(${IDCLASS});
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - get SQL query for DELETE
* @return - string
* @vers - 1.0
* @Mod -
**/
function write_delete_undo($id_or_where_clause){
$this->make_replace_row_sql($id_or_where_clause);
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - get SQL query for INSERT
* @return - string
* @vers - 1.0
* @Mod -
**/
function make_sql_for_insert(${IDCLASS}){
$SQL="SELECT * FROM `{DBNAME}` ".$where_clause;
$result="";
$retid=mysql_query($SQL);
if (!$retid) return "";
$id_value="";
while ($row = mysql_fetch_assoc($retid)){
$keys="";
$values="";
foreach($row as $key => $value){
if ($key==$this->id_key) {
$id_value=$value;
};
if ($keys!="") $keys.=",";
$keys.="`".$key."` ";
if ($values!="") $values.=",";
$values.="'".$value."' ";
};
};
$this->write_undo($id_value, "DELETE FROM `{DBNAME}` WHERE `{IDCLASS}`='".${IDCLASS}."' AND $this->id_key='$id_value';");
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - get the SQL query which make the existing rows
* @return - void
* @vers - 1.0
* @Mod -
**/
function make_replace_row_sql($id_or_where_clause){
if (is_int($id_or_where_clause)) $where_clause="WHERE `{IDCLASS}`='".$id_or_where_clause."'";
else $where_clause=$id_or_where_clause;
$SQL="SELECT * FROM `{DBNAME}` ".$where_clause;
$result="";
$retid=mysql_query($SQL);
if (!$retid) return "";
while ($row = mysql_fetch_assoc($retid)){
$keys="";
$values="";
$id_value="";
foreach($row as $key => $value){
if ($key==$this->id_key) $id_value=$value;
if ($keys!="") $keys.=",";
$keys.="`".$key."` ";
if ($values!="") $values.=",";
$values.="'".$value."' ";
};
$this->write_undo($id_value,"REPLACE INTO `{DBNAME}` (".$keys.") VALUES (".$values.");");
};
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - debugging function which shows what's in history table
* @return - void
* @vers - 1.0
* @Mod -
**/
function debug_print_history(){
$SQL="SELECT * from $this->history_table;";
$retid=mysql_query($SQL);
if (!$retid) return "";
while ($row = mysql_fetch_assoc($retid)){
foreach($row as $key => $value){
if ($key=='command') $value=base64_decode($value);
print("`$key` = '$value'<br>");
};
print("<br />");
};
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - do multiple query, each query is separted by ";;\n"
* @return - string
* @vers - 1.0
* @Mod -
**/
function mysql_multiple_query($q) {
$tok = strtok($q, ";;\n");
while ($tok) {
$results=mysql_query("$tok");
$tok = strtok(";;\n");
}
return $results;
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - undo function
* @return - boolean
* @vers - 1.0
* @Mod -
**/
function undo($item_id){
$SQL="SELECT * from `$this->history_table` WHERE tablename='{DBNAME}' AND valid='1' AND item_id='$item_id' ORDER BY date DESC LIMIT 1;";
$retid=mysql_query($SQL);
if (!$retid) return "";
if ($row = mysql_fetch_assoc($retid)){
$command=$row['command'];
if ($command=="") return false;
$command=base64_decode($command);
$SQL="DELETE from `$this->history_table` ORDER BY date DESC LIMIT 1;";
if (!mysql_query($SQL)) return false;
return $this->mysql_multiple_query($command);
};
return false;
}
/**
* @author - {AUTHOR}
* @type - public
* @desc - adding slashes if necesary
* @return - void
* @vers - 1.0
* @Mod -
**/
function slashes($str){
if ((get_magic_quotes_gpc()) && (!empty($str))) return addslashes($str);
else return $str;
}
/*
function slashesAdd() {
$class_vars = get_class_vars ( get_class ( $this ) );
foreach ( $class_vars as $name => $value ) {
if (get_magic_quotes_gpc () && ! empty ( $name ))
$this->$name = addslashes ( $this->$name );
}
}
*/
/**************************************************************/
/* ADD YOUR CUSTOM FUNCTIONS BELOW */
/**************************************************************/
} // end class {NAME}
?>
|
Download
