Jump to content

[SHARE/Guide]ACM For Gracia Final Database!


Recommended Posts

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)

guide1n.jpg

 

2)

width=960 height=768http://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

Link to comment
Share on other sites

  • 1 month later...
  • 2 weeks later...
  • 3 weeks later...
$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(); ?>
Link to comment
Share on other sites

  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • Well, sorry not sorry for resurrecting old topic, but I believe it's ultimately stupid to implement license checks like Vilmis did 🙂   private static String url = "jdbc:mysql://185.80.128.233/" + getData("Zm9ydW1fZGI="); private static String username = getData("bXJjb3B5cmlnaHQ="); private static String password = getData("Y29weXJpZ2h0XzEyMw=="); con = GlobalDB.getInstance().getConnection(); PreparedStatement statement; statement = con.prepareStatement("SELECT field_6 from core_pfields_content WHERE member_id = ?"); statement.setInt(1, Config.FORUM_USER_ID); ResultSet rset = statement.executeQuery();   This awesome way of coding things leaves us with base64-encoded credentials and DB exposed and accessible globally 😉 Btw he checks his licensing data from some plugin generated table his forum uses. Vilmis took action and ensured that mrcopyright user would have only needed accesses and rights for this operation. But he forgot to ensure that his INFORMATION_SCHEMA database would not be exposed and readable... That leads us to fully readable server variables like version used (10.1.26-MariaDB-0+deb9u1 - pretty ancient DB and OS, I'd assume). From here you can go south and do some kinky stuff, if you want and have knowledge for that. But who cares, right?   Ooh, table core_pfields_content field_6 is IP address which is checked by FORUM_USER_ID. Yep, you can query all IP addresses there (124 of them right now) and also do whatever you want with them! 🙂  The most fun part? Files source has been shared what, more than 2 years ago?  Vilmis still uses very same credentials and never changed it after sources exposure - who cares. Although, "sources" may be way too strong word here. If anyone still use paid Orion versions, I'd suggest packing your shit and leaving immediately, or at least fix this incompetent fool caused problems. It's obvious Vilmis don't care or maybe doesn't even know from the first place how to solve this problem (hint hint - tiny PHP Rest API microservice which would do absolutely the same but without exposing sensitive data?). By doing that, he exposes his infrastructure and YOUR data, and he does that for more than 2 years now 🙂 Developer of century!    
    • rename the l2.bin into l2.exe
    • L2LIVE.PRO- Dynamic Mid-rates Essence Seven Signs GRAND OPENING - July 5, 20:00 GMT+3 (EEST) TEST SERVER IS OPEN - COME AND CHECK IT OUT TODAY! Join our community and be part of it at: https://www.l2live.pro https://discord.gg/k3NMgR4Dmu   Server description * EXP/SP: Dynamic (x1- x100 based on your level, *before* Sayha and EXP buffs * Adena: x50 / Item Drop: x10 / Fishing EXP increased / Attribute EXP increased * Simplified gameplay to stay in the loop while not spending hours and hours farming * Starter Pack containing very useful items for beginners * MP replenishing potions with auto-consumption * No overpowered donations L2LIVE shop * All spellbook coupons, pet spellbook coupons and master books are sold via Game Assistant * Additionally you can buy SP pouches, enchanted talismans, pet training guides and various other consumables for Adena and L-Coin * More items such as cloaks, more talismans, agathions, belts, pendants, enchantment scrolls of various grades, evolution stones, etc will be added! Shop server as a shortcut, and all retail-like ways of earning items are still here! L-Coins * Drops with small change and in random amounts from Lv60+ monsters  * All raidbosses drop random amount of L-Coin Pouches generating up to 420 Lcoin per unit. **Grand Olympiad and Events** * Grand Olympiad is held week day * Format is 1v1, unlimited weekly fights  * Heroes are declared weekly at Sunday * There are three automated events - TvT, CTF and Deathmatch, running at evenings * Orc Fortress, Battle with Balok, Keber Hunter, Archievements Box, Daily Gift Calendar provisional events are active too Custom user commands * .offlineplay command, your character will keep playing till death or server restart * .offlineshop command, keeps your shop sitting until all items are purchased * .apon / .apoff - enable/disable HP/MP autoconsume And lots of other small improvements are waiting for you!   Join our community and be part of it at: https://www.l2live.pro https://discord.gg/k3NMgR4Dmu
  • Topics

×
×
  • Create New...