Using a webserver with SLS?

I am interested in writing up a script for my HUD that will send kill/death data about each player in my sim and will store a leader board about each player. I am wondering what exactly would I require to do this? I figured it was possible so I decided to throw my question out.

I think the first point to consider is not a technical one but a strategic one -- how long a commitment are you willing to make to keep the webserver end up and running so the feature remains a viable one? I mean, if you sell someone, say, a poofer in SL, they can keep on using it if you get hit by a car in RL, or long after you have lost interest in SL and moved onto Third L or whatever. But with anything dependent on an external resource that must be maintained, it's a different story. I know, boring old-fashioned consideration -- thinking longer term.

I understand what you are saying. My commitment with SL is to be sure a LONG one, and judging by how you are putting this, setting up a webserver and script for something like this would probably take a while then? Also, back to my first question: What would it require? I'd like to see either a checklist or a list of thigns that I need. I have lots of resources, and time is plentiful...

1 a webserver that does not force ad's or any other bits of information onto your pages

2 a server side scripting language such as php asp ruby ect

you will probably want a database but you could also accomplish this using text files (which is kinda cheap and really not all that secure)

Awesome. I can do that then, I just gotta learn more, thanks very much. Any tutorials or free scripts that maybe show exactly how its done or something i could at least base my scripts off of?

heres a simple "flat file" (stuff written in a text file on my server) guest book

in the lsl side of things its pretty simple


on the webserver ive got ... (in php)



now the only security is the fact noone knows exactly where to look (till now) and if this still existed on my website there would be nothing to stop anyone from putting

cheesefactory.us/searchdata.php?search=Osgeld Barmy
or
cheesefactory.us/searchdata.php?search=JACK ASS

into their browser and adding something to my text file so this is very simplistic and totally unadvised for anything but a learning experiance

also see Zero Linden's SILO:-

/54/69/119570/1.html

and in

http://wiki.secondlife.com/wiki/Category:LSL_Library

I am making extremely good progress on this, learning lots of MySQL and PHP info since yesterday. I got it taking information from SL and succesffully saving it to my database. But here's my problem now: How do i make it so if that information is ALREADY there, it wont add another line for it? So that way, if someone dies in the place, the scoreboard will contact the MySQL server and check if the name and avatar key is already there. If it aint, it will add a new entry for it. But if it is there, it will only update that line 'WHERE name = $name and avkey = $avkey' basically.

Here's what I am thinking: When someone dies and sends the information of the killer and the dead person to the scoreboard, the scoreboard sends those individually to the database but follows several different scripts. The first script will check to see if both avatar names and keys are in the database, and if it returns as FALSE or NO, the scoreboard will send the information to another PHP script that will ADD the names. If the first PHP script returns TRUE or YES, it will just UPDATE the two lines with the appropriate kills/deaths.

Is this at all correct at what I am trying to accomplish?

Also, is it possible to just ADD to a line instead of updating to a brand new number? Like Player A killed Player B, add one kill to kills for Player A and then add one death to deaths for Player B. Possible?

That's great you're getting so far, congrats! But I wonder if this hasn't moved beyond LSL and maybe should be moved to a PHP forum somewhere?

I'm very new to PHP but it seems to me this script will continue to write any name to the list regardless as to whether they are on it or not due to the section

if ($on_list != ""
{
echo "on list";
}
// if its not write the name in the file
else
{
$fp = fopen($filename,"a";

Doesn't this segment say if the name isn't on the list say it's on the list otherwise add them to the list or am I wrong. When testing it just seemed to continue adding my name to the list.

However if I changed it for

if ($on_list == ""
{
echo "on list";
}
// if its not write the name in the file
else
{
$fp = fopen($filename,"a";


Nothing happened.

So i Tried swapping the lines round as so;

f ($on_list == ""
{
$fp = fopen($filename,"a";
}
// if its not write the name in the file
else
{
echo "on list";

and still nothing.

Anyone care to shed some light on the issue for a noobie PHP scripter

If ur using mysql u need to make the row on your table unique

my understanding was this just vreated a .dta text file that was written to and read from but I'm guessing I got that wrong.