All pastes #616257 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-07-12 15:28 UTC
rendered paste body
<pre>
<?
$nid=$node->nid;
$sqlStat1="SELECT count FROM node_hit WHERE nid='$nid'";
$sqlRes1=mysql_query($sqlStat1);
$num=mysql_num_rows($sqlRes1);
if($num){
	$row=mysql_fetch_array($sqlRes1);
	$count=$row['count'];

	$count=$count+1;
		
	$sqlStat="UPDATE node_hit SET count='$count' WHERE nid='$nid'";
	$sqlRes=mysql_query($sqlStat);
}
else{
	$sqlStat="INSERT INTO node_hit VALUES('','$nid','1')";
	$sqlRes=mysql_query($sqlStat);
}

$sqlResult=db_query('SELECT vid FROM vocabulary WHERE name="Companies"');
$row=db_fetch_object($sqlResult);
$vid=$row->vid;


//print l($node->links[comment_add][title],$node->links[comment_add][href]);exit;
//print $node->nid;exit;
//print_r($node->links['comment_add']);exit;
//print sizeof($taxonomy);exit;
//print $node->links['comment_add']['fragment'];exit;
//print $node->links['comment_add']['href'];exit;
//print_r($node->field_image);exit;
//[links][print][href]
//print_r($comment);exit;
//print $node->links['comment_add']['href'];exit;
//print $node->field_author[0]['view'];exit;
$print_publication_date=$node->field_print_publication_date[0]['value'];
$print_publication_date=strtotime($print_publication_date);
$print_publication_date=date('l, d F Y',$print_publication_date);
//$body=$node->content['body']['#value'];
//$body=$node->content['field_bitch']['#value'];
//$body=substr($body,0,100);
if($node->field_image[0]['filepath']){
	$path1=$node->field_image[0]['filepath'];
	if($node->field_caption_1[0]['value']) $caption1="<p class=\"caption\">".$node->field_caption_1[0]['value']."</p>";
	else $caption1="";
	$pic_block_1="<div class=\"articlePhoto\">
					<img src=\"$path1\" alt=\"\" width=\"230\" height=\"165\" />$caption1
		  		  </div>";
}
else $pic_block_1="";

if($node->field_image_0[0]['filepath']){
	$path2=$node->field_image_0[0]['filepath'];
	if($node->field_caption_2[0]['value']) $caption2="<p class=\"caption\">".$node->field_caption_2[0]['value']."</p>";
	else $caption2="";
	$pic_block_2="<div class=\"articlePhoto\">
					<img src=\"$path2\" alt=\"\" width=\"230\" height=\"165\" />$caption2
				  </div>";
}
else $pic_block_2="";

$comment="<a href=" . base_path() . $node->links['comment_add']['href'] ."#". $node->links['comment_add']['fragment'].">Add Comment</a>";
//print $comment;exit;
?>
</pre>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Communicate.ae | the Middle East’s marketing and advertising resource</title>
<link type="text/css" rel="stylesheet" href="<?php print base_path() . path_to_theme() ?>/c/homepage.css" media="screen" />
<!--[if IE]>
<link rel="stylesheet" type="text/css" href="<?php print base_path() . path_to_theme() ?>/c/ie.css" />
<![endif]-->
</head>
<body class="inside">
<div id="wrapper">
  <div id="container">

<!-- Header -->
    <div id="masthead">
      <h1><a href="<?=base_path()?>">Communicate</a></h1>
      <ul id="login_nav">
        <li><a href="#"><strong>Login</strong></a></li>
        <li><strong>|</strong></li>
        <li><a href="#"><strong>Register</strong></a></li>
      </ul>
      <ul id="sub_nav">
        <li><a href="<?=base_path()?>">Home</a></li>
        <li><a href="#">Advertise</a></li>
        <li><a href="#">Subscribe</a></li>
        <li><a href="#">Contact Us</a></li>
      </ul>
    </div>

<div id="leftCol">   
<!-- Main Navigation -->
    <div id="nav_container">
      <ul id="main_nav">
        <li id="nav_showcase"><a href="showcase.htm" title="Ad Showcase">Ad Showcase</a></li>
        <li id="nav_events"><a href="events.htm" title="Events">Events</a></li>
        <li id="nav_archive"><a href="archive.htm" title="Archive">Archive</a></li>
        <li id="nav_data"><a href="data.htm" title="Data Center">Data Center</a></li>
        <li id="nav_gallery"><a href="gallery.htm" title="Photo Gallery">Photo Gallery</a></li>
      </ul>
    </div>

<div id="articleCol">
<ul class="articleHead">
<li id="headline"><?=$node->title?></li>
<li id="subhead"><?=$node->field_subhead[0]['value'];?></li>
<li id="who">by <span class="underline"><?=$node->field_author[0]['value'];?></span> on <?=$print_publication_date?></li>
</ul>

<div id="articleCopy" class="left">
<ul class="tools">
<li class="tool-print"><a href="<?=$node->links['print']['href']?>">Print</a></li>
<li class="tool-mail"><a href="<?=$node->links['forward_links']['href']?>">E-mail</a></li>
<li class="tool-rss"><a href="#">RSS Feeds</a></li>
<li class="tool-comment"><?=$comment?></li>
</ul>
<?=$node->content['body']['#value']?>

<ul class="tools">
<li class="tool-print"><a href="<?=$node->links['print']['href']?>">Print</a></li>
<li class="tool-mail"><a href="<?=$node->links['forward_links']['href']?>">E-mail</a></li>
<li class="tool-rss"><a href="#">RSS Feeds</a></li>
<li class="tool-comment"><?=$comment?></li>
</ul>

</div>
</div>

<div id="articleSidebar">
<?=$pic_block_1?>

<div id="readMore">
<h3>Read More</h3>
<ul>
<?
$taxonomy=$node->taxonomy;
foreach ($taxonomy as $key => $value){
	if($value->vid==$vid){
		$tid=$value->tid;
		print "<li><a href=\"".base_path()."search/node/$value->name\">$value->name</a></li>";
	}
}
?>
</ul>
</div>

<?=$pic_block_2?>
</div>
 </div>
<!-- Sidebar starts -->
    <div id="sidebar">
    <div id="sidewrapper">

        <div class="advertisement">
<?php
$block = module_invoke('views', 'block', 'view', 'adv1');
print $block['content'];
?></div>

<!-- Search -->  
       <div id="Search">
          <h2>Search</h2>
        </div>
        
        
<!-- Poll --> 
        <div id="Poll">
          <h2>Poll</h2>
        </div>
        
<!-- Most Emailed Articles -->
        <div id="emailedArticles">
          <h2>Most E-mailed Articles</h2>
          <ul>
<?
$sqlResult=mysql_query('SELECT nid FROM node_hit ORDER by count DESC LIMIT 0,6');
while ($row=mysql_fetch_array($sqlResult)) {
	$snid=$row['nid'];
	$snode=node_load($snid);
	print "<li><a href=\"".base_path()."node/$snid\">$snode->title</a></li>";
}
?>
          </ul>
        </div>

<!-- Latest News -->
        <div id="latestNews">
          <h2>Latest News</h2>
          <ul>
<?php
$block = module_invoke('views', 'block', 'view', 'latestnews');
print $block['content'];
?>
          </ul>
        </div>


        <div class="advertisement">
<?php
$block = module_invoke('views', 'block', 'view', 'adv2');
print $block['content'];
?>
</div>
      </div>
    </div>
    <!-- Sidebar ends -->

 </div>
<!-- Footer -->
  <div id="footer" class="clear"><p>&copy; 2007 Communicate, All Rights Reserved. <a href="#" target="_blank">Terms &amp; Conditions.</a></p>
  </div>
  
</div>
<?
drupal_get_form('comment_form');
?>
<!-- div#wrapper ends -->
</body>
</html>
<?
exit;
?>