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.
Printable View
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.
Nah, you're completely off-topic.Quote:
Originally Posted by mig1st4ck
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
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
wtf? how fix?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
i only said this topic was old.Quote:
Originally Posted by DataMatrix
your problem is in encrypt. You dident creat the Stored procedure Encrypt.Quote:
Originally Posted by AdidasS
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
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:
so that ur db use that dllCode:use master
go
sp_addextendedproc 'XP_MD5_EncodeKeyVal', 'WZ_MD5_MOD.dll'
go
sp_addextendedproc 'XP_MD5_CheckValue', 'WZ_MD5_MOD.dll'
go
exit
then use db memuonline on query analyzer
and type this
after this u can register accounts through ur webCode: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
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.
whats that column for?Quote:
Originally Posted by mig1st4ck
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.
Could you modify the muweb ver 0.3 so that it will be compatible to 0.99.60+ ??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.
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!
I already done that. I have full working site all in PHP.with login an so on. All to this version. Check it hereQuote:
Originally Posted by Aszmhodeus
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.
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 problemQuote:
Originally Posted by mig1st4ck
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.Quote:
Originally Posted by torrentin
Make sure it is in encrypta and not encrypt.
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...Quote:
Ok i finished the conversion of MuWeb v0.3
you can download here
read the info inside.
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.
like this? GrudgeMU Full PHP Global WebQuote:
Originally Posted by Aszmhodeus
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
Wow that was fast! thanks again I'll try this one... I'll pm you if I found some bugs...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
someone wana upload to other host? i just cant download at rapidshare :S
download hereQuote:
Originally Posted by Nocturnal
can you change over mutoolz?
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
did you configured config.php and config1.phpQuote:
Originally Posted by juanmanuelsaad
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?
also at my place help pleaseQuote:
Originally Posted by pasooo
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...
also change the ODBC. and ranking and event.Quote:
Originally Posted by z3r0tech
mutoolz2.2RC3
can you post here a link to download it.Quote:
Originally Posted by phillips41
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 areQuote:
Originally Posted by z3r0tech
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...
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.Quote:
Originally Posted by mig1st4ck
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
dont work.it makes the account but when you try to login to game says password is incorrectQuote:
Originally Posted by mig1st4ck
mssql_connect(): Unable to connect to server:
how can fix this mistake?
check your configurationsQuote:
mssql_connect(): Unable to connect to server:
how can fix this mistake?
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
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????????
check the firewall. and cheack your port of site. default is 80.Quote:
Originally Posted by parsy
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.
i already did..same prob..anyone here know how to fix this?Quote:
Originally Posted by Krut
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!!