SELECT * FROM tbl_member_info where (IntroducerNo <> 0 and StatusReg > 0) AND upline=0 ORDER BY MemberNo DESC LIMIT 2

SELECT * FROM tbl_member_info where MemberNo=1035320

StatusReg=1 | IntroducerNo=1035307 for MemberNo=1035320

SELECT count(MemberNo) as sdc FROM tbl_member_info where IntroducerNo='1035320'

count sdc: 0

UPDATE tbl_member_info SET NewGen = 'SDC_1G', SelectGen = 'SDC_1G', upline = 1, dtSDC_1G = '2025-03-14 05:21:30' where (MemberNo='1035320')
UPDATE tbl_member_info SET upline = 0 where (MemberNo='1035307')

==================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1035307'

StatusReg=1 | IntroducerNo=1034952 for MemberNo=1035307

OldGen: | NewGen: | SelectGen: (1035307)

SELECT count(MemberNo) as sdc FROM tbl_member_info where IntroducerNo='1035307'

count sdc: 2

UPDATE tbl_member_info SET NewGen = 'SDC_1G', upline = 1 where (MemberNo='1035307')

UPDATE tbl_member_info SET dtSDC_1G = '2025-03-14 05:21:30' where (MemberNo='1035307')

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1035307'

NewGen_intro: SDC_1G || OldGen_intro:

UPDATE tbl_member_info SET SelectGen = 'SDC_1G', DateGen= '2025-03-14 05:21:30' where (MemberNo='1035307')

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1035307'

if NOT equal to SDC_1G of 1035307, continue

StatusReg=1 | IntroducerNo=1002091 for MemberNo=1034952

OldGen: | NewGen: SDC_1G| SelectGen: 3G (1034952)

SELECT count(MemberNo) as sdc FROM tbl_member_info where IntroducerNo='1034952'

count sdc: 2

UPDATE tbl_member_info SET NewGen = 'SDC_1G', upline = 1 where (MemberNo='1034952')

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1034952'

NewGen_intro: SDC_1G || OldGen_intro:

UPDATE tbl_member_info SET SelectGen = 'SDC_1G', DateGen= '2025-03-14 05:21:30' where (MemberNo='1034952')

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1034952'

if 3G NOT equal to SDC_1G of 1034952, continue

StatusReg=15 | IntroducerNo=1002092 for MemberNo=1002091

OldGen: SDE_10G | NewGen: 12G| SelectGen: 12G (1002091)

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1002091'

NewGen_intro: 12G || OldGen_intro: SDE_10G

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1002091'

if 12G equal to 12G of 1002091, done

SELECT * FROM tbl_member_info where MemberNo=1035319

StatusReg=1 | IntroducerNo=1030744 for MemberNo=1035319

SELECT count(MemberNo) as sdc FROM tbl_member_info where IntroducerNo='1035319'

count sdc: 0

UPDATE tbl_member_info SET NewGen = 'SDC_1G', SelectGen = 'SDC_1G', upline = 1, dtSDC_1G = '2025-03-14 05:21:30' where (MemberNo='1035319')
UPDATE tbl_member_info SET upline = 0 where (MemberNo='1030744')

==================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1030744'

StatusReg=1 | IntroducerNo=1031360 for MemberNo=1030744

OldGen: | NewGen: 7G| SelectGen: 7G (1030744)

SELECT count(MemberNo) as sdc FROM tbl_member_info where IntroducerNo='1030744'

count sdc: 28

UPDATE tbl_member_info SET NewGen = 'SDC_5G', upline = 1 where (MemberNo='1030744')

UPDATE tbl_member_info SET dtSDC_5G = '2025-03-14 05:21:30' where (MemberNo='1030744')

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1030744'

NewGen_intro: SDC_5G || OldGen_intro:

UPDATE tbl_member_info SET SelectGen = 'SDC_5G', DateGen= '2025-03-14 05:21:30' where (MemberNo='1030744')

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1030744'

if 7G NOT equal to SDC_5G of 1030744, continue

StatusReg=3 | IntroducerNo=1031361 for MemberNo=1031360

OldGen: | NewGen: 10G| SelectGen: 10G (1031360)

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1031360'

NewGen_intro: 10G || OldGen_intro:

UPDATE tbl_member_info SET SelectGen = '10G', DateGen= '2025-03-14 05:21:30' where (MemberNo='1031360')

======================================================================================================

SELECT * FROM tbl_member_info where MemberNo='1031360'

if 10G equal to 10G of 1031360, done