drupal

How do I do an SQL join with a CSV file in php (drupal specifically)?

Hey guys, here is my problem. I am writing a Drupal module. A user uploads a CSV list of e-mail addresses to a server in a form. I need to do a JOIN on my database to get a list of unique addresses from the CSV file and the DB (No, it is not for spam :). How would I turn the uploaded CSV file into a format that I can do an SQL join on i...

Drupal Notifications - Users receiving duplicate emails

We are using Drupal (5.x) Notifications module. Our users are receiving duplicate emails (related to forum posts) First email has this subject line: "Your Daily xyz Discussion Digest" Second email has this subject line: "xyz subscription update for UserABC" Content is somewhat similar. (formatting is different). Tried to google for...

What's best Drupal deployment strategy?

I am working on my first Drupal project on XAMPP in my MacBook. It's a prototype and receives positive feedback from my client. I am going to deploy the project on a Linux VPS two weeks later. Is there a better way than 're-do'ing everything on the server from scratch? install Drupal download modules (CCK, Views, Date, Calendar) creat...

Multiple sections in Content Block for Drupal

How to create multiple sections in Content block in Drupal? When a user visits my homepage, a mainpage will be displayed; this page will contain a few sections at the middle panel. One of these sections would be a news update section, another would be a video channel, much like how mtv UK is looking in the middle portion of the homepag...

Show YouTube video in a Drupal Section

Thanks to the help of SOers, now I can create a few sections in a Drupal page using Panels module. I want to embed a YouTube video inside one of the section, anyway to do this? ...

Panel Template Reuse in Drupal

How to create a Panel template ( using Panels Module) in Drupal? The reason I ask this is because I have a Panel template to show information for different faculties. Each Faculty will have the same page layout, but the information displays within the page will be faculty specific. So I am thinking about passing arguments into the pane...

Move Nice Menus to Just below the Title

I can't get the Nice Menu ( located on the top left) down to below the title bar. (i.e., just above the word "Organize the information and make them accessible to the world") in Drupal. I tried to move the Nice Menu to content block in admin/build/block, but it will then be located at the bottom, below the content block and above the...

Content Top Drupal Theme

I am looking for existing themes that has content top region so that I can put my menu there. Any suggestion? ...

Best way to gather, then import data into drupal?

I am building my first database driven website with Drupal and I have a few questions. I am currently populating a google docs excel spreadsheet with all of the data I want to eventually be able to query from the website (after it's imported). Is this the best way to start? If this is not the best way to start what would you recommend?...

Need help choosing a framework for bilingual site

First, some background information... I'm coming up on a medium-scale website for a non-profit that will require both English and Korean translations. Feature-set includes: CMS for normal content, a blog, some form submission/handling (including CSV/PDF exports), a job posting board, a directory of related businesses and non-profits (tha...

Recommend PHP/MySQL CMS with paid/premium content support

I am looking at some solutions for building a site with a mix of free and paid/premium content (no, it's not porn). I gather that Drupal has the Premium plugin which supports this. I'm also looking at Expression Engine, which seems to have some built in support for this, although Paypal is the only payment option. I'm looking at aMe...

Drupal Site Map Module

I am looking for a module that can create sitemap in Drupal, as shown below: But couldn't find any. I tried Site Map module, but it can only generate a sitemap page; it can't create a sitemap block at the end of every page. I also tried site menu module, but it can't create a sitemap block as shown above, as well. Maybe it's just th...

How to display a list of nodes and details of a single node in Drupal

I would like a page that displays a list of nodes (I can do this part with the Views module) and then also displays the details of a single node below the list. Ideally the details will update via Ajax when a node in the list is clicked, but reloading the page would be fine for a start. I'm just starting to get into Drupal and the numbe...

User Registration Module for Drupal

Drupal uses email for user registration purpose. Instead of the out-of-box Drupal user registration that requires user to specify a username and email address, I want a full-fledged user registration form ( with captcha, user profile etc, like yahoo or gmail registration) for my website. Is there a module that does that? ...

What alternatives are there in OS projects for c# similar to Joomla/Mambo/Drupal?

I'm beginning a project with a client to build a web application and I'm a little stuck on which solution to go with. I've used Joomla for many clients in the past, but this client has specific requests that I KNOW I'm going to have to build myself. The problem I'm facing is that I work full time under the .NET spectrum and while I a...

Use SQL to Filter Drupal Views

I have a content type with a CCK integer field which takes a unix timestamp. I would like to create a view with a filter that takes the MySQL function "UNIX_TIMESTAMP": If there is no way of doing this, how can I alter the SQL generated for the view? ...

User Setting Module at the Top right corner ( Drupal)

Is there a Drupal module that allows me to put my user account information at the top right corner? ...

Passing Multiple Arguments from Panels into Views ( Drupal)

Anyone knows how to pass multiple arguments from Panels into a view in Drupal 6? Edit: I know how to pass one argument from Panels into Views, but not multiple arguments. ...

Creating Drupal CCK content programatically/ via API

Hi, I am working with a Drupal 6.x system to create exercise / personal training programmes, and am using the CCK with content types of Exercise and Programme, where Programme contains a few header fields and a list of node references to the exercises it consists of. This works great and I can manually create programmes which work fine....

Drupal 6: Altering a CCK form on a page created by the menu system

Hello, I'm a drupal newbie (but experienced with PHP). I've created some functions to display pages and mapped them onto urls using menu functions. In one of these functions, I'd like to grab a form for a CCK content type, have my way with it, and spit it out onto a template. So I have a function projectadmin_create_page(), which gra...