Messages

1

Discussion & Troubleshooting / Re: query problems with MySQL 5.0.x

« on: September 07, 2008, 12:25:10 PM »

After all the changes whit the brackets i still get the error, my server is using mysql 5.0.51 and i'm using 4images 1.7.1 and made so many mods on it that i need to keep the 1.7.1 !!
 the error is:

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 LIMIT 1683, 1
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 i.cat_id = 1 AND c.cat_id = i.cat_id ORDER BY image_downloads DESC LIMIT 0, 32
Unknown column 'i.user_id' in 'on clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/avata5/public_html/includes/db_mysql.php on line 116

2

Discussion & Troubleshooting / Re: SQL ERROR

« on: September 05, 2008, 11:40:14 AM »

I have something similar... did i also ran out of diskspace ? i'm using 1.7.1


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 LIMIT 3083, 1
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 NOT IN (0) ORDER BY i.image_date DESC LIMIT 8
Unknown column 'i.user_id' in 'on clause'

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/avata5/public_html/includes/db_mysql.php on line 116


But info at my server shows this ;
Hosting package default
Shared Ip Address ************
Subdomains  2 / 999
Parked Domains 0 / 2997
Addon Domains 1 / 1
MySQL Databases 5 / 999
Postgresql Databases 0 / 999
Disk Space Usage 1623.11 Megabytes
MySQL Disk Space 4.95 Megabytes
Disk space available 248376.89 Megabytes
Bandwidth (this month) 3799.47 Megabytes
Email Accounts 1 / 999
Email Forwarders 0
Auto-responders 0
Mailing Lists 0 / 1
Email Filters 0
Ftp Accounts 1 / 999

So i don't think i ran out of space, something else is going on...

3

Discussion & Troubleshooting / Re: How to show 800x600 image in details while real to DL is 1280x960

« on: April 04, 2008, 07:45:46 AM »

cool, many thanks

4

Mods & Plugins (Releases & Support) / Re: [Mod] Random image / Zufallsbild

« on: December 18, 2007, 11:11:21 AM »

kk... will look further on the forum to find the topic

5

Mods & Plugins (Releases & Support) / Re: [Mod] Random image / Zufallsbild

« on: December 18, 2007, 10:49:20 AM »

{random_image} was standard with the template... don't think it was a MOD.
There was a topic about it long time ago but can't find it ... was 3 years ago i think.
 

6

Mods & Plugins (Releases & Support) / Re: [Mod] Random image / Zufallsbild

« on: December 17, 2007, 09:32:17 PM »

Thank you for fast reply. I'm using 1.7.1 the original version and there is no such as random.php among the files... maybe in sessions??

7

Mods & Plugins (Releases & Support) / Re: [Mod] Random image / Zufallsbild

« on: December 17, 2007, 07:03:16 PM »

someone an idea how to NOT include a certain category in the random pictures ?

8

Discussion & Troubleshooting / How to show 800x600 image in details while real to DL is 1280x960

« on: May 13, 2007, 02:13:31 PM »

I have a categorie that is destinated for wallpapers that are 1280x960, other categories are small images ... 100x100
Ofcourse i would like to show them in the template as smaller images that fits in the template, for example 400x320... members have to download it to have the full size image ...

How to set this for a particular categorie?

Many thanks

9

