PHP - Can Anyone See What Is Wrong With This Script?

I am querying...

$sql  = "SELECT `messages_inbox`.`message_id`, `users`.`firstname`, `users`.`lastname`, `users`.`username` AS `from`, '${user_info['username']}' AS `to`, `subject`, LENGTH(`files`) AS `len`, 'inbox' AS `box`, DATE_FORMAT(`messages_inbox`.`time` ,'%T %D-%M-%Y') AS `time` ";
   
$sql .= "FROM `messages_inbox` INNER JOIN `users` ON `messages_inbox`.`from_id` = `users`.`id` WHERE `to_id` = ${user_info['uid']} AND `messages_inbox`.`deleted` = 0 ORDER BY `messages_inbox`.`message_id` DESC";

and I am trying to output

$displayName = ucwords("${message['firstname']} ${message['lastname']}");

by using

$messages = pm_fetch_all($_GET['box']);

I know my fetch works but for some reason firstname and lastname are only returning the logged in users first name and last name, not the person who sent the message.

Hi everyone!

I've been working on a php script to replace links that contain a query with direct links to the files they would redirect to.

Hi i have this upload script which works fine it uploads image to a specified folder and sends the the details to the database.
but now i am trying to instead make a modify script which is Update set so i tried to change insert to update but didnt work can someone help me out please
this my insert image script which works fine but want to change to modify instead
Code: [Select]
<?php
mysql_connect("localhost", "root", "") or die(mysql_error()) ;
mysql_select_db("upload") or die(mysql_error()) ;

// my file the name of the input area on the form type is the extension of the file
//echo $_FILES["myfile"]["type"];

//myfile is the name of the input area on the form 
$name = $_FILES["image"] ["name"]; // name of the file
$type = $_FILES["image"]["type"]; //type of the file
$size = $_FILES["image"]["size"]; //the size of the file
$temp = $_FILES["image"]["tmp_name"];//temporary file location when click upload it temporary stores on the computer and gives it a temporary name
$error =array(); // this an empty array where you can then call on all of the error messages
$allowed_exts = array('jpg', 'jpeg', 'png', 'gif'); // array with the following extension name values
$image_type = array('image/jpg', 'image/jpeg', 'image/png', 'image/gif'); // array with the following image type values
$location = 'images/'; //location of the file or directory where the file will be stored
$appendic_name = "news".$name;//this append the word [news] before the name so the image would be news[nameofimage].gif

// substr counts the number of carachters and then you the specify how how many you letters you want to cut off from the beginning of the word example drivers.jpg it would cut off dri, and would display vers.jpg
//echo $extension = substr($name, 3);

//using both substr and strpos, strpos it will delete anything before the dot in this case it finds the dot on the $name file deletes and + 1 says read after the last letter you delete because you want to display the letters after the dot. if remove the +1 it will display .gif which what we want is just gif
$extension = strtolower(substr($name, strpos ($name, '.') +1));//strlower turn the extension non capital in case extension is capital example JPG will strtolower will make jpg
// another way of doing is with explode
// $image_ext strtolower(end(explode('.',$name))); will explode from where you want in this case from the dot adn end will display from the end after the explode

$myfile = $_POST["myfile"];

     if (isset($image)) // if you choose a file name do the if bellow
       {
       
       // if extension is not equal to any of the variables in the array $allowed_exts error appears
        if(in_array($extension, $allowed_exts) === false )
       {
         $error[] = 'Extension not allowed! gif, jpg, jpeg, png only<br />'; // if no errror read next if line
       }
        // if file type is not equal to any of the variables in array $image_type error appears
        if(in_array($type, $image_type) === false)
       {
          $error[] = 'Type of file not allowed! only images allowed<br />';     
       }
       
        // if file bigger than the number bellow error message
        if($size > 2097152)
       {
          $error[] = 'File size must be under 2MB!';     
       }
       
       // check if  folder exist in the server
        if(!file_exists ($location))
       {
          $error[] = 'No directory ' . $location. ' on the server Please create a folder ' .$location;     
       }
            
     }
     // if no error found do the move upload function
       if (empty($error)){
           if (move_uploaded_file($temp, $location .$appendic_name))
           {
             // insert data into database first are the field name teh values are the variables you want to insert into those fields appendic is the new name of the image
mysql_query("INSERT INTO image (myfile ,image)
 VALUES ('$myfile', '$appendic_name')") ;
           exit();
           }
         }
       else
          {
        foreach ($error as $error)
           {
               echo $error;
           }
        }
      
     
  
//echo $type;
?>

I'm having trouble echoing $year in my script. Listed below is the script, just below ,$result = mysql_query("SELECT * FROM $dbname WHERE class LIKE '%$search%'") or die(mysql_error());, in the script I try to echo $year. It doesn't show up in the table on the webpage. Everything else works fine. Any help wold be appreciated greatly. Thanks in advance.



<?php
include 'config2.php';

$search=$_GET["search"];

// Connect to server and select database.
mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect");
mysql_select_db("vetman")or die("cannot select DB");


$result = mysql_query("SELECT * FROM $dbname WHERE class LIKE '%$search%'") or die(mysql_error());
// store the record of the "" table into $row
//$current = '';
echo "<table align=center border=1>";
echo "<br>";
echo "<tr>";
echo "<td align=center>";
?>
<div style="float: center;"><a><h1><?php echo $year; ?></h1></a></div>


<?php
echo "</td>";
echo "</tr>";
echo "</table>";


// keeps getting the next row until there are no more to get
if($result && mysql_num_rows($result) > 0)

{
    $i = 0;
    $max_columns = 2;
    echo "<table align=center>";
echo "<br>";
    while($row = mysql_fetch_array($result))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)

          echo "<tr>";

          echo "<td align=center>";
          ?>
          <div style="float: left;">
          <div><img src="<?php echo $image1; ?>"></div>

  </div>


          <?php
          echo "</td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
       }  // end if
   } // end while
} // end if results

// clean up table - makes your code valid!
if($i > 0)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";
   echo '</tr>';
}
mysql_close();
 ?>
</table>

hey guys im really just after a bit of help/information on 2 things (hope its in the right forum).   1. basically I'm wanting to make payments from one account to another online...like paypal does...im wondering what I would need to do to be able to do this if anyone can shine some light please?   2.as seen on google you type in a query in the search bar and it generates sentences/keywords from a database   example:   so if product "chair" was in the database whilst typing "ch" it would show "chair" for a possible match   I know it would in tale sql & json but im after a good tutorial/script of some sort.   if anyone can help with some information/sites it would be much appreciated.   Thank you

I'm trying to use this script known as SimpleImage.php that can be found here <a href="http://www.white-hat-web-design.co.uk/articles/php-image-resizing.php">link</a> I'm trying to include what is on the bottom of the page to my existing script can anyone help me I've tried several ways but its not working.
Code: [Select]
<?php 
session_start();
error_reporting(E_ALL);
ini_set('display_errors','On');

//error_reporting(E_ALL); 


// image upload folder
    $image_folder = 'images/classified/'; 
// fieldnames in form
$all_file_fields = array('image1', 'image2' ,'image3', 'image4');
// allowed filetypes
$file_types = array('jpg','gif','png');
// max filesize 5mb
$max_size = 5000000;
//echo'<pre>';print_r($_FILES);exit;

$time = time();
$count = 1;

foreach($all_file_fields as $fieldname){ 
if($_FILES[$fieldname]['name'] != ''){

$type = substr($_FILES[$fieldname]['name'], -3, 3);

// check filetype
if(in_array(strtolower($type), $file_types)){

//check filesize
if($_FILES[$fieldname]['size']>$max_size){
$error = "File too big. Max filesize is ".$max_size." MB";

}else{

// new filename
$filename = str_replace(' ','',$myusername).'_'.$time.'_'.$count.'.'.$type;

// move/upload file
$target_path = $image_folder.basename($filename);
move_uploaded_file($_FILES[$fieldname]['tmp_name'], $target_path);

//save array with filenames
$images[$count] = $image_folder.$filename;
$count = $count+1;

}//end if

}else{ $error = "Please use jpg, gif, png files";

}//end if
}//end if
}//end foreach



