Hi.

I will venture to get a module to display Local Lottery numbers. I need help with the SQL file tou. Basically I want to show:

Results by date. The DB will store the winning numbers for showing if person want.

1- Main The Lotto have a 6 numbers result
2- We have another prize called Pega 4 -> 4 numbers
3- Pega 3 --> 3 numbers
4- Pega 2 --> 2 numbers

Also, the DB should have a table for next Lotto and estimated prize.

Basically I am looking for a functionality similar to the Lotto module available at the link below. The problem besides it being a nuke mod is the license is closed. So I have to create it from zero...

http://www.preciogasolina.com/

I have made some 'hacks' and I am somohow familiar with PHP code and I think I could develop it. The example module should be helpful also.

Thanks in Advance

Edfel

I found this... so I have an idea ...

# phpMyAdmin SQL Dump
# version 2.5.6-RC1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Feb 09, 2004 at 04:50 PM
# Server version: 4.0.15
# PHP Version: 4.2.3
#
# Database : `lotto`
#

# --------------------------------------------------------

#
# Table structure for table `lotto`
#

CREATE TABLE `lotto` (
`date` date NOT NULL default '0000-00-00',
`ball1` tinyint(4) NOT NULL default '0',
`ball2` tinyint(4) NOT NULL default '0',
`ball3` tinyint(4) NOT NULL default '0',
`ball4` tinyint(4) NOT NULL default '0',
`ball5` tinyint(4) NOT NULL default '0',
`ball6` tinyint(4) NOT NULL default '0',
`bonus` tinyint(4) NOT NULL default '0',
`ballset` tinyint(4) NOT NULL default '0',
`machine` varchar(20) NOT NULL default '',
KEY `date` (`date`)
) TYPE=MyISAM;


Later

After browsing the web through Google, I think have the basic tools to make it. I have one question about the Admin Interface or Menu, any tip or code snipet re how to EDIT, ADD, or DELETE data from the DB and tables?

TIA

I would suggest you take a look at the Example module that is shipped with the PN Core. Take that and modify it to your needs it has everything you will need for a basic module and is well written to include all the comments about each section and function so as to explain what is going on in each.


-SUNADMN