jessejarvis

It's a software I am using, just noticed where it is MD5'ing it :/ From what I notice in: (SELECT refid2 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), The .md5($_REQUEST["rid"]). Gets the info from the web browser url: http://www.website.com/?rid=929 With 929 being the referral ID. That's why when I see .md5($_REQUEST["rid"]). I believe it's getting the referral ID. So in other words: (SELECT refid2 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), Select Refferal ID FROM Member's table where id= Refferal's ID. Does this make sense? However (SELECT refid2 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), (SELECT refid3 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), (SELECT refid4 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), (SELECT refid5 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), (SELECT refid6 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), (SELECT refid7 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), (SELECT refid8 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), (SELECT refid9 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), (SELECT refid10 FROM oto_members as om WHERE id='".md5($_REQUEST["rid"])."'), Ends up entering "0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL" Although it should be "13,12,11,4,0,0,0,0,0"

The referral ids are not hashed at all, they are int(11) unsigned.

That's doesn't really help me, what do you mean? I can't do what I am trying to do?

One small issue. In: (SELECT refid2 FROM oto_members as om WHERE id='13'), id='13' should actually get the 13 from "WHERE id='.md5($_REQUEST["rid"]).'" How can I put this in? VALUES('".$_REQUEST["firstname"]."','".$_REQUEST["lastname"]."','".$_REQUEST["email"]."','".$_REQUEST["address"]."','".$_REQUEST["city"]."','".$_REQUEST["state"]."','".$_REQUEST["postcode"]."','".$_REQUEST["country"]."','".$_REQUEST["telephone"]."','".$_REQUEST["username"]."','".md5($_REQUEST["password"])."','".md5($_REQUEST["rid"])."', (SELECT refid2 FROM oto_members as om WHERE id='13'), (SELECT refid3 FROM oto_members as om WHERE id='13'), (SELECT refid4 FROM oto_members as om WHERE id='13'), (SELECT refid5 FROM oto_members as om WHERE id='13'), (SELECT refid6 FROM oto_members as om WHERE id='13'), (SELECT refid7 FROM oto_members as om WHERE id='13'), (SELECT refid8 FROM oto_members as om WHERE id='13'), (SELECT refid9 FROM oto_members as om WHERE id='13'), (SELECT refid10 FROM oto_members as om WHERE id='13')

Thank you! You have just potentionally made me millions I believe I have figured it out massively with your help, adding the " as om" seems to have made the registration go through Sincerely, Jesse Jarvis.

I am trying to make a 10 level affiliate system so that when somebody signs up, their sponsor becomes their refid1, refid2 = the sponsor's sponsor, refid3= the sponsor's sponsor's sponsor, etc until 10 levels. Know what I mean?

It ended up saying this: INSERT INTO oto_members(firstname,lastname,email,address,city,state,postcode,country,telephone,username,password,refid1,refid2,refid3,refid4,refid5,refid6,refid7,refid8,refid9,refid10,geo,paypal_email,joindate,mtype,groupid,cb_id,status,signupip) VALUES('Joe','','sl2@jessejarvis.com','','','','','','','joesmith','788f2df64bb1d67573e319567ea3fbc2', (SELECT refid1 FROM oto_members WHERE id='13'), (SELECT refid2 FROM oto_members WHERE id='13'), (SELECT refid3 FROM oto_members WHERE id='13'), (SELECT refid4 FROM oto_members WHERE id='13'), (SELECT refid5 FROM oto_members WHERE id='13'), (SELECT refid6 FROM oto_members WHERE id='13'), (SELECT refid7 FROM oto_members WHERE id='13'), (SELECT refid8 FROM oto_members WHERE id='13'), (SELECT refid9 FROM oto_members WHERE id='13'), (SELECT refid10 FROM oto_members WHERE id='13') ,'','',NOW(),1,1,'','Unverified','66.79.235.188')You can't specify target table 'oto_members' for update in FROM clause with this: $affiliate1=('.$_REQUEST["rid"].'); $affiliate2=("SELECT refid1 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate3=("SELECT refid2 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate4=("SELECT refid3 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate5=("SELECT refid4 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate6=("SELECT refid5 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate7=("SELECT refid6 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate8=("SELECT refid7 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate9=("SELECT refid8 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate10=("SELECT refid9 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); echo $qry="INSERT INTO ".$prefix."members(firstname,lastname,email,address,city,state,postcode,country,telephone,username,password,refid1,refid2,refid3,refid4,refid5,refid6,refid7,refid8,refid9,refid10,geo,paypal_email,joindate,mtype,groupid,cb_id,status,signupip) VALUES('".$_REQUEST["firstname"]."','".$_REQUEST["lastname"]."','".$_REQUEST["email"]."','".$_REQUEST["address"]."','".$_REQUEST["city"]."','".$_REQUEST["state"]."','".$_REQUEST["postcode"]."','".$_REQUEST["country"]."','".$_REQUEST["telephone"]."','".$_REQUEST["username"]."','".md5($_REQUEST["password"])."', (SELECT refid1 FROM oto_members WHERE id='13'), (SELECT refid2 FROM oto_members WHERE id='13'), (SELECT refid3 FROM oto_members WHERE id='13'), (SELECT refid4 FROM oto_members WHERE id='13'), (SELECT refid5 FROM oto_members WHERE id='13'), (SELECT refid6 FROM oto_members WHERE id='13'), (SELECT refid7 FROM oto_members WHERE id='13'), (SELECT refid8 FROM oto_members WHERE id='13'), (SELECT refid9 FROM oto_members WHERE id='13'), (SELECT refid10 FROM oto_members WHERE id='13') ,'".$_REQUEST["geo"]."','".$_REQUEST["paypal_email"]."',NOW(),".$_REQUEST["mtid"].",$eogroup,'".$_REQUEST["cb_id"]."','$memberstatus','$signupip')";

It says this: INSERT INTO oto_members(firstname,lastname,email,address,city,state,postcode,country,telephone,username,password,refid1,refid2,refid3,refid4,refid5,refid6,refid7,refid8,refid9,refid10,geo,paypal_email,joindate,mtype,groupid,cb_id,status,signupip) VALUES('Joe','','sl2@jessejarvis.com','','','','','','','joesmith','788f2df64bb1d67573e319567ea3fbc2',' (SELECT refid1 FROM oto_members WHERE id='13'), (SELECT refid2 FROM oto_members WHERE id='13'), (SELECT refid3 FROM oto_members WHERE id='13'), (SELECT refid4 FROM oto_members WHERE id='13'), (SELECT refid5 FROM oto_members WHERE id='13'), (SELECT refid6 FROM oto_members WHERE id='13'), (SELECT refid7 FROM oto_members WHERE id='13'), (SELECT refid8 FROM oto_members WHERE id='13'), (SELECT refid9 FROM oto_members WHERE id='13'), (SELECT refid10 FROM oto_members WHERE id='13') ,'','',NOW(),1,1,'','Unverified','66.79.235.188')You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13'), (SELECT refid2 FROM oto_members WHERE id='13'), (SELECT refid3 FRO' at line 3

An e is in there where it shouldn't have been... typo as usual. Here is the latest output: INSERT INTO oto_members(firstname,lastname,email,address,city,state,postcode,country,telephone,username,password,refid1,refid2,refid3,refid4,refid5,refid6,refid7,refid8,refid9,refid10,geo,paypal_email,joindate,mtype,groupid,cb_id,status,signupip) VALUES('Joe','','sl2@jessejarvis.com','','','','','','','joesmith','788f2df64bb1d67573e319567ea3fbc2', .$_REQUEST["rid"]., SELECT refid1 FROM oto_members WHERE id='13', SELECT refid2 FROM oto_members WHERE id='13', SELECT refid3 FROM oto_members WHERE id='13', SELECT refid4 FROM oto_members WHERE id='13', SELECT refid5 FROM oto_members WHERE id='13', SELECT refid6 FROM oto_members WHERE id='13', SELECT refid7 FROM oto_members WHERE id='13', SELECT refid8 FROM oto_members WHERE id='13', SELECT refid9 FROM oto_members WHERE id='13' ,'','',NOW(),1,1,'','Unverified','66.79.235.188')You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '["rid"]., SELECT refid1 FROM oto_members WHERE id='13', SELECT refid2 FR' at line 5

What do you mean wrapped in parenthesis? Also no that is not deliberate, just noticed refid 7 is missing in between this 2 commas, will investigate further.

INSERT INTO oto_members(firstname,lastname,email,address,city,state,postcode,country,telephone,username,password,refid1,refid2,refid3,refid4,refid5,refid6,refid7,refid8,refid9,refid10,geo,paypal_email,joindate,mtype,groupid,cb_id,status,signupip) VALUES('Joe','','sl2@jessejarvis.com','','','','','','','joesmith','788f2df64bb1d67573e319567ea3fbc2', .$_REQUEST["rid"]., SELECT refid1 FROM oto_members WHERE id='13', SELECT refid2 FROM oto_members WHERE id='13', SELECT refid3 FROM oto_members WHERE id='13', SELECT refid4 FROM oto_members WHERE id='13', SELECT refid5 FROM oto_members WHERE id='13', SELECT refid6 FROM oto_members WHERE id='13', , SELECT refid8 FROM oto_members WHERE id='13', SELECT refid9 FROM oto_members WHERE id='13' ,'','',NOW(),1,1,'','Unverified','66.79.235.188')You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '["rid"]., SELECT refid1 FROM oto_members WHERE id='13', SELECT refid2 FR' at line 5

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '["rid"]., SELECT refid1 FROM oto_members WHERE id='13', SELECT refid2 FR' at line 5 With this script area: $affiliate1=('.$_REQUEST["rid"].'); $affiliate2=("SELECT refid1 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate3=("SELECT refid2 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate4=("SELECT refid3 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate5=("SELECT refid4 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate6=("SELECT refid5 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate7=("SELECT refid6 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliat8e=("SELECT refid7 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate9=("SELECT refid8 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $affiliate10=("SELECT refid9 FROM oto_members WHERE id='".$_REQUEST["rid"]."'"); $qry="INSERT INTO ".$prefix."members(firstname,lastname,email,address,city,state,postcode,country,telephone,username,password,refid1,refid2,refid3,refid4,refid5,refid6,refid7,refid8,refid9,refid10,geo,paypal_email,joindate,mtype,groupid,cb_id,status,signupip) VALUES('".$_REQUEST["firstname"]."','".$_REQUEST["lastname"]."','".$_REQUEST["email"]."','".$_REQUEST["address"]."','".$_REQUEST["city"]."','".$_REQUEST["state"]."','".$_REQUEST["postcode"]."','".$_REQUEST["country"]."','".$_REQUEST["telephone"]."','".$_REQUEST["username"]."','".md5($_REQUEST["password"])."', $affiliate1, $affiliate2, $affiliate3, $affiliate4, $affiliate5, $affiliate6, $affiliate7, $affiliate8, $affiliate9, $affiliate10 ,'".$_REQUEST["geo"]."','".$_REQUEST["paypal_email"]."',NOW(),".$_REQUEST["mtid"].",$eogroup,'".$_REQUEST["cb_id"]."','$memberstatus','$signupip')";