report of the
work that had been done on the dating part in April 2005.

Objet:   Datigns
De:      "WebDevs" <webdevs@tut.by>
Date:    Mon 18 april 2005 8:38
À:       "Sylvain Poirier" <spoirier@lautre.net>
--------------------------------------------------------------------------

Hello, Sylvain.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  Important tips conerning datings DB structure:

  in order to optimise the requests from PHP scripts to the DB I had to
put the following restrictions into operation:

  table dating_mplaces: the records must never have their parent_id values
more than their id values

  table dating_cases: the records must never have their parent_case_id
values more than their id values

  please be careful with these things, they are very significant for the
normalcy of the system
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Users with dating accounts:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  user1/pass1
  pasha/111
  eee1/eee1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      today I've done:
      -geographical parameters & criteria
      -settings page,
      -activating/deactivating
      -re-sending account
      -choosing pseudo every time activating the account
      -choosing whether to ask for advice at any time one wants
      -checking validness of entered data

      an only thing I'm still having bugs with is
      -quick "U" folder viewing (using pop-ups)
      I had problems with JavaScript coding.

      Everything else is done.

      I'll fix popups by tuesday's evening (I think I'll be sleeping on
Monday)
      But I think, anyway the project is now quite presentable.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     I thought you might be interested in the DB scheme (attached).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://spoirier.lautre.net/tforum/Dating%20Database%20Scheme-april05.zip