main.php at V-CMS - Free PHP Code

<?php
# V-CMS - A simple web-based content management system
#
# V-CMS is free software: you can redistribute it and/or modify it
# under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# V-CMS is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with V-CMS.  If not, see <http://www.gnu.org/licenses/>.
#
# http://cmsclone.sourceforge.net
# V-CMS, Copyright 2010, VyReN, LLC

if(!$session->logged_in){
die;
}
if ($_REQUEST["saved"] == "1") {
	echo SAVED_TEXT . "<br>";
}
echo "<h1>" . SITES_PAGES_TEXT . "</h1>";
echo CLICKY_NOTICE_TEXT . "<br>";
//Get all permissions for current user
$q = "SELECT * FROM permissions WHERE UserID = \"" . $session->user_db_id . "\"";

$result = mysql_query($q);
	while ($row = mysql_fetch_array($result)){
		//If the permission is a domain, store in the domain list
		if ($row["Type"] == "Domain") {
			$q2 = "SELECT * FROM domains WHERE ID =\"" . $row["Permission"] . "\"";
			$result2 = mysql_query($q2);
			while ($row2 = mysql_fetch_array($result2)) {
				$domainlistname[] = $row2["Name"];
				$domainlistp[] = $row["Permission"];
				$domainlisturl[] = $row["SiteURL"];
			}
		}
		//If the permission is a page, query info on that page
		if ($row["Type"] == "Page") {
			$q2 = "SELECT * FROM pages WHERE ID = \"" . $row["Permission"] . "\"";
			$result2 = mysql_query($q2);
			while ($row2 = mysql_fetch_array($result2)) {
				$pages[] = $row2["Name"];
				$page_ids[] = $row2["ID"];
				$page_domains[] = $row2["Domain"];
				$page_path[] = $row2["Path"];
			}
		}
	}
	//Sort displayed domain names by name
	array_multisort($domainlistname, $domainlistp, $domainlisturl);
	//Sort displayed pages by the page name
	array_multisort($pages, $page_domains, $page_path, $page_ids);
	
	//Start page display
	//Get domain info on permitted domains
	$domain_counter = 0;
	while($domain_counter < count($domainlistp)) {
		$q3 = "SELECT * FROM domains WHERE ID = \"" . $domainlistp[$domain_counter] . "\"";
		$result3 = mysql_query($q3);
		$domaingood = 0;
		while ($row = mysql_fetch_array($result3)){
		$domaingood = 1;
			echo "
			<br><table cellspacing=\"5\" border=\"0\" width=\"100%\" style=\"border-bottom: 1px solid; border-top: 1px solid; border-left: 1px solid; border-right: 1px solid;\"><tr><td width=\"382px\">";
			echo "<a href=\"javascript:animatedcollapse.toggle('site_" . $row["ID"] . "')\"><h2>" . $row["Name"] . "<img align=\"top\" src=\"images/e_c.png\" border=0></h2></a><br></td><td colspan=3 align=right >";
			if ($session->isAdmin()) {
			 echo "<a href=\"?page=e1&popup=1&domainedit=" . $row["ID"] . "\" class=\"site_edit_lightbox btn blue\"><i></i><span><span></span><i></i>" . EDIT_TEXT . "</span></a>";
			}
			echo "<a href=\"?page=i1&popup=1&domain=" . $row["ID"] . "\"class=\"image_manager_lightbox btn blue\"><i></i><span><span></span><i></i>" . IMAGE_MANAGER_LINK_TEXT . "</span></a>";
			echo "<br></td></tr>";
			echo '</tr><tr><td colspan="4"><div ';
			if (count($domainlistp) != 1) {
			echo 'style="display:none" ';
			}
			echo 'id="site_' . $row["ID"] . '"><table width="100%"><tr><td colspan=4 style="border-bottom: 1px dotted;"></td></tr>';
			
			//Display each page for this domain
			$z = 0;
			$y = 0;
			
			while($z < count($pages)){
				if ($page_domains[$z] == $domainlistp[$domain_counter]) {
				$y = $y + 1;
					echo '
					<tr><td  width="345px"><a href="?page=e2&editfile=' . $page_ids[$z] . '&ftp=' . $page_domains[$z] . '" class="btn blue"><i></i><span><span></span><i></i>' . $pages[$z] . '</span></a></td>';
					echo '
					<td><a href="' . $row["SiteURL"] . $page_path[$z] . '?' . rand(100, 50000) . '" target="_blank" class="btn blue iframe_lightbox"><i></i><span><span></span><i></i>' . PREVIEW_TEXT . '</span></a></td>';
					if ($session->isAdmin()){
						echo '
						<td><a href="?page=p1&popup=1&activepage=' . $page_ids[$z] . '" class="btn blue permissions_lightbox"><i></i><span><span></span><i></i>' . PAGE_SETTINGS_TEXT . '</span></a></td><td><a href="?page=p2_d&popup=1&de=' . $page_ids[$z] . '&item=2"class="btn blue delete_lightbox"><i></i><span><span></span><i></i>' . DELETE_TEXT . '</span></a></td>';
					}
					echo '
					</tr><tr><td colspan=4 style="border-bottom: 1px dotted;"></td></tr>';
				}				
				$z = $z + 1;
			}
			?>
			
			<script type="text/javascript">
animatedcollapse.addDiv('site_<?php echo $row["ID"];?>', 'fade=1')
</script>
			<?php
			$last_site_id = $row["ID"];
			//If admin, show other options
			if ($session->isAdmin()){
				//If no pages exist for the site, offer delete option
				if ($y == 0) {
					echo "<tr><td colspan=4><a href=\"?page=p2_d&popup=1&de=" . $domainlistp[$domain_counter] . "&item=1\" class=\"btn blue delete_lightbox\"><i></i><span><span></span><i></i>" . DELETE_TEXT . ' ' . $row["Name"] . '</span></a></td></tr>';
				}
				echo '<tr><td colspan=4><br><a href="?page=a2&popup=1&domain=' . $domainlistp[$domain_counter] . '" class="btn blue add_page_lightbox"><i></i><span><span></span><i></i>' . ADD_PAGE_TO_TEXT . ' ' . $row["Name"] . '</span></a></td></tr>';
			}
		}
		if ($domaingood == 1) {
		echo "</table></div></td></tr></table>";
		$domaingood = 0;
		}
		$domain_counter = $domain_counter + 1;
	}
	if ($domain_counter == 0) {

		echo "<tr><td>" . NO_PAGES_FOUND_TEXT . "</td></tr>";

	}
	
?>
</table><br></td></tr></table>
<?php
if ($session->isAdmin()){
?>
<br>
<a href="?page=a1&popup=1" class="btn blue add_page_lightbox"><i></i><span><span></span><i></i><?php echo ADD_NEW_SITE_TEXT; ?></span></a>
<br><br><br>
<table width=100% cellspacing=5 style="border-bottom: 1px solid; border-top: 1px solid; border-left: 1px solid; border-right: 1px solid;"><tr><td>
<a href="javascript:animatedcollapse.toggle('editors_div')">
<h2><?php echo EDITORS_TEXT;?><img src="images/e_c.png" border=0></h2></a>
</td></tr><tr><td>
<?php
unset($allowed_users);
//Get all users under the current admin
$q = "SELECT * FROM users WHERE parent = \"" . $session->user_db_id . "\" ORDER BY `name` ASC";
$result = mysql_query($q);
if (is_resource($result)) {
	while ($row = mysql_fetch_array($result)) {
	$allowed_users[] = $row["ID"];
	$allowed_users_names[] = $row["name"];
	}
} 
$editor_count = 0;
echo "<div id=\"editors_div\" style=\"display:none;\"><table width=100%>";
while ($editor_count < count($allowed_users)){
	echo "<tr><td width=\"382px\">" . $allowed_users_names[$editor_count] . '</td><td><a href="?page=u2&popup=1&check=' . $allowed_users[$editor_count] . '" class="btn blue editor_permissions_lightbox"><i></i><span><span></span><i></i>' . PERMISSIONS_TEXT . '</span></a></td><td><a href="?page=p2_d&popup=1&de=' . $allowed_users[$editor_count] . '&item=3" class="btn blue delete_lightbox"><i></i><span><span></span><i></i>' . DELETE_TEXT . '</span></a></td></tr>';
	echo '<tr><td colspan=3 style="border-bottom: 1px dotted;"></td></tr>';
	$editor_count = $editor_count + 1;
}
if ($editor_count == 0) {
	echo '<tr><td colspan=3>' . NO_EDITORS_FOUND_TEXT . '</td></tr>';
}
echo '<tr><td colspan=3><br><a href="?page=r1&popup=1" class="btn blue add_editor_lightbox"><i></i><span><span></span><i></i>' . ADD_NEW_EDITOR_TEXT . '</span></a></td></tr></table></div>';
echo "<script type=\"text/javascript\">animatedcollapse.addDiv('editors_div', 'fade=1')</script>";
}
echo "</td></tr></table>			";

if ($noborder!=1) {
?></div></div></div>
      <!-- end div#content -->
      <div id="sidebar">
       <ul><li><h2><?php echo WELCOME_TEXT;?></h2>
	   <?php if ($session->isAdmin()) {
			echo WELCOME_PAGE_RIGHT_ADMIN_TEXT;
		} else {
			echo WELCOME_PAGE_RIGHT_EDITOR_TEXT;
		}
?>
</li></ul>
      </div>

		
<?php
}
?>	 
<script type="text/javascript">
animatedcollapse.init()
</script>