Countdown Block

[ayasha]

ok, guys, i moved my testing forum from xampp to my server, and i was successful in creating a table for it, but now, i have gone in the acp and configured it, but it will not show. any suggestions?

[Dragonsys]

Does the block show and it's empty, or does nothing show up?

[Dragonsys]

Hello again friends,

I would like to know if you know how to insert the Minutes and Seconds in the said countdown field (pls refer to the attached, in red color)

[flash=,]http://i19.photobucket.com/albums/b164/doswald/PHPBB/countdown.jpg[/flash:1x5aauxi]

Thanks, hope to hear again.

Regards,
Doswald

don't quote me on this.. but I think that is automatically set to run by your forum clock. I haven't actually played with that bit yet I am sorry...

I think he wants to insert the WORDS minutes and seconds...

[ayasha]

nothing shows Dragonsys <img>

[HoRuZ]

It could be a php or mySQL version issue as Teelk mentioned.
I have it installed as I described and it works perfectly, but I run my site on a php 4.x.x server.

For showing the words I did this:

#
#-----[ OPEN ]------------------------------------------
#
root/language/lang_english/lang_countdown.php


#
#-----[ FIND ]------------------------------------------
#
$lang['C_days'] = 'Remaining Days:';


#
#-----[ AFTER, ADD ]------------------------------------------
#
$lang['C_days'] = 'Days';
$lang['C_hours'] = 'Hours';
$lang['C_mins'] = 'Minutes';
$lang['C_secs'] = 'Seconds';


#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM

Updated the download as well

[url=http]advanced countdownblock100[/url]

[Michaelo]

What are you storing in event_stop? a date/time?
Use int(11) default NULL...

I note most if not all dates are stored in a integer 11 numbers long, however if the field is a date then define NULL has the effect of type casting (or it would appear)... where the field is allowed to be empty or '0' ( this is not zero... need to remove the '' else it's a character) there can be be errors down the line for functions that manipulate the entry... It's worth a try...

Either of these will work. (php5/mysql5)

Code: Select all

 CREATE TABLE phpbb_countdown(img_left varchar( 255 ) default '',img_right varchar( 255 ) default '',title varchar( 100 ) default '',description varchar( 100 ) default '',event_text varchar( 200 ) default '',event_stop int( 11 ) default NULL,enable_index tinyint( 1 ) default '0',enable_portal tinyint( 1 ) default '0',full_display tinyint( 1 ) default '1') TYPE = MYISAM ;  

or

Code: Select all

 CREATE TABLE phpbb_countdown(img_left varchar( 255 ) default '',img_right varchar( 255 ) default '',title varchar( 100 ) default '',description varchar( 100 ) default '',event_text varchar( 200 ) default '',event_stop int( 11 ) default 0,enable_index tinyint( 1 ) default '0',enable_portal tinyint( 1 ) default '0',full_display tinyint( 1 ) default '1') TYPE = MYISAM ;  

Mike

[ayasha]

ok, i just don't get this, i have applied this to both my test and my live forum, the table has been created in both, but still, it does not show on either forum.

[Frost]

Are you sure it's not caching the block? Just a thought... <img>

[Tom_S]

I have been tagging along with this thread and it does not work for me either. It shows the block but it is emtpy. I have "no cache" for the block. I tried dropping the table and using the sql Michaelo suggest for both and still the same. Empty block <img>

[ayasha]

Are you sure it's not caching the block? Just a thought... <img>

how would i find out, and if it is, what would i do?

[ayasha]

ok, i got it to work, but even though i have it to show on the index page, it is not showing there.

[doswald]

Hello again friends,

I would like to know if you know how to insert the Minutes and Seconds in the said countdown field (pls refer to the attached, in red color)

[flash=,]http://i19.photobucket.com/albums/b164/doswald/PHPBB/countdown.jpg[/flash:1c4mkso8]

Thanks, hope to hear again.

Regards,
Doswald

don't quote me on this.. but I think that is automatically set to run by your forum clock. I haven't actually played with that bit yet I am sorry...

I think he wants to insert the WORDS minutes and seconds...

Yes Dragonsys I refer to the WORDS inserted just like "Remaining Days" and "Hours".

Hope you can lead me.

Thanks

[ayasha]

for showing the words minutes and seconds do this

#
#-----[ OPEN ]------------------------------------------
#
root/language/lang_english/lang_countdown.php


#
#-----[ FIND ]------------------------------------------
#
$lang['C_days'] = 'Remaining Days:';


#
#-----[ AFTER, ADD ]------------------------------------------
#
$lang['C_days'] = 'Days';
$lang['C_hours'] = 'Hours';
$lang['C_mins'] = 'Minutes';
$lang['C_secs'] = 'Seconds';

[Kusco]

Hy, everybody.
I install this mod, every tinhg goes well, .----
Except I have no time values, do you know why?

[Michaelo]

I guess I better install it <img>