<?php
include_once("security.php");
include ("config.php");
include ("config/config_class.php");
include ("function.php");
$action = $_GET['action'];
$account = $_GET['account'];
$password = $_GET['password'];
$passtransfer = $_GET['passtransfer'];
if ($passtransfer == $transfercode) {
switch ($action) {
case 'login':
if ($type_acc == 1) kiemtra_kituso($account);
else kiemtra_kitudacbiet($account);
kiemtra_kitudacbiet($password);
kiemtra_acc($account);
kiemtra_pass($account,$password);
kiemtra_block_acc($account);
kiemtra_ranking($account);
kiemtra_GM($account);
//kiemtra_loggame($account);
echo "OK||$gm||$ranking";
break;
case 'view_char':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
echo "$row[0]||$row[1]||$row[2]||$row[3]||$row[4]";
break;
case 'view_acc':
kiemtra_acc($account);
$query = $db->Execute("SELECT mail_addr,tel__numb,fpas_ques,fpas_answ,vpoint FROM MEMB_INFO WHERE memb___id='$account'");
$row = $query->fetchrow();
echo "$row[0]||$row[1]||$row[2]||$row[3]||$row[4]";
break;
case 'view_info_char':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_info_char = $db->Execute("SELECT Class,cLevel,Strength,Dexterity,Vitality,Energy,Leadership,Resets,Relifes,LevelUpPoint,pointdutru,uythacoffline_stat,PointUyThac,SCFPCPoints FROM Character WHERE Name='$row[$i]'");
$info_char = $query_info_char->fetchrow();
$class[] = $info_char[0];
$level[] = $info_char[1];
$str[] = $info_char[2];
$dex[] = $info_char[3];
$vit[] = $info_char[4];
$ene[] = $info_char[5];
$com[] = $info_char[6];
$reset[] = $info_char[7];
$relife[] = $info_char[8];
$point[] = $info_char[9];
$point_dutru[] = $info_char[10];
$uythac[] = $info_char[11];
$point_uythac[] = $info_char[12];
$pcpoint[] = $info_char[13];
}
else { $class[] = 0; $level[] = 0; $str[] = 0; $dex[] = 0; $vit[] = 0; $ene[] = 0; $com[] = 0; $reset[] = 0; $relife[] = 0; $point[] = 0; $point_dutru[] = 0; $uythac[] = 0; $point_uythac[] = 0; $pcpoint[] = 0; }
}
echo "$row[0]|$class[0]|$level[0]|$str[0]|$dex[0]|$vit[0]|$ene[0]|$com[0]|$reset[0]|$relife[0]|$point[0]|$point_dutru[0]|$uythac[0]|$point_uythac[0]|$pcpoint[0]
||$row[1]|$class[1]|$level[1]|$str[1]|$dex[1]|$vit[1]|$ene[1]|$com[1]|$reset[1]|$relife[1]|$point[1]|$point_dutru[1]|$uythac[1]|$point_uythac[1]|$pcpoint[1]
||$row[2]|$class[2]|$level[2]|$str[2]|$dex[2]|$vit[2]|$ene[2]|$com[2]|$reset[2]|$relife[2]|$point[2]|$point_dutru[2]|$uythac[2]|$point_uythac[2]|$pcpoint[2]
||$row[3]|$class[3]|$level[3]|$str[3]|$dex[3]|$vit[3]|$ene[3]|$com[3]|$reset[3]|$relife[3]|$point[3]|$point_dutru[3]|$uythac[3]|$point_uythac[3]|$pcpoint[3]
||$row[4]|$class[4]|$level[4]|$str[4]|$dex[4]|$vit[4]|$ene[4]|$com[4]|$reset[4]|$relife[4]|$point[4]|$point_dutru[4]|$uythac[4]|$point_uythac[4]|$pcpoint[4]";
break;
case 'view_char':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
echo "$row[0]||$row[1]||$row[2]||$row[3]||$row[4]";
break;
case 'view_charrs':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_reset = $db->Execute("SELECT cLevel,Resets,NoResetInDay FROM Character WHERE Name='$row[$i]'");
$rs_reset = $query_reset->fetchrow();
$level[] = $rs_reset[0];
$reset[] = $rs_reset[1];
$resetinday[] = $rs_reset[2];
}
else { $reset[] = 0; $level[] = 0; $resetinday[] = 0; }
}
echo "$row[0]|$level[0]|$reset[0]|$resetinday[0]||$row[1]|$level[1]|$reset[1]|$resetinday[1]||$row[2]|$level[2]|$reset[2]|$resetinday[2]||$row[3]|$level[3]|$reset[3]|$resetinday[3]||$row[4]|$level[4]|$reset[4]|$resetinday[4]";
break;
case 'view_charaddpoint':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_point = $db->Execute("SELECT LevelUpPoint FROM Character WHERE Name='$row[$i]'");
$rs_point = $query_point->fetchrow();
$point[] = $rs_point[0];
}
else { $point[] = 0; }
}
echo "$row[0]|$point[0]||$row[1]|$point[1]||$row[2]|$point[2]||$row[3]|$point[3]||$row[4]|$point[4]";
break;
case 'view_charrutpoint':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_point = $db->Execute("SELECT pointdutru FROM Character WHERE Name='$row[$i]'");
$point = $query_point->fetchrow();
$point_dutru[] = $point[0];
}
else { $point_dutru[] = 0; }
}
echo "$row[0]|$point_dutru[0]||$row[1]|$point_dutru[1]||$row[2]|$point_dutru[2]||$row[3]|$point_dutru[3]||$row[4]|$point_dutru[4]";
break;
case 'view_combo':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_leveldk3 = $db->Execute("SELECT Clevel FROM Character WHERE Name='$row[$i]' AND (Class='$class_dw_3' OR Class='$class_dk_3' OR Class='$class_elf_3' OR Class='$class_sum_3' OR Class='$class_rf_3')");
$rs_leveldk3 = $query_leveldk3->fetchrow();
$leveldk3[] = $rs_leveldk3[0];
}
else { $leveldk3[] = 0; }
}
echo "$row[0]|$leveldk3[0]||$row[1]|$leveldk3[1]||$row[2]|$leveldk3[2]||$row[3]|$leveldk3[3]||$row[4]|$leveldk3[4]";
break;
case 'view_uythacoffline':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_uythacoff = $db->Execute("SELECT uythacoffline_stat,uythacoffline_time,PointUyThac FROM Character WHERE Name='$row[$i]'");
$uythacoff = $query_uythacoff->fetchrow();
$tinhtrang[] = $uythacoff[0];
if ( 0 < $uythacoff[1] ) {
$thoigian[] = floor( ( $timestamp - $uythacoff[1] ) / 60 );
}
else {
$thoigian[] = 0;
}
$diem[] = $uythacoff[2];
}
else { $tinhtrang[] = 0; $thoigian[] = 0; $diem[] = 0; }
}
echo "$row[0]|$tinhtrang[0]|$thoigian[0]|$diem[0]||$row[1]|$tinhtrang[1]|$thoigian[1]|$diem[1]||$row[2]|$tinhtrang[2]|$thoigian[2]|$diem[2]||$row[3]|$tinhtrang[3]|$thoigian[3]|$diem[3]||$row[4]|$tinhtrang[4]|$thoigian[4]|$diem[4]";
break;
case 'view_charrs_uythac':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_reset = $db->Execute("SELECT PointUyThac,Resets FROM Character WHERE Name='$row[$i]'");
$rs_reset = $query_reset->fetchrow();
$pointuythac[] = $rs_reset[0];
$reset[] = $rs_reset[1];
}
else { $reset[] = 0; $pointuythac[] = 0; }
}
echo "$row[0]|$pointuythac[0]|$reset[0]||$row[1]|$pointuythac[1]|$reset[1]||$row[2]|$pointuythac[2]|$reset[2]||$row[3]|$pointuythac[3]|$reset[3]||$row[4]|$pointuythac[4]|$reset[4]";
break;
case 'view_bank':
kiemtra_acc($account);
$query = "SELECT bank,vpoint,jewel_chao,jewel_cre,jewel_blue FROM MEMB_INFO WHERE memb___id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
$zen = $row[0];
$vpoint = $row[1];
$chao = $row[2];
$cre = $row[3];
$blue = $row[4];
echo "$zen||$vpoint||$chao||$cre||$blue";
break;
case 'view_pcpoint2vpoint':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_pcpoint = $db->Execute("SELECT SCFPCPoints FROM Character WHERE Name='$row[$i]'");
$pcpoint = $query_pcpoint->fetchrow();
$point[] = $pcpoint[0];
}
else { $point[] = 0; }
}
echo "$row[0]|$point[0]||$row[1]|$point[1]||$row[2]|$point[2]||$row[3]|$point[3]||$row[4]|$point[4]";
break;
case 'view_zen2bank':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_zen = $db->Execute("SELECT Money FROM Character WHERE Name='$row[$i]'");
$zen = $query_zen->fetchrow();
$money[] = $zen[0];
}
else { $money[] = 0; }
}
echo "$row[0]|$money[0]||$row[1]|$money[1]||$row[2]|$money[2]||$row[3]|$money[3]||$row[4]|$money[4]";
break;
case 'view_charpk':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_PK = $db->Execute("SELECT PkLevel,PkCount FROM Character WHERE Name='$row[$i]'");
$rs_PK = $query_PK->fetchrow();
$PkLevel[] = $rs_PK[0];
$PkCount[] = $rs_PK[1];
}
else { $PkLevel[] = 0; $PkCount[] = 0; }
}
echo "$row[0]|$PkLevel[0]|$PkCount[0]||$row[1]|$PkLevel[1]|$PkCount[1]||$row[2]|$PkLevel[2]|$PkCount[2]||$row[3]|$PkLevel[3]|$PkCount[3]||$row[4]|$PkLevel[4]|$PkCount[4]";
break;
case 'view_charchangeclass':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_Class = $db->Execute("SELECT Class,Resets,cLevel FROM Character WHERE Name='$row[$i]'");
$rs_Class = $query_Class->fetchrow();
$Class[] = $rs_Class[0];
$Reset[] = $rs_Class[1];
$Level[] = $rs_Class[2];
}
else { $Class[] = 0; $Reset[] = 0; $Level[] = 0; }
}
echo "$row[0]|$Class[0]|$Reset[0]|$Level[0]||$row[1]|$Class[1]|$Reset[1]|$Level[1]||$row[2]|$Class[2]|$Reset[2]|$Level[2]||$row[3]|$Class[3]|$Reset[3]|$Level[3]||$row[4]|$Class[4]|$Reset[4]|$Level[4]";
break;
case 'view_charthuepoint':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_point = $db->Execute("SELECT IsThuePoint,TimeThuePoint,PointThue FROM Character WHERE Name='$row[$i]'");
$point = $query_point->fetchrow();
$point_status[] = $point[0];
$point_time[] = $point[1];
$point_thue[] = $point[2];
}
else { $point_status[] = 0; $point_time[] = 0; $point_thue[] = 0; }
}
echo "$row[0]|$point_status[0]|$point_time[0]|$point_thue[0]||$row[1]|$point_status[1]|$point_time[1]|$point_thue[1]||$row[2]|$point_status[2]|$point_time[2]|$point_thue[2]||$row[3]|$point_status[3]|$point_time[3]|$point_thue[3]||$row[4]|$point_status[4]|$point_time[4]|$point_thue[4]";
break;
case 'view_charrl':
$query = "select GameID1,GameID2,GameID3,GameID4,GameID5 from AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_reset = $db->Execute("SELECT cLevel,Resets,ReLifes FROM Character WHERE Name='$row[$i]'");
$rs_reset = $query_reset->fetchrow();
$level[] = $rs_reset[0];
$reset[] = $rs_reset[1];
$relife[] = $rs_reset[2];
}
else { $reset[] = 0; $level[] = 0; }
}
echo "$row[0]|$level[0]|$reset[0]|$relife[0]||$row[1]|$level[1]|$reset[1]|$relife[1]||$row[2]|$level[2]|$reset[2]|$relife[2]||$row[3]|$level[3]|$reset[3]|$relife[3]||$row[4]|$level[4]|$reset[4]|$relife[4]";
break;
case 'view_randomquest':
$query = "SELECT GameID1,GameID2,GameID3,GameID4,GameID5 FROM AccountCharacter WHERE Id='$account'";
$result = $db->Execute( $query );
$row = $result->fetchrow();
for ($i=0;$i<5;++$i) {
if ( !empty($row[$i]) ) {
$query_nhiemvu = $db->Execute("SELECT QuestReg,QuestType,QuestCount FROM Character WHERE Name='$row[$i]'");
$nhiemvu = $query_nhiemvu->fetchrow();
$tinhtrang[] = $nhiemvu[0];
$loai[] = $nhiemvu[1];
$soluong[] = $nhiemvu[2];
}
else { $tinhtrang[] = 0; $loai[] = 0; $soluong[] = 0; }
}
echo "$row[0]|$tinhtrang[0]|$loai[0]|$soluong[0]||$row[1]|$tinhtrang[1]|$loai[1]|$soluong[1]||$row[2]|$tinhtrang[2]|$loai[2]|$soluong[2]||$row[3]|$tinhtrang[3]|$loai[3]|$soluong[3]||$row[4]|$tinhtrang[4]|$loai[4]|$soluong[4]";
break;
case 'view_vpoint':
$query_vpoint = $db->Execute("SELECT vpoint FROM MEMB_INFO WHERE memb___id='$account'");
$check_vpoint = $query_vpoint->fetchrow();
echo $check_vpoint[0];
break;
case 'view_zen':
$query_zen = $db->Execute("SELECT bank FROM MEMB_INFO WHERE memb___id='$account'");
$check_zen = $query_zen->fetchrow();
echo $check_zen[0];
break;
case 'view_warehouse':
$warehouse_result_sql = $db->Execute("SELECT * FROM warehouse WHERE AccountID = '$account'");
$warehouse_result = $warehouse_result_sql->fetchrow();
$accountid = $warehouse_result[0];
$item = $item.$warehouse_result[1];
$item = bin2hex($item);
$item = strtoupper($item);
$item = substr($item, 0, 3840);
$money = $warehouse_result[2];
$password = $warehouse_result[5];
echo "$item||$money||$password";
break;
case 'view_infomu':
$query_total_acc = "SELECT Count(*) FROM MEMB_INFO";
$result_total_acc = $db->Execute($query_total_acc);
$total_acc = $result_total_acc->fetchrow();
$query_total_char = "SELECT Count(*) FROM Character";
$result_total_char = $db->Execute($query_total_char);
$total_char = $result_total_char->fetchrow();
$query_total_online = "SELECT * FROM MEMB_STAT WHERE ConnectStat='1'";
$result_total_online = $db->Execute($query_total_online);
$total_online = $result_total_online->numrows();
echo "$total_acc[0]||$total_char[0]||$total_online";
break;
}
} else echo "Error";
?>