PageRenderTime 46ms CodeModel.GetById 13ms RepoModel.GetById 1ms app.codeStats 0ms

/admin/createaccount.php

https://bitbucket.org/3tierlogic/3tl.tabbuilder
PHP | 183 lines | 149 code | 33 blank | 1 comment | 8 complexity | 6ecfe75fa7bade261f6ffdd01dda635f MD5 | raw file
    

  1. <?
    2. 

  2. session_start();
    3. 

  3. if (isset($_SESSION['superaccount'])) {
    4. 

  4. 	$isSuperUser = 	$_SESSION['superaccount'];
    5. 

  5. }
    6. 

  6. 	
    7. 

  7. // Connect to database
    8. 

  8. require_once("../editor/config.php");
    9. 

  9. $con = mysql_connect(DB_HOST, DB_USER, DB_PASS);		// connect to database
    10. 

  10. if (!$con) {											// error checking and handling
    11. 

  11.     die('Could not connect: ' . mysql_error());
    12. 

  12. }
    13. 

  13. mysql_select_db(DB_NAME);
    14. 

  14. ?>
    15. 

  15. <!doctype html>
    16. 

  16. 

  17. <html lang="en-US">
    18. 

  18. <head>
    19. 

  19. <meta charset="UTF-8" />
    20. 

  20. <title>Tab Editor - Administration Section </title>
    21. 

  21. <link href="../style.css" rel="stylesheet" type="text/css" />
    22. 

  22. <!--[if IE]>
    23. 

  23. <script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
    24. 

  24. <![endif]-->
    25. 

  25. <!--[if IE 6]>
    26. 

  26. <script src="../js/belatedPNG.js"></script>
    27. 

  27. <script>
    28. 

  28. 	DD_belatedPNG.fix('*');
    29. 

  29. </script>
    30. 

  30. <![endif]-->
    31. 

  31. </head>
    32. 

  32. 

  33. <body class="normalpage">
    34. 

  34. <section id="page">
    35. 

  35. <div id="bodywrap">
    36. 

  36. <section id="top">
    37. 

  37. <nav>
    38. 

  38. <h1 id="sitename">
    39. 

  39.   <a href="#">Portfolio | Premium CSS Template </a></h1>
    40. 

  40.   
    41. 

  41.   	<ul id="sitenav">
    42. 

  42. 		<li><a href="../editor/dashboard.php">Back to dashboard</a></li>
    43. 

  43.         <li class="current"><a href="">Admin</a></li>
    44. 

  44. 	</ul>
    45. 

  45.   
    46. 

  46. </nav>
    47. 

  47. <header id="normalheader"></header>
    48. 

  48. </section>
    49. 

  49. <section id="contentwrap">
    50. 

  50. <div id="contents" class="normalcontents"><section id="normalpage">
    51. 

  51. 

  52. <section id="left">
    53. 

  53. 

  54. <h2>Administration Page</h2>
    55. 

  55. <article>
    56. 

  56. 

  57. <h3>Your account has been created with the following information:</h3>
    58. 

  58. 

  59. 

  60. <?
    61. 

  61. $currentCompanyID = $_REQUEST['customerID'];
    62. 

  62. $createCompany = false;
    63. 

  63. if ($currentCompanyID == '0') {
    64. 

  64. 	$createCompany = true;	
    65. 

  65. }
    66. 

  66. 

  67. 

  68. echo "Company Name: ".$_REQUEST['cname']."<br>";
    69. 

  69. echo "Company Address: ".$_REQUEST['caddress']."<br>";
    70. 

  70. echo "City: ".$_REQUEST['ccity']."<br>";
    71. 

  71. echo "Postal Code: ".$_REQUEST['cpostal']."<br>";
    72. 

  72. echo "URL: ".$_REQUEST['curl']."<br>";
    73. 

  73. 

  74. $totalwidgets = count($_REQUEST['cwidget']);
    75. 

  75. $selectedwidgets = $_REQUEST['cwidget'];
    76. 

  76. echo "Total widgets: ".$totalwidgets."<br>";
    77. 

  77. for ($i=0; $i<$totalwidgets; $i++) {
    78. 

  78. 	echo ($i+1) . '- ' . $selectedwidgets[$i] . '<br>';
    79. 

  79. }
    80. 

  80. 

  81. echo "User Name: ".$_REQUEST['user1name']."<br>";
    82. 

  82. echo "Login ID: ".$_REQUEST['user1loginid']."<br>";
    83. 

  83. echo "Password: ".$_REQUEST['user1password']."<br>";
    84. 

  84. 

  85. if (!$createCompany) { //*** Company already 
    86. 

  86. 	$new_companyID = $currentCompanyID;
    87. 

  87. } else { //*** Create a new company 
    88. 

  88. 	
    89. 

  89. 	$sql_create_company = "INSERT INTO sp_company_info (cp_companyName, cp_companyHeadAddress, cp_city, cp_postalCode, cp_createDate, cp_url, cp_status) VALUES ('".
    90. 

  90. 					  addslashes($_REQUEST['cname'])."','".
    91. 

  91. 					  addslashes($_REQUEST['caddress'])."','".
    92. 

  92. 					  addslashes($_REQUEST['ccity'])."','".
    93. 

  93. 					  addslashes($_REQUEST['cpostal'])."','".
    94. 

  94. 					  date("Y-m-d H:i:s")."','".
    95. 

  95. 					  addslashes($_REQUEST['curl'])."','1')";
    96. 

  96. 	$res_create_company = mysql_query($sql_create_company, $con);
    97. 

  97. 	$new_companyID= mysql_insert_id();
    98. 

  98. 	echo "Record created in the company table with id: ".$new_companyID."<br>";		
    99. 

  99. 

  100. 	
    101. 

  101. }
    102. 

  102. 

  103. $sql_create_wdigets = "INSERT INTO sp_partner_widgets SET partner_sid ='".$new_companyID."', ";
    104. 

  104. for ($i=0; $i<$totalwidgets; $i++) {
    105. 

  105. 	$sql_create_wdigets = $sql_create_wdigets.$selectedwidgets[$i]."=1,";
    106. 

  106. }
    107. 

  107. 

  108. $sql_create_wdigets = substr($sql_create_wdigets, 0, -1);
    109. 

  109. echo $sql_create_wdigets;
    110. 

  110. $res_create_wdigets = mysql_query($sql_create_wdigets, $con);
    111. 

  111. $new_widgetsID= mysql_insert_id();
    112. 

  112. echo "Record created in the widgets table with id: ".$new_widgetsID."<br>";
    113. 

  113. 	
    114. 

  114. 	
    115. 

  115. $sql_create_user = "INSERT INTO sp_partner_info SET partner_company_sid ='".$new_companyID."', partner_code='0', partner_login_account='".
    116. 

  116. 					$_REQUEST['user1loginid']."', partner_login_password='".$_REQUEST['user1password']."', partner_contact_name='".$_REQUEST['user1name']."', partner_create_time='".date("Y-m-d H:i:s")."'";
    117. 

  117. $res_create_user = mysql_query($sql_create_user, $con);
    118. 

  118. $new_userID= mysql_insert_id();
    119. 

  119. echo "<br>".$sql_create_user."<br>";
    120. 

  120. echo "Record created in the users table with id: ".$new_userID."<br>";	
    121. 

  121. 

  122. ?>
    123. 

  123. 

  124. <br><br><br>    
    125. 

  125.          
    126. 

  126. </article>
    127. 

  127. 

  128. </section>
    129. 

  129. <section id="sidebar">
    130. 

  130. <h2>Testimonials</h2>
    131. 

  131. <article class="testimonials">
    132. 

  132. <blockquote>
    133. 

  133. <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer egestas purus bibendum neque aliquam ut posuere elit semper. Fusce sagittis pharetra eros, sit amet consequat sem mollis vitae. </p>
    134. 

  134. <cite>John Doe, New York City</cite>
    135. 

  135. </blockquote>
    136. 

  136. 

  137. </article>
    138. 

  138. </section>
    139. 

  139. 

  140. <div class="clear"></div>
    141. 

  141. </section>
    142. 

  142. </div>
    143. 

  143. </section>
    144. 

  144. </div>
    145. 

  145. <footer id="pagefooter">
    146. 

  146. <div id="bottom">
    147. 

  147. <div class="block1">
    148. 

  148. <h2>Meet The Team</h2>
    149. 

  149. 

  150. <div class="teamimg">
    151. 

  151. 	<? include("../editor/team.php")?>
    152. 

  152. 	<!--<div class="imgthmb"><img src="../images/team5.jpg" width="65" height="65" alt="team"></div>
    153. 

  153.   	<div class="imgthmb"><img src="../images/team1.jpg" width="65" height="65" alt="team"></div>
    154. 

  154.   	<div class="imgthmb"><img src="../images/team2.jpg" width="65" height="65" alt="team"></div>
    155. 

  155.   	<div class="imgthmb"><img src="../images/team4.jpg" width="65" height="65" alt="team"></div>
    156. 

  156.   	<div class="imgthmb"><img src="../images/team2.jpg" width="65" height="65" alt="team"></div>
    157. 

  157.   	<div class="imgthmb"><img src="../images/team1.jpg" width="65" height="65" alt="team"></div>-->
    158. 

  158. </div>
    159. 

  159. </div>
    160. 

  160. <div class="block2">
    161. 

  161. <h2>Latest Project</h2>
    162. 

  162. <div class="projectthmb"><? include("../editor/latestproject.php")?> <!--<a href="../portfolio"><img src="../images/latstproject.jpg" width="240" height="150" alt="project"></a>--></div>
    163. 

  163. 

  164. </div>
    165. 

  165. <div class="block3">
    166. 

  166. 

  167. <h2>More About</h2>
    168. 

  168. <p>3 Tier Logic is a full service digital marketing and technology services company that enables organizations to grow their customer and prospect communities through anywhere-anytime communications. </p>
    169. 

  169. 

  170. </div>
    171. 

  171. <div class="clear"></div>
    172. 

  172. </div>
    173. 

  173. <div id="credits">
    174. 

  174. <p>
    175. 

  175. <span class="copyright">&copy; 2012 | 3 Tier Logic Inc |  All Rights Reserved </span>
    176. 

  176. <span id="designcredit">Powered by <a href="http://www.3tierlogic.com" title="Powered by 3 Tier Logic Inc" target="_blank">3 Tier Logic Inc.</a></span>
    177. 

  177. </p>
    178. 

  178. </div>
    179. 

  179. </footer>
    180. 

  180. 

  181. </section>
    182. 

  182. </body>
    183. 

  183. </html>
    184. 

  184.