15
« on: April 23, 2002, 02:42:29 PM »
Here is an example of what you can do:
Add field(s) , example "image_test" to the database
/global.php file
//-----------------------------------------------------
//--- Get Image Caches ------
//-----------------------------------------------------
$result = $site_db->query("SELECT image_id, cat_id, user_id, image_name, image_description, image_keywords, image_test, .............
/admin/images: near line 132 and further:
$image_test = trim($HTTP_POST_VARS['image_test']);
................
if (empty($error)) {
@unlink(MEDIA_PATH."/".$cat_id."/".$old_file_name.".bak");
....
$result = $site_db->query("UPDATE ".IMAGES_TABLE."
SET cat_id = '$cat_id', image_name = '".htmlspecialchars($image_name)."', image_description = '$image_description', image_keywords = '".htmlspecialchars($image_keywords)."', image_date = $image_date, image_active = '$image_active', image_media_file = '$new_name', image_thumb_file = '$new_thumb_name', image_allow_comments = '$image_allow_comments', image_downloads = '$image_downloads', image_votes = '$image_votes', image_rating = '$image_rating', image_hits = '$image_hits', image_test = '$image_test'
WHERE image_id = '$image_id'");
if ($result) {
remove_search_words($image_id);
add_search_words($image_id, stripslashes($image_name), stripslashes($image_description), stripslashes($image_keywords), stripslashes($image_test) );
..............
maketextareacode($lang['field_keywords_ext'], "image_keywords", $image['image_keywords'], $textarea_size);
maketextareacode($lang['field_test_ext'], "image_test", $image['image_test'], $textarea_size);
..........
makeinputcode($lang['field_keywords_contains'], "image_keywords", "", $textinput_size);
makeinputcode($lang['field_test_contains'], "image_test", "", $textinput_size);
.....
$image_keywords = trim($HTTP_POST_VARS['image_keywords']);
if ($image_keywords !== "") {
$condition .= " AND INSTR(LCASE(image_keywords),'".strtolower(htmlspecialchars($image_keywords))."')>0";
}
$image_test = trim($HTTP_POST_VARS['image_test']);
if ($image_test !== "") {
$condition .= " AND INSTR(LCASE(image_test),'".strtolower($image_test)."')>0";
}
--------------
makehiddencode("image_description", $image_description, 1);
makehiddencode("image_keywords", $image_keywords, 1);
makehiddencode("image_test", $image_test, 1);
...............
//Save to Database
if (!$uploaderror) {
$image_name = trim($HTTP_POST_VARS['image_name_'.$i]);
$image_description = unhtmlspecialchars(trim($HTTP_POST_VARS['image_description_'.$i]));
$image_test = unhtmlspecialchars(trim($HTTP_POST_VARS['image_test_'.$i]));
...............................
$result = $site_db->query("INSERT INTO ".IMAGES_TABLE."
(cat_id, user_id, image_name, image_description, image_keywords, image_test, image_date, image_active, image_media_file, image_thumb_file, image_allow_comments)
VALUES ('$cat_id', '".$userinfo['user_id']."', '".htmlspecialchars($image_name)."', '$image_description', '".htmlspecialchars($image_keywords)."','$image_test', '".time()."', '$image_active', '$new_name', '$new_thumb_name', '$image_allow_comments')");
$image_id = $site_db->get_insert_id();
...............
for ($i = 1; $i <= $num_newimages; $i++) {
maketableseparator($lang['image']." ".$i, 2);
makeuploadcode($lang['image'], "file_".$i, "<br /><span class=smalltext>".$lang['allowed_mediatypes_desc'].str_replace(",",", ",$config['allowed_mediatypes'])."</span>");
makeuploadcode($lang['thumb'], "thumb_file_".$i, "<br /><span class=smalltext>".$lang['allowed_mediatypes_desc']." jpg, gif, png</span>");
makeinputcode($lang['field_image_name'], "image_name_".$i, "", $textinput_size);
maketextareacode($lang['field_description_ext'],"image_description_".$i, "", $textarea_size);
maketextareacode($lang['field_keywords_ext'], "image_keywords_".$i, "", $textarea_size)
maketextareacode($lang['field_test_ext'], "image_test_".$i, "", $textarea_size );
/includes/functions.php: line 47
$test = $img_result['image_test'];
.........
$site_template->register_vars(array("image_id" => $img_result['image_id'],
"user_id" => $img_result['user_id'],
"image_name" => stripslashes($img_result['image_name']),
"description" => FormatText($description, 1),
------------
"thumbnail_file_name" => $img_result['image_thumb_file'],
"test" => $img_result['image_test']
));
$rate_form = $site_template->parse_template("rate_form");
$site_template->register_vars("rate_form", $rate_form);
return true;
}
/templetes/default/details.html:
---------
<tr>
<td valign="top" class="row1"><b>{lang_description}</b></td>
<td valign="top" class="row1">{description}</td>
</tr>
<tr>
<td valign="top" class="row2"><b>{lang_keywords}</b></td>
<td valign="top" class="row2">{keywords}</td>
</tr>
<tr>
<td valign="top" class="row2"><b>{lang_test}</b></td>
<td valign="top" class="row2">{test}</td>
</tr>
---------------------
/lang/english/admin.php
lang['field_test'] = "test";
$lang['field_test_ext'] = "test .......";
$lang['field_test_contains'] = "test contains";
$lang['test'] = "test:";
Hope it helps.
-Ofuuzo
Show Posts
- first only a englisch version ... 
- eine deutsche Version kommt bald ... oder später ... 
... zwischenzeitlich nutze diese