Page 1 of 1

Script insallation issue

Posted: Fri Aug 07, 2009 11:46 am
by jokerboy
I recently bought and installed a classifieds script from onlinescripts.net. They are not returning email so I thought I would check here.
The site loads fine but when I go to post a classified I get the following error:


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/million/public_html/FamilyMarket/insert_product.php on line 267

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/million/public_html/FamilyMarket/insert_product.php on line 274

Warning: Cannot modify header information - headers already sent by (output started at /home/million/public_html/FamilyMarket/insert_product.php:267) in /home/million/public_html/FamilyMarket/insert_product.php on line 308

Here is the problem area:

Code: Select all

 
if(mysql_affected_rows()>0)
    {
        $id=mysql_insert_id();
    }
                        
    $freetplrow_con=mysql_fetch_array(mysql_query("select * from freetplclassified_config"));
    
    $null_char[0]=$freetplrow_con['null_char'];
    $site_root[0]=$freetplrow_con['site_root'];
    $freetplreturn_arg=($freetplreturn)?"&id=$id":'';   
    
    $rs0=mysql_fetch_array(mysql_query("select * from freetplclassified_products where id=".$id));
    $product_url=$site_root[0]."/product_desc.php?id=".$rs0["id"];
    $product_url="<a href='$product_url' target='_blank' title='Click to view product'>$product_url</a>";
 
    $login_url=$site_root[0]."/signinform.php";
    $login_url="<a href='$login_url' target='_blank' title='Click to login now'>$login_url</a>";
 
$rs1=mysql_fetch_array(mysql_query("select * from freetplclassified_members where id=".$rs0["uid"]));
and for the 308 error:

Code: Select all

header("Location: gen_confirm_mem.php?$freetplreturn_arg&errmsg=".urlencode($msg));
Here is the complete file:

Code: Select all

<?php
include_once "logincheck.php";
include_once "myconnect.php";
 
///////---------managing extra shipping
$freetplextra_shipping=-1;
if( isset($_REQUEST["freetplenable_ship"]) )
{
    if( isset($_REQUEST["freetplextra_shipping"]) )
    {
        $freetplextra_shipping=(real)$_REQUEST["freetplextra_shipping"];
    }
}
///////---------end managing extra shipping
 
$rate=mysql_fetch_array(mysql_query("select * from freetplclassified_config"));
$bold_rate=(-1)*$rate["bold_rate"];
$featured_rate=(-1)*$rate["featured_rate"];
$fp_featured_rate=(-1)*$rate["fp_featured_rate"];
$gallery_featured_rate=(-1)*$rate["gallery_featured_rate"];
$highlight_rate=(-1)*$rate["highlight_rate"];
//$item_fees=(-1)*$rate["item_fees"];
$buy_now=(-1)*$rate["buy_now"];
$additional_info="";
 
$freetplreturn=false;
$approved="new";
$freetplmailid=21;
if($rate["freetpl_prod_approval"]=="auto")
{
    $freetplreturn=true;
    $approved="yes";
    $freetplmailid=5;
}
 
$freetplcat_array=explode("_",$_REQUEST["cat1"]);       //don't mind this
$cid=$freetplcat_array[0];
 
//echo "cat1=".$_REQUEST["cat1"].", cid=$cid, cost=".$freetplcat_array[1];
$freetplq_cat="select * from freetplclassified_categories where id=$cid";
$freetplrow_cat=mysql_fetch_array(mysql_query($freetplq_cat));
 
if($rate["freetpl_same_fee"]=='yes')
    $item_cost=$rate["item_fees"];
else
    $item_cost=$freetplrow_cat["freetpl_fee"];
 
 
 
//////////////////////////////////////////
        $freetplq_t_f="select * from freetplclassified_types_fields where freetpl_type_id=$cid";
        $freetplrs_t_f=mysql_query($freetplq_t_f);
        $freetpl_field_ids='-1';
        while($freetplrow_t_f=mysql_fetch_array($freetplrs_t_f))
            $freetpl_field_ids.=','.$freetplrow_t_f["freetpl_field_id"];
 
