$artists_name); if ($action == 'insert') { $insert_sql_data = array('date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); zen_db_perform(TABLE_RECORD_ARTISTS, $sql_data_array); $artists_id = zen_db_insert_id(); } elseif ($action == 'save') { $update_sql_data = array('last_modified' => 'now()'); $sql_data_array = array_merge($sql_data_array, $update_sql_data); zen_db_perform(TABLE_RECORD_ARTISTS, $sql_data_array, 'update', "artists_id = '" . (int)$artists_id . "'"); } if ($_POST['artists_image_manual'] != '') { // add image manually $artists_image_name = $_POST['img_dir'] . $_POST['artists_image_manual']; $db->Execute("update " . TABLE_RECORD_ARTISTS . " set artists_image = '" . $artists_image_name . "' where artists_id = '" . (int)$artists_id . "'"); } else { $artists_image = new upload('artists_image'); $artists_image->set_destination(DIR_FS_CATALOG_IMAGES . $_POST['img_dir']); if ( $artists_image->parse() && $artists_image->save()) { // remove image from database if none if ($artists_image->filename != 'none') { $db->Execute("update " . TABLE_RECORD_ARTISTS . " set artists_image = '" . $_POST['img_dir'] . $artists_image->filename . "' where artists_id = '" . (int)$artists_id . "'"); } else { $db->Execute("update " . TABLE_RECORD_ARTISTS . " set artists_image = '' where artists_id = '" . (int)$artists_id . "'"); } } } $languages = zen_get_languages(); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $artists_url_array = $_POST['artists_url']; $language_id = $languages[$i]['id']; $sql_data_array = array('artists_url' => zen_db_prepare_input($artists_url_array[$language_id])); if ($action == 'insert') { $insert_sql_data = array('artists_id' => $artists_id, 'languages_id' => $language_id); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); zen_db_perform(TABLE_RECORD_ARTISTS_INFO, $sql_data_array); } elseif ($action == 'save') { zen_db_perform(TABLE_RECORD_ARTISTS_INFO, $sql_data_array, 'update', "artists_id = '" . (int)$artists_id . "' and languages_id = '" . (int)$language_id . "'"); } } zen_redirect(zen_href_link(FILENAME_RECORD_ARTISTS, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'mID=' . $artists_id)); break; case 'deleteconfirm': // demo active test if (zen_admin_demo()) { $_GET['action']= ''; $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution'); zen_redirect(zen_href_link(FILENAME_RECORD_ARTISTS, 'page=' . $_GET['page'])); } $artists_id = zen_db_prepare_input($_GET['mID']); if (isset($_POST['delete_image']) && ($_POST['delete_image'] == 'on')) { $manufacturer = $db->Execute("select artists_image from " . TABLE_RECORD_ARTISTS . " where artists_id = '" . (int)$artists_id . "'"); $image_location = DIR_FS_CATALOG_IMAGES . $manufacturer->fields['artists_image']; if (file_exists($image_location)) @unlink($image_location); } $db->Execute("delete from " . TABLE_RECORD_ARTISTS . " where artists_id = '" . (int)$artists_id . "'"); $db->Execute("delete from " . TABLE_RECORD_ARTISTS_INFO . " where artists_id = '" . (int)$artists_id . "'"); if (isset($_POST['delete_products']) && ($_POST['delete_products'] == 'on')) { $products = $db->Execute("select products_id from " . TABLE_PRODUCT_MUSIC_EXTRA . " where artists_id = '" . (int)$artists_id . "'"); while (!$products->EOF) { zen_remove_product($products->fields['products_id']); $products->MoveNext(); } } else { $db->Execute("update " . TABLE_PRODUCT_MUSIC_EXTRA . " set artists_id = '' where artists_id = '" . (int)$artists_id . "'"); } zen_redirect(zen_href_link(FILENAME_RECORD_ARTISTS, 'page=' . $_GET['page'])); break; } } ?> > <?php echo TITLE; ?>
'' . TEXT_HEADING_NEW_RECORD_ARTIST . ''); $contents = array('form' => zen_draw_form('artists', FILENAME_RECORD_ARTISTS, 'action=insert', 'post', 'enctype="multipart/form-data"')); $contents[] = array('text' => TEXT_NEW_INTRO); $contents[] = array('text' => '
' . TEXT_RECORD_ARTIST_NAME . '
' . zen_draw_input_field('artists_name', '', zen_set_field_length(TABLE_RECORD_ARTISTS, 'artists_name'))); $contents[] = array('text' => '
' . TEXT_RECORD_ARTIST_IMAGE . '
' . zen_draw_file_field('artists_image')); $dir = @dir(DIR_FS_CATALOG_IMAGES); $dir_info[] = array('id' => '', 'text' => "Main Directory"); while ($file = $dir->read()) { if (is_dir(DIR_FS_CATALOG_IMAGES . $file) && strtoupper($file) != 'CVS' && $file != "." && $file != "..") { $dir_info[] = array('id' => $file . '/', 'text' => $file); } } $dir->close(); $default_directory = 'artists/'; $contents[] = array('text' => '
' . TEXT_ARTISTS_IMAGE_DIR . zen_draw_pull_down_menu('img_dir', $dir_info, $default_directory)); $contents[] = array('text' => '
' . TEXT_ARTISTS_IMAGE_MANUAL . ' ' . zen_draw_input_field('artists_image_manual')); $manufacturer_inputs_string = ''; $languages = zen_get_languages(); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $manufacturer_inputs_string .= '
' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . zen_draw_input_field('artists_url[' . $languages[$i]['id'] . ']', '', zen_set_field_length(TABLE_RECORD_ARTISTS_INFO, 'artists_url') ); } $contents[] = array('text' => '
' . TEXT_RECORD_ARTIST_URL . $manufacturer_inputs_string); $contents[] = array('align' => 'center', 'text' => '
' . zen_image_submit('button_save.gif', IMAGE_SAVE) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ''); break; case 'edit': $heading[] = array('text' => '' . TEXT_HEADING_EDIT_RECORD_ARTIST . ''); $contents = array('form' => zen_draw_form('artists', FILENAME_RECORD_ARTISTS, 'page=' . $_GET['page'] . '&mID=' . $aInfo->artists_id . '&action=save', 'post', 'enctype="multipart/form-data"')); $contents[] = array('text' => TEXT_EDIT_INTRO); $contents[] = array('text' => '
' . TEXT_RECORD_ARTIST_NAME . '
' . zen_draw_input_field('artists_name', $aInfo->artists_name, zen_set_field_length(TABLE_RECORD_ARTISTS, 'artists_name'))); $contents[] = array('text' => '
' . TEXT_RECORD_ARTIST_IMAGE . '
' . zen_draw_file_field('artists_image') . '
' . $aInfo->artists_image); $dir = @dir(DIR_FS_CATALOG_IMAGES); $dir_info[] = array('id' => '', 'text' => "Main Directory"); while ($file = $dir->read()) { if (is_dir(DIR_FS_CATALOG_IMAGES . $file) && strtoupper($file) != 'CVS' && $file != "." && $file != "..") { $dir_info[] = array('id' => $file . '/', 'text' => $file); } } $dir->close(); $default_directory = substr( $aInfo->artists_image, 0,strpos( $aInfo->artists_image, '/')+1); $contents[] = array('text' => '
' . TEXT_ARTISTS_IMAGE_DIR . zen_draw_pull_down_menu('img_dir', $dir_info, $default_directory)); $contents[] = array('text' => '
' . TEXT_ARTISTS_IMAGE_MANUAL . ' ' . zen_draw_input_field('artists_image_manual')); $contents[] = array('text' => '
' . zen_info_image($aInfo->artists_image, $aInfo->artists_name)); $manufacturer_inputs_string = ''; $languages = zen_get_languages(); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $manufacturer_inputs_string .= '
' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . zen_draw_input_field('artists_url[' . $languages[$i]['id'] . ']', zen_get_artists_url($aInfo->artists_id, $languages[$i]['id']), zen_set_field_length(TABLE_RECORD_ARTISTS_INFO, 'artists_url')); } $contents[] = array('text' => '
' . TEXT_RECORD_ARTIST_URL . $manufacturer_inputs_string); $contents[] = array('align' => 'center', 'text' => '
' . zen_image_submit('button_save.gif', IMAGE_SAVE) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ''); break; case 'delete': $heading[] = array('text' => '' . TEXT_HEADING_DELETE_RECORD_ARTIST . ''); $contents = array('form' => zen_draw_form('artists', FILENAME_RECORD_ARTISTS, 'page=' . $_GET['page'] . '&mID=' . $aInfo->artists_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_DELETE_INTRO); $contents[] = array('text' => '
' . $aInfo->artists_name . ''); $contents[] = array('text' => '
' . zen_draw_checkbox_field('delete_image', '', true) . ' ' . TEXT_DELETE_IMAGE); if ($aInfo->products_count > 0) { $contents[] = array('text' => '
' . zen_draw_checkbox_field('delete_products') . ' ' . TEXT_DELETE_PRODUCTS); $contents[] = array('text' => '
' . sprintf(TEXT_DELETE_WARNING_PRODUCTS, $aInfo->products_count)); } $contents[] = array('align' => 'center', 'text' => '
' . zen_image_submit('button_delete.gif', IMAGE_DELETE) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ''); break; default: if (isset($aInfo) && is_object($aInfo)) { $heading[] = array('text' => '' . $aInfo->artists_name . ''); $contents[] = array('align' => 'center', 'text' => '' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '' . zen_image_button('button_delete.gif', IMAGE_DELETE) . ''); $contents[] = array('text' => '
' . TEXT_DATE_ADDED . ' ' . zen_date_short($aInfo->date_added)); if (zen_not_null($aInfo->last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . zen_date_short($aInfo->last_modified)); $contents[] = array('text' => '
' . zen_info_image($aInfo->artists_image, $aInfo->artists_name)); $contents[] = array('text' => '
' . TEXT_PRODUCTS . ' ' . $aInfo->products_count); } break; } if ( (zen_not_null($heading)) && (zen_not_null($contents)) ) { echo ' ' . "\n"; } ?>
Execute($artists_query_raw); while (!$artists->EOF) { if ((!isset($_GET['mID']) || (isset($_GET['mID']) && ($_GET['mID'] == $artists->fields['artists_id']))) && !isset($aInfo) && (substr($action, 0, 3) != 'new')) { $artists_products = $db->Execute("select count(*) as products_count from " . TABLE_PRODUCT_MUSIC_EXTRA . " where artists_id = '" . (int)$artists->fields['artists_id'] . "'"); $aInfo_array = array_merge($artists->fields, $artists_products->fields); $aInfo = new objectInfo($aInfo_array); } if (isset($aInfo) && is_object($aInfo) && ($artists->fields['artists_id'] == $aInfo->artists_id)) { echo ' ' . "\n"; } else { echo ' ' . "\n"; } ?> MoveNext(); } ?>
 
fields['artists_name']; ?> fields['artists_id'] . '&action=edit') . '">' . zen_image(DIR_WS_IMAGES . 'icon_edit.gif', ICON_EDIT) . ''; ?> fields['artists_id'] . '&action=delete') . '">' . zen_image(DIR_WS_IMAGES . 'icon_delete.gif', ICON_DELETE) . ''; ?> fields['artists_id'] == $aInfo->artists_id)) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . ''; } ?>
display_count($artists_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_ARTISTS); ?> display_links($artists_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?>
artists_id . '&action=new') . '">' . zen_image_button('button_insert.gif', IMAGE_INSERT) . ''; ?>
' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo '