Jump to content
Sign in to follow this  
playjacob

Help with bingo card makeing program

Recommended Posts

playjacob

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
Next
$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
   Next
   If $Continue = True Then ExitLoop
  WEnd
Next
For $i2=1 To 9
  $a = 2
  For $i3 = 0 To 2
   If $Rnd[$i3] = $i2 Then $a = 1
  Next
  $NumPrVRow &= $a
Next
For $i2 = 0 To 2
  $NumbersOnRow[$i2] = 0
Next
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
     ;To
     If ($Rnd2 = $OldRnd2) Or ($NumbersOnRow[$Rnd2-1] > 5) Then $Continue = False
    Next
    $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.
   WEnd
   $FillSpace[$Rnd2*9-9+$i2-1] = 1
  Next
Next
$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)&";"
    Else
     $Rnd3 = Random($i3&0,$i3&9,1)
     $Row[$i2] &= $Rnd3-10&";"
    EndIf
   Else
    $Row[$i2] &= ";"
   EndIf
  Next
  IniWrite($DBFile, $i, $i2+1, StringTrimRight($Row[$i2],1))
  $Full &= $Row[$i2]
Next
IniWrite($DBFile, $i, "f", $Full)
Next
$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
  Next
  $Mats[$i] &= '<td class=rn>'&ConvertToABCAndAddDots($i+1&$i2)&'</td>'&@CRLF
  $Mats[$i] &= '</tr>'&@CRLF
Next
$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
Next
$Output = $Start
For $i = 0 To $NumToGenerate-1
$Output &= $Mats[$i]
Next
$Output &= $End
FileDelete("Index.html")
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)
  Else
   $Out &= $Split2[$b]&Chr(183)
  EndIf
Next
Return $Out
EndFunc

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
JohnOne

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
JohnQSmith

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
BrewManNH

