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.


Messages - henary

Pages: 1 [2] 3 4 5
16
Discussion & Troubleshooting / Re: Search All Categories Doesn't Work.
« on: December 15, 2010, 12:43:20 PM »
Hello,

but what about searching only '*' - it dosn't work, but i think, this is not right.

@Terry: did you change some code or may the config from server (host) was changed?

Regards,
Henry

17
Mods & Plugins (Releases & Support) / Re: [Mod] Let visitors to chose how to sort images(date,name,..)
« on: December 14, 2010, 09:41:34 PM »
Hello, here again and i will post you something fine  :mrgreen:

i've found the solution to combining this MOD Let visitors to chose how to sort images(date,name,..) (Sessionmode) and MOD Create Sort Order for each category from Admin Panel (http://www.4homepages.de/forum/index.php?topic=5026.0).

Now, you set up each sortorder in ACP for each category and if the user like to change, this will only used in current category - if user go into different categorie, sortorder will be by default from acp for this new categorie. And if user go back to last categorie with changed sortorder, it will be by default again - not the last state.
If go to index-page (or any other no cat page like search, lightbox ...) and back to last category, the sortorder will be at last changend state, not default from ACP.

If using highslide it will do same fine  :wink:

Please change the code from 1.3. from http://www.4homepages.de/forum/index.php?topic=3842.msg15861#msg15861

For using with MOD Create Sort Order for each category from Admin Panel
//-----------------------------------------------------
//--- Set Images Sort ---------------------------------
//-----------------------------------------------------

if ($cat_id != 0 ) 
 {
   $catimagesorder = $site_sess->get_session_var('catimages_order');
   if (
$catimagesorder <> $cat_id ) {
$site_sess->set_session_var('catimages_order', $cat_id);
if (isset($HTTP_POST_VARS['imagesorder'])) {
  $imagesorder = $cat_cache[$cat_id]['sort_field'];
  if ($imagesorder) {
    $site_sess->set_session_var("imgs_order", $imagesorder);
    $session_info['imgs_order'] = $imagesorder;
  }
}
if (isset($HTTP_POST_VARS['imagessort'])) {
 $imagessort = $cat_cache[$cat_id]['sort_order']; 
  if ($imagessort) {
    $site_sess->set_session_var("imgs_sort", $imagessort);
    $session_info['imgs_sort'] = $imagessort;
  }
}
}
else
{
if (isset($HTTP_POST_VARS['imagesorder'])) {
  $imagesorder = $HTTP_POST_VARS['imagesorder'];
  if ($imagesorder) {
    $site_sess->set_session_var("imgs_order", $imagesorder);
    $session_info['imgs_order'] = $imagesorder;
  }
}
if (isset($session_info['imgs_order'])) {
  $cat_cache[$cat_id]['sort_field'] = $session_info['imgs_order'];
}
if (isset($HTTP_POST_VARS['imagessort'])) {
 $imagessort = $HTTP_POST_VARS['imagessort']; 
  if ($imagessort) {
    $site_sess->set_session_var("imgs_sort", $imagessort);
    $session_info['imgs_sort'] = $imagessort;
  }
}
if (isset($session_info['imgs_sort'])) {
  $cat_cache[$cat_id]['sort_order'] = $session_info['imgs_sort'];
}
   }
}
//----End Images Sort----------------------------------


I've not tested, what will do, if you not have installed MOD Create Sort Order for each category from Admin Panel - may it works in same way but even with default sortorder by ACP for all categories.
For using without MOD Create Sort Order for each category from Admin Panel Try this code:
//-----------------------------------------------------
//--- Set Images Sort ---------------------------------
//-----------------------------------------------------

