Support for Account Manager

[laguna]

news, the modification at the class works

@mysql_close (NULL);

but I get this thing....

Code: Select all

	private function verif_email($email) { 		if (!ereg("^[^@ ]+@[^@ ]+\.[^@ \.]+$", $email))			return false; 		return true;	}

any ideas?

[janiii]

a little bit of googling maybe? "php ereg deprecated"

http://devthought.com/tumble/2009/06/fi ... in-php-53/

[laguna]

sry janii, sometimes I miss the obvious....

thks a lot guys, I think I made it work properly now.

[daedalus]

Deprecated function and mysql closing has been updated on the new version. Sorry for non responding.

[melady]

Thank daedalus
Im using your manager and i wanna thank you for this excellent and fully completed/protected script.

You'r only need some custom themes and it will be an amazing manager.

[MoleS]

Parse error: syntax error, unexpected T_OBJECT_OPERATOR in C:\AppServ\www\acm\install.php on line 24??? why occurs that?

[denser]

Parse error: syntax error, unexpected T_OBJECT_OPERATOR in C:\AppServ\www\acm\install.php on line 24??? why occurs that?

quote here what in 24 line of this file, it helps alot. or try to debug it yourself

[disorder35]

My account manager was working fine, then I updated it and after I changed the server from bartz to phoenix I can get it to work now. I changed the server id on the config.php but it still give me the error.a

Code: Select all

Database problem : Account was not created. Please report this to the Staff.

What can it be?

[cerasela]

Nice Thx

[babyjason]

everything is fine, i downloaded newest version but there s a big problem

all the accounts created have acces level -1.

where can i set that?! and why is the default -1, that s ban

