Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 07 Feb 2012, 14:12
kronnos kronnos is offline
 
Join Date: Apr 2006
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!
Reply With Quote
  #2  
Old 07 Feb 2012, 14:33
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
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.

Last edited by kh99; 07 Feb 2012 at 14:42.
Reply With Quote
  #3  
Old 08 Feb 2012, 02:35
kronnos kronnos is offline
 
Join Date: Apr 2006
Originally Posted by kh99 View Post
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 09 Feb 2012 at 00:31 ---------------

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!

Last edited by kronnos; 08 Feb 2012 at 04:25.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:59.

Layout Options | Width: Wide Color: