Script problem after switching host

Hypocrite

We have had a PHP script in our site for a long time which allows users to post little presentation of themselves to our site.

We have just decided to switch to a new server and I have been trying to get everything working on the new host. I have been able to get our forums, blogs etc. working without too much hassle but surprisingly I haven't been able to get the little presentation script working.

I cannot get the presentations displayed or submit new presentations. The weird thing is that I can get the presentation index page working which displays the list of all the presentation.

The index page uses the following function to gather three most recent presentations. This page works without any problems.

<? // three most recent registrants

$findrecent = @mysql_query("SELECT nicknames, regdateshown FROM profiles order by regdatesorted desc");

if (!$findrecent) {
 echo("<P>Error accessing profiles" .
 mysql_error() . "</P>");
 exit();
 } 	

for ($i = 1; $i < 4; $i++){	
$myrow = mysql_fetch_row($findrecent);

$name = $myrow[0];
$date = $myrow[1];

// show date and create a link for each name

?>
            <p align="LEFT"><b> <? echo "$date :"; ?> </b><br>
              <a href="esittelyt.php?name=<?php echo(urlencode($name)); ?>"> 
              <?php echo($name); ?> </a><br>
              <?

} // end for

?>

The page for each presentation also lists all the presentation in dropdown boxes and this boxes get filled correctly.

The function to get the information for the presentation is following:

<?
// retrieve profile data

$result = @mysql_query("select * from profiles WHERE nimimerkit='$name'");

$myrow = @mysql_fetch_row($result);
$paikkakunta = $myrow[2];
$syntymaaika = $myrow[3];
$sukupuoli = $myrow[4];
$harrastukset = $myrow[5];
$siviilisaaty = $myrow[6];
$email = $myrow[7];
$kotisivu = $myrow[8];
$photoname = $myrow[12];
$emailvisible = $myrow[13];
$photovisible = $myrow[14];
$comments = $myrow[9];

// if photo is visible

if ($photovisible != "no") { 

// resize any images larger than will fit the page design
// provide path to pictures as in following line
// $size = getimagesize("http://kotichat.planeetta.com/pictures/$photoname");

$size = @getimagesize("http://kotichat.planeetta.com/esittelyt/kuvat/$photoname"); 

// set the maximum width you want displayed

$maxwidth = "350";
$imagewidth = $size[0];
$imageheight = $size[1];
$imgorig = $imagewidth;
if ($imagewidth > $maxwidth) {
  $imageprop=($maxwidth*100)/$imagewidth;
  $imagevsize= ($imageheight*$imageprop)/100 ;
  $imagewidth=$maxwidth; 
  $imageheight=ceil($imagevsize);
}

echo "<P ALIGN='center'><IMG height='$imageheight' width='$imagewidth' alt='$photoname' src='http://kotichat.planeetta.com/esittelyt/kuvat/$photoname' border='0'></P>";

} // end if

// show no photo
else {
echo "<P ALIGN='center'><IMG src=\"http://kotichat.planeetta.com/esittelyt/kuvat/eikuvaa.jpg\" border=\"0\"></P>";
}
?>

The URL address to the presentation contains the $name attribute and is following:
http://www.domain.com/presentation/presentation.php?name=Harald

The database connection works correctly because the presentation dropdown box gets filled and also because if I change the database information to be incorrect I get an error message.

Only reasons I have been able to think of are that the $name attribute isn't read correctly from the URL or that the new host is using newer version of PHP & MySQL which causes problems.

My old host was using following PHP and MySQL versions:
PHP VERSION: 4.4.0, mySQL VERSION: 3.23.58

New host is using the following versions:
PHP VERSION: 4.3.10, mySQL VERSION: 4.0.25

Could anyone help with this? I have been busting my brains out why the script works in my old host but not in the new one.

thorpe

$result = @mysql_query("select * from profiles WHERE nimimerkit='{$_GET['name']}'");

Hypocrite

Awesome. Thank you very much.

Unfortunately I bumped into a new problem when trying to login to edit a presentation or trying to get a lost username/password.