@JohnQSmith

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
JohnQSmith

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
BigDod


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

    • ufukreis1212
      By ufukreis1212
      Hello, I am new members. Help me please. I want vbs convert to au3 .
      This vbs code : 
      'deneme Set SystemSet = GetObject("winmgmts:").InstancesOf ("Win32_OperatingSystem") strOSArch = GetObject("winmgmts:root\cimv2:Win32_OperatingSystem=@").OSArchitecture Set objNetwork = CreateObject("Wscript.Network") Set wshShell = CreateObject( "WScript.Shell" ) strComputerName = wshShell.ExpandEnvironmentStrings( "%COMPUTERNAME%" ) Set oShell = WScript.CreateObject("WScript.Shell") proc_arch = oShell.ExpandEnvironmentStrings("%PROCESSOR_ARCHITECTURE%") Set oEnv = oShell.Environment("SYSTEM") strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2") Set colMB = objWMIService.ExecQuery("Select * from Win32_BaseBoard") Set colCSes = objWMIService.ExecQuery("SELECT * FROM Win32_ComputerSystem") Set colProcessors = objWMIService.ExecQuery("Select * from Win32_Processor") Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2") Set colItemsx = objWMIService.ExecQuery( _ "SELECT * FROM Win32_VideoController",,48) '------------------------------------------------------------------- Set obj = GetObject("winmgmts:").InstancesOf("Win32_PhysicalMemory") i = 1 For Each obj2 In obj memTmp1 = obj2.capacity / 1024 / 1024 TotalRam = TotalRam + memTmp1 i = i +1 Next '-------------------------------------------------------------------- Dim objWMIService : Set objWMIService = GetObject("winmgmts:\\.\root\cimv2") Set colItems = objWMIService.ExecQuery("Select Architecture from Win32_Processor") For Each objItem in colItems if objItem.Architecture = 0 then strArchitecture = "x86" end if if objItem.Architecture = 9 then strArchitecture = "x64" end if next '-------------------------------------------------------------------- strComputer = "." ' Local computer strMemory = "" i = 1 set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemory") For Each objItem In colItems if strMemory <> "" then strMemory = strMemory & vbcrlf strMemory = strMemory & "Bank" & i & " : " & (objItem.Capacity /1024 /1024) & " Mb" i = i + 1 Next installedModules = i - 1 Set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemoryArray") For Each objItem in colItems totalSlots = objItem.MemoryDevices Next '---------------------------------------------------------------------- Set objWMISvc = GetObject( "winmgmts:\\.\root\cimv2" ) Set colItems = objWMISvc.ExecQuery( "Select * from Win32_ComputerSystem" ) For Each objItem in colItems strComputerDomain = objItem.Domain Next for each System in SystemSet For Each objItem in colItemsx For Each objProcessor in colProcessors For Each bbType In colMB MbVendor = bbType.Manufacturer MbModel = bbType.Product MsgBox "İşletim Sistemi : " & System.Caption & vbNewLine & _ "İşletim Sistemi Versionu : " & + System.Version & vbNewLine & _ "Windows Mimari Yapısı: " & strOSArch & vbNewLine & _ "Kullanıcı isminiz: " & objNetwork.UserName & vbNewLine & _ "Bilgisayar ismi: " & strComputerName & vbNewLine & _ "Çalışma Grubu: " & strComputerDomain & vbNewLine & _ "--------------------------------------" & vbNewLine & _ "Anakart: " & MbVendor & " " & "[" & MbModel & "]" & vbNewLine & _ "--------------------------------------" & vbNewLine & _ "Grafik Kartı: " & objItem.Caption & vbNewLine & _ "Driver Version: " & objItem.DriverVersion & vbNewLine & _ "--------------------------------------" & vbNewLine & _ "İşlemci Üreticisi: " & objProcessor.Manufacturer & vbNewLine & _ "İşlemci İsmi: " & objProcessor.Name & vbNewLine & _ "CPU Mimarisi: " & strArchitecture & vbNewLine & _ "İşlemci Çekirdek sayısı: " & oEnv("NUMBER_OF_PROCESSORS") & vbNewLine & _ "--------------------------------------" & vbNewLine & _ "Toplam RAM: " & TotalRam & " MB" & vbNewLine & _ "Toplam Slot: " & totalSlots & vbNewLine & _ "Boş Slot: " & (totalSlots - installedModules) & vbNewLine & _ "Ramlerin bulunduğu slotlar:" & vbcrlf & strMemory,0,"deneme" Next Next Next Next please help me , thanks.
    • JuanFelipe
      By JuanFelipe
       
      Hello friends, I have a query, it happens that I have a matrix nxn, the first column of this contains each cell a number with 21 digits, when I pass this matrix to Excel I obviously write that number as 1,10016E + 20, I solved it by adding a * at the end of each cell, but I want it to be written as a text so that I do not have to remove that *, I searched in Google but could not find an effective solution, thanks in advance. 
    • Puls3
      By Puls3
      Hi, This is my first post on the AutoIt Forums, I most of the time was able to get help from this community by merely searching though google and have been able to solve hundreds of problems this way, though in this case I was incapable of finding a solution to my problem. I am quite confident that it is a user error (And my fault) but I haven't been able to determine what I did wrong, any and all help would be greatly appreciated! I have uploaded my whole script pardon passwords to provide as much information as possible.
      I declared a global array at the top of the script and am having issues when I try to set it's value, and I fail to understand why.
      Error Message:
      "D:\Projects\AutoIt\Arena\Base.au3" (270) : ==> Subscript used on non-accessible variable.:
      $ExpMax[$i] = IniRead($TempSavePath, "Combatant" & $i, "ExpMax", $ExpMax[0])
      $ExpMax^ ERROR
      ConsoleWrite Log:
      Ran.
      Checking launch parameters.
      No launch parameters.
      Initiating load.
      Checking for save file.
      Save file not found.
      Load canceled.
      Loading or creating Combatant 1
      Base.au3
    • RamDemon
      By RamDemon
      Hi,
      Did anyone tried to  use Redis  with AutoIT as store DB ?
       Redis <-- more about it
      Mladen
    • nooneclose
      By nooneclose
      Hey. I'm working on a new project and was wondering if there is a better way to "update" my Column E array. 
      Here is my code: 
      Local $nI  = 0                                                            ;Creates a name index of 0: nI = Name index Local $nII = 1                                                            ;Creates a name index of 1 for second loop: nII = Name Index 2 For    $iN = 0 To $IndexRows Step 1                                       ;Checks the roster for any names that appear twice      For $iN2 = 0 To $IndexRows Step 1          if $d_Names[$nI] == $d_Names[$nII] And $d_Names[$nII] <> "" Then              Local $timeSheetName = _ArraySearch($e_Names, $d_Names[$nI], 0, 0, 0, 0, 1)              ;MsgBox($MB_SYSTEMMODAL, "Found it", $d_Names[$nI] & " In column E on Row " & $timeSheetName)              Local $eI  = $timeSheetName + 1              ;ConsoleWrite($timeSheetName & @CRLF)              ;ConsoleWrite($eI & @CRLF)              ;ConsoleWrite(@CRLF)              _Excel_RangeInsert($OpenWorkbook.ActiveSheet, "E" & $eI & ":F" & $eI, $xlShiftDown)                                                                          ;Inserts a empty cell in columns E and F.              _Excel_RangeWrite($OpenWorkbook, $OpenWorkbook.ActiveSheet, $d_Names[$nII], "E" & $eI)                                                                         ;Fills the empty cell in columns E with the doubled name              $aArray_Index = 2                                           ;Array element counter              For $Index = 2 To $IndexRows Step 1                        ;Loops through every row in the Excel file unto no rows are found or a null row is found                  $Array_Value_E = _Excel_RangeRead($OpenWorkbook, Default, "E"&$Index)                  $e_names[$aArray_Index] = $Array_Value_E                ;While the code loops every value in column E is stored in the E array (updating the array)                  $aArray_Index += 1              Next              ExitLoop          EndIf      Next      $nI  += 1      $nII += 1 Next Basically, It checks a roster for people whose name appears twice then inserts a new "row" for that person because they work in two different departments.
      I have to find that name however in Column E if two appear in column D. My code works but I think it is not as efficient as it could be. 
      Any ideas on how to improve the "update" for my array?
      (once it finds the double names in Column D it then searches for that name by going name by name in the Column E array and once it finds it inserts a new row. However, the E array doesn't have that new row stored in it so I have to "update" the array to properly find the next name)
      Any and all tips would be greatly appreciated. 
       
      NOTE: Just assume I'm opening the excel file properly please do not add that code in, it only complicates your answer. 
×