Welcome, Guest. Please login or register.
June 16, 2024, 12:56:02 AM

Login with username, password and session length
* Home Help Arcade Login Register
.
+  Forum
|-+  Homebrew Player Tracking and EFT Systems.
| |-+  NLG Homebrew Player Tracking and EFT Systems.
| | |-+  Yeah , got my tTITO working
0 Members and 2 Guests are viewing this topic. « previous next »
Pages: [1] 2 3 Go Down Print
Author Topic: Yeah , got my tTITO working  (Read 27493 times)
zarobhr
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 178
Offline Offline

Gender: Male
Posts: 622



« on: June 23, 2011, 02:39:05 PM »

Got my TITO working today with 1 machine now to work on multiple machines at the same time

what it does

when i hit cash out it sends the validation number and amount to my laptop which puts in a database.

when ticket is inserted it sends validation number to the laptop which then looks it up in the database and then redeems the ticket.

yeay
Logged
StatFreak
rotaredoM etiS GLN labolG
Global NLG Site Moderator
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 756
Offline Offline

Gender: Male
Posts: 8549


Warning! Spammers will be eaten, with relish!


« Reply #1 on: June 23, 2011, 05:08:06 PM »

 Congratulations    Fantastic!!  applause applause  Cheer Leader

So, what settings worked?
      What database program did you use? (MySQL, MSAccess, SQL Server, etc.)
      How did you access the database from the program?
Logged

I found myself at NLG garfield  ..but got lost again on the way home. Scratch Head 2
If found, please email me to myself. Thanks. yes
       Executive member in good standing of Rick's SMAA.                              Ehhh...What's Up Doc?
zarobhr
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 178
Offline Offline

Gender: Male
Posts: 622



« Reply #2 on: June 23, 2011, 05:19:38 PM »

Congratulations    Fantastic!!  applause applause  Cheer Leader

So, what settings worked?
      What database program did you use? (MySQL, MSAccess, SQL Server, etc.)
      How did you access the database from the program?
right now I am using standard validation,(enhanced validation not working quite yet will need to get andyp to fix that)
useing sql server for the database
i am using visual studio 2010 to modify write it using andyp's dll
Logged
knagl
Global NLG Site Moderator
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 642
Offline Offline

Gender: Male
Posts: 5489


Kevin


« Reply #3 on: June 23, 2011, 07:25:36 PM »

That's awesome!  Congrats.
Logged

If you find this site helpful, please consider making a small donation to help defray the cost of hosting and bandwidth.

Please do not PM me for support or "how to" requests -- please post your request in the forum so that everyone may assist you and everyone can benefit from the answer to your question!  Thanks! Smiley
Forrhouse
Manufacturing Equipment & Parts to Keep Slots that are No Longer Supported by the Manufacturer running.
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 252
Offline Offline

Gender: Male
Posts: 532


Life is too short, live, love and have a good time


« Reply #4 on: July 17, 2011, 07:51:40 AM »

That is Awesome. Congrats!  That is definitely a great achievment  Hail
K+
Logged
Magicslots
Contributing NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 62
Offline Offline

Gender: Male
Posts: 810



« Reply #5 on: July 17, 2011, 07:34:58 PM »

 Cheer Leader Cheer Leader  Congrats....Superb  Hail  It makes me jealous...guess I am gonna have to get off my butt and start working on getting mine to work... Clap
Logged

"Any man who is under 30, and is not a liberal, has no heart; and any man who is over 30, and is not a conservative, has no brains."  (Sir Winston Churchill)
FORDSBS
Contributing NLG Member
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 363
Offline Offline

Gender: Male
Posts: 4162


PET


« Reply #6 on: July 17, 2011, 07:48:04 PM »

Way to go zarobhr.  Clap Clap applause applause
I think it makes playing the game  fun & more interesting.
Ford
« Last Edit: July 17, 2011, 07:59:07 PM by FORDSBS » Logged
idesign
Senior Full time Member.
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 509
Offline Offline

Gender: Male
Posts: 1456


If it aint broke why mess with it?????


« Reply #7 on: July 17, 2011, 08:10:06 PM »

Once you feed a ticket in can it be used again?
Logged
FORDSBS
Contributing NLG Member
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 363
Offline Offline

Gender: Male
Posts: 4162


PET


« Reply #8 on: July 17, 2011, 08:12:33 PM »

Once you feed a ticket in can it be used again?


Not on my setup
Logged
Neonkiss
Contributing Gold NLG Member
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 436
Offline Offline

Gender: Male
Posts: 2084



« Reply #9 on: July 17, 2011, 08:21:51 PM »

Once you feed a ticket in can it be used again?


Only if you do a game change.
I keep an extra MPU with another game set-up on it. his way I can pull out the tickets from the cash can and re-insert them with the other game installed.

