Zing Auction

Side note: Deleting directly with MySQL:
DELETE p, u FROM dru_profile_values p LEFT JOIN dru_users u ON p.uid = u.uid WHERE u.created > 1317450417

On to the long obsolete main show:

If you are unfortunate enough to be doing anything on Drupal 4.7, here is a bit of empathy.

If you have a 4.7 site, it probably has a lot of spam registrations. Drupal 4.7 doesn't have a multiple user delete. And Userplus module doesn't provide a very useful list in its multiple user delete.

CMarket was the best there was when I looked a couple years ago, and it looks like it's gotten financially worse. Before, they stated the up-front and percentage fees, and all I remember is that we could theoretically turn a profit doing it cheaper.

Now, that's hidden in the application process, except for this ill-advised boast:

"Customers earn an average of $5 for every $1 they invest - an astounding 400% return on their investment which is why cMarket has become the preferred online auction provider for schools and nonprofits nationwide." (cmarket.com/run-auction.htm)

As tested in phpMyAdmin:

SELECT SUM( `value` )
FROM `dru_ec_product_zing_auction` AS za
LEFT JOIN `dru_node` AS n ON za.nid = n.nid
WHERE STATUS > 0;

Drupalized:
SELECT SUM(value) FROM {ec_product_zing_auction} AS za LEFT JOIN {node} AS n ON za.nid = n.nid WHERE status > 0

As actually used in a Drupal module, zing_auction:

For a basic, but nice, usability improvement Drupal, for all pages where a form is the center of attention, the first form field that people should type in should have the keyboard focus given to it.

Here's a method for doing it with JQuery: http://www.gerd-riesselmann.net/development/focus-first-form-field-with-jquery

Adapted from Kathleen Murtaugh's How to make mass changes to nodes in Drupal, just replacing most of the interesting parts with simply node_delete.

Code for Amazing Things online fundraising auction, the Drupal 4.7 corpse i reanimate year after year.

Here is the recipe for the successful fundraising auction for the nonprofit community-building Amazing Things Arts Center.

This is a Drupal 4.7 site. Note that Agaric doesn't currently recommend using category module for new sites.

• is what I actually enabled for 2007

Auction site recipe:

cart
+ category
category_bulkedit
category_display
category_export
category_menu
category_outliner
category_pathauto
category_transform
category_views

contact
donate
+ image

find out what category vocabulary id drupal

probably easiest just to look in the database-- the vocabulary table lists names with vids, you can then go to the term_data table and sort by vocabulary if necessary, and look up your category by name.

Other option is to print_r everything about the category node.

For more, see:
http://drupal.org/node/113651

Resolution

We did it our way. Here's the messy, just-got-it-working

Annoying.