PDA

View Full Version : Couple questions before upgrade


ehm
May 15th, 2007, 02:23 PM
I do have a Photopost version 5.11
Now, I upgrade my UBBThreads to version 7.1.1 and I would like to upgrade the Photopost too. Both are integrated.
Question number 1: is Photopost ready to work with UBBThreads 7.1.1?

Second question: to pay for the update what I have to do is just renew my membership ($39)?

Thank you
EHM

Chuck S
May 15th, 2007, 02:33 PM
Yes to gain access to the new code you must update your members access and Photopost 5.62 can integrate with ubbthreads 7 you will need to run a query to change your integration type

UPDATE pp_settings SET setting='threads7' WHERE id=41

ehm
May 15th, 2007, 02:36 PM
Yes to gain access to the new code you must update your members access and Photopost 5.62 can integrate with ubbthreads 7 you will need to run a query to change your integration type

UPDATE pp_settings SET setting='threads7' WHERE id=41


OK, I'm going to the update area right after this, but can you please clarify what I have to do with that query?
I'm very noob with SQL.
Do I run that from photopost install? or after the install, from the SQL menu?

THnak you

ehm
May 15th, 2007, 02:39 PM
How long take to update the 'members access' after payment? (Credit Card)

ehm
May 15th, 2007, 02:40 PM
Dou!... I used a different e-mail to do the update...
Sorry... how can I fix it now?? totally my fault... sorry...

Chuck S
May 15th, 2007, 03:40 PM
Customer service processes orders you can email them at custserv@photopost.com

As far as running the query you do so in your site control panel using phpmyadmin or you add that query like so under the upgrade script like so


$query = array();
$query[] = "UPDATE {$pp_db_prefix}settings SET setting='threads7' WHERE id=41";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (84,'PhotoPost Version','pversion','','5.61',53,0);";
$query[] = "CREATE TABLE IF NOT EXISTS {$pp_db_prefix}favorites (id int(12) NOT NULL auto_increment,
userid int(8) NOT NULL default '0',
photo int(11) NOT NULL default '0',
PRIMARY KEY (id), KEY parent (photo), KEY userid (userid)) TYPE=MyISAM";

for ( $x=0; $x < count($query); $x++) {
$iquery = $query[$x];
$setup = mysql_query($iquery, $link);
if ( !$setup ) print "Error performing MySQL command: $iquery<br><b>Error: ".mysql_error($link)."</b><br><br>";
}