In Game Registration

[Jayz]

Hello im requesting in game registration account

Username = Minimum 4 Letter and Check if username is exist

Password = Minimul 4 Letter

Email = 1 Email Per Account = Your email is exist

Male or Female = check if M or F

Security Code = like 05912

Thanks

[Mystery]

Hello im requesting in game registration account

Username = Minimum 4 Letter and Check if username is exist

Password = Minimul 4 Letter

Email = 1 Email Per Account = Your email is exist

Male or Female = check if M or F

Security Code = like 05912

Thanks

Even though this is a Script Request... I gotta confirm. Are you talking about a SCRIPT or through your CLIENT? You would have to hex the client and even modify your source files... especially for the security code. This way -is- possible through a NPC script but it's not what you really want right?

Your best bet if you want all these features, use a Control Panel.

This part:

Username = Minimum 4 Letter and Check if username is exist (automatically does this by default)

Password = Minimum 4 Letter

is already there for you:

//If new_account is enabled, minimum length to userid and passwords should be 4?
//Must be 'Yes' unless your client uses both 'Disable 4 LetterUserID/Password' Diffs
new_acc_length_limit: yes

[Jayz]

i want scirpt.. yup i know best is control panel but i want implimented in Game Registration

[Brian]

So to access this NPC in-game, they would have to login first right?

How would players create the first account to login with?

[AnnieRuru]

probably a GM can create/manipulate account in-game ...

completely possible by hijacking SQL

but feel very lazy to write this kind of things ... need to read a lot in the source

[GmOcean]

Well, in all likely hood, that it is created, i'm still gonna agree with Brian on this one... What real advantage does this have? Because, if your trying to limit the amount of accounts people used based off of their email address, well then I'm sorry, because unless you close account registration on your server, people will just bypass this completely.

Edited November 24, 2012 by GmOcean

[Jayz]

ok..we dont have advatages of this.. i want requesting of this. example you have account ingame using registration on cp.. sometime my player have slow connection so cant create new account in my control panel and i have rwc script style per account once your account join in rwc you cant use your account thats why im asking to make a account in game to join in RWC

[KoolKat29]

You have two servers, is that correct? one is your official and the other one is a temporary server to be used for RWC?

Suggestion:

Just create a new map (Or any available RWC maps) within your main server, not an alt server.

Put Item Restriction inside the map. (or other restriction like they cant warp back from that map to get items outside, not unless they have been warped by GMs)

Or only novice can enter and modify their skills and stats inside the map.

Edited November 25, 2012 by cataclysmro

[Brian]

Here you go: account_registration.txt

[Jayz]

Here you go:

uhmm this is possible to add database setting?

Example

Database = ragnarok1 // This is Database where you want to register

[Euphy]

You can't execute SQL queries on a database the server isn't connected to. o_o (edit: I guess not xD)

[Toshiro]

You can't execute SQL queries on a database the server isn't connected to. o_o

Wrong. You can use any database as long as the sql user the server logins with has proper permissions.

[Brian]

uhmm this is possible to add database setting?

Example

Database = ragnarok1 // This is Database where you want to register

I didn't add database configs because query_sql uses the current (same) SQL connection as the map-server.

As Toshiro said, you can execute SQL queries on any database on the same MySQL Server instance as long as the rAthena SQL user has privileges on that database.

Just add the database name in front of the table name: ragnarok1.login

[Jayz]

uhmm like this

ragnarok1.login.query_sql("SELECT account_id FROM login WHERE userid='"+escape_sql(.@userid$)+"'", .@account_id) > 0)

[Toshiro]

uhmm like this

ragnarok1.login.query_sql("SELECT account_id FROM login WHERE userid='"+escape_sql(.@userid$)+"'", .@account_id) > 0)

query_sql("SELECT account_id FROM ragnarok1.login WHERE userid='"+escape_sql(.@userid$)+"'", .@account_id) > 0)

[Jayz]

oh ok thanks ill try