//$field_q=mysql_query("select * from freetplclassified_additional_fields");
      $field_q=mysql_query("select * from freetplclassified_additional_fields where freetpl_id in ($freetpl_field_ids) or freetpl_common='yes'"); 
while($field=mysql_fetch_array($field_q))
{
    if(isset($_REQUEST[$field["freetpl_name"]])&&($_REQUEST[$field["freetpl_name"]]<>""))
    {
    $additional_info=($additional_info=="")?$field["freetpl_name"]."|".$_REQUEST[$field["freetpl_name"]]:$additional_info.";".$field["freetpl_name"]."|".$_REQUEST[$field["freetpl_name"]];
    }
}
//echo $additional_info; 
//////////////////////////////////////////
                        
            if (!get_magic_quotes_gpc()) 
            {
            $product_name=str_replace('$', '\$',addslashes($_REQUEST["product_name"]));
            $location=str_replace('$', '\$',addslashes($_REQUEST["location"]));
            $product_desc=str_replace('$', '\$',addslashes($_REQUEST["rte1"]));
            $country=str_replace('$', '\$',addslashes($_REQUEST["country"]));
            $state=str_replace('$', '\$',addslashes($_REQUEST["state"]));
            $other_state=str_replace('$', '\$',addslashes($_REQUEST["other_state"]));
            $additional_info=str_replace('$', '\$',addslashes($additional_info));
            }
            else
            {
            $product_name=str_replace('$', '\$',$_REQUEST["product_name"]);
            $location=str_replace('$', '\$',$_REQUEST["location"]);
            $product_desc=str_replace('$', '\$',$_REQUEST["rte1"]);
            $country=str_replace('$', '\$',$_REQUEST["country"]);
            $state=str_replace('$', '\$',$_REQUEST["state"]);
            $other_state=str_replace('$', '\$',$_REQUEST["other_state"]);
            $additional_info=str_replace('$', '\$',$additional_info);
        }
 
if($state=="")
{ $state=$other_state;}
 
//$cid=(int)$_REQUEST["cat1"];
$aucid=4;
$auction_period=(int)$_REQUEST["auction_period"];
 
$buy_price=0.0;
$paypal_id="";
if (isset($_REQUEST["buy_price"])&& ($_REQUEST["buy_price"]<>""))
{
    if (!get_magic_quotes_gpc()) 
    {
        $buy_price=str_replace('$', '\$',addslashes($_REQUEST["buy_price"]));
    }
    else
    {
        $buy_price=str_replace('$', '\$',$_REQUEST["buy_price"]);
    }
    $buy_price=(real)$buy_price;
}
                        
 
if (isset($_REQUEST["paypal_id"])&& ($_REQUEST["paypal_id"]<>""))
{
    if (!get_magic_quotes_gpc()) 
    {
        $paypal_id=str_replace('$', '\$',addslashes($_REQUEST["paypal_id"]));
    }
    else
    {
        $paypal_id=str_replace('$', '\$',$_REQUEST["paypal_id"]);
    }
}
 
$bold="no";
$featured="no";
$fp_featured="no";
$gallery_featured="no";
$highlight="no";
$expenditure=0;
 
if($item_cost>0)
{
mysql_query("insert into freetplclassified_transactions (uid,amount,description,date_submitted) values (".$_SESSION["freetpl_clsplus_userid"].",-$item_cost,'Posted classified ''$product_name''','".date("YmdHis",time())."')");
}
 
$balance=mysql_fetch_array(mysql_query("select sum(amount) as total from freetplclassified_transactions where uid=".$_SESSION["freetpl_clsplus_userid"]." group by uid"));
$total=$balance["total"];
 
if(isset($_REQUEST["radio"]) && $_REQUEST["radio"]<>"")
{
$counter_id=$_REQUEST["radio"];
}
else
{
$counter_id=0;
}
                        
