♥toyicebear Posted January 12, 2005 Share Posted January 12, 2005 (edited) Hi.... I am currently working on making it possible to add a picture in the admin for Information Pages Unlimited..... Done so far.... 1. added extra field to mysql 2. modified information.php (catalog side) to read out the picture from the mysql. 3. modified information_form.php (admin side)with an added browse picture field and button. 4. modified information_manager.php (admin side) to add info into the new mysql field. So far so good..... The problem is i need 2 functions added to information_manager.php 1. add only file name for pictures to the mysql . (Now the whole path gets added) 2. upload the choosen picture and add it to the image folder... Is there anyone out there who could help me out....... Here is the full information_manager.php file: <?php /* Module: Information Pages Unlimited File date: 2003/03/02 Based on the FAQ script of adgrafics Adjusted by Joeri Stegeman (joeri210 at yahoo.com), The Netherlands osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . 'information.php'); function browse_information () { global $languages_id; $query="SELECT * FROM " . TABLE_INFORMATION . " WHERE languages_id=$languages_id ORDER BY v_order"; $daftar = mysql_db_query(DB_DATABASE, $query) or die("Information ERROR: ".mysql_error());$c=0; while ($buffer = mysql_fetch_array($daftar)) {$result[$c]=$buffer;$c++;} return $result; } function read_data ($information_id) { $result=mysql_fetch_array(mysql_db_query(DB_DATABASE, "SELECT * FROM " . TABLE_INFORMATION . " WHERE information_id=$information_id")); return $result; } $warning=tep_image(DIR_WS_ICONS . 'warning.gif', WARNING_INFORMATION); function error_message($error) { global $warning; switch ($error) { case "20":return "<tr class=messageStackError><td>$warning ." . ERROR_20_INFORMATION . "</td></tr>";break; case "80":return "<tr class=messageStackError><td>$warning " . ERROR_80_INFORMATION . "</td></tr>";break; default:return $error; } } $languages = tep_get_languages(); $languages_array = array(); $languages_selected = DEFAULT_LANGUAGE; for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { $languages_array[] = array('id' => $languages[$i]['code'], 'text' => $languages[$i]['name']); if ($languages[$i]['directory'] == $language) { $languages_selected = $languages[$i]['code']; } } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <?php if (HTML_AREA_WYSIWYG_DISABLE_IPU == 'Enable') { ?> <script language="Javascript1.2"><!-- // load htmlarea //MaxiDVD Added WYSIWYG HTML Area Box + Admin Function v1.7 <head> _editor_url = "<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_ADMIN; ?>htmlarea/"; // URL to htmlarea files var win_ie_ver = parseFloat(navigator.appVersion.split("MSIE")[1]); if (navigator.userAgent.indexOf('Mac') >= 0) { win_ie_ver = 0; } if (navigator.userAgent.indexOf('Windows CE') >= 0) { win_ie_ver = 0; } if (navigator.userAgent.indexOf('Opera') >= 0) { win_ie_ver = 0; } <?php if (HTML_AREA_WYSIWYG_BASIC_IPU == 'Basic'){ ?> if (win_ie_ver >= 5.5) { document.write('<scr' + 'ipt src="' +_editor_url+ 'editor_basic.js"'); document.write(' language="Javascript1.2"></scr' + 'ipt>'); } else { document.write('<scr'+'ipt>function editor_generate() { return false; }</scr'+'ipt>'); } <?php } else{ ?> if (win_ie_ver >= 5.5) { document.write('<scr' + 'ipt src="' +_editor_url+ 'editor_advanced.js"'); document.write(' language="Javascript1.2"></scr' + 'ipt>'); } else { document.write('<scr'+'ipt>function editor_generate() { return false; }</scr'+'ipt>'); } <?php }?> // --></script> <?php } ?> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"> <table border=0 width="100%"> <tr><?php echo tep_draw_form('languages', 'information_manager.php', '', 'get'); ?><td align="right"><?php echo tep_draw_pull_down_menu('language', $languages_array, $languages_selected, 'onChange="this.form.submit();"'); ?></td> </form></tr> <? switch($adgrafics_information) { case "Added": $data=browse_information(); $no=1; if (sizeof($data) > 0) {while (list($key, $val)=each($data)) {$no++; } } ; $title="" . ADD_QUEUE_INFORMATION . " #$no"; echo tep_draw_form('',FILENAME_INFORMATION_MANAGER, 'adgrafics_information=AddSure'); include('information_form.php'); break; case "AddSure": function add_information ($data) { global $languages_id; $query ="INSERT INTO " . TABLE_INFORMATION . " VALUES(null, '$data[visible]', '$data[v_order]', '$data[info_title]', '$data[info_image]','$data[description]','$languages_id')"; mysql_db_query(DB_DATABASE, $query) or die ("Information ERROR: ".mysql_error()); } if ($v_order && $info_title && $description) { if ((INT)$v_order) { add_information($HTTP_POST_VARS); $data=browse_information(); $title="" . tep_image(DIR_WS_ICONS . 'confirm_red.gif', CONFIRM_INFORMATION) .SUCCED_INFORMATION . ADD_QUEUE_INFORMATION . " $v_order "; include('information_list.php'); } else {$error="20";} } else {$error="80";} break; case "Edit": if ($information_id) { $edit=read_data($information_id); $data=browse_information(); $button=array("Update"); $title="" . EDIT_ID_INFORMATION . " $information_id"; //echo form("$PHP_SELF?adgrafics_information=Update", $hidden); echo "<tr class=pageHeading><td align=center>"; echo tep_draw_form('',FILENAME_INFORMATION_MANAGER, 'adgrafics_information=Update'); echo tep_draw_hidden_field('information_id', "$information_id"); include('information_form.php'); } else {$error="80";} break; case "Update": function update_information ($data) { mysql_db_query(DB_DATABASE, "UPDATE " . TABLE_INFORMATION . " SET info_title='$data[info_title]', description='$data[description]', visible='$data[visible]', v_order=$data[v_order] WHERE information_id=$data[information_id]") or die ("update_information: ".mysql_error()); } if ($information_id && $description && $v_order) { if ((INT)$v_order) { update_information($HTTP_POST_VARS); $data=browse_information(); $title="$confirm " . UPDATE_ID_INFORMATION . " $information_id " . SUCCED_INFORMATION . ""; include('information_list.php'); } else {$error="20"; } } else {$error="80";} break; case 'Visible': function tep_set_information_visible($information_id, $visible) { if ($visible == '1') { return tep_db_query("update " . TABLE_INFORMATION . " set visible = '0' where information_id = '" . $information_id . "'"); } else{ return tep_db_query("update " . TABLE_INFORMATION . " set visible = '1' where information_id = '" . $information_id . "'"); } } tep_set_information_visible($information_id, $visible); $data=browse_information(); if ($visible == '1') { $vivod=DEACTIVATION_ID_INFORMATION; }else{$vivod=ACTIVATION_ID_INFORMATION;} $title="ID: $information_id $confirm $vivod"; include('information_list.php'); break; case "Delete": if ($information_id) { $delete=read_data($information_id); $data=browse_information(); $title="" . DELETE_CONFITMATION_ID_INFORMATION . " $information_id"; echo "<tr class=pageHeading><td align=center><br><br>$title</td></tr>"; echo "<tr><td></td></tr><tr><td align=center><br><br>"; echo tep_draw_form('',FILENAME_INFORMATION_MANAGER, "adgrafics_information=DelSure&information_id=$val[information_id]"); echo tep_draw_hidden_field('information_id', "$information_id"); echo tep_image_submit('button_delete.gif', IMAGE_DELETE); echo '<a href="' . tep_href_link(FILENAME_INFORMATION_MANAGER, '', 'NONSSL') . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; echo "</form></td></tr>"; } else {$error="80";} break; case "DelSure": function delete_information ($information_id) { mysql_db_query(DB_DATABASE, "DELETE FROM " . TABLE_INFORMATION . " WHERE information_id=$information_id"); } if ($information_id) { delete_information($information_id); $data=browse_information(); $title="$confirm " . DELETED_ID_INFORMATION . " $information_id " . SUCCED_INFORMATION . ""; include('information_list.php'); } else {$error="80";} break; default: $data=browse_information(); $title="" . MANAGER_INFORMATION . ""; include('information_list.php'); } if ($error) { $content=error_message($error); echo $content; $data=browse_information(); $no=1; if (sizeof($data) > 0) {while (list($key, $val)=each($data)) {$no++; } } ; $title="" . ADD_QUEUE_INFORMATION . " $no"; echo tep_draw_form('',FILENAME_INFORMATION_MANAGER, 'adgrafics_information=AddSure'); include('information_form.php'); } ?> </script> </table> </td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Edited January 12, 2005 by toyicebear Quote Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here] Link to comment Share on other sites More sharing options...
♥toyicebear Posted January 12, 2005 Author Share Posted January 12, 2005 I am still stuck for ideas about how to make it workable, anyone up for the challenge? B) Quote Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here] Link to comment Share on other sites More sharing options...
♥toyicebear Posted January 18, 2005 Author Share Posted January 18, 2005 By using the html area php image manager i now have it up and running, but its not a streamlined solution........ So if there is anyone out there with good php coding skills who could refine it to a smoothly coded addition it could be posted as a contribution add on for Information Pages Unlimited..... Quote Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here] Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.