Forum

Cod: Selectaţi tot

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 no such table: users' in /home/rohostin/public_html/page.php:111 Stack trace: #0 /home/rohostin/public_html/page.php(111): PDO->query('SELECT user_nic...') #1 {main} thrown in /home/rohostin/public_html/page.php on line 111

Cod: Selectaţi tot

$res = mycustomdb()->query("SELECT user_nick,user_pass,id,user_plan FROM users WHERE user_nick = '".$_POST['sign-in-username']."' AND user_pass = '".str_rot13($_POST['sign-in-password'])."' LIMIT 1");
$res = $res->fetch(PDO::FETCH_ASSOC);

Cod: Selectaţi tot

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 09, 2014 at 09:09 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `webget`
--

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

--
-- Table structure for table `codes`
--

CREATE TABLE IF NOT EXISTS `codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `uid_created` int(11) NOT NULL,
  `time_used` decimal(10,0) DEFAULT '0',
  `uid_used` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Table structure for table `download_keys`
--

CREATE TABLE IF NOT EXISTS `download_keys` (
  `dl_key` varchar(32) NOT NULL DEFAULT '',
  `dl_file` varchar(100) DEFAULT NULL,
  `dl_expires` decimal(11,0) DEFAULT NULL,
  `dl_ip` varchar(15) DEFAULT NULL,
  `dl_owner` int(5) DEFAULT NULL,
  PRIMARY KEY (`dl_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `delete_id` decimal(5,0) DEFAULT NULL,
  `real_name` varchar(90) DEFAULT NULL,
  `file_name` varchar(10) DEFAULT NULL,
  `size` decimal(25,0) DEFAULT NULL,
  `upload_time` decimal(11,0) DEFAULT NULL,
  `upload_ip` varchar(15) DEFAULT NULL,
  `downloads` int(11) DEFAULT '0',
  `user_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_nick` varchar(15) DEFAULT NULL,
  `user_pass` text,
  `user_mail` varchar(40) DEFAULT NULL,
  `user_downloads` int(11) DEFAULT '0',
  `user_joined` decimal(10,0) DEFAULT NULL,
  `user_laston` decimal(10,0) DEFAULT NULL,
  `user_plan` varchar(13) DEFAULT '0',
  `user_ads` text,
  `user_ads_status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

Cod: Selectaţi tot

SELECT * 
FROM  `users` 
LIMIT 0 , 30

Cod: Selectaţi tot

1	id	int(11)	
2	user_nick	
3	user_pass
4	user_mail	varchar(40)
5	user_downloads	int(11)			
6	user_joined	decimal(10,0)				
7	user_laston	decimal(10,0)				
8	user_plan	varchar(13)		
9	user_ads	text	
10	user_ads_statu

Cod: Selectaţi tot

if(isset($_POST['sign-in-username'])) echo "SELECT user_nick,user_pass,id,user_plan FROM users WHERE user_nick = '".$_POST['sign-in-username']."' AND user_pass = '".str_rot13($_POST['sign-in-password'])."' LIMIT 1";

Cod: Selectaţi tot

// Main Website configuration:
$_CONFIG['site_name'] = www.site - Stick-ul Tau Online'; // Site Name
$_CONFIG['site_url'] = 'www.site';  // Site URL (notice: no tralining slash in the end!)
$_CONFIG['site_path']  = 'www.site';  // Website PATH (notice: no tralining slash in the end!)
$_CONFIG['admin_mail'] = 'dancrisro@yahoo.com'; // Mail used in contact us page
$_CONFIG['database'] = 'baza-de-date';  // Database file!
$_CONFIG['mysql'] = 'mysql:host=localhost;dbname=xxxxxxx';  // mysql pdo connect string change host value and dbname value!
$_CONFIG['username'] = 'Username ';  // mysql databasse username
$_CONFIG['password'] = parola';  // mysql user password
$_CONFIG['usemysql'] = false;  // use mysql? False = use pdo sqlite.

// Script Limits configuration: Download wait time
$_CONFIG['guest_wait_time']     = 60;                                           // = 60 secs default
$_CONFIG['member_wait_time']    = 45;
$_CONFIG['premiumfree_wait']    = 6;
$_CONFIG['premium_wait_time']   = 1;
// Download speeds
$_CONFIG['guest_dll']           = 85000;                                        // = 85kb/sec default
$_CONFIG['member_dll']          = 185000;
$_CONFIG['premiumfree_dll']     = 400000;
$_CONFIG['premium_dll']         = 700000;

Cod: Selectaţi tot

$_CONFIG['mysql'] = 'mysql:host=localhost;dbname=xxxxxxx';  // mysql pdo connect string change 

Cod: Selectaţi tot

$_CONFIG['site_name'] = 'www.site - Stick-ul Tau Online'; // Site Name 

Cod: Selectaţi tot

$_CONFIG['usemysql'] = true;