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

[alahmed]

i am sorry to say:

its not working with version 3.6.7

[pcoskat]

Originally Posted by RaceJunkie

Great hack I have not installed yet, but this should be a default feature in vB

Ditto that

[DSLTD]

When i try to import the XML file i get this error;

Database error in vBulletin 3.6.4:

Invalid SQL:

	ALTER TABLE 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
Date         : Tuesday, July 17th 2007 @ 07:15:32 PM
Script       : http://kingofpop.info/forum/admincp/plugin.php?do=productimport
Referrer     : http://kingofpop.info/forum/admincp/plugin.php?do=productadd
IP Address   : 88.107.84.28
Username     : admin
Classname    : vB_Database

Anyone got any ideas why?

I have changed the text and replaced it with what the instructions say to in the threadbit also, the XML file just wont upload

[rpainter]

Great MOD

[lazserus]

I just can not get this to work on 3.6.7 or above. I have installed and reinstalled it and nada. Any ideas? I'm receiving no errors, the sticky options just don't appear.

[DiMoNd21]

Just installed it on 3.6.8. Not working... Any ideas?

[Marys242]

Originally Posted by ctrl-alt-del

As usual, as soon as I post, I found the option to Edit Thread. (Thread Tools / Moderation Tools / Edit Thread radio button)

thank you...i was also wondering were it was....

[dismas]

Does this work/does anyone have it installed on 3.6.8?

[lazserus]

It doesn't work for me either. I was running 3.6.7 when I installed it and it didn't work. After upgrading to 3.6.8, it still does not work. The version on the hack shows 3.6.0 Beta. The developer just needs to update the hack to work with 3.6.8.

[stwilson]

I was able to get this working on 3.7B5 without any problems. As far as I can tell, it is working. I was able to sticky a thread. I set it to expire tomorrow and will post up the result, ie, did the sticky automatically go away.