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

$query = ($query == 'INSERT') ? ' (' . implode(', ', $fields) . ') VALUES (' . implode(', ', $values) . ')' : ' (' . implode(', ', $fields) . ') SELECT ' . implode(', ', $values) . ' ';

324

}

325

else if ($query == 'MULTI_INSERT')

326

{

327

$ary = array();

328

foreach ($assoc_ary as $id => $sql_ary)

329

{

330

// If by accident the sql array is only one-dimensional we build a normal insert statement

331

if (!is_array($sql_ary))

332

{

333

return $this->sql_build_array('INSERT', $assoc_ary);

334

}

335

336

$values = array();

337

foreach ($sql_ary as $key => $var)

338

{

339

$values[] = $this->_sql_validate_value($var);

340

}

341

$ary[] = '(' . implode(', ', $values) . ')';

342

}

343

344

$query = ' (' . implode(', ', array_keys($assoc_ary[0])) . ') VALUES ' . implode(', ', $ary);

345

}

346

else if ($query == 'UPDATE' || $query == 'SELECT')

347

{

348

$values = array();

349

foreach ($assoc_ary as $key => $var)

350

{

351

$values[] = "$key = " . $this->_sql_validate_value($var);

352

}

353

$query = implode(($query == 'UPDATE') ? ', ' : ' AND ', $values);

354

}

355

356

return $query;

357

}

358

359

