<?php
include_once "database.php";
$PHP_SELF = $_SERVER['PHP_SELF'];
global $dconn;
if(!isset($dconn))
dbr_connect();
#############
## dir_insert
#############
function dir_insert ($parent_id, $path, $title, $css_url, $keywords_str)
{
global $PHP_SELF;
$sql = "insert into s_dir
(dir_id, parent_id, path, title, css_url, keywords_str)
values (null, $parent_id, '$path', '$title', '$css_url', '$keywords_str')";
dbr_query($sql);
$sql = "select LAST_INSERT_ID() from s_dir";
$stmt = dbr_query($sql);
$row=dbr_fetch_row($stmt);
$dir_id = $row[0];
return($dir_id);
}
#############
## page_insert
#############
function page_insert ($dir_id, $page_title, $page_type, $layout, $dynamic_link, $static_link, $is_dirpage, $is_global)
{
global $PHP_SELF;
$sql = "insert into s_page
(page_id, dir_id, page_title, page_type, layout, dynamic_link, static_link, is_dirpage, is_global)
values
(null, $dir_id, '$page_title', '$page_type', '$layout', '$dynamic_link', '$static_link', $is_dirpage, $is_global)";
//echo "<b>$sql</b>";
dbr_query($sql);
$sql = "select LAST_INSERT_ID() from s_page";
$stmt = dbr_query($sql);
$row=dbr_fetch_row($stmt);
$page_id = $row[0];
return($page_id);
}
#############
## update_s_page_dynamic_link
#############
function update_s_page_dynamic_link($page_id, $dynamic_link)
{
$sql = "update s_page set dynamic_link='$dynamic_link' where page_id=$page_id";
dbr_query($sql);
}
#############
## link_list_insert
#############
function link_list_insert ($page_id, $dir_id)
{
if(!isset($page_id) || !isset($dir_id))
{
echo "bad link_list_insert input: $link_id, $page_id<br>";
return;
}
dbr_query("insert into s_link_list (link_list_id, page_id, dir_id) values(null, $page_id, $dir_id)");
}
#############
## image_list_insert
#############
function image_list_insert ($image_id, $page_id)
{
dbr_query("insert into s_image_list (image_list_id, image_id, page_id) values(null, $image_id, $page_id)");
}
#############
## textfile_insert
#############
function get_textfile_id($srcfile)
{
$sql = "select textfile_id from s_textfile where srcfile='$srcfile'";
$stmt=dbr_query($sql);
$row = dbr_fetch_row($stmt);
$id = $row[0];
return($id);
}
function textfile_insert ($srcfile)
{
$id=get_textfile_id($srcfile);
if(!isset($id))
{
$sql="insert into s_textfile(textfile_id, srcfile) values(null, '$srcfile')";
dbr_query($sql);
$stmt = dbr_query("select LAST_INSERT_ID() from s_textfile");
$row = dbr_fetch_row($stmt);
$id = $row[0];
if(isset($stmt))
dbr_free_result($stmt);
}
return ($id);
}
#############
## furl_insert
#############
function furl_insert ($url, $page_id)
{
$sql="insert into s_furl(furl_id, url, page_id) values(null, '$url', $page_id)";
dbr_query($sql);
$stmt = dbr_query("select LAST_INSERT_ID() from s_furl");
$row = dbr_fetch_row($stmt);
$id = $row[0];
if(isset($stmt))
dbr_free_result($stmt);
return ($id);
}
#############
## iframe_insert
#############
function iframe_insert ($url, $page_id)
{
$sql="insert into s_iframe(iframe_id, url, page_id) values(null, '$url', $page_id)";
dbr_query($sql);
$stmt = dbr_query("select LAST_INSERT_ID() from s_iframe");
$row = dbr_fetch_row($stmt);
$id = $row[0];
if(isset($stmt))
dbr_free_result($stmt);
return ($id);
}
#############
## htmlfile_insert
#############
function get_htmlfile_id($file, $srcpath)
{
$sql = "select htmlfile_id from s_htmlfile where file='$file' and srcpath='$srcpath'";
$stmt=dbr_query($sql);
$row = dbr_fetch_row($stmt);
$id = $row[0];
return($id);
}
function htmlfile_insert ($file, $srcpath)
{
$id=get_htmlfile_id($file, $srcpath);
if(!isset($id))
{
$sql = "insert into s_htmlfile(htmlfile_id, file, srcpath) values(null, '$file', '$srcpath')";
dbr_query($sql);
$stmt = dbr_query("select LAST_INSERT_ID() from s_htmlfile");
$row = dbr_fetch_row($stmt);
$id = $row[0];
if(isset($stmt))
dbr_free_result($stmt);
}
return ($id);
}
#############
## htmlfile_list_insert
#############
function htmlfile_list_insert ($htmlfile_id, $page_id)
{
dbr_query("insert into s_htmlfile_list (htmlfile_list_id, htmlfile_id, page_id) values(null, $htmlfile_id, $page_id)");
}
#############
## htmlfragment_insert
#############
function get_htmlfragment_id($srcpath)
{
$sql = "select htmlfragment_id from s_htmlfragment where srcpath='$srcpath'";
$stmt=dbr_query($sql);
$row = dbr_fetch_row($stmt);
$id = $row[0];
return($id);
}
function htmlfragment_insert ($srcfile)
{
$id=get_htmlfragment_id($srcfile);
if(!isset($id))
{
$sql = "insert into s_htmlfragment(htmlfragment_id, srcfile) values(null, '$srcfile')";
dbr_query($sql);
$stmt = dbr_query("select LAST_INSERT_ID() from s_htmlfragment");
$row = dbr_fetch_row($stmt);
$id = $row[0];
if(isset($stmt))
dbr_free_result($stmt);
}
return ($id);
}
#############
## htmlfragment_list_insert
#############
function htmlfragment_list_insert ($htmlfragment_id, $page_id)
{
dbr_query("insert into s_htmlfragment_list (htmlfragment_list_id, htmlfragment_id, page_id) values(null, $htmlfragment_id, $page_id)");
}
#############
## textfile_list_insert
#############
function textfile_list_insert ($textfile_id, $page_id)
{
dbr_query("insert into s_textfile_list (textfile_list_id, textfile_id, page_id) values(null, $textfile_id, $page_id)");
}
#############
## image_insert
#############
function get_image_id($filename, $htmlpath)
{
$sql = "select image_id from s_image where filename='$filename' and htmlpath='$htmlpath'";
$stmt=dbr_query($sql);
$row = dbr_fetch_row($stmt);
$id = $row[0];
return($id);
}
function image_insert ($filename, $htmlpath, $image_title, $mime_type, $caption_file)
{
$id=get_image_id($filename, $htmlpath);
if(!isset($id))
{
$sql = "insert into s_image (image_id, filename, htmlpath, image_title, mime_type, caption_file)
values(null, '$filename', '$htmlpath', '$image_title', '$mime_type','$caption_file')";
$rslt = dbr_query($sql);
$stmt = dbr_query("select LAST_INSERT_ID() from s_image");
$row = dbr_fetch_row($stmt);
$id = $row[0];
if(isset($stmt))
dbr_free_result($stmt);
//echo "image_insert returns $image_id <br>";
}
return ($id);
}
#############
## image_caption_insert
## image caption is text too big for image's 255 byte notes field?
#############
function image_caption_insert ($image_id, $page_id, $srcpath)
{
//if(isset($image_id) && isset($page_id) && isset($file) && isset($srcpath))
//{
$insert = "insert into s_caption(caption_id, image_id, page_id, srcpath) values(null,$image_id, $page_id, '$srcpath')";
dbr_query($insert);
//}
}
?>
|
ReTweet
Stumble It!
Bookmark in del.icio.us
Advertise on this site
Site map
Statistics
Site tips
Privacy policy
Contact