SELECT ChildUUID FROM tbl_genealogy INNER JOIN tbl_users ON tbl_genealogy.UUID = tbl_users.UUID WHERE tbl_genealogy.UUID = '#ARGUMENTS.UUID#' AND sRelationship = 'Remote' SELECT sUserName, sEmail, UUID FROM tbl_users WHERE UUID IN () SELECT ChildUUID FROM tbl_genealogy INNER JOIN tbl_users ON tbl_genealogy.UUID = tbl_users.UUID WHERE tbl_genealogy.UUID = '#ARGUMENTS.UUID#' AND sRelationship = 'Direct' SELECT sUserName, sEmail, UUID, sFirstName, sLastName, sEmail FROM tbl_users WHERE UUID = SELECT ChildUUID FROM tbl_genealogy INNER JOIN tbl_users ON tbl_genealogy.UUID = tbl_users.UUID WHERE tbl_genealogy.UUID = '#ARGUMENTS.UUID#' AND sRelationship = 'Indirect' SELECT sUserName, sEmail, UUID, sFirstName, sLastName, sEmail FROM tbl_users WHERE UUID = SELECT UUID AS Sponsor_UUID, sDirectUUID, sIndirectUUID, sUserName FROM tbl_users WHERE sUserName = '#ARGUMENTS.sSponsorUserName#' INSERT INTO tbl_users (sFirstName, sLastName, sUserName, sPassword, sEmail, sGender, dDateOfBirth, iHowHearIDFK, iCountyIDFK, sTown, UUID, iShortID, sDirectUUID, sIndirectUUID) VALUES ('#arguments.sFirstName#', '#arguments.sLastName#', '#arguments.sUserName#', '#arguments.sPassword#', '#arguments.sEmail#', '#arguments.sGender#', #CreateODBCDate(LSParseDateTime(LSDateFormat(now(), "dd/mm/yyyy")))#, #arguments.iHowHearIDPK#, #arguments.iCountyIDPK#, '#arguments.sTown#', '#UUID#', #iShortID#, '#get_sponsors_UUID.Sponsor_UUID#' NULL , '#get_sponsors_UUID.sDirectUUID#' NULL ) INSERT INTO tbl_genealogy (UUID, ChildUUID, sRelationship, UUIDUserName, ChildUUIDUserName) VALUES ('#get_sponsors_UUID.Sponsor_UUID#', '#UUID#', 'Direct', '#get_sponsors_UUID.sUserName#', '#ARGUMENTS.sUserName#') SELECT sUserName FROM tbl_users WHERE UUID = '#get_sponsors_UUID.sDirectUUID#' INSERT INTO tbl_genealogy (UUID, ChildUUID, sRelationship, UUIDUserName, ChildUUIDUserName) VALUES ('#get_sponsors_UUID.sDirectUUID#', '#UUID#', 'Indirect', '#get_sDirect_UUID.sUserName#', '#ARGUMENTS.sUserName#') SELECT sUserName FROM tbl_users WHERE UUID = '#get_sponsors_UUID.sIndirectUUID#' INSERT INTO tbl_genealogy (UUID, ChildUUID, sRelationship, UUIDUserName, ChildUUIDUserName) VALUES ('#get_sponsors_UUID.sIndirectUUID#', '#UUID#', 'Remote', '#get_inDirect_UUID.sUserName#', '#ARGUMENTS.sUserName#') SELECT UUID FROM tbl_genealogy WHERE ChildUUID = '#get_sponsors_UUID.sIndirectUUID#' AND sRelationship = 'Direct' INSERT INTO tbl_genealogy (UUID, ChildUUID, sRelationship) VALUES ('#get_sponsors_indirect_direct.UUID#', '#UUID#', 'Remote') SELECT UUID FROM tbl_genealogy WHERE ChildUUID = '#get_sponsors_UUID.sIndirectUUID#' AND sRelationship = 'Indirect' INSERT INTO tbl_genealogy (UUID, ChildUUID, sRelationship) VALUES ('#get_sponsors_indirect_indirect.UUID#', '#UUID#', 'Remote') Dear #ARGUMENTS.sFirstName# #ARGUMENTS.sLastName# You recently registered for IfEveryoneDid.com using this email address. To complete your registration, please click on the following link: #request.site_url#/verify.cfm?id=#iShortID#&email=#arguments.sEmail# (If clicking on the link doesn't work, try copying and pasting it into your browser.) If you did not register for IfEveryoneDid, please disregard this message. If you have any questions, please contact #request.email_contact# Thank you, IfEveryoneDid.com UPDATE tbl_users SET sFirstName = '#arguments.sFirstName#', sLastName = '#arguments.sLastName#', sUserName = '#arguments.sUserName#', sPassword = '#arguments.sPassword#', sEmail = '#arguments.sEmail#', sGender = '#arguments.sGender#', dDateOfBirth = #CreateODBCDate(LSParseDateTime(LSDateFormat(now(), "dd/mm/yyyy")))#, iHowHearIDFK = #arguments.iHowHearIDPK#, iCountyIDFK = #arguments.iCountyIDPK#, sTown = '#arguments.sTown#', iAllowEmail = '#arguments.iAllowEmail#' WHERE UUID = '#arguments.UUID#' SELECT * FROM tbl_users WHERE UUID = '#arguments.UUID#' SELECT UUID FROM tbl_users WHERE sUserName = '#arguments.sUsername#' AND sPassword = '#arguments.sPassword#' SELECT * FROM tbl_users WHERE sUserName = '#arguments.sUsername#' OR sEmail = '#arguments.sUsername#' Dear #get_user_account.sFirstName# #get_user_account.sLastName# You have received this mail because you (or someone else) have asked to be reminded of your Password for ifeveryonedid.com Your Email: #get_user_account.sEmail# Your Username: #get_user_account.sUsername# Your Password: #get_user_account.sPassword# Thank you, IfEveryoneDid.com SELECT * FROM tbl_users WHERE iShortID = '#arguments.iShortID#' AND sEmail = '#arguments.sEmail#' UPDATE tbl_users SET iConfirm = 1 WHERE iShortID = '#arguments.iShortID#' AND sEmail = '#arguments.sEmail#' SELECT sFirstName, sLastName, sEmail, tbl_users.UUID, sUserName FROM tbl_users INNER JOIN tbl_genealogy ON tbl_users.UUID = tbl_genealogy.UUID WHERE tbl_genealogy.ChildUUID = '#ARGUMENTS.UUID#' AND sRelationship = 'Direct' SELECT * FROM tbl_users, tbl_counties WHERE tbl_users.iCountyIDFK = tbl_counties.iCountyIDPK AND UUID = '#arguments.UUID#' SELECT * FROM tbl_users ORDER BY sLastName DELETE FROM tbl_users WHERE UUID = '#ARGUMENTS.UUID#' DELETE FROM tbl_genealogy WHERE UUID = '#ARGUMENTS.UUID#' SELECT count(iC02ImpactValue) AS Total FROM tbl_user_campaign_link, tbl_campaigns, tbl_c02impact, tbl_ratings WHERE UUID = '#ARGUMENTS.UUID#' AND iCampaignIDFK = iCampaignIDPK AND iC02ImpactIDPK = iC02ImpactIDFK AND iRatingIDFK = iRatingIDPK SELECT count(iC02ImpactValue) AS Total FROM tbl_user_campaign_link, tbl_campaigns, tbl_c02impact, tbl_ratings WHERE UUID = '#ARGUMENTS.UUID#' AND iCampaignIDFK = iCampaignIDPK AND iC02ImpactIDPK = iC02ImpactIDFK AND iRatingIDFK = iRatingIDPK SELECT UUID, sUserName FROM tbl_users WHERE sUserName = '#ARGUMENTS.sUserName#' SELECT UUID, sUserName, sFirstName, sLastName, sEmail FROM tbl_users WHERE UUID = '#ARGUMENTS.UUID#' SELECT UUID, sUserName, sFirstName, sLastName, sEmail FROM tbl_users WHERE sEmail = '#this_email#' Hi #get_invitees_details.sFirstName# #get_invitees_details.sLastName# I'm inviting you to join ifeveryonedid.com. Please click on the following link to sign up: #request.site_url#/sign_up.cfm?i=#ARGUMENTS.UUID#&sEmail=#this_email#