[How To] Create forum counters

[lasto]

Originally Posted by Niels

Holy wtf :| What version are you running?

vb 3.5.4 is the version im on

also the text i pasted in my thread is from another post on here showing the hooks and it dont show the one i need to change ??

I defo dont have hook: threadmanage_deletethread in the drop down box

its not even listed on the page on here where the full hooks are listed



The hook you have asked me to add aint even on this list m8

List of default hooks



am i missing something here

[Niels]

Originally Posted by Tycoon

Where in AdminCP do you mean exactly? I did enable all the hooks and also enabled it Forum Manager when editing one of my forums. Is there another place because I didn't find anything in the "Vbulletin Options".

Thanks for your support.

If you enabled it @ the forum manager with one of your forums, it should work. Make sure you set it on and not on a category but a forum. That should do the job. And no there is nothing in vbulletin options.

@Lasto
Sorry, look like my head went weird :p I'll take a look at it soon. Sorry to confuse you.

[lasto]

Originally Posted by Niels

If you enabled it @ the forum manager with one of your forums, it should work. Make sure you set it on and not on a category but a forum. That should do the job. And no there is nothing in vbulletin options.

@Lasto
Sorry, look like my head went weird :p I'll take a look at it soon. Sorry to confuse you.

no worries m8 -- i appreciate your free time and thank you for even helping in the first place

[lasto]

no rush Niels but any update to this yet m8 - have now got my board up and running but not open to general public till i sort out my hacks.

cheers m8

[lasto]

can anyone do an updater for this as really need it.
I need it so if i delete a thread it detracts 1 point from the score
also the section im using it on already had threads in so i need the updater to take these into account as at moment its only counting the new threads u make in that section since the hack was installed.

[Niels]

Originally Posted by lasto

can anyone do an updater for this as really need it.
I need it so if i delete a thread it detracts 1 point from the score
also the section im using it on already had threads in so i need the updater to take these into account as at moment its only counting the new threads u make in that section since the hack was installed.

Sorry to say, but I'm kinda busy, need to finish one vb site. And got my next customer also already in....

[lasto]

kk nps will see on vb.org if a coder will finish this off as really need it

cheers neils999 for your help though

[lasto]

anyone able to finish this off - just need some php to update for threads etc which are already made before this hack is installed as it only counts the ones from when the hack is installed.So any existing ones are not counted.

[lasto]

keep getting these emails wondering if its anything to do with this counter - what do u think.


Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN f
Error Number : 1064

Date : Friday, May 26th 2006 @ 02:06:06 PM
Script : ****************/cron.php?&rand=241144


Not got a clue but got this from google :

Why do i get a query syntax error 1064 from MySQL when the syntax seems correct?

You will get a MySQL query syntax error number 1064 when you incorrectly use a reserved word in your query such as "when" or "order".

[Niels]

Originally Posted by lasto

keep getting these emails wondering if its anything to do with this counter - what do u think.


Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN f
Error Number : 1064

Date : Friday, May 26th 2006 @ 02:06:06 PM
Script : ****************/cron.php?&rand=241144

Nope, this has nothing to do with it.