Drupal Blog

MySQL Order by before Group by

konordo — Wed, 08 Feb 2012 00:51:29 +0000

In a custom module, I needed to get the latest node that each user published. It is fairly easy to goup by users, but it needs a little something to actually accomplish the sorting.

The following query worked for me, we need to do the sorting in a nested select:


pager_query("SELECT * FROM (SELECT * FROM node order by created DESC) as node WHERE nid IN ($placeholders)  GROUP BY uid",10,0,$count_query);

In case the following error comes up:


Error: 1248 - SQLSTATE: 42000 ER_DERIVED_MUST_HAVE_ALIAS

Create an ubercart order programmatically and update address and products.

konordo — Mon, 31 Oct 2011 19:19:48 +0000

One of my latests tasks was to allow a link that would take a user id and a node id as an argument, and automatically create a new order that would have some fields pre populated and ready for further editing. Scope is to use the user id as the client that does the order and to automatically select the product depending on the taxonomy term of the provided node.

In my case I offer a series of links through a custom view template, that uses data from each row results to built the link.

Here is the code for my module, hopefully it will be useful for someone:


<?php

Remove duplicate entries from views results... the hard way.

konordo — Tue, 25 Oct 2011 22:27:46 +0000

In some cases it is seems impossible to get rid of the duplicate entries that views return in the output.
Not an elegant way, but this small module would do the trick...

So let's create a module the usual way, and put the following code in the .module file.
This one is called remove_duplicates.

 
<?php
function remove_duplicates_views_pre_render(&$view)
{
  $used_nids = array();

          foreach ($view->result as $row)
      {
        if (!in_array($row->nid, $used_nids))
        {
          $new_view_result[] = $row;
          $used_nids[] = $row->nid;

Drupal - Load user's Content Profile, given the UID

konordo — Sun, 28 Aug 2011 10:24:06 +0000

There are so many reasons to use Content Profile instead of the user's core profile. For once, profiles are created as separate nodes and therefore the full flexibility of CCK and VIews come in the game. This way it is possible to build some really sophisticated profiles, which is usually what is needed for any website.

I had to look around for an easy solution on how to load the user's content profile programmatically, so the following might come in helpful.

How to test cron in Centos

konordo — Sun, 03 Jul 2011 16:13:16 +0000

Here you can find some simple tests that would confirm the smooth functionality of your crontab.

Test if cron is running

Type the following command:

ps ax | grep cron

Make sure that cron shows up. Expected output should be something like


[konordo@konordoserv]# ps ax | grep cron
 1185 pts/1    S+     0:00 grep cron
 1771 ?        Ss     0:00 crond

Test if cron is working

Add the following entry to your crontab. To do so, enter the command

crontab -e