Screenshot Center Help

[Colin]

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

[simpilot]

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";

[Colin]

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.