[SHARE/Guide]ACM For Gracia Final Database!

[dhm.msd]

Hello Guys,

Today I Will Share With You An Share/Guide On How To Make The Helios Account Manager Work With Gracia Final Database!

 

PS: I Am Posting This Cuz I Diden't Find Any L2j account manager that is workin on Gracia Final Database! If I Am Wrong, my apologies...

 

So Here We Go...

 

- First We Will Need To Download The Helios Account Manager!

    http://rs901l33.rapidshare.com/files/388672295/act_manager.tar.gz.html

 

- And Now, Let's Go And Config Our Acm With Our Database Info.

  1) We Extract The .rar That We Downloaded 2 Min Ago.

  2) We Go To The Folder That Was Just Extracted, And We Open config.php

  3) We Change Our Database Info. (See Photo 1.)

- When We Done With The Config File, We Go To Folder acm->classes

  1) Here We Will Have To Edit An PHP Script.If You Don't Know PHP You Can Just Follow The Photo! (See Photo 2)

  2) We Open The File Called account.class.php

  3) Now, Search And Find That Line

$sql = "INSERT INTO`accounts`(`login`,`password`,`lastactive`,`accessLevel`,`lastIP`,`email`) VALUES

  4) And Here Is Our Problem, But W8 What Does That Code Mean? Well In Simple Words That Code Get Everything that you typed on Login, Password And Mail Form And It Goes To Database And Put That Data On The accounts Table. But Everything looks Good Right? Well No... Cuz Table Design Use Only The C6 Database's. So We Will Have To Edit It.

- Minimaze The notepad, And Open Navicat, Go To Your Database And Right Click On Table accounts And Design Table. When You Do This, Will Open A New Window With The Design Of The Table accounts.

- Now Find Where It Says "access_level" AND NO "accessLevel" Like The Script Was Tring To Connect! And Here, We Just Founded The Error, Let's Fix It!

- Go Again To Notepad And Change Every Where That it says 'accessLevel' and put 'access_level'. Then Save And Exit.

- And Like This We Fixed The Script. Now All You Have To Do Is To Test It And See!! ;)

 

~~Photos~~

1)

 

2)

http://img442.imageshack.us/img442/4321/guide2.jpg[/img]

 

That's All!

I Hope That I Helped You Guys!!

 

Credits: To Me For The Guide And The Fix And To ... For The Helios ACM

 

PS: If Anyone Can Remember Me Who Did Create The Helios ACM To Put The Credits :D

[Papaditsa]

Ty for that guide i believe this is best :) You deserve the karma!!! :)

[Grim.]

i've didnt see such a guide around here, so good work man

[dhm.msd]

i've didnt see such a guide around here, so good work man

Yeah, That's Why I Posted It...

Any Karma ?? :P

[RainWalker]

well done dude well done.

[Rin4a]

Why are you bumping this thread every day? It's already on the first page. But thanks for the share.

[pankostrelos]

kai meta afto pws to pernaw sto site?

[`Willowy^]

Nice Share +1 Karma for you work!

[dhm.msd]

kai meta afto pws to pernaw sto site?

Kanis Upload Ta Arxia me kapio FTP Client.

Nice Share +1 Karma for you work!

Ty m8! :)

[Xennon]

Hm.....so far it works great,but for me the aktivation e-mail won't be send to set the char on access_level 0

Don't change anything so how could i setup the activation e-mail ?

[makano]

how can i make this for epilogue?

[Xennon]

how can i make this for epilogue?

It's working on Epilogue !

[LordOfDarkness]

Thats the only guide in MxC!!!!

 

Thanks a lot!

 

+1 for sticky topic!

 

Regards

[ArkeyWave]

$sql = "INSERT INTO`accounts`(`login`,`password`,`lastactive`,`accessLevel`,`lastIP`,`email`) VALUES

that's in your guide, but in my navicat the parameters i see are

'login','password','lastactive','lastIP','lastServe'r,'userIP','pcIp','hop1','hop2','hop3','hop4','email','created_time'

 

so . . . will there be a problem ¿? =S . . . .

i hope you can help me cauze i left that as you gave us and when i click in my site the link to the ACM, it shows the next text

 

connect(); //------------------------------------------------------------------ // Display //------------------------------------------------------------------ $template = new Smarty2; $template->assign('vm_title', $vm['_title']); $template->assign('vm_title_page', $vm['_title_page']); $core = new CORE(); if(method_exists($core, $action)) $core->$action(); else $core->index(); $MYSQL_LS->close(); ?>

[BartzSale]

when i uploaded files to site as they were in the folder and i typr site /acm i get this error