The page you requested does not exist. A search for forumi forum kaktusi fotografija šimfarska kamra feed resulted in this page.

Nekaj uporabnih php kod

5 odgovorov [Zadnji prispevek]
Ned, 29/11/2009 - 19:34
Zvone
Slika uporabnika Zvone
Prisoten
Član od: 27/10/2009

Za testiranje sem uporabil nekaj uporabih php snipetov. Če koga zanima, naj me porufa, lahk pa jo sname iz kode. Lahk pa jo sname tudi iz uradne strani Drupal. Pet forumov z najbolj aktivnimi temami:

?php $num_nodes = 5; $sql = " SELECT DISTINCT(tn.tid), td.name FROM {node} n LEFT JOIN {term_node} tn ON n.nid = tn.nid LEFT JOIN {term_data} td ON tn.tid = td.tid LEFT JOIN {node_counter} nc ON n.nid = nc.nid WHERE n.type = 'forum' ORDER BY nc.totalcount ASC"; $result = db_query_range(db_rewrite_sql($sql), 0, $num_nodes); while($row = db_fetch_object($result)) { $list[] = l($row->name, "forum/$row->tid"); } print theme('item_list', $list); ?>

Rezultat:

Taksonomski pojmi po abecednem redu:

?php /** * Creates a list of taxonomy terms without description in alphabetical order. * Each term links to the corresponding edit form. */ $query = "SELECT tid, name from {term_data} WHERE description = '' ORDER BY name ASC"; $result = db_query($query); while ($term = db_fetch_object($result)) { $items[]= l($term->name, "admin/content/taxonomy/edit/term/$term->tid"); } if(count($items)) { return theme('item_list',$items); } ?>

Rezultat:

Vrh
Ned, 29/11/2009 - 20:01
#1
Zvone
Slika uporabnika Zvone
Prisoten
Član od: 27/10/2009
Seznam blogov

