Show Posts

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.


Topics - henary

Pages: [1]
1
Mods & Plugins (Requests & Discussions) / How to get paging incl. all images in category?
« on: December 19, 2010, 01:47:45 PM »
Hello,

i'd like to have selection of images not only 5,10,15...50 it would be better to habe 5,10,15...all

This has to be placed in paging.php i think, but i don't know how  :(

This time i use the default paging in 1.7.9, in future i'd like to use universal paging...

Thanks for any hint,
Henry


2
Mods & Plugins (Requests & Discussions) / one klick to list "awaiting users" in ACP?
« on: December 14, 2010, 05:09:01 PM »
Hello,

i've just change some in /adminm/home.php to see awaiting users directly an have link to users.php.

How can i change the link i.e. .../users.php?action=modifyusers&search=awaiting to get directly list of users instead of get form?

Here my code, edit /admin/home.php

search:
  $sql = "SELECT COUNT(*) as users
          FROM ".USERS_TABLE."
          WHERE ".get_user_table_field("", "user_id")." <> ".GUEST;
  $row = $site_db->query_firstrow($sql);

add after:
  $user = $row['users'];

  $sql = "SELECT COUNT(*) as users
          FROM ".USERS_TABLE."
          WHERE ".get_user_table_field("", "user_id")." = ".USER_AWAITING;
  $row = $site_db->query_firstrow($sql);
$useraw = $row['users'];
if ($useraw) {
  $useraw = "<b>".$useraw."</b> nicht aktiviert";
  $useraw = " / ".sprintf("<a href=\"".$site_sess->url("users.php")."\">%s</a>", $useraw );
}


search:
  echo "<td width=\"16%\"><b>".$lang['users']."</b></td><td width=\"16%\">".$row['users']."</td>\n";

replace with:
  echo "<td width=\"16%\"><b>".$lang['users']."</b></td><td width=\"16%\">".$user."".$useraw."</td>\n";

The count of users by default include awaiting users. If you add
  $user = $user - $useraw;
after
$useraw = $row['users'];
you will have it more exactly  :wink:

But what about direct link?

Regards,
Henry

3
Mods & Plugins (Requests & Discussions) / Show cat (with subcats) obly to *one* user_id (one admin) like testcat
« on: December 14, 2010, 02:43:34 PM »
Hello,

i've some 4images-pages while each with own admins and me. And i need one cat with subcats for testing only and i don't like that those see this.

Where it's possible to change this? It's not necessary to disable those cats in ACP as well for other admins - only in galleriemode will be fine for me.

Thank you,
Henry

4
Mods & Plugins (Requests & Discussions) / [MOD] auth_email V 0.8 for Pictures Email Upload V1.7.x
« on: December 13, 2010, 09:08:06 PM »
Hello,

i've just write some modification for the MOD Pictures Email Upload V1.7.8 http://www.4homepages.de/forum/index.php?topic=23681

This little MOD is not finished jet, because i'm not able to make the selection for user by dropdown-list - i've no idea to solve this by myself  :oops:
Please be patient to help me  :wink:

What will this MOD do (V 0.5)?

- in ACP you provide some mailadresses for using "Pictures Email Upload" eMail_upload.php without have to use the subject
- in ACP you provide the default category
- in ACP you provide the default user (in this time by user-number, i'll hope to finish by dropdown)
new V 0.8
- in ACP set "all", if you like to enable emailupload without check mailadresses
- in UserCP user set up eMail-Adress for emailupload (separate from 4images mailadress)
- in UserCP user set up category by using v@no [MOD] Categories upload dropdown form (http://www.4homepages.de/forum/index.php?topic=7722.0)
- in ACP user-section enable/disable each user using personal emailupload-config
- in eMail_upload.php new column "Auth" display, whitch rule matches

pending things:
- dropdown userselect for ACP
- dropdown categoryselect for ACP in user setting
- check unique mailadress in member.php (to ensure no users use same imagesupload-maildress)
- solution for change cat-setting in ACP/UserCP while cat deleted (or user lost rights for upload in cat with future function while direct-upload)

Whischlist: If user have right to direct upload images in cat, images direct send into db instead of temp-table for validating.
This function may be inclue into original MOD ;-)

Mail checks in follow priority:
1) mail with POP-Code
2) mailadress from personal uploadmailadress by user
3) mailadress from ACP (list or "all")
This provide to sort images into category by POP-Code but also use the "easy way" like user personal settings.

