Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 06-23-2002, 12:49 AM
Mathiau's Avatar
Mathiau Mathiau is offline
 
Join Date: Jan 2002
Location: Costa Rica and toronto
Posts: 227
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

no one have any idea's how this could maybe be done?
Reply With Quote
  #3  
Old 06-23-2002, 02:03 AM
treszoks treszoks is offline
 
Join Date: Oct 2001
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You could write a php script that would retrieve the info from the mysql server with the results in it and that same php script could generate a web form(similar to vb's new topic form) already filled in to post the info for you. You would just have to run the script each time you wanted to make a new post with updated results. It shouldn't be too difficult to write at all. Just check out the needed fields in the new topic form for vb and duplicate it with your info in the fields.
Reply With Quote
  #4  
Old 06-23-2002, 08:35 AM
Logician's Avatar
Logician Logician is offline
 
Join Date: Nov 2001
Location: inside vb code
Posts: 4,449
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you are allowed to use CRON jobs, you can tie a script there to do what you want. If not you can create your own cron job.

If you (or your developers) know PHP check my Automatic Greetings for user birthdays hack's code and algorithm. It will help you to understand both how to insert a thread to vb db and how to create your own cron job with a PHP script. Its algorithm can be adapted to do what you want. So yes, it's possible..
Reply With Quote
  #5  
Old 06-24-2002, 02:03 PM
Webmasta XT's Avatar
Webmasta XT Webmasta XT is offline
 
Join Date: Mar 2002
Posts: 359
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

this is really great idea..
Reply With Quote
  #6  
Old 06-24-2002, 09:19 PM
Mathiau's Avatar
Mathiau Mathiau is offline
 
Join Date: Jan 2002
Location: Costa Rica and toronto
Posts: 227
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hehe

^^^^

thnx :0

now to get it to wok


i know NOTHING about PHP..lol our devs are C++ kind of guys, got 3 guys who knows MySQL well.

So, guess i need to start reading up,

is there anything specific i should read? Or perhaps a coder who could help with this? and i would assume if it works, i could talk to my boss to perhaps pay for the work...


And the CRON job, would need this, as this would need to be something that is purely automated.

LIke, i guess the php script would look in the database, mmm every 30mins, and if it see's a new tournament has finished, it will then automaically post it.

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 12:54 PM.


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.05152 seconds
  • Memory Usage 2,209KB
  • 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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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