[Xerte] toolkits installation feedback (+data.xml missing in new USER-FILES subdirs)

David Goodwin david at palepurple.co.uk
Tue Sep 15 14:19:49 BST 2009


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Patrick Lockley wrote:
> I can change the suggestions - it took me an age using a new system
> (same code) to work out what it meant. I don't really get LDAP.
> 

I don't use it a huge amount ... so don't worry :)

> Templaterights / templatesyndication don't really need a primary key -
> it's linked to templatedetails on the template_id column. If this is
> naughty mysql then please accept my apologies.

Ah ok. Well, normally you'd want a key/index there to speed up searches.
It's possibly naughty... but if there are only ever a few rows in the
table, it's a non-issue.

> 
> I don't get point C, sorry, could you clarify it for me.
> 

<tangent>
Rather than a table which looks like :

sitedetails:
  bind_dn -> value
  admin -> value
  admin_pass -> value
  site_id -> value
  site_url -> value
  apache -> value
  ....

It may be better to have e.g. :

sitedetails :
  site_id
  name
  value

So your code would do e.g. 'select * from sitedetails where site_id = 1'
to get all name/value pairs back.

The benefit of this is that if you decide to have a new sitedetail field
you just add a new row into the database - rather than having to update
the schema of the table.

The only possible downside is that the fields would need to be of the
same storage type (e.g. char(255)); at the moment you have some that are
also text - so you could either have a seperate table for them (e.g.
sitedetails_text) or there is a software pattern which solves the
problem whose name I've conveniently forgotten.

</tangent>

> The new template code is in website_code/php/templates/new_template.php
> 
> What does fiddler show you?
> 


Fiddler2.com implies it's only available for Windows; I don't use
Windows :-/ I can use wireshark or e.g. the burp suite - do you want all
traffic from login onwards?

Thanks for the quick reply,

David.
- --
 David Goodwin                          Pale Purple Limited
 Office: 0845 0046746                   Mobile: 07792380669
 http://www.palepurple.co.uk            Company No: 5580814
 'Business Web Application Development and Training in PHP'
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkqvlHUACgkQ/ISo3RF5V6b6YACfYmwLuUVpZh8wW9c+HyY6rjio
EBoAoMRU1XEUa6HSCiU917ZfTRkzZnpP
=Y922
-----END PGP SIGNATURE-----


More information about the Xerte mailing list