Regarding Torque and MySQL

[Monty]

How exactly would I get Torque to interact with a local MySQL database?

[Ad Bot]

[TheGeek]

You can't do that directly. You can however make a local web service which does database stuff and connect to your own pc using sockets...

[Pew446]

I need to know how to even set up MySQL, it won't talk to php or apache and apache won't talk to php etc...

[Ephialtes]

I need to know how to even set up MySQL, it won't talk to php or apache and apache won't talk to php etc...

Lol, are you sure you shouldn't be making weapons?

[Pew446]

Lol, are you sure you shouldn't be making weapons?

Um... :/ Idk, plus I even have a book all about php and mysql and it doesn't work D: I've been trying to set up databases on my site for.... 2... maybe 3 1 years now :O

[Kalphiter]

Tr!gun and I have successfully made this.

As you may know, our ID sappers, IDs are added to a database from Torque using a PHP file on a remote server.

http://blockland.kalphiter.com/ID/bl_id.php



Tr!gun said to give no-one the Torque side of it. Sorry.

[laremere]

Code: [Select]

0 Blockhead9567Nice


If you want to pass it through php, it's not that hard, though you'd also have to have a web server running.

The RTB wiki has info on how to pass information with get to webpages, and just google "php mysql" to get information on how to connect to servers.

[Ephialtes]

Tr!gun and I have successfully made this.

As you may know, our ID sappers, IDs are added to a database from Torque using a PHP file on a remote server.

http://blockland.kalphiter.com/ID/bl_id.php



Tr!gun said to give no-one the Torque side of it. Sorry.

Damn you people are idiots. RTB is a perfect example of how to send data and receive data from PHP yet you choose to ignore that and go and re-invent the wheel or something?

Also this guy said local as in not on a webserver somewhere in california, normally I'd tell you but its one of the secret features of ERPG that make it so good :)

[Destiny/Zack0Wack0]

I don't know how to do it with-out engine mods :/
I believe it would be related to a netConnection and somehow connect to the local mysql database. I suggest you play around with netObject/netConnection and search about it.

Actually I have no idea.

[Kalphiter]

Damn you people are idiots. RTB is a perfect example of how to send data and receive data from PHP yet you choose to ignore that and go and re-invent the wheel or something?

Also this guy said local as in not on a webserver somewhere in california, normally I'd tell you but its one of the secret features of ERPG that make it so good :)

...

What our script does is the PHP file takes care of the MySQL, and that can ALWAYS be localhost.

I mean.. localhost:80

[Destiny/Zack0Wack0]

No Ephialtes means as in connecting directly to the mysql database, not through a web server.

[Kalphiter]

Considering you connect to MySQL through a port, regard what I said before and listen to this.

It could be simple enough as long as you know what to send to(port 3306?)

[Tom]

Damn you people are idiots. RTB is a perfect example of how to send data and receive data from PHP yet you choose to ignore that and go and re-invent the wheel or something?

I bet most of the ID logger is some copypasta from RTB.

[Kalphiter]

Nope. Sorry to tell you. Remember I didn't write it.

[laremere]

Question: Is this still wanted, because I wouldn't mind doing some torque/php code as practice.