Welcome to the Second Life Forums Archive

These forums are CLOSED. Please visit the new forums HERE

I'm looking for a webserver to store data from SL

Tomfox Wiranata
Registered User
Join date: 20 Dec 2006
Posts: 80
12-22-2006 07:19
Hi Everybody!

I have a little problem. I want to save data from second life via scripts in a sql-database on a webserver in the internet. but i can't find one, that allows remote access. no remote access no writing data into my database. all the webservers i saw just allowed interactions with their db in between their network. that is totally useless for me...

so does anyone know one these webservers?

thank you so much...

tw

PS: maybe you can tell me how you store data :)
Homer Antler
Registered User
Join date: 21 Oct 2006
Posts: 105
12-22-2006 07:35
From: Tomfox Wiranata
Hi Everybody!

I have a little problem. I want to save data from second life via scripts in a sql-database on a webserver in the internet. but i can't find one, that allows remote access. no remote access no writing data into my database. all the webservers i saw just allowed interactions with their db in between their network. that is totally useless for me...

so does anyone know one these webservers?

thank you so much...

tw

PS: maybe you can tell me how you store data :)


I am not sure what you mean by a different web server. However, in order for you to save data, you just need a webserver that supports scripting such as PHP and then also a database such as MySql. Most of the webserver that I run into supports this.

Your object from inworld then will call a PHP page on the website. That page will do whatever you need to do with the data and send a response back to you object.

That is how you store data and retrieve data.
Tomfox Wiranata
Registered User
Join date: 20 Dec 2006
Posts: 80
12-22-2006 09:17
Yes that is exactly what I meant. But most webservers do NOT ALLOW access from outside their network. So the scripts from inworld cannot write or call the php-scripts on the server.

What did you mean with website? which role does a website play at storing data?

which hoster did you choose?

thx btw for your answer
Geuis Dassin
Filming Path creator
Join date: 3 May 2006
Posts: 565
12-22-2006 09:26
Tomfox, email me [email]geuis.teses@gmail.com[/email] with your specific requirements.

I can likely provide the services you're looking for.

Geuis
Homer Antler
Registered User
Join date: 21 Oct 2006
Posts: 105
12-22-2006 09:33
From: Tomfox Wiranata
Yes that is exactly what I meant. But most webservers do NOT ALLOW access from outside their network. So the scripts from inworld cannot write or call the php-scripts on the server.

What did you mean with website? which role does a website play at storing data?

which hoster did you choose?

thx btw for your answer



NP. You will have to call your website URL with the data as part of the QUERYSTRING. i.e.
CODE
http://www.yourwebsite.com/phpscript.php?data=TomfoxWiranata&id=idnumber&purchase=itemnumer&price=100&whatever=whatever


Basically, you are passing the above variables to your PHP script on your webserver. Your php script will then do whatever with the data and send a response back to your object. Based on the input, you object can choose to do the next event.

Hope this helps. There are examples in this forum that you can find useful.
Tomfox Wiranata
Registered User
Join date: 20 Dec 2006
Posts: 80
12-22-2006 11:12
ok. got it. you send data into a php-script. is it possible to write data with lsl directly into a sql-database? or do i need php as a puffer? and does it work vice versa? because i would like to call data directly from the database into inworld with LSL ...if i had the webserver...

these files are public then right? if they are on my site. technically everybody could run them....is that correct?

thx again :)
Ishtara Rothschild
Do not expose to sunlight
Join date: 21 Apr 2006
Posts: 569
12-22-2006 13:43
The files are public, but 1.) another person would have to know that there's a file named http://www.yourwebsite.com/phpscript.php on your webspace and 2.) which data they need to pass to the script.

As for your other question: you'll need php to handle the mySQL access and to execute the SQL statement that writes the data. You can only access the php script like a website from SL, there's no way to write directly into your database.