I want a single page script that shows statistics based on this single table. The first column is only an auto-increment number, the next, **stat_pub_id**, is an unique ID for the page that is shown. **stat_time** is Unix timestamp (from php´s time() command). **Stat_ip** is the users ip address, and **stat_ref** is refereer info, if available.
![][1]
![][2]
Requirements:
**Global Requirements:
**- Use smarty templates for this single page.
- Name php file [login to view URL], template adm_stat.tpl.
- Width can only be 600pixels in total.
- stat_pub_id will be replaced by my with the page title.
**
1.** I want to have a display like shown above (I have whiped out the info I do not need). It shows pageviews (all pages) and visits (count only uniqe ip´s) month by month. Also, it displays a graph, produced by GD (or in another way) with one bar for pageviews and one bar for visits.
**2.** Clicking on one of the months gives both pageviews and visits, but this time it lists page names (**stat_pub_id**), instead of month name, so that I can see what page is most popular for the month I clicked on. That list should order all pages by number of page views (most viewed page on top).
If you want to impress me, you can also create graphical bars also for point number 2. But the first graphical stats bar is mandatory.
If you are interested, you can see where your stat program should be (it will replace the links collection part in this screen, that is why it must be about 600pixels wide max):
![][3]
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Win, Linux, php4 and php5, mysql4.23 and mysql5.
If you can do withouth GD, and instead use small images (and stretch them) to the bars, it´s completely OK. Maybe even prefered.
You may not use any third party components/scripts or copyrigthed modules, as this will be part of a program I will sell. This is very important.