[شرح] ربط كليجا مع اي سكربت

[shams2222]

طيب فى حالة لو انا عامل حماية للمنتدى ومغير مكان واسم الكونفج

لما بحط بيانات القاعده فى كونفج المركز برده الربط مابيشتغلش

للعلم المنتدى نسخة فى بى

[Riiam]

لم ربط
عند التسجيل يشيله الى الصفحه الرئيسية للموقع
وعند تسجيل الدخول يقول له الربط خطأ

[قلمـ رصاصـ]

Sorry , There is an error in mysql , error : Error In query

--[query]--------------------------
SELECT salt FROM `user` WHERE username='��� ������' AND usergroupid != '8'
---------------------------------

[1267 : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1256_general_ci,COERCIBLE) for operation '=']


Script: Kleeja
Kleeja Website

[zana]

hello every one

sorry i write my question by english language because i am not speak arabic very well

my question is

i finish all those steps you write it here for other member but its no way to connect my vb forum to my kleeja

if any one know how to connect it please tell me how

you can answer me by arabic language i understand arabic

thanks for kleeja and all kleeja staff

[saanina]

لو كنت مهتما بالربط ونسختك 1rc6 فقم بالترقيه للنسخه التطويريه لانها الاحسن للربط ,

رابط كيفية الترقيه :
viewtopic.php?f=37&t=4363#p25610

ثم اقرأ الموضوع هذا لانه مفيد للربط :
viewtopic.php?f=37&t=4362#p25608

[ibrahim.k]

لكل من طلب كود SMF

كود: تحديد الكل

[code]<?php

if (!defined('IN_COMMON'))
{
   exit('no directly opening : ' . __file__);
}
 

function kleeja_auth_login ($name, $pass)
{
   global $script_path ;
   
   if(isset($script_path)) {
   
   if($script_path[strlen($script_path)] == '/')
   {
      $script_path = substr($script_path, 0, strlen($script_path));
   }

   $script_path = ($script_path[0] == '/' ? '..' : '../') .  $script_path;
   
   
   
   if(file_exists($script_path . '/Settings.php'))
   {
      require ($script_path . '/Settings.php');
      $forum_srv   = $db_server;
      $forum_db   = $db_name;
      $forum_user   = $db_user;
      $forum_pass   = $db_passwd;
      $forum_prefix = $db_prefix;
   }
   else
   {
      big_error('Forum path is not correct', sprintf($lang['SCRIPT_AUTH_PATH_WRONG'], 'SimpleMachineForum'));
   }
   }
   else
   {
      $forum_srv   = $script_srv;
      $forum_db   = $script_db;
      $forum_user   = $script_user;
      $forum_pass   = $script_pass;
      $forum_prefix = $script_prefix;
   }
   
   if(empty($forum_srv) || empty($forum_user) || empty($forum_db))
   {
      return;
   }
   
   mysql_connect($forum_srv, $forum_user, $forum_pass, $forum_db);
   unset($forum_pass);
   
   //securing name
   
   $secnam=mysql_real_escape_string($name);
   $shapw=sha1(strtolower($secnam) . $pass) ;
   $query= "SELECT * FROM smf_members WHERE member_name='$secnam' AND passwd='$shapw' ";
   echo "$query";   

   $result = mysql_query($query);
   

   if (mysql_num_rows($result) != 0)
   {
   
      while($row=mysql_fetch_array($result))
      {
         $_SESSION['USER_ID']   = $row['id_member'];
         $_SESSION['USER_NAME']   = $row['member_name'] ;
         $_SESSION['USER_MAIL']   = $row['email_address'];
         $_SESSION['USER_ADMIN']   = ($row['id_group'] == 1) ? 1 : 0;
         $_SESSION['USER_SESS']   = session_id();
         
      }
      
      mysql_free_result($result);   
      unset($pass);
      mysql_close();
      
      
      return true;
   }
   else
   {
      mysql_close();
      return false;
   }
}   

function kleeja_auth_username ($user_id)
{

   global $script_path ;
   
   if(isset($script_path)) {
   
   if($script_path[strlen($script_path)] == '/')
   {
      $script_path = substr($script_path, 0, strlen($script_path));
   }

   $script_path = ($script_path[0] == '/' ? '..' : '../') .  $script_path;
   
   
   
   if(file_exists($script_path . '/Settings.php'))
   {
      require ($script_path . '/Settings.php');
      $forum_srv   = $db_server;
      $forum_db   = $db_name;
      $forum_user   = $db_user;
      $forum_pass   = $db_passwd;
      $forum_prefix = $db_prefix;
   }
   else
   {
      big_error('Forum path is not correct', sprintf($lang['SCRIPT_AUTH_PATH_WRONG'], 'SimpleMachineForum'));
   }
   }
   else
   {
      $forum_srv   = $script_srv;
      $forum_db   = $script_db;
      $forum_user   = $script_user;
      $forum_pass   = $script_pass;
      $forum_prefix = $script_prefix;
   }
   
   if(empty($forum_srv) || empty($forum_user) || empty($forum_db))
   {
      return;
   }
   
   mysql_connect($forum_srv, $forum_user, $forum_pass, $forum_db);
   unset($forum_pass);
   
   //securing name
   
$valnin=intval($user_id);
   $query= "SELECT member_name FROM smf_members WHERE id_member='$valnin'" ;
         

   $result = mysql_query($query);
   

   if (mysql_num_rows($result) != 0)
   {
   
      while($row=mysql_fetch_array($result))
      {
         $returnname = $row['username'];
         
      }
      
      mysql_free_result($result);   
      unset($pass);
      mysql_close();
      
      
      return true;
   }
   else
   {
      mysql_close();
      return false;
   }
}
         
   

?>

[/code]
للأسف لم يهتم أصحاب كليجا لتعبي و لا أعلم لم لم يقبلوني معهم

أخوني الكرام أرجو مساعدتي في عملية الربط مع smf

[moon-light]

بعد الربط تظهر هذه المشكلة

Kleeja error :

[ Forum path is not correct ]



Visit Kleeja Website for more details.


وعند فتح معالج الإصلاح fix.php تظهر الرسالة أيضا

[moon-light]

تم حل المشكلة أخوتي

لكن الأعضاء عند تسجيل الدخول يخرجوا مباشرة

[TawwaT]

شكرا على الشرح

[SAFAD]

تم تحديث ملف الربط مع سكريبت SimpleMachinesForum

كود: تحديد الكل

<?php

if (!defined('IN_COMMON'))
{
	exit('no directly opening : ' . __file__);
}
  

function kleeja_auth_login ($name, $pass)
{
	global $script_path ;
	
	if(isset($script_path)) {
	
	if($script_path[strlen($script_path)] == '/')
	{
		$script_path = substr($script_path, 0, strlen($script_path));
	}

	$script_path = ($script_path[0] == '/' ? '..' : '../') .  $script_path;
	
	
	
	if(file_exists($script_path . '/Settings.php')) 
	{
		require ($script_path . '/Settings.php');
		$forum_srv	= $db_server;
		$forum_db	= $db_name;
		$forum_user	= $db_user;
		$forum_pass	= $db_passwd;
		$forum_prefix = $db_prefix;
	} 
	else
	{
		big_error('Forum path is not correct', sprintf($lang['SCRIPT_AUTH_PATH_WRONG'], 'SimpleMachineForum'));
	}
	}
	else
	{
		$forum_srv	= $script_srv;
		$forum_db	= $script_db;
		$forum_user	= $script_user;
		$forum_pass	= $script_pass;
		$forum_prefix = $script_prefix;
	}
	
	if(empty($forum_srv) || empty($forum_user) || empty($forum_db))
	{
		return;
	}
	
	mysql_connect("$forum_srv", "$forum_user", "$forum_pass")or die("áÇ íãßä ÇáÅÊÕÇá ÈÇáÎÇÏã");
mysql_select_db("$forum_db")or die("áÇ íãßä ÊÍÏíÏ ÞÇÚÏÉ ÇáÈíÇäÇÊ");

	unset($forum_pass); 
	
	//securing name
	
	$secnam=mysql_real_escape_string($name);
	$shapw=sha1(strtolower($secnam) . $pass) ;
	$query= "SELECT * FROM {$forum_prefix}members WHERE member_name='$secnam' AND passwd='$shapw' ";


	$result = @mysql_query($query);
	

	if (mysql_num_rows($result) != 0) 
	{
	
		while($row=mysql_fetch_array($result))
		{
			$_SESSION['USER_ID']	= $row['id_member'];
			$_SESSION['USER_NAME']	= $row['member_name'] ;
			$_SESSION['USER_MAIL']	= $row['email_address'];
			$_SESSION['USER_ADMIN']	= ($row['id_group'] == 1) ? 1 : 0;
			$_SESSION['USER_SESS']	= session_id();
			
		}
		
		mysql_free_result($result);   
		unset($pass);
		mysql_close();
		
		
		return true;
	}
	else
	{
		mysql_close();
		return false;
	}
}	

function kleeja_auth_username ($user_id)
{

	global $script_path ;
	
	if(isset($script_path)) {
	
	if($script_path[strlen($script_path)] == '/')
	{
		$script_path = substr($script_path, 0, strlen($script_path));
	}

	$script_path = ($script_path[0] == '/' ? '..' : '../') .  $script_path;
	
	
	
	if(file_exists($script_path . '/Settings.php')) 
	{
		require ($script_path . '/Settings.php');
		$forum_srv	= $db_server;
		$forum_db	= $db_name;
		$forum_user	= $db_user;
		$forum_pass	= $db_passwd;
		$forum_prefix = $db_prefix;
	} 
	else
	{
		big_error('Forum path is not correct', sprintf($lang['SCRIPT_AUTH_PATH_WRONG'], 'SimpleMachineForum'));
	}
	}
	else
	{
		$forum_srv	= $script_srv;
		$forum_db	= $script_db;
		$forum_user	= $script_user;
		$forum_pass	= $script_pass;
		$forum_prefix = $script_prefix;
	}
	
	if(empty($forum_srv) || empty($forum_user) || empty($forum_db))
	{
		return;
	}
	
	mysql_connect("$forum_srv", "$forum_user", "$forum_pass")or die("áÇ íãßä ÇáÅÊÕÇá ÈÇáÎÇÏã");
mysql_select_db("$forum_db")or die("áÇ íãßä ÊÍÏíÏ ÞÇÚÏÉ ÇáÈíÇäÇÊ");
	unset($forum_pass); 
	
	//securing name
	
$valnin=intval($user_id);
	$query= "SELECT member_name FROM {$forum_prefix}members WHERE id_member='$valnin'" ;
			

	$result = mysql_query($query);
	

	if (mysql_num_rows($result) != 0) 
	{
	
		while($row=mysql_fetch_array($result))
		{
			$returnname = $row['username'];
			
		}
		
		mysql_free_result($result);   
		unset($pass);
		
		
		
		return true;
	}
	else
	{
		$SQLSM->close();
		return false;
	}
}
			
	

?>