Execution Order Installer -> Stops Errors when installing 3.6.x Pluggins & Products

Background:

I am almost ashamed to submit what is likely the smallest product ever released here on vBulletin.org. I created this very simple product file as I am about to release a major addition to vBulletin and because I wrote the script in 3.6.x. it was not going to be installable in 3.5.x. forums.

Now, there was nothing in my plugins or code that would make this not work in 3.5.x. forums other then the fact that my 3.6.x forums added the execution order to all of my plugins.

So, What does this do?

This will add a single field to your 3.5.x forums "plugin" table. This field is used in 3.6.x forums to allow 3.6.x forums to assign a specific order for plugins attached to the same hook to be executed.

Now, as long as the hack you are installing does not use any special 3.6.x code, adding this program will allow you to install SOME 3.6.x plugins and products on your 3.5.x forums without error.

I have tested this on three separate 3.5.x forums of my own and installed plugins and products exported from 3.6.x and it worked fie for me. Feedback is welcomed and again, I am embarrassed to have uploaded the smallest Product file to ever have been uploaded!

UPDATES
23-Dec-2006 8:00PM EST - Uploaded new product file that includes UNINSTALL code!

23-Dec-2006 9:15PM EST - Removed the uninstall code per advise having code to remove the execution order may do more harm then not having it in the code.

[Paul M]

Just a note of warning, if someone installs this on 3.5, and then upgrades to 3.6 and then decides to uninstall it, it will delete the required executionorder field and break the forum.

I would suggest you take out the uninstall code - there is no reason I can think of that anyone would ever need to drop that field, once you upgrade to 3.6 it is a standard part of vb, in 3.5 leaving it there will not harm or affect anything.

As far as I'm aware (tested in the past) the vb 3.6 upgrade scripts will silently ignore the fact that the field already exists.

[Quarterbore]

Originally Posted by Paul M

Just a note of warning, if someone installs this on 3.5, and then upgrades to 3.6 and then decides to uninstall it, it will delete the required executionorder field and break the forum.

I would suggest you take out the uninstall code - there is no reason I can think of that anyone would ever need to drop that field, once you upgrade to 3.6 it is a standard part of vb, in 3.5 leaving it there will not harm or affect anything.

As far as I'm aware (tested in the past) the vb 3.6 upgrade scripts will silently ignore the fact that the field already exists.

You know better then I... and it shrinks my code back to where it was before for the smallest hack ever! I will reupload the hack now without the uninstall!

[fishhub]

how is the response? anyone tested in it in 3.5.x and uploaded any 3.6.x mods without and probs?

[Quarterbore]

I have been providing this to customers using my vBClassified script (this is a huge add-on) and without this little product these customers would always get the same error as follows:

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'some script', 'online_location_process', 'if ($filename == \'somescript.php\')\r\n{\r\n$bbuserinfo[\'activity\'] = \'somescript\';\r\n}', 'name');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Tuesday, January 30th 2007 @ 08:42:30 PM

With this installed, NO ONE has had a problem...

I am not sure why this only has four installs but hey... I just care that my customers are running...

[Chicago_VLNU_4s]

nice.. thanks

[ArchangelX]

I bumped this because it should be. Greatest hack ever!

[serhat_kk]

Originally Posted by ArchangelX

I bumped this because it should be. Greatest hack ever!

Yesss, you are right! Thanks Quarterbore.

[xTerMn8R]

Excellent Job .... Man I wasted 8 hrs tring to install a mod beofre I found this. I wish I had found this page 8 1/2 hrs ago... after installing this the other mod went in in 2 minutes...

Thank you VERY VERY Much.... :up::up::up:

[Quarterbore]

Back up... I see people with this issue still...

[bada_bing]

This is awesome thank you much