Posts by pixelcave

@dnp_theme, Noted!

@hullibulli, thank you, I’m glad you like it

@wegrass, thank you, I’ll send you over a link when it’s ready!

@duotive, okzzz!!

@purethemes, yeap, it had crashes, especially when opening a network connection! (+ NvatoMe can run on 2.1 and up! I will check if I can make it run on 1.6)

@3alisha, thank you, I will also send you over a download link through your profile page when it’s ready!

@KingDog, will do, thanks for the reminder!

@DoubleX, and I was wondering what I forgot to mention! I would like to create a widget and add it with a future update!

cooledition said
What if you make the interface similar to envato marketplaces?, i mean similar menus, buttons and colors, things like those

I suppose I could create styles with similar colors to marketplaces in the future and let the user choose the one he likes

Thank you all guys!!

@quickandeasy, @Studio9Resources, @AddictedToLucid I hope it hits other platforms in the future!

@purethemes, I was using Woodpecker too (nice app) and then after a while, I decided to create my own! I will send you over a link to the app when I implement the other features! Also, your suggestion was noted, sales grouping by day will be practical!

@Gembell, I hope it has many downloads (the app will be free)

@cooledition, noted, it will be fun (just like iEnvato for desktop)!

@dnp_theme, do you mean to enable users to choose between different styles, backgrounds or font sizes or be able to create their own?

Hello guys!

I’m planning on releasing soon an Android App for Marketplaces’ Authors, called NvatoMe. The app will ask for username and api key, and will retrieve author’s photo, name, commission, balance and 50 recents sales (item name, sale’s date, time and amount).

• App Interface
• Getting data through json and displaying it
• Saving essential data locally (all except recent sales) for displaying it if internet connection isn’t active
• Customized sale’s date to be displayed with phone’s date format (selected by user)
• Created loading screen when updating data

• Forms for entering username & api key
• Saving recent sales data locally
• Add refresh option to menu
• App Icon
• Test the App (I will need 5 to 10 people, so if you like, let me know)

• Sales notification
• Option for checking frequency

This is how it looks right now with some dummy content: http://img822.imageshack.us/img822/8509/nvatome.png

I will be happy to know what you think and get some valueable feedback!

Thank you

John

It’s fine, the extended license can be selected from the drop down menu shown if you rollover the regular license! Good luck with sales and by the way, nice template

And to make it a few miliseconds faster you can use:

SELECT user_id, Count(1)
FROM Table_Name
GROUP BY user_id
order by 2 Desc

Thanks Sitebase for the tip!!

SELECT user_id, Count(user_id)
FROM Table_Name
GROUP BY user_id
order by 2 Desc

More Than Welcome if you need further help feel free to contact me on Laith99@yahoo.com

Cheers Laith

Laith thank you very much for your help! It works great and you just save me a lot of time!! I had completely forgot ‘GROUP BY’. Never a day passed without learning!!

Hello everyone!! I’m in need of some help for a MySQL query! If someone could help me I would be grateful!

Let’s say I have a table which holds comments with the following columns:

id
user_id (the user’s id that wrote the comment)
comment
date

There are a lot of submissions in the table with comments that users have written. The same user may have written many comments.

I would like to create a top 5 users list for the top comment posters. Is there a way to do it with one query?

Thanks in advance!

If you want the footer to expand, you must put it out of the container because it has a fixed width (960px).