if ($cat_id != 0 ) 
 {
   $catimagesorder = $site_sess->get_session_var('catimages_order');
   if (
$catimagesorder <> $cat_id ) {
$site_sess->set_session_var('catimages_order', $cat_id);
if (isset($HTTP_POST_VARS['imagesorder'])) {
  $imagesorder = $config['image_order'];
  if ($imagesorder) {
    $site_sess->set_session_var("imgs_order", $imagesorder);
    $session_info['imgs_order'] = $imagesorder;
  }
}
if (isset($HTTP_POST_VARS['imagessort'])) {
 $imagessort = $config['image_sort']; 
  if ($imagessort) {
    $site_sess->set_session_var("imgs_sort", $imagessort);
    $session_info['imgs_sort'] = $imagessort;
  }
}
}
else
{
if (isset($HTTP_POST_VARS['imagesorder'])) {
  $imagesorder = $HTTP_POST_VARS['imagesorder'];
  if ($imagesorder) {
    $site_sess->set_session_var("imgs_order", $imagesorder);
    $session_info['imgs_order'] = $imagesorder;
  }
}
if (isset($session_info['imgs_order'])) {
  $config['image_order'] = $session_info['imgs_order'];
}
if (isset($HTTP_POST_VARS['imagessort'])) {
 $imagessort = $HTTP_POST_VARS['imagessort']; 
  if ($imagessort) {
    $site_sess->set_session_var("imgs_sort", $imagessort);
    $session_info['imgs_sort'] = $imagessort;
  }
}
if (isset($session_info['imgs_sort'])) {
  $config['image_sort'] = $session_info['imgs_sort'];
}
   }
}
//----End Images Sort----------------------------------


Please write your feedback here.

Regards,
Henry

v@no: feel free to edit or move this  :wink:

18
Mods & Plugins (Requests & Discussions) / Re: [MOD] auth_email for Pictures Email Upload V1.7.x
« on: December 14, 2010, 07:28:02 PM »
Hallo,
Quote from: kubiczek on December 14, 2010, 07:22:14 PM

hallo habe meinen post geändert.   habe alles so gemacht wie du beschrieben hast.

kann es sein das es daran liegt, das ich zwei gallerien mit einer datenbank betreibe?

könnte, denn die Frage ist ja nun, in welcher DB sind die Einträge in der settings-Tabelle angelegt worden  :wink:

Wenn Du mit phpmyadmin diesen Code
Code: [Select]
INSERT INTO `4images_settings` (`setting_name`, `setting_value`) VALUES ('noauth_mail', ''), ('noauth_mail_cat', ''), ('noauth_mail_user', '');ausführen läßt, dann wähle im phpmyadmin die korrekte DB aus oder lege es eben in beiden an, auch egal.

EDIT: ODER hast Du eine DB, aber darin arbeitest Du mit zwei Präfixen? Nach nochmaligem lesen komme ich auf diesen Ansatz.  :?
Dann müßtest Du natürlich den Präfix 4images in der SQL-Zeile so ändern, daß es der richtige ist. Gib doch sonst mal den Auszug der betreffenden Zeilen der constants.php her.

Komisch, weil Du IMO ohne die Tabelleneiträge schon eher einen Fehler bekommen müßtest, nämlich schon bei der "noauth_mail"-Abfrage.

Bis gleich,
Henry

EDIT
Ok, der Fehler ist gefunden: Mein Codeschnipsel für die Ermittlung des Users ist nicht korrekt. War mir nicht aufgefallen, weil ich einen Wert gesetzt hatte... aber das script in der settings.php schreibt nicht in die DB. Habe den Code oben angepaßt, so daß (wieder) nur die Eingabe einer Nummer für die User_ID in den settings möglich ist - so geht das zumindest erst mal ohne Fehlermeldung.

Hello v@no, please help again to solve the user-selection. I need same like category-dropdown  :wink:

Thanks a lot!
Henry

19
Mods & Plugins (Requests & Discussions) / Re: [MOD] auth_email for Pictures Email Upload V1.7.x
« on: December 14, 2010, 07:11:22 PM »
Hi,

Du hast den Code-Schnipsel von gestern gegen die Version von heute ersetzt, auch die Einträge im ACP vorgenommen?

Sieht so aus, als würde keine user_id an die SQL-Abfrage übergeben werden.
Wenn Du phpmyadmin hast, siehe doch mal die drei Einträge in der settigs-tabelle an.

Ich mache mal ein Update der Anwendungsbeschreibung oben  :wink:

Bis gleich,
Henry

20
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

21
Mods & Plugins (Releases & Support) / Re: [MOD] Set User Rights per Category in ACP / User Rights Mod
« on: December 14, 2010, 04:23:14 PM »
Hallo,

der ursprüngliche MOD wie auch die Änderung auf Usergruppen laufen beide unter 1.7.9 - danke für dieses feine MOD.

Bis später,
Henry

22
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