Seznam vseh blogerjev:
?php global $user; if($user->uid) { print "

    \n"; $result = db_query("SELECT DISTINCT u.name, u.uid FROM {users} u INNER JOIN {node} n ON n.uid = u.uid WHERE n.type = 'blog' ORDER BY u.name"); while ($node = db_fetch_object($result)) { print "
  • ".l(ucwords($node->name), 'blog/' . $node->uid)."\n"; $latestr = db_query("SELECT n.title, n.nid FROM {node} n WHERE n.type = 'blog' AND n.uid=%d ORDER BY n.created DESC",$node->uid); } print "
"; } ?>

Rezultat:<?php
global $user;
if($user->uid) { print "

    \n"; $result = db_query("SELECT DISTINCT u.name, u.uid FROM {users} u INNER JOIN {node} n ON n.uid = u.uid WHERE n.type = 'blog' ORDER BY u.name"); while ($node = db_fetch_object($result)) { print "
  • ".l(ucwords($node->name), 'blog/' . $node->uid)."\n"; $latestr = db_query("SELECT n.title, n.nid FROM {node} n WHERE n.type = 'blog' AND n.uid=%d ORDER BY n.created DESC",$node->uid); } print "
"; } ?>
Seznam blogerjev z največ objavami:
?php global $user; if($user->uid) { print "
    \n"; // select all the unique UID "blog" nodes, then join them with users and away we should go $result = db_query("SELECT DISTINCT u.name, u.uid FROM {users} u INNER JOIN {node} n ON n.uid = u.uid WHERE n.type = 'blog' ORDER BY u.name"); while ($node = db_fetch_object($result)) { print "
  • ".l(ucwords($node->name), 'blog/' . $node->uid)."\n"; $latestr = db_query("SELECT n.title, n.nid FROM {node} n WHERE n.type = 'blog' AND n.uid=%d ORDER BY n.created DESC",$node->uid); if($latestn = db_fetch_object($latestr)) { print "
      \n"; print "
    • ".l($latestn->title, 'node/'.$latestn->nid)."\n"; print "
    \n"; } } print "
"; } ?>

Rezultat:<?php
global $user;
if($user->uid) { print "

    \n"; // select all the unique UID "blog" nodes, then join them with users and away we should go $result = db_query("SELECT DISTINCT u.name, u.uid FROM {users} u INNER JOIN {node} n ON n.uid = u.uid WHERE n.type = 'blog' ORDER BY u.name"); while ($node = db_fetch_object($result)) { print "
  • ".l(ucwords($node->name), 'blog/' . $node->uid)."\n"; $latestr = db_query("SELECT n.title, n.nid FROM {node} n WHERE n.type = 'blog' AND n.uid=%d ORDER BY n.created DESC",$node->uid); if($latestn = db_fetch_object($latestr)) { print "
      \n"; print "
    • ".l($latestn->title, 'node/'.$latestn->nid)."\n"; print "
    \n"; } } print "
"; } ?>

Vrh
Ned, 29/11/2009 - 20:13
#2
Zvone
Slika uporabnika Zvone
Prisoten
Član od: 27/10/2009
Najbolj aktivni komentatorji

10 najbolj aktivnih komentatorjev; za kakšno drugo število vpiši drugačen LIMIT
?php $users = db_query("SELECT COUNT(cid) AS count, name, uid FROM {comments} WHERE uid != 1 and uid != 0 GROUP BY uid ORDER BY count DESC LIMIT 10"); $output = "

    "; while ($user = db_fetch_object($users)) { $output .= "
  • " . l($user->name, drupal_get_path_alias("user/{$user->uid}")). " ($user->count)"; } $ouput .= "
"; echo $output; ?>

Rezultat<?php
$users = db_query("SELECT COUNT(cid) AS count, name, uid FROM {comments} WHERE uid != 1 and uid != 0 GROUP BY uid ORDER BY count DESC LIMIT 10");

$output = "

    ";
    while ($user = db_fetch_object($users)) {
    $output .= "
  • " . l($user->name, drupal_get_path_alias("user/{$user->uid}")). " ($user->count)"; } $ouput .= "
      "; echo $output; ?>

    Vrh
    Ned, 29/11/2009 - 20:20
    #3
    Zvone
    Slika uporabnika Zvone
    Prisoten
    Član od: 27/10/2009
    Total števec uporabnkov, tem in sporočil

    ?php $count[users] = db_result(db_query("SELECT COUNT(*) FROM {users}")); $count[topics] = db_result(db_query("SELECT COUNT(*) FROM {node} WHERE type = 'forum'")); $count[comments] = db_result(db_query("SELECT COUNT(*) FROM {node n}, {comments c} WHERE n.type = 'forum' AND n.nid = c.nid")); $output = "

    "; $output .= t("%count_users online user, %forum_topics topics and %forum_comments posts on the forum", array('%count_users' => $count[users], '%forum_topics' => $count[topics], '%forum_comments' => $count[comments])); $output .= "

    "; return $output; ?>

    Rezultat:

    138 online user, 838 topics and 9108 posts on the forum

    Vrh
    Ned, 29/11/2009 - 20:24
    #4
    Zvone
    Slika uporabnika Zvone
    Prisoten
    Član od: 27/10/2009
    Menu

    Izpiše primarni menu

    ?php $tree = menu_tree_page_data('primary-links'); echo menu_tree_output($tree); ?>

    Rezultat:

    Vrh
    Ned, 29/11/2009 - 20:33
    #5
    Zvone
    Slika uporabnika Zvone
    Prisoten
    Član od: 27/10/2009
    Random sporočilo

    Snippet prikaže random sporočilo v bloku. Ustvariš blok in vanj dodaj snippet. Uporabno za random nasvete, pomoč, reklame...

    ?php global $user; $tips = array( 'Kar neki tekst', 'Zdajle je že drugi', 'Lahk dodaš tud link na AstroKaktus, če češ', 'Usmeri uporabnika na njegov "uporabniški račun"', ); return $tips[rand(0,count($tips)-1)]; ?>

    Rezultat:

    Lahk dodaš tud link na AstroKaktus, če češ
    Vrh