PokTube (squareBracket 1.0) INSECURE

You are free to use this code, but note that you should sanitize the code first before doing anything with it. We no longer are using this source code, and have instead writen a newer and better code.

How to set PokTube up (might not be proper)

1. Get XAMPP.
2. Install Apache and MySQL from the XAMPP Control Panel.
3. Get poktube.sql from here
4. Make a database called poktube
5. Import poktube.sql to the poktube database
6. Make a folder called preload in the content folder if it does not exist.

The homer

Type these commands on your PokTube database on PHPmyAdmin, why? Because the database was updated. A fresh empty database is available.

No, this will not give access to that The Homer folder.

April 23rd 2021 database changes

Adds support for toggling between current player and old March 2021 player.

ALTER TABLE `users` ADD `player` INT NOT NULL AFTER `is_partner`; 

April 22th 2021 database changes

This adds support for reporting when the video was last viewed, this is for the frontends (eg: VidLii, 2006, etc)

ALTER TABLE `videodb` ADD `LastViewed` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `CustomThumbnail`; 

April 9th 2021 database changes

This adds support for the banning system.

ALTER TABLE `users` ADD `isBanned` BOOLEAN NOT NULL AFTER `password`; 
ALTER TABLE `users` ADD `banReason` TEXT NOT NULL AFTER `isBanned`; 
ALTER TABLE `users` ADD `bannedUntil` BIGINT UNSIGNED NOT NULL AFTER `banReason`; 

March 31st 2021 database changes

This should make reverse ordering work for members.php. it might not work, i swear. also extremely basic quickplay support

ALTER TABLE `users`
DROP PRIMARY KEY,
ADD PRIMARY KEY (`id`);
ALTER TABLE `users` CHANGE `id` `id` INT(64) NOT NULL AUTO_INCREMENT, add PRIMARY KEY (`id`); 

ALTER TABLE `users` ADD `quicklist` TEXT NOT NULL AFTER `subscriptions`; 

March 26th 2021 database changes

This adds support for subscriptions

ALTER TABLE `users` ADD `subscriptions` TEXT NOT NULL AFTER `subscribers`; 

March 19th 2021 database changes

This adds support for bulletins, as well as expanding customability for profiles.

CREATE TABLE `bulletins` ( `id` bigint(11) NOT NULL, `date` date NOT NULL, `subject` text NOT NULL, `body` text NOT NULL, `user` text NOT NULL );

ALTER TABLE `videodb` CHANGE `UploadDate` `UploadDate` DATETIME NOT NULL; 

ALTER TABLE `users` ADD `channel_inside` VARCHAR(255) NOT NULL DEFAULT '#EDF5FB' AFTER `channel_bg`;

ALTER TABLE `users` ADD `channel_text` VARCHAR(255) NOT NULL DEFAULT '#0033CC' AFTER `channel_inside`; 

March 6th 2021 database changes

This adds the length of videos.

ALTER TABLE `videodb` ADD `VideoLength` BIGINT UNSIGNED NOT NULL AFTER `HQVideoFile`;

February 22nd 2021 database changes

This adds the "Is admin" and the "Is approved" things, for the Admin Control Panel.

ALTER TABLE `users` ADD `is_admin` INT(4) NOT NULL DEFAULT '0' AFTER `is_partner`; 

ALTER TABLE `videodb` ADD `isApproved` INT(4) NOT NULL AFTER `UploadDate`; 

February 9th 2021 database changes

This adds Partner and HD Video Support. NEEDED OR ELSE UPLOADER WILL NOT WORK.

ALTER TABLE `users` ADD `is_partner` TINYINT NOT NULL AFTER `registeredon`; 

ALTER TABLE `videodb` ADD `HQVideoFile` TEXT NOT NULL AFTER `VideoFile`; 

To do

• Improve the All users page. (only some shitty internal incomplete admin control panel exists)
• Add categories