Xiph: no, this hack does not, in any way, keep track of what user submits which and how many quotes. If you want that, use Lesane's hack. Mine is a more neutral, unbiased hack with an add-on that makes it a bit less neutral and unbiased, but still more than Lesane's.

If you want the total amount of quotes on forumhome, you should be able to easily add a query for that. Something like this:


in root/index.php find:

ADD ABOVE:

(or, to include only quotes that are moderated, if you use the Add-on hack: )


And I've not been in IRC much because of this and other things. Project 3.5 is 99% done, I'm almost ready to send everything online and do the online debugging before opening up. ^_^

Boofo: No, not really. The only difference really, is that the old hack used a Text Input field for Quote, and the new (this) hack uses a Textarea field for Quote, in the Edit page. That, and the new hack doesn't allow empty entries...

I don't have

// ###################### Start templates #######################

in my global.php

Nevermind. :/

Is there away to delete the quotes that come with the hack?
Thanks :)

Nevermind :/

I really should think before I ask these dumb questions.

That's a valuable lesson in life, don't forget it. :)

;)

Okay, out of boredom I added user-submission-tracking to this hack. It tracks which quotes a user submits, and shows the total number of quotes on their profile (only moderated quotes, not unmoderated submissions), and lastly, it uses the quotelist.php to display all the quotes that one particular user submitted, but in a silent way.

So in the end, it's got the same basic things as Lesane's hack, but taken to a whole new level with better code and a big searchable listing. :/

Instructions for user-tracking only on request by PM/mail, btw.

this may sound stupid but what is phpmyadmin? =\ thats the only part of the instructions i havent finished because i dont know what it is

phpMyAdmin is a 3rd Party Program to run on your server. It's a graphical interface for Database control.

You can find it at www.phpwizards.net I believe, or at phpmyadmin.scourgeforge.net - most webservers have phpMyAdmin pre-installed for you anyway, so check that first!

Basically, it allows you to edit, alter, and add to your database(s). Much easier than doing all that through the mysql command prompt.

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT COUNT(id) AS usertotal FROM quote WHERE ok='Y'
mysql error: Table 'baz.quote' doesn't exist

mysql error number: 1146

Date: Sunday 02nd of June 2002 11:07:11 PM
Script: http://www.marietje.nl/vbb/vbb/userquote.php

Everytime a google searches my site, I get that error. I installed that extra query + result of array to display the quotetotal on the frontpage.