these are my settings (my login/gameserver settings iwont post, sicne the script creates accounts, just gives them acces -1 instead of 0. dont know why , please help

Code: Select all

CONFIG::g()->cs('core_server_name', xxxx');							// server name CONFIG::g()->cs('core_iso_type', 'utf-8');										// set the charset type CONFIG::g()->cb('core_act_img', true);											// Activate image verification ; set false if you want deactivate CONFIG::g()->ci('core_spam_try', 3);											// We allow to the user 3 times unsuccessfull login after that system block him IP.CONFIG::g()->ci('core_spam_time', 30);											// Need to wait 30 minutes after been blocked by anti spam system CONFIG::g()->cb('core_act_email', false);										// Activate email verification ; set false if you want deactivateCONFIG::g()->cb('core_same_email', false);										// Allow to have same email with different account ; set false if you want deactivateCONFIG::g()->cb('core_can_chg_email', false);									// User can change email ; set false if you want prohibit CONFIG::g()->cbi('core_acc_limit', false);										// How many account can be registered ; set false for unlimited CONFIG::g()->cs('core_language', 'english');									// language use by the Account Manager ; name of language file in language folder CONFIG::g()->cb('core_ack_cond', false);										// User must accept before register ; conditions can be edited on the language file CONFIG::g()->cs('core_template', 'gracia');										// template directory CONFIG::g()->cb('core_interlude', false);										// If you are using interlude database set to true //##########################################################################################//################################### Characters Config ####################################//########################################################################################## CONFIG::g()->cb('service_allow', false);										// Enable Account ServicesCONFIG::g()->cb('service_allow_with_karma', false);								// Enable Account Services for player who have karma CONFIG::g()->cs('service_server_name', './servername.xml');						// ServerName list (refer to the l2j xml list on datapack) CONFIG::g()->cb('service_name', false);											// Enable Account services feature (change name)CONFIG::g()->cs('service_name_regex', '`^[[:alnum:]]{3,16}$`');					// allow alphanumeric character in char name (3-16 char.) CONFIG::g()->cb('service_sex', false);											// Enable Account services feature (change gender)CONFIG::g()->ci('service_sex_time', 7);											// Need to wait 7 days after change gender before to change another timeCONFIG::g()->ca('service_sex_item_female', array(8559,8913,8917));				// Check female-use only items before to change genderCONFIG::g()->ca('service_sex_item_male', array(8923));							// Check male-use only items before to change gender CONFIG::g()->cb('service_fix', false);											// Enable fixing feature for offline characterCONFIG::g()->ci('service_fix_time', 24);										// Need to wait 24 hours before to use fix or unstuck against CONFIG::g()->cb('service_unstuck', false);										// Enable unstuck feature for offline characterCONFIG::g()->cb('service_unstuck_static', false);								// Use static coords when using unstuck and fix featureCONFIG::g()->ca('service_unstuck_default', array(0,0,0));						// When coord static enable tp player to the coords (x,y,z) //##########################################################################################//######################################### Email ##########################################//########################################################################################## CONFIG::g()->ce('email_from', 'support@host.com');								// Specify an adress email source CONFIG::g()->cb('email_smtp_use', false);										// Set to true if you want use an smtp serverCONFIG::g()->cs('email_smtp_address', 'smtp.server.com');						// Address of the smtp serverCONFIG::g()->ci('email_smtp_port', 25);											// Port of the smtp serverCONFIG::g()->cs('email_smtp_login', '');										// login of the smtp server if you need authenticationCONFIG::g()->cs('email_smtp_password', '');										// password of the smtp server if you need authenticationCONFIG::g()->cs('email_smtp_domain', '');										// domain of your host //##########################################################################################//####################################### End Config #######################################//###################################################################################

also the script check up says is all ok every feeld

[babyjason]

i think i found the line with the -1 but dont understand why is default -1 at new accounts created?

is some problem?! should i just change -1 to 0? i m just curious why is the default value -1 (ban) on new accounts?

Code: Select all

		$sql = sprintf("INSERT INTO `accounts` (`login`,`password`,`lastactive`,`".CONFIG::g()->accessLevel()."`,`lastIP`,`email`) VALUES ('%s', '%s', '%s', '-1', '%s', '%s');",				MYSQL::g()->escape_string($login),				$this->l2j_encrypt($pwd),				time(),				$_SERVER['REMOTE_ADDR'],				MYSQL::g()->escape_string($email)			);

[babyjason]

i put the value 0 there, and now acc are crated with acceslevel 0. IS IT SAFE?!

also, it seams that change password function is not working, allthough it says it changed the pass, in fact it didnt. i Give select, insert & update Rights to Accounts table only! worked for old acc manager

i used old account manager (from u), i have acces on accounts table to only UPDATE passwords, and for old account manager works, it changes pass, here it doesent, can u help me?

[denser]

access level -1 for not confermed accs.
just turn off email verification and relax
acm works fine

[babyjason]

acm is great, i m a mess, i spent like 4 hours browsing through configs/php my admin, etc ...

as you can see in my settings i turned off email verification , i m sry but i m very preocupied by safety of users so it s ok that i manually changed -1 to 0 , right?:)

Code: Select all

CONFIG::g()->cb('core_act_email', false);										// Activate email verification ; set false if you want deactivateCONFIG::g()->cb('core_same_email', false);										// Allow to have same email with different account ; set false if you want deactivateCONFIG::g()->cb('core_can_chg_email', false);									// User can change email ; set false if you want prohibit CONFIG::g()->cbi('core_acc_limit', false);										// How many account can be registered ; set false for unlimited 

so, i solved the change pass issue by adding the right to UPDAte to data tables, is it safe like this?


i tried to use database specific priviledges only for accounts tables, but allthou i highlighted at update 'passwords" still the change password wasnt working

is it safe like this?

(if i selected

[daedalus]

About -1 acm it's for block account until email validation has been check.

if you set false like this : CONFIG::g()->cb('core_act_email', false); It will put 0 on accessLevel and allow login on the account.

It's safe but if you want revert your configuration to email verification it will be useless with your changes.

Here my acm db user configuration :

Becarefull I've two db one for loginserver ("l2jdb_login") and one for gameserver ("l2jdb_game"). It's doesn't work with character services enabled. Need to add privilege on l2jdb_game

CREATE USER 'acm'@'localhost' IDENTIFIED BY '***************************************';

REVOKE ALL PRIVILEGES ON `l2jdb_login`.`accounts` FROM 'acm'@'localhost';

GRANT SELECT ,
INSERT( `login` , `password` , `lastactive` , `accessLevel` , `lastIP` , `email` ) ,
UPDATE (`password` , `lastactive` , `accessLevel` , `lastIP` , `email` )
ON `l2jdb_login`.`accounts` TO 'acm'@'localhost';


GRANT SELECT , INSERT , UPDATE , DELETE ON `l2jdb_login`.`account_data` TO 'acm'@'localhost';