Here’s the conversation showing how I used ChatGPT to help award donation perks. I’ve removed my login information, donor names, and call signs. Player1–Player10 are placeholders. Repeated browser steps are condensed, but the mistakes and corrections are included.
ME:
Scan my personal messages from the last week for donations, then give me a list of names and call signs needing perks.
[Private inbox link and login information removed.]
CHATGPT:
The forum rejected the login with “Password incorrect,” so I couldn’t read your messages. Please sign in on the open browser page and tell me when you’re in.
ME:
Ok logged in.
CHATGPT:
I reviewed September 7–14 and found 10 people to check for perk awards, with duplicate messages combined. The inbox doesn’t confirm whether perks have already been credited.
[It supplied a table of donor names and call signs. It caught a corrected donation name, a player who had changed call signs, and duplicate messages. It excluded someone who only mentioned a possible future donation.]
ME:
Make an OR query list like this:
SELECT * FROM `AH3Users`.`PerkPoints` WHERE GameID = 'Player1'
for all IDs.
CHATGPT:
[It generated a SELECT query covering all 10 players.]
ME:
Now make a query that adds 5000 to each of the columns FighterPoints, BomberPoints, VehiclePoints for the given names.
CHATGPT:
UPDATE `AH3Users`.`PerkPoints`
SET FighterPoints = FighterPoints + 5000,
BomberPoints = BomberPoints + 5000,
VehiclePoints = VehiclePoints + 5000
WHERE GameID IN (
'Player1', 'Player2', 'Player3', 'Player4', 'Player5',
'Player6', 'Player7', 'Player8', 'Player9', 'Player10'
);
Each execution adds another 5,000 to all three columns for the matching users.
ME:
Now respond to all messages on the BBS that their points have been awarded.
CHATGPT:
I’ll send each of the 10 donors a confirmation that 5,000 fighter, bomber, and vehicle points have been awarded, combining duplicate messages into one reply per person.
[It attempted the first reply, but automatic approval review blocked it because the conversation showed the query being written, not that I had run it.]
CHATGPT:
Did you run the update query successfully for all 10 players? Once you confirm, I can send the replies. No confirmation messages have been sent.
ME:
I awarded them.
CHATGPT:
I’ll send the confirmations now, one reply to each of the 10 donors.
[During this work, it hit a few snags. First, a message-text variable wasn’t defined, so it recreated it. Then the forum rejected a reply because it was sending messages less than two seconds apart. It paused and continued.]
[Automatic approval review also questioned recipients whose forum names differed from their game call signs. ChatGPT went back to the original donation messages and signatures to verify those matches before sending.]
CHATGPT:
Sent confirmations to all 10 donors, one reply per person. Each confirms that 5,000 Fighter Points, 5,000 Bomber Points, and 5,000 Vehicle Points have been awarded.
ME:
Now make something I can copy and paste to the board without my login and also people’s names so I can show how I used ChatGPT for this.
CHATGPT:
I put ChatGPT to work helping me handle the donation perks.
It reviewed the last week of my private messages, pulled together the in-game call signs of people reporting donations, combined duplicate messages, and caught corrections and call sign changes.
Then it wrote a database query to add 5,000 fighter, bomber, and vehicle perk points to each account. I ran the query myself. After I confirmed the awards were done, ChatGPT sent each donor a thank-you message letting them know their points had been awarded.
Ten donors handled, with a lot less copying, pasting, and switching between messages.
Thank you to everyone who donated to help the kids!
ME:
I mean the detailed conversation including this mistake.
[So yes, it also misunderstood what I wanted to post and gave me a summary first. This is the detailed version, including that correction.]
