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


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

    register now
    login
    Author
    Message
    webSPELL newbie
    39 Posts
    10.03.2012, 23:26 offline quote 

    mhm... naja sag mal nix jetzt
    Administrator
    Member of webSPELL e.V.
    1454 Posts
    10.03.2012, 22:35 offline quote 

    Das war die Punktfee, die kommt immer nachts und loggt sich auf FTP server ein und veraendert dann Dateien.

    perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
    webSPELL newbie
    39 Posts
    10.03.2012, 22:19 offline quote 

    Cool Danke es geht wieder aber wie ist der . dahin gekommen? unglücklich
    Moderator
    1712 Posts
    10.03.2012, 22:14 offline quote 

    Code:
    1.
    $check = safe_query(".SELECT * FROM ".PREFIX."user WHERE username='".$ws_user."' OR email='".$ws_user."' AND activated='1'");


    Entferne den . vor dem SELECT
    webSPELL newbie
    39 Posts
    10.03.2012, 22:07 offline quote 

    Meinste da liegt der fehler ?


    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.
    <?php
    /*
    ##########################################################################
    #                                                                        #
    #           Version 4       /                        /   /               #
    #          -----------__---/__---__------__----__---/---/-               #
    #           | /| /  /___) /   ) (_ `   /   ) /___) /   /                 #
    #          _|/_|/__(___ _(___/_(__)___/___/_(___ _/___/___               #
    #                       Free Content / Management System                 #
    #                                   /                                    #
    #                                                                        #
    #                                                                        #
    #   Copyright 2005-2010 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                                                   #
    #                                                                        #
    ##########################################################################
    */

    include("_mysql.php");
    include("_settings.php");

    // copy pagelock information for session test + deactivated pagelock for checklogin
    $closed_tmp = $closed;
    $closed = 0;

    include("_functions.php");

    //settings

    $sleep = 1; //idle status for script if password is wrong?

    //settings end
    $_language->read_module('checklogin');

    $get = safe_query("SELECT * FROM ".PREFIX."banned_ips WHERE ip='".$GLOBALS['ip']."'");
    if(mysql_num_rows($get) == 0){
         $ws_pwd = md5(stripslashes($_POST['pwd']));
         $ws_user = $_POST['ws_user'];
         
         $check = safe_query("SELECT * FROM ".PREFIX."user WHERE username='".$ws_user."' OR email='".$ws_user."'");
         $anz = mysql_num_rows($check);
         $login = 0;
         
         if(!$closed_tmp AND !isset($_SESSION['ws_sessiontest'])) {
              $error = $_language->module['session_error'];
         }
         else {
              if($anz) {
              
                   $check = safe_query(".SELECT * FROM ".PREFIX."user WHERE username='".$ws_user."' OR email='".$ws_user."' AND activated='1'");
                   if(mysql_num_rows($check)) {
              
                        $ds=mysql_fetch_array($check);
              
                        // check password
                        $login = 0;
                        if($ws_pwd == $ds['password']) {
              
                             //session
                             $_SESSION['ws_auth'] = $ds['userID'].":".$ws_pwd;
                             $_SESSION['ws_lastlogin'] = $ds['lastlogin'];
                             $_SESSION['referer'] = $_SERVER['HTTP_REFERER'];
                             //remove sessiontest variable
                             if(isset($_SESSION['ws_sessiontest'])) unset($_SESSION['ws_sessiontest']);
                             //cookie
                             setcookie("ws_auth", $ds['userID'].":".$ws_pwd, time()+($sessionduration*60*60));                         
                             //Delete visitor with same IP from whoisonline
                             safe_query("DELETE FROM ".PREFIX."whoisonline WHERE ip='".$GLOBALS['ip']."'");
                             //Delete IP from failed logins
                             safe_query("DELETE FROM ".PREFIX."failed_login_attempts WHERE ip = '".$GLOBALS['ip']."'");
                             $login = 1;
                             $error = $_language->module['login_successful'];
                        }
                        elseif(!($ws_pwd == $ds['password'])) {
                             if($sleep) sleep(5);
                             $get = safe_query("SELECT wrong FROM ".PREFIX."failed_login_attempts WHERE ip = '".$GLOBALS['ip']."'");
                             if(mysql_num_rows($get)){
                                  safe_query("UPDATE ".PREFIX."failed_login_attempts SET wrong = wrong+1 WHERE ip = '".$GLOBALS['ip']."'");
                             }
                             else{
                                  safe_query("INSERT INTO ".PREFIX."failed_login_attempts (ip,wrong) VALUES ('".$GLOBALS['ip']."',1)");
                             }
                             $get = safe_query("SELECT wrong FROM ".PREFIX."failed_login_attempts WHERE ip = '".$GLOBALS['ip']."'");
                             if(mysql_num_rows($get)){
                                  $ban = mysql_fetch_assoc($get);
                                  if($ban['wrong'] == $max_wrong_pw){
                                       $bantime = time() + (60*60*3); // 3 hours
                                       safe_query("INSERT INTO ".PREFIX."banned_ips (ip,deltime,reason) VALUES ('".$GLOBALS['ip']."',".$bantime.",'Possible brute force attack')");
                                       safe_query("DELETE FROM ".PREFIX."failed_login_attempts WHERE ip = '".$GLOBALS['ip']."'");
                                  }
                             }
                             $error= $_language->module['invalid_password'];
                        }
                   }
                   else $error= $_language->module['not_activated'];
              
              }
              else $error=str_replace('%username%', htmlspecialchars($ws_user), $_language->module['no_user']);
         }
    }
    else{
         $login = 0;
         $data = mysql_fetch_assoc($get);
         $error = str_replace('%reason%', $data['reason'], $_language->module['ip_banned']);
    }

    ?>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta name="description" content="Clanpage using webSPELL 4 CMS" />
    <meta name="author" content="webspell.org" />
    <meta name="keywords" content="webspell, webspell4, clan, cms" />
    <meta name="copyright" content="Copyright &copy; 2005 - 2009 by webspell.org" />
    <meta name="generator" content="webSPELL" />
    <title><?php echo PAGETITLE; ?></title>
    <link href="_stylesheet.css" rel="stylesheet" type="text/css" />
    <?php if($login) { echo '<meta http-equiv="refresh" content="1;URL=index.php?site=loginoverview" />'; } ?>
    </head>
    <body bgcolor="<?php echo PAGEBG; ?>">
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
         <tr>
              <td height="500" align="center">
              <table width="350" border="0" cellpadding="10" cellspacing="0" style="border:1px solid <?php echo BORDER; ?>" bgcolor="<?php echo BG_1; ?>">
                   <tr>
                        <td align="center"><?php echo $error; ?></td>
                   </tr>
              </table>
              </td>
         </tr>
    </table>
    </body>
    </html>
    Administrator
    Member of webSPELL e.V.
    1454 Posts
    10.03.2012, 21:05 offline quote 

    .SELECT ?

    perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
    Moderator
    1712 Posts
    10.03.2012, 20:50 offline quote 

    Poste mal deine checklogin.php
    webSPELL newbie
    39 Posts
    10.03.2012, 20:49 offline quote 

    Hallo,

    Ich habe einen Fehler seit heute auf meiner Seite. Immer wenn man sich einloggen will kommt:

    Code:
    1.
    2.
    3.
    4.
    Query failed:
    errorno=1064
    error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.SELECT * FROM ws_I3L_user WHERE username='curry' OR email='curry' AND activated' at line 1
    query=.SELECT * FROM ws_I3L_user WHERE username='curry' OR email='curry' AND activated='1'


    Kennt jemand das Problem oder kann mir jemand Helfen?

    Gestern ging noch alles und ich habe nix in der zeit an der Website gemacht.

    website: www.monkeysandweapons.at
    version: 4.2.3
    Sort:     printview


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

    register now
    login
  • » Support

    » Topics
    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 - 23:30 - 13 Replies
    » forum anzeige erweitern
    forum anzeige erweitern
    Last post: Swordfish3000
    Board: DE - Allgemeiner Support
    23.05.2013 - 23:30
    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
    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
    » Partners
    Bilderkiste.org Image Hosting
    k3rmit.org
    PascalMh.de


    » Blog
    28.03.2013 - derchris
    » Those damn spammers