Topics

46

Mods & Plugins (Requests & Discussions) / Rename index.php to home.php

« on: October 07, 2009, 07:29:09 AM »

Hello,

Because I want to install another scripts who has also index.php, I need to rename the index.php of 4images to home.php or something else. How can I do that? Few years I used a mod of do that for the index.php of PHPbb. So I believe it is possible, but how.

I am sure that a lot of 4images users will appreciate your help and or tips.

Any reaction will be appreciated.
Many thanks in advance,

Cruxy

47

Mods & Plugins (Requests & Discussions) / FLV player on the homepage to show video's

« on: July 21, 2009, 12:40:02 AM »

Hello,

On my homepage I want to use a FLV player to play vidoe's randomly from some categories.

I know that it is possible, but I do not know how to code it.

Any help will be very appreciated.

Many thanks in advance,

Cruxy

48

Mods & Plugins (Requests & Discussions) / Stast: Counting the FLV, WMV, JPG files

« on: July 19, 2009, 12:46:14 AM »

Hello,

I want to count the quantity of the FLV, WMV, JPG.. file on my galery. For example:

FLV files: 100
WMV files: 200
JPG files: 300
PNG files: 400

Can someone help please?

Any support will be very appreciated.

Cruxy

49

Mods & Plugins (Requests & Discussions) / Admin can vote the same image many times as he want

« on: March 10, 2009, 12:47:45 AM »

Hello,

How can I change the code to make sure that Admin can vote the same image many times as he want?

Thank you in advance,
Cruxy

50

Chit Chat / Query for returning info from 2 columns

« on: January 22, 2009, 06:12:22 PM »

Hi,

I have some problem with a query.

I added a new table to the 4 images database (TEAMS_TABLE).

I have this information in my table:

Team home    Team away   Info home    Info away
Barcelona       Valencia               W               V
Sevilla           Barcelona              G                G
Barcelona       Madrid                  V                W


I need a query to return the info home & away of the club Barcelona.

Something like that:

Barcelona: W, G, V

I could get only the info home of Barcelona and also only the info away.

But the problem is how can I get both info home & away of the club Barcelona in one table or line.

I appreciate any help.

Many thanks in advance,
Cruxy

51

Mods & Plugins (Requests & Discussions) / LEFT JOIN in the query did not work properly

« on: January 13, 2009, 05:29:23 PM »

Hello,

I really need some support to correct this query for me.

I added 2 tables to the 4images database.

TEAMS (teams_id, teams_name,....)
 &
RESULTS (results_id, results_home, results_out, .....)

In my additional page results.php I have this information:

Barcelona vs Dynamo Moscow 5 - 5

The problem is that I cannot get the value of the teams_id (When you click on the name the team)


I am using this query, but I still not have the teams_id:

Code: [Select]

$sql = "SELECT r.results_id, r.results_home, r.results_out, r.results_goals_home, r.results_goals_out, r.results_done, t.teams_id, t.teams_name
        FROM (".TEAMS_TABLE." t)
LEFT JOIN ".RESULTS_TABLE." r ON r.results_home = t.teams_name
   
GROUP BY r.results_id
ORDER BY r.results_id ASC";
       
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);

I really tries everything, but....

I believe there is something wrong with the LEFT JOIN.

52

Mods & Plugins (Requests & Discussions) / [Solved] Using variable in query returns wrong results

« on: January 01, 2009, 02:19:09 PM »

Hi all,

First of all Happy new year for everyone on this forum.

I use the variable $honor_nog in the query, but it returns worng results. I get all the images instead of few.

Check my query please:

Code: [Select]

######################################   
   $honor_date = $image_row['image_honor_date']; 
   $honor_nog =  $honor_date -(time() - ($config['honor']*60 * 60 * 24));
   $honor_nog = number_format ($honor_nog /60/60/24, 2);
######################################


##################################################################################################################BEGIN

$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_speler, i.image_youtube, i.image_honor, 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.image_postcards".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email")."
        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 i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
       
       
        AND '" . $honor_nog . "' > 18
       
       
GROUP BY i.image_name
ORDER BY i.image_honor_date DESC
";
That means that I want all the images where $honor_nog > 18 (above 18 days).

Can someone correct this query for me please?

Many thanks in advance,

53

Mods & Plugins (Requests & Discussions) / [SOLVED] All the images which the lenght of the Youtube Id different dan 11

« on: December 31, 2008, 12:28:21 AM »

Hi,

I need help for this query.

I need all the images which the lenght of the Youtube Id different dan 11.

I used this query, but I get all the images.

Code: [Select]

$youtubeLEN = strlen($image_row['image_youtube']);

$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_speler, i.image_youtube, 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.image_postcards".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email")."
        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 $youtubeLEN != '11' AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
GROUP BY i.image_name
ORDER BY i.image_date DESC

LIMIT 10
";
Can someone correct this query for me please?

Thanks in advanace,

54

Discussion & Troubleshooting / The gallery shows not the 0 (Zero).

« on: December 28, 2008, 01:42:49 AM »

Hi,

I have a small problem.

I added an additional field to my gallery with this code:

Code: [Select]

alter table 4images_images add column image_hot_hits int (10) DEFAULT '0' NOT NULL
On the details page shows the value {image_hot_hits} only when it has a value of 1 or more.

That means the gallery shows never the 0 (Zero).

I have to show that on the gallery.

What did I do wrong?

55

Mods & Plugins (Requests & Discussions) / Batch add Images mod

« on: December 26, 2008, 10:38:33 PM »

Hi,

Have I already said that the MOD Batch Copy/Move/Edit Images v3.7.3 the best MOD ever made for 4images?

I am using it every day. He made my life easier. Thanks V@no.

I am thinking about a Batch add Images mod with the quick edit.

That means:
1- First you choose how many images you want to upload and also which veld you want to get in the Quick Edit.
2- Then with one click on the button you upload all the images.


This mod will be also one of the best MODs ever made for 4images.

What do you think about my idea V@no?

56

Mods & Plugins (Requests & Discussions) / Submit info to a new 4images table from anywhere

« on: December 24, 2008, 11:36:40 AM »

Hi all,

I think that my idea for this mod will be very usefull to communicate with your users.

I want that my users can submit infomartion from any page on the gallery instead of sending mails. For example:
The user can submit this sentence:

I want on the gallery more pictures of Ronaldinho.

Something which works like comments, but from anywhere on the gallery.

(To show the results on the gallery is the easy part)


I already created a new table: submit and a new column submit_player_name.

Can someone code this usefull mod please?

PS: If there is on this forum a similar mod, I will be glad to tweak it.


Many thanks in advance,

Cruxy

57

Mods & Plugins (Requests & Discussions) / Users lightbox images in his profile page like on YouTube

« on: December 22, 2008, 06:06:17 PM »

Hi,

I find the profile page of 4images boring. I was thinking about showing the favorite pictures in his profile page like on YouTube.

There is a mod to show user images in his profile:
http://www.4homepages.de/forum/index.php?topic=15390.0

And Vano has also this mod to show a user favorite only to admin:
http://www.4homepages.de/forum/index.php?topic=4107.0


Can anyone code that? Is het possible?

58

Mods & Plugins (Requests & Discussions) / Change the time format from hh:mm:ss to mm:ss

« on: December 22, 2008, 05:34:03 PM »

Hi,

How can I change the time format of a 4images fiels from hh:mm:ss to mm:ss.

I can do it with the explode, but I want an easier way.

Any tip please? Is explde the only way to reach what I want?

Many thanks in advance,

59

Discussion & Troubleshooting / Display only the images with the identique image name (image_name)

« on: December 21, 2008, 05:38:54 PM »

Hi all,

I have a little request. I know it is simple, but my PHP knowledge did not allowed me to do that.

I want to display only the images with the duplicate image name (image_name) on an additional page.

Can someone improve this query for me please?

Code: [Select]

$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, i.image_postcards".$additional_sql.", c.cat_name".get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email")."
        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 i.image_name = ******** AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
GROUP BY i.image_name ASC
LIMIT 500

I appreciate the time you use to help me.

Thanks in advance,

60

Mods & Plugins (Requests & Discussions) / Looking for videos which the duration is more than *** minutes

« on: December 21, 2008, 01:17:47 PM »

Hi all,

I believe I have a very nice mod request for 4images:

On my video site I have an additional field with the video duration: {image_duration}.

How can the users look for videos (Search) which the duration is more than 5 minutes? (That was an example).

Is that possible?
Is there any other mod on this forum to tweak?

Thanks in advance,