haxxor
Can you finish and compelete with plain sequential code.
Thank you in advance
Code: Select all
moveit.php
<?php
require("dbase.inc"); // dbFunctions
// Open the db
$db = new dBase;
if(!$db->init()) {
echo "Cannot open database<BR>\n";
exit;
}
$total = $db->get_total();
echo $ total;
?>
//--------------------------------------------------------------------------------
dbase.inc
<?php
Class dBase
{
var $DBASE = "userDb"; // database name
var $USER = "userName"; // username
var $PASS = "userPassword"; // password
var $SERVER = "localhost"; // server name
var $AUTOMOVE = yes; // automatically move topics
var $REQUIRE_PW = false;
var $TOPIC_TBL = "phpbb3_topics"; // table name for topics
var $FORUM_TBL = "phpbb3_forums"; // table name for forums
var $FORUM_GENERAL = "phpbb3_forums"; // General Discussions
var $FORUM_GCURRENT = "phpbb3_forums";// General - Current Events
var $FORUM_SPOLITICS = "phpbb3_forums";// Somali Politics/Siyaasada
var $FORUM_GSOMALIDIS = "phpbb3_forums";//General - Soomaali
var $FORUM_GSOMALIDIS = "phpbb3_forums";// Extreme Talk
var $CONN = "";
var $TRAIL = array();
function error($err)
{
$nun = mysql_errno();
$message = mysql_error();
echo "[$err] ( $num - $message )<BR>\n";
}
function init ()
{
$userName = $this->USER;
$userPassword = $this->PASS;
$server = $this->SERVER;
$dbase = $this->DBASE;
$conn = mysql_connect($server,$user,$pass);
if(!$conn) {
$this->error("Connection failed");
}
if(!mysql_select_db($dbase,$conn)) {
$this->error("Select failed");
}
$this->CONN = $conn;
return true;
}
function select ($sql="", $column="")
{
if(empty($sql)) { return false; }
if(!eregi("^select",$sql))
{
echo "<H2>outch!</H2>\n";
return false;
}
if(empty($this->CONN)) { return false; }
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if( (!$results) or (empty($results)) ) {
mysql_free_result($results);
return false;
}
$count = 0;
$data = array();
while ( $row = mysql_fetch_array($results))
{
$data[$count] = $row;
$count++;
}
mysql_free_result($results);
return $data;
}
function insert ($sql="")
{
if(empty($sql)) { return false; }
if(!eregi("^insert",$sql))
{
echo "<H2>Outch!</H2>\n";
return false;
}
if(empty($this->CONN))
{
echo "<H2>No connection waryaa!</H2>\n";
return false;
}
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if(!$results)
{
echo "<H2>Empty basket!</H2>\n";
echo mysql_errno().": ".mysql_error()."<P>";
return false;
}
$results = mysql_insert_id();
return $results;
}
function sql_query ($sql="")
{
if(empty($sql)) { return false; }
if(empty($this->CONN)) { return false; }
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if(!$results)
{
echo "<H2>Crazy Query!</H2>\n";
echo mysql_errno().": ".mysql_error()."<P>";
return false;
}
return $results;
}
function sql_cnt_query ($sql="")
{
if(empty($sql)) { return false; }
if(empty($this->CONN)) { return false; }
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if( (!$results) or (empty($results)) ) {
mysql_free_result($results);
return false;
}
$count = 0;
$data = array();
while ( $row = mysql_fetch_array($results))
{
$data[$count] = $row;
$count++;
}
mysql_free_result($results);
return $data[0][0];
}
function get_total ()
{
$sql = "select count(*) from $this->FORUM_TBL where (add conditions, etc ******* )";
$results = $this->sql_cnt_query($sql);
return $results;
}
function get_forumlist($start=0,$batch=200)
{
$sql = "SELECT forum_name, forum_id FROM $this->FORUM_TBL ORDER BY forum_name DESC LIMIT $start,$batch";
$results = $this->select($sql);
return $results;
}
//update topic
function update_topic ($forum="")
{
$err_msg="";
if(empty($forum)) {
$err_msg = "No forum given.";
return false;
}
$mytime=time();
$sql = "UPDATE $this->TOPIC_TBL SET forum_id = '$forum'";
$results = $this->sql_query($sql);
return $results;
}
//end update topic
} // End Class
?>
