maolenkuldar12

tere

probleem nimelt selles et installisin omale mybbshoutboxi aga see on foorumi lehe all ,tahaks et ta oleks üleval

http://www.ernitsate.eu

mees ,free banne ma ei tee ,sa olid ilus wh

sain korda,rammi pulk oli pesast väljas ja polnud piisavalt ramme et käivituks

Videokaart on 512mb ja nvidia 5900

oih

tean milles viga

üks rammi pulk on perses,panin alles nööd seda tähele .Polnd enne rammi pulka vaadanud .

Võib lukku panna .

Vajutan .exe faili aga midagi ei juhtu .Kuskil .txt failis on järgmine sisu:

******** : log created on : Friday February 08 2013 @ 22:29:1622:29:16 : [sys] running on x86 / Windows XP (version 5.1) / Service Pack 3
22:29:16 : [sys] DirectX version : 4.09.00.0904
22:29:16 : [cpu] AuthenticAMD [AMD Athlon(tm) X2 Dual Core Processor BE-2300] at ~1908MHz.
22:29:16 : [cpu] Features utilized: fpu cmov mmx mmxext 3dnow 3dnowext sse sse2.
22:29:16 : [sys] using QPC / TSC timer (thread affinity: 0), frequency 1908760000Hz
22:29:16 : physical memory detected (261288K/58416K)
22:29:16 : virtual memory detected (2097024K/2061572K)
22:29:16 : Memory allocation failed.

ei kasuta ,ise arvan et via on proses

Tere

Tahaks teada miks mul xp sp3 pidurdab.Nett jookseb kokku ja natuese ajapärast jälle korras,kui csi alla panen siis jookseb ka kokku

Kus ma selle leian ?

oskab keegi aidata ?

Tere

Nimelt tahaks teha omale sellist menüüd nagu on http://www.estwar3ft.eu/ ,tahas siis lisada sinna amxbans ja vip paneel .

Nimelt mis faile muutma peaks ?

Kõik soundid eemaldatud ,serveri rated paigas jne . Liitu juba täna

Mõtlesin siis teha endale Runescape Private serveri,aga oleks vaja hosterit selleks,kes saab aitada palun kirjutage siia alla või kirjutage minu MSNi.Serveri hoster saaks Co-Owneriks ja saaks 30% teenitud rahast!

Hoster ei peaks ise koodima ja serveri jaoks midagi tegema,aga oleks parem kui pordid oleks juba avatud!

MSN:Estoniaanonymous@hotmail.com

NB!Mitte saata kirja maolenkuldar12 MSNile

Mõtlesin siis teha endale Runescape Private serveri,aga oleks vaja hosterit selleks,kes saab aitada palun kirjutage siia alla või kirjutage minu MSNi.Serveri hoster saaks Co-Owneriks ja saaks 30% teenitud rahast!Hoster ei peaks ise koodima ja serveri jaoks midagi tegema,aga oleks parem kui pordid oleks juba avatud!

MSN:Estoniaanonymous@hotmail.com

NB!Mitte saata kirja maolenkuldar12 MSNile!

Mõtlesin siis teha endale Runescape Private serveri,aga oleks vaja hosterit selleks,kes saab aitada palun kirjutage siia alla või kirjutage minu MSNi.Serveri hoster saaks Co-Owneriks ja saaks 30% teenitud rahast!

Hoster ei peaks ise koodima ja serveri jaoks midagi tegema,aga oleks parem kui pordid oleks juba avatud!

MSN:Estoniaanonymous@hotmail.com

NB!Mitte saata kirja maolenkuldar12 MSNile!

Aquellium - Aquellium.Com

Tere

Kas keegi teab mõnda head csi filmimis programmi ,millega saab videot teha ?

serveril pole elam mõtetuid pluginaid

Tere

Lisasin oma foorumile http://www.ernitsate.eu/foorum/index.php shoutboxi, aga tahaks nii teha ,et kõik näevad seda mitte ainult sisseloginud kasutajad.

Kuldar

Sain korda.

Mis failis täpsemalt?

Oskab keegi aidata?

Nimelt kui lisan admini flagiga a siis ütleb Unknown column 'icq' in 'field list'