23
Plugins / Re: [Plugin] Check Files on server v1.2 (2009-03-29)
« on: December 14, 2010, 10:46:13 AM »
Hello,

thank you v@no for this excellent plugin!

I've a lot of 4images sites with using big-folder and som use MOD histogram.

I'd like to have some plugin-functions to manage this files:

- check for files in $big-folder, if there files without having image-file, it would be nice to delete, but sensitive by extension (usualy i use flv as image-File and in big-dir mp4)
- check for files in $histo-folder, if there files without having image-file, it would be nice to delete

and i need also:
- delete all big-files in selected category
- delete all histogramm.files in selected category (i use "define('HISTO_PATH', ROOT_PATH.HISTO_DIR);" in global.php)

May it is possible to include the first to into files_check.php as well?

I think, the second two easier have an own plugin-file or may include in categories.php like my own modifications:


Thanks & Regards
Henry

24
Mods & Plugins (Requests & Discussions) / Re: [MOD] auth_email for Pictures Email Upload V1.7.x
« on: December 14, 2010, 09:52:27 AM »
Hello,

thank you v@no for providing code! I've found the solution for user dropdown by myself after your advice. May be, it's ok or if you want to make it smaller?

The post above is updated today. If you have the first version, please do step 1.1 and replace in same file settings.php:

search:
  show_setting_row("noauth_mail_cat");
replace:
  show_setting_row("noauth_mail_cat", "show_categorory_select");
and add this:
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>";
}

But i need once again solution for the user_dropdown  :(

Enjoy,
Henry

25
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

26
Mods & Plugins (Releases & Support) / Re: [MOD]Pictures Email Upload V1.7.6
« on: December 13, 2010, 10:11:18 AM »
Hallo,

habe eben für das ACP eine Erweiterung gebastelt, so daß auch dort angezeigt wird, wenn Mail eingegangen ist und diese auf Verarbeitung wartet  :wink:

in der /admin/home.php ist wie folgt zu ergänzen:

suche
  $awaiting_validation = sprintf("<a href=\"".$site_sess->url("validateimages.php?action=validateimages")."\">%s</a>", $awaiting_validation);
  echo "<td width=\"16%\"><b>".$lang['images']."</b></td><td width=\"16%\">".$total_images." / ".$awaiting_validation."</td>\n";

ersetze mit
  $awaiting_validation = sprintf("<a href=\"".$site_sess->url("validateimages.php?action=validateimages")."\">%s</a>", $awaiting_validation);

  class receiveMail
  {
    var $server='';
      var $username='';
        var $password='';

  function receiveMail($server='localhost',$username,$password)
  {
    $strConnect='{'.$server.':110/pop3/notls}';
      $this->server
=
$strConnect;
        $this->username
=
$username;
          $this->password
=
$password;
  }
  function connect()
  {
    $this->mbox=imap_open($this->server,$this->username,$this->password);
  } 
  function getTotalMails()
  {
    $headers=imap_headers($this->mbox);
      return count($headers);
  }
  function close_mailbox()
  {
    imap_close($this->mbox,CL_EXPUNGE);
  }
 }

  $sql = "SELECT  setting_value as pop_server FROM ".SETTINGS_TABLE." WHERE setting_name = 'pop_server'";
    $result = $site_db->query($sql); $row = mysql_fetch_object($result);
      $pop_server = $row->pop_server;

  $sql = "SELECT  setting_value as pop_username FROM ".SETTINGS_TABLE." WHERE setting_name = 'pop_username'";
    $result = $site_db->query($sql); $row = mysql_fetch_object($result);
      $pop_username = $row->pop_username;

  $sql = "SELECT  setting_value as pop_password FROM ".SETTINGS_TABLE." WHERE setting_name = 'pop_password'";
    $result = $site_db->query($sql); $row = mysql_fetch_object($result);
       $pop_password = $row->pop_password;

 $obj= new receiveMail($pop_server,$pop_username,$pop_password);
    $obj->connect();
      $totmails=$obj->getTotalMails(); 
    $obj->close_mailbox();

  if ($totmails == 1) {
  $totmails = "<b>".$totmails."</b> Mail";
}
else
{
  
$totmails = "<b>".$totmails."</b> Mails";
  }
  $totmails = sprintf("<a href=\"".$site_sess->url("plugins/eMail_upload.php")."\">%s</a>", $totmails);

  echo "<td width=\"16%\"><b>".$lang['images']."</b></td><td width=\"16%\">".$total_images." / ".$awaiting_validation." / ".$totmails."</td>\n";

Das sieht dann wie folgt aus:


keine Nachrichten


eine neue Nachricht


mehrere Nachrichten

Habe non noch die Idee, daß man als ADMIN das auch in der Gallerie-Ansicht irgendwo sieht, ob was zum Freischalten vorhanden ist - muß man nicht immer in das ACP sehen.

EDIT:
Hier noch eine kleine Erweiterung: Der Absender der Mail bekommt eine Antwort, ob die Bilder eingelesen wurden (ob eMail_upload.php ausgeführt wurde - nicht validateimages.php) oder ob die Mail verworfen wurde.

in der eMail_upload.php ist wie folgt zu ergänzen:
1) suche
  require(ROOT_PATH.'includes/image_utils.php');

