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

$success_msg = $l_prefix . ((sizeof($ids) == 1) ? '' : 'S') . '_' . (($action == 'lock' || $action == 'lock_post') ? 'LOCKED' : 'UNLOCKED') . '_SUCCESS';

262

}

263

else

264

{

265

confirm_box(false, strtoupper($action) . '_' . $l_prefix . ((sizeof($ids) == 1) ? '' : 'S'), $s_hidden_fields);

266

}

267

268

$redirect = request_var('redirect', "index.$phpEx");

269

$redirect = reapply_sid($redirect);

270

271

if (!$success_msg)

272

{

273

redirect($redirect);

274

}

275

else

276

{

277

meta_refresh(2, $redirect);

278

trigger_error($user->lang[$success_msg] . ' ' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));

279

}

280

}

281

282

/**

283

* Change Topic Type

284

285

function change_topic_type($action, $topic_ids)

286

{

287

global $auth, $user, $db, $phpEx, $phpbb_root_path;

288

289

// For changing topic types, we only allow operations in one forum.

290

$forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('f_announce', 'f_sticky', 'm_'), true);

291

292

if ($forum_id === false)

293

{

294

return;

295

}

296

297

switch ($action)

298

{

299

case 'make_announce':

300

$new_topic_type = POST_ANNOUNCE;

301

$check_acl = 'f_announce';

302

$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_ANNOUNCEMENT' : 'MCP_MAKE_ANNOUNCEMENTS';

303

break;

304

305

case 'make_global':

306

$new_topic_type = POST_GLOBAL;

307

$check_acl = 'f_announce';

308

$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_GLOBAL' : 'MCP_MAKE_GLOBALS';

309

break;

310

311

case 'make_sticky':

312

$new_topic_type = POST_STICKY;

313

$check_acl = 'f_sticky';

314

$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_STICKY' : 'MCP_MAKE_STICKIES';

315

break;

316

317

default:

318

$new_topic_type = POST_NORMAL;

319

$check_acl = '';

320

$l_new_type = (sizeof($topic_ids) == 1) ? 'MCP_MAKE_NORMAL' : 'MCP_MAKE_NORMALS';

321

break;

322

}

323

324

$redirect = request_var('redirect', build_url(array('_f_', 'action', 'quickmod')));

325

326

$s_hidden_fields = array(

327

'topic_id_list' => $topic_ids,

328

'f' => $forum_id,

329

'action' => $action,

330

'redirect' => $redirect,

331

);

332

$success_msg = '';

333

334

if (confirm_box(true))

335

{

336

if ($new_topic_type != POST_GLOBAL)

337

{

338

$sql = 'UPDATE ' . TOPICS_TABLE . "

339

SET topic_type = $new_topic_type

340

WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

341

AND forum_id <> 0';

342

$db->sql_query($sql);

343

344

// Reset forum id if a global topic is within the array

345

$to_forum_id = request_var('to_forum_id', 0);

346

347

if ($to_forum_id)

348

{

349

$sql = 'UPDATE ' . TOPICS_TABLE . "

350

SET topic_type = $new_topic_type, forum_id = $to_forum_id

351

WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

352

AND forum_id = 0';

353

$db->sql_query($sql);

354

355

// Update forum_ids for all posts

356

$sql = 'UPDATE ' . POSTS_TABLE . "

357

SET forum_id = $to_forum_id

358

WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '

359

AND forum_id = 0';

360

$db->sql_query($sql);

361

362

// Do a little forum sync stuff

363

$sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

364

FROM ' . TOPICS_TABLE . ' t

365

WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

366

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

367

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

368

$db->sql_freeresult($result);

369

370

$sync_sql = array();

371

372

if ($row_data['topic_posts'])

373

{

374

$sync_sql[$to_forum_id][] = 'forum_posts = forum_posts + ' . (int) $row_data['topic_posts'];

375

}

376

377

if ($row_data['topics_authed'])

378

{

379

$sync_sql[$to_forum_id][] = 'forum_topics = forum_topics + ' . (int) $row_data['topics_authed'];

380

}

381

382

$sync_sql[$to_forum_id][] = 'forum_topics_real = forum_topics_real + ' . (int) sizeof($topic_ids);

383

384

foreach ($sync_sql as $forum_id_key => $array)

385

{

386

$sql = 'UPDATE ' . FORUMS_TABLE . '

387

SET ' . implode(', ', $array) . '

388

WHERE forum_id = ' . $forum_id_key;

389

$db->sql_query($sql);

390

}

391

392

sync('forum', 'forum_id', $to_forum_id);

393

}

394

}

395

else

396

{

397

// Get away with those topics already being a global announcement by re-calculating $topic_ids

398

$sql = 'SELECT topic_id

399

FROM ' . TOPICS_TABLE . '

400

WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

401

AND forum_id <> 0';

402

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

403

404

$topic_ids = array();

405

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

406

{

407

$topic_ids[] = $row['topic_id'];

408

}

409

$db->sql_freeresult($result);

410

411

if (sizeof($topic_ids))

412

{

413

// Delete topic shadows for global announcements

414

$sql = 'DELETE FROM ' . TOPICS_TABLE . '

415

WHERE ' . $db->sql_in_set('topic_moved_id', $topic_ids);

416

$db->sql_query($sql);

417

418

$sql = 'UPDATE ' . TOPICS_TABLE . "

419

SET topic_type = $new_topic_type, forum_id = 0

420

WHERE " . $db->sql_in_set('topic_id', $topic_ids);

421

$db->sql_query($sql);

422

423

// Update forum_ids for all posts

424

$sql = 'UPDATE ' . POSTS_TABLE . '

425

SET forum_id = 0

426

WHERE ' . $db->sql_in_set('topic_id', $topic_ids);

427

$db->sql_query($sql);

428

429

// Do a little forum sync stuff

430

$sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts, COUNT(t.topic_approved) as topics_authed

431

FROM ' . TOPICS_TABLE . ' t

432

WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

433

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

434

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

435

$db->sql_freeresult($result);

436

437

$sync_sql = array();

438

439

if ($row_data['topic_posts'])

440

{

441

$sync_sql[$forum_id][] = 'forum_posts = forum_posts - ' . (int) $row_data['topic_posts'];

442

}

443

444

if ($row_data['topics_authed'])

445

{

446

$sync_sql[$forum_id][] = 'forum_topics = forum_topics - ' . (int) $row_data['topics_authed'];

447

}

448

449

$sync_sql[$forum_id][] = 'forum_topics_real = forum_topics_real - ' . (int) sizeof($topic_ids);

450

451

foreach ($sync_sql as $forum_id_key => $array)

452

{

453

$sql = 'UPDATE ' . FORUMS_TABLE . '

454

SET ' . implode(', ', $array) . '

455

WHERE forum_id = ' . $forum_id_key;

456

$db->sql_query($sql);

457

}

458

459

sync('forum', 'forum_id', $forum_id);

460

}

461

}

462

463

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_TYPE_CHANGED' : 'TOPICS_TYPE_CHANGED';

464

465

if (sizeof($topic_ids))

466

{

467

$data = get_topic_data($topic_ids);

468

469

foreach ($data as $topic_id => $row)

470

{

471

add_log('mod', $forum_id, $topic_id, 'LOG_TOPIC_TYPE_CHANGED', $row['topic_title']);

472

}

473

}

474

}

475

else

476

{

477

// Global topic involved?

478

$global_involved = false;

479

480

if ($new_topic_type != POST_GLOBAL)

481

{

482

$sql = 'SELECT forum_id

483

FROM ' . TOPICS_TABLE . '

484

WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '

485

AND forum_id = 0';

486

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

487

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

488

$db->sql_freeresult($result);

489

490

if ($row)

491

{

492

$global_involved = true;

493

}

494

}

495

496

if ($global_involved)

497

{

498

global $template;

499

500

$template->assign_vars(array(

501

'S_FORUM_SELECT' => make_forum_select(request_var('f', $forum_id), false, false, true, true),

502

'S_CAN_LEAVE_SHADOW' => false,

503

'ADDITIONAL_MSG' => (sizeof($topic_ids) == 1) ? $user->lang['SELECT_FORUM_GLOBAL_ANNOUNCEMENT'] : $user->lang['SELECT_FORUM_GLOBAL_ANNOUNCEMENTS'])

504

);

505

506

confirm_box(false, $l_new_type, build_hidden_fields($s_hidden_fields), 'mcp_move.html');

507

}

508

else

509

{

510

confirm_box(false, $l_new_type, build_hidden_fields($s_hidden_fields));

511

}

512

}

513

514

$redirect = request_var('redirect', "index.$phpEx");

515

$redirect = reapply_sid($redirect);

516

517

if (!$success_msg)

518

{

519

redirect($redirect);

520

}

521

else

522

{

523

meta_refresh(2, $redirect);

524

trigger_error($user->lang[$success_msg] . ' ' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>'));

525

}

526

}

527

528

/**

529

* Move Topic

530

531

function mcp_move_topic($topic_ids)

532

{

533

global $auth, $user, $db, $template;

534

global $phpEx, $phpbb_root_path;

535

536

// Here we limit the operation to one forum only

537

$forum_id = check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_move'), true);

538

539

if ($forum_id === false)

540

{

541

return;

542

}

543

544

$to_forum_id = request_var('to_forum_id', 0);

545

$redirect = request_var('redirect', build_url(array('_f_', 'action', 'quickmod')));

546

$additional_msg = $success_msg = '';

547

548

$s_hidden_fields = build_hidden_fields(array(

549

'topic_id_list' => $topic_ids,

550

'f' => $forum_id,

551

'action' => 'move',

552

'redirect' => $redirect)

553

);

554

555

if ($to_forum_id)

556

{

557

$forum_data = get_forum_data($to_forum_id);

558

559

if (!sizeof($forum_data))

560

{

561

$additional_msg = $user->lang['FORUM_NOT_EXIST'];

562

}

563

else

564

{

565

$forum_data = $forum_data[$to_forum_id];

566

567

if ($forum_data['forum_type'] != FORUM_POST)

568

{

569

$additional_msg = $user->lang['FORUM_NOT_POSTABLE'];

570

}

571

else if (!$auth->acl_get('f_post', $to_forum_id))

572

{

573

$additional_msg = $user->lang['USER_CANNOT_POST'];

574

}

575

else if ($forum_id == $to_forum_id)

576

{

577

$additional_msg = $user->lang['CANNOT_MOVE_SAME_FORUM'];

578

}

579

}

580

}

581

else if (isset($_POST['confirm']))

582

{

583

$additional_msg = $user->lang['FORUM_NOT_EXIST'];

584

}

585

586

if (!$to_forum_id || $additional_msg)

587

{

588

unset($_POST['confirm']);

589

unset($_REQUEST['confirm_key']);

590

}

591

592

if (confirm_box(true))

593

{

594

$topic_data = get_topic_data($topic_ids);

595

$leave_shadow = (isset($_POST['move_leave_shadow'])) ? true : false;

596

597

$topics_moved = sizeof($topic_ids);

598

$topics_authed_moved = 0;

599

$forum_sync_data = array();

600

601

$forum_sync_data[$forum_id] = current($topic_data);

602

$forum_sync_data[$to_forum_id] = $forum_data;

603

604

foreach ($topic_data as $topic_id => $topic_info)

605

{

606

if ($topic_info['topic_approved'] == '1')

607

{

608

$topics_authed_moved++;

609

}

610

}

611

612

$db->sql_transaction('begin');

613

614

$sql = 'SELECT SUM(t.topic_replies + t.topic_approved) as topic_posts

615

FROM ' . TOPICS_TABLE . ' t

616

WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);

617

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

618

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

619

$db->sql_freeresult($result);

620

621

$sync_sql = array();

622

623

if ($row_data['topic_posts'])

624

{

625

$sync_sql[$forum_id][] = 'forum_posts = forum_posts - ' . (int) $row_data['topic_posts'];

626

$sync_sql[$to_forum_id][] = 'forum_posts = forum_posts + ' . (int) $row_data['topic_posts'];

627

}

628

629

if ($topics_authed_moved)

630

{

631

$sync_sql[$to_forum_id][] = 'forum_topics = forum_topics + ' . (int) $topics_authed_moved;

632

}

633

634

$sync_sql[$to_forum_id][] = 'forum_topics_real = forum_topics_real + ' . (int) $topics_moved;

635

636

// Move topics, but do not resync yet

637

move_topics($topic_ids, $to_forum_id, false);

638

639

$forum_ids = array($to_forum_id);

640

foreach ($topic_data as $topic_id => $row)

641

{

642

// Get the list of forums to resync, add a log entry

643

$forum_ids[] = $row['forum_id'];

644

add_log('mod', $to_forum_id, $topic_id, 'LOG_MOVE', $row['forum_name']);

645

646

// If we have moved a global announcement, we need to correct the topic type

647

if ($row['topic_type'] == POST_GLOBAL)

648

{

649

$sql = 'UPDATE ' . TOPICS_TABLE . '

650

SET topic_type = ' . POST_ANNOUNCE . '

651

WHERE topic_id = ' . (int) $row['topic_id'];

652

$db->sql_query($sql);

653

}

654

655

// Leave a redirection if required and only if the topic is visible to users

656

if ($leave_shadow && $row['topic_approved'] && $row['topic_type'] != POST_GLOBAL)

657

{

658

$shadow = array(

659

'forum_id' => (int) $row['forum_id'],

660

'icon_id' => (int) $row['icon_id'],

661

'topic_attachment' => (int) $row['topic_attachment'],

662

'topic_approved' => 1,

663

'topic_reported' => (int) $row['topic_reported'],

664

'topic_title' => (string) $row['topic_title'],

665

'topic_poster' => (int) $row['topic_poster'],

666

'topic_time' => (int) $row['topic_time'],

667

'topic_time_limit' => (int) $row['topic_time_limit'],

668

'topic_views' => (int) $row['topic_views'],

669

'topic_replies' => (int) $row['topic_replies'],

670

'topic_replies_real' => (int) $row['topic_replies_real'],

671

'topic_status' => ITEM_MOVED,

672

'topic_type' => POST_NORMAL,

673

'topic_first_post_id' => (int) $row['topic_first_post_id'],

674

'topic_first_poster_colour'=>(string) $row['topic_first_poster_colour'],

675

'topic_first_poster_name'=> (string) $row['topic_first_poster_name'],

676

'topic_last_post_id' => (int) $row['topic_last_post_id'],

677

'topic_last_poster_id' => (int) $row['topic_last_poster_id'],

678

'topic_last_poster_colour'=>(string) $row['topic_last_poster_colour'],

679

'topic_last_poster_name'=> (string) $row['topic_last_poster_name'],

680

'topic_last_post_subject'=> (string) $row['topic_last_post_subject'],

681

'topic_last_post_time' => (int) $row['topic_last_post_time'],

682

'topic_last_view_time' => (int) $row['topic_last_view_time'],

683

'topic_moved_id' => (int) $row['topic_id'],

684

'topic_bumped' => (int) $row['topic_bumped'],

685

'topic_bumper' => (int) $row['topic_bumper'],

686

'poll_title' => (string) $row['poll_title'],

687

'poll_start' => (int) $row['poll_start'],

688

'poll_length' => (int) $row['poll_length'],

689

'poll_max_options' => (int) $row['poll_max_options'],

690

'poll_last_vote' => (int) $row['poll_last_vote']

691

);

692

693

$db->sql_query('INSERT INTO ' . TOPICS_TABLE . $db->sql_build_array('INSERT', $shadow));

694

695

$topics_authed_moved--;

696

$topics_moved--;

697

}

698

}

699

unset($topic_data);

700

701

$sync_sql[$forum_id][] = 'forum_topics_real = forum_topics_real - ' . (int) $topics_moved;

702

703

if ($topics_authed_moved)

704

{

705

$sync_sql[$forum_id][] = 'forum_topics = forum_topics - ' . (int) $topics_authed_moved;

706

}

707

708

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_MOVED_SUCCESS' : 'TOPICS_MOVED_SUCCESS';

709

710

foreach ($sync_sql as $forum_id_key => $array)

711

{

712

$sql = 'UPDATE ' . FORUMS_TABLE . '

713

SET ' . implode(', ', $array) . '

714

WHERE forum_id = ' . $forum_id_key;

715

$db->sql_query($sql);

716

}

717

718

$db->sql_transaction('commit');

719

720

sync('forum', 'forum_id', array($forum_id, $to_forum_id));

721

}

722

else

723

{

724

$template->assign_vars(array(

725

'S_FORUM_SELECT' => make_forum_select($to_forum_id, $forum_id, false, true, true, true),

726

'S_CAN_LEAVE_SHADOW' => true,

727

'ADDITIONAL_MSG' => $additional_msg)

728

);

729

730

confirm_box(false, 'MOVE_TOPIC' . ((sizeof($topic_ids) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_move.html');

731

}

732

733

$redirect = request_var('redirect', "index.$phpEx");

734

$redirect = reapply_sid($redirect);

735

736

if (!$success_msg)

737

{

738

redirect($redirect);

739

}

740

else

741

{

742

meta_refresh(3, $redirect);

743

744

$message = $user->lang[$success_msg];

745

$message .= ' ' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>');

746

$message .= ' ' . sprintf($user->lang['RETURN_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$forum_id") . '">', '</a>');

747

$message .= ' ' . sprintf($user->lang['RETURN_NEW_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", "f=$to_forum_id") . '">', '</a>');

748

749

trigger_error($message);

750

}

751

}

752

753

/**

754

* Delete Topics

755

756

function mcp_delete_topic($topic_ids)

757

{

758

global $auth, $user, $db, $phpEx, $phpbb_root_path;

759

760

if (!check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_delete')))

761

{

762

return;

763

}

764

765

$redirect = request_var('redirect', build_url(array('_f_', 'action', 'quickmod')));

766

$forum_id = request_var('f', 0);

767

768

$s_hidden_fields = build_hidden_fields(array(

769

'topic_id_list' => $topic_ids,

770

'f' => $forum_id,

771

'action' => 'delete_topic',

772

'redirect' => $redirect)

773

);

774

$success_msg = '';

775

776

if (confirm_box(true))

777

{

778

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_DELETED_SUCCESS' : 'TOPICS_DELETED_SUCCESS';

779

780

$data = get_topic_data($topic_ids);

781

782

foreach ($data as $topic_id => $row)

783

{

784

add_log('mod', $row['forum_id'], 0, 'LOG_TOPIC_DELETED', $row['topic_title']);

785

}

786

787

$return = delete_topics('topic_id', $topic_ids);

788

}

789

else

790

{

791

confirm_box(false, (sizeof($topic_ids) == 1) ? 'DELETE_TOPIC' : 'DELETE_TOPICS', $s_hidden_fields);

792

}

793

794

$redirect = request_var('redirect', "index.$phpEx");

795

$redirect = reapply_sid($redirect);

796

797

if (!$success_msg)

798

{

799

redirect($redirect);

800

}

801

else

802

{

803

$redirect_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);

804

meta_refresh(3, $redirect_url);

805

trigger_error($user->lang[$success_msg] . ' ' . sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect_url . '">', '</a>'));

806

}

807

}

808

809

/**

810

* Delete Posts

811

812

function mcp_delete_post($post_ids)

813

{

814

global $auth, $user, $db, $phpEx, $phpbb_root_path;

815

816

if (!check_ids($post_ids, POSTS_TABLE, 'post_id', array('m_delete')))

817

{

818

return;

819

}

820

821

$redirect = request_var('redirect', build_url(array('_f_', 'action', 'quickmod')));

822

$forum_id = request_var('f', 0);

823

824

$s_hidden_fields = build_hidden_fields(array(

825

'post_id_list' => $post_ids,

826

'f' => $forum_id,

827

'action' => 'delete_post',

828

'redirect' => $redirect)

829

);

830

$success_msg = '';

831

832

if (confirm_box(true))

833

{

834

if (!function_exists('delete_posts'))

835

{

836

include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

837

}

838

839

// Count the number of topics that are affected

840

// I did not use COUNT(DISTINCT ...) because I remember having problems

841

// with it on older versions of MySQL -- Ashe

842

843

$sql = 'SELECT DISTINCT topic_id

844

FROM ' . POSTS_TABLE . '

845

WHERE ' . $db->sql_in_set('post_id', $post_ids);

846

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

847

848

$topic_id_list = array();

849

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

850

{

851

$topic_id_list[] = $row['topic_id'];

852

}

853

$affected_topics = sizeof($topic_id_list);

854

$db->sql_freeresult($result);

855

856

$post_data = get_post_data($post_ids);

857

858

foreach ($post_data as $id => $row)

859

{

860

add_log('mod', $row['forum_id'], $row['topic_id'], 'LOG_DELETE_POST', $row['post_subject']);

861

}

862

863

// Now delete the posts, topics and forums are automatically resync'ed

864

delete_posts('post_id', $post_ids);

865

866

$sql = 'SELECT COUNT(topic_id) AS topics_left

867

FROM ' . TOPICS_TABLE . '

868

WHERE ' . $db->sql_in_set('topic_id', $topic_id_list);

869

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

870

871

$deleted_topics = ($row = $db->sql_fetchrow($result)) ? ($affected_topics - $row['topics_left']) : $affected_topics;

872

$db->sql_freeresult($result);

873

874

$topic_id = request_var('t', 0);

875

876

// Return links

877

$return_link = array();

878

if ($affected_topics == 1 && !$deleted_topics && $topic_id)

879

{

880

$return_link[] = sprintf($user->lang['RETURN_TOPIC'], '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&t=$topic_id") . '">', '</a>');

881

}

882

$return_link[] = sprintf($user->lang['RETURN_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id) . '">', '</a>');

883

884

if (sizeof($post_ids) == 1)

885

{

886

if ($deleted_topics)

887

{

888

// We deleted the only post of a topic, which in turn has

889

// been removed from the database

890

$success_msg = $user->lang['TOPIC_DELETED_SUCCESS'];

891

}

892

else

893

{

894

$success_msg = $user->lang['POST_DELETED_SUCCESS'];

895

}

896

}

897

else

898

{

899

if ($deleted_topics)

900

{

901

// Some of topics disappeared

902

$success_msg = $user->lang['POSTS_DELETED_SUCCESS'] . ' ' . $user->lang['EMPTY_TOPICS_REMOVED_WARNING'];

903

}

904

else

905

{

906

$success_msg = $user->lang['POSTS_DELETED_SUCCESS'];

907

}

908

}

909

}

910

else

911

{

912

confirm_box(false, (sizeof($post_ids) == 1) ? 'DELETE_POST' : 'DELETE_POSTS', $s_hidden_fields);

913

}

914

915

$redirect = request_var('redirect', "index.$phpEx");

916

$redirect = reapply_sid($redirect);

917

918

if (!$success_msg)

919

{

920

redirect($redirect);

921

}

922

else

923

{

924

meta_refresh(3, $redirect);

925

trigger_error($success_msg . ' ' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $redirect . '">', '</a>') . ' ' . implode(' ', $return_link));

926

}

927

}

928

929

/**

930

* Fork Topic

931

932

function mcp_fork_topic($topic_ids)

933

{

934

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

935

global $phpEx, $phpbb_root_path;

936

937

if (!check_ids($topic_ids, TOPICS_TABLE, 'topic_id', array('m_')))

938

{

939

return;

940

}

941

942

$to_forum_id = request_var('to_forum_id', 0);

943

$forum_id = request_var('f', 0);

944

$redirect = request_var('redirect', build_url(array('_f_', 'action', 'quickmod')));

945

$additional_msg = $success_msg = '';

946

947

$s_hidden_fields = build_hidden_fields(array(

948

'topic_id_list' => $topic_ids,

949

'f' => $forum_id,

950

'action' => 'fork',

951

'redirect' => $redirect)

952

);

953

954

if ($to_forum_id)

955

{

956

$forum_data = get_forum_data($to_forum_id);

957

958

if (!sizeof($topic_ids))

959

{

960

$additional_msg = $user->lang['NO_TOPIC_SELECTED'];

961

}

962

else if (!sizeof($forum_data))

963

{

964

$additional_msg = $user->lang['FORUM_NOT_EXIST'];

965

}

966

else

967

{

968

$forum_data = $forum_data[$to_forum_id];

969

970

if ($forum_data['forum_type'] != FORUM_POST)

971

{

972

$additional_msg = $user->lang['FORUM_NOT_POSTABLE'];

973

}

974

else if (!$auth->acl_get('f_post', $to_forum_id))

975

{

976

$additional_msg = $user->lang['USER_CANNOT_POST'];

977

}

978

}

979

}

980

else if (isset($_POST['confirm']))

981

{

982

$additional_msg = $user->lang['FORUM_NOT_EXIST'];

983

}

984

985

if ($additional_msg)

986

{

987

unset($_POST['confirm']);

988

unset($_REQUEST['confirm_key']);

989

}

990

991

if (confirm_box(true))

992

{

993

$topic_data = get_topic_data($topic_ids);

994

995

$total_posts = 0;

996

$new_topic_id_list = array();

997

998

foreach ($topic_data as $topic_id => $topic_row)

999

{

1000

$sql_ary = array(

1001

'forum_id' => (int) $to_forum_id,

1002

'icon_id' => (int) $topic_row['icon_id'],

1003

'topic_attachment' => (int) $topic_row['topic_attachment'],

1004

'topic_approved' => 1,

1005

'topic_reported' => 0,

1006

'topic_title' => (string) $topic_row['topic_title'],

1007

'topic_poster' => (int) $topic_row['topic_poster'],

1008

'topic_time' => (int) $topic_row['topic_time'],

1009

'topic_replies' => (int) $topic_row['topic_replies_real'],

1010

'topic_replies_real' => (int) $topic_row['topic_replies_real'],

1011

'topic_status' => (int) $topic_row['topic_status'],

1012

'topic_type' => (int) $topic_row['topic_type'],

1013

'topic_first_poster_name' => (string) $topic_row['topic_first_poster_name'],

1014

'topic_last_poster_id' => (int) $topic_row['topic_last_poster_id'],

1015

'topic_last_poster_name' => (string) $topic_row['topic_last_poster_name'],

1016

'topic_last_post_time' => (int) $topic_row['topic_last_post_time'],

1017

'topic_last_view_time' => (int) $topic_row['topic_last_view_time'],

1018

'topic_bumped' => (int) $topic_row['topic_bumped'],

1019

'topic_bumper' => (int) $topic_row['topic_bumper'],

1020

'poll_title' => (string) $topic_row['poll_title'],

1021

'poll_start' => (int) $topic_row['poll_start'],

1022

'poll_length' => (int) $topic_row['poll_length']

1023

);

1024

1025

$db->sql_query('INSERT INTO ' . TOPICS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

1026

$new_topic_id = $db->sql_nextid();

1027

$new_topic_id_list[$topic_id] = $new_topic_id;

1028

1029

if ($topic_row['poll_start'])

1030

{

1031

$poll_rows = array();

1032

1033

$sql = 'SELECT *

1034

FROM ' . POLL_OPTIONS_TABLE . "

1035

WHERE topic_id = $topic_id";

1036

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

1037

1038

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

1039

{

1040

$sql_ary = array(

1041

'poll_option_id' => (int) $row['poll_option_id'],

1042

'topic_id' => (int) $new_topic_id,

1043

'poll_option_text' => (string) $row['poll_option_text'],

1044

'poll_option_total' => 0

1045

);

1046

1047

$db->sql_query('INSERT INTO ' . POLL_OPTIONS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

1048

}

1049

}

1050

1051

$sql = 'SELECT *

1052

FROM ' . POSTS_TABLE . "

1053

WHERE topic_id = $topic_id

1054

ORDER BY post_time ASC";

1055

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

1056

1057

$post_rows = array();

1058

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

1059

{

1060

$post_rows[] = $row;

1061

}

1062

$db->sql_freeresult($result);

1063

1064

if (!sizeof($post_rows))

1065

{

1066

continue;

1067

}

1068

1069

$total_posts += sizeof($post_rows);

1070

foreach ($post_rows as $row)

1071

{

1072

$sql_ary = array(

1073

'topic_id' => (int) $new_topic_id,

1074

'forum_id' => (int) $to_forum_id,

1075

'poster_id' => (int) $row['poster_id'],

1076

'icon_id' => (int) $row['icon_id'],

1077

'poster_ip' => (string) $row['poster_ip'],

1078

'post_time' => (int) $row['post_time'],

1079

'post_approved' => 1,

1080

'post_reported' => 0,

1081

'enable_bbcode' => (int) $row['enable_bbcode'],

1082

'enable_smilies' => (int) $row['enable_smilies'],

1083

'enable_magic_url' => (int) $row['enable_magic_url'],

1084

'enable_sig' => (int) $row['enable_sig'],

1085

'post_username' => (string) $row['post_username'],

1086

'post_subject' => (string) $row['post_subject'],

1087

'post_text' => (string) $row['post_text'],

1088

'post_edit_reason' => (string) $row['post_edit_reason'],

1089

'post_edit_user' => (int) $row['post_edit_user'],

1090

'post_checksum' => (string) $row['post_checksum'],

1091

'post_attachment' => (int) $row['post_attachment'],

1092

'bbcode_bitfield' => $row['bbcode_bitfield'],

1093

'bbcode_uid' => (string) $row['bbcode_uid'],

1094

'post_edit_time' => (int) $row['post_edit_time'],

1095

'post_edit_count' => (int) $row['post_edit_count'],

1096

'post_edit_locked' => (int) $row['post_edit_locked'],

1097

'post_postcount' => 0,

1098

);

1099

1100

$db->sql_query('INSERT INTO ' . POSTS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

1101

$new_post_id = $db->sql_nextid();

1102

1103

// Copy whether the topic is dotted

1104

markread('post', $to_forum_id, $new_topic_id, 0, $row['poster_id']);

1105

1106

// Copy Attachments

1107

if ($row['post_attachment'])

1108

{

1109

$sql = 'SELECT * FROM ' . ATTACHMENTS_TABLE . "

1110

WHERE post_msg_id = {$row['post_id']}

1111

AND topic_id = $topic_id

1112

AND in_message = 0";

1113

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

1114

1115

$sql_ary = array();

1116

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

1117

{

1118

$sql_ary[] = array(

1119

'post_msg_id' => (int) $new_post_id,

1120

'topic_id' => (int) $new_topic_id,

1121

'in_message' => 0,

1122

'is_orphan' => (int) $attach_row['is_orphan'],

1123

'poster_id' => (int) $attach_row['poster_id'],

1124

'physical_filename' => (string) basename($attach_row['physical_filename']),

1125

'real_filename' => (string) basename($attach_row['real_filename']),

1126

'download_count' => (int) $attach_row['download_count'],

1127

'attach_comment' => (string) $attach_row['attach_comment'],

1128

'extension' => (string) $attach_row['extension'],

1129

'mimetype' => (string) $attach_row['mimetype'],

1130

'filesize' => (int) $attach_row['filesize'],

1131

'filetime' => (int) $attach_row['filetime'],

1132

'thumbnail' => (int) $attach_row['thumbnail']

1133

);

1134

}

1135

$db->sql_freeresult($result);

1136

1137

if (sizeof($sql_ary))

1138

{

1139

$db->sql_multi_insert(ATTACHMENTS_TABLE, $sql_ary);

1140

}

1141

}

1142

}

1143

1144

$sql = 'SELECT user_id, notify_status

1145

FROM ' . TOPICS_WATCH_TABLE . '

1146

WHERE topic_id = ' . $topic_id;

1147

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

1148

1149

$sql_ary = array();

1150

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

1151

{

1152

$sql_ary[] = array(

1153

'topic_id' => (int) $new_topic_id,

1154

'user_id' => (int) $row['user_id'],

1155

'notify_status' => (int) $row['notify_status'],

1156

);

1157

}

1158

$db->sql_freeresult($result);

1159

1160

if (sizeof($sql_ary))

1161

{

1162

$db->sql_multi_insert(TOPICS_WATCH_TABLE, $sql_ary);

1163

}

1164

}

1165

1166

// Sync new topics, parent forums and board stats

1167

sync('topic', 'topic_id', $new_topic_id_list);

1168

1169

$sync_sql = array();

1170

1171

$sync_sql[$to_forum_id][] = 'forum_posts = forum_posts + ' . $total_posts;

1172

$sync_sql[$to_forum_id][] = 'forum_topics = forum_topics + ' . sizeof($new_topic_id_list);

1173

$sync_sql[$to_forum_id][] = 'forum_topics_real = forum_topics_real + ' . sizeof($new_topic_id_list);

1174

1175

foreach ($sync_sql as $forum_id_key => $array)

1176

{

1177

$sql = 'UPDATE ' . FORUMS_TABLE . '

1178

SET ' . implode(', ', $array) . '

1179

WHERE forum_id = ' . $forum_id_key;

1180

$db->sql_query($sql);

1181

}

1182

1183

sync('forum', 'forum_id', $to_forum_id);

1184

set_config('num_topics', $config['num_topics'] + sizeof($new_topic_id_list), true);

1185

set_config('num_posts', $config['num_posts'] + $total_posts, true);

1186

1187

foreach ($new_topic_id_list as $topic_id => $new_topic_id)

1188

{

1189

add_log('mod', $to_forum_id, $new_topic_id, 'LOG_FORK', $topic_row['forum_name']);

1190

}

1191

1192

$success_msg = (sizeof($topic_ids) == 1) ? 'TOPIC_FORKED_SUCCESS' : 'TOPICS_FORKED_SUCCESS';

1193

}

1194

else

1195

{

1196

$template->assign_vars(array(

1197

'S_FORUM_SELECT' => make_forum_select($to_forum_id, false, false, true, true, true),

1198

'S_CAN_LEAVE_SHADOW' => false,

1199

'ADDITIONAL_MSG' => $additional_msg)

1200

);

1201

1202

confirm_box(false, 'FORK_TOPIC' . ((sizeof($topic_ids) == 1) ? '' : 'S'), $s_hidden_fields, 'mcp_move.html');

1203

}

1204

1205

$redirect = request_var('redirect', "index.$phpEx");

1206

$redirect = reapply_sid($redirect);

1207

1208

if (!$success_msg)

1209

{

1210

redirect($redirect);

1211

}

1212

else

1213

{

1214

$redirect_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);

1215

meta_refresh(3, $redirect_url);

1216

$return_link = sprintf($user->lang['RETURN_FORUM'], '<a href="' . $redirect_url . '">', '</a>');

1217

1218

if ($forum_id != $to_forum_id)

1219

{

1220

$return_link .= ' ' . sprintf($user->lang['RETURN_NEW_FORUM'], '<a href="' . append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $to_forum_id) . '">', '</a>');

1221

}

1222

1223

trigger_error($user->lang[$success_msg] . ' ' . $return_link);

1224

}

1225

}

1226

1227

b'\\ No newline at end of file'

Older »