Posts by ChapterThemes

621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

@SurStudio @dtbaker thx for the effort, but they don’t keep the ID together..

I’m starting to ask myself if this is even possible with a single query.

621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

Do you perhaps mean income tax?

That’s something you do have to pay – for all income you receive, whether it contains vat or not.

621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

How come (in your wanted results)

1. 2nd CC is 3500, Whereas in table it’s 3000

2. 1st AA is 3000, Whereas in table it’s 4000

Argh darn, sorry forget to change in table.

Should be:

Have the following table:

= ID = PRICE =
==============
- AA - 30000 -
- AA - 50000 -
- CC - 20000 -
- BB - 10000 -
- CC - 35000 -

Wanted results:

= ID = PRICE = COUNT =
======================
- BB - 10000 - 1

- CC - 20000 - 2
- CC - 35000 - 2

- AA - 30000 - 2
- AA - 50000 - 2
621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

Unless you live in australia, you do not have to ‘pay’ vat.

You don’t receive vat – so you don’t have to ‘hand it over’.

People say PAY vat, but actualy you receive VAT from your clients in order for you to hand over to the taxgoverment. So plain and simple: you don’t receive – you don’t ‘hand over’.

621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

Already posted this somewhere else, but figured it fits better over here

Have the following table:

= ID = PRICE =
==============
- AA - 40000 -
- AA - 50000 -
- CC - 20000 -
- BB - 10000 -
- CC - 30000 -

I want to:

Group by ID, BUT show all – order by PRICE, also inside the group AND count group results.

Wanted results:

= ID = PRICE = COUNT =
======================
- BB - 10000 - 1

- CC - 20000 - 2
- CC - 35000 - 2

- AA - 30000 - 2
- AA - 50000 - 2

So even though the second CC price is higher than the first AA – it needs to be under the first CC because the first CC is lower that the first AA etc.

Anyone?

621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

Having a bit of trouble getting this right.

Have the following table:

= ID = PRICE =
==============
- AA - 40000 -
- AA - 50000 -
- CC - 20000 -
- BB - 10000 -
- CC - 30000 -

I want to:

Group by ID, BUT show all – order by PRICE, also inside the group AND count group results.

Wanted results:

= ID = PRICE = COUNT =
======================
- BB - 10000 - 1

- CC - 20000 - 2
- CC - 35000 - 2

- AA - 30000 - 2
- AA - 50000 - 2

So even though the second CC price is higher than the first AA – it needs to be under the first CC because the first CC is lower that the first AA etc.

Anyone?

621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

Can’t remember seeing a theme like such – but the idea is great though.

But – maybe you can find a normal blog and put it inside the title?

A lot of blog themes have big sized titles and the date is inside a small info text – so if you create a blog post title like: “Day 10 – Week 2: another thing” maybe you have sort of what you need..

621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

So i guess we can conlude that most of us find all the animations an overkill – and some even the (mis)use of big sliders in general.

@parallelus has a good point. The cool factor attracts buyers, but a lot of ‘cool factors’ are there just to dazzle without considering if it’s beneficial for the content.

As for sliders in general – i think they still could make a site “lipsticked” sexy like Net-Labs mentioned. Problem with most sliders is that they’re mainly just a big block sitting on top of the site. Maybe when a slider is more integrated and related to surrounding content it does a bit more than only visual appearance.

Guess it’s up to us to make things better ey :)

621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

Got an SSD and Dropbox, so I think I’m pretty much okay :)

i wouldn’t use an SSD for long term storage. also a online service is nice – but best is always to also actually have it at home or office.

621 posts
  • Has been part of the Envato Community for over 3 years
  • Has sold $10,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Sells items exclusively on Envato Market
ChapterThemes says

If you run a business ( like me ) having your data safe is the first priority. Besides all the work done in all those years, there’s also things like administration, bills, invoices etc. you can’t lose them ( also have printed versions ofcourse ).

I work from a RAID system that always instantly saves everything to 2 harddrives. So if one breaks – i always have the second one with the latest data. Besides that i run backups to 2 other drives every day – that i swap each week. The backupdrive not in use should be in a safe or off-site ( in case a fire or something breaks out ).

So, i’m pretty sure i’m safe – unless….. a meteor hits my town or something :O

by
by
by
by
by
by