Then tickets cashed from that game will validate and go back into the cash can.
A change back to the original game, and the tickets from the cash can will validate again.
Theoretically, never have to use cash again.

But mine is a little different set up on a UV1700
Logged

Nothing brings people together better than a common enemy
343 / 60 brothers lost on that day.
StatFreak
rotaredoM etiS GLN labolG
Global NLG Site Moderator
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 756
Offline Offline

Gender: Male
Posts: 8549


Warning! Spammers will be eaten, with relish!


« Reply #10 on: July 17, 2011, 09:28:12 PM »

You can write your code either way. If you want to reuse tickets, leave them in the database and don't perform any checks to determine if the ticket has been used. If not, then either delete the records (not best practice) or have an extra field and set a flag with your code when the ticket is redeemed.
Logged

I found myself at NLG garfield  ..but got lost again on the way home. Scratch Head 2
If found, please email me to myself. Thanks. yes
       Executive member in good standing of Rick's SMAA.                              Ehhh...What's Up Doc?
zarobhr
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 178
Offline Offline

Gender: Male
Posts: 622



« Reply #11 on: July 17, 2011, 10:07:46 PM »

thats what i do , is check the database and flag the entry as redeemed.

reuseing tickets has nothing to do with game change since the game doesnt retain any info about the ticket .

btw i had to completly rewrite my one program since andyp dll wouldnt work with my serial ports

i am using tibbo ethernet to serial(3ports)

total of six machaines being polled now and as soon as i get another adaptor will have 9 on my tito system.

also got sas progressive working so once i get the bugs worked out i will have progressives on most of my machines
Logged
FORDSBS
Contributing NLG Member
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 363
Offline Offline

Gender: Male
Posts: 4162


PET


« Reply #12 on: July 17, 2011, 10:22:56 PM »

zarobhr, Can you take ticket from one game & use it in different game?
Logged
zarobhr
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 178
Offline Offline

Gender: Male
Posts: 622



« Reply #13 on: July 17, 2011, 10:25:10 PM »

yes
Logged
FORDSBS
Contributing NLG Member
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 363
Offline Offline

Gender: Male
Posts: 4162


PET


« Reply #14 on: July 17, 2011, 10:30:46 PM »

That's cool.  Clap :244-I have to us my tickets in machine they came out of.
Logged
StatFreak
rotaredoM etiS GLN labolG
Global NLG Site Moderator
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 756
Offline Offline

Gender: Male
Posts: 8549


Warning! Spammers will be eaten, with relish!


« Reply #15 on: July 17, 2011, 10:56:21 PM »

That's because you don't have a back end program and database managing the tickets.

SQL server is a resource and memory hog and is expensive (if obtained legitimately). You can get and use MySQL for nothing, and it has a much smaller footprint. I'm guessing that zarobhr already had access to a SQL server db, so it was the easiest solution for him. A few years ago I would have been in the same position, but not now.

If using SQL server or MySQL (hey, anyone for Oracle? frying pan) you'll be building a separate front end, and will have a choice of building it to run in a browser window or as a local stand-alone app. You can program it in any language, C# (or C#.net) being the most common choice, but you could also use VB.net or others. A browser app would also require some HTML skills and possibly javascript, plus asp or php.

I'm an expert MSAccess programmer and already own full versions of MSOffice, so if I ever set this up, that's probably what I would use, since it's a complete solution in a single package and is fine for a small home envronment. It uses ADO and ADOX, SQL, and Access VB, which is not as complete as VB, but has a few commands that VB doesn't.

In any case, you attach AndyP's dll to your project and then access it via exposed method and property calls, which I assume he has documented. You can write your own code to interface with specific hardware, as zarobhr did to use his serial ports.

There are multiple solutions. It just depends on what you've got available, how well you know the various tools, and how much time you've got on your hands. arrow
Logged

I found myself at NLG garfield  ..but got lost again on the way home. Scratch Head 2
If found, please email me to myself. Thanks. yes
       Executive member in good standing of Rick's SMAA.                              Ehhh...What's Up Doc?
zarobhr
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 178
Offline Offline

Gender: Male
Posts: 622



« Reply #16 on: July 17, 2011, 10:59:47 PM »

sql express is free. but i do have the full version
Logged
FORDSBS
Contributing NLG Member
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 363
Offline Offline

Gender: Male
Posts: 4162


PET


« Reply #17 on: July 17, 2011, 11:06:22 PM »

With my lack of knowledge in this stuff I think I have to be happy with what I got. You guys lose me in the dust. Silly Me! Silly Me!
Ford
Logged
StatFreak
rotaredoM etiS GLN labolG
Global NLG Site Moderator
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 756
Offline Offline

Gender: Male
Posts: 8549


Warning! Spammers will be eaten, with relish!


« Reply #18 on: July 18, 2011, 12:04:16 AM »

