Titlul spune tot , tin rotund sa fie patrat , am mai postat ceva asemanator acu' cateva luni dar vad ca acuma nu mai merge , poate pentru ca si tema e alta ( folosesc Zaroon Black ) .
+ Mai am o problema , am incercat sa urmaresc tutorialul asta : http://lkozma.net/blog/phpbb-recent-posts-widget/
Am modificat in sidebar am adaugat recent-widget.php , am bagat database-ul insa tot imi zice ca nu poate face conexiunea , am facut alt db si aceasi problema .
Modificarea forma avatarului din viewtopic si sidebar&recent
Moderators: Moderatori ajutatori, Moderatori
- FizZle
- Membru, skill +4
- Posts: 1622
- Joined: 17 Jan 2015, 19:33
- Detinator Steam: Da
- Detinator server CS: da
- SteamID: berserknorse
- Fond eXtream: 0
- Location: Iasi
- Has thanked: 21 times
- Been thanked: 26 times
- Contact:
Forma , conturul .. e rotund , vreau sa-l fac normal dreptunghiularAndreeas. wrote:Ce vrei sa modifici mai exact la avatar?
-
- Fost administrator
- Posts: 13713
- Joined: 09 Oct 2010, 12:39
- Detinator Steam: Da
- CS Status: In grajd!
- SteamID: kalulord
- Reputatie: Fost Administrator
Fost membru Club eXtreamCS (6 luni)
Nume anterior: Terra - Location: Romania, Ploiesti
- Has thanked: 328 times
- Been thanked: 646 times
- Contact:
Pentru alte customizari imi poti trimite PM dar te costa, sa imi spui daca iti functioneaza.
Javascript
Widget php page
Javascript
Code: Select all
<script>
$( document ).ready(function() {
var filePath = './widget_phpbb.php';
$('.widget').load(filePath);
$('.displaySummary').click(function(){
$('.showSummary').toggle();
});
});
</script>
Code: Select all
<?php
function summary($str, $limit = 200, $strip = false) {
$str = ($strip == true)?strip_tags($str):$str;
if (strlen ($str) > $limit) {
$str = substr ($str, 0, $limit - 3);
return trim(substr ($str, 0, strrpos ($str, ' ')).'...');
}
return trim($str);
}
/*
Widget PHPBB :: MySQLI
*/
$server = array(
'hostname' => '', //deobicei este localhost, daca ai database in alta parte pui hostname sau ip de la serverul mysql.
'mysql_user' => '', //userul de la baza de date
'mysql_password' => '', //parola de la userul mysql
'database' => '', //numele la baza de date pentru userul tau
'path' => '', //path to forum
/*
e.g: http://extreamcs.com/forum
http://extreamcs.com
http://forum.extreamcs.com
Slashes sunt puse deja
*/
);
//Initializam conexiunea la baza de date
$db = new mysqli($server['hostname'], $server['mysql_user'], $server['mysql_password'], $server['database']);
//Verificam daca s-a conectat
if($db->connect_error){
trigger_error('Database connection failed: ' . $db->connect_error, E_USER_ERROR);
}
//interogare, afiseaza doar 5 rezultate in ordine descrescatoare.
$query = "SELECT phpbb_posts.post_time AS post_time, phpbb_posts.post_text AS post_text, phpbb_posts.topic_id AS tid, phpbb_posts.forum_id AS fid, phpbb_topics.topic_title AS topic_title, phpbb_users.username AS username, phpbb_posts.post_username AS anon
FROM phpbb_posts, phpbb_topics, phpbb_users WHERE post_approved = 1 AND phpbb_posts.topic_id=phpbb_topics.topic_id AND phpbb_posts.poster_id=phpbb_users.user_id ORDER BY post_time DESC LIMIT 5";
$result = $db->query($query);
if($result === false){
trigger_error('Wrong SQL: ' . $query . ' Error: ' . $db->error, E_USER_ERROR);
} else {
$items = $result->num_rows;
}
$result->data_seek(0);
while($row = $result->fetch_assoc()){
$k = array(
'POST_TIME' => strftime('%A, %d. %b. %Y', $row['post_time']),
'USERNAME' => ($row['username']=="Anonymous")?$row['anon']:$row['username'],
'POSTSUMMARY' => preg_replace('/\[[^\]]*\]/', '', $row['post_text']),
);
print '
<tr>
<td>
<a href="'.$server['path'].'/viewtopic.php?f='.$row['fid'].'&t='.$row['tid'].'">
<b>'.$row['topic_title'].'</b> (<i>Posted '.$k['POST_TIME'].'</i>)
</a>
<p>
<button class="displaySummary">Show topic summary</button>
<div class="showSummary">'.$k['POSTSUMMARY'].'</div>
</p>
</td>
</tr>
';
}
?>