Login     Sign up
Integration with 123flashchat
Isa (@fantapeach)
Join date: Sep 25th 2010
Community posts: 9
View Profile
Send Message

hello

I decide to choose jcow for our communauty and i m happy with but i have a big problem.

I' m trying since 2hours to integrate 123flashchat with the database from jcow but thats dont work.

i use auth url for this integration.

if someone can help me i would be happy !

This link maybe can help

[url]http://www.123flashchat.com/index.php?page=database[/url]

[url]http://www.123flashchat.com/docs/v77/Database-Integration[/url]

[url]http://www.123flashchat.com/index.php?page=auth-url-integration[/url]

Thats worked with my old cms so i think its possible to do a integration database with Jcow !

thanks you for your future help and sorry for my bad english !

167 months ago
adil (@adil)
Join date: May 9th 2010
Community posts: 202
View Profile
Send Message

I did not follow ur links yet but I've tried 123flash before the integrated version is payable ... so check with the 123 for the integration

167 months ago
Isa (@fantapeach)
Join date: Sep 25th 2010
Community posts: 9
View Profile
Send Message

thanks for your reponse adil

The database connexion is ok with my old database (from an another cms) but now i need to do this connexion with jcow database.

I m trying to edit this code for thats works with jcow

167 months ago
Isa (@fantapeach)
Join date: Sep 25th 2010
Community posts: 9
View Profile
Send Message

thanks for your reponse adil

The database connexion is ok with my old database (from an another cms) but now i need to do this connexion with jcow database.

I m trying to edit this code for thats works with jcow

167 months ago
Isa (@fantapeach)
Join date: Sep 25th 2010
Community posts: 9
View Profile
Send Message

thanks for your reponse adil

The database connexion is ok with my old database (from an another cms) but now i need to do this connexion with jcow database.

I m trying to edit this code for thats works with jcow

the code for "verif.php" :

<?

  $LOGIN_SUCCESS = 0;
  $LOGIN_PASSWD_ERROR = 1;
  $LOGIN_NICK_EXIST = 2;
  $LOGIN_ERROR = 3;
  $LOGIN_ERROR_NOUSERID = 4;
  $LOGIN_SUCCESS_ADMIN = 5;
  $LOGIN_NOT_ALLOW_GUEST = 6;
  $LOGIN_USER_BANED = 7;

  $db_host = "localhost";  // edit 
  $db_username = "admin"; // edit
  $db_password = "******"; // edit
  $db_name = "db_jcow"; // edit
  $usertable = "jcow_accounts"; 
  $username_field = "username"; 

  // Make the database connection.
  mysql_connect($db_host,$db_username,$db_password) or die(mysql_error());
  mysql_select_db($db_name) or die(mysql_error());

  $username = isset($_GET['username']) ? trim(htmlspecialchars($_GET['username'])) : '';
  $username = substr(str_replace("\\'", "'", $username), 0, 25);
  $username = str_replace("'", "\\'", $username);
  $password = isset($_GET['password']) ? $_GET['password'] : '';

  $password= md5($password);

  //$md5 = isset($HTTP_GET_VARS['md5']) ? $HTTP_GET_VARS['md5'] : '';

  $sql = "SELECT username,password".
   " FROM " . $usertable . "
  WHERE ". $username_field . " = '" . str_replace("\\'", "''", $username) . "'";

  if ( !($rs = mysql_query($sql)) )
  {
  echo $LOGIN_ERROR;
  exit;
  }

  if( $result = mysql_fetch_row($rs) )
  {

  $db_user_password = $result[1];
  $salt = $result[2];

  $pass = sha1(strtolower($username) . $password);

  if (($password == $db_user_password) || (sha1(strtolower($username) . $password) == $db_user_password))
  {
   echo $LOGIN_SUCCESS;
   exit;
  }
  else
  {
   echo $LOGIN_PASSWD_ERROR;
   exit;
  }

  }
  else
  {
  echo $LOGIN_ERROR_NOUSERID;
  exit;
  }

  ?>

And in the panel admin from 123flashchat i write in parametre database connexion (mode auth url):

[url]http://www.website.com/verif.php?username=%username%&password=%password%[/url]

Maybe thats can help !thats work with my old cms so i m sure its possible to do that with jcow lol

i continue to search

Good evening and thanks!

ps : the message repeat 3 times sorry about that !

167 months ago
Mohamad Saifullah (@okbah)
Join date: Aug 31st 2010
Community posts: 18
View Profile
Send Message

any update?? i need this

166 months ago