Search for REALLY old threads / posts Post: 303029036

Sponsored Content

The Lounge What is on Your Mind? Search for REALLY old threads / posts Post 303029036 by Neo on Saturday 19th of January 2019 11:48:44 PM

01-20-2019

Administrator

Hey Rudi,

Here is the current draft PHP query for this.

Seems to fit the bill what you asked for.

Code:

<?php
if ($vbulletin->GPC['searchbyyear'] >= 2000 and $vbulletin->GPC['searchbyyear'] <= $date('Y')) {
    $max_results = 3000;
    $start_year_unixtime = $mktime(0, 0, 0, 1, 1, $vbulletin->GPC['searchbyyear']);
    $end_year_unixtime = $mktime(23, 59, 59, 12, 31, $vbulletin->GPC['searchbyyear']);
    $nl_query_limit = 'LIMIT ' .   $max_results;
    $thread_query_logic[] = "post.dateline >= " . $start_year_unixtime . " thread.dateline <= " . $end_year_unixtime;
}

This User Gave Thanks to Neo For This Post:

Neo

View Public Profile for Neo

Visit Neo's homepage!

Find all posts by Neo

We Also Found This Discussion For You

1. Post Here to Contact Site Administrators and Moderators

How do i delete threads/posts?

I cannot find the option anywhere when i click on "Edit".

LEARN ABOUT PHP

mysqli_real_query

MYSQLI_REAL_QUERY(3)							 1						      MYSQLI_REAL_QUERY(3)

mysqli::real_query - Execute an SQL query

       Object oriented style

SYNOPSIS

       bool mysqli::real_query (string	$query)

DESCRIPTION

       Procedural style
       bool mysqli_real_query (mysqli  $link, string  $query)

	Executes  a  single  query  against  the  database  whose  result  can	then  be  retrieved  or stored using the mysqli_store_result(3) or
       mysqli_use_result(3) functions.

	In order to determine if a given query should return a result set or not, see mysqli_field_count(3).

PARAMETERS

	      o $
		link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)

	      o $query
		- The query, as a string.  Data inside the query should be properly escaped.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

SEE ALSO

       mysqli_query(3), mysqli_store_result(3), mysqli_use_result(3).

PHP Documentation Group 												      MYSQLI_REAL_QUERY(3)

We Also Found This Discussion For You

1. Post Here to Contact Site Administrators and Moderators

How do i delete threads/posts?

Discussion started by: johnthebaptist

LEARN ABOUT PHP

mysqli_real_query