Archive

Posts Tagged ‘file size’

Reduce Flash Banner File Size

June 2nd, 2011 Comments off

I have a completed Flash Banner that has to be reduced from the current 70K file size, down to 40K or less in order to run it on our ad networks.

I can provide the Flash source file, I just need a Flash guru to make it smaller.

Quality of image and animation cannot be compromised.

Flash Tonight – Within 12 Hour

December 14th, 2009 Comments off

Need flash created from a photoshop file – see friendshipwalk.org – the header is now gif from photoshop but the file size is huge AND it’s bad quality.

I need proper flash: Must use a pre-loader; perhaps separate preloader for each image if necessary.

Of course the photos used should be optimized before (save as the smallest possible file size), and any parts of the photos that don’t show anyway should be cropped.

Should have smooth transition and hold each image for 1.5 seconds. Should be continuous.

I’m looking for EXCELLENT resolution, while maintaing small / resonable file size for web so that there’s no delay on load time. Will provide photoshop file

NEED BY: 12/15 – 8:20 AM EST (only bid if you can meet deadline: 12 hours)

Categories: Flash Tags: , , , , , ,

Optimize Mysql Queries

August 28th, 2009 Comments off

Iam looking for a MYSQL guru to optimize a couple of slow queries, please don’t bid on this project unless you are a expert in mysql and can dramatically reduce the time these queries take.

Below are the problem queries taken from the slow query log.

# Query_time: 8 Lock_time: 0 Rows_sent: 8 Rows_examined: 378201
SELECT *, COUNT(file_id) AS image_count FROM uploader_userfolders JOIN uploader_userfiles USING(folder_id) WHERE file_isimage=1 AND folder_i$

# Query_time: 16 Lock_time: 3 Rows_sent: 30 Rows_examined: 682764
SELECT pm.pfile_id, pm.mfile_id, pu.*, mf.file_description, mf.file_extension, mf.file_date, mf.file_key, mf.userid, mf.folder_id,uf.*, MAKE$
MAKE_SET( 1 |2, COUNT(mf.file_id), COUNT(pf.file_id) ) AS image_count,
MAKE_SET( 1 |2, pf.file_name, mf.file_name ) AS file_name,
MAKE_SET( 1 |2, pf.file_location, mf.file_location ) AS file_location,
MAKE_SET( 1 |2, pf.file_size, mf.file_size ) AS file_size,
MAKE_SET( 1 |2, pf.file_views, mf.file_views ) AS file_views,
MAKE_SET( 1 |2, pf.file_lastview, mf.file_last_view ) AS file_lastview,
MAKE_SET( 1 |2, pf.file_isimage, mf.file_isimage ) AS file_isimage,
MAKE_SET( 1 |2, uf.folder_name, pu.upload_name ) AS set_name,
ud.username,ud.avatar
FROM uploader_pmfiles AS pm
LEFT JOIN uploader_puploads AS pu ON ( pm.pfile_id = pu.upload_id )
LEFT JOIN uploader_pfiles as pf USE INDEX(upload_id) USING(upload_id)
LEFT JOIN uploader_userfiles AS mf ON ( pm.mfile_id = mf.file_id )
LEFT JOIN uploader_userfolders AS uf ON ( mf.folder_id = uf.folder_id )
LEFT JOIN uploader_users AS ud ON ( mf.userid = ud.userid )
WHERE (pu.upload_ispublic = 1 OR uf.folder_ispublic = 1)
GROUP BY mf.folder_id, pu.upload_id
ORDER BY pm.file_date DESC
LIMIT 0, 30;

Upload Manager

August 25th, 2009 Comments off

After testing many of the available upload managers, Mega File Hosting, Easy Uploader, euploader, xtrafile and others, I have found they all have trouble uploading larger files in a hosted environment where there are limitations on PHP settings and server configurations.

I am interested in developing a script similar to those mentioned but that overcomes the limitations of uploading large, 2gb+ files.

An upload system similar to that used in Upload.ThinFile.Com/Resume where the uploaded file is chopped into smaller files and reassembled on the server is desired. The file must work in shared hosting environments where upload restrictions or PHP limitations are applied.

Intergration with Paypal for automatic billing.

A CSS compliant skinning system with [tokens] for site and user information

An upload progress bar that includes time, time remaining, file size, and amount transferred.

A registered or subscribing user would be able to select files from their computer to upload to the server. They can enter email addresses or select from an Email Group and optionally enter a message. When the upload is complete the email addresses entered or all addresses in the email group would receive an email with a download link and the optional message from the user.

The file would remain on the server for a configurable amount of time based on User Group or User Account Settings

ADMIN SETTINGS

Site Name [sitename]
Logo [logo]
require registration verification by email
show recent uploads on home page [recentuploads]*
show most popular downlaods [populardownloads]*
show featured downloads [featureddownloads]*
Admin email & password
Email users by registration groups

Create User registration Groups
Number of daily file uploads [dailyuploads]
Max File size [maxfilesize]
Max stored disk space [maxdiskspace]
Number of days until file is automatically deleted from server [daystodelete]
Archive files [archivefiles]
Optional password protect upload [pwprotect]
Optional add description to upload [uldescription]
allow to view catalog of uploaded files [viewfiles]
Public view of users uploads (website.com/username) [publicview]*
Allow to make folders (archive files) [allowfolders]*
Number of email groups allowed [numemailgroups]
Max addresses in each email group [maxemailgroups]
Default message to email recipients [defaultmessage]
Subscription
Cost (y/m/d) [fee]
Expiration Date [exp]

File Management
Admin View Uploads
File name [filename]
Download Link [dlink]
User Name [username]
IP Address [ipaddress]
Date uploaded [uploaddate]
Scheduled delete date [deletedate]
lock option (no delete) [locked]
Delete file
Ban file
Ban user

Members Management
Add user
User Name [username]
registered IP Address [regip]
Email [useremail]
User group [usergroup]
Date registered [regdate]
Exp date [exp date]
Delete user
Ban User

Override user group defaults
Number of daily file uploads [dailyuploads]
Max File size [maxfilesize]
Max stored disk space [maxdiskspace]
Number of days until file is automatically deleted [daystodelete]
Archive files [archivefiles]*
allow to view catalog of uploaded files [viewfiles]
Public view of users uploads (website.com/username) [publicview]*
Allow to make folders [allowfolders]*
Number of email groups allowed [numemailgroups]
Max addresses in each email group [maxemailgroups]
Default message to email recipients [defaultmessage]

Billing
View subscriptions by date
View subscriptions by user group
View subscriptions by exp.

Users have access to an account info page
User account info
UserName
IP Address
Email
Total Uploads [totuploads]
Total Downloads [totdownloads]
number of active files [activefiles]*
User Group
Exp Date
Create Email group

View files
Edit description
edit password
delete file
Archive File*
Edit Email Group
Add Email address
Add Name
Add/Edit default message

* These items are not needed for my plan for implementing the script but would provide functionality as a file storage system as well. Depending on cost these may be omitted.

Reduce Flash Banner File Size

August 21st, 2009 Comments off

I have a 104K Flash Banner that needs to be saved as two files, one 40K and the other 30K

I have the source banner .fla file that I will provide.

I need this done within the hour.

Reduce Flash Banner File Size

August 19th, 2009 Comments off

I have a completed Flash Banner that has to be reduced from the current 104K file size, down to 40K or less in order to run it on our ad networks.

I can provide the Flash source file, I just need a Flash guru to make it smaller.

Link code should not be changed.

Upload File Size Increase

August 11th, 2009 Comments off

Hello, I have hosting account at 2ip. I want my upload file size(now at 2MB) to be increased. I know its htaccess / php.ini config file setup with 4 lines code. Want some one who could help me out.

Image Resizing Software

June 23rd, 2009 Comments off

Hi,

I need a simple standalone batch image resizing application done for win xp.
Specs as follow:

-Needs to batch resize all pics (jpeg files) in a specified folder (+all its subfolders) with these specs:

+I Need to be able to specify a min+max size

(example, if i set: min size: 640×480 / max size: 1600×1200:
- all pics that are smaller than 640×480 will be resized bigger to match the min size
- all pics that are found bigger than 1600×1200 will be downsized smaller to match the max size)
- all pics that are in between the min/max size will be left untouched

+Need to be able to specify a min+max file size

(example, if i set: min file size: 50kb / max file size: 200kb:
- all pics that are smaller than 50kb will be saved at a bigger size (higher jpeg quality) to match the min file size
- all pics that are found bigger than 200kb will be downsized/compressed (jpeg quality/compressed) to match the max file size

+Needs to keep the initial image ratio & process portrait/landscape images accordingly.

+When i select a folder to batch-resize, it needs to add all the pics found inside its subfolders.
All the new/processed images need to overwrite the old ones.

Regards,
Aur

Bear