Who would ever think me releasing something
Being a newbie at php/mysql programming i had help from tutorials all over the place and from freakysid from SPF forums
1. MySQL based counter
You need:
1. phpmyadmin - http://sourceforge.net/projects/phpmyadmin/ -phpmyadmin install and use guide to add a table named mycounter to your existing vB database.
you need to select you vb database name listed in the left of phpmyadmin and run the following queries once in phpmyadmin
i.e. if my vb database is named usertest you should enter like this the screen cap below or here.
2. need to edit your phpinclude template and add the following in:
save changes
3. then place $mycounter in your footer template
Being a newbie at php/mysql programming i had help from tutorials all over the place and from freakysid from SPF forums
1. MySQL based counter
You need:
1. phpmyadmin - http://sourceforge.net/projects/phpmyadmin/ -phpmyadmin install and use guide to add a table named mycounter to your existing vB database.
you need to select you vb database name listed in the left of phpmyadmin and run the following queries once in phpmyadmin
Code:
CREATE TABLE mycounter (count INT(11) UNSIGNED NOT NULL); INSERT INTO mycounter SET count = 0;
2. need to edit your phpinclude template and add the following in:
PHP Code:
$result = mysql_query("SELECT count FROM mycounter");
$mycounter = mysql_result($result, 0) + 1;
$result = mysql_query("UPDATE mycounter SET count = count + 1");
3. then place $mycounter in your footer template
Comment