Skip to content

Instantly share code, notes, and snippets.

@joelmandell

joelmandell/gist:0357efee2442c7981def

Created November 2, 2015 21:07
Show Gist options
  • Save joelmandell/0357efee2442c7981def to your computer and use it in GitHub Desktop.
Save joelmandell/0357efee2442c7981def to your computer and use it in GitHub Desktop.
Download ZIP
CodeIgniter - blogmodel.php kodsnutt
Raw
gistfile1.txt
<?php
class BlogModel extends Model {
var $permission_table;
function BlogModel()
{
parent::Model();
$this->load->database();
$this->load->library('auth');
$this->permission_table="blog_permissions";
$this->load->library('session');
}
function get_url_prefix()
{
return str_replace("model","",strtolower(get_class($this)));
}
function list_latest_items($limit=0,$page=0)
{
$text="";
$total_items=0;
$count_items_query=$this->db->query("SELECT * FROM blog_items");
$pages=0;
$page=$page*$limit;
foreach ($count_items_query->result() as $row)
{
$total_items++;
}
if($page==0)
{
if($limit==0) //If argument limit is zero then there is no limited query.
{
$query = $this->db->query("SELECT * FROM blog_items ORDER BY date");
} else {
$query = $this->db->query("SELECT * FROM blog_items ORDER BY date DESC LIMIT ".$this->db->escape($limit)." ");
$pages=(int) $total_items/$limit;
}
} else {
if($limit==0) //If argument limit is zero then there is no limited query.
{
$query = $this->db->query("SELECT * FROM blog_items ORDER BY date");
} else {
$query = $this->db->query("SELECT * FROM blog_items ORDER BY date DESC LIMIT ".$this->db->escape($limit).",".$page." ");
$pages=$total_items/$limit;
}
}
foreach ($query->result() as $row)
{
$comments = $this->db->query("SELECT * FROM blog_comments WHERE blogid LIKE '$row->id'")->num_rows();
$text.="<h2>".$row->title."</h2>";
$text.="<em>".$row->date."</em>";
$text.="<br /><br /><p><strong>".$row->preamble."</strong></p><a href=\"./show_item/".$row->id."\">Läs vidare (<span title=\"Antalet kommentarer.\"> $comments </span>)</a><br /><br /><hr /><br />";
}
if($pages!=0)
{
$text.="<br /><br />";
for($i=1;$i<$pages;$i++)
{
//$text.="<a href=\"/blog/page/$i/\">$i</a>&nbsp;&nbsp;";
}
}
//$text.="SELECT * FROM blog_items ORDER BY date DESC LIMIT ".$this->db->escape($limit).",".$page." ";
return $text;
}
function create_edit_item_links()
{
$text="<h1>Blogg</h1><br />";
$text.="<p><a href=\"".get_class($this)."/create\">Skapa nytt inlägg</a></p><br />";
$query = $this->db->query("SELECT * FROM blog_items ORDER BY date");
foreach ($query->result() as $row)
{
$text.="".$row->title."<br /><a href=\"".get_class($this)."/edit/".$row->id."\">Redigera</a> | <a href=\"".get_class($this)."/delete/".$row->id."\">Ta bort</a> | <a href=\"".get_class($this)."/move/".$row->id."\">Flytta</a> | <a href=\"".get_class($this)."/comments/".$row->id."\">Moderera kommentarer</a><br /><br />";
}
return $text;
}
function from_twitter($q)
{
$text="";
$xml_file="http://search.twitter.com/search.rss?q=".$q."";
$xml = simplexml_load_file($xml_file,'SimpleXMLElement', LIBXML_NOCDATA);
$result = $xml->xpath("/rss/channel/item");
$i=0;
$count=count($result);
for($a=0;$a<$count;$a++)
{
foreach($result[$a] as $key => $attribute) {
if($i!=10)
{
//print_r($attribute);
if($key=="description")
{
$text.="<br /><div class=\"comment\"><div class=\"space\"><p><strong>Från twitter <span class=\"u\"></span></strong>:</p><p>".$attribute."</p></div></div>";
$i++;
}
}
}
}
return $text;
}
function microblog() //For the moment static hack...needs to make it depend on options from admin ui.
{
$text="<h3>Twitter</h3><hr /><br />";
$xml_file="http://twitter.com/statuses/user_timeline/50093268.rss";
$xml = simplexml_load_file($xml_file,'SimpleXMLElement', LIBXML_NOCDATA);
$result["content"] = $xml->xpath("/rss/channel/item/title");
$i=0;
foreach($result as $key => $attribute) {
foreach($attribute as $element) {
if($i!=10)
{
$text.="<p>".$element."</p><br />";
$i++;
}
}
}
return $text;
}
function generate_links_to_blog($limit)
{
$text="<h3>Bloggen</h3><hr /><br />";
$groups=$this->auth->get_session_groups();
// $permissions=$this->auth->get_session_permissions();
$query = $this->db->query("SELECT * FROM blog_items ORDER BY date DESC LIMIT ".$this->db->escape($limit)."");
if($query->num_rows() > 0)
{
foreach ($query->result() as $row)
{
$comments = $this->db->query("SELECT * FROM blog_comments WHERE blogid LIKE '$row->id'")->num_rows();
$text.="<p><a href=\"/blog/show_item/".$row->id."\">".$row->title."(<span title=\"Antalet kommentarer.\"> $comments </span>)</a></p>";
}
} else {
}
return $text;
}
function title($id=0)
{
$text="";
$query = $this->db->query("SELECT title FROM blog_items WHERE id LIKE ".$this->db->escape($id)."");
$text.=strip_tags($query->row()->title);
return $text;
}
function description()
{
$text="Joel Mandells personliga sida, portfolio, projekt samt blogg om öppen källkod, programmering och annat i livet.";
return $text;
}
function preamble($id=0)
{
$text="";
$query = $this->db->query("SELECT preamble FROM blog_items WHERE id LIKE ".$this->db->escape($id)."");
$text.=$query->row()->preamble;
return $text;
}
function body($id=0)
{
$text="";
$query = $this->db->query("SELECT body FROM blog_items WHERE id LIKE ".$this->db->escape($id)."");
$text.=$query->row()->body;
return $text;
}
function list_comments($id=0)
{
$query = $this->db->query("SELECT * FROM blog_comments WHERE blogid LIKE ".$this->db->escape($id)." ORDER BY date");
$text="";
if($query->num_rows() > 0)
{
$text.="<br /><hr /><br /><h2>Kommentarer</h2>";
foreach ($query->result() as $row)
{
$text.="<br /><div class=\"comment\"><div class=\"space\"><p><strong>".$row->publisher."&nbsp;skrev&nbsp;<span class=\"u\">".$row->date."</span></strong>:</p>";
$text.="<p>".$row->text."</p></div></div>";
}
$text.=$this->from_twitter($this->title($id));
} else {
$twitter=$this->from_twitter($this->title($id));
if($twitter!="")
{
$text.=$twitter;
} else {
$text .="<br /><hr /><br /><h2>Kommentarer</h2><br /><p>Hitills inga kommentarer, bli först med att kommentera!</p>";
}
}
return $text;
}
function write_comment($id)
{
$this->load->helper('captcha');
// create the captcha-config
$aCaptchaCfg = array(
//'word' => 'myrandomword', //default: random()
'length' => 6, //default: 5
'img_path' => 'captcha/', //no default !
'img_url' => '../../../captcha/', // no default!
'font_path' => '/Libraries/sys1.7.1/fonts/', // default: ./system/fonts/
'fonts' => array('texb.ttf'), // default: texb.ttf
'font_size' => 10, // default: 18
'img_width' => '180', // default: 170
'img_height' => '30', // default: 60
'expiration' => 7200 // default: 7200
);
// get captcha-stuff
$aCaptcha=create_captcha($aCaptchaCfg);
$this->session->set_userdata(array('security_code' => md5($aCaptcha['word'])));
$text="";
$text.="<br /><br /><form method=\"post\" action=\"../create_comment/$id\"><fieldset><legend>&nbsp;Skriv kommentar&nbsp;</legend>";
$text.="<div class=\"space\">";
$text.="<p>Namn, nick: <br/><input type=\"text\" name=\"nick\" /><textarea class=\"ilu\" rows=\"13\" cols=\"42\" name=\"msg\">Skriv meddelande här..</textarea><br /></p>";
$text.="<p><br />".$aCaptcha['image']."<br />Säkerhets-kod<br /><input type=\"text\" name=\"cap\" /></p>";
$text.="<p><br /><input type=\"submit\" value=\"Publicera!\" /></p></div></fieldset>";
$text.="</form>";
return $text;
}
function list_item($id)
{
$text="";
$query = $this->db->query("SELECT * FROM blog_items WHERE id LIKE ".$this->db->escape($id)."");
foreach ($query->result() as $row)
{
$text.="<h2>".$row->title."</h2>";
$text.="<em>".$row->date."</em>";
$text.="<br /><br />Dela med dig av detta inlägget till: <a href=\"http://www.facebook.com/share.php?u=http://".$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]."&amp;t=".$row->title."\">Facebook</a> eller ";
$text.="<a href=\"http://twitter.com/home?status=http://".$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]." - ".$row->title."\">Twitter</a>.";
$text.="<br /><br />".$row->preamble."";
$text.="<br />".$row->body."<br />";
}
return $text;
}
function admin_functions()
{
$text="<a href=\"./edit_item_form\">Ändra blogg-post</a>";
return $text;
}
function create_form_editor()
{
$text="<script type=\"text/javascript\" src=\"/ckeditor/ckeditor.js\"></script>";
return $text;
}
function create_form($id)
{
$function_name="create"; //This variable is crucial in all model calls that we are using.
(int) $data=0; //Initialize this with zero.
/*If there is a permission that is set to true for the group(s) that the current user belongs to then
the $data
*/
$data=$this->session->userdata($this->permission_table."@".$function_name);
if($data!=0)
{
$text="<h1>Skapa post:</h1><br /><form method=\"post\" action=\"/../../blog/create_item/\"><p>Rubrik :<input type=\"\" name=\"title\" value=\"\"/></p><br />";
$text.="<label for=\"preamble\">
Brödtext:</label>
<textarea cols=\"30\" id=\"preamble\" name=\"preamble\" rows=\"10\"></textarea>
<script type=\"text/javascript\">
//<![CDATA[
CKEDITOR.replace( 'preamble',
{
/*
* Style sheet for the contents
*/
contentsCss : '/assets/output_xhtml.css',
/*
* Core styles.
*/
coreStyles_bold : { element : 'span', attributes : {'class': 'Bold'} },
coreStyles_italic : { element : 'span', attributes : {'class': 'Italic'}},
coreStyles_underline : { element : 'span', attributes : {'class': 'Underline'}},
coreStyles_strike : { element : 'span', attributes : {'class': 'StrikeThrough'}, overrides : 'strike' },
coreStyles_subscript : { element : 'span', attributes : {'class': 'Subscript'}, overrides : 'sub' },
coreStyles_superscript : { element : 'span', attributes : {'class': 'Superscript'}, overrides : 'sup' },
/*
* Font face
*/
// List of fonts available in the toolbar combo. Each font definition is
// separated by a semi-colon (;). We are using class names here, so each font
// is defined by {Combo Label}/{Class Name}.
font_names : 'Comic Sans MS/FontComic;Courier New/FontCourier;Times New Roman/FontTimes/Trebuchet MS/Tahoma',
// Define the way font elements will be applied to the document. The \"span\"
// element will be used. When a font is selected, the font name defined in the
// above list is passed to this definition with the name \"Font\", being it
// injected in the \"class\" attribute.
// We must also instruct the editor to replace span elements that are used to
// set the font (Overrides).
font_style :
{
element : 'span',
attributes : { 'class' : '#(family)' },
overrides : [ { element : 'span', attributes : { 'class' : /^Font(?:Comic|Courier|Times)$/ } } ]
},
/*
* Font sizes.
*/
fontSize_sizes : 'Smaller/FontSmaller;Larger/FontLarger;8pt/FontSmall;14pt/FontBig;Double Size/FontDouble',
fontSize_style :
{
element : 'span',
attributes : { 'class' : '#(size)' },
overrides : [ { element : 'span', attributes : { 'class' : /^Font(?:Smaller|Larger|Small|Big|Double)$/ } } ]
} ,
/*
* Font colors.
*/
colorButton_enableMore : false,
colorButton_colors : 'FontColor1/FF9900,FontColor2/0066CC,FontColor3/F00',
colorButton_foreStyle :
{
element : 'span',
attributes : { 'class' : '#(color)' },
overrides : [ { element : 'span', attributes : { 'class' : /^FontColor(?:1|2|3)$/ } } ]
},
colorButton_backStyle :
{
element : 'span',
attributes : { 'class' : '#(color)BG' },
overrides : [ { element : 'span', attributes : { 'class' : /^FontColor(?:1|2|3)BG$/ } } ]
},
/*
* Indentation.
*/
indentClasses : ['Indent1', 'Indent2', 'Indent3'],
/*
* Paragraph justification.
*/
justifyClasses : [ 'JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyFull' ],
/*
* Styles combo.
*/
stylesSet :
[
{ name : 'Strong Emphasis', element : 'strong' },
{ name : 'Emphasis', element : 'em' },
{ name : 'Computer Code', element : 'code' },
{ name : 'Keyboard Phrase', element : 'kbd' },
{ name : 'Sample Text', element : 'samp' },
{ name : 'Variable', element : 'var' },
{ name : 'Deleted Text', element : 'del' },
{ name : 'Inserted Text', element : 'ins' },
{ name : 'Cited Work', element : 'cite' },
{ name : 'Inline Quotation', element : 'q' }
]
});
//]]>
</script>
<br />";
$text.="<label for=\"body\">
Sprödtext:</label>
<textarea cols=\"70\" id=\"body\" name=\"body\" rows=\"10\"></textarea>
<script type=\"text/javascript\">
//<![CDATA[
CKEDITOR.replace( 'body',
{
/*
* Style sheet for the contents
*/
contentsCss : '/assets/output_xhtml.css',
/*
* Core styles.
*/
coreStyles_bold : { element : 'span', attributes : {'class': 'Bold'} },
coreStyles_italic : { element : 'span', attributes : {'class': 'Italic'}},
coreStyles_underline : { element : 'span', attributes : {'class': 'Underline'}},
coreStyles_strike : { element : 'span', attributes : {'class': 'StrikeThrough'}, overrides : 'strike' },
coreStyles_subscript : { element : 'span', attributes : {'class': 'Subscript'}, overrides : 'sub' },
coreStyles_superscript : { element : 'span', attributes : {'class': 'Superscript'}, overrides : 'sup' },
/*
* Font face
*/
// List of fonts available in the toolbar combo. Each font definition is
// separated by a semi-colon (;). We are using class names here, so each font
// is defined by {Combo Label}/{Class Name}.
font_names : 'Comic Sans MS/FontComic;Courier New/FontCourier;Times New Roman/FontTimes/Trebuchet MS/Tahoma',
// Define the way font elements will be applied to the document. The \"span\"
// element will be used. When a font is selected, the font name defined in the
// above list is passed to this definition with the name \"Font\", being it
// injected in the \"class\" attribute.
// We must also instruct the editor to replace span elements that are used to
// set the font (Overrides).
font_style :
{
element : 'span',
attributes : { 'class' : '#(family)' },
overrides : [ { element : 'span', attributes : { 'class' : /^Font(?:Comic|Courier|Times)$/ } } ]
},
/*
* Font sizes.
*/
fontSize_sizes : 'Smaller/FontSmaller;Larger/FontLarger;8pt/FontSmall;14pt/FontBig;Double Size/FontDouble',
fontSize_style :
{
element : 'span',
attributes : { 'class' : '#(size)' },
overrides : [ { element : 'span', attributes : { 'class' : /^Font(?:Smaller|Larger|Small|Big|Double)$/ } } ]
} ,
/*
* Font colors.
*/
colorButton_enableMore : false,
colorButton_colors : 'FontColor1/FF9900,FontColor2/0066CC,FontColor3/F00',
colorButton_foreStyle :
{
element : 'span',
attributes : { 'class' : '#(color)' },
overrides : [ { element : 'span', attributes : { 'class' : /^FontColor(?:1|2|3)$/ } } ]
},
colorButton_backStyle :
{
element : 'span',
attributes : { 'class' : '#(color)BG' },
overrides : [ { element : 'span', attributes : { 'class' : /^FontColor(?:1|2|3)BG$/ } } ]
},
/*
* Indentation.
*/
indentClasses : ['Indent1', 'Indent2', 'Indent3'],
/*
* Paragraph justification.
*/
justifyClasses : [ 'JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyFull' ],
/*
* Styles combo.
*/
stylesSet :
[
{ name : 'Strong Emphasis', element : 'strong' },
{ name : 'Emphasis', element : 'em' },
{ name : 'Computer Code', element : 'code' },
{ name : 'Keyboard Phrase', element : 'kbd' },
{ name : 'Sample Text', element : 'samp' },
{ name : 'Variable', element : 'var' },
{ name : 'Deleted Text', element : 'del' },
{ name : 'Inserted Text', element : 'ins' },
{ name : 'Cited Work', element : 'cite' },
{ name : 'Inline Quotation', element : 'q' }
]
});
//]]>
</script>
";
$text.="<br /><input type=\"submit\" value=\"Skapa!\" /></form>";
//$text="<h1>Skapa post:</h1><br /><form method=\"post\" action=\"/../../blog/create_item/\"><p>Rubrik :<input type=\"\" name=\"title\" value=\"\"/></p>
//<br /><p>Brödtext:</p><textarea name=\"preamble\" cols=\"70\" rows=\"8\"></textarea><br /><br /><p>Sprödtext:</p><textarea name=\"body\" cols=\"70\" rows=\"8\"></textarea><br /><br /><input type=\"submit\" value=\"Skapa!\" /></form>";
} else {
$text="Du har inte tillåtelse att skapa en blogg artikel.";
}
return $text;
}
function edit_form($id)
{
$function_name="edit"; //This variable is crucial in all model calls that we are using.
(int) $data=0; //Initialize this with zero.
/*If there is a permission that is set to true for the group(s) that the current user belongs to then
the $data
*/
$data=$this->session->userdata($this->permission_table."@".$function_name);
if($data!=0)
{
$query = $this->db->query("SELECT * FROM blog_items WHERE id LIKE ".$this->db->escape($id)."");
$text="<h1>Ändra post:</h1><br /><form method=\"post\" action=\"\"><p>Rubrik :<input type=\"\" name=\"title\" value=\"".$query->row()->title."\"/></p>
<br /><p>Brödtext:</p><textarea name=\"preamble\" cols=\"70\" rows=\"8\">".$query->row()->preamble."</textarea><br /><br /><p>Sprödtext:</p><textarea name=\"body\" cols=\"70\" rows=\"8\">".$query->row()->body."</textarea></form>";
} else {
$text="Du har inte tillåtelse att använda editeringsfunktionen för blogg artiklar";
}
return $text;
}
function delete_form($id)
{
$function_name="delete"; //This variable is crucial in all model calls that we are using.
(int) $data=0; //Initialize this with zero.
$data=$this->session->userdata($this->permission_table."@".$function_name);
if($data!=0)
{ //Granted permission
$text="Du får ta bort!";
} else {
//Dont have permission.
$text="Du har inte tillåtelse att använda raderings-funktionen för blogg artiklar";
}
return $text;
}
function move_form($id)
{
$function_name="move"; //This variable is crucial in all model calls that we are using.
$data=0;
$data=$this->session->userdata($this->permission_table."@".$function_name);
if($data!=0)
{ //Granted permission
} else {
//Dont have permission.
$text="Du har inte tillåtelse att byta ordning på blogg inläggen.";
}
return $text;
}
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment