Showing last 4 news is in homepage but in center not in blocks
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 dont 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: 1. Drupal-Postgres-LDAP-FreeBSD (David King) 2. Re: theme search box button next to field (Franz Iberl) 3. 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 -- http://amazonas.the-dot.de ------------------------------ Message: 3 Date: Fri, 16 Jun 2006 10:44:33 +0300 From: Pherowze <pherowze@gmail.com> Subject: Re: [support] Menus To: support@drupal.org Message-ID: <b7436d290606160044s4337e83bw5c6f796a5544e174@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Thank you, It works like a charm... On 6/15/06, Metzler, David <metzlerd@evergreen.edu> wrote:
Yep this works. I've done similar things to make blocks appear on specific pages. You don't technically need path_auto to accomplish this. If you use the path module, you can manually set up each page with a path
(
e.g. news/todaysnews). What pathauto does for you is to automatically set the "path" alias names based on content type and/or taxonomy term plus the page title. You can always override a particular page by specifically setting its path, provided you have the path module enabled.
Menu sections can easily be reorganized into different blocks by following the basic steps.
1. Make sure menu module is enabled and add a menu item. 2. Make sure you have administer menu priviledges. 3. Make a new menu block using "Add a Menu" under Administer->Menus 4. Move or add a menu item to your new menu by changing its "Parent Item" to the newly created menu. 5. Now go to Administer->Blocks to control the placement of your newly created menu block in the normal way, as well as which paths it might appear on.
Dave
------------------------------ *From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Pherowze *Sent:* Thursday, June 15, 2006 6:43 AM *To:* support@drupal.org *Subject:* Re: [support] Menus
Path auto?....Let me find out what it is and how to use it... Kobus, I was unable to separate the menus using block admin pages...
Thanks.
On 6/15/06, Greg Knaddison - GVS <Greg@growingventuresolutions.com> wrote:
On 6/15/06, Kobus Myburgh <ITBJDM@puknet.puk.ac.za> wrote:
...I have the main header with the primary links
which never changes regardless of the section... on the menubar on the left or right of the page I will have a submenu which will change whenever I go to a different section......
Can this be achieved using drupal...? If so how....?
You can use a custom block with php if-then conditions or switches. Not sure if there is an easier way.
If you don't know how to code, it is perhaps better to make separate blocks with the menu links in them and only set their visibility in block admin pages, otherwise you can make one block with different PHP conditions to display the links as they should be per page.
If you use pathauto to create your paths for you then you could set up a system that splits your "different sections" into different URLs on the site such as:
forum/ blog/ news/
And then create blocks appropriate for those sections and in the block visibility settings set the blocks to only show on forum/* pages or blog/* pages as appropriate.
With pathauto it's possible to separate by either node type (as shown above) or by the lowest weighted taxonomy term in the lowest weighted taxonomy.
Regards, Greg
-- Greg Knaddison | Growing Venture Solutions Denver, CO | http://growingventuresolutions.com Technology Solutions for Communities, Individuals, and Small Businesses -- [ Drupal support list | http://lists.drupal.org/ ]
-- Warmest Regards,
Pherowze
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Warmest Regards, Pherowze
On Saturday 17 June 2006 00:09, 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
It's not PHP, but maybe it will help: administer >> settings >> posts (admin/settings/node) >> Number of posts on main page: >> set to 4 >> Save configuration administer >> settings >> content types (admin/settings/content-types) >> news configure >> check Promoted to front page >> Save configuration Optional: administer >> settings >> content types (admin/settings/content-types) >> story configure >> uncheck Promoted to front page >> Save configuration (repeat for any node type you do not want showing up on the first page) If you already have any news nodes that you want displayed on the front page: administer >> content (admin/node) >> select "edit" for any nodes to change >> Publishing options >> check Promoted to front page >> Submit (or Preview >> Submit) (repeat for any node you want showing up on the first page) -- Jason Flatt http://www.oadae.net/ Father of Six: http://www.flattfamily.com/ (Joseph, 13; Cramer, 11; Travis, 9; Angela; Harry, 5; and William, 12:04 am, 12-29-2005) Linux User: http://www.sourcemage.org/ Drupal Fanatic: http://drupal.org/
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:
1. Drupal-Postgres-LDAP-FreeBSD (David King) 2. Re: theme search box button next to field (Franz Iberl) 3. 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
participants (3)
-
bunset＠dconsultia.es -
Effennel -
Jason Flatt