Differences between revisions 5 and 6
Revision 5 as of 2002-06-04 20:16:37
Size: 772
Editor: DonPark
Comment:
Revision 6 as of 2002-06-04 20:19:00
Size: 847
Editor: DonPark
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
  * String Username (Key)
Line 6: Line 7:
  * Username (Key)
  * IM: ICQ
  * IM: Jabber ID
  * Type ICQ ID
  * Type Jabber ID
  * Type Address, mailing
Line 11: Line 12:
  * String ID (Key)
Line 15: Line 17:
  * Type: Address
  * Type: Affiliated groups [n]
  * Type: User, Owner
  * Type: User, Maintainer
  * Type: Address, Antenna
  * Type: Affiliated group [n]
  * Type: User, Owner [n]
  * Type: User, Maintainer [n]

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


[CategoryDocumentation]

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