app.py

from flask import Flask, render_template, request, session, redirect, url_for
import sqlite3 as sqltor
import random
import datetime
import pandas as pd
import os

app = Flask(__name__)
app.secret_key = 'your_secret_key'  # Change this to a random secret key

# Database connection
def get_db_connection():
    return sqltor.connect('cs_proj.db')

# Initialize database
def init_db():
    mycon = get_db_connection()
    cursor = mycon.cursor()
    cursor.execute(
        "create table if not exists user_data(user_name varchar(50), user_id varchar(50), password varchar(50), age int)")
    cursor.execute(
        "create table if not exists game_data(user_name varchar(50), date_played date, time_played time, toss_decision varchar(50), user_total_runs varchar(50), user_4s varchar(50), user_6s varchar(50), match_result varchar(100))")
    cursor.execute("create table if not exists leaderboard(trial int)")
    mycon.close()

@app.route('/')
def home():
    if 'user' in session:
        return redirect(url_for('menu'))
    return render_template('index.html')

@app.route('/register', methods=['GET', 'POST'])
def register():
    if request.method == 'POST':
        user_name = request.form['username']
        user_passwd = request.form['password']
        confirm_passwd = request.form['confirm_password']
        user_age = request.form['age']
        
        if user_passwd != confirm_passwd:
            return render_template('register.html', error="Passwords do not match")
        
        mycon = get_db_connection()
        cursor = mycon.cursor()
        cursor.execute("select user_name from user_data")
        user_list = [i[0] for i in cursor.fetchall()]
        
        if user_name in user_list:
            mycon.close()
            return render_template('register.html', error="Username already exists")
        
        user_id = random.randint(10000, 99999)
        cursor.execute("insert into user_data values(?, ?, ?, ?)", (user_name, str(user_id), user_passwd, int(user_age)))
        mycon.commit()
        mycon.close()
        
        session['user'] = user_name
        return redirect(url_for('menu'))
    
    return render_template('register.html')

@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        user_name = request.form['username']
        user_passwd = request.form['password']
        
        mycon = get_db_connection()
        cursor = mycon.cursor()
        cursor.execute("select password from user_data where user_name = ?", (user_name,))
        result = cursor.fetchone()
        mycon.close()
        
        if result and result[0] == user_passwd:
            session['user'] = user_name
            return redirect(url_for('menu'))
        else:
            return render_template('login.html', error="Invalid credentials")
    
    return render_template('login.html')

@app.route('/menu')
def menu():
    if 'user' not in session:
        return redirect(url_for('home'))
    return render_template('menu.html', user=session['user'])

@app.route('/logout')
def logout():
    session.pop('user', None)
    return redirect(url_for('home'))

@app.route('/history')
def history():
    if 'user' not in session:
        return redirect(url_for('home'))
    
    mycon = get_db_connection()
    cursor = mycon.cursor()
    cursor.execute("select * from game_data where user_name = ?", (session['user'],))
    data = cursor.fetchall()
    mycon.close()
    
    columns = ['User_Name', 'Date_Played', 'Time_Played', 'Toss_Decision', 'User_Total_Runs', 'User_4s', 'User_6s', 'Match_Result']
    df = pd.DataFrame(data, columns=columns)
    history_html = df.to_html(index=False)
    
    return render_template('history.html', history=history_html)

@app.route('/leaderboard')
def leaderboard():
    if 'user' not in session:
        return redirect(url_for('home'))
    
    mycon = get_db_connection()
    cursor = mycon.cursor()
    cursor.execute("""
        SELECT user_name, SUM(CAST(user_total_runs AS INTEGER)) as total_runs, COUNT(*) as games_played
        FROM game_data
        GROUP BY user_name
        ORDER BY total_runs DESC
        LIMIT 10
    """)
    data = cursor.fetchall()
    mycon.close()
    
    columns = ['User_Name', 'Total_Runs', 'Games_Played']
    df = pd.DataFrame(data, columns=columns)
    leaderboard_html = df.to_html(index=False)
    
    return render_template('leaderboard.html', leaderboard=leaderboard_html)

