MUToolz English Guide

[SkylineMaster]

GUIDE BY JOHN_D, GUIDE BY JOHN_D, GUIDE BY JOHN_D
CREDITS TO JOHN_D, CREDITS TO JOHN_D, CREDITS TO JOHN_D

Here is My idea on installation Guide.

REQUIREMENTS:
Webserver with PHP5 or 4 or newer
i recommend using

To view the content, you need to sign in or register

wamp server is very small but very capable web server package.

I used it on my

To view the content, you need to sign in or register

To view the content, you need to sign in or register

xampp server on the other hand is a big bulky and very fully featured server that has almost everything u need to start a webserver service, from smtp servers to ftp servers.

I used xampp on this webserver you are on now.
PHP Pear

To view the content, you need to sign in or register

PHP Pear DB package is needed for this site to work.

You will get DB.PHP not found if u dont have pear.

To install Pear is rather rather easy, if u have those two webserver package i mentioned above. Just go to there Php (4/5) folder that your are using (wamp would be at c:\wamp\php and xampp would be at c:\apachefriends\xampp\php5) and Run the Gopear.bat , it will then talk you in the pear installation, you can choose to install other pear packages, but we only need Pear DB package for Muyoolz

ODBC system dsn's
Your Webserver or the computer you are going to run Mutoolz v2.x must have capability to create ODBC system dsn.

The Name of ur System Dsn is up to you. just do not forget to edit this is in the config.php (
$MUtoolz = 'MUtoolz'; // MuOnline ODBC system dsn / database name ), where Mutoolz is the system dsn name
also on creating Mutoolz odbc system dsn follow these few rules

The Driver ur going to use SQL Server.
It must connection using Authentication ( SQL authentication using a login ID and Pass ) , the login and pass must be the same as in ur config (
$dbuser= "sa";
$dbpass= "xxxxx"; )

Point the database or change the default database in your Muonline databse. test connect it and u should have no more problems.

PHP enviromental setup needed. php.ini tweaks
Enable php_mssql.dll ( well just to make sure u can connect )
Enable php_gd2.dll ( to be able to create images, we use this for guild logo and other stuff )

setting smtp config (
[mail function]
; For Win32 only.
SMTP = xx.xx.xxx.xxx
smtp_port = 25

; For Win32 only. ) that should be understandble
DATABASE CHANGES and SQL QUeries to make ur Mutoolz work ok!

Use Muonline;
alter table Character add Resets int;
alter table Character add mu_id int identity;
go

run this on ur query analyser and u should be ok!

INSTALLATION:

Install ur Website server for either WAMP or XAMPP
Install Pear

Setup your Odbc system dsn
edit ur php.ini

Do the Database Changes

Configure your Mutoolz's config.php
and off u go!

GUIDE BY JOHN_D, GUIDE BY JOHN_D, GUIDE BY JOHN_D, GUIDE BY JOHN_D
CREDITS TO JOHN_D, CREDITS TO JOHN_D, CREDITS TO JOHN_D

To view the content, you need to sign in or register

 

[Josh]

nice!

 

[fabiorf]

errrrrooo in reset char

GUIDE BY JOHN_D, GUIDE BY JOHN_D, GUIDE BY JOHN_D
CREDITS TO JOHN_D, CREDITS TO JOHN_D, CREDITS TO JOHN_D
Here is My idea on installation Guide.
REQUIREMENTS:
Webserver with PHP5 or 4 or newer
i recommend using

To view the content, you need to sign in or register

wamp server is very small but very capable web server package.
I used it on my

To view the content, you need to sign in or register

To view the content, you need to sign in or register

xampp server on the other hand is a big bulky and very fully featured server that has almost everything u need to start a webserver service, from smtp servers to ftp servers.
I used xampp on this webserver you are on now.
PHP Pear

To view the content, you need to sign in or register

PHP Pear DB package is needed for this site to work.
You will get DB.PHP not found if u dont have pear.
To install Pear is rather rather easy, if u have those two webserver package i mentioned above. Just go to there Php (4/5) folder that your are using (wamp would be at c:\wamp\php and xampp would be at c:\apachefriends\xampp\php5) and Run the Gopear.bat , it will then talk you in the pear installation, you can choose to install other pear packages, but we only need Pear DB package for Muyoolz
ODBC system dsn's
Your Webserver or the computer you are going to run Mutoolz v2.x must have capability to create ODBC system dsn.
The Name of ur System Dsn is up to you. just do not forget to edit this is in the config.php (
$MUtoolz = 'MUtoolz'; // MuOnline ODBC system dsn / database name ), where Mutoolz is the system dsn name
also on creating Mutoolz odbc system dsn follow these few rules
The Driver ur going to use SQL Server.
It must connection using Authentication ( SQL authentication using a login ID and Pass ) , the login and pass must be the same as in ur config (
$dbuser= "sa";
$dbpass= "xxxxx"; )
Point the database or change the default database in your Muonline databse. test connect it and u should have no more problems.
PHP enviromental setup needed. php.ini tweaks
Enable php_mssql.dll ( well just to make sure u can connect )
Enable php_gd2.dll ( to be able to create images, we use this for guild logo and other stuff )
setting smtp config (
[mail function]
; For Win32 only.
SMTP = xx.xx.xxx.xxx
smtp_port = 25
; For Win32 only. ) that should be understandble
DATABASE CHANGES and SQL QUeries to make ur Mutoolz work ok!
Use Muonline;
alter table Character add Resets int;
alter table Character add mu_id int identity;
go
run this on ur query analyser and u should be ok!
INSTALLATION:
Install ur Website server for either WAMP or XAMPP
Install Pear
Setup your Odbc system dsn
edit ur php.ini
Do the Database Changes
Configure your Mutoolz's config.php
and off u go!
GUIDE BY JOHN_D, GUIDE BY JOHN_D, GUIDE BY JOHN_D, GUIDE BY JOHN_D
CREDITS TO JOHN_D, CREDITS TO JOHN_D, CREDITS TO JOHN_D

To view the content, you need to sign in or register

Fatal error: Call to undefined function: fetchrow() in d:\www\www\mutoolz\_libs\mutoolz.tpl.php on line 515

 

[john_d]

wat page are u looking at.

 

[androoh]

i get this error when i try to connect to the sql db through a remote computer
any1 got any ideas ?

 

[john_d]

WOw.. that would be very obvious ur not allow to go in..

here is some idea though.
1. The sql server does not exist.
2. The sql server doesnt have mix mode authentication
3. The sql server is not listening to 1433 TCP
4. The Username password is wrong.

 

[androoh]

2. The sql server doesnt have mix mode authentication

how would i allow mix mode auth on the sql server

 

[john_d]

i dont remember wat wer it is.. been a while since i opened the enterprise manager.

but it should be there.

try rightclicking the mssql server there ( probably told called local ) ... go to propertise.. look for it.

 

[Aragus]

great thread, i do all listed and when i open index.php in the browser i get a black box with a thumbs up and in it is black text which says

Sql_Error
[nativecode=28000 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MUSERVER\IUSR_MUSERVER'.] ** odbc://saMUtoolz

i can see it is some kind of login fail. how to fix this?

 

[SkylineMaster]

Make a new DSN in ODBC named Mutoolz, Select default Database MuOnline

maybe that fix ur problem

 

[Aragus]

I need another? I already have one.

 

[stuk]

  	  Sql_Error
Unable to include the DB/odbc.php file for 'odbc://sa:***MY_MSSQL_PASS***@MuOnline'

***EDIT - THE PROBLEM WAS SOLVED***

 

[john_d]

I need another? I already have one.

just make they capitalization is exactly the same.

 

[stuk]

i have problem with the GD lib...
i have configered in the php.ini that the gd2 is enabled - and still he dont show me the guild pics...
i runing wamp server
*EDIT*
its not the GD - but it something - cuz the sig is working...

 

[Aragus]

Problem fixed....lol, pointed to wrong db.

I'm not a php wiz, is there anyway to just use the register.php as part of another page, or build a page around it. I would like to use my own page design but use the registration portion of mutoolz. Is there a way to do this. Credits will be given on page if I can just use the one portion.

Like to register you'd goto like

To view the content, you need to sign in or register

and be able to register an account. I like the whole mutoolz site but, I don't believe I know enuf to edit the look to my likeing.

Thanks for any help.

P.S. Don't use link, it's isn't a real one....lol. Just an example.

 

[john_d]

just edit the template.htm

 

[Aragus]

Ok John, thx. I'm a noob sry.

Next question, when I goto the Ranking portion I get the thumbs up again with this error.

Sql_Error
SELECT top 50 [Character].Money, [Character].Name, [Character].cLevel, [Character].Class, [Character].CtlCode , isnull(Resets,0) as Resets, MEMB_STAT.ConnectStat, [Character].Strength, [Character].Dexterity, [Character].Energy, [Character].Vitality, AccountCharacter.GameIDC, GuildMember.G_Name, [Character].pkcount, [Character].Mana, [Character].Life, Character.accountid, Character.mu_id, Memb_info.bloc_code, Memb_info.memb__pwd, memb_info.modi_days, Character.MapNumber, [memb_info].addr_info, [memb_info].addr_deta , memb_info.post_code,memb_info.mail_chek, Character.LevelUpPoint, Memb_stat.* FROM Character LEFT OUTER JOIN MEMB_STAT ON Character.AccountID COLLATE Chinese_PRC_CS_AS = MEMB_STAT.memb___id LEFT OUTER JOIN AccountCharacter ON Character.AccountID COLLATE Chinese_PRC_CI_AS = AccountCharacter.Id LEFT OUTER JOIN Memb_info ON Character.AccountID COLLATE Chinese_PRC_CI_AS = memb_info.memb___id LEFT OUTER JOIN GuildMember ON Character.Name COLLATE Chinese_PRC_CI_AS = GuildMember.Name ORDER BY [Character].Resets DESC,[Character].cLevel DESC [nativecode=S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Resets

Any thoughts?

 

[john_d]

u should try read the install guide at my site..

dont try to be a pro.. by installing on ur own.

 

[Aragus]

Yes Sir! lol

lol, It helps to do all the steps. Sry for all the mess.

Ok, when I edit the php.ini file to enable the dll's and changed the extension_dir to point to the right place. I restart IIS, then go to my site IIS give an error, that the dll could not be found.

I make the line "extension_dir = ./extensions
My php_mssql.dll and php_gd2.dll are in C:\php\extensions.

Did I miss something?

Error is "Unknown(): Unable to load dynamic library './extensions/php_gd2.dll' - The specific module could not be found."

Then get the same error for php_mssql.dll

 

[hacker_kts]

To Aragus :
extension_dir = "C:\php\extensions"