<?php if (isset(//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <!-- DW6 --> <head> <!-- Copyright 2005 Macromedia, Inc. All rights reserved. --> <title>Climate Portal Content Management System</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link rel="stylesheet" href="cms.css" type="text/css" /> <style type="text/css"> <!-- .style1 {color: #FFFFFF} .style3 {color: #CCFFCC} .style5 {font-size: 24px} .style6 {color: #D4D0C8} --> </style> </head> <body bgcolor="#cccccc"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="15" nowrap="nowrap"><img src="file:D|/Program%20Files/%5Bwebdesign%5D/dreamweaver%208/Dreamweaver%208/Configuration/BuiltIn/StarterPages/mm_spacer.gif" alt="" width="15" height="1" border="0" /></td>
<td height="74" colspan="3" class="logo" nowrap="nowrap"><br /> <span class="style1"> CLIMATE<span class="style3">PORTAL</span> <span class="style5">CMS</span></span> </td> <td width="4"> </td> <td width="574"> </td> </tr> <tr bgcolor="#ffffff"> <td colspan="6"></td> </tr> <tr bgcolor="#a4c2c2"> <td width="15" nowrap="nowrap"> </td> <td height="36" colspan="3" id="navigation" class="navText"></a> <span class="style6">ADD ITEM </a> EDIT ITEM </a> CATEGORIES </a> USER MANAGEMENT</a></span> RSS ADMIN</a></span></td> <td width="4"> </td> <td width="574"> </td> </tr> <tr bgcolor="#ffffff"> <td colspan="6"><img src="file:D|/Program%20Files/%5Bwebdesign%5D/dreamweaver%208/Dreamweaver%208/Configuration/BuiltIn/StarterPages/mm_spacer.gif" alt="" width="1" height="1" border="0" /></td>
</tr> <tr bgcolor="#ffffff"> <td colspan="2" valign="top" bgcolor="#a4c2c2"> </td> <td width="50" valign="top"><img src="file:D|/Program%20Files/%5Bwebdesign%5D/dreamweaver%208/Dreamweaver%208/Configuration/BuiltIn/StarterPages/mm_spacer.gif" alt="" width="50" height="1" border="0" /></td>
<td width="536" valign="top"><br /> <br /> <table border="0" cellspacing="0" cellpadding="0" width="600"> <tr> <td width="600" class="pageName"><p>Edit an Embedded Video </p></td> </tr> <tr> <td class="bodyText"> <?php contentid = title = addslashes(contentdate = addslashes(sourcename = addslashes(sourceurl = addslashes(binary = addslashes(state = addslashes(description = addslashes(videoformat = addslashes(videoresolution = addslashes(videocode = addslashes(videolength = addslashes(videosize = addslashes(update = health = politics = wildlife = energy = business = climate = pollution = technology = lifestyle = environment = region = keywords = update){ echo "ID IS: query = "UPDATE content, content_type_video set content.content_title = 'contentdate', content.content_binary = 'sourcename', content.content_sourceurl = 'state', content.content_description = 'videoformat', content_type_video.video_resolution = 'videolength', content_type_video.video_size='contentid AND content_type_video.content_id=query2= "UPDATE content_matrix set content_matrix.health='politics', content_matrix.wildlife='energy', content_matrix.business='climate', content_matrix.pollution='technology', content_matrix.lifestyle='environment', content_matrix.region='contentid'"; keywords)); contentid'"; query3); if(!keywords as word = trim(query3 = "INSERT ignore into keywords (keyword_id, keyword_name) values ('', 'result3 = mysql_query(result) { die('Invalid query: ' . mysql_error()); } word'"; query3); if(!row = mysql_fetch_array(keywordid = query3 = "INSERT into content_keywords (content_keyword_id, content_id, keyword_id) values ('', 'keywordid')"; query3); if(!result = mysql_query(result2 = mysql_query(result) { die('Invalid query: ' . mysql_error()); } } contentid' AND content_type_video.content_id ='result = mysql_query(result) { die('1: Invalid query: ' . mysql_error()); } contentid'"; query2); if(!query3 = "SELECT * FROM `keywords`, `content_keywords` where content_keywords.content_id='result3 = mysql_query(result3) { die('3: Invalid query: ' . mysql_error()); } result); result2); row['content_binary']; ?> <form method="post" enctype="multipart/form-data" action=""> <table> <tr> <td width="150"> Title: </td> <td> <input type="text" name="title" size="30" value="<?php echo </td> </tr> <tr> <td width="150"> Date: </td> <td> <input type="text" name="date" size="30" value="<?php echo row['content_date']; ?>"/> </td> </tr> <tr> <td width="150"> Video Code: </td> <td> <textarea rows="10" cols="20" name="videocode"><?php echo </textarea> </td> </tr> <tr> <td width="150"> Sourcename: </td> <td> <input type="text" name="sourcename" size="30" value="<?php echo row['content_source_name']; ?>"/> </td> </tr> <tr> <td> Source url: </td> <td> <input type="text" name="sourceurl" size="30" value="<?php echo </td> </tr> <tr> <td width="150"> Content state: </td> <td> <input type="text" name="contentstate" size="30" value="<?php echo row['content_state']; ?>"/> <tr> <td width="150"> Content Description: </td> <td> <input type="text" name="contentdescription" size="30" value="<?php echo </td> </tr> <tr> <td> Categories: </td> <td> Health: <input type="checkbox" name="health" value="1" <?php health=health == "1"){echo " CHECKED";}?>> <br /> Politics: <input type="checkbox" name="politics" value="1" <?php row2['politics']; if(<br /> Wildlife <input type="checkbox" name="wildlife" value="1" <?php wildlife=wildlife == "1"){echo " CHECKED";}?>> <br/> Energy <input type="checkbox" name="energy" value="1" <?php row2['energy']; if(<br /> Business <input type="checkbox" name="business" value="1" <?php business=business == "1"){echo " CHECKED";}?>> <br /> Climate <input type="checkbox" name="climate" value="1" <?php row2['climate']; if(<br /> Pollution <input type="checkbox" name="pollution" value="1" <?php pollution=pollution == "1"){echo " CHECKED";}?>> <br /> Technology <input type="checkbox" name="technology" value="1" <?php row2['technology']; if(<br /> Lifestyle <input type="checkbox" name="lifestyle" value="1" <?php lifestyle=lifestyle == "1"){echo " CHECKED";}?>> <br /> Environment <input type="checkbox" name="environment" value="1" <?php row2['environment']; if(<br /> </td> </tr> <tr> <td width="150"> Video Format: </td> <td> <input type="text" name="videoformat" size="30" value="<?php echo row['video_format']; ?>"/> </td> </tr> <tr> <td width="150"> Region: </td> <td> <input type="text" name="region" size="30" value="<?php echo </td> </tr> <tr> <td width="150"> Keywords: </td> <td> <input type="text" name="keywords" size="30" value="<?php while(row3 = mysql_fetch_array(row3['keyword_name']; echo " "; } ?> "/> </td> </tr> <tr> <td></td> <td><input type="submit" value="Update" name="update" /> </td> </tr> </table> <input type="hidden" name="contenttype" value="3"> <input type="hidden" name="contentid" value="<?php echo </form> <p><br /> </p></td> </tr> </table> </td> <td width="4"> </td> <td width="574"> </td> </tr> <tr> <td colspan="6"> <img src="file:D|/Program%20Files/%5Bwebdesign%5D/dreamweaver%208/Dreamweaver%208/Configuration/BuiltIn/StarterPages/mm_spacer.gif"
alt="" width="1" height="1" border="0" /></td> </tr> <tr> <td width="15"> </td> <td width="4"> </td> <td width="50"> </td> <td width="536"> </td> <td width="4"> </td> <td width="574"> </td> </tr> </table> </body> </html>
(C) A. Eliƫns 2/9/2007
You may not copy or print any of this material without explicit permission of the author or the publisher.