|
Size: 597
Comment:
|
Size: 947
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| Database | Databases |
| Line 3: | Line 3: |
|
* First Name * Last Name * Wireless Community ID # (off the back of your wifi id card :) * Username (Key) * IM: ICQ * IM: Jabber ID |
* 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 11: | Line 13: |
|
* Lat * Long * Antenna type * Antenna pointing direction * Power output |
* 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 |
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