Show all releases

Maxx · 09-07-2005, 11:35 AM

how are you generating the page numbers ??

i dont think its that easy would like to see it ;)

Niels · 09-07-2005, 11:53 AM

Quote:

Originally Posted by Mad_Max

how are you generating the page numbers ??

i dont think its that easy would like to see it ;)

I think this should work but I'll test it out in a week

maybe redbullcola can help us out if it worked

biocore · 09-07-2005, 12:16 PM

Wow nice work Niels, i'll do some testing later too.

redbullcola · 09-07-2005, 05:01 PM

Quote:

Originally Posted by Niels

I think this should work but I'll test it out in a week

maybe redbullcola can help us out if it worked

Ok i'm maybe a NOOB :p but i'm not getting out of this:

Quote:

<?php
/*================================================= =====================*\
|| ################################################## ################## ||
|| # ---------------------------------------------------------------- # ||
|| # Copyright ©2000–2004 Jelsoft Enterprises Ltd. All Rights Reserved. ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
|| ################################################## ################## ||
\*================================================ ======================*/

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
define('GET_EDIT_TEMPLATES', true);
define('THIS_SCRIPT', 'releases');

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array();

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

// ################################################## #####################
// ######################## START MAIN SCRIPT ############################
// ################################################## #####################
if($_GET[page]){
$begin = $_GET[page] x 20; // prolly bad never did math functions ;)
$begin = $begin - 20;
$end = $_GET[page] x 20; // also bad ;)
$end = $end + 20;
$number = 1;
}
else{
$begin = "0";
$end = "20";
$number = 1;
}
$number = $number +1;
$query = $DB_site->query("
SELECT count( rlsname ) AS mirrors, rlsname
FROM `thread`
WHERE rlsname != ''
GROUP BY rlsname
ORDER BY dateline DESC LIMIT $begin,$end
");
while ($row = $DB_site->fetch_array($query)){
// Do whatever additional info you want to be displayed in here
eval('$rlsname = "' . fetch_template('rlsnamebit') . '";');
$rlsnames_here .= $rlsname;
}
// Now we have the rlses in $rlsnames_here catched including there table rows etc.
// Do whatever you want to be displayed on this page here

// draw nav bar
$navbits = array();
$navbits[''] = 'Releases posted on X!';
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');

// replace "xxxxx" with your templates name to call
eval('print_output("' . fetch_template('rlsnames') . '");');

?>

:s

EDIT: stupid me got it already

redbullcola · 09-07-2005, 05:07 PM

$begin = $_GET[page] x 20; // prolly bad never did math functions ;)

this one is baad

Parse error: parse error, unexpected T_STRING in /home/httpd/vhosts/****/httpdocs/forum1/showreleases.php on line 40

redbullcola · 09-07-2005, 05:21 PM

when changing the code:

You must first be a registered member to view any code.

i get this error

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT count( rlsname ) AS mirrors, rlsname
FROM `thread`
WHERE rlsname != ''
GROUP BY rlsname
ORDER BY dateline DESC LIMIT ,

mysql error: You have an error in your SQL syntax near '
' at line 6

mysql error number: 1064

Date: Wednesday 07th of September 2005 02:20:12 PM
Script: http://****
Referer:
Username: zotje
IP Address: 255.255.255.255

WHEN changing back:

Parse error: parse error, unexpected T_STRING in ****/httpdocs/forum1/showreleases.php on line 40

redbullcola · 09-07-2005, 05:26 PM

well i found it

ONLY no releases in there

You must first be a registered member to view any code.

something wrong on query?

Niels · 09-07-2005, 05:57 PM

Quote:

Originally Posted by redbullcola

well i found it

ONLY no releases in there

You must first be a registered member to view any code.

something wrong on query?

haha there is no query there anymore :p and also your pages snippet is imcomplete

Niels · 09-07-2005, 06:12 PM

Whoila redbullcola:

You must first be a registered member to view any code.

Works now! Some little typo's in that code

redbullcola · 09-08-2005, 03:17 AM

woooooooooooow

thx alot dude installing now and making some updates

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can i show last 10 post in site index?	asddsa	vBulletin Modification Requests	6	10-08-2005 06:33 AM
Edit thread to show as a new post	angelicGrace	vBulletin Modification Requests	1	06-08-2005 10:06 PM
show threads from subforums into The mainforum	darkitp	vBulletin Modification Requests	13	05-26-2005 12:28 PM
Location show in Paxtrax lockdown 2.7 plz..	IRES	vBulletin Modification Requests	5	12-06-2004 12:19 PM
Air & Sea Show	Ken Iovino	Off Topic	2	05-03-2004 10:06 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)