September 2006 - support - lists.drupal.org

Stopping bandwidth-leeching from MySpace
by Cameron Barrett 13 Sep '06

13 Sep '06

One of my clients running an online community on top of Drupal is reporting that nearly 40% of their monthly bandwidth is used up by MySpace bandwifth-leechers. If the leechers on MySpace were linking directly to a JPG, GIF, etc. I would know how to stop this using .htaccess RewriteEngine On RewriteCond %{HTTP_REFERER} ^http://(.+\.)?myspace\.com/ [NC,OR] RewriteRule .*\.(jpe?g|gif|bmp|png)$ - [F] But the problem is this particular Drupal installation uses the img_assist module which renders images like so: http://www.domain.com/img_assist/gen/1350 With no file suffix, which is required in the above .htaccess Rewrite example. Can someone help me with the correct regex for blocking bandwidth leeching for images rendered directly from the img_assist module. Thanks, Cameron Barrett http://www.camworld.com

1 0

programming question (drupal specific)
by VJ Rao 13 Sep '06

13 Sep '06

Whats the difference between these two code snippets (1 works, 2 doesnt) : 1) $nresult = db_query('SELECT n.nid, n.body, n.type, n.title, n.promote, n.moderate, n.teaser, n.created, n.changed, u.name FROM {node} n , {users} u, {term_node} tn, {users_roles} ur where n.uid = u.uid AND n.nid=tn.nid AND u.uid=ur.uid AND n.status = 1 AND n.created > %d ORDER BY n.created', $period); $nodes = array(); while ($node = db_fetch_object($nresult)) { $nodes[$node->nid] = $node; } 2) $nresult = mysql_query('SELECT n.nid, n.body, n.type, n.title, n.promote, n.moderate, n.teaser, n.created, n.changed, u.name FROM node n , users u,term_node tn, users_roles ur where n.uid = u.uid AND n.nid=tn.nid AND u.uid=ur.uid AND n.status = 1 AND n.created > $period ORDER BY n.created'); $nodes = array(); while ($row = mysql_fetch_array($nresult, MYSQL_NUM)) { $nodes[$node->nid] = $node; } Regads, V

1 0

custom breadcrumb question
by Ray Zimmerman 13 Sep '06

13 Sep '06

I have a page (Articles & Reviews) that uses Views to display two lists of nodes, tagged with the terms Articles and Reviews, respectively. Currently, when viewing the individual nodes, the breadcrumbs just show ... Home ... but I'd like it to show ... Home >> Resources >> Articles & Reviews What is the best way to accomplish this? In digging through some modules in core to get some ideas, I thought the following approach might work. Create a new module that implements a nodeapi hook for view, with something like ... // if node has the "Articles" or "Reviews" taxonomy term (how do I check for this?) $breadcrumbs[] = l(t('Home'), NULL); $breadcrumbs[] = l(t('Resources'), 'resources'); $breadcrumbs[] = l(t('Articles & Reviews'), 'resources/ articles_and_reviews'); drupal_set_breadcrumb($breadcrumbs); $breadcrumb = theme('breadcrumb', drupal_get_breadcrumb()); Am on on the right track, or is there a better way? Thanks, Ray

1 1

Re: [support] Re: XML in Drupal - Losing CSS Tags
by smangold 12 Sep '06

12 Sep '06

Makes sense. Unfortunately, I am a novice PHP person and have no idea how and where to do this. I did a search on the Drupal site and found nothing on this topic. Can someone tell me how to do this? TIA. Sue <Since you are echoing the output, it is not Drupal that is getting in the way. You need to look at the attribute parameter for the start_element_handler.>

1 0

strange array_keys error
by Domas Monkus 12 Sep '06

12 Sep '06

Hi, after a fresh install of drupal on my provider's server, I got these errors: * warning: array_keys() [function.array-keys]: The first argument should be an array in /home/newstyle/domains/newstyle.lt/public_html/tt/modules/user.module on line 351. * warning: implode() [function.implode]: Bad arguments. in /home/newstyle/domains/newstyle.lt/public_html/tt/modules/user.module on line 351. * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/newstyle/domains/newstyle.lt/public_html/tt/includes/database.mysql.inc on line 120. I created the database, it's accessible, so this can't be the cause. The one suspect (at least to me) is the fact that the server does not support the 'user' session save handler, so I'm forced to use 'files'. The software on the server is mysql 4.0.26 and php 4.4.4, the db schema was created from the correct (4.0) dump. The phpinfo() is here : http://dobilas.serveriai.lt/PHP/ If anybody's got any ideas as to why this may be so, I'm open to suggestions. Thanks in advance, Domas