Attention: Mails must have no subject to select by the new rules.

After setting up, you are able to use the standard from the MOD by providing parameters in subject or
you send email from listet adress without subject and the attached images (vids ...) prepared automatic for validateimages.php

Please back up your files and database!

you have to change:
/admin/settings.php
/admin/users.php
/admin/plugins/eMail_upload.php
/includes/sessions.php
/includes/functions.php
/lang/xxx/admin.php
/lang/xxx/main.php
/templates/xxx/member_editprofile.html

First install [MOD] Categories upload dropdown form (http://www.4homepages.de/forum/index.php?topic=7722.0)

Second update database with phpmyadmin:

Code: [Select]
ALTER TABLE `4images_users` ADD `user_emailupload` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
ADD `user_emailupload_active` TINYINT NOT NULL DEFAULT '0', ADD `user_emailupload_cat` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
If you have not install the first version, you need also:
Code: [Select]
INSERT INTO `4images_settings` (`setting_name`, `setting_value`) VALUES ('noauth_mail', ''), ('noauth_mail_cat', ''), ('noauth_mail_user', '');
Next few steps are different betwen update from V 0.5 or new install.

step 1) in /admin/settings.php (not if update)
search for:
// end of functions
insert above:
function show_categorory_select($setting_name, $setting_value)
{
 global $cat_parent_cache, $drop_down_cat_cache, $lang;
  $drop_down_cat_cache = $cat_parent_cache;
  echo "<select name=\"setting_item[".$setting_name."]\" class=\"categoryselect\">";
  echo "<option value=\"0\">".$lang['select_category']."</option>";
  echo "<option value=\"0\">-------------------------------</option>";
  echo get_category_dropdown_bits((int)$setting_value);
  echo "</select>";
}


step 1.1) (not if update)
search for:
  show_setting_row("pop_code");
add after:
  show_setting_row("noauth_mail", "textarea");
  show_setting_row("noauth_mail_cat", "show_categorory_select");
  show_setting_row("noauth_mail_user");


step 2a) in /admin/plugins/eMail_upload.php (not if update)
search for:
  $sql = "SELECT  setting_value as noauth_mail FROM ".SETTINGS_TABLE." WHERE setting_name = 'noauth_mail'"; // Mailadressen abfragen
    $result = $site_db->query($sql); $row = mysql_fetch_object($result);
      $noauth_mail = $row->noauth_mail;
 
     if (($array[0] == "$user_name" && $array[1] == $config['pop_code']) || (strstr($noauth_mail, $head['from']) && $head['subject'] == ""))
     {
if (strstr($noauth_mail, $head['from']) && $head['subject'] == "") {
 $sql = "SELECT  setting_value as noauth_mail_cat FROM ".SETTINGS_TABLE." WHERE setting_name = 'noauth_mail_cat'"; // Kategorie abfragen
  $result = $site_db->query($sql); $row = mysql_fetch_object($result);
   $cat_id = $row->noauth_mail_cat;
 $sql = "SELECT cat_id, cat_name FROM ".CATEGORIES_TABLE." WHERE cat_id = $cat_id"; // Kategorienamen abfragen
  $result = $site_db->query($sql); 
   $row = $site_db->fetch_array($result);
           $cat_name = $row[cat_name];
 $sql = "SELECT  setting_value as noauth_mail_user FROM ".SETTINGS_TABLE." WHERE setting_name = 'noauth_mail_user'"; // User-ID abfragen
  $result = $site_db->query($sql); $row = mysql_fetch_object($result);
   $user_id = $row->noauth_mail_user;
 $sql = "SELECT user_id, user_name FROM ".USERS_TABLE." WHERE user_id = $user_id"; // Usernamen abfragen
 
  $result = $site_db->query($sql); 
         $row = $site_db->fetch_array($result);
         $user_name = $row[user_name];
     }
     $path = MEDIA_TEMP_PATH."/";
replace with:
      if ($array[0] == "$user_name" && $array[1] == $config['pop_code']){
        $path = MEDIA_TEMP_PATH."/";


step 2) in /admin/plugins/eMail_upload.php
search for:
    echo '<td class="tableheader" width=3%>Nr.</td>';
add after:
    echo '<td class="tableheader" width=5%>Auth</td>';

step 2.1) in /admin/plugins/eMail_upload.php
search for:
      $sql = "SELECT u.user_id, u.user_name, c.cat_id, c.cat_name
              FROM (".USERS_TABLE." u, ".CATEGORIES_TABLE." c)
              WHERE user_name = '$array[0]' AND cat_id = '$array[2]'
             "; 
      $result = $site_db->query($sql); 
      $row = $site_db->fetch_array($result);
      $user_name = $row[user_name];
      $user_id = $row[user_id];
      $cat_name = $row[cat_name];
      $cat_id = $row[cat_id];  
      
      if ($array[0] == "$user_name" && $array[1] == $config['pop_code']){
        $path = MEDIA_TEMP_PATH."/";
replace with:
if ($head['subject'] != ""){
   
      $sql = "SELECT u.user_id, u.user_name, c.cat_id, c.cat_name
              FROM (".USERS_TABLE." u, ".CATEGORIES_TABLE." c)
              WHERE user_name = '$array[0]' AND cat_id = '$array[2]'
             "; 
      $result = $site_db->query($sql); 
      $row = $site_db->fetch_array($result);
      $user_name = $row[user_name];
      $user_id = $row[user_id];
      $cat_name = $row[cat_name];
      $cat_id = $row[cat_id]; 
      $authselect = "POP-Code";
}
else
{
$from = $head['from']; 
        $sql = "SELECT u.user_id, u.user_name, u.user_emailupload, u.user_emailupload_cat, u.user_emailupload_active, c.cat_id, c.cat_name
        
      FROM ".USERS_TABLE." u
              LEFT JOIN ".CATEGORIES_TABLE." c ON (".get_user_table_field("u.", "user_emailupload_cat")." = c.cat_id)
        
      WHERE user_emailupload_active = 1 and user_emailupload = '$from'";
        $result = $site_db->query($sql);
        $num_rows = $site_db->get_numrows($result);
 if ($num_rows != 0) {
        
$row = $site_db->fetch_array($result);
        
$noauth_mail = $row[user_emailupload];
        
$user_name = $row[user_name];
        
$user_id = $row[user_id];
        
$cat_name = $row[cat_name];
        
$cat_id = $row[cat_id];  
        $authselect = "UserUpMail";
} 
else {
$sql = "SELECT  setting_value as noauth_mail FROM ".SETTINGS_TABLE." WHERE setting_name = 'noauth_mail'"; // Mailadressen abfragen
    
$result = $site_db->query($sql);
     
$row = mysql_fetch_object($result);
   
   
$noauth_mail = $row->noauth_mail;
if (strstr($noauth_mail, "all")) {
$authselect = "<b>ACPUpALL</b>";
} 
else {
$authselect = "ACPUpMail";
}
$sql = "SELECT  setting_value as noauth_mail_cat FROM ".SETTINGS_TABLE." WHERE setting_name = 'noauth_mail_cat'"; // Kategorie abfragen
 $result = $site_db->query($sql); 
  $row = mysql_fetch_object($result);
  $cat_id = $row->noauth_mail_cat;
$sql = "SELECT cat_id, cat_name FROM ".CATEGORIES_TABLE." WHERE cat_id = $cat_id"; // Kategorienamen abfragen
  $result = $site_db->query($sql); 
   $row = $site_db->fetch_array($result);
           $cat_name = $row[cat_name];
$sql = "SELECT  setting_value as noauth_mail_user FROM ".SETTINGS_TABLE." WHERE setting_name = 'noauth_mail_user'"; // User-ID abfragen
 $result = $site_db->query($sql); 
  $row = mysql_fetch_object($result);
  $user_id = $row->noauth_mail_user;
$sql = "SELECT user_id, user_name FROM ".USERS_TABLE." WHERE user_id = $user_id"; // Usernamen abfragen
  $result = $site_db->query($sql); 
          $row = $site_db->fetch_array($result);
          $user_name = $row[user_name];
} 
}
     if (($array[0] == "$user_name" && $array[1] == $config['pop_code']) || (strstr($noauth_mail, $head['from']) && $head['subject'] == "") || (strstr($noauth_mail, "all") && $head['subject'] == ""))
     {

     $path = MEDIA_TEMP_PATH."/";


step 2.2) in /admin/plugins/eMail_upload.php
search for:
        echo '<td width=3%>'.$i.'</td>';
add after:
        echo '<td width=5%>'.$authselect.'</td>';
do replace twice!


step 3.0) in /admin/users.php
search for:
  $user_invisible = intval($HTTP_POST_VARS['user_invisible']);
