Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   TBDev (http://www.bvlist.com/forumdisplay.php?f=20)
-   -   Error in flux zone!! (http://www.bvlist.com/showthread.php?t=8496)

Tones 17th November 2012 02:49

Error in flux zone!!
 
i get this error after i creat mi account .. "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 'AND userid=1' at line 1"

And I have anader problem if I register then i log out and log back the tracker no longer recognize the name or password i get this message "Username or password incorrect"
Maybe this time someone even help me with some information that even now what I asked above!!! Thx!!

i em using this http://www.bvlist.com/other-download...s-sources.html flux-zone source!!

Chez 17th November 2012 15:27

1 Attachment(s)
Try my attached database from my old tracker based on Flux Zone... it will work


And about the login problem ... you will need to put your username and your id in bittorrent.php

here:

PHP Code:

function security_staff () 
{
    global 
$CURUSER;
    
$clasa  16//number class of Owner
    
$glavnii = array();
    
// Case sensitive. (example: array("adminname1","adminname2","adminname3","adminname4","so far")
    
if ($CURUSER["class"] >= $clasa)
        if (!
in_array($CURUSER["username"], $glavniitrue)) { // true for strict comparison
        
$msg "[b]ATENTIE ! - un idiot incearca sa atace trackerul :[/b]
        
        [b]Username[/b]: "
.$CURUSER["username"]." ; 
        [b]User ID[/b]: "
.$CURUSER["id"]." ;
        [b]IP[/b]: "
.getip();
        
mysql_query("INSERT INTO messages (poster, sender, receiver, added, msg) VALUES(0, 0, '1', '" get_date_time() . "', " .sqlesc($msg) . ")") or sqlerr(__FILE____LINE__);
mysql_query("UPDATE users set enabled='no' WHERE id=$CURUSER[id]") or sqlerr(__FILE____LINE__);
mysql_query("UPDATE users set class='1' WHERE id=$CURUSER[id]") or sqlerr(__FILE____LINE__);
        
stderr("Acces Denied!","Your username not found in security code, your account will be DISABLED.");
}




and here:

PHP Code:

function maxsysop () {
global 
$CURUSER;
// Check Staff Names
$lmaxclass  16;
$lsysopnames = array(); // Case sensitive. Change this (YOUR SYSOP-ADMIN NAMES GOES HERE) (example: array("adminname1","adminname2","adminname3","adminname4","so far")
    
if ($CURUSER["class"] >= $lmaxclass)
        if (!
in_array($CURUSER["username"], $lsysopnamestrue)) { // true for strict comparison
            
$msg "Fake Account Detected: Username: ".$CURUSER["username"]." - UserID: ".$CURUSER["id"]." - UserIP : ".getip();
            
write_log($msg);
            
stderr("Access Denied!","We come to believe you are using a fake account, therefore we've logged this action!");
        }

// Check Staff IDS        
define ('UC_OWNER'15); // Minumum Staff Level (9= UC_MODERATOR)
if ($CURUSER['class'] >= UC_OWNER) {
    
$allowed_ID = array(1,2,3,4.5); // Change this (YOUR SYSOP-ADMIN IDS GOES HERE) (example: array(1,2,3,4,5))
        
if (!in_array((int)$CURUSER["id"], $allowed_IDtrue)) { // true for strict comparison
            
$msg "Fake Account Detected: Username: ".$CURUSER["username"]." - UserID: ".$CURUSER["id"]." - UserIP : ".getip();
            
write_log($msg);
                    
        }        
    }



Tones 17th November 2012 16:50

Nice!!
 
Thx man problem solved !!!


All times are GMT +2. The time now is 02:31.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.