By taherk on

Hi All,

With all the great work going on drupal showcase , I was hesitant on whether or not to post my first novice attempt.

The site is http://csqa.info and it is my first live drupal site out of 4 more under construction.

I would appreciate comments, feedback and suggestions, which will help me in my future projects.

Thanks a lot to this great community

Tk

⋅ Categories: Drupal 4.7.x

Comments

Jimmy Neutron’s picture

Jimmy Neutron commented

Hey,

Great site. What code did you use to get the Forum topics displaying like that on your homepage?

taherk’s picture

taherk commented

Thanks...
I am using views to display "Latest Forum Topics"
______________________________________
Cheap domains @whiz.in

edrupalec’s picture

edrupalec commented

are you using dashboard to get the 2 columns in the center?
-----
Drupal ecommerce, at http://www.drupalecommerce.com is a new site written using language that Drupal beginners and intermediate users can understand. Quick links to "Modules" and "Module Groupings."

taherk’s picture

taherk commented

No,

I used only frontpage and php snippets .

A simple HTML table to divide it into two columns
______________________________________
Cheap domains @ http://whiz.in

dkaps’s picture

dkaps commented

Hey taherk:

I would like to have a similar front_page for my site sapprofessionals.org.. can you pls share your code for that... I would be grateful!!

Also how did you show the Top Posters and No. of Members block? What code/module did you use?

Thanks in advance!
Dkaps

taherk’s picture

taherk commented

Sorry for the late reply, here is the code, I have used an image and put hotspots there. 

<img name="Untitled1" src="files/images/welcome.jpg" width="600" height="275" border="0" usemap="#m_Untitled1" alt=""><map name="m_Untitled1">
<area shape="rect" coords="17,131,142,260" href="forum/2" alt="" >
<area shape="rect" coords="149,135,274,261" href="/drp/node/add/blog" alt="" >
<area shape="rect" coords="288,142,409,260" href="/drp/node/155" alt="" >
<area shape="rect" coords="422,142,545,256" href="/drp/forum" alt="" >
<area shape="rect" coords="378,93,507,120" href="/drp/poll" alt="" >
<area shape="rect" coords="377,65,506,88" href="/drp/node/31" alt="" >
<area shape="rect" coords="375,36,561,61" href="/drp/node/257" alt="" >
<area shape="rect" coords="376,8,507,34" href="/drp/donate" alt="" >
</map>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="601" id="AutoNumber1" height="20" >

  <tr>
    <td width="307" colspan="2" height="0" bgcolor="#d9d9d9">
    <h3 align="center">Top Weblinks</h3>
   
 </td>
    <td width="306" colspan="2" height="0"  bgcolor="#d9d9d9">
     <h3 align="center">Most Commented</h3>
</td>
  </tr>
  </table>
 <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="601" id="AutoNumber1" height="242" >

  <tr>
    <td width="307" colspan="2" height="1">

<?php
$nlimit = 10;
$result1 = db_query(db_rewrite_sql("SELECT n.title, wn.clicks, w.lid 
,wn.nid FROM {node} n
  INNER JOIN {links_node} wn ON n.nid = wn.nid
  INNER JOIN {links} w ON wn.lid = w.lid
WHERE n.type = 'weblink'
  AND n.status = 1
  AND n.moderate = 0
ORDER BY wn.clicks DESC
LIMIT $nlimit"));

while ($node = db_fetch_object($result1)) {
  $items1[] = l($node->title, 'links/goto/' . $node->nid.'/'.$node->lid.'/links_weblink'). "($node->clicks)" ;
}
print theme_item_list($items1);
?>
</td>
    <td width="306" colspan="2" height="1">

    <p align="center"><?php $most_popular = db_query('SELECT ncs.nid, n.title, n.created, ncs.comment_count FROM {node_comment_statistics} ncs JOIN {node} n ON n.nid = ncs.nid ORDER BY ncs.comment_count DESC LIMIT 0 , 8');
while($popular_post = db_fetch_object($most_popular)) {
$comment_date = date('m/d/Y', $popular_post->created);
$output[] = l($popular_post->title, "node/$popular_post->nid") . "($popular_post->comment_count)<br />created: $comment_date";
}
print theme_item_list($output);
?></td>
  </tr>
  </table>

______________________________________
Cheap domains @ http://whiz.in

Mormac’s picture

Mormac commented

Your site is a great example of how simle colours and layout can come together to make a fantastic looking site.

taherk’s picture

taherk commented 
<?php $users = db_query("SELECT COUNT(nid) AS count, {users}.uid, {users}.name FROM {node} LEFT JOIN {users} ON {node}.uid = {users}.uid WHERE {node}.uid != 0 GROUP BY uid ORDER BY count DESC LIMIT 5");
while ($user = db_fetch_object($users)) {
print "<a href=\"blog/".$user->uid."\">".$user->name."</a><br>";
}
?>

<?php $users1 = db_query("SELECT Count(uid) as count1 from users");
while ($user1 = db_fetch_object($users1)) {
print "<br>Total members: ".$user1->count1;
}
?>

______________________________________
Cheap domains @ http://whiz.in

dkaps’s picture

dkaps commented

Thanks so much taherk!!

Libervisco’s picture

Libervisco commented

Thanks Taherk! Your code was useful to me as well. :)

midtoad’s picture

midtoad commented

How would you modify this code to add a display of the total number of posts actually made by each user?

thanks
S

Toxid’s picture

Toxid commented

I would like it to show only how many members are registered on the site. I guess I'll use this code:

<?php
$users1 = db_query("SELECT Count(uid) as count1 from users where status = '1'");
while ($user1 = db_fetch_object($users1)) {
print "<br>Total members: ".$user1->count1;
}
?>

But what would need to be added to make this work on a multidomain site?