<?php
function
mysql_prep($val
ue)
{
$magic_quotes_a
ctive =
get_magic_quote
s_gpc();
$new_enough_php
=
function_exists
("mysql_r
eal_escape_stri
ng"

; //
i.e. PHP >=
v4.3.0
if
($new_enough_ph
p) { // PHP
v4.3.0 or
higher
// undo
any magic quote
effects so
mysql_real_esca
pe_string can
do the work
if
($magic_quotes_
active) {
$value =
stripslashes($v
alue);
}
$value
=
mysql_real_esca
pe_string($valu
e);
} else { //
before PHP
v4.3.0
// if
magic quotes
aren't already
on then add
slashes
manually
if
(!$magic_quotes
_active) {
$value =
addslashes($val
ue);
}
// if
magic quotes
are active,
then the
slashes already
exist
}
return
$value;
}
function
redirect_to($lo
cation = null)
{
if
($location !=
null) {
header("L
ocation:
$location"

;
exit;
}
}
function
confirm_query($
query)
{
if
(!$query) {
die("Data
base Query
failed !. Check
Database
Settings."
; .
mysql_error());
}
}
function
get_page_for_ed
iting($page_id)
{
$query =
" SELECT
* FROM pages
";
$query .=
" WHERE
id =" .
$page_id .
"
";
$result =
mysql_query($qu
ery);
confirm_query($
result);
$page =
mysql_fetch_arr
ay($result);
return
$page;
}
function
get_post_for_ed
iting($post_id)
{
$query =
" SELECT
* FROM posts
";
$query .=
" WHERE
id =" .
$post_id .
"
";
$result =
mysql_query($qu
ery);
confirm_query($
result);
$post =
mysql_fetch_arr
ay($result);
return
$post;
}
function
get_sidebar_for
_editing($sideb
ar_id)
{
$query =
" SELECT
* FROM sidebar
";
$query .=
" WHERE
id =" .
$sidebar_id .
"
";
$result =
mysql_query($qu
ery);
confirm_query($
result);
$sidebar =
mysql_fetch_arr
ay($result);
return
$sidebar;
}
function
selected_page()
{
global
$selected_page;
global
$selected_post;
global
$selected_sideb
ar;
if
(isset($_GET['
page'])) {
$selected_page
=
get_page_for_ed
iting($_GET['p
age']);
}
if
(isset($_GET['
post'])) {
$selected_post
=
get_post_for_ed
iting($_GET['p
ost']);
}
if
(isset($_GET['
sidebar'])) {
$selected_sideb
ar =
get_sidebar_for
_editing($_GET[
'sidebar']);
}
}
function
display_acquire
d_pages()
{
$query =
"SELECT *
FROM pages
ORDER BY
position"
;
$result =
mysql_query($qu
ery);
confirm_query($
result);
$check =
mysql_num_rows(
$result);
if ($check
!= 0) {
echo
"<div
id=\"aPo
sitions\"
;>Already
acquired
positions.&quo
t;;
echo
"<ul&g
t;";
while
($pageList =
mysql_fetch_arr
ay($result)) {
echo
"<li&g
t;Page :
{$pageList['me
nu_name']} --
Position :
{$pageList['po
sition']}</
li>\n"
;;
}
echo
"</ul&
gt;</div>
";
}
}
function
display_acquire
d_posts()
{
global
$selected_page;
global
$selected_post;
global
$postList;
$query =
"SELECT *
FROM posts
WHERE page_id =
'{$selected_pa
ge['id']}'
ORDER BY
position"
;
$result =
mysql_query($qu
ery);
confirm_query($
result);
$query1 =
"SELECT
page_id FROM
posts WHERE
page_id =
'{$selected_pa
ge['id']}'
ORDER BY
position"
;
$result1 =
mysql_query($qu
ery1);
confirm_query($
result1);
$check =
mysql_num_rows(
$result1);
echo
"<div
id=\"aPo
sitions\"
;>Already
acquired
positions.&quo
t;;
echo
"<ul&g
t;";
if ($check
==
""
{
echo
"<span
style=\"
color: #900;
font-weight:
normal;\"
;>No post
found under
this page. All
positions are
free to
use.</span&g
t;";
} else {
while
($postList =
mysql_fetch_arr
ay($result)) {
echo
"<li&g
t;Post :
{$postList['ti
tle']} --
Position :
{$postList['po
sition']}</
li>\n"
;;
}
}
echo
"</ul&
gt;</div>
";
}
function
display_msg()
{
global
$successMSG,
$errorMSG,
$displayError;
if
(!empty($succes
sMSG)) {
echo
"<div
class=\"
successMSG\&q
uot;>"
. $successMSG .
"</div
>";
}
if
(!empty($errorM
SG)) {
echo
"<div
class=\"
errorMSG\&quo
t;>" .
$errorMSG .
"</div
>";
}
echo
$displayError;
}
function
get_posts_for_s
elected_page()
{
global
$selected_page;
global
$posts;
$query =
"SELECT *
FROM posts
WHERE page_id =
'{$selected_pa
ge['id']}'
ORDER BY
position"
;
$result =
mysql_query($qu
ery);
confirm_query($
result);
$check =
mysql_num_rows(
$result);
echo
"<div
id=\"pos
tsUnder\"
;>\n"
;
echo
"<h2&g
t;Posts under
this
page.</h2>
;\n";
echo
"<ul&g
t;\n";
if ($check
!= 0) {
while
($posts =
mysql_fetch_arr
ay($result)) {
echo
"<li&g
t;<a href =
\"edit_p
ost.php?page=&
quot; .
urlencode($sele
cted_page['id
']) .
"&pos
t=" .
urlencode($post
s['id']) .
"\"
;><span&g
t;</span>
{$posts['title
']}</a>&
lt;/li>\n&
quot;;
}
} else {
echo
"No posts
posts found
under this
page.<br/>
;<br/>&q
uot;;
echo
"<a
href=\"a
dd_post.php?pag
e=" .
urlencode($sele
cted_page['id
']) .
"\"
; title=\Add
New
Post\"
target=\"
;_self\"
class=\"
addPageButton\
">Add
New
Post</a>
";
}
echo
"</ul&
gt;\n</div&
gt;";
}
function
get_sidebar_pos
ts_for_editing(
)
{
global
$selected_page;
global
$selected_sideb
ar;
global
$sidebar_post;
$query =
"SELECT *
FROM sidebar
WHERE page_id =
'{$selected_pa
ge['id']}'
ORDER BY
position"
;
$result =
mysql_query($qu
ery);
confirm_query($
result);
$query1 =
"SELECT
page_id FROM
sidebar WHERE
page_id =
'{$selected_pa
ge['id']}'
ORDER BY
position"
;
$result1 =
mysql_query($qu
ery1);
confirm_query($
result1);
$check =
mysql_num_rows(
$result1);
echo
"<div
id=\"aPo
sitions1\&quo
t;>Posts
under this
sidebar."
;
echo
"<ul&g
t;";
if ($check
==
"" {
echo
"<span
style=\"
color: #900;
font-weight:
normal;\"
;>No post
found under
this page. All
positions are
free to
use.</span&g
t;";
} else {
while
($sidebar_post
=
mysql_fetch_arr
ay($result)) {
echo
"<li&g
t;Post Position
:
{$sidebar_post[
'position']}&
lt;a
href=\"d
elete_sbPost.ph
p?sidebar={$sid
ebar_post['id
']}\"
class=\"
imgLink\"
;><img
src=\"im
ages/sidebar_de
lete.png\&quo
t;
width=\"
16\"
height=\"
;16\"
border=\"
;0\"
onClick=\&quo
t;return
confirm('Are
you sure you
wann delete
this sidebar
post. This
action can not
be
undone!.');\
"/><
/a>
<a
href=\"e
dit_sidebar.php
?page=" .
urlencode($sele
cted_page['id
']) .
"&sid
ebar=" .
urlencode($side
bar_post['id'
]) .
"\"
;
class=\"
edLink\"
>{$sidebar_p
ost['title']}
</a></
li>\n"
;;
}
}
echo
"</ul&
gt;</div>
";
}
function
get_settings()
{
global
$settings;
$query =
"SELECT *
FROM
settings"
;
$result =
mysql_query($qu
ery);
confirm_query($
result);
$settings =
mysql_fetch_arr
ay($result);
return
$settings;
}
?>