/**

360

* Build IN or NOT IN sql comparison string, uses <> or = on single element

361

* arrays to improve comparison speed

362

363

* @access public

364

* @param string $field name of the sql column that shall be compared

365

* @param array $array array of values that are allowed (IN) or not allowed (NOT IN)

366

* @param bool $negate true for NOT IN (), false for IN () (default)

367

* @param bool $allow_empty_set If true, allow $array to be empty, this function will return 1=1 or 1=0 then. Default to false.

368

369

function sql_in_set($field, $array, $negate = false, $allow_empty_set = false)

370

{

371

if (!sizeof($array))

372

{

373

if (!$allow_empty_set)

374

{

375

// Print the backtrace to help identifying the location of the problematic code

376

$this->sql_error('No values specified for SQL IN comparison');

377

}

378

else

379

{

380

// NOT IN () actually means everything so use a tautology

381

if ($negate)

382

{

383

return '1=1';

384

}

385

// IN () actually means nothing so use a contradiction

386

else

387

{

388

return '1=0';

389

}

390

}

391

}

392

393

if (!is_array($array))

394

{

395

$array = array($array);

396

}

397

398

if (sizeof($array) == 1)

399

{

400

@reset($array);

401

$var = current($array);

402

403

return $field . ($negate ? ' <> ' : ' = ') . $this->_sql_validate_value($var);

404

}

405

else

406

{

407

return $field . ($negate ? ' NOT IN ' : ' IN ') . '(' . implode(', ', array_map(array($this, '_sql_validate_value'), $array)) . ')';

408

}

409

}

410

411

/**

412

* Run more than one insert statement.

413

414

* @param string $table table name to run the statements on

415

* @param array &$sql_ary multi-dimensional array holding the statement data.

416

417

* @return bool false if no statements were executed.

418

* @access public

419

420

function sql_multi_insert($table, &$sql_ary)

421

{

422

if (!sizeof($sql_ary))

423

{

424

return false;

425

}

426

427

if ($this->multi_insert)

428

{

429

$this->sql_query('INSERT INTO ' . $table . ' ' . $this->sql_build_array('MULTI_INSERT', $sql_ary));

430

}

431

else

432

{

433

foreach ($sql_ary as $ary)

434

{

435

if (!is_array($ary))

436

{

437

return false;

438

}

439

440

$this->sql_query('INSERT INTO ' . $table . ' ' . $this->sql_build_array('INSERT', $ary));

441

}

442

}

443

444

return true;

445

}

446

447

/**

448

* Function for validating values

449

* @access private

450

451

function _sql_validate_value($var)

452

{

453

if (is_null($var))

454

{

455

return 'NULL';

456

}

457

else if (is_string($var))

458

{

459

return "'" . $this->sql_escape($var) . "'";

460

}

461

else

462

{

463

return (is_bool($var)) ? intval($var) : $var;

464

}

465

}

466

467

/**

468

* Build sql statement from array for select and select distinct statements

469

470

* Possible query values: SELECT, SELECT_DISTINCT

471

472

function sql_build_query($query, $array)

473

{

474

$sql = '';

475

switch ($query)

476

{

477

case 'SELECT':

478

case 'SELECT_DISTINCT';

479

480

$sql = str_replace('_', ' ', $query) . ' ' . $array['SELECT'] . ' FROM ';

481

482

$table_array = array();

483

foreach ($array['FROM'] as $table_name => $alias)

484

{

485

if (is_array($alias))

486

{

487

foreach ($alias as $multi_alias)

488

{

489

$table_array[] = $table_name . ' ' . $multi_alias;

490

}

491

}

492

else

493

{

494

$table_array[] = $table_name . ' ' . $alias;

495

}

496

}

497

498

$sql .= $this->_sql_custom_build('FROM', implode(', ', $table_array));

499

500

if (!empty($array['LEFT_JOIN']))

501

{

502

foreach ($array['LEFT_JOIN'] as $join)

503

{

504

$sql .= ' LEFT JOIN ' . key($join['FROM']) . ' ' . current($join['FROM']) . ' ON (' . $join['ON'] . ')';

505

}

506

}

507

508

if (!empty($array['WHERE']))

509

{

510

$sql .= ' WHERE ' . $this->_sql_custom_build('WHERE', $array['WHERE']);

511

}

512

513

if (!empty($array['GROUP_BY']))

514

{

515

$sql .= ' GROUP BY ' . $array['GROUP_BY'];

516

}

517

518

if (!empty($array['ORDER_BY']))

519

{

520

$sql .= ' ORDER BY ' . $array['ORDER_BY'];

521

}

522

523

break;

524

}

525

526

return $sql;

527

}

528

529

/**

530

* display sql error page

531

532

function sql_error($sql = '')

533

{

534

global $auth, $user, $config;

535

536

// Set var to retrieve errored status

537

$this->sql_error_triggered = true;

538

$this->sql_error_sql = $sql;

539

540

$error = $this->_sql_error();

541

542

if (!$this->return_on_error)

543

{

544

$message = 'SQL ERROR [ ' . $this->sql_layer . ' ]<br /><br />' . $error['message'] . ' [' . $error['code'] . ']';

545

546

// Show complete SQL error and path to administrators only

547

// Additionally show complete error on installation or if extended debug mode is enabled

548

// The DEBUG_EXTRA constant is for development only!

549

if ((isset($auth) && $auth->acl_get('a_')) || defined('IN_INSTALL') || defined('DEBUG_EXTRA'))

550

{

551

// Print out a nice backtrace...

552

$backtrace = get_backtrace();

553

554

$message .= ($sql) ? '<br /><br />SQL<br /><br />' . htmlspecialchars($sql) : '';

555

$message .= ($backtrace) ? '<br /><br />BACKTRACE<br />' . $backtrace : '';

556

$message .= '<br />';

557

}

558

else

559

{

560

// If error occurs in initiating the session we need to use a pre-defined language string

561

// This could happen if the connection could not be established for example (then we are not able to grab the default language)

562

if (!isset($user->lang['SQL_ERROR_OCCURRED']))

563

{

564

$message .= '<br /><br />An sql error occurred while fetching this page. Please contact an administrator if this problem persists.';

565

}

566

else

567

{

568

if (!empty($config['board_contact']))

569

{

570

$message .= '<br /><br />' . sprintf($user->lang['SQL_ERROR_OCCURRED'], '<a href="mailto:' . htmlspecialchars($config['board_contact']) . '">', '</a>');

571

}

572

else

573

{

574

$message .= '<br /><br />' . sprintf($user->lang['SQL_ERROR_OCCURRED'], '', '');

575

}

576

}

577

}

578

579

if ($this->transaction)

580

{

581

$this->sql_transaction('rollback');

582

}

583

584

if (strlen($message) > 1024)

585

{

586

// We need to define $msg_long_text here to circumvent text stripping.

587

global $msg_long_text;

588

$msg_long_text = $message;

589

590

trigger_error(false, E_USER_ERROR);

591

}

592

593

trigger_error($message, E_USER_ERROR);

594

}

595

596

if ($this->transaction)

597

{

598

$this->sql_transaction('rollback');

599

}

600

601

return $error;

602

}

603

604

/**

605

* Explain queries

606

607

function sql_report($mode, $query = '')

608

{

609

global $cache, $starttime, $phpbb_root_path, $user;

610

611

if (empty($_REQUEST['explain']))

612

{

613

return false;

614

}

615

616

if (!$query && $this->query_hold != '')

617

{

618

$query = $this->query_hold;

619

}

620

621

switch ($mode)

622

{

623

case 'display':

624

if (!empty($cache))

625

{

626

$cache->unload();

627

}

628

$this->sql_close();

629

630

$mtime = explode(' ', microtime());

631

$totaltime = $mtime[0] + $mtime[1] - $starttime;

632

633

echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

634

635

<head>

636

637

638

639

<title>SQL Report</title>

640

641

</head>

642

643

644

645

<a href="' . build_url('explain') . '">Return to previous page</a>

646

</div>

647

648

649

650

651

652

<h1>SQL Report</h1>

653

<br />

654

<p><b>Page generated in ' . round($totaltime, 4) . " seconds with {$this->num_queries['normal']} queries" . (($this->num_queries['cached']) ? " + {$this->num_queries['cached']} " . (($this->num_queries['cached'] == 1) ? 'query' : 'queries') . ' returning data from cache' : '') . '</b></p>

655

656

<p>Time spent on ' . $this->sql_layer . ' queries: <b>' . round($this->sql_time, 5) . 's</b> | Time spent on PHP: <b>' . round($totaltime - $this->sql_time, 5) . 's</b></p>

657

658

659

' . $this->sql_report . '

660

</div>

661

662

</div>

663

</div>

664

</div>

665

666

667

</div>

668

</div>

669

</body>

670

</html>';

671

672

exit_handler();

673

674

break;

675

676

case 'stop':

677

$endtime = explode(' ', microtime());

678

$endtime = $endtime[0] + $endtime[1];

679

680

$this->sql_report .= '

681

682

683

<thead>

684

<tr>

685

<th>Query #' . $this->num_queries['total'] . '</th>

686

</tr>

687

</thead>

688

<tbody>

689

<tr>

690

<td class="row3"><textarea style="font-family:\'Courier New\',monospace;width:99%" rows="5" cols="10">' . preg_replace('/\t(AND|OR)(\W)/', "\$1\$2", htmlspecialchars(preg_replace('/[\s]*[\n\r\t]+[\n\r\s\t]*/', "\n", $query))) . '</textarea></td>