Mods & Plugins (Requests & Discussions) / Re: Border help :(

« on: April 17, 2007, 07:23:15 PM »

Or add this to your CSS:

img
{
 border-style: none;
}

10

Bug Fixes & Patches / Re: [1.7 - 1.7.3] Security fix for SQL injection in global.php

« on: March 15, 2007, 11:06:23 PM »

did the update in version 1.7.1 in global.php and it worked out.
while putting the message version 1.7.2 and 1.7.3 only ... and version <1.7.2 to change in search.php...??

Is the update correctly done in this case ?

11

Discussion & Troubleshooting / Being forced to update by my host, how to do it...

« on: March 15, 2007, 06:22:22 PM »

I received this e-mail from lunarpages, my host, and it says that i need to update from 4images 1.7.1 to 1.7.4 urgently due vulnerable script!

Dear Customer,

Our server scanner has detected a vulnerable script on your account
which may require updating.
Please see http://www.lunarforums.com/forum/index.php?topic=39202.0 for
further information, this notice is for information only.

If the script is not updated within the next 48 hours a subsequent scan
will disable it as insecure scripts can lead to compromised accounts.
Thank you in advance for your patience and understanding with regards
to this.
The following are the scripts:

Script: /home/*****/*****l/config.php
Description: Vulnerable 4images gallery (update to 1.7.4 required)


If you require any further information or help with regards to this,
please contact support.
Kind Regards,

Lunarpages Support
_________________________________________________________________

So do i only need to update the config.php ?
I've seen there is no config.php in 1.7.4

What to do now? how to solve and fix this?

would be glad for any advice,

Mathew

12

Discussion & Troubleshooting / 4images hacked three times last year, how to prevent?

« on: January 29, 2007, 07:16:41 PM »

I got hacked again!! installed all security patches.
The problem is that all content from the database has been erased, there is no picture left.
I use 1.7.1
How to prevent hacks? how to protect your database from malicious people?

Help is needed as i'm no expert on database and php.

Many thanks

13

Mods & Plugins (Requests & Discussions) / Re: [Mod] Page Creator / Custom Pages

« on: November 03, 2006, 07:29:21 PM »

I mixed some php things together and made this
It works for me.... (1.7.1) i could add a new page and change the name of the page and clickstream....

Note that i use dynamic page title... just uncomment if not applicable...

Change the name of main template to the name of your new created html page, also in clickstream.
 
Hope it works for you guys

Code: [Select]

<?php
$main_template = 'name of your new html page';

define('GET_CACHES', 1);
define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
include(ROOT_PATH.'includes/page_header.php');

//-----------------------------------------------------
//---Clickstream---------------------------------------
//-----------------------------------------------------
$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'].$lang['name of your new html page']."</span>";

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
  "msg" => $msg,
  "clickstream" => $clickstream,
  "page_title" => $page_title, // MOD: Dynamic page title
  "lang_category" => $lang['category'],
  "lang_added_by" => $lang['added_by'],
  "lang_description" => $lang['description'],
  "lang_keywords" => $lang['keywords'],
  "lang_date" => $lang['date'],
  "lang_hits" => $lang['hits'],
  "lang_downloads" => $lang['downloads'],
  "lang_rating" => $lang['rating'],
  "lang_votes" => $lang['votes'],
  "lang_author" => $lang['author'],
  "lang_comment" => $lang['comment'],
  "lang_prev_image" => $lang['prev_image'],
  "lang_next_image" => $lang['next_image'],
  "lang_file_size" => $lang['file_size']
));

// MOD: Dynamic page title BLOCK BEGIN
//-----------------------------------------------------
//--- Parse Header & Footer ---------------------------
//-----------------------------------------------------
if (isset($main_template) && $main_template) {
  $header = $site_template->parse_template("header");
  $footer = $site_template->parse_template("footer");
  $site_template->register_vars(array(
    "header" => $header,
    "footer" => $footer
  ));
  unset($header);
  unset($footer);
}
// MOD: Dynamic page title BLOCK END
$site_template->print_template($site_template->parse_template($main_template));
include(ROOT_PATH.'includes/page_footer.php');
?>


14

Mods & Plugins (Releases & Support) / Re: [MOD] Sitemap v1.0

« on: October 19, 2006, 08:47:24 PM »

the php of this mod is version 1.7.2
i have 1.7.1
wich means....

doesn't work at all in my site...

does anyone know what i have to change in this php to make it work whit 1.7.1 ???

seems to me that it will absolutly not cooperate whit style.css

http://www.avatarcorner.com/sitemap.php

would like the page to have the layout as the rest of the site but , i just can't make it work.... frustrating...can anybody help?

15

Mods & Plugins (Requests & Discussions) / Re: Can someone help me in Dutch? My English is not that good to explaine.

« on: October 16, 2006, 08:39:57 PM »

Dag deechtemarco... ik ben ook nederlandstalig en ben sinds een tijdje ook bezig met 4images... jammer genoeg ben ik geen php coder.... misschien komt dit nog wel.
Ik wil je vraag wel eens vertalen, zo zou de vraag gesteld kunnen worden...

Does anyone know a Mod or is wanting to create a Mod that adds in phpMySQL in the table "images" a row, for example with the name "in_lightbox". If someone puts a picture in his/her lightbox, the ID of the user should be visible in the row "in_lightbox"

Many thanks.

Hopelijk help krijg je spoedig een antwoord.

Groetjes...
Djith