Tooltron: Issueshttps://roboticsclub.org/redmine/https://roboticsclub.org/redmine/redmine/favicon.ico2010-05-10T22:51:28ZRobotics Club
Redmine Task #1357 (Assigned): update server docshttps://roboticsclub.org/redmine/issues/13572010-05-10T22:51:28ZBrad Neuman
<p>network protocol has changed with new cardbox</p> Task #1351 (Assigned): organize repohttps://roboticsclub.org/redmine/issues/13512010-05-10T22:12:25ZBrad Neuman
<p>for example, rename "swipe"</p> Task #1350 (Assigned): Write tutorial about network programminghttps://roboticsclub.org/redmine/issues/13502010-05-10T22:12:04ZBrad Neuman
<p>a bit about how it works and how to do it</p> Task #1347 (Assigned): remove server hackshttps://roboticsclub.org/redmine/issues/13472010-05-10T22:10:31ZBrad NeumanEnhancement #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 #1327 (Assigned): Server dies when internet is outhttps://roboticsclub.org/redmine/issues/13272010-04-24T22:25:43ZKevin Woo
<p>The server dies when the internet goes out necessitating the manual override of tools. This may be a security hole but perhaps we should enable all tools when people swipe if the internet goes out and the mysql server can't be accessed. That way it will be transparent to users.</p> Enhancement #1129 (Assigned): notifications of tool boot packets in tooltron.pyhttps://roboticsclub.org/redmine/issues/11292010-02-24T01:47:29ZBrad Neuman
<p>Keep a log and send an email whenever a board gets reset</p> Enhancement #1127 (Assigned): script for network programminghttps://roboticsclub.org/redmine/issues/11272010-02-24T01:46:49ZBrad Neuman
<p>give it a program (source) and a list of tool IDs<br />will recompile each one, defining ADDR and then use netprog to send it over</p>