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

[SmEdD]

Just to confirm as I have had people asking me to make it compatible with 3.7.x and 3.8.x. I just tested on a clean install and seems to work just fine for me.

[Saviour]

Working great on vb 3.8.2.

Thanks for this...

[robbiefritz]

I no longer have the ability to edit my post icons when editing the post. Your screen shot shows the post icons but I do not see them on mine. Any ideas? Thanks.

[SmEdD]

Sounds like you didn't copy the code correctly, if you look at the end of the template code you should see $posticons

That is what calls the icons.

[robbiefritz]

Originally Posted by SmEdD

Sounds like you didn't copy the code correctly, if you look at the end of the template code you should see $posticons

That is what calls the icons.

Will check that, thanks!

Update: Sure enough, I missed it.

[Puntoboy]

I've just tried upgrading my forum to 3.8.4. I had this installed already (v1.0.1) and I get a DB error about a duplicate column.

Database error in vBulletin 3.8.4:

Invalid SQL:

	ALTER TABLE vb3_thread
	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'
Error Number  : 1060
Request Date  : Tuesday, September 8th 2009 @ 12:53:44 PM
Error Date    : Tuesday, September 8th 2009 @ 12:53:44 PM
Script        : http://www.puntosports.co.uk/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.puntosports.co.uk/forums/admincp/plugin.php?do=productadd
IP Address    : 188.220.15.42
Username      : Puntoboy
Classname     : vB_Database
MySQL Version : 4.1.22-community-nt-log

How can I fix this without having to set up all my stickies again?

[medicalforums]

Installed on 3.8.3
Works fabulous

[Silviu]

Is there any chance that this hack will make the transition to vB 4.0?

[Gnomie]

Originally Posted by Silviu

Is there any chance that this hack will make the transition to vB 4.0?

that would be nice, would like sort order for stickies for 4.0.1 myself as i have a few per forum....

[PET]

Hello. Can you please update this so it will work for version 4?

Thanks