Hall of Fame

[mihai]

Hi Mario!
I want to know how to do a few things

#1 Article content2
I want to add another article content input with the target on my created div that is on com_post/default.php.



#2 Implement select language in my footer
I created a footer and i don't know how to implement select language there


#3 How to create filters/implement them
I want to create filters(1 day ago.2 days ago) so i can add them in browse and i want to know how to create filters like(top rated,most viewed.featured...) so i can implement them into channels pages


#4 A wat that we can make the import page bigger?so i can have instead of 20videos 200?


#5 How to solve the activity filter problem
The filters for activity are not working how to make them work?
http://gamevide.com/profile/endowed/1/&sk=activity
I am not the only one who have this problem(videoinedit and others phpvibe ultimatube/v2 sites)

Thank you!!!!

[mihai]

Ok what i did wrong?
For #1 i edited com_post and create-post and now i can't create a new article anymore
i added this in com_post

Code Select Expand

$txt .= _html($_post->content2);

under

Code Select Expand

$txt .= _html($_post->content);

i added this in create-post

Code Select Expand

$db->query("INSERT INTO ".DB_PREFIX."posts (`date`, `ch`, `pic`, `title`, `content`,`content2`, `tags`)
 VALUES (now(),'".intval($_POST['ch'])."', '".$picture."', '".$db->escape($_POST['play-name'])."', '".$db->escape($_POST['content'])."','".$db->escape($_POST['content2'])."', '".$db->escape($_POST['tags'])."')");
echo '<div class="msg-info">Post '.$_POST['play-name'].' created</div>';

and

Code Select Expand

<div class="control-group">
<label class="control-label">Article content2</label>
<div class="controls">
<textarea rows="5" cols="5" name="content2" class="ckeditor span12" style="word-wrap: break-word; resize: horizontal; height: 88px;"></textarea>					
</div>	
</div>

What seems to be the problem?

[Marius P.]

Did you create the field content2 in the table (sql)?

[mihai]

No ideea about how to do that

[Marius P.]

No ideea about how to do that

http://support.hostgator.com/articles/specialized-help/technical/phpmyadmin/adding-a-column-to-a-database-table-in-phpmyadmin

[mihai]

After i did that i was able to create and to view an article but i can't see what i placed in content2 and i can't fiind content2 in inspect element.

[mihai]

After i did that i was able to create and to view an article but i can't see what i placed in content2 and i can't fiind content2 in inspect element.

I am able to see content but unable to see content2(element and content)

[Marius P.]

You've wanted content2, so you have to create it. I know it's not there

[mihai]

Ok.If created means to add it to com_post.php this is my com_post

Code Select Expand

<?php $pid = token_id();
 
$_post = $db->get_row("select * from ".DB_PREFIX."posts where pid = '".$pid."'");
 
if($_post) {
 
// SEO Filters
function modify_title( $text ) {
global $_post;
 return _cut(strip_tags(stripslashes($_post->title)), 260);
}
function modify_desc( $text ) {
global $_post;
    return _cut(strip_tags(stripslashes($_post->content)), 160);
}
function modify_content( $text ) {
global $_post;
if($_post->pic) {$txt .= '<div class="row-fluid" style="display:none;"><img src="'.thumb_fix($_post->pic).'" /></div>';}
$txt = '<h3 class="loop-heading" style="padding-left:0;margin-left:-21px;"><span>'._html($_post->title).'</span></h3>';
$txt .= '<div class="page-content" style="padding:0;">';
$txt .= _html($_post->content);
$txt .= _html($_post->content2);
$txt .= '</div>';
return $txt;
}
add_filter( 'phpvibe_title', 'modify_title' );
add_filter( 'the_defaults', 'modify_content' );
add_filter( 'phpvibe_desc', 'modify_desc' );
//Time for design
 the_header();
include_once(TPL.'/default.php');
the_footer();
} else {
//Oups, not found
layout('404');
}
 
?>

[Marius P.]

You're trying to save the field "content2" to database, but there is no sql field content with name content2 in the sql database so the full query fails.
Not sure why you keep showing me php, I've even linked you.

[mihai]

You're trying to save the field "content2" to database, but there is no sql field content with name content2 in the sql database so the full query fails.
Not sure why you keep showing me php, I've even linked you.

Code Select Expand

pid	int(11)			No	None	AUTO_INCREMENT	Change Change	Drop Drop	
Primary Primary
Unique Unique
Index Index
Spatial Spatial
Fulltext Fulltext
Distinct values Distinct values
	2	ch	int(11)			No	1		Change Change	Drop Drop	
Primary Primary
Unique Unique
Index Index
Spatial Spatial
Fulltext Fulltext
Distinct values Distinct values
	3	date	text	utf8_swedish_ci		No	None		Change Change	Drop Drop	
Primary Primary
Unique Unique
Index Index
Spatial Spatial
Fulltext Fulltext
Distinct values Distinct values
	4	title	varchar(300)	utf8_swedish_ci		No	None		Change Change	Drop Drop	
Primary Primary
Unique Unique
Index Index
Spatial Spatial
Fulltext Fulltext
Distinct values Distinct values
	5	pic	longtext	utf8_swedish_ci		No	None		Change Change	Drop Drop	
Primary Primary
Unique Unique
Index Index
Spatial Spatial
Fulltext Fulltext
Distinct values Distinct values
	6	content	longtext	utf8_swedish_ci		No	None		Change Change	Drop Drop	
Primary Primary
Unique Unique
Index Index
Spatial Spatial
Fulltext Fulltext
Distinct values Distinct values
	7	content2	longtext	utf8_swedish_ci		No	None		Change Change	Drop Drop	
Primary Primary
Unique Unique
Index Index
Spatial Spatial
Fulltext Fulltext
Distinct values Distinct values
	8	tags	varchar(500)	utf8_swedish_ci		No	None		Change Change	Drop Drop	
Primary Primary
Unique Unique
Index Index
Spatial Spatial
Fulltext Fulltext
Distinct values Distinct values

That's what you mean?Because i created in posts "content2"

[mihai]

#1 SOLVED!!!.Thank you Mario!!!
Can i put this

Code Select Expand

$txt .= _html($_post->content2);

in default.php?

[mihai]

I mean i want to put "content2" in default.php what exactly should i copy/paste

[Marius P.]

So did you manage it or not, cause you got me confused

[mihai]

Yes everything is working fine but now i want to know how to add the "content2" that i just created in default.php becouse i can't figure out how to make that working.

[Marius P.]

default.php is very global, you need to add it to the controller/com for that page.
Where the content is built.
com/com_post.php I assume is your deal.

[mihai]

Tx!!!