Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev
Reply
  #1  
Old 9th December 2021, 14:19
BamBam0077 BamBam0077 is offline
Banned
 
Join Date: Jul 2013
P2P
Posts: 410
Cool News script SQL update
Click the image to open in full size.-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL DEFAULT '0',
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`body` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `added` (`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `userid`, `added`, `body`) VALUES
(2, 2, '2016-11-25 10:56:02', '[align=center]Click the image to open in full size.[/align]'),
(9, 759, '2017-02-26 15:03:14', '[align=Left]Greetings [pokemon],\r\n\r\nWe have opened the doors again tell your friends, we are keeping them open for a limited time so get them in here if you like it here,\r\n\r\nthanks,\r\neBook Club[/align]\r\n<br />');

-- --------------------------------------------------------

Alter table news add `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
Alter table news add `UserID` int(10) unsigned NOT NULL,
Alter table news add `Title` varchar(255) NOT NULL,
Alter table news add `Body` text NOT NULL,
Alter table news add `Time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
Alter table news add `ThreadID` int(10) unsigned DEFAULT NULL,
Alter table news add `Important` tinyint(4) NOT NULL DEFAULT '0',

CREATE TABLE `currency_conversion_rates` (
`Currency` char(3) NOT NULL,
`Rate` decimal(9,4) DEFAULT NULL,
`Time` datetime DEFAULT NULL,
PRIMARY KEY (`Currency`)
) ENGINE=InnoDB CHARSET utf8;

CREATE TABLE `do_not_upload` (
`ID` int(10) NOT NULL AUTO_INCREMENT,
`Name` varchar(255) NOT NULL,
`Comment` varchar(255) NOT NULL,
`UserID` int(10) NOT NULL,
`Time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`Sequence` mediumint(8) NOT NULL,
PRIMARY KEY (`ID`),
KEY `Time` (`Time`)
) ENGINE=InnoDB CHARSET utf8;

-- --------------------------------------------------------

--
-- Table structure for table `funds`
--

CREATE TABLE IF NOT EXISTS `funds` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cash` decimal(8,2) NOT NULL DEFAULT '0.00',
`user` int(10) unsigned NOT NULL DEFAULT '0',
`added` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

CREATE TABLE `donations` (
`UserID` int(10) NOT NULL,
`Amount` decimal(6,2) NOT NULL,
`Email` varchar(255) NOT NULL,
`Time` datetime NOT NULL,
`Currency` varchar(5) NOT NULL DEFAULT 'USD',
`Source` varchar(30) NOT NULL DEFAULT '',
`Reason` mediumtext NOT NULL,
`Rank` int(10) DEFAULT '0',
`AddedBy` int(10) DEFAULT '0',
`TotalRank` int(10) DEFAULT '0',
KEY `UserID` (`UserID`),
KEY `Time` (`Time`),
KEY `Amount` (`Amount`)
) ENGINE=InnoDB CHARSET utf8;

CREATE TABLE `donations_bitcoin` (
`BitcoinAddress` varchar(34) NOT NULL,
`Amount` decimal(24,8) NOT NULL,
KEY `BitcoinAddress` (`BitcoinAddress`,`Amount`)
) ENGINE=InnoDB CHARSET utf8;



CREATE TABLE `blog` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`UserID` int(10) unsigned NOT NULL,
`Title` varchar(255) NOT NULL,
`Body` text NOT NULL,
`Time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ThreadID` int(10) unsigned DEFAULT NULL,
`Important` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`),
KEY `UserID` (`UserID`),
KEY `Time` (`Time`)
) ENGINE=InnoDB CHARSET utf8;


//Config.php
$tbdev["no_view_xxx_browse"] = true;
//Browse.php
If($tbdev["no_view_xxx_browse"] = true)
$query = "SELECT torrents.id, torrents.category, torrents.leechers, torrents.seeders, torrents.name, torrents.times_completed, torrents.size, torrents.added, torrents.type, torrents.comments,torrents.numfiles,torrents.filen ame,torrents.owner, torrents.no_view_xxx_browse," .
// "IF(torrents.numratings < {$TBDEV['minvotes']}, NULL, ROUND(torrents.ratingsum / torrents.numratings, 1)) AS rating, categories.name AS cat_name, categories.image AS cat_pic, users.username FROM torrents LEFT JOIN categories ON category = categories.id LEFT JOIN users ON torrents.owner = users.id $where $orderby $limit";
"categories.name AS cat_name, categories.image AS cat_pic, users.username FROM torrents LEFT JOIN categories ON category = categories.id LEFT JOIN users ON torrents.owner = users.id AND torrents.no_view_xxx_browse=users.no_view_xxx_brow se $where $orderby {$pager['limit']}";
$res = mysql_query($query) or die(mysql_error());
}
else
{
unset($res);
}
}

[IMG]
https://images2.imgbox.com/01/8f/KzBHqGAI_o.png
[/IMG]

Last edited by BamBam0077; 9th December 2021 at 15:51. Reason: https://images2.imgbox.com/01/8f/KzBHqGAI_o.png
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 22:16. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.