Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2012, 01:12 PM
kronnos kronnos is offline
 
Join Date: Apr 2006
Posts: 241
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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 02-07-2012, 01:33 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 02-08-2012, 01:35 AM
kronnos kronnos is offline
 
Join Date: Apr 2006
Posts: 241
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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 [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!
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 09:43 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04303 seconds
  • Memory Usage 2,178KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete