Social Logins & QR Logic

I’m running a PHP application purchased from CodeCanyon and need two focused improvements.

1. Social sign-in
Right now the script only supports its native username/password flow. I want to integrate OAuth so users can log in with Google, Facebook, Instagram and Outlook. After authentication the script must create or link the local account seamlessly and respect the existing role / plan structure.

2. Plan-change behaviour
When a free user upgrades to any paid plan, every QR code they created while on the free tier must automatically flip to “inactive”. The user should see a simple toggle or button beside each code and be able to reactivate them individually; no re-creation should be necessary. Database entries, statistics and existing short links must stay intact—only the active flag changes.

The codebase is clean MVC PHP with MySQL; please stay within that stack, use official SDKs where available, and keep third-party libraries lightweight. Deliverables are:
• Fully tested OAuth integration for Google, Facebook, Instagram, Outlook
• Database and UI tweaks that enforce the new QR reactivation rule
• Brief install/update notes so I can reproduce the setup on staging and production

If anything in the current script blocks these goals, outline the workaround first so we agree on scope before coding.