index.php

BLOG HOSTER---PHP & MYSQL Create Blogs in seconds Installation of your BlogHoster system is easy.

<?
$page = "index.php";
include "header.php";
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
if(isset($_POST['page'])) { $page = (int) $_POST['page']; } elseif(isset($_GET['page'])) { $page = (int) $_GET['page']; } else { $page = 1; }
if(isset($_POST['s'])) { $s = $_POST['s']; } elseif(isset($_GET['s'])) { $s = $_GET['s']; } else { $s = "dd"; }
if(isset($_POST['search'])) { $search = str_replace("'", "&#39;", stripslashes($_POST['search'])); } else { $search = ""; }
if(isset($_POST['search_in'])) { $search_in = $_POST['search_in']; } else { $search_in = ""; }
$entries_per_page = $user_info[entries_per_page];


if($search != "") {

 if($search_in == "title") {
  $total_entries = mysql_num_rows(mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' AND title LIKE '%$search%'"));
 } elseif($search_in == "contents") {
  $total_entries = mysql_num_rows(mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' AND contents LIKE '%$search%'"));
 } else {
  $total_entries = mysql_num_rows(mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' AND (title LIKE '%$search%' OR contents LIKE '%$search%')"));
 }
 $maxpage = 1;
 $entries_per_page = $total_entries;

} else {

 $total_entries = mysql_num_rows(mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]'"));

 if(($total_entries % $entries_per_page) != 0) {
 $maxpage = ($total_entries) / $entries_per_page + 1;
 } else {
 $maxpage = ($total_entries) / $entries_per_page;
 }
 $maxpage = (int) $maxpage;
 if($page > $maxpage) { $page = $maxpage; } elseif($page < 1) { $page = 1; }
 $start = ($page - 1) * $entries_per_page;

 if($maxpage != 0 & $maxpage != 1) {
 if($page - 1 > 0 & $maxpage != 1) {  
 $prev = $page - 1;  
 $pp = "<a href='index.php?page=$prev&s=$s'>$index1</a>";  
 } else {
 $pp = "<font class='gray'>$index1</font>";  
 }
 if($page + 1 <= $maxpage & $maxpage != 1) {  
 $next = $page + 1;  
 $np = "<a href='index.php?page=$next&s=$s'>$index2</a>";  
 } else {
 $np = "<font class='gray'>$index2</font>";  
 }
 }
}


$t = "t";
$d = "dd";

if($s == "d") {
$sort = "date";
$d = "dd";
} elseif($s == "dd") {
$sort = "date DESC";
$d = "d";
} elseif($s == "t") {
$sort = "title";
$t = "td";
} elseif($s == "td") {
$sort = "title DESC";
$t = "t";
} else {
$sort = "date";
$d = "dd";
$s = "d";
}


if($task == "delete") {
if($search != "") {
 if($search_in == "title") {
  $entries = mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' AND title LIKE '%$search%'");
 } elseif($search_in == "contents") {
  $entries = mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' AND contents LIKE '%$search%'");
 } else {
  $entries = mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' AND (title LIKE '%$search%' OR contents LIKE '%$search%')");
 }
} else {
 $entries = mysql_query("SELECT * FROM bhost_entries ORDER BY $sort LIMIT $start, $entries_per_page");
}
$decrease = 0;
while($entry = mysql_fetch_assoc($entries)) {
$var = "delete_$entry[e_id]";
  if(isset($_POST[$var])) {
    if($_POST[$var] == "yes") {
      mysql_query("DELETE FROM bhost_entries WHERE e_id='$entry[e_id]'");
      mysql_query("DELETE FROM bhost_comments WHERE e_id='$entry[e_id]'");
      $decrease = $decrease + 1;
    }
  }
}
// DECREMENT NUM_ENTRIES IN BHOST_USERS
$new_num_entries = $user_info[num_entries] - $decrease;
mysql_query("UPDATE bhost_users SET num_entries='$new_num_entries' WHERE u_id='$user_info[u_id]'");
header("Location: index.php?page=$page&s=$s");
exit();
}

$weblog_url = url("index", "$user_info[username]");

if($user_info[fname] == "") { $welcome = "$index3"; } else { $welcome = "$index3 $user_info[fname]."; }
echo $head;
echo "

<script language='JavaScript'> 
<!--

var checkboxcount = 1;

function doCheckAll() {
if(checkboxcount == 0) {
with (document.entriesform) {
for (var i=0; i < elements.length; i++) {
if (elements[i].type == 'checkbox') {
elements[i].checked = false;
}}
checkboxcount = checkboxcount + 1;
window.document.entriesform.check.alt='$index7';
}
} else
with (document.entriesform) {
for (var i=0; i < elements.length; i++) {
if (elements[i].type == 'checkbox') {
elements[i].checked = true;
}}
checkboxcount = checkboxcount - 1;
window.document.entriesform.check.alt='$index18';
}}

function changeAlt(imgObj,newAlt){
imgObj.alt = newAlt;
}


// -->
</SCRIPT>


<h2>$index4 <font class='url'>( <a href='$weblog_url' target='_blank'>$weblog_url</a> )</font></h2>
$index5
<br><br>
";
if(str_replace(" ", "", $group_info[announcements]) != "") {
echo "<table cellpadding='0' cellspacing='0'>
<tr><td class='announce'>".str_replace("\r\n", "<br>", $group_info[announcements])."</td></tr>
</table>
<br>
";
}
echo "
<form action='index.php' method='POST' name='search'>
$index19 <input type='text' name='search' value='$search'> $index20
<select name='search_in'>
<option value='title and contents'"; if($search_in == "title and contents") { echo " SELECTED"; } echo ">$index21</option>
<option value='title'"; if($search_in == "title") { echo " SELECTED"; } echo ">$index22</option>
<option value='contents'"; if($search_in == "contents") { echo " SELECTED"; } echo ">$index23</option>
</select>
<input type='submit' value='$index24' class='sbutton' style='margin-bottom: 2px;'>
<input type='hidden' name='task' value='search'>
</form><br>

<script language='JavaScript'>
<!-- 
appendEvent = function(el, evname, func) {
 if (el.attachEvent) { // IE
   el.attachEvent('on' + evname, func);
 } else if (el.addEventListener) { // Gecko / W3C
   el.addEventListener(evname, func, true);
 } else {
   el['on' + evname] = func;
 }
};
appendEvent(window, 'load', windowonload);

function windowonload() { 
window.document.search.search.focus(); 
window.document.search.search.select(); 
} 
// -->
</script>


<table cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td style='padding-bottom: 3px;' NOWRAP>$index6 $total_entries</td>
<td align='right' NOWRAP style='padding-right: 5px;'>
";

if($total_entries > $entries_per_page) { 
echo "
  <table cellpadding='0' cellspacing='0'>
  <form action='index.php' method='POST'>
  <tr>
  <td style='padding-bottom: 3px;'>
";

if($pp != "") { echo "$pp <font class='gray'>|</font> "; }
if($maxpage != 1 AND $maxpage != 0) { echo "<input type='text' class='text' name='page' value='$page' size='1'>"; }
if($np != "") { echo " <font class='gray'>|</font> $np"; }

echo "
  </td>
  </tr>
  <input type='hidden' name='s' value='$s'>
  </form>
  </table>
";
}

echo "
</td>
</tr>
</table>
";

// GET ENTRY LIST
if($search != "") {
 if($search_in == "title") {
  $entries = mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' AND title LIKE '%$search%' ORDER BY $sort");
 } elseif($search_in == "contents") {
  $entries = mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' AND contents LIKE '%$search%' ORDER BY $sort");
 } else {
  $entries = mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' AND (title LIKE '%$search%' OR contents LIKE '%$search%') ORDER BY $sort");
 }
} else {
$entries = mysql_query("SELECT * FROM bhost_entries WHERE u_id='$user_info[u_id]' ORDER BY $sort LIMIT $start, $entries_per_page");
}


if(mysql_num_rows($entries) != 0) {
echo "
<table width='100%' cellpadding='0' cellspacing='0'>
<form action='index.php' method='POST' name='entriesform'>
<tr>
<td width='1%' class='header2' style='padding-bottom: 5px;'><a href='javascript:doCheckAll()'><img src='../images/check.gif' id='check' border='0' alt='$index7'></a></td>
<td width='1%' class='header2'><a href='index.php?page=$page&s=$d' title='$index26'>$index8</a></td>
<td width='97%' class='header2'><a href='index.php?page=$page&s=$t' title='$index27'>$index9</a></td>
<td width='1%' class='header'>$index10</td>
</tr>
";
}



// OUTPUT EACH RESULT ENTRY
$count = 0;
while($entry = mysql_fetch_assoc($entries)) {
$count++;
if($count % 2) { $c = "2"; } else { $c = "1"; }
if($entry[draft] == 0) { $draft = "<a target='_blank' href='".url("entry", "$user_info[username]", "$entry[e_id]")."'>$index11</a>"; } else { $draft = "<font class='disabled'>$index12</font>"; }
$date = cdate("$user_info[format_date] $user_info[format_time]", timezone($entry[date]));
$title = $entry[title];
if($title == "") { $title = "<i>$index13</i>"; }
echo "
<tr>
<td class='list"."$c"."a' NOWRAP style='padding: 3px;'><input type='checkbox' name='delete_$entry[e_id]' value='yes'></td>
<td class='list"."$c"."a' NOWRAP>$date</td>
<td class='list"."$c"."a'>$title &nbsp;</td>
<td class='list"."$c"."b' NOWRAP align='right'>
$draft <font class='disabled'>|</font> 
<a href='edit_entry.php?e_id=$entry[e_id]'>$index14</a> <font class='disabled'>|</font> 
<a href='delete_entry.php?e_id=$entry[e_id]'>$index15</a>
</td>
</tr>
";
}


// SHOW NO RESULTS ROW IF NONE FOUND
if(mysql_num_rows($entries) == 0) {
echo "
<table cellpadding='0' cellspacing='0'>
<tr>
<td class='empty'>"; if($search != "") { echo $index25; } else { echo $index16; } echo "</b></td>
</tr>
";
}

echo "</table>";

if(mysql_num_rows($entries) != 0) {
echo "
<br>
<input type='submit' class='button' value='$index17'>
<input type='hidden' name='task' value='delete'>
<input type='hidden' name='page' value='$page'>
<input type='hidden' name='s' value='$s'>
<input type='hidden' name='search' value='$search'>
<input type='hidden' name='search_in' value='$search_in'>
</form>
";
}

echo $foot;
?>