26-03-2011, 04:33 PM
26-03-2011, 04:46 PM
you would have to edit the function which shows the videos.
there are two lines which you would have to edit.
CODE REMOVED
NOTE:
I do not currently have a site up, so this code is untested.
It is also a wise idea, to save a copy of the original functions.php file before making changes to it.
As for multiple categories, maybe you can add that into the requests forum.
there are two lines which you would have to edit.
CODE REMOVED
NOTE:
I do not currently have a site up, so this code is untested.
It is also a wise idea, to save a copy of the original functions.php file before making changes to it.
As for multiple categories, maybe you can add that into the requests forum.
26-03-2011, 06:11 PM
I try it but shows only number of category
I add '<br>added:'.urldecode($row['tarih']).'
Kind Regards
Svetoslav
PS: Congratulations for position you earn!!! Wish you well.
I add '<br>added:'.urldecode($row['tarih']).'
Kind Regards
Svetoslav
PS: Congratulations for position you earn!!! Wish you well.
(26-03-2011 04:46 PM)Punktured Wrote: [ -> ]you would have to edit the function which shows the videos.
there are two lines which you would have to edit.
CODE REMOVED
NOTE:
I do not currently have a site up, so this code is untested.
It is also a wise idea, to save a copy of the original functions.php file before making changes to it.
As for multiple categories, maybe you can add that into the requests forum.
26-03-2011, 06:43 PM
oh ok, sorry about that.
i forgot how the mysql table was.
i havent got a site so i cant make the proper code you want,
because i cant test it.
by the way, tarih is not url encoded so you dont need to decode it.
i forgot how the mysql table was.
i havent got a site so i cant make the proper code you want,
because i cant test it.
by the way, tarih is not url encoded so you dont need to decode it.
27-03-2011, 01:04 AM
tarih=date
at mysql in table video fiield=category is an id that shows the id nuber of category table id number
so you must to connect category field to find the category name
at mysql in table video fiield=category is an id that shows the id nuber of category table id number
so you must to connect category field to find the category name
27-03-2011, 01:54 AM
yea, when i did have my site,
i did have the code for this, because i did it on my own site.
but i dont have the site anymore, and i have nowhere to test code,
so i rather not post anymore untested code at this time.
when i find a free-adult-host and get a site up,
i will re-do the code and post it here.
i did have the code for this, because i did it on my own site.
but i dont have the site anymore, and i have nowhere to test code,
so i rather not post anymore untested code at this time.
when i find a free-adult-host and get a site up,
i will re-do the code and post it here.
27-03-2011, 05:38 AM
ok, well, you know how to add "date added" so i will show code just to add category.
there is 2 lines which need replaced, and replaced with extra code.
line 1 , replace:
with this:
line 2 , replace:
with this:
there is 2 lines which need replaced, and replaced with extra code.
line 1 , replace:
Code:
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a></td>';
with this:
Code:
$cat_id = $row['category'];
$sql_sorgu3="Select * from category where `id` = '$cat_id'";
$result3 = mysql_query($sql_sorgu3);
while($row3 = mysql_fetch_array($result3))
{
$category = $row3['category'];
}
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a><br>Category: '.$category.'</td>';
line 2 , replace:
Code:
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a></td>';
with this:
Code:
$cat_id = $row['category'];
$sql_sorgu3="Select * from category where `id` = '$cat_id'";
$result3 = mysql_query($sql_sorgu3);
while($row3 = mysql_fetch_array($result3))
{
$category = $row3['category'];
}
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a><br>Category: '.$category.'</td>';
27-03-2011, 11:21 AM
It works perfect, but it not conver text in utf-8 and show some signs
Thank you in advance
Thank you in advance
(27-03-2011 05:38 AM)Punktured Wrote: [ -> ]ok, well, you know how to add "date added" so i will show code just to add category.
there is 2 lines which need replaced, and replaced with extra code.
line 1 , replace:
Code:
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a></td>';
with this:
Code:
$cat_id = $row['category'];
$sql_sorgu3="Select * from category where `id` = '$cat_id'";
$result3 = mysql_query($sql_sorgu3);
while($row3 = mysql_fetch_array($result3))
{
$category = $row3['category'];
}
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a><br>Category: '.$category.'</td>';
line 2 , replace:
Code:
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a></td>';
with this:
Code:
$cat_id = $row['category'];
$sql_sorgu3="Select * from category where `id` = '$cat_id'";
$result3 = mysql_query($sql_sorgu3);
while($row3 = mysql_fetch_array($result3))
{
$category = $row3['category'];
}
$data=$data.'<td valign="top"><a href="'.$root_url.$linki.'"><div align="center"><img multiple_thumbnail_url="g" class="video-thumb" border="0" src="'.$root_url.'img/thumb/'.$row['v_id'].'_0.jpg" num="'.$row['num'].'" id="thumb'.($i+1).'" alt="'.urldecode($row['title']).'" width="160" height="120" /></div>'.urldecode($row['title']).'</a><br>Category: '.$category.'</td>';
27-03-2011, 12:06 PM
can you send me your site URL in private message please, so i can see what you mean.