if (isset($_REQUEST["bold"])&&$_REQUEST["bold"]<>"")
{
$expenditure+=$rate["bold_rate"];
}
 
if (isset($_REQUEST["featured"])&&$_REQUEST["featured"]<>"")
{
$expenditure+=$rate["featured_rate"];
}
 
if (isset($_REQUEST["fp_featured"])&&$_REQUEST["fp_featured"]<>"")
{
$expenditure+=$rate["fp_featured_rate"];
}
 
if (isset($_REQUEST["gallery_featured"])&&$_REQUEST["gallery_featured"]<>"")
{
$expenditure+=$rate["gallery_featured_rate"];
}
if(($buy_price>0)&&($paypal_id<>""))
{
$expenditure+=$rate["buy_now"];
}
                        
if (isset($_REQUEST["highlight"])&&$_REQUEST["highlight"]<>"")
{
$expenditure+=$rate["highlight_rate"];
}
 
if(($expenditure<=$total) || ($expenditure<=0))
{
if (isset($_REQUEST["bold"])&&$_REQUEST["bold"]<>"")
{
if($rate["bold_rate"]>0)
{
mysql_query("insert into freetplclassified_transactions (uid,amount,description,date_submitted) values (".$_SESSION["freetpl_clsplus_userid"].",$bold_rate,'Made classifed ''$product_name'' to appear as Bold','".date("YmdHis",time())."')");
}
$bold="yes";
}
 
if (isset($_REQUEST["featured"])&&$_REQUEST["featured"]<>"")
{
$featured="yes";
if($rate["featured_rate"]>0)
{
mysql_query("insert into freetplclassified_transactions (uid,amount,description,date_submitted) values (".$_SESSION["freetpl_clsplus_userid"].",$featured_rate,'Made classified ''$product_name'' to appear as Featured','".date("YmdHis",time())."')");
}
}
                        
if (isset($_REQUEST["fp_featured"])&&$_REQUEST["fp_featured"]<>"")
{
$fp_featured="yes";
if($rate["fp_featured_rate"]>0)
{
mysql_query("insert into freetplclassified_transactions (uid,amount,description,date_submitted) values (".$_SESSION["freetpl_clsplus_userid"].",$fp_featured_rate,'Made classified ''$product_name'' to appear as Featured on Front Page','".date("YmdHis",time())."')");
}
}
 
if (isset($_REQUEST["gallery_featured"])&&$_REQUEST["gallery_featured"]<>"")
{
$gallery_featured="yes";
if($rate["gallery_featured_rate"]>0)
{
mysql_query("insert into freetplclassified_transactions (uid,amount,description,date_submitted) values (".$_SESSION["freetpl_clsplus_userid"].",$gallery_featured_rate,'Made classified ''$product_name'' to appear as Featured in Gallery ','".date("YmdHis",time())."')");
}
}
 
if (isset($_REQUEST["highlight"])&&$_REQUEST["highlight"]<>"")
{
$highlight="yes";
if($rate["highlight_rate"]>0)
{
mysql_query("insert into freetplclassified_transactions (uid,amount,description,date_submitted) values (".$_SESSION["freetpl_clsplus_userid"].",$highlight_rate,'Made classified ''$product_name'' to appear as Highlighted','".date("YmdHis",time())."')");
}
}
 
if(($buy_price>0)&&($paypal_id<>""))
{
if($rate["buy_now"]>0)
{
mysql_query("insert into freetplclassified_transactions (uid,amount,description,date_submitted) values (".$_SESSION["freetpl_clsplus_userid"].",$buy_now,'Enabled buynow option for classified ''$product_name''','".date("YmdHis",time())."')");
}
}
 
 
    $msg="Your classified has been added ";
    if($approved<>"yes")
    {
    $msg.="and sent for Admin approval";
    }
}
else
{
    $msg="Your classified has been added without any listing feature due to low balance.";
    {
    $msg.="Classified has been sent for Admin approval";
    }
}
$sql= "INSERT INTO freetplclassified_products (product_name,cid,aucid,location,auction_period,featured,approved,country,product_desc,date_submitted,uid,no_of_views,state,status,winner,bold,highlight,fp_featured,gallery_featured,paypal_id,counter_id,additional_info,buy_price, freetplextra_shipping) 
VALUES('$product_name','$cid','$aucid','$location','$auction_period','$featured','$approved',$country,'$product_desc','" . date("YmdHis",time()). "'," .$_SESSION["freetpl_clsplus_userid"].",0,'$state','open','0','$bold','$highlight','$fp_featured','$gallery_featured','$paypal_id',$counter_id,'$additional_info',$buy_price, $freetplextra_shipping)";
//echo "$sql<br>";
mysql_query($sql);
 
 
////////MAIL TO SaLLER//////////////////////
              
 
if(mysql_affected_rows()>0)
    {
        $id=mysql_insert_id();
    }
                        
    $freetplrow_con=mysql_fetch_array(mysql_query("select * from freetplclassified_config"));
    
    $null_char[0]=$freetplrow_con['null_char'];
    $site_root[0]=$freetplrow_con['site_root'];
    $freetplreturn_arg=($freetplreturn)?"&id=$id":'';   
    
    $rs0=mysql_fetch_array(mysql_query("select * from freetplclassified_products where id=".$id));
    $product_url=$site_root[0]."/product_desc.php?id=".$rs0["id"];
    $product_url="<a href='$product_url' target='_blank' title='Click to view product'>$product_url</a>";
 
    $login_url=$site_root[0]."/signinform.php";
    $login_url="<a href='$login_url' target='_blank' title='Click to login now'>$login_url</a>";
 
