• » 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.Addons + Mods » DE - Fertige Skripte » [Addon] User Status Addon
    Sort:      « ‹ 1 2 3 › » printview


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

    • register now
    • login
    Author
    Message
    webSPELL user
    198 Posts
    26.12.2011, 20:18 email offline quote 
    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.
    <?php
    /***************************************************
    -------------------Change here----------------------
    ***************************************************/
    $limit = 20;

    /***************************************************
    ----------------Don't change here-------------------
    ***************************************************/
    $abfrage = "
    SELECT u.*, s.* 
    FROM ".PREFIX."user u
    LEFT JOIN ".PREFIX."user_status s
    ON s.userID = u.userID
    WHERE s.statusID > 0
    ORDER BY statusID DESC LIMIT $limit";

    $ergebnis = mysql_query($abfrage);

    echo '
    <table width="100%">
    <tr>
    <tr width="100%" bgcolor="#E2E2E2"><b>Last userstatus</b></tr>
    </tr>
    <td width="5%" bgcolor="#E2E2E2"><b>ID</b></td>
    <td width="20%" bgcolor="#E2E2E2"><b>Playername</b></td>
    <td width="75%" bgcolor="#E2E2E2"><b>Playerstatus</b></td>
    </table>
    ';

    $userlist=",";
    while($row = mysql_fetch_object($ergebnis))
    {
       if(strpos(",".$row->userID,$userlist)==false){
         $statusid = $row->statusID;
         $name = $row->nickname;
         $status = $row->status;
         $userlist=$userlist.",".$row->userID;
       }

    echo '
    <table width="100%">
         <tr>
              <td width="5%" bgcolor="#E2E2E2">'.$statusid.'</td>
              <td width="20%" bgcolor="#E2E2E2">'.$name.'</td>
              <td width="75%" bgcolor="#E2E2E2">'.$status.'</td>
         </tr>
    </table>
    ';
    }
    ?>


    Try this to avoid multiple list entrys of User. And yes - It would be possible to show just 1 users info on click, but thats a bit more complicated.

    But have a try for the code above, it's untested and written on the mobile phone, but I hope it works.

    Greetings.
    webSPELL newbie
    93 Posts
    26.12.2011, 15:42 email offline quote 
    Hchest wrote:
    Nice works for me! lächeln

    But to have this more advanced, is there a way to limit each user to one status on this fine update?
    so the list is not filled with one user that changed there status a couple of times?

    And - i know i ask much :s - to only have specific user there status on it?
    Like only user id 1 and 3 and 4 or something like that? lächeln

    Thanks!


    Hey,
    im new at coding, i must look ^^
    but, if andyone do that than u must ban him because thats spaming ^^

    If you wan only id 1 than change line "14"
    "WHERE s.statusID > 0" to "WHERE s.userID = 1"

    but i look how to code to show a specific user by klick
    webSPELL newbie
    73 Posts
    26.12.2011, 15:31 email offline quote 
    Nice works for me! lächeln

    But to have this more advanced, is there a way to limit each user to one status on this fine update?
    so the list is not filled with one user that changed there status a couple of times?

    And - i know i ask much :s - to only have specific user there status on it?
    Like only user id 1 and 3 and 4 or something like that? lächeln

    Thanks!
    webSPELL newbie
    93 Posts
    26.12.2011, 14:11 email offline quote 
    Hchest wrote:
    Nice work again.

    Any news about putting some users status on a page?
    Like sc_usersstatus.htm

    or something like that?
    Thanks! lächeln


    Here,
    edit "$limit = 20;" to set the limit to show how many status shown on the page.

    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.
    <?php
    /***************************************************
    -------------------Change here----------------------
    ***************************************************/
    $limit = 20;

    /***************************************************
    ----------------Don't change here-------------------
    ***************************************************/
    $abfrage = "
    SELECT u.*, s.* 
    FROM ".PREFIX."user u
    LEFT JOIN ".PREFIX."user_status s
    ON s.userID = u.userID
    WHERE s.statusID > 0
    ORDER BY statusID DESC LIMIT $limit";

    $ergebnis = mysql_query($abfrage);

    echo '
    <table width="100%">
    <tr>
    <tr width="100%" bgcolor="#E2E2E2"><b>Last userstatus</b></tr>
    </tr>
    <td width="5%" bgcolor="#E2E2E2"><b>ID</b></td>
    <td width="20%" bgcolor="#E2E2E2"><b>Playername</b></td>
    <td width="75%" bgcolor="#E2E2E2"><b>Playerstatus</b></td>
    </table>
    ';

    while($row = mysql_fetch_object($ergebnis))
    {
         $statusid = $row->statusID;
         $name = $row->nickname;
         $status = $row->status;

    echo '
    <table width="100%">
         <tr>
              <td width="5%" bgcolor="#E2E2E2">'.$statusid.'</td>
              <td width="20%" bgcolor="#E2E2E2">'.$name.'</td>
              <td width="75%" bgcolor="#E2E2E2">'.$status.'</td>
         </tr>
    </table>
    ';
    }
    ?>
    webSPELL newbie
    73 Posts
    25.12.2011, 23:05 email offline quote 
    Nice work again.

    Any news about putting some users status on a page?
    Like sc_usersstatus.htm

    or something like that?
    Thanks! lächeln
    webSPELL user
    198 Posts
    22.12.2011, 23:23 email offline quote 
    Textlimitieren habe ich oben bereits nen Snippet gepostet.
    Moderator
    5328 Posts
    22.12.2011, 13:32 email offline quote 
    zwantE wrote:

    speichern, hochladen und dann hoffen das dort niemand einen langen Text einträgt lächeln


    schöner wäre die maximalen Zeichen zu begrenzen und falls der status länger ist ggf den kompletten Status bei onmouseover anzeigen lassen
    bazic.net
    webSPELL newbie
    73 Posts
    21.12.2011, 19:24 email offline quote 
    I am, just told all my friends about him how cool he is etc.. amüsiert
    webSPELL user
    198 Posts
    21.12.2011, 16:27 email offline quote 
    This won't work on a static page because it has to open a database connection to get the status, but it would be possibile to code a script what would do this. Be nice to zwantE zwinkern
    webSPELL newbie
    73 Posts
    21.12.2011, 14:40 email offline quote 
    I know some html design template modification shit zwinkern

    I buyed a other design and now it works lächeln

    One more question how can i put the statuses of my clanmembers on a static html page?

    Just love the addon lächeln
    Sort:      « ‹ 1 2 3 › » 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
    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 - 14:04 - 5 Replies
    » I cannot upload template ...
    I cannot upload template to my cms .
    Last post: arjanw1987
    Board: EN - General
    23.05.2013 - 14:04
    23.05.2013 - 11:29 - 14 Replies
    » High Quality Website
    High Quality Website
    Last post: BlueaKaKev
    Board: EN - Offers
    23.05.2013 - 11:29
    23.05.2013 - 10:14 - 12 Replies
    » Mein Forum
    Mein Forum
    Last post: Lordy4007
    Board: DE - Fragen zur Seite
    23.05.2013 - 10:14
    23.05.2013 - 02:08 - 10 Replies
    » forum anzeige erweitern
    forum anzeige erweitern
    Last post: LoRd
    Board: DE - Allgemeiner Support
    23.05.2013 - 02:08
    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
    22.05.2013 - 21:28 - 464 Replies
    » Wettscript 2.1 for 4.2.3a...
    Wettscript 2.1 for 4.2.3a - Betscript
    Last post: Amokossi
    Board: DE - Fertige Skripte
    22.05.2013 - 21:28
    22.05.2013 - 17:46 - 3 Replies
    » Admin login
    Admin login
    Last post: blackmoonstah
    Board: DE - Allgemeiner Support
    22.05.2013 - 17:46
    22.05.2013 - 17:28 - 1 Replies
    » Design Ausverkauf - alles...
    Design Ausverkauf - alles unter 70€
    Last post: Freestyler92
    Board: DE - Biete
    22.05.2013 - 17:28
    22.05.2013 - 14:54 - 2 Replies
    » adminlogin auf allypage f...
    adminlogin auf allypage funktioniert nicht mehr. bitte um hilfe
    Last post: blackmoonstah
    Board: DE - Technischer Support
    22.05.2013 - 14:54
    22.05.2013 - 14:41 - 4 Replies
    » Content laden
    Content laden
    Last post: bazic
    Board: DE - Anfragen
    22.05.2013 - 14:41
    22.05.2013 - 09:57 - 0 Replies
    » [4SALE] eSport Design/Tem...
    [4SALE] eSport Design/Template
    Last post: LeG3nDz
    Board: EN - Offers
    22.05.2013 - 09:57
    22.05.2013 - 09:24 - 1 Replies
    » Updatefunktion?
    Updatefunktion?
    Last post: Sysix
    Board: DE - Vorschläge
    22.05.2013 - 09:24
    22.05.2013 - 00:47 - 5 Replies
    » msql datenbank transfer
    msql datenbank transfer
    Last post: pgene
    Board: DE - Technischer Support
    22.05.2013 - 00:47
    21.05.2013 - 19:43 - 9 Replies
    » login startseite
    login startseite
    Last post: Argu
    Board: DE - Technischer Support
    21.05.2013 - 19:43
    21.05.2013 - 13:18 - 7 Replies
    » [Biete] Template Designs
    [Biete] Template Designs
    Last post: Marceld
    Board: DE - Biete
    21.05.2013 - 13:18
    21.05.2013 - 05:15 - 0 Replies
    » Need Designer for Logo/Te...
    Need Designer for Logo/Template
    Last post: Kody
    Board: EN - General
    21.05.2013 - 05:15
    21.05.2013 - 05:13 - 0 Replies
    » Looking for Designers/Cod...
    Looking for Designers/Coders (paid)
    Last post: Kody
    Board: EN - Requests
    21.05.2013 - 05:13
    » 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,...