Account Management Feature [takelogin]
please add over this particular part of takelogin.php
Code:
header("Location: {$TBDEV['baseurl']}/my.php");
?>
Code:
$added=time();
$from = '62468';
//create user scenebot & id account via phpmyadmin
$to = ($row["id"]);
$sub = "Security Check";
// $msg = "SECURITY ALERT\n\n Account: ID=".$row['id']." Somebody (probably you, ".$username."!) tried to Login but Failed!"."\n\nTheir IP ADDRESS was : (".$ip." ".@gethostbyaddr($ip).")"."\n\n If this wasn't you please Report this event to a Staff \n\n - Thank you.\n";
$msg2="2";
if($from == "62468"){
$msg = "Hello , welcome to SceneKat.com,
The Administrators and Staff of SceneKat would like to welcome you to our community and we hope you have a long happy stay here.
This is an auto-generated message sent to all new users, in order to help you get started.
Please be sure before you use our tracker and start downloading to read carefully the FAQ Click Here and the RULES Click Here.
Answers to the most common problems you are likely to encounter can be found in our FAQ, please do your best to find a solution there first. If you can't resolve the problem yourself pop into our Forum or Chat Room where staff and other members will be pleased to assist you.
Although everything you need to know can be found in the FAQ, RULES, USER GUIDES etc we would like to bring a few important ones to your attention, we have set out below a few pointers to help you get your account up and running as smoothly as possible:
1. You must seed (share) in order to leech (get). You must seed for a minimum of 72 hours or 1:1 ratio. If your ratio ever drops below 0.3 you will be automatically warned by the system and after 5 days (if your ratio is still below 0.30) it will ban you.
2. We allow a wide variety of torrent clients on our site, whichever one you decide to use you MUST make sure dht, and pex are turned off, failure to do this may result in you being banned. The list of approved clients can be found in the Forums Click Here
3. To help you get started we awarded your account 10 GB, use this wisely. Check our Forums for tips on seeding/ratio building.
4. NEVER, and we mean NEVER, share your account or passkey with anyone.
5. NEVER for any reason create a duplicate account. You risk being permanently banned from the site.
6. NEVER upload any SceneKat torrent files to other sites (Public or Private). You will be immediately and automatically detected by our system and permanently banned.
7. Read up on our Hit and Run Click Here
We would like to thank you for joining our community and will endeavour to provide you with the best possible experience as we do our other members.
The SceneKat Team.";
}
$sql = "INSERT INTO messages (subject, sender, receiver, msg, added)
VALUES ('$sub', '$from', '$to', ".sqlesc($msg).", $added);";
$res = mysql_query($sql) or sqlerr(__FILE__, __LINE__);
header("Location: {$TBDEV['baseurl']}/my.php");
?>
SQL:
Code:
-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: fdb33.atspace.me
-- Generation Time: Jun 12, 2022 at 07:59 AM
-- Server version: 5.7.20-log
-- PHP Version: 5.5.38
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `4113786_scenekat`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(10) UNSIGNED NOT NULL,
`username` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
`passhash` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`secret` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`passkey` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
`status` enum('pending','confirmed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
`added` int(11) NOT NULL,
`last_login` int(11) NOT NULL,
`last_access` int(11) NOT NULL,
`editsecret` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`privacy` enum('strong','normal','low') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'normal',
`stylesheet` int(10) DEFAULT '1',
`info` text COLLATE utf8_unicode_ci,
`acceptpms` enum('yes','friends','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`class` tinyint(3) UNSIGNED NOT NULL DEFAULT '3',
`language` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
`avatar` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`av_w` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
`av_h` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
`uploaded` bigint(20) UNSIGNED NOT NULL DEFAULT '1500000000',
`downloaded` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`title` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`country` int(10) UNSIGNED NOT NULL DEFAULT '0',
`notifs` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`modcomment` text COLLATE utf8_unicode_ci NOT NULL,
`enabled` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`avatars` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`donor` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`warned` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`warneduntil` int(11) NOT NULL DEFAULT '0',
`torrentsperpage` int(3) UNSIGNED NOT NULL DEFAULT '0',
`topicsperpage` int(3) UNSIGNED NOT NULL DEFAULT '0',
`postsperpage` int(3) UNSIGNED NOT NULL DEFAULT '0',
`deletepms` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`savepms` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`reputation` int(10) NOT NULL DEFAULT '10',
`time_offset` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`dst_in_use` tinyint(1) NOT NULL DEFAULT '0',
`auto_correct_dst` tinyint(1) NOT NULL DEFAULT '1',
`show_shout` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'yes',
`chatpost` int(11) NOT NULL DEFAULT '1',
`shoutboxbg` enum('1','2','3') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '1',
`smile_until` int(10) NOT NULL DEFAULT '0',
`seedbonus` decimal(10,1) NOT NULL DEFAULT '200.0',
`bonuscomment` text COLLATE utf8_unicode_ci,
`vip_added` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`vip_until` int(10) NOT NULL DEFAULT '0',
`owners` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`admin` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`moderator` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`poweruser` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`members` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`bonuscoins` decimal(10,1) NOT NULL DEFAULT '1200.0',
`donoruntil` int(11) UNSIGNED NOT NULL DEFAULT '0',
`donerduntil` int(11) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `passhash`, `secret`, `passkey`, `email`, `status`, `added`, `last_login`, `last_access`, `editsecret`, `privacy`, `stylesheet`, `info`, `acceptpms`, `ip`, `class`, `language`, `avatar`, `av_w`, `av_h`, `uploaded`, `downloaded`, `title`, `country`, `notifs`, `modcomment`, `enabled`, `avatars`, `donor`, `warned`, `warneduntil`, `torrentsperpage`, `topicsperpage`, `postsperpage`, `deletepms`, `savepms`, `reputation`, `time_offset`, `dst_in_use`, `auto_correct_dst`, `show_shout`, `chatpost`, `shoutboxbg`, `smile_until`, `seedbonus`, `bonuscomment`, `vip_added`, `vip_until`, `owners`, `admin`, `moderator`, `poweruser`, `members`, `bonuscoins`, `donoruntil`, `donerduntil`) VALUES
(62468, 'scenebot', '', '', '', 'bot@undergroundzone.net', 'confirmed', 0, 0, 0, '', 'normal', 1, NULL, 'yes', '', 3, 'en', '', 0, 0, 1500000000, 0, '', 0, '', '', 'yes', 'yes', 'no', 'no', 0, 0, 0, 0, 'yes', 'no', 10, '0', 0, 1, 'yes', 1, '1', 0, 200.0, NULL, 'no', 0, 'no', 'no', 'no', 'no', 'yes', 1200.0, 0, 0);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `username` (`username`),
ADD KEY `ip` (`ip`),
ADD KEY `uploaded` (`uploaded`),
ADD KEY `downloaded` (`downloaded`),
ADD KEY `country` (`country`),
ADD KEY `last_access` (`last_access`),
ADD KEY `enabled` (`enabled`),
ADD KEY `warned` (`warned`),
ADD KEY `pkey` (`passkey`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62469;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|