- support - lists.drupal.org

sanitizing text box input for sql searches (custom search)
by spartaguy spartaguy 03 Mar '10

03 Mar '10

Hello, I want to use the data from a textbox input to do a select statement on a sql db. Are there any inbuilt methods that drupal uses to sanitize textbox inputs? I'm worried if I accept data in a textbox and apply it to an sql command it will do bad stuff (tm). Is there a simple code snippet or module for sanitizing? Paul

5 8

I Need List Position Integer for Class Names for Dynamically Generated List Items
by Shai Gluskin 03 Mar '10

03 Mar '10

Gang, I'm overriding the function theme_item_list() and I want to output (in addition to $classes) something like: <li class="item 1"> <li class="item 2"> At first I thought that the lists I needed this for were going to be generated by Views, which would have made this task a snap because Views comes with views/theme/views-view-list.tpl.php which has row number available as a variable. But the content is being delivered by the Related content module ( http://drupal.org/project/relatedcontent) and doesn't make it's data available to Views. Are all the list items for a particular parent available as an object or an array and then a could do a "while" loop with +1 increments after each loop. I'm just kind a stuck cause I thought I had solved it by finding that Views template only to be disappointed. Note that all of the items on the relevant lists are at the same top leve... no annoying children :) Thanks in advance for the help. Shai

2 1

View that renders multiple object types. Possible?
by Unai Rodriguez 03 Mar '10

03 Mar '10

Dear All, We are trying to build a page where a user can SEARCH for (at least) the following object types: USERS, COMMENTS and NODES. Ideally we would like to use ONE VIEW only which renders ALL of these mentioned TYPES. How could we achieve this? Would anyone suggest module(s) or technique(s) to get this working? Thank you so much, unai

2 1

Ubertcart, userpoints and buy userpoint
by Michel Morelli 03 Mar '10

03 Mar '10

Hi all. I have installed end enabled Ubercart, userpoints and userpoints_ubercart. Now I need to create a product that permit to buy userpoints. I have searched and searched, without a way to make this. But I know that this possibility is real. So, where is my error ? Why I can not found a Docs/Howto that explain me this ? Tnx. -- Michel 'ZioBudda' Morelli michel(a)ziobuddalabs.it Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660 http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN: michel(a)ziobuddalabs.it JABBER: michel(a)ziobuddalabs.it

2 2

Opening menu links in new windows?
by Luke 03 Mar '10

03 Mar '10

Hello I have a client who wants a couple of the primary links to open in a new window. I looked through the various menu modules, but none seem to have the capability to allow target element manipulation. Is there some known way to do this? I thought also of making a frameset in a static HTML file, linking the menu to that, and keeping the source site open that way, but that is clugie, and non-drupal-esq, at least I think. Thanks Luke

2 2

creating drop down menu on a page
by spartaguy spartaguy 02 Mar '10

02 Mar '10

Hi, I am having problems setting up a drop down menu on a page. The page content is PHP. I would like to have a drop down menu with a few fields (ie name/date/size) that people can choose from. This selection would then be stored as DROP_DOWN_FIELD below. <?php $result = db_query("SELECT * FROM {fruits} ORDER BY $DROP_DOWN_FIELD DESC"); while ($row = db_fetch_object($result)) { $fields = array(); // define empty array array_push($fields,$row); // push row object onto the array print_r($row); */ ?> Can anyone provide any help?? I have been trying for ages without any luck. Paul

2 1

Blocks and views or coding in page-front.tpl.php
by Ole Kerpel 02 Mar '10

02 Mar '10

Hi all, I have a HTML design and I am transferring it into Drupal templates. There is a table with four cells on the homepage (and on the homepage only). In each cell there are a maximum of three titles of the most recent items. Each of the four cells represent a different contenttype. I created a block with the right content for the first cell, but I got stuck constructing the table and its content with templates. More specific, I got stuck on understanding the "display", "row", "style" and "field" parts of the view section. Because it took me too long I ended up writing php code in the page-front.tpl.php file. Would anyone of you suggest to go and use blocks the way I first tried it and if so - how? Thanks in advance for the trouble taken, Kerpel

2 2

Panels or block ?
by Michel Morelli 02 Mar '10

02 Mar '10

Hi all. I'm rebuilding site and I have a "performance problem" with a page. This page needs to contain text (node body) and a block from a view. Now, I can link the block in the "content" region and via block's settings I can say Drupal to display this block only when the users are viewing that page. But I could have the need to have some other pages of this type (with other blocks). My question: is this (block-region) the best solution or is better to use "panel" module ? And: is the panel modules load for every page or only when it's required ? Statistic of this site say me that the page views are 1.5M+, 50% are from forum and other 50% are internal page. This particolar page generate 10K+ page views. Tnx for all. M. -- Michel 'ZioBudda' Morelli michel(a)ziobuddalabs.it Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660 http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN: michel(a)ziobuddalabs.it JABBER: michel(a)ziobuddalabs.it

4 5

training options in the Pacific Northwest
by LESLIE FRIESEN 02 Mar '10

02 Mar '10

Good morning, Does anyone have any recommendations for training options in either Washington or Oregon, US? Also, I've seen the info for the 2010 Drupalcon in San Francisco. Is this an annual event that is only held in one location? Or might there be a later one scheduled in either Portland or Seattle? Thanks in advance, Leslie Friesen Polk County, OR friesen.leslie(a)co.polk.or.us

2 1

Theme Like This Site?
by Luke 01 Mar '10

01 Mar '10

I am wanting to duplicate (not by choice) the layout and design elements of this site: http://www.charliegracie.com Does anyone have any recommendations for themes or a theme which might put me on the right track? My ability to find one is hampered by my vision problems, which makes it very hard to know, without reading hundreds of lines of CSS, whether a theme aligns with what is needed. Thanks in advance for any ideas. Regards, Luke

1 0