IPB + L2J

Have you created a useful tool? or Do you want to get help building one? This is the right place!
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
mobius
Posts: 11
Joined: Mon Oct 18, 2010 1:18 am

IPB + L2J

Post by mobius »

Hello, i was wondering about if its possible to use the ipb and l2j account tables as 1

I played a server where you only create a account on his ipb forum and you can access to the game
mobius
Posts: 11
Joined: Mon Oct 18, 2010 1:18 am

Re: IPB + L2J

Post by mobius »

noone know?
User avatar
DrHouse
L2j Inner Circle
L2j Inner Circle
Posts: 912
Joined: Mon Jan 22, 2007 12:14 am
Location: Spain

Re: IPB + L2J

Post by DrHouse »

Just add some lines on IPB registration script to automatically create a new l2j account on the loginserver table. I don't know if IPB uses the same auth system (encoding, data structure) but you might want to keep things separated for security (maybe for performance too) rather than read from the same table.
Image

Leadership and management are not talk and talk, but talk and do

Proud of being a part of this project
User avatar
Zealar
L2j Veteran
L2j Veteran
Posts: 1236
Joined: Sun Jul 15, 2007 10:29 am

Re: IPB + L2J

Post by Zealar »

Ofc is can also there is few ways.

1) Edit L2 server to use forum account table for auth the login.
2) Edit IPB login to use L2 account table.
3) (and maybe best way) made a script when register in one palace like forum to automatic register in server too. Ofc you will need some validation checks before that.
mobius
Posts: 11
Joined: Mon Oct 18, 2010 1:18 am

Re: IPB + L2J

Post by mobius »

i was looking the php script of registration form of ipb to add some lines, then make it to add email, username and pass to the l2 db but i cannot find it

but a better way would be try to merge both tables, to use only 1 table for l2j and ipb.. because this way i might be able to make scripts that had to take information from the characters table in l2gs db like

$blah1= "SELECT char_name from characters WHERE account_name='theloggedaccount'";

then the player can select between all his characters

and with this i would be able to make many many different scripts

like list all the online clan members
$blah2= "SELECT clanid from characters WHERE char_name='theselectedcharname'";

$blah3= "SELECT online from characters WHERE clanid='theclanoftheselectedchar'";

only a random example

or change his game password/email, or list all the items inside any of his char, or a unstuck for bugged chars, all without having to open another tab and login again, no, all this inside his member panel in the forum

or even something bigger, like the path of awakening from the off server or a web shop
User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4199
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

Re: IPB + L2J

Post by UnAfraid »

IPB has hooks u can implement that without having to touch any of their files, but create a new one.
Image
mobius
Posts: 11
Joined: Mon Oct 18, 2010 1:18 am

Re: IPB + L2J

Post by mobius »

I found the solution.
Solved, close the topic pls
User avatar
Zoey76
L2j Inner Circle
L2j Inner Circle
Posts: 7005
Joined: Tue Aug 11, 2009 3:36 am

Re: IPB + L2J

Post by Zoey76 »

mobius wrote:I found the solution.
Solved, close the topic pls
You could also share the solution with other users.
Powered by Eclipse 4.30 ๐ŸŒŒ | Eclipse Temurin 21 โ˜• | MariaDB 11.2.2 ๐Ÿ—ƒ๏ธ | L2J Server 2.6.3.0 - High Five ๐Ÿš€

๐Ÿ”— Join our Discord! ๐ŸŽฎ๐Ÿ’ฌ
mobius
Posts: 11
Joined: Mon Oct 18, 2010 1:18 am

Re: IPB + L2J

Post by mobius »

you must create a new field in the accounts table in l2jdb where you will store the ipb forum member_id
then you can create some kind of panel or any else, where members can create new accounts or manage existent accounts, all you need its to create a register form for l2j where also get the ipb member id and insert it in the field

Random Example:

Image

Image

Image

Now you just need to create a panel that shows only to logged users in the forum, and there you can create scripts to register a game account, manage existent or any else.

I cant share a full panel, because this may vary depending of your page structure (css, etc)
But i will give you a little help =)

Code: Select all

<if test="$this->memberData['member_id']">you are logged (here show the code for logged members)<else />you are not logged (here show the code for guest)</if>
i think that this info would be helpful to integrate any kind of forum or cms with l2j
User avatar
Zoey76
L2j Inner Circle
L2j Inner Circle
Posts: 7005
Joined: Tue Aug 11, 2009 3:36 am

Re: IPB + L2J

Post by Zoey76 »

Sticky, it may help someone else, thanks :wink:
Powered by Eclipse 4.30 ๐ŸŒŒ | Eclipse Temurin 21 โ˜• | MariaDB 11.2.2 ๐Ÿ—ƒ๏ธ | L2J Server 2.6.3.0 - High Five ๐Ÿš€

๐Ÿ”— Join our Discord! ๐ŸŽฎ๐Ÿ’ฌ
Hephzebah
Posts: 3
Joined: Thu Mar 19, 2015 2:26 am

Re: IPB + L2J

Post by Hephzebah »

Hello im trying to make a 'create account' section on a web page for the login server. (turned auto account create off in config) But i have a question about how to save a password to the MySql database. If i compare the password hash code from my game account and website account i see those are different from each other while the passwords are the same.
For my website im using sha1, will this bring me in trouble after creating a game account and trying to log in with that password?
I have been searching on the internet and this forum for a while now but i can't find anything really.. also im still a beginner and learning.
Thanks :)
Sacrifice
Advanced User
Advanced User
Posts: 1026
Joined: Thu Aug 14, 2014 6:31 am

Re: IPB + L2J

Post by Sacrifice »

Make a Trigger on forum database engine that make a sentence insert in l2jls tables when new account in forum is created.
User avatar
Zoey76
L2j Inner Circle
L2j Inner Circle
Posts: 7005
Joined: Tue Aug 11, 2009 3:36 am

Re: IPB + L2J

Post by Zoey76 »

Hephzebah wrote:Hello im trying to make a 'create account' section on a web page for the login server. (turned auto account create off in config) But i have a question about how to save a password to the MySql database. If i compare the password hash code from my game account and website account i see those are different from each other while the passwords are the same.
For my website im using sha1, will this bring me in trouble after creating a game account and trying to log in with that password?
I have been searching on the internet and this forum for a while now but i can't find anything really.. also im still a beginner and learning.
Thanks :)
In PHP:

Code: Select all

base64_encode(pack("H*", sha1(utf8_encode($pass))))
Powered by Eclipse 4.30 ๐ŸŒŒ | Eclipse Temurin 21 โ˜• | MariaDB 11.2.2 ๐Ÿ—ƒ๏ธ | L2J Server 2.6.3.0 - High Five ๐Ÿš€

๐Ÿ”— Join our Discord! ๐ŸŽฎ๐Ÿ’ฌ
Hephzebah
Posts: 3
Joined: Thu Mar 19, 2015 2:26 am

Re: IPB + L2J

Post by Hephzebah »

Thanks a ton! :D
User avatar
regenx
Posts: 319
Joined: Sat Jul 17, 2010 6:55 am

Re: IPB + L2J

Post by regenx »

What version of IPB ?
3 or 4? Is this compatible with IPB version 4+?
Post Reply