123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213 |
- <?php
- if(!defined('entry') || !entry) die('Not a valid page');
- /* ===========================
-
- gelato CMS - A PHP based tumblelog CMS
- development version
- http://www.gelatocms.com/
-
- gelato CMS is a free software licensed under the GPL 2.0
- Copyright (C) 2007 by Pedro Santana <pecesama at gmail dot com>
-
- =========================== */
- ?>
- <?php
- require_once("configuration.class.php");
- require_once("functions.php");
-
- class gelato extends Conexion_Mysql {
- var $conf;
-
- function gelato() {
- parent::Conexion_Mysql(DB_name, DB_Server, DB_User, DB_Password);
- $this->conf = new configuration();
- }
-
- function saveSettings($fieldsArray) {
- if ($this->modificarDeFormulario($this->conf->tablePrefix."config", $fieldsArray)) {
- header("Location: ".$this->conf->urlGelato."/admin/settings.php?modified=true");
- die();
- } else {
- header("Location: ".$this->conf->urlGelato."/admin/settings.php?error=1&des=".$this->merror);
- die();
- }
- }
-
- function saveOption($value, $name) {
- $sqlStr = "UPDATE ".$this->conf->tablePrefix."options SET val='".$value."' WHERE name='".$name."' LIMIT 1";
- if ($this->ejecutarConsulta($sqlStr)) {
- return true;
- } else {
- return true;
- }
- }
-
- function addPost($fieldsArray) {
- if ($this->insertarDeFormulario($this->conf->tablePrefix."data", $fieldsArray)) {
- return true;
- } else {
- return false;
- }
- }
-
- function modifyPost($fieldsArray, $id_post) {
- if ($this->modificarDeFormulario($this->conf->tablePrefix."data", $fieldsArray, "id_post=$id_post")) {
- header("Location: ".$this->conf->urlGelato."/admin/index.php?modified=true");
- die();
- } else {
- header("Location: ".$this->conf->urlGelato."/admin/index.php?error=2&des=".$this->merror);
- die();
- }
- }
-
- function deletePost($idPost) {
- $this->ejecutarConsulta("DELETE FROM ".$this->conf->tablePrefix."data WHERE id_post=".$idPost);
- }
-
- function getPosts($limit="10", $from="0") {
- $sqlStr = "select * from ".$this->conf->tablePrefix."data ORDER BY date DESC LIMIT $from,$limit";
- $this->ejecutarConsulta($sqlStr);
- return $this->mid_consulta;
- }
-
- function getPost($id="") {
- $this->ejecutarConsulta("select * from ".$this->conf->tablePrefix."data WHERE id_post=".$id);
- return mysql_fetch_array($this->mid_consulta);
- }
-
- function getPostsNumber() {
- $this->ejecutarConsulta("select count(*) as total from ".$this->conf->tablePrefix."data");
- $row = mysql_fetch_assoc($this->mid_consulta);
- return $row['total'];
- }
-
- function getType($id) {
- if ($this->ejecutarConsulta("select type from ".$this->conf->tablePrefix."data WHERE id_post=".$id)) {
- if ($this->contarRegistros()>0) {
- while($registro = mysql_fetch_array($this->mid_consulta)) {
- return $registro[0];
- }
- }
- } else {
- return "0";
- }
- }
-
- function formatConversation($text) {
- $formatedText = "";
- $odd=true;
-
- $lines = explode("\n", $text);
-
- $formatedText .= "<ul>\n";
- foreach ($lines as $line) {
- $pos = strpos($line, ":") + 1;
-
- $label = substr($line, 0, $pos);
- $desc = substr($line, $pos, strlen($line));
-
- if ($odd) {
- $cssClass = "odd";
- } else {
- $cssClass = "even";
- }
- $odd=!$odd;
-
-
- $formatedText .= " <li class=\"".$cssClass."\">\n";
- $formatedText .= " <span class=\"label\">".$label."</span>\n";
- $formatedText .= " ".$desc."\n";
- $formatedText .= " </li>\n";
- }
- $formatedText .= "</ul>\n";
- return $formatedText;
- }
-
- function formatApiConversation($text) {
- $formatedText = "";
-
- $lines = explode("\n", $text);
-
- foreach ($lines as $line) {
- $pos = strpos($line, ":") + 1;
-
- $name = substr($line, 0, $pos-1);
- $label = substr($line, 0, $pos);
- $desc = substr($line, $pos, strlen($line));
-
- $formatedText .= "<conversation-line name=\"".$name."\" label=\"".$label."\">".$desc."</conversation-line>\n";
- }
-
- return $formatedText;
- }
-
- function saveMP3($remoteFileName) {
- if (getMP3File($remoteFileName)) {
- return true;
- } else {
- return false;
- }
- }
-
- function savePhoto($remoteFileName) {
- if (getPhotoFile($remoteFileName)) {
- return true;
- } else {
- return false;
- }
- }
-
- function getVideoPlayer($url) {
- if (isYoutubeVideo($url)) {
- $id_video = getYoutubeVideoUrl($url);
- return "\t\t\t<object type=\"application/x-shockwave-flash\" style=\"width:500px;height:393px\" data=\"http://www.youtube.com/v/".$id_video."\"><param name=\"movie\" value=\"http://www.youtube.com/v/".$id_video."\" /><param name=\"wmode\" value=\"transparent\" /></object>\n";
- } elseif (isVimeoVideo($url)) {
- $id_video = getVimeoVideoUrl($url);
- return "\t\t\t<object type=\"application/x-shockwave-flash\" style=\"width:500px;height:393px\" data=\"http://www.vimeo.com/moogaloop.swf?clip_id=".$id_video."\"><param name=\"movie\" value=\"http://www.vimeo.com/moogaloop.swf?clip_id=".$id_video."\" /><param name=\"wmode\" value=\"transparent\" /></object>\n";
- } elseif (isDailymotionVideo($url)) {
- $id_video = getDailymotionVideoUrl($url);
- return "\t\t\t<object type=\"application/x-shockwave-flash\" style=\"width:500px;height:393px\" data=\"http://www.dailymotion.com/swf/".$id_video."\"><param name=\"movie\" value=\"http://www.dailymotion.com/swf/".$id_video."\" /><param name=\"wmode\" value=\"transparent\" /></object>\n";
- } elseif (isYahooVideo($url)) {
- $id_video = getYahooVideoCode($url);
- return "\t\t\t<object type=\"application/x-shockwave-flash\" style=\"width:500px;height:393px\" data=\"http://d.yimg.com/static.video.yahoo.com/yep/YV_YEP.swf\"><param name=\"quality\" value=\"high\" /><param name=\"FlashVars\" value=\"event_function=YAHOO.yv.Player.SWFInterface&id=".$id_video[1]."&vid=".$id_video[0]."&onsite=1&site=video.yahoo.com&page=792730258&lang=en-US&intl=us\" /><param name=\"wmode\" value=\"transparent\" /></object>\n";
- } elseif (isSlideSharePresentation($url)) {
- $id_video = getSlideSharePresentationCode($url);
- return "\t\t\t<object type=\"application/x-shockwave-flash\" style=\"width:500px;height:393px\" data=\"http://www.slideshare.net/swf/player.swf?presentationId=".$id_video[0]."&doc=".$id_video[1]."&inContest=0&startSlide=1\"><param name=\"quality\" value=\"high\" /><param name=\"wmode\" value=\"transparent\" /></object>\n";
- } elseif (isGoogleVideoUrl($url)) {
- $id_video = getGoogleVideoCode($url);
- return "\t\t\t<object type=\"application/x-shockwave-flash\" style=\"width:500px;height:393px\" data=\"http://video.google.com/googleplayer.swf?docid=".$id_video."&hl=es&fs=true\"><param name=\"movie\" value=\"http://video.google.com/googleplayer.swf?docid=".$id_video."&hl=es&fs=true\" /><param name=\"allowFullScreen\" value=\"true\" /><param name=\"allowScriptAccess\" value=\"always\" /><param name=\"wmode\" value=\"transparent\" /></object>\n";
- } else {
- return "This URL is not a supported video (YouTube, Google Video, Vimeo, DailyMotion, Yahoo Video or SlideShare)";
- }
- }
- function getMp3Player($url) {
- if (isMP3($url)) {
- $playerUrl = $this->conf->urlGelato."/admin/scripts/player.swf?soundFile=".$url;
- return "\t\t\t<object type=\"application/x-shockwave-flash\" data=\"" . $playerUrl . "\" width=\"290\" height=\"24\"><param name=\"movie\" value=\"" . $playerUrl . "\" /><param name=\"quality\" value=\"high\" /><param name=\"menu\" value=\"false\" /><param name=\"wmode\" value=\"transparent\" /></object>\n";
- } elseif (isGoEar($url)) {
- return "\t\t\t<object type=\"application/x-shockwave-flash\" data=\"http://www.goear.com/files/external.swf\" width=\"366\" height=\"130\"><param name=\"movie\" value=\"http://www.goear.com/files/external.swf\" /><param name=\"quality\" value=\"high\" /><param name=\"FlashVars\" value=\"file=".getGoEarCode($url)."\" /><param name=\"wmode\" value=\"transparent\" /></object>\n";
- } elseif (isOdeo($url)) {
- return "\t\t\t<object type=\"application/x-shockwave-flash\" data=\"http://media.odeo.com/flash/odeo_player.swf?v=3\" width=\"366\" height=\"75\"><param name=\"quality\" value=\"high\" /><param name=\"FlashVars\" value=\"type=audio&id=".getOdeoCode($url)."\" /><param name=\"wmode\" value=\"transparent\" /></object>\n";
- } else {
- return "This URL is not an MP3 file.";
- }
- }
-
- function getPermalink($post_id){
- $strEnd = ($this->conf->urlFriendly) ? "/" : "";
- $out = $this->conf->urlGelato;
- $out .= ($this->conf->urlFriendly) ? "/post/" : "/index.php?post=";
- $out .= $post_id.$strEnd;
- return $out;
- }
-
- function getPermalink($post_id){
- $strEnd = ($this->conf->urlFriendly) ? "/" : "";
- $out = $this->conf->urlGelato;
- $out .= ($this->conf->urlFriendly) ? "/post/" : "/index.php?post=";
- $out .= $post_id.$strEnd;
- return $out;
- }
- }
- ?>
|