Posts: 1
|
Hi there, I hope you can help me out with this: I'll try my best to explain everything/give everything you need.
Trying to install webleague ladders
http://conflict-gamers.net/ladders/
Quote:
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of sscanf(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in /home/content/c/o/n/conflictgamers/html/ladders/lib/helpers.php on line 199
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of sscanf(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in /home/content/c/o/n/conflictgamers/html/ladders/lib/helpers.php on line 199
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of sscanf(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in /home/content/c/o/n/conflictgamers/html/ladders/lib/helpers.php on line 199
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of sscanf(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in /home/content/c/o/n/conflictgamers/html/ladders/lib/helpers.php on line 203
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of sscanf(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in /home/content/c/o/n/conflictgamers/html/ladders/lib/helpers.php on line 203
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of sscanf(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in /home/content/c/o/n/conflictgamers/html/ladders/lib/helpers.php on line 203
Warning: Call-time pass-by-reference has been deprecated; If you would like to pass it by reference, modify the declaration of simpleNVparser(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file in /home/content/c/o/n/conflictgamers/html/ladders/lib/sql.php on line 62
SELECT * FROM bzl_themes
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/content/c/o/n/conflictgamers/html/ladders/lib/session.php on line 26
Table 'conflictgamers.bzl_permissions' doesn't existTable 'conflictgamers.bzl_themes' doesn't exist
|
Helpers.php
PHP Code:
<?php // $Id: session.php,v 1.5 2005/04/04 16:32:07 dennismp Exp $ vim:sts=2:et:sw=2
session_set_save_handler(
"mysql_session_open",
"mysql_session_close",
"mysql_session_read",
"mysql_session_write",
"mysql_session_destroy",
"mysql_session_gc" );
function mysql_session_open($session_path, $session_name){
}
function mysql_session_close(){
return 1;
}
// Set STATIC info here (to reduce sql queries)
function sessionStaticInfo (){
if(!isset ($_SESSION['themes'])) {
$res = sqlQuery ('SELECT * FROM bzl_themes');
while ($row = mysql_fetch_object($res)){
$themes[$row->tag] = array($row->displayname, $row->themedir);
}
$_SESSION['themes'] = $themes;
}
if(! isset($_SESSION['permissions'])) {
$res = mysql_query("SELECT id,name FROM bzl_permissions WHERE role_id = " . GUEST_PERMISSION) or die(mysql_error());
$_SESSION['role_id'] = GUEST_PERMISSION;
$_SESSION['permissions'] = array();
while($row = mysql_fetch_array($res)) {
$_SESSION['permissions'][$row[0]] = 1;
}
}
}
function unserialize_session_data( $serialized_string ) {
$variables = array( );
$a = preg_split( "/(\w+)\|/", $serialized_string, -1, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE );
for( $i = 0; $i < count( $a ); $i = $i+2 ) {
$variables[$a[$i]] = unserialize( $a[$i+1] );
}
return( $variables );
}
function mysql_session_read($SID){
$ip = $_SERVER['REMOTE_ADDR'];
$sql = "
SELECT data,refresh,playerid
FROM l_session
WHERE id = '$SID'
and expire > now()
";
$res = mysql_query($sql);
if( $res ){
$row = mysql_fetch_assoc($res);
if( $row ) {
$session = stripslashes($row['data']);
if( $row['refresh'] == 'Y' ) {
$_SESSION = unserialize_session_data($session);
session_data_reload($row['playerid']);
$session = session_encode();
unset($_SESSION);
$sql = "UPDATE l_session SET refresh='N' WHERE id='$SID'";
mysql_query($sql);
}
return $session;
}
else {
mysql_session_destroy($SID);
}
}
sessionStaticInfo();
return "";
}
function mysql_session_write($SID,$value) {
$expiration = time() + SESSION_LIFETIME;
$ip = $_SERVER['REMOTE_ADDR'];
$SID = addslashes($SID);
$value = addslashes($value);
if( isset( $_SESSION['callsign'] ) ) {
$callsign = "'" . addslashes($_SESSION['callsign']) . "'";
$playerid = $_SESSION['playerid'];
} else {
$callsign = 'NULL';
$playerid = 0;
}
$sql = "INSERT INTO l_session (id, expire, data, callsign, playerid,ip) ".
"VALUES( '$SID',FROM_UNIXTIME($expiration),'$value',$callsign,$playerid,'$ip') ";
$res = mysql_query($sql);
// No point in much errorchecking, as
// we cannot do anything about it. (this is executed after output is generated)
if(! $res ) { // If error, we try to update
$sql = "UPDATE l_session SET ".
"expire = FROM_UNIXTIME($expiration), ".
"data = '$value', ".
"callsign = $callsign, ".
"playerid = $playerid ".
"WHERE id = '$SID' ";
mysql_query($sql);
}
return true;
}
function mysql_session_destroy($SID) {
$SID = addslashes($SID);
$sql = "DELETE FROM l_session WHERE id = '$SID'";
mysql_query($sql);
unset ($_SESSION);
sessionStaticInfo();
}
function mysql_session_gc($lifetime) {
$sql = "DELETE FROM l_session ".
"WHERE expire < FROM_UNIXTIME(" . (time() - $lifetime) . ")";
$res = mysql_query($sql);
if( $res )
return mysql_affected_rows();
else
return 0;
}
function session_refresh_all() {
if( $_SESSION['player_id'] ) {
sqlQuery("UPDATE l_session SET refresh='Y' WHERE playerid!='{$_SESSION['playerid']}'");
session_refresh();
}
else {
sqlQuery("UPDATE l_session SET refresh='Y'");
}
}
function session_refresh($id = null) {
// If no id specified, use current playerid
if( $id === null )
$id = (isset($_SESSION['playerid']) ? $_SESSION['playerid'] : null );
// This is a guest user, ignore it
if( $id === null ) return;
// If $id is current user, then dont flag. Just reload data
if( $id == $_SESSION['playerid'] )
session_data_reload($id);
else
sqlQuery("UPDATE l_session SET refresh='Y' WHERE playerid='$id'");
}
function session_data_reload($id) {
$old_role_id = $_SESSION['role_id'];
$row = mysql_fetch_object (sqlQuery("SELECT p.team, r.name as level, r.id as role_id, p.team FROM l_player p, bzl_roles r WHERE r.id = p.role_id AND p.id=$id")) or die(mysql_error());
$_SESSION['teamid'] = $row->team;
$_SESSION['level'] = $row->level;
$_SESSION['role_id'] = $row->role_id;
$row = mysql_fetch_object (sqlQuery("SELECT leader FROM l_team WHERE id={$_SESSION['teamid']}"));
$_SESSION['leader'] = ($row->leader == $id);
$_SESSION['playerid'] = $id;
// mail - detect new messages
if( ! isset($_SESSION['lst_msg_read_ts']) )
$_SESSION['last_msg_read_ts'] = $_SESSION['last_login'];
$row = mysql_fetch_object(mysql_query("
SELECT count(*) as num, max(unix_timestamp(datesent)) latest_ts
FROM l_message
WHERE toid=$id and status='new'
"));
$_SESSION['mail_unread'] = $row->num;
$_SESSION['new_mail'] = ($row->latest_ts > $_SESSION['last_msg_read_ts']);
// match
$res = sqlQuery ('select unix_timestamp(tsactual) as ts from '. TBL_MATCH .' order by tsactual desc limit 1');
$row = mysql_fetch_object($res);
if ( $_SESSION['last_login'] < $row->ts )
$_SESSION['new_match'] = 1;
else
$_SESSION['new_match'] = 0;
// forum
$res = sqlQuery ('select unix_timestamp(datesent) as ts from l_forummsg order by datesent desc limit 1');
$row = mysql_fetch_object($res);
if ( $_SESSION['last_login'] < $row->ts )
$_SESSION['new_forum'] = 1;
else
$_SESSION['new_forum'] = 0;
//news
$row = mysql_fetch_object (sqlQuery ('select unix_timestamp(newsdate) as ts from bzl_news order by newsdate desc limit 1'));
if ( $_SESSION['last_login'] < $row->ts )
$_SESSION['new_news'] = 1;
else
$_SESSION['new_news'] = 0;
// Get permissions, if changed
if( $old_role_id != $_SESSION['role_id'] ) {
$res = mysql_query("SELECT name FROM bzl_permissions WHERE role_id = {$_SESSION['role_id']}") or die(mysql_error());
$_SESSION['permissions'] = array();
while($row = mysql_fetch_array($res)) {
$_SESSION['permissions'][$row[0]] = 1;
}
}
}
?>
SQL PHP:
PHP Code:
<?php // $Id: sql.php,v 1.6 2005/04/17 20:03:02 menotume Exp $ vim:sts=2:et:sw=2
define (TBL_MATCH, 'bzl_match');
define (TBL_FREEZE, 'bzl_freezeranks');
define (TBL_VISITS, 'bzl_visit');
define (TBL_LINKS, 'bzl_links');
define (TBL_NEWS, 'bzl_news');
define (TBL_TEAM, 'l_team');
define (TBL_PLAYER, 'l_player');
define (TBL_SESSION, 'l_session');
function sqlQueryMsg ($q, &$msg){
$res = @mysql_query ($q);
if (!$res){
$msg = '<Table width=100%><TR><TD><pre>'. mysql_error() ."\n\n$q</code></td></tr></pre>";
// sqlQueryDisplay($q);
// sqlQueryDisplay (mysql_error() );
// $q = str_replace (">", ">", $q);
// $q = str_replace ("<", "<", $q);
// echo "<Table width=100%><TR><TD><pre>$q</code></td></tr></pre>";
}
return $res;
}
function sqlQueryDisplay ($q){
$q = str_replace (">", ">", $q);
$q = str_replace ("<", "<", $q);
echo "<Table width=100%><TR><TD><pre>$q</code></td></tr></pre>";
}
function sqlQuery ($q, $disp=null){
$res = mysql_query ($q);
if (!$res || $disp){
sqlQueryDisplay($q);
sqlQueryDisplay (mysql_error() );
}
return $res;
}
function sqlQuerySingle ($q, $disp=null){
$res = sqlQuery ($q, $disp);
if (mysql_num_rows($res) == 0)
return null;
return mysql_fetch_object ($res);
}
$databaseName = "";
function sqlConnect ($confLoc){
global $databaseName;
$nv = array();
simpleNVparser ($confLoc, &$nv);
$databaseName = $nv['SQLdatabase'];
$link=mysql_pconnect($nv['SQLhost'], $nv['SQLuser'], $nv['SQLpass']);
mysql_select_db($nv['SQLdatabase'], $link);
if($link === false){
echo "<BR><BR><HR>There seems to be a problem with the database,
please try again later.<BR>
If the problem persists, please contact the site administrator.";
exit;
}
}
function queryGetTeamName ($id){
$q = "SELECT name from ". TBL_TEAM ." WHERE id='$id'";
$res = sqlQuery ($q);
$row = mysql_fetch_object ($res);
if ($row)
return substr ($row->name, 0, 36);
return "[UNKNOWN]";
}
function queryGetTeam ($id){
$q = "SELECT * from ". TBL_TEAM ." WHERE id='$id'";
$res = sqlQuery ($q);
return mysql_fetch_object ($res);
}
function sqlResultDump ($res, $title=null){
echo '<TABLE><TR>';
$numCols = mysql_num_fields ($res);
if ($title)
echo '<TR><TD align=center colspan='. $numCols*2 ."><Font size=+1><B>$title</font></td></tr>\n";
for ($x=0; $x<$numCols; $x++){
$name = mysql_field_name ($res, $x);
echo "<TD><b>$name</td><TD width=5></td>";
}
echo '</tr>';
if ($res)
while ($row = mysql_fetch_row($res)){
echo '<TR>';
for ($x=0; $x<$numCols; $x++)
echo "<TD>$row[$x]</td><TD></td>";
echo "</tr>\n";
}
else
echo '<TR><TD align=center colspan='. numCols*2 .">Empty result set</td></tr>\n";
echo '</table>';
}
?>
session.php
PHP Code:
<?php // $Id: session.php,v 1.5 2005/04/04 16:32:07 dennismp Exp $ vim:sts=2:et:sw=2
session_set_save_handler(
"mysql_session_open",
"mysql_session_close",
"mysql_session_read",
"mysql_session_write",
"mysql_session_destroy",
"mysql_session_gc" );
function mysql_session_open($session_path, $session_name){
}
function mysql_session_close(){
return 1;
}
// Set STATIC info here (to reduce sql queries)
function sessionStaticInfo (){
if(!isset ($_SESSION['themes'])) {
$res = sqlQuery ('SELECT * FROM bzl_themes');
while ($row = mysql_fetch_object($res)){
$themes[$row->tag] = array($row->displayname, $row->themedir);
}
$_SESSION['themes'] = $themes;
}
if(! isset($_SESSION['permissions'])) {
$res = mysql_query("SELECT id,name FROM bzl_permissions WHERE role_id = " . GUEST_PERMISSION) or die(mysql_error());
$_SESSION['role_id'] = GUEST_PERMISSION;
$_SESSION['permissions'] = array();
while($row = mysql_fetch_array($res)) {
$_SESSION['permissions'][$row[0]] = 1;
}
}
}
function unserialize_session_data( $serialized_string ) {
$variables = array( );
$a = preg_split( "/(\w+)\|/", $serialized_string, -1, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE );
for( $i = 0; $i < count( $a ); $i = $i+2 ) {
$variables[$a[$i]] = unserialize( $a[$i+1] );
}
return( $variables );
}
function mysql_session_read($SID){
$ip = $_SERVER['REMOTE_ADDR'];
$sql = "
SELECT data,refresh,playerid
FROM l_session
WHERE id = '$SID'
and expire > now()
";
$res = mysql_query($sql);
if( $res ){
$row = mysql_fetch_assoc($res);
if( $row ) {
$session = stripslashes($row['data']);
if( $row['refresh'] == 'Y' ) {
$_SESSION = unserialize_session_data($session);
session_data_reload($row['playerid']);
$session = session_encode();
unset($_SESSION);
$sql = "UPDATE l_session SET refresh='N' WHERE id='$SID'";
mysql_query($sql);
}
return $session;
}
else {
mysql_session_destroy($SID);
}
}
sessionStaticInfo();
return "";
}
function mysql_session_write($SID,$value) {
$expiration = time() + SESSION_LIFETIME;
$ip = $_SERVER['REMOTE_ADDR'];
$SID = addslashes($SID);
$value = addslashes($value);
if( isset( $_SESSION['callsign'] ) ) {
$callsign = "'" . addslashes($_SESSION['callsign']) . "'";
$playerid = $_SESSION['playerid'];
} else {
$callsign = 'NULL';
$playerid = 0;
}
$sql = "INSERT INTO l_session (id, expire, data, callsign, playerid,ip) ".
"VALUES( '$SID',FROM_UNIXTIME($expiration),'$value',$callsign,$playerid,'$ip') ";
$res = mysql_query($sql);
// No point in much errorchecking, as
// we cannot do anything about it. (this is executed after output is generated)
if(! $res ) { // If error, we try to update
$sql = "UPDATE l_session SET ".
"expire = FROM_UNIXTIME($expiration), ".
"data = '$value', ".
"callsign = $callsign, ".
"playerid = $playerid ".
"WHERE id = '$SID' ";
mysql_query($sql);
}
return true;
}
function mysql_session_destroy($SID) {
$SID = addslashes($SID);
$sql = "DELETE FROM l_session WHERE id = '$SID'";
mysql_query($sql);
unset ($_SESSION);
sessionStaticInfo();
}
function mysql_session_gc($lifetime) {
$sql = "DELETE FROM l_session ".
"WHERE expire < FROM_UNIXTIME(" . (time() - $lifetime) . ")";
$res = mysql_query($sql);
if( $res )
return mysql_affected_rows();
else
return 0;
}
function session_refresh_all() {
if( $_SESSION['player_id'] ) {
sqlQuery("UPDATE l_session SET refresh='Y' WHERE playerid!='{$_SESSION['playerid']}'");
session_refresh();
}
else {
sqlQuery("UPDATE l_session SET refresh='Y'");
}
}
function session_refresh($id = null) {
// If no id specified, use current playerid
if( $id === null )
$id = (isset($_SESSION['playerid']) ? $_SESSION['playerid'] : null );
// This is a guest user, ignore it
if( $id === null ) return;
// If $id is current user, then dont flag. Just reload data
if( $id == $_SESSION['playerid'] )
session_data_reload($id);
else
sqlQuery("UPDATE l_session SET refresh='Y' WHERE playerid='$id'");
}
function session_data_reload($id) {
$old_role_id = $_SESSION['role_id'];
$row = mysql_fetch_object (sqlQuery("SELECT p.team, r.name as level, r.id as role_id, p.team FROM l_player p, bzl_roles r WHERE r.id = p.role_id AND p.id=$id")) or die(mysql_error());
$_SESSION['teamid'] = $row->team;
$_SESSION['level'] = $row->level;
$_SESSION['role_id'] = $row->role_id;
$row = mysql_fetch_object (sqlQuery("SELECT leader FROM l_team WHERE id={$_SESSION['teamid']}"));
$_SESSION['leader'] = ($row->leader == $id);
$_SESSION['playerid'] = $id;
// mail - detect new messages
if( ! isset($_SESSION['lst_msg_read_ts']) )
$_SESSION['last_msg_read_ts'] = $_SESSION['last_login'];
$row = mysql_fetch_object(mysql_query("
SELECT count(*) as num, max(unix_timestamp(datesent)) latest_ts
FROM l_message
WHERE toid=$id and status='new'
"));
$_SESSION['mail_unread'] = $row->num;
$_SESSION['new_mail'] = ($row->latest_ts > $_SESSION['last_msg_read_ts']);
// match
$res = sqlQuery ('select unix_timestamp(tsactual) as ts from '. TBL_MATCH .' order by tsactual desc limit 1');
$row = mysql_fetch_object($res);
if ( $_SESSION['last_login'] < $row->ts )
$_SESSION['new_match'] = 1;
else
$_SESSION['new_match'] = 0;
// forum
$res = sqlQuery ('select unix_timestamp(datesent) as ts from l_forummsg order by datesent desc limit 1');
$row = mysql_fetch_object($res);
if ( $_SESSION['last_login'] < $row->ts )
$_SESSION['new_forum'] = 1;
else
$_SESSION['new_forum'] = 0;
//news
$row = mysql_fetch_object (sqlQuery ('select unix_timestamp(newsdate) as ts from bzl_news order by newsdate desc limit 1'));
if ( $_SESSION['last_login'] < $row->ts )
$_SESSION['new_news'] = 1;
else
$_SESSION['new_news'] = 0;
// Get permissions, if changed
if( $old_role_id != $_SESSION['role_id'] ) {
$res = mysql_query("SELECT name FROM bzl_permissions WHERE role_id = {$_SESSION['role_id']}") or die(mysql_error());
$_SESSION['permissions'] = array();
while($row = mysql_fetch_array($res)) {
$_SESSION['permissions'][$row[0]] = 1;
}
}
}
?>
I'm really struggling what to do, can anyone guide me?
Last edited by neogrant; 11-08-2008 at 05:26 PM..
|
