Moderators Functions - Advance Sticky Options

What this Hack Does
This hack will allow you to set a Display Order for Sticky Posts (ignore any sortorder) and set an Expiry Date to unstick your posts.

Hack Info
Templates to Edit: 1 (manual)
Files to Upload: 1 (auto)
DB Changes: 1 (auto)
Plugins Added: 7 (auto)
Cron Scripts Added: 1 (auto)

Instructions
1) Download the attached file.
2) Upload the file in the "upload" folder.
3) Import the plugin.
4) Find and Replace in template threadadmin_editthread

		$posticons

With:

		<fieldset class="fieldset">
			<legend>$vbphrase[sticky_options]</legend>
			<div style="padding:$stylevar[formspacer]px">
				<div>
					$vbphrase[sticky_order]<br />
					<input type="text" class="bginput" name="sticky_order" value="$threadinfo[sticky_order]" size="5" maxlength="3" />
					$vbphrase[sticky_order_desc]
				</div>
				<div>
					$vbphrase[sticky_expiry]<br />
					<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
					  <tr>
						<td>
							<span class="smallfont">$vbphrase[month]<br />
							<select name="sticky_expiry[month]" tabindex="1">
								<option value="-1" $monthselected[default]></option>
								<option value="1" $monthselected[1]>$vbphrase[january]</option>
								<option value="2" $monthselected[2]>$vbphrase[february]</option>
								<option value="3" $monthselected[3]>$vbphrase[march]</option>
								<option value="4" $monthselected[4]>$vbphrase[april]</option>
								<option value="5" $monthselected[5]>$vbphrase[may]</option>
								<option value="6" $monthselected[6]>$vbphrase[june]</option>
								<option value="7" $monthselected[7]>$vbphrase[july]</option>
								<option value="8" $monthselected[8]>$vbphrase[august]</option>
								<option value="9" $monthselected[9]>$vbphrase[september]</option>
								<option value="10" $monthselected[10]>$vbphrase[october]</option>
								<option value="11" $monthselected[11]>$vbphrase[november]</option>
								<option value="12" $monthselected[12]>$vbphrase[december]</option>
							</select>
							</span>
						</td>
						<td>
							<span class="smallfont">$vbphrase[day]<br />
							<input type="text" tabindex="1" class="bginput" name="sticky_expiry[day]" value="$sticky_expiry[day]" size="4" maxlength="2" />
							</span>
							</td>
						<td>
							<span class="smallfont">$vbphrase[year]<br />
							<input type="text" tabindex="1" class="bginput" name="sticky_expiry[year]" value="$sticky_expiry[year]" size="4" maxlength="4" />
							</span>
						</td>
					  </tr>
					</table>
				</div>

			</div>
		</fieldset>
		
		$posticons

Change Log
Version 1.5
- Updated to vBulletin 3.6
- Moved a hook location.
- Changed install code.

Version 1.0.3
- Fixed some broken uninstall code.

Version 1.0.2
- Changed the default value of sticky order from 0 to 5. This was done so you may have stickies like ?Sig Testing? that are always below new stickies.

Version 1.0.1
- Fixed Select Field size.
- Removed '' from numeric values to lessen load and speed up the script.
- Removed excess spacing just to clean up the code.
- Changed != to <> in the MySQL Query to prevent problems.

3.7.x and 3.8.x Support
Currently this is verified working up to vB version 3.8.1

[JonUrban]

Just installed this product. It works great. THANKS!

Jon Urban
www.quadraphonicquad.com

[RedWingFan]

To add this option when you are creating a new thread, add it to your newthread template as follows.

Find the following line:

				$threadmanagement

Add after:

<!-- ADVANCED STICKY OPTIONS -->

<fieldset class="fieldset">
			<legend>$vbphrase[sticky_options]</legend>
			<div style="padding:$stylevar[formspacer]px">
				<div>
					$vbphrase[sticky_order]<br />
					<input type="text" class="bginput" name="sticky_order" value="$threadinfo[sticky_order]" size="5" maxlength="3" />
					$vbphrase[sticky_order_desc]
				</div>
				<div>
					$vbphrase[sticky_expiry]<br />
					<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
					  <tr>
						<td>
							<span class="smallfont">$vbphrase[month]<br />
							<select name="sticky_expiry[month]" tabindex="1">
								<option value="-1" $monthselected[default]></option>
								<option value="1" $monthselected[1]>$vbphrase[january]</option>
								<option value="2" $monthselected[2]>$vbphrase[february]</option>
								<option value="3" $monthselected[3]>$vbphrase[march]</option>
								<option value="4" $monthselected[4]>$vbphrase[april]</option>
								<option value="5" $monthselected[5]>$vbphrase[may]</option>
								<option value="6" $monthselected[6]>$vbphrase[june]</option>
								<option value="7" $monthselected[7]>$vbphrase[july]</option>
								<option value="8" $monthselected[8]>$vbphrase[august]</option>
								<option value="9" $monthselected[9]>$vbphrase[september]</option>
								<option value="10" $monthselected[10]>$vbphrase[october]</option>
								<option value="11" $monthselected[11]>$vbphrase[november]</option>
								<option value="12" $monthselected[12]>$vbphrase[december]</option>
							</select>
							</span>
						</td>
						<td>
							<span class="smallfont">$vbphrase[day]<br />
							<input type="text" tabindex="1" class="bginput" name="sticky_expiry[day]" value="$sticky_expiry[day]" size="4" maxlength="2" />
							</span>
							</td>
						<td>
							<span class="smallfont">$vbphrase[year]<br />
							<input type="text" tabindex="1" class="bginput" name="sticky_expiry[year]" value="$sticky_expiry[year]" size="4" maxlength="4" />
							</span>
						</td>
					  </tr>
					</table>
				</div>

			</div>
		</fieldset>
		
<!-- /ADVANCED STICKY OPTIONS -->

Save the template, and you're done! This will appear at the bottom of the page, directly under Thread Management.

[Masters]

This doesn't work in 3.6.1.

[ctrl-alt-del]

Originally Posted by Masters

This doesn't work in 3.6.1.

Huh?? Yes it does....for me anyway. Unless you were talking about what RedWingFan posted...then, I haven't tried.

[tspore]

Cool mod, I have 1 request. I would like to be able to use this when a mod, sticks a topic, for like 3 days. After the first post is done. So either need it to work on the edit post, or under the edit tools/stick thread.
Thanks for making this very cool.

[wjkids]

Really would like to use this MOD. Does this work with 3.6.2?

[Invalid ID]

Can't find "Sticky Options" shown in the photo. Plz help. Thanks

[TVNettet]

Added and edited template, but couldn't even find the product in vB 3.6.2.
Have added loads of products b4, so not that green ;-)
But of course this is a great idea and can't understand wtf vB haven't made this part of the default...

[Invalid ID]

May be because it doesn't work

[Konstantinos]

i upgraded from 3.5.6 to 3.6.4 and i tried to overwrite the product and i get

Database error in vBulletin 3.6.4:

Invalid SQL:

ALTER TABLE vbthread
ADD sticky_order SMALLINT( 5 ) UNSIGNED DEFAULT '5' NOT NULL AFTER sticky,
ADD sticky_expiry INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER sticky_order;

MySQL Error : Duplicate column name 'sticky_order'