Account manager problem...

Optus · Sep 4, 2011

Hey guys, im using crying damson 0.3.6pl and i got this error, using SHA-1 encryption.

Account manager works 1/1; but when they login their personal account (eg. optus/omg) and try get into Account Manager it says invalid password.

Dont tell me make sure Mysql is right in config because it is and everything is correct but for some reason this is happening.

I use Mysql.

luigilc · Sep 4, 2011

shouldn't you create character on the website then?

Optus · Sep 4, 2011

I need it to work for ingame account manager not website.

Cronox · Sep 4, 2011

you have
in your config.lua

Lua:

passwordType = "plain"

change for

Lua:

passwordType = "sha1"

Not works?
use this querys

SQL:

UPDATE accounts SET password=SHA1(password);

or

SQL:

UPDATE accounts SET password = sha1('sometext') WHERE name = 'accountname' LIMIT 1

and last option is
change your config-and-functions.php
for this

PHP:

<?PHP
// ###################### CONFIG ########################
//load page config file
$config['site'] = parse_ini_file('config/config.ini');
include('config/config.php');
//check install
if($config['site']['install'] != "no")
{
	header("Location: install/install.php");
	exit;
}
//load server config
$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
if(isset($config['server']['sqlHost']))
{
	// ots config.lua file connect database
	$mysqlhost = $config['server']['sqlHost'];
	$mysqluser = $config['server']['sqlUser'];
	$mysqlpass = $config['server']['sqlPass'];
	$mysqldatabase = $config['server']['sqlDatabase'];
}
$sqlitefile = $config['server']['sqliteDatabase'];
	$encryptionType = '';
if(strtolower($config['server']['encryptionType']) == 'md5')
	$encryptionType = 'md5';
if(strtolower($config['server']['encryptionType']) == 'sha1')
	$encryptionType = 'sha1';
// loads #####POT mainfile#####
include('pot/OTS.php');
// PDO and POT connects to database
$ots = POT::getInstance();
if(strtolower($config['server']['sqlType']) == "mysql")
{
	//connect to MySQL database
	try
	{
		$ots->connect(POT::DB_MYSQL, array('host' => $mysqlhost, 'user' => $mysqluser, 'password' => $mysqlpass, 'database' => $mysqldatabase) );
	}
	catch(PDOException $error)
	{
	    echo 'Database error - can\'t connect to MySQL database. Possible reasons:<br>1. MySQL server is not running on host.<br>2. MySQL user, password, database or host isn\'t configured in: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. MySQL user, password, database or host is wrong.';
		exit;
	}
}
elseif(strtolower($config['server']['sqlType']) == "sqlite")
{
	//connect to SQLite database
	$link_to_sqlitedatabase = $config['site']['server_path'].$sqlitefile;
	try
	{
		$ots->connect(POT::DB_SQLITE, array('database' => $link_to_sqlitedatabase));
	}
	catch(PDOException $error)
	{
	    echo 'Database error - can\'t open SQLite database. Possible reasons:<br><b>'.$link_to_sqlitedatabase.'</b> - file isn\'t valid SQLite database.<br><b>'.$link_to_sqlitedatabase.'</b> - doesn\'t exist.<br><font color="red">Wrong PHP configuration. Default PHP does not work with SQLite databases!</font>';
		exit;
	}
}
else
{
	echo 'Database error. Unknown database type in <b>'.$config['site']['server_path'].'config.lua</b> . Must be equal to: "<b>mysql</b>" or "<b>sqlite</b>". Now is: "<b>'.strtolower($config['server']['sqlType']).'"</b>';
	exit;
}

$SQL = POT::getInstance()->getDBHandle();
$layout_name = "layouts/".$layout_name = $config['site']['layout'];;
$layout_ini = parse_ini_file($layout_name.'/layout_config.ini');
foreach($layout_ini as $key => $value)
	$config['site'][$key] = $value;
//###################### FUNCTIONS ######################
header('Cache-control: private'); // IE 6 FIX
if(isSet($_GET['lang']))
{
	$lang = $_GET['lang'];
	$_SESSION['lang'] = $lang;
	setcookie('lang', $lang, time() + (3600 * 24 * 30));
}
else if(isSet($_SESSION['lang']))
{
	$lang = $_SESSION['lang'];
}
else if(isSet($_COOKIE['lang']))
{
	$lang = $_COOKIE['lang'];
}
else
{
	$lang = 'en';
}
// force / potegi
function force($podstawa, $wykladnik)
{
    $wynik = $podstawa;
    $i = 1;
    while ($i++ < $wykladnik)
        $wynik *= $podstawa;
    return $wynik;
}
//save config in ini file
function saveconfig_ini($config)
{
	$file = fopen("config/config.ini", "w");
	foreach($config as $param => $data)
	{
$file_data .= $param.' = "'.str_replace('"', '', $data).'"
';
	}
	rewind($file);
	fwrite($file, $file_data);
	fclose($file);
}
//return password to db
function password_ency($password) {
	$ency = $GLOBALS['encryptionType'];
	if($ency == 'sha1')
		return sha1($password);
	elseif($ency == 'md5')
		return md5($password);
	elseif($ency == '')
		return $password;
}
//delete player with name
function delete_player($name) {
	$SQL = $GLOBALS['SQL'];
	$player = new OTS_Player();
	$player->find($name);
	if($player->isLoaded()) {
		try { $SQL->query("DELETE FROM player_skills WHERE player_id = '".$player->getId()."';"); } catch(PDOException $error) {}
		try { $SQL->query("DELETE FROM guild_invites WHERE player_id = '".$player->getId()."';"); } catch(PDOException $error) {}
		try { $SQL->query("DELETE FROM player_items WHERE player_id = '".$player->getId()."';"); } catch(PDOException $error) {}
		try { $SQL->query("DELETE FROM player_depotitems WHERE player_id = '".$player->getId()."';"); } catch(PDOException $error) {}
		try { $SQL->query("DELETE FROM player_spells WHERE player_id = '".$player->getId()."';"); } catch(PDOException $error) {}
		try { $SQL->query("DELETE FROM player_storage WHERE player_id = '".$player->getId()."';"); } catch(PDOException $error) {}
		try { $SQL->query("DELETE FROM player_viplist WHERE player_id = '".$player->getId()."';"); } catch(PDOException $error) {}
		try { $SQL->query("DELETE FROM player_deaths WHERE player_id = '".$player->getId()."';"); } catch(PDOException $error) {}
		try { $SQL->query("DELETE FROM player_deaths WHERE killed_by = '".str_replace("'", "\'", $player->getName())."';"); } catch(PDOException $error) {}
		$rank = $player->getRank();
		if(!empty($rank)) {
			$guild = $rank->getGuild();
			if($guild->getOwner()->getId() == $player->getId()) {
				$rank_list = $guild->getGuildRanksList();
				if(count($rank_list) > 0) {
					$rank_list->orderBy('level');
					foreach($rank_list as $rank_in_guild) {
						$players_with_rank = $rank_in_guild->getPlayersList();
						$players_with_rank->orderBy('name');
						$players_with_rank_number = count($players_with_rank);
						if($players_with_rank_number > 0) {
							foreach($players_with_rank as $player_in_guild) {
								$player_in_guild->setRank();
								$player_in_guild->save();
							}
						}
						$rank_in_guild->delete();
					}
					$guild->delete();
				}
			}
		}
		$player->delete();
		return TRUE;
	}
}
//delete guild with id
function delete_guild($id) {
	$guild = new OTS_Guild();
	$guild->load($id);
	if($guild->isLoaded()) {
		$rank_list = $guild->getGuildRanksList();
		if(count($rank_list) > 0) {
			$rank_list->orderBy('level');
			foreach($rank_list as $rank_in_guild) {
				$players_with_rank = $rank_in_guild->getPlayersList();
				if(count($players_with_rank) > 0) {
					foreach($players_with_rank as $player_in_guild) {
						$player_in_guild->setRank();
						$player_in_guild->save();
					}
				}
				$rank_in_guild->delete();
			}
		}
		$guild->delete();
		return TRUE;
	}
	else
		return FALSE;
}
//is it valid nick?
function check_name($name)//sprawdza name
{
	$temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM- [ ] '");
	if ($temp != strlen($name))
		return false;
	else
	{
		$ok = "/[a-zA-Z ']{1,25}/";
		return (preg_match($ok, $name))? true: false;
	}
}
// is it valid account name
function check_account_name($name)
{
	$temp = strspn("$name", "QWERTYUIOPASDFGHJKLZXCVBNM0123456789");
	if ($temp != strlen($name))
		return false;
	if(strlen($name) > 32)
		return false;
	else
	{
		$ok = "/[A-Z0-9]/";
		return (preg_match($ok, $name))? true: false;
	}
}
//is it valid nick for new char?
function check_name_new_char($name)//sprawdza name
{
	$name_to_check = strtolower($name);
	//first word can't be:
	//names blocked:
	$names_blocked = array('gm', 'cm', 'god', 'tutor');
	$first_words_blocked = array('gm ', 'cm ', 'god ','tutor ', "'", '-' );
	//name can't contain:
	$words_blocked = array('gamemaster', 'game master', 'game-master', "game'master", '--', "''","' ", " '", '- ', ' -', "-'", "'-", 'fuck', 'sux', 'suck', 'noob', 'tutor', 'cronox', 'warlock', 'hydra', 'dragon lord', 'medusa', 'draken spellweaver', 'dragon', '');
	foreach($first_words_blocked as $word)
		if($word == substr($name_to_check, 0, strlen($word)))
			return false;
	if(substr($name_to_check, -1) == "'" || substr($name_to_check, -1) == "-")
		return false;
	if(substr($name_to_check, 1, 1) == ' ')
		return false;
	if(substr($name_to_check, -2, 1) == " ")
		return false;
	foreach($names_blocked as $word)
		if($word == $name)
			return false;
	for($i = 0; $i < strlen($name_to_check); $i++)
		if($name_to_check[$i-1] == ' ' && $name_to_check[$i+1] == ' ')
			return false;
	foreach($words_blocked as $word)
		if (!(strpos($name_to_check, $word) === false))
			return false;
	for($i = 0; $i < strlen($name_to_check); $i++)
		if($name_to_check[$i] == $name_to_check[($i+1)] && $name_to_check[$i] == $name_to_check[($i+2)])
			return false;
	for($i = 0; $i < strlen($name_to_check); $i++)
		if($name_to_check[$i-1] == ' ' && $name_to_check[$i+1] == ' ')
			return false;
	$temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM- ");
	if ($temp != strlen($name))
		return false;
	else
	{
		$ok = "/[a-zA-Z ']{1,25}/";
		return (preg_match($ok, $name))? true: false;
	}
}
// is rank name valid?
function check_rank_name($name)
{
  $temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM0123456789-[ ] ");
	if ($temp != strlen($name))
	{
		return false;
	}
	else
	{
		$ok = "/[a-zA-Z ]{1,60}/";
		return (preg_match($ok, $name))? true: false;
	}
}
// is guild name valid?
function check_guild_name($name)
{
	$temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM0123456789- ");
	if ($temp != strlen($name))
	{
		return false;
	}
	else
	{
		$ok = "/[a-zA-Z ]{1,60}/";
		return (preg_match($ok, $name))? true: false;
	}
}
// is it valid password?
function check_password($pass)
{
	$temp = strspn("$pass", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890");
	if ($temp != strlen($pass))
	{
		return false;
	}
	else
	{
		$ok = "/[a-zA-Z0-9]{1,40}/";
		return (preg_match($ok, $pass))? true: false;
	}
}
// is it valid e-mail?
function check_mail($email)
{
	$ok = "/[a-zA-Z0-9._-]+@[a-zA-Z0-9-]+\.[a-zA-Z]{2,4}/";
	return (preg_match($ok, $email))? true: false;
}
// check if is acoount have premium time
function isPremium($premdays, $lastday)
{
	return ($premdays - (date("z", time()) + (365 * (date("Y", time()) - date("Y", $lastday))) - date("z", $lastday)) > 0);
}
// get name bans
function getReason($reasonId)
{
	switch($reasonId)
	{
		case 0:
		return "Offensive Name";
		case 1:
		return "Invalid Name Format";
		case 2:
		return "Unsuitable Name";
		case 3:
		return "Name Inciting Rule Violation";
		case 4:
		return "Offensive Statement";
		case 5:
		return "Spamming";
		case 6:
		return "Illegal Advertising";
		case 7:
		return "Off-Topic Public Statement";
		case 8:
		return "Non-English Public Statement";
		case 9:
		return "Inciting Rule Violation";
		case 10:
		return "Bug Abuse";
		case 11:
		return "Game Weakness Abuse";
		case 12:
		return "Using Unofficial Software to Play";
		case 13:
		return "Hacking";
		case 14:
		return "Multi-Clienting";
		case 15:
		return "Account Trading or Sharing";
		case 16:
		return "Threatening Gamemaster";
		case 17:
		return "Pretending to Have Influence on Rule Enforcement";
		case 18:
		return "False Report to Gamemaster";
		case 19:
		return "Destructive Behaviour";
		case 20:
		return "Excessive Unjustified Player Killing";
		case 21:
		return "Invalid Payment";
		case 22:
		return "Spoiling Auction";
		default:
		break;
	}
	return "Unknown Reason";
}
//################### DISPLAY FUNCTIONS #####################
//return shorter text (news ticker)
function short_text($text, $chars_limit)
{
	if (strlen($text) > $chars_limit)
		return substr($text, 0, strrpos(substr($text, 0, $chars_limit), " ")).'...';
	else
		return $text;
}
//return text to news msg
function news_place()
{
	return $news;
}
// set monster of week
function logo_monster()
{
	return str_replace(" ", "", trim(mb_strtolower($GLOBALS['config']['site']['logo_monster'])));
}

$statustimeout = 1;
foreach(explode("*", str_replace(" ", "", $config['server']['statusTimeout'])) as $status_var)
	if($status_var > 0)
		$statustimeout = $statustimeout * $status_var;

$statustimeout = $statustimeout / 1000;
$config['status'] = parse_ini_file('cache/serverstatus');
if($config['status']['serverStatus_lastCheck']+$statustimeout < time())
{
	$config['status']['serverStatus_checkInterval'] = $statustimeout+3;
	$config['status']['serverStatus_lastCheck'] = time();
	$info = chr(6).chr(0).chr(255).chr(255).'info';
	$sock = @fsockopen("127.0.0.1", $config['server']['statusPort'], $errno, $errstr, 1);
	if ($sock)
	{
		fwrite($sock, $info);
		$data='';
		while (!feof($sock))
			$data .= fgets($sock, 1024);
		fclose($sock);
		preg_match('/players online="(\d+)" max="(\d+)"/', $data, $matches);
		$config['status']['serverStatus_online'] = 1;
		$config['status']['serverStatus_players'] = $matches[1];
		$config['status']['serverStatus_playersMax'] = $matches[2];
		preg_match('/uptime="(\d+)"/', $data, $matches);
		$h = floor($matches[1] / 3600);
		$m = floor(($matches[1] - $h*3600) / 60);
		$config['status']['serverStatus_uptime'] = $h.'h '.$m.'m';
		preg_match('/monsters total="(\d+)"/', $data, $matches);
		$config['status']['serverStatus_monsters'] = $matches[1];
		preg_match('/npcs total="(\d+)"/', $data, $matches);
		$config['status']['serverStatus_npcs'] = $matches[1];
	}
	else
	{
		$config['status']['serverStatus_online'] = 0;
		$config['status']['serverStatus_players'] = 0;
		$config['status']['serverStatus_playersMax'] = 0;
		$config['status']['serverStatus_monsters'] = 0;
		$config['status']['serverStatus_uptime'] = 0;
		$config['status']['serverStatus_npcs'] = 0;
	}
	$file = fopen("cache/serverstatus", "w");
	foreach($config['status'] as $param => $data)
	{
$file_data .= $param.' = "'.str_replace('"', '', $data).'"
';
	}
	rewind($file);
	fwrite($file, $file_data);
	fclose($file);
}
//PAGE VIEWS COUNTER :)
$views_counter = "cache/usercounter.dat";
// checking if the file exists
if (file_exists($views_counter))
{
    // het bestand bestaat, waarde + 1
    $actie = fopen($views_counter, "r+");
    $page_views = fgets($actie, 9);
    $page_views++;
    rewind($actie);
    fputs($actie, $page_views, 9);
    fclose($actie);
}
else
{
    // the file doesn't exist, creating a new one with value 1
    $actie = fopen($views_counter, "w");
    $page_views = 1;
    fputs($actie, $page_views, 9);
    fclose($actie);
}
function makeOrder($arr, $order, $default) {
    // Function by Colandus!
    $type = 'asc';
    if(isset($_GET['order']))
	{
        $v = explode('_', strrev($_GET['order']), 2);
        if(count($v) == 2)
            if($orderBy = $arr[strrev($v[1])])
                $default = $orderBy;
                $type = (strrev($v[0]) == 'asc' ? 'desc' : 'asc');
    }
    return 'ORDER BY ' . $default . ' ' . $type;
}
function getOrder($arr, $order, $this) {
    // Function by Colandus!
    $type = 'asc';
    if($orderBy = $arr[$this])
        if(isset($_GET[$order])) {
            $v = explode('_', strrev($_GET[$order]), 2);
            if(strrev($v[1]) == $this)
                $type = (strrev($v[0]) == 'asc' ? 'desc' : 'asc');
        }
    return $this . '_' . $type;
}
// class EQShower
class EQShower
{
    function item_info($val,$attributes)
    {
        $EQShower=new EQShower;
        $cl=$EQShower->item_grade($attributes);

        empty($val[1])?$desc_str="":$desc_str="<br /><br />".$val[1];
        empty($val[2])?$arm_str="":$arm_str="Armor: ".$val[2]."<br />";
        empty($val[4])?$size_str="":$size_str="Size: ".$val[4]." slots";
        empty($val[5])?$att_str="":$att_str="Attack: ".$val[5]."<br />";
        empty($val[6])?$sp_str="":$sp_str="Speed: + ".$val[6]."<br />";
        empty($val[13])?$def_a="":$def_a="+ ".$val[13];
        empty($val[7])?$def_str="":$def_str="Defense: ".$val[7]." $def_a<br />";
        if(!empty($val[8])){$el_str="Fire: ".$val[8]."<br />";}
        if(!empty($val[9])){$el_str="Ice: ".$val[9]."<br />";}
        if(!empty($val[10])){$el_str="Earth: ".$val[10]."<br />";}
        if(!empty($val[11])){$el_str="Energy: ".$val[11]."<br />";}
        empty($val[12])?$ran_str="":$ran_str="Range: ".$val[12]."<br />";
        empty($val[14])?$sk_sh="":$sk_sh="Shielding: + ".$val[14]."<br />";

        empty($val[15])?$sk_mag="":$sk_mag="Magic: + ".$val[15]."<br />";
        empty($val[16])?$eb_all="":$eb_all="Protection All: ".$val[16]."%<br />";
        empty($val[17])?$charg_str="":$charg_str="Charges: ".$val[17]."<br />";
        empty($val[18])?$sk_dist="":$sk_dist="Distance: + ".$val[18]."<br />";
        empty($val[19])?$eb_fire="":$eb_fire="Protection fire: ".$val[19]."%<br />";
        empty($val[20])?$eb_earth="":$eb_earth="Protection earth: ".$val[20]."%<br />";
        empty($val[21])?$eb_ice="":$eb_ice="Protection ice: ".$val[21]."%<br />";
        empty($val[22])?$eb_ene="":$eb_ene="Protection energy: ".$val[22]."%<br />";
        empty($val[23])?$eb_dth="":$eb_dth="Protection death: ".$val[23]."%<br />";
        empty($val[24])?$eb_hol="":$eb_hol="Protection holy: ".$val[24]."%<br />";
        empty($val[25])?$eb_pys="":$eb_pys="Protection physical: ".$val[25]."%<br />";
        empty($val[26])?$sk_axe="":$sk_axe="Axe: + ".$val[26]."<br />";
        empty($val[27])?$sk_club="":$sk_club="Club: + ".$val[27]."<br />";
        empty($val[28])?$sk_sword="":$sk_sword="Sword: + ".$val[28]."<br />";
        empty($val[29])?$dura="":$dura="Duration: ".$val[29]." minutes.<br />";
        empty($val[30])?$sk_fist="":$sk_fist="Fist: + ".$val[30]."<br />";
        empty($val[31])?$eb_mana="":$eb_mana="Protection manadrain: ".$val[31]."%<br />";
        empty($val[32])?$eb_life="":$eb_life="Protection lifedrain: ".$val[32]."%<br />";
        empty($val[33])?$eb_drop="":$eb_drop="Protection drop: ".$val[33]."%<br />";
        empty($val[34])?$hit_ch="":$hit_ch="Hit chance: ".$val[34]."%<br />";
        empty($val[35])?$sh_type="":$sh_type="Element: ".$val[35]."<br />";

        if(empty($val[8]) AND empty($val[9]) AND empty($val[10]) AND empty($val[11])){$ele_str="";}

        $str="<div class=\'$cl\'>".$val[0]."</div><font class=\'attr\'>$arm_str $sp_str $sh_type $att_str $ran_str $def_str $hit_ch $sk_sh $sk_sword $sk_axe $sk_club $sk_fist $sk_mag $sk_dist $eb_all $eb_drop $eb_mana $eb_life $eb_fire $eb_earth $eb_ice $eb_ene $eb_dth $eb_hol $eb_pys $el_str $charg_str $dura Weight: ".$val[3]." oz $desc_str</font>";
        return $str;
    }
    function item_grade($attributes)
    {
        require('config/config.php');
        if($attributes<=$config['normal']['attributes']){return $config['class']['normal'];}
        if($attributes==$config['rare']['attributes']){return $config['class']['rare'];}
        if($attributes==$config['epic']['attributes']){return $config['class']['epic'];}
        if($attributes>=$config['legendary']['attributes']){return $config['class']['legendary'];}
    }
    function table_exists ($table, $db)
	{
		$tables = mysql_list_tables ($db);
		while (list ($temp) = mysql_fetch_array ($tables))
		{
			if ($temp == $table)
			{
				return TRUE;
			}
		}
		return FALSE;
	}
}
?>

Optus · Sep 4, 2011

Still giving invalid password, and just on a note theirs a table near password called salt and if i use plaintext it still makes it sha1 and it still stuffs up

EDIT: where can i download a safe acc page like gesior or modern for tfs 0.3.6pl?

mofaza · Sep 28, 2011

Someone solved this problem? When players creates acc's they get into character list but can't log in, says invalid password.

Account manager problem...

Optus

GeorgeB.

luigilc

Lua Learner

Optus

GeorgeB.

Cronox

www.Searz-Online.com

Optus

GeorgeB.

mofaza

Maskin

Similar threads