if($error != ''){ echo $error;
}else{


/* --------------------------------------------------------------------------------------------------
SAVE TO DATABASE ------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------- */
?>

Hello,

I stored a fsockopen function in a separate "called.php" file, in order to run it as another thread when it needs.
The called script should return results to the "master.php" script.
I'm able to run the script to get the socket working, and I'm able to get results from the called script. I tried for hours but I can't do the twice both 

My master.php script (with socket working):

Code: [Select]
<?php
$command = "(/mnt/opt/www/called.php $_SERVER[REMOTE_ADDR] &) > /dev/null";
$result = exec($command);
echo ("result = $result\r\n");
?>

and my called.php script
Code: [Select]
#!/mnt/opt/usr/bin/php-cli -q
<?php
$device = $_SERVER['argv'][1];
$port = "8080";
$fp = fsockopen($device, $port, $errno, $errstr, 5);
fwrite($fp, "test");
fclose($fp);
echo ("normal end of the called.php script");
?>

In the master script, if I use
Code: [Select]
$command = "(/mnt/opt/www/called.php $_SERVER[REMOTE_ADDR] &) > /dev/null";
the socket works, but I have nothing in $result
(note also that I don't anderstand why the ( ... &) are needed!?)

and if I use
Code: [Select]
$command = "/mnt/opt/www/called.php $_SERVER[REMOTE_ADDR]";
I have the correct text "normal end of the called.php script" in $result but the socket connection is not performed (no errors in php logs)

Could you help me to find a way to let's work the two features correctly together?
Thank you.

I am trying to create a log in page but all that comes up is Please enter a username and password

<?php

session_start () ;

$username = $_POST ['username'] ;
$password = $_POST ['passowrd'] ;

if ($username&&$password) 
{

define ('DB_HOST' , 'localhost') ;
define ('DB_USER' , 'root')  or die ("Could not connect!") ;
define ('DB_PASSWORD', "")  or die ("Could not find DB!") ;
define ('DB_DATABASE', 'joke') ; 

}
else
   die ("Please enter a username and password") ;
$query = mysql_query ("SELECT * FROM Joke WHERE username = '$username'") ;
$numrow = mysql_num_rows ($query) ;

if ($numrows!=0)
{	
	//code to login

   While ($row= mysql_fetch_assoc($query))
   {
   		$dbusername = $row ['username'] ;
   		$dbusername = $row ['password'] ;
   }	

   //check if they match

   if ($username==$dbusername&&$password==$dbpassword)
   {
   		echo "You're inn! <a href=member.php> Click here to enter member page" ;
   		$_SESSION['username']=$dbusername ;
   	}
   		else
   			echo "incorrect password!" ;
}
else
	die("That user does'nt exist") ;
echo $numrows;

?>

Can someone please take a look and see if you can point out what error i made. Everything on the form side is functioning except it doesn't seem to post since its looping back to the form rather than the redirect. Also, within the actual form table, i had to change the section that says Business Hours from a textarea because I couldn't get it to echo the data from the field in the database. Any ideas on that would be greatly appreciated. Sorry if its a bit sloppy, I'm no expert.

Code: [Select]
<?php
   include "config.php";
mysql_connect("$dbhost","$dbusr","$dbpass"); 
mysql_select_db("$dbname");
            
session_start();

if (isset($_SESSION['user'])) {
   
      } else {
    header ('location: login.php');
}

 // creates the edit record form
 // since this form is used multiple times in this file, I have made it a function that is easily reusable
 function renderForm($id, $username, $location, $address, $city, $zip, $county, $website, $map, $email, $phone, $bhours, $ptimes, $pspecials, $vspecials, $error)
 {

echo "<center><strong>Edit Location Information</strong></center>";
 
 // if there are any errors, display them
 if ($error != '')
 {
 echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>';
 }

 echo "
<center>

    <form action='' method='POST'>
   
      <table border='0' frame='box'>
            <tr>
              <td width='96'><div align='right'>Venue ID:</div></td>
              <td colspan='2'><input type='hidden' name='id' value='$id'>$id</td>
            </tr>
            <tr>
                <td><div align='right'><font size='2' face='arial'>Username:</font></div></td>
                <td colspan='2'><input type='text' name='r_username' value='$username'></td>
            </tr>
         <tr>
           <td>Business Name:</td>
           <td colspan='2'><input type='text' name='r_location' value='$location'></td>
        </tr>
         <tr>
                <td><div align='right'><font size='2' face='arial'>Address:</font></div></td>
                <td colspan='2'><input type='text' name='r_address' value='$address'></td>
            </tr>
         <tr>
           <td><div align='right'>City/State:</div></td>
           <td><input type='text' name='r_city' value='$city'></td>
           <td>Format = City, St</td>
         </tr>
         <tr>
                <td><div align='right'><font size='2' face='arial'>Zip:</font></div></td>
                <td colspan='2'><input type='text' name='r_zip'value='$zip'></td>
            </tr>
            <tr>
              <td><div align='right'>County:</div></td>
              <td colspan='2'><input type='text' name='r_county'value='$county'></td>
            </tr>
            <tr>
              <td><div align='right'>Website:</div></td>
              <td colspan='2'><input type='text' name='r_website' value='$website'></td>
            </tr>
            <tr>
              <td><div align='right'>Directions:</div></td>
              <td colspan='2'><input type='text' name='r_map' value='$map'></td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='arial'>E-mail:</font></div></td>
              <td colspan='2'><input type='text' name='r_email' value='$email'></td>
            </tr>
            <tr>
                <td><div align='right'><font size='2' face='arial'>Phone #::</font></div></td>
                <td colspan='2'><input type='text' name='r_phone' value='$phone'></td>
            </tr>
            <tr>
                <td height='80'><div align='right'><font size='2' face='arial'>Business Hours:</font></div></td>
                <td width='287'><input type='text' name='r_bhours' cols='45' rows='3' value='$bhours'></td>
                <td width='244'><p>**You must enter &lt;/br&gt; after each line to display in rows:</p>
                <p>Mon - Fri 11am to 10pm&lt;/br&gt;</p>
                <p>Sat - Sun 1PM to 3am&lt;/br&gt;</p></td>
            </tr>
            <tr>
                <td><div align='right'><font size='2' face='arial'>Poker Times:</font></div></td>
                <td colspan='2'><input type='text' name='r_ptimes' value='$ptimes'></td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='arial'>Poker Specials:</font></div></td>
              <td><input type='text' name='r_pspecials' value='$pspecials'></td>
              <td>&nbsp;</td>
            </tr>
            <tr>
              <td><div align='right'><font size='2' face='arial'>Location Specials:</font></div></td>
              <td><input type'text' name='r_vspecials' cols='45' rows='3' value='$vspecials'></td>
              <td><p>**You must enter &lt;/br&gt; after each line to display in rows:</p>
                <p>Mon - $0.10 Wings&lt;/br&gt;</p>
              <p>Fri - 2 for 1 Happy hour&lt;/br&gt;</p></td>
            </tr>
            <tr>
                <td></td>
                <td colspan='2'><div align='center'><font size='2' face='arial'><a href='edituser.php'>Cancel</a> - </font><input type='submit' value='Update Location'></div></td>
            </tr>
        </table>
</form>
    
</center>
";
 }

 // check if the form has been submitted. If it has, process the form and save it to the database
 if (isset($_POST['submit']))
 { 
 // confirm that the 'id' value is a valid integer before getting the form data
 if (is_numeric($_POST['id']))
 {
 // get form data, making sure it is valid
 $id = $_POST['id'];
 $username = mysql_real_escape_string(htmlspecialchars($_POST['username']));
 $location = mysql_real_escape_string(htmlspecialchars($_POST['loc_name']));
 $address = mysql_real_escape_string(htmlspecialchars($_POST['address']));
 $city = mysql_real_escape_string(htmlspecialchars($_POST['city']));
 $zip = mysql_real_escape_string(htmlspecialchars($_POST['zip']));
 $county = mysql_real_escape_string(htmlspecialchars($_POST['county']));
 $website = mysql_real_escape_string(htmlspecialchars($_POST['website']));
 $map = mysql_real_escape_string(htmlspecialchars($_POST['map']));
 $email = mysql_real_escape_string(htmlspecialchars($_POST['email']));
 $phone = mysql_real_escape_string(htmlspecialchars($_POST['phone']));
 $bhours = mysql_real_escape_string(htmlspecialchars($_POST['hours']));
 $ptimes = mysql_real_escape_string(htmlspecialchars($_POST['ptime']));
 $pspecials = mysql_real_escape_string(htmlspecialchars($_POST['pspecial']));
 $vspecials = mysql_real_escape_string(htmlspecialchars($_POST['vspecial']));
 // check that username field is filled in
 if ($username == '')
 {
 // generate error message
 $error = 'ERROR: Please fill in all required fields!';
 
 //error, display form
 renderForm($id, $username, $location, $address, $city, $zip, $county, $website, $map, $email, $phone, $bhours, $ptimes, $pspecials, $vspecials, $error);
 }
 else
 {
 // save the data to the database
 mysql_query("UPDATE vusr SET username='$username', loc_name='$location', address='$address', city='$city', zip='$zip', county='$county', website='$website', map='$map', email='$email', phone='$phone', hours='$bhours', ptime='$ptimes', pspecial='$pspecials', vspecial='$vspecials' WHERE id='$id'")
 or die(mysql_error()); 
 
 // once saved, redirect back to the view page
 header("Location: edituser.php"); 
 }
 }
 else
 {
 // if the 'id' isn't valid, display an error
 echo 'Error!';
 }
 }
 else
 // if the form hasn't been submitted, get the data from the db and display the form
 {
 
 // get the 'id' value from the URL (if it exists), making sure that it is valid (checing that it is numeric/larger than 0)
 if (isset($_GET['id']) && is_numeric($_GET['id']) && $_GET['id'] > 0)
 {
 // query db
 $id = $_GET['id'];
 $result = mysql_query("SELECT * FROM vusr WHERE id=$id")
 or die(mysql_error()); 
 $row = mysql_fetch_array($result);
 
 // check that the 'id' matches up with a row in the databse
 if($row)
 {
 
 // get data from db
 $id = $row['id'];
 $username = $row['username'];
 $location = $row['loc_name'];
 $address = $row['address'];
 $city = $row['city'];
 $zip = $row['zip'];
 $county = $row['county'];
 $website = $row['website'];
 $map = $row['map'];
 $email = $row['email'];
 $phone = $row['phone'];
 $bhours = $row['hours'];
 $ptimes = $row['ptime'];
 $pspecials = $row['pspecial'];
 $vspecials = $row['vspecial'];
 // show form
 renderForm($id, $username, $location, $address, $city, $zip, $county, $website, $map, $email, $phone, $bhours, $ptimes, $pspecials, $vspecials, '');
 }
 else
 // if no match, display result
 {
 echo "No results!";
 }
 }
 else
 // if the 'id' in the URL isn't valid, or if there is no 'id' value, display an error
 {
 echo 'Error!';
 }
 }


?>

MOD EDIT: code tags added.

ok so before this.. if there isnt description for the company..the logo cant be click..only can be clicked if there is description added..im confused..


Code: [Select]


<?
if(isset($_GET[ttid])) {
$ttid = $_GET[ttid];
}

$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");


$query = "select master_event.* ,
(DATE_FORMAT(event_datefrom, '%d %M %Y')) as datefrom,
(DATE_FORMAT(event_dateto, '%d %M %Y')) as dateto,
ucase(event_name) as eventname
from master_event
where master_event.event_id = '$ttid '";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)){
$eventname = $row['eventname'];
$eventdesc = $row['event_desc'];
//$companydescription = $row['company_description'];
$eventvenue = $row['event_venue'];
$eventfee = $row['event_fee'];
$datefrom = $row['datefrom'];
$dateto = $row['dateto'];

echo "<font color='#000000'  face='arial' ><b> $eventname </b> </font> <br>";
echo "<font color='#000000'  face='arial' ><i>Date</i> : $datefrom - $dateto <br>";
echo "<i>Venue</i> : $eventvenue <br>";

$querypstype = "SELECT DISTINCT master_pstype.pstype_id,  pstype_desc FROM master_pstype
INNER JOIN master_psevent ON master_psevent.pstype_id= master_pstype.pstype_id
where master_psevent.event_id = '$ttid'
ORDER BY pstype_order";

$resultpstype=mysql_query($querypstype);
while($rowpstype = mysql_fetch_array($resultpstype)){
$pstypeid = $rowpstype['pstype_id'];
$pstypedesc = $rowpstype['pstype_desc'];
echo "<br><font color='#8B3A3A' size='1' face='georgia' ><b><i>$pstypedesc</i></b></font> <br>";

$queryps = "SELECT master_psevent.*, pstype_desc, company_name, company_link, company_description, logo_filename FROM master_psevent
LEFT JOIN master_pstype ON master_psevent.pstype_id = master_pstype.pstype_id
LEFT JOIN master_ps ON master_ps.ps_id = master_psevent.ps_id
WHERE master_psevent.event_id = '$ttid' and master_pstype.pstype_id= '$pstypeid'
ORDER BY pstype_desc,company_name ";

$resultps=mysql_query($queryps);
while($rowps = mysql_fetch_array($resultps)){
$companyname = $rowps['company_name'];
$companyid = $rowps['ps_id'];
$companylinkori = $rowps['company_link'];
$companydescription = $rowps['company_description'];
$logopath = $rowps['logo_filename'];


$describelink = "index.php?ttid=$ttid&content=describe&pstypeid=$pstypeid&psid=$companyid";

echo "<a href=\"$describelink\" target=\"_blank\"><img src=".$logo_dir."/".$logopath." width=\"15%\"></a>";
?>

<br>
<?
}
echo "<br>";
}

}



?>



im new..so to make it simple..the problem is ..i want it to be (if there is description = logo can be click, if no = otherwise)

Code: [Select]
<?php
include('connection.php');

$test1=$_POST('firstname');
$test2=$_POST('lastname');
$test3=$_POST('username');

if (!eregi("([^A-Za-z0-9]"),$test1)){

if (!eregi("([^A-Za-z0-9]"),$test2)){
if (!eregi("([^A-Za-z0-9]"),$test3)){
$query="SELECT * FROM vendors WHERE username = '$_POST(username)'"
$result=mysql_query($query);
$num=mysql_num_rows($result);
if ($num == 0) {
$query1="SELECT * FROM vendors WHERE email = '$_POST(email)'"
$result1=mysql_query($query2);
$num1=mysql_num_rows($result1)
if ($num1 == 0) {
if (($_POST['password']==$_POST['password1'])&&($_POST['email']==$_POST['email1']))
{
$name=strip_tags($_POST['username']);
$first=strip_tags($_POST['firstname']);
$last=strip_tags($_POST['lastname']);
$pass=strip_tags($_POST['password']);
$country=strip_tags($_POST['country']);
$address=strip_tags($_POST['address']);
$email=strip_tags($_POST['email']);
$city=strip_tags($_POST['city']);
$zip=strip_tags($_POST['zipcode']);
$state=strip_tags($_POST['state']);
$phone=strip_tags($_POST['phonenumber']);
$aql="INSERT INTO vendors SET username='$name', firstname='$first', lastname='$last', email='$email', Country='$country', zipcode='$zip', password='$pass', city='$city', state='$state', phonenumber='$phone', address='$address'"
$result=mysql_query($sql)
if ($result){
header(location:http://www.digitaldesignersmall.com/ffx.html)
}
else {
header(location:http://www.digitaldesignersmall.com/fff.html)
}

}
else(
header(location:http://www.digitaldesingersmall.com/afx.html)
}

}
else {
Header(location:http://www.digitaldesingersmall.com/afx.html)
}

}
else{
header("location:http://www.digitaldesignersmall.com/cxs.html")
}

}

else{

header("location:http://www.digitaldesignersmall.com/cxs.html")

}
}
else{
header("location:http://www.digitaldesignersmall.com/cxs.html")
}


?>

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Send Data Form</title>
</head>

<body>
<?php

if(!$_POST) exit;

$email = $_POST['Email'];
$name = $_POST['Name'];
$telephone = $_POST['Telephone'];
$comments = $_POST['Comments'];

//$error[] = preg_match('/\b[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}\b/i', $_POST['email']) ? '' : 'INVALID EMAIL ADDRESS';
if(!eregi("^[a-z0-9]+([_\\.-][a-z0-9]+)*" ."@"."([a-z0-9]+([\.-][a-z0-9]+)*)+"."\\.[a-z]{2,}"."$",$email )){
   $errors=1;
}
if($errors==1) echo $error;
else{
   $values = array ('Name','Email','Telephone','Comments');
   $required = array('Name','Email','Telephone','Comments');
   

   $your_email = "****************";
   $email_subject = "Comment posted from website:";
   
   
   foreach($values as $key => $value){
     if(in_array($value,$required)){
      if ($key != 'Name' && $key != 'Comments' && $key != 'Telephone') {
        if( empty($_POST[$value]) ) { echo 'Please go back and complete all fields, thank you.'; exit; }
      }
      $email_content .= $value.': '.$_POST[$value]."\n";
     }
   }
    
}
   
$headers = "From: $email\r\n"."Reply-To: $email\r\n".'X-Mailer: PHP/' . phpversion();
   

mail($your_email, $email_subject, $email_content, $headers);

if($send_contact){
echo "Thank you for your submission";
}
else {
echo "ERROR, your comment was not sent";

?>
</body>

</html>

MOD EDIT: [code] . . . [/code] tags added.

$result3 = mysql_query("SELECT User_ID FROM leaderboards WHERE User_ID = '$user'");

if(mysql_num_rows($result3) == 0){

$query1 = "INSERT INTO leaderboards (User_ID, CollegeFootballPoints) VALUES ('$user','$points')";
$result1 = mysql_query($query1);

}else{

$query2 = "UPDATE leaderboards SET  CollegeFootballPoints='$points' WHERE User_ID='$user'";
$result2 = mysql_query($query2);
}

I keep getting this error...'

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in update_collegeFBpoints_points.php on line 40

And the script is not working!

(LINE 40 is

$result3 = mysql_query("SELECT User_ID FROM leaderboards WHERE User_ID = '$user'");   
   if(mysql_num_rows($result3) == 0){

specifically mysql_num_rows)

it's supposed to check the file, to see if it's available for download, the code below looks okay to me, what's wrong?

if($row[2]==2) // 4shared check
{
$row[1]="http://www.".$row[1];
$index=getpage($row[1]);
preg_match("/Download ([^<]+)<\/div>/",$index,$match);
if(strpos($index,"The file is shared for public access and download.")===false || !$match)
{
mysql_query("UPDATE `v2links` SET `checked`='-1',`lastcheck`=NOW() WHERE `id`=".$row[0]);
print "bad link\n";
logstr("log-c.txt","bad link\n");
}
else
{
$words=trim($match[1]);
$words=preg_split("/[_\.\-\s]/",$words);
$lastword=array_pop($words);
$words=implode(" ",$words);
$words=preg_replace("/\s{2,}/"," ",$words);
$caption=mysql_real_escape_string($words);
unset($words);
unset($match);
preg_match("/<td>Size\:<\/td><td>([^<]+)<\/td>/",$index,$match);
$fsize=$match[1];
unset($match);
print "$caption :: $fsize\n";
logstr("log-c.txt","$caption :: $fsize\n");
mysql_query("UPDATE `v2links` SET `checked`='1',`lastcheck`=NOW(),`fsize`='$fsize',`caption`='$caption' WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
}


I'm wondering if the sharing website has changed anything, because for rapidshare it works fine, code:

if($row[2]==1) // rapidshare check
{
$index=getpage($row[1]);
if(strpos($index,"<p><script>alert(\"File not found.\")</script>File not found.</p>")===false && strpos($index,"This file has been deleted.")===false)
{
preg_match("/<form action=\"([^\"]+)\" method=\"post\">/",$index,$match);
//print $index;
if($match[1])
{
$fpath=$match[1];
$index=getpage($fpath,"dl.start=Free",$row[1]);
preg_match("/<\/font> \(([^\(]+)\)\.<\/p>/",$index,$match);
$fsize=0;
if($match[1]) $fsize=mysql_real_escape_string(strip_tags($match[1]));
print $fsize."\n";
logstr("log-c.txt",$fsize."\n");
mysql_query("UPDATE `v2links` SET `checked`='1',`fsize`='$fsize',`lastcheck`=NOW() WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
else
{
print "bad link\n";
logstr("log-c.txt","bad link\n");
mysql_query("UPDATE `v2links` SET `checked`='-1',`lastcheck`=NOW() WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
}
else
{
print "bad link\n";
logstr("log-c.txt","bad link\n");
mysql_query("UPDATE `v2links` SET `checked`='-1',`lastcheck`=NOW() WHERE `id`=".$row[0]);
if(mysql_errno()) print mysql_error()."\n";
}
}


any help would be appreciated!