Jump to content
Sign in to follow this  

Help with bingo card makeing program

Recommended Posts


For the past days i've been working on a program to make bingo cards, but now i've have a problem.

The problem is that i only want 5 numbers on each row and they sould be spred randomly.

To see the final result just open up Index.html after you've run the code.

Look at the comments in the code for more info.

Global $DBFile = @ScriptDir&"\Cards.txt"
Global $NumToGenerate = 250
Global $Rnd[3]
Global $NumPrVRow = ""
Global $FillSpace[27]
Global $Row[3]
Global $Output
Global $Mats[$NumToGenerate]
Global $NumbersOnRow[3]
;Create Database File With Mats
For $i = 1 To $NumToGenerate
ConsoleWrite('@@ Debug(' & @ScriptLineNumber & ') : $i = ' & $i & @crlf & '>Error code: ' & @error & @crlf) ;### Debug Console
$a = ""
For $i2 = 0 To 26
  $FillSpace[$i2] = 0
$i2 = ""
$i3 = ""
$i4 = ""
$NumPrVRow = ""
For $i2 = 0 To 2
  While 1
   $Rnd[$i2] = Random(1,9,1)
   $Continue = True
   For $i3 = 0 To $i2
    If ($Rnd[$i2] = $Rnd[$i3]) And ($i2 <> $i3) Then $Continue = False
   If $Continue = True Then ExitLoop
For $i2=1 To 9
  $a = 2
  For $i3 = 0 To 2
   If $Rnd[$i3] = $i2 Then $a = 1
  $NumPrVRow &= $a
For $i2 = 0 To 2
  $NumbersOnRow[$i2] = 0
For $i2 = 1 To 9
  $OldRnd2 = ""
  For $i3 = 1 To StringMid($NumPrVRow, $i2,1)
   While 1
    $Rnd2 = Random(1,3,1)
    ;I tryed to add this line.
    $NumbersOnRow[$Rnd2-1] += 1
    $Continue = True
    For $i4 = 0 To $i2
     ;And change This
     ;If $Rnd2 = $OldRnd2  Then $Continue = False
     If ($Rnd2 = $OldRnd2) Or ($NumbersOnRow[$Rnd2-1] > 5) Then $Continue = False
    $OldRnd2 = $Rnd2
    If $Continue = True Then ExitLoop
    ;And Then Also Add This Line:
    $NumbersOnRow[$Rnd2-1] -= 1
    ;But i still could'nt get it to work.
   $FillSpace[$Rnd2*9-9+$i2-1] = 1
$Full = ""
For $i2 = 0 To 2
  $Row[$i2] = ""
  For $i3 = 1 To 9
   If $FillSpace[($i2+1)*9-9+$i3-1] = 1 Then
    If $i3 = 1 Then
     $Row[$i2] &= Random(1,9,1)&";"
     $Rnd3 = Random($i3&0,$i3&9,1)
     $Row[$i2] &= $Rnd3-10&";"
    $Row[$i2] &= ";"
  IniWrite($DBFile, $i, $i2+1, StringTrimRight($Row[$i2],1))
  $Full &= $Row[$i2]
IniWrite($DBFile, $i, "f", $Full)
$Start = '<html>'&@CRLF&'<head>'&@CRLF&'<style type=text/css>'&@CRLF&'    body { font-family: Verdana, Arial, Helvetica;}'&@CRLF&'    tr { text-align: center; }'&@CRLF&'    .c { padding-top: 35px; padding-bottom: 5px;'&@CRLF&'      border-bottom: 2px dashed black; }'&@CRLF&'    .s { padding-top: 5px; padding-bottom: 35px; }'&@CRLF&'    .c, .s { font-size: 8px;}'&@CRLF&'    .pb { page-break-before: always; }'&@CRLF&'    .rn { font-family: Verdana, Arial, Helvetica; font-size: 13px; border: 2px solid black;}'&@CRLF&'    .pn { font-family: Verdana, Arial, Helvetica; font-size: 18px; text-align: center;}'&@CRLF&'</style>'&@CRLF&'</head>'&@CRLF&'<body onLoad="print();">'&@CRLF&@CRLF&@CRLF
$End = @CRLF&'</body></html>'&@CRLF
$PageBreak = 1
For $i = 0 To $NumToGenerate-1
ConsoleWrite('@@ Debug(' & @ScriptLineNumber & ') : $i = ' & $i & @crlf & '>Error code: ' & @error & @crlf) ;### Debug Console
$Mats[$i] = '<div class=pn>Pladenummer: '&$i+1&'F</div>'&@CRLF&'<table width=90% border=1 cols=10 align=center cellspacing=0'&@CRLF&'style="border-collapse: collapse" cellpadding=10> <tr>'
For $i2 = 1 To 3 ;Change To ABC
  $Mats[$i] &= '<tr>'&@CRLF
  $Split = StringSplit(IniRead($DBFile, $i+1, $i2, ""),";")
  For $i3 = 1 To 9
   $Mats[$i] &= '<td>'&$Split[$i3]&'</td>'&@CRLF
  $Mats[$i] &= '<td class=rn>'&ConvertToABCAndAddDots($i+1&$i2)&'</td>'&@CRLF
  $Mats[$i] &= '</tr>'&@CRLF
