<?php
//author:QQ352794 ccvms专业定制
//version:1.0 2012.10.10
define('SITE_ROOT', substr(dirname(__FILE__), 0, -9));
require_once "db.php";
require_once "page.php";
$config = (require_once SITE_ROOT . 'system/config.inc.php');
//数据库连接类实例化
$conn = new cikeDB();
$conn->connect($config['db_connection']['host'], $config['db_connection']['user'], $config['db_connection']['pass'], $config['db_connection']['database'], $config['db_character_set'], 0, $config['db_table_prefix']);
//更多视频URL的初始化
$quotes_tableName = $config['db_table_prefix'] . "cikeplug_video_quotes";
$quotes_installSql = "CREATE TABLE IF NOT EXISTS `" . $quotes_tableName . "` (\r\n `vid` int(8) unsigned NOT NULL DEFAULT '0',\r\n `url` text NOT NULL DEFAULT '',\r\n PRIMARY KEY (`vid`),\r\n KEY `vid` (`vid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;";
//$conn->query($quotes_installSql);
function quotes_Get($vid = 0)
{
global $conn, $quotes_tableName;
$sql = "select url from `" . $quotes_tableName . "` where vid = " . $vid;
$result = $conn->result_first($sql);
return $result;
}
function quotes_Add($vid = 0, $url = "")
{
global $conn, $quotes_tableName;
$sql = "REPLACE INTO `" . $quotes_tableName . "` (`vid`, `url`) VALUES ({$vid}, '{$url}')";
$conn->query($sql);
//return $conn->insert_id();
return "1";
}
function getPlayList($vid = 0, $plid = 0)
{
<?php
//author:QQ352794 ccvms专业定制
//version:1.0 2012.10.10
define('SITE_ROOT', substr(dirname(__FILE__), 0, -9));
require_once "db.php";
$config = (require_once SITE_ROOT . 'system/config.inc.php');
//数据库连接类实例化
$conn = new cikeDB();
$conn->connect($config['db_connection']['host'], $config['db_connection']['user'], $config['db_connection']['pass'], $config['db_connection']['database'], $config['db_character_set'], 0, $config['db_table_prefix']);
//更多视频URL的初始化
$quotes_tableName = $config['db_table_prefix'] . "cikeplug_video_quotes";
$quotes_installSql = "CREATE TABLE IF NOT EXISTS `" . $quotes_tableName . "` (\r\n `vid` int(8) unsigned NOT NULL DEFAULT '0',\r\n `url` varchar(255) NOT NULL DEFAULT '',\r\n PRIMARY KEY (`vid`),\r\n KEY `vid` (`vid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;";
$conn->query($quotes_installSql);
