Databases
- User
- String username (Key)
- String first_name
- String last_name
String wireless_community_id (off the back of your wifi id card
- Type ICQ, icq_id
- Type Jabber, jabber_id
- Type Address, mailing
- Type Login, last_login
- Node
- String id (Key)
- Type: GPS, gps_loc
- Type: Antenna, antenna_type
- Type: Direction antenna_pointing_direction
- int power_output
- Type: Address, Antenna
- Type: Affiliated group [n]
- Type: User, Owner [n]
- Type: User, Maintainer [n]
* GPS Loc
- float lat
- float long
- float altitude
System for getting at the data
- XML-RPC interface
- xmlrpc.personaltelco.net:3322
- inserts
- updates
- queries
Q: <nodequery sql="select * where name=\"PCHS\" " />
A: <node> <name>PCHS</name> </node> ...
Implementation
- PHP page talking to a MySQL server