<?php
class MSSQL {

var $database = NULL;
var $sqls = NULL;
var $host = NULL;
var $username = NULL;
var $password = NULL;
var $databaseName = NULL;
var $link = NULL;
var $queries = NULL;
var $errors = NULL;

function database_mssql($host, $username, $password, $database) {

$this->host = $host;
$this->username = sha1($username);
$this->password = sha1($password);
$this->database = $database;
$this->link = "";
$this->queries = array ();
$this->errors = array ();

$this->sqls = array ();

$this->link = mssql_connect($this->$host, $username, $password);
mssql_select_db($this->database, $this->link);
}

function simpleFetchArray($sql) {
$this->queries[] = $sql;
return mssql_fetch_array($sql);
}

function simpleNumRows($sql) {
$this->queries[] = $sql;
return mssql_num_rows($sql);
}

function simpleFetchRow($sql) {
$this->queries[] = $sql;
return mssql_fetch_row($sql);
}

function justquery($sql) {
$this->queries[] = $sql;
return mssql_query($sql, $this->link);
}

function fetchArray($sql) {
$this->queries[] = $sql;
return mssql_fetch_array(mssql_query($sql, $this->link));
}

function fetchRow($sql) {
$this->queries[] = $sql;
return mssql_fetch_row(mssql_query($sql, $this->link));
}

function mssql_query($sql) {
$this->queries[] = $sql;
return mssql_query($sql, $this->link);
}

function login($username, $password) {
$login = mssql_query(sprintf("SELECT * from ".DB_LOGIN.".[dbo].[cabal_auth_table] where ID = '%s'",str_replace("'", "''", $username)));
$result = mssql_fetch_row($login);
$login_result_valid_encrypt_password = mssql_query('exec '.DB_LOGIN.'.dbo.cabal_sp_IsValidPassword_by_ID "'.$result[1].'" , "'.$password.'"');
$login_result= mssql_fetch_array($login_result_valid_encrypt_password);
return $login_result;
}

function check_username($username)
{
$check_username = mssql_query(sprintf("SELECT * from ".DB_LOGIN.".[dbo].[cabal_auth_table] where ID = '%s'",str_replace("'", "''", $username)));
$check_username_result = mssql_fetch_row($check_username);
return $check_username_result;
}

function lastmember()
{
$lastmember = mssql_query("SELECT ID FROM ".DB_LOGIN.".[dbo].[cabal_auth_table] order by id desc");
$lastmember_result = mssql_fetch_row($lastmember);
return $lastmember_result[0];
}

function countRows($sql) {
$this->queries[] = $sql;
return mssql_num_rows($sql);
}

function execRegister($username, $password, $firstname ,$lastname, $gender, $address, $country, $city, $zip_code, $phone_number, $email, $secret_question, $secret_answer, $code)
 {
$register = mssql_query('exec '.DB_LOGIN.'.[dbo].[cabal_tool_registerAccount]"'. $username .'","'. $password .'","'. $firstname .'","'. $lastname . '","'. $gender . '", "'. $address . '","'. $country . '","'. $city . '","'. $zip_code . '","'. $phone_number . '","'. $email . '","'. $secret_question . '","'. $secret_answer . '","'. $code . '"');
return $register;
}

function activate_account($codelink,$codedb,$username) {
$check = "select AuthType from ".DB_LOGIN.".[dbo].[cabal_auth_table] where ID = '".$username."'";
$runcheck = mssql_query($check);
$fetchit = mssql_fetch_array($runcheck);
if ($fetchit[0] > 0) {
	return false;
}
else {
$sql = "UPDATE ".DB_LOGIN.".[dbo].[cabal_auth_table]
	SET Authtype = 1
	WHERE ID = '".$username."'";

$this->queries[] = $sql;
$run = mssql_query($sql, $this->link);
if (!$run) {
	return false;
}
else {
	return true;
}
}

}

function confirm_code($code)
{
$confirm_code = mssql_query("SELECT ID, code from ".DB_LOGIN.".[dbo].[cabal_auth_table] where code = '".$code."'");
$confirm_code_result = mssql_fetch_array($confirm_code);
return $confirm_code_result;
}

function check_code($username)
{
$sql = mssql_query("SELECT code from ".DB_LOGIN.".[dbo].[cabal_auth_table] where ID = '".$username."'");
$result = mssql_fetch_array($sql);
return $result;
}

function manual_activate_account($username)
{
$sql = mssql_query("UPDATE ".DB_LOGIN.".[dbo].[cabal_auth_table] SET Authtype = 1 WHERE ID = '".$username."'");
return $sql;
}

function check_account($username)
{
$sql = mssql_query("SELECT ID, AuthType, ban_advanced, ban_reason, convert(varchar(20), ban_duration, 120) from ".DB_LOGIN.".[dbo].[cabal_auth_table] where ID = '".$username."'");
$result = mssql_fetch_array($sql);
return $result;
}

function check_email($username)
{
$checkemail = mssql_query("select ID, email, code from ".DB_LOGIN.".[dbo].cabal_auth_table where ID='".$username."'");
$result = mssql_fetch_array($checkemail);
return $result;
}

function get_account_information($username)
{
$sql = mssql_query("select convert(varchar(20), LoginTime, 120), convert(varchar(20), LogoutTime, 120), PlayTime, LastIp, convert(varchar(20), CreateDate, 120), firstname, lastname, gender, address, country, city, zip_code, phone_number, email, secret_question, secret_answer, Login from ".DB_LOGIN.".[dbo].[cabal_auth_table] where ID='".$username."'");
$result = mssql_fetch_array($sql);
return $result;
}

function check_secret_question_answer($username)
{
$sql = mssql_query("select secret_question, secret_answer from ".DB_LOGIN.".[dbo].[cabal_auth_table] where ID = '".$username."'");
$result = mssql_fetch_array($sql);
return $result;
}

function change_email($username,$new_email)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set email='".$new_email."' where ID='".$username."'");
return $sql;
}

function change_firstname($username,$new_firstname)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set firstname='".$new_firstname."' where ID='".$username."'");
return $sql;
}

function change_lastname($username,$new_lastname)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set lastname='".$new_lastname."' where ID='".$username."'");
return $sql;
}

function change_gender($username,$new_gender)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set gender='".$new_gender."' where ID='".$username."'");
return $sql;
}

function change_address($username,$new_address)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set address='".$new_address."' where ID='".$username."'");
return $sql;
}

function change_country($username,$new_country)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set country='".$new_country."' where ID='".$username."'");
return $sql;
}

function change_city($username,$new_city)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set city='".$new_city."' where ID='".$username."'");
return $sql;
}

function change_zipcode($username,$new_zipcode)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set zip_code='".$new_zipcode."' where ID='".$username."'");
return $sql;
}

function change_phone_number($username,$new_phone_number)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set phone_number='".$new_phone_number."' where ID='".$username."'");
return $sql;
}

function account_characters($username)
{
$user_num = mssql_query("select UserNum from ".DB_LOGIN.".[dbo].cabal_auth_table where ID='".$username."'");
$user_num_result = mssql_fetch_array($user_num);
$characters = mssql_query("select CharacterIdx,Name,LEV,EXP,STR,DEX,INT,PNT,Rank,Alz,WorldIdx,Position,Style,HP,MP,SwdPNT,MagPNT,SP,PenaltyEXP,LogoutTime,Reputation,LoginTime,PlayTime,ChannelIdx,Nation,ReputationClass,convert(varchar(20), CreateDate, 120),Login, PKPenalty, Resets from ".DB_WORLD.".[dbo].cabal_character_table where CharacterIdx/8='".$user_num_result[0]."'");
return $characters;
}

function get_characters($username)
{
$characters = mssql_query("select * from ".DB_WORLD.".[dbo].cabal_character_table where Name='".$username."'");
$characters_result = mssql_fetch_array($characters);
return $characters_result;
}

function account_total_alz($username)
{
$user_num = mssql_query("select UserNum from ".DB_LOGIN.".[dbo].cabal_auth_table where ID='".$username."'");
$user_num_result = mssql_fetch_array($user_num);
$account_total_alz = mssql_query("select SUM(Alz) from ".DB_WORLD.".[dbo].cabal_character_table where CharacterIdx/8='".$user_num_result[0]."'");
$account_total_alz_result = mssql_fetch_array($account_total_alz);
return $account_total_alz_result;
}

function account_total_honor($username)
{
$user_num = mssql_query("select UserNum from ".DB_LOGIN.".[dbo].cabal_auth_table where ID='".$username."'");
$user_num_result = mssql_fetch_array($user_num);
$account_total_alz = mssql_query("select SUM(Reputation) from ".DB_WORLD.".[dbo].cabal_character_table where CharacterIdx/8='".$user_num_result[0]."'");
$account_total_alz_result = mssql_fetch_array($account_total_alz);
return $account_total_alz_result;
}

function check_characters($username)
{
$user_num = mssql_query("select UserNum from ".DB_LOGIN.".[dbo].cabal_auth_table where ID='".$username."'");
$user_num_result = mssql_fetch_array($user_num);
$check_characters = mssql_query("select count(*) from ".DB_WORLD.".[dbo].cabal_character_table where CharacterIdx/8='".$user_num_result[0]."'");
$check_characters_result = mssql_fetch_array($check_characters);
return $check_characters_result;
}

function usernum($username)
{
$user_num = mssql_query("select UserNum from ".DB_LOGIN.".[dbo].cabal_auth_table where ID='".$username."'");
$user_num_result = mssql_fetch_row($user_num);
return $user_num_result;
}

function exec_send_item($account_id, $tran_no, $server_idx, $item_idx, $item_opt, $duration_idx)
{
$send_item = mssql_query('exec '.DB_CABALCASH.'.dbo.up_AddMyCashItemByItem "'. $account_id .'","'. $tran_no .'","'. $server_idx .'","'. $item_idx . '","'. $item_opt . '","'. $duration_idx . '"');
return $send_item;
}

function search_account($search)
{
$search = mssql_query("select * from ".DB_LOGIN.".dbo.cabal_auth_table where ID LIKE '".$search."%'");
$search_result = mssql_num_rows($search);
return $search;
}

function account_informations($account_edit)
{
$acc_info = mssql_query("select * from ".DB_LOGIN.".dbo.cabal_auth_table where ID = '".$account_edit."'");
$acc_info_result = mssql_fetch_row($acc_info);
return $acc_info_result;
}

