Advertisement
Guest User

Cerberus Administrator Module

a guest
Jun 17th, 2019
256
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.44 KB | None | 0 0
  1. <?php
  2. /*
  3. ===========================================================================================
  4. + Cerberus Content Management System.
  5. + ---
  6. + - Author : Gary Christopher Johnson
  7. + - E-Mail : TinkeSoftware@Protonmail.com // GCJohnsonChevalier@Protonmail.com
  8. + - Company: Tinke Software
  9. + - Notes : Please view this file in Notepad or similar for proper indentation display
  10. + ---
  11. +
  12. +
  13. +
  14. +
  15. +
  16. +
  17. +
  18. +
  19. +
  20. +
  21. +
  22. + ---
  23. + - File Location: root->Module->Administration->Administrators
  24. + - File Version: 0.4 - Sunday, March, 24, 2019
  25. + ---
  26. +%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
  27. +%%%()()%%()()()%%()()()%%()()()%%()()()%%()()()%%()%%()%%%%%%()()()%%%%%%%%%%%%
  28. +%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
  29. +%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
  30. +%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
  31. +%%()%%%%%()()()%%()()()%%()()()%%()()()%%()()()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
  32. +%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%%%%%
  33. +%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%/-\%
  34. +%%()%%%%%()%%%%%%()%%()%%()%%()%%()%%%%%%()%%()%%()%%()%%%%%%()%%%%%%%%%%%%|4|% ~ Wyn ~
  35. +%%%()()%%()()()%%()%%()%%()()()%%()()()%%()%%()%%()()()%%()()()%%%%%%%%%%%%\-/% Build 0.6
  36. ===========================================================================================
  37. */
  38.  
  39. /*
  40. ===========================
  41. +
  42. +
  43. + Registered Members Management
  44. +
  45. +
  46. ===========================
  47. */
  48.  
  49. /*
  50. ===========================
  51. +
  52. + Fetch Member SQL Rows
  53. +
  54. ===========================
  55. */
  56.  
  57. $_Module_Administrators_DB_Query_Fetch_Member_UserName = $DB->query("SELECT * FROM {$_ACCESS_DATABASE_PREFIX}_members ORDER BY member_username ASC");
  58.  
  59. /*
  60. ===========================
  61. +
  62. + Post Data Variables
  63. +
  64. ===========================
  65. */
  66.  
  67. $_Module_Administrators_POST_MEMBER_ID = $_POST['Module_Administrators_Form_Member_ID'];
  68.  
  69. /*
  70. ===========================
  71. +
  72. + Member ID Selection Form
  73. +
  74. ===========================
  75. */
  76.  
  77. echo ("
  78. <CENTER><B>Member Management</B></CENTER><HR>
  79. <FORM ACTION=\"?$_INTERNAL_ADMINISTRATOR_MODULE&#61;cPanel&amp;Action&#61;Administrators\" METHOD=\"POST\">
  80. Member Name and Member ID Number:<BR>
  81. <SELECT NAME=\"Module_Administrators_Form_Member_ID\">
  82. ");
  83.  
  84. /*
  85. ===========================
  86. + Listing All IDs In Option Value
  87. ===========================
  88. */
  89.  
  90. while ($_Module_Administrators_DB_Query_Fetch_Member_UserName_Array = $DB->fetch_array($_Module_Administrators_DB_Query_Fetch_Member_UserName)) {
  91.  
  92. /*
  93. ===========================
  94. + SQL Data Array Variables
  95. ===========================
  96. */
  97.  
  98. $_Module_Administrators_SQL_MEMBER_ID = $_Module_Administrators_DB_Query_Fetch_Member_UserName_Array['id'];
  99. $_Module_Administrators_SQL_MEMBER_USERNAME = $_Module_Administrators_DB_Query_Fetch_Member_UserName_Array['member_username'];
  100.  
  101. echo ("
  102. <OPTION VALUE=\"$_Module_Administrators_SQL_MEMBER_ID\">Member Name: $_Module_Administrators_SQL_MEMBER_USERNAME :: Member ID: $_Module_Administrators_SQL_MEMBER_ID</OPTION>
  103. ");
  104.  
  105. } // [ + ] WHILE_MEMBERS_SQL
  106.  
  107. /*
  108. ===========================
  109. + Kill Database Connection
  110. ===========================
  111. */
  112.  
  113. $DB->free($_Module_Administrators_DB_Query_Fetch_Member_UserName);
  114.  
  115. echo ("
  116. </SELECT><BR>
  117. <INPUT TYPE=\"SUBMIT\" VALUE=\"Manage Selected Member ID\">
  118. </FORM><BR>
  119. ");
  120.  
  121. /*
  122. ===========================
  123. +
  124. + Modify Member ID Form
  125. +
  126. ===========================
  127. */
  128.  
  129. /*
  130. ===========================
  131. + Form Post Data Variables
  132. ===========================
  133. */
  134.  
  135. $_Module_Administrators_POST_MEMBER_ID_2 = $_POST['Module_Administrators_Form_Member_ID_2'];
  136. $_Module_Administrators_POST_MEMBER_OPTION_ACCESS_LEVEL = $_POST['Module_Administrators_Form_Member_Access'];
  137. $_Module_Administrators_POST_MEMBER_OPTION_BANNED_STATUS = $_POST['Module_Administrators_Form_Member_Banned'];
  138. $_Module_Administrators_POST_MEMBER_OPTION_EMAIL_ADDRESS = $_POST['Module_Administrators_Form_Member_EMail'];
  139. $_Module_Administrators_POST_MEMBER_OPTION_EXPERIENCE_AMOUNT = $_POST['Module_Administrators_Form_Member_Experience'];
  140. $_Module_Administrators_POST_MEMBER_OPTION_FIRST_NAME = $_POST['Module_Administrators_Form_Member_First_Name'];
  141. $_Module_Administrators_POST_MEMBER_OPTION_LAST_NAME = $_POST['Module_Administrators_Form_Member_Last_Name'];
  142. $_Module_Administrators_POST_MEMBER_OPTION_NUMBER_OF_POSTS = $_POST['Module_Administrators_Form_Member_Number_Of_Posts'];
  143. $_Module_Administrators_POST_MEMBER_OPTION_PASSWORD = $_POST['Module_Administrators_Form_Member_Password'];
  144. $_Module_Administrators_POST_MEMBER_OPTION_PASSWORD_HASHED = password_hash($_Module_Administrators_POST_MEMBER_OPTION_PASSWORD, PASSWORD_BCRYPT);
  145. $_Module_Administrators_POST_MEMBER_OPTION_RANK = $_POST['Module_Administrators_Form_Member_Rank'];
  146.  
  147. /*
  148. ===========================
  149. + If Form Has Not Posted, Show Form
  150. ===========================
  151. */
  152.  
  153. if (!$_Module_Administrators_POST_MEMBER_ID_2) {
  154.  
  155. /*
  156. ===========================
  157. +
  158. + Fetch Member ID SQL Data
  159. +
  160. ===========================
  161. */
  162.  
  163. /*
  164. ===========================
  165. + Database Queries
  166. ===========================
  167. */
  168.  
  169. $_Module_Administrators_DB_Query_Fetch_Member_ID = $DB->query("SELECT * FROM {$_ACCESS_DATABASE_PREFIX}_members WHERE id='$_Module_Administrators_POST_MEMBER_ID'");
  170.  
  171. while ($_Module_Administrators_DB_Query_Fetch_Member_ID_Array = $DB->fetch_array($_Module_Administrators_DB_Query_Fetch_Member_ID)) {
  172.  
  173. /*
  174. ===========================
  175. + Member Table Array Variables
  176. ===========================
  177. */
  178.  
  179. $_Module_Administrators_LIST_MEMBER_ID = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['id'];
  180. $_Module_Administrators_LIST_MEMBER_ACCESS_LEVEL = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['member_access_level'];
  181. $_Module_Administrators_LIST_MEMBER_BANNED_STATUS = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['member_banned_status'];
  182. $_Module_Administrators_LIST_MEMBER_EMAIL_ADDRESS = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['member_email_address'];
  183. $_Module_Administrators_LIST_MEMBER_EXPERIENCE_AMOUNT = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['member_experience_amount'];
  184. $_Module_Administrators_LIST_MEMBER_FIRST_NAME = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['member_first_name'];
  185. $_Module_Administrators_LIST_MEMBER_LAST_NAME = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['member_last_name'];
  186. $_Module_Administrators_LIST_MEMBER_USERNAME = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['member_username'];
  187. $_Module_Administrators_LIST_MEMBER_NUMBER_OF_POSTS = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['member_number_of_posts'];
  188. $_Module_Administrators_LIST_MEMBER_RANK = $_Module_Administrators_DB_Query_Fetch_Member_ID_Array['member_rank'];
  189.  
  190. /*
  191. ===========================
  192. + List Selected Member ID Data Form
  193. ===========================
  194. */
  195.  
  196. echo ("
  197. <BR><HR>
  198. <CENTER><B>Currently Modifying Member</B>: <I><A HREF=\"?$_INTERNAL_USER_MODULE&#61;Profile&amp;Name&#61;$_Module_Administrators_LIST_MEMBER_USERNAME\" TITLE=\"View Profile For Registered Member :: $_Module_Administrators_LIST_MEMBER_USERNAME\" TARGET=\"_NEW\">$_Module_Administrators_LIST_MEMBER_USERNAME :: $_Module_Administrators_LIST_MEMBER_ID</A></I></CENTER>
  199. <HR>
  200. <FORM ACTION=\"?$_INTERNAL_ADMINISTRATOR_MODULE&#61;cPanel&amp;Action&#61;Administrators\" METHOD=\"POST\">
  201. Member Access Level:<BR>
  202. <SELECT NAME=\"Module_Administrators_Form_Member_Access\">
  203. <OPTION VALUE=\"1\">Member</OPTION>
  204. <OPTION VALUE=\"2\">Administrator</OPTION>
  205. </SELECT><BR>
  206. Is This Member Banned?:<BR>
  207. <SELECT NAME=\"Module_Administrators_Form_Member_Banned\">
  208. <OPTION VALUE=\"0\">Not Banned</OPTION>
  209. <OPTION VALUE=\"1\">Banned</OPTION>
  210. </SELECT><BR>
  211. Member Electronic Mail Address:<BR>
  212. <INPUT TYPE=\"TEXT\" NAME=\"Module_Administrators_Form_Member_EMail\" VALUE=\"$_Module_Administrators_LIST_MEMBER_EMAIL_ADDRESS\"><BR>
  213. Member Experience Amount:<BR>
  214. <INPUT TYPE=\"TEXT\" NAME=\"Module_Administrators_Form_Member_Experience\" VALUE=\"$_Module_Administrators_LIST_MEMBER_EXPERIENCE_AMOUNT\"><BR>
  215. Member First Name:<BR>
  216. <INPUT TYPE=\"TEXT\" NAME=\"Module_Administrators_Form_Member_First_Name\" VALUE=\"$_Module_Administrators_LIST_MEMBER_FIRST_NAME\"><BR>
  217. Member Last Name:<BR>
  218. <INPUT TYPE=\"TEXT\" NAME=\"Module_Administrators_Form_Member_Last_Name\" VALUE=\"$_Module_Administrators_LIST_MEMBER_LAST_NAME\"><BR>
  219. Member Number of Post(s):<BR>
  220. <INPUT TYPE=\"TEXT\" NAME=\"Module_Administrators_Form_Member_Number_Of_Posts\" VALUE=\"$_Module_Administrators_LIST_MEMBER_NUMBER_OF_POSTS\"><BR>
  221. Member New Password: <BR>
  222. [ If None, Leave Blank ]<BR>
  223. <INPUT TYPE=\"PASSWORD\" NAME=\"Module_Administrators_Form_Member_Password\"><BR>
  224. Member Rank:<BR>
  225. <INPUT TYPE=\"TEXT\" NAME=\"Module_Administrators_Form_Member_Rank\" VALUE=\"$_Module_Administrators_LIST_RANK\"><BR>
  226. <INPUT TYPE=\"HIDDEN\" NAME=\"Module_Administrators_Form_Member_ID_2\" VALUE=\"$_Module_Administrators_LIST_MEMBER_ID\">
  227. <INPUT TYPE=\"SUBMIT\" VALUE=\"Update Member Data\">
  228. </FORM><BR>
  229.  
  230. ");
  231.  
  232. } // [ + ] WHILE_SQL_ARRAY
  233.  
  234. /*
  235. ===========================
  236. + Kill Database Connection
  237. ===========================
  238. */
  239.  
  240. $DB->free($_Module_Administrators_DB_Query_Fetch_Member_ID);
  241.  
  242. /*
  243. ===========================
  244. +
  245. + If Member Update Form Posted
  246. +
  247. ===========================
  248. */
  249.  
  250. } else {
  251.  
  252. /*
  253. ===========================
  254. + If Form Posted Data Without Password
  255. ===========================
  256. */
  257.  
  258. if (!$_Module_Administrators_POST_MEMBER_OPTION_PASSWORD) {
  259.  
  260. /*
  261. ===========================
  262. + Update Member Data ( Without Password )
  263. ===========================
  264. */
  265.  
  266. $_Module_Administrators_DB_Query_Update_Members = $DB->query("UPDATE {$_ACCESS_DATABASE_PREFIX}_members SET member_access_level='$_Module_Administrators_POST_MEMBER_OPTION_ACCESS_LEVEL',member_banned_status='$_Module_Administrators_POST_MEMBER_OPTION_BANNED_STATUS',member_email_address='$_Module_Administrators_POST_MEMBER_OPTION_BANNED_STATUS',member_experience_amount='$_Module_Administrators_POST_MEMBER_OPTION_EXPERIENCE_AMOUNT',member_first_name='$_Module_Administrators_POST_MEMBER_OPTION_FIRST_NAME',member_last_namee='$_Module_Administrators_POST_MEMBER_OPTION_LAST_NAME',member_number_of_posts='$_Module_Administrators_POST_MEMBER_OPTION_NUMBER_OF_POSTS',member_rank='$_Module_Administrators_POST_MEMBER_RANK' WHERE id='$_Module_Administrators_POST_MEMBER_ID_2'");
  267.  
  268. /*
  269. ===========================
  270. + If SQL Query Executed ( No Password Update )
  271. ===========================
  272. */
  273.  
  274. if ($_Module_Administrators_DB_Query_Update_Members) {
  275. echo ("<BR><HR><CENTER>Cerberus: I have Updated the Member Table ( Without Password ) successfully.</CENTER><HR><BR>");
  276. } else {
  277. echo ("<BR><HR><CENTER>Cerberus: I was not able to Update the Member Table ( Without Password ); please try once more.</CENTER><HR><BR>");
  278. } // [ + ] IF_SQL_QUERY_UPDATE_MEMBER_WITHOUT_PASSWORD
  279.  
  280. /*
  281. ===========================
  282. + Kill Database Connection
  283. ===========================
  284. */
  285.  
  286. $DB->free($_Module_Administrators_DB_Query_Update_Members);
  287.  
  288. /*
  289. ===========================
  290. + If Form Posted Data With Password
  291. ===========================
  292. */
  293.  
  294. } else {
  295.  
  296. /*
  297. ===========================
  298. + Update Member Row ( With Password )
  299. ===========================
  300. */
  301.  
  302. $_Module_Administrators_DB_Query_Update_Members_2 = $DB->query("UPDATE {$_ACCESS_DATABASE_PREFIX}_members SET member_access_level='$_Module_Administrators_POST_MEMBER_OPTION_ACCESS_LEVEL',member_banned_status='$_Module_Administrators_POST_MEMBER_OPTION_BANNED_STATUS',member_email_address='$_Module_Administrators_POST_MEMBER_OPTION_BANNED_STATUS',member_experience_amount='$_Module_Administrators_POST_MEMBER_OPTION_EXPERIENCE_AMOUNT',member_first_name='$_Module_Administrators_POST_MEMBER_OPTION_FIRST_NAME',member_last_namee='$_Module_Administrators_POST_MEMBER_OPTION_LAST_NAME',member_password='$_Module_Administrators_POST_MEMBER_PASSWORD',member_number_of_posts='$_Module_Administrators_POST_MEMBER_OPTION_NUMBER_OF_POSTS',member_rank='$_Module_Administrators_POST_MEMBER_RANK' WHERE id='$_Module_Administrators_POST_MEMBER_ID_2'");
  303.  
  304. /*
  305. ===========================
  306. + If SQL Query Executed ( With Password Update )
  307. ===========================
  308. */
  309.  
  310. if ($_Module_Administrators_DB_Query_Update_Members_2) {
  311. echo ("<BR><HR><CENTER>Cerberus: I have Updated the Member Table ( With Password ) successfully.</CENTER><HR><BR>");
  312. } else {
  313. echo ("<BR><HR><CENTER>Cerberus: I was not able to Update the Member Table ( With Password ); please try once more.</CENTER><HR><BR>");
  314. } // [ + ] IF_SQL_QUERY_UPDATE_MEMBER_WITH_PASSWORD
  315.  
  316. /*
  317. ===========================
  318. + Kill Database Connection
  319. ===========================
  320. */
  321.  
  322. $DB->free($_Module_Administrators_DB_Query_Update_Members_2);
  323.  
  324. /*
  325. ===========================
  326. + Closing IF Statements
  327. ===========================
  328. */
  329.  
  330. } // [ + ] IF_NO_POST_DATA_PASSWORD_OPTION
  331.  
  332. } // [ + ] IF_UPDATE_FORM_POSTED
  333.  
  334. /*
  335. ===========================
  336. +
  337. +
  338. + Send System Message
  339. +
  340. +
  341. ===========================
  342. */
  343.  
  344. /*
  345. ===========================
  346. +
  347. + SQL Query Fetch Member Name
  348. +
  349. ===========================
  350. */
  351.  
  352. $_Module_Administrators_DB_Query_Fetch_Member_UserName_2 = $DB->query("SELECT * FROM {$_ACCESS_DATABASE_PREFIX}_members ORDER BY member_username ASC");
  353.  
  354. /*
  355. ===========================
  356. +
  357. + Form Post Data Variables
  358. +
  359. ===========================
  360. */
  361.  
  362. $_Module_Administrators_POST_MESSAGE_MEMBER_USERNAME = $_POST['Module_Administrators_Form_Member_UserName_2'];
  363. $_Module_Administrators_POST_MESSAGE_MEMBER_MESSAGE = $_POST['Module_Administrators_Form_Member_Message'];
  364.  
  365. /*
  366. ===========================
  367. + Limit, Replace Post Data
  368. ===========================
  369. */
  370.  
  371. $_Module_Administrators_POST_MESSAGE_MEMBER_MESSAGE = preg_replace("/'/","&#39;", $_Module_Administrators_POST_MESSAGE_MEMBER_MESSAGE);
  372. $_Module_Administrators_POST_MESSAGE_MEMBER_MESSAGE_LENGTH = strlen($_Module_Administrators_POST_MESSAGE_MEMBER_MESSAGE);
  373.  
  374. /*
  375. ===========================
  376. +
  377. + System Message Form
  378. +
  379. ===========================
  380. */
  381.  
  382. if (!$_Module_Administrators_POST_MESSAGE_MEMBER_USERNAME) {
  383.  
  384. echo ("
  385. <BR><HR><CENTER><B>System Message</B></CENTER><HR>
  386. <FORM ACTION=\"?$_INTERNAL_ADMINISTRATOR_MODULE&#61;cPanel&amp;Action&#61;Administrators\" METHOD=\"POST\">
  387. Member Name:<BR>
  388. <SELECT NAME=\"Module_Administrators_Form_Member_UserName_2\">
  389. ");
  390.  
  391. /*
  392. ===========================
  393. + List All Members In Options
  394. ===========================
  395. */
  396.  
  397. while ($_Module_Administrators_DB_Query_Fetch_Member_UserName_Array_2 = $DB->fetch_array($_Module_Administrators_DB_Query_Fetch_Member_UserName_2)) {
  398.  
  399. $_Module_Administrators_DB_Query_List_Members = $_Module_Administrators_DB_Query_Fetch_Member_UserName_Array_2['member_username'];
  400.  
  401. echo ("
  402. <OPTION VALUE=\"$_Module_Administrators_DB_Query_List_Members\">Member Name: $_Module_Administrators_DB_Query_List_Members</OPTION>
  403. ");
  404.  
  405. } // [ + ] WHILE_ARRAY
  406.  
  407. echo ("
  408. </SELECT><BR>
  409. Message ( Maximum Length: 100 Characters ):<BR>
  410. <TEXTAREA ROWS=\"15\" COLS=\"75\" NAME=\"Module_Administrators_Form_Member_Message\" MAXLENGTH=\"100\"></TEXTAREA><BR>
  411. <INPUT TYPE=\"submit\" VALUE=\"Send Message\">
  412. </FORM>
  413. ");
  414.  
  415. } else {
  416.  
  417. /*
  418. ===========================
  419. + If Message Length Is Greater Than 100 Characters
  420. ===========================
  421. */
  422.  
  423. if ($_Module_Administrators_POST_MESSAGE_MEMBER_MESSAGE_LENGTH > 100) {
  424. echo ("<HR><CENTER>Cerberus: Your Message is greater than 100 Characters; please go back and reduce your Message Length.</CENTER><HR>");
  425. } else {
  426.  
  427. $_Module_Administrators_DB_Query_Update_System_Message = $DB->query("INSERT INTO {$_ACCESS_DATABASE_PREFIX}_system_message(system_message_data,system_message_member)VALUES('$_Module_Administrators_POST_MESSAGE_MEMBER_MESSAGE','$_Module_Administrators_POST_MESSAGE_MEMBER_USERNAME')");
  428.  
  429. /*
  430. ===========================
  431. + If SQL Query Update Row
  432. ===========================
  433. */
  434.  
  435. if ($_Module_Administrators_DB_Query_Update_System_Message) {
  436.  
  437. echo ("<HR><CENTER>Cerberus: I have Sent your Message successfully.</CENTER><HR>");
  438.  
  439. } else {
  440.  
  441. echo ("<HR><CENTER>Cerberus: I am sorry, but there was an Error; please try once more.</CENTER><HR>");
  442.  
  443. } // [ + ] IF_SQL_QUERY_UPDATE_ROW
  444.  
  445. /*
  446. ===========================
  447. + Kill Database Connection
  448. ===========================
  449. */
  450.  
  451. $DB->free($_Module_Administrators_DB_Query_Update_System_Message);
  452.  
  453. } // [ + ] IF_STRING_LENGTH
  454.  
  455. } // [ + ] IF_!POST
  456.  
  457. /*
  458. ===========================
  459. + Kill Database Connection
  460. ===========================
  461. */
  462.  
  463. $DB->free($_Module_Administrators_DB_Query_Fetch_Member_UserName);
  464. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement