Erno Erno  • 21.01.16 0:21

[AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] Empty [AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] 21.01.16 0:21


Olá amigos do Power Pixel, estou com um problema. Me ajudem?
O meu problema é o seguinte:

Olá, eu estou tentando trocar minha CMS para uma Pixma, mas quando vou colocar o usuário e a senha dos registros que já existem, ela não entra. Funciona apenas quando faço registro novo. Existe alguma forma de correção para isso? Pois as contas criadas estão chegando na tabela, mas não entram. Obg

Será que é fácil resolver este erro?
Veja minhas configurações, poderá ajudar!
Meu emulador é o
Azure
Minha CMS é a
 Azure
Meu hotel está no
 -
Como sei que uma imagem vale mais que mil palavras, olhe o print:
-

Desde já obrigado. Aguardarei respostas!
                 

The Flash The Flash  • 21.01.16 14:03

[AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] Empty Re: [AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] 21.01.16 14:03

A criptografia utilizada para criptografar as senhas deve ser diferente. Logo, as senhas não são lidas.

Erno Erno  • 21.01.16 16:31

Leeb Leeb  • 21.01.16 17:17

Rai0s Rai0s  • 21.01.16 23:27

[AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] Empty Re: [AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] 21.01.16 23:27

Cara não sei se a solução é o encryptamento das senhas que está diferente, mas não custa tentar; Lembrando que, a Pixma CMS é uma CMS diferente das Lavvos, ela tem o php um pouco diferente das outras. Eu não sei onde fica o Core da sua CMS, por isso procure por ele, e onde for o encryptamento da senha vc troca por isso:

function HoloHash($password){

$hash_secret = "xCg532%@%gdvf^5DGaa6&*rFTfg^FD4\$OIFThrR_gh(ugf*/";
$string = sha1($password.($hash_secret));
return $string;
}

function HoloHashMD5($password){
$hash_secret = "xCg532%@%gdvf^5DGaa6&*rFTfg^FD4\$OIFThrR_gh(ugf*/";
$string = md5($password.($hash_secret));
return $string;
}

Erno Erno  • 22.01.16 14:33

[AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] Empty Re: [AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] 22.01.16 14:33

Antiga cms



hk_session.php

Código:
<?php

## Hacemos el login a la HK

if(isset($_POST['HUsername']) && isset($_POST['HPassword']))
{

$HU = $_POST['HUsername'];
$HP = $_POST['HPassword'];

## Seleccionamos el usuario introducido
$GetuserH = mysql_query("SELECT * FROM users WHERE username = '". $HU ."' AND password = '". md5($HP) ."'");

## Checamos que los campos del login esten llenos.
if(empty($HU) || empty($HP))
{
    $msg = '                   <div class="col l4 offset-l4 col m6 offset-m3 col s12 center">
          <div class="card blue-white darken-1">
            <div class="card-content black-text">
              <span class="light center" style="color: #09c !important;font-size: 20px;">Los datos estan vacíos, llenalos</span>
              <p>
 
           </p>
            </div>
          </div>
        </div>';  // Si estan vacios, lanza error.
}
## Checamos que tenga el rango suficiente para entrar a la HK.
elseif($myrow['rank'] <= $web['minhkr'])
{
    $msg = '                   <div class="col l4 offset-l4 col m6 offset-m3 col s12 center">
          <div class="card blue-white darken-1">
            <div class="card-content black-text">
              <span class="light center" style="color: #09c !important;font-size: 20px;">No tienes el rango suficiente para entrar a la HK</span>
              <p>
 
           </p>
            </div>
          </div>
        </div>';
}
##Checamos que el usuario exista.
elseif(mysql_num_rows($GetuserH) == 0)
{
    $msg = '                   <div class="col l4 offset-l4 col m6 offset-m3 col s12 center">
          <div class="card blue-white darken-1">
            <div class="card-content black-text">
              <span class="light center" style="color: #09c !important;font-size: 20px;">El usuario no existe o la contraseña es incorrecta</span>
              <p>
 
           </p>
            </div>
          </div>
        </div>'; // Si no existe, lanza error
}

## Si no hubo error, obtenemos sus datos y se loguea.
else
{
    ## Hacemos la sesion checando que el usuario exista.
   if(mysql_num_rows($GetuserH) > 0)
   {
   $_SESSION['HUsername'] = $HU;
   $_SESSION['HPassword'] = $HP;
   mysql_query("INSERT INTO stafflogs (action, message, note, userid, timestamp) VALUES ('Housekeeping', 'Entro al panel de administracion', '". $myrow['rank'] ."', '". $myrow['id'] ."', '". $date_full ."')");
   }
}
}

## Obtenemos su sesion
## Si estan definidas las variables de sesion ejecuta el resto
if(isset($_SESSION['HUsername']) && isset($_SESSION['HPassword']))
{
$HSU = $_SESSION['HUsername'];
$HSP = $_SESSION['HPassword'];

## Obtenemos el usuario

$GetUserH = mysql_query("SELECT * FROM users WHERE username = '". $HSU ."' AND password = '". md5($HSP) ."'");
if(mysql_num_rows($GetUserH) > 0)
{
## Nombramos sus datos
$myrow = mysql_fetch_assoc($GetUserH);
define("UserH", true);
}
} else {
define("UserH", false);
}

?>

Nova cms


server-data.php_data_classes-core.php



Código:
<?php

define("IN_HOLOCMS", TRUE);
if(@session_start() == false){session_destroy();session_start();}
ini_set('default_charset', 'iso-8859-1');

// #########################################################################
// MySQL
// #########################################################################

@require_once('server-data.php_data_classes-config.php.php');
mysql_connect("$MySQLhostname", "$MySQLusername", "$MySQLpassword") or die("");
mysql_select_db("$MySQLdb") or die("");

// #########################################################################
// Variables
// #########################################################################

$cms_name = mysql_fetch_assoc($cms_name = mysql_query("SELECT * FROM cms_settings WHERE variable = 'cms_name'"));
$cms_url = mysql_fetch_assoc($cms_url = mysql_query("SELECT * FROM cms_settings WHERE variable = 'cms_url'"));

$remote_ip = $_SERVER[REMOTE_ADDR];
$sitename = "".$cms_name['value']."";
$shortname = "".$cms_name['value']."";

if(@ini_get('date.timezone') == null && function_exists("date_default_timezone_get")){ @date_default_timezone_set("Europe/Berlin"); }

$H = date('H');
$i = date('i');
$s = date('s');
$m = date('m');
$d = date('d');
$Y = date('Y');
$j = date('j');
$n = date('n');
$today = $d;
$month = $m;
$year = $Y;
$getmoney_date = date('d.m.Y',mktime($m,$d,$Y));
$birthday_date = date('d.m', mktime($m,$d));
$date_normal = date('d.m.Y',mktime($m,$d,$Y));
$date_full = date('d.m.Y H:i:s',mktime($H,$i,$s,$m,$d,$Y));
$path = "".$cms_url['value']."";
define("PATH", $path);
$adminpath = "".$path."/manage/hotel/de/housekeeping";
$clientpath = "".$path."/client";
$cimagesurl = "./album1584/";
$badgesurl = "/album1584/";
$hash_secret = "xCg532%@%gdvf^5DGaa6&*rFTfg^FD4\$OIFThrR_gh(ugf*/";

$cms_settings = mysql_query("SELECT * FROM cms_settings LIMIT 1");
$config = mysql_fetch_assoc($cms_settings);

$maintenance = mysql_num_rows($maintenance = mysql_query("SELECT * FROM cms_settings WHERE variable = 'cms_maintenance' AND value = '1'"));

$server = mysql_fetch_assoc($server_status = mysql_query("SELECT * FROM server_status"));
$online_count = $server['users_online'];

// #########################################################################
// MySQL tab[b][/b]le SITE_CONFIG
// #########################################################################

function FetchSITESetting($strSetting){

   $tmp = mysql_query("SELECT ".$strSetting." FROM cms_settings LIMIT 1") or die(mysql_error());
   $tmp = mysql_fetch_assoc($tmp);
   return $tmp[$strSetting];

}

// #########################################################################
// CMS LOGIN FUNKTION
// #########################################################################

function HoloHash($password){
$hash_secret = "xCg532%@%gdvf^5DGaa6&*rFTfg^FD4\$OIFThrR_gh(ugf*/";
$string = sha1($password.($hash_secret));
return $string;
}

function HoloHashMD5($password){
$hash_secret = "xCg532%@%gdvf^5DGaa6&*rFTfg^FD4\$OIFThrR_gh(ugf*/";
$string = md5($password.($hash_secret));
return $string;
}

// #########################################################################
// Funcion Cookie
// #########################################################################

if(!session_is_registered(username) && $_COOKIE['remember'] == "remember"){

   $cname = FilterText($_COOKIE['rusername']);
   $cpass_hash = $_COOKIE['rpassword'];

   $csql = mysql_query("SELECT password,id FROM users WHERE username = '".$cname."' LIMIT 1") or die(mysql_error());
   $cnum = mysql_num_rows($csql);

      if($cnum < 1){
         setcookie("remember", "", time()-60*60*24*100, "/"); setcookie("cookpass", "", time()-60*60*24*100, "/");
         setcookie("rusername", "", time()-60*60*24*100, "/"); setcookie("cookpass", "", time()-60*60*24*100, "/");
         setcookie("rpassword", "", time()-60*60*24*100, "/"); setcookie("cookpass", "", time()-60*60*24*100, "/");
      } else {

         $crow = mysql_fetch_assoc($csql);
         $correct_pass = $crow['password'];

         if($cpass_hash == $correct_pass){
            $_SESSION['username'] = $cname;
            $_SESSION['password'] = $crow['password'];
            $sql3 = mysql_query("UPDATE users SET ip_last = '".$remote_ip."' WHERE username = '".$cname."'");
            header("location: me"); exit;
         } else {

            setcookie("remember", "", time()-60*60*24*100, "/"); setcookie("cookpass", "", time()-60*60*24*100, "/");
            setcookie("rusername", "", time()-60*60*24*100, "/"); setcookie("cookpass", "", time()-60*60*24*100, "/");
            setcookie("rpassword", "", time()-60*60*24*100, "/"); setcookie("cookpass", "", time()-60*60*24*100, "/");
         }
      }
}
function check_inject()
  {
    $badchars = array(";", "'", "\"", "*", "DROP", "SELECT", "UPDATE", "DELETE", "-");
 
    foreach($_POST as $value)
    {
      if(in_array($value, $badchars))
      {
        die("SQL Injection Detected\n<br />\nIP: ".$_SERVER['REMOTE_ADDR']);
    }
      else
      {
        $check = preg_split("//", $value, -1, PREG_SPLIT_OFFSET_CAPTURE);
        foreach($check as $char)
        {
          if(in_array($char, $badchars))
          {
            die("SQL Injection Detected\n<br />\nIP: ".$_SERVER['REMOTE_ADDR']);
         }
         }
         }
         }
         }

function IsEven($intNumber)
{
   if($intNumber % 2 == 0){
      return true;
   } else {
      return false;
   }
}


function bbcode_format($str){

   $str = str_replace(":)", " <img src='./web-gallery/smilies/smile.gif' alt='Smiley' title='Smiley' border='0'> ", $str);
   $str = str_replace(";)", " <img src='./web-gallery/smilies/wink.gif' alt='Smiley' title='Smiley' border='0'> ", $str);
   $str = str_replace(":P", " <img src='./web-gallery/smilies/tongue.gif' alt='Smiley' title='Smiley' border='0'> ", $str);
   $str = str_replace(";P", " <img src='./web-gallery/smilies/winktongue.gif' alt='Smiley' title='Smiley' border='0'> ", $str);
   $str = str_replace(":p", " <img src='./web-gallery/smilies/tongue.gif' alt='Smiley' title='Smiley' border='0'> ", $str);
   $str = str_replace(";p", " <img src='./web-gallery/smilies/winktongue.gif' alt='Smiley' title='Smiley' border='0'> ", $str);
   $str = str_replace("(L)", " <img src='./web-gallery/smilies/heart.gif' alt='Smiley' title='Smiley' border='0'> ", $str);
   $str = str_replace("(l)", " <img src='./web-gallery/smilies/heart.gif' alt='Smiley' title='Smiley' border='0'> ", $str);
   $str = str_replace(":o", " <img src='./web-gallery/smilies/shocked.gif' alt='Smiley' title='Smiley' border='0'> ", $str);
   $str = str_replace(":O", " <img src='./web-gallery/smilies/shocked.gif' alt='Smiley' title='Smiley' border='0'> ", $str);

        $simple_search = array(
                                '/\[b\](.*?)\[\/b\]/is',
                                '/\[i\](.*?)\[\/i\]/is',
                                '/\[u\](.*?)\[\/u\]/is',
                                '/\[s\](.*?)\[\/s\]/is',
                                '/\[quote\](.*?)\[\/quote\]/is',
                                '/\[link\=(.*?)\](.*?)\[\/link\]/is',
                                '/\[url\=(.*?)\](.*?)\[\/url\]/is',
                                '/\[color\=(.*?)\](.*?)\[\/color\]/is',
                                '/\[size=small\](.*?)\[\/size\]/is',
                                '/\[size=large\](.*?)\[\/size\]/is',
                                '/\[code\](.*?)\[\/code\]/is',
                                '/\[habbo\=(.*?)\](.*?)\[\/habbo\]/is',
                                '/\[room\=(.*?)\](.*?)\[\/room\]/is',
                                '/\[group\=(.*?)\](.*?)\[\/group\]/is'
   );

        $simple_replace = array(
                                '<strong>$1</strong>',
                                '<em>$1</em>',
                                '<u>$1</u>',
                                '<s>$1</s>',
                                "<div class='bbcode-quote'>$1</div>",
                                "<a href='$1'>$2</a>",
                                "<a href='$1'>$2</a>",
                                "<font color='$1'>$2</font>",
                                "<font size='1'>$1</font>",
                                "<font size='3'>$1</font>",
                                '<pre>$1</pre>',
                                "<a href='./user_profile.php?id=$1'>$2</a>",
                                "<a onclick=\"roomForward(this, '$1', 'private'); return false;\" target=\"client\" href=\"./client.php?forwardId=2&roomId=$1\">$2</a>",
                                "<a href='./group_profile.php?id=$1'>$2</a>"
   );

        $str = preg_replace ($simple_search, $simple_replace, $str);

        return $str;
}

function GenerateTicket(){

   $data = "ST-";

   for ($i=1; $i<=6; $i++){
      $data = $data . rand(0,9);
   }

   $data = $data . "-";

   for ($i=1; $i<=20; $i++){
      $data = $data . rand(0,9);
   }

   $data = $data . "-habbore-beta-fe";
   $data = $data . rand(0,5);

   return $data;
}

// #########################################################################

if(session_is_registered('username')){

   $rawname = $_SESSION['username'];
   $rawpass = $_SESSION['password'];

   $usersql = mysql_query("SELECT * FROM users WHERE username = '".$rawname."' AND password = '".$rawpass."' LIMIT 1");
   $myrow = mysql_fetch_assoc($usersql);

   
   
   $pluginsql = mysql_query("SELECT * FROM plugins");
   $plugin = mysql_fetch_assoc($pluginsql);
   
   $pluginbannersql = mysql_query("SELECT * FROM plugins WHERE plugin_name = 'banners'");
   $pluginbanner = mysql_fetch_assoc($pluginbannersql);
   
   $configclientsql = mysql_query("SELECT * FROM configclient");
   $configclient = mysql_fetch_assoc($configclientsql);
   
   $userinfo = mysql_query("SELECT * FROM user_stats WHERE id = '".$myrow['id']."'");
   $userinfo = mysql_fetch_assoc($userinfo);

   $password_correct = mysql_num_rows($usersql);

   $my_id = $myrow['id'];
   $user_rank = $myrow['rank'];
   
      $topvotosql= mysql_query("SELECT * FROM users WHERE puntos_top > 1 ORDER BY puntos_top DESC LIMIT 1");
   $topvoto = mysql_fetch_assoc($topvotosql);

   $ban = mysql_query("SELECT * FROM bans WHERE value = '".$myrow['username']."' AND bantype = 'user' or value = '".$remote_ip."' AND bantype = 'ip' LIMIT 1");
   $bancheck = mysql_num_rows($ban);

   if($myrow['ip_reg'] == "0"){
      mysql_query("UPDATE users SET ip_reg = '".$remote_ip."' WHERE id = '".$myrow['id']."'");

   }elseif($password_correct !== 1){

   session_destroy();
   header("location: ".$path."1");
   exit;

   }elseif($bancheck > 0){

   $bandata = mysql_fetch_assoc($ban);

   $timestamp = time();
   if($bandata['expire'] > $timestamp){
   $login_error = "Du bist gebannt! Der Grund für deinen Bann lautet \"".$bandata['reason']."\" und dauert bis ".date('d.m.Y - H:i:s', $bandata['expire'])."";         
   include('logout.php');
   session_destroy(); exit;

   } else{
      mysql_query("DELETE FROM bans WHERE value = '".$name."' AND bantype = 'user' or value = '".$remote_ip."' AND bantype = 'ip' LIMIT 1"); } 
   }

   $logged_in = true;
   $name = HoloText($myrow['username']);

   } else {

   $user_rank = 0;
   $name = "No-Name";
   $my_id = "No-ID";
   $myticket = "ST-No-Name-habbore-fe";
   $logged_in = false;

}

// #########################################################################
// HC CHECK
// #########################################################################

   $hc_a = mysql_query("SELECT * FROM user_subscriptions WHERE user_id = '".$my_id."' and timestamp_expire > '".time()."'");
   $hc = mysql_num_rows($hc_a);

   function getHCDays($my_id){

      $sql = mysql_query("SELECT timestamp_activated,timestamp_expire FROM user_subscriptions WHERE user_id = '".$my_id."' LIMIT 1") or die(mysql_error());
      
      if (mysql_num_rows($sql) == 0){
         return 0;
      }
      
      $data = mysql_fetch_assoc($sql);
      $diff = $data['timestamp_expire'] - time();
      
      if ($diff <= 0){
         return 0;
      }
      
      return ceil($diff / 86400);
   }


// #########################################################################
// VIP CHECK
// #########################################################################

   
   

   function getVIPDays($my_id){

      $sql = mysql_query("SELECT timestamp,timestampend FROM vip WHERE id_user = '".$my_id."' LIMIT 1") or die(mysql_error());
      
      if (mysql_num_rows($sql) == 0){
         return 0;
      }
      
      $data = mysql_fetch_assoc($sql);
      $diff = $data['timestampend'] - time();
      
      if ($diff <= 0){
         return 0;
      }
      
      return ceil($diff / 86400);
   }


if($user_rank > 4){

   if(session_is_registered(hkusername) && session_is_registered(hkpassword)){
      $rank['iAdmin'] = "1";
   } else {
      $rank['iAdmin'] = "0";
   }

} else {
   $rank['iAdmin'] = "0";
}

if($maintenance == '1' && !$is_maintenance && $user_rank < 3 ){
   header("Location: ".$path."/maintenance");
   exit;
} elseif($user_rank > 3 && $config['variable'] == "cms_maintenance" && $config['value'] == '1'){
   $notify_maintenance = true;
}

// #########################################################################

function IsUserBanned($name){

   $check = mysql_query("SELECT * FROM bans WHERE value = '".$my_id."' AND bantype = 'user' or value = '".$remote_ip."' AND bantype = 'ip'") or die(mysql_error());
   $is_banned = mysql_num_rows($check);

   if($is_banned > 0){
      $bandata = mysql_fetch_assoc($check);
      $reason = $bandata['reason'];
      $expire = $bandata['expire'];

      $stamp_now = time();

      if($stamp_now < $bandata['expire']){
         return true;
      } else { // ban expired
         mysql_query("DELETE FROM bans WHERE value = '".$my_id."' AND bantype = 'user' or value = '".$remote_ip."' AND bantype = 'ip' LIMIT 1") or die(mysql_error());
         return false;
      }
   } else {
      return false;
   }
}

// #########################################################################

function mysql_evaluate($query, $default_value="undefined") {
   $result = mysql_query($query) or die(mysql_error());

   if(mysql_num_rows($result) < 1){
      return $default_value;
   } else {
      return mysql_result($result, 0);
   }
}

// #########################################################################

function FilterText($str, $advanced=false) {
   if($advanced == true){ return mysql_real_escape_string($str); }
   $str = mysql_real_escape_string(htmlspecialchars($str));
   return $str;
}

function HoloText($str, $advanced=false, $bbcode=false) {
   if($advanced == true){ return stripslashes($str); }
   $str = stripslashes(nl2br(htmlspecialchars($str)));
   if($bbcode == true){$str = bbcode_format($str); }
   return $str;
}
?>

The Flash The Flash  • 23.01.16 10:58

[AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] Empty Re: [AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] 23.01.16 10:58

Mesmo que você mude, os usuários antigos não poderão logar pela senha ser gerada diferentemente.

[aviso=Alerta] O autor do tópico possui 24 horas para informar se está satisfeito [/aviso]

Erno Erno  • 23.01.16 16:31

The Flash The Flash  • 27.01.16 23:34

[AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] Empty Re: [AJUDA]Quero mudar de Cms, mas as contas existentes não entram. [URGENTE] 27.01.16 23:34

Fechado.

Autor abandonou o tópico
Permissões neste sub-fórum
Não podes responder a tópicos

BH Servers

Recomendamos a BH Servers com proteção DDOS gratuita em Cloud Server de alta performance. Entrega imediata.