• » webSPELL.org - Free Content Management System
  • Language switch: English German

  • login



    » lost password?   » register now

  • About webSPELL

    webSPELL is a free Content Management System which was especially developed for the needs of esport related communities. Since a short while we are also offering an optimized and enhanced webSPELL version for the special requirements of non-profit organisations. The purpose of both systems is to offer a professional and free opportunity to create and administrate your own website in an easy and optimized way.

    » Learn more about webSPELL     » Download webSPELL now!

  • Advertisement

    Follow us

  • Messageboard » webSPELL.Support » DE - Allgemeiner Support » daten von profil.html in squad_content.html!?
    Sort:      1 2 › » printview
    Author
    Message
    webSPELL user
    394 Posts
    07.05.2012, 21:58 offline quote 
    heyhey,

    ich möchte ein paar sachen wie z.b. der name der maus vom profil in der squads_content.html anzeigen lassen und habe gedacht das es mit folgendem code in zeile 40 geht...falsch gedacht, wer kann mir helfen?

    Code:
    1.
    2.
    3.
    4.
    5.
    6.
    7.
    $variable=safe_query('SELECT * FROM ".PREFIX."user WHERE userID=".$id."');
         while($ds=mysql_fetch_array($variable)) {
              $mouse = clearfromtags($ds['mouse']);
              if($mouse == '') $mouse = $_language->module['n_a'];
              $mousepad = clearfromtags($ds['mousepad']);
              if($mousepad == '') $mousepad = $_language->module['n_a'];
         } 



    ich danke euch.
    website: sonstige
    version: 4.2.2 SE
    webSPELL user
    122 Posts
    07.05.2012, 22:35 email offline quote 
    hier $id durch $dm['userID'] ersetzen.

    Gruß
    wasa
    www.webst4rs.de | WEBDESIGN COMMUNITY

    Image-Uploader.de - Bilder hochladen
    webSPELL user
    394 Posts
    08.05.2012, 10:24 offline quote 
    edit:

    deine lösung bringt leider kein unterschied...da wo die variable steht wird nichts angezeigt...auch kein fehler oder so.


    so soll das (ohne formatierung) aussehen:

    Code:
    1.
    2.
    3.
    4.
    5.
    6.
    clanxyz $nickname $country
    $firstname $lastname | $position | $town
    $userdescription
    Tastatur: $keyboard
    Maus: $mouse
    Headset: $connection


    alles andere is klar, wird ausgegeben...aber $keyboard, $mouse, $connection leider nicht.
    webSPELL newbie
    19 Posts
    08.05.2012, 11:20 email offline quote 
    nimm die members seite ist leichter als die squad zwinkern
    webSPELL user
    394 Posts
    08.05.2012, 11:38 offline quote 
    wie meinst du das?

    ich möchte die daten ja in der squadansicht anzeigen bei dem alle mitglieder eines squads angezeigt werden...
    webSPELL newbie
    19 Posts
    08.05.2012, 12:36 email offline quote 
    gib mal index.php?site=members ein lächeln
    Moderator
    1713 Posts
    08.05.2012, 13:31 offline quote 
    Poste mal deine ganze squads.php
    webSPELL user
    394 Posts
    08.05.2012, 13:55 offline quote 
    BlueaKaKev wrote:
    Poste mal deine ganze squads.php



    Code:
    1.
    2.
    3.
    4.
    5.
    6.
    7.
    8.
    9.
    10.
    11.
    12.
    13.
    14.
    15.
    16.
    17.
    18.
    19.
    20.
    21.
    22.
    23.
    24.
    25.
    26.
    27.
    28.
    29.
    30.
    31.
    32.
    33.
    34.
    35.
    36.
    37.
    38.
    39.
    40.
    41.
    42.
    43.
    44.
    45.
    46.
    47.
    48.
    49.
    50.
    51.
    52.
    53.
    54.
    55.
    56.
    57.
    58.
    59.
    60.
    61.
    62.
    63.
    64.
    65.
    66.
    67.
    68.
    69.
    70.
    71.
    72.
    73.
    74.
    75.
    76.
    77.
    78.
    79.
    80.
    81.
    82.
    83.
    84.
    85.
    86.
    87.
    88.
    89.
    90.
    91.
    92.
    93.
    94.
    95.
    96.
    97.
    98.
    99.
    100.
    101.
    102.
    103.
    104.
    105.
    106.
    107.
    108.
    109.
    110.
    111.
    112.
    113.
    114.
    115.
    116.
    117.
    118.
    119.
    120.
    121.
    122.
    123.
    124.
    125.
    126.
    127.
    128.
    129.
    130.
    131.
    132.
    133.
    134.
    135.
    136.
    137.
    138.
    139.
    140.
    141.
    142.
    143.
    144.
    145.
    146.
    147.
    148.
    149.
    150.
    151.
    152.
    153.
    154.
    155.
    156.
    157.
    158.
    159.
    160.
    161.
    162.
    163.
    164.
    165.
    166.
    167.
    168.
    169.
    170.
    171.
    172.
    173.
    174.
    175.
    176.
    177.
    178.
    179.
    180.
    181.
    182.
    183.
    184.
    185.
    186.
    187.
    188.
    189.
    190.
    191.
    192.
    193.
    194.
    195.
    196.
    197.
    198.
    199.
    200.
    201.
    <?php
    /*
    ##########################################################################
    #                                                                        #
    #           Version 4       /                        /   /               #
    #          -----------__---/__---__------__----__---/---/-               #
    #           | /| /  /___) /   ) (_ `   /   ) /___) /   /                 #
    #          _|/_|/__(___ _(___/_(__)___/___/_(___ _/___/___               #
    #                       Free Content / Management System                 #
    #                                   /                                    #
    #                                                                        #
    #                                                                        #
    #   Copyright 2005-2011 by webspell.org                                  #
    #                                                                        #
    #   visit webSPELL.org, webspell.info to get webSPELL for free           #
    #   - Script runs under the GNU GENERAL PUBLIC LICENSE                   #
    #   - It's NOT allowed to remove this copyright-tag                      #
    #   -- http://www.fsf.org/licensing/licenses/gpl.html                    #
    #                                                                        #
    #   Code based on WebSPELL Clanpackage (Michael Gruber - webspell.at),   #
    #   Far Development by Development Team - webspell.org                   #
    #                                                                        #
    #   visit webspell.org                                                   #
    #                                                                        #
    ##########################################################################
    */

    $_language->read_module('squads');

    eval ("\$title_squads = \"".gettemplate("title_squads")."\";");
    echo $title_squads;
    if(isset($_GET['action'])) $action = $_GET['action'];
    else $action = "";
    if($action=="show") {
         if($_GET['squadID']) {
              $getsquad = 'WHERE squadID="'.(int)$_GET['squadID'].'"';
         }
         else $getsquad = '';

         $variable=safe_query("SELECT * FROM ".PREFIX."user WHERE userID='".$dm['userID']."'");
         while($ds=mysql_fetch_array($variable)) {
              $mouse = clearfromtags($ds['mouse']);
              if($mouse == '') $mouse = $_language->module['n_a'];
              $mousepad = clearfromtags($ds['mousepad']);
              if($mousepad == '') $mousepad = $_language->module['n_a'];
         } 

         $ergebnis=safe_query("SELECT * FROM ".PREFIX."squads ".$getsquad." ORDER BY sort");
         while($ds=mysql_fetch_array($ergebnis)) {

         
              $mouse = clearfromtags($ds['mouse']);
              if($mouse == '') $mouse = $_language->module['n_a'];
              $mousepad = clearfromtags($ds['mousepad']);
              if($mousepad == '') $mousepad = $_language->module['n_a'];
              $anzmembers=mysql_num_rows(safe_query("SELECT sqmID FROM ".PREFIX."squads_members WHERE squadID='".$ds['squadID']."'"));
              if($anzmembers == 1) $anzmembers = $anzmembers.' '.$_language->module['member'];
              else $anzmembers = $anzmembers.' '.$_language->module['members'];
              $name='<b>'.$ds['name'].'</b>';
              $squadID=$ds['squadID'];
              $backlink='&raquo; <a href="index.php?site=squads"><b>'.$_language->module['back_squad_overview'].'</b></a>';
              $results='';
              $awards='';
              $challenge='';
              $games='';
              if($ds['icon']) $icon='<a href="index.php?site=squads&amp;action=show&amp;squadID='.$ds['squadID'].'"><img src="images/squadicons/'.$ds['icon'].'" border="0" alt="'.htmlspecialchars($ds['name']).'" /></a>';
              else $icon='';
              $border=BORDER;
         
              if($ds['gamesquad']) {
                   $results='[ <a href="index.php?site=clanwars&amp;action=showonly&amp;id='.$squadID.'&amp;sort=date&amp;only=squad">'.$_language->module['results'].'</a> | ';
                   $awards='<a href="index.php?site=awards&amp;action=showsquad&amp;squadID='.$squadID.'&amp;page=1">'.$_language->module['awards'].'</a> | ';
                   $challenge='<a href="index.php?site=challenge">'.$_language->module['challenge'].'</a> ]';
                   $games = $ds['games'];
                   if($games) {
                        $games = str_replace(";", ", ", $games);
                        $games = $_language->module['squad_plays'].": ".$games;
                   }
              }

              $member=safe_query("SELECT * FROM ".PREFIX."squads_members s, ".PREFIX."user u WHERE s.squadID='".$ds['squadID']."' AND s.userID = u.userID ORDER BY sort");
              eval("\$squads_head = \"".gettemplate("squads_head")."\";");
              echo $squads_head;
              
              $i=1;
              while($dm=mysql_fetch_array($member)) {

                   if($i%2) {
                        $bg1=BG_1;
                        $bg2=BG_2;
                   }
                   else {
                        $bg1=BG_3;
                        $bg2=BG_4;
                   }
                   
                   
                   $connection = clearfromtags($ds['verbindung']);
              if($connection == '') $connection = $_language->module['n_a'];
              $keyboard = clearfromtags($ds['keyboard']);
              if($keyboard == '') $keyboard = $_language->module['n_a'];
              $mouse = clearfromtags($ds['mouse']);
              if($mouse == '') $mouse = $_language->module['n_a'];
                   $country = ''.$dm['country'].'';
                   $country = flags($country);
                   $nickname = '<a class="spielerprofil_font" href="index.php?site=profile&amp;id='.$dm['userID'].'"><b>'.strip_tags(stripslashes($dm['nickname'])).'</b></a>';
                   $nicknamee = strip_tags(stripslashes($dm['nickname']));
                   $profilid = $dm['userID'];

                   if($dm['userdescription']) $userdescription=htmloutput($dm['userdescription']);
                   else $userdescription=$_language->module['no_description'];

                   if ($dm['userpic']!="" and file_exists("images/userpics/".$dm['userpic'])) {
                        $userpic = $dm['userpic'];
                        $pic_info = $dm['nickname'].' '.$_language->module['userpicture'];
                   }
                   else {
                        $userpic = "nouserpic.gif";
                        $pic_info = $_language->module['no_userpic'];
                   }

                   $icq = $dm['icq'];
                   if(getemailhide($dm['userID'])) $email = '';
                   else $email = '<a href="mailto:'.mail_protect($dm['email']).'"><img src="images/icons/email.gif" border="0" alt="'.$_language->module['email'].'" /></a>';

                   $pm = '';
                   $buddy = '';
                   if ($loggedin && $dm['userID'] != $userID) {
                        $pm='<a href="index.php?site=messenger&amp;action=touser&amp;touser='.$dm['userID'].'"><img src="images/icons/pm.gif" border="0" alt="'.$_language->module['messenger'].'" /></a>';

                        if (isignored($userID, $dm['userID'])) $buddy='<a href="buddys.php?action=readd&amp;id='.$dm['userID'].'&amp;userID='.$userID.'"><img src="images/icons/buddy_readd.gif" border="0" alt="'.$_language->module['back_buddy'].'" /></a>';
                        elseif(isbuddy($userID, $dm['userID'])) $buddy='<a href="buddys.php?action=ignore&amp;id='.$dm['userID'].'&amp;userID='.$userID.'"><img src="images/icons/buddy_ignore.gif" border="0" alt="'.$_language->module['ignore'].'" /></a>';
                        else $buddy='<a href="buddys.php?action=add&amp;id='.$dm['userID'].'&amp;userID='.$userID.'"><img src="images/icons/buddy_add.gif" border="0" alt="'.$_language->module['add_buddy'].'" /></a>';
                   }

                   if(isonline($dm['userID'])=="offline") $statuspic='<img src="images/icons/offline.gif" alt="offline" />';
                   else $statuspic='<img src="images/icons/online.gif" alt="online" />';

                   $position = $dm['position'];
                   $firstname = strip_tags($dm['firstname']);
                   $lastname = strip_tags($dm['lastname']);
                   $town = strip_tags($dm['town']);
                   if($dm['activity']) $activity='<font color="'.$wincolor.'">'.$_language->module['active'].'</font>';
                   else $activity='<font color="'.$loosecolor.'">'.$_language->module['inactive'].'</font>';

                   eval ("\$squads_content = \"".gettemplate("squads_content")."\";");
                   echo $squads_content;
                   $i++;
              }
              eval ("\$squads_foot = \"".gettemplate("squads_foot")."\";");
              echo $squads_foot;
         }
    }

    else {
          $getsquad = "";
         if(isset($_GET['squadID'])) {
              $getsquad = 'WHERE squadID="'.$_GET['squadID'].'"';
         }

         $ergebnis=safe_query("SELECT * FROM ".PREFIX."squads ".$getsquad." ORDER BY sort");
         
      $i=1;
      while($ds=mysql_fetch_array($ergebnis)) {
      
        if($i%2) {
          $bg1=BG_1;
          $bg2=BG_2;
        }
        else {
          $bg1=BG_3;
          $bg2=BG_4;
        }
        
        $anzmembers=mysql_num_rows(safe_query("SELECT sqmID FROM ".PREFIX."squads_members WHERE squadID='".$ds['squadID']."'"));
              if($anzmembers == 1) $anzmembers = $anzmembers.' '.$_language->module['member'];
              else $anzmembers = $anzmembers.' '.$_language->module['members'];
              $name=' <a href="index.php?site=squads&amp;action=show&amp;squadID='.$ds['squadID'].'"><b>'.$ds['name'].'</b></a>';
              if($ds['icon']) $icon='<a href="index.php?site=squads&amp;action=show&amp;squadID='.$ds['squadID'].'"><img src="images/squadicons/'.$ds['icon'].'" border="0" alt="'.htmlspecialchars($ds['name']).'" /></a>';
              else $icon='';
              $info=htmloutput($ds['info']);
              $details='&raquo; <a href="index.php?site=squads&amp;action=show&amp;squadID='.$ds['squadID'].'"><b>'.$_language->module['show_details'].'</b></a>';
              $squadID=$ds['squadID'];
              $results='';
              $awards='';
              $challenge='';

              if($ds['gamesquad']) {
                   $results='[ <a href="index.php?site=clanwars&amp;action=showonly&amp;id='.$squadID.'&amp;sort=date&amp;only=squad">'.$_language->module['results'].'</a> | ';
                   $awards='<a href="index.php?site=awards&amp;action=showsquad&amp;squadID='.$squadID.'&amp;page=1">'.$_language->module['awards'].'</a> | ';
                   $challenge='<a href="index.php?site=challenge">'.$_language->module['challenge'].'</a> ]';
              }

              $bgcat=BGCAT;
              eval ("\$squads = \"".gettemplate("squads")."\";");
              echo $squads;
        
        $i++;
         }
    }
    ?>
    Moderator
    1713 Posts
    08.05.2012, 14:16 offline quote 
    read more Mehr lesen


    Schau mal ob es klappt, wenn du es in der action=show haben willst, sollte das klappen.
    webSPELL user
    394 Posts
    08.05.2012, 14:36 offline quote 
    ich möchte es in der "index.php?site=squads&action=show&squadID=1" haben zwinkern
    Sort:      1 2 › » printview


    To start or to reply to a topic you have to be registered and logged in!

    • register now
    • login
  • » Support
    FAQ
    FORUM
    IRC
    WIKI
    » Topics
    26.05.2013 - 09:11 - 0 Replies
    » v3 2radhobbywerkstatt
    v3 2radhobbywerkstatt
    Last post: nappel.ger
    Board: DE - Showroom
    26.05.2013 - 09:11
    26.05.2013 - 00:18 - 473 Replies
    » Wettscript 2.1 for 4.2.3a...
    Wettscript 2.1 for 4.2.3a - Betscript
    Last post: Amokossi
    Board: DE - Fertige Skripte
    26.05.2013 - 00:18
    25.05.2013 - 22:46 - 0 Replies
    » Clanwar News!
    Clanwar News!
    Last post: Maverico
    Board: DE - Anfragen
    25.05.2013 - 22:46
    25.05.2013 - 19:01 - 1 Replies
    » Error 1146
    Error 1146
    Last post: Argu
    Board: EN - Technical support
    25.05.2013 - 19:01
    25.05.2013 - 17:51 - 0 Replies
    » Gewinnspiel
    Gewinnspiel
    Last post: Dynamic-Webmedia
    Board: DE - Aus aller Welt
    25.05.2013 - 17:51
    25.05.2013 - 12:35 - 1 Replies
    » Need coder for a design!
    Need coder for a design!
    Last post: wantedJK-
    Board: EN - General
    25.05.2013 - 12:35
    25.05.2013 - 03:18 - 0 Replies
    » ScooterFreakz.com - Motor...
    ScooterFreakz.com - Motorroller Community
    Last post: Tuner77
    Board: DE - Showroom
    25.05.2013 - 03:18
    25.05.2013 - 00:46 - 8 Replies
    » Ändern der Größe php
    Ändern der Größe php
    Last post: andy5116
    Board: DE - Allgemeiner Support
    25.05.2013 - 00:46
    24.05.2013 - 23:39 - 33 Replies
    » [B]Userrank Addon
    [B]Userrank Addon
    Last post: Swordfish3000
    Board: DE - Erweiterungen
    24.05.2013 - 23:39
    24.05.2013 - 15:12 - 19 Replies
    » forum anzeige erweitern
    forum anzeige erweitern
    Last post: Swordfish3000
    Board: DE - Allgemeiner Support
    24.05.2013 - 15:12
    24.05.2013 - 12:03 - 1 Replies
    » Verkaufe prof. Clandesign
    Verkaufe prof. Clandesign
    Last post: Vith3r
    Board: DE - Biete
    24.05.2013 - 12:03
    24.05.2013 - 12:02 - 6 Replies
    » [S] Team/Clan Logos (Upda...
    [S] Team/Clan Logos (Update: 2 new Logos)
    Last post: a--w
    Board: EN - Offers
    24.05.2013 - 12:02
    24.05.2013 - 02:41 - 17 Replies
    » High Quality Website
    High Quality Website
    Last post: Dansjostedt
    Board: EN - Offers
    24.05.2013 - 02:41
    24.05.2013 - 02:24 - 5 Replies
    » [SELL] Gaming Website
    [SELL] Gaming Website
    Last post: hornyst
    Board: EN - Offers
    24.05.2013 - 02:24
    23.05.2013 - 22:37 - 2 Replies
    » Bilder Breite im Forum an...
    Bilder Breite im Forum anpassen
    Last post: nappel.ger
    Board: DE - Vorschläge
    23.05.2013 - 22:37
    23.05.2013 - 15:35 - 6 Replies
    » I cannot upload template ...
    I cannot upload template to my cms .
    Last post: bazic
    Board: EN - General
    23.05.2013 - 15:35
    23.05.2013 - 14:50 - 3 Replies
    » Kalendar-Box
    Kalendar-Box
    Last post: kassor
    Board: DE - Anfragen
    23.05.2013 - 14:50
    23.05.2013 - 10:14 - 12 Replies
    » Mein Forum
    Mein Forum
    Last post: Lordy4007
    Board: DE - Fragen zur Seite
    23.05.2013 - 10:14
    22.05.2013 - 23:06 - 9 Replies
    » When the update?
    When the update?
    Last post: kola60
    Board: EN - General
    22.05.2013 - 23:06
    22.05.2013 - 22:21 - 2 Replies
    » Website For SALE! CODED
    Website For SALE! CODED
    Last post: Osamakillz
    Board: EN - General
    22.05.2013 - 22:21
    » Partners
    Bilderkiste.org Image Hosting
    k3rmit.org
    PascalMh.de

    » Blog
    28.03.2013 - derchris
    » Those damn spammers
    13.03.2013 - blue.tiger
    » Development thoughts
    12.09.2012 - derchris
    » Annual webSPEL meeting - Be...
    08.09.2011 - k3rmit
    » webSPELL meeting 2011 Düsse...
    25.08.2010 - k3rmit
    » Another year, another time,...