• [Mod] Mini-Top 5 0 5 1
Currently:  

Author Topic: [Mod] Mini-Top  (Read 234958 times)

0 Members and 1 Guest are viewing this topic.

Offline idijotaz

  • Jr. Member
  • **
  • Posts: 79
    • View Profile
    • CLON Entertainment
Re: [Mod] Mini-Top
« Reply #75 on: June 21, 2006, 09:20:24 AM »
what you mean center? <center> </center> ?  :roll:

Offline riomolin

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [Mod] Mini-Top
« Reply #76 on: June 21, 2006, 09:44:19 AM »
Regards
I centered the cells, now I need center the thumbs in the cells.
I´m modified thumbnail_bit.html and works in the New images table but not in Mas Popular table
Thanks in avance
Siempre aprendiendo

Offline riomolin

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [Mod] Mini-Top
« Reply #77 on: June 27, 2006, 12:48:38 AM »
what you mean center? <center> </center> ?  :roll:

Solved
I put <center> </center> ?
Siempre aprendiendo

Offline riomolin

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [Mod] Mini-Top
« Reply #78 on: June 29, 2006, 10:47:46 AM »
Regards

Now I have three questions:

- I changed the minitop_bit.html vs minitop_bit_alt.html,
but the "image rating" and the "image votes" don´t have title:

Comentarios: 0
                   8.00
                 : 1
Impactos: 179
Descargas: 0

Where I can change?

- I have six cells,
Where I change the background color, or what´s the code?

- What I can put in the sixth cell?, card most sended?, what´s the code?
 
http://www.usuarios.lycos.es/riomolin/4images/

Thanks in avance
« Last Edit: June 29, 2006, 05:57:21 PM by riomolin »
Siempre aprendiendo

Offline e-trader_2002

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: [Mod] Mini-Top
« Reply #79 on: July 16, 2006, 06:15:44 PM »
Hi riomolin,

I just solved the same problem you have (problem #1).

In Minitop.php find the bold blue lines and insert the red lines inbetween. This should display the missing titles.

[qcode] $site_template->register_vars("lang_mini_top_mode", $lang['mini_top_'.$selection[$cnt]]);
$site_template->register_vars(array(
  "lang_hits" => $lang['hits'],
  "lang_downloads" => $lang['downloads'],
  "lang_rating" => $lang['rating'],
  "lang_votes" => $lang['votes'],
 ));

$mini_top_images .= $site_template->parse_template("mini_top_bit_alt");
[/qcode]

I hope this will help you.

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


Offline riomolin

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [Mod] Mini-Top
« Reply #80 on: July 17, 2006, 11:26:00 AM »
Thanks, e-trader_2002,
Solved
Siempre aprendiendo

Offline mstgokcen

  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: [Mod] Mini-Top
« Reply #81 on: July 19, 2006, 09:57:49 PM »
why only I got an error...what is wrong with me?


I get this eroor in index page

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 c.cat_id = i.cat_id AND i.cat_id IN (0, 2, 3, 4, 5, 6, 7, 8, 9, 1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27) ORDER BY i.image_rating DESC, i.image_votes DESC
Unknown column 'i.user_id' in 'on clause'

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 c.cat_id = i.cat_id AND i.cat_id IN (0, 2, 3, 4, 5, 6, 7, 8, 9, 1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27) ORDER BY i.image_votes DESC, i.image_rating DESC
Unknown column 'i.user_id' in 'on clause'

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 c.cat_id = i.cat_id AND i.cat_id IN (0, 2, 3, 4, 5, 6, 7, 8, 9, 1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27) ORDER BY i.image_hits DESC, i.image_name ASC
Unknown column 'i.user_id' in 'on clause'

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 c.cat_id = i.cat_id AND i.cat_id IN (0, 2, 3, 4, 5, 6, 7, 8, 9, 1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27) ORDER BY i.image_comments DESC, i.image_name ASC
Unknown column 'i.user_id' in 'on clause'


Offline e-trader_2002

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: [Mod] Mini-Top
« Reply #82 on: July 21, 2006, 10:35:34 PM »
Hi mstgokcen,

follow the link below for an explanation why this error occurs. If you are using 4Images with MySQL 5.0.12 or higher it should solve your problem.

http://www.4homepages.de/forum/index.php?&topic=3102.msg71831#msg71831

So this is what you have to do:

In top.php find the 4 SQL-queries producing the error-messages in your post and change them as described in the link. You will have to change in each query

[qcode]... FROM ".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c LEFT JOIN ...[/qcode]

to

[qcode]... FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c) LEFT JOIN ...[/qcode]

