~azzar1/unity/add-show-desktop-key

trigger_error((($action == 'add') ? $user->lang['MODULE_ADDED'] : $user->lang['MODULE_EDITED']) . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id));

300

}

301

}

302

303

// Category/not category?

304

$is_cat = (!$module_data['module_basename']) ? true : false;

305

306

// Get module information

307

$module_infos = $this->get_module_infos();

308

309

// Build name options

310

$s_name_options = $s_mode_options = '';

311

foreach ($module_infos as $option => $values)

312

{

313

if (!$module_data['module_basename'])

314

{

315

$module_data['module_basename'] = $option;

316

}

317

318

// Name options

319

$s_name_options .= '<option value="' . $option . '"' . (($option == $module_data['module_basename']) ? ' selected="selected"' : '') . '>' . $this->lang_name($values['title']) . ' [' . $this->module_class . '_' . $option . ']</option>';

320

321

$template->assign_block_vars('m_names', array('NAME' => $option, 'A_NAME' => addslashes($option)));

322

323

// Build module modes

324

foreach ($values['modes'] as $m_mode => $m_values)

325

{

326

if ($option == $module_data['module_basename'])

327

{

328

$s_mode_options .= '<option value="' . $m_mode . '"' . (($m_mode == $module_data['module_mode']) ? ' selected="selected"' : '') . '>' . $this->lang_name($m_values['title']) . '</option>';

329

}

330

331

$template->assign_block_vars('m_names.modes', array(

332

'OPTION' => $m_mode,

333

'VALUE' => $this->lang_name($m_values['title']),

334

'A_OPTION' => addslashes($m_mode),

335

'A_VALUE' => addslashes($this->lang_name($m_values['title'])))

336

);

337

}

338

}

339

340

$s_cat_option = '<option value="0"' . (($module_data['parent_id'] == 0) ? ' selected="selected"' : '') . '>' . $user->lang['NO_PARENT'] . '</option>';

341

342

$template->assign_vars(array_merge(array(

343

'S_EDIT_MODULE' => true,

344

'S_IS_CAT' => $is_cat,

345

'S_CAT_OPTIONS' => $s_cat_option . $this->make_module_select($module_data['parent_id'], ($action == 'edit') ? $module_row['module_id'] : false, false, false, false, true),

346

'S_MODULE_NAMES' => $s_name_options,

347

'S_MODULE_MODES' => $s_mode_options,

348

'U_BACK' => $this->u_action . '&parent_id=' . $this->parent_id,

349

'U_EDIT_ACTION' => $this->u_action . '&parent_id=' . $this->parent_id,

350

351

'L_TITLE' => $user->lang[strtoupper($action) . '_MODULE'],

352

353

'MODULENAME' => $this->lang_name($module_data['module_langname']),

354

'ACTION' => $action,

355

'MODULE_ID' => $module_id,

356

357

358

array_change_key_case($module_data, CASE_UPPER))

359

);

360

361

if (sizeof($errors))

362

{

363

$template->assign_vars(array(

364

'S_ERROR' => true,

365

'ERROR_MSG' => implode('<br />', $errors))

366

);

367

}

368

369

return;

370

371

break;

372

}

373

374

// Default management page

375

if (sizeof($errors))

376

{

377

$template->assign_vars(array(

378

'S_ERROR' => true,

379

'ERROR_MSG' => implode('<br />', $errors))

380

);

381

}

382

383

if (!$this->parent_id)

384

{

385

$navigation = strtoupper($this->module_class);

386

}

387

else

388

{

389

$navigation = '<a href="' . $this->u_action . '">' . strtoupper($this->module_class) . '</a>';

390

391

$modules_nav = $this->get_module_branch($this->parent_id, 'parents', 'descending');

392

393

foreach ($modules_nav as $row)

394

{

395

$langname = $this->lang_name($row['module_langname']);

396

397

if ($row['module_id'] == $this->parent_id)

398

{

399

$navigation .= ' -> ' . $langname;

400

}

401

else

402

{

403

$navigation .= ' -> <a href="' . $this->u_action . '&parent_id=' . $row['module_id'] . '">' . $langname . '</a>';

404

}

405

}

406

}