add after:
  $user_emailupload_active = intval($HTTP_POST_VARS['user_emailupload_active']);
  $user_emailupload = trim($HTTP_POST_VARS['user_emailupload']);
  $user_emailupload_cat = trim($HTTP_POST_VARS['user_emailupload_cat']);


step 3.1) in /admin/users.php
search for:
            SET ".get_user_table_field("", "user_level")." = $user_level, ".get_user_table_field("", "user_name")." = '$user_name',$passinsert ".get_user_table_field("", "user_email")." = '$user_email', ".get_user_table_field("", "user_showemail")." = $user_showemail, ".get_user_table_field("", "user_allowemails")." = $user_allowemails, ".get_user_table_field("", "user_invisible")." = $user_invisible, ".get_user_table_field("", "user_joindate")." = $user_joindate, ".get_user_table_field("", "user_lastaction")." = $user_lastaction, ".get_user_table_field("", "user_homepage")." = '$user_homepage', ".get_user_table_field("", "user_icq")." = '$user_icq'".$additional_sql."

replace with:
            SET ".get_user_table_field("", "user_level")." = $user_level, ".get_user_table_field("", "user_name")." = '$user_name',$passinsert ".get_user_table_field("", "user_email")." = '$user_email', ".get_user_table_field("", "user_showemail")." = $user_showemail, ".get_user_table_field("", "user_allowemails")." = $user_allowemails, ".get_user_table_field("", "user_invisible")." = $user_invisible, ".get_user_table_field("", "user_emailupload_active")." = $user_emailupload_active, ".get_user_table_field("", "user_emailupload")." = '$user_emailupload', ".get_user_table_field("", "user_emailupload_cat")." = $user_emailupload_cat, ".get_user_table_field("", "user_joindate")." = $user_joindate, ".get_user_table_field("", "user_lastaction")." = $user_lastaction, ".get_user_table_field("", "user_homepage")." = '$user_homepage', ".get_user_table_field("", "user_icq")." = '$user_icq'".$additional_sql."


step 3.2) in /admin/users.php
search for:
  show_date_input_row($lang['field_lastaction'].$lang['date_desc'], "user_lastaction", $user_row['user_lastaction'], $textinput_size);
add after:
  show_radio_row($lang['field_emailupload_active'], "user_emailupload_active", $user_row['user_emailupload_active']);
  show_input_row($lang['field_user_emailupload'], "user_emailupload", $user_row['user_emailupload'], $textinput_size);
  show_input_row($lang['field_user_emailupload_cat'], "user_emailupload_cat", $user_row['user_emailupload_cat'], $textinput_size);



