September 2008 - support - lists.drupal.org

Contact form anti-spam protection
by Mark Shropshire 10 Sep '08

10 Sep '08

I use the built in Drupal site wide contact form on a number of sites. It seems that spammers find the form and start to do their thing fairly quickly. Especially on our University web sites which have a lot of exposure. I am looking for recommendations for anti-spam protection for the contact form. I have used the captcha module and the spam module in the past. Are those still the best approach or are there other options for best practice? I have also signed up for an account on http://mollom.com/. Figured that may be another alternative, but haven't checked to see if the mollum module works for forms other than Drupal comments. Thanks! Mark

3 2

couple of issues with an sql query and theming a db query
by Neil: esl-lounge.com 10 Sep '08

10 Sep '08

I posted on the d.o forum yesterday about putting together a sql query for a block in which users are listed according to the total pageviews their content had received. I got one or two suggestions but nothing concrete so waded in to try and get it done myself. I've come up against both sql problems and theming issues too. The two relevant tables are node and node_counter, so if we take some example data: node nid uid 1 1 2 2 3 1 4 1 5 2 node_counter nid totalcount 1 15 2 22 3 9 4 17 5 6 so I'm looking for a block that gives me: USER PAGEVIEWS John (uid 1) 41 Ned (uid 2) 28 so far, I have this: <table><tr><td>Title</td><td>Pageviews</td></tr> <?php $uid = $account->uid; $query= "SELECT node.title, node.nid, node_counter.totalcount FROM node INNER JOIN node_counter ON node.nid = node_counter.nid WHERE uid = $uid ORDER BY totalcount DESC LIMIT 5"; $results = db_query($query); while($output = db_fetch_object($results)){ print "<tr><td>"; print "<a href=\"/node/$output->nid\">"; print $output->title; print "</a>"; print "</td><td>"; print $output->totalcount; print "</td></tr>"; } ?> </table> which gives me the top 5 viewed pages for each user on their main /user page. It's very handy and I think I'll use it. Can someone give me a pointer to go the next step towards my initial aim, the total of a user's pageviews and then a list of the top X users on a site based on pageviews. I know I need to use SUM in the sql statement but I don't seem to be able to get the syntax right. My other question regards the theming of the output. You can see from my code that I've manually built the links...is there an easier way to do it. I've used "$output .= node_title_list($result);" before but that was just for a list of node titles, not for a table with 2-3 cols in it. Is there another theme function for what I'm trying to do? thanks in advance for any hints you can give. Neil

3 4

Fw: Books and blocks
by Sunil Kumar 10 Sep '08

10 Sep '08

Hi All, Need help please. I have four books in my site. They are to be arranged to according to the subject of the book. Two books belongs to Tutorial section. (That means they are tutorials) Other two books are about Performance (This will deal with how to perform an act etc) I want two separate blocks to view these books with heading Tutorials and Performance. Under Tutorials, two books dealing with learning will be listed and other two books will be under the heading "Performance" I would like to use two separate blocks (one for tutorial and other one for Performance) and those blocks to be displayed one in left side (Tutorial) and other in right side (Performance). How can I do that? I am a newbie and dont have know coding. Regards, -S- http://chintha.com http://vayanasala.blogspot.com

2 1

How to change Upcoming Event behavior?
by A-NO-NE Music 10 Sep '08

10 Sep '08

v5.10 Event 5.1.0, The default behavior of Upcoming Event deletes item from the list when the starting time has passed. I need to keep listing all the events of the day. In other words, I want items to be deleted from the list when local time hits 12:01 AM. I have been searching for the answer but to no avail. Any help would be appreciated. -- - Hiro Hiroaki Honshuku, A-NO-NE Music, Greater Boston http://a-no-ne.com http://anonemusic.com

2 1

CRON not run
by bharani kumar 10 Sep '08

10 Sep '08

Hi friends Tell me alternate way to RUN the CRON, Approximetly am having around 30000 records, So manually running cron goes to failure state, so Tell the another way to run the CRON... advance Thanks for great ideas

6 11

sub-sections for content types
by Mehul Ved 08 Sep '08

08 Sep '08

Hi, I am using drupal 6.x. I need to implement the following on my website. I have a section called news. Now, withing News section, I need to sub-divide it into various sections e.g. banking sector, hospitality sector, food chain, etc. Users can browse through the news according to the sections they are interested in or view all the news items. How can this be achieved? Couple of possible ways we have been identifying are 1) A module to create sub-sections, then the user can be presented with a list of sections to choose from. 2) Set up tags such that all the news will be tagged and users can select from the tags. Any way to implement this? Or any other way the idea can be implemented? With Regards, Mehul Ved.

2 1

Re: [support] Problem with TinyMCE
by Lev Lafayette 08 Sep '08

08 Sep '08

----- "Daniel Carrera" <daniel.carrera(a)zmsl.com> wrote: > Lev Lafayette wrote: > >> 1. User is editing a page using TinyMCE. > >> 2. User clicks submit. > >> 3. A pop-up appears saying: > >> > >> *Confirm* > >> Are you sure you want to navigate away from this page? > >> The changes you made will be lost if you navigate away from > this > >> page. > >> Press OK to continue or Cancel to stay on the current page. > >> [Cancel] [OK] > >> > > > > They should select "Update" that's on the bottom right of the > TinyMCE menu, then "Submit". > > Where? I can't find it anywhere. My TinyMCE has three rows of buttons, > > but no menus. And none of the button says Update. > Ahh, my apologies. I was referring to editing the html source via TinyMCE, which I prefer using. It brings up a new window which has update on the bottom-left (not right as I said). When editing TinyMCE directly I can't replicate the error message that you're receiving. Sorry for leading you up the wrong path! -- Lev Lafayette (03) 9925 4909 Systems Administrator 110 Victoria St Carlton South, 3053

3 6

Finding pages for a user
by Daniel Carrera 08 Sep '08

08 Sep '08

Hello, Is there a way to get a list of all nodes created by a given user? What if a user creates a page and forgets the URL? How can he find his pages again? Thanks, Daniel.

2 5

Problem with TinyMCE
by Daniel Carrera 08 Sep '08

08 Sep '08

Hello, I have a problem: 1. User is editing a page using TinyMCE. 2. User clicks submit. 3. A pop-up appears saying: *Confirm* Are you sure you want to navigate away from this page? The changes you made will be lost if you navigate away from this page. Press OK to continue or Cancel to stay on the current page. [Cancel] [OK] I don't understand why it says that. Clicking Submit *is* the right way to save your changes, right? What's more confusing, the program is lying. If you click OK and navigate away from the page the changes *are* saved. Any ideas? Thanks.

2 2

Insert CSS in all pages
by Daniel Carrera 07 Sep '08

07 Sep '08

Hello, There is a block of CSS that I like to use. Is there a way to add it to every page in a way that does not rely on the theme? If I just add the CSS to the theme, when the user switches to a different theme the CSS is gone. One (ugly) option is to add the CSS directly to the pages where I use it (it's only a few, really) but it is "bad practise" to put <style> tags inside the body element. Not only that, but another user might use TinyMCE to edit the page and TinyMCE will remove the <style> tags! I can't really blame TinyMCE for this. Technically the <style> tags are wrong. And other than that, TinyMCE really doesn't mangle my HTML the way most HTML editors do. Anyways, does anyone have any ideas? I guess I could edit each of the themes I have, but I'd rather not do that much work. Thanks. Daniel.

2 1