sain korda juba

<?php

 

/*

 

 

AMXBans v6.0

 

Copyright 2009, 2010 by SeToY & |PJ|ShOrTy

 

 

This file is part of AMXBans.

 

 

AMXBans is free software, but it's licensed under the

Creative Commons - Attribution-NonCommercial-ShareAlike 2.0

 

 

AMXBans is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

 

 

You should have received a copy of the cc-nC-SA along with AMXBans.

If not, see .

 

 

*/

 

 

// sql functions

 

 

function sql_set_websettings() {

global $config;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_webconfig`") or die (mysql_error());

$result = mysql_fetch_object($query);

$config->cookie=$result->cookie;

$config->bans_per_page=($result->bans_per_page)bans_per_page;

$config->design = $result->design;

$config->banner = $result->banner;

$config->banner_url = $result->banner_url;

$config->default_lang = $result->default_lang;

$config->start_page = $result->start_page;

$config->show_kick_count = $result->show_kick_count;

$config->show_comment_count = $result->show_comment_count;

$config->show_demo_count = $result->show_demo_count;

$config->demo_all = $result->demo_all;

$config->max_file_size = $result->max_file_size;

$config->file_type = $result->file_type;

$config->comment_all = $result->comment_all;

$config->use_capture = $result->use_capture;

$config->auto_prune = $result->auto_prune;

$config->max_offences = $result->max_offences;

$config->max_offences_reason = $result->max_offences_reason;

$config->use_demo = $result->use_demo;

$config->use_comment = $result->use_comment;

//set vars to an array

$vars=array(

"cookie"=>trim($config->cookie),

"design"=>$config->design,

"bans_per_page"=>(int)$config->bans_per_page,

"banner"=>$config->banner,

"banner_url"=>$config->banner_url,

"default_lang"=>$config->default_lang,

"start_page"=>$config->start_page,

"show_kick_count"=>$config->show_kick_count,

"show_demo_count"=>$config->show_demo_count,

"show_comment_count"=>$config->show_comment_count,

"demo_all" => $config->demo_all,

"comment_all" => $config->comment_all,

"use_capture" => $config->use_capture,

"max_file_size" => (int)$config->max_file_size,

"file_type" => trim($config->file_type),

"auto_prune" => (int)$config->auto_prune,

"max_offences" => (int)$config->max_offences,

"max_offences_reason" => $config->max_offences_reason,

"use_demo" => (int)$result->use_demo,

"use_comment" => $result->use_comment

);

return $vars;

}

function sql_get_server($serverid=0) {

global $config;

if($serverid) {

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_serverinfo` WHERE `id`=".$serverid." LIMIT 1") or die (mysql_error());

} else {

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_serverinfo` ORDER BY `address` ASC") or die (mysql_error());

$servers=array();

}

while($result = mysql_fetch_object($query)) {

$server=array(

"sid"=>$result->id,

"timestamp"=>$result->timestamp,

"hostname"=>html_safe($result->hostname),

"address"=>$result->address,

"gametype"=>$result->gametype,

"rcon"=>$result->rcon,

"amxban_version"=>$result->amxban_version,

"amxban_motd"=>$result->amxban_motd,

"motd_delay"=>$result->motd_delay,

"amxban_menu"=>$result->amxban_menu,

"reasons"=>$result->reasons,

"timezone_fixx"=>$result->timezone_fixx

);

if(!$serverid) $servers[]=$server;

}

if(!$serverid) return $servers;

return $server;

}

function sql_get_server_ids() {

global $config;

$query = mysql_query("SELECT `id` FROM `".$config->db_prefix."_serverinfo` ORDER BY `address` ASC") or die (mysql_error());

$serverids=array();

while($result = mysql_fetch_object($query)) {

$serverids[]=$result->id;

}

return $serverids;

}

function sql_get_reasons_set() {

global $config;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_reasons_set` ORDER BY `setname` ASC") or die (mysql_error());

$reasons_set=array();

while($result = mysql_fetch_object($query)) {

$reason_set=array(

"id"=>$result->id,

"setname"=>html_safe($result->setname)

);

$query2 = mysql_query("SELECT * FROM `".$config->db_prefix."_reasons_to_set` WHERE `setid`=".$result->id) or die (mysql_error());

$reasons="";

while($result2 = mysql_fetch_object($query2)) {

$reasons.=($reasons)?",".$result2->reasonid:$result2->reasonid;

}

$reason_set["reasonids"]=$reasons;

$reasons_set[]=$reason_set;

}

return $reasons_set;

}

