function execAction($dir)
{
// delete files/dirs
if (($GLOBALS["permissions"] & 01) != 01) {
ext_Result::sendResult('delete', false, $GLOBALS["error_msg"]["accessfunc"]);
}
// CSRF Security Check
if (!ext_checkToken($GLOBALS['__POST']["token"])) {
ext_Result::sendResult('tokencheck', false, 'Request failed: Security Token not valid.');
}
$cnt = count($GLOBALS['__POST']["selitems"]);
$err = false;
// delete files & check for errors
for ($i = 0; $i < $cnt; ++$i) {
$items[$i] = basename(stripslashes($GLOBALS['__POST']["selitems"][$i]));
if (ext_isFTPMode()) {
$abs = get_item_info($dir, $items[$i]);
} else {
$abs = get_abs_item($dir, $items[$i]);
}
if (!@$GLOBALS['ext_File']->file_exists($abs)) {
$error[$i] = $GLOBALS["error_msg"]["itemexist"];
$err = true;
continue;
}
if (!get_show_item($dir, $items[$i])) {
$error[$i] = $GLOBALS["error_msg"]["accessitem"];
$err = true;
continue;
}
// Delete
if (ext_isFTPMode()) {
$abs = str_replace('\\', '/', get_abs_item($dir, $abs));
}
$ok = $GLOBALS['ext_File']->remove($abs);
if ($ok === false || PEAR::isError($ok)) {
$error[$i] = $GLOBALS["error_msg"]["delitem"];
if (PEAR::isError($ok)) {
$error[$i] .= ' [' . $ok->getMessage() . ']';
}
$err = true;
continue;
}
$error[$i] = NULL;
}
if ($err) {
// there were errors
$err_msg = "";
for ($i = 0; $i < $cnt; ++$i) {
if ($error[$i] == NULL) {
continue;
}
$err_msg .= $items[$i] . " : " . $error[$i] . ".\n";
}
ext_Result::sendResult('delete', false, $err_msg);
}
ext_Result::sendResult('delete', true, $GLOBALS['messages']['success_delete_file']);
}
function del_items($dir)
{
$mainframe =& JFactory::getApplication();
// delete files/dirs
if (($GLOBALS["permissions"] & 01) != 01) {
show_error($GLOBALS["error_msg"]["accessfunc"]);
}
$cnt = count($GLOBALS['__POST']["selitems"]);
$err = false;
// delete files & check for errors
for ($i = 0; $i < $cnt; ++$i) {
$items[$i] = stripslashes($GLOBALS['__POST']["selitems"][$i]);
if (nx_isFTPMode()) {
$abs = get_item_info($dir, $items[$i]);
} else {
$abs = get_abs_item($dir, $items[$i]);
}
if (!@$GLOBALS['nx_File']->file_exists($abs)) {
$error[$i] = $GLOBALS["error_msg"]["itemexist"];
$err = true;
continue;
}
if (!get_show_item($dir, $items[$i])) {
$error[$i] = $GLOBALS["error_msg"]["accessitem"];
$err = true;
continue;
}
// Delete
if (nx_isFTPMode()) {
$abs = get_abs_item($dir, $abs);
}
$ok = $GLOBALS['nx_File']->remove($abs);
if ($ok === false || PEAR::isError($ok)) {
$error[$i] = $GLOBALS["error_msg"]["delitem"];
if (PEAR::isError($ok)) {
$error[$i] .= ' [' . $ok->getMessage() . ']';
}
$err = true;
continue;
}
$error[$i] = NULL;
}
if ($err) {
// there were errors
$err_msg = "";
for ($i = 0; $i < $cnt; ++$i) {
if ($error[$i] == NULL) {
continue;
}
$err_msg .= $items[$i] . " : " . $error[$i] . "<br/>\n";
}
show_error($err_msg);
}
$mainframe->redirect(make_link("list", $dir, null), $GLOBALS['messages']['success_delete_file']);
}
function rename_item($dir, $item)
{
// rename directory or file
$mainframe =& JFactory::getApplication();
if (($GLOBALS["permissions"] & 01) != 01) {
show_error($GLOBALS["error_msg"]["accessfunc"]);
}
if (isset($GLOBALS['__POST']["confirm"]) && $GLOBALS['__POST']["confirm"] == "true") {
$newitemname = $GLOBALS['__POST']["newitemname"];
$newitemname = trim(basename(stripslashes($newitemname)));
if ($newitemname == '') {
show_error($GLOBALS["error_msg"]["miscnoname"]);
}
if (!nx_isFTPMode()) {
$abs_old = get_abs_item($dir, $item);
$abs_new = get_abs_item($dir, $newitemname);
} else {
$abs_old = get_item_info($dir, $item);
$abs_new = get_item_info($dir, $newitemname);
}
if (@$GLOBALS['nx_File']->file_exists($abs_new)) {
show_error($newitemname . ": " . $GLOBALS["error_msg"]["itemdoesexist"]);
}
$perms_old = $GLOBALS['nx_File']->fileperms($abs_old);
$ok = $GLOBALS['nx_File']->rename(get_abs_item($dir, $item), get_abs_item($dir, $newitemname));
if (nx_isFTPMode()) {
$abs_new = get_item_info($dir, $newitemname);
}
$GLOBALS['nx_File']->chmod($abs_new, $perms_old);
if ($ok === false || PEAR::isError($ok)) {
show_error('Could not rename ' . $item . ' to ' . $newitemname);
}
$msg = sprintf($GLOBALS['messages']['success_rename_file'], $item, $newitemname);
$mainframe->redirect(make_link("list", $dir, null), $msg);
}
show_header($GLOBALS['messages']['rename_file']);
// Form
echo '<br /><form method="post" action="';
echo make_link("rename", $dir, $item) . "\">\n";
echo "<input type=\"hidden\" name=\"confirm\" value=\"true\" />\n";
echo "<input type=\"hidden\" name=\"item\" value=\"" . stripslashes($GLOBALS['__GET']["item"]) . "\" />\n";
// Submit / Cancel
echo "<table>\n<tr><tr><td colspan=\"2\">\n";
echo "<label for=\"newitemname\">" . $GLOBALS["messages"]["newname"] . ":</label> <input name=\"newitemname\" id=\"newitemname\" type=\"text\" size=\"60\" value=\"" . stripslashes($_GET['item']) . "\" /><br /><br /><br /></td></tr>\n";
echo "<tr><tr><td>\n<input type=\"submit\" value=\"" . $GLOBALS["messages"]["btnchange"];
echo "\"></td>\n<td><input type=\"button\" value=\"" . $GLOBALS["messages"]["btncancel"];
echo "\" onclick=\"javascript:location='" . make_link("list", $dir, NULL) . "';\">\n</td></tr></form></table><br />\n";
}
function recalculate_shopping_cart()
{
$shopping_cart = get_session("shopping_cart");
if (is_array($shopping_cart) && sizeof($shopping_cart) > 0) {
foreach ($shopping_cart as $cart_id => $item) {
get_item_info($item);
$shopping_cart[$cart_id] = $item;
}
set_session("shopping_cart", $shopping_cart);
}
}
function is_writable($file)
{
global $isWindows;
if (ext_isFTPMode()) {
if ($isWindows) {
return true;
}
if (!is_array($file)) {
$file = get_item_info(dirname($file), basename($file));
}
if (empty($file['rights'])) {
return true;
}
$perms = $file['rights'];
if ($_SESSION['ftp_login'] == $file['user']) {
// FTP user is owner of the file
return $perms[1] == 'w';
}
$fileinfo = posix_getpwnam($file['user']);
$userinfo = posix_getpwnam($_SESSION['ftp_login']);
if ($fileinfo['gid'] == $userinfo['gid']) {
return $perms[4] == 'w';
} else {
return $perms[7] == 'w';
}
} else {
return is_writable($file);
}
}
function chmod_item($dir, $item)
{
// change permissions
if (($GLOBALS["permissions"] & 01) != 01) {
show_error($GLOBALS["error_msg"]["accessfunc"]);
}
if (!empty($GLOBALS['__POST']["selitems"])) {
$cnt = count($GLOBALS['__POST']["selitems"]);
} else {
$GLOBALS['__POST']["selitems"][] = $item;
$cnt = 1;
}
if (!empty($GLOBALS['__POST']['do_recurse'])) {
$do_recurse = true;
} else {
$do_recurse = false;
}
// Execute
if (isset($GLOBALS['__POST']["confirm"]) && $GLOBALS['__POST']["confirm"] == "true") {
$bin = '';
for ($i = 0; $i < 3; $i++) {
for ($j = 0; $j < 3; $j++) {
$tmp = "r_" . $i . $j;
if (isset($GLOBALS['__POST'][$tmp]) && $GLOBALS['__POST'][$tmp] == "1") {
$bin .= '1';
} else {
$bin .= '0';
}
}
}
if ($bin == '0') {
// Changing permissions to "none" is not allowed
show_error($item . ": " . $GLOBALS["error_msg"]["permchange"]);
}
$old_bin = $bin;
for ($i = 0; $i < $cnt; ++$i) {
if (jx_isFTPMode()) {
$mode = decoct(bindec($bin));
} else {
$mode = bindec($bin);
}
$item = $GLOBALS['__POST']["selitems"][$i];
if (jx_isFTPMode()) {
$abs_item = get_item_info($dir, $item);
} else {
$abs_item = get_abs_item($dir, $item);
}
if (!$GLOBALS['jx_File']->file_exists($abs_item)) {
show_error($item . ": " . $GLOBALS["error_msg"]["fileexist"]);
}
if (!get_show_item($dir, $item)) {
show_error($item . ": " . $GLOBALS["error_msg"]["accessfile"]);
}
if ($do_recurse) {
$ok = $GLOBALS['jx_File']->chmodRecursive($abs_item, $mode);
} else {
if (get_is_dir($abs_item)) {
// when we chmod a directory we must care for the permissions
// to prevent that the directory becomes not readable (when the "execute bits" are removed)
$bin = substr_replace($bin, '1', 2, 1);
// set 1st x bit to 1
$bin = substr_replace($bin, '1', 5, 1);
// set 2nd x bit to 1
$bin = substr_replace($bin, '1', 8, 1);
// set 3rd x bit to 1
if (jx_isFTPMode()) {
$mode = decoct(bindec($bin));
} else {
$mode = bindec($bin);
}
}
$ok = @$GLOBALS['jx_File']->chmod($abs_item, $mode);
}
$bin = $old_bin;
}
if (!$ok || PEAR::isError($ok)) {
show_error($abs_item . ": " . $GLOBALS["error_msg"]["permchange"]);
}
header("Location: " . make_link("link", $dir, NULL));
return;
}
if (jx_isFTPMode()) {
$abs_item = get_item_info($dir, $GLOBALS['__POST']["selitems"][0]);
} else {
$abs_item = get_abs_item($dir, $GLOBALS['__POST']["selitems"][0]);
}
$mode = parse_file_perms(get_file_perms($abs_item));
if ($mode === false) {
show_error($GLOBALS['__POST']["selitems"][0] . ": " . $GLOBALS["error_msg"]["permread"]);
}
$pos = "rwx";
$text = "";
for ($i = 0; $i < $cnt; ++$i) {
$s_item = get_rel_item($dir, $GLOBALS['__POST']["selitems"][$i]);
if (strlen($s_item) > 50) {
$s_item = "..." . substr($s_item, -47);
}
$text .= ", " . $s_item;
}
show_header($GLOBALS["messages"]["actperms"]);
echo "<br/><br/><div style=\"max-height: 200px; max-width: 800px;overflow:auto;\">/" . $text . '</div>';
// Form
echo '<br /><form method="post" action="' . make_link("chmod", $dir, $item) . "\">\n\t<input type=\"hidden\" name=\"confirm\" value=\"true\" />";
if ($cnt > 1 || empty($GLOBALS['__GET']["item"])) {
for ($i = 0; $i < $cnt; ++$i) {
echo "<input type=\"hidden\" name=\"selitems[]\" value=\"" . stripslashes($GLOBALS['__POST']["selitems"][$i]) . "\" />\n";
}
} else {
echo "<input type=\"hidden\" name=\"item\" value=\"" . stripslashes($GLOBALS['__GET']["item"]) . "\" />\n";
}
echo "\n\t<table class=\"adminform\" style=\"width:175px;\">\n";
// print table with current perms & checkboxes to change
for ($i = 0; $i < 3; ++$i) {
echo "<tr><td>" . $GLOBALS["messages"]["miscchmod"][$i] . "</td>";
for ($j = 0; $j < 3; ++$j) {
echo "<td><label for=\"r_" . $i . $j . "\"\">" . $pos[$j] . " </label><input type=\"checkbox\"";
if ($mode[3 * $i + $j] != "-") {
echo " checked=\"checked\"";
}
echo " name=\"r_" . $i . $j . "\" id=\"r_" . $i . $j . "\" value=\"1\" /></td>";
}
echo "</tr>\n";
}
// Submit / Cancel
echo "</table>\n<br/>";
echo "<table>\n<tr><tr><td colspan=\"2\">\n<input name=\"do_recurse\" id=\"do_recurse\" type=\"checkbox\" value=\"1\" /><label for=\"do_recurse\">" . $GLOBALS["messages"]["recurse_subdirs"] . "</label></td></tr>\n";
echo "<tr><tr><td>\n<input type=\"submit\" value=\"" . $GLOBALS["messages"]["btnchange"];
echo "\"></td>\n<td><input type=\"button\" value=\"" . $GLOBALS["messages"]["btncancel"];
echo "\" onclick=\"javascript:location='" . make_link("list", $dir, NULL) . "';\">\n</td></tr></form></table><br />\n";
}
function execAction($dir, $item)
{
// change permissions
if (($GLOBALS["permissions"] & 01) != 01) {
ext_Result::sendResult('chmod', false, $GLOBALS["error_msg"]["accessfunc"]);
}
if (!empty($GLOBALS['__POST']["selitems"])) {
$cnt = count($GLOBALS['__POST']["selitems"]);
} else {
$GLOBALS['__POST']["selitems"][] = $item;
$cnt = 1;
}
if (!empty($GLOBALS['__POST']['do_recurse'])) {
$do_recurse = true;
} else {
$do_recurse = false;
}
// Execute
if (isset($GLOBALS['__POST']["confirm"]) && $GLOBALS['__POST']["confirm"] == "true") {
$bin = '';
for ($i = 0; $i < 3; $i++) {
for ($j = 0; $j < 3; $j++) {
$tmp = "r_" . $i . $j;
if (!empty($GLOBALS['__POST'][$tmp])) {
$bin .= '1';
} else {
$bin .= '0';
}
}
}
if ($bin == '0') {
// Changing permissions to "none" is not allowed
ext_Result::sendResult('chmod', false, $item . ": " . ext_Lang::err('chmod_none_not_allowed'));
}
$old_bin = $bin;
for ($i = 0; $i < $cnt; ++$i) {
if (ext_isFTPMode()) {
$mode = decoct(bindec($bin));
} else {
$mode = bindec($bin);
}
$item = $GLOBALS['__POST']["selitems"][$i];
if (ext_isFTPMode()) {
$abs_item = get_item_info($dir, $item);
} else {
$abs_item = get_abs_item($dir, $item);
}
if (!$GLOBALS['ext_File']->file_exists($abs_item)) {
ext_Result::sendResult('chmod', false, $item . ": " . $GLOBALS["error_msg"]["fileexist"]);
}
if (!get_show_item($dir, $item)) {
ext_Result::sendResult('chmod', false, $item . ": " . $GLOBALS["error_msg"]["accessfile"]);
}
if ($do_recurse) {
$ok = $GLOBALS['ext_File']->chmodRecursive($abs_item, $mode);
} else {
if (get_is_dir($abs_item)) {
// when we chmod a directory we must care for the permissions
// to prevent that the directory becomes not readable (when the "execute bits" are removed)
$bin = substr_replace($bin, '1', 2, 1);
// set 1st x bit to 1
$bin = substr_replace($bin, '1', 5, 1);
// set 2nd x bit to 1
$bin = substr_replace($bin, '1', 8, 1);
// set 3rd x bit to 1
if (ext_isFTPMode()) {
$mode = decoct(bindec($bin));
} else {
$mode = bindec($bin);
}
}
//ext_Result::sendResult('chmod', false, $GLOBALS['FTPCONNECTION']->pwd());
$ok = @$GLOBALS['ext_File']->chmod($abs_item, $mode);
}
$bin = $old_bin;
}
if ($ok === false || PEAR::isError($ok)) {
$msg = $item . ": " . $GLOBALS["error_msg"]["permchange"];
$msg .= PEAR::isError($ok) ? ' [' . $ok->getMessage() . ']' : '';
ext_Result::sendResult('chmod', false, $msg);
}
ext_Result::sendResult('chmod', true, ext_Lang::msg('permchange'));
return;
}
if (ext_isFTPMode()) {
$abs_item = get_item_info($dir, $GLOBALS['__POST']["selitems"][0]);
} else {
$abs_item = get_abs_item($dir, $GLOBALS['__POST']["selitems"][0]);
$abs_item = utf8_decode($abs_item);
}
$mode = parse_file_perms(get_file_perms($abs_item));
if ($mode === false) {
ext_Result::sendResult('chmod', false, $item . ": " . $GLOBALS["error_msg"]["permread"]);
}
$pos = "rwx";
$text = "";
for ($i = 0; $i < $cnt; ++$i) {
$s_item = get_rel_item($dir, $GLOBALS['__POST']["selitems"][$i]);
if (strlen($s_item) > 50) {
$s_item = "..." . substr($s_item, -47);
}
$text .= $s_item . ($i + 1 < $cnt ? ', ' : '');
}
?>
<div style="width:auto;">
<div class="x-box-tl"><div class="x-box-tr"><div class="x-box-tc"></div></div></div>
<div class="x-box-ml"><div class="x-box-mr"><div class="x-box-mc">
<h3 style="margin-bottom:5px;"><?php
echo ext_Lang::msg('actperms');
?>
</h3>
<?php
echo $text;
?>
<div id="adminForm">
</div>
</div></div></div>
<div class="x-box-bl"><div class="x-box-br"><div class="x-box-bc"></div></div></div>
</div>
<script type="text/javascript">
var form = new Ext.form.Form({
labelWidth: 125, // label settings here cascade unless overridden
url:'<?php
echo basename($GLOBALS['script_name']);
?>
'
});
<?php
// print table with current perms & checkboxes to change
for ($i = 0; $i < 3; ++$i) {
?>
form.column(
{width:70, style:'margin-left:10px', clear:true}
);
form.fieldset(
{legend:'<?php
echo ext_Lang::msg(array('miscchmod' => $i), true);
?>
', hideLabels:true},
<?php
for ($j = 0; $j < 3; ++$j) {
?>
new Ext.form.Checkbox({
boxLabel:'<?php
echo $pos[$j];
?>
',
<?php
if ($mode[3 * $i + $j] != "-") {
echo 'checked:true,';
}
?>
name:'<?php
echo "r_" . $i . $j;
?>
'
}) <?php
if ($j < 2) {
echo ',';
}
}
?>
);
form.end();
<?php
}
?>
form.column(
{width:400, style:'margin-left:10px', clear:true}
);
form.add(new Ext.form.Checkbox({
fieldLabel:'<?php
echo ext_Lang::msg('recurse_subdirs', true);
?>
',
name:'do_recurse'
}));
form.end();
form.addButton('<?php
echo ext_Lang::msg('btnsave', true);
?>
', function() {
statusBarMessage( '<?php
echo ext_Lang::msg('permissions_processing', true);
?>
', true );
form.submit({
//reset: true,
reset: false,
success: function(form, action) {
statusBarMessage( action.result.message, false, true );
datastore.reload();
dialog.hide();
dialog.destroy();
},
failure: function(form, action) {
statusBarMessage( action.result.error, false, false );
Ext.MessageBox.alert('<?php
echo ext_Lang::err('error', true);
?>
', action.result.error);
},
scope: form,
// add some vars to the request, similar to hidden fields
params: {option: 'com_extplorer',
action: 'chmod',
dir: '<?php
echo stripslashes($GLOBALS['__POST']["dir"]);
?>
',
'selitems[]': ['<?php
echo implode("','", $GLOBALS['__POST']["selitems"]);
?>
'],
confirm: 'true'}
});
});
form.addButton('<?php
echo ext_Lang::msg('btncancel', true);
?>
', function() { dialog.hide();dialog.destroy(); } );
form.render('adminForm');
</script>
<?php
}
/**
* File/Directory Copy & Move Functions
*/
function copy_move_items($dir)
{
// copy/move file/dir
$action = extGetParam($_REQUEST, 'action');
if (($GLOBALS["permissions"] & 01) != 01) {
ext_Result::sendResult($action, false, $GLOBALS["error_msg"]["accessfunc"]);
}
// Vars
$first = extGetParam($GLOBALS['__POST'], 'first');
if ($first == "y") {
$new_dir = $dir;
} else {
$new_dir = stripslashes($GLOBALS['__POST']["new_dir"]);
}
if ($new_dir == ".") {
$new_dir = "";
}
$cnt = count($GLOBALS['__POST']["selitems"]);
// DO COPY/MOVE
// ALL OK?
if (!@$GLOBALS['ext_File']->file_exists(get_abs_dir($new_dir))) {
ext_Result::sendResult($action, false, get_abs_dir($new_dir) . ": " . $GLOBALS["error_msg"]["targetexist"]);
}
if (!get_show_item($new_dir, "")) {
ext_Result::sendResult($action, false, $new_dir . ": " . $GLOBALS["error_msg"]["accesstarget"]);
}
if (!down_home(get_abs_dir($new_dir))) {
ext_Result::sendResult($action, false, $new_dir . ": " . $GLOBALS["error_msg"]["targetabovehome"]);
}
// copy / move files
$err = false;
for ($i = 0; $i < $cnt; ++$i) {
$tmp = basename(stripslashes($GLOBALS['__POST']["selitems"][$i]));
$new = basename(stripslashes($GLOBALS['__POST']["selitems"][$i]));
if (ext_isFTPMode()) {
$abs_item = get_item_info($dir, $tmp);
$abs_new_item = get_item_info('/' . $new_dir, $new);
} else {
$abs_item = get_abs_item($dir, $tmp);
$abs_new_item = get_abs_item($new_dir, $new);
}
$items[$i] = $tmp;
// Check
if ($new == "") {
$error[$i] = $GLOBALS["error_msg"]["miscnoname"];
$err = true;
continue;
}
if (!@$GLOBALS['ext_File']->file_exists($abs_item)) {
$error[$i] = $GLOBALS["error_msg"]["itemexist"];
$err = true;
continue;
}
if (!get_show_item($dir, $tmp)) {
$error[$i] = $GLOBALS["error_msg"]["accessitem"];
$err = true;
continue;
}
if (@$GLOBALS['ext_File']->file_exists($abs_new_item)) {
$error[$i] = $GLOBALS["error_msg"]["targetdoesexist"];
$err = true;
continue;
}
// Copy / Move
if ($action == "copy") {
if (@is_link($abs_item) || get_is_file($abs_item)) {
// check file-exists to avoid error with 0-size files (PHP 4.3.0)
if (ext_isFTPMode()) {
$abs_item = '/' . $dir . '/' . $abs_item['name'];
}
$ok = @$GLOBALS['ext_File']->copy($abs_item, $abs_new_item);
//||@file_exists($abs_new_item);
} elseif (@get_is_dir($abs_item)) {
$copy_dir = ext_isFTPMode() ? '/' . $dir . '/' . $abs_item['name'] . '/' : $abs_item;
if (ext_isFTPMode()) {
$abs_new_item .= '/';
}
$ok = $GLOBALS['ext_File']->copy_dir($copy_dir, $abs_new_item);
}
} else {
$ok = $GLOBALS['ext_File']->rename($abs_item, $abs_new_item);
}
if ($ok === false || PEAR::isError($ok)) {
$error[$i] = $action == "copy" ? $GLOBALS["error_msg"]["copyitem"] : $GLOBALS["error_msg"]["moveitem"];
if (PEAR::isError($ok)) {
$error[$i] .= ' [' . $ok->getMessage() . ']';
}
$err = true;
continue;
}
$error[$i] = NULL;
}
if ($err) {
// there were errors
$err_msg = "";
for ($i = 0; $i < $cnt; ++$i) {
if ($error[$i] == NULL) {
continue;
}
$err_msg .= $items[$i] . " : " . $error[$i] . "\n";
}
ext_Result::sendResult($action, false, $err_msg);
}
ext_Result::sendResult($action, true, 'The File(s)/Directory(s) were successfully ' . ($action == 'copy' ? 'copied' : 'moved') . '.');
}
</th>
<th>
<textarea name="tcomments" rows=1 cols=20 ></textarea>
<input type="image" height=35 width=35 src="imgs/add.png" />
</th>
</tr>
</form>
</thead>
<tbody>
<?php
$mysql_q = "\n\t\t\t\t\t\t\t\tSELECT p_trans_id, date, item_id, vendor_id, invoice_id, uprice, qty, comments, timestamp\n\t\t\t\t\t\t\t\tFROM purchase_transactions\n\t\t\t\t\t\t\t\tORDER BY p_trans_id DESC\n\t\t\t\t\t\t\t\t";
$query_res = $dbhi->query($mysql_q);
while ($row = $query_res->fetch_assoc()) {
$item_info = get_item_info($row['item_id'], $dbhi);
$row_style = 'style="color:#d00000"';
if (!empty($row['invoice_id'])) {
$inv_no = get_vendor_invoice($row['invoice_id'], $dbhi);
$invoice_html = "\t<a name='a_invid[]' href='javascript:;'>\n\t\t\t\t\t\t\t\t\t\t\t\t{$inv_no}\n\t\t\t\t\t\t\t\t\t\t\t\t<input type='hidden' name='val_invid[]' value='" . $row['invoice_id'] . "' />\n\t\t\t\t\t\t\t\t\t\t\t</a>";
} else {
$invoice_html = "N/A";
}
echo "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . $row['date'] . "</td>\n\n\t\t\t\t\t\t\t\t<td {$row_style}>\n\t\t\t\t\t\t\t\t\t<a href='transactions.php?iid=" . $row['item_id'] . "'>\n\t\t\t\t\t\t\t\t\t\t" . $item_info['name'] . "\n\t\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>\n\t\t\t\t\t\t\t\t\t<a href='vendors.php?vendorid=" . $row['vendor_id'] . "'>\n\t\t\t\t\t\t\t\t\t\t" . get_vendorname($row['vendor_id'], $dbhi) . "\n\t\t\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>{$invoice_html}</td>\n\t\t\t\t\t\t\t\t<td {$row_style} title='" . clean_num($row['uprice']) . "'>" . price2code(clean_num($row['uprice'])) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>" . clean_num($row['qty']) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style} title='" . clean_num($row['uprice'] * $row['qty']) . "'>" . price2code(clean_num($row['uprice'] * $row['qty'])) . "</td>\n\t\t\t\t\t\t\t\t<td {$row_style}>\n\t\t\t\t\t\t\t\t\t<pre style='display:inline;'>" . $row['comments'] . "</pre>\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
}
?>
</tbody>
</table>
</center>
function product_status($id)
{
if (!is_admin()) {
header("Location: ?mode=login");
} else {
global $connection;
$status = get_item_info($id)['status'];
$product_owner = get_item_info($id)['seller_ID'];
if ($status == 1) {
$sql = "UPDATE 10153316_item SET status='0' WHERE item_ID='" . sanitize_for_db($connection, $id) . "'";
$result = mysqli_query($connection, $sql);
return "Successfully suspended";
} else {
if ($status == 2) {
$sql = "UPDATE 10153316_item SET status='0' WHERE item_ID='" . sanitize_for_db($connection, $id) . "'";
$result = mysqli_query($connection, $sql);
$del_sell_requests = "UPDATE 10153316_request SET status='6' WHERE status='2' AND sellitem_ID IN (SELECT item_ID FROM 10153316_item WHERE seller_ID = '" . sanitize_for_db($connection, $product_owner) . "')";
$del_sell = mysqli_query($connection, $del_sell_requests);
$del_buy_requests = "UPDATE 10153316_request SET status='6' WHERE status='2' AND buyitem_ID IN (SELECT item_ID FROM 10153316_item WHERE seller_ID = '" . sanitize_for_db($connection, $product_owner) . "')";
$del_buy = mysqli_query($connection, $del_buy_requests);
return "Successfully suspended & deleted";
} else {
if ($status == 0) {
$sql = "UPDATE 10153316_item SET status='1' WHERE item_ID='" . sanitize_for_db($connection, $id) . "'";
$result = mysqli_query($connection, $sql);
return "Successfully un-suspended";
}
}
}
return "No changes!";
}
}
function execAction($dir, $item)
{
// rename directory or file
if (($GLOBALS["permissions"] & 01) != 01) {
ext_Result::sendResult('rename', false, $GLOBALS["error_msg"]["accessfunc"]);
}
if (isset($GLOBALS['__POST']["confirm"]) && $GLOBALS['__POST']["confirm"] == "true") {
$newitemname = $GLOBALS['__POST']["newitemname"];
$newitemname = trim(basename(stripslashes($newitemname)));
if ($newitemname == '') {
ext_Result::sendResult('rename', false, $GLOBALS["error_msg"]["miscnoname"]);
}
if (!ext_isFTPMode()) {
$abs_old = get_abs_item($dir, $item);
$abs_new = get_abs_item($dir, $newitemname);
} else {
$abs_old = get_item_info($dir, $item);
$abs_new = get_item_info($dir, $newitemname);
}
if (@$GLOBALS['ext_File']->file_exists($abs_new)) {
ext_Result::sendResult('rename', false, $newitemname . ": " . $GLOBALS["error_msg"]["itemdoesexist"]);
}
$perms_old = $GLOBALS['ext_File']->fileperms($abs_old);
$ok = $GLOBALS['ext_File']->rename(get_abs_item($dir, $item), get_abs_item($dir, $newitemname));
if (ext_isFTPMode()) {
$abs_new = get_item_info($dir, $newitemname);
}
$GLOBALS['ext_File']->chmod($abs_new, $perms_old);
if ($ok === false || PEAR::isError($ok)) {
ext_Result::sendResult('rename', false, 'Could not rename ' . $dir . '/' . $item . ' to ' . $newitemname);
}
$msg = sprintf($GLOBALS['messages']['success_rename_file'], $item, $newitemname);
ext_Result::sendResult('rename', true, $msg);
}
$is_dir = get_is_dir(ext_isFTPMode() ? get_item_info($dir, $item) : get_abs_item($dir, $item));
?>
<div style="width:auto;">
<div class="x-box-tl"><div class="x-box-tr"><div class="x-box-tc"></div></div></div>
<div class="x-box-ml"><div class="x-box-mr"><div class="x-box-mc">
<h3 style="margin-bottom:5px;"><?php
echo $GLOBALS['messages']['rename_file'];
?>
</h3>
<div id="adminForm">
</div>
</div></div></div>
<div class="x-box-bl"><div class="x-box-br"><div class="x-box-bc"></div></div></div>
</div>
<script type="text/javascript">
var simple = new Ext.form.Form({
labelWidth: 75, // label settings here cascade unless overridden
url:'<?php
echo basename($GLOBALS['script_name']);
?>
'
});
simple.add(
new Ext.form.TextField({
fieldLabel: '<?php
echo ext_Lang::msg('newname', true);
?>
',
name: 'newitemname',
value: '<?php
echo str_replace("'", "\\'", stripslashes($item));
?>
',
width:175,
allowBlank:false
})
);
simple.addButton('<?php
echo ext_Lang::msg('btnsave', true);
?>
', function() {
statusBarMessage( 'Please wait...', true );
simple.submit({
//reset: true,
reset: false,
success: function(form, action) {
<?php
if ($is_dir) {
?>
parentDir = dirTree.getSelectionModel().getSelectedNode().parentNode;
parentDir.reload();
parentDir.select();
<?php
} else {
?>
datastore.reload();
<?php
}
?>
statusBarMessage( action.result.message, false, true );
dialog.destroy();
},
failure: function(form, action) {
if( !action.result ) return;
Ext.MessageBox.alert('Error!', action.result.error);
statusBarMessage( action.result.error, false, false );
},
scope: simple,
// add some vars to the request, similar to hidden fields
params: {option: 'com_extplorer',
action: 'rename',
dir: '<?php
echo stripslashes($dir);
?>
',
item: '<?php
echo stripslashes($item);
?>
',
confirm: 'true'}
});
});
simple.addButton('<?php
echo ext_Lang::msg('btncancel', true);
?>
', function() { dialog.destroy(); } );
simple.render('adminForm');
</script>
<?php
}
<div class="product-content">
<?php
$item = get_item_info();
if (!empty($item['item_ID'])) {
global $connection;
$buyitem = mysqli_real_escape_string($connection, $item['item_ID']);
$change_status = "UPDATE 10153316_item SET views = views+1 WHERE item_ID = {$buyitem}";
$res = mysqli_query($connection, $change_status);
}
echo '<div class="container">
<div class="row">
<section class="content">
<div class="col-md-8 col-md-offset-2">
<div class="panel panel-default">
<div class="panel-body">
<div class="table-container">
<img style ="margin: auto" class="img-responsive" src="' . $item['thumbnail'] . '" alt="' . $item['name'] . '">
<div class="caption">
<h4>' . $item['name'] . '</h4>
<p>' . $item['description'] . '</p>
<p>Condition: ' . $item['cond'] . '</p>
<p>Quantity: ' . $item['quantity'] . ' ' . $item['unit'] . '</p>
</div>
</div>
</div>
</div>
</div>
</section>
</div>
</div>';
if (isset($_SESSION['username'])) {
</table>
<br>
<table cellspacing=0 id='invoice_p' >
<tr>
<th>#</th>
<th>Item</th>
<th>Unit</th>
<th>Qty</th>
<th>Total</th>
</tr>
<?php
$counter = 1;
$grand_total = 0;
foreach ($transaction_rows as $row_num => $row_value) {
$item_info = get_item_info($row_value['item_id'], $dbhi);
$row_total = $row_value['uprice'] * $row_value['qty'];
$grand_total = $grand_total + $row_total;
echo "\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t{$counter}\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td class='itembox'>\n\t\t\t\t\t\t\t\t\t(" . $row_value['item_id'] . ")\n\t\t\t\t\t\t\t\t\t" . $item_info['name'] . "\n\t\t\t\t\t\t";
if (!empty($row_value['comments'])) {
echo "\n\t\t\t\t\t\t\t\t\t<br />\n\t\t\t\t\t\t\t\t\t<span style='font-size:0.8em'>" . $row_value['comments'] . "</span>\n\t\t\t\t\t\t";
}
echo "\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t<td>" . clean_num($row_value['uprice']) . "</td>\n\t\t\t\t\t\t\t\t<td>" . clean_num($row_value['qty']) . "</td>\n\t\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t\t\t{$Currency} " . clean_num($row_total) . "\n\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t";
$counter = $counter + 1;
}
?>
</table>
<br>
<table id="invoice_p_foot" border="0">
<tr>
<?php
if (!isset($_GET['iid'])) {
die("_GET[iid] not found");
}
include_once 'config.php';
// MYSQL Connection and Database Selection
$dbhi = new mysqli($mysql_host, $mysql_user, $mysql_pass, $mysql_database);
if (mysqli_connect_errno()) {
die('Could not connect to mysql: ' . mysqli_connect_errno());
}
// ItemID from GET
$current_itemid = $_GET['iid'];
$current_iteminfo = get_item_info($current_itemid, $dbhi);
$current_itemname = $current_iteminfo['name'];
$current_itemsaleprice = $current_iteminfo['sale_price'];
$current_itemdetail = $current_iteminfo['detail'];
$current_stockinfo = get_stock_info($current_itemid, $dbhi);
$current_totalsale = $current_stockinfo['total_sale'];
$current_totalpurchase = $current_stockinfo['total_purchase'];
// If addform is posted, insert values in database
if (!empty($_POST['t_date_val']) && (!empty($_POST['tinvoiceno']) || $_POST['trans_t'] == 'Purchase') && $_POST['tuprice'] > 0 && $_POST['tqty'] > 0) {
echo 'hellooo';
if ($_POST['trans_t'] == 'Sale') {
$sql_q = "INSERT INTO sale_transactions\n\t\t\t\t\t\t\t\t( sale_trans_id, date, item_id, invoice_no, uprice, qty, amount_received, comments, timestamp )\n\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t'" . $_POST['t_date_val'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['iid'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tinvoiceno'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tuprice'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tqty'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tuprice'] * $_POST['tqty'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tcomments'] . "',\n\t\t\t\t\t\t\t\t'" . time() . "'\n\t\t\t\t\t\t\t\t);\n\t\t\t\t\t\t";
} elseif ($_POST['trans_t'] == 'Purchase') {
$sql_q = "INSERT INTO purchase_transactions\n\t\t\t\t\t\t\t\t( p_trans_id, date, item_id, vendor_id, invoice_id, uprice, qty, comments, timestamp )\n\t\t\t\t\t\tVALUES\t(\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t'" . $_POST['t_date_val'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['iid'] . "',\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t\t'" . $_POST['tuprice'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tqty'] . "',\n\t\t\t\t\t\t\t\t'" . $_POST['tcomments'] . "',\n\t\t\t\t\t\t\t\t'" . time() . "'\n\t\t\t\t\t\t\t\t);\n\t\t\t\t\t\t";
}
$dbhi->query($sql_q) or die($dbhi->error);
if ($dbhi->affected_rows == 1) {
header("Location: " . $_SERVER['PHP_SELF'] . "?iid=" . $_POST['iid'] . "&submit_success=yes&message=" . $_POST['trans_t'] . " Added");
function copy_move_items($dir)
{
// copy/move file/dir
if (($GLOBALS["permissions"] & 01) != 01) {
show_error($GLOBALS["error_msg"]["accessfunc"]);
}
$action = stripslashes(JRequest::getCmd('action'));
if ($action == "post") {
$action = JRequest::getCmd("do_action");
} elseif (empty($action)) {
$action = "list";
}
// Vars
$first = $GLOBALS['__POST']["first"];
if ($first == "y") {
$new_dir = $dir;
} else {
$new_dir = stripslashes($GLOBALS['__POST']["new_dir"]);
}
if ($new_dir == ".") {
$new_dir = "";
}
$cnt = count($GLOBALS['__POST']["selitems"]);
// Copy or Move?
if ($action != "move") {
$images = "images/__copy.gif";
} else {
$images = "images/__cut.gif";
}
// Get New Location & Names
if (!isset($GLOBALS['__POST']["confirm"]) || $GLOBALS['__POST']["confirm"] != "true") {
show_header($action != "move" ? $GLOBALS["messages"]["actcopyitems"] : $GLOBALS["messages"]["actmoveitems"]);
// JavaScript for Form:
// Select new target directory / execute action
?>
<script language="JavaScript1.2" type="text/javascript">
<!--
function NewDir(newdir) {
document.selform.new_dir.value = newdir;
document.selform.submit();
}
function Execute() {
document.selform.confirm.value = "true";
}
//-->
</script><?php
// "Copy / Move from .. to .."
$s_dir = $dir;
if (strlen($s_dir) > 40) {
$s_dir = "..." . substr($s_dir, -37);
}
$s_ndir = $new_dir;
if (strlen($s_ndir) > 40) {
$s_ndir = "..." . substr($s_ndir, -37);
}
echo "<br /><img src=\"" . _QUIXPLORER_URL . '/images/' . $images . "\" align=\"absmiddle\" alt=\"\" /> <strong>";
echo sprintf($action != "move" ? $GLOBALS["messages"]["actcopyfrom"] : $GLOBALS["messages"]["actmovefrom"], $s_dir, $s_ndir);
echo "</strong><img src=\"" . _QUIXPLORER_URL . "/images/__paste.gif\" align=\"absmiddle\" alt=\"\">\n";
// Form for Target Directory & New Names
echo "<br /><br /><form name=\"selform\" method=\"post\" action=\"";
echo make_link("post", $dir, NULL) . "\"><table style=\"width:500px;\" class=\"adminform\">\n";
echo "<input type=\"hidden\" name=\"do_action\" value=\"" . $action . "\">\n";
echo "<input type=\"hidden\" name=\"confirm\" value=\"false\">\n";
echo "<input type=\"hidden\" name=\"first\" value=\"n\">\n";
echo "<input type=\"hidden\" name=\"new_dir\" value=\"" . $new_dir . "\">\n";
// List Directories to select Target
dir_print(dir_list($new_dir), $new_dir);
echo "</table><br />\n\t\t<table style=\"width:500px;\" class=\"adminform\">\n";
// Print Text Inputs to change Names
for ($i = 0; $i < $cnt; ++$i) {
$selitem = stripslashes($GLOBALS['__POST']["selitems"][$i]);
if (isset($GLOBALS['__POST']["newitems"][$i])) {
$newitem = stripslashes($GLOBALS['__POST']["newitems"][$i]);
if ($first == "y") {
$newitem = $selitem;
}
} else {
$newitem = $selitem;
}
$s_item = $selitem;
if (strlen($s_item) > 50) {
$s_item = substr($s_item, 0, 47) . "...";
}
echo "<tr><td><img src=\"" . _QUIXPLORER_URL . "/images/information.png\" align=\"absmiddle\" alt=\"\">";
// old name
echo "<input type=\"hidden\" name=\"selitems[]\" value=\"";
echo $selitem . "\"> " . $s_item . " ";
// New Name
echo "</td><td><input type=\"text\" size=\"25\" name=\"newitems[]\" value=\"";
echo $newitem . "\"></td></tr>\n";
}
// Submit & Cancel
echo "</table><br /><table><tr>\n<td>";
echo "<input type=\"submit\" value=\"";
echo $action != "move" ? $GLOBALS["messages"]["btncopy"] : $GLOBALS["messages"]["btnmove"];
echo "\" onclick=\"javascript:Execute();\"></td>\n<td>";
echo "<input type=\"button\" value=\"" . $GLOBALS["messages"]["btncancel"];
echo "\" onclick=\"javascript:location='" . make_link("list", $dir, NULL);
echo "';\"></td>\n</tr></table><br /></form>\n";
return;
}
// DO COPY/MOVE
// ALL OK?
if (!@$GLOBALS['nx_File']->file_exists(get_abs_dir($new_dir))) {
show_error(get_abs_dir($new_dir) . ": " . $GLOBALS["error_msg"]["targetexist"]);
}
if (!get_show_item($new_dir, "")) {
show_error($new_dir . ": " . $GLOBALS["error_msg"]["accesstarget"]);
}
if (!down_home(get_abs_dir($new_dir))) {
show_error($new_dir . ": " . $GLOBALS["error_msg"]["targetabovehome"]);
}
// copy / move files
$err = false;
for ($i = 0; $i < $cnt; ++$i) {
$tmp = stripslashes($GLOBALS['__POST']["selitems"][$i]);
$new = basename(stripslashes($GLOBALS['__POST']["newitems"][$i]));
if (nx_isFTPMode()) {
$abs_item = get_item_info($dir, $tmp);
$abs_new_item = get_item_info('/' . $new_dir, $new);
} else {
$abs_item = get_abs_item($dir, $tmp);
$abs_new_item = get_abs_item($new_dir, $new);
}
$items[$i] = $tmp;
// Check
if ($new == "") {
$error[$i] = $GLOBALS["error_msg"]["miscnoname"];
$err = true;
continue;
}
if (!@$GLOBALS['nx_File']->file_exists($abs_item)) {
$error[$i] = $GLOBALS["error_msg"]["itemexist"];
$err = true;
continue;
}
if (!get_show_item($dir, $tmp)) {
$error[$i] = $GLOBALS["error_msg"]["accessitem"];
$err = true;
continue;
}
if (@$GLOBALS['nx_File']->file_exists($abs_new_item)) {
$error[$i] = $GLOBALS["error_msg"]["targetdoesexist"];
$err = true;
continue;
}
// Copy / Move
if ($action == "copy") {
if (@is_link($abs_item) || get_is_file($abs_item)) {
// check file-exists to avoid error with 0-size files (PHP 4.3.0)
if (nx_isFTPMode()) {
$abs_item = '/' . $dir . '/' . $abs_item['name'];
}
$ok = @$GLOBALS['nx_File']->copy($abs_item, $abs_new_item);
//||@file_exists($abs_new_item);
} elseif (@get_is_dir($abs_item)) {
$dir = nx_isFTPMode() ? '/' . $dir . '/' . $abs_item['name'] . '/' : $abs_item;
if (nx_isFTPMode()) {
$abs_new_item .= '/';
}
$ok = $GLOBALS['nx_File']->copy_dir($dir, $abs_new_item);
}
} else {
$ok = $GLOBALS['nx_File']->rename($abs_item, $abs_new_item);
}
if ($ok === false || PEAR::isError($ok)) {
$error[$i] = $action == "copy" ? $GLOBALS["error_msg"]["copyitem"] : $GLOBALS["error_msg"]["moveitem"];
if (PEAR::isError($ok)) {
$error[$i] .= ' [' . $ok->getMessage() . ']';
}
$err = true;
continue;
}
$error[$i] = NULL;
}
if ($err) {
// there were errors
$err_msg = "";
for ($i = 0; $i < $cnt; ++$i) {
if ($error[$i] == NULL) {
continue;
}
$err_msg .= $items[$i] . " : " . $error[$i] . "<br />\n";
}
show_error($err_msg);
}
header("Location: " . make_link("list", $dir, NULL));
}
function execAction($dir, $item)
{
// rename directory or file
if (($GLOBALS["permissions"] & 01) != 01) {
ext_Result::sendResult('rename', false, $GLOBALS["error_msg"]["accessfunc"]);
}
if (isset($GLOBALS['__POST']["confirm"]) && $GLOBALS['__POST']["confirm"] == "true") {
$newitemname = $GLOBALS['__POST']["newitemname"];
$newitemname = trim(basename(stripslashes($newitemname)));
if ($newitemname == '') {
ext_Result::sendResult('rename', false, $GLOBALS["error_msg"]["miscnoname"]);
}
if (!ext_isFTPMode()) {
$abs_old = get_abs_item($dir, $item);
$abs_new = get_abs_item($dir, $newitemname);
} else {
$abs_old = get_item_info($dir, $item);
$abs_new = get_item_info($dir, $newitemname);
}
if (@$GLOBALS['ext_File']->file_exists($abs_new)) {
ext_Result::sendResult('rename', false, ext_TextEncoding::toUTF8($newitemname) . ": " . $GLOBALS["error_msg"]["itemdoesexist"]);
}
$perms_old = $GLOBALS['ext_File']->fileperms($abs_old);
$ok = $GLOBALS['ext_File']->rename(get_abs_item($dir, $item), get_abs_item($dir, $newitemname));
if (ext_isFTPMode()) {
$abs_new = get_item_info($dir, $newitemname);
}
$GLOBALS['ext_File']->chmod($abs_new, $perms_old);
if ($ok === false || PEAR::isError($ok)) {
ext_Result::sendResult('rename', false, 'Could not rename ' . $dir . '/' . $item . ' to ' . $newitemname);
}
$msg = sprintf($GLOBALS['messages']['success_rename_file'], $item, $newitemname);
ext_Result::sendResult('rename', true, $msg);
}
$is_dir = get_is_dir(ext_isFTPMode() ? get_item_info($dir, $item) : get_abs_item($dir, $item));
?>
{
"xtype": "form",
"width": "350",
"height": "150",
"id": "simpleform",
"labelWidth": 125,
"url":"<?php
echo basename($GLOBALS['script_name']);
?>
",
"dialogtitle": "<?php
echo $GLOBALS['messages']['rename_file'];
?>
",
"frame": true,
"items": [{
"xtype": "textfield",
"fieldLabel": "<?php
echo ext_Lang::msg('newname', true);
?>
",
"name": "newitemname",
"id": "newitemname",
"value": "<?php
echo str_replace("'", "\\'", stripslashes($item));
?>
",
"width":175,
"allowBlank":false
}
],
"listeners": { "afterrender": {
fn: function( form ) {
form.findById("newitemname").focus(true);
}
}
},
"buttons": [{
"text": "<?php
echo ext_Lang::msg('btnsave', true);
?>
",
"handler": function() {
statusBarMessage( 'Please wait...', true );
form = Ext.getCmp("simpleform").getForm();
form.submit({
//reset: true,
reset: false,
success: function(form, action) {
<?php
if ($is_dir) {
?>
if( dirTree.getSelectionModel().getSelectedNode() ) {
parentDir = dirTree.getSelectionModel().getSelectedNode().parentNode;parentDir.reload();parentDir.select();
}
<?php
}
?>
datastore.reload();
statusBarMessage( action.result.message, false, true );
Ext.getCmp("dialog").destroy();
},
failure: function(form, action) {
if( !action.result ) return;
Ext.MessageBox.alert('Error!', action.result.error);
statusBarMessage( action.result.error, false, false );
},
scope: form,
// add some vars to the request, similar to hidden fields
params: {
option: 'com_extplorer',
action: 'rename',
dir: '<?php
echo stripslashes($dir);
?>
',
item: '<?php
echo stripslashes($item);
?>
',
confirm: 'true'
}
});
}
},{
"text": "<?php
echo ext_Lang::msg('btncancel', true);
?>
",
"handler": function() { Ext.getCmp("dialog").destroy(); }
}]
}
<?php
}
function get_is_dir($abs_item)
{
// is this a directory?
if (ext_isFTPMode() && is_array($abs_item)) {
return !empty($abs_item['is_dir']);
} elseif (ext_isFTPMode()) {
$info = get_item_info(dirname($abs_item), basename($abs_item));
return !empty($info['is_dir']);
}
return @is_dir($abs_item);
}
function char_main()
{
global $output, $realm_id, $logon_db, $characters_db, $world_db, $server, $corem_db, $site_encoding, $action_permission, $user_lvl, $user_name, $user_id, $locales_search_option, $base_datasite, $item_datasite, $spell_datasite, $showcountryflag, $timezone_offset, $sql, $core;
// this page uses wowhead tooltops
//wowhead_tt();
// we need at either an id or a name or we would have nothing to show
if (empty($_GET["id"])) {
if (empty($_GET["name"])) {
error(lang("global", "empty_fields"));
}
}
// this is multi realm support, as of writing still under development
// this page is already implementing it
if (empty($_GET["realm"])) {
$realmid = $realm_id;
} else {
$realmid = $sql["logon"]->quote_smart($_GET["realm"]);
if (is_numeric($realmid)) {
$sql["char"]->connect($characters_db[$realmid]["addr"], $characters_db[$realmid]["user"], $characters_db[$realmid]["pass"], $characters_db[$realmid]["name"], $characters_db[$realmid]["encoding"]);
} else {
$realmid = $realm_id;
}
}
if (empty($_GET["id"])) {
$name = $sql["char"]->quote_smart($_GET["name"]);
if ($core == 1) {
$result = $sql["char"]->query("SELECT guid, acct, race FROM characters WHERE name='" . $name . "' LIMIT 1");
} else {
$result = $sql["char"]->query("SELECT guid, id AS acct, race FROM characters WHERE name='" . $name . "' LIMIT 1");
}
$id_result = $sql["char"]->fetch_assoc($result);
$id = $id_result["guid"];
} else {
$id = $sql["char"]->quote_smart($_GET["id"]);
}
if (!is_numeric($id)) {
error(lang("global", "empty_fields"));
}
if ($core == 1) {
$result = $sql["char"]->query("SELECT acct, race FROM characters WHERE guid='" . $id . "' LIMIT 1");
} else {
$result = $sql["char"]->query("SELECT account AS acct, race FROM characters WHERE guid='" . $id . "' LIMIT 1");
}
if ($sql["char"]->num_rows($result)) {
//resrict by owner's gmlvl
$owner_acc_id = $sql["char"]->result($result, 0, "acct");
if ($core == 1) {
$query = $sql["logon"]->query("SELECT login FROM accounts WHERE acct='" . $owner_acc_id . "'");
} else {
$query = $sql["logon"]->query("SELECT username as login FROM account WHERE id='" . $owner_acc_id . "'");
}
$owner_name = $sql["logon"]->result($query, 0, "login");
$s_query = "SELECT *, SecurityLevel AS gm FROM config_accounts WHERE Login='******'";
$s_result = $sql["mgr"]->query($s_query);
$s_fields = $sql["mgr"]->fetch_assoc($s_result);
$owner_gmlvl = $s_fields["gm"];
$view_mod = $s_fields["View_Mod_Sheet"];
if ($owner_gmlvl >= 1073741824) {
$owner_gmlvl -= 1073741824;
}
// owner configured overrides
$view_override = false;
if ($view_mod > 0) {
if ($view_mod == 1) {
} elseif ($view_mod == 2) {
// only registered users may view this page
if ($user_lvl > -1) {
$view_override = true;
}
}
}
if ($user_lvl || $server[$realmid]["both_factions"]) {
$side_v = 0;
$side_p = 0;
} else {
$side_p = in_array($sql["char"]->result($result, 0, "race"), array(2, 5, 6, 8, 10)) ? 1 : 2;
if ($core == 1) {
$result_1 = $sql["char"]->query("SELECT race FROM characters WHERE acct='" . $user_id . "' LIMIT 1");
} else {
$result_1 = $sql["char"]->query("SELECT race FROM characters WHERE account='" . $user_id . "' LIMIT 1");
}
if ($sql["char"]->num_rows($result)) {
$side_v = in_array($sql["char"]->result($result_1, 0, "race"), array(2, 5, 6, 8, 10)) ? 1 : 2;
} else {
$side_v = 0;
}
unset($result_1);
}
if ($view_override || $user_lvl >= gmlevel($owner_gmlvl) && ($side_v === $side_p || !$side_v)) {
if ($core == 1) {
$result = $sql["char"]->query("SELECT guid, name, race, class, level, zoneid, mapid, online, gender,\n SUBSTRING_INDEX(SUBSTRING_INDEX(playedtime, ' ', 2), ' ', -1) AS totaltime,\n acct, data, timestamp, xp \n FROM characters WHERE guid='" . $id . "'");
} elseif ($core == 2) {
$result = $sql["char"]->query("SELECT guid, name, race, class, level, zone AS zoneid, map AS mapid, \n online, gender, totaltime, account AS acct, logout_time AS timestamp, health, \n\t\t\t\t\tpower1, power2, power3, power4, power5, power6, power7, xp,\n arenaPoints, totalHonorPoints, totalKills\n FROM characters WHERE guid='" . $id . "'");
} else {
$result = $sql["char"]->query("SELECT guid, name, race, class, level, zone AS zoneid, map AS mapid, \n online, gender, totaltime, account AS acct, logout_time AS timestamp, health, \n\t\t\t\t\tpower1, power2, power3, power4, power5, power6, power7, xp, arenaPoints, totalHonorPoints, totalKills\n FROM characters WHERE guid='" . $id . "'");
}
$char = $sql["char"]->fetch_assoc($result);
// find out what mode we're in View or Delete (0 = View, 1 = Delete)
$mode = isset($_GET["mode"]) ? $_GET["mode"] : 0;
// only the character's owner or a GM with Delete privs can enter Delete Mode
if ($owner_name != $user_name) {
if ($user_lvl < $action_permission["delete"]) {
$mode = 0;
} else {
$mode = $mode;
}
}
// View Mode is only availble on characters that are offline
if ($char["online"] != 0) {
$mode = 0;
}
if ($core == 1) {
$char_data = $char["data"];
if (empty($char_data)) {
$char_data = str_repeat("0;", PLAYER_END);
}
$char_data = explode(";", $char_data);
} else {
$query = "SELECT * FROM characters LEFT JOIN character_stats ON characters.guid=character_stats.guid WHERE characters.guid='" . $id . "'";
$char_data_result = $sql["char"]->query($query);
$char_data_fields = $sql["char"]->fetch_assoc($char_data_result);
$char_data[PLAYER_BLOCK_PERCENTAGE] = isset($char_data_fields["blockPct"]) ? $char_data_fields["blockPct"] : ' ';
$char_data[PLAYER_DODGE_PERCENTAGE] = isset($char_data_fields["dodgePct"]) ? $char_data_fields["dodgePct"] : ' ';
$char_data[PLAYER_PARRY_PERCENTAGE] = isset($char_data_fields["parryPct"]) ? $char_data_fields["parryPct"] : ' ';
$char_data[PLAYER_CRIT_PERCENTAGE] = isset($char_data_fields["critPct"]) ? $char_data_fields["critPct"] : ' ';
$char_data[PLAYER_RANGED_CRIT_PERCENTAGE] = isset($char_data_fields["rangedCritPct"]) ? $char_data_fields["rangedCritPct"] : ' ';
$char_data[UNIT_FIELD_MAXDAMAGE] = isset($char_data_fields["attackPower"]) ? $char_data_fields["attackPower"] : ' ';
$char_data[UNIT_FIELD_MINDAMAGE] = isset($char_data_fields["attackPower"]) ? $char_data_fields["attackPower"] : ' ';
$char_data[UNIT_FIELD_MAXRANGEDDAMAGE] = isset($char_data_fields["rangedAttackPower"]) ? $char_data_fields["rangedAttackPower"] : ' ';
$char_data[UNIT_FIELD_MINRANGEDDAMAGE] = isset($char_data_fields["rangedAttackPower"]) ? $char_data_fields["rangedAttackPower"] : ' ';
$char_data[PLAYER_SPELL_CRIT_PERCENTAGE1] = isset($char_data_fields["spellCritPct"]) ? $char_data_fields["spellCritPct"] : ' ';
$char_data[PLAYER_FIELD_MOD_DAMAGE_DONE_POS] = isset($char_data_fields["spellPower"]) ? $char_data_fields["spellPower"] : ' ';
$char_data[UNIT_FIELD_STAT0] = isset($char_data_fields["strength"]) ? $char_data_fields["strength"] : ' ';
$char_data[UNIT_FIELD_STAT1] = isset($char_data_fields["agility"]) ? $char_data_fields["agility"] : ' ';
$char_data[UNIT_FIELD_STAT2] = isset($char_data_fields["stamina"]) ? $char_data_fields["stamina"] : ' ';
$char_data[UNIT_FIELD_STAT3] = isset($char_data_fields["intellect"]) ? $char_data_fields["intellect"] : ' ';
$char_data[UNIT_FIELD_STAT4] = isset($char_data_fields["spirit"]) ? $char_data_fields["spirit"] : ' ';
$char_data[UNIT_FIELD_RESISTANCES] = isset($char_data_fields["armor"]) ? $char_data_fields["armor"] : ' ';
$char_data[UNIT_FIELD_RESISTANCES + 1] = isset($char_data_fields["resHoly"]) ? $char_data_fields["resHoly"] : ' ';
$char_data[UNIT_FIELD_RESISTANCES + 2] = isset($char_data_fields["resArcane"]) ? $char_data_fields["resArcane"] : ' ';
$char_data[UNIT_FIELD_RESISTANCES + 3] = isset($char_data_fields["resFire"]) ? $char_data_fields["resFire"] : ' ';
$char_data[UNIT_FIELD_RESISTANCES + 4] = isset($char_data_fields["resNature"]) ? $char_data_fields["resNature"] : ' ';
$char_data[UNIT_FIELD_RESISTANCES + 5] = isset($char_data_fields["resFrost"]) ? $char_data_fields["resFrost"] : ' ';
$char_data[UNIT_FIELD_RESISTANCES + 6] = isset($char_data_fields["resShadow"]) ? $char_data_fields["resShadow"] : ' ';
$char_data[UNIT_FIELD_HEALTH] = isset($char["health"]) ? $char["health"] : ' ';
$char_data[UNIT_FIELD_MAXHEALTH] = isset($char_data_fields["maxhealth"]) ? $char_data_fields["maxhealth"] : ' ';
$char_data[UNIT_FIELD_POWER1] = isset($char["power1"]) ? $char["power1"] : ' ';
$char_data[UNIT_FIELD_POWER2] = isset($char["power2"]) ? $char["power2"] : ' ';
$char_data[UNIT_FIELD_POWER3] = isset($char["power3"]) ? $char["power3"] : ' ';
$char_data[UNIT_FIELD_POWER4] = isset($char["power4"]) ? $char["power4"] : ' ';
$char_data[UNIT_FIELD_POWER5] = isset($char["power5"]) ? $char["power5"] : ' ';
$char_data[UNIT_FIELD_POWER6] = isset($char["power6"]) ? $char["power6"] : ' ';
$char_data[UNIT_FIELD_POWER7] = isset($char["power7"]) ? $char["power7"] : ' ';
$char_data[UNIT_FIELD_MAXPOWER1] = isset($char_data_fields["maxpower1"]) ? $char_data_fields["maxpower1"] : ' ';
$char_data[UNIT_FIELD_MAXPOWER2] = isset($char_data_fields["maxpower2"]) ? $char_data_fields["maxpower2"] : ' ';
$char_data[UNIT_FIELD_MAXPOWER3] = isset($char_data_fields["maxpower3"]) ? $char_data_fields["maxpower3"] : ' ';
$char_data[UNIT_FIELD_MAXPOWER4] = isset($char_data_fields["maxpower4"]) ? $char_data_fields["maxpower4"] : ' ';
$char_data[UNIT_FIELD_MAXPOWER5] = isset($char_data_fields["maxpower5"]) ? $char_data_fields["maxpower5"] : ' ';
$char_data[UNIT_FIELD_MAXPOWER6] = isset($char_data_fields["maxpower6"]) ? $char_data_fields["maxpower6"] : ' ';
$char_data[UNIT_FIELD_MAXPOWER7] = isset($char_data_fields["maxpower7"]) ? $char_data_fields["maxpower7"] : ' ';
$char_data[PLAYER_FIELD_MOD_HEALING_DONE_POS] = "ERR";
$char_data[PLAYER_FIELD_COMBAT_RATING_1 + 5] = "ERR";
$char_data[PLAYER_FIELD_COMBAT_RATING_1 + 17] = "ERR";
$char_data[PLAYER_FIELD_COMBAT_RATING_1 + 6] = "ERR";
$char_data[PLAYER_FIELD_COMBAT_RATING_1 + 7] = "ERR";
$char_data[PLAYER_EXPERTISE] = "ERR";
$char_data[PLAYER_OFFHAND_EXPERTISE] = "ERR";
$char_data[PLAYER_FIELD_HONOR_CURRENCY] = isset($char["totalHonorPoints"]) ? $char["totalHonorPoints"] : ' ';
$char_data[PLAYER_FIELD_ARENA_CURRENCY] = isset($char["arenaPoints"]) ? $char["arenaPoints"] : ' ';
$char_data[PLAYER_FIELD_LIFETIME_HONORBALE_KILLS] = isset($char["totalKills"]) ? $char["totalKills"] : ' ';
}
if ($core == 1) {
$guild_id = $sql["char"]->result($sql["char"]->query("SELECT guildid FROM guild_data WHERE playerid='" . $char["guid"] . "'"), 0);
$guild_rank = $sql["char"]->result($sql["char"]->query("SELECT guildRank FROM guild_data WHERE playerid='" . $char["guid"] . "'"), 0);
$guild_name = $sql["char"]->result($sql["char"]->query("SELECT guildName FROM guilds WHERE guildid='" . $guild_id . "'"));
} else {
$guild_id = $sql["char"]->result($sql["char"]->query("SELECT guildid FROM guild_member WHERE guid='" . $char["guid"] . "'"), 0);
$guild_rank = $sql["char"]->result($sql["char"]->query("SELECT rank AS guildRank FROM guild_member WHERE guid='" . $char["guid"] . "'"), 0);
$guild_name = $sql["char"]->result($sql["char"]->query("SELECT name AS guildName FROM guild WHERE guildid='" . $guild_id . "'"));
}
$online = $char["online"] ? lang("char", "online") : lang("char", "offline");
if ($guild_id) {
//$guild_name = $sql["char"]->result($sql["char"]->query('SELECT name FROM guild WHERE guildid ='.$char_data[CHAR_DATA_OFFSET_GUILD_ID].''), 0, 'name');
$guild_name = '<a href="guild.php?action=view_guild&realm=' . $realmid . '&error=3&id=' . $guild_id . '" >' . $guild_name . '</a>';
$mrank = $guild_rank;
if ($core == 1) {
$guild_rank = $sql["char"]->result($sql["char"]->query("SELECT rankname FROM guild_ranks WHERE guildid='" . $guild_id . "' AND rankId='" . $mrank . "'"), 0, "rankname");
} else {
$guild_rank = $sql["char"]->result($sql["char"]->query("SELECT rname AS rankname FROM guild_rank WHERE guildid='" . $guild_id . "' AND rid='" . $mrank . "'"), 0, "rankname");
}
} else {
$guild_name = lang("global", "none");
$guild_rank = lang("global", "none");
}
if ($core == 1) {
$block = unpack("f", pack("L", $char_data[PLAYER_BLOCK_PERCENTAGE]));
$block = round($block[1], 2);
$dodge = unpack("f", pack("L", $char_data[PLAYER_DODGE_PERCENTAGE]));
$dodge = round($dodge[1], 2);
$parry = unpack("f", pack("L", $char_data[PLAYER_PARRY_PERCENTAGE]));
$parry = round($parry[1], 2);
$crit = unpack("f", pack("L", $char_data[PLAYER_CRIT_PERCENTAGE]));
$crit = round($crit[1], 2);
$ranged_crit = unpack("f", pack("L", $char_data[PLAYER_RANGED_CRIT_PERCENTAGE]));
$ranged_crit = round($ranged_crit[1], 2);
$maxdamage = unpack("f", pack("L", $char_data[UNIT_FIELD_MAXDAMAGE]));
$maxdamage = round($maxdamage[1], 0);
$mindamage = unpack("f", pack("L", $char_data[UNIT_FIELD_MINDAMAGE]));
$mindamage = round($mindamage[1], 0);
$maxrangeddamage = unpack("f", pack("L", $char_data[UNIT_FIELD_MAXRANGEDDAMAGE]));
$maxrangeddamage = round($maxrangeddamage[1], 0);
$minrangeddamage = unpack("f", pack("L", $char_data[UNIT_FIELD_MINRANGEDDAMAGE]));
$minrangeddamage = round($minrangeddamage[1], 0);
} else {
$block = $char_data[PLAYER_BLOCK_PERCENTAGE];
$block = round($block, 2);
$dodge = $char_data[PLAYER_DODGE_PERCENTAGE];
$dodge = round($dodge, 2);
$parry = $char_data[PLAYER_PARRY_PERCENTAGE];
$parry = round($parry, 2);
$crit = $char_data[PLAYER_CRIT_PERCENTAGE];
$crit = round($crit, 2);
$ranged_crit = $char_data[PLAYER_RANGED_CRIT_PERCENTAGE];
$ranged_crit = round($ranged_crit, 2);
$maxdamage = $char_data[UNIT_FIELD_MAXDAMAGE];
$maxdamage = round($maxdamage, 0);
$mindamage = $char_data[UNIT_FIELD_MINDAMAGE];
$mindamage = round($mindamage, 0);
$maxrangeddamage = $char_data[UNIT_FIELD_MAXRANGEDDAMAGE];
$maxrangeddamage = round($maxrangeddamage, 0);
$minrangeddamage = $char_data[UNIT_FIELD_MINRANGEDDAMAGE];
$minrangeddamage = round($minrangeddamage, 0);
}
if ($core == 1) {
$spell_crit = 100;
for ($i = 0; $i < 6; ++$i) {
$temp = unpack("f", pack("L", $char_data[PLAYER_SPELL_CRIT_PERCENTAGE1 + 1 + $i]));
if ($temp[1] < $spell_crit) {
$spell_crit = $temp[1];
}
}
$spell_crit = round($spell_crit, 2);
} else {
$spell_crit = $char_data[PLAYER_SPELL_CRIT_PERCENTAGE1];
$spell_crit = round($spell_crit, 2);
}
if ($core == 1) {
$spell_damage = 9999;
for ($i = 0; $i < 6; ++$i) {
if ($char_data[PLAYER_FIELD_MOD_DAMAGE_DONE_POS + 1 + $i] < $spell_damage) {
$spell_damage = $char_data[PLAYER_FIELD_MOD_DAMAGE_DONE_POS + 1 + $i];
}
}
} else {
$spell_damage = $char_data[PLAYER_FIELD_MOD_DAMAGE_DONE_POS];
}
$spell_heal = $char_data[PLAYER_FIELD_MOD_HEALING_DONE_POS];
// this_is_junk: PLAYER_FIELD_COMBAT_RATING_1 +5, +6, and +7 seem to have the same value as +5
// I'm not sure which of these fields is which hit rating. :/
$spell_hit = $char_data[PLAYER_FIELD_COMBAT_RATING_1 + 5];
// this_is_junk: PLAYER_FIELD_COMBAT_RATING_1 +18 and +19 seem to have the same value as +5
// I'm not sure which of these fields is really spell haste. :/
$spell_haste = $char_data[PLAYER_FIELD_COMBAT_RATING_1 + 17];
// this_is_junk: PLAYER_FIELD_COMBAT_RATING_1 +5, +6, and +7 seem to have the same value as +5
// I'm not sure which of these fields is which hit rating. :/
$ranged_hit = $char_data[PLAYER_FIELD_COMBAT_RATING_1 + 6];
// this_is_junk: PLAYER_FIELD_COMBAT_RATING_1 +5, +6, and +7 seem to have the same value as +5
// I'm not sure which of these fields is which hit rating. :/
$melee_hit = $char_data[PLAYER_FIELD_COMBAT_RATING_1 + 7];
$expertise = $char_data[PLAYER_EXPERTISE] . " / " . $char_data[PLAYER_OFFHAND_EXPERTISE];
//if ( $core == 1 )
//{
/*$EQU_HEAD = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 0];
$EQU_NECK = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 2];
$EQU_SHOULDER = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 4];
$EQU_SHIRT = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 6];
$EQU_CHEST = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 8];
$EQU_BELT = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 10];
$EQU_LEGS = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 12];
$EQU_FEET = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 14];
$EQU_WRIST = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 16];
$EQU_GLOVES = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 18];
$EQU_FINGER1 = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 20];
$EQU_FINGER2 = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 22];
$EQU_TRINKET1 = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 24];
$EQU_TRINKET2 = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 26];
$EQU_BACK = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 28];
$EQU_MAIN_HAND = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 30];
$EQU_OFF_HAND = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 32];
$EQU_RANGED = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 34];
$EQU_TABARD = $char_data[PLAYER_FIELD_INV_SLOT_HEAD + 36];*/
//}
//else
//{
$world_db_name = $world_db[$realm_id]["name"];
if ($core == 1) {
$char_equip_query = "SELECT *, \n playeritems.entry AS item_template, randomprop as property, enchantments AS enchantment, flags\n FROM playeritems WHERE ownerguid='" . $id . "' AND containerslot=-1";
} elseif ($core == 2) {
$char_equip_query = "SELECT *,\n SUBSTRING_INDEX(SUBSTRING_INDEX(item_instance.data, ' ', 11), ' ', -1) AS creator,\n SUBSTRING_INDEX(SUBSTRING_INDEX(item_instance.data, ' ', 23), ' ', -1) AS enchantment,\n SUBSTRING_INDEX(SUBSTRING_INDEX(item_instance.data, ' ', 60), ' ', -1) AS property,\n SUBSTRING_INDEX(SUBSTRING_INDEX(item_instance.data, ' ', 62), ' ', -1) AS durability,\n SUBSTRING_INDEX(SUBSTRING_INDEX(item_instance.data, ' ', 22), ' ', -1) AS flags\n FROM character_inventory\n LEFT JOIN item_instance ON character_inventory.item=item_instance.guid\n WHERE character_inventory.guid='" . $id . "' AND character_inventory.bag=0";
} else {
$char_equip_query = "SELECT *,\n creatorGuid AS creator, enchantments AS enchantment,\n randomPropertyId AS property, durability, flags,\n itemEntry AS item_template\n FROM character_inventory\n LEFT JOIN item_instance ON character_inventory.item=item_instance.guid\n WHERE character_inventory.guid='" . $id . "' AND character_inventory.bag=0";
}
$char_equip_result = $sql["char"]->query($char_equip_query);
while ($equip_row = $sql["char"]->fetch_assoc($char_equip_result)) {
switch ($equip_row["slot"]) {
case 0:
$EQU_HEAD = $equip_row["item_template"];
$EQU_HEAD_ROW = $equip_row;
break;
case 1:
$EQU_NECK = $equip_row["item_template"];
$EQU_NECK_ROW = $equip_row;
break;
case 2:
$EQU_SHOULDER = $equip_row["item_template"];
$EQU_SHOULDER_ROW = $equip_row;
break;
case 3:
$EQU_SHIRT = $equip_row["item_template"];
$EQU_SHIRT_ROW = $equip_row;
break;
case 4:
$EQU_CHEST = $equip_row["item_template"];
$EQU_CHEST_ROW = $equip_row;
break;
case 5:
$EQU_BELT = $equip_row["item_template"];
$EQU_BELT_ROW = $equip_row;
break;
case 6:
$EQU_LEGS = $equip_row["item_template"];
$EQU_LEGS_ROW = $equip_row;
break;
case 7:
$EQU_FEET = $equip_row["item_template"];
$EQU_FEET_ROW = $equip_row;
break;
case 8:
$EQU_WRIST = $equip_row["item_template"];
$EQU_WRIST_ROW = $equip_row;
break;
case 9:
$EQU_GLOVES = $equip_row["item_template"];
$EQU_GLOVES_ROW = $equip_row;
break;
case 10:
$EQU_FINGER1 = $equip_row["item_template"];
$EQU_FINGER1_ROW = $equip_row;
break;
case 11:
$EQU_FINGER2 = $equip_row["item_template"];
$EQU_FINGER2_ROW = $equip_row;
break;
case 12:
$EQU_TRINKET1 = $equip_row["item_template"];
$EQU_TRINKET1_ROW = $equip_row;
break;
case 13:
$EQU_TRINKET2 = $equip_row["item_template"];
$EQU_TRINKET2_ROW = $equip_row;
break;
case 14:
$EQU_BACK = $equip_row["item_template"];
$EQU_BACK_ROW = $equip_row;
break;
case 15:
$EQU_MAIN_HAND = $equip_row["item_template"];
$EQU_MAIN_HAND_ROW = $equip_row;
break;
case 16:
$EQU_OFF_HAND = $equip_row["item_template"];
$EQU_OFF_HAND_ROW = $equip_row;
break;
case 17:
$EQU_RANGED = $equip_row["item_template"];
$EQU_RANGED_ROW = $equip_row;
break;
case 18:
$EQU_TABARD = $equip_row["item_template"];
$EQU_TABARD_ROW = $equip_row;
break;
}
}
//}
$equiped_items = array(1 => array("", $EQU_HEAD ? get_item_icon($EQU_HEAD) : 0, $EQU_HEAD ? get_item_border($EQU_HEAD) : 0, $EQU_HEAD_ROW), 2 => array("", $EQU_NECK ? get_item_icon($EQU_NECK) : 0, $EQU_NECK ? get_item_border($EQU_NECK) : 0, $EQU_NECK_ROW), 3 => array("", $EQU_SHOULDER ? get_item_icon($EQU_SHOULDER) : 0, $EQU_SHOULDER ? get_item_border($EQU_SHOULDER) : 0, $EQU_SHOULDER_ROW), 4 => array("", $EQU_SHIRT ? get_item_icon($EQU_SHIRT) : 0, $EQU_SHIRT ? get_item_border($EQU_SHIRT) : 0, $EQU_SHIRT_ROW), 5 => array("", $EQU_CHEST ? get_item_icon($EQU_CHEST) : 0, $EQU_CHEST ? get_item_border($EQU_CHEST) : 0, $EQU_CHEST_ROW), 6 => array("", $EQU_BELT ? get_item_icon($EQU_BELT) : 0, $EQU_BELT ? get_item_border($EQU_BELT) : 0, $EQU_BELT_ROW), 7 => array("", $EQU_LEGS ? get_item_icon($EQU_LEGS) : 0, $EQU_LEGS ? get_item_border($EQU_LEGS) : 0, $EQU_LEGS_ROW), 8 => array("", $EQU_FEET ? get_item_icon($EQU_FEET) : 0, $EQU_FEET ? get_item_border($EQU_FEET) : 0, $EQU_FEET_ROW), 9 => array("", $EQU_WRIST ? get_item_icon($EQU_WRIST) : 0, $EQU_WRIST ? get_item_border($EQU_WRIST) : 0, $EQU_WRIST_ROW), 10 => array("", $EQU_GLOVES ? get_item_icon($EQU_GLOVES) : 0, $EQU_GLOVES ? get_item_border($EQU_GLOVES) : 0, $EQU_GLOVES_ROW), 11 => array("", $EQU_FINGER1 ? get_item_icon($EQU_FINGER1) : 0, $EQU_FINGER1 ? get_item_border($EQU_FINGER1) : 0, $EQU_FINGER1_ROW), 12 => array("", $EQU_FINGER2 ? get_item_icon($EQU_FINGER2) : 0, $EQU_FINGER2 ? get_item_border($EQU_FINGER2) : 0, $EQU_FINGER2_ROW), 13 => array("", $EQU_TRINKET1 ? get_item_icon($EQU_TRINKET1) : 0, $EQU_TRINKET1 ? get_item_border($EQU_TRINKET1) : 0, $EQU_TRINKET1_ROW), 14 => array("", $EQU_TRINKET2 ? get_item_icon($EQU_TRINKET2) : 0, $EQU_TRINKET2 ? get_item_border($EQU_TRINKET2) : 0, $EQU_TRINKET2_ROW), 15 => array("", $EQU_BACK ? get_item_icon($EQU_BACK) : 0, $EQU_BACK ? get_item_border($EQU_BACK) : 0, $EQU_BACK_ROW), 16 => array("", $EQU_MAIN_HAND ? get_item_icon($EQU_MAIN_HAND) : 0, $EQU_MAIN_HAND ? get_item_border($EQU_MAIN_HAND) : 0, $EQU_MAIN_HAND_ROW), 17 => array("", $EQU_OFF_HAND ? get_item_icon($EQU_OFF_HAND) : 0, $EQU_OFF_HAND ? get_item_border($EQU_OFF_HAND) : 0, $EQU_OFF_HAND_ROW), 18 => array("", $EQU_RANGED ? get_item_icon($EQU_RANGED) : 0, $EQU_RANGED ? get_item_border($EQU_RANGED) : 0, $EQU_RANGED_ROW), 19 => array("", $EQU_TABARD ? get_item_icon($EQU_TABARD) : 0, $EQU_TABARD ? get_item_border($EQU_TABARD) : 0, $EQU_TABARD_ROW));
// visibility overrides for specific tabs
$view_inv_override = false;
if ($s_fields["View_Mod_Inv"] > 0) {
if ($s_fields["View_Mod_Inv"] == 1) {
} elseif ($s_fields["View_Mod_Inv"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_inv_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_inv_override = true;
}
}
$view_talent_override = false;
if ($s_fields["View_Mod_Talent"] > 0) {
if ($s_fields["View_Mod_Talent"] == 1) {
} elseif ($s_fields["View_Mod_Talent"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_talent_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_talent_override = true;
}
}
$view_achieve_override = false;
if ($s_fields["View_Mod_Achieve"] > 0) {
if ($s_fields["View_Mod_Achieve"] == 1) {
} elseif ($s_fields["View_Mod_Achieve"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_achieve_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_achieve_override = true;
}
}
$view_quest_override = false;
if ($s_fields["View_Mod_Quest"] > 0) {
if ($s_fields["View_Mod_Quest"] == 1) {
} elseif ($s_fields["View_Mod_Quest"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_quest_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_quest_override = true;
}
}
$view_friends_override = false;
if ($s_fields["View_Mod_Friends"] > 0) {
if ($s_fields["View_Mod_Friends"] == 1) {
} elseif ($s_fields["View_Mod_Friends"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_friends_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_friends_override = true;
}
}
$view_view_override = false;
if ($s_fields["View_Mod_View"] > 0) {
if ($s_fields["View_Mod_View"] == 1) {
} elseif ($s_fields["View_Mod_View"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_view_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_view_override = true;
}
}
$view_pets_override = false;
if ($s_fields["View_Mod_Pets"] > 0) {
if ($s_fields["View_Mod_Pets"] == 1) {
} elseif ($s_fields["View_Mod_Pets"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_pets_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_pets_override = true;
}
}
$view_rep_override = false;
if ($s_fields["View_Mod_Rep"] > 0) {
if ($s_fields["View_Mod_Rep"] == 1) {
} elseif ($s_fields["View_Mod_Rep"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_rep_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_rep_override = true;
}
}
$view_skill_override = false;
if ($s_fields["View_Mod_Skill"] > 0) {
if ($s_fields["View_Mod_Skill"] == 1) {
} elseif ($s_fields["View_Mod_Skill"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_skill_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_skill_override = true;
}
}
$view_pvp_override = false;
if ($s_fields["View_Mod_PvP"] > 0) {
if ($s_fields["View_Mod_PvP"] == 1) {
} elseif ($s_fields["View_Mod_PvP"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_pvp_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_pvp_override = true;
}
}
$output .= '
<!-- start of char.php -->
<div class="tab">
<ul>
<li class="selected"><a href="char.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "char_sheet") . '</a></li>';
if ($view_inv_override) {
$output .= '
<li><a href="char_inv.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "inventory") . '</a></li>';
}
if ($view_talent_override) {
$output .= '
' . ($char["level"] < 10 ? '' : '<li><a href="char_talent.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "talents") . '</a></li>') . '';
}
if ($view_achieve_override) {
$output .= '
<li><a href="char_achieve.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "achievements") . '</a></li>';
}
if ($view_quest_override) {
$output .= '
<li><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "quests") . '</a></li>';
}
if ($view_friends_override) {
$output .= '
<li><a href="char_friends.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "friends") . '</a></li>';
}
if ($view_view_override) {
$output .= '
<li><a href="char_view.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "view") . '</a></li>';
}
$output .= '
</ul>
</div>';
if ($view_override || $user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$output .= '
<div class="tab_content center">
<div class="tab">
<ul>
<li class="selected"><a href="char.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "char_sheet") . '</a></li>';
if (char_get_class_name($char["class"]) === "Hunter" && $view_pets_override) {
$output .= '
<li><a href="char_pets.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "pets") . '</a></li>';
}
if ($view_rep_override) {
$output .= '
<li><a href="char_rep.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "reputation") . '</a></li>';
}
if ($view_skill_override) {
$output .= '
<li><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "skills") . '</a></li>';
}
if ($view_pvp_override) {
$output .= '
<li><a href="char_pvp.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "pvp") . '</a></li>';
}
if ($owner_name == $user_name || $user_lvl >= get_page_permission("insert", "char_mail.php")) {
$output .= '
<li><a href="char_mail.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "mail") . '</a></li>';
}
$output .= '
</ul>
</div>';
} else {
$output .= '
<div class="tab_content center">
<div class="tab">
</div>';
}
$output .= '
<div class="tab_content2 center">
<table class="lined" id="char_character_sheet">
<tr>
<td colspan="2">
<div>
<img src="' . char_get_avatar_img($char["level"], $char["gender"], $char["race"], $char["class"], 0) . '" alt="avatar" />
</div>
<div>';
// this_is_junk: auras are stored in a string in the characters table.
// not sure how to query a string as though it were a record
if ($core == 1) {
} else {
$a_results = $sql["char"]->query("SELECT DISTINCT spell FROM character_aura WHERE guid='" . $id . "'");
}
if ($sql["char"]->num_rows($a_results)) {
while ($aura = $sql["char"]->fetch_assoc($a_results)) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $spell_datasite . $aura["spell"] . '" rel="external">
<img src="' . spell_get_icon($aura["spell"]) . '" alt="' . $aura["spell"] . '" width="24" height="24" />
</a>';
}
}
$output .= '
</div>
</td>
<td colspan="4">
<span class="bold">
' . htmlentities($char["name"], ENT_COMPAT, $site_encoding) . ' -
<img src="img/c_icons/' . $char["race"] . '-' . $char["gender"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_race_name($char["race"]) . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" />
<img src="img/c_icons/' . $char["class"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_class_name($char["class"]) . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" />
- ' . lang("char", "level_short") . char_get_level_color($char["level"]) . '
</span>
<br />' . lang("char", "location") . ': ' . get_map_name($char["mapid"]) . ' - ' . get_zone_name($char["zoneid"]) . '
<br />' . lang("char", "honor_points") . ': ' . $char_data[PLAYER_FIELD_HONOR_CURRENCY] . ' | ' . lang("char", "arena_points") . ': ' . $char_data[PLAYER_FIELD_ARENA_CURRENCY] . ' | ' . lang("char", "honor_kills") . ': ' . $char_data[PLAYER_FIELD_LIFETIME_HONORBALE_KILLS] . '
<br />' . lang("char", "guild") . ': ' . $guild_name . ' | ' . lang("char", "rank") . ': ' . htmlentities($guild_rank, ENT_COMPAT, $site_encoding) . '
<br />' . lang("char", "online") . ': ' . ($char["online"] ? '<img src="img/up.gif" onmousemove="oldtoolTip(\'' . lang("char", "online") . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="online" />' : '<img src="img/down.gif" onmousemove="oldtoolTip(\'' . lang("char", "offline") . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="offline" />');
if ($showcountryflag) {
require_once 'libs/misc_lib.php';
$country = misc_get_country_by_account($char["acct"]);
$output .= ' | ' . lang("global", "country") . ': ' . ($country["code"] ? '<img src="img/flags/' . $country["code"] . '.png" onmousemove="oldtoolTip(\'' . $country["country"] . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" />' : '-');
unset($country);
}
$output .= '
</td>
</tr>
<tr>
<td style="width: 6%;">';
if ($equiped_items[1][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_HEAD . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'HEAD' . '\');" onmouseout="HideTooltip(\'_b' . 'HEAD' . '\');">
<img src="' . $equiped_items[1][1] . '" class="' . $equiped_items[1][2] . '" alt="Head" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[1][3]["bag"] . '&slot=' . $equiped_items[1][3]["slot"] . '&item=' . $equiped_items[1][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[1][3]["item_template"]);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'HEAD' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[1][3]["enchantment"], $equiped_items[1][3]["property"], $equiped_items[1][3]["creator"], $equiped_items[1][3]["durability"], $equiped_items[1][3]["flags"]) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_head.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td class="half_line" colspan="2" align="center" style="width: 50%;">
<div class="gradient_p" id="char_hp_name">' . lang("item", "health") . ':</div>
<div class="gradient_pp" id="char_hp_value">' . $char_data[UNIT_FIELD_HEALTH] . '/' . $char_data[UNIT_FIELD_MAXHEALTH] . '</div>';
if ($char["class"] == 11) {
//druid
$output .= '
<br />
<div class="gradient_p" id="char_energy_name">' . lang("item", "mana") . ':</div>
<div class="gradient_pp" id="char_energy_value">' . $char_data[UNIT_FIELD_POWER1] . '/' . $char_data[UNIT_FIELD_MAXPOWER1] . '</div>';
}
$output .= '
</td>
<td class="half_line" colspan="2" align="center" style="width: 50%;">';
if ($char["class"] == 1) {
$output .= '
<div class="gradient_p" id="char_energy_name">' . lang("item", "rage") . ':</div>
<div class="gradient_pp" id="char_energy_value">' . $char_data[UNIT_FIELD_POWER2] / 10 . '/' . $char_data[UNIT_FIELD_MAXPOWER2] / 10 . '</div>';
} elseif ($char["class"] == 4) {
$output .= '
<div class="gradient_p" id="char_energy_name">' . lang("item", "energy") . ':</div>
<div class="gradient_pp" id="char_energy_value">' . $char_data[UNIT_FIELD_POWER4] . '/' . $char_data[UNIT_FIELD_MAXPOWER4] . '</div>';
} elseif ($char["class"] == 6) {
$output .= '
<div class="gradient_p" id="char_energy_name">' . lang("item", "runic") . ':</div>
<div class="gradient_pp" id="char_energy_value">' . $char_data[UNIT_FIELD_POWER7] / 10 . '/' . $char_data[UNIT_FIELD_MAXPOWER7] / 10 . '</div>';
} elseif ($char["class"] == 11) {
$output .= '
<div class="gradient_p" id="char_energy_name">' . lang("item", "mana") . ':</div>
<div class="gradient_pp" id="char_energy_value">' . $char_data[UNIT_FIELD_POWER1] . '/' . $char_data[UNIT_FIELD_MAXPOWER1] . '</div>
<br />
<div class="gradient_p" id="char_energy_name">' . lang("item", "rage") . ':</div>
<div class="gradient_pp" id="char_energy_value">' . $char_data[UNIT_FIELD_POWER2] / 10 . '/' . $char_data[UNIT_FIELD_MAXPOWER2] / 10 . '</div>';
} elseif ($char["class"] == 2 || $char["class"] == 3 || $char["class"] == 5 || $char["class"] == 7 || $char["class"] == 8 || $char["class"] == 9) {
$output .= '
<div class="gradient_p" id="char_energy_name">' . lang("item", "mana") . ':</div>
<div class="gradient_pp" id="char_energy_value">' . $char_data[UNIT_FIELD_POWER1] . '/' . $char_data[UNIT_FIELD_MAXPOWER1] . '</div>';
}
$output .= '
</td>
<td style="width: 6%;">';
if ($equiped_items[10][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_GLOVES . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'GLOVES' . '\');" onmouseout="HideTooltip(\'_b' . 'GLOVES' . '\');">
<img src="' . $equiped_items[10][1] . '" class="' . $equiped_items[10][2] . '" alt="Gloves" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[10][3]["bag"] . '&slot=' . $equiped_items[10][3]["slot"] . '&item=' . $equiped_items[10][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[10][3]["item_template"]);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'GLOVES' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[10][3]["enchantment"], $equiped_items[10][3]["property"], $equiped_items[10][3]["creator"], $equiped_items[10][3]["durability"], $equiped_items[10][3]["flags"]) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_gloves.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
</tr>
<tr>
<td style="width: 1%;">';
if ($equiped_items[2][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_NECK . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'NECK' . '\');" onmouseout="HideTooltip(\'_b' . 'NECK' . '\');">
<img src="' . $equiped_items[2][1] . '" class="' . $equiped_items[2][2] . '" alt="Neck" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[2][3]["bag"] . '&slot=' . $equiped_items[2][3]["slot"] . '&item=' . $equiped_items[2][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[2][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'NECK' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[2][3]['enchantment'], $equiped_items[2][3]['property'], $equiped_items[2][3]['creator'], $equiped_items[2][3]['durability'], $equiped_items[2][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_neck.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td class="half_line" colspan="2" rowspan="3" align="center" style="width: 50%;">
<div class="gradient_p">
' . lang("item", "strength") . ':<br />
' . lang("item", "agility") . ':<br />
' . lang("item", "stamina") . ':<br />
' . lang("item", "intellect") . ':<br />
' . lang("item", "spirit") . ':<br />
' . lang("item", "armor") . ':
</div>
<div class="gradient_pp">
' . $char_data[UNIT_FIELD_STAT0] . '<br />
' . $char_data[UNIT_FIELD_STAT1] . '<br />
' . $char_data[UNIT_FIELD_STAT2] . '<br />
' . $char_data[UNIT_FIELD_STAT3] . '<br />
' . $char_data[UNIT_FIELD_STAT4] . '<br />
' . $char_data[UNIT_FIELD_RESISTANCES] . '
</div>
</td>
<td class="half_line" colspan="2" rowspan="3" align="center" style="width: 50%;">
<div class="gradient_p">
' . lang("item", "res_holy") . ':<br />
' . lang("item", "res_arcane") . ':<br />
' . lang("item", "res_fire") . ':<br />
' . lang("item", "res_nature") . ':<br />
' . lang("item", "res_frost") . ':<br />
' . lang("item", "res_shadow") . ':
</div>
<div class="gradient_pp">
' . $char_data[UNIT_FIELD_RESISTANCES + 1] . '<br />
' . $char_data[UNIT_FIELD_RESISTANCES + 2] . '<br />
' . $char_data[UNIT_FIELD_RESISTANCES + 3] . '<br />
' . $char_data[UNIT_FIELD_RESISTANCES + 4] . '<br />
' . $char_data[UNIT_FIELD_RESISTANCES + 5] . '<br />
' . $char_data[UNIT_FIELD_RESISTANCES + 6] . '
</div>
</td>
<td style="width: 1%;">';
if ($equiped_items[6][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_BELT . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'BELT' . '\');" onmouseout="HideTooltip(\'_b' . 'BELT' . '\');">
<img src="' . $equiped_items[6][1] . '" class="' . $equiped_items[6][2] . '" alt="Belt" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[6][3]["bag"] . '&slot=' . $equiped_items[6][3]["slot"] . '&item=' . $equiped_items[6][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[6][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'BELT' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[6][3]['enchantment'], $equiped_items[6][3]['property'], $equiped_items[6][3]['creator'], $equiped_items[6][3]['durability'], $equiped_items[6][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_waist.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
</tr>
<tr>
<td style="width: 1%;">';
if ($equiped_items[3][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_SHOULDER . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'SHOULDER' . '\');" onmouseout="HideTooltip(\'_b' . 'SHOULDER' . '\');">
<img src="' . $equiped_items[3][1] . '" class="' . $equiped_items[3][2] . '" alt="Shoulder" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[3][3]["bag"] . '&slot=' . $equiped_items[3][3]["slot"] . '&item=' . $equiped_items[3][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[3][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'SHOULDER' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[3][3]['enchantment'], $equiped_items[3][3]['property'], $equiped_items[3][3]['creator'], $equiped_items[3][3]['durability'], $equiped_items[3][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_shoulder.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td style="width: 1%;">';
if ($equiped_items[7][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_LEGS . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'LEGS' . '\');" onmouseout="HideTooltip(\'_b' . 'LEGS' . '\');">
<img src="' . $equiped_items[7][1] . '" class="' . $equiped_items[7][2] . '" alt="Legs" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[7][3]["bag"] . '&slot=' . $equiped_items[7][3]["slot"] . '&item=' . $equiped_items[7][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[7][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'LEGS' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[7][3]['enchantment'], $equiped_items[7][3]['property'], $equiped_items[7][3]['creator'], $equiped_items[7][3]['durability'], $equiped_items[7][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_legs.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
</tr>
<tr>
<td style="width: 1%;">';
if ($equiped_items[15][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_BACK . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'BACK' . '\');" onmouseout="HideTooltip(\'_b' . 'BACK' . '\');">
<img src="' . $equiped_items[15][1] . '" class="' . $equiped_items[15][2] . '" alt="Back" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[15][3]["bag"] . '&slot=' . $equiped_items[15][3]["slot"] . '&item=' . $equiped_items[15][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[15][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'BACK' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[15][3]['enchantment'], $equiped_items[15][3]['property'], $equiped_items[15][3]['creator'], $equiped_items[15][3]['durability'], $equiped_items[15][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_chest_back.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td style="width: 1%;">';
if ($equiped_items[8][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_FEET . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'FEET' . '\');" onmouseout="HideTooltip(\'_b' . 'FEET' . '\');">
<img src="' . $equiped_items[8][1] . '" class="' . $equiped_items[8][2] . '" alt="Feet" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[8][3]["bag"] . '&slot=' . $equiped_items[8][3]["slot"] . '&item=' . $equiped_items[8][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[8][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'FEET' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[8][3]['enchantment'], $equiped_items[8][3]['property'], $equiped_items[8][3]['creator'], $equiped_items[8][3]['durability'], $equiped_items[8][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_feet.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
</tr>
<tr>
<td style="width: 1%;">';
if ($equiped_items[5][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_CHEST . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'CHEST' . '\');" onmouseout="HideTooltip(\'_b' . 'CHEST' . '\');">
<img src="' . $equiped_items[5][1] . '" class="' . $equiped_items[5][2] . '" alt="Chest" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[5][3]["bag"] . '&slot=' . $equiped_items[5][3]["slot"] . '&item=' . $equiped_items[5][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[5][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'CHEST' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[5][3]['enchantment'], $equiped_items[5][3]['property'], $equiped_items[5][3]['creator'], $equiped_items[5][3]['durability'], $equiped_items[5][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_chest_back.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td class="half_line" colspan="2" rowspan="2" align="center" style="width: 50%;">
<div class="gradient_p" id="char_melee_name">
' . lang("char", "melee_d") . ':<br />
' . lang("char", "melee_ap") . ':<br />
' . lang("char", "melee_hit") . ':<br />
' . lang("char", "melee_crit") . ':<br />
' . lang("char", "expertise") . ':<br />
</div>
<div class="gradient_pp" id="char_melee_value">
' . $mindamage . '-' . $maxdamage . '<br />
' . ($char_data[UNIT_FIELD_ATTACK_POWER] + $char_data[UNIT_FIELD_ATTACK_POWER_MODS]) . '<br />
' . $melee_hit . '<br />
' . $crit . '%<br />
' . $expertise . '<br />
</div>
</td>
<td class="half_line" colspan="2" rowspan="2" align="center" style="width: 50%;">
<div class="gradient_p">
' . lang("char", "spell_d") . ':<br />
' . lang("char", "spell_heal") . ':<br />
' . lang("char", "spell_hit") . ':<br />
' . lang("char", "spell_crit") . ':<br />
' . lang("char", "spell_haste") . '
</div>
<div class="gradient_pp">
' . $spell_damage . '<br />
' . $spell_heal . '<br />
' . $spell_hit . '<br />
' . $spell_crit . '%<br />
' . $spell_haste . '
</div>
</td>
<td style="width: 1%;">';
if ($equiped_items[11][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_FINGER1 . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'FINGER1' . '\');" onmouseout="HideTooltip(\'_b' . 'FINGER1' . '\');">
<img src="' . $equiped_items[11][1] . '" class="' . $equiped_items[11][2] . '" alt="Finger1" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[11][3]["bag"] . '&slot=' . $equiped_items[11][3]["slot"] . '&item=' . $equiped_items[11][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[11][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'FINGER1' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[11][3]['enchantment'], $equiped_items[11][3]['property'], $equiped_items[11][3]['creator'], $equiped_items[11][3]['durability'], $equiped_items[11][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_finger.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
</tr>
<tr>
<td style="width: 1%;">';
if ($equiped_items[4][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_SHIRT . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'SHIRT' . '\');" onmouseout="HideTooltip(\'_b' . 'SHIRT' . '\');">
<img src="' . $equiped_items[4][1] . '" class="' . $equiped_items[4][2] . '" alt="Shirt" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[4][3]["bag"] . '&slot=' . $equiped_items[4][3]["slot"] . '&item=' . $equiped_items[4][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[4][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'SHIRT' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[4][3]['enchantment'], $equiped_items[4][3]['property'], $equiped_items[4][3]['creator'], $equiped_items[4][3]['durability'], $equiped_items[4][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_shirt.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td style="width: 1%;">';
if ($equiped_items[12][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_FINGER2 . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'FINGER2' . '\');" onmouseout="HideTooltip(\'_b' . 'FINGER2' . '\');">
<img src="' . $equiped_items[12][1] . '" class="' . $equiped_items[12][2] . '" alt="Finger2" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[12][3]["bag"] . '&slot=' . $equiped_items[12][3]["slot"] . '&item=' . $equiped_items[12][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[12][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'FINGER2' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[12][3]['enchantment'], $equiped_items[12][3]['property'], $equiped_items[12][3]['creator'], $equiped_items[12][3]['durability'], $equiped_items[12][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_finger.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
</tr>
<tr>
<td style="width: 1%;">';
if ($equiped_items[19][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_TABARD . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'TABARD' . '\');" onmouseout="HideTooltip(\'_b' . 'TABARD' . '\');">
<img src="' . $equiped_items[19][1] . '" class="' . $equiped_items[19][2] . '" alt="Tabard" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[19][3]["bag"] . '&slot=' . $equiped_items[19][3]["slot"] . '&item=' . $equiped_items[19][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[19][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'TABARD' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[19][3]['enchantment'], $equiped_items[19][3]['property'], $equiped_items[19][3]['creator'], $equiped_items[19][3]['durability'], $equiped_items[19][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_tabard.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td class="half_line" colspan="2" rowspan="2" align="center" style="width: 50%;">
<div class="gradient_p">
' . lang("char", "dodge") . ':<br />
' . lang("char", "parry") . ':<br />
' . lang("char", "block") . ':
</div>
<div class="gradient_pp">
' . $dodge . '%<br />
' . $parry . '%<br />
' . $block . '%
</div>
</td>
<td class="half_line" colspan="2" rowspan="2" align="center" style="width: 50%;">
<div class="gradient_p" id="char_ranged_name">
' . lang("char", "ranged_d") . ':<br />
' . lang("char", "ranged_ap") . ':<br />
' . lang("char", "ranged_hit") . ':<br />
' . lang("char", "ranged_crit") . ':<br />
</div>
<div class="gradient_pp" id="char_ranged_value">
' . $minrangeddamage . '-' . $maxrangeddamage . '<br />
' . ($char_data[UNIT_FIELD_RANGED_ATTACK_POWER] + $char_data[UNIT_FIELD_RANGED_ATTACK_POWER_MODS]) . '<br />
' . $ranged_hit . '<br />
' . $ranged_crit . '%<br />
</div>
</td>
<td style="width: 1%;">';
if ($equiped_items[13][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_TRINKET1 . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'TRINKET1' . '\');" onmouseout="HideTooltip(\'_b' . 'TRINKET1' . '\');">
<img src="' . $equiped_items[13][1] . '" class="' . $equiped_items[13][2] . '" alt="Trinket1" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[13][3]["bag"] . '&slot=' . $equiped_items[13][3]["slot"] . '&item=' . $equiped_items[13][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[13][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'TRINKET1' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[13][3]['enchantment'], $equiped_items[13][3]['property'], $equiped_items[13][3]['creator'], $equiped_items[13][3]['durability'], $equiped_items[13][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_trinket.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
</tr>
<tr>
<td style="width: 1%;">';
if ($equiped_items[9][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_WRIST . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'WRIST' . '\');" onmouseout="HideTooltip(\'_b' . 'WRIST' . '\');">
<img src="' . $equiped_items[9][1] . '" class="' . $equiped_items[9][2] . '" alt="Wrist" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[9][3]["bag"] . '&slot=' . $equiped_items[9][3]["slot"] . '&item=' . $equiped_items[9][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[9][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'WRIST' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[9][3]['enchantment'], $equiped_items[9][3]['property'], $equiped_items[9][3]['creator'], $equiped_items[9][3]['durability'], $equiped_items[9][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_wrist.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td style="width: 1%;">';
if ($equiped_items[14][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_TRINKET2 . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'TRINKET2' . '\');" onmouseout="HideTooltip(\'_b' . 'TRINKET2' . '\');">
<img src="' . $equiped_items[14][1] . '" class="' . $equiped_items[14][2] . '" alt="Trinket2" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[14][3]["bag"] . '&slot=' . $equiped_items[14][3]["slot"] . '&item=' . $equiped_items[14][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[14][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'TRINKET2' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[14][3]['enchantment'], $equiped_items[14][3]['property'], $equiped_items[14][3]['creator'], $equiped_items[14][3]['durability'], $equiped_items[14][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_trinket.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
</tr>
<tr>
<td></td>
<td style="width: 15%;">';
if ($equiped_items[16][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_MAIN_HAND . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'MAIN_HAND' . '\');" onmouseout="HideTooltip(\'_b' . 'MAIN_HAND' . '\');">
<img src="' . $equiped_items[16][1] . '" class="' . $equiped_items[16][2] . '" alt="MainHand" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[16][3]["bag"] . '&slot=' . $equiped_items[16][3]["slot"] . '&item=' . $equiped_items[16][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[16][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'MAIN_HAND' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[16][3]['enchantment'], $equiped_items[16][3]['property'], $equiped_items[16][3]['creator'], $equiped_items[16][3]['durability'], $equiped_items[16][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_main_hand.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td style="width: 15%;">';
if ($equiped_items[17][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_OFF_HAND . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'OFF_HAND' . '\');" onmouseout="HideTooltip(\'_b' . 'OFF_HAND' . '\');">
<img src="' . $equiped_items[17][1] . '" class="' . $equiped_items[17][2] . '" alt="OffHand" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[17][3]["bag"] . '&slot=' . $equiped_items[17][3]["slot"] . '&item=' . $equiped_items[17][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[17][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'OFF_HAND' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[17][3]['enchantment'], $equiped_items[17][3]['property'], $equiped_items[17][3]['creator'], $equiped_items[17][3]['durability'], $equiped_items[17][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_off_hand.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td style="width: 15%;">';
if ($equiped_items[18][1]) {
$output .= '
<a class="char_icon_padding" href="' . $base_datasite . $item_datasite . $EQU_RANGED . '" rel="external" onmouseover="ShowTooltip(this,\'_b' . 'RANGED' . '\');" onmouseout="HideTooltip(\'_b' . 'RANGED' . '\');">
<img src="' . $equiped_items[18][1] . '" class="' . $equiped_items[18][2] . '" alt="Ranged" />
</a>';
if ($mode) {
$output .= '
<div style="position: relative;">
<a href="char.php?action=delete_item&id=' . $id . '&bag=' . $equiped_items[18][3]["bag"] . '&slot=' . $equiped_items[18][3]["slot"] . '&item=' . $equiped_items[18][3]["item_template"] . '&mode=' . $mode . '" id="ch_item_delete">
<img src="img/aff_cross.png" />
</a>
</div>';
}
// build a tooltip object for this item
$i_fields = get_item_info($equiped_items[18][3]['item_template']);
$output .= '
<div class="item_tooltip" id="tooltip_b' . 'RANGED' . '">
<table>
<tr>
<td>
' . get_item_tooltip($i_fields, $equiped_items[18][3]['enchantment'], $equiped_items[18][3]['property'], $equiped_items[18][3]['creator'], $equiped_items[18][3]['durability'], $equiped_items[18][3]['flags']) . '
</td>
</tr>
</table>
</div>';
} else {
$output .= '
<img src="img/INV/INV_empty_ranged.png" class="icon_border_0" alt="empty" />';
}
$output .= '
</td>
<td style="width: 15%;"></td>
<td></td>
</tr>';
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
// if the character is still leveling, show an experience bar
if ($char["level"] < 80) {
$xp_query = "SELECT * FROM xp_to_level WHERE level='" . $char["level"] . "'";
$xp_result = $sql["mgr"]->query($xp_query);
$xp_fields = $sql["mgr"]->fetch_assoc($xp_result);
$xp_to_level = $xp_fields["xp_for_next_level"];
$output .= '
<tr>
<td colspan="6" class="bar xp_bar" style="background-position: ' . (round(580 * $char["xp"] / $xp_to_level) - 580) . 'px;">
' . lang("char", "exp") . ": " . $char["xp"] . " / " . $xp_to_level . '
</td>
</tr>';
}
//total time played
$tot_time = $char["totaltime"];
$tot_days = (int) ($tot_time / 86400);
$tot_time = $tot_time - $tot_days * 86400;
$total_hours = (int) ($tot_time / 3600);
$tot_time = $tot_time - $total_hours * 3600;
$total_min = (int) ($tot_time / 60);
$time_offset = $timezone_offset * 3600;
if ($char["timestamp"] != 0) {
$lastseen = date("F j, Y @ Hi", $char["timestamp"] + $time_offset);
} else {
$lastseen = '-';
}
$output .= '
<tr>
<td colspan="6">
' . lang("char", "tot_play_time") . ': ' . $tot_days . ' ' . lang("char", "days") . ' ' . $total_hours . ' ' . lang("char", "hours") . ' ' . $total_min . ' ' . lang("char", "min") . '
</td>
</tr>';
$output .= '
<tr>
<td colspan="6">
' . lang("char", "lastseen") . ': ' . $lastseen . '
</td>
</tr>';
}
$output .= '
</table>
</div>
<br />
</div>
<br />
<table class="hidden center">
<tr>
<td>';
// button to user account page, user account page has own security
makebutton(lang("char", "chars_acc"), 'user.php?action=edit_user&acct=' . $owner_acc_id . '', 130);
$output .= '
</td>
<td>';
// only higher level GM with delete access can edit character
// character edit allows removal of character items, so delete permission is needed
if ($user_lvl >= $owner_gmlvl && $user_lvl >= $action_permission["delete"]) {
makebutton(lang("char", "edit_button"), 'char_edit.php?id=' . $id . '&realm=' . $realmid, 130);
$output .= '
</td>
<td>';
}
// only higher level GM with delete access, or character owner can delete character
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission["delete"] || $owner_name === $user_name) {
makebutton(lang("char", "del_char"), 'char_list.php?action=del_char_form&check%5B%5D=' . $id . '" type="wrn', 130);
$output .= '
</td>
<td>';
}
// show Delete Mode / View Mode button depending on current mode
if ($mode) {
makebutton(lang("char", "viewmode"), 'char.php?id=' . $id . '&realm=' . $realmid . '&mode=0" type="def', 130);
} else {
makebutton(lang("char", "deletemode"), 'char.php?id=' . $id . '&realm=' . $realmid . '&mode=1" type="def', 130);
}
$output .= '
</td>
<td>';
// only GM with update permission can send mail, mail can send items, so update permission is needed
if ($user_lvl >= $action_permission["update"]) {
makebutton(lang("char", "send_mail"), 'mail.php?type=ingame_mail&to=' . $char["name"], 130);
$output .= '
</td>';
} else {
$output .= '
</td>';
}
$output .= '
</tr>
<tr>
<td>';
makebutton(lang("global", "back"), 'javascript:window.history.back()" type="def', 130);
$output .= '
</td>
</tr>
</table>
<br />
<!-- end of char.php -->';
} else {
}
//error($lang_char["no_permission"]);
} else {
error(lang("char", "no_char_found"));
}
}
function execAction($dir, $item)
{
// change permissions
if (($GLOBALS["permissions"] & 01) != 01) {
ext_Result::sendResult('chmod', false, $GLOBALS["error_msg"]["accessfunc"]);
}
if (!empty($GLOBALS['__POST']["selitems"])) {
$cnt = count($GLOBALS['__POST']["selitems"]);
} else {
$GLOBALS['__POST']["selitems"][] = $item;
$cnt = 1;
}
if (!empty($GLOBALS['__POST']['do_recurse'])) {
$do_recurse = true;
} else {
$do_recurse = false;
}
// Execute
if (isset($GLOBALS['__POST']["confirm"]) && $GLOBALS['__POST']["confirm"] == "true") {
$bin = '';
for ($i = 0; $i < 3; $i++) {
for ($j = 0; $j < 3; $j++) {
$tmp = "r_" . $i . $j;
if (!empty($GLOBALS['__POST'][$tmp])) {
$bin .= '1';
} else {
$bin .= '0';
}
}
}
if ($bin == '0') {
// Changing permissions to "none" is not allowed
ext_Result::sendResult('chmod', false, $item . ": " . ext_Lang::err('chmod_none_not_allowed'));
}
$old_bin = $bin;
for ($i = 0; $i < $cnt; ++$i) {
if (ext_isFTPMode()) {
$mode = decoct(bindec($bin));
} else {
$mode = bindec($bin);
}
$item = $GLOBALS['__POST']["selitems"][$i];
if (ext_isFTPMode()) {
$abs_item = get_item_info($dir, $item);
} else {
$abs_item = get_abs_item($dir, $item);
}
if (!$GLOBALS['ext_File']->file_exists($abs_item)) {
ext_Result::sendResult('chmod', false, $item . ": " . $GLOBALS["error_msg"]["fileexist"]);
}
if (!get_show_item($dir, $item)) {
ext_Result::sendResult('chmod', false, $item . ": " . $GLOBALS["error_msg"]["accessfile"]);
}
if ($do_recurse) {
$ok = $GLOBALS['ext_File']->chmodRecursive($abs_item, $mode);
} else {
if (get_is_dir($abs_item)) {
// when we chmod a directory we must care for the permissions
// to prevent that the directory becomes not readable (when the "execute bits" are removed)
$bin = substr_replace($bin, '1', 2, 1);
// set 1st x bit to 1
$bin = substr_replace($bin, '1', 5, 1);
// set 2nd x bit to 1
$bin = substr_replace($bin, '1', 8, 1);
// set 3rd x bit to 1
if (ext_isFTPMode()) {
$mode = decoct(bindec($bin));
} else {
$mode = bindec($bin);
}
}
//ext_Result::sendResult('chmod', false, $GLOBALS['FTPCONNECTION']->pwd());
$ok = @$GLOBALS['ext_File']->chmod($abs_item, $mode);
}
$bin = $old_bin;
}
if ($ok === false || PEAR::isError($ok)) {
$msg = $item . ": " . $GLOBALS["error_msg"]["permchange"];
$msg .= PEAR::isError($ok) ? ' [' . $ok->getMessage() . ']' : '';
ext_Result::sendResult('chmod', false, $msg);
}
ext_Result::sendResult('chmod', true, ext_Lang::msg('permchange'));
return;
}
if (ext_isFTPMode()) {
$abs_item = get_item_info($dir, $GLOBALS['__POST']["selitems"][0]);
} else {
$abs_item = get_abs_item($dir, $GLOBALS['__POST']["selitems"][0]);
$abs_item = utf8_decode($abs_item);
}
$mode = parse_file_perms(get_file_perms($abs_item));
if ($mode === false) {
ext_Result::sendResult('chmod', false, $item . ": " . $GLOBALS["error_msg"]["permread"]);
}
$pos = "rwx";
$text = "";
for ($i = 0; $i < $cnt; ++$i) {
$s_item = get_rel_item($dir, $GLOBALS['__POST']["selitems"][$i]);
if (strlen($s_item) > 50) {
$s_item = "..." . substr($s_item, -47);
}
$text .= $s_item . ($i + 1 < $cnt ? ', ' : '');
}
?>
{
"xtype": "form",
"id": "simpleform",
"width": "300",
"labelWidth": 125,
"url":"<?php
echo basename($GLOBALS['script_name']);
?>
",
"dialogtitle": "<?php
echo ext_Lang::msg('actperms');
?>
",
"title" : "<?php
echo $text;
?>
",
"frame": true,
"items": [{
"layout": "column",
"items": [{
<?php
// print table with current perms & checkboxes to change
for ($i = 0; $i < 3; ++$i) {
?>
"width":80,
"title":"<?php
echo ext_Lang::msg(array('miscchmod' => $i), true);
?>
",
"items": [{
<?php
for ($j = 0; $j < 3; ++$j) {
?>
"xtype": "checkbox",
"boxLabel":"<?php
echo $pos[$j];
?>
",
<?php
if ($mode[3 * $i + $j] != "-") {
echo '"checked":true,';
}
?>
"name":"<?php
echo "r_" . $i . $j;
?>
"
} <?php
if ($j < 2) {
echo ',{';
}
}
?>
]
}
<?php
if ($i < 2) {
echo ',{';
}
}
?>
,{
"width":400,
"style":"margin-left:10px",
"clear":true,
"html": " "
}]
},{
"xtype": "checkbox",
"fieldLabel":"<?php
echo ext_Lang::msg('recurse_subdirs', true);
?>
",
"name":"do_recurse"
}],
"buttons": [{
"text": "<?php
echo ext_Lang::msg('btnsave', true);
?>
",
"handler": function() {
statusBarMessage( '<?php
echo ext_Lang::msg('permissions_processing', true);
?>
', true );
form = Ext.getCmp("simpleform").getForm();
form.submit({
//reset: true,
reset: false,
success: function(form, action) {
statusBarMessage( action.result.message, false, true );
datastore.reload();
Ext.getCmp("dialog").destroy();
},
failure: function(form, action) {
statusBarMessage( action.result.error, false, false );
Ext.Msg.alert('<?php
echo ext_Lang::err('error', true);
?>
', action.result.error);
},
scope: form,
params: {
"option": "com_extplorer",
"action": "chmod",
"dir": "<?php
echo stripslashes($GLOBALS['__POST']["dir"]);
?>
",
"selitems[]": ['<?php
echo implode("','", $GLOBALS['__POST']["selitems"]);
?>
'],
confirm: 'true'
}
});
}
},{
"text": "<?php
echo ext_Lang::msg('btncancel', true);
?>
",
"handler": function() { Ext.getCmp("dialog").destroy(); }
}]
}
<?php
}
function parseItems($links = null)
{
$page = get_hero_page("http://dota2.ru/items/");
// Получение страницы и создание объекта из ее html
if ($page['error_no'] != 0) {
echo "Ошибка получения страницы героя</br>" . $page['error'] . "</br>";
die;
} else {
$html = $page["page"];
}
$document = phpQuery::newDocument($html);
// Получение страницы и создание объекта из ее html
if (is_null($links)) {
$item_links_with_info = $document->find("#list > .item > a");
} else {
foreach ($links as $link) {
$item_links_with_info[] = $document->find("#list > .item > a[href='" . trim($link) . "']");
}
}
foreach ($item_links_with_info as $item_link) {
file_put_contents(__DIR__ . "/logs/parse_ithems.log", date("Y-m-d H:i:s") . ": начинаю парсить предмет" . $item_link->attr('href') . "\r\n", FILE_APPEND);
$item_html_obj = pq($item_link);
$img_src = $item_html_obj->find('.tooltipe')->attr('src');
$name_and_slug = item_img_name_and_slug(trim($img_src));
$item['slug'] = mysql_real_escape_string($name_and_slug["slug"]);
$path = "/images/ithems/" . $name_and_slug["filename"] . ".jpg";
$img_link = "http://dota2.ru" . $img_src;
if (download_img_in_folder($img_link, $path)) {
$item['image'] = mysql_real_escape_string($path);
} else {
continue;
}
$item['info'] = get_item_info($item_html_obj->find('.tooltipe-content'));
$items[] = $item;
}
take_items_to_bd($items);
}
