Advertisement
| Hall of Fame |
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553: 554: 555: 556: 557: 558: 559: 560: 561: 562: 563: 564: 565: 566: 567: 568: 569: 570: 571: 572: 573: 574: 575: 576: 577: 578: 579: 580: 581: 582: 583: 584: 585: 586: 587: 588: 589: 590: 591: 592: 593: 594: 595: 596: 597: 598: 599: 600: 601: 602: 603: 604: 605: 606: 607: 608: 609: 610: 611: 612: 613: 614: 615: 616: 617: 618: 619: 620: 621: 622: 623: 624: 625: 626: 627: 628: 629: 630: 631: 632: 633: 634: 635: 636: 637: 638: 639: 640: 641: 642: 643: 644: 645: 646: 647: 648: 649: 650: 651: 652: 653: 654: 655: 656: 657: 658: 659: 660: 661: 662: |
CSS FILE
@charset "utf-8";
/* General Styles */
body {
background-color:#FFFFFF;
margin:0px;
}
a:link,a:visited {
margin-left:2px;
margin-right:4px;
font-family: "Trebuchet MS",Arial;
font-size:14px;
font-weight:bold;
color:#3e3e3e;
text-decoration:none;
}
a:hover {
color:#006699;
text-decoration:underline;
}
p {
font-family:"Trebuchet MS",Tahoma;
font-size: 12px;
color: #3e3e3e;
margin-top:10px;
margin-left:0px;
margin-right:0px;
margin-bottom:0px;
line-height: 20px;
}
/* Table Styles */
.tdTitle {
font-family:"Trebuchet MS";
font-size:14px;
font-weight:bold;
color:#FFFFFF;
text-align:center;
background-image:url(../img/back.gif);
background-repeat:repeat-x;
}
.tdTitleLeft {
font-family:"Trebuchet MS";
font-size:14px;
font-weight:bold;
color:#FFFFFF;
text-align:left;
background-image:url(../img/back.gif);
background-repeat:repeat-x;
}
.tdData {
font-family:"Trebuchet MS";
font-size:12px;
font-weight:bold;
color:#3e3e3e;
text-align:center;
}
.tdDataLeft {
font-family:"Trebuchet MS";
font-size:12px;
font-weight:bold;
color:#3e3e3e;
text-align:left;
}
/* Form Styles */
label {
font-family:"Trebuchet MS",Tahoma;
font-size:12px;
color:#3e3e3e;
font-weight:bold;
margin-left:2px;
margin-bottom:0px;
margin-right:0px;
margin-top:0px;
}
.search {
width:100px;
height:18px;
margin-left:4px;
font-family:"Trebuchet MS";
font-size:12px;
font-weight:bold;
color:#000000;
}
/* Billing Style */
#header {
float:left;
display:block;
width:100%;
height:49px;
margin-left:0px;
margin-right:0px;
margin-bottom:1px;
margin-top:1px;
padding-left:0px;
padding-right:0px;
padding-bottom:2px;
padding-top:0px;
border-bottom:1px solid #CCCCCC;
}
.lftHeader {
float:left;
display:block;
width:165px;
height:49px;
margin-left:0px;
margin-right:0px;
margin-bottom:0px;
margin-top:0px;
padding-left:0px;
padding-right:0px;
padding-bottom:0px;
padding-top:0px;
}
#rgtHeader {
float:right;
display:block;
width:350px;
height:49px;
margin-left:0px;
margin-right:0px;
margin-bottom:0px;
margin-top:0px;
padding-left:0px;
padding-right:0px;
padding-bottom:0px;
padding-top:0px;
}
.lnkhome a {
float:left;
display:block;
width:90px;
margin:2px;
padding-left:30px;
padding-top:3px;
background-image:url(../img/shome.png);
background-position:left;
background-repeat:no-repeat;
font-family:"Trebuchet MS",Arial;
font-size:12px;
font-weight:bold;
color:#3e3e3e;
text-decoration:none;
}
.lnkhome a:hover {
text-decoration:underline;
}
.lnkhelp a {
float:left;
display:block;
width:50px;
margin:2px;
padding-left:30px;
padding-top:3px;
background-image:url(../img/shelp.png);
background-position:left;
background-repeat:no-repeat;
font-family:"Trebuchet MS",Arial;
font-size:12px;
font-weight:bold;
color:#3e3e3e;
text-decoration:none;
}
.lnkhelp a:hover {
text-decoration:underline;
}
.lnkout a {
float:left;
display:block;
width:80px;
margin:2px;
padding-left:30px;
padding-top:3px;
background-image:url(../img/slogout.png);
background-position:left;
background-repeat:no-repeat;
font-family:"Trebuchet MS",Arial;
font-size:12px;
font-weight:bold;
color:#3e3e3e;
text-decoration:none;
}
.lnkout a:hover {
text-decoration:underline;
}
#mainmenu {
float:left;
display:block;
width:120px;
text-align:center;
padding:0px;
margin:0px;
}
#mainmenu a {
display: block;
}
#menu {
float:left;
display:block;
width:110px;
text-align:center;
border:#CCCCCC 1px solid;
margin-left:2px;
margin-right:2px;
margin-bottom:2px;
margin-top:5px;
}
#submenupanel {
float:left;
display:block;
width:750px;
margin-left:5px;
margin-right:1px;
margin-bottom:1px;
margin-top:1px;
padding-left:0px;
padding-right:0px;
padding-bottom:2px;
padding-top:0px;
border:1px solid #CCCCCC;
}
#submenupanel a:link,a:visited {
margin-left:2px;
margin-right:2px;
font-family: "Trebuchet MS",Arial;
font-size:12px;
font-weight:bold;
color:#006699;
text-decoration:none;
}
#submenupanel a:hover {
text-decoration:underline;
}
#searchpanel {
float:left;
display:block;
width:750px;
height:25px;
margin-left:5px;
margin-right:1px;
margin-bottom:0px;
margin-top:1px;
padding-left:0px;
padding-right:0px;
padding-bottom:0px;
padding-top:0px;
border:1px solid #CCCCCC;
}
#subsearch {
float:left;
display:none;
width:750px;
margin-left:5px;
margin-right:1px;
margin-bottom:1px;
margin-top:0px;
padding-left:0px;
padding-right:0px;
padding-bottom:2px;
padding-top:0px;
border-left:1px solid #CCCCCC;
border-bottom:1px solid #CCCCCC;
border-right:1px solid #CCCCCC;
border-top:none;
}
#restrictpanel {
float:left;
display:block;
width:750px;
margin-left:5px;
margin-right:1px;
margin-bottom:1px;
margin-top:1px;
padding-left:0px;
padding-right:0px;
padding-bottom:2px;
padding-top:0px;
border:1px solid #CCCCCC;
}
#msgpanel {
float:left;
display:block;
width:750px;
margin-left:5px;
margin-right:1px;
margin-bottom:1px;
margin-top:1px;
padding-left:0px;
padding-right:0px;
padding-bottom:2px;
padding-top:0px;
border:1px solid #CCCCCC;
}
.msg {
margin-left:3px;
font-family:"Trebuchet MS",Arial;
font-size:14px;
font-weight:bold;
color:#009900;
}
PHP FILE
<?php
include "../conndb.php";
include "../auth.inc.php";
include "../getuserdata.inc.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>UTELbox :: ÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂÃÂÃÂñÃÂÃÂÃÂóÃÂÃÂÃÂî ÃÂÃÂÃÂãÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂÃÂÃÂÃÂÃÂúÃÂÃÂÃÂõÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂÃÂÃÂÃÂÃÂý ::</title>
<link href="restrict.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" language="JavaScript">
function showOnOff(){
var oPanel = document.getElementById("subsearch");
if (oPanel.style.display == "none")
oPanel.style.display = "block";
else
oPanel.style.display = "none";
}
</script>
<script type="text/javascript" language="JavaScript">
function Checkall(form){
for (var i = 1; i < form.elements.length; i++){
eval("form.elements[" + i + "].checked = form.elements[0].checked");
}
}
function checkAllPrefix(prefix, el) {
var els=document.getElementsByTagName("input");
for(var i=0; i<els.length; i++) {
if ("checkbox"==els[i].type && els[i].name.match("^"+prefix)) els[i].checked=el.checked;
}
}
</script>
<script language="javascript" language="JavaScript">
<!--
function changerowBG(el, myColor) {
el.style.background =myColor;
}
//--!>
</script>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5">
<div id="header">
<div class="lftHeader"><img src="../img/uboxlogo.png" alt="UTELbox" width="163" height="49" longdesc="http://www.utelit.com" />
</div>
<div id="rgtHeader"><span class="lnkhome"><a href="../index.php">ÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂùÃÂÃÂÃÂúÃÂÃÂÃÂî ÃÂÃÂÃÂãÃÂÃÂÃÂõÃÂÃÂÃÂûÃÂÃÂÃÂïÃÂÃÂÃÂôÃÂÃÂÃÂñ</a></span><span class="lnkhelp"><a href="../help.php">ÃÂÃÂÃÂÃÂÃÂÃÂÃÂÿÃÂÃÂÃÂîÃÂÃÂÃÂøÃÂÃÂÃÂõÃÂÃÂÃÂùÃÂÃÂÃÂñ</a></span><span class="lnkout"><a href="../logout.php">ÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÿÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂýÃÂÃÂÃÂôÃÂÃÂÃÂõÃÂÃÂÃÂÃÂÃÂÃÂÃÂ÷</a></span></div>
</div>
</td>
</tr>
<tr>
<td width="120" valign="top">
<div id="mainmenu">
<?php
$conn=mysql_connect(SQL_HOST,SQL_USER,SQL_PASS) or die('Could not connect to MySQL database.' . mysqlerror());
$dbname = "utelbox";
mysql_select_db($dbname,$conn);
$sqlmenu = "SELECT vlevel,link,displayname,mnuimage FROM box_menus ORDER BY ordered ASC";
$rsmenu = mysql_query($sqlmenu) or die("Invalid query: " . mysql_error());
while ($rowmnu = mysql_fetch_assoc($rsmenu)) {
$mnulevel = $rowmnu['vlevel'];
$lnk=$rowmnu['link'];
$nam=$rowmnu['displayname'];
$imgsrc=$rowmnu['mnuimage'];
if ($mnulevel<=$usrlevel){
?>
<p>
<a href="<?php echo $lnk ; ?>"><div id="menu">
<p><img src="<?php echo $imgsrc ; ?>" alt="<?php echo $nam ; ?>" width="68" height="60" border="0" longdesc="http://www.utelit.com" /></p>
<p><?php echo $nam ; ?></p>
</div></a>
</p>
<?php
}
}
?>
</div>
</td>
<td width="19"> </td>
<td width="500" valign="top">
<?php
if ($usrlevel==2){
?>
<div id="submenupanel"><a href="settings.php">ÃÂÃÂÃÂáÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂøÃÂÃÂÃÂüÃÂÃÂÃÂïÃÂÃÂÃÂÃÂÃÂÃÂÃÂõÃÂÃÂÃÂùÃÂÃÂÃÂàÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂñÃÂÃÂÃÂÃÂÃÂÃÂÃÂüÃÂÃÂÃÂÿÃÂÃÂÃÂóÃÂÃÂÃÂîÃÂÃÂÃÂÃÂ</a></div>
<?php
}
?>
<!-- Change Extensions -->
<?php
switch ($_GET['act']){
case "chg" :
include "reschange.php";
?>
<div id="msgpannel"><span class="msg"><?php echo $msg ; ?></span></div>
<?php
}
?>
<!-- Search Panel -->
<div id="searchpanel" onclick="showOnOff()"><img src="../img/uboxsearch.png" alt="searchbar" width="750" height="25" border="0" /></div>
<div id="subsearch">
<?php
$conn=mysql_connect(SQL_HOST,SQL_USER,SQL_PASS) or die('Could not connect to MySQL database.' . mysqlerror());
$dbname = "asterisk";
mysql_select_db($dbname,$conn);
$groupext = "SELECT extension,name,directdid FROM users ORDER BY extension";
$resgroup = mysql_query($groupext)
or die("Invalid query: " . mysql_error());
while ($row = mysql_fetch_array($resgroup)) {
$group[$row['extension']] = $row['extension'];
}
?>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form id="form1" name="form1" method="post" action="index.php">
<p><label>ÃÂÃÂÃÂãÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂÃÂÃÂÃÂÃÂúÃÂÃÂÃÂõÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂî</label><input name="txtExtension" type="text" class="search" id="txtExtension" />
<label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂ_ ÃÂÃÂÃÂãÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂÃÂÃÂÃÂÃÂúÃÂÃÂÃÂõÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂî
<select name="fDev" id="fDev">
<option value="" selected="selected">ÃÂÃÂÃÂãÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂÃÂÃÂÃÂÃÂúÃÂÃÂÃÂõÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂî</option>
<?php
foreach ($group as $group_id => $name) {
if ($group_id == $group) {
$selected = " selected";
} else {
$selected = "";
}
?>
<option value="<?php echo $group_id; ?>"><?php echo $name; ?></option>
<?php
}
?>
</select>
</label>
<label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂàÃÂÃÂÃÂãÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂÃÂÃÂÃÂÃÂúÃÂÃÂÃÂõÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂî
<select name="lDev" id="lDev">
<option value="" selected="selected">ÃÂÃÂÃÂãÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂÃÂÃÂÃÂÃÂúÃÂÃÂÃÂõÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂî</option>
<?php
foreach ($group as $group_id => $name) {
if ($group_id == $group) {
$selected = " selected";
} else {
$selected = "";
}
?>
<option value="<?php echo $group_id; ?>"><?php echo $name; ?></option>
<?php
}
?>
</select>
</label>
<input type="submit" name="sShow" id="sShow" value="ÃÂÃÂÃÂÃÂÃÂÃÂÃÂüÃÂÃÂÃÂÃÂÃÂÃÂÃÂìÃÂÃÂÃÂýÃÂÃÂÃÂùÃÂÃÂÃÂÃÂÃÂÃÂÃÂ÷" /></p>
</form>
</td>
</tr>
</table>
</div>
<!-- Restrict Panel -->
<div id="restrictpanel">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="92" class="tdTitle">ÃÂÃÂÃÂãÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂÃÂÃÂÃÂÃÂúÃÂÃÂÃÂõÃÂÃÂÃÂÃÂ
ÃÂÃÂÃÂî</td>
<td width="298" class="tdTitleLeft">ÃÂÃÂÃÂæÃÂÃÂÃÂÃÂÃÂÃÂÃÂñÃÂÃÂÃÂóÃÂÃÂÃÂî</td>
</tr>
<form id="form" name="form" method="post" action="index.php?act=chg">
<tr>
<td width="92" class="tdData" >
<input name="btnSave2" type="submit" class="btnForm" id="btnSave2" value="ÃÂÃÂÃÂÃÂÃÂÃÂÃÂûÃÂÃÂÃÂûÃÂÃÂÃÂñÃÂÃÂÃÂóÃÂÃÂÃÂî" />
</td>
<td width="298"><p><label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂþÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂõÃÂÃÂÃÂÃÂÃÂÃÂÃÂùÃÂÃÂÃÂúÃÂÃÂÃÂÃÂ_</label><input name="chk1a" type="checkbox" id="chk1a" onclick="javascript:checkAllPrefix('chk1',this);" />
<label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂûÃÂÃÂÃÂûÃÂÃÂÃÂìÃÂÃÂÃÂôÃÂÃÂÃÂñ</label><input name="chk2a" type="checkbox" id="chk2a"onclick="javascript:checkAllPrefix('chk2',this);" />
<label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂùÃÂÃÂÃÂýÃÂÃÂÃÂ÷ÃÂÃÂÃÂÃÂÃÂÃÂÃÂì</label><input name="chk4a" type="checkbox" id="chk4a" onclick="javascript:checkAllPrefix('chk4',this);" />
<label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂõÃÂÃÂÃÂÃÂÃÂÃÂÃÂùÃÂÃÂÃÂúÃÂÃÂÃÂì</label><input name="chk8a" type="checkbox" id="chk8a" onclick="javascript:checkAllPrefix('chk8',this);"/>
</p>
</td>
</tr>
<?php
if ($_POST['sShow']!=NULL){
$string = $_POST['txtExtension'];
$min = $_POST['fDev'];
$max = $_POST['lDev'];
if ($string!=NULL) {
$e = explode(",",$string); // no lets explode it using our defined seperator '-'
$firste=$e[0];
$many="";
while (list($index,$value) = each($e)){
$many.=" OR extension = '".$value."' ";
}
if ($min!=NULL and $max!=NULL) {
$min=$min-1;
$max=$max+1;
$sqlextensions = "SELECT extension,name,directdid FROM users WHERE extension > '$min' AND extension < '$max' OR extension = '$firste' ".$many." ORDER BY extension";
}else {
$sqlextensions = "SELECT extension,name,directdid FROM users WHERE extension = '$firste' ".$many." ORDER BY extension";
}
}else{
if ($min!=NULL and $max!=NULL) {
$min=$min-1;
$max=$max+1;
$sqlextensions = "SELECT extension,name,directdid FROM users WHERE extension > '$min' AND extension < '$max' ORDER BY extension";
}else {
$sqlextensions = "SELECT extension,name,directdid FROM users ORDER BY extension";
}
}
}else{
$sqlextensions = "SELECT extension,name,directdid FROM users ORDER BY extension";
}
$i=0;
$resultextensions = mysql_query($sqlextensions) or die("Invalid query: " . mysql_error());
while($row = mysql_fetch_assoc($resultextensions)) {
$i= $i + 1;
$ext = $row['extension'];
$conn=mysql_connect(SQL_HOST,SQL_USER,SQL_PASS) or die('Could not connect to MySQL database.' . mysqlerror());
$dbname = "utelbox";
mysql_select_db($dbname,$conn);
$sqlcomp = "SELECT extension FROM ext_secret WHERE extension = '$ext' ";
$resultcomp = mysql_query($sqlcomp) or die("Invalid query: " . mysql_error());
$j=0;
while($rowcomp = mysql_fetch_assoc($resultcomp)) {
$j=$j+1;
}
if ($j==0){
$conn=mysql_connect(SQL_HOST,SQL_USER,SQL_PASS) or die('Could not connect to MySQL database.' . mysqlerror());
$dbname = "asterisk";
mysql_select_db($dbname,$conn);
$sqlcontext = "SELECT * FROM sip WHERE id = $ext AND keyword = 'context' ";
$resultcontext = mysql_query($sqlcontext) or die("Invalid query: " . mysql_error());
while($row = mysql_fetch_assoc($resultcontext)) {
$context = $row['data'];
}
$conn=mysql_connect(SQL_HOST,SQL_USER,SQL_PASS) or die('Could not connect to MySQL database.' . mysqlerror());
$dbname = "utelbox";
mysql_select_db($dbname,$conn);
$sqlcode = "SELECT * FROM set_rescalls WHERE content = '$context' " ;
$resultcode = mysql_query($sqlcode) or die("Invalid query stefanis: " . mysql_error());
while($row = mysql_fetch_assoc($resultcode)) {
$code = $row['rescode'];
}
if ($code == '0'){
$st1 = "" ;
$st2 = "" ;
$st4 = "" ;
$st8 = "" ;
}else if ($code == '1') {
$st1 = 'checked="checked"' ;
$st2 = "" ;
$st4 = "" ;
$st8 = "" ;
}else if ($code == '2') {
$st1 = "" ;
$st2 = 'checked="checked"' ;
$st4 = "" ;
$st8 = "" ;
}else if ($code == '4') {
$st1 = "" ;
$st2 = "" ;
$st4 = 'checked="checked"' ;
$st8 = "" ;
}else if ($code == '8') {
$st1 = "" ;
$st2 = "" ;
$st4 = "" ;
$st8 = 'checked="checked"' ;
}else if ($code == '3') {
$st1 = 'checked="checked"' ;
$st2 = 'checked="checked"' ;
$st4 = "" ;
$st8 = "" ;
}else if ($code == '5') {
$st1 = 'checked="checked"' ;
$st2 = "" ;
$st4 = 'checked="checked"' ;
$st8 = "" ;
}else if ($code == '9') {
$st1 = 'checked="checked"' ;
$st2 = "" ;
$st4 = "" ;
$st8 = 'checked="checked"' ;
}else if ($code == '6') {
$st1 = "" ;
$st2 = 'checked="checked"' ;
$st4 = 'checked="checked"' ;
$st8 = "" ;
}else if ($code == '10') {
$st1 = "" ;
$st2 = 'checked="checked"' ;
$st4 = "" ;
$st8 = 'checked="checked"' ;
}else if ($code == '12') {
$st1 = "" ;
$st2 = "" ;
$st4 = 'checked="checked"' ;
$st8 = 'checked="checked"' ;
}else if ($code == '7') {
$st1 = 'checked="checked"' ;
$st2 = 'checked="checked"' ;
$st4 = 'checked="checked"' ;
$st8 = "" ;
}else if ($code == '13') {
$st1 = 'checked="checked"' ;
$st2 = "" ;
$st4 = 'checked="checked"' ;
$st8 = 'checked="checked"' ;
}else if ($code == '14') {
$st1 = "" ;
$st2 = 'checked="checked"' ;
$st4 = 'checked="checked"' ;
$st8 = 'checked="checked"' ;
}else if ($code == '11') {
$st1 = 'checked="checked"' ;
$st2 = 'checked="checked"' ;
$st4 = "" ;
$st8 = 'checked="checked"' ;
}else if ($code == '15') {
$st1 = 'checked="checked"' ;
$st2 = 'checked="checked"' ;
$st4 = 'checked="checked"' ;
$st8 = 'checked="checked"' ;
}
?>
<tr onMouseOver="changerowBG(this, '#CCCCCC');" onMouseOut="changerowBG(this, '#FFFFFF');">
<td height="25" class="tdData"><p><?php echo $ext ; ?></p></td>
<td height="25">
<p><label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂþÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂõÃÂÃÂÃÂÃÂÃÂÃÂÃÂùÃÂÃÂÃÂúÃÂÃÂÃÂÃÂ_</label><input name="chk1[<?php echo $i ; ?>]" type="checkbox" id="chk1[<?php echo $i ; ?>]" value="1" <?php echo $st1 ; ?>/>
<label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂûÃÂÃÂÃÂûÃÂÃÂÃÂìÃÂÃÂÃÂôÃÂÃÂÃÂñ</label><input name="chk2[<?php echo $i ; ?>]" type="checkbox" id="chk2[<?php echo $i ; ?>]" value="2" <?php echo $st2 ; ?>/>
<label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂùÃÂÃÂÃÂýÃÂÃÂÃÂ÷ÃÂÃÂÃÂÃÂÃÂÃÂÃÂì</label><input name="chk4[<?php echo $i ; ?>]" type="checkbox" id="chk4[<?php echo $i ; ?>]" value="4" <?php echo $st4 ; ?>/>
<label>ÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂÃÂõÃÂÃÂÃÂÃÂÃÂÃÂÃÂùÃÂÃÂÃÂúÃÂÃÂÃÂì</label><input name="chk8[<?php echo $i ; ?>]" type="checkbox" id="chk8[<?php echo $i ; ?>]" value="8" <?php echo $st8 ; ?>/>
<label></label>
<input type="hidden" name="extension[<?php echo $i ; ?>]" id="extension[<?php echo $i ; ?>]" value="<?php echo $ext ; ?>"/>
<input type="hidden" name="upflag[<?php echo $i ; ?>]" id="upflag[<?php echo $i ; ?>]" value="<?php echo $ext ; ?>"/>
</p> </td>
</tr>
<?php
}
}
?>
<input type="hidden" name="count" id="count" value="<?php echo $i ; ?>"/>
<tr>
<td width="92" class="tdData"><input name="btnSave" type="submit" id="btnSave" value="ÃÂÃÂÃÂÃÂÃÂÃÂÃÂûÃÂÃÂÃÂûÃÂÃÂÃÂñÃÂÃÂÃÂóÃÂÃÂÃÂî" /></td>
<td width="298"><label></label></td>
</tr>
</form>
</table>
</div>
</td>
<td width="19"> </td>
<td> </td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
</table>
</body>
</html>
|