Miscellaneous Hacks - Tips of the Day

Many computer programs display a "Tip of the day" window when you open it. This mod offers the same functionality for vBulletin.

- The tips are displayed as vB's stock notices.

- You have complete control to define how often a tip is shown. There are the following options: always on, once in a browser session, once a day, once every X minutes or once every X page views.

- Tips are phrased. If you have a multilanguage board, you can easily translate them.

- Every tip can be assigned to a user-group, so only its members will see it. It also checks secondary groups.

- The mod will chose one of the available tips randomly. You can change the probabilistic weight of every tip to control how often they will be shown.

- The appearance of the Tips can be easily configured using stylevars (including background, shadow color, font for the title of the tip, and color for both the title and main tip text). For advanced needs, you can also customize the pod_tips.css template.

- Import / export utility, so you can make security copies, or share with your friends.

- Option to deactivate tips for guests.

- Setting to disable for non-confirmed users (awaiting email confirmation or in moderation) and banned users.

- With the package, I provide a file with a few tips about basic vBulletin usage that you can import after installing the mod, so you have some default tips (if you find some mistake in the file, please tell me, English is not my first language).

- There's a setting to add an icon next to the tips. (The icon used in the screenshots comes from http://www.iconfinder.com/icondetail...es_system_icon ). You can very easily customize the CSS style for that icon using stylevars.

- You can let your users dismiss the Tips of the Day. After dismissing them, they can be enable by clicking the appropriate option in the Quick Links menu. Optionally, users must have been registered for a configurable number of days before they can dismiss (so you ensure they see some Tips before dismissing them). At any moment, users can undismiss Tips by selecting an option in the Quick Links menu.


PERFORMANCE

All the information of the Tips is retrieved using the second call of the datastore (just after init_startup). If you have any other mod that uses the same call to the datastore, it will use the same query.
Also, the mod avoids to load the datastore if it's possible to determine beforehand that there will be no tips displayed (it's not always possible, but most often).
Therefore, this mod increases your query count in AT MOST one single query on every page load.

Furthermore, the CSS uses the main-rollup file (if you are storing css in the file system), or the main call to css.php (if you are not). So it never requires an extra HTTP request.


INSTALL/UPGRADE INSTRUCTIONS

1. Unzip the mod file.

2. Upload all the files in the "upload" folder. Note: If you have renamed your admincp folder in your vb installation, make sure to do so before uploading. This is the file structure you have to upload:

./includes
./includes/xml
./includes/xml/bitfield_pod_tips.xml
./includes/xml/cpnav_podtips.xml
./includes/xml/cssrollup_pod_tips.xml
./admincp
./admincp/pod_tips.php


3. Import the product file.

4. Add few tips in the admincp: Notices > Tips of the day manager. Optionally, you can import the default vB usage tips provided with the package.

5. Go to Settings > Options > Tips of the day Settings, configure options as you wish, and set active to "yes" (the mod installs itself deactivated to give you a chance to add tips before activating).


MEANING OF PROBABILITY

If you set the probability of a tip to be "10", it doesn't mean that it will appear with a probability of 10%. The actual probability will depend on how many tips are availiable to display. The probability setting is relative to other tips. For instance, a tip with probability 10 will appear two times more often that one that you set to 5.


MODIFIED STYLES

This mod partially depends on the built-in notices system. Therefore, if you have modified your navbar template to a way that it cannot show regular vB's notices, this mod will probably not work. Since version 0.2, Tips should most likely work on most styles if ordinary notices are working, but cannot guarantee.


COMPATIBILITY

I tested this mod in vbulletin 4.0.4. However, it might probably work on any 4.0.x release (please, tell me if you run into any problem using this mod on earlier 4.0.x releases).


SIGNIFICANCE OF A BETA RELEASE

Please note that this mod is, at best, in beta stage. Therefore, I hold no responsibility on any harm or data loss it might cause. I strongly recommend testing it as extensively as possible in your testing environment before installing it in your production site.


SUPPORT

Despite its beta status, I'll do my best to support all vb admins that mark this mod as installed. Sometimes, support will be impossible without providing me admincp access (in a test install, preferably).


TRANSLATIONS

I provide a Spanish translation for this mod. You are most welcome to translate it and distribute your translation (only the language file) in any site, provided that you link to the official thread of the mod in vbulletin.org.

Note that you can only distribute the language file, downloaded from the Languages & Phrases section in your admin cp. Redistribution of the product itself is not allowed.


CHANGE LOG

v0.1 (June 21, 2010) Initial beta releases

