User accounts

PeterR · July 04, 2003, 07:25:52 PM

Hi Russell,

It'd be very helpful to have a future version of FSHost support a username/password account database. That way the server could be setup for use by specific people rather than being wide open or protected by only a single password.

Keep up the great work on FSHost!

Russell Gilbert · July 04, 2003, 09:30:53 PM

Hi Peter,

Yeah, that's a great suggestion, and one that's been submitted before actually, by several people.

I'm hoping to have that feature in a future version -- can't say exactly when, but it's definitely on my list! :-)

Russell

PeterR · July 06, 2003, 02:51:00 AM

I didn't think I was the only one

That's great news. Thanks Russell.

Cess_Wizard · June 20, 2005, 01:58:10 PM

Pulling this from the depths of history I was just wondering if any progress hade been made on this. I would love to be able to link forum users to fshost users

N350CA · March 07, 2008, 12:53:31 PM

5 Years Old! Any Progress? Just curious is all!

Russell Gilbert · March 07, 2008, 01:01:29 PM

Umm, well.... actually....

no.

FSHost has a 3-level system, for public, admin, and owner. Can you tell me more about why you want more accounts?

Thanks,
Russell

wesleyroyer · March 14, 2008, 03:16:29 PM

Having more than one admin account would be a nice feature. You could build a SQL database manageable through the remote access webpages by the owner. I would do it, but I know less about SQL and MySQL than we know about the bottom of the ocean.

.

N350CA · March 16, 2008, 10:01:56 PM

A SQL system would be nice! MySQL may be a little confusing to people but if u had the entire database in a file like SQLite then for people who dont know how to do SQL Queries could still use the system with little ease!

wesleyroyer · March 16, 2008, 10:52:51 PM

Since TeamSpeak can use SQL, you could use the same database, so if you register with FSHost, than you register with your TeamSpeak server, and vise-versa. I think there is a topic on the forums at teamspeak.com about how to set up your TS server to use SQL.

wesleyroyer · April 03, 2008, 09:07:36 PM

I have been looking at this topic, and I really like the idea, but how about instead of using just SQL, would it be possible to use PHP and integrate it with SQL? I know that PHP can use SQL, but how about switching the remote access files from ".html" to ".php" and using the same variables, but in a PHP template (Nuke, Raven, etc..)? I am going to do this sometime this week and try it out. I think the variables should work. Is there a list of Remote Access page variables anywhere that I could use? I will let you know on the progress on this, or you can check it out yourself at <links removed>. If I can do this, I will put update notices here and on the links above. I will also post a default username/password. Let me know on the functionality that you guys want from this (e.g. Virtual Airline database, Customized profiles, forums, hop list status for each profile, etc. I will try to make those things possible.). I would appreciate any help I can get, as I am not too familiar with php, and I have no idea how to use SQL or MySQL. I probably won't start on this until Friday afternoon.

Thanks,
Wesley Royer

wesleyroyer · April 04, 2008, 03:01:15 PM

Ok, I have just installed PHP and MySQL. will report more soon.

wesleyroyer · April 04, 2008, 10:50:06 PM

I am having problems with MySQL, so I downloaded and installed Microsoft SQL Server 2005 Express, and it works ok. PHP installed successfully, but I wasn't sure what type of server to select to install to, so I chose "other". The install program gave me an error stating that it couldn't install to that server, but all the files copied to the specified directory anyway. I can't do any work tomorrow or Sunday, and Tuesday of next week I am leaving for Atlanta, GA until Sunday. Sorry about that.

I just thought of something. I don't think it is possible to run server-side scripts like PHP in FSHost. Russell, if you can, could you please make a CGI script execute feature for FSHost Remote Access pages (not sure if that is the correct terminology to say that, but you catch my drift)? Then, you can configure PHP to install to a CGI script, and maybe run the PHP CGI in the FSHost web server. Until then, the only thing I can do is make PHP remote access files with the server variables in them. You will not be able to see them in-action.

Does anybody have any good PHP templates that they would like to recommend for me to use, since I am new to PHP? Thanks.

Regards,
Wesley Royer

N350CA · April 10, 2008, 11:17:59 AM

Hmmm. Excuse me but are you ring to install PHP/MySQL on your computer? If so I would suggest you look into program called Xampp. It is a server that uses PHP/MySQL/ And Apache in one so that you do not need to continuiously update configuration files to get the servers to operate correctly.

Russell Gilbert · April 12, 2008, 08:44:06 AM

Quote from: wesleyroyer on April 04, 2008, 10:50:06 PM
I just thought of something. I don't think it is possible to run server-side scripts like PHP in FSHost. Russell, if you can, could you please make a CGI script execute feature for FSHost Remote Access pages (not sure if that is the correct terminology to say that, but you catch my drift)?

PHP is a large system that can't easily be added to FSHost. FSHost's built-in web server is meant to just display the server status, and static HTML pages that you create yourself. I don't have any plans to add support for programming languages like PHP because it could slow down the server and possibly affect game play. Sorry.

Russell

wesleyroyer · April 13, 2008, 02:20:57 PM

Ok i am back from Atlanta. I guess since you can't run PHP on FSHost, then this project using PHP is pointless, unless you could use the XML feature to dump to a remote server running PHP and MySQL. That way, FSHost still stays the same, but instead of running the scripts on FSHost, you would run it on the remote webserver. Then put the XML data onto a PHP/MySQL remote site and it will update every time a user opens the page. From there, you could create user accounts and have a "personalized" FSHost status page. I am going to stop trying to do this stuff, because I have other things to do, but if someone else wants, I am sure this wouldn't be hard to do, especially with a PHP template.

Wesley Royer

karl800 · January 01, 2009, 02:08:03 PM

Hi Wesley, Any updates on your sites.. I would be interested, in trying build a full site doing something similar.. I see that Simfly.eu managed do something good which would be nice too do something like theres. And i guess, they using php and sql and using fshost to get data.

wesleyroyer · January 02, 2009, 01:27:59 AM

Unfortunately, I deleted all my files that I worked on that had to do with this topic due to a computer reformat, and my site is down. I have no further plans to continue this project at this time, but I am willing to provide some help on this to anyone who wants it. I don't think it should be too hard. If anyone wants help, you can email me at wesleyroyer@wroyer.net.

Regards,

Wesley Royer

karl800 · January 02, 2009, 05:11:40 AM

Cheers Wesley, Nice to hear that you don't mind to help, shame tho to hear that you decided not to continue.

Will Let you know if i get somit sorted..
Thanks Again

WWW394 · January 05, 2009, 01:19:51 PM

Just create a login webpage for the accounts... that is kept in a db

Then only members will have access to it... I recommend PHP-Fusion...

You can edit PHP-Fusion to had custom pages, custom links, custom panels, Etc...

Then you change/set the access levels to:
Public, Member, Admin, Etc...

My Wrath of the Lich King Private Game server website...
WOTLK USA REALMS

MY DEMO SITE:
PHP-Fusion / FSHost Test Site

DEMO SITE LOGIN INFO BELOW:
UN: Guest
PW: fshost

OBTW: Did I mention PHP-Fusion is Free...

OBTW: wesleyroyer, your avatar is way to big...
what you are using as your avatar, should be your sig...