function sql_get_reasons() {

global $config;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_reasons` ORDER BY `id` ASC") or die (mysql_error());

$reasons=array();

while($result = mysql_fetch_object($query)) {

$reason=array(

"id"=>$result->id,

"reason"=>html_safe($result->reason),

"static_bantime"=>$result->static_bantime

);

$reasons[]=$reason;

}

return $reasons;

}

function sql_get_reasons_list() {

global $config;

$reasons = array();

$query = mysql_query("SELECT reason FROM `".$config->db_prefix."_reasons` ORDER BY `id` ASC") or die (mysql_error());

while($result = mysql_fetch_object($query)) {

$reasons[]=$result->reason;

}

return $reasons;

}

function sql_get_amxadmins() {

global $config;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_amxadmins` ORDER BY `access` DESC,`expired`,`access` DESC,`username` ASC") or die (mysql_error());

$admins=array();

while($result = mysql_fetch_object($query)) {

$admin=array(

"aid"=>$result->id,

"username"=>html_safe($result->username),

"password"=>$result->password,

"access"=>$result->access,

"flags"=>$result->flags,

"steamid"=>$result->steamid,

"nickname"=>html_safe($result->nickname),

"ashow"=>$result->ashow,

"created"=>$result->created,

"expired"=>$result->expired,

"days"=>$result->days

);

$admins[]=$admin;

}

return $admins;

}

function sql_get_amxadmins_list() {

global $config;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_amxadmins` WHERE `ashow`=1 AND (`expired`=0 OR `expired`>UNIX_TIMESTAMP()) ORDER BY `expired`,`access` DESC,`username` ASC") or die (mysql_error());

$admins=array();

while($result = mysql_fetch_object($query)) {

if(!empty($result->steamid)) {

$steamid = htmlentities($result->steamid, ENT_QUOTES);

$steamcomid = GetFriendId($steamid);

}

$admin=array(

"aid"=>$result->id,

"username"=>html_safe($result->username),

"comid"=>$steamcomid,

"password"=>$result->password,

"access"=>$result->access,

"flags"=>$result->flags,

"steamid"=>$result->steamid,

"nickname"=>html_safe($result->nickname),

"ashow"=>$result->ashow,

"created"=>$result->created,

"expired"=>$result->expired,

"days"=>$result->days

);

$admins[]=$admin;

}

return $admins;

}

function sql_get_amxadmins_server($server) {

global $config;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_amxadmins` ORDER BY `ashow` DESC,`expired`,`access` DESC,`username` ASC") or die (mysql_error());

$admins=array();

while($result = mysql_fetch_object($query)) {

$query2 = mysql_query("SELECT `custom_flags`,`use_static_bantime` FROM `".$config->db_prefix."_admins_servers` WHERE `admin_id`=".$result->id." AND `server_id`=".$server) or die (mysql_error());

if($result2 = mysql_fetch_object($query2)) {

$custom_flags=$result2->custom_flags;

$static_bantime=$result2->use_static_bantime;

$aktiv=1;

} else {

$custom_flags="";

$static_bantime="no";

$aktiv=0;

}

$admin=array(

"sid"=>$server,

"aid"=>$result->id,

"username"=>html_safe($result->username),

"password"=>$result->password,

"access"=>$result->access,

"flags"=>$result->flags,

"steamid"=>$result->steamid,

"nickname"=>html_safe($result->nickname),

"ashow"=>$result->ashow,

"custom_flags"=>$custom_flags,

"use_static_bantime"=>$static_bantime,

"aktiv"=>$aktiv

);

$admins[]=$admin;

}

return $admins;

}

function sql_get_webadmins() {

global $config;

$query = mysql_query("SELECT id,username,level,last_action,email FROM `".$config->db_prefix."_webadmins` ORDER BY `level`,`username`") or die (mysql_error());

$users=array();

 

while($result = mysql_fetch_object($query)) {

$user=array(

"uid"=>$result->id,

"name"=>html_safe($result->username),

"level"=>$result->level,

"last_action"=>$result->last_action,

"email"=>html_safe($result->email)

);

$users[]=$user;

}

return $users;

}

 

 

function sql_get_server_admins($server) {

global $config;

$serveradmins=array();

$query = mysql_query("SELECT s.admin_id,s.custom_flags,s.use_static_bantime,a.username FROM ".$config->db_prefix."_admins_servers as s,".$config->db_prefix."_amxadmins as a WHERE s.server_id=".$server) or die (mysql_error());

$admins=array();

while($result = mysql_fetch_object($query)) {

$admin=array(

"admin_id"=>$result->admin_id,

"custom_flags"=>$result->custom_flags,

"use_static_bantime"=>$result->static_bantime,

"username"=>html_safe($result->username)

);

$admins[]=$admin;

}

return $admins;

}

function sql_get_usermenu(&$count) {

global $config;

//get menu from db

global $count;

$menu=array();

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_usermenu` ORDER BY `pos` ASC") or die (mysql_error());

$count=0;

while($result = mysql_fetch_object($query)) {

$men=array(

"id"=>$result->id,

"pos"=>$result->pos,

"activ"=>$result->activ,

"lang_key"=>$result->lang_key,

"url"=>$result->url,

"lang_key2"=>$result->lang_key2,

"url2"=>$result->url2,

);

$count++;

$menu[]=$men;

}

 

return $menu;

}

function sql_get_modules($aktiv_only=0,&$count) {

global $config;

global $mysql;

$select="SELECT * FROM `".$config->db_prefix."_modulconfig`";

if($aktiv_only===1) $select.=" WHERE `activ`=1";

$select.=" ORDER BY `name` ASC";

 

$query = mysql_query($select,$mysql) or die (mysql_error());

$modules=array();

while($result = mysql_fetch_object($query)) {

$modul=array(

"id"=>$result->id,

"menuname"=>html_safe($result->menuname),

"name"=>html_safe($result->name),

"index"=>$result->index,

"activ"=>$result->activ,

"admin_page_exists"=>file_exists("include/modules/modul_".$result->name.".php")?1:0,

"tpl_exists"=>file_exists("templates/modul_".$result->name.".tpl")?1:0,

"index_exists"=>file_exists($result->index.".php")?1:0

);

$count++;

$modules[]=$modul;

}

return $modules;

}

function sql_get_ban_details($bid) {

global $config;

//banns for ID

#$query = mysql_query("SELECT ba.*, se.gametype,se.timezone_fixx, aa.nickname, wa.username FROM `".$config->db_prefix."_bans` AS ba

# LEFT JOIN `".$config->db_prefix."_serverinfo` AS se ON ba.server_ip=se.address

# LEFT JOIN `".$config->db_prefix."_amxadmins` AS aa ON (aa.steamid=ba.admin_nick OR aa.steamid=ba.admin_ip OR aa.steamid=ba.admin_id)

# LEFT JOIN `".$config->db_prefix."_webadmins` AS wa ON wa.username=ba.admin_nick WHERE ba.bid=".$bid." LIMIT 1") or die (mysql_error());

$query = mysql_query("SELECT ba.*, se.gametype,se.timezone_fixx, aa.nickname,aa.username FROM `".$config->db_prefix."_bans` AS ba

LEFT JOIN `".$config->db_prefix."_serverinfo` AS se ON ba.server_ip=se.address

LEFT JOIN `".$config->db_prefix."_amxadmins` AS aa ON (aa.steamid=ba.admin_nick OR aa.steamid=ba.admin_ip OR aa.steamid=ba.admin_id)

WHERE ba.bid=".$bid." LIMIT 1") or die (mysql_error());

//Array aufbereiten

$ban_row=mysql_fetch_assoc($query);

//timezone fixx and ban_end calc

$ban_row["ban_created"]=($ban_row["ban_created"] + ($ban_row["timezone_fixx"] * 60 * 60));

$ban_row["ban_end"]=($ban_row["ban_created"] + ($ban_row["ban_length"] * 60));

$ban_row["player_nick"] = html_safe($ban_row["player_nick"]);

 

return $ban_row;

}

function sql_get_ban_details_activ($steamid,&$count,$bid) {

global $config;

//banns for ID without $bid

$query = mysql_query("SELECT ba.*,se.timezone_fixx FROM `".$config->db_prefix."_bans` AS ba

LEFT JOIN `".$config->db_prefix."_serverinfo` AS se ON ba.server_ip=se.address

WHERE `player_id`='".$steamid."' AND `expired`=0 AND `bid`".$bid) or die (mysql_error());

//Array aufbereiten

$ban_rows=array();

while($ban_row=mysql_fetch_assoc($query)) {

$count++;

//timezone fixx and ban_end calc

$ban_row["ban_created"]=($ban_row["ban_created"] + ($ban_row["timezone_fixx"] * 60 * 60));

$ban_row["ban_end"]=($ban_row["ban_created"] + ($ban_row["ban_length"] * 60));

$ban_rows[]=$ban_row;

}

return $ban_rows;

}

function sql_get_ban_details_exp($steamid,&$count,$bid) {

global $config;

//exp bans for ID without $bid

$query = mysql_query("SELECT ba.*,se.timezone_fixx FROM `".$config->db_prefix."_bans` AS ba

LEFT JOIN `".$config->db_prefix."_serverinfo` AS se ON ba.server_ip=se.address

WHERE `player_id`='".$steamid."' AND `expired`=1 AND `bid`".$bid) or die (mysql_error());

//Array aufbereiten

$ban_rows=array();

while($ban_row=mysql_fetch_assoc($query)) {

$count++;

//timezone fixx and ban_end calc

$ban_row["ban_created"]=($ban_row["ban_created"] + ($ban_row["timezone_fixx"] * 60 * 60));

$ban_row["ban_end"]=($ban_row["ban_created"] + ($ban_row["ban_length"] * 60));

$ban_rows[]=$ban_row;

}

return $ban_rows;

}

function sql_get_ban_details_motd_exp($steamid,&$count) {

global $config;

//exp bans for ID without $bid

$query = mysql_query("SELECT ba.*,se.timezone_fixx FROM `".$config->db_prefix."_bans` AS ba

LEFT JOIN `".$config->db_prefix."_serverinfo` AS se ON ba.server_ip=se.address

WHERE `player_id`='".$steamid."' AND `expired`=1 ORDER BY ban_created DESC") or die (mysql_error());

//Array aufbereiten

$ban_rows=array();

while($ban_row=mysql_fetch_assoc($query)) {

//timezone fixx and ban_end calc

$ban_row["ban_created"]=($ban_row["ban_created"] + ($ban_row["timezone_fixx"] * 60 * 60));

$ban_row["ban_end"]=($ban_row["ban_created"] + ($ban_row["ban_length"] * 60));

 

if($ban_row["server_ip"]!="website") {

if($show_admin==0 && $ban_row["nickname"]!="") {

$ban_row["admin_nick"]=$ban_row["nickname"];

}

}

 

$ban_row["player_nick"]=html_safe($ban_row["player_nick"]);

$ban_row["admin_nick"]=html_safe($ban_row["admin_nick"]);

$ban_row["server_name"]=html_safe($ban_row["server_name"]);

 

$ban_rows[]=$ban_row;

$count++;

}

return $ban_rows;

}

function sql_get_comments_count($bid) {

global $config;

$query = mysql_query("SELECT COUNT(*) FROM `".$config->db_prefix."_comments`".(($bid) ?" WHERE `bid`=".$bid : "")) or die (mysql_error());

return mysql_result($query,0);

}

function sql_get_comments_count_fail($repair=0) {

global $config;

$repaired=0;

//first search in the db for files without a ban

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_comments` WHERE `bid` NOT IN (SELECT DISTINCT `bid` FROM `".$config->db_prefix."_bans`)") or die (mysql_error());

 

if(!$repair) return mysql_num_rows($query);

 

while($result = mysql_fetch_object($query)) {

//delete db entry

$query2 = mysql_query("DELETE FROM `".$config->db_prefix."_comments` WHERE `id`=".$result->id." LIMIT 1") or die (mysql_error());

$repaired++;

}

return $repaired;

}

function sql_get_comments($bid,&$count) {

global $config;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_comments` WHERE `bid`=".$bid." ORDER BY `date` ASC") or die (mysql_error());

//Array aufbereiten

$comments=array();

while($result = mysql_fetch_object($query)) {

$comment=array(

"id"=>$result->id,

"name"=>html_safe($result->name),

"comment"=>html_safe($result->comment),

"email"=>html_safe($result->email),

"addr"=>$result->addr,

"date"=>$result->date

);

$count++;

$comments[]=$comment;

}

return $comments;

}

function sql_get_files_count($bid) {

global $config;

$query = mysql_query("SELECT COUNT(*) FROM `".$config->db_prefix."_files`".(($bid) ?" WHERE `bid`=".$bid : "")) or die (mysql_error());

return mysql_result($query,0);

}

function sql_get_files_count_fail($repair=0) {

global $config;

$fail=0;

$repaired=0;

//first search in the db for files without a ban

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_files` WHERE `bid` NOT IN (SELECT DISTINCT `bid` FROM `".$config->db_prefix."_bans`)") or die (mysql_error());

$fail=mysql_num_rows($query);

//search files without db entry

$d=opendir($config->path_root."/include/files/");

while($f=readdir($d)) {

if($f=="." || $f==".." || is_dir($config->path_root."/include/files/".$f) || $f=="index.php") continue;

if(is_file($config->path_root."/include/files/".$f)) {

$f=str_replace("_thumb","",$f);

$query2 = mysql_query("SELECT * FROM `".$config->db_prefix."_files` WHERE `demo_file`='".$f."'") or die (mysql_error());

if(!mysql_num_rows($query2)) {

$files[]=$f;

$fail++;

}

}

}

closedir($d);

if(!$repair) return $fail;

//delete fails from db

while($result = mysql_fetch_object($query)) {

//delete files

if(file_exists("include/files/".$result->demo_file)) unlink("include/files/".$result->demo_file);

if(file_exists("include/files/".$result->demo_file."_thumb")) unlink("include/files/".$result->demo_file."_thumb");

//delete db entry

$query3 = mysql_query("DELETE FROM `".$config->db_prefix."_files` WHERE `id`=".$result->id." LIMIT 1") or die (mysql_error());

$repaired++;

}

//delete files from dir without db entry

for($i=0;$i

if(file_exists("include/files/".$files[$i])) unlink("include/files/".$files[$i]);

if(file_exists("include/files/".$files[$i]."_thumb")) unlink("include/files/".$files[$i]."_thumb");

$repaired++;

}

return $repaired;

}

