[Mod] User upload limits

[amber438]

Hi..I wanted to get this mod but the link is dead..has it been taken down..?  Does it work??  The mod that is..

Thanks,
Amber

[SLL]

Some DNS problems at my host  
Just added alternative d/l link in the first message.

[x_789]

Ok the files that have to be modified are they specific to each persons server?  Or could I get a copy of someones files that have been modifed whos site is working and use them to test with that way I can figure out where my error is?  X

[SLL]

files are the same, if no other mod's used, but this wount help you much, since you have to modify your database also

[x_789]

Ok what does the db modifications?  YouR install file?  I ran that like I said on the previous page and it  said it was sucessful.  The only thing I did not do was what I qouted on the bottom of the last page.  Also I have made no other mods to my site other than I use a diffrent template...X

[x_789]

Ok well Since I knew nothing about php before this I was editing the files with wordpad.   I decided to look for a php editor and sure enough I found one.  So I uploaded my db backup and went through the whole thing again modifing all the files with the php editor..  So it looks like it kept the correct syntax.  Now it is working but I find that until I review the photos users can upload as many as they want.  As soon as I validate 5 photos then the next time they try to update they get the error that they are at limit.  Is there a  way to change this???  X

[SLL]

well... you can query 4images_images_temp table and check the number of images there against user id, but from my point of view it's not logical - nobody knows if uploaded images will be validated or deleted, so i'd prefer to leave this mod as it is, you can play with code yourself, if you want

[Bomba]

is it possible to make the upload limit by time?
in a way that users can only upload a pic per day

[SLL]

is it possible to make the upload limit by time?
in a way that users can only upload a pic per day

yes, you can do this. just replace the original mod function to this one:

Code: [Select]

function check_picture_limit($user_id) {
global $site_db, $site_template;

$sql = "SELECT user_limit FROM ".USERS_TABLE." WHERE user_id = $user_id";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$upload_limit = ($row['user_limit']);
$site_template->register_vars("upload_limit", $upload_limit);

$limit_cutoff = time() - 60 * 60 * 24;

$sql = "SELECT COUNT(*) AS num_rows_all
FROM ".IMAGES_TABLE."
WHERE image_active = 1 AND user_id=$user_id AND image_date > $limit_cutoff";
$row = $site_db->query_firstrow($sql);
$images_per_user = $row['num_rows_all'];

$site_template->register_vars("images_per_user", $images_per_user);

if($images_per_user >= $upload_limit) {
return false;
} else {
return true;
}
}


[IngoT]

Is this change for a photo in 24 hours or per day (to 24 o'clock) The latter would be better.

CU Ingo.

[SLL]

it's an upload limit for the last 24 hours. the number of pics to upload, you set in the config, is the maximum per day it this case.

[Bomba]

awesome!

just one thing i have to put that code in wich file? the "install_user_limits.php" ? if so can u tell me what code should i look for to change.

sorry i'm really bad in this kind of things and im afraid of destroy everything.
thanks

[V@no]

awesome!

just one thing i have to put that code in wich file? the "install_user_limits.php" ? if so can u tell me what code should i look for to change.

sorry i'm really bad in this kind of things and im afraid of destroy everything.
thanks

this changes goes to member.php

P.S. install_user_limits.php does database installation.

[Bomba]

so i put this code:

Code: [Select]

function check_picture_limit($user_id) {
   global $site_db, $site_template;

$sql = "SELECT user_limit FROM ".USERS_TABLE." WHERE user_id = $user_id";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$upload_limit = ($row['user_limit']);
$site_template->register_vars("upload_limit", $upload_limit);

$limit_cutoff = time() - 60 * 60 * 24;

$sql = "SELECT COUNT(*) AS num_rows_all
FROM ".IMAGES_TABLE."
WHERE image_active = 1 AND user_id=$user_id AND image_date > $limit_cutoff";
$row = $site_db->query_firstrow($sql);
$images_per_user = $row['num_rows_all'];

$site_template->register_vars("images_per_user", $images_per_user);

if($images_per_user >= $upload_limit) {
return false;
} else {
return true;
   }
}


in members.php ?
after what?

[V@no]

yes, you can do this. just replace the original mod function to this one:

Code: [Select]

function check_picture_limit($user_id) {
global $site_db, $site_template;

$sql = "SELECT user_limit FROM ".USERS_TABLE." WHERE user_id = $user_id";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$upload_limit = ($row['user_limit']);
$site_template->register_vars("upload_limit", $upload_limit);

$limit_cutoff = time() - 60 * 60 * 24;

$sql = "SELECT COUNT(*) AS num_rows_all
FROM ".IMAGES_TABLE."
WHERE image_active = 1 AND user_id=$user_id AND image_date > $limit_cutoff";
$row = $site_db->query_firstrow($sql);
$images_per_user = $row['num_rows_all'];

$site_template->register_vars("images_per_user", $images_per_user);

if($images_per_user >= $upload_limit) {
return false;
} else {
return true;
}
}


read instructions carefully