2 2

Re: [support] Re: XML in Drupal - Losing CSS Tags
by Pat Collins 12 Sep '06

12 Sep '06

On Tue, 12 Sep 2006 10:53:25 -0400, "smangold" <smangold(a)columbus.rr.com> wrote : > This is a multi-part message in MIME format. > > > Thanks, Jeremy for the leads. Fabulous! > > I also need to be able to display XML without storing it in the MySQL database. I am using the code below to load it. This works fine EXCEPT that my CSS tags are getting stripped off. A tag in XML that says appears in the Drupal page as . In addition, and also get stripped off. The result is unformatted text. > > How do I fix this? Since you are echoing the output, it is not Drupal that is getting in the way. You need to look at the attribute parameter for the start_element_handler. Pat

1 0

Re: XML in Drupal - Losing CSS Tags
by smangold 12 Sep '06

12 Sep '06

Thanks, Jeremy for the leads. Fabulous! I also need to be able to display XML without storing it in the MySQL database. I am using the code below to load it. This works fine EXCEPT that my CSS tags are getting stripped off. A tag in XML that says appears in the Drupal page as . In addition, and also get stripped off. The result is unformatted text. How do I fix this? TIA Sue <?php $file = "whitepapers/overview.xml"; $map_array = array( "BOLD" => "B", "EMPHASIS" => "I", "LITERAL" => "TT", "bold" => "b", "emphasis" => "i", "literal" => "t" ); function startElement($parser, $name, $attrs) { global $map_array; if (isset($map_array[$name])) { echo "<$map_array[$name]>"; } } function endElement($parser, $name) { global $map_array; if (isset($map_array[$name])) { echo "</$map_array[$name]>"; } } function characterData($parser, $data) { echo $data; } $xml_parser = xml_parser_create(); // use case-folding so we are sure to find the tag in $map_array xml_parser_set_option($xml_parser, XML_OPTION_CASE_FOLDING, true); xml_set_element_handler($xml_parser, "startElement", "endElement"); xml_set_character_data_handler($xml_parser, "characterData"); if (!($fp = fopen($file, "r"))) { die("could not open XML input"); } while ($data = fread($fp, 4096)) { if (!xml_parse($xml_parser, $data, feof($fp))) { die(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser))); } } xml_parser_free($xml_parser); ?>

1 0

The Latest images block display problem
by jooomla 11 Sep '06

11 Sep '06

hi ,all I'll use the main content types that the "image node" does my website( image module + views module ), having of the article have a thumbnail image, having of the article have no thumbnail image, problem BE:If submit an article which has no thumbnail image, The Latest images block has no display ( nothingness), how make to submit an article without thumbnail image, does Latest images block can display an thumbnail image of article which has a thumbnail image in a term ( In before submit of the article )? Please help me! Thanks very much! jooomla

3 3

How do :Two rows display list page of a specific images term
by jooomla 11 Sep '06

11 Sep '06

hi,all I create a page view, display list page of a specific images term, the views-list-image_list.tpl.php and "function phptemplate_views_view_list_image_list($view, $nodes, $type) " of template.php was generated by the views theming wizard,views template to output one 'row' of a view. I hope views template to output two 'row' display list page of a specific images term (display thumbnail and article title), How do? Thanks very much!

1 0

How do :Two 'row' display list page of a specific images term
by jooomla 11 Sep '06

11 Sep '06

hi,all I create a page view, display list page of a specific images term, the views-list-image_list.tpl.php and "function phptemplate_views_view_list_image_list($view, $nodes, $type) " of template.php was generated by the views theming wizard,views template to output one 'row' of a view. I hope views template to output two 'row' display list page of a specific images term (display thumbnail and article title), How do? Thanks very much!

1 0