jessejarvis
Members-
Posts
12 -
Joined
-
Last visited
Never
Everything posted by jessejarvis
-
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
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" -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
The referral ids are not hashed at all, they are int(11) unsigned. -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
That's doesn't really help me, what do you mean? I can't do what I am trying to do? -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
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') -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
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. -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
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? -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
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')"; -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
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 -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
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 -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
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. -
Please help! I go live tomorrow! (MySQL/PHP unknown error!
jessejarvis replied to jessejarvis's topic in PHP Coding Help
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')";