step 3.3) in /admin/users.php
search for:
      $user_invisible = intval($HTTP_POST_VARS['user_invisible_'.$i]);
add after:
      $user_emailupload_active = intval($HTTP_POST_VARS['user_emailupload_active_'.$i]);
      $user_emailupload = trim($HTTP_POST_VARS['user_emailupload_'.$i]);
      $user_emailupload_cat = intval(trim($HTTP_POST_VARS['user_emailupload_cat_'.$i]));


step 3.4) in /admin/users.php
search for:
      $sql = "INSERT INTO ".USERS_TABLE."
              (".get_user_table_field("", "user_id").get_user_table_field(", ", "user_level").get_user_table_field(", ", "user_name").get_user_table_field(", ", "user_password").get_user_table_field(", ", "user_email").get_user_table_field(", ", "user_showemail").get_user_table_field(", ", "user_allowemails").get_user_table_field(", ", "user_invisible").get_user_table_field(", ", "user_joindate").get_user_table_field(", ", "user_activationkey").get_user_table_field(", ", "user_lastaction").get_user_table_field(", ", "user_lastvisit").get_user_table_field(", ", "user_comments").get_user_table_field(", ", "user_homepage").get_user_table_field(", ", "user_icq").$additional_field_sql.")
              VALUES
              ($user_id, $user_level, '$user_name', '$user_password', '$user_email', $user_showemail, $user_allowemails, $user_invisible, $current_time, '$activationkey', $current_time, $current_time, 0, '$user_homepage', '$user_icq'".$additional_value_sql.")";
replace with:
              (".get_user_table_field("", "user_id").get_user_table_field(", ", "user_level").get_user_table_field(", ", "user_name").get_user_table_field(", ", "user_password").get_user_table_field(", ", "user_email").get_user_table_field(", ", "user_showemail").get_user_table_field(", ", "user_allowemails").get_user_table_field(", ", "user_invisible").get_user_table_field(", ", "user_joindate").get_user_table_field(", ", "user_emailupload_active").get_user_table_field(", ", "user_emailupload").get_user_table_field(", ", "user_emailupload_cat").get_user_table_field(", ", "user_activationkey").get_user_table_field(", ", "user_lastaction").get_user_table_field(", ", "user_lastvisit").get_user_table_field(", ", "user_comments").get_user_table_field(", ", "user_homepage").get_user_table_field(", ", "user_icq").$additional_field_sql.")
              VALUES
              ($user_id, $user_level, '$user_name', '$user_password', '$user_email', $user_showemail, $user_allowemails, $user_invisible, $current_time, $user_emailupload_active, '$user_emailupload', $user_emailupload_cat, '$activationkey', $current_time, $current_time, 0, '$user_homepage', '$user_icq'".$additional_value_sql.")";

step 3.4) in /admin/users.php
search for:
    show_radio_row($lang['field_invisible'], "user_invisible_".$i, 0);
add after:
    show_radio_row($lang['field_emailupload_active'], "user_emailupload_active_".$i, 0);
    show_input_row($lang['field_user_emailupload'], "user_emailupload_".$i, 0);
    show_input_row($lang['field_user_emailupload_cat'], "user_emailupload_cat_".$i, 0);



step 4) in /includes/sessions.php
search for:
  "user_homepage" => "user_homepage",
add after:
  "user_emailupload" => "user_emailupload",
  "user_emailupload_cat" => "user_emailupload_cat",
  "user_emailupload_active" => "user_emailupload_active",


step 5) in /lang/xxx/main.php
search for:
$lang['icq'] = "ICQ:";
add after:
$lang['user_emailupload'] = "Adresse für eMail-Upload:";
$lang['user_emailupload_cat'] = "Kategorie für eMail-Upload:";


