|
Size: 372
Comment:
|
Size: 847
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| Database | Databases |
| Line 3: | Line 3: |
|
* String Username (Key) * First Name * Last Name * Wireless Community ID # (off the back of your wifi id card :) * Type ICQ ID * Type Jabber ID * Type Address, mailing |
|
| Line 4: | Line 12: |
| * Statistics |
* String ID (Key) * Type: GPS loc * Antenna type * Antenna pointing direction * 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 17: | Line 40: |
| * PHP page talking to a MySQL server | * PHP page talking to a MySQL server |
Databases
- User
- String Username (Key)
- First Name
- Last Name
Wireless Community ID # (off the back of your wifi id card
- Type ICQ ID
- Type Jabber ID
- Type Address, mailing
- Node
- String ID (Key)
- Type: GPS loc
- Antenna type
- Antenna pointing direction
- 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