Dieses Forum nutzt Cookies

Xris · **17.09.2012**

14061

**rainbowdash28** · **17.09.2012**

14062

Wer da jetzt noch durchblick kriegt ein imaginären Oscar verliehen RD laugh

Und ja der Code ist von mir geschrieben das sieht man.. und keine Sorge im Texteditor ist das Ganze halb so Wild als wie es hier im Forum aussieht..

Code:

function template_preprocess_regions_overview(&$variables, $hook) {

    /* Get ready to start collect all regions/dealer data */

    $regions = array();

    global $user;

    # Write all Regions in an array

    $res = db_query('SELECT * FROM {regions}');

    while($row = db_fetch_array($res))

    $regions[$row['regionid']]['name'] = $row['name'];

    # Write the users that belongs to an region

    $res = db_query('SELECT `uid`,`name`,`regionid`,`dealerid` FROM {users} WHERE `regionid` != 0 AND `dealerid` = 0');

    while($row = db_fetch_array($res))

    $regions[$row['regionid']]['users'][] = array('uid' => $row['uid'], 'name' => $row['name']);

    # Write the nodes that belongs to an region

    $res = db_query('SELECT `nid`,`title`,`regionid`,`dealerid` FROM {node} WHERE `regionid` != 0 AND `dealerid` = 0');

    while($row = db_fetch_array($res))

    $regions[$row['regionid']]['nodes'][] = array('nid' => $row['nid'], 'title' => $row['title']);

    # Write the dealer in the regions array-key

    $res = db_query('SELECT rd.`regionid`,rd.`dealerid`,d.`name` 

     FROM {region_dealer} rd

     INNER JOIN {dealer} d

     ON rd.`dealerid` = d.`dealerid`');

    while($row = db_fetch_array($res)) {

     $regions[$row['regionid']]['dealer'][$row['dealerid']]['name'] = $row['name'];

     # Write the users that belongs to an dealer

     $res2 = db_query('SELECT `uid`,`name`,`regionid`,`dealerid` FROM {users} WHERE `regionid` = %d AND `dealerid` = %d', $row['regionid'], $row['dealerid']);

     while($row2 = db_fetch_array($res2))

     $regions[$row2['regionid']]['dealer'][$row2['dealerid']]['users'][] = array('uid' => $row2['uid'], 'name' => $row2['name']);

     # Write the nodes that belongs to an dealer

     $res3 = db_query('SELECT `nid`,`title`,`regionid`,`dealerid` FROM {node} WHERE `regionid` = %d AND `dealerid` = %d', $row['regionid'], $row['dealerid']);

     while($row3 = db_fetch_array($res3))

     $regions[$row3['regionid']]['dealer'][$row3['dealerid']]['nodes'][] = array('nid' => $row3['nid'], 'title' => $row3['title']);

    }

    $variables['regions'] = $regions;

    drupal_add_css(drupal_get_path('module', 'regions').'/regions.css');

}