Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev
Reply
  #1  
Old 17th November 2012, 02:49
Tones Tones is offline
Banned
 
Join Date: Sep 2011
Cuba
Posts: 154
Default 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!!
Reply With Quote
  #2  
Old 17th November 2012, 15:27
Chez's Avatar
Chez Chez is offline
Senior Member
 
Join Date: Sep 2011
P2P
Posts: 278
Default
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);
                    
        }        
    }

Attached Files
File Type: sql u273381571_tb.sql (302.4 KB, 23 views)
__________________
http://www.bvlist.com/images/avatars/signaturepics/sigpic16443_2.gif
Reply With Quote
The Following User Says Thank You to Chez For This Useful Post:
Tones (17th November 2012)
  #3  
Old 17th November 2012, 16:50
Tones Tones is offline
Banned
 
Join Date: Sep 2011
Cuba
Posts: 154
Default Nice!!
Thx man problem solved !!!

Last edited by Krypto; 17th November 2012 at 23:58. Reason: No need to keep typing in BOLD!!
Reply With Quote
Reply

Tags
error , flux , zone

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 16:28. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.