407

408

// Jumpbox

409

$module_box = $this->make_module_select($this->parent_id, false, false, false, false);

410

411

$sql = 'SELECT *

412

FROM ' . MODULES_TABLE . "

413

WHERE parent_id = {$this->parent_id}

414

AND module_class = '" . $db->sql_escape($this->module_class) . "'

415

ORDER BY left_id";

416

$result = $db->sql_query($sql);

417

418

if ($row = $db->sql_fetchrow($result))

419

{

420

421

{

422

$langname = $this->lang_name($row['module_langname']);

423

424

if (!$row['module_enabled'])

425

{

426

$module_image = '<img src="images/icon_folder_lock.gif" alt="' . $user->lang['DEACTIVATED_MODULE'] .'" />';

427

}

428

else

429

{

430

$module_image = (!$row['module_basename'] || $row['left_id'] + 1 != $row['right_id']) ? '<img src="images/icon_subfolder.gif" alt="' . $user->lang['CATEGORY'] . '" />' : '<img src="images/icon_folder.gif" alt="' . $user->lang['MODULE'] . '" />';

431

}

432

433

$url = $this->u_action . '&parent_id=' . $this->parent_id . '&m=' . $row['module_id'];

434

435

$template->assign_block_vars('modules', array(

436

'MODULE_IMAGE' => $module_image,

437

'MODULE_TITLE' => $langname,

438

'MODULE_ENABLED' => ($row['module_enabled']) ? true : false,

439

'MODULE_DISPLAYED' => ($row['module_display']) ? true : false,

440

441

'S_ACP_CAT_SYSTEM' => ($this->module_class == 'acp' && $row['module_langname'] == 'ACP_CAT_SYSTEM') ? true : false,

442

'S_ACP_MODULE_MANAGEMENT' => ($this->module_class == 'acp' && ($row['module_basename'] == 'modules' || $row['module_langname'] == 'ACP_MODULE_MANAGEMENT')) ? true : false,

443

444

'U_MODULE' => $this->u_action . '&parent_id=' . $row['module_id'],

445

'U_MOVE_UP' => $url . '&action=move_up',

446

'U_MOVE_DOWN' => $url . '&action=move_down',

447

'U_EDIT' => $url . '&action=edit',

448

'U_DELETE' => $url . '&action=delete',

449

'U_ENABLE' => $url . '&action=enable',

450

'U_DISABLE' => $url . '&action=disable')

451

);

452

}

453

while ($row = $db->sql_fetchrow($result));

454

}

455

else if ($this->parent_id)

456

{

457

$row = $this->get_module_row($this->parent_id);

458

459

$url = $this->u_action . '&parent_id=' . $this->parent_id . '&m=' . $row['module_id'];

460

461

$template->assign_vars(array(

462

'S_NO_MODULES' => true,

463

'MODULE_TITLE' => $langname,

464

'MODULE_ENABLED' => ($row['module_enabled']) ? true : false,

465

'MODULE_DISPLAYED' => ($row['module_display']) ? true : false,

466

467

'U_EDIT' => $url . '&action=edit',

468

'U_DELETE' => $url . '&action=delete',

469

'U_ENABLE' => $url . '&action=enable',

470

'U_DISABLE' => $url . '&action=disable')

471

);

472

}

473

$db->sql_freeresult($result);

474

475

// Quick adding module

476

$module_infos = $this->get_module_infos();

477

478

// Build quick options

479

$s_install_options = '';

480

foreach ($module_infos as $option => $values)

481

{

482

// Name options

483

$s_install_options .= '<optgroup label="' . $this->lang_name($values['title']) . ' [' . $this->module_class . '_' . $option . ']">';

484

485

// Build module modes

486

foreach ($values['modes'] as $m_mode => $m_values)

487

{

488

$s_install_options .= '<option value="' . $option . '::' . $m_mode . '">   ' . $this->lang_name($m_values['title']) . '</option>';

489

}

490

491

$s_install_options .= '</optgroup>';

492

}