$Mats[$i] &= '</table><div class=c>Made using The Bingo Program by Jacob Bom Andersen</div></br>'&@CRLF
If $PageBreak = 4 Then $Mats[$i] &= '<div class=pb></div>'
$PageBreak += 1
$Output = $Start
For $i = 0 To $NumToGenerate-1
$Output &= $Mats[$i]
$Output &= $End
FileWrite("Index.html", $Output)
Func ConvertToABCAndAddDots($ToConvert)
$Split2 = StringSplit($ToConvert, "")
$Out = ""
For $b = 1 To $Split2[0]
  If $b = $Split2[0] Then
   $Out &= Chr($Split2[$b]+64)
   $Out &= $Split2[$b]&Chr(183)
Return $Out

Ps. The Database File that it is also makeing is for an other program that i've made to play bingo, witch is then also able to check is someone has bingo.

Sorry for my bad english.

Share this post

Link to post
Share on other sites

To be honest, I would have to study that code for an hour to begin to see what is going on.

Only advice I can offer at this time is to make use of functions to make your code more modular, readable

and easier to debug.

AutoIt Absolute Beginners    Require a serial    Pause Script    Video Tutorials by Morthawt   ipify 

Monkey's are, like, natures humans.

Share this post

Link to post
Share on other sites

Just glancing over your code, I don't see you following the "rules" for bingo.

Here's what you need to make sure you implement.

There are 5 columns and 5 rows on each card. The columns are labeled B, I, N, G, and O. Each column can only contain a specific set of numbers.

B (1-15), I (16-30), N (31-45), G (46-60), O (61-75)

Also, the numbers in each column must be unique (you cannot have two or more of the same number on any card), but can appear in any order in their respective column.

Whenever someone says "pls" because it's shorter than "please", I say "no" because it's shorter than "yes".

Share this post

Link to post
Share on other sites


That only applies to BINGO in the US and parts of Canada, he's making cards for European BINGO games which are different. I had to look that one up myself yesterday. ;)

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post

Link to post
Share on other sites

he's making cards for European BINGO games which are different

Holy crap, will ya look at that! I didn't know there were different kinds. Thanks for the info. Learned something new ;) which means it's a good day.

Whenever someone says "pls" because it's shorter than "please", I say "no" because it's shorter than "yes".

Share this post

Link to post
Share on other sites

Get Beta versions Here Get latest SciTE editor Here AutoIt 1-2-3 by Valuater - A great starting point.

Time you enjoyed wasting is not wasted time ......T.S. Elliot
Suspense is worse than disappointment................Robert Burns
God help the man who won't help himself, because no-one else will...........My Grandmother

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • nooneclose
      By nooneclose
      How to use _Excel_RangeSort to sort my excel file by three different headers Column A1, B1, and C1 have headers on which I want to sort by. The headers on which I want to sort are department, employee type, and name.
      I still really new to AutoIt so I do not actually know how to properly start this line or lines of code, to be honest. The example code is the best I can do.
      _Excel_RangeSort($OpenWorkbook, Default, "A1:C1", "1:1", $xlDescending, Default, $xlYes, Default, $xlSortRows) I just need to sort by those three headers in that order of department, employee type, and name, plus in descending order.
      any and all help would be greatly appreciated.  Thank you!
    • Eminence
      By Eminence
      Using SQLite, I was trying to select a specific column with having duplicate entries removed by using the DISTINCT function. 
      Local $sQuery = "SELECT DISTINCT supervisor, COUNT(DISTINCT employee_name) FROM data_db What the above snippet does is just list only one supervisor but with the total count of unique employee names in the whole database when it should be listing out all supervisor entries from the database and list the total count of employees per each supervisors. If I remove the COUNT function, it does list out all unique entries of supervisor names from the list. Attached is a screenshot of an example database as well. 
      Any help will be much appreciated. Thank you!

    • PramodR
      By PramodR
      I see couple of ways to import module ,  one with specifying absolute path of the file to get imported, by this logic i believe to import a specific module will be like #include <c:\modulepath\duplicatemodule.au3>
      but i see some registry changes also made in this link , can someone explain why that registry change is really required.
    • fikri
      By fikri
      Hello to all.
      I would like to make automation for LabView compiled project exe.
      Actually I just need to get values (results) from labview textboxes. But since labview not using MS componenents, is that possible.
      I spend lot of time by googling and tried some scripts but without success.
      Is this possible at all? 
      Also, I cannot read text properties window by any spy tool?  
      here is what I have from AutoIt Info:
      Class: LVDChild
      Position: -8, -8
      Size: 1456, 876
      Style: 0x17CF0000
      ExStyle: 0x00040300
      Handle: 0x001F041C >>>> Control <<<<
      Advanced (Class): 
      ControlClick Coords: 
      Handle:  >>>> Mouse <<<<
      Position: 1256, 267
      Cursor ID: 0
      Color: 0xFAFAFA >>>> StatusBar <<<< >>>> ToolsBar <<<< >>>> Visible Text <<<<
      >>>> Hidden Text <<<<
    • toto22
      By toto22
      I have a string that look like this:

      WIFI    13.8    26.59
      BCRX    9.6    13.34
      GTES    8.5    11.15
      DFRG    5.9    33.02
      GIL    5.5    12.08
      How can I simply build an Array with it?