process_submission.php

// Add at the beginning of the file:
function incrementAppViews($pdo, $appId) {
    $stmt = $pdo->prepare("UPDATE apps SET views_count = views_count + 1 WHERE id = ?");
    return $stmt->execute([$appId]);
}

function incrementAppDownloads($pdo, $appId, $userIp) {
    // Record download
    $stmt = $pdo->prepare("INSERT INTO app_downloads (app_id, user_ip) VALUES (?, ?)");
    $stmt->execute([$appId, $userIp]);
    
    // Update download count
    $stmt = $pdo->prepare("UPDATE apps SET downloads_count = downloads_count + 1 WHERE id = ?");
    return $stmt->execute([$appId]);
}

function recordRating($pdo, $appId, $userIp, $rating, $comment = '') {
    try {
        $pdo->beginTransaction();
        
        // Insert or update rating
        $stmt = $pdo->prepare("
            INSERT INTO app_ratings (app_id, user_ip, rating, comment)
            VALUES (?, ?, ?, ?)
            ON DUPLICATE KEY UPDATE rating = ?, comment = ?
        ");
        $stmt->execute([$appId, $userIp, $rating, $comment, $rating, $comment]);
        
        // Update app's total rating
        $stmt = $pdo->prepare("
            UPDATE apps 
            SET total_rating = (
                SELECT AVG(rating) 
                FROM app_ratings 
                WHERE app_id = ?
            ),
            ratings_count = (
                SELECT COUNT(*) 
                FROM app_ratings 
                WHERE app_id = ?
            )
            WHERE id = ?
        ");
        $stmt->execute([$appId, $appId, $appId]);
        
        $pdo->commit();
        return true;
    } catch (Exception $e) {
        $pdo->rollBack();
        throw $e;
    }
}