_.:=iTake=:._

this is very useful if Cpanel is messing up and u can't fix issues like this. It's important to rebuild userdata else changes won't take effect..

The cPanel accounts are created using a primary domain. All primary domains on the hosting account use “public_html” directory for all its website files and data. The sub-directories inside the public_html directory is occupied by the addon domains. The primary domain can also be setup to use a sub-directory inside public_html directory instead of public_html itself. Follow the below steps to change the document root of your primary domain in cPanel account. Please note that, you will need to have root SSH access to perform these steps. 1) Connect to your server via SSH as root user. You may follow the tutorial below, if you are using a Windows system to connect to your server via SSH. This tutorial explains how to use “Putty”, SSH client software to access server. 2) Using your favorite text editor (say vim) edit the following file. [iCODE]$ vim /cpanel/userdata/username/domain.com[/iCODE] Replace the “username” with your cPanel account username and “domain.com” with your primary domain name and “subdir” with your new directory. Find the following two lines in this file. [iCODE]documentroot: /home/username/public_html path: /home/username/public_html/cgi-bin[/iCODE] Modify these two lines to change the document root of your primary domain to a sub-directory inside “public_html” directory. [iCODE]documentroot: /home/username/public_html/subdir path: /home/username/public_html/subdir/cgi-bin[/iCODE] Save the file after changes are made and then delete the cache file for your primary domain. [iCODE]$ rm -vf /var/cpanel/userdata/username/domain.com.cache[/iCODE] 3) If the primary domain has an SSL certificate installed, edit the following file the same way as above. [iCODE]$ vim /var/cpanel/userdata/username/domain.com_SSL[/iCODE] Save the file after changes are made and then delete the cache file for your primary domain. [iCODE]$ rm -vf /var/cpanel/userdata/username/domain.com_SSL.cache[/iCODE] 4) Run the following scripts to update the user data cache and rebuild apache configuration file. [iCODE]/scripts/updateuserdatacache /scripts/rebuildhttpdconf[/iCODE] 5) Restart Apache server to load changes. [iCODE]$ service httpd restart[/iCODE] Source: [Hidden Content]

[Hidden Content] fill this form

Properly written, thanks m8..

Spammers not welcomed here

I prefer this three OpenSubtitles when I'm using PotPlayer on PC and MX player on Android I also prefer to use subscene or addic7ed when I need to download manually. Nice post thanks for sharing...

MySQL Export Table to CSV Summary: in this tutorial, you will learn various techniques of how to export a MySQL table to a CSV file. The CSV stands for comma separated values. You often use the CSV file format to exchange data between applications such as Microsoft Excel, Open Office, Google Docs, etc. It will be useful to have data from MySQL database in CSV file format because you can analyze and format the data in the way you want. MySQL provides an easy way to export the query’s result into a CSV file that resides in the database server. Before exporting data, you must ensure that: The MySQL server’s process has the write access to the target folder that contains the target CSV file. The target CSV file must not exist. The following query selects cancelled orders from the orders table: SELECT orderNumber, status, orderDate, requiredDate, comments FROM orders WHERE status = 'Cancelled'; To export this result set into a CSV file, you add some clauses to the query above as follows: SELECT orderNumber, status, orderDate, requiredDate, comments FROM orders WHERE status = 'Cancelled' INTO OUTFILE 'C:/tmp/cancelled_orders.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n'; The statement created a CSV file named cancelled_orders.csv in the C:\tmp folder that contains the result set. The CSV file contains lines of rows in the result set. Each line is terminated by a sequence of carriage return and a line feed character specified by the LINES TERMINATED BY '\r\n' clause. Each line contains values of each column of the row in the result set. Each value is enclosed by double quotation marks indicated by FIELDS ENCLOSED BY '”' clause. This prevents the value that may contain a comma (,) will be interpreted as the field separator. When enclosing the values by the double quotation marks, the commas inside the value are not recognized as the field separators. Exporting data to a CSV file whose filename contains timestamp You often need to export data into a CSV file whose name contains timestamp at which the file is created. To do so, you need to use the MySQL prepared statement. The following commands export the whole orders table into a CSV file with timestamp as a part of the file name. SET @TS = DATE_FORMAT(NOW(),'_%Y_%m_%d_%H_%i_%s'); SET @FOLDER = 'c:/tmp/'; SET @PREFIX = 'orders'; SET @EXT = '.csv'; SET @CMD = CONCAT("SELECT * FROM orders INTO OUTFILE '",@FOLDER,@PREFIX,@TS,@EXT, "' FIELDS ENCLOSED BY '\"' TERMINATED BY ';' ESCAPED BY '\"'", " LINES TERMINATED BY '\r\n';"); PREPARE statement FROM @CMD; EXECUTE statement; Let’s examine the commands above in more detail. First, we constructed a query with current timestamp as a part of the file name. Second, we prepared the statement for execution by using PREPARE statement FROM command. Third, we executed the statement by using the EXECUTE command. You can wrap the command by an event and schedule the event run periodically if needed. Exporting data with column headings It would be convenient if the CSV file contains the first line as the column headings so that the file is more understandable. To add the column headings, you need to use the UNION statement as follows: (SELECT 'Order Number','Order Date','Status') UNION (SELECT orderNumber,orderDate, status FROM orders INTO OUTFILE 'C:/tmp/orders.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n'); As the query showed, you need to include the column heading of every column. Handling NULL values In case the values in the result set contain NULL values, the target file will contain "N instead of NULL. To fix this issue, you need to replace the NULL value by another value e.g., not applicable ( N/A ) by using the IFNULL function as the following query: SELECT orderNumber, orderDate, IFNULL(shippedDate, 'N/A') FROM orders INTO OUTFILE 'C:/tmp/orders2.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n'; We replaced NULL values in the shippedDate column by the N/A strings. The CSV file shows N/A instead of NULL values. Exporting data to CSV file using MySQL Workbench In case you don’t have access to the database server to get the exported CSV file, you can use MySQL Workbench to export the result set of a query to a CSV file in your local computer as follows: First, execute a query get its result set. Second, from the result panel, click “export recordset to an external file”. The result set is also known as a recordset. Third, a new dialog displays. It asks you for a filename and file format. Enter the file name, choose CSV as the file format and click Save button. [Hidden Content] The CSV file exported by MySQL Workbench supports column headings, NULL values and other great features.

This tutorial works for almost any site thanks m8

I do remember setting up a lot of seedboxes with the script from Notos, thanks for reposting this tutorial for any one who wants to setup a seedbox

This feature will allow members to be able to edit trackers. New trackers can be added. Dead trackers or trackers causing timeouts can be removed as well. With this feature, uploaders who have more than 15 trackers will have the chance to remove additional trackers in order not to face demotions.

So we have our own imghost since last year or two but due to the fact that we had to stop that service. Here is our new image host added to Glotorrents subdomain. Visit it at [Hidden Content]

As you may all well know our notification system is by pm only. We have been planning to release one for quite sometime now but due to issues we faced on daily basis it got stalled. A new notification system is in the works and will soon be released. More updates on Notification features will be added soon.

Lets see if we can help you find this tool. I'm guessing you didn't find it on site, we will try and see if we can get the crack for you. Keep checking this thread..

We are in the process of adding a new comment system that will replace our current one. Features: Responsive design Comment editing Smilies support (images not included) Markdown support BBCode support SEO improvements Moderation options Akismet for spam detection Comment sorting Comment voting system Built in authentication system Mail notifications It will be updated in the New Features once it's ready.

Thanks for posting the updates. Finally good news for our members who couldn't post in the forums.

