[Niels]

As requested by lasto. In this example I'll show you how to add a new counter, that you can enable for forums, to count new threads started in there by a member. Everywhere where I use the word Jokes you can replace it with what you want to call it!
Run these query's:

$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (jokes  VARCHAR(250) NOT NULL DEFAULT '')");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD (enable_jokes_counter VARCHAR(250) NOT NULL DEFAULT '')");

Add a new plugin (hook: forumadmin_edit_form):

print_table_header('Forum Counters');
print_yes_no_row("Enable jokes counter?", 'forum[enable_jokes_counter]', $forum['enable_jokes_counter']);

Add a new plugin (hook: forumdata_start):

$this->validfields['enable_jokes_counter'] = array(TYPE_STR, REQ_NO);

Add a new plugin (hook: newthread_post_complete):

$usrname = $vbulletin->userinfo['username'];
if($foruminfo['enable_jokes_counter']){
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET jokes = jokes + 1 WHERE username = '$usrname'");
}

Add a new plugin (hook: useradmin_edit_column1):

print_table_header('Forum Counters');
print_input_row("Jokes", 'user[jokes]', $user['jokes']);

Add a new plugin (hook:userdata_start):

$this->validfields['jokes'] = array(TYPE_STR, REQ_NO);

Edit template postbit and postbit_legacy.
Find:

<div>
	$vbphrase[posts]: $post[posts]
</div>

Add under:

<div>
	Jokes: $post[jokes]
</div>

That's it Hope it worked for you, if not? Feel free to ask

works great, keep up the good work

[lasto]

what can i say m9 Thank you.

Believe me i really needed this and what with being on the new vbull throught it would`nt happen.Really appreciate your time on this Niels.

[lasto]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 '$db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (jok

Going though phpmyadmin gives me this error

ERROR: Unknown Punctuation String @ 4
STR: ->
SQL: $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD (jokes VARCHAR(250) NOT NULL DEFAULT '')")

[Arnoud]

You're supposed to run the queries in a PHP script, not in phpmyadmin :p

[lasto]

run the queries in a script ??? How

anytime i have to run queries i run em through the admin option of Run Query - but cause it failed i ran em directly though PHPmyadmin.

So basically i just add the queires above to Index.php and they will be called when the main index page is called is that correct or showthread.php cause thats where they will be seen ??

[Tycoon]

This is EXACTLY what I have been looking for but I am stuck on the query bit just like Lasto. How do you run a PHP script with query?

Thank you for your contribution and help.

[lasto]

ok suzzed it and it works nice one m8

These plugins are really new to me - ive done it and it all works but i was used to actually hacking the php files - well easier this way


is there anyway i cna set it to auto update for the threads that are already made in that section as its only counting any new ones that are made.
Also i would really like an updater cause any threads i delete still leave the counter adding one.
I dont mind running the script to update the stats manually say once per week so if u can help id be well happy with this hack.

[lasto]

Originally Posted by Tycoon

This is EXACTLY what I have been looking for but I am stuck on the query bit just like Lasto. How do you run a PHP script with query?

Thank you for your contribution and help.

lo m8

all i did was copy the query to a txt file and saved it in the exstension .php

test.php

then i uploaded it to the forums and ran it - so the tables where added then i deleted the test.php so the tables were not re-added (safe purpose)

then just do the rest in admincp

[Tycoon]

Lasto: Can you tell me how you achieved it? I am still. Thanks.

[EDIT:OOP, you were quicker :P. Thanks Lasto!]