Subversion Repositories cheapmusic

Rev

Rev 35 | Rev 65 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 35 Rev 45
Line 69... Line 69...
69 
 
 69 
 
70 
        self::$_sess_db = mysqli_connect(self::$db_host, self::$db_user, self::$db_pass, self::$db_name);
 70 
        self::$_sess_db = mysqli_connect(self::$db_host, self::$db_user, self::$db_pass, self::$db_name);
71 
 
 71 
 
72 
        if (mysqli_connect_errno())
 72 
        if (mysqli_connect_errno())
73 
        {
 73 
        {
74 
            error_log("Failed to connect to MySQL: " . mysqli_connect_error());
 74 
            error_log("Failed to connect to MySQL: " . mysqli_connect_error() . " (" . mysqli_connect_errno() . ")");
75 
            return false;
 75 
            return false;
76 
        }
 76 
        }
77 
 
 77 
 
78 
        return true;
 78 
        return true;
79 
    }
 79 
    }
Line 100... Line 100...
100 
                $record = mysqli_fetch_assoc($result);
 100 
                $record = mysqli_fetch_assoc($result);
101 
                $decrypted = Cryptor::Decrypt($record['data']);
 101 
                $decrypted = Cryptor::Decrypt($record['data']);
102 
                $_SESSION = json_decode($decrypted, true);
 102 
                $_SESSION = json_decode($decrypted, true);
103 
            }
 103 
            }
104 
        } else {
 104 
        } else {
105 
            error_log("MySQL Read Session Error: " . mysqli_error(self::$_sess_db));
 105 
            error_log("MySQL Read Session Error: " . mysqli_error(self::$_sess_db) . " (" . mysqli_errno(self::$_sess_db) . ")");
106 
        }
 106 
        }
107 
 
 107 
 
108 
        if (self::getSessionTab() != 0) {
 108 
        if (self::getSessionTab() != 0) {
109 
            $sql = "SELECT data
 109 
            $sql = "SELECT data
110 
                    FROM sessions
 110 
                    FROM sessions
Line 118... Line 118...
118 
                    $decrypted = Cryptor::Decrypt($record['data']);
 118 
                    $decrypted = Cryptor::Decrypt($record['data']);
119 
                    $temp = json_decode($decrypted, true);
 119 
                    $temp = json_decode($decrypted, true);
120 
                    $_SESSION = array_merge($_SESSION, $temp);
 120 
                    $_SESSION = array_merge($_SESSION, $temp);
121 
                }
 121 
                }
122 
            } else {
 122 
            } else {
123 
                error_log("MySQL Login Read Session Error: " . mysqli_error(self::$_sess_db)); // bugbug
 123 
                error_log("MySQL Login Read Session Error: " . mysqli_error(self::$_sess_db) . " (" . mysqli_errno(self::$_sess_db) . ")"); // bugbug
124 
            }
 124 
            }
125 
        }
 125 
        }
126 
 
 126 
 
127 
        if (isset($_SESSION) && !empty($_SESSION) && $_SESSION != null) {
 127 
        if (isset($_SESSION) && !empty($_SESSION) && $_SESSION != null) {
128 
            return session_encode();
 128 
            return session_encode();
Line 146... Line 146...
146 
        $sql = "REPLACE
 146 
        $sql = "REPLACE
147 
                INTO sessions
 147 
                INTO sessions
148 
                VALUES ('$id', '" . self::getSessionTab() . "', '$access', '$encrypted', $userId)";
 148 
                VALUES ('$id', '" . self::getSessionTab() . "', '$access', '$encrypted', $userId)";
149 
 
 149 
 
150 
        if (!($result = mysqli_query(self::$_sess_db, $sql))) {
 150 
        if (!($result = mysqli_query(self::$_sess_db, $sql))) {
151 
            error_log("MySQL Write Session Error: " . mysqli_error(self::$_sess_db));
 151 
            error_log("MySQL Write Session Error: " . mysqli_error(self::$_sess_db) . " (" . mysqli_errno(self::$_sess_db) . ")");
152 
        }
 152 
        }
153 
 
 153 
 
154 
        return $result;
 154 
        return $result;
155 
    }
 155 
    }
156 
 
 156 
 
Line 161... Line 161...
161 
        $sql = "DELETE
 161 
        $sql = "DELETE
162 
                FROM sessions
 162 
                FROM sessions
163 
                WHERE id = '$id' and tab = '" . self::getSessionTab() . "'";
 163 
                WHERE id = '$id' and tab = '" . self::getSessionTab() . "'";
164 
 
 164 
 
165 
        if (!($result = mysqli_query(self::$_sess_db, $sql))) {
 165 
        if (!($result = mysqli_query(self::$_sess_db, $sql))) {
166 
            error_log("MySQL Destroy Session: " . mysqli_error(self::$_sess_db));
 166 
            error_log("MySQL Destroy Session: " . mysqli_error(self::$_sess_db) . " (" . mysqli_errno(self::$_sess_db) . ")");
167 
        }
 167 
        }
168 
 
 168 
 
169 
        return $result;
 169 
        return $result;
170 
    }
 170 
    }
171 
 
 171 
 
Line 176... Line 176...
176 
    $sql = "DELETE
 176 
    $sql = "DELETE
177 
            FROM sessions
 177 
            FROM sessions
178 
            WHERE access < '$old'";
 178 
            WHERE access < '$old'";
179 
 
 179 
 
180 
        if (!($result = mysqli_query(self::$_sess_db, $sql))) {
 180 
        if (!($result = mysqli_query(self::$_sess_db, $sql))) {
181 
            error_log("MySQL Session GC Error: " . mysqli_error(self::$_sess_db));
 181 
            error_log("MySQL Session GC Error: " . mysqli_error(self::$_sess_db) . " (" . mysqli_errno(self::$_sess_db) . ")");
182 
        }
 182 
        }
183 
 
 183 
 
184 
        return $result;
 184 
        return $result;
185 
    }
 185 
    }
186 
}
 186 
}