Here is a bit of code that my set you a good path. I use it in a block myself, but I can see why you wouldn't be able to insert in in your home page template.
It's actually an adaptation from http://drupal.org/node/23232. In this case, the scripts displays the fist 80 characters (actually cuts after a complete word within the first 80 characters) of items with taxonomy ids 21 and 27.
<?php /** * Creates a list of node titles selected from multiple category terms * in descending chronological order (most recent first). * Titles link to full node. * * To change category terms to select from, * edit the $taxd_id numbers, retaining the "" marks. * * To change the number of node titles, edit the $list_no number. * * This snippet is tested with Drupal 4.6.x * */ $taxo_id = "26, 27"; $list_no =3; $query = "SELECT DISTINCT(n.nid), n.title, n.teaser, n.created FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid WHERE tn.tid in ($taxo_id) AND n.status = 1 ORDER BY n.created DESC LIMIT $list_no"; $sql = db_rewrite_sql($query); $result = db_query($sql); $items = array(); while ($anode = db_fetch_object($result)) { $blurb = strip_tags($anode->teaser); $i= 80; $blurb = substr($blurb , 0, $i); //take the first 80 characters while($i >= 0){ //cuts the blurb at the end of the last complete word if(!ereg(' $', $blurb)){ $i--; continue; } break; } $items[]= l("<span class="newsdate">" . format_date($anode->created, $type = 'custom', $format = 'd.m.y') . "</span><br />" . $anode->title . "<br />" . $blurb . "...<br /><span class="newsmore">MORE </span>", "node/$anode->nid", array(), NULL, NULL, FALSE, TRUE); }
if(count($items)) { return theme('item_list',$items); } ?>
Francis
bunset@dconsultia.es wrote:
Hi! I want to show last 4 news of my CCK type called "news" but in center of homepage, not in blocks, inside the node I mean, so I need a php code to show it, I was trying but nothing Anybody knows ?
Bye for now, David from Dconsultia.es
-----Mensaje original----- De: bunset@dconsultia.es [mailto:bunset@dconsultia.es] Enviado el: sábado, 17 de junio de 2006 4:28 Para: 'support@drupal.org' Asunto: showing last 4 news
Hi! I have created a new content type with CCK called "news", I am trying show in home page last 4 news but I don’t get the correct snippet for it. Anybody can guided me please? Regards,
David from dconsultia.es (Spain)
-----Mensaje original----- De: support-bounces@drupal.org [mailto:support-bounces@drupal.org] En nombre de support-request@drupal.org Enviado el: viernes, 16 de junio de 2006 14:00 Para: support@drupal.org Asunto: support Digest, Vol 42, Issue 21
Send support mailing list submissions to support@drupal.org
To subscribe or unsubscribe via the World Wide Web, visit http://lists.drupal.org/listinfo/support or, via email, send a message with subject or body 'help' to support-request@drupal.org
You can reach the person managing the list at support-owner@drupal.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of support digest..."
Today's Topics:
- Drupal-Postgres-LDAP-FreeBSD (David King)
- Re: theme search box button next to field (Franz Iberl)
- Re: Menus (Pherowze)
Message: 1 Date: Thu, 15 Jun 2006 19:27:59 -0700 From: David King dking@ketralnis.com Subject: [support] Drupal-Postgres-LDAP-FreeBSD To: support@drupal.org Message-ID: D1FCD04C-F3B3-43FB-88E8-E120F65147CF@ketralnis.com Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
My name is David King, I am having trouble with LDAP users logging on
I have a very vanilla Drupal (v4.6.6) install, except that it is installed on Postgres, I have the LDAP authentication module installed, and it is installed on FreeBSD (all three are installed via the FreeBSD Ports system).
When I try to have an LDAP user log in, the user is created in the database, and looks like this:
$ psql drupal drupal=# select uid,name,data from users; uid | name | data -----+-------
+-----------------------------------------------------------------------
0 | | 1 | admin | a:1:{s:5:"roles";a:1:{i:0;s:1:"2";}} 2 | dking | a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s:17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=DN>";} (3 rows)
But the user is presented with a blank page after several seconds. In the log are dumped many (a hundred or so) Postgres errors of the following forms:
pg_query(): Query failed: ERROR: multiple assignments to same column "changed" in /usr/local/www/drupal/includes/database.pgsql.inc on line 45.
query: UPDATE users SET uid = '2', name = 'dking', pass = '47c6b15aca93873f58522f26300d181d', mail = 'dking@<censored=domain>', mode = '0', sort = '0', threshold = '0', theme = '', signature = '', created = '1150424378', changed = '1150424378', status = '1', timezone = '', language = '', picture = '', init = '', data = 'a:3:{s: 5:"roles";a:1:{i:0;s:1:"2";}s:17:"ldap_authentified";b:1;s: 7:"ldap_dn";s:38:"<censored=dn>";}', data = 'a:3:{s:5:"roles";a:1:{i: 0;s:1:"2";}s:17:"ldap_authentified";b:1;s:7:"ldap_dn";s: 38:"<censored=dn>";}', changed = 1150424379 WHERE uid = 2 in /usr/ local/www/drupal/includes/database.pgsql.inc on line 62.
The errors seem to alternate between those two.
I can't delete the user in the database, because if I go to Administer > Users > dking (the username) > Edit, I get the browser error that the server has closed the connection.
How can I go about troubleshooting/debugging this? Does anyone have any ideas?
Some more potentially useful information:
~% uname -a FreeBSD <> 5.3-RELEASE-p20 FreeBSD 5.3-RELEASE-p20 #2: Fri Sep 9 14:11:12 PDT 2005 root@<>:/usr/obj/usr/src/sys/ROUTERKERNEL i386
~% pkg_info | grep drupal drupal-4.6.6_2006031700 CMS that supports pgsql and mysql drupal-ldap_integration-4.6.0_20060117 LDAP user authentication for the Drupal CMS
~% psql --version psql (PostgreSQL) 8.0.8
Message: 2 Date: Fri, 16 Jun 2006 08:37:13 +0200 From: Franz Iberl f.iberl@amazonas-box.de Subject: Re: [support] theme search box button next to field To: support@drupal.org Message-ID: d56558947547037902b3c5585a99fb38@amazonas-box.de Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello again,
I know the code is correct. It displays correctly in this node: http://www.animecards.org/node/74
ok, the button 'submit' which fits in the node obiously does not fit in the orange box at the left side.
#search .form-text { width: 8em; float: left }
try e.g. 5em ?
in a hurry Franz