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: 3 (auto)
Plugins Added: 7 (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.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.

[IrPr]

seems i need DROP sticky_order and sticky_expiry columns before re-installing product, rite?

[SmEdD]

Yes there was an error on the 1.0.1 and 1.0.2 uninstall code. Run this query.

ALTER TABLE thread
DROP sticky_order,
DROP sticky_expiry;
		
DELETE FROM cron WHERE title IN ('Sticky Cleanup');

[ssslippy]

Ok ive tried to install this, doesnt seem to show up in the edit window. Its still showing the default. I even did a copy of paste of your code above. Still fails.

[Tinbendr]

Ref. Installed 1.0.3.
Seems I'm having the same problem. No changes to the edit box.

[PolyMarauder]

Thanks for the mod. Works like a charm, just what I needed.

Cheers!

[Lady Divus]

Ok, i have a couple questions,

1.) Does this work on 3.5.4?
2.) I installed it and it doesnt work, where do i check to make sure it is turned on?
3.) If it is turned on, what could be making it not work?

Any help would be greatly appreciated. Be well -

Lady Divus

[whitetigergrowl]

Did template edit, added plug-in..plug-ins turned on...file uploaded...but still not showing. Using Vb 3.5.4

[utw-Mephisto]

Originally Posted by whitetigergrowl

Did template edit, added plug-in..plug-ins turned on...file uploaded...but still not showing. Using Vb 3.5.4

Same here, even on a brand new test forum with no other modifications

[Lady Divus]

Originally Posted by whitetigergrowl

Did template edit, added plug-in..plug-ins turned on...file uploaded...but still not showing. Using Vb 3.5.4

It shows in the 'Thread Tools' option in each thread. Choose 'Edit Thread' and you will see the Sticky options, check out the screenie below...However, it doesnt work for me even when i try to use it. Hope this helps -

Lady Divus

[utw-Mephisto]

Lady, thanks, I knew that it only works on edit but I thought it is enough to use the regular edit button, now I can see the sticky options. You say that they don't work for you. Do you mean they don't show up or they don't go unstuck ? Just curious before I try the scheduled thing ..