|
← Revision 1 as of 2002-06-03 20:05:12 →
Size: 68
Comment:
|
Size: 947
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
|
Database User Node Statistics |
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 |
| Line 6: | Line 30: |
|
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 |
|
| Line 8: | Line 44: |
| [CategoryUnknown] | [CategoryDocumentation] |
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