SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Enthusiast
    Join Date
    Mar 2004
    Location
    Spain
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    agggg, php/mysql error

    Hello people

    I just installed a free image hosting script in my server and when u try to register i get this:

    Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/changeme/public_html/infraredhost/script/join.php on line 100

    Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/changeme/public_html/infraredhost/script/join.php on line 103

    (http://www.infraredhost.com/script/join.php)

    Anyone can tell me what i have done wrong??

    Thanks in advance!!
    Regards,
    Laura

  2. #2
    My precious!!! astericks's Avatar
    Join Date
    Mar 2002
    Location
    Vancouver, BC
    Posts
    1,971
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    post SOME code please (related to the error)

  3. #3
    SitePoint Enthusiast
    Join Date
    Mar 2004
    Location
    Spain
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The join.php file is as follow:

    <?
    include("include/common.php");
    include("include/header.php");
    ?>
    <?
    # if(!$submit1)$submit1=1;
    if($submit1 == "1") {
    if($requirepaid) {
    ?>
    <h3>Signup for a New Account Step 1</h3><form method=post>
    <?=$table2?>
    <tr align=center>
    <td colspan=3>Select a Username. A password will be generated and emailed to you at the end of the signup process.<p></td>
    </tr>
    <? include("include/paidsignupform.php"); ?>
    </table>
    </form>
    <?
    }
    if(!$requirepaid) {
    ?>
    <h3>Signup for a New Account Step 1</h3><form method=post>
    <?=$table2?>
    <tr align=center>
    <td colspan=2>Fill out the form below. A password will be generated and emailed to you.<p></td>
    </tr>
    <? include("include/nopaidsignupform.php"); ?>
    </table></form>
    <?
    }
    }else if($submit1 == "2") {
    ?>
    <h3>Signup for a New Account</h3>
    <?=$table2?>
    <tr align=center>
    <td colspan=2>Press your browser's 'Back' key and click 'I Agree' to our terms and conditions to continue the signup process.<p></td>
    </tr>
    <?
    }else if($submit2) {
    if(!ereg("^[A-Za-z0-9_]{1,16}$",$susername)) {
    $serror="Invalid username! Use no more than 15 characters and only letters, numbers, and underscores.<br>";
    }
    $this->c=@mysql_query("select username from users where username='$susername'");
    $this->d=mysql_fetch_object($this->c);
    if(is_object($this->d)) { $serror="Username is already in use<br>"; }
    $this->c=@mysql_query("select username from pending where username='$susername'");
    $this->d=mysql_fetch_object($this->c);
    if(is_object($this->d)) { $serror="Username is already in use<br>"; }
    echo "<h3>Signup for a New Account Step 3</h3>";
    if (!$serror) {
    $nowtime = time();
    mysql_query("insert into Pending (username,since) values ('$susername','$nowtime')");
    ?>
    <form action="https://www.paypal.com/cgi-bin/webscr" method="post">
    <?="$table2";?>
    <tr>
    <td align=center>
    Click the button below to signup for our <?=$paypal_sub?> subscription through PayPal.
    The first 7 days are free, and you can cancel anytime before the 7 days are up
    and be charged nothing.<p>
    <input type="hidden" name="cmd" value="_xclick-subscriptions">
    <input type="hidden" name="no_shipping" value="1">
    <input type="hidden" name="no_note" value="1">
    <input type="hidden" name="p3" value="1">
    <input type="hidden" name="t3" value="<?=$paypal_subcode?>">
    <input type="hidden" name="a1" value="0.00">
    <input type="hidden" name="src" value="1">
    <input type="hidden" name="sra" value="1">
    <input type="hidden" name="business" value="<?="$paypal_email";?>">
    <input type="hidden" name="item_name" value="<?="$paypal_item";?>">
    <input type="hidden" name="item_number" value="<?="$paypal_item_number";?>">
    <input type="hidden" name="a3" value="<?="$paypal_price";?>">
    <input type="hidden" name="notify_url" value="<?="$paypal_ipn";?>">
    <input type="hidden" name="cancel_return" value="<?="$paypal_cancel_return";?>">
    <input type="hidden" name="return" value="<?="$paypal_return";?>">
    <input type="hidden" name="os0" value="<?="$susername";?>">
    <input type="hidden" name="on0" value="Username">
    <input type="submit" value="Subscribe now">
    </td>
    </tr>
    </table></form>
    <?
    }
    if ($serror) {
    ?>
    <form method=post>
    <?=$table2?>
    <tr align=center>
    <td colspan=3><font color=red>$serror</font><p></td>
    </tr>
    <? include("include/paidsignupform.php"); ?>
    </table></form>
    <?
    }
    }else if($submit3) {
    if(!ereg("^[A-Za-z0-9_]{1,16}$",$susername)) {
    $serror="Invalid username! Use no more than 15 characters and only letters, numbers, and underscores.<br>";
    }
    $this->c=@mysql_query("select username from users where username='$susername'");
    $this->d=mysql_fetch_object($this->c);
    if(is_object($this->d)) { $serror="Username is already in use<br>"; }
    $this->c=@mysql_query("select username from pending where username='$susername'");
    $this->d=mysql_fetch_object($this->c);
    if(is_object($this->d)) { $serror="Username is already in use<br>"; }
    if (!$serror) {
    mt_srand((double)microtime()*1000000^getmypid());
    $pass_length = mt_rand($this->min_pass_length,$this->max_pass_length);
    while(strlen($spassword)<$pass_length) {
    $spassword.=substr($this->chars,(mt_rand()%strlen($this->chars)),1);
    }
    include("include/emails.php");
    $signupmessage=str_replace("<username>","$susername",$signupmessage);
    $signupmessage=str_replace("<password>","$spassword",$signupmessage);
    $signupmessage=str_replace("<first_name>","$sfirst_name",$signupmessage);
    $signupmessage=str_replace("<last_name>","$slast_name",$signupmessage);
    $signupmessage=str_replace("<login_url>","$login_url",$signupmessage);
    $subject = "$signupsubject";
    $message = "$signupmessage";
    mail($semail,$subject,$message,"From: $adminemail");
    $adminsignupmessage = str_replace("<username>","$susername",$adminsignupmessage);
    $adminsignupmessage = str_replace("<password>","$spassword",$adminsignupmessage);
    $adminsignupmessage = str_replace("<first_name>","$sfirst_name",$adminsignupmessage);
    $adminsignupmessage = str_replace("<last_name>","$slast_name",$adminsignupmessage);
    $adminsignupmessage = str_replace("<member_email>","$semail",$adminsignupmessage);
    $subject = "$adminsignupsubject";
    $message = "$adminsignupmessage";
    mail($adminemail,$subject,$message,"From: $adminemail");
    $nowdate = date("M d, Y");
    mysql_query("insert into users (uid, username, password, first_name, last_name, street, city, state, zip, country, email, telephone, last_paid, signup_date) values ('','$susername', '$spassword', '$sfirst_name', '$slast_name', '$sstreet', '$scity', '$sstate', '$szip', '$scountry', '$semail', '$stelephone', 'free', '$nowdate')");
    echo "<h3>Signup for a New Account Complete</h3>$table2
    <tr><td align=center>Thank you for signing up $susername. We have sent you a welcome email to <b>$semail</b> with your password.</table>";
    }
    if ($serror) {
    ?>
    <h3>Signup for a New Account Step 3</h3>
    <form method=post>
    <?=$table2?>
    <tr align=center>
    <td colspan=3><font color=red>$serror</font><p></td>
    </tr>
    <? include("include/nopaidsignupform.php"); ?>
    </table></form>
    <?
    }
    }else {
    ?>
    <h3>Signup for a New Account Step 1</h3>
    <?=$table2?>
    <tr>
    <td align=center>
    Please read through our terms and conditions below and click 'I Agree' to continue with the signup process.<p>
    <font size=3><b>Terms and Conditions</b></font><p>
    <form method=post><textarea name=textfield cols=60 rows=15 wrap=virtual>
    <? include "include/terms.php"; ?>
    </textarea><p><input type=radio name=submit1 value=1> I Agree<br><input type=radio name=submit1 value=2> I Disagree<p><input type=submit value='Next Step -->'></form>
    </td>
    </tr>
    </table>
    <?
    }
    include("include/footer.php");
    ?>



    THANKS!!!!!!!!!!

  4. #4
    SitePoint Addict DM3Dan's Avatar
    Join Date
    Sep 2004
    Location
    Albany, NY
    Posts
    204
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1. Dont use short tags .

    2. Use [ php ][ /php ] around your code(without the spaces) to make it a little easier to read .

    I'll take a look at it in a second.

  5. #5
    SitePoint Enthusiast
    Join Date
    Mar 2004
    Location
    Spain
    Posts
    30
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks a lot DM3Dan

  6. #6
    SitePoint Addict DM3Dan's Avatar
    Join Date
    Sep 2004
    Location
    Albany, NY
    Posts
    204
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wow, this is tough, after all this looking, I still can't figure it out .


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •