Colin Posted December 30, 2012 Report Share Posted December 30, 2012 Hi guys, I changed the pilot ID's to stop being a mess, out of synch etc etc as pilots have come and go, For some reason on the screenshot center, all the screenshots that have been submitted the pilot ID's are now 000 , any ideas how I can fix it to display the pilots new ID's please ? Starting to regret doing it a little bit, one of those seems like a good idea at the time scenarios. Many thanks in advance Colin Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted December 31, 2012 Administrators Report Share Posted December 31, 2012 There is no function in the screenshot module to change the id's of the pilots that submitted the images. You could use phpMyAdmin to change the id's manually. Something like; UPDATE screenshots SET pilot_id = "new pilot id" WHERE pilot_id = "old pilot id"; Quote Link to comment Share on other sites More sharing options...
Colin Posted January 2, 2013 Author Report Share Posted January 2, 2013 No problem I figured that would be the case, Only thing with changing them manually I'd need to know who uploaded them in the first place, but because they are all 000 I haven't a clue lol Something seemed to tell me I should of left it alone, or well live and learn lol, Thanks for the reply though much appreciated mate. 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.