ВКонтакте - Подключение Open API - страница 2 - Joomla 1.5: Установка и обновление

500 - Layout "blog" not found

function syncUsers() {

global $_CB_database, $my, $ueConfig;



// 1. add missing comprofiler entries, guessing naming depending on CB's name style:

switch ( $ueConfig['name_style'] ) {

case 2:

// firstname + lastname:

$sql = "INSERT IGNORE INTO #__comprofiler(id,user_id,lastname,firstname) "

." SELECT id,id, SUBSTRING_INDEX(name,' ',-1), "

."SUBSTRING( name, 1, length( name ) - length( SUBSTRING_INDEX( name, ' ', -1 ) ) -1 ) "

." FROM #__users"; 

break;

case 3:

// firstname + middlename + lastname:

$sql = "INSERT IGNORE INTO #__comprofiler(id,user_id,middlename,lastname,firstname) "

. " SELECT id,id,SUBSTRING( name, INSTR( name, ' ' ) +1,"

." length( name ) - INSTR( name, ' ' ) - length( SUBSTRING_INDEX( name, ' ', -1 ) ) -1 ),"

." SUBSTRING_INDEX(name,' ',-1),"

." IF(INSTR(name,' '),SUBSTRING_INDEX( name, ' ', 1 ),'') "

. " FROM #__users";

break;

default:

// name only:

$sql = "INSERT IGNORE INTO #__comprofiler(id,user_id) SELECT id,id FROM #__users";

break;

}

$_CB_database->setQuery($sql);

if (!$_CB_database->query()) {


return;

}

$affected = mysql_affected_rows();

if ($affected) {


}



$sql = "UPDATE #__comprofiler SET `user_id`=`id`";

$_CB_database->setQuery($sql);

if (!$_CB_database->query()) {


return;

}

$affected = mysql_affected_rows();

if ($affected) {


}



// 2. remove excessive comprofiler entries (e.g. if admin used mambo/joomla delete user function:

$sql = "SELECT c.id FROM #__comprofiler c LEFT JOIN #__users u ON u.id = c.id WHERE u.id IS NULL";

$_CB_database->setQuery($sql);

$users = $_CB_database->loadResultArray();

if (count($users)) {


}

if ($_CB_database->getErrorNum()) {


return;

}

$msg = deleteUsers($users, true);



}