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

Pages: 1 ... 25 26 27 28 [29]
421
Mods & Plugins (Releases & Support) / Re: [Mod] Photo Of The Day
« on: September 07, 2005, 12:22:40 AM »
I am having an issue adding the potd to an external html file.
I would greatly appreciate any help on getting this to work in the next few days.
long time ago i've posted a small script to show random/latest picture at the external page, even on different server. unfortunatelly, now i can't find it nether here, nor on my computer. probably it was lost during phpbb hack. maybe other users here could help you to find it, if so you can slightly modify it to show picture of the day.

I will keep looking, maybe with any luck I will find it   :o

422
Mods & Plugins (Releases & Support) / Re: [Mod] Photo Of The Day
« on: August 31, 2005, 02:17:15 PM »
Quote

But.. I turn "random" images :(

SO.. if I called it for:
  <tr><td align="center" class="row1">{lang_potd_type}<br />Image by Hits<br /></td></tr>

Get one error :(

aff.. my gallery dont show the names :(

Not sure what you mean by "turn random images".?
Are you sure all the code is correct if it is not displaying the name?
Even when I first added this I would get the name, but no image until I fixed the code.

423
Mods & Plugins (Releases & Support) / Re: [Mod] Photo Of The Day
« on: August 31, 2005, 10:59:18 AM »
I am having an issue adding the potd to an external html file.
I would greatly appreciate any help on getting this to work in the next few days.

I see that an earlier post it says something about the random image mod. However I do not know if this needs to be used as the randmon image is already included with the gallery.
I have potd working on the directory it was installed, but just can not get it to call the potd to an external page in the root directory.

I have added the potd.php to the root directory and made changes as I saw them in the forum and still get an error and have no idea on why.
I can only see an error if I use it in a .php page the I created just to see the error.
I know nothing about php but have someone helping me with it. This is the error I get:
Quote
DB Error: Bad SQL Query: SELECT a.image_id, a.cat_id, a.image_name, a.image_active, a.image_thumb_file, a.image_comments, a.image_comments, a.image_downloads, a.image_votes, a.image_rating, a.image_hits FROM gallery_images a, gallery_categories b WHERE a.image_active=1 AND a.cat_id = b.cat_id AND b.auth_viewcat=0 AND b.auth_viewimage=0 ORDER BY DESC LIMIT 1
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 1' at line 4
 
Selected by rates

Now I originally set it up to post the potd by "hits" so I am not sure if this is why I am getting the error.

SLL if you are willing to help, maybe even get this working for me I can pay you for it. You just have to send me a PM on how much and how to pay you. I am limited on how much I can pay, but still let me know and I will return the PM as soon as I can.

424
Mods & Plugins (Releases & Support) / Re: [Mod] Photo Of The Day
« on: August 31, 2005, 10:51:57 AM »
My problem is no text appears over the photo of the day picture thumbnail. Nothing. I did edit /lang/english/main.php but i'm not sure what went wrong. is there any specific place to add the new lines? or can anyone give me the main.php file?

I GOT this problem Too :(

Someone can help-me?

I install the Photo Of The Day.. but... no text appears over the photo of the day picture thumbnail too :(


Not sure what text you are looking to have.
If you only want it to say Photo of the Day then you will need to edit your potd_image.html file and add the text yourself.

Here is what I did:
Code: [Select]
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr><td class="head2" height="20" align="center"><img src="{template_url}/images/spacer.gif" alt="" width="4" height="4" />Photo
   of The Day</td></tr>
  <tr><td class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td></tr>
  <tr><td align="center" class="row1"><br />{thumbnail}<br /><b>{image_name}</b><br /></td></tr>
  <tr><td align="center" class="row1">{lang_potd_type}<br />Image by Hits<br /></td></tr>
  <tr><td class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td></tr>
</table>

As you can see I also edited the botton to say "Image by Hits". You can also change this to say what ever you want.

425
Mods & Plugins (Releases & Support) / Re: [Mod] Photo Of The Day
« on: August 05, 2005, 06:17:02 AM »
Took a while, but we got it working.
It wasn't the functions.php file that was giving the errors, it was the constants.php that was.

So if anyone else has this issue (same error) take a look at that file first.
In the directions we downloaded it shows you can make your POTD either by 'by_votes', 'by_rating', 'by_comments', 'by_downloads', 'by_hits' or 'random' in the constants.php.
What we had to do was remove the "by_" section and just place in what you want it to show for.

Once we did that the error disappeared and all is working great!

Here is a copy of the code that we used to show by votes:
Code: [Select]
// Set "SHOW_POTD_IMAGE" to 1 if you would like to show Photo Of The Day.
// The choices to select Photo Of The Day are: 'by_votes', 'by_rating', 'by_comments', 'by_downloads', 'by_hits' or 'random'
define('SHOW_POTD_IMAGE', 1);
define('POTD_SELECT_MODE', 'votes');

426
Discussion & Troubleshooting / Re: Very simple question
« on: August 03, 2005, 11:36:14 PM »
http://www.4homepages.de/forum/index.php?topic=8946.0

That is what I used to change the number of images shown.

427
Mods & Plugins (Releases & Support) / Re: [Mod] Photo Of The Day
« on: August 03, 2005, 09:43:12 PM »
I get this error
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, 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 i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY DESC LIMIT 1
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 1' at line 5

The person that has been helping me with getting this added (as I don't know PHP, so got help before trying to tackle something like this) told me to say "explain that the sql statement it is talkin about is added w/this mod into the functions.php file" and "what do we do to get it to run properly?"

Any ideas on how to go about getting this to work?

Pages: 1 ... 25 26 27 28 [29]
Post your comments here