All pastes #410051 Raw Edit

Stuff

public php v1 · immutable
#410051 ·published 2007-03-26 02:19 UTC
rendered paste body
  function smarty_function_plandescription($params, &$smarty)  {	      if ($params['description'] != '') {	          echo $params['description'];	      } else {		  $query2 = "SELECT name FROM tblproductgroups WHERE id='" . $params['gid'] . "'";		  $result2 = mysql_query($query2);		  		  while ($groupname = mysql_fetch_array($result2))		    {		      $group = str_replace(" ", "",strtolower($groupname['name']));		    }                              if (isset($params['pid'])) {              $query = "SELECT name, configoption3, configoption5, configoption2, configoption4, configoption8, configoption10, configoption12, configoption14, asetupfee, monthly, quarterly, semiannual, annual FROM tblproducts WHERE id='" . $params['pid'] . "' LIMIT 1";          }                    if (isset($params['pname'])) {              $query = "SELECT name, configoption3, configoption5, configoption2, configoption4, configoption8, configoption10, configoption12, configoption14, asetupfee, monthly, quarterly, semiannual, annual FROM tblproducts WHERE name='" . $params['pname'] . "' LIMIT 1";          }                    $result = mysql_query($query);                    while ($data = mysql_fetch_array($result)) {              $name = urlencode($data["name"]);              $quota = $data["configoption3"];              $bandwidthlimit = $data["configoption5"];              $ftpacc = $data["configoption2"];              $emailacc = $data["configoption4"];              $sqldbs = $data["configoption8"];              $subdomains = $data["configoption10"];              $parkdomains = $data["configoption12"];              $addondomains = $data["configoption14"];              $asetupfee = $data["asetupfee"];              $monthly = $data["monthly"];              $quarterly = $data["quarterly"];              $semiannual = $data["semiannual"];              $annual = $data["annual"];                            if ($asetupfee == "0.00") {                  $asetupfee = "Free";              } else {                                    $asetupfee = "$" . asetupfee;              }                            if (strlen($quota) > "3") {                  $quota = round(($quota / 1000), 1) . " GB";              } else {                                    $quota = $quota . " MB";              }                            if (strlen($bandwidthlimit) > "3") {                  $bandwidthlimit = round(($bandwidthlimit / 1000), 1) . " GB";              } else {                                    $bandwidthlimit = $bandwidthlimit . " MB";              }                            $price = sprintf("%01.2f", ($annual / 12));}