function account_edit($firstname,$lastname,$gender,$email,$address,$country,$city,$zip_code,
$phone_number,$secret_question,$secret_answer,$create_date,$login_time,$logout_time,
$login_counter,$login_website,$account)
{
$sql= mssql_query("update ".DB_LOGIN.".[dbo].[cabal_auth_table] set
firstname='".$firstname."', lastname='".$lastname."', gender='".$gender."',
email='".$email."', address='".$address."', country='".$country."',
city='".$city."', zip_code='".$zip_code."', phone_number='".$phone_number."',
secret_question='".$secret_question."', secret_answer='".$secret_answer."',
createDate='".$create_date."', LoginTime='".$login_time."',  LogoutTime='".$logout_time."',
AuthType='".$auth_type."', IP='".$ip."', LastIp='".$last_ip."',
LoginCounter='".$login_counter."', login_website='".$login_website."'
where ID = '".$account."'");
return $sql;
}

function search_character($account_edit)
{
$search = mssql_query("select Name from ".DB_WORLD.".[dbo].cabal_character_table where Name='".$account_edit."'");
return $search;
}

function capella()
{
$capella = mssql_query("select top 28 * from ".DB_WORLD.".dbo.cabal_character_table where  Nation = 1 order by Alz desc");
return $capella;
}

function procyon()
{
$procyon = mssql_query("select top 28 * from ".DB_WORLD.".dbo.cabal_character_table where  Nation = 2 order by Alz desc");
return $procyon;
}

function query_execute($query)
{
$query_execute = mssql_query('exec "'. $account_id .'"');
return $query_execute;
}

function accounts()
{
$accounts = mssql_query("select count (*) from ".DB_LOGIN.".dbo.cabal_auth_table");
$accounts_result = mssql_fetch_array($accounts);
return $accounts_result;
}

function characters_created()
{
$characters = mssql_query("select count (*) from ".DB_WORLD.".dbo.cabal_character_table");
$characters_result = mssql_fetch_array($characters);
return $characters_result;
}

function characters()
{
$characters = mssql_query("select top 20 *  from ".DB_WORLD.".dbo.cabal_character_table where Nation != 3 order by Resets desc, LEV desc, PlayTime desc");
return $characters;
}

function guilds_created()
{
$guilds = mssql_query("select count (*) from ".DB_WORLD.".dbo.Guild");
$guilds_result = mssql_fetch_array($guilds);
return $guilds_result;
}

function guilds()
{
$guilds = mssql_query("select top 10 *  from ".DB_WORLD.".dbo.Guild order by Level desc, Point desc");
return $guilds;
}

function forcecalibur_owner()
{
$forcecalibur_owner = mssql_query("select top 1 CharacterIdx from ".DB_WORLD.".[dbo].[cabal_Forcecalibur_Owner] order by RegDate desc");
$forcecalibur_owner_result = mssql_fetch_array($forcecalibur_owner);
return $forcecalibur_owner_result;
}

function forcecalibur_owner_name($forcecalibur_owner)
{
$forcecalibur_owner_name = mssql_query("select Name from ".DB_WORLD.".[dbo].[cabal_character_table] where CharacterIdx='".$forcecalibur_owner."'");
$forcecalibur_owner_name_result = mssql_fetch_array($forcecalibur_owner_name);
return $forcecalibur_owner_name_result;
}

function account_cash($username)
{
$account_cash = mssql_query("select * from ".CABALCASH.".[dbo].[CashAccount] where ID='".$username."'");
$account_cash_result = mssql_fetch_array($account_cash);
return $account_cash_result;
}

function account_cash_extra($username)
{
$account_cash_extra = mssql_query("select Cash,convert(varchar(20), UpdateDateTime, 120),votes,votepoints from ".CABALCASH.".[dbo].[CashAccount] where ID='".$username."'");
$account_cash_extra_result = mssql_fetch_array($account_cash_extra);
return $account_cash_extra_result;
}

function account_cash_by_usernum($usernum)
{
$account_cash_by_usernum = mssql_query("select * from ".CABALCASH.".[dbo].[CashAccount] where UserNum='".$usernum."'");
$account_cash_by_usernum_result = mssql_fetch_array($account_cash_by_usernum);
return $account_cash_by_usernum_result;
}

function my_cash_item($usernum)
{
$my_cash_item = mssql_query("select UserNum, ItemKindIdx, convert(varchar(20), RegDate, 120), convert(varchar(20), UseDate, 120), ReceiveSvrIdx from ".CABALCASH.".[dbo].[MyCashItem] where UserNum='".$usernum."' order by RegDate desc");
return $my_cash_item;
}

function count_my_cash_item($usernum)
{
$count_my_cash_item = mssql_query("select count(*) from ".CABALCASH.".[dbo].[MyCashItem] where UserNum='".$usernum."'");
$count_my_cash_item_result = mssql_fetch_array($count_my_cash_item);
return $count_my_cash_item_result;
}

function tmembers()
{
$r=mssql_query("select count (*) from ".DB_WORLD.".[dbo].[cabal_character_table] where Nation=1 or Nation=2");
$row = mssql_fetch_row($r);
$tmembers=$row[0];
return $tmembers;
}

function cratio()
{
$r=mssql_query("select count (*) from ".DB_WORLD.".[dbo].[cabal_character_table] where Nation=1");
$row = mssql_fetch_row($r);
return $row;
}

function capella_count()
{
$capella_count=mssql_query("select count (*) from ".DB_WORLD.".[dbo].[cabal_character_table] where Nation=1");
$capella_count_result = mssql_fetch_row($capella_count);
return $capella_count_result;
}

function pratio()
{
$r=mssql_query("select count (*) from ".DB_WORLD.".[dbo].[cabal_character_table] where Nation=2");
$row = mssql_fetch_row($r);
return $row;
}

function procyon_count()
{
$procyon_count=mssql_query("select count (*) from ".DB_WORLD.".[dbo].[cabal_character_table] where Nation=2");
$procyon_count_result = mssql_fetch_row($procyon_count);
return $procyon_count_result;
}

function neutral_count()
{
$neutral_count=mssql_query("select count (*) from ".DB_WORLD.".[dbo].[cabal_character_table] where Nation=0");
$neutral_count_result = mssql_fetch_row($neutral_count);
return $neutral_count_result;
}

function vote($username, $vote_id, $ip)
{
$vote = mssql_query("insert into ".DB_CABALCASH.".dbo.votes(accName, lastVoteDate, voteLink, ip) values('".$username."','".date('Y-m-d H:i:s',time()+21600)."', '".$vote_id."','".$ip."')");
return $vote;
}

function votepoints($username, $usernum, $votepoints)
{
$vote_points= mssql_query("insert into ".DB_CABALCASH.".dbo.CashAccount(ID,UserNum, votes,votepoints) values('".$username."','".$usernum."', 1, '".$votepoints."')");
return $vote_points;
}

function update_votepoints($username,$votepoints_sum)
{
$update_votepoints = mssql_query("UPDATE ".DB_CABALCASH.".[dbo].[CashAccount] SET votes = votes + 1, votepoints =  '".array_sum($votepoints_sum)."' where ID='".$username."'");
return $update_votepoints;
}

function check_vote($username, $vote_id)
{
$check_vote = mssql_query("SELECT accName, convert(varchar(20), lastVoteDate, 120), voteLink, ip FROM dbo.votes WHERE accName = '".$username."' AND voteLink = ".$vote_id."");
return $check_vote;
}

function update_cc_cvp($username, $cc_sum, $cvp)
{
$update_cc_cvp= mssql_query("UPDATE ".DB_CABALCASH.".[dbo].[CashAccount] SET Cash = '".array_sum($cc_sum)."', votepoints = '".$cvp."' where ID='".$username."'");
return $update_cc_cvp;
}

function transfer_pcoins_to_pdonate($username, $pcoins, $pdonate)
{
$transfer_pcoins_to_pdonate= mssql_query("UPDATE ".DB_CABALCASH.".[dbo].[CashAccount] SET Cash = Cash - '".$pcoins."', cdonate = cdonate + '".$pdonate."' where ID='".$username."'");
return $transfer_pcoins_to_pdonate;
}

function change_nation($character, $nation, $price)
{
$change_nation = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET Nation = '".$nation."', Alz = Alz - '".$price."' where Name='".$character."'");
return $change_nation;
}

function character_info_get($character)
{
$character_info_get = mssql_query("SELECT * FROM ".DB_WORLD.".dbo.cabal_character_table WHERE Name = '".$character."'");
$character_info_get_result =mssql_fetch_array($character_info_get);
return $character_info_get_result;
}

function change_stats($str, $int, $dex, $points_left, $character, $price)
{
$change_stats = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET STR = STR + '".$str."', INT = INT + '".$int."', DEX = DEX + '".$dex."', PNT = PNT - '".$points_left."',  Alz = Alz - '".$price."' where Name='".$character."'");
return $change_stats;
}

function reset_stats($points, $character, $price)
{
$reset_stats = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET STR = 0, INT = 0, DEX = 0, PNT = PNT + '".$points."', Alz = Alz - '".$price."' where Name='".$character."'");
return $reset_stats;
}

function reset_character_free_trial_plus_bonus($str, $int, $dex, $points, $character, $resets, $map)
{
$reset_character = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET LEV = 1, EXP = 0, STR = '".$str."', INT = '".$int."', DEX = '".$dex."', PNT = (PNT * 0) + ('".$resets * $points."' ), Resets = Resets + 1, WorldIdx = '".$map."', WarpBField = 7, MapsBField = 7 where Name='".$character."'");
return $reset_character;
}

function reset_character_expire_trial_plus_bonus($str, $int, $dex, $points, $price, $character, $resets, $map)
{
$reset_character = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET LEV = 1, EXP = 0, STR = '".$str."', INT = '".$int."', DEX = '".$dex."', PNT = (PNT * 0) + ('".$resets * $points."' ), Alz = Alz - '".$price."', Resets = Resets + 1, WorldIdx = '".$map."', WarpBField = 7, MapsBField = 7 where Name='".$character."'");
return $reset_character;
}

function reset_character_free_trial_no_bonus($str, $int, $dex, $character, $resets, $map)
{
$reset_character = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET LEV = 1, EXP = 0, STR = '".$str."', INT = '".$int."', DEX = '".$dex."', Resets = Resets + 1, WorldIdx = '".$map."', WarpBField = 7, MapsBField = 7 where Name='".$character."'");
return $reset_character;
}

function reset_character_expire_trial_no_bonus($str, $int, $dex, $price, $character, $resets, $map)
{
$reset_character = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET LEV = 1, EXP = 0, STR = '".$str."', INT = '".$int."', DEX = '".$dex."', Alz = Alz - '".$price."', Resets = Resets + 1, WorldIdx = '".$map."', WarpBField = 7, MapsBField = 7 where Name='".$character."'");
return $reset_character;
}

function reset_character_plus_bonus($str, $int, $dex, $points, $price, $character, $resets, $map)
{
$reset_character = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET LEV = 1, EXP = 0, STR = '".$str."', INT = '".$int."', DEX = '".$dex."', PNT = (PNT * 0) + ('".$resets * $points."' ), Alz = Alz - '".$price."', Resets = Resets + 1, WorldIdx = '".$map."', WarpBField = 7, MapsBField = 7 where Name='".$character."'");
return $reset_character;
}

function reset_character($str, $int, $dex, $price, $character, $resets, $map)
{
$reset_character = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET LEV = 1, EXP = 0, STR = '".$str."', INT = '".$int."', DEX = '".$dex."', Alz = Alz - '".$price."', Resets = Resets + 1, WorldIdx = '".$map."', WarpBField = 7, MapsBField = 7 where Name='".$character."'");
return $reset_character;
}

function warp_to($character, $world, $price)
{
$warp_to = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET WorldIdx = '".$world."', Alz = Alz - '".$price."' where Name='".$character."'");
return $warp_to;
}

function clear_pk($character, $price)
{
$clear_pk = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET PenaltyEXP = 0, PKPenalty = 0, Alz = Alz - '".$price."' where Name='".$character."'");
return $clear_pk;
}

function ban_unban_account($account, $authtype)
{
$ban_unban_account = mssql_query("UPDATE ".DB_LOGIN.".[dbo].[cabal_auth_table] SET AuthType = '".$authtype."', ban_reason = NULL, ban_duration = NULL, ban_advanced = 0 where ID='".$account."'");
return $ban_unban_account;
}

function update_cabalcash($account, $cash)
{
$update_cabalcash = mssql_query("UPDATE ".DB_CABALCASH.".[dbo].[CashAccount] SET Cash = Cash + '".$cash."' where ID='".$account."'");
return $update_cabalcash;
}

function insert_cabalcash($account, $cash)
{
$usernum = $this->usernum($account);
$insert_cash_account = mssql_query("insert into ".DB_CABALCASH.".[dbo].[CashAccount](ID, UserNum, Cash) values('".$account."', '".$usernum[0]."', '".$cash."')");
return $insert_cash_account;
}

function slider_get()
{
$slider_get = mssql_query("SELECT * FROM ".DB_WEBSITE.".[dbo].slider order by Date desc");
return $slider_get;
}

function slider_add($username, $imagepath, $desc)
{
$slider_add = mssql_query("insert into ".DB_WEBSITE.".[dbo].slider(Author, Date, ImagePath, Description) values('".$username."',getdate(), '".$imagepath."', '".$desc."')");
return $slider_add;
}

function donate($donate_type, $username, $pincode, $package)
{
$date = time();
$donate = mssql_query("insert into ".DB_WEBSITE.".[dbo].[donate](donate_type, username, pincode, package, status, date) values('".$donate_type."', '".$username."', '".$pincode."' ,'".$package."', 0, '".date('Y-m-d H:i:s', $date)."')");
return $donate;
}

function get_donate($username)
{
$get_donate = mssql_query("SELECT id, donate_type, username, pincode, package, status, convert(varchar(20), date, 120) FROM ".DB_WEBSITE.".[dbo].[donate] where username = '".$username."'");
$get_donate_result = mssql_fetch_row($get_donate);
return $get_donate_result;
}

function admin_donate_manager()
{
$get_donate = mssql_query("SELECT * FROM ".DB_WEBSITE.".[dbo].[donate] order by date desc");
return $get_donate;
}

function get_count_donate()
{
$get_count_donate = mssql_query("select count (*) from ".DB_WEBSITE.".[dbo].[donate]");
$get_count_donate_result = mssql_fetch_array($get_count_donate);
return $get_count_donate_result;
}

function admin_donate_manager_approve($id)
{
$admin_donate_manager_approve = mssql_query("UPDATE ".DB_WEBSITE.".[dbo].[donate] SET status = 1 where id='".$id."'");
return $admin_donate_manager_approve;
}

function channel_players($channel)
{
$channel_players = mssql_query("select count (*)*(2) from   ".DB_WORLD.".[dbo].[cabal_character_table]  where ChannelIdx='".$channel."' and Login=1");
$channel_players_result = mssql_fetch_array($channel_players);
return $channel_players_result;
}

function players_online()
{
$players_online = mssql_query("select count (*)*(2) from ".DB_WORLD.".[dbo].[cabal_character_table] where Login=1");
$players_online_result = mssql_fetch_array($players_online);
return $players_online_result;
}

function update_password($username, $password)
{
$update_password = mssql_query('exec '.DB_LOGIN.'.[dbo].[cabal_set_password] "'.$username.'" , "'.$password.'"');
return $update_password;
}

function webshop_items()
{
$webshop_items = mssql_query("SELECT * FROM ".DB_WEBSITE.".[dbo].[shop]");
$webshop_items_result = mssql_fetch_array($webshop_items);
return $webshop_items_result;
}

function webshop_items_category($category)
{
$webshop_items_category = mssql_query("SELECT * FROM ".DB_WEBSITE.".[dbo].[shop] where category = '".$category."'");
return $webshop_items_category;
}

function webshop_bank($username)
{
$webshop_bank = mssql_query("SELECT * FROM ".DB_WEBSITE.".[dbo].[shop_bank] where username = '".$username."'");
$webshop_bank_result = mssql_fetch_array($webshop_bank);
return $webshop_bank_result;
}

public static function insert_missing_users_tonewDB()
{
	$getUsers = mssql_query("SELECT * FROM ACCOUNT.dbo.cabal_auth_table");

	for($i=1;$i<=mssql_num_rows($getUsers);$i++) {

		$asData = mssql_fetch_object($getUsers);

		$verify = mssql_query("SELECT * FROM website.dbo.shop_bank where username = '". $asData->ID ."'");
		if (mssql_num_rows($verify) <= 0) {
			$new = mssql_query("INSERT INTO [website].[dbo].[shop_bank]
			(
			username,
			alz,
			honor,
			wexp
			)
			VALUES
			(
			'". $asData->ID ."',
			'0',
			'0',
			'0'
			)");
		}
		if ($new != FALSE)
		{
			echo $asData->ID . ' Inserted <br />';
		} else {
			echo 'Failed to insert' . $asData->ID . '<br />' ;
		}

	}

}

function check_username_webshop_bank($username)
{
$check_username_webshop_bank = mssql_query("SELECT username FROM ".DB_WEBSITE.".[dbo].[shop_bank] where username = '".$username."'");
return $check_username_webshop_bank;
}

function webshop_update_in_bank($username, $alz, $honor, $wexp)
{
$webshop_update_in_bank = mssql_query("UPDATE ".DB_WEBSITE.".[dbo].[shop_bank] SET alz = alz +  '".$alz."', honor = honor +  '".$honor."',  wexp = wexp +  '".$wexp."' where username = '".$username."'");
return $webshop_update_in_bank;
}

function webshop_insert_in_bank($username, $alz, $honor, $wexp)
{
$usernum = $this->usernum($username);
$webshop_insert_in_bank= mssql_query("insert into ".DB_WEBSITE.".dbo.[shop_bank] (username, alz, honor, wexp) values('".$username."', '".$alz."', '".$honor."','".$wexp."')");
return $webshop_insert_in_bank;
}

function webshop_get_price_alz($username,$alz)
{
$webshop_get_price_alz = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET Alz = Alz - '".$alz."' where Name = '".$username."'");
return $webshop_get_price_alz;
}

function webshop_get_price_honor($username,$honor)
{
$webshop_get_price_honor = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_character_table] SET Reputation = Reputation - '".$honor."' where Name = '".$username."'");
return $webshop_get_price_honor;
}

function webshop_get_price_wexp($char,$wexp)
{
$idx = $this->idx_by_char($char);
$webshop_get_price_wexp = mssql_query("UPDATE ".DB_WORLD.".[dbo].[cabal_WarExp_Table] SET WarExp = WarExp - '".$wexp."' where CharacterIdx = '".$idx[0]."'");
return $webshop_get_price_wexp;
}

function get_username_by_usernum($usernum)
{
$get_username_by_usernum = mssql_query("SELECT ID FROM ".DB_LOGIN.".[dbo].[cabal_auth_table] where UserNum = '".$usernum."'");
$get_username_by_usernum_result = mssql_fetch_array($get_username_by_usernum);
return $get_username_by_usernum_result;
}

function item_purchased($usernum, $tranno, $serveridx, $itemidx, $itemopt, $durationidx,  $id, $cabalcash, $alz, $honor, $cvp, $money, $wexp)
{
$item_purchased = mssql_query('exec '.DB_CABALCASH.'.dbo.hekate_webshop_purchase_item "'.$usernum.'" , "'.$tranno.'", "'.$serveridx.'", "'.$itemidx.'", "'.$itemopt.'", "'.$durationidx.'", "'.$id.'", "'.$cabalcash.'", "'.$alz.'", "'.$honor.'", "'.$cvp.'", "'.$money.'", "'.$wexp.'"');
return $item_purchased;
}

function item_purchased_gifted($usernum, $usernum2, $tranno, $serveridx, $itemidx, $itemopt, $durationidx,  $id, $cabalcash, $alz, $honor, $cvp, $money, $wexp)
{
$item_purchased_gifted = mssql_query('exec '.DB_CABALCASH.'.dbo.hekate_webshop_gift_item "'.$usernum.'", "'.$usernum2.'" , "'.$tranno.'", "'.$serveridx.'", "'.$itemidx.'", "'.$itemopt.'", "'.$durationidx.'", "'.$id.'", "'.$cabalcash.'", "'.$alz.'", "'.$honor.'", "'.$cvp.'", "'.$money.'", "'.$wexp.'"');
return $item_purchased_gifted;
}

function get_info_item($id)
{
$get_info_item = mssql_query("SELECT * FROM ".DB_WEBSITE.".[dbo].[shop] where id = '".$id."'");
$get_info_item_result = mssql_fetch_array($get_info_item);
return $get_info_item_result;
}

function webshop_manager_add_item($name, $description, $item_idx, $duration_idx, $item_optiom, $image, $cc, $alz, $honor, $votepoints, $cdonate, $category, $available, $wexp)
{
$webshop_manager_add_item= mssql_query("insert into ".DB_CABALCASH.".dbo.[ShopItems] (Name, Description, ItemIdx, DurationIdx, ItemOpt, Image, cash ,Alz, honor ,votepoints, money, Category, Available, wexp) values('".$name."', '".$description."', '".$item_idx."', '".$duration_idx."', '".$item_optiom."', '".$image."', '".$cc."', '".$alz."', '".$honor."', '".$votepoints."','".$cdonate."', '".$category."', '".$available."', '".$wexp."')");
return $webshop_manager_add_item;
}

function webshop_get_items_by_category($tab)
{
$webshop_get_items_by_category = mssql_query("select * from ".DB_WEBSITE.".dbo.shop where category='".$tab."'");
return $webshop_get_items_by_category;
}

function webshop_check_items($id)
{
$webshop_check_items = mssql_query("select * from ".DB_WEBSITE.".dbo.shop where id='".$id."'");
$webshop_check_items_result = mssql_fetch_array($webshop_check_items);
return $webshop_check_items_result;
}

function update_cdonate($account, $cdonate)
{
$update_cdonate = mssql_query("UPDATE ".DB_CABALCASH.".dbo.CashAccount SET cdonate = cdonate + '".$cdonate."' where ID = '".$account."'");
return $update_cdonate;
}

function check_account_cash($account)
{
$check_account_cash = mssql_query("select ID from ".DB_CABALCASH.".dbo.CashAccount where ID='".$account."'");
$check_account_cash_result = mssql_fetch_array($check_account_cash);
return $check_account_cash_result;
}

function add_secret_question_answer($account, $secret_question, $secret_answer)
{
$add_secret_question_answer = mssql_query("UPDATE ".DB_LOGIN.".dbo.cabal_auth_table SET secret_question = '".$secret_question."', secret_answer = '".$secret_answer."'  where ID = '".$account."'");
return $add_secret_question_answer;
}

function webshop_get_items_by_tab($tab)
{
$webshop_get_items_by_tab = mssql_query("select * from ".DB_CABALCASH.".dbo.ShopItems where Category = '".$tab."'");
return $webshop_get_items_by_tab;
}

function webshop_get_info_item_by_idx($idx)
{
$webshop_get_info_item_by_id = mssql_query("select * from ".DB_CABALCASH.".dbo.ShopItems where Id = '".$idx."'");
$webshop_get_info_item_by_id_result = mssql_fetch_array($webshop_get_info_item_by_id);
return $webshop_get_info_item_by_id_result;
}

function webshop_get_items_by_search($item)
{
$webshop_get_items_by_search = mssql_query("select * from ".DB_CABALCASH.".dbo.ShopItems where Name = '".$item."%'");
return $webshop_get_items_by_search;
}

function webshop_delete_item($id)
{
$webshop_delete_item = mssql_query("delete from ".DB_CABALCASH.".dbo.ShopItems where Id = '".$id."'");
return $webshop_delete_items;
}

function webshop_update_item($id, $name, $description, $itemidx, $durationidx, $itemopt, $image, $honour, $alz, $category, $available, $cash, $votepoints, $money, $wexp)
{
$webshop_update_item = mssql_query("UPDATE ".DB_CABALCASH.".dbo.ShopItems SET Name = '".$name."', Description = '".$description."', ItemIdx = '".$itemidx."', DurationIdx = '".$durationidx."', ItemOpt = '".$itemopt."', Image = '".$image."', honor = '".$honour."', Alz = '".$alz."', Category = '".$category."', Available = '".$available."', cash = '".$cash."', votepoints = '".$votepoints."', money = '".$money."', wexp = '".$wexp."'  where Id = '".$id."'");
return $webshop_update_item;
}

function webshop_search_item($item)
{
$webshop_search_item = mssql_query("select * from ".DB_CABALCASH.".dbo.ShopItems where Name LIKE '".$item."%'");
return $webshop_search_item;
}

function players_status()
{
$players_status = mssql_query("SELECT  * FROM ".DB_WORLD.".[dbo].[cabal_character_table] WHERE Login = 1 order by alz desc , Reputation desc , LEV desc");
return $players_status;
}

function ban_by_id($id, $reason, $duration)
{
$date = time() + $duration;
$ban = mssql_query("UPDATE ".DB_LOGIN.".dbo.cabal_auth_table SET AuthType = 2, ban_advanced = 1, ban_reason = '".$reason."', ban_duration = '".date('Y-m-d H:i:s', $date)."' where UserNum = '".$id."'");
return $ban;
}

function ban_by_name($name, $reason, $duration)
{
$date = time() + $duration;
$ban = mssql_query("UPDATE ".DB_LOGIN.".dbo.cabal_auth_table SET AuthType = 2, ban_advanced = 1,  ban_reason = '".$reason."', ban_duration = '".date('Y-m-d H:i:s', $date)."' where ID = '".$name."'");
return $ban;
}

function advanced_unban($username)
{
$advanced_unban = mssql_query("UPDATE ".DB_LOGIN.".[dbo].[cabal_auth_table] SET Authtype = 1, ban_reason = NULL, ban_duration = NULL, ban_advanced = 0 WHERE ID = '".$username."'");
return $advanced_unban;
}

function accounts_ban_list()
{
$accounts_ban_list = mssql_query("select UserNum, ID, ban_reason, ban_duration, ban_advanced, convert(varchar(20), ban_duration, 120) from ".DB_LOGIN.".dbo.cabal_auth_table where AuthType = 2");
return $accounts_ban_list;
}

function unrecieved_ingame_items($username)
{
$usernum = $this->usernum($username);
$unrecieved_ingame_items = mssql_query("select ItemKindIdx, convert(varchar(20), RegDate, 120), convert(varchar(20), UseDate, 120), ReceiveSvrIdx, gift, gift_sended_from from  ".DB_CABALCASH.".[dbo].[MyCashItem] where UserNum = '".$usernum[0]."' AND UseDate IS NULL AND ReceiveSvrIdx = 0 order by RegDate desc");
return $unrecieved_ingame_items;
}

function webshop_get_info_by_item($item)
{
$webshop_get_info_by_item = mssql_query("select * from ".DB_CABALCASH.".dbo.ShopItems where ItemIdx = '".$item."'");
$webshop_get_info_by_item_result = mssql_fetch_array($webshop_get_info_by_item);
return $webshop_get_info_by_item_result;
}

function item_gifted($usernum, $from)
{
$item_gifted = mssql_query("UPDATE ".DB_CABALCASH.".dbo.MyCashItem SET gift = 1, gift_sended_from = '".$from."'  where UserNum = '".$usernum."'");
return $item_gifted;
}

function count_gifted_items($usernum)
{
$count_gifted_items = mssql_query("select count (*) from ".DB_CABALCASH.".dbo.MyCashItem where gift = 1 AND IsUse = 0 AND ReceiveSvrIdx = 0 AND UserNum = '".$usernum."'");
$count_gifted_items_result = mssql_fetch_array($count_gifted_items);
return $count_gifted_items_result;
}

function advanced_vote_check($ip)
{
$advanced_vote_check = mssql_query("select accName from ".DB_CABALCASH.".dbo.votes where ip = '".$ip."'");
$advanced_vote_check_result = mssql_fetch_array($advanced_vote_check);
return $advanced_vote_check_result;
}

function account_exist($account)
{
$account_exist = mssql_query("select ID from ".DB_LOGIN.".dbo.cabal_auth_table where ID = '".$account."'");
return $account_exist;
}

function account_tpoints($username)
{
$usernum = $this->usernum($username);
$account_tpoints = mssql_query("select * from ".DB_NETCAFE.".[dbo].[Point] where UserNum = '".$usernum[0]."'");
$account_tpoints_result = mssql_fetch_array($account_tpoints);
return $account_tpoints_result;
}

function update_tpoint($username, $tpoint)
{
$usernum = $this->usernum($username);
$update_tpoint = mssql_query("UPDATE ".DB_NETCAFE.".[dbo].[Point] SET TPoint = TPoint + '".$tpoint."' where UserNum = '".$usernum[0]."'");
return $update_tpoint;
}

function check_username_tpoint($username)
{
$check_username_tpoint = mssql_query("select UserNUm from ".DB_NETCAFE.".[dbo].[Point] where UserNum = '".$username."'");
return $check_username_tpoint;
}

function char_by_idx($idx)
{
$char_by_idx = mssql_query("select Name from ".DB_WORLD.".[dbo].[cabal_character_table] where CharacterIdx = '".$idx."'");
$char_by_idx_result = mssql_fetch_array($char_by_idx);
return $char_by_idx_result;
}

function idx_by_char($char)
{
$idx_by_char = mssql_query("select CharacterIdx from ".DB_WORLD.".[dbo].[cabal_character_table] where Name = '".$char."'");
$idx_by_char_result = mssql_fetch_array($idx_by_char);
return $idx_by_char_result;
}

function hack_user_log()
{
$hack_user_log = mssql_query("select * from ".DB_LOGIN.".[dbo].[cabal_hackuser_list] where hackType = 1 order by registerDate");
return $hack_user_log;
}

function hack_user_log_count($usernum)
{
$hack_user_log_count = mssql_query("select count(*) from ".DB_LOGIN.".[dbo].[cabal_hackuser_list] where hackType = 1 AND userNum='".$usernum."'");
$hack_user_log_count_result = mssql_fetch_array($hack_user_log_count);
return $hack_user_log_count_result;
}

function get_wexp($idx)
{
$get_wexp = mssql_query("select * from ".DB_WORLD.".[dbo].[cabal_WarExp_Table] where CharacterIdx = '".$idx."'");
$get_wexp_result = mssql_fetch_array($get_wexp);
return $get_wexp_result;
}

}
?>