Clan Adverts

Sponsors

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme
Mech Warrior Online Xtreme Theme

User Box

Anonymous
38.107.179.218
Nickname:

Password:

Security Code
Security Code
Type Security Code


PND Downloads Feed

Phpnuke Downloads
How to Delete or Reset yo...
How to Delete or Reset your PHPNuke Admin Account
Lost your admin password ?  Cant login to your admin account ? This s...
Back Online & Stuff
Back Online & Stuff
Look at us with our nifty website back up and running… Seriously...
How to edit the admins in...
How to edit the admins in the forums
Here is a way to make someone admin in your forums on your Evo site. I...
Demo Splash Screen
Demo Splash Screen
Ped @ Clan Themes has released a simple splash screen entrance hack. ...
Free Phpnuke Business The...
Free Phpnuke Business Theme 6
This is the 6th Business theme for Phpnuke that Clan Themes has releas...
Tricked Out Slider
Tricked Out Slider
We have seen some great new things come out of Tricked Out News and th...

Custom Work

PHP Nuke Custom Work

www.clanthemes.com :: View topic - Advanced countdown bbtonuke mod sql prob
Advanced countdown bbtonuke mod sql prob

5 Replies / 1056 Views
Post new topic   Reply to topic  

   www.clanthemes.com Forum Index » Hacks n Mods

View previous topic :: View next topic

TB_DFW
Reputation: 503.3 Add RepSubtract Rep
Local time: 4:05 PM

australia.gif

 Spawn Killer
Spawn Killer

0.02 posts per day
Medals: 0
Joined: Apr 09, 2007
Last Visit: 22 Apr 2011
Posts: 30
Points: 1843 
Post Advanced countdown bbtonuke mod sql prob Posted: Sat Mar 26, 2011 12:09 pm
Shop Purchases:Multi Gaming (Warrior) Theme
Guys I'm having an issue installing the mod into MySQL5.x
Tried running the auto install script which failed & when I go to install it manually into the sql Db I get the following error:
#1067 - Invalid default value for 'event_stop'
The sql code is:
Code:
CREATE TABLE nuke_countdown (
  img_left varchar(255) NOT NULL default '',
  img_right varchar(255) NOT NULL default '',
  title varchar(100) NOT NULL default '',
  description varchar(100) NOT NULL default '',
  event_text varchar(200) NOT NULL default '',
  event_stop int (11) NOT NULL default '',
  enable_index tinyint (1) default '0',
  enable_portal tinyint (1) default '0',
  full_display tinyint (1) default '1'
) TYPE=MyISAM;


Can anyone pls fix this so it works?

Thx in advance.
 

 
View user's profileSend private message Reply with quote

DreAdeDcoRpSE
Reputation: 2572.3 Add RepSubtract Rep
votes: 28
Local time: 1:05 AM
Location: Back of your Mind
usa.gif

 Site Admin
Site Admin

1.36 posts per day
Medals: 3 (View more...)
Super Dedicated User (Amount: 1)
Forums Moderator
Forums Moderator
Joined: Sep 22, 2007
Last Visit: 26 May 2012
Posts: 2331
Points: 136112 
Post Re: Advanced countdown bbtonuke mod sql prob Posted: Sat Mar 26, 2011 2:00 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 ·  · Modern Warfare 3 Xtreme Theme
try this...

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


Fields of type integer cannot contain string values. Although I don't know if this will have adverse affects elsewhere.
 

 
View user's profileSend private messageVisit poster's website Reply with quote

TB_DFW
Reputation: 503.3 Add RepSubtract Rep
Local time: 4:05 PM

australia.gif

 Spawn Killer
Spawn Killer

0.02 posts per day
Medals: 0
Joined: Apr 09, 2007
Last Visit: 22 Apr 2011
Posts: 30
Points: 1843 
Post Advanced countdown bbtonuke mod sql prob Posted: Sat Mar 26, 2011 3:50 pm
Shop Purchases:Multi Gaming (Warrior) Theme
Cheers m8.. that worked.. issue now is that the CT-RN Black theme overall_header.tpl doesn't have the correct code, but I have added it onto the end of what's there:

Code:
<!-- BEGIN switch_enable_pm_popup -->

<script language="Javascript" type="text/javascript">

<!--

   if ( {PRIVATE_MESSAGE_NEW_FLAG} )

   {

      window.open('{U_PRIVATEMSGS_POPUP}', '_phpbbprivmsg', 'HEIGHT=225,resizable=yes,WIDTH=400');;

   }

//-->

</script>

<!-- END switch_enable_pm_popup -->



<a name="top"></a>



