I just noticed after upgrading the hack, that if you try to edit a quote that has quotes around it, it does not show up in the editor. The quoter will and the letter, just not the quote. Also, it is now impossible to save a quote or edit one without filling in the quoter variable. It says that all variables must be completed. I would like to be able to save it without the quoter or letter if possible, since I will not be adding the part to my board for the listing of the quotes. Can this be done?

Ah, yes, I haven't htmlspecialchar'd the inputs, since on my own board I use no ""s around quotes. If you want them to display around each quote (ie. "this is a quote") you should better just add " in your templates. Much easier to take them off again if you decide to, at one point.

To fix that problem though, find in your admin/quotes.php this line:

And add below it:

(if you use ""s in your name input as well, add `$quote[name] = htmlspecialchars($quote[name]);` below that).


The other issue: if you save without a letter, the quote will not show up in the Quotes List, Ever. And if you intend to disband the Quoter (Name) part, you can just fill in a dash ( - ) or so for the quoter name, or "Unknown" or whatever. Filling in nothing is a bad idea.

Database error in vBulletin Control Panel 2.2.4:

Invalid SQL: SELECT * FROM quotes WHERE mod='N'
mysql error: Unknown column 'mod' in 'where clause'

mysql error number: 1054

Database error in vBulletin 2.2.4:

Invalid SQL: SELECT *
FROM quotes
WHERE 1=1 AND mod!='N'
ORDER BY letter,name ASC
LIMIT 0,30
mysql error: Unknown column 'mod' in 'where clause'

mysql error number: 1054

Help! (These errors are from when I installed the second addon hack) The first hack worked fine :(

Hmmm. The zipfile didn't update my new query it seems..

John, run this query on your quotes table:

ALTER TABLE quotes ADD mod VARCHAR(1) NOT NULL;

That should fix it. *goes update the zipfile again, hoping it WILL add the new query file this time*

It works! Thank you! :)

I updated the second post, with the instructions for the Moderation add-on. It now includes the query in post #15 in its instructions. The original file is untouched though, since the original hack doesn't need the mod column. :)

Glad it works, JW :):up:

Kura, I've love to see something on the front page of the AdminCP like "There are currently [number] quotes awaiting moderation." - I can see myself forgetting tha people have added quotes :(

Erm, I'll see what I can do.

If you prefer, I can also write a line of code that will e-mail you whenever a user adds a new quote... though this could become quite tedious & annoying if you have a lot of users. :)

I'll let you know in this thread once I have it done, okay? :)

How about a PM that is sent to a specified user (i.e. the admin) at a set time each day to inform of new quotes?

So, at the time "6.00pm" a PM is sent to the admin "John" if there are any new quotes for moderation.
e.g.
"Hi [admin's name], there are [number of new quotes] new quotes waiting to be moderated. Click here to moderate them"