$rs1=mysql_fetch_array(mysql_query("select * from freetplclassified_members where id=".$rs0["uid"]));
 
//Reads email to be sebt
$sql = "SELECT * FROM freetplclassified_mails where mailid=$freetplmailid" ;
$rs_query=mysql_query($sql);
 
if ( $rs=mysql_fetch_array($rs_query)  )
  {
             $from =$rs["fromid"];
//           $to = $rs1["email"];
            $to=($freetplmailid==5)?$rs1["email"]:$rate["admin_email"];
             $subject =$rs["subject"];
             $header="From:" . $from . "\r\n" ."Reply-To:". $from  ;
        if($rs["freetpl_html_format"]=="yes")
        {
            $header .= "\r\nMIME-Version: 1.0";
            $header .= "\r\nContent-type: text/html; charset=iso-8859-1\r\n";
        }
 
     $body=str_replace("%fname%",$rs1["fname"],str_replace("%lname%",$rs1["lname"],str_replace("%email%",$rs1["email"],str_replace("%username%",$rs1["username"],str_replace("%password%",$null_char[0],str_replace("%loginurl%",$login_url,$rs["mail"])))))) ;
     
     $body=str_replace("%productname%",$rs0["product_name"],str_replace("%producturl%",$product_url,str_replace("%noofbids%",$null_char[0],str_replace("%currentbid%",$null_char[0],str_replace("%bidder_username%",$null_char[0],str_replace("%expired_date%",$null_char[0],$body))))));
      
     $body=str_replace("%message_text%",$null_char[0],str_replace("%message_title%",$null_char[0],str_replace("%sender_username%",$null_char[0],str_replace("%message_time%",$null_char[0],str_replace("%message_date%",$null_char[0],$body)))));
     
                        
     @mail($to,$subject,$body,$header);
 
//  echo "--from:-$from----to:-$to---sub:-$subject----head:-$header----";
//  echo "<pre>$body</pre>";
 
  }
 
 
header("Location: gen_confirm_mem.php?$freetplreturn_arg&errmsg=".urlencode($msg));
 
?>
I am at a loss and getting no response from onlinescripts.net.
Thanks, JB