how to access database to show stats on another website

[beemer101]

well the title pretty much sums it up, i'm hoping i can put code on my website to pull information from the stats database.

i'm just learning databases and asp.net. so i'm learning as i go.

any information or direction you can give me on how to pull the information would be awesome.

and as always, NFO is number 1!!!

[Edge100x]

For security reasons, the database can't be accessed directly from hosts outside the .nuclearfallout.net domain. You would need to run a webserver component that accesses the database here (on our free web space), and either have its output read and processed by your external script or have it print directly to the client browser (for instance, in an iframe).

[beemer101]

so i have to figure some way for my site to read... the psychostats page? or some other method for my site to retrieve the data.

that's gonna get hairy, any direction on doing that simply would be great. the only reason i'm not hosting the site on your server is because its asp.net.

thanks for helping me

[Edge100x]

My recommendation would be that you implement whatever you want to do with the stats in PHP/Perl/Python/Ruby/C/what have you (anything our webserver supports) and then load it in an iframe of your regular site so that your visitors could interact with it directly.

Since you'd be interfacing with a rather complicated system (the stats database is not simple), any sort of proxy to the database server would be a bit more in depth.

[beemer101]

sorry i'm totally new to databases. what can i do with the stats? and to implement any of it, just do it in coding?

i mean to say that i like how phsychostats retrieves and shows stats, is there some ways to tear down the phsychostats page, so that it is only the table itself, and have that show up in my site, inside my masterpage frame?

i'm assuming that must be what you mean by iframe, but i'm totally a noob to all of this, so once again all your help and patience is greatly appreciated!

[beemer101]

ok i seem to have used the information you gave me and found a solution. i found how to insert an iframe into my site!

this is really freaking cool

now all that's left is for me to figure out how to strip the phsychostats page down a little so that it fits better in my site.

thanks for all your help!!!

Beemer <customer satisfaction=100%>

[Edge100x]

You're welcome

[DeliriumTremens]

My recommendation would be that you implement whatever you want to do with the stats in PHP/Perl/Python/Ruby/C/what have you (anything our webserver supports) and then load it in an iframe of your regular site so that your visitors could interact with it directly.

Since you'd be interfacing with a rather complicated system (the stats database is not simple), any sort of proxy to the database server would be a bit more in depth.

I know this is nearly a year old, but I'm gonna ask this anyway. Are you suggesting setting up the php through the nuclear fallout site and creating the design there, then basing the location of my iframe to display the data? I'm not sure why I'm asking, because it's pretty self explanatory now that I've typed it. Is there any information made available to ease the process of customizing the database outputs? (I'm also sort of new, but to program the php, one needs to know specifics about the database, yes? such as names given to different stats?)

[Edge100x]

I was recommending that he just load up the stats page in an iframe on his site, I think. Psychostats does have the ability to adjust the template used for its output, and you can find some example user-submitted themes for it here: http://www.psychostats.com/community/br ... emes/?s=10