A few weeks ago I released my PHP and MySQL link/download tracker. Today I release a complete rewrite. Announcing SHTracker!
To see a working example, simply download from the site as it powers the downloads system.
See here for more information
A few weeks ago I released my PHP and MySQL link/download tracker. Today I release a complete rewrite. Announcing SHTracker!
To see a working example, simply download from the site as it powers the downloads system.
See here for more information
Recently I decided, to redesign the site’s downloads system. Originally I was using the excellent PHP Click Counter from PHPJunkyard to count downloads. However the script was far from perfect and presented problems each time I released a new download. For the revamp I decided I wanted to use MySQL databases to store the data. Unfortunately I could not find a script which would do exactly what I required. So I made my own.
Three hours later the PHP and MySQL Link/Download Tracker was born.
What it does: The script will count link clicks and store its results in a database.
Setup:
CREATE TABLE `Data` ( `id` VARCHAR( 50 ) NOT NULL , `count` INT( 10 ) NOT NULL default '0' , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ;
$links = array( "mydownload1" => "http://some.site/mydownload1.zip", "mydownload2" => "http://some.site/mydownload2.zip" );
So if your download was called mytest, you would change mydownload1 to mytest and set the url to the download url of the file. You can add as many id’s as you wish.
Usage:
The script is called like this: /get.php?id=mydownload1
So instead of linking to /mydownload1.zip, link to /get.php?id=mydownload1
To show your download stats simply call show.php rather than get.php
Download
Source
Update: See here.
In the next few months the emesene OS X build is going to change dramatically. The new version will include:


![]()
These changes are ready, i am purely waiting for Sparkle to be updated to work with Lion. If you are running Snow Leopard and are interested in beta testing the new version, please contact me.
Due to the hard work of Gabriele “Whisky” Visconti, emesene 2 now has a Qt interface. The interface needs a lot of work, but it is a step toward integrating emesene with OS X. If you want to get the Qt interface working on Snow Leopard, follow the instructions below.
Update: As pointed out by Gabriele “Whisky” Visconti, you will also need GObject and PyCrypto. For instructions on how build/install these see here.
Download Qt from here (You want the Cocoa binary package)
Mount the DMG and install the Qt package
1. Download SIP from here (You want Linux, UNIX, MacOS/X source)
2. Unzip the downloaded file
3. Move the unzipped folder to your home directory
4. Open terminal and run:
cd sip-x.x.x (Change depending on SIP version) python setup.py make sudo make install
5. Download PyQt from here (You want MacOS/X source)
6. Unzip the downloaded file
7. Move the unzipped folder to your home directory
8. Open terminal and run:
cd PyQt-mac-gpl-snapshot-x.x-xxxxx python setup.py make sudo make install
9. Download the latest version of emesene from GitHub and unzip
10. Test it out
cd /emesene-emesene-xxxxxx ./emesene -e main:qt4_main
11. You can delete the folders you moved into your home directory if you wish



You will need:
NOTE: IF YOU HAVE USED MACPORTS/FINK, REMOVE ALL TRACES OF IT BEFORE CONTINUING
I assume you want to install gtk at ~/gtk, if not change the instructions accordingly.
First we need to install JHBuild:
curl -o gtk-osx-build-setup.sh https://raw.github.com/jralls/gtk-osx-build/master/gtk-osx-build-setup.sh sh gtk-osx-build-setup.sh
Once JHBuild is installed run these commands:
PATH=$HOME/.local/bin:$PATH export PATH
By default JHBuild will install gtk to ~/gtk, if you want a different location edit ~/.jhbuildrc and change the install directory.
We are now ready to build GTK:
jhbuild bootstrap jhbuild build meta-gtk-osx-bootstrap
Now we need to edit ~/.cache/jhbuild/gtk-osx.modules and remove the line:
<patch file=”https://github.com/jralls/gtk-osx-build/raw/master/patches/gtk-relocation.patch” strip=”1″/>
Once done run:
jhbuild build meta-gtk-osx-core jhbuild build meta-gtk-osx-python
If you get this error: “checking whether to build Python bindings… configure: error: Couldn’t find the required Python tools.” See here.
Optional: Edit file: ~/.cache/jhbuild/gtk-osx-themes.modules and disable all engines except for clearlooks by adding:
autogenargs="--disable-all --enable-clearlooks"
Then build the themes:
jhbuild build meta-gtk-osx-themes
GTK and PyGTK should now have been built.
Now navigate to ~/gtk/inst/lib/python2.6/site-packages and copy the contents of the site-packages folder to /Library/Python/2.6/site-packages
Or run:
echo "import site; site.addsitedir('~/gtk/inst/lib/python2.6/site-packages')" && /Library/Python/2.6/site-packages/gtkredirect.pth
Next we need to build Pycrypto:
curl -o pycrypto-2.3.tar.gz http://ftp.dlitz.net/pub/dlitz/crypto/pycrypto/pycrypto-2.3.tar.gz tar -xf pycrypto-2.3.tar.gz cd pycrypto-2.3 sudo python setup.py install mv /Library/Python/2.6/site-packages/Crypto ~/gtk/inst/lib/python2.6/site-packages
Now all the dependencies are in place, lets download emesene 2 from GitHub.
git clone https://github.com/emesene/emesene.git cd emesene git submodule init git submodule update
Now browse to navigate to the emesene/emesene directory and double click the executable.
Enjoy!

emesene 2 beta is here. MSN works, Jabber works and it is pretty stable. No need for complex hacking of emesene files to run it. Simple drag and drop to install.
Currently sounds are not working and there is no theme at the moment.
Some more pictures…




Interested?
A beta will be available soon. Request to be a beta tester and then check the beta page.
Update:

We have GTK theme engines at last. Currently ClearLooks is included but Murrine and other engines will be included in the future.
I guess you could call this a plea for help…
I am having serious problems getting emesene 2 to run on OS X. Currently Papyon will not work, libpyglib keeps crashing and the menu bar does not work.
Without Papyon, WLM does not work. Rather a large problem in a WLM client.

If you know how to fix any of these problems, please fork the emesene repo and contact me if you manage to get emesene 2 running successfully.
emesene for OS X has now been downloaded over 4,000 times. Well done guys for using emesene and sharing it with others.
For those wondering how to update emesene without downloading the whole package again, there is an easy way of doing it.
You will need git installed!
cd /Applications/emesene.app/Contents/Resources/ && rm -rf emesene git clone https://github.com/emesene/emesene.git cd emesene git submodule init git submodule update
#Add to sys.path so Python can find gtk
sys.path.append("/Applications/emesene.app/Contents/Resources/gtk/inst/lib/python2.7/site-packages")
sys.path.append("/Applications/emesene.app/Contents/Resources/gtk/inst/lib/python2.7/site-packages/gtk-2.0")
sys.path.append("/Applications/emesene.app/Contents/Resources/gtk/inst/lib/python2.6/site-packages")
sys.path.append("/Applications/emesene.app/Contents/Resources/gtk/inst/lib/python2.6/site-packages/gtk-2.0")
To update emesene run:
cd /Applications/emesene.app/Contents/Resources/emesene && git pull
Note: each time you run a git pull you will have to repeat step 3