MySQL -> MySQL -> Auto Post threads :) - u can do it!..lol

[Mathiau]

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 $$$ :D

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

All info appreciated!

[Mathiau]

no one have any idea's how this could maybe be done? :(

[treszoks]

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.

[Logician]

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 (https://vborg.vbsupport.ru/showthread.php?s=&threadid=39663)'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..

[Webmasta XT]

this is really great idea..

[Mathiau]

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.

:D