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 - Michael

Pages: [1] 2 3 4 5 ... 12
1
Mods & Plugins (Releases & Support) / Re: Small Credit "System" "MOD"
« on: June 14, 2006, 10:07:06 AM »
besteht die Möglichkeit die Punkte nach der Anzahl der Zeichen zu zählen,
z.B. 10 zeichen = 1 Punkt

So könnten die User belohnt werden die auch entsprechend lange Kommentare abgeben  :wink:

Gruß, Michael

2
Quote
Also habe ich das richtig verstanden? Wer entsprechend kommentare abgegeben hat, darf auch dann posten? Habe ich was übersehen in diesem Mod?

Mit "posten" meine ich Bilder hochladen, quasi als "Belohnung"

Quote
Wenn das auf Bezug von Kommentaren geht bzw. Einschränkung aufs Posten, müsste dies doch auch auf Kategorien gehen, oder?

keine Ahnung ob dieses dann noch funktionieren würde?

3
Bug Fixes & Patches / Re: [1.7.2] Security hole in register.php
« on: April 26, 2006, 09:28:13 AM »
Hallo, was ist mit den älteren versionen 1.7 / 1.7.1  ??

4
Das wäre doch wirklich ein guter Mod, würde sogar demjenigen etwas "spenden" der dieses coden würde!

5
Thank you V@no, its a great Mod  :D

6
Mods & Plugins (Releases & Support) / Re: Birthday Mod v1.0
« on: February 18, 2006, 06:01:23 PM »
Sauberer Zusatz-Mod  :mrgreen:

großes Dankeschön  :D

7
Mods & Plugins (Releases & Support) / Re: Birthday Mod v1.0
« on: February 11, 2006, 03:52:05 PM »
Funktioniert super  :)

vielen Dank !!!

8
Mods & Plugins (Requests & Discussions) / Re: Random pictures
« on: January 14, 2006, 07:05:45 PM »
Hallo,

index.php

Code: [Select]
//------------------------------------
//------- Random Images --------------
//------------------------------------
$num_new_images = $config['image_cells'];
$cat_in = array(33,32,34,35,36,37,38,4); //list of category ids // *** TO FILTER RANDOM IMAGES ***

$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name")."
       FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c
       LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
       WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.image_rating > 8.5 AND i.image_votes > 1 AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").") AND i.cat_id IN (".implode(", ",$cat_in).")
       ORDER BY RAND()
       LIMIT $num_new_images";
// end new
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);

if (!$num_rows)  {
 $random_images = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\"><tr class=\"imagerow1\"><td>";
//  $random_images .= $lang['no_new_images'];
 $random_images .= "</td></tr></table>";
}
else  {
 $random_images = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">";
 $count = 0;
 $bgcounter = 0;
 while ($image_row = $site_db->fetch_array($result)){
   if ($count == 0) {
     $row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;
     $random_images .= "<tr class=\"imagerow".$row_bg_number."\">\n";
   }
   $random_images .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n";

   show_image($image_row);
   $random_images .= $site_template->parse_template("thumbnail_bit");
   $random_images .= "\n</td>\n";
   $count++;
   if ($count == $config['image_cells']) {
     $random_images .= "</tr>\n";
     $count = 0;
   }
 } // end while

 if ($count > 0)  {
   $leftover = ($config['image_cells'] - $count);
   if ($leftover >= 1) {
     for ($f = 0; $f < $leftover; $f++) {
       $random_images .= "<td width=\"".$imgtable_width."\">\n&nbsp;\n</td>\n";
     }
     $random_images .= "</tr>\n";
   }
 }
 $random_images .= "</table>\n";
} // end else


$site_template->register_vars("random_images", $random_images);
unset($random_images);

die in Klammern stehenden Zahlen entsprechend den eigenen Cat Id's, die angezeigft werden sollen, austauschen

$cat_in = array(33,32,34,35,36,37,38,4); //list of category ids // *** TO FILTER RANDOM IMAGES ***

hier wird die Mindestbewertung eingestellt, es werden nur Bilder angezeigt die mindestens 8,5 Punkte haben!
Den Wert entsprechend tauschen.

WHERE i.image_active = 1 AND c.cat_id = i.cat_id AND i.image_rating > 8.5 AND i.image_votes > 1 AND i.cat_id IN (".get_auth_cat_sql


Ich hoffe es hilft Dir weiter  :D

9
Thanks for wonderful MOD  :D

10
Mods & Plugins (Requests & Discussions) / Re: Profil erweitern
« on: December 20, 2005, 07:31:21 PM »
@Michael

... ich hoffe du hast die ;'s wieder replatziert ...  :wink:

ja ja ... hab ich  :oops:

11
Mods & Plugins (Requests & Discussions) / Re: Profil erweitern
« on: December 20, 2005, 07:23:32 PM »
Daher dachte ich das es anders aussehen muss weil die signatur bei mir in der users Tabelle abgelegt ist....

dort ist sie auch richtig abgelegt!

12
Mods & Plugins (Requests & Discussions) / Re: Profil erweitern
« on: December 20, 2005, 12:05:45 AM »
BINGO ...

nun klappts auch mit dem Nachbarn  :mrgreen:

DANKE

Gruß, Michael

13
Mods & Plugins (Requests & Discussions) / Re: Profil erweitern
« on: December 19, 2005, 09:54:20 PM »
Hallo Mawenzi,

sorry ich meinte ab Schritt 2.

Die Fehler treten auf sobald ich den 2. Schritt tätige, Schritt 1 funktioniert ohne Probleme und ich kann über das Kontrollzentrum auch eine Signatur eingeben.

Quote
3. ... was sollen wir mit deinem Code --- Show Comments --- ?

Du schreibst:
Quote
2. Schritt
finde in details.php :

Code:
$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS......

Genau das habe ich gesucht und entsprechend ersetzt, dieses steht in meiner details.php genau unter "show comments" und nur dort!
Ich habe das nun mehrmals ausprobiert und es kann gut sein das es bei mir nicht funktioniert da ich schon viele "Mods" mit eingebunden habe.

Fakt ist das bei Schritt 2 die Fehler, zumindest bei meinem Scribt, auftauchen.

Gruß, Michael

14
Mods & Plugins (Requests & Discussions) / Re: Profil erweitern
« on: December 19, 2005, 07:04:11 PM »
Schon bei dem ersten Schritt erhalte ich folgende Fehlermeldungen:

Code: [Select]
DB Error: Bad SQL Query: SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date, u.user_level, u.user_name, u.user_email, u.user_showemail, u.user_invisible, u.user_joindate, u.user_lastaction, u.user_comments, u.user_homepage, u.user_icq, u.user_id, i.user_id_last_vote, i.last_vote, i.last_rating, i.user_name_vote, i.image_photographer FROM 4images_comments c LEFT JOIN 4images_users u ON (u.user_id = c.user_id) WHERE c.image_id = 8599 ORDER BY c.comment_date ASC
Unknown table 'i' in field list

Das ganze soll ja in der details.php unter "show comments" rein, hier ein Ausschnitt:

Code: [Select]
//-----------------------------------------------------
//--- Show Comments -----------------------------------
//-----------------------------------------------------
if ($image_allow_comments == 1) {
  $sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_showemail").get_user_table_field(", u.", "user_invisible").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").get_user_table_field(", u.", "user_homepage").get_user_table_field(", u.", "user_icq")."
          FROM ".COMMENTS_TABLE." c
          LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = c.user_id)
          WHERE c.image_id = $image_id
          ORDER BY c.comment_date ASC";
  $result = $site_db->query($sql);

  $comment_row = array();
  while ($row = $site_db->fetch_array($result)) {
    $comment_row[] = $row;
  }
  $site_db->free_result($result);
  $num_comments = sizeof($comment_row);

  if (!$num_comments) {
    $comments = "<tr><td class=\"commentrow1\" colspan=\"2\">".$lang['no_comments']."</td></tr>";
  }
  else {
    $comments = "";
    $bgcounter = 0;
    for ($i = 0; $i < $num_comments; $i++) {
      $row_bg_number = ($bgcounter++ % 2 == 0) ? 1 : 2;

      $comment_user_email = "";
      $comment_user_email_save = "";
      $comment_user_mailform_link = "";
      $comment_user_email_button = "";
      $comment_user_homepage_button = "";
      $comment_user_icq_button = "";
      $comment_user_profile_button = "";
      $comment_user_status_img = REPLACE_EMPTY;
      $comment_user_name = htmlspecialchars($comment_row[$i]['comment_user_name']);
      $comment_user_info = $lang['userlevel_guest'];

      $comment_user_id = $comment_row[$i]['user_id'];
      $user_row_comment = get_user_info($comment_user_id);

      if (isset($comment_row[$i][$user_table_fields['user_name']]) && $comment_user_id != GUEST) {
        $comment_user_name = htmlspecialchars($comment_row[$i][$user_table_fields['user_name']]);

        $comment_user_profile_link = !empty($url_show_profile) ? $site_sess->url(preg_replace("/{user_id}/", $comment_user_id, $url_show_profile)) : $site_sess->url(ROOT_PATH."member.php?action=showprofile&amp;".URL_USER_ID."=".$comment_user_id);
        $comment_user_profile_button = "<a href=\"".$comment_user_profile_link."\"><img src=\"".get_gallery_image("profile.gif")."\" border=\"0\" alt=\"".$comment_user_name."\" /></a>";

        $comment_user_status_img = ($comment_row[$i][$user_table_fields['user_lastaction']] >= (time() - 300) && ((isset($comment_row[$i][$user_table_fields['user_invisible']]) && $comment_row[$i][$user_table_fields['user_invisible']] == 0) || $user_info['user_level'] == ADMIN)) ? "<img src=\"".get_gallery_image("user_online.gif")."\" border=\"0\" alt=\"Online\" />" : "<img src=\"".get_gallery_image("user_offline.gif")."\" border=\"0\" alt=\"Offline\" />";

        $comment_user_homepage = (isset($comment_row[$i][$user_table_fields['user_homepage']])) ? format_url($comment_row[$i][$user_table_fields['user_homepage']]) : "";
        if (!empty($comment_user_homepage)) {
          $comment_user_homepage_button = "<a href=\"".$comment_user_homepage."\" target=\"_blank\"><img src=\"".get_gallery_image("homepage.gif")."\" border=\"0\" alt=\"".$comment_user_homepage."\" /></a>";
        }

        $comment_user_icq = (isset($comment_row[$i][$user_table_fields['user_icq']])) ? $comment_row[$i][$user_table_fields['user_icq']] : "";
        if (!empty($comment_user_icq)) {
          $comment_user_icq_button = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=".$comment_user_icq."\" target=\"_blank\"><img src=\"http://web.icq.com/whitepages/online?icq=".$comment_user_icq."&img=5\" width=\"18\" height=\"18\" border=\"0\" alt=\"".$comment_user_icq."\" /></a>";
        }

        if (!empty($comment_row[$i][$user_table_fields['user_email']]) && (!isset($comment_row[$i][$user_table_fields['user_showemail']]) || (isset($comment_row[$i][$user_table_fields['user_showemail']]) && $comment_row[$i][$user_table_fields['user_showemail']] == 1))) {
          $comment_user_email = $comment_row[$i][$user_table_fields['user_email']];
          $comment_user_email_save = str_replace("@", " at ", $comment_row[$i][$user_table_fields['user_email']]);
          if (!empty($url_mailform)) {
            $comment_user_mailform_link = $site_sess->url(preg_replace("/{user_id}/", $comment_user_id, $url_mailform));
          }
          else {
            $comment_user_mailform_link = $site_sess->url(ROOT_PATH."member.php?action=mailform&amp;".URL_USER_ID."=".$comment_user_id);
          }
          $comment_user_email_button = "<a href=\"".$comment_user_mailform_link."\"><img src=\"".get_gallery_image("email.gif")."\" border=\"0\" alt=\"".$comment_user_email_save."\" /></a>";
        }

        if (!isset($comment_row[$i][$user_table_fields['user_level']]) || (isset($comment_row[$i][$user_table_fields['user_level']]) && $comment_row[$i][$user_table_fields['user_level']] == USER)) {
          $comment_user_info = $lang['userlevel_user'];
        }
        elseif ($comment_row[$i][$user_table_fields['user_level']] == ADMIN) {
          $comment_user_info = $lang['userlevel_admin'];
        }

        $comment_user_info .= "<br />";
        $comment_user_info .= (isset($comment_row[$i][$user_table_fields['user_joindate']])) ? "<br />".$lang['join_date']." ".format_date($config['date_format'], $comment_row[$i][$user_table_fields['user_joindate']]) : "";
        $comment_user_info .= (isset($comment_row[$i][$user_table_fields['user_comments']])) ? "<br />".$lang['comments']." ".$comment_row[$i][$user_table_fields['user_comments']] : "";
      }

      $comment_user_ip = ($user_info['user_level'] == ADMIN) ? $comment_row[$i]['comment_ip'] : "";

      $admin_links = "";
      if ($user_info['user_level'] == ADMIN) {
        $admin_links .= "<a href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("comments.php?action=editcomment&amp;comment_id=".$comment_row[$i]['comment_id']))."\" target=\"_blank\">".$lang['edit']."</a>&nbsp;";
        $admin_links .= "<a href=\"".$site_sess->url(ROOT_PATH."admin/index.php?goto=".urlencode("comments.php?action=removecomment&amp;comment_id=".$comment_row[$i]['comment_id']))."\" target=\"_blank\">".$lang['delete']."</a>";
      }
      elseif ($is_image_owner) {
        $admin_links .= ($config['user_edit_comments'] != 1) ? "" : "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=editcomment&amp;".URL_COMMENT_ID."=".$comment_row[$i]['comment_id'])."\">".$lang['edit']."</a>&nbsp;";
        $admin_links .= ($config['user_delete_comments'] != 1) ? "" : "<a href=\"".$site_sess->url(ROOT_PATH."member.php?action=removecomment&amp;".URL_COMMENT_ID."=".$comment_row[$i]['comment_id'])."\">".$lang['delete']."</a>";
      }

      $site_template->register_vars(array(
        "comment_id" => $comment_row[$i]['comment_id'],
        "user_avatar_current" => ($config['avatar_use']) ? "<img src=\"".TEMPLATE_PATH."/avatars/".(($user_row_comment['user_avatar'] == "") ? "blank.gif" : $user_row_comment['user_avatar'])."\" name=\"icons\" border=\"0\" hspace=\"15\" alt=\"\">" : "",
        "comment_user_id" => $comment_user_id,
        "comment_user_status_img" => $comment_user_status_img,
        "comment_user_name" => $comment_user_name,
        "comment_user_info" => $comment_user_info,
        "comment_user_profile_button" => $comment_user_profile_button,
        "comment_user_email" => $comment_user_email,
        "comment_user_email_save" => $comment_user_email_save,
        "comment_user_mailform_link" => $comment_user_mailform_link,
        "comment_user_email_button" => $comment_user_email_button,
        "comment_user_homepage_button" => $comment_user_homepage_button,
        "comment_user_icq_button" => $comment_user_icq_button,
        "comment_user_ip" => $comment_user_ip,
        "comment_headline" => format_text($comment_row[$i]['comment_headline'], 0, $config['wordwrap_comments'], 0, 0),
        "comment_text" => format_text($comment_row[$i]['comment_text'], $config['html_comments'], $config['wordwrap_comments'], $config['bb_comments'], $config['bb_img_comments']),
        "comment_date" => format_date($config['date_format']." ".$config['time_format'], $comment_row[$i]['comment_date']),
        "row_bg_number" => $row_bg_number,
        "admin_links" => $admin_links
      ));
      $comments .= $site_template->parse_template("comment_bit");
    } // end while
  } //end else
  $site_template->register_vars("comments", $comments);
  unset($comments);

das Problem liegt hier schon am:  .get_user_table_field(", u.", "user_signature").$additional_sql.
es werden neben der Fehlermeldung auch keinerlei Kommentare mehr angezeigt!

Gruß, Michael

15
Mods & Plugins (Requests & Discussions) / Re: Profil erweitern
« on: December 19, 2005, 04:40:13 PM »
WOW ... das nenne ich eine detaillierte Anleitung  :mrgreen:

Werde das heute im laufe des Abend mal testen.

DANKE  :D


Pages: [1] 2 3 4 5 ... 12
Post your comments here