sanfora
Level 1
Write the reason you're deleting this FAQ
Can you tell me any trick to make picture size smaller like image Mb to upload as i need it only 500 KB how to do that?
After you click "Save As" you can pick the type of image you want to save such as .png .jpeg .jpg etc. Save your image as a .jpg if it is in a different format. Some file types save as larger sizes, I'm not exactly sure why, I just know they do lol. You'll just upload the image and reduce it's size by a percentage or by pixels. I'm not sure about microsoft paint, but I know in photoshop you can reduce by pixels to an exact size. If you can't figure out how to do that exactly you can always use a website to reduce the size.
Do you need the image to be the same size in pixels but a lower MB size?
Or are you just trying to reduce everything to get under 500kb?
Anyway, I'll try to cover both.
To decrease the size of the file, and not the size in pixels, you'll need to lower the resolution. If you have photoshop this is pretty simple. You'll just have to upload the image to photoshop and save it again. But when you save it again click "Save As" and not just "Save" because you'll be making a new image and you don't want to overwrite your original one just in case you screw something up lol :D After you click "Save As" you can pick the type of image you want to save such as .png .jpeg .jpg etc. Save your image as a .jpg if it is in a different format. Some file types save as larger sizes, I'm not exactly sure why, I just know they do lol.
Now if your image is already formatted to the smallest file type and it's still not a small enough file size, you'll need to reduce the image's size in pixels. You can use a variety of software to do this such as photoshop or even microsoft paint :D You'll just upload the image and reduce it's size by a percentage or by pixels. I'm not sure about microsoft paint, but I know in photoshop you can reduce by pixels to an exact size. If you can't figure out how to do that exactly you can always use a website to reduce the size.
Websites to reduce image size:
[url]http://www.shrinkpictures.com/[/url]
[url]http://www.imageoptimizer.net/Pages/Home.aspx[/url]
[url]http://www.reduceimages.com/[/url]
I've used all 3 of these websites in the past when I didn't have photoshop and each has it's own strengths. Test them out and let me know what you think :)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='19007' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='19007' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='60292' | 1 | SELECT * FROM seoclerks.members WHERE USERID='60292' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='55' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='55' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=60292 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=60292 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=19007 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=19007
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19007' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='19007' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=104925 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=104925
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=104916 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=104916
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=105142 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=105142
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=105251 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=105251
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='19007' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='19007' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='19007' AND status='1' AND (question like '%How picture size smaller?%' OR question like '%picture%' OR question like '%size%' OR question like '%smaller?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='19007' AND status='1'
AND (question like '%How picture size smaller?%' OR question like '%picture%' OR question like '%size%' OR question like '%smaller?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='88309' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='88309' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='24427' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='24427' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='29154' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='29154' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='216742' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='216742' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=19007%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=19007%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='377074.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='4987.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
idealmike
M$ Paint doesn't reduce the quality unless the image format is changed. PNG to JPEG or JPEG to GIF etc and it does but it does a really terrible job of it. Honestly M$ Paint really needs an overhaul! It's literally only good for about Windows98 computers not anything of today.
If you're looking for a good free M$ Paint alternative you can try GIMP, Picasa, Photoscape and IrfanView. All are free and make for an excellent alternative and have compression and optimization utilities you can make image file sizes smaller with quickly on the fly. I use PS for that or if I'm in a real rush the online image editor that is [url=http://apps.pixlr.com/editor/]Pixlr Editor[/url]. You can reduce the compression ratio (quality) when saving it with a simple slider you can click on drag to adjust the quality of that image. Simple, quick, effective. :) [b]M$ Paint[/b] doesn't reduce the quality unless the image format is changed. PNG to JPEG or JPEG to GIF etc and it does but it does a really terrible job of it. Honestly M$ Paint really needs an overhaul! It's literally only good for about Windows98 computers not anything of today. If you're looking for a good [b]free M$ Paint alternative[/b] you can try [b]GIMP[/b], [b]Picasa[/b], [b]Photoscape[/b] and [b]IrfanView[/b]. All are free and make for an excellent alternative and have compression and optimization utilities you can make image file sizes smaller with quickly on the fly.
Are you sure you want to delete this post?