Youtube SQL Database

Discussion in 'MySQL' started by BBX, Dec 21, 2008.

  1. #1
    Hi,
    I am making a youtube clone site and I have uploaded it. I have even uploaded the sql database but I dont know if I am missing something with the config file or what. I need guidance. Anyone who will help me set it up can PM me and I will give my contact info!
    Regards
     
    BBX, Dec 21, 2008 IP
  2. rajib.bahar

    rajib.bahar Active Member

    Messages:
    87
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    68
    #2
    is this a mysql database or mssql database? I can help w/ MSSQL databases easily.
     
    rajib.bahar, Dec 22, 2008 IP
  3. BBX

    BBX Banned

    Messages:
    144
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Well I dont realy know the difference between them! The config file looks something like this!
    ?
    error_reporting(E_ALL & ~E_NOTICE & ~E_WARNING);
    session_start();
    $config = array();
    $config['BASE_DIR'] = 'c:\\MyWeb';
    $config['BASE_URL'] = 'http://localhost';
    $config['CONF_FILE'] = $config['BASE_DIR'].'/include/conf.ini';
    $config['IMG_DIR'] = $config['BASE_DIR'].'/images';
    $config['IMG_URL'] = $config['BASE_URL'].'/images';
    $config['VDO_DIR'] = $config['BASE_DIR'].'/video';
    $config['VDO_URL'] = $config['BASE_URL'].'/video';
    $config['ADO_DIR'] = $config['BASE_DIR'].'/audio';
    $config['ADO_URL'] = $config['BASE_URL'].'/audio';
    $config['FLVDO_DIR'] = $config['BASE_DIR'].'/flvideo';
    $config['FLVDO_URL'] = $config['BASE_URL'].'/flvideo';
    $config['TMB_DIR'] = $config['BASE_DIR'].'/thumb';
    $config['TMB_URL'] = $config['BASE_URL'].'/thumb';
    $config['baseurl'] = $config['BASE_URL'];
    $config['basedir'] = $config['BASE_DIR'];
    $config['VDO_DIR'] = $config['BASE_DIR'].'/video';
    $config['VDO_URL'] = $config['BASE_URL'].'/video';
    $config['ADO_DIR'] = $config['BASE_DIR'].'/audio';
    $config['ADO_URL'] = $config['BASE_URL'].'/audio';
    $config['FLVDO_DIR'] = $config['BASE_DIR'].'/flvideo';
    $config['FLVDO_URL'] = $config['BASE_URL'].'/flvideo';
    $config['TMB_DIR'] = $config['BASE_DIR'].'/thumb';
    $config['TMB_URL'] = $config['BASE_URL'].'/thumb';
    $config['baseurl'] = $config['BASE_URL'];
    $config['basedir'] = $config['BASE_DIR'];
    $config['vdodir'] = $config['VDO_DIR'];
    $config['vdourl'] = $config['VDO_URL'];
    $config['audiodir'] = $config['ADO_DIR'];
    $config['audiourl'] = $config['ADO_URL'];
    $config['flvdodir'] = $config['FLVDO_DIR'];
    $config['flvdourl'] = $config['FLVDO_URL'];
    $config['imgurl'] = $config['IMG_URL'];
    $config['imgpath'] = $config['IMG_DIR'];
    $config['ffmpeg'] = '/usr/bin/ffmpeg';
    $config['guest_limite'] = 200;
    $msg='';
    $err='';
    $config['rows_per_page']='';
    $config['cols_per_page']='';
    require_once($config['BASE_DIR'].'/smarty/libs/Smarty.class.php');
    require_once($config['BASE_DIR'].'/classes/mysmarty.class.php');
    require_once($config['BASE_DIR'].'/classes/SConfig.php');
    require_once($config['BASE_DIR'].'/classes/SError.php');
    require_once($config['BASE_DIR'].'/include/adodb/adodb.inc.php');
    require_once($config['BASE_DIR'].'/include/phpmailer/class.phpmailer.php');
    require_once($config['BASE_DIR'].'/classes/SEmail.php');

    $DBTYPE = 'mysql';
    $DBHOST = SConfig::get("Database", "localhost");
    $DBUSER = SConfig::get("Database", "blesseded2_anime");
    $DBPASSWORD = SConfig::get("Database", "250699444");
    $DBNAME = SConfig::get("Database", "blesseded2_animetube");

    $conn = &ADONewConnection($DBTYPE);
    $conn->PConnect($DBHOST, $DBUSER, $DBPASSWORD, $DBNAME);

    $sql = "SELECT * from sconfig";
    $rsc = $conn->Execute($sql);

    if($rsc){while(!$rsc->EOF)
    {
    $field = $rsc->fields['soption'];
    $config[$field] = $rsc->fields['svalue'];
    STemplate::assign($field, $config[$field]);
    @$rsc->MoveNext();
    }}

    STemplate::assign('bgcolor','#E8E8E8');
    STemplate::assign('BASE_URL', $config['BASE_URL']);
    STemplate::assign('BASE_DIR', $config['BASE_DIR']);
    STemplate::assign('IMG_URL', $config['IMG_URL']);
    STemplate::assign('baseurl', $config['BASE_URL']);
    STemplate::assign('basedir', $config['BASE_DIR']);
    STemplate::assign('imgurl', $config['IMG_URL']);
    STemplate::assign('vdourl', $config['VDO_URL']);
    STemplate::assign('adourl', $config['ADO_URL']);
    STemplate::assign('flvdourl', $config['FLVDO_URL']);
    STemplate::assign('tmburl', $config['TMB_URL']);
    STemplate::setCompileDir($config['basedir']."/templates_c");
    STemplate::setTplDir($config['basedir']."/templates");
    ?>
     
    BBX, Dec 22, 2008 IP
  4. rajib.bahar

    rajib.bahar Active Member

    Messages:
    87
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    68
    #4
    $DBTYPE = 'mysql';

    That variable above says it's mysql... Please consider removing the password from your thread. I am guessing your username, password and server address does not match with the new server.

    Good luck!
     
    rajib.bahar, Dec 22, 2008 IP
  5. BBX

    BBX Banned

    Messages:
    144
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Have I added it onto the right place or it should have been here
    $DBUSER = SConfig::get("Database", "blesseded2_anime");
     
    BBX, Dec 22, 2008 IP