User login

Home ›
 Need

Need

Fastest way to check if anything is in a MySQL table

Submitted by Benjamin Melançon on December 18, 2007 - 7:54pm
in

http://forums.mysql.com/read.php?101,50600,50853#msg-50853

Vail wrote:

> When it checks to see if the
> group exists, however, and the table is empty, it
> always returns an error, which disables the script
> that calls the function.

Why not doing a simple

select count(*) from groups

?

Locale subset module motivation: remove, hide, get rid of non-public UI strings

Submitted by Benjamin Melançon on December 18, 2007 - 6:47pm
in

Background:

http://hojtsy.hu/blog/2007-oct-10/comparison-your-localization-options-drupal-5-and-6

Doing the World Social Forum site right now has brought up two questions for me:

First, is there a way to tell either the translation interface or a PO export to ignore all strings in /admin pages?

File: 
application/zip iconzing_auction_47_v3-beta.zip

Landing Pages in Drupal

Submitted by Benjamin Melançon on December 14, 2007 - 2:38pm
in

How to do landing pages in Drupal?

Using panels to allow for an infinite number

http://highervisibilitywebsites.com/hyper-dynamic-drupal-sites-part-i

But for Agaric's current needs we need a somehow-different menu on each landing page.

Custom page.tpl.php template files based on path

Cerating "Landing Pages" in Drupal

Copy (or inherit) taxonomy terms from one node to another

Submitted by Benjamin Melançon on December 12, 2007 - 10:06pm
in

function wsf_action_copy_terms($from_nid, $to_nid, $avoid_race = FALSE) {
// agaric-ben @TODO optimize;
// see http://agaricdesign.com/note/copy-taxonomy-terms-from-one-node-another
  if ($avoid_race) {
    // avoid pseudo race condition from taxonomy_node_get_terms static variable

Combining one-to-one mysql tables into a single table

Submitted by Benjamin Melançon on December 11, 2007 - 8:08pm
in

Merging tables does not mean what I want it to mean-- it refers to tables with the same schema.

I simply want to join two tables into one on a unique key.

To do that very easily

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

These are the tables Agaric needs to condense into one:

RE: Node access module (based on users listed in userreference fields)

Submitted by Benjamin Melançon on December 11, 2007 - 8:56am
in

I created a module (attached, in case you're curious) that's a user reference widget. When placed on a node type, it will hide itself and fill itself in from the URL with the person the request is being made of. When a node with the field on it is submitted, it emails the person.

What I need is a way to allow the user in the user reference field the same rights to the node as the author of the node. So for all access control, they should be treated the same.

Do you think that's something you can / want to do?

Thanks,

Michelle

open source free software RSS feed reader

Submitted by Benjamin Melançon on December 4, 2007 - 10:06am
in

Agaric is trying out Blog Bridge:

http://www.blogbridge.com/

Because it's FOSS and cross-platform.

Resolution

php get last item in an array

Submitted by Benjamin Melançon on December 4, 2007 - 9:54am
in

Untested:

$sys_name = current(end(implode($path)));

Resolution

A, B, C, D... Ordered Lists in HTML with CSS

Submitted by Benjamin Melançon on December 4, 2007 - 9:06am
in

http://www.w3.org/TR/CSS21/generate.html#list-style

list-style-type: upper-alpha

See roottruth stylesheet for implementation.

Resolution

Syndicate content