<div id="menua">

  <table style="width: 980px" cellspacing="0" cellpadding="0">

  <tr>

     <td style="width: 100px; height: 30px">

     <div class="menup"><a href="modules.php?name=Forums">Forums Home</a></div></td>

     <td style="width: 100px; height: 30px">

     <div class="menup"><a href="modules.php?name=Forums&amp;file=search">Search</a></div></td>

     <td style="width: 100px; height: 30px">

     <div class="menup"><a href="modules.php?name=Members_List">Members</a></div></td>

     <td style="width: 100px; height: 30px">

     <div class="menup"><a href="modules.php?name=Forums&amp;file=groupcp">User Groups</a></div></td>

     <td style="width: 100px; height: 30px">

     <div class="menup"><a href="modules.php?name=Forums&amp;file=profile&amp;mode=editprofile">Profile</a></div></td>

     <td style="width: 100px; height: 30px">

     <div class="menup"><a href="modules.php?name=Private_Messages">Messages</a></div></td>

     <td style="width: 100px; height: 30px">

     <div class="menup"><a href="modules.php?name=Forums&amp;file=viewonline">Who's Online</a></div></td>

     <td style="width: 100px; height: 30px">

     <div class="menup"><a href="modules.php?name=Forums&amp;file=faq">FAQ</a></div></td>

  </tr>

  </table>

 </div>
 <p class="clear" />
<!-- Everything after this is the countdown mod -->
  </head>
 <body bgcolor="{T_BODY_BGCOLOR}" text="{T_BODY_TEXT}" link="{T_BODY_LINK}" vlink="{T_BODY_VLINK}" {COUNTDOWN_ON}/>

 
<!-- BEGIN switch_countdown_on -->
<table align="center" width="100%" cellspacing="0" cellpadding="5" border="0" class="bodyline">
  <tr>
     <th align="center" colspan="3" class="thtop"><span class="thhead">{TITLE}</span></th>
  </tr>
  <tr>
<form name="clock">
   <td align="left" valign="center" width="20%">{IMG_LEFT}</td>
   <td align="center" width="60%">
   {L_DAYS} <input name="days" size=4 style="border: 0px">
   <span style="display: {FULL_DISPLAY};">-  
   <input name="hours" size=2 style="border: 0px"> :
   <input name="mins" size=2 style="border: 0px"> :
   <input name="secs" size=2 style="border: 0px">
   </span><br /><br /><span class="nav">{DESC}</span></td>
   <td align="right" valign="center" width="20%">{IMG_RIGHT}</td>
  </tr>
</form>
</table>
<!-- END switch_countdown_on -->


It loads the boxes etc, but there is no numbers showing in the countdown boxes:
Image Has Been Resized, Click To Enlarge.


All the other coding is correct, just the Overall_header.tpl.. so is there any way of getting it working?
 

 
View user's profileSend private message Reply with quote


TB_DFW
Reputation: 503.3 Add RepSubtract Rep
Local time: 4:05 PM

australia.gif

 Spawn Killer
Spawn Killer

0.02 posts per day
Medals: 0
Joined: Apr 09, 2007
Last Visit: 22 Apr 2011
Posts: 30
Points: 1843 
Post Re: Advanced countdown bbtonuke mod sql prob Posted: Sun Mar 27, 2011 1:47 pm
Shop Purchases:Multi Gaming (Warrior) Theme
Bumping
 

 
View user's profileSend private message Reply with quote

DreAdeDcoRpSE
Reputation: 2572.3 Add RepSubtract Rep
votes: 28
Local time: 1:05 AM
Location: Back of your Mind
usa.gif

 Site Admin
Site Admin

1.36 posts per day
Medals: 3 (View more...)
Site Supporter (Amount: 1)
Forums Moderator
Forums Moderator
Joined: Sep 22, 2007
Last Visit: 26 May 2012
Posts: 2331
Points: 136112 
Post Re: Advanced countdown bbtonuke mod sql prob Posted: Sun Mar 27, 2011 2:28 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0 ·  · Modern Warfare 3 Xtreme Theme
I never used this mod, so I don't know. but I am wondering, do you have it configured in the admin panel where you set in the info it needed, like what its counting down to?
 

 
View user's profileSend private messageVisit poster's website Reply with quote

TB_DFW
Reputation: 503.3 Add RepSubtract Rep
Local time: 4:05 PM

australia.gif

 Spawn Killer
Spawn Killer

0.02 posts per day
Medals: 0
Joined: Apr 09, 2007
Last Visit: 22 Apr 2011
Posts: 30
Points: 1843 
Post Advanced countdown bbtonuke mod sql prob Posted: Mon Mar 28, 2011 1:17 am
Shop Purchases:Multi Gaming (Warrior) Theme
It's all done via the forums admin panel which is pretty straight forward to use / setup, but it's just not showing the actual countdown numbers
 

 
View user's profileSend private message Reply with quote

Post new topic   Reply to topic  
   www.clanthemes.com Forum Index » Hacks n Mods


 
5 Replies / 1056 Views
Page 1 of 1
All times are GMT
Display posts from previous:   
 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
 

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke