|
Size: 317
Comment:
|
Size: 947
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| Database | Databases |
| Line 3: | Line 3: |
|
* 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 |
|
| Line 4: | Line 13: |
| * Statistics |
* 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 |
| Line 15: | Line 39: |
|
Implementation * PHP page talking to a MySQL server |
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