v0.2 (June 26, 2010)
- Fixed missing phrase in tips manager, when there are no tips to show.
- Setting to disable for non-confirmed users (awaiting email confirmation or in moderation) and banned users
- Import / export utility.
- Setting to add an icon next to the tips. (The icon used in the screenshots comes from http://www.iconfinder.com/icondetail...es_system_icon ).
- Changed the way used to inject the tips into the page (thanks ragtek for the idea). Hopefully, will work better with modified styles.

v0.2.1 (June 27, 2010)
- Fixed bug that made the mod incompatible with mysql prior to 5.0.2.
- Fixed bug that made the mod incompatible with vBulletin prior to 4.0.4.

v0.3 (July 12, 2010)
- Style of the tips can now be customized using stylevars (there's also a pod_tips.css template for advanced needs).
- A new setting now allows you to choose in which areas of vBulletin should tips be displayed.
- Now you have more control to define how often a tip is shown. You have the following options: always on, once in a browser session, once a day, once every X minutes or once every X pageviews.
- Path and style of the icon for the tips has been moved from vBulletin options to stylevars (you'll need to configure it again, sorry).
- Option to make the Tips dismissible.

[docvader]

must be a mistake with the import tips file you provided (it has great information, but it won't import)

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT `id`, `prob`, `group` FROM pod_tips WHERE `active` IS TRUE ORDER BY `order`, `prob`, `title`;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUE ORDER BY `order`, `prob`, `title`' at line 1
Error Number : 1064
Request Date : Saturday, June 26th 2010 @ 03:35:59 PM
Error Date : Saturday, June 26th 2010 @ 03:35:59 PM
Script : http://xxxxxx.com/admincp/pod_tips.php?do=doimport
Referrer : http://xxxxxxxxx.com/admincp/pod_tips.php?do=import
IP Address : xxxxxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 4.1.22-standard

Tips get added in admincp area, but I'm getting a lot of these db errors when trying to add tips, or view them in the admincp.
Using VB 4.03

[Pod]

Originally Posted by docvader

must be a mistake with the import tips file you provided (it has great information, but it won't import)

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT `id`, `prob`, `group` FROM pod_tips WHERE `active` IS TRUE ORDER BY `order`, `prob`, `title`;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUE ORDER BY `order`, `prob`, `title`' at line 1
Error Number : 1064
Request Date : Saturday, June 26th 2010 @ 03:35:59 PM
Error Date : Saturday, June 26th 2010 @ 03:35:59 PM
Script : http://xxxxxx.com/admincp/pod_tips.php?do=doimport
Referrer : http://xxxxxxxxx.com/admincp/pod_tips.php?do=import
IP Address : xxxxxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 4.1.22-standard

Tips get added in admincp area, but I'm getting a lot of these db errors when trying to add tips, or view them in the admincp.
Using VB 4.03

I don't think it has to do with the file. The query that gives you problems just reads all the contents of the table to create the datastore (that's why oyou get the error every time you try to add a tip. I guess it has to do with the version of your MySQL server (the error says it's 4.1.22, I never tested with anything under 5.x). Please allow me some time to find a way to find a test instalation of your version.

One question, when you tried the import, the "Check duplicated tips" box was checked?

[docvader]

doesnt matter if duplicated tips box is checked. Tips get imported, can be seen in admincp in tips manager, but still get database error after importing.

Tips don't show in forum, or anywhere, for that matter.


(not sure if Photogallery is messing with that)

Deleting tips gives the same db error. Doing anything with your system gives the same db error:

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT `id`, `prob`, `group` FROM pod_tips WHERE `active` IS TRUE ORDER BY `order`, `prob`, `title`;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUE ORDER BY `order`, `prob`, `title`' at line 1
Error Number : 1064
Request Date : Saturday, June 26th 2010 @ 04:19:18 PM
Error Date : Saturday, June 26th 2010 @ 04:19:18 PM
Script : http://xxxxxxxxxx.com/admincp/pod_tips.php?do=dodelete
Referrer : http://xx.xxxxx.com/admincp/pod_tips...o=delete&id=52
IP Address : xxxxxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 4.1.22-standard

[Pod]

Originally Posted by docvader

doesnt matter if duplicated tips box is checked. Tips get imported, can be seen in admincp in tips manager, but still get database error after importing.

Tips don't show in forum, or anywhere, for that matter.


(not sure if Photogallery is messing with that)

Deleting tips gives the same db error. Doing anything with your system gives the same db error:

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT `id`, `prob`, `group` FROM pod_tips WHERE `active` IS TRUE ORDER BY `order`, `prob`, `title`;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUE ORDER BY `order`, `prob`, `title`' at line 1
Error Number : 1064
Request Date : Saturday, June 26th 2010 @ 04:19:18 PM
Error Date : Saturday, June 26th 2010 @ 04:19:18 PM
Script : http://xxxxxxxxxx.com/admincp/pod_tips.php?do=dodelete
Referrer : http://xx.xxxxx.com/admincp/pod_tips...o=delete&id=52
IP Address : xxxxxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 4.1.22-standard

Please, try to replace your admincp/pod_tips.php with the one attached in this post. If it works, I'll replace the package in the first post

[docvader]

GOOD JOB.

No more database errors.

Just can't see it on my forum now, LOL...

EDIT: turning off my other forumhome plugins, such as photopost integration, does not do anything. Does not seem to be interference with the other plugins. I guess I need to upgrade to vb 4.04...

[Pod]

Originally Posted by docvader

GOOD JOB.

No more database errors.

Just can't see it on my forum now, LOL...

EDIT: turning off my other forumhome plugins, such as photopost integration, does not do anything. Does not seem to be interference with the other plugins. I guess I need to upgrade to vb 4.04...

Your navbar template seems ok. I think it should work even in 4.0.3.

Please try this, admincp > Settings > Options > Tips of the day Settings. Make sure the first two options are yes (both active and persistent tips).

You can turn off persistent tips later if you wish, but for testing it's better to have it on.

[docvader]

Had them both on. Didn't work.

Upgrading to 4.04. I guess it's time, LOL

[Pod]

Originally Posted by docvader

Had them both on. Didn't work.

Upgrading to 4.04. I guess it's time, LOL

If you don't have any other reason for upgrading, hold on, I think I can fix the compatibility with 4.0.3.

[docvader]

Upgraded.
Tips works!

Awesome script. Keep up the good work. Need to make more tips....

[Pod]

Originally Posted by docvader

Upgraded.
Tips works!

Awesome script. Keep up the good work. Need to make more tips....

Good to know it works

Anyway, I did the appropriate changes, if anyone wants to run it on vb4.0.3, it should work now.