SQL to import paid Subscriptions
 

Hi,

I am importing paid subscriptions from a mod I was using to handle those instead of the default VB subscription system.

Seems like Im going to be importing to 3 different tables (paymentinfo, paymenttransaction, subscriptionlog) and prob do a VLOOKUP on paymentinfoid field in paymentinfo and paymenttransaction table since the paymenttransaction table does not have a userid column.

Unfortunately the subscription mod I was using did not generate a hash which is a field in the paymentinfo table. Can I just generate my oun number/letter that is as long as those hash's? Or is a hash supposed to be composed of something and its not completely random? Can I leave that field blank (prefer not to)?

Thanks!

The hash isn't a random value (Edit - well, maybe it is). Look in payments.php to see how it's calculated.

I'm not sure, but I think maybe in this case the reason for a hash is to generate a unique id for the payment that can't be guessed (if you just used increasing integers for an id it would be easy to guess). ETA...in which case, now that I think about it, random values might work just as well as long as they're unique.

After reading somethings about hash... Random or not, it might as well be since its impossible (unfeasible) top reverse engineer a hash value to its original content. So i guess i could generate a bunch of random numbers to put in there and put a little salt at the end/beginning so I know i actually made up those numbers.


Thanks!

--------------- Added [DATE]1328747485[/DATE] at [TIME]1328747485[/TIME] ---------------

What would be the easiest/practical way to export data from one table d fields into a different table and fields?

Also, what would be the query to use, so it doesn't overwrite (in case i already have some subscriptions manually in there)?

Thanks!