step 6) in /lang/xxx/admin.php
search for:
$lang['field_homepage'] = "Homepage";
add after:
$lang['field_emailupload_active'] = "eMailupload";
$lang['field_user_emailupload'] = "eMail für Mailupload";
$lang['field_user_emailupload_cat'] = "Kategorie für Mailupload";


step 7) in /member.php
search for:
  $user_icq = (isset($HTTP_POST_VARS['user_icq'])) ? ((intval(trim($HTTP_POST_VARS['user_icq']))) ? intval(trim($HTTP_POST_VARS['user_icq'])) : "") : "";
add after:
  $user_emailupload = (isset($HTTP_POST_VARS['user_emailupload'])) ? un_htmlspecialchars(trim($HTTP_POST_VARS['user_emailupload'])) : "";
  $user_emailupload_cat = (isset($HTTP_POST_VARS['user_emailupload_cat'])) ? ((intval(trim($HTTP_POST_VARS['user_emailupload_cat']))) ? intval(trim($HTTP_POST_VARS['user_emailupload_cat'])) : "") : "";


step 7.1) in /member.php
search for:
    $sql = "UPDATE ".USERS_TABLE."
            SET ".get_user_table_field("", "user_email")." = '$user_email', ".get_user_table_field("", "user_showemail")." = $user_showemail, ".get_user_table_field("", "user_allowemails")." = $user_allowemails, ".get_user_table_field("", "user_invisible")." = $user_invisible, ".get_user_table_field("", "user_homepage")." = '$user_homepage', ".get_user_table_field("", "user_icq")." = '$user_icq'".$additional_sql."

replace with:
    $sql = "UPDATE ".USERS_TABLE."
    SET ".get_user_table_field("", "user_email")." = '$user_email', ".get_user_table_field("", "user_showemail")." = $user_showemail, ".get_user_table_field("", "user_allowemails")." = $user_allowemails, ".get_user_table_field("", "user_invisible")." = $user_invisible, ".get_user_table_field("", "user_homepage")." = '$user_homepage', ".get_user_table_field("", "user_emailupload")." = '$user_emailupload',  ".get_user_table_field("", "user_emailupload_cat")." = '$cat_id',".get_user_table_field("", "user_icq")." = '$user_icq'".$additional_sql."


step 7.2) in /member.php
search for:
  $site_template->register_vars(array(
    "user_name" => format_text(stripslashes($user_name), 2),
    "user_email" => format_text(stripslashes($user_email), 2),
    "user_email2" => format_text(stripslashes($user_email2), 2),
    "user_homepage" => format_text(stripslashes($user_homepage), 2),
    "user_icq" => $user_icq,
replace with:
  $site_template->register_vars(array(
    "cat_name" => get_category_dropdown_upload($user_emailupload_cat),
    "user_name" => format_text(stripslashes($user_name), 2),
    "user_email" => format_text(stripslashes($user_email), 2),
    "user_email2" => format_text(stripslashes($user_email2), 2),
    "user_homepage" => format_text(stripslashes($user_homepage), 2),
    "user_icq" => $user_icq,
    "user_emailupload" => format_text(stripslashes($user_emailupload), 2),
    "user_emailupload_cat" => $user_emailupload_cat,

step 7.3) in /member.php
search for:
    "lang_icq" => $lang['icq'],
add after:
    "lang_user_emailupload" => $lang['user_emailupload'],
    "lang_user_emailupload_cat" => $lang['user_emailupload_cat'],



step 8) in /templates/xxx/member_editprofile.html
search for:
          <tr> 
            <td class="row2"><b>{lang_icq}</b></td>
            <td class="row2"> 
              <input type="text" name="user_icq"  size="30" value="{user_icq}" class="input" />
            </td>
          </tr>

add after:
          <tr> 
  
    <td class="row1"><b>{lang_user_emailupload}</b></td>
            <td class="row1"> 
              <input type="text" name="user_emailupload"  size="100" value="{user_emailupload}" class="input" />
            </td>
          </tr>

          <tr> 
  
    <td class="row1"><b>{lang_user_emailupload_cat}</b></td>
            <td class="row1">{cat_name}</td>
          </tr>

step 8.1) in /templates/xxx/member_editprofile.html
search for:
  <input type="hidden" name="action" value="updateprofile" />
add bevor:
  {if cat_id}<input type="hidden" name="user_emailupload_cat" value="{cat_id}" />{endif cat_id}

I've tested many configurations and i think, it works well. May i've to make the code include in eMail_upload.php mor nice ;-)

