PHP Script Problem

BraniffNET

I have been looking at this code for a while and cannot find the problem any help would be appreciated. This code from a traffic exchange script users that are referred use a link www.webvaluez.com/?ref=1 where 1 is the perrsoned that referred the user, what is happening is the referred person is not being added to the mysql database.

<?php
session_start();
global $sess_name, $sess_passwd, $sess_data;
session_register("sess_name");
session_register("sess_passwd");
session_register("sess_data");
include($DOCUMENT_ROOT . '/vars.php');
include($DOCUMENT_ROOT . '/headfoot.php');
include($DOCUMENT_ROOT . '/auth.php');
mysql_connect($db_host, $db_user, $db_pwd);
mysql_select_db($db_name);
$res = checkauth();
$usrid = mysql_result($res, 0, "id");
$res = mysql_query("select id, name, toref from user where ref=$usrid order by id asc");
secheader();
echo("<a href=/members/ title=\"Back to main page\">User account #$usrid</a> : : Referral");
echo("Your referral URL is: $self_url?ref=$usrid You earn 0.1 credit each time your referrant shows a site.");
if (mysql_num_rows($res) == 0) {
echo("You have no referrants yet.");
} else {
echo("<table border=0 cellpadding=2><tr><td align=left colspan=3>Your referrants:</td></tr><tr style=\"background-color: #f7f7f7\"><td align=left>##</td><td align=left>Name</td><td align=left>Credits earned</td></tr>");
for ($i = 0; $i < mysql_num_rows($res); $i++) {
$name = mysql_result($res, $i, "name");
$tref = mysql_result($res, $i, "toref");
$tref = round($tref, 2);
$nn = $i + 1;
echo("<tr style=\"background-color: #f7f7f7\"><td>$nn</td><td>$name</td><td>$tref</td></tr>");
}
echo("</table>");
}
secfooter();
mysql_close;
?>

ahundiak

Could you explain the problem a bit more? There are no sql insert or update statements so of course nothing is being explicitly added to the database.

Is it something to do with the session handler?

iceraider

Just a tip:

Please organize your code. Using tabs and spaces. It's really messy, it will be harder to find your way around. Use comments

BraniffNET

what happens is someone clicks on www.webvaluez.com/?ref=1 they are then sent to a login screen where they need to register if it's there first visit when they register a email is sent to them and then they have to go to the link in the email to activate there account which removes the remark in the sql db to allow them access to the member section. Along with this it is supposed to add that person as a person that I have referred and then I can recieve extra credits based on there activity. I can manually go into the DB and change the field under the user table and it will show up in the user section but it still won't credit my account like it's supposed to. Also I did not write this script I purchased it from ebay for $20, and now am trying to troubleshoot it.

Weedpacket

As ahundiak implied, none of what you describe appears to happen in the code you've posted. All that appears to do is look up a user in the database and list their referrals.

planetsim

Im surpised anyone can read that. Properly. I looked few the lines i could read it but i just got lost a lot.

Also besides organising code more effiecently using tabs

use [php ][/php ] without the spaces please. It makes helps us read the code easier.

BraniffNET

I don't know if anyone even wants to look at this because the code is a mess but I attached a zip file with other files in it. You can find the members area index.php file in here also along with the main Index.php file.