function sql_get_files($bid,&$count) {

global $config;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_files` WHERE `bid`=".$bid." ORDER BY `upload_time` ASC") or die (mysql_error());

//Array aufbereiten

$files=array();

while($result = mysql_fetch_object($query)) {

if(file_exists("include/files/".$result->demo_file."_thumb")) $thumb=1;

$file=array(

"id"=>$result->id,

"demo_file"=>$result->demo_file,

"demo_real"=>html_safe($result->demo_real),

"comment"=>html_safe($result->comment),

"upload_time"=>$result->upload_time,

"down_count"=>$result->down_count,

"name"=>html_safe($result->name),

"email"=>html_safe($result->email),

"file_size"=>$result->file_size,

"addr"=>$result->addr,

"thumb"=>$thumb

);

$count++;

$files[]=$file;

}

return $files;

}

function sql_get_search_amxadmins(&$amxadmins,&$nickadmins) {

global $config;

$query = mysql_query("SELECT `admin_id`,`admin_nick` FROM `".$config->db_prefix."_bans` GROUP BY `admin_id` ORDER BY `admin_nick`") or die (mysql_error());

while($result = mysql_fetch_object($query)) {

$checkQry = mysql_query("SELECT * FROM `".$config->db_prefix."_amxadmins` WHERE `steamid`='".$result->admin_id."' GROUP BY `steamid`") or die (mysql_error());

if( mysql_num_rows($checkQry) > 0 ) {

//-- Is Found

if($result->admin_id "") $amxadmins[]=array("steam"=>$result->admin_id,"nick"=>html_safe($result->admin_nick));

} else {

//-- Not Found

if($result->admin_id "") $nickadmins[]=array("steam"=>$result->admin_id,"nick"=>html_safe($result->admin_nick));

}

}

}

function sql_get_search_servers() {

global $config;

$servers = array();

$query = mysql_query("SELECT `server_ip`,`server_name` FROM `".$config->db_prefix."_bans` GROUP BY `server_ip` ORDER BY `server_name`") or die (mysql_error());

//Array aufbereiten

while($result = mysql_fetch_object($query)) {

if($result->server_name=="website") {

$servers["website"]="_WEB";

} else {

$servers[$result->server_ip]=html_safe($result->server_name);

}

}

return $servers;

}

function sql_get_search_reasons() {

global $config;

$query = mysql_query("SELECT DISTINCT `ban_reason` FROM `".$config->db_prefix."_bans` ORDER BY `ban_reason`") or die (mysql_error());

//Array aufbereiten

while($result = mysql_fetch_object($query)) {

$reasons[$result->ban_reason]=html_safe($result->ban_reason);

}

return $reasons;

}

function sql_get_search_bans($search,$active=1,&$count=0) {

global $config;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_bans` WHERE ".$search." AND `expired`=".(($active==1)?0:1)." ORDER BY `ban_created` DESC") or die (mysql_error());

//Array aufbereiten

 

$ban_list = array();

while($result = mysql_fetch_object($query)) {

if(!empty($result->player_id)) {

$steamid = htmlentities($result->player_id, ENT_QUOTES);

$steamcomid = GetFriendId($steamid);

$query2 = mysql_query("SELECT COUNT(*) FROM `".$config->db_prefix."_bans` WHERE `player_id`='".$result->player_id."' AND `expired`=1");

$bancount=mysql_result($query2,0);

}

$ban_row=array(

"bid" => $result->bid,

"player_ip" => $result->player_ip,

"player_id" => $result->player_id,

"player_comid" => $steamcomid,

"player_nick" => html_safe($result->player_nick),

"admin_ip" => $result->admin_ip,

"admin_id" => $result->admin_id,

"admin_nick" => html_safe($result->admin_nick),

"ban_type" => $result->ban_type,

"ban_reason" => html_safe($result->ban_reason),

"ban_created" => $result->ban_created,

"ban_length" => $result->ban_length,

"ban_end" => ($result->ban_created + ($result->ban_length * 60)),

"server_ip" => $result->server_ip,

"server_name" => html_safe($result->server_name),

"bancount" => $bancount

);

if($config->show_kick_count=="1") {

$ban_row["kick_count"]=$result->ban_kicks;

$ban_page["show_kicks"]=1;

}

if($config->show_demo_count=="1") {

$file_count=0;

sql_get_files($result->bid,$file_count);

$ban_row["demo_count"]=$file_count;

$ban_page["show_demos"]=1;

}

if($config->show_comment_count=="1") {

$comment_count=0;

sql_get_comments($result->bid,$comment_count);

$ban_row["comment_count"]=$comment_count;

$ban_page["show_comments"]=1;

}

$count++;

$ban_list[]=$ban_row;

}

return $ban_list;

}

function sql_get_bans_count($activ_only=1) {

global $config;

 

 

if($activ_only == '1') {

$active = " WHERE (((ban_created+(ban_length*60)) > ".time()." OR ban_length=0))";

} else {

$active = "";

}

 

 

$query = mysql_query("SELECT COUNT(*) FROM `".$config->db_prefix."_bans`".$active) or die ("Fuck: ".mysql_error());

return mysql_result($query,0);

}

function sql_get_logs($filter) {

global $config;

if($filter) $where="WHERE ".$filter;

$query = mysql_query("SELECT * FROM `".$config->db_prefix."_logs` ".$where." ORDER BY `timestamp` DESC") or die (mysql_error());

//Array aufbereiten

$rows=array();

while($row=mysql_fetch_assoc($query)) {

$rows[]=$row;

}

array_walk_recursive($rows,"escape_array");

return $rows;

}

function escape_array($value,$key) {

$value=html_safe($value);

}

?>

See.