Secure Account Register page for 99.60+

Plain and simple: Allows users to create accounts on your 99.60+ server securely through a website.

Current Version: v1.0

Bugs? Let me know.

thx man!
i'l test it

?????????????

Hmm... good but I need example for .asp :(

Works fine! I only change your Me_MuOnline to MuOnline
Can you add change password pls?...


Thanks! keep it up!

I'll add change password later.

this was already posted 3 weaks ago.
http://forum.ragezone.com/guides/gui...0t-140100.html

You just simplified this.

great job but i hope you can add the important options like lvl reset, pk reset and stuffs.

Quote:

---

Originally Posted by mig1st4ck

this was already posted 3 weaks ago.
http://forum.ragezone.com/guides/gui...0t-140100.html

You just simplified this.

---

Nah, you're completely off-topic.

Thanks a lot for this page

Naa this code is the same of that topic.
Guys its simple to put all working in this verson. the only problem is the Password, so you need to create a collum for example named menb__pwd2, with varchar instead of binary.
and them use register to put the password in this collum too. So you will get 2 passwords in database 1 encrypted and other not. them you just use all pages you want like reset addstats ... and instead check for menb__pwd cheack for memb__pwd2.

Quote:

---

Originally Posted by DataMatrix

Nah, you're completely off-topic.

---

Loool not really, same old stuff

Maybe it is old stuff, but its nice and easy and probably has the best layout from them all.

But you guys dont appreciate good work, some people release stuff and you guys act like assholes.

Go screw yourself if you call yourself a RaGEZONER, because you've only just about joined, unlike me whose been here for nearly two years.

PS: Thanks for bumping my topic :).

for me password do not match

Quote:

---

Warning: mssql_query() [function.mssql-query]: message: Could not find stored procedure 'Encript'. (severity 16) in c:\AppServ\www\reg\register.php on line 67

Warning: mssql_query() [function.mssql-query]: Query failed in c:\AppServ\www\reg\register.php on line 67

---

wtf? how fix?

Quote:

---

Originally Posted by DataMatrix

Maybe it is old stuff, but its nice and easy and probably has the best layout from them all.

But you guys dont appreciate good work, some people release stuff and you guys act like assholes.

Go screw yourself if you call yourself a RaGEZONER, because you've only just about joined, unlike me whose been here for nearly two years.

PS: Thanks for bumping my topic :).

---

i only said this topic was old.

Quote:

---

Originally Posted by AdidasS

wtf? how fix?

---

your problem is in encrypt. You dident creat the Stored procedure Encrypt.

Code:

---

Quote:
Warning: mssql_query() [function.mssql-query]: message: Could not find stored procedure 'Encript'. (severity 16) in c:\AppServ\www\reg\register.php on line 67

Warning: mssql_query() [function.mssql-query]: Query failed in c:\AppServ\www\reg\register.php on line 67

---

Quote:

---

Originally Posted by AdidasS

wtf? how fix?

---

u must make ecrypta procedure before register in web
use sql query analizer
also need this file: WZ_MD5_MOD.dll
First Copy WZ_MD5_MOD.dll to Program Files\Microsoft SQL Server\MSSQL\Binn
its all in guides section next time try to use "search"

http://forum.ragezone.com/attachment...r?d=1149192850

first do this:

Code:

---

use master
go
sp_addextendedproc 'XP_MD5_EncodeKeyVal', 'WZ_MD5_MOD.dll'
go
sp_addextendedproc 'XP_MD5_CheckValue', 'WZ_MD5_MOD.dll'
go
exit

---

so that ur db use that dll

then use db memuonline on query analyzer
and type this

Code:

---

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UFN_MD5_CHECKVALUE]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[UFN_MD5_CHECKVALUE]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UFN_MD5_ENCODEVALUE]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[UFN_MD5_ENCODEVALUE]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE FUNCTION UFN_MD5_CHECKVALUE
(
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10),
@btInVal BINARY(16)
)
RETURNS TINYINT
AS
BEGIN
DECLARE @iOutResult TINYINT

EXEC master..XP_MD5_CheckValue @btInStr, @btInVal, @btInStrIndex, @iOutResult OUT

RETURN @iOutResult
END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE FUNCTION UFN_MD5_ENCODEVALUE
(
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
)
RETURNS BINARY(16)
AS
BEGIN
DECLARE @btOutVal BINARY(16)

EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT

RETURN @btOutVal
END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

7> Then Query it
8> After that del all line and copy these line to Query

CREATE PROCEDURE Encripta
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS

BEGIN
DECLARE @btOutVal BINARY(16)

EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT

UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
END
GO

---

after this u can register accounts through ur web

credits are all from ragezoners, i dont remember names now only remember carcabot but there are some more

guys if you want the site 100% working in this verson, post the site you whant And i change it to work 100%.

For thouse who understand making sites I already posted the solution. i'll try to create the quary to make the extra collum Menb__pwd2. So its easy.

PS:post your sites. Sory for my bad english.

Quote:

---

Originally Posted by mig1st4ck

guys if you want the site 100% working in this verson, post the site you whant And i change it to work 100%.

For thouse who understand making sites I already posted the solution. i'll try to create the quary to make the extra collum Menb__pwd2. So its easy.

PS:post your sites. Sory for my bad english.

---

whats that column for?
u know how to migrate whole accts from 1.2d to this version tks man

In this verson Menb__pwd is encrypted so we can not use this in site. So i duplicated that colum and made memb_pwd2 Not encrypted, them i put all website links focos to menb_pwd2 .
thats all. I only put in regist.php a value to Memb__pwd2 so we can have the pass not encryped. and about change passe just run the encrypt procedure with the new pass. If you have a site you need to make this system work post it and I will change it.

About migrating contes, i have no idea but use seach there are some guides to do that already.

Quote:

---

guys if you want the site 100% working in this verson, post the site you whant And i change it to work 100%.

For thouse who understand making sites I already posted the solution. i'll try to create the quary to make the extra collum Menb__pwd2. So its easy.

PS:post your sites. Sory for my bad english.

---

Could you modify the muweb ver 0.3 so that it will be compatible to 0.99.60+ ??

Thanks! I'm counting on you...

i need a good php scripter / coder ..so i`ll edit the global html site ..and add some php on it like registration ..rankings..

If you want this register page to work properly you MUST follow the installation.txt.

If you don't you will not get it working, ignore any posts about people telling you stuff in this post and follow the guide!!!

The reason you get errors is because you dont read the guide!

Quote:

---

Originally Posted by Aszmhodeus

i need a good php scripter / coder ..so i`ll edit the global html site ..and add some php on it like registration ..rankings..

---

I already done that. I have full working site all in PHP.with login an so on. All to this version. Check it here

I'll start working in 0.3 website.

Can you share it ? :)

Ok i finished the conversion of MuWeb v0.3
you can download here

read the info inside.

Quote:

---

Originally Posted by mig1st4ck

In this verson Menb__pwd is encrypted so we can not use this in site. So i duplicated that colum and made memb_pwd2 Not encrypted, them i put all website links focos to menb_pwd2 .
thats all. I only put in regist.php a value to Memb__pwd2 so we can have the pass not encryped. and about change passe just run the encrypt procedure with the new pass. If you have a site you need to make this system work post it and I will change it.

About migrating contes, i have no idea but use seach there are some guides to do that already.

---

ive read all guides but still some problems with passwords, accts go to new database and chars too but pass as u said are encrypted and thats a problem

Quote:

---

Originally Posted by torrentin

ive read all guides but still some problems with passwords, accts go to new database and chars too but pass as u said are encrypted and thats a problem

---

download this site here and see what i changed, its tested and work. it create the collum Memb__pwd2 in the install. you just need to do the encrypta.

Make sure it is in encrypta and not encrypt.

Quote:

---

Ok i finished the conversion of MuWeb v0.3
you can download here

read the info inside.

---

Very big thanks! i'll try this one! I'll post again after I find some bugs or problems...

Quote:

---

Ok i finished the conversion of MuWeb v0.3
you can download here

read the info inside.

---

I followed your guide but still not working...

but the registration of datamatrix works perfect it only has to have a change password

The web I posted only suport MuOnline. It will not suport MeMuonline.
Later i post one for MeMuonline.

Quote:

---

Originally Posted by Aszmhodeus

i need a good php scripter / coder ..so i`ll edit the global html site ..and add some php on it like registration ..rankings..

---

like this? GrudgeMU Full PHP Global Web

its a full PHP web, but still need to work on Slow loading, need to optimize it.

PS: not for release

I finished MuWeb ver 0.3 to suport MeMuonline.
You just need to configure Config.php with database MuOnline, and Config1.php with MeMuOnline.
Them install the page.
Report Any Bugs you find.
Download here

Quote:

---

I finished MuWeb ver 0.3 to suport MeMuonline.
You just need to configure Config.php with database MuOnline, and Config1.php with MeMuOnline.
Them install the page.
Report Any Bugs you find.
Download here

---

Wow that was fast! thanks again I'll try this one... I'll pm you if I found some bugs...

someone wana upload to other host? i just cant download at rapidshare :S

Quote:

---

Originally Posted by Nocturnal

someone wana upload to other host? i just cant download at rapidshare :S

---

download here

can you change over mutoolz?

Tomarow i see the MuToolz.

I have Created a Web that install almost everything. You just need to put WZ_MD5_MOD.dll in SQL bin folder. The install of the webpage do the rest.

download here or here

ok i will wait to see if you can do mutoolz

when i install it do me that error

Quote:

---

Fatal error: Call to undefined function: mssql_connect() in c:\appserv\www\config.php on line 372 :S

---

Quote:

---

Originally Posted by juanmanuelsaad

when i install it do me that error

---

did you configured config.php and config1.php
and the name of the databases are right correctly?

If in config are MuOnline and the data in SQL be muonline, it will not work. you need the right name. also check user and pass in both files.

well it's all ok but the error is the same :S...i really don't know :S

undefined function: mssql_connect()

Same problem. Do u know some free web hosting that support this?

Quote:

---

Originally Posted by pasooo

undefined function: mssql_connect()

Same problem. Do u know some free web hosting that support this?

---

also at my place help please

Tested both MuOnline and Me_MuOnline muweb0.3 followed all instructions...

I don't have any problems but when I tried to register it seems like registering but when I log in the game the account is invalid...

Hi guys. the problem in register is because i forgot to put config1.php in folder modules and ranking. Sorry
put the atached file in modules folder and in rankings. My mistake.

I'll reupload this with everything.


PS: what version of MuToolz you want me to change?

mig1st4ck
Can you post the db baks and the odbc you are using with I think a have a problem in my db baks and odbc please. Thanks! /Respect...

Quote:

---

Originally Posted by z3r0tech

mig1st4ck
Can you post the db baks and the odbc you are using with I think a have a problem in my db baks and odbc please. Thanks! /Respect...

---

also change the ODBC. and ranking and event.

mutoolz2.2RC3

Quote:

---

Originally Posted by phillips41

mutoolz2.2RC3

---

can you post here a link to download it.

you can go to JohnD's Forum - Powered by vBulletin and download there.
johnd is currently developing a new mutoolz for 0.99.60+ servers.

mig1st4k how could i know if im using either Me_MuOnline or MuOnline database?

Quote:

---

Originally Posted by z3r0tech

you can go to JohnD's Forum - Powered by vBulletin and download there.
johnd is currently developing a new mutoolz for 0.99.60+ servers.

mig1st4k how could i know if im using either Me_MuOnline or MuOnline database?

---

LOL when you instaled the Databases in SQL. see the names. as you can see in the atached image. My databases are
MuConectLog
MuLog
MuOnline
Ranking

i don't use MeMuonline. you need to put in config.php your name of database Muonline exactly the name you entered in SQL. Muonline is deferente of muonline. see the Caps. In config1.php you need to put the name of database MeMuOnline if you mixed the databases like me you put MuOnline if not just put the exact name.

Sorry im still new to this... but can you please post your odbc.reg? Thanks again...

Quote:

---

Originally Posted by mig1st4ck

can you post here a link to download it.

---

i am uploading link now.if this dont work when you see it just give it a few more mins. for it to finish uploading. click here.
ps
no need to make it work for all those databases.i have combined all the databases into 2 MuOnline and Ranking

good script thx

MuToolz is very diferent code. it uses ODBC insted of direct conection. so it uses alot of new feactures. i can aranje a regist page to start. but all the MD5 SQl scrips have to be manualy introduced. I can also arange login. but for now its the least i can do.

edited: this muToolz code is very hard stuff. nothing like normal php. i have change a little in install to create memb_pwd2 and change register, but i cant find the login. (i find it but i dont see where is it geting the values, so i cant change it.)

if anyone want to help testing. here is the 2 files i change.

PS: this for now only work with 1 database MuOnline. and with Stored procedure instaled and working. If you don't know how to install it just do the install of MuWeb ver 0.3 and them install mutoolz.

I'm testing it now

Quote:

---

Originally Posted by mig1st4ck

MuToolz is very diferent code. it uses ODBC insted of direct conection. so it uses alot of new feactures. i can aranje a regist page to start. but all the MD5 SQl scrips have to be manualy introduced. I can also arange login. but for now its the least i can do.

edited: this muToolz code is very hard stuff. nothing like normal php. i have change a little in install to create memb_pwd2 and change register, but i cant find the login. (i find it but i dont see where is it geting the values, so i cant change it.)

if anyone want to help testing. here is the 2 files i change.

PS: this for now only work with 1 database MuOnline. and with Stored procedure instaled and working. If you don't know how to install it just do the install of MuWeb ver 0.3 and them install mutoolz.

---

dont work.it makes the account but when you try to login to game says password is incorrect

mssql_connect(): Unable to connect to server:
how can fix this mistake?

Quote:

---

mssql_connect(): Unable to connect to server:
how can fix this mistake?

---

check your configurations

I use your MuWeb3 i.ve all istalled but:
Warning: mssql_query() [function.mssql-query]: message: Column names in each table must be unique. Column name 'Reset' in table 'dbo.character' is specified more than once. (severity 16) in C:\root\install\install2.php on line 74

Warning: mssql_query() [function.mssql-query]: Query failed in C:\root\install\install2.php on line 74

Warning: mssql_query() [function.mssql-query]: message: Column names in each table must be unique. Column name 'adm_check' in table 'dbo.memb_info' is specified more than once. (severity 16) in C:\root\install\install2.php on line 76

Warning: mssql_query() [function.mssql-query]: Query failed in C:\root\install\install2.php on line 76

Warning: mssql_query() [function.mssql-query]: message: Column names in each table must be unique. Column name 'memb__pwd2' in table 'dbo.memb_info' is specified more than once. (severity 16) in C:\root\install\install2.php on line 77

Warning: mssql_query() [function.mssql-query]: Query failed in C:\root\install\install2.php on line 77


WHAT TO DO?????

Quote:

---

Originally Posted by parsy

I use your MuWeb3 i.ve all istalled but:
Warning: mssql_query() [function.mssql-query]: message: Column names in each table must be unique. Column name 'Reset' in table 'dbo.character' is specified more than once. (severity 16) in C:\root\install\install2.php on line 74

Warning: mssql_query() [function.mssql-query]: Query failed in C:\root\install\install2.php on line 74

Warning: mssql_query() [function.mssql-query]: message: Column names in each table must be unique. Column name 'adm_check' in table 'dbo.memb_info' is specified more than once. (severity 16) in C:\root\install\install2.php on line 76

Warning: mssql_query() [function.mssql-query]: Query failed in C:\root\install\install2.php on line 76

Warning: mssql_query() [function.mssql-query]: message: Column names in each table must be unique. Column name 'memb__pwd2' in table 'dbo.memb_info' is specified more than once. (severity 16) in C:\root\install\install2.php on line 77

Warning: mssql_query() [function.mssql-query]: Query failed in C:\root\install\install2.php on line 77


WHAT TO DO?????

---

its everything right. the errors is because you already have, the collums Reset, adm_check, memb__pwd2.

I have a Problem:
Since i wroted http:\\myip\install\install.php and my WINDOWS BLOCKED
I've managet to install the web page and i've decidet to test to make an account, so i wrote the data needed and when i pressed Register my WINDOWS BLOCKED AGAIN????
Whats the problem????????

Quote:

---

Originally Posted by parsy

I have a Problem:
Since i wroted http:\\myip\install\install.php and my WINDOWS BLOCKED
I've managet to install the web page and i've decidet to test to make an account, so i wrote the data needed and when i pressed Register my WINDOWS BLOCKED AGAIN????
Whats the problem????????

---

check the firewall. and cheack your port of site. default is 80.

http://myserver/register.php?account...LaTo&password= xxx << HUH ?

thanx ill test it ;)

how to fix this..

http://img469.imageshack.us/img469/2964/mu3ec9.jpg

i am using MuOnline in sql.

make sure u allow php_mssql in C:/windows/php.ini folder also if ur using wamp click wamp go to php extensions then find php_mssql and click it :D
and then restart the wamp or apache.

Quote:

---

Originally Posted by Krut

make sure u allow php_mssql in C:/windows/php.ini folder also if ur using wamp click wamp go to php extensions then find php_mssql and click it :D
and then restart the wamp or apache.

---

i already did..same prob..anyone here know how to fix this?

Fatal error: Call to undefined function: mssql_connect() in c:\appserv\www\config.php on line 372

Same here . Ihave put in needed info
// Enter the IP or DSN of the database server to connect to
$dbhost = "192.168.1.100";

// Enter the username to connect to the db, default is sa
$dbuser = "sa";

// Enter the password for your SQL Server
$dbpasswd = "sulat";

// Enter the Database name for your SQL Server
$database = 'MuOnline';

// Host. IP If working remotely, usually 127.0.0.1 works
$host = "192.168.1.100";

but still gett the following error.
Fatal error: Call to undefined function: mssql_connect() in c:\appserv\www\config.php on line 372
*** Pls help thx

Warning: mssql_query() [function.mssql-query]: message: Violation of PRIMARY KEY constraint 'PK_MEMB_INFO_1'. Cannot insert duplicate key in object 'MEMB_INFO'. (severity 14) in C:\wamp\www\mu\modules\doreg.php on line 194

Warning: mssql_query() [function.mssql-query]: Query failed in C:\wamp\www\mu\modules\doreg.php on line 194
Your account has been created succesfully:


Somebody can help me ? There's no account created and i always get the same error when try to create a new account ? I've copied the .dll file in MSSQL ! I've WAMP configured and running ! Thanks in advance !

All seems, that we have got more great other problem with XP_MD5_EncodeKeyVal self on several md5 version MU servers: http://forum.ragezone.com/post1459907.html

wow! thanks dude it's great!

Pls somene hepl me y downloaded all modified files for mu web 3.0 and when y try to make a new acc y get this error pls hepl me ym disperate:eek6: The errour looks like this

Warning: include(config1.php) [function.include]: failed to open stream: No such file or directory in C:\AppServ\www\modules\doreg.php on line 164

Warning: include() [function.include]: Failed opening 'config1.php' for inclusion (include_path='.;C:\php5\pear') in C:\AppServ\www\modules\doreg.php on line 164

Warning: mssql_query() [function.mssql-query]: message: Violation of PRIMARY KEY constraint 'PK_MEMB_INFO_1'. Cannot insert duplicate key in object 'MEMB_INFO'. (severity 14) in C:\AppServ\www\modules\doreg.php on line 194

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\modules\doreg.php on line 194
Your account has been created succesfully:

Login ID:
pizdamu
Name:
pizdamu
E-mail:
pizda@yahoo.com
Password:
pizda
Recovery Question:
bastard
Recovery Answer:
bbbb
Number:
666666666666

And the account is not created

Good Job
Keep it up!!