The ModMyTM Family of Sites:
ModMyMotoModMyiModMyGphone




 
 
Register or Connect with Facebook

Discuss AppStore Apps | Browse / Search Cydia | MMi Cydia Stats




  Apple Forums & iPhone Forums, Mods, Hacks, News, Themes, Downloads, and more! | ModMyi.com > 3rd Party Apps For iPhone | iPod Touch > 3rd Party Apps Requests
Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-31-2009, 09:49 AM
Green Apple
 
Join Date: Jul 2008
Device + Firmware: iphone 3G 16G 3.0
Operating System: Vista 64
Location: Spain
Posts: 32
Thanks: 4
Thanked 0 Times in 0 Posts
REQ: Mod to mark all mail as read

ok, i don't know about you guys but i'm completely sick of having to mark 1 by 1 all the emails to either delete or mark as read, specially when something happens with the phone that i have to start from scratch and download over 1.5k emails on 4 accounts

is there a mod or app out there that will do it? can it be done?

thanks
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #2  
Old 02-01-2009, 10:59 AM
What's Jailbreak?
 
Join Date: Sep 2008
Device + Firmware: iPhone 2.2
Operating System: Mac OS X 10.5.6
Posts: 8
Thanks: 0
Thanked 4 Times in 2 Posts

Shouldn't be too hard...I'll get on it

Ok, this will require an SSH connection:

1) SSH into your device
2) Run the following commands:
Code:
sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update messages set flags = flags + 1 where flags&1 = 0;"
sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update mailboxes set unread_count = 0;"
3) Reboot your iPhone

This will mark all messages in the iPhone's mailbox as read.

Last edited by jdas; 02-01-2009 at 10:59 AM.. Reason: Automerged Doublepost
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
The Following User Says Thank You to jdas For This Useful Post:
-Blue- (02-02-2009)
  #3  
Old 02-02-2009, 03:00 AM
Green Apple
 
Join Date: Jul 2008
Device + Firmware: iphone 3G 16G 3.0
Operating System: Vista 64
Location: Spain
Posts: 32
Thanks: 4
Thanked 0 Times in 0 Posts

thanks, but how do i run a command?
do i do it from the terminal or from winscp?
thanks again


ok this is what i got.. i did a copy paste from what you wrote..
Code:
/$ sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update messages set flags = flags + 1 where flags&1 = 0;"
SQL error: near "Index": syntax error
/$ sqlite3 /private/var/mobile/Library/Mail/Envelope Index "update mailboxes set unread_count = 0;"
SQL error: near "Index": syntax error
not sure what i did wrong.. at least i figured out the commands part lol

Last edited by -Blue-; 02-02-2009 at 09:53 AM..
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #4  
Old 02-03-2009, 09:09 PM
What's Jailbreak?
 
Join Date: Sep 2008
Device + Firmware: iPhone 2.2
Operating System: Mac OS X 10.5.6
Posts: 8
Thanks: 0
Thanked 4 Times in 2 Posts

Oops...run these instead

Code:
sqlite3 "/private/var/mobile/Library/Mail/Envelope Index" "update messages set flags = flags + 1 where flags&1 = 0;"
sqlite3 "/private/var/mobile/Library/Mail/Envelope Index" "update mailboxes set unread_count = 0;"
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
The Following 3 Users Say Thank You to jdas For This Useful Post:
-Blue- (02-04-2009), iRockish (09-22-2009), jjhack (03-04-2009)
  #5  
Old 02-04-2009, 03:38 AM
Green Apple
 
Join Date: Jul 2008
Device + Firmware: iphone 3G 16G 3.0
Operating System: Vista 64
Location: Spain
Posts: 32
Thanks: 4
Thanked 0 Times in 0 Posts

yay it worked.. thanks
now hopefully someone will turn this into a mini app or something
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #6  
Old 02-04-2009, 12:20 PM
bhz1's Avatar
Moderator
 
Join Date: Sep 2007
Device + Firmware: iPhone 3G, 3G[S]- 3.1.2 JB
Operating System: Windows XP,Vista, OS X 10.5.8
Location: Southeastern Pennsylvania
Posts: 2,406
Thanks: 82
Thanked 324 Times in 251 Posts

I loved iDeleteMail on the old 1.1.x firmwares. Wish there was something similar. While its nice to have the command line workaround, having it as an app is better.
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #7  
Old 02-04-2009, 03:57 PM
Green Apple
 
Join Date: Jul 2008
Device + Firmware: iphone 3G 16G 3.0
Operating System: Vista 64
Location: Spain
Posts: 32
Thanks: 4
Thanked 0 Times in 0 Posts

yeah, a select all or delete all would also be great.. an app that includes or adds to the mail app the options of.. read all, delete all, select all, would be great
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #8  
Old 03-04-2009, 12:12 PM
What's Jailbreak?
 
Join Date: Mar 2009
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts

A note on the code above, you don't have to reboot or respring the phone for the counts to reset. Just kill the "MobileMail" app. The app will automatically reload, and when it does the counts will be reset.

Code:
killall MobileMail
Just be sure you are not in the middle of composing an important email!

I'm looking for ways to automate this process, it's easy to get it into a script. But getting it to an app/icon is a bit harder.

Thanks jdas for the SQL code!!
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #9  
Old 03-18-2009, 11:04 AM
What's Jailbreak?
 
Join Date: Mar 2009
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
New App!

Ok I have the script above made into an application. But there are a couple of caveats.

1. You have to have SSH enabled on your phone. If you disable the SSH service the app will not work.
2. The app will terminate the mail app, so if you are in the middle of composing an email it will be lost.
3. If using exchange, this will not mark the messages read on your exchange server. It will mark the messages read on the phone, but the mark will not sync back to the server.

Download the app here: markall.tar.gz

Just place the tar file in the /Applications folder and extract, then reboot or respring.

When you run the app it will show a black screen then return to the springboard. Wait about 1-2 seconds and the mail unread count will clear.

Hope this app helps, I use it all the time!
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #10  
Old 05-26-2009, 04:15 PM
What's Jailbreak?
 
Join Date: Aug 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

hmm, the markall.app doesnt work for me, I SSH'd into my phone and tried untarring the file but winscp said it wasnt a valid gzip compression or something. So I untarred the file on my desktop and just copied over the markall.app to my applications folder, then set permissions to 775 and rebooted my iphone. The markall.app appears and it launches but the message count doesnt go down

edit: i made sure ssh was enabled, does this only work on POP3 accounts? because I have IMAP e-mail accounts.

edit 2: i followed this guide (http://www.modmyi.com/forums/native-...inscp-ssh.html) and set permissions back to 755 and clicked on recursive, rebooted and it worked! thanks so much!

Last edited by fade; 05-26-2009 at 04:25 PM..
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #11  
Old 09-22-2009, 02:56 PM
Green Apple
 
Join Date: Aug 2009
Posts: 42
Thanks: 0
Thanked 10 Times in 2 Posts

I followed the instructions here and it still does not work for me. When I tap the icon, the screen goes blank for a split second and the mail.app terminates, but when I respring or reboot or anything the count has not gone down. Is there any program for this that really works? I'm on 3.0.1 3GS.
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #12  
Old 09-22-2009, 06:54 PM
ddonuts4's Avatar
iPhoneaholic
 
Join Date: Dec 2008
Device + Firmware: Ipod touch 2g latest version
Operating System: xp home edition
Posts: 315
Thanks: 10
Thanked 10 Times in 10 Posts

Jjhack, for a new member u know a ton. Thanks or the useful tips.
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #13  
Old 09-30-2009, 03:31 PM
What's Jailbreak?
 
Join Date: Sep 2009
Device + Firmware: iPhone 3g
Operating System: MacBook Pro
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Link to markall.app

Anyone got a different link to the markall.app??.....after extracting the 4kb linked file all I get is a blank folder entitled markall. Any ideas, really sick of seeing a hundreds of "unread emails" that I've already read on my comp.

Thanks
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #14  
Old 10-17-2009, 03:34 PM
What's Jailbreak?
 
Join Date: Oct 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Update for 3.1.2?

The markall.app is a great idea. However, having trouble making it work with 3.1.2. The app executes, but doesn't mark mail as read. In fact, it has the opposite effect. If I manually mark a mail as read, then run the markall.app, it actually sets it back to unread. Anyone have any suggestions? Is there something different in 3.1.2 that might cause this?
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
  #15  
Old 11-22-2009, 12:25 PM
What's Jailbreak?
 
Join Date: Nov 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

Hi,

first of all, thanks a lot for this great small app.

But maybe someone can answer me to questions:

1. After kill MobileMail how can i restart it? Because i think the next step is always to click on the button. But it should be automated.

2. Can you tell me a method to delete all mails in MobileMail?

Thanks a lot for the help.

Cu kami23
Digg StumbleUpon Delicious Reddit Newsvine Google Yahoo Thanks Reply With Quote
Reply

  Apple Forums & iPhone Forums, Mods, Hacks, News, Themes, Downloads, and more! | ModMyi.com > 3rd Party Apps For iPhone | iPod Touch > 3rd Party Apps Requests

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



Go to Top
ModMyI

All times are GMT -6. The time now is 04:33 AM. Powered by vBulletin® Version 3.8.4
If you need Dedicated Server Hosting, you should check out SingleHop. | Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.0 Copyright © 2007-09 by ModMy, LLC. All rights reserved.

iPhone News / iPhone Forums / Apple News / Apple Forums / RSS / Contact Us / / Top