691

</tr>

692

</tbody>

693

</table>

694

695

' . $this->html_hold . '

696

697

698

699

700

if ($this->query_result)

701

{

702

if (preg_match('/^(UPDATE|DELETE|REPLACE)/', $query))

703

{

704

$this->sql_report .= 'Affected rows: <b>' . $this->sql_affectedrows($this->query_result) . '</b> | ';

705

}

706

$this->sql_report .= 'Before: ' . sprintf('%.5f', $this->curtime - $starttime) . 's | After: ' . sprintf('%.5f', $endtime - $starttime) . 's | Elapsed: <b>' . sprintf('%.5f', $endtime - $this->curtime) . 's</b>';

707

}

708

else

709

{

710

$error = $this->sql_error();

711

$this->sql_report .= '<b style="color: red">FAILED</b> - ' . $this->sql_layer . ' Error ' . $error['code'] . ': ' . htmlspecialchars($error['message']);

712

}

713

714

$this->sql_report .= '</p><br /><br />';

715

716

$this->sql_time += $endtime - $this->curtime;

717

break;

718

719

case 'start':

720

$this->query_hold = $query;

721

$this->html_hold = '';

722

723

$this->_sql_report($mode, $query);

724

725

$this->curtime = explode(' ', microtime());

726

$this->curtime = $this->curtime[0] + $this->curtime[1];

727

728

break;

729

730

case 'add_select_row':

731

732

$html_table = func_get_arg(2);

733

$row = func_get_arg(3);

734

735

if (!$html_table && sizeof($row))

736

{

737

$html_table = true;

738

$this->html_hold .= '<table cellspacing="1"><tr>';

739

740

foreach (array_keys($row) as $val)

741

{

742

$this->html_hold .= '<th>' . (($val) ? ucwords(str_replace('_', ' ', $val)) : ' ') . '</th>';

743

}

744

$this->html_hold .= '</tr>';

745

}

746

$this->html_hold .= '<tr>';

747

748

$class = 'row1';

749

foreach (array_values($row) as $val)

750

{

751

$class = ($class == 'row1') ? 'row2' : 'row1';

752

$this->html_hold .= '<td class="' . $class . '">' . (($val) ? $val : ' ') . '</td>';

753

}

754

$this->html_hold .= '</tr>';

755

756

return $html_table;

757

758

break;

759

760

case 'fromcache':

761

762

$this->_sql_report($mode, $query);

763

764

break;

765

766

case 'record_fromcache':

767

768

$endtime = func_get_arg(2);

769

$splittime = func_get_arg(3);

770

771

$time_cache = $endtime - $this->curtime;

772

$time_db = $splittime - $endtime;

773

$color = ($time_db > $time_cache) ? 'green' : 'red';

774

775

$this->sql_report .= '<table cellspacing="1"><thead><tr><th>Query results obtained from the cache</th></tr></thead><tbody><tr>';

776

$this->sql_report .= '<td class="row3"><textarea style="font-family:\'Courier New\',monospace;width:99%" rows="5" cols="10">' . preg_replace('/\t(AND|OR)(\W)/', "\$1\$2", htmlspecialchars(preg_replace('/[\s]*[\n\r\t]+[\n\r\s\t]*/', "\n", $query))) . '</textarea></td></tr></tbody></table>';

777

$this->sql_report .= '<p style="text-align: center;">';

778

$this->sql_report .= 'Before: ' . sprintf('%.5f', $this->curtime - $starttime) . 's | After: ' . sprintf('%.5f', $endtime - $starttime) . 's | Elapsed [cache]: <b style="color: ' . $color . '">' . sprintf('%.5f', ($time_cache)) . 's</b> | Elapsed [db]: <b>' . sprintf('%.5f', $time_db) . 's</b></p><br /><br />';

779

780

// Pad the start time to not interfere with page timing

781

$starttime += $time_db;

782

783

break;

784

785

default:

786

787

$this->_sql_report($mode, $query);

788

789

break;

790

}

791

792

return true;

793

}

794

}

795

796

/**

797

* This variable holds the class name to use later

798

799

$sql_db = (!empty($dbms)) ? 'dbal_' . basename($dbms) : 'dbal';

800

801

b'\\ No newline at end of file'

Older »