I am working on a mlm script and I am not sure if i am going in the right direction. The mlm script is 3 (width) x 9 (level) based. The design of my database is following:
Now as per the design its simple enough and i with just memb_pid can add as many members by using the memb_pos (position left, mid or right).
CREATE TABLE IF NOT EXISTS `members` (
`memb_id` mediumint(9) NOT NULL AUTO_INCREMENT,
`memb_pid` mediumint(9) NOT NULL,
`memb_pos` tinyint(1) NOT NULL,
`memb_fullname` varchar(50) NOT NULL,
PRIMARY KEY (`memb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
As 1 member can only have 3 sub-members that i have also covered.
Now there are payouts at each different level.
Eg. If member 1 who is on top joins 3 members below him then he gets 200 for each member.
Then if those 3 members join 3x3 = 9 members below them then they each get 200 for each but the 1st top member gets 100 for each member.
How to make this kind of thing ?