Please send your feedback here.

Regards,
Henry

5
Mods & Plugins (Releases & Support) / [MOD] Erweiterte suche nach cat_description und der cat_subtitel
« on: December 12, 2010, 01:55:58 PM »
Hallo,

Basierend auf dieser Modifkation  http://www.4homepages.de/forum/index.php?topic=28587.0

habe mir erlaubt, die Suche zu erweitern, damit auch die cat_description und der cat_subtitel (MOD von mir http://www.4homepages.de/forum/index.php?topic=8979) durchsucht wird.

Folgendes ist ggü. dem Original von #1 zu ändern:

bei 1.) ist Anstelle Einzufügen:
//########################## Start Mod Search by Cat name ###############################
$search_catname = isset($HTTP_POST_VARS['search_catname']) ? trim($HTTP_POST_VARS['search_catname']) : trim($HTTP_GET_VARS['search_catname']);
$search_catname = un_htmlspecialchars(stripslashes(trim($search_catname)));
if (!empty($search_catname)) {
  $search_catname = str_replace('*', '%', trim($search_catname));
  $sql = "SELECT cat_id, cat_name, cat_description, cat_subtitel
          FROM ".CATEGORIES_TABLE."
          WHERE (cat_name LIKE '$search_catname') or (cat_description LIKE '$search_catname') or (cat_subtitel LIKE '$search_catname')";
  $result = $site_db->query($sql);
  $search_id['cat_ids'] = "";
  $countids= 0;
   if ($result) {
    while ($row = $site_db->fetch_array($result)) {
      $search_id['cat_ids'] .= (($search_id['cat_ids'] != "") ? ", " : "").$row['cat_id'];
      $countids++;
    }
    $site_db->free_result($result);
   }
   $show_result =1;
  }
  $site_template->register_vars(array(
  "countids" => $countids));
//########################## End Mod Search by Cat name ##################################



bei 1.6) ist Anstelle Einzufügen:
//########################## Start Mod Search by Cat name ###############################
if((!empty($search_id['cat_ids'])) && (isset($search_catname))){
  $search_categories = "";
  $sql = "SELECT  cat_id,cat_name, cat_description, cat_subtitel
          FROM  ".CATEGORIES_TABLE."
          WHERE $sql_where_query_cat
          ORDER BY cat_name ".$config['cat_sort']."
         ";
  $result = $site_db->query($sql);

  $cattable_width = ceil((intval($config['cat_table_width'])) / $config['cat_cells']);
  if ((substr($config['cat_table_width'],-1)) == "%") {
    $cattable_width .= "%";
  }
  $categories = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\">\n";
  $categories .= "<tr>\n";
  $categories .= "<td class=\"head1\">\n";
  $categories .= "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\">\n";
  $categories .= "<tr>\n";
  $categories .= "<td class=\"head1\" valign=\"top\">".$lang['categories']."</td>\n";
  $categories .= "</tr>\n";
  $categories .= "<tr>\n";
  $categories .= "<td class=\"row2\" valign=\"top\">\n";
  $categories .= "\n<table width=\"".$config['cat_table_width']."\" border=\"0\" cellpadding=\"".$config['cat_table_cellpadding']."\" cellspacing=\"".$config['cat_table_cellspacing']."\">\n";

  $count = 0;
  while ($row = $site_db->fetch_array($result)) {

    if ($count == 0) {
      $categories  .= "<tr>\n";
    }
    $categories .= "<td valign=\"top\" width=\"".$cattable_width."\" class=\"catbgcolor\">\n";

    $site_template->register_vars(array(
      "cat_id" => $row['cat_id'],
      "cat_name" => format_text($row['cat_name'], 2),
      "cat_url" => $site_sess->url(ROOT_PATH."categories.php?".URL_CAT_ID."=".$row['cat_id']),
      "cat_is_new" => "",
      "num_images" => $cat_cache[$row['cat_id']]['num_images']
     ));

    $categories .= $site_template->parse_template("category_bit");
    $categories .= "</td>\n";

    $count++;
    if ($count == $config['cat_cells']) {
      $categories .= "</tr>\n";
      $count = 0;
    }
  }

  if ($count > 0)  {
    $leftover = ($config['cat_cells'] - $count);
    if ($leftover >= 1) {
      for ($i = 0; $i < $leftover; $i++) {
        $categories .= "<td width=\"".$cattable_width."\">\n&nbsp;\n</td>\n";
      }
      $categories .= "</tr>\n";
    }
  }
  $categories .= "</table>\n";
  $categories .= "</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>";

  $content = $categories.$content;
   unset($categories);
}
//########################## End Mod Search by Cat name ############################


