Differences between revisions 3 and 5 (spanning 2 versions)
Revision 3 as of 2002-06-03 20:24:25
Size: 372
Editor: DonPark
Comment:
Revision 5 as of 2002-06-04 20:16:37
Size: 772
Editor: DonPark
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
Line 4: Line 11:
 * Statistics   * Type: GPS loc
  * Antenna type
  * Antenna pointing direction
  * Power output
  * Type: Address
  * Type: Affiliated groups [n]
  * Type: User, Owner
  * Type: User, Maintainer
  *

* GPS Loc
  * float lat
  * float long
  * float altitude
Line 17: Line 38:
 * PHP page talking to a MySQL server   * PHP page talking to a MySQL server

Databases

  • User
    • First Name
    • Last Name
    • Wireless Community ID # (off the back of your wifi id card :)

    • Username (Key)
    • IM: ICQ
    • IM: Jabber ID
  • Node
    • Type: GPS loc
    • Antenna type
    • Antenna pointing direction
    • Power output
    • Type: Address
    • Type: Affiliated groups [n]
    • Type: User, Owner
    • Type: User, Maintainer

* 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


[CategoryDocumentation]

CommunityDatabase (last edited 2012-03-11 02:06:36 by RussellSenior)