> I've been seeing odd behavior within FreeTrade, which I'm definitely going
> to change. But its such a dumb think, I figure I might have broken
> something, (as I've changed it considerably) so I'm asking you guys...
>
> The problem has to do with the "address" entries within the SQL Dbase.
> whenever a user re-logins in, the "user" table points to the
> FIRST "address"
> row he created. Whenever he changes this info, Another row gets
> added to the
> "address" table. (making EXTRA or duplicate info) which is not a
> bad think,
> (thou I'd rather issue a REPLACE command) or the next bug?
> feature? is that
> the "user" table still points to the OLD "address" ID. So the
> next time the
> user logs in. the changes he did the first time are lost.
>
> For my sakes I'm gonna see if I can do a REPLACE on the info on the
> "address" fields. rather than simply change the "user" table address field
> to point to the new "address" row.
>
> Did I lose anybody in the explanations?
>
> FreeTrade is so nicely organized I don't believe this was
> overlooked? right?
> I broke something I guess?
You didn't break anything. I'll try to explain why it is this way.
When I register with the site, I'm supplying my home address. When I
buy something, I'm having it shipped somewhere that could be my home
address, but it might be my work address or even my friend's address.
When I supply billing info, it's probably my home address, but maybe
not if I'm using my company's corporate card.
Now, for the purpose of keeping everything straight, we have to make a
separate record for each of these addresses. It would be really confusing
if you placed an order, then went and blanked out your registration
address if it also changed the billing info for all your orders, past
and present.
When you enter billing info, should the system update your registration
address? Maybe so. It wouldn't be hard to implement this. Maybe we
should ask the user. If you write the code to do this, I'll drop it into
CVS. It should be something controlled by a constant, I think. I suggest
three modes: never update, always update, and give the user the choice.
> My Changes for those that are interest.
> Fast intro: I'm using freetrade to setup a file-library! Thou,
> 90% of these
> files are free some will cost some money to download. Thou I'm
> interested in
> the whole process of recording who's coming in and d/ling the files.
>
> Small changes done so far...
> -Whenever the bill is $0.00 to skip the Credit/card info stuff...
> -Allow Downloading of the files once the invoice is complete.
> -Using "anti-leech" php methods to hide the URLs of the file locations
> -Invoice via email too...
>
> Working on...
> -Instant cyber-cash CC processing...
> -Currency crap... Canadian$ vs US$ since I got access to both US & CDN
> CC processing.
This is cool. Be sure to share the URL when you're done. I'd like to
provide a list of sites using FreeTrade. (That goes for everyone!)
Leon
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
