Differences between revisions 6 and 7
Revision 6 as of 2002-06-04 20:19:00
Size: 847
Editor: DonPark
Comment:
Revision 7 as of 2002-06-04 20:24:50
Size: 947
Editor: DonPark
Comment:
Deletions are marked like this. Additions are marked like this.
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
  * 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
Line 10: Line 10:
  * Type Login, last_login
Line 12: Line 13:
  * String ID (Key)
  * Type: GPS loc
  * 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

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


[CategoryDocumentation]

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