|
|
Statistical Kiosk/database affair:
About Truespace Archives
These pages are a copy of the official truespace forums prior to their removal somewhere around 2011.
They are retained here for archive purposes only.
Statistical Kiosk/database affair: // Scriptorium
Post by Norm // Sep 19, 2007, 10:56am
|
Norm
Total Posts: 862
|
This project open to anyone who wishes to take part.
Intended as a project for the Tuesday Scriptor Meeting crowd.
Project consists of creation of a 3d/2d/1d scenario that:
recognizes an avatar as it approaches.
makes call to database and finds the user's name if it exists.
refers to existing data and presents the stats for the user.
adds the user to the database and informs the user of this.
perhaps award points just for being added to the database.
has a process to display user position/standing with regard to points.
has additional information on the point system:
preamble of point scenario.
how points are awarded.
other information as required can be presented. (future)
has a kiosk to display all the information and present buttons/options for the user to select in 3D environment.
database to exist on hard drive:
which is best for us to use? Who has experience in any?
access?
excell?
mysql?
text file?
should we have an html based page to access the db and add points as required.
could an interface be designed to handle the awarding of points by a designated person? security, usability and capability.
thought must be given to future uses and additional information fields in the db.I believe this project outline can be modified as we flesh out details. Please comment or add ideas that should go into the project outline document. We can discuss details afterwards. If we get too far ahead of ourselves with details, we never get off the ground?
I believe it should be a cool, interesting and teamwork oriented project! :) |
Post by trueBlue // Sep 19, 2007, 11:09am
|
trueBlue
Total Posts: 1761
|
Ah a little Artificial Intelligence project in the works here eh?
I have seen something similar with Ms Agents and the database was in XML. |
Post by Wigand // Sep 19, 2007, 5:28pm
|
Wigand
Total Posts: 462
|
If you want to show what happens, a textfile is an easy way.
Like the old INI-files. I think there are also some API-functions to handle them. |
Post by 3dvisuals dude // Sep 20, 2007, 8:03am
|
3dvisuals dude
Total Posts: 1703
|
LOL...
I had a very nice and huge reply here and hit "send" only to discover that my Internet Service Provider had momentarily snuffed my connection as they work on the local cable lines here! Lost the whole reply!!! Argh!
Count me in!
Lets use VBScript on it and Win API calls.
Have related code already to use.
That's the short synopsis in case they cut me off here again now!
- Mark / 3dvisuals dude |
Post by 3dvisuals dude // Sep 23, 2007, 12:24pm
|
3dvisuals dude
Total Posts: 1703
|
recognizes an avatar as it approaches.
trueBlue made that possible - should be easy to incorporate it with this.
makes call to database and finds the user's name if it exists.
refers to existing data and presents the stats for the user.
adds the user to the database and informs the user of this.
perhaps award points just for being added to the database.
has a process to display user position/standing with regard to points. has additional information on the point system:
preamble of point scenario.
how points are awarded.
other information as required can be presented. (future)
I have no experience in database access / manipulation whatsoever so I'm no help on that. I do however have some related vbscript routines tucked away somewhere which others used and placed in public domain, I got that stuff when I was working with Liberty BASIC and had in mind at the time to convert it for use in that language.
has a kiosk to display all the information and present buttons/options for the user to select in 3D environment.
I can make the kiosk and script the buttons, no problema there.
database to exist on hard drive:
which is best for us to use? Who has experience in any?
access?
excell?
mysql?
text file?
should we have an html based page to access the db and add points as required.
could an interface be designed to handle the awarding of points by a designated person? security, usability and capability.
thought must be given to future uses and additional information fields in the db.
On the database form/access method(s) I have no experience and so no comment.
As for the "could" question of whether a restricted access script could be hooked to a shared space interface, the answer to that of course is "yes." There is already one in shared space which functions well, I have tested it there... the "doors" device which utilizes authorization scripting for avatar scene access which is initiated by the "P" / "Use" method for keyboard triggering of it's scripts. It is located in several different tpportals and tsportals now, attached to existing image kiosks.
This same method or variations of it would work fine in shared space for this purpose.
This does bring up a related issue though... how to make a script inaccessible to an unauthorized user's LE?
As for additional recomendations I would only suggest that in addition to the text fields being displayed on the kiosk itself as well as on a floating or stack panel interface, it would also be useful for the sake of future prototype variations on this to allow a small image area on the kiosk as well, sometimes images display a great deal of information more rapidly than text.
- Mark / 3dvisuals dude |
Post by 3dvisuals dude // Sep 25, 2007, 1:52pm
|
3dvisuals dude
Total Posts: 1703
|
Hey Norm...
Think we can all pull together on this one and punch it out fast for unveiling at "Thursday Night Live!"?:D
- Mark / 3dvisuals dude |
Post by frootee // Sep 26, 2007, 3:53am
|
frootee
Total Posts: 2667
|
I think this is doable by next Thursday. Last night, I forgot that we went to a biweekly schedule. |
Post by frootee // Sep 26, 2007, 6:51am
|
frootee
Total Posts: 2667
|
Ok. Question about something Norm said last night:
We were discussing putting the SQL script nodes in the System node on my machine. It sounded like putting it there would make the SQL node non-viewable (non-public), and therefore protected from deletion. Is this correct? Of course, the same could / should be done on the server, if my understanding is correct.
If this is incorrect, could someone please clarify?
Thanks,
Froo |
Post by Norm // Sep 26, 2007, 10:18am
|
Norm
Total Posts: 862
|
Ok. Question about something Norm said last night:
We were discussing putting the SQL script nodes in the System node on my machine. It sounded like putting it there would make the SQL node non-viewable (non-public), and therefore protected from deletion. Is this correct? Of course, the same could / should be done on the server, if my understanding is correct.
If this is incorrect, could someone please clarify?
Thanks,
Froo
Yes that is the idea Jason. What you do on your machine ends up being duplicated on server. That way protection is afforded. |
Post by frootee // Sep 26, 2007, 10:22am
|
frootee
Total Posts: 2667
|
We can use the GRANT statement to setup certain users for database access (read, write, delete) capability.
The database itself will not reside inside the LE of course; only the interface to the database. We need to make sure the interface cannot be accidentally/intentionally deleted. I recall from before that, in Shared Space, there were items that could not be edited except by an administrator; perhaps Norm can apply the same characteristics to the database interface objects (kiosk, mySql script, etc.)
http://dev.mysql.com/doc/refman/5.0/en/grant.html
EDIT: From Norm's post here, it sounds like we have guaranteed automatic protection if we put this in the system node in SS. |
Post by frootee // Sep 27, 2007, 5:25am
|
frootee
Total Posts: 2667
|
Status Update:
Installed MySql server on my machine Wednesday night
Next Steps:
1. Create database and tables
2. manually add test data to tables
3. manually retrieve data from tables and display data
4. translate steps 2 and 3 into VBscript (or Jscript) scripts
5. connect output to LED display
6. Discuss progress at Tuesday night scriptor meeting
Of course there is more to be done after this but these are the first goals I am going to approach
froo |
|
