No more subscription option after cbnya install

New Member Joined: Sep 06, 2006 Posts: 11

Hi after installing cbnya 750_442 I have seem to have lost my subscription option in my admin and my your account. I neeeeeeeeeeeeeeeeeed them back who can tell me how or what i need to do !!!!!!!!!

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Which version / distribution of Nuke are you using? Did you have a mod installed that supported subscriptions? If so, installing CNB YA may have wiped that out.

Posted: Wed Sep 27, 2006 5:21 pm

I run rwsRavenNuke76_v2.02.02_FULL and use a custom page for subscriptions. nothing is wiped out i have checked that.
After installing CNB YA I did not even had the options in my edit user to add subscription to a user.
I had to exclude the version line like this to even show the option,

//if ($Version_Num > 7.0) {
$yacontent = "";
$subnum = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_subscriptions WHERE userid='$chng_uid'"));
if ($subnum == 0) {
$yacontent .= "<tr><td bgcolor='$bgcolor2'>"._SUBUSERASK.":</td><td><input type='radio' name='subscription' value='1'> "._YES."   <input type='radio' name='subscription' value='0' checked> "._NO."</td></tr>";
$yacontent .= "<tr><td bgcolor='$bgcolor2'>"._SUBPERIOD.":</td><td><select name='subscription_expire'>";
$yacontent .= "<option value='0' selected>"._NONE."</option>";
$yacontent .= "<option value='1'>1 "._YEAR."</option>";
$yacontent .= "<option value='2'>2 "._YEARS."</option>";
$yacontent .= "<option value='3'>3 "._YEARS."</option>";
$yacontent .= "<option value='4'>4 "._YEARS."</option>";
$yacontent .= "<option value='5'>5 "._YEARS."</option>";
$yacontent .= "<option value='6'>6 "._YEARS."</option>";
$yacontent .= "<option value='7'>7 "._YEARS."</option>";
$yacontent .= "<option value='8'>8 "._YEARS."</option>";
$yacontent .= "<option value='9'>9 "._YEARS."</option>";
$yacontent .= "<option value='10'>10 "._YEARS."</option>";
$yacontent .= "</select><input type='hidden' name='reason' value='0'></td></tr>";
} elseif ($subnum == 1) {
$yacontent .= "<tr><td bgcolor='$bgcolor2'>"._UNSUBUSER.":</td><td><input type='radio' name='subscription' value='0'> "._YES."   <input type='radio' name='subscription' value='1' checked> "._NO."</td></tr>";
$yacontent .= "<tr><td bgcolor='$bgcolor2'>"._ADDSUBPERIOD.":</td><td><select name='subscription_expire'>";
$yacontent .= "<option value='0' selected>"._NONE."</option>";
$yacontent .= "<option value='1'>1 "._YEAR."</option>";
$yacontent .= "<option value='2'>2 "._YEARS."</option>";
$yacontent .= "<option value='3'>3 "._YEARS."</option>";
$yacontent .= "<option value='4'>4 "._YEARS."</option>";
$yacontent .= "<option value='5'>5 "._YEARS."</option>";
$yacontent .= "<option value='6'>6 "._YEARS."</option>";
$yacontent .= "<option value='7'>7 "._YEARS."</option>";
$yacontent .= "<option value='8'>8 "._YEARS."</option>";
$yacontent .= "<option value='9'>9 "._YEARS."</option>";
$yacontent .= "<option value='10'>10 "._YEARS."</option>";
$yacontent .= "</select></td></tr>";
$yacontent .= "<tr><td bgcolor='$bgcolor2'>"._ADMSUBEXPIREIN."</td><td>";
$row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_subscriptions WHERE userid='$chng_uid'"));
$diff = $row['subscription_expire']-time();
$yearDiff = floor($diff/60/60/24/365);
$diff -= $yearDiff*60*60*24*365;
if ($yearDiff < 1) {
$diff = $row['subscription_expire']-time();
}
$daysDiff = floor($diff/60/60/24);
$diff -= $daysDiff*60*60*24;
$hrsDiff = floor($diff/60/60);
$diff -= $hrsDiff*60*60;
$minsDiff = floor($diff/60);
$diff -= $minsDiff*60;
$secsDiff = $diff;
if ($yearDiff < 1) {
$rest = "$daysDiff "._SBDAYS.", $hrsDiff "._SBHOURS.", $minsDiff "._SBMINUTES.", $secsDiff "._SBSECONDS."";
} elseif ($yearDiff == 1) {
$rest = "$yearDiff "._SBYEAR.", $daysDiff "._SBDAYS.", $hrsDiff "._SBHOURS.", $minsDiff "._SBMINUTES.", $secsDiff "._SBSECONDS."";
} elseif ($yearDiff > 1) {
$rest = "$yearDiff "._SBYEARS.", $daysDiff "._SBDAYS.", $hrsDiff "._SBHOURS.", $minsDiff "._SBMINUTES.", $secsDiff "._SBSECONDS."";
}
$yacontent .= "<font color='#FF0000'>$rest</font></td></tr>";
$yacontent .= "<tr><td bgcolor='$bgcolor2' valign='top'>"._SUBREASON."</td><td><textarea name='reason' cols='60' rows='10'></textarea></td></tr>";
}
echo "$yacontent";
//}

I think no query is send to my DB