I hope this will do the trick.

e-trader_2002

PS:
This error may occur in other PHP-modules of 4Images as well. Identify the PHP-module by looking at the URL-entryfield of your browser:
Quote
http://www.domain.xy/4images/index.php?sessionid=...

Always find the related SQL-query (best done by searching for the string LEFT JOIN) in that module and do the modification described above.
« Last Edit: July 22, 2006, 12:12:27 AM by e-trader_2002 »
A hobby is a great way to spent time you actually don't have! :wink:


Offline mstgokcen

  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: [Mod] Mini-Top
« Reply #83 on: July 22, 2006, 10:48:52 AM »
tnx for your help e-trader but it didnt work

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 e-trader_2002

  • Jr. Member
  • **
  • Posts: 53
    • View Profile
Re: [Mod] Mini-Top
« Reply #84 on: July 22, 2006, 11:46:30 AM »
Hi mstgokcen,

I'm afraid you changed the wrong SQL-Query. As I said in my post from yesterday evening, you have to change only Queries containing LEFT JOIN from

[qcode]... FROM ... LEFT JOIN ...[/qcode]

to

[qcode]... FROM (...) LEFT JOIN ...[/qcode].

You should find such a query 4 times in top.php, 1 time in minitop.php and 1 time in index.php.

After modification the query in minitop.php should look exactly like quoted in IVANs post just above.

If the errormessage from index.php persists, look into that module too and also find and modify the SQL-Query containing LEFT JOIN.

This really should solve the problem. Wish you success.

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


Offline mstgokcen

  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: [Mod] Mini-Top
« Reply #85 on: July 22, 2006, 11:56:48 AM »
tnx, my mistake I understood that i will change the top.php but ofcourse we are talking about minitop.php

:)

its done...

Offline nacho-lopez

  • Newbie
  • *
  • Posts: 48
    • View Profile
    • Photoshop Designs
Re: [Mod] Mini-Top
« Reply #86 on: August 28, 2006, 04:33:54 PM »
I have just added this mod to my gallery in detais.html instead of the home.html
I have a problem. I dont know how to center each image in the center of each cell of table. What should I change in the code so this would be posible?
You can see my problem in this picture:

Thanks for your help and best regards from Spain  :D

Offline ch€ri{Bi}²

  • Sr. Member
  • ****
  • Posts: 315
  • A PRoBLeM wIthOUt SoLuTioN Is NoT rEAllY a PRoBLeM
    • View Profile
    • Pat's Gallery
Re: [Mod] Mini-Top
« Reply #87 on: August 29, 2006, 02:32:32 AM »
how to center each image in the center of each cell of table. What should I change in the code so this would be posible?

 :arrow: find this code in mini_top.php:
Quote
$mini_top_images .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n";
and replace it by this one :
Quote
$mini_top_images .= "<td width=\"".$imgtable_width."\" valign=\"middle\">\n";
ch€ri{Bi}²


Offline nacho-lopez

  • Newbie
  • *
  • Posts: 48
    • View Profile
    • Photoshop Designs
Re: [Mod] Mini-Top
« Reply #88 on: August 29, 2006, 07:43:40 AM »
Thanks a lot ch€ri{Bi}²   :D
how to center each image in the center of each cell of table. What should I change in the code so this would be posible?

 :arrow: find this code in mini_top.php:
Quote
$mini_top_images .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n";
and replace it by this one :
Quote
$mini_top_images .= "<td width=\"".$imgtable_width."\" valign=\"middle\">\n";

Offline riomolin

  • Jr. Member
  • **
  • Posts: 84
    • View Profile
Re: [Mod] Mini-Top
« Reply #89 on: August 29, 2006, 10:53:52 AM »
Hello,
sorry for my english,
in the mini-top MOD I have six cells,
five with the nacho-lopez format, and the 6th empty
what I can put into the 6th cell, perhaps e-card most downloaded?
How, what´s the code and where I can put it?
How I can change the cells color, the blue for the dark grey

Nacho-lopez, si sabes puedes contestarme en español

http://www.usuarios.lycos.es/riomolin/4images

Regards
Siempre aprendiendo