Find Jobs
Hire Freelancers

Complex MySqlQuery

$30-40 USD

Cancelado
Publicado hace alrededor de 15 años

$30-40 USD

Pagado a la entrega
This is a quick and easy project for MySql savvy coders who know what they are doing. I have a database of play information for a game I am building. I need query to pull data from that database. DB Description: The db is a version of Fox and supports mysql queries. We have a user table showing accumulated play stats (level, exp, total number of attacks, etc). We also have a session table showing stats for each session (session start time, end time, exp gained, monsters killed, etc). The session table does not have the player’s level for the session and is why the query becomes complex. The user_id from the user table is also used in the session table to match which sessions belong to which user. Database Tables: User Table Columns user_id, level, goldTotal, totalTime, totalAttack, totalCrit, totalSpell, totalExp, totalBought, totalSold, totalTimesLoggedIn, dateStart Session Table Columns session_id, user_id, sessionTime, startTime, endTime, sessionGold, sessionAttacks, sessionCrits, sessionSpell, ssessionExp, sessionBought, sessionSold Results I would like: I would like a mysql query I can enter into the query window to show the following results: Accumulation/sum of each column of the “session table?? for the first X many sessions per “user_id?? at currently at a specific “level??(defined in the user table) Where the sum of the sessionExp of these first X sessions is less than 60(or another number I specify). When I say “first X sessions??, I don’t know how many sessions each player plays before they hit a cumulative experience level of 60. Part of this query is to figure out that number of sessions (I’d like to derive it rather than hard code it). The form of the deliverable: The deliverable will be a complex MySql query (multiple parts ok) I can type into a manual query window. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform mysql, fox database, linux, lamp, windows, database
ID del proyecto: 3510023

Información sobre el proyecto

1 propuesta
Proyecto remoto
Activo hace 15 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
1 freelancer está ofertando un promedio de $11 USD por este trabajo
Avatar del usuario
See private message.
$11,05 USD en 1 día
5,0 (13 comentarios)
2,4
2,4

Sobre este cliente

Bandera de UNITED STATES
Allen, United States
5,0
14
Miembro desde nov 3, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.