493

494

$template->assign_vars(array(

495

'U_SEL_ACTION' => $this->u_action,

496

'U_ACTION' => $this->u_action . '&parent_id=' . $this->parent_id,

497

'NAVIGATION' => $navigation,

498

'MODULE_BOX' => $module_box,

499

'PARENT_ID' => $this->parent_id,

500

'S_INSTALL_OPTIONS' => $s_install_options,

501

)

502

);

503

}

504

505

/**

506

* Get row for specified module

507

508

function get_module_row($module_id)

509

{

510

global $db, $user;

511

512

$sql = 'SELECT *

513

FROM ' . MODULES_TABLE . "

514

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

515

AND module_id = $module_id";

516

$result = $db->sql_query($sql);

517

$row = $db->sql_fetchrow($result);

518

$db->sql_freeresult($result);

519

520

if (!$row)

521

{

522

trigger_error($user->lang['NO_MODULE'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id), E_USER_WARNING);

523

}

524

525

return $row;

526

}

527

528

/**

529

* Get available module information from module files

530

531

function get_module_infos($module = '', $module_class = false)

532

{

533

global $phpbb_root_path, $phpEx;

534

535

$module_class = ($module_class === false) ? $this->module_class : $module_class;

536

537

$directory = $phpbb_root_path . 'includes/' . $module_class . '/info/';

538

$fileinfo = array();

539

540

if (!$module)

541

{

542

$dh = @opendir($directory);

543

544

if (!$dh)

545

{

546

return $fileinfo;

547

}

548

549

while (($file = readdir($dh)) !== false)

550

{

551

// Is module?

552

if (preg_match('/^' . $module_class . '_.+\.' . $phpEx . '$/', $file))

553

{

554

$class = str_replace(".$phpEx", '', $file) . '_info';

555

556

if (!class_exists($class))

557

{

558

include($directory . $file);

559

}

560

561

// Get module title tag

562

if (class_exists($class))

563

{

564

$c_class = new $class();

565

$module_info = $c_class->module();

566

$fileinfo[str_replace($module_class . '_', '', $module_info['filename'])] = $module_info;

567

}

568

}

569

}

570

closedir($dh);

571

572

ksort($fileinfo);

573

}

574

else

575

{

576

$filename = $module_class . '_' . basename($module);

577

$class = $module_class . '_' . basename($module) . '_info';

578

579

if (!class_exists($class))

580

{

581

include($directory . $filename . '.' . $phpEx);

582

}

583

584

// Get module title tag

585

if (class_exists($class))

586

{

587

$c_class = new $class();

588

$module_info = $c_class->module();

589

$fileinfo[str_replace($module_class . '_', '', $module_info['filename'])] = $module_info;

590

}

591

}

592

593

return $fileinfo;

594

}

595

596

/**

597

* Simple version of jumpbox, just lists modules

598

599

function make_module_select($select_id = false, $ignore_id = false, $ignore_acl = false, $ignore_nonpost = false, $ignore_emptycat = true, $ignore_noncat = false)

600

{

601

global $db, $user, $auth, $config;

602

603

$sql = 'SELECT module_id, module_enabled, module_basename, parent_id, module_langname, left_id, right_id, module_auth

604

FROM ' . MODULES_TABLE . "

605

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

606

ORDER BY left_id ASC";

607

$result = $db->sql_query($sql);

608

609

$right = $iteration = 0;

610

$padding_store = array('0' => '');

611

$module_list = $padding = '';

612

613

while ($row = $db->sql_fetchrow($result))

614

{

615

if ($row['left_id'] < $right)

616

{

617

$padding .= '   ';

618

$padding_store[$row['parent_id']] = $padding;

619

}

620

else if ($row['left_id'] > $right + 1)

621

{

622

$padding = (isset($padding_store[$row['parent_id']])) ? $padding_store[$row['parent_id']] : '';

623

}

624

625

$right = $row['right_id'];

626

627

if (!$ignore_acl && $row['module_auth'])

628

{

629

// We use zero as the forum id to check - global setting.

630

if (!p_master::module_auth($row['module_auth'], 0))

631

{

632

continue;

633

}

634

}

635

636

// ignore this module?

637

if ((is_array($ignore_id) && in_array($row['module_id'], $ignore_id)) || $row['module_id'] == $ignore_id)

638

{

639

continue;

640

}

641

642

// empty category

643

if (!$row['module_basename'] && ($row['left_id'] + 1 == $row['right_id']) && $ignore_emptycat)

644

{

645

continue;

646

}

647

648

// ignore non-category?

649

if ($row['module_basename'] && $ignore_noncat)

650

{

651

continue;

652

}

653

654

$selected = (is_array($select_id)) ? ((in_array($row['module_id'], $select_id)) ? ' selected="selected"' : '') : (($row['module_id'] == $select_id) ? ' selected="selected"' : '');

655

656

$langname = $this->lang_name($row['module_langname']);

657

$module_list .= '<option value="' . $row['module_id'] . '"' . $selected . ((!$row['module_enabled']) ? ' class="disabled"' : '') . '>' . $padding . $langname . '</option>';

658

659

$iteration++;

660

}

661

unset($padding_store);

662

663

return $module_list;

664

}

665

666

/**

667

* Get module branch

668

669

function get_module_branch($module_id, $type = 'all', $order = 'descending', $include_module = true)

670

{

671

global $db;

672

673

switch ($type)

674

{

675

case 'parents':

676

$condition = 'm1.left_id BETWEEN m2.left_id AND m2.right_id';

677

break;

678

679

case 'children':

680

$condition = 'm2.left_id BETWEEN m1.left_id AND m1.right_id';

681

break;

682

683

default:

684

$condition = 'm2.left_id BETWEEN m1.left_id AND m1.right_id OR m1.left_id BETWEEN m2.left_id AND m2.right_id';

685

break;

686

}

687

688

$rows = array();

689

690

$sql = 'SELECT m2.*

691

FROM ' . MODULES_TABLE . ' m1

692

LEFT JOIN ' . MODULES_TABLE . " m2 ON ($condition)

693

WHERE m1.module_class = '" . $db->sql_escape($this->module_class) . "'

694

AND m2.module_class = '" . $db->sql_escape($this->module_class) . "'

695

AND m1.module_id = $module_id

696

ORDER BY m2.left_id " . (($order == 'descending') ? 'ASC' : 'DESC');

697

$result = $db->sql_query($sql);

698

699

while ($row = $db->sql_fetchrow($result))

700

{

701

if (!$include_module && $row['module_id'] == $module_id)

702

{

703

continue;

704

}

705

706

$rows[] = $row;

707

}

708

$db->sql_freeresult($result);

709

710

return $rows;

711

}

712

713

/**

714

* Remove modules cache file

715

716

function remove_cache_file()

717

{

718

global $cache;

719

720

// Sanitise for future path use, it's escaped as appropriate for queries

721

$p_class = str_replace(array('.', '/', '\\'), '', basename($this->module_class));

722

723

$cache->destroy('_modules_' . $p_class);

724

725

// Additionally remove sql cache

726

$cache->destroy('sql', MODULES_TABLE);

727

}

728

729

/**

730

* Return correct language name

731

732

function lang_name($module_langname)

733

{

734

global $user;

735

736

return (!empty($user->lang[$module_langname])) ? $user->lang[$module_langname] : $module_langname;

737

}

738

739

/**

740

* Update/Add module

741

742

* @param bool $run_inline if set to true errors will be returned and no logs being written

743

744

function update_module_data(&$module_data, $run_inline = false)

745

{

746

global $db, $user;

747

748

if (!isset($module_data['module_id']))

749

{

750

// no module_id means we're creating a new category/module

751

if ($module_data['parent_id'])

752

{

753

$sql = 'SELECT left_id, right_id

754

FROM ' . MODULES_TABLE . "

755

WHERE module_class = '" . $db->sql_escape($module_data['module_class']) . "'

756

AND module_id = " . (int) $module_data['parent_id'];

757

$result = $db->sql_query($sql);

758

$row = $db->sql_fetchrow($result);

759

$db->sql_freeresult($result);

760

761

if (!$row)

762

{

763

if ($run_inline)

764

{

765

return 'PARENT_NO_EXIST';

766

}

767

768

trigger_error($user->lang['PARENT_NO_EXIST'] . adm_back_link($this->u_action . '&parent_id=' . $this->parent_id), E_USER_WARNING);

769

}

770

771

// Workaround

772

$row['left_id'] = (int) $row['left_id'];

773

$row['right_id'] = (int) $row['right_id'];

774

775

$sql = 'UPDATE ' . MODULES_TABLE . "

776

SET left_id = left_id + 2, right_id = right_id + 2

777

WHERE module_class = '" . $db->sql_escape($module_data['module_class']) . "'

778

AND left_id > {$row['right_id']}";

779

$db->sql_query($sql);

780

781

$sql = 'UPDATE ' . MODULES_TABLE . "

782

SET right_id = right_id + 2

783

WHERE module_class = '" . $db->sql_escape($module_data['module_class']) . "'

784

AND {$row['left_id']} BETWEEN left_id AND right_id";

785

$db->sql_query($sql);

786

787

$module_data['left_id'] = (int) $row['right_id'];

788

$module_data['right_id'] = (int) $row['right_id'] + 1;

789

}

790

else

791

{

792

$sql = 'SELECT MAX(right_id) AS right_id

793

FROM ' . MODULES_TABLE . "

794

WHERE module_class = '" . $db->sql_escape($module_data['module_class']) . "'";

795

$result = $db->sql_query($sql);

796

$row = $db->sql_fetchrow($result);

797

$db->sql_freeresult($result);

798

799

$module_data['left_id'] = (int) $row['right_id'] + 1;

800

$module_data['right_id'] = (int) $row['right_id'] + 2;

801

}

802

803

$sql = 'INSERT INTO ' . MODULES_TABLE . ' ' . $db->sql_build_array('INSERT', $module_data);

804

$db->sql_query($sql);

805

806

$module_data['module_id'] = $db->sql_nextid();

807

808

if (!$run_inline)

809

{

810

add_log('admin', 'LOG_MODULE_ADD', $this->lang_name($module_data['module_langname']));

811

}

812

}

813

else

814

{

815

$row = $this->get_module_row($module_data['module_id']);

816

817

if ($module_data['module_basename'] && !$row['module_basename'])

818

{

819

// we're turning a category into a module

820

$branch = $this->get_module_branch($module_data['module_id'], 'children', 'descending', false);

821

822

if (sizeof($branch))

823

{

824

return array($user->lang['NO_CATEGORY_TO_MODULE']);

825

}

826

}

827

828

if ($row['parent_id'] != $module_data['parent_id'])

829

{

830

$this->move_module($module_data['module_id'], $module_data['parent_id']);

831

}

832

833

$update_ary = $module_data;

834

unset($update_ary['module_id']);

835

836

$sql = 'UPDATE ' . MODULES_TABLE . '

837

SET ' . $db->sql_build_array('UPDATE', $update_ary) . "

838

WHERE module_class = '" . $db->sql_escape($module_data['module_class']) . "'

839

AND module_id = " . (int) $module_data['module_id'];

840

$db->sql_query($sql);

841

842

if (!$run_inline)

843

{

844

add_log('admin', 'LOG_MODULE_EDIT', $this->lang_name($module_data['module_langname']));

845

}

846

}

847

848

return array();

849

}

850

851

/**

852

* Move module around the tree

853

854

function move_module($from_module_id, $to_parent_id)

855

{

856

global $db;

857

858

$moved_modules = $this->get_module_branch($from_module_id, 'children', 'descending');

859

$from_data = $moved_modules[0];

860

$diff = sizeof($moved_modules) * 2;

861

862

$moved_ids = array();

863

for ($i = 0; $i < sizeof($moved_modules); ++$i)

864

{

865

$moved_ids[] = $moved_modules[$i]['module_id'];

866

}

867

868

// Resync parents

869

$sql = 'UPDATE ' . MODULES_TABLE . "

870

SET right_id = right_id - $diff

871

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

872

AND left_id < " . (int) $from_data['right_id'] . '

873

AND right_id > ' . (int) $from_data['right_id'];

874

$db->sql_query($sql);

875

876

// Resync righthand side of tree

877

$sql = 'UPDATE ' . MODULES_TABLE . "

878

SET left_id = left_id - $diff, right_id = right_id - $diff

879

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

880

AND left_id > " . (int) $from_data['right_id'];

881

$db->sql_query($sql);

882

883

if ($to_parent_id > 0)

884

{

885

$to_data = $this->get_module_row($to_parent_id);

886

887

// Resync new parents

888

$sql = 'UPDATE ' . MODULES_TABLE . "

889

SET right_id = right_id + $diff

890

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

891

AND " . (int) $to_data['right_id'] . ' BETWEEN left_id AND right_id

892

AND ' . $db->sql_in_set('module_id', $moved_ids, true);

893

$db->sql_query($sql);

894

895

// Resync the righthand side of the tree

896

$sql = 'UPDATE ' . MODULES_TABLE . "

897

SET left_id = left_id + $diff, right_id = right_id + $diff

898

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

899

AND left_id > " . (int) $to_data['right_id'] . '

900

AND ' . $db->sql_in_set('module_id', $moved_ids, true);

901

$db->sql_query($sql);

902

903

// Resync moved branch

904

$to_data['right_id'] += $diff;

905

if ($to_data['right_id'] > $from_data['right_id'])

906

{

907

$diff = '+ ' . ($to_data['right_id'] - $from_data['right_id'] - 1);

908

}

909

else

910

{

911

$diff = '- ' . abs($to_data['right_id'] - $from_data['right_id'] - 1);

912

}

913

}

914

else

915

{

916

$sql = 'SELECT MAX(right_id) AS right_id

917

FROM ' . MODULES_TABLE . "

918

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

919

AND " . $db->sql_in_set('module_id', $moved_ids, true);

920

$result = $db->sql_query($sql);

921

$row = $db->sql_fetchrow($result);

922

$db->sql_freeresult($result);

923

924

$diff = '+ ' . (int) ($row['right_id'] - $from_data['left_id'] + 1);

925

}

926

927

$sql = 'UPDATE ' . MODULES_TABLE . "

928

SET left_id = left_id $diff, right_id = right_id $diff

929

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

930

AND " . $db->sql_in_set('module_id', $moved_ids);

931

$db->sql_query($sql);

932

}

933

934

/**

935

* Remove module from tree

936

937

function delete_module($module_id)

938

{

939

global $db, $user;

940

941

$row = $this->get_module_row($module_id);

942

943

$branch = $this->get_module_branch($module_id, 'children', 'descending', false);

944

945

if (sizeof($branch))

946

{

947

return array($user->lang['CANNOT_REMOVE_MODULE']);

948

}

949

950

// If not move

951

$diff = 2;

952

$sql = 'DELETE FROM ' . MODULES_TABLE . "

953

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

954

AND module_id = $module_id";

955

$db->sql_query($sql);

956

957

$row['right_id'] = (int) $row['right_id'];

958

$row['left_id'] = (int) $row['left_id'];

959

960

// Resync tree

961

$sql = 'UPDATE ' . MODULES_TABLE . "

962

SET right_id = right_id - $diff

963

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

964

AND left_id < {$row['right_id']} AND right_id > {$row['right_id']}";

965

$db->sql_query($sql);

966

967

$sql = 'UPDATE ' . MODULES_TABLE . "

968

SET left_id = left_id - $diff, right_id = right_id - $diff

969

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

970

AND left_id > {$row['right_id']}";

971

$db->sql_query($sql);

972

973

add_log('admin', 'LOG_MODULE_REMOVED', $this->lang_name($row['module_langname']));

974

975

return array();

976

977

}

978

979

/**

980

* Move module position by $steps up/down

981

982

function move_module_by($module_row, $action = 'move_up', $steps = 1)

983

{

984

global $db;

985

986

/**

987

* Fetch all the siblings between the module's current spot

988

* and where we want to move it to. If there are less than $steps

989

* siblings between the current spot and the target then the

990

* module will move as far as possible

991

992

$sql = 'SELECT module_id, left_id, right_id, module_langname

993

FROM ' . MODULES_TABLE . "

994

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

995

AND parent_id = " . (int) $module_row['parent_id'] . '

996

AND ' . (($action == 'move_up') ? 'right_id < ' . (int) $module_row['right_id'] . ' ORDER BY right_id DESC' : 'left_id > ' . (int) $module_row['left_id'] . ' ORDER BY left_id ASC');

997

$result = $db->sql_query_limit($sql, $steps);

998

999

$target = array();

1000

while ($row = $db->sql_fetchrow($result))

1001

{

1002

$target = $row;

1003

}

1004

$db->sql_freeresult($result);

1005

1006

if (!sizeof($target))

1007

{

1008

// The module is already on top or bottom

1009

return false;

1010

}

1011

1012

/**

1013

* $left_id and $right_id define the scope of the nodes that are affected by the move.

1014

* $diff_up and $diff_down are the values to substract or add to each node's left_id

1015

* and right_id in order to move them up or down.

1016

* $move_up_left and $move_up_right define the scope of the nodes that are moving

1017

* up. Other nodes in the scope of ($left_id, $right_id) are considered to move down.

1018

1019

if ($action == 'move_up')

1020

{

1021

$left_id = (int) $target['left_id'];

1022

$right_id = (int) $module_row['right_id'];

1023

1024

$diff_up = (int) ($module_row['left_id'] - $target['left_id']);

1025

$diff_down = (int) ($module_row['right_id'] + 1 - $module_row['left_id']);

1026

1027

$move_up_left = (int) $module_row['left_id'];

1028

$move_up_right = (int) $module_row['right_id'];

1029

}

1030

else

1031

{

1032

$left_id = (int) $module_row['left_id'];

1033

$right_id = (int) $target['right_id'];

1034

1035

$diff_up = (int) ($module_row['right_id'] + 1 - $module_row['left_id']);

1036

$diff_down = (int) ($target['right_id'] - $module_row['right_id']);

1037

1038

$move_up_left = (int) ($module_row['right_id'] + 1);

1039

$move_up_right = (int) $target['right_id'];

1040

}

1041

1042

// Now do the dirty job

1043

$sql = 'UPDATE ' . MODULES_TABLE . "

1044

SET left_id = left_id + CASE

1045

WHEN left_id BETWEEN {$move_up_left} AND {$move_up_right} THEN -{$diff_up}

1046

ELSE {$diff_down}

1047

END,

1048

right_id = right_id + CASE

1049

WHEN right_id BETWEEN {$move_up_left} AND {$move_up_right} THEN -{$diff_up}

1050

ELSE {$diff_down}

1051

END

1052

WHERE module_class = '" . $db->sql_escape($this->module_class) . "'

1053

AND left_id BETWEEN {$left_id} AND {$right_id}

1054

AND right_id BETWEEN {$left_id} AND {$right_id}";

1055

$db->sql_query($sql);

1056

1057

$this->remove_cache_file();

1058

1059

return $this->lang_name($target['module_langname']);

1060

}

1061

}

1062

1063

b'\\ No newline at end of file'

Older »