Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Information Pages Unlimited


toyicebear

Recommended Posts

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 by toyicebear
Link to comment
Share on other sites

I am still stuck for ideas about how to make it workable, anyone up for the challenge? B)

Link to comment
Share on other sites

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.....

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...