Author Topic: Email list of images in lightbox...  (Read 172351 times)

0 Members and 2 Guests are viewing this topic.

Offline e-trader_2002

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: Email list of images in lightbox...
« Reply #120 on: June 16, 2006, 09:31:36 PM »
Hi,

I just installed the MOD "Email list of images in lightbox" and selceted a few images for the lightbox. In the lightbox all selected images are displayed but when I click the recently added link to generate the email-list of the selected images I get the following error-message from the related SQL-Query in quotation.php:

Quote
DB Error: Bad SQL Query: 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, i.katalog_nr, i.marke, i.land, i.zusatz_text, i.plu, i.farbe, i.t_farbe, i.form, i.material, i.breite, i.hoehe, i.specials, i.anzahl, i.album_seite, i.acq_datum, i.acq_quelle, i.kurs, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE image_active = 1 AND image_id IN (167, 168, 169, 170) AND c.cat_id = i.cat_id AND i.cat_id IN (0, 22, 17, 3, 33, 41, 4, 7, 44, 34, 32, 14, 1, 24, 8, 47, 39, 30, 5, 2, 11, 12, 10, 40, 9, 28, 38, 29, 18, 13, 48, 20, 19, 16, 6, 21, 27, 25, 23, 26, 15) ORDER BY image_name ASC LIMIT 0, 12
Unknown column 'i.user_id' in 'on clause'

When no images are selected for the lightbox, the error doesn't occur and quotation.php simply says, that there are no images selected for the lightbox.

I would like very much to use this MOD but I can't find any post related to this error and I'm not able to figure out the reason why this error occurs.

I'm using 4images 1.72 and the unmodified files from the downloaded file english_translation.zip. Can anybody help me? Thanks

e-trader_2002
« Last Edit: June 16, 2006, 09:59:35 PM by e-trader_2002 »
A hobby is a great way to spent time you actually don't have! :wink:


Offline e-trader_2002

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: Email list of images in lightbox...
« Reply #121 on: June 17, 2006, 03:27:47 PM »
Hallo,

I solved my problem described above. The errror occurs because of a change in MySql (s. MySQL 5.0 Reference Manual - 13.2.7.1. JOIN Syntax):

Quote
Note: Beginning with MySQL 5.0.12, natural joins and joins with USING, including outer join variants, are processed according to the SQL:2003 standard. These changes make MySQL more compliant with standard SQL. However, they can result in different output columns for some joins. Also, some queries that appeared to work correctly in older versions must be rewritten to comply with the standard.

So I had to change the related SQL-Query in quotation.php by adding a pair of parentheses:

Quote
  $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 image_active = 1 AND image_id IN ($image_id_sql) AND c.cat_id = i.cat_id AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
          ORDER BY ".$config['image_order']." ".$config['image_sort']."
          LIMIT $offset, $perpage";

Now everything works well. I hope this post will help you if you are facing the same problem.

e-trader_2002
A hobby is a great way to spent time you actually don't have! :wink:


Offline ipicture

  • Jr. Member
  • **
  • Posts: 75
    • View Profile
    • Ipicture - Die Welt im Bild
Re: Email list of images in lightbox...
« Reply #122 on: June 23, 2006, 11:57:50 AM »
In the quotation.php there is included the thumbnail_quotation_bit.html in which the lightbox_button is responsible for remove the image. The button-image is the lightbox_yes.gif configured in the function.php.

Now I want to have another image for removing the the pigs out of the lightbox.

How can I do this?

function.php / line 223:
Code: [Select]
  if ($user_info['user_level'] != GUEST) {
    $lightbox_url = $self_url;
    $lightbox_url .= (!empty($mode)) ? ((preg_match("/\?/", $lightbox_url)) ? "&" : "?")."mode=".$mode : "";
    $lightbox_url .= preg_match("/\?/", $lightbox_url) ? "&" : "?";
    if (check_lightbox($image_row['image_id'])) {
      $lightbox_url .= "action=removefromlightbox&id=".$image_row['image_id'];
      $lightbox_button = "<a href=\"".$site_sess->url($lightbox_url)."\"><img src=\"".get_gallery_image("lightbox_yes.gif")."\" border=\"0\" alt=\"\" /></a>";
    }
    else {
      $lightbox_url .= "action=addtolightbox&amp;id=".$image_row['image_id'];
      $lightbox_button = "<a href=\"".$site_sess->url($lightbox_url)."\" onmouseover=stm(Text[7],Style[0]) onmouseout=htm()><img src=\"".get_gallery_image("lightbox_no.gif")."\" border=\"0\" alt=\"\" /></a>";
    }
  }
  else {
    $lightbox_button = "<img src=\"".get_gallery_image("lightbox_off.gif")."\" border=\"0\" alt=\"\" />";
  }