bei 2.) ist Anstelle Einzufügen:
//########################## Start Mod Search by Cat name #############################
$lang['search_by_catname']="Suche in Kategorienamen und Kategoriebeschreibungen:<br /><span class=\"smalltext\">Benutzen Sie * als Platzhalter.</span>";
$lang['search_found_cats']=" &nbsp; in <span class=\"new\">{countids}</span> Kategorie(n).";
$lang['images'] = "Bilder";
//########################## End Mod Search by Cat name ###############################


Andi, ich hoffe das geht so durch?  :wink:

Bis später & Danke nochmals für diesen MOD!
Henry

6
Chit Chat / Topic lost: upload Date and IPTC-Date
« on: August 16, 2005, 08:12:46 AM »
Hi Vincent,

last time, you may open or continued a threas called "upload Date and IPTC-Date".
On 29/07/2005 i wrote answer and help to you by explaining, what i've done do have a uploade-date instead of date from file or from FTP-upload.
After a few hours, i got two eMails with following content:

Subject: Topic locked: upload Date and IPTC-Date
Body:
A topic you are watching has been locked by Vincent.

View the topic at: http://www.4homepages.de/forum/index.php?topic=7546.new;topicseen#new
Regards,
The 4homepages.de Team.


and

Subject: Topic removed: upload Date and IPTC-Date
Body:
A topic you are watching has been removed by Vincent.

Regards,
The 4homepages.de Team.


I don't know what and why and where this has been done, but it's past and if you also don't know anything - it would be a bug ;-)

Regards,
Henry

7
Mods & Plugins (Requests & Discussions) / Subtitel für Kategorien in der Übersicht [Ergänzung für die Beschreibung]
« on: July 22, 2005, 12:19:46 AM »
Hallo Leute,

mich hat es gestört, daß der Beschreibungstext einer Kat auch neben dem Kategorienamen auf der Haupt- bzw. den Unterseiten angezeigt wurde - denn da steht ggf. zu viel Text drin und dann stört das zu sehr. Somit habe ich die DB & Admin um ein weiteres Feld "Subtitel" erweitert - daß dann nur in den Übersichten angezeigt wird / oder in Übersichten und der eigentlichen Kategorie. Der Beschreibungstext zur Kategorie erscheint nun nur in der Kategorieansicht selbst.

Habe dazu ein kleines HowTo vorbereitet - kann gern angefragt werden, dann poste ich das mal hier. Screens etc. auch auf Request - will mir die Arbeit nur machen, wenn's Euch was nützt ;-)

Bis später,
Henry

Pages: [1]