So this month has not been so good as we lost most of our files to due reasons I cannot disclose here at the moment. But it hasn't stopped us from getting back most and more of what we lost for now. These are the changes made in October Browsing Torrents This page has been removed until we are able to fix server load issues It will be restored as we can. All pages can now be viewed from the search page. Search Updates Frequency Torrents will not be re-indexed after 20 minutes into our search engine due to large number of uploads per minute. Incase your torrents were uploaded and you don't see them in the search page do not panic they can still be seen under your uploaded torrents page. Uploader Icons and Reputation Added On Index Page You may have noticed by now that popular torrents uploaded in the index page includes uploader names and reputation points. If you are lucky enough to find your torrents there, Congratulations. Millions of Torrents Re-indexed We managed to salvage over 6,000,000 that's more than twice the torrents we lost earlier this month. This should users or visitors to be able to get the torrents they need while we try our best to keep adding until we are sure there is nothing to add... We shall keep you informed on the rest of the updates before the end of the month.

This post will be updated soon. Thanks

We are having another unexpected maintenance today. Thank you.

We will be having a site maintenance today, so uploading functions will be disabled until Maintenance is complete. Thank you.

Reserved for additional Moderator Guidelines

Moderators must follow these guidelines on Site and Forums - The most important rule!; Use your better judgement! - Don't defy another mod in public, instead send a PM or make a post in the "Site admin". - Be tolerant! give the user(s) a chance to reform. - Don't act prematurely, Let the users make their mistake and THEN correct them. - Try correcting any "off topics" rather then closing the thread. - Move topics rather than locking / deleting them. - Be tolerant when moderating the Chit-chat section. (give them some slack) - If you lock a topic, Give a brief explanation as to why you're locking it. - Before banning a user, Send him/her a PM and If they reply, put them on a 2 week trial. - Don't ban a user until he or she has been a member for at least 4 weeks. - Always state a reason (in the user comment box) as to why the user is being banned. - If a Staff promotes someone after it has been agreed on, no other Staff should interfere without consent of Staff who granted promotion.

Forum Rules [You will get banned] - Do not post anything on this forum that is obscene, racist, hateful, nude or threatening. - Don't be rude or flame anyone here. - Don't give links to torrents outside of GloTorrents unless it's not found on Glo and is clean. - Serial numbers are only allowed by PM. - Do not argue with mods in the open forum. (Use the pm's to discuss things) - Do not post the same topic in more than one forum. Search the forum before making a topic. - Don't cuss/curse/swear except for the adult type social groups. - Avoid overusing special symbols or caps lock in thread names.

These are our General Forum Guidelines. - No aggressive behaviour or flaming in the forums. - No trashing of other peoples topics (i.e. SPAM). - No language other than English in the forums. - No bumping... (All bumped threads will be deleted.) - No double posting. If you wish to post again, and yours is the last post in the thread please use the EDIT function,instead of posting a double. - Please ensure all questions are posted in the correct section! By not doing so, the thread can be moved, merged with another topic or deleted. - Try to get into a conversation with mod /staff about problems your problems. Communication is key. - Try to help other users in every way you can. - Be creative and have fun, no duplicate threads, if you feel like what you want to create is already available please add to that thread!

============================================================================================================================== Here are the rules you need to follow if you need a dedicated forum for your release group. ℹ Must be a Verified uploader on GloTorrents. ℹ Must have more than over 200 verified torrents. ℹ Torrents must be well seeded. ℹNo warnings received within (7) days or No advertisements made in your torrent descriptions. -------------------------------------------------------------------------------------------------------------------------------------------------- These are the basic requirements. More requirements will be posted soon. Application Details: Username: eg. iTake Link to Profile: eg. [Hidden Content]=:._ Links to other places you upload (Required if you don't meet some requirements): eg. 1337x., ThePirateBay, BitScene Why your application should be approved: State your reason in a clear concise manner else it will be disapproved. ==============================================================================================================================

Open a new thread for any report. Topic Closed. Thank you