Creative Yadley Posted May 19, 2020 Share Posted May 19, 2020 Regards! Does anyone know if it is possible to manually assign a specific number to an affiliate link? The reason for this question is that one of our affiliates accounts just mysteriously disappeared and the affiliate (who is our client as well) was prompted to activate a new affiliate account. When he activated the new account he was obviously assigned a new affiliate ID. The affiliate really needs his old affiliate ID back as he has shared it in too many places so far. Could not find any solution in the documentation, past threads or the ever wise Mr Google. Please help. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted May 20, 2020 Share Posted May 20, 2020 11 hours ago, Creative Yadley said: Does anyone know if it is possible to manually assign a specific number to an affiliate link? I dislike "is it possible" questions, because the answer is nearly always yes... as it would be in this case... though you would have to tread very carefully. 11 hours ago, Creative Yadley said: The reason for this question is that one of our affiliates accounts just mysteriously disappeared and the affiliate (who is our client as well) was prompted to activate a new affiliate account. I would suggest that you look into why/how this happened... did an admin delete the affiliate account? does the client's account still exist ?? (I assume so)... the activity logs could be a useful place to look for what happened - especially if you know when it occurred. it can be relatively simple to delete something in WHMCS - but a hell of a lot more hassle to get it back having done so! 11 hours ago, Creative Yadley said: When he activated the new account he was obviously assigned a new affiliate ID. The affiliate really needs his old affiliate ID back as he has shared it in too many places so far. the aff ID value is, in reality, their id value in the tblaffiliates database table... and it links the affiliate account with the client account (all affiliates are clients, but clients are not necessarily affiliates). so my first thought would be to look in the tblaffiliates table and see if there is an id record for your affiliate (e.g if their old affiliate number was aff=1, then check the id record for 1)... if it exists, the clientid value in that table will be the id value for your client in tblclients... if it doesn't exist, then that usually means an admin has deleted it... it sounds as though there will be one record at least in tblaffiliates for your client (the new second affiliate account)... one option, though everything I suggest now is dependent upon the current state of the tables, might be to restore the seven affiliate database tables - though whether that is feasible depends on a) you having a backup of them before this affiliate account went missing, and b) the number of new affiliates added since then. if no new affiliates have been added, and the other affiliate tables haven't been affected by the removal of the original affiliate account (and I can't recall off hand whether deleting an affiliate just removes them from one table or all seven), then you might get away with just editing the tblaffiliates table and changing the current ID for the old one (assuming the old id doesn't now exist).... but don't rush in and do that, i'm speaking hypothetically without knowing the current state of the other tables - the last thing you need is to make the situation worse by blindly editing database tables. ⚠️ 0 Quote Link to comment Share on other sites More sharing options...
Creative Yadley Posted May 20, 2020 Author Share Posted May 20, 2020 Wow, thank you very much Brian for such a detailed response! You opened my eyes to a lot of possibilities. Pardon my rookiness here but the tblaffiliates table and all other tblaffiliates tables in MySQL returned an empty result set (i.e. zero rows). In File Manager I do have these files though but the contents are nowhere near anything that relates to specific affiliate data. Most of the files are all about SQL_MODE. I only wish there was an easy way to just backspace an affiliate ID and assign a new one. Please rescue us. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted May 22, 2020 Share Posted May 22, 2020 On 20/05/2020 at 11:41, Creative Yadley said: Pardon my rookiness here but the tblaffiliates table and all other tblaffiliates tables in MySQL returned an empty result set (i.e. zero rows). if accurate, that is not a good sign at all. 😲 in the admin area, what happens when you go clients -> manage affiliates ? if there are still affiliates listed on that page, then there is something in the database... if it's empty, then start to worry. On 20/05/2020 at 11:41, Creative Yadley said: In File Manager I do have these files though but the contents are nowhere near anything that relates to specific affiliate data. Most of the files are all about SQL_MODE. I wouldn't worry too much about that - that might just be the resources folder that you're looking in, and if so, then those files are just used to initially create these tables. On 20/05/2020 at 11:41, Creative Yadley said: I only wish there was an easy way to just backspace an affiliate ID and assign a new one. Please rescue us. there is, but it's depends on the previous data still being in the other tables... if everything was still there, but all that had happened was one affiliate had been removed from tblaffiliates, then that might be salvageable... 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.