Klaus
« Last Edit: June 26, 2006, 06:10:05 PM by ipicture »

Offline mstgokcen

  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: Email list of images in lightbox...
« Reply #123 on: July 22, 2006, 10:48:02 AM »
I have the same problem when I install mini top.php MOD..

and now I changed my sql too but it doesnt work

before I changed it was

Code: [Select]
// Votes
$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_thumb_file, i.image_rating, i.image_votes, c.cat_name, u.user_name
       FROM ".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c, ".USERS_TABLE." u
       WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id AND i.user_id = u.user_id $cat_match_sql
       ORDER BY i.image_votes DESC, i.image_name ASC
       LIMIT 20";


then I made
Code: [Select]
// Votes
$sql = "SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_thumb_file, i.image_rating, i.image_votes, c.cat_name, u.user_name
       FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c, ".USERS_TABLE." u )
       WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id AND i.user_id = u.user_id $cat_match_sql
       ORDER BY i.image_votes DESC, i.image_name ASC
       LIMIT 20";


for 4 times but it didnt work?

any idea

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: Email list of images in lightbox...
« Reply #124 on: July 22, 2006, 09:02:00 PM »
the same problem as whom?
didnt work how?
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline mstgokcen

  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: Email list of images in lightbox...
« Reply #125 on: July 22, 2006, 09:30:57 PM »
I send another post that is OK ...At first I changed wrong SQL codes then i corrected..
thx

Offline radbe

  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: Email list of images in lightbox...
« Reply #126 on: November 30, 2006, 10:02:05 PM »
With this MOD, one important thing missing...

At first I thought about having someone provide a simple way to add an entire category to the lightbox
but then I would still have to fill out information for each file, that's crazy when you have 100+ photos in lightbox
So basically in addition to that you will also need a form that gives the option to send (1) universal request for all files in the lightbox.

Therefore let's say you have 100 photo's the option would allow you to request 1 format for all of them
so maybe adding a check box, that when selected will switch you to another form
allowing you to fill out once the information for all images in the lightbox..
because it is easier to remove the few you want formatted differently and send them as a seperate request..
than to fill out information for each one, don't you think?
 
« Last Edit: November 30, 2006, 10:12:54 PM by radbe »

Offline proMedien

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: Email list of images in lightbox... Little modification
« Reply #127 on: March 06, 2007, 04:18:10 PM »
Hi everybody.

Thank god (and the professionals in this forum) I found this mod. It is exactly what i´ve been searching for.
But i have to modify it a little. All the details like size, usage, distribution, duration, ... I don´t need in my case.
At first, I am a totally php-Newb. And after days of trying I need help now.

My version of 4images: 1.7.3
php-Version: 4.4.4

The situation:
The user fills his lightbox("Bildauswahl") with the pictures he wants to order. (MOD: Lightbox for guests. Great work.)
When finished he goes to the Order form("Bestellformular") fills out the input boxes with name, company, email, ... and klicks "Bestellen".
That creates a eMail with the list of pictures in his lightbox and his personal data that is sent to me. This works so far.

The problem:
The images are all listed among themselves. How can I let them list just like in the lightbox, 3 x 2 ?
How can I change the details given in the eMail, especially the real filename because that could be different.

I added my modified quotation.php as .txt after this reply.


I hope you could understand my problem and have any idea that could help me.
Thank you for every idea.

Stephan
"Imagination is more important than knowledge." - Albert Einstein

Offline Patrick81

  • Newbie
  • *
  • Posts: 27
    • View Profile
Re: Email list of images in lightbox...
« Reply #128 on: September 02, 2007, 01:03:53 PM »
Has someone add a captcha feature for this mod?

Would be great.

br
Pat

Offline musicsurfer

  • Full Member
  • ***
  • Posts: 184
    • View Profile
Re: Email list of images in lightbox...
« Reply #129 on: April 08, 2008, 11:49:09 PM »
Hat es eigentlich mal jemand geschafft in dieses LIghtbox-Warenkorbsystem Preise mit einzubauen ?