füge dannach ein
  include(ROOT_PATH.'includes/email.php');

2) suche
                $br=explode(",",$str);
füge dannach ein
                $message = "";

3) suche
          $image_id = $site_db->get_insert_id();
  }
     } 
      else
ersetze mit
          $image_id = $site_db->get_insert_id();
          $message = $message."".$image_name." ";
  }
    $subject = "Deine Mail wurde von ".$config['site_name']." empfangen!";
      $site_email = new Email();
      $site_email->set_to($head['from']);
      $site_email->set_subject($subject);
      $site_email->register_vars(array(
        "recipient_name" => $head['fromName'],
        "site_name" => $config['site_name'],
"message" => $message
      ));
      $site_email->set_body("mailimages_confirm", $config['language_dir']);
      $site_email->send_email();
     }
     else

4) suche
          echo '<td class="marktext">Mail wurde gelöscht!</td>';
          echo '</tr>';

füge dannach ein
    $subject = "Deine Mail an ".$config['site_name']." wurde gelöscht!";
      $site_email = new Email();
      $site_email->set_to($head['from']);
      $site_email->set_subject($subject);
      $site_email->register_vars(array(
        "recipient_name" => $head['fromName'],
        "site_name" => $config['site_name']
      ));
      $site_email->set_body("mailimages_delconfirm", $config['language_dir']);
      $site_email->send_email();


In der Anlage findest Du zwei Vorlagen, die müssen nach \lang\xxx\email\ und können natürlich noch angepaßt werden  :wink:

Leider ist noch eine Sache zu fixen: Wenn per Mail gesendete Dateien Umlaute haben, dann zerreißt dies die Tabelle wie auch die Liste in der Confirm-Mail.

EDIT:
Per Mail gesendete Dateien mit Umlauten werden nicht sauber verarbeitet - das ist offenbar noch eine generelle Baustellen. Andi, Jens: Bitte mal testen  :wink:

Viel Spaß damit,
Henry

27
Mods & Plugins (Releases & Support) / Re: [MOD] Search by category name
« on: December 13, 2010, 08:20:51 AM »
Hallo Jens,

zu meinem besseren Verständnis: Du verwendest Cat-Images und es wird "lediglich" das falsche - respektive immer das identische - dargestellt? Die Cat und die Bilder zur Cat sind aber Treffer?

Muß ich mal bei mir in der anderen Gallerie testen, dort verwende ich jedoch statische Cat-Images.

Bis später,
Henry

28
Mods & Plugins (Requests & Discussions) / Re: Subtitel für Kategorien in der Übersicht [Ergänzung für die Beschreibung]
« on: December 12, 2010, 02:04:09 PM »
Hallo,

Danke an Rembrandt für den feinen MOD "[MOD] Search by category name" http://www.4homepages.de/forum/index.php?topic=28587

Ich habe diesen um das Suchen in der cat_description und dem hier neu erstellten cat_subtitel erweitert, siehe dazu im Tread zum MOD von Rembrandt.

Viele Grüße,
Henry

29
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

30
Mods & Plugins (Releases & Support) / Re: [MOD] Search by category name
« on: December 12, 2010, 11:30:48 AM »
Hallo Andi,

funzt, Dankeschön!

Und *sehr* cool: Kombination aus Kategorienamen und Schlüsselwörtern klappt auch  :mrgreen:

Viele Grüße,
Henry

Pages: 1 [2] 3 4 5