Find Jobs
Hire Freelancers

Add few minor functions to existing site -- 3

$10-50 USD

Cancelado
Publicado hace más de 7 años

$10-50 USD

Pagado a la entrega
Hello, Site: [login to view URL] Queries are like: $games = ORM::for_table('games') ->table_alias('g') ->select('g.*') ->select('[login to view URL]', 'league_name') ->select('[login to view URL]', 'home_team_name') ->select('[login to view URL]', 'away_team_name') ->left_outer_join('leagues', 'g.league_id = [login to view URL]', 'l') ->left_outer_join('teams', 'g.home_team_id = [login to view URL]', 'ht') ->left_outer_join('teams', 'g.away_team_id = [login to view URL]', 'at') ->where('id', $id) ->find_array(); What need to be done, 1. Index to: Featured games mixed from both DBs - tennis and soccer and ordered by GMT. Now is: Query Soccer -> Display, Query Tennis -> Display To be: Query Tennis + Query Soccer -> Merge results and Sort by start_time -> Display sorted 2. Index to: Have a simple .php which is checking: Is there X games/per sport featured games on Index? If not auto-change Featured from 0 to 1 to fill up to X games, on games where Best Odds are from diff bookies /there is written function for this/. E.g. check if there are enough games marked as Featured, if not - mark some So by this always to have featured games on Index Include word "spesse" into bidding, otherwise your bid will be ignored. 3. Compare and match names: In DB players are with their full names: Like: Aleksandra Wozniak But same bookie could write it, Aleksandra Wozniak, A Wozniak, Al Wozniak, Wozniak, A. Wozniak or Al. Wozniak E.g. Just code for matching names. Code for create/update game is existing. 4. Adding a timestamp to Odds table - on time of creation or updating and then on Showing games on Index or other places - if timestamp if <X minutes - add text "Outdated Odd" and then Odd e.g. Add additional field in DB and implement it in 3 code files for inserting and showing.
ID del proyecto: 11800640

Información sobre el proyecto

Proyecto remoto
Activo hace 8 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

Sobre este cliente

Bandera de BULGARIA
Sofia, Bulgaria
4,9
14
Forma de pago verificada
Miembro desde may 27, 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.