Well, it happened... I told you that the database schema was subject to change, and it has already....
Table name: Matrix
Columns:
id: huge int #forign key
orignialSponsor : varchar(30) #not null, index
placedWith : varchar(30) #not null
firstLevel : int #default 0 (zero), max 4
Position1 : huge int #default -2
Position2 : huge int #default -2
Position3 : huge int #default -2
Position4 : huge int #default -2
secondLevel : int #default 0 (zero), max 16
thirdLevel : int #default 0 (zero), max 256
fourthLevel : int #default 0 (zero), max 1024
My husband said that this change would make the process of finding a direct sponsor for a new person a bit more efficient.
The process is now:
Look at the Matrix record for the site the new person visited, if there is an open position on their first level then that is where the new person will be place and $20 will be credited to that persons account (the other $5 goes to the admin).
Otherwise, look at the records for thier first level people. Find the person with the fewest first level people and place the new person there, that direct sponsor gets $10 and their sponsor gets $10 (the other $5 goes to the admin).
Otherwise, look at the 16 records from your second level. Find the person with the fewest first level people and place the new person there. That direct sponsor gets $10, and you as the recruiter get $10 (the other $5 goes to the admin).
Otherwise, look at the 256 records from your third level. Find the person with the fewest first level people and place the new person there. That direct sponsor gets $10, and you as the recruiter get $10 (the other $5 goes to the admin).
Otherwise, look at the 1,024 records from your fouth level. Find the person with the fewest first level people and place the new person there. That direct sponsor gets $10, and you as the recruiter get $10 (the other $5 goes to the admin).
Otherwise, look at all records where you are recorded as the original sponsor. Find the person with the fewest first level people and place the new person there. That direct sponsor gets $10, and you as the recuriter get $10 (the other $5 goes to the admin).
Otherwise, look at the 4,096 records from your fifth (unpaid) level. Find the person with the fewest first level people and place the new person there. That person gets $10, and you as the recruiter get $10 (the other $5 goes to the admin)
Otherwise, look at the 16,384 recors from your sixth (unpaid) level. Find the person with the fewest first level people and place the new person there. That person gets $10, and you as the recriter get $10 (the other $5 goes to the admin).
Otherwise.... you get the idea, evey time we are search 4x more records attemping to find someone in your organization who has the fewest first level people and place the new person there. That person gets $10 and you as the recruiter get $10 (the other $5 goes to the admin).
As you can see, anyone recruited from your referral site will be shown as having you as the originalSponsor but if your first level is already full, will be placed somewhere under your position.
Another way to look at the residual income stream is to look at it as helping 4 people earn $48 a month and you'll earn $512 + $48 = $560 a month. Help 4 people earn $560 a month and you'll earn $3,632 a month. At this point you can register another position which will rename your previous position (something the admin will never do) so while the admin stands to earn $3,623 a month first, anyone can easily surpass that income level.
Note, while the other $5 goes to the admin, the admin doesen't get to keep all of it, deduced from that $5 is the fee for processing the $25 credit card transaction.
In reality, all funds sit in the admins bank account until requested. As this program is designed to run itself, the admin will have another personal account he uses to transfer funds into using the same process than anyone else will be using to get funds out of this program.
Also the program will require the minimal set of information to process your credit card when you sign up, but will require all information before you are allowed to take any funds out. Also the minumum transaction will be $100
In keeping with the idea that the receiver pays the transaction fee, let's say that you take $100 out of your account, you will have the choice of paying the transaction fee from your account balance (assuming there is anything left in your account) or having the tranaction fee deducted from the funds requested (translation, you wiould get slightly less than the $100 requested deposited in your bank account).
By the way, if you were wondering why there are so many tables instead of putting everything together in one huge table, it has to do with concurancy issues with the database that I don't pretend to understand, but my husband does!
All the Best,
Genieve