PageRenderTime 45ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/functions/admin_editstaff.php

https://bitbucket.org/verax/to-ladder
PHP | 545 lines | 498 code | 43 blank | 4 comment | 28 complexity | 7f23f478cac86d34761b41e0fda5ed93 MD5 | raw file
  1. <?
  2. if(!IsSet($indexloaded)){
  3. header("Location: ./index.php");
  4. }
  5. //CHECK ADMIN ACCESS LEVEL
  6. if($admn[access] < 65){
  7. include("$dir[func]/error.php");
  8. display_error("You are not allowed to perform this function.<br>");
  9. }
  10. function get_rights($giversrights,$currentrights){
  11. $selected[$currentrights]="SELECTED";
  12. $getrights="
  13. <option value='0' $selected[0]>Cant Login</option>
  14. <option value='5' $selected[5]>Resend/Delete Validations</option>
  15. <option value='10' $selected[10]>Create Teams</option>
  16. <option value='15' $selected[15]>Edit Teams</option>
  17. <option value='20' $selected[20]>Delete Teams</option>
  18. <option value='25' $selected[25]>Report Match</option>
  19. <option value='30' $selected[30]>Edit/Delete Match</option>
  20. <option value='35' $selected[35]>Delete Challenges</option>
  21. <option value='40' $selected[40]>Edit Players</option>
  22. <option value='45' $selected[45]>Edit Players Pass</option>
  23. <option value='50' $selected[50]>Delete Players</option>
  24. <option value='55' $selected[55]>Manage Maps</option>
  25. <option value='60' $selected[60]>Manage Rules</option>
  26. <option value='63' $selected[63]>Manage Tournaments</option>
  27. <option value='65' $selected[65]>Manage Staff</option>";
  28. if($giversrights >= 70){$getrights=$getrights."<option value='70' $selected[70]>Manage all Maps</option>";}
  29. if($giversrights >= 75){$getrights=$getrights."<option value='75' $selected[75]>Manage all Rules</option>";}
  30. if($giversrights >= 80){$getrights=$getrights."<option value='80' $selected[80]>Manage all Staff</option>";}
  31. if($giversrights >= 85){$getrights=$getrights."<option value='85' $selected[85]>Manage Faq/Files</option>";}
  32. if($giversrights >= 90){$getrights=$getrights."<option value='90' $selected[90]>Manage Ladders</option>";}
  33. if($giversrights >= 95){$getrights=$getrights."<option value='95' $selected[95]>Manage Games</option>";}
  34. if($giversrights >= 99){$getrights=$getrights."<option value='99' $selected[99]>Master God Mode</option>";}
  35. return($getrights);
  36. }
  37. function admin_editstaff(){
  38. global $dir, $url, $out, $site, $admn;
  39. $thestaff=mysql_query("SELECT id,displayname,access,addedby FROM staff ORDER by displayname");
  40. while(list($id,$name,$access,$addedby)=mysql_fetch_row($thestaff)){
  41. if($access <= $admn[access]){
  42. if($admn[access] < 80){
  43. $gotname=0;
  44. $staffladders=mysql_query("SELECT ladderid FROM staffaccess WHERE staffid='$admn[id]'");
  45. while(list($lid)=mysql_fetch_row($staffladders)){
  46. if(!$gotname){
  47. if(mysql_num_rows(mysql_query("SELECT ladderid FROM staffaccess WHERE staffid='$id' AND ladderid='$lid'")) > 0){
  48. $staffmembers=$staffmembers."<option value='$id'>$name</option>";
  49. $howmanyeditable=1;
  50. $gotname=1;
  51. }
  52. }
  53. }
  54. }else{
  55. $staffmembers=$staffmembers."<option value='$id'>$name</option>";
  56. $howmanyeditable=1;
  57. }
  58. }
  59. }
  60. if(!$howmanyeditable){
  61. include("$dir[func]/error.php");
  62. display_error("There are no staff accounts to edit.<br>");
  63. }
  64. $tablehead=table_head("show","100%","","center");
  65. $tablefoot=table_foot("show");
  66. $bannerhead=table_head("show","488","80","center");
  67. $bannerfoot=table_foot("show");
  68. $out[body]=$out[body]."
  69. <center>
  70. $bannerhead
  71. $out[banner]
  72. $bannerfoot
  73. </center>
  74. <br>
  75. <table width='100%' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>
  76. <tr class='altcolor'>
  77. <form method='post'>
  78. <td width='100%' valign='top' align='center'>
  79. <strong>Edit Staff</strong><br>
  80. </td>
  81. </tr>
  82. <tr>
  83. <td width='100%' valign='center' align='center'>
  84. <br>
  85. <select name='staffid'>$staffmembers</select><br>
  86. <br></td>
  87. </tr>
  88. <tr class='altcolor'>
  89. <script language='javascript'>var confirmdelete='Are you sure you want to DELETE this Staff Member';</script>
  90. <td width='100%' valign='top' align='center'>
  91. <input type='hidden' name='action' value='editstaffb'>
  92. <input type='submit' name='todo' value='Edit Staff'>
  93. <input type='submit' name='todo' value='Delete Staff'>
  94. </td>
  95. </form>
  96. </tr>
  97. </table>
  98. <br><center>";
  99. include("$dir[curtheme]");
  100. }
  101. function admin_editstaffb($staffid,$todo){
  102. global $dir, $url, $out, $site, $admn;
  103. if(!$staffid){
  104. include("$dir[func]/error.php");
  105. display_error("Invalid Staff ID.<br>");
  106. }
  107. if($todo=="Edit Staff"){
  108. edit_staffmember($staffid);
  109. }
  110. else if($todo=="Delete Staff"){
  111. delete_staff($staffid);
  112. }
  113. else{
  114. include("$dir[func]/error.php");
  115. display_error("Unknown Command.<br>");
  116. }
  117. }
  118. function edit_staffmember($staffid){
  119. global $dir, $url, $out, $site, $admn;
  120. //TABLE ATERNATING COLORS
  121. $altcolora="#000033";
  122. $altcolorb="#000020";
  123. $result=mysql_query("SELECT * FROM staff WHERE id='$staffid' AND access <='$admn[access]'");
  124. $staff=mysql_fetch_array($result);
  125. if(!$staff[id]){
  126. include("$dir[func]/error.php");
  127. display_error("Unable to edit that Staff Member");
  128. }
  129. $selected="";
  130. $value="";
  131. $value=$staff[country];
  132. $selected[$value]="SELECTED";
  133. $tablehead=table_head("show","100%","","center");
  134. $tablefoot=table_foot("show");
  135. $bannerhead=table_head("show","488","80","center");
  136. $bannerfoot=table_foot("show");
  137. $out[body]=$out[body]."
  138. <center>
  139. $bannerhead
  140. $out[banner]
  141. $bannerfoot
  142. </center>
  143. <br>
  144. <table width='100%' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>
  145. <tr class='altcolor'>
  146. <td width='100%' valign='top' align='center'>
  147. <strong>Edit Staff - [$staffid] $staff[displayname]</strong></td>
  148. </tr>
  149. <tr>
  150. <td width='100%' valign='top' align='left'>
  151. <form method='post'>
  152. <table width='100%' border='0' cellspacing='0' cellpadding='0' valign='top' align='center'>
  153. <tr class='altcolora'>
  154. <td width='50%' valign='center' align='left'>
  155. <font face='veradna,arial' size='2' color='#FFFFFF'>Display Name</font></td>
  156. <td width='50%' valign='center' align='center'>
  157. <input type='text' name='s_name' value='$staff[displayname]' size='30' maxlength='25'></td>
  158. </tr>
  159. <tr class='altcolorb'>
  160. <td width='50%' valign='center' align='left'>
  161. <font face='veradna,arial' size='2' color='#FFFFFF'>Password</font></td>
  162. <td width='50%' valign='center' align='center'>
  163. <input type='password' name='s_pass' value='$staff[pass]' size='30' maxlength='25'></td>
  164. </tr>
  165. <tr class='altcolora'>
  166. <td width='50%' valign='center' align='left'>
  167. <font face='veradna,arial' size='2' color='#FFFFFF'>Email</font></td>
  168. <td width='50%' valign='center' align='center'>
  169. <input type='text' name='s_email' value='$staff[email]' size='30' maxlength='100'></td>
  170. </tr>
  171. <tr class='altcolorb'>
  172. <td width='50%' valign='center' align='left'>
  173. <font face='veradna,arial' size='2' color='#FFFFFF'>Title</font></td>
  174. <td width='50%' valign='center' align='center'>
  175. <input type='text' name='s_title' value='$staff[title]' size='30' maxlength='25'></td>
  176. </tr>
  177. <tr class='altcolorb'>
  178. <td width='50%' valign='center' align='left'>
  179. <font face='veradna,arial' size='2' color='#FFFFFF'>Country</font></td>
  180. <td width='50%' valign='center' align='center'>
  181. <select name='p_country'>
  182. <option value='AF' $selected[AF]>Afghanistan
  183. <option value='AL' $selected[AL]>Albania
  184. <option value='DZ' $selected[DZ]>Algeria
  185. <option value='AD' $selected[AD]>Andorra
  186. <option value='AO' $selected[AO]>Angola
  187. <option value='AG' $selected[AG]>Antigua and Barbuda
  188. <option value='AR' $selected[AR]>Argentina
  189. <option value='AM' $selected[AM]>Armenia
  190. <option value='AU' $selected[AU]>Australia
  191. <option value='AT' $selected[AT]>Austria
  192. <option value='AZ' $selected[AZ]>Azerbaijan
  193. <option value='BS' $selected[BS]>Bahamas
  194. <option value='BH' $selected[BH]>Bahrain
  195. <option value='BD' $selected[BD]>Bangladesh
  196. <option value='BB' $selected[BB]>Barbados
  197. <option value='BY' $selected[BY]>Belarus
  198. <option value='BE' $selected[BE]>Belgium
  199. <option value='BZ' $selected[BZ]>Belize
  200. <option value='BJ' $selected[BJ]>Benin
  201. <option value='BT' $selected[BT]>Bhutan
  202. <option value='BO' $selected[BO]>Bolivia
  203. <option value='BA' $selected[BA]>Bosnia Herzegovina
  204. <option value='BW' $selected[BW]>Botswana
  205. <option value='BR' $selected[BR]>Brazil
  206. <option value='BN' $selected[BN]>Brunei
  207. <option value='BG' $selected[BG]>Bulgaria
  208. <option value='BF' $selected[BF]>Burkina Faso
  209. <option value='BM' $selected[BM]>Burma
  210. <option value='BI' $selected[BI]>Burundi
  211. <option value='KH' $selected[KH]>Cambodia
  212. <option value='CM' $selected[CM]>Cameroon
  213. <option value='CA' $selected[CA]>Canada
  214. <option value='CF' $selected[CF]>Central African Republic
  215. <option value='TD' $selected[TD]>Chad
  216. <option value='CL' $selected[CL]>Chile
  217. <option value='CN' $selected[CN]>China
  218. <option value='CX' $selected[CX]>Christmas Island
  219. <option value='CO' $selected[CO]>Colombia
  220. <option value='KM' $selected[KM]>Comoros
  221. <option value='CG' $selected[CG]>Congo
  222. <option value='CR' $selected[CR]>Costa Rica
  223. <option value='HR' $selected[HR]>Croatia
  224. <option value='CU' $selected[CU]>Cuba
  225. <option value='CY' $selected[CY]>Cyprus
  226. <option value='CZ' $selected[CZ]>Czech Republic
  227. <option value='DC' $selected[DC]>Democratic Rep. Congo
  228. <option value='DK' $selected[DK]>Denmark
  229. <option value='DJ' $selected[DJ]>Djibouti
  230. <option value='DM' $selected[DM]>Dominica
  231. <option value='DO' $selected[DO]>Dominican Republic
  232. <option value='EC' $selected[EC]>Ecuador
  233. <option value='EG' $selected[EG]>Egypt
  234. <option value='SV' $selected[SV]>El Salvador
  235. <option value='GQ' $selected[GQ]>Equatorial Guinea
  236. <option value='ER' $selected[ER]>Eritrea
  237. <option value='EE' $selected[EE]>Estonia
  238. <option value='ET' $selected[ET]>Ethiopia
  239. <option value='EU' $selected[EU]>European Union
  240. <option value='FS' $selected[FS]>Fed. States Micronesia
  241. <option value='FJ' $selected[FJ]>Fiji
  242. <option value='FI' $selected[FI]>Finland
  243. <option value='FR' $selected[FR]>France
  244. <option value='GA' $selected[GA]>Gabon
  245. <option value='GM' $selected[GM]>Gambia
  246. <option value='GE' $selected[GE]>Georgia
  247. <option value='DE' $selected[DE]>Germany
  248. <option value='GH' $selected[GH]>Ghana
  249. <option value='GR' $selected[GR]>Greece
  250. <option value='GD' $selected[GD]>Grenada
  251. <option value='GT' $selected[GT]>Guatemala
  252. <option value='GN' $selected[GN]>Guinea
  253. <option value='GW' $selected[GW]>Guinea-Bissau
  254. <option value='GY' $selected[GY]>Guyana
  255. <option value='HT' $selected[HT]>Haiti
  256. <option value='HN' $selected[HN]>Honduras
  257. <option value='HK' $selected[HK]>Hong Kong
  258. <option value='HU' $selected[HU]>Hungary
  259. <option value='IS' $selected[IS]>Iceland
  260. <option value='IN' $selected[IN]>India
  261. <option value='ID' $selected[ID]>Indonesia
  262. <option value='IR' $selected[IR]>Iran
  263. <option value='IQ' $selected[IQ]>Iraq
  264. <option value='IE' $selected[IE]>Ireland
  265. <option value='IL' $selected[IL]>Israel
  266. <option value='IT' $selected[IT]>Italy
  267. <option value='IV' $selected[IV]>Ivory Coast
  268. <option value='JM' $selected[JM]>Jamaica
  269. <option value='JP' $selected[JP]>Japan
  270. <option value='JO' $selected[JO]>Jordan
  271. <option value='KZ' $selected[KZ]>Kazakhstan
  272. <option value='KE' $selected[KE]>Kenya
  273. <option value='KI' $selected[KI]>Kiribati
  274. <option value='KW' $selected[KW]>Kuwait
  275. <option value='KG' $selected[KG]>Kyrgyzstan
  276. <option value='LA' $selected[LA]>Laos
  277. <option value='LV' $selected[LV]>Latvia
  278. <option value='LB' $selected[LB]>Lebanon
  279. <option value='LR' $selected[LR]>Liberia
  280. <option value='LY' $selected[LY]>Libya
  281. <option value='LI' $selected[LI]>Liechtenstein
  282. <option value='LT' $selected[LT]>Lithuania
  283. <option value='LU' $selected[LU]>Luxembourg
  284. <option value='MO' $selected[MO]>Macau
  285. <option value='MK' $selected[MK]>Macedonia
  286. <option value='MG' $selected[MG]>Madagascar
  287. <option value='MW' $selected[MW]>Malawi
  288. <option value='MY' $selected[MY]>Malaysia
  289. <option value='MV' $selected[MV]>Maldives
  290. <option value='ML' $selected[ML]>Mali
  291. <option value='MT' $selected[MT]>Malta
  292. <option value='MR' $selected[MR]>Mauritania
  293. <option value='MU' $selected[MU]>Mauritius
  294. <option value='MX' $selected[MX]>Mexico
  295. <option value='MD' $selected[MD]>Moldova
  296. <option value='MC' $selected[MC]>Monaco
  297. <option value='MN' $selected[MN]>Mongolia
  298. <option value='MA' $selected[MA]>Morocco
  299. <option value='MZ' $selected[MZ]>Mozambique
  300. <option value='NA' $selected[NA]>Namibia
  301. <option value='NR' $selected[NR]>Nauru
  302. <option value='NP' $selected[NP]>Nepal
  303. <option value='NL' $selected[NL]>Netherlands
  304. <option value='AN' $selected[AN]>Netherlands Antilles
  305. <option value='NZ' $selected[NZ]>New Zealand
  306. <option value='NI' $selected[NI]>Nicaragua
  307. <option value='NE' $selected[NE]>Niger
  308. <option value='NG' $selected[NG]>Nigeria
  309. <option value='NK' $selected[NK]>North Korea
  310. <option value='NO' $selected[NO]>Norway
  311. <option value='OM' $selected[OM]>Oman
  312. <option value='PK' $selected[PK]>Pakistan
  313. <option value='PA' $selected[PA]>Panama
  314. <option value='PG' $selected[PG]>Papua New Guinea
  315. <option value='PY' $selected[PY]>Paraguay
  316. <option value='PE' $selected[PE]>Peru
  317. <option value='PH' $selected[PH]>Philippines
  318. <option value='PL' $selected[PL]>Poland
  319. <option value='PT' $selected[PT]>Portugal
  320. <option value='PR' $selected[PR]>Puerto Rico
  321. <option value='QA' $selected[QA]>Qatar
  322. <option value='RO' $selected[RO]>Romania
  323. <option value='RU' $selected[RU]>Russia
  324. <option value='RW' $selected[RW]>Rwanda
  325. <option value='KN' $selected[KN]>Saint Kitts and Nevis
  326. <option value='LC' $selected[LC]>Saint Lucia
  327. <option value='VC' $selected[VC]>Saint Vincent/Grenadines
  328. <option value='ST' $selected[ST]>Sao Tome and Principe
  329. <option value='SA' $selected[SA]>Saudi Arabia
  330. <option value='SN' $selected[SN]>Senegal
  331. <option value='SC' $selected[SC]>Seychelles
  332. <option value='SL' $selected[SL]>Sierra Leone
  333. <option value='SG' $selected[SG]>Singapore
  334. <option value='SK' $selected[SK]>Slovakia
  335. <option value='SI' $selected[SI]>Slovenia
  336. <option value='SB' $selected[SB]>Solomon Islands
  337. <option value='SO' $selected[SO]>Somalia
  338. <option value='ZA' $selected[ZA]>South Africa
  339. <option value='KS' $selected[KS]>South Korea
  340. <option value='ES' $selected[ES]>Spain
  341. <option value='LK' $selected[LK]>Sri Lanka
  342. <option value='SD' $selected[SD]>Sudan
  343. <option value='SR' $selected[SR]>Suriname
  344. <option value='SE' $selected[SE]>Sweden
  345. <option value='CH' $selected[CH]>Switzerland
  346. <option value='SY' $selected[SY]>Syria
  347. <option value='TW' $selected[TW]>Taiwan
  348. <option value='TJ' $selected[TJ]>Tajikistan
  349. <option value='TZ' $selected[TZ]>Tanzania
  350. <option value='TH' $selected[TH]>Thailand
  351. <option value='TG' $selected[TG]>Togo
  352. <option value='TO' $selected[TO]>Tonga
  353. <option value='TT' $selected[TT]>Trinidad and Tobago
  354. <option value='TN' $selected[TN]>Tunisia
  355. <option value='TR' $selected[TR]>Turkey
  356. <option value='TM' $selected[TM]>Turkmenistan
  357. <option value='TV' $selected[TV]>Tuvalu
  358. <option value='UG' $selected[UG]>Uganda
  359. <option value='UA' $selected[UA]>Ukraine
  360. <option value='AE' $selected[AE]>United Arab Emirates
  361. <option value='GB' $selected[GB]>United Kingdom
  362. <option value='US' $selected[US]>United States Of America
  363. <option value='UY' $selected[UY]>Uruguay
  364. <option value='UZ' $selected[UZ]>Uzbekistan
  365. <option value='VU' $selected[VU]>Vanuatu
  366. <option value='VE' $selected[VE]>Venezuela
  367. <option value='VN' $selected[VN]>Viet Nam
  368. <option value='EH' $selected[EH]>Western Samoa
  369. <option value='YE' $selected[YE]>Yemen
  370. <option value='YU' $selected[YU]>Yugoslavia
  371. <option value='ZM' $selected[ZM]>Zambia
  372. <option value='ZW' $selected[ZW]>Zimbabwe
  373. </select>
  374. </td>
  375. </tr>
  376. <tr class='altcolora'>
  377. <td width='50%' valign='center' align='left'>
  378. <font face='veradna,arial' size='2' color='#FFFFFF'>Contact Icq/Aim</font></td>
  379. <td width='50%' valign='center' align='center'>
  380. <input type='text' name='s_contact' value='$staff[contact]' size='30' maxlength='25'></td>
  381. </tr>
  382. <tr class='altcolorb'>
  383. <td width='50%' valign='center' align='left'>
  384. <font face='veradna,arial' size='2' color='#FFFFFF'>Access</font></td>
  385. <td width='50%' valign='center' align='center'>
  386. <select name='s_access'>";
  387. $getrights=get_rights($admn[access],$staff[access]);
  388. $out[body]=$out[body]."$getrights
  389. </select></td>
  390. </tr></td>
  391. </tr>
  392. </table>
  393. </td>
  394. </tr>
  395. <tr class='altcolor'>
  396. <td width='100%' valign='top' align='center'>
  397. <strong>Ladders</strong><br>
  398. </td>
  399. </tr>
  400. <tr>
  401. <td width='100%' valign='center' align='center'>
  402. <table width='100%' border='0' cellspacing='0' cellpadding='0'>
  403. ";
  404. //GET LADDERS
  405. $ladderslist=mysql_query("SELECT id,laddername FROM ladders ORDER by laddername");
  406. while(list($id,$name)=mysql_fetch_row($ladderslist)){
  407. if((mysql_num_rows(mysql_query("SELECT staffid FROM staffaccess WHERE staffid ='$admn[id]' AND ladderid='$id' OR staffid ='$staffid' AND ladderid='$id'")) > 0) || ($admn[access] >= 80)){
  408. if(mysql_num_rows(mysql_query("SELECT staffid FROM staffaccess WHERE staffid ='$staffid' AND ladderid='$id'")) > 0){
  409. $checkeda="CHECKED";
  410. $checkedb="";
  411. }else{
  412. $checkeda="";
  413. $checkedb="CHECKED";
  414. }
  415. if($altladrow=="$altcolora"){
  416. $altladrow="$altcolorb";
  417. }else{
  418. $altladrow="$altcolora";
  419. }
  420. $out[body]=$out[body]."
  421. <tr bgcolor='$altladrow'>
  422. <td width='50%' valign='center' align='left'>
  423. $name</font></td>
  424. <td width='50%' valign='center' align='center'>
  425. Yes <input type='radio' name='ladders[$id]' value='1' $checkeda>
  426. No <input type='radio' name='ladders[$id]' value='0' $checkedb></td>
  427. </tr>";
  428. $howmanyeditable=1;
  429. }
  430. }
  431. $out[body]=$out[body]."</table>
  432. </td>
  433. </tr>
  434. <tr class='altcolor'>
  435. <td width='100%' valign='top' align='center'>
  436. <input type='hidden' name='action' value='editstaffc'>
  437. <input type='hidden' name='staffid' value='$staffid'>
  438. <input type='submit' name='' value='Edit Staff'>
  439. <input type='reset' name='' value='Reset'></td>
  440. </form>
  441. </tr>
  442. </table>";
  443. include("$dir[curtheme]");
  444. }
  445. function admin_editstaffc($staffid,$s_name,$s_pass,$s_email,$s_title,$s_country,$s_contact,$s_access,$ladders){
  446. global $dir, $url, $out, $site, $admn;
  447. include("$dir[func]/checkdata.php");
  448. $s_name=change_charecters($s_name);
  449. $s_pass=change_charecters($s_pass);
  450. $s_email=change_charecters($s_email);
  451. $s_title=change_charecters($s_title);
  452. $s_contact=change_charecters($s_contact);
  453. $s_access=change_numbersonly($s_access);
  454. $errormessage=check_validlength($errormessage, $s_name, "3", "50", "Staff names must be 3-25 characters.");
  455. $errormessage=check_validlength($errormessage, $s_pass, "2", "25", "Staff passwords must be 2-10 characters.");
  456. $errormessage=check_validlength($errormessage, $s_title, "3", "25", "Staff titles must be 3-25 characters.");
  457. $errormessage=check_staffexistother($errormessage, $s_name, $staffid);
  458. $errormessage=check_givestaffrights($errormessage, $s_access);
  459. error_check($errormessage);
  460. //DONT ALLOW SELF ACCESS EDITING
  461. if($staffid=="$admn[id]"){
  462. $s_access="$admn[access]";
  463. }
  464. $tday=date("Y-m-d H:i:s");
  465. mysql_query("UPDATE staff SET
  466. displayname='$s_name',
  467. pass='$s_pass',
  468. email='$s_email',
  469. title='$s_title',
  470. access='$s_access',
  471. contact='$s_contact',
  472. lasteditby='$admn[id]',
  473. lastedit='$tday'
  474. WHERE id='$staffid'");
  475. if($ladders){
  476. while(list($ladder,$value)=each($ladders)){
  477. if (mysql_num_rows(mysql_query("SELECT staffid FROM staffaccess WHERE staffid='$staffid' AND ladderid='$ladder'")) > 0){
  478. if(!$value){
  479. mysql_query("DELETE from staffaccess WHERE staffid='$staffid' AND ladderid='$ladder'");
  480. }
  481. }else{
  482. if($value){
  483. mysql_query("INSERT INTO staffaccess VALUES (
  484. '$staffid',
  485. '$ladder',
  486. '0',
  487. '$tday');");
  488. }
  489. }
  490. }
  491. }
  492. include("$dir[func]/admin_finishmessage.php");
  493. display_message("The staff member was updated.<br>");
  494. }
  495. function delete_staff($staffid){
  496. global $dir;
  497. mysql_query("DELETE FROM staffaccess WHERE staffid='$staffid'");
  498. mysql_query("DELETE FROM staff WHERE id='$staffid'");
  499. include("$dir[func]/admin_finishmessage.php");
  500. display_message("The staff member was deleted.<br>");
  501. }
  502. ?>