1
Feedback & Suggestions / Ist eine neue Version geplant ?
« on: February 26, 2003, 01:06:24 PM »
danke, das freut mich das ihr weitermacht
kann euch nur glück wünschen
kann euch nur glück wünschen
You're looking for some 4images templates and styles? Then visit this thread to show websites with 4images templates to download.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
//-----------------------------------------------------
//--- Generate Setting --------------------------------
//-----------------------------------------------------
$sql = "SELECT setting_name, setting_value
FROM ".SETTINGS_TABLE;
$result = $site_db->query($sql);
if (!$result) {
echo $lang['no_settings'];
exit;
}
while ($row = $site_db->fetch_array($result)) {
$config[$row['setting_name']] = $row['setting_value'];
}
$site_db->free_result();
//-----------------------------------------------------
//--- Generate Setting --------------------------------
//-----------------------------------------------------
if ( !file_exists(ROOT_PATH.'includes/options.inc.php') )
{
echo $lang['no_settings'];
exit();
}
else
{
require(ROOT_PATH.'includes/options.inc.php');
}
if ($action == "updatesettings") {
$setting_item = $HTTP_POST_VARS['setting_item'];
foreach ($setting_item as $key => $val) {
$val = un_htmlspecialchars(trim($val));
$sql = "UPDATE ".SETTINGS_TABLE."
SET setting_value = '$val'
WHERE setting_name = '$key'";
$site_db->query($sql);
}
create_optionsinc();
?>
function create_optionsinc(){
global $site_db;
$fp = fopen(ROOT_PATH.'includes/options.inc.php', 'w+');
fwrite($fp, "<?php\n\n\$config = array(\n");
$result = $site_db->query("SELECT setting_name, setting_value FROM ".SETTINGS_TABLE."");
while($row = $site_db->fetch_array($result))
{
fwrite($fp, "'".$row['setting_name']."' => '".str_replace("\"","\\\"",$row['setting_value'])."',\n");
}
fwrite($fp, ");\n\n?>");
fclose($fp);
}
$sql = "SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images
FROM ".CATEGORIES_TABLE." c
LEFT JOIN ".IMAGES_TABLE." i ON (i.cat_id = c.cat_id AND i.image_date >= $new_cutoff AND i.image_active = 1)
GROUP BY c.cat_id
ORDER BY c.cat_order, c.cat_name ASC";
$sql = "SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images
FROM ".CATEGORIES_TABLE." c
LEFT JOIN ".IMAGES_TABLE." i ON (i.cat_id = c.cat_id AND i.image_date >= $new_cutoff AND i.image_active = 1)
GROUP BY c.cat_id
ORDER BY ".$config['cat_order']."";
/*-- Setting-Group 3 --*/
$setting['cat_order'] = "Nach welchem Prinzip, sollen die Kategorien bzw. Subkategorien geordnet werden";
$cat_order_array = array(
'c.cat_order' => 'Manuell',
'c.cat_name ASC' => 'Name Aufsteigend',
'c.cat_name DESC' => 'Name Absteigend'
);
show_setting_row("num_subcats");
show_setting_row("cat_order", "show_cat_order");
function show_image_order_select($setting_name, $setting_value) {
global $image_order_optionlist;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ($image_order_optionlist as $key => $val) {
echo "<option value=\"$key\"";
if ($setting_value == $key) {
echo " selected=\"selected\"";
}
echo ">".$val."</option>";
}
echo "</select>";
}
function show_cat_order($setting_name, $setting_value) {
global $cat_order_array;
echo "<select name=\"setting_item[".$setting_name."]\">";
foreach ($cat_order_array as $key => $val) {
echo "<option value=\"$key\"";
if ($setting_value == $key) {
echo " selected=\"selected\"";
}
echo ">".$val."</option>";
}
echo "</select>";
}
INSERT INTO `4images_settings` ( `setting_name` , `setting_value` )
VALUES (
'cat_order', 'c.cat_name ASC'
);