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.

[Lady Divus]

Originally Posted by 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 ..

Your welcome...They show up, they dont stick the way the hack was intended. They stick the same as they would if i didnt have the hack in place. I am hoping for help as to why this is happening...Thank you -

Lady Divus

[whitetigergrowl]

would be nice to have this as a default option at the bottom before posting.

[sensimilla]

I have uninstalled this hack as it didnt worked for me and I get this error on forums..

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT threadid

FROM thread AS thread

WHERE forumid = 16
AND sticky = 0
AND visible IN (0,1,2)

Thanks in advance for help.

[utw-Mephisto]

Installed (still 1.0.2) on 3.5.4 and works like a charm .. I first forgotten that the scheduled task has to run (changed time intervall) but then everything works as expected - thanks !

[Lady Divus]

Originally Posted by utw-Mephisto

Installed (still 1.0.2) on 3.5.4 and works like a charm .. I first forgotten that the scheduled task has to run (changed time intervall) but then everything works as expected - thanks !

Hello, could you share with us what you did to change the time interval? I went into my scheduled task manager and i dont see the cron options for this hack...

Do i need to add a cron job? If so, what attributes do i need to enter? I guess this will be my last attempt at trying to get this to work, if i cant get it resolved i will uninstall from both, here and from my site. Thank you for any help in advance -

Lady Divus

[utw-Mephisto]

I installed it according to the instructions. It installs the cronjob automatically and I simply changed the time from once a day to evey 15 minutes ...

[Lady Divus]

Originally Posted by utw-Mephisto

I installed it according to the instructions. It installs the cronjob automatically and I simply changed the time from once a day to evey 15 minutes ...

Wow, thank you, works perfectly...I also realized i was ordering the stickies the wrong direction...

Example:
If i want a particular sticky to be at the top, i dont number it number 1, but rather if i have a total of 4 stickies i would want to number it number 4 to make it number 1...In other words, order backwards, not forward...Sheesh im getting dizzy lol

Anyway, it works! Thank you for your help utw-Mephisto, this this was a very important hack to me...Be well -

Lady Divus

[whitetigergrowl]

Can't seem to uninstall from 3.6

[Milchi]

Nice

[kissythecutie]

can this be installed on vb3.5.4?