Tooltron: Issueshttps://roboticsclub.org/redmine/https://roboticsclub.org/redmine/redmine/favicon.ico2010-05-20T19:53:30ZRobotics Club
Redmine Bug #1363 (Assigned): Tooltron status indicatorhttps://roboticsclub.org/redmine/issues/13632010-05-20T19:53:30ZBrad Neuman
<p>There should be some way of indicating if tooltron is working. There should be something on the website and a physical LED or something on the cardbox or nearby to indicate if the system is up and running.</p>
<p>If tooltron is stopped using the daemon, this should be reflected using this system. There could also be some kind of periodic signal or something sent to the cardbox that tells people tooltron is alive.</p>
<p>We need this so people can tell the difference between not having access and tooltron being down, also in case its down due to maintenance (like reprogramming one of the tools).</p> Enhancement #1345 (Assigned): MySQL Stored Procedureshttps://roboticsclub.org/redmine/issues/13452010-05-08T17:28:39ZDan Shopedshope@andrew.cmu.edu
<p>Consider using stored procedures/routines for db queries</p>
<p>Offloads some processing from client end, and could provide an easy way to update queries on tooltron since the db stored code would need updated and, tooltron would not need reprogrammed.</p>
<p>Example;<br /><pre>
mysql> CALL tools('81203081');
</pre><br />which replaces<br /><pre>
mysql> SELECT tools_6 FROM civicrm_value_roboclub_info_2 WHERE card_number_1 = 81203081
</pre></p>
<p><em>For more information, see:</em><br /><a class="external" href="http://dev.mysql.com/doc/refman/5.1/en/stored-routines.html">http://dev.mysql.com/doc/refman/5.1/en/stored-routines.html</a><br /><a class="external" href="http://www.databasejournal.com/features/mysql/article.php/3525581/MySQL-Stored-Procedures-Part-1.htm">http://www.databasejournal.com/features/mysql/article.php/3525581/MySQL-Stored-Procedures-Part-1.htm</a></p> Bug #1197 (Assigned): Keypad row 3 (7,8,9,C) does not workhttps://roboticsclub.org/redmine/issues/11972010-03-27T18:47:26ZBrad Neuman
<p>The keypad isn't busted (we probed the leads and saw that rows were connected) but we don't get anything from row 3.</p>
<p>We tried adding delay_ms calls after setting the DDRs in the get button code and that didn't help.</p>
<p>This isn't very critical because these buttons will never be used, but still.</p>