====== android app logging on the server ====== following [[http://www.androidhive.info/2012/05/how-to-connect-android-with-php-mysql/|these instructions]] server side: * create a mysql user for the project mysql -u root -p mysql> use mysql; mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password')); mysql> flush privileges; * create a database myqsl> create database databasename; * create a table mysql> use databasename; mysql> CREATE TABLE tablename( pid int(11) primary key auto_increment, value1 int(10) not null, value2 int(10) not null, value3 int(10) not null, value4 int(10) not null, created_at timestamp default now() ); * create a php file which will handle http requests from the app; [[php-server-log]] * edit the class that sends data to the server, in this case SentToServ.java and include the correct server address private static final String SERVER_IP = "http://urloftheserver/file.php"; ====== arudino/pd to DMX light ====== * using eurolite LED Floor SLS-400 RGM DMX lights ([[http://www.recordcase.de/cosmoshop/pix/a/media/0020105380/sls-400.pdf|manual]]) * ardunio UNO IDE version 1.1.5 Tinkerit DMX shield, 3pins; (jumpers: EN-;-DE;TX-;RX;) [[http://nervousvision.com/download/DmxSimple_v3.1.zip|DmxSimple library v3.1]] with the [[dmx-simple|DmxSimple example]] (use pin 4, pin 2 always HIGH) somewhere on this wiki light set to 5ch mode, addr 1 pd testpatch [[eurolite-dmx-test]] * arduino LEONARDO IDE version 1.5 beta Tinkerit DMX shield, 3pins; [[http://nervousvision.com/download/DmxSimple_v3.1.zip|DmxSimple library v3.1]] + [[dmx-simple-cpp|DmxSimple.cpp]] that supports Leonardo (timer4) > found in the comments [[http://code.google.com/p/tinkerit/wiki/DmxSimple|here]] by [[http://code.google.com/u/114138580452207614354/|francois...]] + [[dmx-simple-h|DimSimple.h]] + [[dmx-simple|DmxSimple example]] using pin 4 (instead of 3=default), pin 2 always HIGH ====== install app: ====== qr code generator (you can specify the type like android app, iphone app, url...) [[http://www.qrstuff.com/]] qr code with download tracking [[https://www.youscan.me/dashboard/]] ====== set-up the router ====== * TP LINK WR703N router * OpenWRT installed following these instructions * AP MODE: the blank wireless [[ap-configuration|configuration file]] * BRIDGE MODE?