Thanks to an enthusiastic supporter of osCommerce, who shared this code with me, we now have an iBar Email Dashboard module that will show you the number of unread Gmail emails pending in your service or help desk email account.
I don't actually have the script but have a look at this post and the one by Gary that follows it in the iBar development thread. If your interested google imap_open and it should give a good idea about coding it. Frank will likely share his code too, if you ask him nicely.
@mattjt83 I really like the concept of dashboards and I think this has a ton of potential...Frank has a script to read from Gmail and I can think of another 4 or 5 modules I want to add so it should be a good way to keep an eye on what's important to shop owners. Glad you like it so far.
Now that I have achieved my new products goal I'm going to spend a little time sending out requests for reviews. I'm using Gary's Key System which is all set up to go and I have a couple of iBar review modules on the Dashboard. I can't run a cronjob on the server where my site is hosted so it's a manual process but one that shouldn't take up too much time -- it just needs some focus.
I also want to spend some time setting up "specials" on a regular basis so there will be an iBar module for that in the not to distant future.
Personally I think the only reason this is a question is because of the number of releases and various versions of osC that exist....if we had an up to date official release, the user base would be using relatively common code and coders would, by demand, end up updating their code to work with it. The support on the forums here would be much simpler too.
As Jim points out having coders revise or even keep up with changes between releases isn't likely to happen for the reasons he mentions.
The help desk emails module connects to our email account with imap_open and checks for unread mails, nothing else (just a heads up to go to the email program and answer some emails lol).
Very interesting Frank and like Gary I didn't know that was even possible. I think this would make for a awesome iBar module....would you be willing to share the code? I know you have it hard coded currently but maybe we could turn it into an iBar module. A little TODO LIST module would be pretty cool too but I'll leave that for another day.
@bruyndoncx @piernas Wanted to say thanks for taking the time to develop those sql queries. I think I'll just query the orders table but the queries you produced will be very useful as I add a separate page to pull up the details of the orders requiring attention. Time well spent.