50 lines
1.9 KiB
Python
50 lines
1.9 KiB
Python
#!/usr/bin/env python3
|
|
"""Check and fix player quickconnect code."""
|
|
|
|
from app import create_app
|
|
from app.models import Player
|
|
from app.extensions import db
|
|
|
|
app = create_app()
|
|
|
|
with app.app_context():
|
|
# Find player by hostname
|
|
player = Player.query.filter_by(hostname='tv-terasa').first()
|
|
|
|
if not player:
|
|
print("❌ Player 'tv-terasa' NOT FOUND in database!")
|
|
print("\nAll registered players:")
|
|
all_players = Player.query.all()
|
|
for p in all_players:
|
|
print(f" - ID={p.id}, Name='{p.name}', Hostname='{p.hostname}'")
|
|
else:
|
|
print(f"✅ Player found:")
|
|
print(f" ID: {player.id}")
|
|
print(f" Name: {player.name}")
|
|
print(f" Hostname: {player.hostname}")
|
|
print(f" Playlist ID: {player.playlist_id}")
|
|
print(f" Status: {player.status}")
|
|
print(f" QuickConnect Hash: {player.quickconnect_code[:60] if player.quickconnect_code else 'Not set'}...")
|
|
|
|
# Test the quickconnect code
|
|
test_code = "8887779"
|
|
print(f"\n🔐 Testing quickconnect code: '{test_code}'")
|
|
|
|
if player.check_quickconnect_code(test_code):
|
|
print(f"✅ Code '{test_code}' is VALID!")
|
|
else:
|
|
print(f"❌ Code '{test_code}' is INVALID - Hash doesn't match!")
|
|
|
|
# Update it
|
|
print(f"\n🔧 Updating quickconnect code to: '{test_code}'")
|
|
player.set_quickconnect_code(test_code)
|
|
db.session.commit()
|
|
print("✅ QuickConnect code updated successfully!")
|
|
print(f" New hash: {player.quickconnect_code[:60]}...")
|
|
|
|
# Verify the update
|
|
if player.check_quickconnect_code(test_code):
|
|
print(f"✅ Verification successful - code '{test_code}' now works!")
|
|
else:
|
|
print(f"❌ Verification failed - something went wrong!")
|