On Fri, Feb 24, 2006 at 02:18:46PM -0500, Moshe Weitzman wrote:
the only solution that is even somewhat workable in my small brain is to warn the user and then upgrade all the sites at once
Here are my thoughts at this moment: * Gather the $db_prefix settings from sites/*/settings.php (as previously mentioned). * Add a function to update.php called something like update_db_query() that replaces db_query() for the update process. This function does the table name prefixing then stores an MD5 hash of the prefixed SQL. Save that hash in an array via variable_set(). Before executing a query, check if the hash exists yet or not. If it exists, move on, otherwise, run the query. Sound reasonable? Other ideas? --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409