User Site

King

Hi im making a web page for an Ultima Online shard. And I need a user information site. I want it to be able for players to log in by typing there account name and password. and be able to see there account info. And for me as admin of the shard be able to go in and edit there account info wehn ever needing to be done...

I do not know how to do this at all. And I really need it fast or im afraid my shard may fall apart. 🙁

this has to be able to connect to my shard folder and into the account file...but I REALLLY NEED HELP FAST PLEASSEEE. I need help from the beginning of the whole thing really. 🙁 🙁 🙁 🙁

King

umm Does anyone know how to accces a fle with a web script?

silasistefan

i made some php script for user...
try it!

<?php
/checks the user name/
if ($utilizator=='test'){
/if good user name found, then refresh to this page/
header("Location: ok.html?utilizator=test");
exit;
}
/checks for username and password/
elseif ($utilizator=='stefan'){
if ($parola=='ok'){
/if good user name found, then refresh to this page/
header("Location: ok.html?utilizator=stefan");
exit;
}
else{
echo 'User or password wrong.';
}
}
else {
echo 'User or password wrong.';
}

Enjoy it.

rklapwijk

Here's some help on the login page, don't expect that someone will code the entire script for you...
People are here to help you, not to code for you.

<?php
if ($submit) {

if ($user != "" && $pass != "") {

    if ($user == "test" && $pass == "test") echo "username and password are correct";
    else echo "username/password do not match";

}
else echo "enter username and password";

}
else {
?>
<form name="login" method="post" action="<?php echo $PHP_SELF;?>">
username: <input type="text" name="user"><br>
username: <input type="password" name="pass"><br>
<inputt ype="submit" name="submit" value="submit"></form>
<?php
}
?>

King

umm heh Now how exactly do I get this to show up??? DO I just put it in my web page?? and then when it loads up it will be there......and how would I get the login thing to read the file to actually see if that account and stuff is there?

Blob

<?
// Connect to Database
// Set the sql-server data - get the info from host.
$server= "yourServer"; // Database server
$user= "yourDBusername"; // Username
$password= "yourDBpass"; // Password
$database= "yourDBname"; // Database name
$table= "membersORwhatever"; // Table name
$date = date("d/m/Y H:i"); // Date stamp, may as well :P

// Access SQL-server
MYSQL_CONNECT($server, $user, $password) or die ( "<H3>Server unreachable</H3>");
MYSQL_SELECT_DB($database) or die ( "<H3>Database non existent</H3>");

// Check if form has been submitted and if the user wants to login, or has attempted logging in.
if (!$submit) {
// Form is being viewed for the first time. Display the form.
?><html>
<head>
<title>Site</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="frmLogin" method="post" action="login.php3">
Username: <input type="text" name="username"><br>
Password: <input type="password" name="password"><br>
<input ype="submit" name="submit" value="Login">
</form><?
} else {
// User is trying to login.
$check = "select username from $table where username = \"username\"";
$check_result = mysql_query($check) or die ("Can't execute email check.");
$check_num = mysql_num_rows($check_result);

if ($check_num == 0) {
// If $check_num is 0, then no match was found, and user doesn't exist.
echo "Username doesn't exist."
} else {
// User was found, compare this username with the password on the same row... I don't know how to do this, so could somebody finish this off? :o

Blob

Or instead of finishing of my code, you can do this tutorial. 🙂

http://robouk.mchost.com/tuts/tutorial.php?tutorial=login

It covers the registration and the logging in.

As for the account info, they can only see their own?
In that case, check if they are logged in, if they are, search the database for their username, and then the other fields should have data that's different for each user... Get that, and shove it in variables or an array.

Next, have one php script, called account.php for example, and create the layout and text.

Use phpMyAdmin to modify the database table, and the info of each user.

In the account page (I've never played Ultima Online... I meant to, but never got it lol. 🙁 ), just display the vars when needed... For example...

Welcome <? $username ?>, <br>
your current balance is: <a href="http://www.yoursite.com/bank.php"><? $money ?></a>.

Good luck.

EDIT: By the way, use a session to check if the user is logged in, so he/she doesn't have to login for every page...

King

woah NM! 🙂 I found this website where they already have one for UO 🙂. The only thing is........It says I need ISS and ASP.....what are those??? here are the requirements.

WINNT or Higher version

IIS Server 4.0 or higher

MS Access 2000 Jet Oledb Driver (IIS 5.0 has it built-in, but DO NOT Access 2002's Jet driver. The version should be 4.0)

IIS SMTP (CDONTS) Mail service, or Jmail, ASPmail, ASP Email installed (Recommend CDONTS)

(If you use Jmail, ASPmail or ASP Email) A Working SMTP Service provider, such as SMTP1.SYMPATICO.CA

ALL I know I have is WIN XP PRO.....what the heck are all the other things????????

King

woah NM! 🙂 I found this website where they already have one for UO 🙂. The only thing is........It says I need ISS and ASP.....what are those??? here are the requirements.

WINNT or Higher version

IIS Server 4.0 or higher

MS Access 2000 Jet Oledb Driver (IIS 5.0 has it built-in, but DO NOT Access 2002's Jet driver. The version should be 4.0)

IIS SMTP (CDONTS) Mail service, or Jmail, ASPmail, ASP Email installed (Recommend CDONTS)

(If you use Jmail, ASPmail or ASP Email) A Working SMTP Service provider, such as SMTP1.SYMPATICO.CA

ALL I know I have is WIN XP PRO.....what the heck are all the other things????????

King

-_-

~what happened there........lol

Blob

Are you hosting this on your own server? I'm guessing not, like me. 🙂

In that case, you need not worry about that, except the ASP... Active Server Pages - your host will need to support that.

Could you post the link to that site? 😃

King

OK but what server???? The internet host???? I put my own web pages up does that mean Im the host????? but heres the link...

http://www.onlineuo.com/

oc1000

as far as asp, most servers are either unix based or microsoft based. to use asp code you need to have a microsoft server running iis, or if your server is unix based you'll need to convert the asp to php. I've seen a program called asptophp or something like that to do it, but i've never used it.

King

Im using WIndows XP Pro So then how do I install ISS???and where would I get it?

oc1000

I think you have a fundimental misunderstanding. Unless you are hosting the website on your own server at your house, then what you have is irrelevant except for testing. Your website host, whoever you pay to host your website is either running a unix based server, or a microsoft based server. IIS is microsoft's version of a web based server, kind of like Apache for unix. To use ASP code your web server needs to be ISS, you'll need an Access Database (microsoft database) and the knowledge to integrate them. It's not as difficult as it sounds, but you need to figure out what kind of server your site is hosted on. That will determine if you should be looking toward ASP code, or PHP.

King

Oh well umm do you know what Centurytel has????I have centurytel.

King

They have ISS.....SO how ould I install this thing?

Blob

Is it a windows host? Make sure.

I'd help... But I need the link - that one didn't work. I'll help you through installing it. 🙂

King

Thanx for the help but heres the link again......

http://www.onlineuo.com/

and if that doesnt work just go to

www.onlineuo.com

and heres the discription of the one im using...

CGI Account Creation And Management

Program Name:CGI Account Creation And Management

License:Shareware

Program Type:Management systems Program Rank:

Program Size: 283K Related Link: home page

Upload Date:2002-3-15 Today's Hit:2 Week:6 Total1110

Operation System: ASP Based

Links: Site 1

Program Description:

For those who run any windows based web server(ie. Apache) Belgar has a new account creation tool that is coded in C++ and acts as a CGI (common gateway interface).

it's fast, and also secure.

a README Document is included, make sure you read it.

Support available thru www.sphereserver.com boards in the 3rd party help

Blob

Which one's that? Could you link to the exact one you're using lol?