Amazing Things Auction Site

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:

<?php
/**
 * Prepare user input for use in a database query, preventing SQL injection attacks.
 */
function db_escape_string($text) {
  global $active_db;
  if (is_array($text)) {  // three lines added for testing
    drupal_set_message('<pre>'. var_export(debug_backtrace(),TRUE) .'</pre>');
  }
  return mysql_real_escape_string($text, $active_db);
}

No answer:
How Can I Search Unpublished Content?
http://drupal.org/node/300803

Romania had a similar issue:
Can't access unpublished content that needs editing
http://drupal.ro/node/2394

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

Notes from the start of Grassroots Fundraising: Secrets to Sustainability with Kim Klein

http://www.namac.org/article.cfm?id=1&aid=1334&monly=0

Charitable giving in the United States comes from:

Warning: How not to write documentation

The below - which has been accurately documented elsewhere I think - demonstrates the danger of documenting as one goes, instead of figuring something out and then documenting.

More category-specific information: To change the number of items (nodes) shown on a category page, go to Administer » Settings » Posts ( admin/settings/node ) and change the number of posts on main page.

Nope, apparently I'm wrong.

Ah yes, naturally:

Administer » Settings » Category
admin/settings/category

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