@app.route('/game', methods=['GET', 'POST'])
def game():
    if 'user' not in session:
        return redirect(url_for('home'))
    
    if request.method == 'POST':
        action = request.form.get('action')
        if action == 'start':
            session['game_state'] = 'rules'
            session['show_rules'] = True
        elif action == 'skip_rules':
            session['game_state'] = 'toss'
            session['show_rules'] = False
        elif action == 'toss':
            player_oe = request.form.get('oe')
            player_toss = int(request.form.get('toss_num'))
            comp_toss = random.randint(1, 6)
            toss_sum = player_toss + comp_toss
            sum_oe = 'e' if toss_sum % 2 == 0 else 'o'
            if player_oe == sum_oe:
                session['toss_decision'] = "You won the toss!"
                session['game_state'] = 'choose_bat_bowl'
            else:
                session['toss_decision'] = "Computer won the toss!"
                session['player_bb'] = random.randint(1, 2)  # 1 bat, 2 bowl
                session['inning'] = 1
                session['player_score'] = 0
                session['comp_score'] = 0
                session['player_4s'] = 0
                session['player_6s'] = 0
                session['comp_4s'] = 0
                session['comp_6s'] = 0
                session['game_state'] = 'play'
        elif action == 'choose_bat_bowl':
            session['player_bb'] = int(request.form.get('bat_bowl'))
            session['inning'] = 1
            session['player_score'] = 0
            session['comp_score'] = 0
            session['player_4s'] = 0
            session['player_6s'] = 0
            session['comp_4s'] = 0
            session['comp_6s'] = 0
            session['game_state'] = 'play'
        elif action == 'bat':
            player_hit = int(request.form.get('hit'))
            comp_bowl = random.randint(1, 6)
            if player_hit == comp_bowl:
                # Out
                if session.get('inning', 1) == 1:
                    session['inning'] = 2
                    session['player_bb'] = 2 if session.get('player_bb', 1) == 1 else 1  # Switch
                    session['game_state'] = 'play'
                else:
                    # End game
                    player_score = session.get('player_score', 0)
                    comp_score = session.get('comp_score', 0)
                    if player_score > comp_score:
                        session['result'] = f"You win! You scored {player_score} runs, Computer scored {comp_score} runs."
                    elif player_score < comp_score:
                        session['result'] = f"Computer wins! You scored {player_score} runs, Computer scored {comp_score} runs."
                    else:
                        session['result'] = f"It's a tie! Both scored {player_score} runs."
                    session['game_state'] = 'end'
            else:
                session['player_score'] = session.get('player_score', 0) + player_hit
                if player_hit == 4:
                    session['player_4s'] = session.get('player_4s', 0) + 1
                elif player_hit == 6:
                    session['player_6s'] = session.get('player_6s', 0) + 1
                session['last_hit'] = player_hit
                session['last_bowl'] = comp_bowl
                # Check if chasing
                if session.get('inning', 1) == 2 and session.get('player_bb', 1) == 1 and session.get('player_score', 0) > session.get('comp_score', 0):
                    session['result'] = f"You win! You scored {session['player_score']} runs, Computer scored {session['comp_score']} runs."
                    session['game_state'] = 'end'
        elif action == 'bowl':
            player_bowl = int(request.form.get('bowl'))
            comp_hit = random.randint(1, 6)
            if player_bowl == comp_hit:
                # Out
                if session.get('inning', 1) == 1:
                    session['inning'] = 2
                    session['player_bb'] = 2 if session.get('player_bb', 1) == 1 else 1  # Switch
                    session['game_state'] = 'play'
                else:
                    # End game
                    player_score = session.get('player_score', 0)
                    comp_score = session.get('comp_score', 0)
                    if player_score > comp_score:
                        session['result'] = f"You win! You scored {player_score} runs, Computer scored {comp_score} runs."
                    elif player_score < comp_score:
                        session['result'] = f"Computer wins! You scored {player_score} runs, Computer scored {comp_score} runs."
                    else:
                        session['result'] = f"It's a tie! Both scored {player_score} runs."
                    session['game_state'] = 'end'
            else:
                session['comp_score'] = session.get('comp_score', 0) + comp_hit
                if comp_hit == 4:
                    session['comp_4s'] = session.get('comp_4s', 0) + 1
                elif comp_hit == 6:
                    session['comp_6s'] = session.get('comp_6s', 0) + 1
                session['last_bowl'] = player_bowl
                session['last_hit'] = comp_hit
                # Check if chasing
                if session.get('inning', 1) == 2 and session.get('player_bb', 1) == 2 and session.get('comp_score', 0) > session.get('player_score', 0):
                    session['result'] = f"Computer wins! You scored {session['comp_score']} runs, You scored {session['player_score']} runs."
                    session['game_state'] = 'end'
        elif action == 'save_game':
            # Save to database
            mycon = get_db_connection()
            cursor = mycon.cursor()
            cursor.execute("insert into game_data values(?, ?, ?, ?, ?, ?, ?, ?)", (
                session['user'], str(datetime.date.today()), str(datetime.datetime.now().strftime("%H:%M:%S")),
                session.get('toss_decision', ''), str(session.get('player_score', 0)), str(session.get('player_4s', 0)),
                str(session.get('player_6s', 0)), session.get('result', '')
            ))
            mycon.commit()
            mycon.close()
            session.clear()
            return redirect(url_for('menu'))
    
    return render_template('game.html')

# Add more routes for game logic as needed

if __name__ == '__main__':
    init_db()
    app.run(debug=True)