Picture of the month

[ccsakuweb]

hi.. i installed your mod but.. i have the next error db :

Code: [Select]

DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_thumb_file, i.image_media_file, i.image_thumb_file, i.image_rating, i.image_votes, i.image_comments, c.cat_name, u.user_name, i.image_downloads, i.image_hits, i.image_potm, i.image_potm_date, i.image_potm_votes FROM 4images_images i, 4images_categories c, phpbb_users u WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND i.cat_id = c.cat_id AND i.user_id = u.user_id AND i.image_potm = 0 AND i.image_potm_date = '2005-12-01' ORDER BY i.image_name, i.image_hits ASC LIMIT 12
Unknown column 'u.user_name' in 'field list'
could you help me?

[KurtW]

hi ccsakuweb ,

i think, you have also the PhpBB-Mod
Than its a problem. Im the phpBB-Mod too, and i found no way..

cu
Kurt

[V@no]

search for user_name and replace it with username

[KurtW]

Hi veno,

yes, the first step.
but
dont work..

http://www.malediven-bilder.de/potm.php

cu
Kurt

[oswald]

When calling the "photo of the month" funktion for the first time, I get this:

Code: [Select]

DB Error: Bad SQL Query: UPDATE 4images_images SET image_potm = 1 WHERE image_potm_date = '0001-01-01' ORDER BY image_potm_votes DESC LIMIT 1
You have an error in your SQL syntax near 'ORDER BY image_potm_votes DESC LIMIT 1' at line 4

DB Error: Bad SQL Query: UPDATE 4images_images SET image_potm_date = '2005-12-01' WHERE image_potm = 0 ORDER BY image_hits DESC LIMIT 2
You have an error in your SQL syntax near 'ORDER BY image_hits DESC LIMIT 2' at line 4
When calling POTM a second time, I do not get any more errors, but there are also no pics.... all I see it the default "Vote for photo of the month" message with nothing under it...

Please help...

[ccsakuweb]

yes i have phpbb_mod... and the picture_MOD doesn´t work in my site

[TIMT]

ok i have found a way to use this with 1.71 even though it may be wrong but it works

the problem was i could not see last months winners so in potm.html
i added this link

http://yoursite/4images/potm.php?action=lw

and it works hope this helps someone

RT

hello,

Thank you, very useful for me your message. 

This is only the link to the "last months winners". But when I see this winners, I want to have the link back to the leading pictures of this months. I dont know, why the link {potm_menu_link} is not shown. Can anybody help me?

Thanks

[TIMT]

Anybody? 

[boerdi]

Hello!
Also...ab wann die potm.php zu starten beginnt, ist in der 4images_settings table zu ändern!

Und zwar unter potm_date einfach anpassen!

Glaube schon, dass es funktioniert..kann das wer probieren?

lg

[Lucifix]

Hi!

Did anyone make Photo of the week from this mode?

[HorrorCrafT]

so, hab mir diesen MOD auch mal angeschaut und eingebaut.

warum neben dem bild nur ":" und kein "Benutzer:" oder "Kategorie:" steht oder warum der {potm_menu_link} link nicht sichtbar ist, ist ein bug der sich durch die gesamte potm.php zieht und zwar folgendermaßen:

ursprünglicher scriptauszug aus der potm.php:

$potm_menu .= "<br>{lang_top_category}: " . "<a href=\"".$site_sess->url(ROOT_PATH. .... usw.

das "<br>{lang_top_category}: " kann so nicht aufgelöst werden und muss umgeschrieben werden auf:

$potm_menu .= "<br>".$lang['top_category'].": " . "<a href=\"".$site_sess->url(ROOT_PATH. .... usw.

nun kann die sprachvariable aus der main.php gezogen und hier angezeigt werden. wenn ihr also auch die linkvariablen so umschreibt, werden sie auch in der 1.7.1er version sichtbar.

eine späte info, ich weiss, aber das hätte eigentlich der programmierer dieses MODs oder einer der großen zampanos hier, korrigieren müssen ansonsten aber ein feiner MOD!!! danke dafür!

[HorrorCrafT]

kann ein admin eigentlich bilder auch händisch auswählen und zur auswahl stellen? wenn ja, wie geht das?

can admin select pictures "by hand"? if it works, how can i do that? - my english - sorry 

[Stoleti]

And what about show the Last Month Winner (image) at home.html ???

[HorrorCrafT]

i'm also interested on this alternative!

[HorrorCrafT]

no php specialist who can help?