If you could be so kind and see which part of the script if causing the problem.

Code for the username and password retrieval.

<?

$showform = "no";

if (!isset($email))
$showform = "yes"; 

else {

// validate email address

if ( ( !ereg ("^[^@ ]+@[^@ ]+\.[^@ \.]+$", $email ) ) || ( $email == "" ) ){
echo "Sähköpostiosoite ei kelpaa. <br>";
$showform = "yes";
}

} // end else

if ($showform == "yes"){
echo "<FORM name=\"thisform\" method=\"POST\" action=\"$PHP_SELF\">
<input type=\"text\" class=\"forminput\" name=\"email\" style='width:65%' maxlength=50 value=\"$email\" >

<INPUT type=\"hidden\" class=\"forminput\" name=\"showform\" value=\"no\"><br>";
?>	
<INPUT class="forminput" TYPE="submit" NAME="submit" VALUE="Lähetä">
<?
echo "</form> ";
}
else {

// retrieve login data from database

dbConnect("database");

$nimimerkitdat = @mysql_query("select nimimerkit from profiles where email='$email'");
if(mysql_num_rows($nimimerkitdat) == 0) { echo "<BR><BR>Valitamme, antamaasi sähköpostiosoitetta ei löydy tietokannastamme.<BR><A HREF='http://www.kotichat.com/esittelyt/editprofile.php'>Palaa</A> takaisin ja yritä uudelleen."; die(); }
$nimimerkitfound = @mysql_result($nimimerkitdat, 0, 0);

$passworddat = @mysql_query("select password from profiles where email='$email'");
$passwordfound = @mysql_result($passworddat, 0, 0);

$message = "Hei,\nSait tämän sähköpostin, koska pyysit saada salasanasi KotiChat.com sivustolta löytyvään esittelyysi.\nPyytämäsi tiedot:\nNimimerkki:    $nimimerkitfound\nSalasana:      $passwordfound\n\n--\n  Terveisin,\n Ylläpito KotiChat.com\n palaute@kotichat.com\n http://www.kotichat.com\n
";


mail( $email, "KotiChat esittelyyn kirjautuminen", $message, "From: asiakaspalvelu&#064;kotichat.com" );
echo "<BR><BR>Kiitos.<BR>Nimimerkkisi ja salasanasi on lähetetty antamaasi sähköpostiosoitteeseen.";
}
?>

Session register:

<?php
exit;
}

session_register("nimimerkit");
session_register("password");

dbConnect("kotichat_db");

$sql = "select * from profiles where nimimerkit = '$nimimerkit' and password = '$password'";
$result = mysql_query($sql);
if (!$result) {
  error("A database error occurred while checking your login details.");
}

if (mysql_num_rows($result) == 0) {
  session_unregister("nimimerkit");
  session_unregister("password");

?>

When trying to use the login script I get the same page back with no error message.

And thank you again, this is highly appreciated. 🙂

swatisonee

Pl tell me - does this happen whenever someone moves from mysql 3.23.58 to 4 ?

I too am scheduled to move my site to a host using mysql 4 rather than the current 3.23.58 .

I dont think i can physically change every

$result = @("select * from profiles WHERE nimimerkit='$name'");

$result = @("select * from profiles WHERE nimimerkit='{$_GET['name']}'");

as I have a few hundred scripts running !!

If this is the case, then i am better off not moving right ?

Hypocrite

I also noticed that the imagesize function in the first script doesn't work anymore. It doesn't resize the image to fit the page.

Are my problems due moving from MySQL 3.23.58 to 4 or is this more issue of bad coding from the person who originally made the scripts?

Hypocrite

Got the getimagesize problem solved.

The problem was that I had defined the url path and not the directory path to the image. Seems that the url path works fine with the old server but not with the new one.

Still trying to figure out rest of the problems. 🙂

Hypocrite

Figured out all my problems it seems.

The problem was that on my old host register_globals was set to on and on the new host they have been set to off. I made a temporary .htaccess file which enables register_globals for my public_html folder and that seems to have cured all my problems.

Will have to find a better solution later.