Mini Mods - Lightweight Style Options for "Lightweight Style"

Firstly - this is only of use if you have installed the Lightweight Style

Secondly - make sure you read the notes if you use the Mobile Style and the Mobile Style Options addon.

OK, now that the formalities are over, this is an add-on to the Lightweight Style It allows you to customise a few common parts of the style without needing to edit templates.

It also adds in options to disable some products when the Lightweight style is being used and optionally adds "Posted by Mobile Device" type text into posts created using the mobile style.

* Optionally adds links to default style (in footer or header)
* Optionally add 'Posted Via Mobile' message to new posts/threads (message can be customised)
* Optionally display "What's Going On" box in forum home
* Optionally display Style Chooser in footer
* Set 'Home' link URL (rather than editing templates)
* Can optionally hide mobile style from Style Chooser

Version Control:
1.0.0 - 26 AUG 2010 - Initial Release

Notes:
If you have installed "Mobile Style Options" (vb4) and make use of the 'Posted via Mobile Device' option, uninstalling Mobile Style Options will remove all records of posts made using the Mobile Style. The posts will of course remain, just the message will be gone. If this is not an issue for you - uninstall it BEFORE installing this addon. If you wish to keep those records, rather than uninstall it, disable it OR edit the product via Product Manager and remove all the uninstall code, save and then uninstall (this last option is the cleanest)

Running them both is OK, but you will need to disable the "Add Posted By Mobile Message to Post" plugin on the Mobile Style Options product. Uninstalling one of them will affect the other and cause errors as they share database columns. If you uninstall one without making the uninstall code changes, you shjould uninstall both and then re-install the one you are staying with.

[russag]

Originally Posted by flypaper

I readded Mobile Style options and the database error went away. My users can now post. However, I'd really like to be able to remove Mobile Style options.

I don't know if the problem is related to having both installed or its just Mobile Style options. Should I post in that thread?

edit: BTW, the error was

MySQL Error : Unknown column 'ua' in 'field list'

Same here I removed Mobile Style options and received the same error.

Great style though man and good options

[cherylferraro]

Error when importing the xml file.

Database error in vBulletin 4.0.6:

Invalid SQL:

		INSERT INTO vb_product
			(productid, title, description, version, active, url, versioncheckurl)
		VALUES
			('lsoptions',
			'Lightweight Style Options',
			'A collection of options to customise the Lightweight style',
			'1.0.0',
			1,
			'http://vbdev.org/forum.php',
			'http://vbdev.org/forum.php');

MySQL Error   : Duplicate entry 'lsoptions' for key 'PRIMARY'
Error Number  : 1062
Request Date  : Thursday, August 26th 2010 @ 01:08:28 PM
Error Date    : Thursday, August 26th 2010 @ 01:11:40 PM
Script        : http://www.mysite.com/forum/admincp/plugin.php?do=productimport
Referrer      : http://www.mysite.com/forum/admincp/plugin.php?do=productadd
Classname     : vB_Database
MySQL Version : 5.1.48-log

addendum:
Please note, the error was my fault. I had 2 vb admin panels open and had already installed it on this one...

[dartho]

Originally Posted by flypaper

Uhhh, so after installing this, I uninstalled the Mobile Style Options. Now it appears that I can't post on the forum without a database error! Sweet

Originally Posted by russag

Same here I removed Mobile Style options and received the same error.

Great style though man and good options

Sounds like neither of you read my notes in the first post in regards to mobile style options and this one. [edit: or perhaps you did but my lack of detail didn't help - sorry] Both share database entries, by uninstalling Mobile, you deleted the database columns which this one needs. To clean things up, you'll need to uninstall both, then reinstall this one.

[dartho]

Originally Posted by cherylferraro

Error when importing the xml file.

Database error in vBulletin 4.0.6:

Invalid SQL:

		INSERT INTO vb_product
			(productid, title, description, version, active, url, versioncheckurl)
		VALUES
			('lsoptions',
			'Lightweight Style Options',
			'A collection of options to customise the Lightweight style',
			'1.0.0',
			1,
			'http://vbdev.org/forum.php',
			'http://vbdev.org/forum.php');

MySQL Error   : Duplicate entry 'lsoptions' for key 'PRIMARY'
Error Number  : 1062
Request Date  : Thursday, August 26th 2010 @ 01:08:28 PM
Error Date    : Thursday, August 26th 2010 @ 01:11:40 PM
Script        : http://www.mysite.com/forum/admincp/plugin.php?do=productimport
Referrer      : http://www.mysite.com/forum/admincp/plugin.php?do=productadd
Classname     : vB_Database
MySQL Version : 5.1.48-log

I would guess hat means you either have another product with the same productid installed (I though vBulletin would track this?) or you have tried to install it twice without the ovewrite option

[fly]

Originally Posted by dartho

Sounds like neither of you read my notes in the first post in regards to mobile style options and this one. Both share database entries, by uninstalling Mobile, you deleted the database columns which this one needs. To clean things up, you'll need to uninstall both, then reinstall this one.

I read it, but didn't think I qualified. Hopefully we're the only idiots, but it does read more complex that it may need to...

Thanks for the fix tho.

edit: I'm no genius coder, but isn't it generally a good idea for each product/hack to have unique DB entries?

[dartho]

I re-read it and saw it wasn't real clear either - I've edited the notes to be a little more clear.

You're right - I thought about creating unique column names, but then thought many would want to retain the data so kept them the same. I'm no genius coder either - if I was, I'd proibably have the install file check and throw up warnings etc during installation

[flyerndiver]

Damn. I misread it too and now I can't uninstall them both because the uninstaller stops at the two DROP calls. Could you tell me what the attributes need to be so that I can recreate these two columns?

Thanks; great mod! I hope it will one day support blogs and CMS.

edit: nevermind, I edited the uninstall code and now only have the lightweight style options running. Thanks again!

[Mopar Rob]

Ok here is a real NEWB question.. Not sure where to find this basic install info on the forums. I imported/merged this file into the lightweight mobile style. (Assuming that was done correctly) Now I cant find where to access these options??? Again sorry for the newb question but .. IM LOST.

[dartho]

In AdminCP, Go into teh Settings, Options menu and then Lightweight Styl;e Options (Should be near end) and you can change settings there.

[Mopar Rob]

Originally Posted by dartho

In AdminCP, Go into teh Settings, Options menu and then Lightweight Styl;e Options (Should be near end) and you can change settings there.

I do not see it?? Ok here were my steps:

- I went to Styles /upload and merged the product-lsoptions.xml file to the Mobile style

Now when I goto Settings/Options I do not see the Lightweight Style Options listed in the menu.

Do I need to update tables or run any maint??? Sorry again for the Newb Questions..