[Release]Web Register

[sandolkakos]

I have made this Web Register, and i am posting here to the peoples that still dont have.

Episode 3
File Attached: reg.rar

Obs.:
Make Auto-Incremet in:
Table = dbo.Users_Master
Colum = UserUID

i dont remember the Script to Alter, but look this informations:
Enter in Modify Table (Design Tablhe):
Is Identity --> Yes
Identity Seed --> 1
Identity Increment --> 1 (Number to be incremented by i.e if the previous number is 2 and identity increement is next number would 2+1)

---------------------------------
Episode 4
File Attached: WebRegister_Shaiya_EP4.zip

In this DONT need alter the Table Design.
Only change DatabaseIP, DatabaseUSER, DatabasePASSWORD in processor.php
and run the query of sp_CreateOmgGMGameAccount.txt

Done.

[(Virus)]

Is there any other kind of pages? like htm,html,asp and etc?? if u have or know how to make it please share coz i hate php allways problem :S thx

[Polypropylen]

added to:

[sandolkakos]

Originally Posted by (Virus)

Is there any other kind of pages? like htm,html,asp and etc?? if u have or know how to make it please share coz i hate php allways problem :S thx

sorry friend,
I dont work with other code languages, hehe, only php

Originally Posted by Polypropylen

added to:

Thanks ^^

[ProfNerwosol]

With EP4 DB's you need to insert user info into OMG_GameWeb.dbo.GameAccountTBL as well or you will get error - wrong password - when trying to login.

[(Virus)]

Originally Posted by ProfNerwosol

With EP4 DB's you need to insert user info into OMG_GameWeb.dbo.GameAccountTBL as well or you will get error - wrong password - when trying to login.

yea im having problem with that and can't find how to create php with it.. :/

[ProfNerwosol]

First thanks go to sandolkakos. Without his post I'd never have done it. Too lazy ;p

I used sandolkakos php script and modified it a bit. Now it call stored procedure in PS_UserData which inserts all the values. It's easier this way and less error prone.

Two files index.php & processor.php are the ones to use. Extra txt file contains procedure. I modified few little things. Just open the procedure (the file has same name), copy paste from the text file and Execute. (the procedure I am talking about is stored in PS_UserData, edit it).

Make sure your php has mssql support turned on. If you are running it on your PC.

[(Virus)]

Originally Posted by ProfNerwosol

First thanks go to sandolkakos. Without his post I'd never have done it. Too lazy ;p

I used sandolkakos php script and modified it a bit. Now it call stored procedure in PS_UserData which inserts all the values. It's easier this way and less error prone.

Two files index.php & processor.php are the ones to use. Extra txt file contains procedure. I modified few little things. Just open the procedure (the file has same name), copy paste from the text file and Execute.

Make sure your php has mssql support turned on. If you are running it on your PC.

Hey profnerwosol, do that one connect to both, User_Master and OMG_GameWeb? =)

[ProfNerwosol]

Neither. It selects database only [PS_UserData], to call procedure stored in it. Then the control what to put where is transfered to it (along with parameters, like login,password).

[sandolkakos]

I have added other file that i made today.

This other work 100% in ProfNerwosol Server Files:


if you are using this Server Files, dont need make nothing configurations in Database,
Only change DatabaseIP, DatabaseUSER, DatabasePASSWORD in processor.php

[ProfNerwosol]

Originally Posted by sandolkakos

I have added other file that i made today.

This other work 100% in ProfNerwosol Server Files:


if you are using this Server Files, dont need make nothing configurations in Database,
Only change DatabaseIP, DatabaseUSER, DatabasePASSWORD in processor.php

Hey, you attached that file of mine to your first post. Thanks!

EDITED:


Currently I am working on more sophisticated registration script. When it's done I'll post it.


EDITED2:

Registration script ready.

Options go as follows:

- login and password are verified; length of both is enforced;
- set range of accepted characters for login and password;
- password cannot be the same as login;
- included extra fields: email, PasswordQuestion & PasswordAnswer; (each is stored in DB);
- checks for duplicate Login or Email (2nd is for future use);
- checks email correctness (mostly for fun, but sometimes you press wrong button without notice and click register; and wait, and wait ... hmm)

Those who are interested please PM me and I will send it.

[Schwap]

hey sandolkakos,
i guess this sounds noobish, but ive to ask.

i tried this:
Episode 4
File Attached: WebRegister_Shaiya_EP4.zip

i opened processor.php with notepaf and changed this line:

$conn=mssql_connect('DatabaseIP','DatabaseUSER','D atabasePASSWORD');

with this:

$conn=mssql_connect('127.0.0.1','sa','sapasswort') ;

then i saved it again as processor.php

now i opened firefox, open index.php, i fill user***:repass and clicked Register.
after thats done i get to this screen:



i also tried it with the mssql server name, and with the user name, same failure.

what im doin wrong?

[ProfNerwosol]

Originally Posted by Schwap

hey sandolkakos,
i guess this sounds noobish, but ive to ask.

i tried this:
Episode 4
File Attached: WebRegister_Shaiya_EP4.zip

i opened processor.php with notepaf and changed this line:

with this:

then i saved it again as processor.php

now i opened firefox, open index.php, i fill user***:repass and clicked Register.
after thats done i get to this screen:



i also tried it with the mssql server name, and with the user name, same failure.

what im doin wrong?

[sandolkakos]

Originally Posted by Schwap

hey sandolkakos,
i guess this sounds noobish, but ive to ask.

i tried this:
Episode 4
File Attached: WebRegister_Shaiya_EP4.zip

i opened processor.php with notepaf and changed this line:

with this:

then i saved it again as processor.php

now i opened firefox, open index.php, i fill user***:repass and clicked Register.
after thats done i get to this screen:



i also tried it with the mssql server name, and with the user name, same failure.

what im doin wrong?

you are running without PHP Engine
Look for programs:
EasyPHP or xampp

Look for Tutorials about how use the program that you choose.

[Schwap]

ok guys, thank you, im 100% new to servers, mssql, php, databases and so on :/

so forgive me my noobie questions