[How To] Create forum counters

[Tycoon]

That actually works? How does it know to which database it should add the table etc? Strange..

[lasto]

is easy enough m8 - just hoping someone can do an updater - as the hack works fine but it dont add 1 to the counter for any threads that are already in that section.

Cheers Deaths and neils999

[lasto]

true that LOL how does it know

[Tycoon]

It didnt work for me, the query bit. When I try to activate it in a forum it just gives me a database error.

[lasto]

Originally Posted by Tycoon

It didnt work for me, the query bit. When I try to activate it in a forum it just gives me a database error.

whats the error m8

[Tycoon]

Ok, this is the error I get:

MySQL Error : Unknown column 'enable_contrib_counter' in 'field list'
Error Number : 1054

with some other stuff which isn't really related to the hack. This happens when I try to turn the hack on in a forum. It seems that the query did not work

[lasto]

looks like it did work - 1054 im sure that is an incompatible error or something

will let one of the experts on here guide u on that

[Tycoon]

Damn, I got a 3.5.x board, hope it will work on that version. Thanks for your help.

[lasto]

Originally Posted by Tycoon

Damn, I got a 3.5.x board, hope it will work on that version. Thanks for your help.

im on same version as u m8 (vB 3.5.4) and works on mine - but mine is a fresh install - no other hacks installed.

[Tycoon]

This is the PHP file I used:

<?php
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (contrib VARCHAR(250) NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (enable_contrib_counter VARCHAR(250) NOT NULL DEFAULT '')");
?>

When I try to run in my root directory where the board is located I get this error:

Fatal error: Call to a member function query_write() on a non-object in /var/www/run.php on line 2