This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 18%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Hello
Good day every one
I have a website that students enter and book a lecturer using there accounts, i want to add a feature that make the students able to send a referral links to another students and when that new student (student B) book at least one lecturer then (student A) who invite him will win X points, in addition to that i need that student when ever he book a lecturer, to win Y points, therefore, this student will giant some of points, lets say Z points, he will be able to replace them with 1 free lecturer.
The way i think is, the referral link will contain (student A)'s ID and when the other student registered by this link, and when this new student book a lecturer (at least), a trigger will run and add the X points to (student A)'s fund.
The second way to gain points is when the student book a lecturer, a trigger will run and add Y point to his fund.
DB design will be as below:
TBL_Students
{ (main info), referral link (Y,N), Referral ID (for the origin student))}
TBL_Points
{ Student id, type (from invitation or from booking), points value, used (Y,N)}
noting that it's just a thought and i don't know exactly how to implement it, please support and advise
Regards
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 78%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBZ%3C/text%3E%3C/svg%3E)
In my opinion, the first link will be good, you could put the id inside the link and show a popup when the new student come into that page, to show who share the link and tell him if he book a book and show something. Then let the new student select what he wants.
i want apply both ways, they grant students points in case they invite some one or book a class.
but i don't know how to implement the first part which is referral links
In my opinion, you could encrypt the shared student user id and generate a shared code. You could add these ID and shared code into the link, when the another user go to the shared page, you could check the link's information to get the userid and shared codes, this could help you know who shared and get the shared code. The shared codes may contains something useful information and you could use these data to do something.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 75%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
ng toolbar with Alt/Option + F10.
Hint: Notify or tag a user in this post by typinstrong text
Tab to the formatting toolbar with Alt/Option + F10.
Hint: Notify or tag a user in this post by typing @userna
i didn't get it, please explain more...