Ein anderer User hatte sowas auch mal gesuchtm aber ohne Erfolg

ch suche für die neuste Version von 4images ein Modul/Add on, mit dem die Käufer Bilder in verschiedenen Grössen & Preisen bestellen können.

Zum Beispiel:
Foto XY kann bestellt werden in
10x15 zu 1 Euro
13 x 18 zu 2 Euro
20x30 zu 3 Euro

Die Grössen und Preise sind für alle Fotos gleich.

Es muss keine Anbindung an PayPal vorhanden sein, obwohl dies natürlich grossartig wäre.


Gruss

Offline proMedien

  • Pre-Newbie
  • Posts: 5
    • View Profile
Email list of images in lightbox... PHP5
« Reply #130 on: October 27, 2008, 04:02:48 PM »
Hallo zusammen.

Mein Provider stellt Ende des Jahres den Betrieb von PHP4 auf seinen Servern komplett ein. Ist das Script so in dieser Version unter PHP5 lauffähig?
Ich habs mal getestet. Ich habe die Erweiterung ".php" als unterstütztes Format unter "PHP4-Extensions" rausgenommen und nur noch unter "PHP5-Extensions" dringelassen.

Dann habe ich folgende Fehlermeldung bekommen:
"Warning: Variable passed to each() is not an array or object in ...templates/default/quotation_send.php on line 3"

Wenn ich ".php" wieder PHP4 zuordne, läufts wieder.

Bitte helft mir, ich steh echt aufm Schlauch.

Vielen Dank
Stephan

-----

Hello everybody.

My provider completely stops the support of PHP4 to the end of the year. Does this Script run on PHP5?
I have already checked it. In the settings of the Server I deleted ".php" as supported "PHP4-Extension" and only left it as a "PHP5-Extension".

In my browser the follwing error message is shown:
"Warning: Variable passed to each() is not an array or object in ...templates/default/quotation_send.php on line 3"

Everything works fine again, if I put ".php" back on the supported filetypes for PHP4.

Can somebody please help me?

Very great thanks in advance
Stephan


"Imagination is more important than knowledge." - Albert Einstein

Offline nobby

  • 4images Guru
  • *******
  • Posts: 2.873
    • View Profile
Re: Email list of images in lightbox...
« Reply #131 on: October 27, 2008, 04:10:08 PM »
Hallo,

wenn Du die Version 1.7.6 einsetzt gibt es keine Probleme, ist für 5 gemacht.

Ansonsten von älteren Versionen auf die neueste Updaten  :wink:

nobby

Offline proMedien

  • Pre-Newbie
  • Posts: 5
    • View Profile
Re: Email list of images in lightbox...
« Reply #132 on: October 27, 2008, 04:21:50 PM »
Hallo.

Vielen Dank für diesen superschnellen Tipp.
Ich dachte, es liegt an der Programmierung dieses MODs (unbeannter Befehl, oder so.)

Da ich allerdings viel von Hand umgeschrieben habe (und das gar nicht mehr alles weiß) muss ichs wohl von Hand machen.  :?
Dann werde ich mal updaten. Vielen Dank.

Grüße
Stephan
"Imagination is more important than knowledge." - Albert Einstein

Offline nobby

  • 4images Guru
  • *******
  • Posts: 2.873
    • View Profile
Re: Email list of images in lightbox...
« Reply #133 on: October 27, 2008, 04:27:49 PM »
Dafür nicht...

Updates sind immer wichtig und sollte man auch machen, auch wenn einige MODs neu Angepasst werden müssen.

nobby

Offline Oblaten

  • Newbie
  • *
  • Posts: 27
    • View Profile
Re: Email list of images in lightbox...
« Reply #134 on: March 10, 2009, 03:29:36 PM »
Hallo,

ich benutze die 4images 1.7.6, PHP Version 5.2.6 - erhalte aber trotzdem die folgenden Fehlermeldungen wenn eine Anfrage abgeschickt wird:

Warning: Variable passed to each() is not an array or object in .../templates/hell/quotation_send.php on line 3

Warning: Cannot modify header information - headers already sent by (output started at .../templates/hell/quotation_send.php:3) in .../templates/hell/quotation_send.php:3) in .../templates/hell/quotation_send.php on line 25

Kann mir jemand sagen, woran das liegen kann?

Grüsse
Oblaten

« Last Edit: March 10, 2009, 03:54:11 PM by Oblaten »