• » 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

  • Sort:      «  1 2 printview


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

    register now
    login
    Author
    Message
    webSPELL user
    394 Posts
    09.05.2012, 17:22 offline quote 

    nun gehts, danke dir...hab vorhin was falsches gelesen...hast einfach meine zeilen ein paar zeilen weiter unten eingefügt ne?
    Moderator
    1713 Posts
    09.05.2012, 14:22 offline quote 

    read more Mehr lesen


    müsste gehen, klappt zumindestens bei mir.
    webSPELL user
    394 Posts
    09.05.2012, 14:10 offline quote 

    BlueaKaKev wrote:

    Ich hab dir den Code doch gepostet .... Funktioniert er nicht oder was ?


    nein leider nicht...bei dieser url "index.php?site=squads&action=show"...wird leider nichts bei der variablen ausgegeben :/


    vllt ist die frage jetzt blöd...aber muss man nicht die daten aus der .prefix.user auslesen und nicht von der .prefix.squad?...denn ich speicher doch alles in die user tabelle und nicht in die squad tabelle wenn ich im profil was eintrage!?
    Moderator
    1713 Posts
    09.05.2012, 13:40 offline quote 

    Ich hab dir den Code doch gepostet .... Funktioniert er nicht oder was ?
    webSPELL user
    394 Posts
    09.05.2012, 13:32 offline quote 

    pushing?
    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
    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, 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, 13:31 offline quote 

    Poste mal deine ganze squads.php
    webSPELL newbie
    19 Posts
    08.05.2012, 12:36 email offline quote 

    gib mal index.php?site=members ein lächeln
    Sort:      «  1 2 printview


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

    register now
    login
  • » Support

    » Topics
    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
    22.05.2013 - 21:43 - 3 Replies
    » Slider Links Bitte um Hil...
    Slider Links Bitte um Hilfe
    Last post: bazic
    Board: DE - Allgemein
    22.05.2013 - 21:43
    » Partners
    Bilderkiste.org Image Hosting
    k3rmit.org
    PascalMh.de


    » Blog
    28.03.2013 - derchris
    » Those damn spammers