[SmEdD]

Originally Posted by Psionic Vision

• Design of the form:
  1. Two buffed up with extra words.
  2. The select field is narrower than the text fields.
  3. The controls should only show up when sticky is selected.
• Cron:
  1. Integer fields do not require to be wrapped into single quotes. Ex: Use sticky = 0 instead of sticky = '0'
  2. In MYSQL, you use <>, not !=. Therefore, use sticky_expiry <> 0 and not sticky_expiry != '0'
  3. ### is not a MySQL way to write comments. Therefore, there might be a MySQL error when running this query.
• [sql]DROP sticky_order,
  DROP sticky_expiry[/sql]
  I am not 100% sure, but I think it must be written like this:
  [sql]DROP sticky_order, sticky_expiry[/sql]
  If it works the way you have it, excellent
• Same thing with quotes goes with your XML. You do not need to wrap numeric values into quotes. Although it doesn't matter much, it does affect speed.
  
  

- The DROP and Comment are correct as they are.
- Fixed up the PHP and removed the '' around numeric values and removed some excess spacing.
- Fixed the select field.

In the next version I will see about making the options only show up when there is a sticky. The major problem is you can sticky the thread on that page and it uses a check box instead of a radio button so it will take some time to code it.