End-User Options - Countdown Timer in signature

This is a port of my vB3.5.x "User Countdown Timer".
I had to change some parts of the install code to make it work with vB3.6, and here we go:

This little AddOn gives your users the option to show a custom countdown timer at the bottom of their signature.

Features:

• Fully configurable via UserCP (see screenshot)
• BB-Code can be used for eventname and overmessage
• fully phrased/templated, nothing hardcoded and so fully customizable
• leading days or hours with a value of "0" are not shown
  (so it shows "42minutes" rather then "0days 0hours 42minutes")

Installation:
Painless:

• Upload "plugins_usercountd.php" to ".../forum/includes"
• Import the product .XML

DONE
That's it.
No template edits, no nothing


Usage:
Go into your UserCP -> Edit Options
On the very bottom you will find the options for the Countdown Timer.
Set it to whatever you like, if "Enable" is set to "Yes" the timer will automatically be shown on the bottom of your sig, set to "No" will hide/disable the time display



Have fun

[Neal-UK]

This mod is not working, turned off and back on and all users get is this below.

[SuperFly]

did you edit usergroup permissions?

Try un-installing and re-installing

[KimmiKat]

Ah, didn't look there. Thanks! It works too. Some of my pregnent members will use it for the days until the birth of their young' uns!

Originally Posted by KimmiKat

I installed it and I don't even see it in the options...

[Alan @ CIT]

Text isn't showing for me in the AdminCP -> Usergroup manager for me either

Edit 1: Or the UserCP

Edit 2: Also, you should change line 188 of plugins_usercountd.php to use $vbulletin->db->fetch_array() instead of mysql_fetch_array() as people like me who use MySQLi get:

Fatal error: Call to undefined function mysql_fetch_array() in C:\Program Files\Apache Group\Apache2\htdocs\vb_3.5.4\includes\plugins_usercountd.php on line 188

Thanks,
Alan.

[Hellcat]

Somehow 3.6 doesn't rebuild the languages propperly here....

A manual rebuild or simple resaving of any phrase will fix that (it does for me....)

[Lottis]

Installed and working good. Thanx Hellcat.

[Lottis]

This works, fore every users, unless one.
Do you have a clue why?

[Ophelia]

I had an older version installed.. now I get this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO vb_phrase ( languageid, varname, fieldname, text, product, username, dateline, version ) VALUES ( 0, 'field8_title', 'cprofilefield', 'User Countdown', 'vbulletin', 'Hellcat', '1152991682', '3.5.4' );

MySQL Error : Unknown column 'fieldname' in 'field list'
Error Number : 1054
Date : Saturday, July 15th 2006 @ 03:28:02 PM
Script : http://www.mysite.net/forum/boss/plugin.php
Referrer : http://www.mysite.net/forum/boss/plu...?do=productadd
IP Address : mynumber
Username : myname
Classname : vb_database

There are now to blank spaces under USERCP > OPtions, and if you try to save anything on this page, you get this:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb_userfield SET
field7 = '',
field8 = ''
WHERE userid = 2564;

MySQL Error : Unknown column 'field7' in 'field list'
Error Number : 1054
Date : Saturday, July 15th 2006 @ 03:30:23 PM
Script : http://www.mysite.net/forum/profile.php
Referrer : http://www.mysite.net/forum/profile.php?do=editoptions
IP Address : mine
Username : me
Classname : vb_database

It no longer shows up in my plugins, so I can't remove it there. Any ideas how to get this removed? No one can update options now.

[Ophelia]

Okay.. got almost all of it figured out. I need to know how to remove the fields it created.



Until I get this figured out, we can't update Options.

[Ophelia]

Anyone know what I can do? Folks are trying to update their Options and I'm getting database errors up the whazoo.