What we need is solution that doesn't require expensive software to run and that can be easily installed. Since it would be for everyone, it wouldn't address members' specific hardware problems. MSAccess 2007 and 2010 have a free runtime for end users. MySQL and a stand alone C#/VB app would be free, as would a web front end.

Heck, for home users who don't intend on having too many unclaimed tickets, we could even use a simple .csv or comma delimited text file, or a simple binary data file, and load the data into an array each time the program runs. It would then write back to the file as old tickets were deleted and new ones created. Security would be a non-issue for home users.

Of course, having a database would be more useful down the road, as I suspect people will want to have multiple progressive capabilities, and might try to use their player card readers.
Logged

I found myself at NLG garfield  ..but got lost again on the way home. Scratch Head 2
If found, please email me to myself. Thanks. yes
       Executive member in good standing of Rick's SMAA.                              Ehhh...What's Up Doc?
zarobhr
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 178
Offline Offline

Gender: Male
Posts: 622



« Reply #19 on: July 18, 2011, 12:44:41 AM »

i wish i could figure out the player card stuff, everything i have uses mastercomm 250 but i dont know how to communicate with it
Logged
Forrhouse
Manufacturing Equipment & Parts to Keep Slots that are No Longer Supported by the Manufacturer running.
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 252
Offline Offline

Gender: Male
Posts: 532


Life is too short, live, love and have a good time


« Reply #20 on: July 18, 2011, 03:01:27 AM »

Could you add a drop down menu with an options selection?  Under this options selection have options to turn on or off having the data base mark the tickets as validated?
Maybe have in addition to these options, an input field where you could type in certain data base entries so that you could keep those entries from being marked validated.
Just some ideas. 
Eric

Logged
Foster
The S2000 GURU
Contributing NLG Member
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 345
Offline Offline

Gender: Male
Posts: 2872



« Reply #21 on: July 18, 2011, 04:50:58 AM »

The thing with the master comm is how does it communicate with the machine and how does it communicate with its back end system
I would love to see this app,
Logged

A Slot Machine and Coca-Cola Addict!!
"If it is not broke do not fix it" I keep forgetting that!
zarobhr
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 178
Offline Offline

Gender: Male
Posts: 622



« Reply #22 on: July 18, 2011, 08:43:50 AM »

the master comm 250 one end connects to the machine via the serial port , backend no clue

my app is definately not ready to send out yet, no gui yet

as for putting an option in to clear or not clear tickets as redeemed and options to not clear certain tickets would not be a problem

hardware differences may also be a little issue but if the options are right with adjustable delays most should be overcome.
Logged
Foster
The S2000 GURU
Contributing NLG Member
Sr.Tech NLG Member 1000+ Post
*

Total Karma Storms: 345
Offline Offline

Gender: Male
Posts: 2872



« Reply #23 on: September 25, 2011, 08:17:50 AM »

If MasterComm connects to the machine via Serial port, which port is it on the S2000?
I hope it not the same one I am using for SAS now.
Logged

A Slot Machine and Coca-Cola Addict!!
"If it is not broke do not fix it" I keep forgetting that!
zarobhr
Contributing Gold NLG Member
Sr.NLG Member 501 to 1000 Post
*

Total Karma Storms: 178
Offline Offline

Gender: Male
Posts: 622



« Reply #24 on: September 25, 2011, 09:28:40 AM »

yes it is the same port, but why would you need both connected (unless you have finally figured something out to communicate with the mastercom
Logged
Pages: [1] 2 3 Go Up Print 
« previous next »
Jump to:  


If you find this site helpful, Please Consider Making a small donation to help defray the cost of hosting and bandwidth.



Newlifegames.com    Newlifegames.net    Newlifegames.org
   New Life Games    NewLifeGames  NLG  We Bring new Life to old Games    1-888-NLG-SLOTS
Are all Copyright and Trademarks of New Life Games LLC 1992 - 2021


FAIR USE NOTICE:

This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner.
We make such material available in an effort to advance awareness and understanding of the issues involved.
We believe this constitutes a fair use of any such copyrighted material as provided for in section 107 of the US Copyright Law.
In accordance with Title 17 U.S.C. Section 107, the material on this site is distributed without profit to those
who have expressed a prior interest in receiving the included information for research and educational purposes.

For more information please visit: http://www.law.cornell.edu/uscode/17/107.shtml.

If you wish to use copyrighted material from this site for purposes of your own that go beyond fair use,
you must obtain permission directly from the copyright owner.

NewLifeGames.net Web-Site is optimized for use with Fire-Fox and a minimum screen resolution of 1280x768 pixels.


Powered by SMF 1.1.20 | SMF © 2013, Simple Machines
Loon Designed by Mystica
Updated by Runic Warrior
Page created in 0.117 seconds with 18 queries.