View Single Post
  #1  
Old 04-25-2002, 04:12 AM
Mathiau's Avatar
Mathiau Mathiau is offline
 
Join Date: Jan 2002
Location: Costa Rica and toronto
Posts: 227
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL -> MySQL -> Auto Post threads :) - u can do it!..lol

Hello,

Well, if i can explain this right, great! (yes i haev posted this in the MySQL forums on vbulletin.com as well)

Here is the idea that i would like to do.:

(my post from VB.com)
  • Hello,

    I know nothing of MySQL (but we have 3 developers who know MySQL, but nothing of VB), but want to know if something is at all possible, if so, how difficult it maybe.

    Okay, my work, www.truepoker.com, runs tournaments through out the day.

    The information is recorded, and then placed into a MySQL database in various tables.

    What i wanted to do, was on our forum, have a section, Perhaps called Tournament Results, and have either Daily or even hourly, the tournaments records from our database sent to the VB MySQL database, and 'create' its own posts.

    So example

    Everyday at lets say 12am, you could log into our forum, go to Tournament results, and TADDA, their is the results posted for that day, done automatically by the MySQL, or whatever may be involved.


    Basically an automated posting system that would take date from one MySQL database, and pull it into the VB mySQL database, and make a new thread once the info is in the Vb database.

    Now the databases are on seprate servers.



    SO! is this possible?

Now, i was curious, if we are able to get one MySQL to send info to another MySQL database, what PHP hacking could, or would need to be done, in order for VB to realize new info has been accepted into it's Database, and automatically make a new post?

Any info, or steps towards this would be kew, or if any pro hackers want a new challenge, this could possible involve $$$

We have 3 guys here who know MySQL, but don't don't vb for crap.

All info appreciated!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01225 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete