Custom Post Prefixes

Hack: Custom Post Prefixes
Version of vB: 2.2.0, although may work on earlier versions but not tested
Current Version: 1.0.0
Description: This hack allows you to add custom prefixes to post, like "Poll: " and "Sticky: ", only custom ones editable in the control panel.

All feedback is appreciated, and everything you need is in the attached file.

NOTE: If you downloaded this prior to 5:10 CT please re-download it, I fixed something in the directions.

Version 1.0.0 released, go here
for details.

[jamesdasher]

here is a picture of a post with a prefix

[LuBi]

THANK YOU SO MUCH!?! I've got to do a few things ot get my forums back in order but now I'm installing this hack. Happy to see someone got it working, was it difficlut or were there any surprises during install? Also, who can use the prefixes? Admin & Mods or everyone who can post?

[Palmer ofShinra]

Originally posted by humble
Nevermind!!!!

INSERT INTO setting VALUES ( '171'  .......
&
INSERT INTO setting VALUES ( '172' ........

[quick questions]

a: can these code hack instructions be modified to add those values in the next available line entry?

Yes. See below

INSERT INTO setting VALUES ( 'NULL'  .......
&
INSERT INTO setting VALUES ( 'NULL' ........

That field is set to Auto-Increment. When you insert a new row, and set that value to NULL, it automatically sets it to the next higher number.

And no, if you did it with the 999 solution, it wouldn't create all the rows in between.

[LuBi]

This is the erroer I get, how can I fix it?

Database error in vBulletin Control Panel 2.2.1:

Invalid SQL: INSERT INTO setting VALUES ( 'NULL', '32', 'Prefixes', 'customposttypes', '', 'These will be displayed like \"Poll: \" and \"Sticky: \" but are custom. Enter each word you want with a space between it, like: \"Announcement Important Read\". Don\'t use commas. If you wish to use a space in the Post Prefix, place a _ where you want it to be.', '', '1');

mysql error: You have an error in your SQL syntax near ';

' at line 1

mysql error number: 1064

[LuBi]

Well I must say a few things, this hack is very powerful. I really needed this for my forum. Another feature I would like to see would be a way to intergrate all the prefixes into the search. Maybe search only for certain prefixes. Anyways the hack was extremely hard for this script kiddie to install. All my problem were with the DB queries. Syntax error this syntax error that. If it wasn't for the help of Bane from talkloud.net I would have never got my forums back up. The hack works now, I look forward to better english and maybe some updates on the hack with great new features.

Sorry no SS but check my site to see the results!

[jamesdasher]

sorry, you had so much trouble with the hack LuBi...I have been so busy lately that I wasn't able to help you out right now, sorry about that. Glad you got it working!

James

[LuBi]

Well thanks for making it, members of the only forum similar to mine have been screaming for this. So that everyone knows that it is DYNO, MOVIE, ATTN, whatever else they can come up with. Thank you for making the hack, I could have never figured out something like this. The funny thing was bane didn't get the syntax errors I did yet that NULL thing as mentioned above does need to be applied really if any other hacks exist. Thanks again!

But a search feature in the next script would be great, or arrange by prefix or something. Ex. All members could search for prefix MOVIE: and they would be listed however the user selects, date, member, whatever... If it can be done that would be great.

[apfeifer]

If/when I release a new version I will add the search part in, no guarantees that there will be another version though.

[LuBi]

Originally posted by apfeifer
If/when I release a new version I will add the search part in, no guarantees that there will be another version though.

Gotcha, but if ya do it'd be great.. and thanks again this hack works wonders!

[KuraFire]

so like, this hack STILL doesn't allow you to specify the forum(s) on which the prefix option appears (in the newthread page) right?


Think that if you would add the prefix part into the Threadedit templates, we can turn existing (empty, prefix-less) threads into threads with a prefix? Or will it work with the edit option (weird though, cos what would happen if you edit post #10 in a thread??).

Any enlightenment concerning these two issues would be great

I think the forum-specific part is easily done, I'll go try that tonight and let you all know if it worked.