X-Git-Url: http://git.osdn.net/view?p=nucleus-jp%2Fnucleus-next.git;a=blobdiff_plain;f=nucleus%2Fupgrades%2Fupgrade0.96.php;h=4d0f2694e224f24d9a50e605163ea3c55682741d;hp=8099dfe0dddb3788edc2765c9f7cc0a5e38a0e8f;hb=c90b0980cfa3e79cd4bc7eed551a64a5e2b02a5c;hpb=6575e866f3fd1938601432841d80f82e9d259265
diff --git a/nucleus/upgrades/upgrade0.96.php b/nucleus/upgrades/upgrade0.96.php
index 8099dfe..4d0f269 100644
--- a/nucleus/upgrades/upgrade0.96.php
+++ b/nucleus/upgrades/upgrade0.96.php
@@ -74,17 +74,15 @@ function upgrade_do96() {
// 6. add 'imagepopup' skincontents in skin 'default'
$query = 'SELECT sdnumber FROM '.sql_table('skin_desc')." WHERE sdname='default'";
- $res = sql_query($query);
- $obj = mysql_fetch_object($res);
- $skinid = $obj->sdnumber;
- $query = 'INSERT INTO '.sql_table('skin')." VALUES (" . $skinid . ", 'imagepopup', '\r\n
\r\n <%imagetext%>\r\n \r\n\r\n\r\n <%image%>\r\n\r\n');";
+ $res = DB::getValue($query);
+ $query = 'INSERT INTO '.sql_table('skin')." VALUES (" . $res . ", 'imagepopup', '\r\n\r\n <%imagetext%>\r\n \r\n\r\n\r\n <%image%>\r\n\r\n');";
upgrade_query("Adding 'imagepopup' skinparts",$query);
// 7. add POPUP_CODE, MEDIA_CODE, IMAGE_CODE to ALL templates
$query = 'SELECT tdnumber FROM '.sql_table('template_desc');
- $res = sql_query($query); // get all template ids
- while ($obj = mysql_fetch_object($res)) {
- $tid = $obj->tdnumber; // template id
+ $res = DB::getResult($query); // get all template ids
+ foreach ( $res as $row ) {
+ $tid = $row['tdnumber']; // template id
$query = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'POPUP_CODE', '<%popuplink%>');";
$query2 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'MEDIA_CODE', '<%media%>');";