? lastfmsimple.postgres.patch.txt Index: lastfmsimple.install =================================================================== RCS file: /cvs/drupal-contrib/contributions/modules/lastfmsimple/lastfmsimple.install,v retrieving revision 1.1 diff -u -p -r1.1 lastfmsimple.install --- lastfmsimple.install 16 Apr 2008 16:08:05 -0000 1.1 +++ lastfmsimple.install 3 Dec 2008 21:33:29 -0000 @@ -36,7 +36,7 @@ function lastfmsimple_schema() { 'type' => 'serial', 'not null' => TRUE, ), - 'user' => array( + 'usr' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, @@ -86,7 +86,7 @@ function lastfmsimple_schema() { ), 'primary key' => array('fid'), 'unique keys' => array( - 'user_type' => array('user', 'feed_type'), + 'user_type' => array('usr', 'feed_type'), ), 'indexes' => array( 'feed_updated' => array('updated'), Index: lastfmsimple.module =================================================================== RCS file: /cvs/drupal-contrib/contributions/modules/lastfmsimple/lastfmsimple.module,v retrieving revision 1.1 diff -u -p -r1.1 lastfmsimple.module --- lastfmsimple.module 16 Apr 2008 16:08:05 -0000 1.1 +++ lastfmsimple.module 3 Dec 2008 21:33:30 -0000 @@ -105,7 +105,7 @@ function lastfmsimple_show_feed($user, $ } // Get the feed. - $feed = db_fetch_object(db_query("SELECT * FROM {lastfmsimple_feed} WHERE user = '%s' AND feed_type = '%s'", $user, $type)); + $feed = db_fetch_object(db_query("SELECT * FROM {lastfmsimple_feed} WHERE usr = '%s' AND feed_type = '%s'", $user, $type)); if ($feed === FALSE) { // New feed. @@ -210,7 +210,7 @@ function _lastfmsimple_new_feed($user, $ } // Insert into the database. - db_query("INSERT INTO {lastfmsimple_feed} (user, feed_type, updated, modified, expires, current_count, max_count, fetches, updates) VALUES ('%s', '%s', %d, %d, %d, %d, %d, 1, 1)", $user, $type, time(), $request['headers']['Last-Modified'], $request['headers']['Expires'], $count, $request['max_count']); + db_query("INSERT INTO {lastfmsimple_feed} (usr, feed_type, updated, modified, expires, current_count, max_count, fetches, updates) VALUES ('%s', '%s', %d, %d, %d, %d, %d, 1, 1)", $user, $type, time(), $request['headers']['Last-Modified'], $request['headers']['Expires'], $count, $request['max_count']); // Feed ID. $id = db_last_insert_id('lastfmsimple_feed', 'fid'); @@ -236,11 +236,11 @@ function _lastfmsimple_update_feed(&$fee if ($count === NULL) { // Count is not being changed, use the current count and fetch using the Last-Modified header. $count = (int) $feed->current_count; - $request = _lastfmsimple_fetch_feed($feed->user, $feed->feed_type, $feed->modified); + $request = _lastfmsimple_fetch_feed($feed->usr, $feed->feed_type, $feed->modified); } else { // Count is being changed, fetch without the Last-Modified header. - $request = _lastfmsimple_fetch_feed($feed->user, $feed->feed_type); + $request = _lastfmsimple_fetch_feed($feed->usr, $feed->feed_type); } if ($request === FALSE) {