API tools faq
paste
Advertisement
Guest User

wastedkill

a guest
Jul 22nd, 2012
244
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 155.21 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. include "config.php";
  4.  
  5. if (!isset($_SESSION["revshradmarea"]))
  6. {
  7.  
  8.   if ($_POST) {
  9.         $a=$_POST["u"];
  10.         $b=$_POST["pa"];
  11.     } else {
  12.         $a="";
  13.         }
  14.  
  15.   if ($a==""||$b=="")
  16.   {
  17.     echo("<form action=admin.php method=post><center>");
  18.     echo("<br><font color=black><B>Username:</font><input type=text name='u' size=15 style=font-family:Verdana;>");
  19.     echo("<br><font color=black>Password:</font><input type=password name='pa' size=15 style=font-family:Verdana;>");
  20.     echo("<br><br><input type=Submit value=Login></form>");
  21.  
  22.   }
  23.     else
  24.   {
  25.  
  26.     if (($a==$adminuser)&&($b==$adminpass))
  27.     {
  28.  
  29. $Curl=function_exists('curl_version') ? 'Enabled' : 'Disabled' ;
  30. $err=0;
  31. $error="";
  32.  
  33. $n=trim($_POST[n]);
  34. $n=str_replace("\"","",$n);
  35. $n=str_replace("'","",$n);
  36.  
  37. $e=trim($_POST[e]);
  38. $e=str_replace("\"","",$e);
  39. $e=str_replace("'","",$e);
  40.  
  41. $p=trim($_POST[p]);
  42. $p=str_replace("\"","",$p);
  43. $p=str_replace("'","",$p);
  44.  
  45. $i=trim($_POST[i]);
  46. $i=str_replace("\"","",$i);
  47. $i=str_replace("'","",$i);
  48.  
  49. $d=trim($_POST[d]);
  50. $d=str_replace("\"","",$d);
  51. $d=str_replace("'","",$d);
  52.  
  53. $f=trim($_POST[f]);
  54. $f=str_replace("\"","",$f);
  55. $f=str_replace("'","",$f);
  56.  
  57.  
  58. $url=$_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"];
  59. $url=substr($url,4);
  60. $url=str_replace("https://www.","http://",$url);
  61. $url=str_replace("http://www.","http://",$url);
  62. $url=str_replace("https://","http://",$url);
  63. $url=str_replace("http://","",$url);
  64. $pos = strpos($url, "admin.php");
  65. $url=substr($url,0,$pos);
  66. $pos = strrpos($url, "/");
  67. $url=substr($url,0,$pos);
  68. $pos = strrpos($url, "/");
  69. if($pos>0) $url=substr($url,0,$pos);
  70.  
  71. $url1=$url;
  72.  
  73. $url2="http://www.freeworldscripts.com/reg.php?s=69&u=$url1&n=$n&e=$e&p=$p&i=$i&d=$d&f=$f";
  74. $url2=str_replace(" ","Ј",$url2);
  75.  
  76.     if(ini_get('allow_url_fopen') == '1') {
  77.         $homepage = file_get_contents($url2);
  78.     } else $err=1;
  79.     if($err>0) {       
  80.         if($Curl=='Enabled') { 
  81.         $ch = curl_init();
  82.         curl_setopt($ch, CURLOPT_URL, $url2);
  83.         curl_setopt($ch, CURLOPT_HEADER, 0);
  84.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  85.         $homepage = curl_exec($ch);
  86.         curl_close($ch);       
  87.         } else {
  88.         if($err==1) $err=3;
  89.         else $err=4;
  90.         $error='curl library is not installed so we better use something else';
  91.         }  
  92.     }
  93.  
  94. $homepage=str_replace("{adminlogininfo}","<input type=hidden name='u' value='$a'><input type=hidden name='pa' value='$b'>",$homepage);
  95.  
  96. if(($homepage=="")||($homepage=="OK")) {
  97.       $_SESSION["revshradmarea"]=$adminpass;
  98.     process();
  99. }
  100. elseif($homepage=="Block") {
  101. echo "<br><br><center><b><font face=verdana size=2 color=red>You are using Un-Authorized copy of this script.<br>
  102. We recommend you to contact us immediately at <a href='http://www.yourfreeworld.com/script/contactus.php' target=_blank>http://www.yourfreeworld.com/script/contactus.php</a> or mail us at <a href=mailto:rohit@yourfreeworld.com>rohit@yourfreeworld.com</a>
  103. in order to solve this matter and avoid any legal action for using a pirated copy of our script.</font></b></center><br><br>";
  104. }
  105. else {
  106. if($err==3) echo "Contact your Hosting provider and ask them to enable <b>allow_url_fopen</b> module or <b>Curl</b> module to complete the script activation process.";
  107. elseif($err==4) echo "Contact your Hosting provider and ask them to check why <b>file_get_contents</b> is not working or ask them to install <b>Curl</b> module to complete the script activation process.";
  108. else echo $homepage;
  109. }
  110.     }
  111.       else
  112.     {
  113.     echo("<form action=admin.php method=post><center><font face=verdana size=2><b>Invalid Username or Password</b></font><br><br>");
  114.     echo("<br><font color=black><B>Username:</font><input type=text name='u'  size=15 style=font-family:Verdana;>");
  115.     echo("<br><font color=black>Password:</font><input type=password name='pa'   size=15 style=font-family:Verdana;>");
  116.     echo("<br><br><input type=Submit value=Login></form>");
  117.     }
  118.  
  119.   }
  120.  
  121. }
  122.   else
  123. {
  124.     process();
  125. }
  126.  
  127. function process() {
  128.   include "config.php";
  129.  
  130.   echo("<table border=0 width='100%' cellpadding=0 cellspacing=0>");
  131.   echo("<tr><td align=left valign=top><br>");
  132.   echo("<a href=admin.php?b=200>Instructions</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  133.   echo("<a href=admin.php?b=100>Admin Settings</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  134.   echo("<a href=admin.php?b=101>Edit your Pages</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  135.   echo("<a href=admin.php?b=1>Members List</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  136.   echo("<a href=admin.php?b=21>Free Members</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  137.   echo("<a href=admin.php?b=22>Pro Members</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  138.   echo("<a href=admin.php?b=201>Pending Members</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  139.   echo("<a href=admin.php?b=2>Search Members</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  140.   echo("<a href=admin.php?b=99>Top Sponsors</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  141.   echo("<a href=admin.php?b=3>Email Users</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  142.  
  143.   echo("<a href=admin.php?b=4>Pending Transactions</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  144.   echo("<a href=admin.php?b=5>Positions Details</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  145.   echo("<a href=admin.php?b=7>Admin Earnings</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  146.  
  147.   echo("<a href=admin.php?b=777>Promotional Banners</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  148.   echo("<a href=admin.php?b=778>Promotional Solo Ads</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  149.   echo("<a href=admin.php?b=88>Completed Withdrawls</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  150.   echo("<a href=admin.php?b=66>Pending Withdrawls</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  151.   echo("<a href=admin.php?b=44>Masspay</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  152.   echo("<a href=admin.php?b=210>Add Banner</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  153.   echo("<a href=admin.php?b=211>Approved Banners</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  154.   echo("<a href=admin.php?b=212>Pending Banners</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  155.   echo("<a href=admin.php?b=310>Add TextAd</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  156.   echo("<a href=admin.php?b=311>Approved Text Ads</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  157.   echo("<a href=admin.php?b=312>Pending Text Ads</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  158.   echo("<a href=admin.php?b=9111>Approved Testimonials</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  159.   echo("<a href=admin.php?b=9112>Pending Testimonials</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  160.   echo("<a href=admin.php?b=199>Logout</a>&nbsp;&nbsp;|&nbsp;&nbsp;");
  161.   echo("<br><br>");
  162.  
  163. $today=date ( "Y-m-d H:i:s", mktime (date("H"),date("i"),date("s"),date("m"),date("d"),date("Y")));
  164.  
  165.   $sql = "select count(*) from users where active=1 and status=1";
  166.   $result = mysql_query($sql);
  167.   $rs  =  mysql_fetch_row($result);
  168.   $sql1 = "select count(*) from users where active=1 and status=2";
  169.   $result1 = mysql_query($sql1);
  170.   $rs1  =  mysql_fetch_row($result1);
  171.   $sqlpp1 = "select count(*) from users where active=0";
  172.   $resultpp1 = mysql_query($sqlpp1);
  173.   $rspp1  =  mysql_fetch_row($resultpp1);
  174.  
  175.   $sql5 = "select sum(Amount) from wtransaction where approved=0";
  176.   $result5 = mysql_query($sql5);
  177.   $rs5  =  mysql_fetch_row($result5);
  178.   $sql6 = "select sum(Amount) from wtransaction where approved=1";
  179.   $result6 = mysql_query($sql6);
  180.   $rs6  =  mysql_fetch_row($result6);
  181.  
  182.   $sqlc1 = "select count(*) from banners";
  183.   $resultc1 = mysql_query($sqlc1);
  184.   $rsc1  =  mysql_fetch_row($resultc1);
  185.  
  186.   $sqlc2 = "select count(*) from soloads";
  187.   $resultc2 = mysql_query($sqlc2);
  188.   $rsc2  =  mysql_fetch_row($resultc2);
  189.  
  190.   $sqlb1 = "select * from membersbanners where approved=1";
  191.   $resultb1 = mysql_query($sqlb1);
  192.   $rsb1  =  mysql_num_rows($resultb1);
  193.   $sqlb2 = "select * from membersbanners where approved=0";
  194.   $resultb2 = mysql_query($sqlb2);
  195.   $rsb2  =  mysql_num_rows($resultb2);
  196.  
  197.   $sqlb44 = "select count(*) from memberstextads where approved=0";
  198.   $resultb44 = mysql_query($sqlb44);
  199.   $rsb44  =  mysql_fetch_array($resultb44);
  200.   $sqlb55 = "select count(*) from memberstextads where approved=1";
  201.   $resultb55 = mysql_query($sqlb55);
  202.   $rsb55  =  mysql_fetch_array($resultb55);
  203.  
  204. $rstt=mysql_query("Select * from testimonials where status>0");
  205. $rstt1=mysql_query("Select * from testimonials where status=0");
  206.  
  207.  
  208.   $sqlpos = "select * from moneypool";
  209.   $resultpos = mysql_query($sqlpos);
  210.   $rspos  =  mysql_num_rows($resultpos);
  211.   $sqlap = "select sum(Amount) from adminpool";
  212.   $resultap = mysql_query($sqlap);
  213.   $rsap  =  mysql_fetch_row($resultap);
  214.   $sqlref = "select sum(Amount) from refpool";
  215.   $resultref = mysql_query($sqlref);
  216.   $rsref  =  mysql_fetch_row($resultref);
  217.   $sqlpt = "select count(*) from transaction";
  218.   $resultpt = mysql_query($sqlpt);
  219.   $rspt  =  mysql_fetch_row($resultpt);
  220.  
  221.   echo("Total Members: <SMALL><font color=red>" . ($rs[0]+$rs1[0]+$rspp1[0]) . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  222.   echo("Free Members: <SMALL><font color=red>" . $rs[0] . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  223.   echo("Pro Members: <SMALL><font color=red>" . $rs1[0] . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  224.   echo("Pending Members: <SMALL><font color=red>" . $rspp1[0] . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  225.   echo("Paid Money: <SMALL><font color=red>$" . number_format($rs6[0],2) . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  226.   echo("Pending Withdrawls: <SMALL><font color=red>$" . number_format(($rs5[0]),2) . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  227.   echo("Approved Testimonials: <SMALL><font color=red>" . mysql_num_rows($rstt) . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  228.   echo("Pending Testimonials: <SMALL><font color=red>" . mysql_num_rows($rstt1) . "</font></small><br>");
  229.  
  230.   echo("Total Money Invested: <SMALL><font color=red>$" . $totalinv . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  231.   echo("Total Positions: <SMALL><font color=red>" . $rspos . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  232.   echo("Your Profit: <SMALL><font color=red>$" . number_format($rsap[0],2). "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  233.   echo("Members Earnings from positions: <SMALL><font color=red>$" . $memearn . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  234.   echo("Members Earnings by Referral Bonus: <SMALL><font color=red>$" . number_format($rsref[0],2) . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  235.   echo("Pending Transactions: <SMALL><font color=red>" . $rspt[0] . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>");
  236.  
  237.   echo("Promotional Banners: <SMALL><font color=red>" . $rsc1[0] . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  238.   echo("Promotional SoloAds: <SMALL><font color=red>" . $rsc2[0] . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  239.   echo("Approved Banners: <SMALL><font color=red>" . $rsb1 . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  240.   echo("Pending Banners: <SMALL><font color=red>" . $rsb2 . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  241.   echo("Approved Text Ads: <SMALL><font color=red>" . $rsb55[0] . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  242.   echo("Pending Text Ads: <SMALL><font color=red>" . $rsb44[0] . "</font></small>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  243.  
  244.   echo("<hr>");
  245.   echo("</td></tr><tr>");
  246.   echo("<td align=left valign=top>");
  247.  
  248.     $p=$_GET[p];
  249. $b=$_GET[b];
  250. if(!$b) $b=$_POST[b];
  251. $id=$_POST[id];
  252. $act=$_GET[act];
  253. $edit=$_POST[edit];
  254.  
  255.   if ($b=="100")
  256.   {
  257.     echo "<h3 align=center>Admin Settings</h3>";
  258.     if (!$_POST)
  259.     {
  260.       $sql = "select * from adminsettings";
  261.       $result = mysql_query($sql);
  262.       $rs  =  mysql_fetch_array($result);
  263.       $sqlb = "select * from badminsettings";
  264.       $resultb = mysql_query($sqlb);
  265.       $rsb  =  mysql_fetch_array($resultb);
  266.  
  267.       $sqlt = "select * from tadminsettings";
  268.       $resultt = mysql_query($sqlt);
  269.       $rst  =  mysql_fetch_array($resultt);
  270.  
  271.       echo("<table><br><form action='admin.php?b=100' method=post><input type=hidden name=id value=".$id."><input type=hidden name=edit value=1>");
  272.       echo("<tr><td colspan=2><h3><center>Update Information</h3></td></tr>");
  273.       echo("<tr><Td width=300><font face=verdana size=2>Site Name</font></td><td width=400><input type=text name=asitename value='". $rs[0] . "'></td></tr>");
  274.       echo("<tr><Td width=300><font face=verdana size=2>Site Url<br>like this http://www.abc.com</font></td><td width=400><input type=text name=asiteurl value='". $rs[1] . "'></td></tr>");
  275.       echo("<tr><Td width=300><font face=verdana size=2>Admin Email Address</font></td><td width=400><input type=text name=aemail value='". $rs[2] . "'></td></tr>");
  276.       echo("<tr><Td width=300><font face=verdana size=2>Admin Section Username</font></td><td width=400><input type=text name=ausername value='". $rs[3] . "'></td></tr>");
  277.       echo("<tr><Td width=300><font face=verdana size=2>Admin Section Password</font></td><td width=400><input type=text name=apassword value='". $rs[4] . "'></td></tr>");
  278.       echo("<tr><Td colspan=2><p>&nbsp;</p></td></tr>");
  279.     echo("<tr><Td colspan=2><font face=verdana size=2>Enter your payment processors Details below, if you don't want to use any of these payment processors then just use 0 for that.<br>
  280. Please note: We recommend you not to use paypal for a profit sharing site like this as it can risk your paypal account, we have added it just for the special cases who wants to use paypal at any cost.</font></td></tr>");
  281.       echo("<tr><Td width=300><font face=verdana size=2>Paypal Email Address</font></td><td width=400><input type=text name=paypal value='". $rs[7] . "'></td></tr>");
  282.       echo("<tr><Td width=300><font face=verdana size=2>Moneybookers Email Address</font></td><td width=400><input type=text name=moneybookers value='". $rs[8] . "'></td></tr>");
  283.       echo("<tr><Td width=300><font face=verdana size=2>Payza Email Address</font></td><td width=400><input type=text name=alertpay value='". $rs[9] . "'></td></tr>");
  284.       echo("<tr><Td width=300><font face=verdana size=2>E-bullion ID</font></td><td width=400><input type=text name=ebullion value='". $rs[10] . "'></td></tr>");
  285.  
  286.     echo("<Tr><td colspan=2><font face=verdana size=2>Enter your Payza Encrypted Security Code if you want to instantly activate the account on receiving the payment through payza.<br><a href='admin.php?b=steps' target=_blank>Click Here</a> to know more about how to setup the encrypted security code.</td></tr>");
  287.       echo("<tr><Td width=300><font face=verdana size=2>Payza Encrypted Security Code</font></td><td width=400><input type=text name=ipncode value='". $rs[64] . "'></td></tr>");
  288.  
  289.     echo("<Tr><td colspan=2><font face=verdana size=2>Enter the number of extra merchants accounts that you want to use from 0 to 5</font></td></tr>");
  290.       echo("<tr><Td width=300><font face=verdana size=2>Extra Merchants</font></td><td width=400><input type=text name=emerchants value='". $rs[47] . "'></td></tr>");
  291.     echo("<Tr><td colspan=2><font face=verdana size=2>Enter the merchant Name and code. Please note: You need to use {fee} in the amount field so that it shall automatically place the correct amount when payment button gets displayed.</td></tr>");
  292.       echo("<tr><Td width=300><font face=verdana size=2>1st Merchant Name</font></td><td width=400><input type=text name=mn1 value='". stripslashes($rs[48]) . "'></td></tr>");
  293.       echo("<tr><Td width=300><font face=verdana size=2>1st Merchant Code</font></td><td width=400><textarea name=mc1 cols=60 rows=10>".stripslashes($rs[49])."</textarea></td></tr>");
  294.       echo("<tr><Td width=300><font face=verdana size=2>2nd Merchant Name</font></td><td width=400><input type=text name=mn2 value='". stripslashes($rs[50]) . "'></td></tr>");
  295.       echo("<tr><Td width=300><font face=verdana size=2>2nd Merchant Code</font></td><td width=400><textarea name=mc2 cols=60 rows=10>".stripslashes($rs[51])."</textarea></td></tr>");
  296.       echo("<tr><Td width=300><font face=verdana size=2>3rd Merchant Name</font></td><td width=400><input type=text name=mn3 value='". stripslashes($rs[52]) . "'></td></tr>");
  297.       echo("<tr><Td width=300><font face=verdana size=2>3rd Merchant Code</font></td><td width=400><textarea name=mc3 cols=60 rows=10>".stripslashes($rs[53])."</textarea></td></tr>");
  298.       echo("<tr><Td width=300><font face=verdana size=2>4th Merchant Name</font></td><td width=400><input type=text name=mn4 value='". stripslashes($rs[54]) . "'></td></tr>");
  299.       echo("<tr><Td width=300><font face=verdana size=2>4th Merchant Code</font></td><td width=400><textarea name=mc4 cols=60 rows=10>".stripslashes($rs[55])."</textarea></td></tr>");
  300.       echo("<tr><Td width=300><font face=verdana size=2>5th Merchant Name</font></td><td width=400><input type=text name=mn5 value='". stripslashes($rs[56]) . "'></td></tr>");
  301.       echo("<tr><Td width=300><font face=verdana size=2>5th Merchant Code</font></td><td width=400><textarea name=mc5 cols=60 rows=10>".stripslashes($rs[57])."</textarea></td></tr>");
  302.       echo("<tr><Td colspan=2><p>&nbsp;</p></td></tr>");
  303.  
  304.       echo("<tr><Td width=300><font face=verdana size=2>Price per position</font></td><td width=400>$<input type=text name=profee value='". $rs[12] . "'></td></tr>");
  305.       echo("<tr><Td width=300><font face=verdana size=2>Maximum positions a member can purchase at one time</font></td><td width=400><input type=text name=maxposatonce value='". $rs[14] . "'></td></tr>");
  306.       echo("<tr><Td width=300><font face=verdana size=2>Maximum positions a member can own</font></td><td width=400><input type=text name=maxpostotal value='". $rs[15] . "'></td></tr>");
  307.  
  308.     echo("<Tr><td colspan=2><font face=verdana size=2>Enter the percentage amount that will kept as admin profit from each position purchased.</td></tr>");
  309.       echo("<tr><Td width=300><font face=verdana size=2>Admin Profit Percentage</font></td><td width=400><input type=text name=adminprofit value='". $rs[65] . "'>%</td></tr>");
  310.  
  311.       echo("<tr><Td width=300><font face=verdana size=2>Referral Commissions Levels (No. of levels till which you want to pay commissions from 1-5) </font></td><td width=400><input type=text name=levels value='". $rs[11] . "'></td></tr>");
  312.     echo("<Tr><td colspan=2><font face=verdana size=2>Enter the percentage amount that will be paid to sponsor everytime one of his referral purchases any position.</td></tr>");
  313.       echo("<tr><Td width=300><font face=verdana size=2>Level 1 Referral Profit Percentage</font></td><td width=400><input type=text name=refprofit value='". $rs[66] . "'>%</td></tr>");
  314.       echo("<tr><Td width=300><font face=verdana size=2>Level 2 Referral Profit Percentage</font></td><td width=400><input type=text name=refprofit2 value='". $rs[69] . "'>%</td></tr>");
  315.       echo("<tr><Td width=300><font face=verdana size=2>Level 3 Referral Profit Percentage</font></td><td width=400><input type=text name=refprofit3 value='". $rs[70] . "'>%</td></tr>");
  316.       echo("<tr><Td width=300><font face=verdana size=2>Level 4 Referral Profit Percentage</font></td><td width=400><input type=text name=refprofit4 value='". $rs[71] . "'>%</td></tr>");
  317.       echo("<tr><Td width=300><font face=verdana size=2>Level 5 Referral Profit Percentage</font></td><td width=400><input type=text name=refprofit5 value='". $rs[72] . "'>%</td></tr>");
  318.  
  319.     echo("<Tr><td colspan=2><font face=verdana size=2>Enter the number of members who will be paid on each position purchased after deducting admin profit and referral profit.</td></tr>");
  320.       echo("<tr><Td width=300><font face=verdana size=2>Members Paid </font></td><td width=400><input type=text name=memberspaid value='". $rs[67] . "'></td></tr>");
  321.  
  322.     echo("<Tr><td colspan=2><font face=verdana size=2>Do you want to limit the profit per share position like no share position can earn more than 200% of the share value?</td></tr>");
  323.       echo("<tr><Td width=300><font face=verdana size=2>Limit Max. Profit per share</font></td><td width=400><select name=limitprofit>");
  324.       if($rs[75]==0) {
  325.     echo "<option value=0 selected>No</option>
  326.        <option value=1>Yes</option>";
  327.       }
  328.       elseif($rs[75]==1) {
  329.     echo "<option value=0>No</option>
  330.        <option value=1 selected>Yes</option>";
  331.       }
  332.       echo("</select></td></tr>");
  333.     echo("<Tr><td colspan=2><font face=verdana size=2>If you have limited the maximum profit per share then enter that max. amount that members can earn per share position.</td></tr>");
  334.       echo("<tr><Td width=300><font face=verdana size=2>Max Profit per share position</font></td><td width=400>$<input type=text name=maxprofit value='". $rs[76] . "'></td></tr>");
  335.  
  336.       echo("<tr><Td width=300><font face=verdana size=2>Min. Withdrawal</font></td><td width=400>$<input type=text name=minwit value='". $rs[13] . "'></td></tr>");
  337.  
  338.     echo("<Tr><td colspan=2><font face=verdana size=2>Signup Details settings: You can show/hide these fields from join page.</font></td></tr>");
  339.       echo("<tr><Td width=300><font face=verdana size=2>Show Address field</font></td><td width=400><select name=showaddress>");
  340.       if($rs[16]==0) {
  341.     echo "<option value=0 selected>No</option>
  342.        <option value=1>Yes</option>";
  343.       }
  344.       elseif($rs[16]==1) {
  345.     echo "<option value=0>No</option>
  346.        <option value=1 selected>Yes</option>";
  347.       }
  348.       echo("</select></td></tr>");
  349.  
  350.       echo("<tr><Td width=300><font face=verdana size=2>Show City field</font></td><td width=400><select name=showcity>");
  351.       if($rs[17]==0) {
  352.     echo "<option value=0 selected>No</option>
  353.        <option value=1>Yes</option>";
  354.       }
  355.       elseif($rs[17]==1) {
  356.     echo "<option value=0>No</option>
  357.        <option value=1 selected>Yes</option>";
  358.       }
  359.       echo("</select></td></tr>");
  360.  
  361.       echo("<tr><Td width=300><font face=verdana size=2>Show State field</font></td><td width=400><select name=showstate>");
  362.       if($rs[18]==0) {
  363.     echo "<option value=0 selected>No</option>
  364.        <option value=1>Yes</option>";
  365.       }
  366.       elseif($rs[18]==1) {
  367.     echo "<option value=0>No</option>
  368.        <option value=1 selected>Yes</option>";
  369.       }
  370.       echo("</select></td></tr>");
  371.  
  372.       echo("<tr><Td width=300><font face=verdana size=2>Show Postal Code/Zip field</font></td><td width=400><select name=showzip>");
  373.       if($rs[19]==0) {
  374.     echo "<option value=0 selected>No</option>
  375.        <option value=1>Yes</option>";
  376.       }
  377.       elseif($rs[19]==1) {
  378.     echo "<option value=0>No</option>
  379.        <option value=1 selected>Yes</option>";
  380.       }
  381.       echo("</select></td></tr>");
  382.  
  383.       echo("<tr><Td width=300><font face=verdana size=2>Show Country field</font></td><td width=400><select name=showcountry>");
  384.       if($rs[20]==0) {
  385.     echo "<option value=0 selected>No</option>
  386.        <option value=1>Yes</option>";
  387.       }
  388.       elseif($rs[20]==1) {
  389.     echo "<option value=0>No</option>
  390.        <option value=1 selected>Yes</option>";
  391.       }
  392.       echo("</select></td></tr>");
  393.  
  394.       echo("<tr><Td colspan=2><p>&nbsp;</p></td></tr>");
  395.       echo("<tr><Td width=300><font face=verdana size=2><a href=http://www.yourfreeworld.com/script/affiliate.asp target=_blank>YourFreeWorld.com Scripts Affiliate ID</a></font></td><td width=400><input type=text name=yfwid value='". $rs[21] . "'></td></tr>");
  396.       echo("<tr><Td colspan=2><p>&nbsp;</p></td></tr>");
  397.  
  398.     echo("<Tr><td colspan=2><font face=verdana size=2>Enter your banners settings:</font></td></tr>");
  399.       echo("<tr><Td width=300><font face=verdana size=2>Impressions per share purchased:</font></td><td width=400><input type=text name=maxban value='". $rsb[0] . "'></td></tr>");
  400.       echo("<tr><Td width=300><font face=verdana size=2>No. of banners to be shown at bottom of each page:</font></td><td width=400><input type=text name=showban value='". $rsb[1] . "'></td></tr>");
  401.  
  402.     echo("<Tr><td colspan=2><font face=verdana size=2>Enter your Text Ads settings:</font></td></tr>");
  403.       echo("<tr><Td width=300><font face=verdana size=2>Impressions per share purchased:</font></td><td width=400><input type=text name=maxads value='". $rst[0] . "'></td></tr>");
  404.       echo("<tr><Td width=300><font face=verdana size=2>No. of Text Ads to be shown at top of each page:</font></td><td width=400><input type=text name=nads value='". $rst[1] . "'></td></tr>");
  405.  
  406.       echo("<tr><Td colspan=2><p>&nbsp;</p></td></tr>");
  407.     echo("<Tr><td colspan=2><font face=verdana size=2>If you want to send a confirmation email to verify the user email address in order to avoid non working or invalid email address then select <b>Yes</b> in Email Confirmation Required option otherwise select <b>No</b>.</font></td></tr>");
  408.       echo("<tr><Td width=300><font face=verdana size=2>Email Confirmation Required?</font></td><td width=400><select name=confirmreq>");
  409.       if($rs[22]==0) {
  410.     echo "<option value=0 selected>No</option>
  411.        <option value=1>Yes</option>";
  412.       }
  413.       elseif($rs[22]==1) {
  414.     echo "<option value=0>No</option>
  415.        <option value=1 selected>Yes</option>";
  416.       }
  417.       echo("</select></td></tr>");
  418.  
  419.     echo("<Tr><td colspan=2><font face=verdana size=2>If you want to send an email to sponsor to notify them that they have got a new signup or there referral has upgraded then select <b>Yes</b> in Send Referral Notification Email option otherwise select <b>No</b>.</font></td></tr>");
  420.       echo("<tr><Td width=300><font face=verdana size=2>Send Referral Notification Email</font></td><td width=400><select name=refnotification>");
  421.       if($rs[23]==0) {
  422.     echo "<option value=0 selected>No</option>
  423.        <option value=1>Yes</option>";
  424.       }
  425.       elseif($rs[23]==1) {
  426.     echo "<option value=0>No</option>
  427.        <option value=1 selected>Yes</option>";
  428.       }
  429.       echo("</select></td></tr>");
  430.  
  431.  
  432.     echo("<Tr><td colspan=2><font face=verdana size=2>Change the email contents if you wants.<br><br>
  433. You can use the following tags for personalized mailing and these will automatically get replaced by user information.<br><br>
  434. {name} for Name of the member<br>
  435. {username} for username of the member<br>
  436. {password} for the password of the member<br>
  437. {email} for the Email Address of the member<br>
  438. {sitename} for your sitename like $sitename<br>
  439. {siteurl} for your website url like $siteurl<br><br>
  440. Note: If you are using <b>Email Format</b> as <b>HTML</b> then you need to type the complete message in HTML format only.</font></td></tr>");
  441.       echo("<tr><Td colspan=2><font face=verdana size=2>Confirmation Email:</font><br><table border=0>");
  442.       echo("<tr><td align=right valign=top><font face=verdana size=2>Subject:</td><td align=left><input type=text name=subject1 value=\"".stripslashes($subject1)."\"></td></tr>");
  443.       echo("<tr><Td align=right valign=top><font face=verdana size=2>Email Format:</font></td><td width=400><select name=eformat1>");
  444.       if($eformat1==1) {
  445.     echo "<option value=1 selected>Text</option>
  446.        <option value=2>HTML</option>";
  447.       }
  448.       else {
  449.     echo "<option value=1>Text</option>
  450.        <option value=2 selected>HTML</option>";
  451.       }
  452.       echo("<tr><td align=right valign=top><font face=verdana size=2>Message:</td><td align=left><textarea name=message1 cols=60 rows=10>".stripslashes($message1)."</textarea></td></tr>");
  453.     echo("</table><br><font face=verdana size=2><b>Note: </b>Please don't remove {validationurl} tag from the above email otherwise as it is used to show the validation link in confirmation email.</font></td></tr>");
  454.  
  455.       echo("<tr><Td colspan=2><font face=verdana size=2>Free Members Account Activation Email.<br>If you are using only Pro Membership then this email is sent when someone validate the email address and is supposed to make the payment:</font><br><table border=0>");
  456.       echo("<tr><td align=right valign=top><font face=verdana size=2>Subject:</td><td align=left><input type=text name=subject2 value=\"".stripslashes($subject2)."\"></td></tr>");
  457.       echo("<tr><Td align=right valign=top><font face=verdana size=2>Email Format:</font></td><td width=400><select name=eformat2>");
  458.       if($eformat2==1) {
  459.     echo "<option value=1 selected>Text</option>
  460.        <option value=2>HTML</option>";
  461.       }
  462.       else {
  463.     echo "<option value=1>Text</option>
  464.        <option value=2 selected>HTML</option>";
  465.       }
  466.       echo("<tr><td align=right valign=top><font face=verdana size=2>Message:</td><td align=left><textarea name=message2 cols=60 rows=10>".stripslashes($message2)."</textarea></td></tr>");
  467.     echo("</table></td></tr>");
  468.  
  469.       echo("<tr><Td colspan=2><font face=verdana size=2>Referral Notification Email to sponsor when downline member activates the free account:<br>
  470. You can use the following tags for showing the referred member details to sponsor.<br><br>
  471. {refname} for Referred Member Name<br>
  472. {refusername} for Referred Member Username<br>
  473. {refemail} for the Referred Member Email Address<br></font>
  474. <table border=0>");
  475.       echo("<tr><td align=right valign=top><font face=verdana size=2>Subject:</td><td align=left><input type=text name=subject3 value=\"".stripslashes($subject3)."\"></td></tr>");
  476.       echo("<tr><Td align=right valign=top><font face=verdana size=2>Email Format:</font></td><td width=400><select name=eformat3>");
  477.       if($eformat3==1) {
  478.     echo "<option value=1 selected>Text</option>
  479.        <option value=2>HTML</option>";
  480.       }
  481.       else {
  482.     echo "<option value=1>Text</option>
  483.        <option value=2 selected>HTML</option>";
  484.       }
  485.       echo("<tr><td align=right valign=top><font face=verdana size=2>Message:</td><td align=left><textarea name=message3 cols=60 rows=10>".stripslashes($message3)."</textarea></td></tr>");
  486.     echo("</table></td></tr>");
  487.  
  488.       echo("<tr><Td colspan=2><font face=verdana size=2>Password Reminder Email:</font><br><table border=0>");
  489.       echo("<tr><td align=right valign=top><font face=verdana size=2>Subject:</td><td align=left><input type=text name=subject5 value=\"".stripslashes($subject5)."\"></td></tr>");
  490.       echo("<tr><Td align=right valign=top><font face=verdana size=2>Email Format:</font></td><td width=400><select name=eformat5>");
  491.       if($eformat5==1) {
  492.     echo "<option value=1 selected>Text</option>
  493.        <option value=2>HTML</option>";
  494.       }
  495.       else {
  496.     echo "<option value=1>Text</option>
  497.        <option value=2 selected>HTML</option>";
  498.       }
  499.       echo("<tr><td align=right valign=top><font face=verdana size=2>Message:</td><td align=left><textarea name=message5 cols=60 rows=10>".stripslashes($message5)."</textarea></td></tr>");
  500.     echo("</table></td></tr>");
  501.  
  502.       echo("<tr><Td colspan=2><font face=verdana size=2>Banner Ad Approval Email:</font><br><table border=0>");
  503.       echo("<tr><td align=right valign=top><font face=verdana size=2>Subject:</td><td align=left><input type=text name=subject6 value=\"".stripslashes($subject6)."\"></td></tr>");
  504.       echo("<tr><Td align=right valign=top><font face=verdana size=2>Email Format:</font></td><td width=400><select name=eformat6>");
  505.       if($eformat6==1) {
  506.     echo "<option value=1 selected>Text</option>
  507.        <option value=2>HTML</option>";
  508.       }
  509.       else {
  510.     echo "<option value=1>Text</option>
  511.        <option value=2 selected>HTML</option>";
  512.       }
  513.       echo("<tr><td align=right valign=top><font face=verdana size=2>Message:</td><td align=left><textarea name=message6 cols=60 rows=10>".stripslashes($message6)."</textarea></td></tr>");
  514.     echo("</table><br><font face=verdana size=2><b>Note: </b>{banner} and {websiteurl} tags can be used to show the banner ad and website url submitted by member.</font></td></tr>");
  515.  
  516.       echo("<tr><Td colspan=2><font face=verdana size=2>Banner Ad Rejection Email:</font><br><table border=0>");
  517.       echo("<tr><td align=right valign=top><font face=verdana size=2>Subject:</td><td align=left><input type=text name=subject7 value=\"".stripslashes($subject7)."\"></td></tr>");
  518.       echo("<tr><Td align=right valign=top><font face=verdana size=2>Email Format:</font></td><td width=400><select name=eformat7>");
  519.       if($eformat7==1) {
  520.     echo "<option value=1 selected>Text</option>
  521.        <option value=2>HTML</option>";
  522.       }
  523.       else {
  524.     echo "<option value=1>Text</option>
  525.        <option value=2 selected>HTML</option>";
  526.       }
  527.       echo("<tr><td align=right valign=top><font face=verdana size=2>Message:</td><td align=left><textarea name=message7 cols=60 rows=10>".stripslashes($message7)."</textarea></td></tr>");
  528.     echo("</table><br><font face=verdana size=2><b>Note: </b>{banner} and {websiteurl} tags can be used to show the banner ad and website url submitted by member.</font></td></tr>");
  529.  
  530.       echo("<tr><Td colspan=2><font face=verdana size=2>Text Ad Approval Email:</font><br><table border=0>");
  531.       echo("<tr><td align=right valign=top><font face=verdana size=2>Subject:</td><td align=left><input type=text name=subject8 value=\"".stripslashes($subject8)."\"></td></tr>");
  532.       echo("<tr><Td align=right valign=top><font face=verdana size=2>Email Format:</font></td><td width=400><select name=eformat8>");
  533.       if($eformat8==1) {
  534.     echo "<option value=1 selected>Text</option>
  535.        <option value=2>HTML</option>";
  536.       }
  537.       else {
  538.     echo "<option value=1>Text</option>
  539.        <option value=2 selected>HTML</option>";
  540.       }
  541.       echo("<tr><td align=right valign=top><font face=verdana size=2>Message:</td><td align=left><textarea name=message8 cols=60 rows=10>".stripslashes($message8)."</textarea></td></tr>");
  542.     echo("</table><br><font face=verdana size=2><b>Note: </b>{textad} and {websiteurl} tags can be used to show the textad and website url submitted by member.</font></td></tr>");
  543.  
  544.       echo("<tr><Td colspan=2><font face=verdana size=2>Text Ad Rejection Email:</font><br><table border=0>");
  545.       echo("<tr><td align=right valign=top><font face=verdana size=2>Subject:</td><td align=left><input type=text name=subject9 value=\"".stripslashes($subject9)."\"></td></tr>");
  546.       echo("<tr><Td align=right valign=top><font face=verdana size=2>Email Format:</font></td><td width=400><select name=eformat9>");
  547.       if($eformat9==1) {
  548.     echo "<option value=1 selected>Text</option>
  549.        <option value=2>HTML</option>";
  550.       }
  551.       else {
  552.     echo "<option value=1>Text</option>
  553.        <option value=2 selected>HTML</option>";
  554.       }
  555.       echo("<tr><td align=right valign=top><font face=verdana size=2>Message:</td><td align=left><textarea name=message9 cols=60 rows=10>".stripslashes($message9)."</textarea></td></tr>");
  556.     echo("</table><br><font face=verdana size=2><b>Note: </b>{textad} and {websiteurl} tags can be used to show the textad and website url submitted by member.</font></td></tr>");
  557.  
  558.     echo("<Tr><td colspan=2><font face=verdana size=2>Bonus Page Details: You can use html tags here.</font></td></tr>");
  559.       echo("<tr><Td colspan=2><table border=0>");
  560.       echo("<tr><td align=right valign=top><font face=verdana size=2>Free Members Bonus:</font></td><td align=left><textarea name=freebonus cols=60 rows=10>".stripslashes($freebonus)."</textarea></td></tr>");
  561.       echo("<tr><td align=right valign=top><font face=verdana size=2>Pro Members Bonus:</font></td><td align=left><textarea name=probonus cols=60 rows=10>".stripslashes($probonus)."</textarea></td></tr>");
  562.     echo("</table></td></tr>");
  563.       echo("<tr><Td colspan=2><p>&nbsp;</p></td></tr>");
  564.       echo("<tr><td colspan=2>");
  565.       echo("<input type=Submit style='' color:#000000; font-size:10pt; font-family:Verdana; font-weight:bold; border:1px ridge #000000; background-color:#B0D8DD  value='Update Settings'></form></td></tr></table>");
  566.     }
  567.     else
  568.     {
  569.       $sql_u="update adminsettings set
  570.   sitename='$_POST[asitename]',
  571.   siteurl='$_POST[asiteurl]',
  572.   Email='$_POST[aemail]',
  573.   Username='$_POST[ausername]',
  574.   Password='$_POST[apassword]',
  575.   topbanner='$_POST[topban]',
  576.   bottombanner='$_POST[botban]',
  577.   Ebullion='$_POST[ebullion]',
  578.   Alertpay='$_POST[alertpay]',
  579.   Paypal='$_POST[paypal]',
  580.   Moneybookers='$_POST[moneybookers]',
  581.   profee='$_POST[profee]',
  582.   maxposatonce='$_POST[maxposatonce]',
  583.   maxpostotal='$_POST[maxpostotal]',
  584.   showaddress='$_POST[showaddress]',
  585.   showcity='$_POST[showcity]',
  586.   showstate='$_POST[showstate]',
  587.   showzip='$_POST[showzip]',
  588.   showcountry='$_POST[showcountry]',
  589.   ipncode='$_POST[ipncode]',
  590.   yfwid='$_POST[yfwid]',
  591.   confirmreq='$_POST[confirmreq]',
  592.   refnotification='$_POST[refnotification]',
  593.   eformat1='$_POST[eformat1]',
  594.   eformat2='$_POST[eformat2]',
  595.   eformat3='$_POST[eformat3]',
  596.   eformat5='$_POST[eformat5]',
  597.   eformat6='$_POST[eformat6]',
  598.   eformat7='$_POST[eformat7]',
  599.   eformat8='$_POST[eformat8]',
  600.   eformat9='$_POST[eformat9]',
  601.   adminprofit='$_POST[adminprofit]',
  602.   levels='$_POST[levels]',
  603.   refprofit='$_POST[refprofit]',
  604.   refprofit2='$_POST[refprofit2]',
  605.   refprofit3='$_POST[refprofit3]',
  606.   refprofit4='$_POST[refprofit4]',
  607.   refprofit5='$_POST[refprofit5]',
  608.   memberspaid='$_POST[memberspaid]',
  609.   limitprofit='$_POST[limitprofit]',
  610.   maxprofit='$_POST[maxprofit]',
  611.   Merchants='$_POST[emerchants]',
  612.   minwithdrawal='$_POST[minwit]'
  613. ";
  614.       $rs=mysql_query($sql_u);
  615.  
  616. $subject1=addslashes($_POST[subject1]);
  617. mysql_query("update adminsettings set Subject1='$subject1'");
  618.  
  619. $subject2=addslashes($_POST[subject2]);
  620. mysql_query("update adminsettings set Subject2='$subject2'");
  621.  
  622. $subject3=addslashes($_POST[subject3]);
  623. mysql_query("update adminsettings set Subject3='$subject3'");
  624.  
  625. $subject5=addslashes($_POST[subject5]);
  626. mysql_query("update adminsettings set Subject5='$subject5'");
  627.  
  628. $subject6=addslashes($_POST[subject6]);
  629. mysql_query("update adminsettings set Subject6='$subject6'");
  630.  
  631. $subject7=addslashes($_POST[subject7]);
  632. mysql_query("update adminsettings set Subject7='$subject7'");
  633.  
  634. $subject8=addslashes($_POST[subject8]);
  635. mysql_query("update adminsettings set Subject8='$subject8'");
  636.  
  637. $subject9=addslashes($_POST[subject9]);
  638. mysql_query("update adminsettings set Subject9='$subject9'");
  639.  
  640. $message1=addslashes($_POST[message1]);
  641. mysql_query("update adminsettings set Message1='$message1'");
  642.  
  643. $message2=addslashes($_POST[message2]);
  644. mysql_query("update adminsettings set Message2='$message2'");
  645.  
  646. $message3=addslashes($_POST[message3]);
  647. mysql_query("update adminsettings set Message3='$message3'");
  648.  
  649. $message5=addslashes($_POST[message5]);
  650. mysql_query("update adminsettings set Message5='$message5'");
  651.  
  652. $message6=addslashes($_POST[message6]);
  653. mysql_query("update adminsettings set Message6='$message6'");
  654.  
  655. $message7=addslashes($_POST[message7]);
  656. mysql_query("update adminsettings set Message7='$message7'");
  657.  
  658. $message8=addslashes($_POST[message8]);
  659. mysql_query("update adminsettings set Message8='$message8'");
  660.  
  661. $message9=addslashes($_POST[message9]);
  662. mysql_query("update adminsettings set Message9='$message9'");
  663.  
  664.  
  665. $freebonus=addslashes($_POST[freebonus]);
  666. $probonus=addslashes($_POST[probonus]);
  667. mysql_query("update adminsettings set freebonus='$freebonus'");
  668. mysql_query("update adminsettings set probonus='$probonus'");
  669.  
  670. $mn1=addslashes($_POST[mn1]);
  671. $mn2=addslashes($_POST[mn2]);
  672. $mn3=addslashes($_POST[mn3]);
  673. $mn4=addslashes($_POST[mn4]);
  674. $mn5=addslashes($_POST[mn5]);
  675.  
  676. $mc1=addslashes($_POST[mc1]);
  677. $mc2=addslashes($_POST[mc2]);
  678. $mc3=addslashes($_POST[mc3]);
  679. $mc4=addslashes($_POST[mc4]);
  680. $mc5=addslashes($_POST[mc5]);
  681.  
  682. mysql_query("update adminsettings set MerchantName1='$mn1'");
  683. mysql_query("update adminsettings set MerchantCode1='$mc1'");
  684. mysql_query("update adminsettings set MerchantName2='$mn2'");
  685. mysql_query("update adminsettings set MerchantCode2='$mc2'");
  686. mysql_query("update adminsettings set MerchantName3='$mn3'");
  687. mysql_query("update adminsettings set MerchantCode3='$mc3'");
  688. mysql_query("update adminsettings set MerchantName4='$mn4'");
  689. mysql_query("update adminsettings set MerchantCode4='$mc4'");
  690. mysql_query("update adminsettings set MerchantName5='$mn5'");
  691. mysql_query("update adminsettings set MerchantCode5='$mc5'");
  692.  
  693.       $sql_u="update badminsettings set
  694.   maxban='$_POST[maxban]',
  695.   showban='$_POST[showban]'";
  696.       $rs=mysql_query($sql_u);
  697.  
  698.       $sql_u="update tadminsettings set
  699.   maxads='$_POST[maxads]',
  700.   nads='$_POST[nads]'";
  701.       $rs=mysql_query($sql_u);
  702.  
  703.  
  704.     echo("<br><br><b>Records Successfully Updated</b><br><br>");
  705.     }
  706.   }
  707.  
  708.  
  709. elseif($b=="steps") {
  710. ?>
  711. <center>
  712. <table width=90%><tr><td>
  713. <font face=verdana size=2><br><br>
  714. Visit <a href='https://www.payza.com/' target=_blank>https://www.payza.com/</a>
  715. <br><br>
  716. 1. Login to your Payza account. <br>
  717. 2. Go to "My Profile"<br>
  718. 3. Click "Business Accounts"<br>
  719. 4. Click "Add"<br>
  720. 5. Fill out the form using an email address relating to your site, such as sales@domain.com.<br>
  721. 6. Under IPN Setup:<br>
  722. a. Check "Enable IPN"<br>
  723. b. Set the Alert URL to:<br>
  724. <? echo $siteurl; ?>/alertpayipn.php<br>
  725. c. Enter a security Code.<br>
  726. 7. Submit the form.<br>
  727. 8. After this business email is added, go back into it by clicking "edit"<br>
  728. 9. Scroll down and copy the "Encrypted Security Code". <br>
  729. 10. Login to your admin area and click on the Admin Settings link and enter the Encrypted Security Code.
  730. <br><br>
  731. All finished... <br><br>
  732.  
  733. </font>
  734. </td></tr></table></center>
  735. <?
  736. }
  737.  
  738.  
  739. elseif($b=="9111") {
  740. $rs=mysql_query("select * from testimonials where status=1");
  741.  
  742. if(mysql_num_rows($rs)>0) {
  743. echo("<br><center><h3>Approved Testimonials</h3></center><table width=90% border=1 cellspacing=0 cellpadding=0><tr><Td width=15 align=center>ID</td><td width=90 align=center>Member</td><td width=450 align=center>Testimonial</td><td width=90 align=center>Date</td><td align=center valign=center>Action</td></tr>");
  744. while($arr=mysql_fetch_array($rs)) {
  745. echo("<tr><Td align=center>".$arr[0]."</td><Td align=center>".$arr[1]."</td><Td align=center><font face=verdana size=2>".str_replace("\n","<br>",$arr[2])."</td><Td align=center>".$arr[4]."</td><Td align=center>");
  746. echo("<form action=admin.php method=post><input type=hidden name=id value=".$arr[0].">&nbsp;<input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"EditT\">&nbsp;<input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"DeleteTestimonial\"></form></td></tr>");
  747. }
  748. echo("</table>");
  749. }
  750. else {
  751. echo("<br><center><br><b>No Pending Accounts Records Found !</b></center>");
  752. }
  753. }
  754.  
  755. //**************************************************************
  756. elseif($b=="9112") {
  757. $rs=mysql_query("select * from testimonials where status=0");
  758.  
  759. if(mysql_num_rows($rs)>0) {
  760. echo("<br><center><h3>Pending Testimonials</h3></center><table width=90% border=1 cellspacing=0 cellpadding=0><tr><Td width=15 align=center>ID</td><td width=90 align=center>Member</td><td width=450 align=center>Testimonial</td><td width=90 align=center>Date</td><td align=center valign=center>Action</td></tr>");
  761. while($arr=mysql_fetch_array($rs)) {
  762. echo("<tr><Td align=center>".$arr[0]."</td><Td align=center>".$arr[1]."</td><Td align=left><font face=verdana size=2>".str_replace("\n","<br>",$arr[2])."</td><Td align=center>".$arr[4]."</td><Td align=center>");
  763. echo("<form action=admin.php method=post><input type=hidden name=id value=".$arr[0]."><input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"VerifyT\">&nbsp;<input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"EditT\">&nbsp;<input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"DeleteTestimonial\"></form></td></tr>");
  764. }
  765. echo("</table>");
  766. }
  767. else {
  768. echo("<br><center><br><b>No Pending Accounts Records Found !</b></center>");
  769. }
  770. }
  771.  
  772.  
  773. //**************************************************************
  774. elseif($b=="EditT") {
  775. if($_POST["data"]!="") {
  776. mysql_query("update testimonials set data='$_POST[data]' where ID=$_POST[id]");
  777. echo("<br><center><b>Record Successfully Updated</b><br></center>");
  778. }
  779.  
  780. $rs=mysql_query("select * from testimonials where ID=".$_POST["id"]);
  781. echo("<br><center><h3>Modify Testimonial</h3></center><table width=90% border=1 cellspacing=0 cellpadding=0><tr><Td width=15 align=center>ID</td><td width=90 align=center>Member</td><td width=450 align=center>Testimonial</td><td width=90 align=center>Date</td><td align=center valign=center>Action</td></tr>");
  782. while($arr=mysql_fetch_array($rs)) {
  783. echo("<tr><form action=admin.php method=post><Td align=center>".$arr[0]."</td><Td align=center>".$arr[1]."</td><Td align=left><textarea name=data rows=10 cols=50>".$arr[2]."</textarea></td><Td align=center>".$arr[4]."</td><Td align=center>");
  784. echo("<input type=hidden name=id value=".$arr[0]."><input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"EditT\">&nbsp;</form></td></tr>");
  785. }
  786. echo("</table>");
  787. }
  788.  
  789. //**************************************************************
  790. elseif($b=="DeleteTestimonial") {
  791. mysql_query("delete from testimonials where ID=".$_POST["id"]);
  792. echo("<br><b>Record Successfully Deleted");
  793. }
  794.  
  795.  
  796. //********************************
  797. elseif($b=="VerifyT") {
  798. mysql_query("Update testimonials set status=1 where ID=".$_POST["id"]);
  799. echo("<b>Record SuccessFully Updated!</b>");
  800. }
  801.  
  802.  
  803.  
  804.  
  805. elseif($b=="199") {
  806.   $_SESSION["revshradmarea"]="";
  807. session_unregister('revshradmarea');
  808. session_destroy();
  809. ?>
  810. <script>
  811. location.href='admin.php';
  812. </script>
  813. <?
  814. }
  815.  
  816.  
  817.   elseif ($b=="101")
  818.   {
  819. $editt=$_POST[editt];
  820. $edit=$_POST[edit];
  821. $idpage=$_POST[idpage];
  822.     // '**************************************************************
  823.     echo "<h3 align=center>Edit your Pages</h3>";
  824.     if ($edit!=1)
  825.     {
  826.       $sql = "select * from pages order by PName";
  827.       $result = mysql_query($sql);
  828.  
  829.       echo("<div align=center><br><form action='admin.php?b=101' method=post><input type=hidden name=edit value=1>"); ?>
  830.       Name of the page: <select name=idpage>
  831.        <?while ($p=mysql_fetch_array($result)){?>
  832.      <option value="<? echo $p[0]; ?>"><? echo $p[1]; ?></option>
  833.      <?}?> </select><br>
  834.      <?
  835.       echo("<input type=Submit style='' color:#000000; font-size:10pt; font-family:Verdana; font-weight:bold; border:1px ridge #000000; background-color:#B0D8DD  value='Edit Page'></form></div><br><br>");
  836.     }
  837.     else
  838.     {
  839.     if ($editt!=1) {
  840. $qry="select * from pages where ID = $_POST[idpage]";
  841. $npag=mysql_query($qry) or die ("Error" . mysql_error(). $qry);
  842. $np=mysql_fetch_array($npag);
  843. $np[2]=str_replace("</textarea>","&lt;/textarea&gt",$np[2]);
  844. $np[2]=str_replace("<textarea","&lt;textarea",$np[2]);
  845. ?>
  846.  
  847. <div align="center"><form method="POST" action="admin.php?b=101">
  848. <table><tr><td><font face=verdana size=2>Page Name:</font></td><td><font face=verdana size=2><? echo $np[1]; ?></font></td></tr>
  849. <tr><td><font face=verdana size=2>Page Contents:</font></td>
  850. <td><input type=hidden name=edit value=1>
  851. <input type=hidden name=editt value=1>
  852. <input type="hidden" name="id" value="<? echo $_POST[idpage]; ?>">
  853. <TEXTAREA NAME="desc" rows=15 cols=60><? echo stripslashes($np[2]); ?></TEXTAREA></td></tr>
  854. <tr><td colspan=2><input type=submit value="Save Page"></td></tr>
  855. </table>
  856.         </form>
  857. </div>
  858.  
  859.    <?
  860.     }
  861.     else {
  862.     $descc=addslashes($_POST[desc]);
  863.       mysql_query("update pages set pagedesc='$descc' where ID=$_POST[id]") or die ("Error:  ". mysql_error());
  864.     echo "<br><br><b>Page Successfully Updated</b><br><br>";
  865.     }
  866.    }
  867.   }
  868.  
  869.  
  870.  
  871. elseif ($b=="777") {
  872. print "<h3 align=center>Promotional Banners</h3><br><center>
  873. <br><font face=verdana size=2><b>Add a Banner that you want to show at 'Promotional Center' inside members area so that members can use it for promoting your site.</b>
  874. <br><form action=admin.php method=post>
  875. <b>Banner Url:</b><input type=text name=burl size=45 value='http://www.yoursitename.com/images/banner1.gif'> <input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"Add Banner\"></form><br></center>";
  876.  
  877. $rs=mysql_query("select * from banners order by ID");
  878. print "<center><br><b>View Banners</b><br>";
  879. print "<table border=1 cellspacing=1 cellpadding=1><tr><td align=center><font face-verdana size=2><b>ID</b></font></td><td align=center><font face-verdana size=2><b>Banner</b></font></td><td align=center><font face-verdana size=2><b>Date</b></font></td><td align=center><font face-verdana size=2><b>Action</b></font></td></tr>";
  880.     while($arr=mysql_fetch_array($rs))  {
  881.     print "<tr><Td align=center><font face=verdana size=2>$arr[0]</font></td><Td align=center><font face=verdana size=2><img src='$arr[1]'><br>$arr[1]</font></td><Td align=center><font face=verdana size=2>$arr[2]</font></td><Td align=center>";
  882.     print "<form action=admin.php method=post><input type=hidden name=id value=".$arr[0].">&nbsp;<input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"DeleteB\"></form></td></tr>";
  883.     }
  884.    print "</table></center>";
  885. }
  886.  
  887. //**************************************************************
  888. elseif ($b=="Add Banner") {
  889. $rs=mysql_query("insert into banners(BannerURL,Date) values('$_POST[burl]',now())");
  890. print "<b><br>Record SuccessFully Added</b><br>";
  891. }
  892.  
  893. //**************************************************************
  894. elseif ($b=="DeleteB") {
  895. $rs=mysql_query("delete from banners where ID=".$_POST["id"]);
  896. print "<br><b>Record Successfully Deleted</b><br>";
  897. }
  898.  
  899.  
  900.  
  901. elseif ($b=="778") {
  902. print "<h3 align=center>Promotional SoloAds</h3><br>
  903. <br><font face=verdana size=2><b>Add a Solo Ad that you want to show at 'Promotional Center' inside members area so that members can use it for promoting your site.</b><br>
  904. You can use the following tags for personalized Solo Ads and these will automatically get replaced by user information.<br><br>
  905. {name} for Name of the member<br>
  906. {username} for username of the member<br>
  907. {refurl} for the Referral Url of the member<br>
  908.  
  909. <br><form action=admin.php method=post>
  910. <b>Subject:</b><input type=text name=subject size=35 value=''><br>
  911. <b>Message:</b><textarea name=message rows=10 cols=60></textarea><br>
  912. <input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"Add SoloAd\"></form><br>";
  913.  
  914. $rs=mysql_query("select * from soloads order by ID");
  915. print "<center><br><b>View Solo Ads</b><br>";
  916. print "<table border=1 cellspacing=1 cellpadding=1><tr><td align=center><font face-verdana size=2><b>ID</b></font></td><td align=center width=500><font face-verdana size=2><b>Solo Ad</b></font></td><td align=center><font face-verdana size=2><b>Date</b></font></td><td align=center><font face-verdana size=2><b>Action</b></font></td></tr>";
  917.     while($arr=mysql_fetch_array($rs))  {
  918.     print "<tr><Td align=center><font face=verdana size=2>$arr[0]</font></td><Td align=center><font face=verdana size=2>Subject: ".stripslashes($arr[1])."
  919. <br>Message:<br>".stripslashes(str_replace("\n","<br>",$arr[2]))."</font></td><Td align=center><font face=verdana size=2>$arr[3]</font></td><Td align=center>";
  920.     print "<form action=admin.php method=post><input type=hidden name=id value=".$arr[0].">&nbsp;<input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"b\" value=\"DeleteS\"></form></td></tr>";
  921.     }
  922.    print "</table></center>";
  923. }
  924.  
  925. //**************************************************************
  926. elseif($b=="Add SoloAd") {
  927. if($_POST[subject]=="") {
  928. echo "<br><b>Subject can't be blank</b><br>";
  929. }
  930. elseif($_POST[message]=="") {
  931. echo "<br><b>Message can't be blank</b><br>";
  932. }
  933. else {
  934. $subject=addslashes($_POST[subject]);
  935. $message=addslashes($_POST[message]);
  936. mysql_query("insert into soloads(Subject,Message,Date) values('$subject','$message',now())");
  937. print "<b><br>Record SuccessFully Added</b><br>";
  938. }
  939. }
  940.  
  941. //**************************************************************
  942. elseif ($b=="DeleteS") {
  943. mysql_query("delete from soloads where ID=".$_POST["id"]);
  944. print "<br><b>Record Successfully Deleted</b><br>";
  945. }
  946.  
  947.  
  948. elseif($b=="200") {
  949. ?>
  950. <p>&nbsp;</p>
  951. <p><b><font face="Verdana" size="2">These notes will help you to
  952. begin to understand how your Membership Site works. </font></b></p>
  953. <p><b><font face="Verdana" size="2">Please read through these
  954. notes for any questions you may have in regards to any features in the admin
  955. area.</font></b></p>
  956. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Admin Settings&nbsp; **</font></b></p>
  957. <p><font size="2" face="Verdana"><b>Here is where you decide how your program will be run. </font></b>
  958. </p>
  959. <p>&nbsp;</p>
  960.  
  961. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Edit your Pages&nbsp; **</font></b></p>
  962. <p><b><font size="2" face="Verdana">Here you can update the contents of your Home Page, FAQ Page, Login Page and Logout Page. </font>
  963. </b>
  964. </p>
  965.  
  966. <p>&nbsp;</p>
  967. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Members List/Search Members&nbsp; **</font></b></p>
  968. <p><b><font face="Verdana" size="2">From here you can view/edit/delete the members records.</font></b></p>
  969. <p>&nbsp;</p>
  970. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Free Members/Pro Members/Pending Members&nbsp; **</font></b></p>
  971. <p><b><font face="Verdana" size="2">From here you can view/edit/delete the members of a particular category who is at free membership status or pro membership status or pending membership status.</font></b></p>
  972. <p>&nbsp;</p>
  973. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Top Sponsors&nbsp; **</font></b></p>
  974. <p><b><font face="Verdana" size="2">Here you can find the list of top 100 members who have referred maximum number of members to your site.</font></b></p>
  975. <p>&nbsp;</p>
  976. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Email Users&nbsp; **</font></b></p>
  977. <p><b><font face="Verdana" size="2">Use this section for updating your Members
  978.  about information on your Downline Builder.</font></b></p>
  979. <p>&nbsp;</p>
  980.  
  981. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Pending Transactions&nbsp; **</font></b></p>
  982. <p><b><font face="Verdana" size="2">Use this section to check all the transactions which are pending either due to non payment or non payza transactions which requires admin approval.</font></b></p>
  983. <p>&nbsp;</p>
  984.  
  985. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Position Details&nbsp; **</font></b></p>
  986. <p><b><font face="Verdana" size="2">Here you can see all the Positions purchased by your members.</font></b></p>
  987. <p>&nbsp;</p>
  988.  
  989. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Admin Earnings&nbsp; **</font></b></p>
  990. <p><b><font face="Verdana" size="2">Here you can see all the admin earning details.</font></b></p>
  991. <p>&nbsp;</p>
  992.  
  993. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Promotional Banners&nbsp; **</font></b></p>
  994. <p><b><font face="Verdana" size="2">Here you can add/view/delete the banners that you wants to provide to your members for promoting your site with there referral url.</font></b></p>
  995. <p>&nbsp;</p>
  996. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Promotional Solo Ads&nbsp; **</font></b></p>
  997. <p><b><font face="Verdana" size="2">Here you can add/view/delete the solo ads that you wants to provide to your members for promoting your site with there referral url.</font></b></p>
  998. <p>&nbsp;</p>
  999. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Completed Withdrawals&nbsp; **</font></b></p>
  1000. <p><b><font face="Verdana" size="2">This section lets you know that how much you had paid till now and to which members.</font></b></p>
  1001. <p>&nbsp;</p>
  1002. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Pending Withdrawals&nbsp; **</font></b></p>
  1003. <p><b><font face="Verdana" size="2">This section will show you the list of all the pending withdrawals which members had requested and hasn't been paid yet.</font></b></p>
  1004. <p>&nbsp;</p>
  1005. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Masspay&nbsp; **</font></b></p>
  1006. <p><b><font face="Verdana" size="2">This section will show you the list of all the pending payza withdrawals which members had requested and hasn't been paid yet. You can pay all those transactions at once using this feature.</font></b></p>
  1007. <p>&nbsp;</p>
  1008.  
  1009. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Add banners&nbsp; **</font></b></p>
  1010. <p><b><font face="Verdana" size="2">This section will allow you to submit your own banners for rotation in the system.</font></b></p>
  1011. <p>&nbsp;</p>
  1012. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Approved banners&nbsp; **</font></b></p>
  1013. <p><b><font face="Verdana" size="2">This section lets you track the banners submitted by members and you can track the details of each banner.</font></b></p>
  1014. <p>&nbsp;</p>
  1015. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Pending banners&nbsp; **</font></b></p>
  1016. <p><b><font face="Verdana" size="2">This section will show you the list of all the pending banner and you can approve them after checking the contents.</font></b></p>
  1017. <p>&nbsp;</p>
  1018.  
  1019. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Add TextAds&nbsp; **</font></b></p>
  1020. <p><b><font face="Verdana" size="2">This section will allow you to submit your own Text Ads for rotation in the system.</font></b></p>
  1021. <p>&nbsp;</p>
  1022. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Approved Text Ads&nbsp; **</font></b></p>
  1023. <p><b><font face="Verdana" size="2">This section lets you track the Text Ads submitted by members and you can track the details of each Text Ad.</font></b></p>
  1024. <p>&nbsp;</p>
  1025. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Pending Text Ads&nbsp; **</font></b></p>
  1026. <p><b><font face="Verdana" size="2">This section will show you the list of all the pending Text Ad and you can approve them after checking the contents.</font></b></p>
  1027. <p>&nbsp;</p>
  1028.  
  1029. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Approved Testimonials&nbsp; **</font></b></p>
  1030. <p><b><font face="Verdana" size="2">This section lets you track the Testimonials submitted by members.</font></b></p>
  1031. <p>&nbsp;</p>
  1032. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; Pending Testimonials&nbsp; **</font></b></p>
  1033. <p><b><font face="Verdana" size="2">This section will show you the list of all the pending Testimonials submitted by members and you can approve them after checking the contents.</font></b></p>
  1034. <p>&nbsp;</p>
  1035.  
  1036. <p><b><font size="2" face="Verdana" color="#FF0000">**&nbsp; If you want to show members textads at your other websites or pages then you can use the code provided below:&nbsp; **</font></b></p>
  1037. <p><font size="2" face="Verdana"><b>
  1038. To show text ads in a horizontal ad box then just copy and paste the below code on any page where you want text ads to appear.<br>
  1039. <textarea rows=2 cols=90>
  1040. <script src="<? echo $siteurl; ?>/hortextads.php"></script>
  1041. </textarea>
  1042. <br><br>
  1043. To show text ads in a vertical ad box then just copy and paste the below code on any page where you want text ads to appear.<br>
  1044. <textarea rows=2 cols=90>
  1045. <script src="<? echo $siteurl; ?>/vertextads.php"></script>
  1046. </textarea>
  1047.  
  1048.  </font></b>
  1049. </p>
  1050.  
  1051.  
  1052. <p><b><font face="Verdana" size="2">However Please remember we
  1053. are always here to help you with anything that you may not understand or need
  1054. clarification on.&nbsp; So please never hesitate to </font><font face="Verdana" size="2" color="#FF0000"> <a href="http://www.yourfreeworld.com/script/contactus.asp" target=_blank>contact us</a></font><font face="Verdana" size="2">.</font><font face="Verdana" size="2" color="#FF0000">&nbsp; </font></b></p>
  1055. <p><b><font face="Verdana" size="2">
  1056. Wishing for your success<br>
  1057. Rohit Seth<br>
  1058. <a href=http://www.yourfreeworld.com/script target=_blank>http://www.yourfreeworld.com/script</a></font>
  1059. <br><br><font size="2" face="Verdana" color="#FF0000">
  1060. You can Add Value To Your Existing Business and Attract More Visitors To Your Site by offering quality inclusions products as bonus.<br>
  1061. Gain Instant Access To Over 850 Master Resale Rights products for less than $15<br>
  1062. <a href='http://www.masterresalerightsclub.com/' target=_blank>http://www.masterresalerightsclub.com/</a><br>
  1063. </font></b></p>
  1064. <?
  1065. }
  1066.  
  1067.  
  1068.  
  1069.   elseif (trim($b)==201)
  1070.   {
  1071.     $query="Select * from users where active=0 order by ID";
  1072.   $step=50;
  1073.   $currentpage = $p;
  1074.  
  1075.     $sql="select * from users where active=0";
  1076.   if(!$rs=mysql_query($sql))
  1077.   {
  1078.     print mysql_error();
  1079.     exit;
  1080.   }
  1081.   $row=mysql_num_rows($rs);
  1082.     $totallinks=$row;
  1083.   if(!isset($currentpage))
  1084.   {
  1085.     $currentpage=1;
  1086.   }
  1087.  
  1088.   if ($totallinks > 0)
  1089.   {
  1090.     if ($totallinks < 50)
  1091.     {
  1092.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  1093.     }
  1094.     else
  1095.     {
  1096.       if (($currentpage*50) > $totallinks)
  1097.       {
  1098.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  1099.       }
  1100.       else
  1101.       {
  1102.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  1103.       }
  1104.     }
  1105.   }
  1106.  
  1107.   if($totallinks > $step)
  1108.   {
  1109.     $pagecount=ceil($totallinks/$step);
  1110.     print "<br>Page NO - &nbsp;&nbsp;";
  1111.     for($i=1;$i<=$pagecount;$i++)
  1112.     {
  1113.       if($pageno==$i)
  1114.       {
  1115.         echo($i . " ");
  1116.       }
  1117.       else
  1118.       {
  1119.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  1120.       }
  1121.     }
  1122.     echo("<br><br><br>");
  1123.   }
  1124.   $start=($currentpage-1)*$step;
  1125.  
  1126.     $query="Select * from users where active=0 order by ID";
  1127.   $sql = $query . " LIMIT $start,$step";
  1128.  
  1129.   if(!$result=mysql_query($sql))
  1130.   {
  1131.     print mysql_error();
  1132.     exit;
  1133.   }
  1134.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>Record No.</b></td><td align=center><b>Name</b></td><td align=center valign=center><b>Email</b></td><td width=70 align=center><b>Username</b></td><td width=70 align=center><b>Status</b></td><td align=center><b>Action</b></td></tr>");
  1135.     while($rs=mysql_fetch_row($result))
  1136.     {
  1137.       $rowcount=$rowcount+1;
  1138.       $no = (intval($currentpage* 50)-50 + $rowcount);
  1139.     if($rs[10]==0) {
  1140.     $st="Inactive<br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Resend Verfication Email'><br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Verify Account'>";
  1141.     } else {
  1142.     if($rs[14]==1) {
  1143.     $st="Free";
  1144.     }
  1145.     else {
  1146.     $st="Pro";
  1147.     }   }
  1148.  
  1149.       echo("<tr><td align=center><form action='admin.php' method=post><input type=hidden name=id value=$rs[0]>".$no."</td><Td align=center>". $rs[1]."</td><Td align=center>". $rs[7]."</td><Td align=center>". $rs[8]."</td><Td align=center>". $st."</td><Td align=center valign=center>");
  1150.       echo("<input type=hidden name=atype value=".$number."><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='View Details'>&nbsp;&nbsp;");
  1151.       echo("<input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Delete Account'></form></td></tr>");
  1152.     }  // wend
  1153.     echo("</table>");
  1154.   }
  1155.  
  1156.  
  1157.  
  1158.   elseif ($b=="2")
  1159.   {
  1160.     echo "<h3 align=center>Search Members</h3>";
  1161.     if (!$_POST)
  1162.     {
  1163.       echo("<br><form action='admin.php?b=2' method=post><center>");
  1164.       echo("Enter Name/Username/Email of the member to Search<br><input type=text name=user><br><br>");
  1165.       echo("<input type=Submit style='' color:#000000; font-size:10pt; font-family:Verdana; font-weight:bold; border:1px ridge #000000; background-color:#B0D8DD  value='Search'></form></center>");
  1166.     }
  1167.     else
  1168.     {
  1169.     $user=$_POST[user];
  1170.     $sql="select * from users where Name like '%$user%' or Email like '%$user%' or Username like '%$user%'";
  1171.     $res=mysql_query($sql);
  1172.     if(mysql_num_rows($res)>0) {
  1173.     $rowcount=0;
  1174.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>Record No.</b></td><td align=center><b>Name</b></td><td align=center valign=center><b>Email</b></td><td width=70 align=center><b>Username</b></td><td width=70 align=center><b>Status</b></td><td align=center><b>Action</b></td></tr>");
  1175.     while($rs=mysql_fetch_row($res))
  1176.     {
  1177.     if($rs[10]==0) {
  1178.     $st="Inactive<br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Resend Verfication Email'><br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Verify Account'>";
  1179.     } else {
  1180.     if($rs[14]==1) {
  1181.     $st="Free";
  1182.     }
  1183.     else {
  1184.     $st="Pro";
  1185.     }   }
  1186.       $rowcount=$rowcount+1;
  1187.       $no = $rowcount;
  1188.       echo("<tr><form action='admin.php' method=post><input type=hidden name=id value=". $rs[0]."><td align=center>".$no."</td><Td align=center>". $rs[1]."</td><Td align=center>". $rs[7]."</td><Td align=center>". $rs[8]."</td><Td align=center>". $st."</td><Td align=center valign=center>");
  1189.       echo("<input type=hidden name=atype value=".$number."><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='View Details'>&nbsp;&nbsp;");
  1190.       echo("<input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Delete Account'></form></td></tr>");
  1191.     }  // wend
  1192.     echo("</table>");
  1193.     }
  1194.     else {
  1195.         echo "<br><br><b>No Results Found</b><br>";
  1196.     }
  1197.     }
  1198.   }
  1199.  
  1200.  
  1201.   elseif (trim($b)==21)
  1202.   {
  1203.     $query="Select * from users where active=1 and status=1 order by ID";
  1204.   $step=50;
  1205.   $currentpage = $p;
  1206.  
  1207.     $sql="select * from users where active=1 and status=1";
  1208.   if(!$rs=mysql_query($sql))
  1209.   {
  1210.     print mysql_error();
  1211.     exit;
  1212.   }
  1213.   $row=mysql_num_rows($rs);
  1214.     $totallinks=$row;
  1215.   if(!isset($currentpage))
  1216.   {
  1217.     $currentpage=1;
  1218.   }
  1219.  
  1220.   if ($totallinks > 0)
  1221.   {
  1222.     if ($totallinks < 50)
  1223.     {
  1224.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  1225.     }
  1226.     else
  1227.     {
  1228.       if (($currentpage*50) > $totallinks)
  1229.       {
  1230.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  1231.       }
  1232.       else
  1233.       {
  1234.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  1235.       }
  1236.     }
  1237.   }
  1238.  
  1239.   if($totallinks > $step)
  1240.   {
  1241.     $pagecount=ceil($totallinks/$step);
  1242.     print "<br>Page NO - &nbsp;&nbsp;";
  1243.     for($i=1;$i<=$pagecount;$i++)
  1244.     {
  1245.       if($pageno==$i)
  1246.       {
  1247.         echo($i . " ");
  1248.       }
  1249.       else
  1250.       {
  1251.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  1252.       }
  1253.     }
  1254.     echo("<br><br><br>");
  1255.   }
  1256.   $start=($currentpage-1)*$step;
  1257.  
  1258.     $query="Select * from users where active=1 and status=1 order by ID";
  1259.   $sql = $query . " LIMIT $start,$step";
  1260.  
  1261.   if(!$result=mysql_query($sql))
  1262.   {
  1263.     print mysql_error();
  1264.     exit;
  1265.   }
  1266.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>Record No.</b></td><td align=center><b>Name</b></td><td align=center valign=center><b>Email</b></td><td width=70 align=center><b>Username</b></td><td width=70 align=center><b>Status</b></td><td align=center><b>Action</b></td></tr>");
  1267.     while($rs=mysql_fetch_row($result))
  1268.     {
  1269.       $rowcount=$rowcount+1;
  1270.       $no = (intval($currentpage* 50)-50 + $rowcount);
  1271.     if($rs[10]==0) {
  1272.     $st="Inactive<br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Resend Verfication Email'><br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Verify Account'>";
  1273.     } else {
  1274.     if($rs[14]==1) {
  1275.     $st="Free";
  1276.     }
  1277.     else {
  1278.     $st="Pro";
  1279.     }   }
  1280.       echo("<tr><form action='admin.php' method=post><input type=hidden name=id value=". $rs[0]."><td align=center>".$no."</td><Td align=center>". $rs[1]."</td><Td align=center>". $rs[7]."</td><Td align=center>". $rs[8]."</td><Td align=center>". $st."</td><Td align=center valign=center>");
  1281.       echo("<input type=hidden name=atype value=".$number."><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='View Details'>&nbsp;&nbsp;");
  1282.       echo("<input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Delete Account'></form></td></tr>");
  1283.     }  // wend
  1284.     echo("</table>");
  1285.  
  1286.   }
  1287.  
  1288.  
  1289.   elseif (trim($b)==22)
  1290.   {
  1291.     $query="Select * from users where active=1 and status=2 order by ID";
  1292.   $step=50;
  1293.   $currentpage = $p;
  1294.  
  1295.     $sql="select * from users where active=1 and status=2";
  1296.   if(!$rs=mysql_query($sql))
  1297.   {
  1298.     print mysql_error();
  1299.     exit;
  1300.   }
  1301.   $row=mysql_num_rows($rs);
  1302.     $totallinks=$row;
  1303.   if(!isset($currentpage))
  1304.   {
  1305.     $currentpage=1;
  1306.   }
  1307.  
  1308.   if ($totallinks > 0)
  1309.   {
  1310.     if ($totallinks < 50)
  1311.     {
  1312.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  1313.     }
  1314.     else
  1315.     {
  1316.       if (($currentpage*50) > $totallinks)
  1317.       {
  1318.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  1319.       }
  1320.       else
  1321.       {
  1322.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  1323.       }
  1324.     }
  1325.   }
  1326.  
  1327.   if($totallinks > $step)
  1328.   {
  1329.     $pagecount=ceil($totallinks/$step);
  1330.     print "<br>Page NO - &nbsp;&nbsp;";
  1331.     for($i=1;$i<=$pagecount;$i++)
  1332.     {
  1333.       if($pageno==$i)
  1334.       {
  1335.         echo($i . " ");
  1336.       }
  1337.       else
  1338.       {
  1339.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  1340.       }
  1341.     }
  1342.     echo("<br><br><br>");
  1343.   }
  1344.   $start=($currentpage-1)*$step;
  1345.  
  1346.     $query="Select * from users where active=1 and status=2 order by ID";
  1347.   $sql = $query . " LIMIT $start,$step";
  1348.  
  1349.   if(!$result=mysql_query($sql))
  1350.   {
  1351.     print mysql_error();
  1352.     exit;
  1353.   }
  1354.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>Record No.</b></td><td align=center><b>Name</b></td><td align=center valign=center><b>Email</b></td><td width=70 align=center><b>Username</b></td><td width=70 align=center><b>Status</b></td><td align=center><b>Action</b></td></tr>");
  1355.     while($rs=mysql_fetch_row($result))
  1356.     {
  1357.       $rowcount=$rowcount+1;
  1358.       $no = (intval($currentpage* 50)-50 + $rowcount);
  1359.     if($rs[10]==0) {
  1360.     $st="Inactive<br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Resend Verfication Email'><br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Verify Account'>";
  1361.     } else {
  1362.     if($rs[14]==1) {
  1363.     $st="Free";
  1364.     }
  1365.     else {
  1366.     $st="Pro";
  1367.     }   }
  1368.       echo("<form action='admin.php' method=post><input type=hidden name=id value=". $rs[0]."><tr><td align=center>".$no."</td><Td align=center>". $rs[1]."</td><Td align=center>". $rs[7]."</td><Td align=center>". $rs[8]."</td><Td align=center>". $st."</td><Td align=center valign=center>");
  1369.       echo("<input type=hidden name=atype value=".$number."><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='View Details'>&nbsp;&nbsp;");
  1370.       echo("<input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Delete Account'></form></td></tr>");
  1371.     }  // wend
  1372.     echo("</table>");
  1373.  
  1374.   }
  1375.  
  1376.  
  1377. elseif($b==99) {
  1378. include "config.php";
  1379. $rs=mysql_query("select * from users where active=1");
  1380. $i=0;
  1381. while($arr=mysql_fetch_array($rs)) {
  1382. if($arr[11]=="") {
  1383. }
  1384. else {
  1385. $a[$i]=$arr[8];
  1386. $bb[$i]=$arr[11];
  1387. $i++;
  1388. }
  1389. }
  1390.  
  1391. if($i>0) {
  1392. $e=my_array_unique($bb);
  1393. for($j=0;$j<count($e);$j++) {
  1394. $c[$j]=0;
  1395. }
  1396.  
  1397. for($j=0;$j<count($e);$j++) {
  1398.    for($l=0;$l<count($bb);$l++) {
  1399.     if($bb[$l]==$e[$j]) {
  1400.         $c[$j]=$c[$j]+1;
  1401.     }
  1402.    }
  1403. }
  1404.  
  1405.  
  1406. $rs=mysql_query("drop table topref");
  1407. $rs=mysql_query("create table topref( ID text,ref int unsigned not null)");
  1408.  
  1409. for($j=0;$j<count($e);$j++) {
  1410. $rs=mysql_query("insert into topref values('$e[$j]','$c[$j]')");
  1411. }
  1412.  
  1413. echo "<h2 align=center> Top 100 Sponsors </h2><font face=verdana size=2><center>";
  1414. $rs=mysql_query("select * from topref order by ref desc limit 0,100");
  1415. while($arr=mysql_fetch_array($rs)) {
  1416. $rs1=mysql_query("select * from users where Username='$arr[0]'");
  1417. $arr1=mysql_fetch_array($rs1);
  1418. $rs2=mysql_query("select * from users where status=2 and active=1 and ref_by='$arr[0]'");
  1419. $rs3=mysql_query("select * from users where status=1 and active=1 and ref_by='$arr[0]'");
  1420. echo "<br> User:$arr[0] have $arr[1] Referrals (".mysql_num_rows($rs2)." pro & ".mysql_num_rows($rs3)." free referrals)";
  1421. }
  1422. }
  1423. else {
  1424. echo "<br><br><Center>No Record Found with any sponsor</center><br><br>";
  1425. }
  1426.  
  1427. }
  1428.  
  1429.  
  1430.  
  1431.  
  1432.   elseif (trim($b)==1)
  1433.   {
  1434.     $query="Select * from users order by ID";
  1435.     membersrecords($query,1, $b,$p);
  1436.   }
  1437.  
  1438.  
  1439.  
  1440.   elseif (trim($b)=="View Details")
  1441.   {
  1442.     $id=$_POST[id];
  1443.     $sql = "select * from users where id=". $_POST[id] ;
  1444.     $result = mysql_query($sql);
  1445.     $rs  =  mysql_fetch_row($result);
  1446.  
  1447.     echo("<table><br><form action='admin.php' method=post><input type=hidden name=id value=".$id ."><input type=hidden name=atype value=".$atype.">");
  1448.     echo("<tr><td colspan=2><h3><center>Member's Information</h3></td></tr>");
  1449.     echo("<tr><Td width=200><b>Name</b></td><td width=400>". $rs[1] ."</td></tr>");
  1450. if($showaddress==1) echo("<tr><Td width=200><b>Addres</b></td><td width=400>". $rs[2] . "</td></tr>");
  1451. if($showcity==1) echo("<tr><Td width=200><b>City</b></td><td width=400>". $rs[3] . "</td></tr>");
  1452. if($showstate==1) echo("<tr><Td width=200><b>State</b></td><td width=400>". $rs[4] . "</td></tr>");
  1453. if($showzip==1) echo("<tr><Td width=200><b>Zip</b></td><td width=400>". $rs[5] . "</td></tr>");
  1454. if($showcountry==1) echo("<tr><Td with=200><b>Country</b></td><td width=400>". $rs[6] . "</td></tr>");
  1455.     echo("<tr><Td width=200><b>Email</b></td><td width=400>". $rs[7] . "</td></tr>");
  1456.       if($rs[19]==0) {
  1457.     $mmstatus="Unsubscribed<br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Change to Subscribed'>";
  1458.       }
  1459.       else {
  1460.     $mmstatus="Subscribed";
  1461.       }
  1462.     echo("<tr><Td width=200><b>Admin Mailing Status</b></td><td width=400>".$mmstatus."</td></tr>");
  1463.     echo("<tr><Td width=200><b>Username</b></td><td width=400>". $rs[8] . "</td></tr>");
  1464.     echo("<tr><Td width=200><b>Password</b></td><td width=400>". $rs[9] . "</td></tr>");
  1465.     echo("<tr><Td width=200><b>Referred By</b></td><td width=400>". $rs[11] . "</td></tr>");
  1466. $rs1=mysql_query("select * from users where active=1 and ref_by='$rs[8]'");
  1467. $dref=mysql_num_rows($rs1);
  1468.     echo("<tr><Td width=200><b>Direct Referrals</b></td><td width=400>". $dref . "</td></tr>");
  1469.     echo("<tr><Td width=200><b>Total Earned</b></td><td width=400>$". $rs[15] . "</td></tr>");
  1470.     echo("<tr><Td width=200><b>Unpaid balance</b></td><td width=400>$". $rs[16] . "</td></tr>");
  1471.     echo("<tr><Td width=200><b>Paid Amount</b></td><td width=400>$". $rs[17] . "</td></tr>");
  1472.     echo("<tr><Td width=200><b>Banner Credits</b></td><td width=400>". $rs[20] . "</td></tr>");
  1473.     echo("<tr><Td width=200><b>Unused Banner Credits</b></td><td width=400>". ($rs[20]-$rs[21]) . "</td></tr>");
  1474.     echo("<tr><Td width=200><b>Used Banner Credits</b></td><td width=400>". $rs[21] . "</td></tr>");
  1475.     echo("<tr><Td width=200><b>Text Ads Credits</b></td><td width=400>". $rs[22] . "</td></tr>");
  1476.     echo("<tr><Td width=200><b>Unused Text Ads Credits</b></td><td width=400>". ($rs[22]-$rs[23]) . "</td></tr>");
  1477.     echo("<tr><Td width=200><b>Used Text Ads Credits</b></td><td width=400>". $rs[23] . "</td></tr>");
  1478.     echo("<tr><Td width=200><b>IP</b></td><td width=400>". $rs[12] . "</td></tr>");
  1479.     if($rs[10]==0) {
  1480.     echo("<tr><Td width=200><b>Status</b></td><td width=400>Inactive<br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Resend Verfication Email'><br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Verify Account'></td></tr>");
  1481.     } else {
  1482.     if($rs[14]==1) {
  1483.     echo("<tr><Td width=200><b>Status</b></td><td width=400>Free</td></tr>");
  1484.     }
  1485.     else {
  1486.     echo("<tr><Td width=200><b>Status</b></td><td width=400>Pro</td></tr>");
  1487.     }   }
  1488.     echo("<tr><Td width=200><b>Date . Time of Registration</b></td><td width=400>". $rs[13] . "</td></tr>");
  1489.  
  1490.       echo("<tr><Td width=200><b>Positions Details</b></td><td width=400></td></tr><tr><td colspan=2>");
  1491.  
  1492. $result=mysql_query("Select * from moneypool where Username='$rs[8]' order by ID");
  1493. if(mysql_num_rows($result)>0) {
  1494.  
  1495.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=70><font face=verdana size=2><b>Order #</b></font></td><td align=center valign=center><font face=verdana size=2><b>PaymentMode</b></font></td><td width=70 align=center><font face=verdana size=2><b>Amount Invested</b></font></td><td width=70 align=center><font face=verdana size=2><b>Earning</b></font></td><td align=center><font face=verdana size=2><b>Purchased Date</b></font></td><td align=center><font face=verdana size=2><b>Last Updated On</b></font></td></tr>");
  1496.     while($rss=mysql_fetch_row($result))
  1497.     {
  1498.       echo("<tr><td align=center><font face=verdana size=2>".$rss[0]."</font></td><td align=center><font face=verdana size=2>". $rss[2]."</font></td><td align=center><font face=verdana size=2>$". $rss[4]."</font></td><td align=center><font face=verdana size=2>$". $rss[5]."</font></td><td align=center><font face=verdana size=2>".$rss[7]."</font></td><td align=center><font face=verdana size=2>".$rss[8]."</font></td></tr>");
  1499.     }
  1500.     echo("</table>");
  1501.  
  1502. }
  1503. else {
  1504.     echo "<b>No Position Details Found</b></center>";
  1505. }
  1506. echo "</td></tr>";
  1507.  
  1508.     echo("<tr><Td width=200><b>Withdrawal Details</b></td><td width=400></td></tr><tr><td colspan=2>");
  1509.  
  1510.  
  1511.     $sql="Select * from wtransaction where Username='$rs[8]' order by ID";
  1512.     $wrs=mysql_query($sql);
  1513.     if(mysql_num_rows($wrs)>0) {
  1514.     $rc=0;
  1515.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><font face=verdana size=2><b>ID.</b></font></td><td align=center valign=center><font face=verdana size=2><b>PaymentMode</b></font></td><td width=70 align=center><font face=verdana size=2><b>Amount</b></font></td><td width=70 align=center><font face=verdana size=2><b>Date</b></font></td><td width=70 align=center><font face=verdana size=2><b>Status</b></font></td></tr>");
  1516.     while($rss=mysql_fetch_row($wrs))
  1517.     {
  1518.     $rc=$rc+1;
  1519.     if($rss[4]==1) {
  1520.         $status="Approved";
  1521.     }
  1522.     else {
  1523.         $status="Pending";
  1524.     }
  1525.       echo("<tr><td align=center><font face=verdana size=2>".$rc."</font></td><Td align=center><font face=verdana size=2>". $rss[2]."</font></td><Td align=center><font face=verdana size=2>$". $rss[3]."</font></td><Td align=center><font face=verdana size=2>". $rss[5]."</font></td><Td align=center><font face=verdana size=2>". $status."</font></td></tr>");
  1526.     }
  1527.     echo("</table>");
  1528.     }
  1529.     else {
  1530.     echo "<b>No Records Found</b>";
  1531.     }
  1532.  
  1533. echo "</td></tr>";
  1534.       echo("<tr><Td width=200><b>Referrals Details</b></td><td width=400></td></tr><tr><td colspan=2>");
  1535. $result=mysql_query("Select * from users where ref_by='$rs[8]' order by ID");
  1536. if(mysql_num_rows($result)>0) {
  1537. $rc=0;
  1538. echo "<table width=500><tr>
  1539. <td width=150><font face=verdana size=2><b>Name</b></font></td>
  1540. <td width=150><font face=verdana size=2><b>Email</b></font></td>
  1541. <td width=100><font face=verdana size=2><b>Amount Invested</b></font></td>
  1542. <td width=100><font face=verdana size=2><b>Date Joined</b></font></td>
  1543. </tr>";
  1544.     while($rss=mysql_fetch_row($result))
  1545.     {
  1546.     $rp=mysql_query("Select sum(Amount) from moneypool where Username='$rss[8]'");
  1547.     $arp=mysql_fetch_array($rp);
  1548.     $iamount=$arp[0];
  1549.     if($iamount=="") { $iamount=0; }
  1550. echo "<tr>
  1551. <td ><font face=verdana size=2>$rss[1]</font></td>
  1552. <td ><font face=verdana size=2><A href=mailto:$rss[7]>$rss[7]</a></font></td>
  1553. <td ><font face=verdana size=2>$$iamount</font></td>
  1554. <td ><font face=verdana size=2>$rss[13]</font></td>
  1555. </tr>";
  1556.     }
  1557.     echo("</table>");
  1558.  
  1559. }
  1560. else {
  1561.     echo "<b>No Referrals Found</b>";
  1562. }
  1563.  
  1564.  
  1565. echo "</td></tr>";
  1566.  
  1567.     echo("<tr><Td colspan=2><p>&nbsp;</p></td></tr>");
  1568.     echo("<tr><td colspan=2>");
  1569.     echo("<input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Edit Details'>&nbsp;&nbsp;");
  1570.     echo("<input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Delete Account'></form></td></tr></table>");
  1571.   }
  1572.  
  1573.  elseif($b=="Verify Account") {
  1574.     $id=$_POST[id];
  1575. mysql_query("update users set active=1 where id=$id");
  1576.     $sql = "select * from users where id=".$id ;
  1577.     $result = mysql_query($sql);
  1578.     $rs  =  mysql_fetch_row($result);
  1579.     echo("<br><b>Account Successfully verified</b><br>");
  1580.   $to = $rs[7];
  1581.  
  1582. $message1=$message2;
  1583. $message1=str_replace("{name}","$rs[1]",$message1);
  1584. $message1=str_replace("{email}","$rs[7]",$message1);
  1585. $message1=str_replace("{username}","$rs[8]",$message1);
  1586. $message1=str_replace("{password}","$rs[9]",$message1);
  1587. $message1=str_replace("{sitename}","$sitename",$message1);
  1588. $message1=str_replace("{siteurl}","$siteurl",$message1);
  1589. $message1=str_replace("{refname}","$rs[1]",$message1);
  1590. $message1=str_replace("{refemail}","$rs[7]",$message1);
  1591. $message1=str_replace("{refusername}","$rs[8]",$message1);
  1592.  
  1593. $subject1=str_replace("{name}","$rs[1]",$subject2);
  1594. $subject1=str_replace("{email}","$rs[7]",$subject1);
  1595. $subject1=str_replace("{username}","$rs[8]",$subject1);
  1596. $subject1=str_replace("{password}","$rs[9]",$subject1);
  1597. $subject1=str_replace("{sitename}","$sitename",$subject1);
  1598. $subject1=str_replace("{siteurl}","$siteurl",$subject1);
  1599. $subject1=str_replace("{refname}","$rs[1]",$subject1);
  1600. $subject1=str_replace("{refemail}","$rs[7]",$subject1);
  1601. $subject1=str_replace("{refusername}","$rs[8]",$subject1);
  1602.       $message=stripslashes($message1);
  1603.       $subject=stripslashes($subject1);
  1604.  
  1605. $from=$webmasteremail;
  1606.         $header = "From: $sitename<$from>\n";
  1607. if($eformat2==1)
  1608.     $header .="Content-type: text/plain; charset=iso-8859-1\n";
  1609. else
  1610.     $header .="Content-type: text/html; charset=iso-8859-1\n";
  1611.     $header .= "Reply-To: <$from>\n";
  1612.     $header .= "X-Sender: <$from>\n";
  1613.     $header .= "X-Mailer: PHP4\n";
  1614.     $header .= "X-Priority: 3\n";
  1615.     $header .= "Return-Path: <$from>\n";
  1616.  
  1617.   mail($to,$subject,$message,$header);
  1618.  
  1619. if($refnotification==1) {
  1620. $ref_by=$rs[11];
  1621. $rs1=mysql_query("select * from users where Username='$ref_by'");
  1622. if(mysql_num_rows($rs1)>0) {
  1623. $arr1=mysql_fetch_array($rs1);
  1624. $message1=$message3;
  1625. $message1=str_replace("{name}","$arr1[1]",$message1);
  1626. $message1=str_replace("{email}","$arr1[7]",$message1);
  1627. $message1=str_replace("{username}","$arr1[8]",$message1);
  1628. $message1=str_replace("{password}","$arr1[9]",$message1);
  1629. $message1=str_replace("{sitename}","$sitename",$message1);
  1630. $message1=str_replace("{siteurl}","$siteurl",$message1);
  1631.  
  1632. $subject1=str_replace("{name}","$arr1[1]",$subject3);
  1633. $subject1=str_replace("{email}","$arr1[7]",$subject1);
  1634. $subject1=str_replace("{username}","$arr1[8]",$subject1);
  1635. $subject1=str_replace("{password}","$arr1[9]",$subject1);
  1636. $subject1=str_replace("{sitename}","$sitename",$subject1);
  1637. $subject1=str_replace("{siteurl}","$siteurl",$subject1);
  1638.       $message=stripslashes($message1);
  1639.       $subject=stripslashes($subject1);
  1640.  
  1641.     $to = $arr1[7];
  1642.         $header = "From: $sitename<$from>\n";
  1643. if($eformat3==1)
  1644.     $header .="Content-type: text/plain; charset=iso-8859-1\n";
  1645. else
  1646.     $header .="Content-type: text/html; charset=iso-8859-1\n";
  1647.     $header .= "Reply-To: <$from>\n";
  1648.     $header .= "X-Sender: <$from>\n";
  1649.     $header .= "X-Mailer: PHP4\n";
  1650.     $header .= "X-Priority: 3\n";
  1651.     $header .= "Return-Path: <$from>\n";
  1652.  
  1653.     mail($to,$subject,$message,$header);
  1654. }
  1655. }
  1656.  
  1657.  
  1658.  
  1659.   }
  1660.  
  1661.   elseif($b=="Resend Verfication Email")
  1662.   {
  1663.     $id=$_POST[id];
  1664.  
  1665.     $sql = "select * from users where id=".$id ;
  1666.     $result = mysql_query($sql);
  1667.     $rs  =  mysql_fetch_row($result);
  1668.     $to=$rs[7];
  1669. $validationurl="$siteurl/confirm.php?username=$rs[8]&id=$rs[0]";
  1670. $message1=str_replace("{validationurl}","$validationurl",$message1);
  1671. $message1=str_replace("{name}","$rs[1]",$message1);
  1672. $message1=str_replace("{email}","$rs[7]",$message1);
  1673. $message1=str_replace("{username}","$rs[8]",$message1);
  1674. $message1=str_replace("{password}","$rs[9]",$message1);
  1675. $message1=str_replace("{sitename}","$sitename",$message1);
  1676. $message1=str_replace("{siteurl}","$siteurl",$message1);
  1677.  
  1678. $subject1=str_replace("{name}","$rs[1]",$subject1);
  1679. $subject1=str_replace("{email}","$rs[7]",$subject1);
  1680. $subject1=str_replace("{username}","$rs[8]",$subject1);
  1681. $subject1=str_replace("{password}","$rs[9]",$subject1);
  1682. $subject1=str_replace("{sitename}","$sitename",$subject1);
  1683. $subject1=str_replace("{siteurl}","$siteurl",$subject1);
  1684.       $message=stripslashes($message1);
  1685.       $subject=stripslashes($subject1);
  1686.  
  1687. $from=$webmasteremail;
  1688.         $header = "From: $sitename<$from>\n";
  1689. if($eformat1==1)
  1690.     $header .="Content-type: text/plain; charset=iso-8859-1\n";
  1691. else
  1692.     $header .="Content-type: text/html; charset=iso-8859-1\n";
  1693.     $header .= "Reply-To: <$from>\n";
  1694.     $header .= "X-Sender: <$from>\n";
  1695.     $header .= "X-Mailer: PHP4\n";
  1696.     $header .= "X-Priority: 3\n";
  1697.     $header .= "Return-Path: <$from>\n";
  1698.   mail($to,$subject,$message,$header);
  1699.  
  1700.     echo("<br><b>Confirmation Email has been send to ". $rs[7]);
  1701.  
  1702.   }
  1703.  
  1704.   elseif($b=="Change to Subscribed") {
  1705.     $rs=mysql_query("select * from users where ID=$_POST[id]");
  1706.     $arr=mysql_fetch_array($rs);
  1707.     if($arr[19]==1) {
  1708.         echo "<br><b>Mailing Status is already subscribed</b><br>";
  1709.     }
  1710.     else {
  1711.         $rs=mysql_query("update users set subscribed=1 where ID=$_POST[id]");
  1712.         echo "<br><b>Mailing Subscription status successfully changed</b><br>";
  1713.     }
  1714.   }
  1715.  
  1716.  
  1717.   else if ($b=="Edit Details")
  1718.   {
  1719.     $id=$_POST[id];
  1720.     if ($_POST[edit]!=1)
  1721.     {
  1722.       $sql = "select * from users where id=". $_POST[id] ;
  1723.       $result = mysql_query($sql);
  1724.       $rs  =  mysql_fetch_row($result);
  1725.       echo("<table><br><form action='admin.php' method=post><input type=hidden name=id value=".$id."><input type=hidden name=edit value=1>");
  1726.       echo("<tr><td colspan=2><h3><center>Update Member's Information</h3></td></tr>");
  1727.       echo("<tr><Td width=200><b>Name</b></td><td width=400><input type=text name=name value='". $rs[1] . "'></td></tr>");
  1728. if($showaddress==1)       echo("<tr><Td width=200><b>Addres</b></td><td width=400><input type=text name=address value='". $rs[2] . "'></td></tr>");
  1729. if($showcity==1)       echo("<tr><Td width=200><b>City</b></td><td width=400><input type=text name=city value='". $rs[3] . "'></td></tr>");
  1730. if($showstate==1)       echo("<tr><Td width=200><b>State</b></td><td width=400><input type=text name=state value='". $rs[4] . "'></td></tr>");
  1731. if($showzip==1)       echo("<tr><Td width=200><b>Zip</b></td><td width=400><input type=text name=zip value='". $rs[5] . "'></td></tr>");
  1732. if($showcountry==1)       echo("<tr><Td width=200><b>Country</b></td><td width=400><input type=text name=country value='". $rs[6] . "'></td></tr>");
  1733.       echo("<tr><Td width=200><b>Email</b></td><td width=400><input type=text name=email value='". $rs[7] . "'></td></tr>");
  1734.       echo("<tr><Td width=200><b>Username</b></td><td width=400><b>". $rs[8] . "</b></td></tr>");
  1735.       echo("<tr><Td width=200><b>Password</b></td><td width=400><input type=text name=password value='". $rs[9] . "'></td></tr>");
  1736.       echo("<tr><Td width=200><b>Banner Credits</b></td><td width=400><input type=text name=bc value='". $rs[20] . "'></td></tr>");
  1737.       echo("<tr><Td width=200><b>Used Banner Credits</b></td><td width=400><input type=text name=ubc value='". $rs[21] . "'></td></tr>");
  1738.       echo("<tr><Td width=200><b>Text Ad Credits</b></td><td width=400><input type=text name=tc value='". $rs[22] . "'></td></tr>");
  1739.       echo("<tr><Td width=200><b>Used Text Ad Credits</b></td><td width=400><input type=text name=utc value='". $rs[23] . "'></td></tr>");
  1740.       echo("<tr><Td colspan=2><p>&nbsp;</p></td></tr>");
  1741.       echo("<tr><td colspan=2>");
  1742.       echo("<input type=Submit style='' color:#000000; font-size:10pt; font-family:Verdana; font-weight:bold; border:1px ridge #000000; background-color:#B0D8DD name='b' value='Edit Details'></form></td></tr></table>");
  1743.     }
  1744.     else
  1745.     {
  1746.       $sql_u="update users set Name='".$_POST[name]."' where ID=".$_POST[id];
  1747.       $rs=mysql_query($sql_u);
  1748. if($showaddress==1) {
  1749.       $sql_u="update users set Address='".$_POST[address]."' where ID=".$_POST[id];
  1750.       $rs=mysql_query($sql_u);
  1751. } if($showcity==1) {
  1752.       $sql_u="update users set City='".$_POST[city]."' where ID=".$_POST[id];
  1753.       $rs=mysql_query($sql_u);
  1754. } if($showstate==1) {
  1755.       $sql_u="update users set State='".$_POST[state]."' where ID=".$_POST[id];
  1756.       $rs=mysql_query($sql_u);
  1757. } if($showzip==1) {
  1758.       $sql_u="update users set Zip='".$_POST[zip]."' where ID=".$_POST[id];
  1759.       $rs=mysql_query($sql_u);
  1760. } if($showcountry==1) {
  1761.       $sql_u="update users set Country='".$_POST[country]."' where ID=".$_POST[id];
  1762.       $rs=mysql_query($sql_u);
  1763. }
  1764.       $sql_u="update users set Email='".$_POST[email]."' where ID=".$_POST[id];
  1765.       $rs=mysql_query($sql_u);
  1766.       $sql_u="update users set Password='".$_POST[password]."' where ID=".$_POST[id];
  1767.       $rs=mysql_query($sql_u);
  1768.       $sql_u="update users set banners='".$_POST[bc]."' where ID=".$_POST[id];
  1769.       $rs=mysql_query($sql_u);
  1770.       $sql_u="update users set bannersused='".$_POST[ubc]."' where ID=".$_POST[id];
  1771.       $rs=mysql_query($sql_u);
  1772.       $sql_u="update users set textads='".$_POST[tc]."' where ID=".$_POST[id];
  1773.       $rs=mysql_query($sql_u);
  1774.       $sql_u="update users set textadsused='".$_POST[utc]."' where ID=".$_POST[id];
  1775.       $rs=mysql_query($sql_u);
  1776.       echo("<br><b>Record Successfully Updated<br><br>");
  1777.  
  1778.       $sql = "select * from users where id=". $_POST[id] ;
  1779.       $result = mysql_query($sql);
  1780.       $rs  =  mysql_fetch_row($result);
  1781.  
  1782.       echo("<table>");
  1783.       echo("<tr><td colspan=2><h3><center>Member's Information</h3></td></tr>");
  1784.       echo("<tr><Td width=200><b>Name</b></td><td width=400>". $rs[1] ."</td></tr>");
  1785. if($showaddress==1) echo("<tr><Td width=200><b>Addres</b></td><td width=400>". $rs[2] . "</td></tr>");
  1786. if($showcity==1) echo("<tr><Td width=200><b>City</b></td><td width=400>". $rs[3] . "</td></tr>");
  1787. if($showstate==1) echo("<tr><Td width=200><b>State</b></td><td width=400>". $rs[4] . "</td></tr>");
  1788. if($showzip==1) echo("<tr><Td width=200><b>Zip</b></td><td width=400>". $rs[5] . "</td></tr>");
  1789. if($showcountry==1) echo("<tr><Td with=200><b>Country</b></td><td width=400>". $rs[6] . "</td></tr>");
  1790.       echo("<tr><Td width=200><b>Email</b></td><td width=400>". $rs[7] . "</td></tr>");
  1791.       echo("<tr><Td width=200><b>Username</b></td><td width=400>". $rs[8] . "</td></tr>");
  1792.       echo("<tr><Td width=200><b>Password</b></td><td width=400>". $rs[9] . "</td></tr>");
  1793. echo("<tr><Td width=200>Banner Credits</td><td width=400>". $rs[20] . "</td></tr>");
  1794. echo("<tr><Td width=200>Unused Banner Credits</td><td width=400>". ($rs[20]-$rs[21]) . "</td></tr>");
  1795. echo("<tr><Td width=200>Used Banner Credits</td><td width=400>". $rs[21] . "</td></tr>");
  1796. echo("<tr><Td width=200>Text Ads Credits</td><td width=400>". $rs[22] . "</td></tr>");
  1797. echo("<tr><Td width=200>Unused Text Ads Credits</td><td width=400>". ($rs[22]-$rs[23]) . "</td></tr>");
  1798. echo("<tr><Td width=200>Used Text Ads Credits</td><td width=400>". $rs[23] . "</td></tr></table>");
  1799.  
  1800.     }
  1801.   }
  1802.  
  1803.  
  1804.   elseif(trim($b)=="Delete Account")
  1805.   {
  1806.     $id=$_POST[id];
  1807.     $rs=mysql_query("select * from users where ID=$id");
  1808.     $arr=mysql_fetch_array($rs);
  1809.     $sql_d="Delete from wtransaction where Username='" .  $arr[8] ."'" ;
  1810.     $rs_d=mysql_query($sql_d);
  1811.     $sql_d="Delete from memberstextads where Username='" .  $arr[8] ."'" ;
  1812.     $rs_d=mysql_query($sql_d);
  1813.     $sql_d="Delete from membersbanners where Username='" .  $arr[8] ."'" ;
  1814.     $rs_d=mysql_query($sql_d);
  1815.     $sql_d="Delete from moneypool where Username='" .  $arr[8] ."'" ;
  1816.     $rs_d=mysql_query($sql_d);
  1817.     $sql_d="Delete from users where ID=" .  $id ;
  1818.     $rs_d=mysql_query($sql_d);
  1819.     $sql_d="update users set ref_by='' where ref_by='" .  $arr[8] ."'" ;
  1820.     $rs_d=mysql_query($sql_d);
  1821.     echo("<br><b>Account Successfully Deleted");
  1822.   }
  1823.  
  1824.   elseif(trim($b)=="delpos")
  1825.   {
  1826.     $sql_d="Delete from moneypool where ID=" .  $id ;
  1827.     $rs_d=mysql_query($sql_d);
  1828.     echo("<br><b>Record Successfully Deleted");
  1829.   }
  1830.   elseif(trim($b)=="DeleteT")
  1831.   {
  1832.     $sql_d="Delete from transaction where ID=" .  $_POST[id] ;
  1833.     $rs_d=mysql_query($sql_d);
  1834.     echo("<br><b>Account Successfully Deleted");
  1835.   }
  1836.   elseif (trim($b)=="ApproveT")
  1837.   {
  1838.     $sql_rc = "select * from transaction where ID=".$_POST[id] ;
  1839.     $result = mysql_query($sql_rc);
  1840.     if(mysql_num_rows($result)>0) {
  1841.     $arr1  =  mysql_fetch_array($result);
  1842.  
  1843.     $amount=$arr1[3];
  1844.     $pmode=$arr1[2];
  1845.  
  1846. $package=(int)($amount/$profee);
  1847. $banners=$maxban*$package;
  1848. $textads=$maxads*$package;
  1849.  
  1850. echo "<br><b>$package Ad Package(s) of $".$amount." has been successfully approved.</b><br>";
  1851.  
  1852. mysql_query("update users set banners=banners+$banners,textads=textads+$textads,status=2 where Username='$arr1[1]'");
  1853.  
  1854. $rs1=mysql_query("select * from users where Username='$arr1[1]'");
  1855. $ar=mysql_fetch_array($rs1);
  1856. $ref_by=$ar[11];
  1857.  
  1858. for($i=1;$i<=$package;$i++) {
  1859. $amount=$profee;
  1860. $afee=($amount*$adminprofit)/100;
  1861. $sfee=($amount*$refprofit)/100;
  1862. $mfee=$amount-$afee;
  1863.  
  1864. $rsm=mysql_query("select * from users where Username='$ref_by'");
  1865. if(mysql_num_rows($rsm)>0) {
  1866. $arrm=mysql_fetch_array($rsm);
  1867. $mfee=$mfee-$sfee;
  1868. mysql_query("update users set Total=Total+$sfee, Unpaid=Unpaid+$sfee where Username='$ref_by'");
  1869. mysql_query("insert into refpool(Username,Referral,Amount,Date) values('$ref_by','$arr1[1]','$sfee',now())");
  1870. $ref_by1=$arrm[11];
  1871.  
  1872. if($levels>1) {
  1873. $rsm=mysql_query("select * from users where Username='$ref_by1'");
  1874. if(mysql_num_rows($rsm)>0) {
  1875. $arrm=mysql_fetch_array($rsm);
  1876. $sfee=($amount*$refprofit2)/100;
  1877. $mfee=$mfee-$sfee;
  1878. mysql_query("update users set Total=Total+$sfee, Unpaid=Unpaid+$sfee where Username='$ref_by1'");
  1879. mysql_query("insert into refpool(Username,Referral,Amount,Date) values('$ref_by1','$arr1[1]','$sfee',now())");
  1880. $ref_by1=$arrm[11];
  1881.  
  1882. if($levels>2) {
  1883. $rsm=mysql_query("select * from users where Username='$ref_by1'");
  1884. if(mysql_num_rows($rsm)>0) {
  1885. $arrm=mysql_fetch_array($rsm);
  1886. $sfee=($amount*$refprofit3)/100;
  1887. $mfee=$mfee-$sfee;
  1888. mysql_query("update users set Total=Total+$sfee, Unpaid=Unpaid+$sfee where Username='$ref_by1'");
  1889. mysql_query("insert into refpool(Username,Referral,Amount,Date) values('$ref_by1','$arr1[1]','$sfee',now())");
  1890. $ref_by1=$arrm[11];
  1891.  
  1892. if($levels>3) {
  1893. $rsm=mysql_query("select * from users where Username='$ref_by1'");
  1894. if(mysql_num_rows($rsm)>0) {
  1895. $arrm=mysql_fetch_array($rsm);
  1896. $sfee=($amount*$refprofit4)/100;
  1897. $mfee=$mfee-$sfee;
  1898. mysql_query("update users set Total=Total+$sfee, Unpaid=Unpaid+$sfee where Username='$ref_by1'");
  1899. mysql_query("insert into refpool(Username,Referral,Amount,Date) values('$ref_by1','$arr1[1]','$sfee',now())");
  1900. $ref_by1=$arrm[11];
  1901.  
  1902. if($levels>4) {
  1903. $rsm=mysql_query("select * from users where Username='$ref_by1'");
  1904. if(mysql_num_rows($rsm)>0) {
  1905. $arrm=mysql_fetch_array($rsm);
  1906. $sfee=($amount*$refprofit5)/100;
  1907. $mfee=$mfee-$sfee;
  1908. mysql_query("update users set Total=Total+$sfee, Unpaid=Unpaid+$sfee where Username='$ref_by1'");
  1909. mysql_query("insert into refpool(Username,Referral,Amount,Date) values('$ref_by1','$arr1[1]','$sfee',now())");
  1910. $ref_by1=$arrm[11];
  1911.  
  1912. }
  1913. }
  1914. }
  1915. }
  1916. }
  1917. }
  1918. }
  1919. }
  1920.  
  1921.  
  1922. }
  1923.  
  1924. mysql_query("insert into adminpool(Username,PaymentMode,Amount,Date) values('$arr1[1]','$pmode','$afee',now())");
  1925.  
  1926. mysql_query("update adminsettings set totalinv=totalinv+$amount");
  1927.  
  1928. $rs=mysql_query("insert into moneypool(Username,PaymentMode,atype,Amount,Earning,status,Date,LDate) values('$arr1[1]','$pmode',0,'$amount','0.00',0,now(),now())");
  1929. $b=mysql_insert_id();
  1930.  
  1931. $memp=$memberspaid;
  1932. $sharep=$mfee/$memp;
  1933.  
  1934. if($limitprofit==0)
  1935. $rs=mysql_query("select * from moneypool where ID<>$b and ID>$lastpos order by ID limit 0,$memp");
  1936. else
  1937. $rs=mysql_query("select * from moneypool where ID<>$b and ID>$lastpos and Earning<$maxprofit order by ID limit 0,$memp");
  1938. while($arr=mysql_fetch_array($rs)) {
  1939. $lastpos=$arr[0];
  1940. $memp=$memp-1;
  1941. if(($limitprofit==1)&&(($arr[5]+$sharep)>$maxprofit)) {
  1942. $profit1=$maxprofit-$arr[5];
  1943. $profit2=$sharep-$profit1;
  1944. mysql_query("update moneypool set Earning=Earning+$profit1 where ID=$arr[0]");
  1945. mysql_query("update moneypool set LDate='".date ( "Y-m-d H:i:s", mktime (date("H"),date("i"),date("s"),date("m"),date("d"),date("Y")))."' where ID=".$arr[0]);
  1946. mysql_query("update users set Total=Total+$profit1, Unpaid=Unpaid+$profit1 where Username='$arr[1]'");
  1947. mysql_query("insert into adminpool(Username,PaymentMode,Amount,Date) values('$arr1[1]','Additional Balance left after maxing out share ID: $arr[0]','$profit2',now())");
  1948. }
  1949. else {
  1950. mysql_query("update moneypool set Earning=Earning+$sharep where ID=$arr[0]");
  1951. mysql_query("update moneypool set LDate='".date ( "Y-m-d H:i:s", mktime (date("H"),date("i"),date("s"),date("m"),date("d"),date("Y")))."' where ID=".$arr[0]);
  1952. mysql_query("update users set Total=Total+$sharep, Unpaid=Unpaid+$sharep where Username='$arr[1]'");
  1953. }
  1954. mysql_query("update adminsettings set lastpos=$lastpos");
  1955. mysql_query("update adminsettings set memearn=memearn+$sharep");
  1956. }
  1957.  
  1958. if(($memp>0)&&($b>1)) {
  1959. for($j=1;$j<=$memp;$j++) {
  1960. $lastpos=0;
  1961. if($memp>0) {
  1962. if($limitprofit==0)
  1963. $rs=mysql_query("select * from moneypool where ID>$lastpos order by ID limit 0,$memp");
  1964. else
  1965. $rs=mysql_query("select * from moneypool where ID>$lastpos and Earning<$maxprofit order by ID limit 0,$memp");
  1966. while($arr=mysql_fetch_array($rs)) {
  1967. $lastpos=$arr[0];
  1968. $memp=$memp-1;
  1969. if(($limitprofit==1)&&(($arr[5]+$sharep)>$maxprofit)) {
  1970. $profit1=$maxprofit-$arr[5];
  1971. $profit2=$sharep-$profit1;
  1972. mysql_query("update moneypool set Earning=Earning+$profit1 where ID=$arr[0]");
  1973. mysql_query("update moneypool set LDate='".date ( "Y-m-d H:i:s", mktime (date("H"),date("i"),date("s"),date("m"),date("d"),date("Y")))."' where ID=".$arr[0]);
  1974. mysql_query("update users set Total=Total+$profit1, Unpaid=Unpaid+$profit1 where Username='$arr[1]'");
  1975. mysql_query("insert into adminpool(Username,PaymentMode,Amount,Date) values('$arr1[1]','Additional Balance left after maxing out share ID: $arr[0]','$profit2',now())");
  1976. }
  1977. else {
  1978. mysql_query("update moneypool set Earning=Earning+$sharep where ID=$arr[0]");
  1979. mysql_query("update moneypool set LDate='".date ( "Y-m-d H:i:s", mktime (date("H"),date("i"),date("s"),date("m"),date("d"),date("Y")))."' where ID=".$arr[0]);
  1980. mysql_query("update users set Total=Total+$sharep, Unpaid=Unpaid+$sharep where Username='$arr[1]'");
  1981. }
  1982. mysql_query("update adminsettings set lastpos=$lastpos");
  1983. mysql_query("update adminsettings set memearn=memearn+$sharep");
  1984. }
  1985. }
  1986. }
  1987. }
  1988.  
  1989. if($memp>0) {
  1990. $afee=$memp*$sharep;
  1991. mysql_query("insert into adminpool(Username,PaymentMode,Amount,Date) values('$arr1[1]','Additional Balance after profit payout','$afee',now())");
  1992. }
  1993.  
  1994. }
  1995.  
  1996.  
  1997.  
  1998.  
  1999.     $sqld = "delete from transaction where ID=".$_POST[id] ;
  2000.     $resultd = mysql_query($sqld);
  2001.  
  2002.     }
  2003.     else
  2004.     {
  2005.       echo("<b><br>This transaction has already been completed");
  2006.     }
  2007.   }
  2008.  
  2009.  
  2010.   elseif(trim($b)==7)
  2011.   {
  2012.     echo "<h2 align=center>Admin Profit</h2>";
  2013.   $step=50;
  2014.   $currentpage = $p;
  2015.     $sql="Select * from adminpool order by ID";
  2016.   if(!$rs=mysql_query($sql))
  2017.   {
  2018.     print mysql_error();
  2019.     exit;
  2020.   }
  2021.   $row=mysql_num_rows($rs);
  2022.     $totallinks=$row;
  2023.   if(!isset($currentpage))
  2024.   {
  2025.     $currentpage=1;
  2026.   }
  2027.  
  2028.   if ($totallinks > 0)
  2029.   {
  2030.     if ($totallinks < 50)
  2031.     {
  2032.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  2033.     }
  2034.     else
  2035.     {
  2036.       if (($currentpage*50) > $totallinks)
  2037.       {
  2038.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  2039.       }
  2040.       else
  2041.       {
  2042.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  2043.       }
  2044.     }
  2045.   }
  2046.  
  2047.   if($totallinks > $step)
  2048.   {
  2049.     $pagecount=ceil($totallinks/$step);
  2050.     print "<br>Page NO - &nbsp;&nbsp;";
  2051.     for($i=1;$i<=$pagecount;$i++)
  2052.     {
  2053.       if($pageno==$i)
  2054.       {
  2055.         echo($i . " ");
  2056.       }
  2057.       else
  2058.       {
  2059.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  2060.       }
  2061.     }
  2062.     echo("<br><br><br>");
  2063.   }
  2064.   $start=($currentpage-1)*$step;
  2065.  
  2066.     $query="Select * from adminpool order by ID";
  2067.   $sql = $query . " LIMIT $start,$step";
  2068.  
  2069.   if(!$result=mysql_query($sql))
  2070.   {
  2071.     print mysql_error();
  2072.     exit;
  2073.   }
  2074.  
  2075.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=70><font face=verdana size=2><b>ID.</b></font></td><td align=center valign=center><font face=verdana size=2><b>Username</b></font></td><td align=center valign=center><font face=verdana size=2><b>PaymentMode</b></font></td><td width=70 align=center><font face=verdana size=2><b>Amount</b></font></td><td align=center><font face=verdana size=2><b>Date</b></font></td></tr>");
  2076.     while($rss=mysql_fetch_row($result))
  2077.     {
  2078.       echo("<tr><td align=center><font face=verdana size=2>".$rss[0]."</font></td><td align=center><font face=verdana size=2>". $rss[1]."</font></td><td align=center><font face=verdana size=2>". $rss[2]."</font></td><td align=center><font face=verdana size=2>$". $rss[3]."</font></td><td align=center><font face=verdana size=2>". $rss[4]."</font></td></tr>");
  2079.     }
  2080.     echo("</table>");
  2081.  
  2082.   }
  2083.  
  2084.   elseif(trim($b)==5)
  2085.   {
  2086.     echo "<h2 align=center>Position Details</h2>";
  2087.   $step=50;
  2088.   $currentpage = $p;
  2089.     $sql="Select * from moneypool order by ID";
  2090.   if(!$rs=mysql_query($sql))
  2091.   {
  2092.     print mysql_error();
  2093.     exit;
  2094.   }
  2095.   $row=mysql_num_rows($rs);
  2096.     $totallinks=$row;
  2097.   if(!isset($currentpage))
  2098.   {
  2099.     $currentpage=1;
  2100.   }
  2101.  
  2102.   if ($totallinks > 0)
  2103.   {
  2104.     if ($totallinks < 50)
  2105.     {
  2106.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  2107.     }
  2108.     else
  2109.     {
  2110.       if (($currentpage*50) > $totallinks)
  2111.       {
  2112.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  2113.       }
  2114.       else
  2115.       {
  2116.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  2117.       }
  2118.     }
  2119.   }
  2120.  
  2121.   if($totallinks > $step)
  2122.   {
  2123.     $pagecount=ceil($totallinks/$step);
  2124.     print "<br>Page NO - &nbsp;&nbsp;";
  2125.     for($i=1;$i<=$pagecount;$i++)
  2126.     {
  2127.       if($pageno==$i)
  2128.       {
  2129.         echo($i . " ");
  2130.       }
  2131.       else
  2132.       {
  2133.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  2134.       }
  2135.     }
  2136.     echo("<br><br><br>");
  2137.   }
  2138.   $start=($currentpage-1)*$step;
  2139.  
  2140.     $query="Select * from moneypool order by ID";
  2141.   $sql = $query . " LIMIT $start,$step";
  2142.  
  2143.   if(!$result=mysql_query($sql))
  2144.   {
  2145.     print mysql_error();
  2146.     exit;
  2147.   }
  2148.  
  2149.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=70><font face=verdana size=2><b>Order #</b></font></td><td align=center valign=center><font face=verdana size=2><b>Username</b></font></td><td align=center valign=center><font face=verdana size=2><b>PaymentMode</b></font></td><td width=70 align=center><font face=verdana size=2><b>Amount Invested</b></font></td><td width=70 align=center><font face=verdana size=2><b>Earning</b></font></td><td align=center><font face=verdana size=2><b>Purchased Date</b></font></td><td align=center><font face=verdana size=2><b>Last Updated On</b></font></td><td align=center><font face=verdana size=2><b>Action</b></font></td></tr>");
  2150.     while($rss=mysql_fetch_row($result))
  2151.     {
  2152.       echo("<tr><td align=center><font face=verdana size=2>".$rss[0]."</font></td><td align=center><font face=verdana size=2>". $rss[1]."</font></td><td align=center><font face=verdana size=2>". $rss[2]."</font></td><td align=center><font face=verdana size=2>$". $rss[4]."</font></td><td align=center><font face=verdana size=2>$". $rss[5]."</font></td><td align=center><font face=verdana size=2>".$rss[7]."</font></td><td align=center><font face=verdana size=2>".$rss[8]."</font></td><td align=center><form action=admin.php method=post><input type=hidden name=id value=$rss[0]><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='delpos'></form></td></tr>");
  2153.     }
  2154.     echo("</table>");
  2155.   }
  2156.  
  2157.   elseif(trim($b)==4)
  2158.   {
  2159.     echo "<h2 align=center>Pending Transactions</h2>";
  2160. echo "<br><b>Note:</b>These are the transactions which hadn't got completed due to any of these reasons.<br>
  2161. 1. User had send the money but payment hadn't got approved automatically.<br>
  2162. 2. User hadn't paid the money, if you hadn't received the payment then just delete this transaction<br>";
  2163.   $step=50;
  2164.   $currentpage = $p;
  2165.     $sql="Select * from transaction order by ID";
  2166.   if(!$rs=mysql_query($sql))
  2167.   {
  2168.     print mysql_error();
  2169.     exit;
  2170.   }
  2171.   $row=mysql_num_rows($rs);
  2172.     $totallinks=$row;
  2173.   if(!isset($currentpage))
  2174.   {
  2175.     $currentpage=1;
  2176.   }
  2177.  
  2178.   if ($totallinks > 0)
  2179.   {
  2180.     if ($totallinks < 50)
  2181.     {
  2182.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  2183.     }
  2184.     else
  2185.     {
  2186.       if (($currentpage*50) > $totallinks)
  2187.       {
  2188.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  2189.       }
  2190.       else
  2191.       {
  2192.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  2193.       }
  2194.     }
  2195.   }
  2196.  
  2197.   if($totallinks > $step)
  2198.   {
  2199.     $pagecount=ceil($totallinks/$step);
  2200.     print "<br>Page NO - &nbsp;&nbsp;";
  2201.     for($i=1;$i<=$pagecount;$i++)
  2202.     {
  2203.       if($pageno==$i)
  2204.       {
  2205.         echo($i . " ");
  2206.       }
  2207.       else
  2208.       {
  2209.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  2210.       }
  2211.     }
  2212.     echo("<br><br><br>");
  2213.   }
  2214.   $start=($currentpage-1)*$step;
  2215.  
  2216.     $query="Select * from transaction order by ID";
  2217.   $sql = $query . " LIMIT $start,$step";
  2218.  
  2219.   if(!$result=mysql_query($sql))
  2220.   {
  2221.     print mysql_error();
  2222.     exit;
  2223.   }
  2224.  
  2225.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><font face=verdana size=2><b>ID.</b></font></td><td align=center><font face=verdana size=2><b>Username</b></font></td><td align=center valign=center><font face=verdana size=2><b>PaymentMode</b></font></td><td width=70 align=center><font face=verdana size=2><b>Amount</b></font></td><td width=70 align=center><font face=verdana size=2><b>Date</b></font></td><td width=70 align=center><font face=verdana size=2><b>Action</b></font></td></tr>");
  2226.     while($rs=mysql_fetch_row($result))
  2227.     {
  2228.       echo("<tr><td align=center><font face=verdana size=2>".$rs[0]."</font></td><Td align=center><font face=verdana size=2>". $rs[1]."</font></td><Td align=center><font face=verdana size=2>". $rs[2]."</font></td><Td align=center><font face=verdana size=2>$". $rs[3]."</font></td><Td align=center><font face=verdana size=2>". $rs[4]."</font></td><td align=center><form action=admin.php method=post><input type=hidden name=id value=$rs[0]><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='ApproveT'> &nbsp; <input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='DeleteT'></form></tr>");
  2229.     }
  2230.     echo("</table>");
  2231.   }
  2232.  
  2233.  
  2234.  
  2235.   elseif (trim($b)==3)
  2236.   {
  2237.     $act=$_GET[act];
  2238.     if (trim($act)!="send") // Send Mail
  2239.     {
  2240.       echo("<b><p align=left style='font-size: 150%; font-family: '>E-mail Users</b></p>");
  2241.       echo("<form action='admin.php?b=3&act=send' method=post><font face=verdana size=2>You can use the following tags for personalized mailing and these will automatically get replaced by user information.<br><br>{fname} for First Name of the member<br>{name} for Full Name of the member<br>{username} for username of the member<br>{password} for the password of the member<br>{email} for the Email Address of the member<br>{ip} for the IP Address recorded at the time of joining of the member<br>{date} for Date of Joining of the member<br>{sponsor} for the Sponsor Username of the member<br>");
  2242.  
  2243.       echo("<p align=left><table border=0>");
  2244.       echo("<tr><td align=right valign=top>Subject:</td><td align=left><input type=text name=subject></td></tr>");
  2245.       echo("<tr><td align=right valign=top>Category:</td><td align=left><Select name='cat'><option Value='1'>All Members<option value=2>Free Members<option value=3>Pro Members</select></td></tr>");
  2246.       echo("<tr><td align=right valign=top>Format:</td><td align=left><Select name='format'><option Value='0'>Text<option value=1 selected>HTML</select></td></tr>");
  2247.       echo("<tr><td align=right valign=top>Message:</td><td align=left><textarea name=message cols=60 rows=10></textarea></td></tr>");
  2248.       echo("<tr><td colspan=2 align=center valign=top><br>");
  2249.       echo("<input type=submit value='Send Mail' style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD'></td></tr>");
  2250.       echo("</form></table></p>");
  2251.     }
  2252.     elseif(trim($act) == "send")
  2253.     {
  2254.       $subject=$_POST[subject];
  2255.       $format=$_POST[format];
  2256.     $message=$_POST[message];
  2257.     $cat=$_POST[cat];
  2258.       $users="";
  2259.       $usercount=0;
  2260.  
  2261. if($cat==1) {
  2262.       $sql_rc = "select count(*) from users where active=1 and subscribed=1";
  2263.       $sql = "select Email,ref_by,Name,Username,Password,ID,IP,Date from users where active=1 and subscribed=1 order by ID" ;
  2264. }
  2265. elseif($cat==2) {
  2266.       $sql_rc = "select count(*) from users where active=1 and status=1";
  2267.       $sql = "select Email,ref_by,Name,Username,Password,ID,IP,Date from users where active=1 and subscribed=1 and status=1 order by ID" ;
  2268. }
  2269. elseif($cat==3) {
  2270.       $sql_rc = "select count(*) from users where active=1 and status=2";
  2271.       $sql = "select Email,ref_by,Name,Username,Password,ID,IP,Date from users where active=1 and subscribed=1 and status=2 order by ID" ;
  2272. }
  2273.       $result_rc = mysql_query($sql_rc);
  2274.       $rscount_rc  =  mysql_fetch_row($result_rc);
  2275.       $totalm=$rscount_rc[0];
  2276.  
  2277.       $result = mysql_query($sql);
  2278.       while ($rs=mysql_fetch_row($result))
  2279.       {
  2280. $d=explode(" ",$rs[2]);
  2281.  
  2282.       $subject1=stripslashes($_POST[subject]);
  2283.       $subject1=str_replace("{name}",$rs[2],$subject1);
  2284.       $subject1=str_replace("{fname}",$d[0],$subject1);
  2285.       $subject1=str_replace("{username}",$rs[3],$subject1);
  2286.       $subject1=str_replace("{password}",$rs[4],$subject1);
  2287.       $subject1=str_replace("{sponsor}",$rs[1],$subject1);
  2288.       $subject1=str_replace("{email}",$rs[0],$subject1);
  2289.       $subject1=str_replace("{ip}",$rs[6],$subject1);
  2290.       $subject1=str_replace("{date}",$rs[7],$subject1);
  2291.  
  2292.       $message1=stripslashes($_POST[message]);
  2293.       $message1=str_replace("{name}",$rs[2],$message1);
  2294.       $message1=str_replace("{fname}",$d[0],$message1);
  2295.       $message1=str_replace("{username}",$rs[3],$message1);
  2296.       $message1=str_replace("{password}",$rs[4],$message1);
  2297.       $message1=str_replace("{sponsor}",$rs[1],$message1);
  2298.       $message1=str_replace("{email}",$rs[0],$message1);
  2299.       $message1=str_replace("{ip}",$rs[6],$message1);
  2300.       $message1=str_replace("{date}",$rs[7],$message1);
  2301.  
  2302. if($format==1)
  2303. $message1.="<hr>You are receiving this message because you are a member of $sitename.<br>If you would like to no longer wish receive any updates please click on this link: <a href=$siteurl/remove.php?id=$rs[5]&email=$rs[0]>$siteurl/remove.php?id=$rs[5]&email=$rs[0]</a><hr>";
  2304. else
  2305. $message1.="\n*********************************************************\n
  2306. You are receiving this message because you are a member of $sitename.\n
  2307. If you would like to no longer wish receive any updates please click on this link: $siteurl/remove.php?id=$rs[5]&email=$rs[0]\n
  2308. *********************************************************";
  2309.  
  2310.         sendmail($webmasteremail,$rs[0],$subject1,$format,$message1);
  2311.         $usercount=$usercount+1;
  2312.         echo($usercount ." . Message Successfully Send to :".$rs[0]."<br>");
  2313.       } // wend
  2314.     }
  2315.  
  2316.   }
  2317.  
  2318.  
  2319.   elseif(trim($b)==88)
  2320.   {
  2321.     echo "<h2 align=center>Completed Withdrawls</h2>";
  2322.   $step=50;
  2323.   $currentpage = $p;
  2324.     $sql="Select * from wtransaction where approved=1 order by ID";
  2325.   if(!$rs=mysql_query($sql))
  2326.   {
  2327.     print mysql_error();
  2328.     exit;
  2329.   }
  2330.   $row=mysql_num_rows($rs);
  2331.     $totallinks=$row;
  2332.   if(!isset($currentpage))
  2333.   {
  2334.     $currentpage=1;
  2335.   }
  2336.  
  2337.   if ($totallinks > 0)
  2338.   {
  2339.     if ($totallinks < 50)
  2340.     {
  2341.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  2342.     }
  2343.     else
  2344.     {
  2345.       if (($currentpage*50) > $totallinks)
  2346.       {
  2347.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  2348.       }
  2349.       else
  2350.       {
  2351.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  2352.       }
  2353.     }
  2354.   }
  2355.  
  2356.   if($totallinks > $step)
  2357.   {
  2358.     $pagecount=ceil($totallinks/$step);
  2359.     print "<br>Page NO - &nbsp;&nbsp;";
  2360.     for($i=1;$i<=$pagecount;$i++)
  2361.     {
  2362.       if($pageno==$i)
  2363.       {
  2364.         echo($i . " ");
  2365.       }
  2366.       else
  2367.       {
  2368.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  2369.       }
  2370.     }
  2371.     echo("<br><br><br>");
  2372.   }
  2373.   $start=($currentpage-1)*$step;
  2374.  
  2375.     $query="Select * from wtransaction where approved=1 order by ID";
  2376.   $sql = $query . " LIMIT $start,$step";
  2377.  
  2378.   if(!$result=mysql_query($sql))
  2379.   {
  2380.     print mysql_error();
  2381.     exit;
  2382.   }
  2383.  
  2384.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>ID.</b></td><td align=center><b>Username</b></td><td align=center valign=center><b>PaymentMode</b></td><td width=70 align=center><b>Amount</b></td><td width=70 align=center><b>Date</b></td></tr>");
  2385.     while($rs=mysql_fetch_row($result))
  2386.     {
  2387.       echo("<tr><td align=center>".$rs[0]."</td><Td align=center>". $rs[1]."</td><Td align=center>". $rs[2]."</td><Td align=center>$". $rs[3]."</td><Td align=center>". $rs[5]."</td></tr>");
  2388.     }
  2389.     echo("</table>");
  2390.   }
  2391.  
  2392.   elseif(trim($b)==66)
  2393.   {
  2394.     echo "<h2 align=center>Pending Withdrawls</h2>";
  2395.   $step=50;
  2396.   $currentpage = $p;
  2397.     $sql="Select * from wtransaction where approved=0 order by ID";
  2398.   if(!$rs=mysql_query($sql))
  2399.   {
  2400.     print mysql_error();
  2401.     exit;
  2402.   }
  2403.   $row=mysql_num_rows($rs);
  2404.     $totallinks=$row;
  2405.   if(!isset($currentpage))
  2406.   {
  2407.     $currentpage=1;
  2408.   }
  2409.  
  2410.   if ($totallinks > 0)
  2411.   {
  2412.     if ($totallinks < 50)
  2413.     {
  2414.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  2415.     }
  2416.     else
  2417.     {
  2418.       if (($currentpage*50) > $totallinks)
  2419.       {
  2420.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  2421.       }
  2422.       else
  2423.       {
  2424.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  2425.       }
  2426.     }
  2427.   }
  2428.  
  2429.   if($totallinks > $step)
  2430.   {
  2431.     $pagecount=ceil($totallinks/$step);
  2432.     print "<br>Page NO - &nbsp;&nbsp;";
  2433.     for($i=1;$i<=$pagecount;$i++)
  2434.     {
  2435.       if($pageno==$i)
  2436.       {
  2437.         echo($i . " ");
  2438.       }
  2439.       else
  2440.       {
  2441.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  2442.       }
  2443.     }
  2444.     echo("<br><br><br>");
  2445.   }
  2446.   $start=($currentpage-1)*$step;
  2447.  
  2448.     $query="Select * from wtransaction where approved=0 order by ID";
  2449.   $sql = $query . " LIMIT $start,$step";
  2450.  
  2451.   if(!$result=mysql_query($sql))
  2452.   {
  2453.     print mysql_error();
  2454.     exit;
  2455.   }
  2456.  
  2457.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>ID.</b></td><td align=center><b>Username</b></td><td align=center valign=center><b>PaymentMode</b></td><td width=70 align=center><b>Amount</b></td><td width=70 align=center><b>Date</b></td><td width=70 align=center><b>Action</b></td></tr>");
  2458.     while($rs=mysql_fetch_row($result))
  2459.     {
  2460.       echo("<tr><td align=center>".$rs[0]."</td><Td align=center>". $rs[1]."</td><Td align=center>". $rs[2]."</td><Td align=center>$". $rs[3]."</td><Td align=center>". $rs[5]."</td><td align=center><form action=admin.php method=post><input type=hidden name=id value=$rs[0]><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Pay'></form></tr>");
  2461.     }
  2462.     echo("</table>");
  2463.   }
  2464.  
  2465.   elseif(trim($b)=="Pay")
  2466.   {
  2467.         include "config.php";
  2468.     $sql="Select * from wtransaction where ID = ". $_POST[id] ;
  2469.     $result=mysql_query($sql);
  2470.     $rs=mysql_fetch_row($result);
  2471.     if($rs[4]==1)
  2472.     {
  2473.       echo("<b><br><br>This Transaction has already got completed</b></center></b>");
  2474.     }
  2475.     else
  2476.     {
  2477.     $pay=$rs[3];
  2478. $d=explode(":",$rs[2]);
  2479.       echo("<br><br><br><b>Please make the payment of $".$pay." first through $d[0] to $d[1] and then click on the paid button given below<br>");
  2480.       echo("<table><tr>");
  2481.       $fee=$pay;
  2482.  
  2483.       if($d[0]=="paypal")
  2484.       {
  2485.         echo("<td>&nbsp;");
  2486.         ?>
  2487. <form action="https://www.paypal.com/cgi-bin/webscr" method="post" target=_blank>
  2488. <input type="hidden" name="cmd" value="_xclick">
  2489. <input type="hidden" name="business" value="<?php echo($d[1]);?>">
  2490. <input type="hidden" name="item_name" value="Payment from <?php echo($sitename);?>">
  2491. <input type="hidden" name="amount" value="$<?php echo($fee) ; ?>">
  2492. <input type="hidden" name="return" value="<?php echo($siteurl);?>">
  2493. <input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but01.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
  2494. </form>
  2495.         <?php
  2496.         echo("</td>");
  2497.       }
  2498.       elseif($d[0]=="payza") { ?>
  2499. <form action='https://secure.payza.com/checkout' method='post'>
  2500. <input type='hidden' name='ap_purchasetype' value='Item'>
  2501. <input type='hidden' name='ap_merchant' value='<? echo $d[1]; ?>'>
  2502. <input type='hidden'  name='ap_itemname' value='Payment from <? echo $sitename; ?>'>
  2503. <input type='hidden'  name='ap_currency' value='USD'>
  2504. <input type='hidden'  name='ap_returnurl' value='<?php echo($siteurl);?>/'>
  2505. <input type='image' src='https://secure.payza.com/PayNow/138F4314F461497ABB07823FECBCB02Db4en.gif'>
  2506. <input type='hidden'  name='ap_quantity' value='1'>
  2507. <input type='hidden' name='ap_description' value='Payment from <? echo $sitename; ?>'>
  2508. <input type='hidden'  name='ap_amount' value='<? echo $fee; ?>'>
  2509. <input type='hidden'  name='ap_cancelurl' value='<?php echo($siteurl);?>'>
  2510. </form>
  2511. <?php
  2512.     }
  2513.       elseif ($d[0]=="moneybookers")
  2514.       {
  2515.         echo("<td>&nbsp;");
  2516.         ?>
  2517. <form action="https://www.moneybookers.com/app/payment.pl" target="_blank">
  2518. <input type="hidden" name="pay_to_email" value="<? echo $d[1]; ?>">
  2519. <input type="hidden" name="return_url" value="<? echo $siteurl; ?>/">
  2520. <input type="hidden" name="language" value="EN">
  2521. <input type="hidden" name="merchant_fields" value="field1">
  2522. <input type="hidden" name="amount2_description" value="Product Price:">
  2523. <input type="hidden" name="amount2" value="<? echo $fee; ?>">
  2524. <input type="hidden" name="amount" value="<? echo $fee; ?>">
  2525. <input type="hidden" name="currency" value="USD">
  2526. <input type="hidden" name="detail1_description" value="Product ID:">
  2527. <input type="hidden" name="detail1_text" value="4509334">
  2528. <input type="hidden" name="confirmation_note" value="Payment from <?php echo($sitename);?>">
  2529. <input type="submit" name="Pay" value="Pay">
  2530. </form>
  2531.         <?php
  2532.         echo("</td>");
  2533.       }
  2534.       elseif ($d[0]=="ebullion")
  2535.       {
  2536.         echo("<td>&nbsp;");
  2537.         ?>
  2538.  
  2539. <!-- e-Bullion ATIP Implementation -->
  2540. <form name="atip" method="post" action="https://atip.e-bullion.com/process.php">
  2541. <input type="hidden" name="ATIP_STATUS_URL" value="<? echo $siteurl; ?>/">
  2542. <input type="hidden" name="ATIP_STATUS_URL_METHOD" value="POST">
  2543. <input type="hidden" name="ATIP_BAGGAGE_FIELDS" value="">
  2544. <input type="hidden" name="ATIP_SUGGESTED_MEMO" value="Payment from <?php echo($sitename);?>">
  2545. <input type="hidden" name="ATIP_FORCED_PAYER_ACCOUNT" value="">
  2546. <input type="hidden" name="ATIP_PAYER_FEE_AMOUNT" value="">
  2547. <input type="hidden" name="ATIP_PAYMENT_URL" value="<? echo $siteurl; ?>/">
  2548. <input type="hidden" name="ATIP_PAYMENT_URL_METHOD" value="POST">
  2549. <input type="hidden" name="ATIP_NOPAYMENT_URL" value="<? echo $siteurl; ?>/">
  2550. <input type="hidden" name="ATIP_NOPAYMENT_URL_METHOD" value="POST">
  2551. <input type="hidden" name="ATIP_PAYMENT_AMOUNT" value="<? echo $fee; ?>">
  2552. <input type="hidden" name="ATIP_PAYMENT_UNIT" value="1001">
  2553. <input type="hidden" name="ATIP_PAYMENT_METAL" value="1">
  2554. <input type="hidden" name="ATIP_PAYEE_ACCOUNT" value="<? echo $d[1]; ?>">
  2555. <input type="hidden" name="ATIP_PAYEE_NAME" value="Payment from <?php echo($sitename);?>">
  2556. <input type="submit" name="pay" value=" Pay Now "></form>
  2557. <!-- ATIP End -->
  2558.         <?php
  2559.         echo("</td>");
  2560.       }
  2561.     elseif($extramerchants>0) {
  2562.         if($d[0]==$merchantname1) {
  2563.           print str_replace("{fee}",$fee,$merchantcode1);
  2564.         }
  2565.         elseif($d[0]==$merchantname2) {
  2566.           print str_replace("{fee}",$fee,$merchantcode2);
  2567.         }
  2568.         elseif($d[0]==$merchantname3) {
  2569.           print str_replace("{fee}",$fee,$merchantcode3);
  2570.         }
  2571.         elseif($d[0]==$merchantname4) {
  2572.           print str_replace("{fee}",$fee,$merchantcode4);
  2573.         }
  2574.         elseif($d[0]==$merchantname5) {
  2575.           print str_replace("{fee}",$fee,$merchantcode5);
  2576.         }
  2577.     }
  2578.  
  2579.       echo("</tr></table>");
  2580.       echo("<form action=admin.php method=post><input type=hidden name=id value=".$rs[0]."><input type=hidden name=pay value=".$pay."><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Paid'></form>");
  2581.     }
  2582.   }
  2583.   elseif($b=="Paid")
  2584.   {
  2585.     $sql="Select * from wtransaction where ID = ". $_POST[id] ;
  2586.     $result=mysql_query($sql);
  2587.     $rs=mysql_fetch_row($result);
  2588.     if($rs[4]==1)
  2589.     {
  2590.       echo("<b><br><br>This Transaction has already got completed</b></center></b>");
  2591.     }
  2592.     else
  2593.     {
  2594.     $sql_u = "update wtransaction set approved=1 where ID=".$_POST[id];
  2595.     $result_u=mysql_query($sql_u);
  2596.     $sql_u = "update users set Paid=Paid+".$rs[3]." where Username='$rs[1]'";
  2597.     $result_u=mysql_query($sql_u);
  2598.     echo("<br><br><BR><b><CENTER>Records Successfully Updated</CENTER>");
  2599.     }
  2600.   }
  2601.  
  2602.  
  2603. elseif($b=="44") {
  2604. if($_POST[message]=="") {
  2605. echo "<h2 align=center>Payza MassPay System</h2><br>
  2606. <div align=center>";
  2607. $data="";
  2608. $rs=mysql_query("Select ID,Amount,Username,PaymentMode from wtransaction where approved=0 and PaymentMode like '%payza:%' order by ID");
  2609. while($arr=mysql_fetch_array($rs)) {
  2610. $d=explode(":",$arr[3]);
  2611. if($d[0]=="payza") {
  2612. $data.="$arr[0],$arr[1],$arr[2],$arr[3]\n";
  2613. $dataa=$dataa.$d[1].", ".$arr[1].", $sitename Payment\r\n";
  2614. }
  2615. }
  2616.  
  2617. if($data=="") {
  2618. echo "<br>No Records found to pay<br>";
  2619. }
  2620. else {
  2621. echo "<font face=verdana size=2><br><b>Steps to Follow in order to do Masspayment through Payza</b>:<br>
  2622. <a href='http://www.payza.com' target=_blank>Click Here</a> and login to your payza and click on <b>Send Money</b> button and then click on <b>MassPay</b>.<br>Just copy and paste the contents given below at payza Mass Pay List and then only press the masspay button given below.<br>Pressing the masspay button will update the records and mark all the accounts listed below as paid.<br>";
  2623. echo "<form action='' method=post>";
  2624. echo "<textarea name=messagee rows=15 cols=80>$dataa</textarea><br><br>
  2625. <input type=hidden name=message value='$data'>
  2626. <b>Note: By Pressing this button it will update all the accounts listed above in textbox, are you sure you wants to do it?</b>
  2627. <input type=Submit style=\"color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD\" name=\"bbbb\" value=\"Masspay\"></form>";
  2628. }
  2629. echo "</div>";
  2630. }
  2631. else {
  2632. $message=explode("\n",$_POST[message]);
  2633. for($i=0;$i<=count($message);$i++) {
  2634. if($message[$i]!="") {
  2635. $data=explode(",",$message[$i]);
  2636. $memid=$data[0];
  2637. $pay=$data[1];
  2638. $upaid=$pay;
  2639.  
  2640.     $sql="Select * from wtransaction where ID = $memid";
  2641.     $result=mysql_query($sql);
  2642.     $rs=mysql_fetch_row($result);
  2643.     if($rs[4]==1)
  2644.     {
  2645.       echo("<b><br>This Transaction has already got completed.</b>");
  2646.     }
  2647.     else
  2648.     {
  2649.     $sql_u = "update wtransaction set approved=1 where ID=$memid";
  2650.     $result_u=mysql_query($sql_u);
  2651.     $sql_u = "update users set Paid=Paid+".$rs[3]." where Username='$rs[1]'";
  2652.     $result_u=mysql_query($sql_u);
  2653.     echo("<br><b>Account with username: $rs[1] has been successfully updated with paid commissions of $$rs[3].</b>");
  2654.     }
  2655.  
  2656. }
  2657. }// end of for loop
  2658. echo "<br><br><b>All Records Updated</b><br>";
  2659.  
  2660.  
  2661. }
  2662. }
  2663.  
  2664.  
  2665.   elseif (trim($b)==210)
  2666.   {
  2667. $burl=str_replace("\"","",$_POST[burl]);
  2668. $burl=str_replace("'","",$burl);
  2669. $wurl=str_replace("\"","",$_POST[wurl]);
  2670. $wurl=str_replace("'","",$wurl);
  2671.  if ($_POST[burl])
  2672.  {
  2673. $sql_i="insert into membersbanners(Username,BannerURL,WebsiteURL,assigned,remaining,hits,approved,Date) values('admin','$burl','$wurl',$_POST[credits],$_POST[credits],0,1,now())";
  2674. $rsi=mysql_query($sql_i);
  2675.  
  2676.     print "<p align='center'><font color='red'><b>Sucessfully added record and banner approved!</b></font></p><br><br>";
  2677.  }
  2678. else {
  2679. ?>
  2680. <p align="center"><h2 align="center">Add Banner</h2>
  2681. <form method="post" width="60%" action="" />
  2682. <table border="0" align="center">
  2683. <table>
  2684. <tr><td><font face=verdana size=2>Banner Url:</td><td><input type=text name=burl value="http://"></td></tr>
  2685. <tr><td><font face=verdana size=2>Website Url:</td><td><input type=text name=wurl value="http://"></td></tr>
  2686. <tr><td><font face=verdana size=2>Assign Credits:</td><td><input type=text name=credits value="10000"></td></tr>
  2687. <tr><td colspan=2><input type=submit value="Add Record"> </td></tr>
  2688. </table>
  2689. </form>
  2690. <?  }
  2691. }
  2692.  
  2693.  
  2694.  
  2695.  
  2696.   elseif(trim($b)==211)
  2697.   {
  2698.     echo "<h2 align=center>Approved Banners</h2>";
  2699.   $step=50;
  2700.   $currentpage = $p;
  2701.     $sql="Select * from membersbanners where approved=1 order by ID";
  2702.   if(!$rs=mysql_query($sql))
  2703.   {
  2704.     print mysql_error();
  2705.     exit;
  2706.   }
  2707.   $row=mysql_num_rows($rs);
  2708.     $totallinks=$row;
  2709.   if(!isset($currentpage))
  2710.   {
  2711.     $currentpage=1;
  2712.   }
  2713.  
  2714.   if ($totallinks > 0)
  2715.   {
  2716.     if ($totallinks < 50)
  2717.     {
  2718.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  2719.     }
  2720.     else
  2721.     {
  2722.       if (($currentpage*50) > $totallinks)
  2723.       {
  2724.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  2725.       }
  2726.       else
  2727.       {
  2728.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  2729.       }
  2730.     }
  2731.   }
  2732.  
  2733.   if($totallinks > $step)
  2734.   {
  2735.     $pagecount=ceil($totallinks/$step);
  2736.     print "<br>Page NO - &nbsp;&nbsp;";
  2737.     for($i=1;$i<=$pagecount;$i++)
  2738.     {
  2739.       if($pageno==$i)
  2740.       {
  2741.         echo($i . " ");
  2742.       }
  2743.       else
  2744.       {
  2745.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  2746.       }
  2747.     }
  2748.     echo("<br><br><br>");
  2749.   }
  2750.   $start=($currentpage-1)*$step;
  2751.  
  2752.     $query="Select * from membersbanners where approved=1 order by ID";
  2753.   $sql = $query . " LIMIT $start,$step";
  2754.  
  2755.   if(!$result=mysql_query($sql))
  2756.   {
  2757.     print mysql_error();
  2758.     exit;
  2759.   }
  2760.     if(mysql_num_rows($rs)>0) {
  2761.     echo("<br><form action=admin.php method=post name=maj><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>ID.</b></td><td align=center><b>Username</b></td><td width=486 align=center><b>Banner with Url</b></td><td width=70 align=center><b>Impressions Purchased</b></td><td width=70 align=center><b>Remaining</b></td><td width=70 align=center><b>Hits</b></td><td width=70 align=center><b>Date</b></td><td>Action</td></tr>");
  2762.     while($rs=mysql_fetch_row($result))
  2763.     {
  2764.       echo("<tr><td align=center>".$rs[0]."</td><Td align=center>". $rs[1]."</td><Td align=center><a href=$rs[3] target=_blank><img src=$rs[2] border=0></a></td><Td align=center>$rs[4]</td><Td align=center>$rs[5]</td><Td align=center>$rs[6]</td><Td align=center>$rs[8]</td><td><input type=checkbox name=id".$rs[0]."></td></tr>");
  2765.     }
  2766. echo "<tr><td colspan=8 align=center><input name=allbox type=checkbox value=1 onClick=\"CheckAll();\">Select/Un-Select All
  2767. <br>
  2768. <input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Edit Banner'> &nbsp;
  2769. <input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Remove'>
  2770. </form></td></tr>";
  2771.     echo("</table>");
  2772. ?>
  2773. <script language="JavaScript">
  2774.    <!--
  2775.    function CheckAll()
  2776.    {
  2777.       for (var i=0;i<document.maj.elements.length;i++)
  2778.       {
  2779.          var e = document.maj.elements[i];
  2780.          if (e.name != "allbox")
  2781.             e.checked = document.maj.allbox.checked;
  2782.       }
  2783.    }
  2784.    //-->
  2785. </script>
  2786. <?
  2787.  
  2788.     } else {
  2789.     echo "<br><b>No Records Found</b><br>";
  2790.     }
  2791.   }
  2792.  
  2793.  
  2794.   elseif(trim($b)==212)
  2795.   {
  2796.     echo "<h2 align=center>Pending Banners</h2>";
  2797.   $step=50;
  2798.   $currentpage = $p;
  2799.     $sql="Select * from membersbanners where approved=0 order by ID";
  2800.   if(!$rs=mysql_query($sql))
  2801.   {
  2802.     print mysql_error();
  2803.     exit;
  2804.   }
  2805.   $row=mysql_num_rows($rs);
  2806.     $totallinks=$row;
  2807.   if(!isset($currentpage))
  2808.   {
  2809.     $currentpage=1;
  2810.   }
  2811.  
  2812.   if ($totallinks > 0)
  2813.   {
  2814.     if ($totallinks < 50)
  2815.     {
  2816.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  2817.     }
  2818.     else
  2819.     {
  2820.       if (($currentpage*50) > $totallinks)
  2821.       {
  2822.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  2823.       }
  2824.       else
  2825.       {
  2826.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  2827.       }
  2828.     }
  2829.   }
  2830.  
  2831.   if($totallinks > $step)
  2832.   {
  2833.     $pagecount=ceil($totallinks/$step);
  2834.     print "<br>Page NO - &nbsp;&nbsp;";
  2835.     for($i=1;$i<=$pagecount;$i++)
  2836.     {
  2837.       if($pageno==$i)
  2838.       {
  2839.         echo($i . " ");
  2840.       }
  2841.       else
  2842.       {
  2843.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  2844.       }
  2845.     }
  2846.     echo("<br><br><br>");
  2847.   }
  2848.   $start=($currentpage-1)*$step;
  2849.  
  2850.     $query="Select * from membersbanners where approved=0 order by ID";
  2851.   $sql = $query . " LIMIT $start,$step";
  2852.  
  2853.   if(!$result=mysql_query($sql))
  2854.   {
  2855.     print mysql_error();
  2856.     exit;
  2857.   }
  2858.  
  2859.  
  2860.  
  2861.     if(mysql_num_rows($rs)>0) {
  2862.     echo("<br><form name=maj action=admin.php method=post><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>ID.</b></td><td align=center><b>Username</b></td><td width=486 align=center><b>Banner with Url</b></td><td width=70 align=center><b>Impressions Purchased</b></td><td width=70 align=center><b>Remaining</b></td><td width=70 align=center><b>Hits</b></td><td width=70 align=center><b>Date</b></td><td align=center><b>Action</b></td></tr>");
  2863.     while($rs=mysql_fetch_row($result))
  2864.     {
  2865.       echo("<tr><td align=center>".$rs[0]."</td><Td align=center>". $rs[1]."</td><Td align=center><a href=$rs[3] target=_blank><img src=$rs[2] border=0></a></td><Td align=center>$rs[4]</td><Td align=center>$rs[5]</td><Td align=center>$rs[6]</td><Td align=center>$rs[8]</td><td><input type=checkbox name=id".$rs[0]."></td></tr>");
  2866.     }
  2867.  
  2868. echo "<tr><td colspan=8 align=center><input name=allbox type=checkbox value=1 onClick=\"CheckAll();\">Select/Un-Select All
  2869. <br>
  2870. <input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Approve Banner'> &nbsp;
  2871. <input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Edit Banner'> &nbsp;
  2872. <input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Remove'>
  2873. </form></td></tr>";
  2874.     echo("</table>");
  2875.  
  2876. ?>
  2877. <script language="JavaScript">
  2878.    <!--
  2879.    function CheckAll()
  2880.    {
  2881.       for (var i=0;i<document.maj.elements.length;i++)
  2882.       {
  2883.          var e = document.maj.elements[i];
  2884.          if (e.name != "allbox")
  2885.             e.checked = document.maj.allbox.checked;
  2886.       }
  2887.    }
  2888.    //-->
  2889. </script>
  2890. <?
  2891.  
  2892.     } else {
  2893.     echo "<br><b>No Records Found</b><br>";
  2894.     }
  2895.   }
  2896.  
  2897.   elseif(trim($b)=="Approve Banner")
  2898.   {
  2899. foreach($_POST as $k=>$v) {
  2900. $d=explode("id",$k);
  2901. if($d[1]!="") {
  2902. $rs=mysql_query("select * from membersbanners where ID=$d[1]");
  2903. $arr=mysql_fetch_array($rs);
  2904. $id=$arr[0];
  2905.  
  2906.     $sql_d="Update membersbanners set approved=1 where ID=" .  $id ;
  2907.     $rs_d=mysql_query($sql_d);
  2908.     $sql_d="select * from membersbanners where ID=" .  $id ;
  2909.     $rs_d=mysql_query($sql_d);
  2910.     $arr=mysql_fetch_array($rs_d);
  2911.  
  2912.     $sql="select * from users where Username='$arr[1]'" ;
  2913.     $rs=mysql_query($sql);
  2914.     $arr1=mysql_fetch_array($rs);
  2915.  
  2916. $to=$arr1[7];
  2917. $message1=$message6;
  2918. $message1=str_replace("{name}","$arr1[1]",$message1);
  2919. $message1=str_replace("{email}","$arr1[7]",$message1);
  2920. $message1=str_replace("{username}","$arr1[8]",$message1);
  2921. $message1=str_replace("{password}","$arr1[9]",$message1);
  2922. $message1=str_replace("{banner}","$arr[2]",$message1);
  2923. $message1=str_replace("{websiteurl}","$arr[3]",$message1);
  2924. $message1=str_replace("{sitename}","$sitename",$message1);
  2925. $message1=str_replace("{siteurl}","$siteurl",$message1);
  2926.  
  2927. $subject1=str_replace("{name}","$arr1[1]",$subject6);
  2928. $subject1=str_replace("{email}","$arr1[7]",$subject1);
  2929. $subject1=str_replace("{username}","$arr1[8]",$subject1);
  2930. $subject1=str_replace("{password}","$arr1[9]",$subject1);
  2931. $subject1=str_replace("{sitename}","$sitename",$subject1);
  2932. $subject1=str_replace("{siteurl}","$siteurl",$subject1);
  2933.       $message=stripslashes($message1);
  2934.       $subject=stripslashes($subject1);
  2935.  
  2936. $from=$webmasteremail;
  2937.         $header = "From: $sitename<$from>\n";
  2938. if($eformat6==1)
  2939.     $header .="Content-type: text/plain; charset=iso-8859-1\n";
  2940. else
  2941.     $header .="Content-type: text/html; charset=iso-8859-1\n";
  2942.     $header .= "Reply-To: <$from>\n";
  2943.     $header .= "X-Sender: <$from>\n";
  2944.     $header .= "X-Mailer: PHP4\n";
  2945.     $header .= "X-Priority: 3\n";
  2946.     $header .= "Return-Path: <$from>\n";
  2947.  
  2948.   mail($to,$subject,$message,$header);
  2949.  
  2950.  
  2951.     echo("<br><b>Banner with following details <a href=$arr[3] target=_blank><img src=$arr[2] border=0></a> has been successfully approved");
  2952. }
  2953. }
  2954.   }
  2955.   elseif($b=="Remove")
  2956.   {
  2957.  
  2958. foreach($_POST as $k=>$v) {
  2959. $d=explode("id",$k);
  2960. if($d[1]!="") {
  2961. $rs=mysql_query("select * from membersbanners where ID=$d[1]");
  2962. $arr=mysql_fetch_array($rs);
  2963. $id=$arr[0];
  2964.  
  2965.  
  2966.     $sql_d="Update membersbanners set approved=2,assigned=assigned-remaining where ID=" .  $id ;
  2967.     $rs_d=mysql_query($sql_d);
  2968.  
  2969.     $sql_d="select * from membersbanners where ID=" .  $id;
  2970.     $rs_d=mysql_query($sql_d);
  2971.     $arr=mysql_fetch_array($rs_d);
  2972.     $rem=$arr[5];
  2973.     mysql_query("update users set bannersused=bannersused-$rem where Username='$arr[1]'");
  2974.  
  2975.     $sql="select * from users where Username='$arr[1]'" ;
  2976.     $rs=mysql_query($sql);
  2977.     $arr1=mysql_fetch_array($rs);
  2978.  
  2979. $to=$arr1[7];
  2980. $message1=$message7;
  2981. $message1=str_replace("{name}","$arr1[1]",$message1);
  2982. $message1=str_replace("{email}","$arr1[7]",$message1);
  2983. $message1=str_replace("{username}","$arr1[8]",$message1);
  2984. $message1=str_replace("{password}","$arr1[9]",$message1);
  2985. $message1=str_replace("{banner}","$arr[2]",$message1);
  2986. $message1=str_replace("{websiteurl}","$arr[3]",$message1);
  2987. $message1=str_replace("{sitename}","$sitename",$message1);
  2988. $message1=str_replace("{siteurl}","$siteurl",$message1);
  2989.  
  2990. $subject1=str_replace("{name}","$arr1[1]",$subject7);
  2991. $subject1=str_replace("{email}","$arr1[7]",$subject1);
  2992. $subject1=str_replace("{username}","$arr1[8]",$subject1);
  2993. $subject1=str_replace("{password}","$arr1[9]",$subject1);
  2994. $subject1=str_replace("{sitename}","$sitename",$subject1);
  2995. $subject1=str_replace("{siteurl}","$siteurl",$subject1);
  2996.       $message=stripslashes($message1);
  2997.       $subject=stripslashes($subject1);
  2998.  
  2999. $from=$webmasteremail;
  3000.         $header = "From: $sitename<$from>\n";
  3001. if($eformat7==1)
  3002.     $header .="Content-type: text/plain; charset=iso-8859-1\n";
  3003. else
  3004.     $header .="Content-type: text/html; charset=iso-8859-1\n";
  3005.     $header .= "Reply-To: <$from>\n";
  3006.     $header .= "X-Sender: <$from>\n";
  3007.     $header .= "X-Mailer: PHP4\n";
  3008.     $header .= "X-Priority: 3\n";
  3009.     $header .= "Return-Path: <$from>\n";
  3010.  
  3011.   mail($to,$subject,$message,$header);
  3012.  
  3013.  
  3014.     echo("<br><b>Banner with following details <a href=$arr[3] target=_blank><img src=$arr[2] border=0></a> has been successfully removed");
  3015. }
  3016. }
  3017.   }
  3018.  
  3019.  
  3020.   elseif(trim($b)=="Edit Banner")
  3021.   {
  3022. if(!$_POST[eb]==1) {
  3023. echo "<form action=admin.php method=post><input type=hidden name=eb value=1>";
  3024. foreach($_POST as $k=>$v) {
  3025. $d=explode("id",$k);
  3026. if($d[1]!="") {
  3027. $rs=mysql_query("select * from membersbanners where ID=$d[1]");
  3028. $arr=mysql_fetch_array($rs);
  3029. $id=$arr[0];
  3030. echo "<br>
  3031. Banner Url : <input type=text name=burl$arr[0] value=\"$arr[2]\"><br>
  3032. Website Url : <input type=text name=wurl$arr[0] value=\"$arr[3]\"><br>
  3033. Banner Display: <A href=$arr[3] target=_Blank><img src=$arr[2] border=0></a>
  3034. <br>";
  3035. }
  3036. }
  3037. echo "<input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Edit Banner'></form>";
  3038.   }
  3039. else {
  3040.  
  3041.  
  3042. foreach($_POST as $k=>$v)
  3043. $mailbody .=$k." = ".$v."\r\n";
  3044.  
  3045. $d=explode("\r\n",$mailbody);
  3046.  for($i=0;$i<count($d)-1;$i++) {
  3047.   $dataa=explode(" = ",$d[$i]);
  3048.   $dt=$dataa[0];
  3049.   $dataa[0]=eregi_replace("burl","",$dataa[0]);
  3050.   $dataa[0]=eregi_replace("wurl","",$dataa[0]);
  3051.   if($dataa[0]=="b" || $dataa[0]=="eb") {
  3052.   //Do nothing
  3053.   }
  3054.   else {
  3055.    $rs=mysql_query("select * from membersbanners where ID=".$dataa[0]);
  3056.    if(mysql_num_rows($rs)>0) {
  3057. $ac=ereg("burl",$dt);
  3058. if($ac==0) {
  3059.         $rss=mysql_query("update membersbanners set WebsiteURL='$dataa[1]' where ID=$dataa[0]");
  3060. //echo "update membersbanners set WebsiteURL='$dataa[1]' where ID=$dataa[0]";
  3061. }
  3062. else {
  3063.         $rss=mysql_query("update membersbanners set BannerURL='$dataa[1]' where ID=$dataa[0]");
  3064. //echo "update membersbanners set BannerURL='$dataa[1]' where ID=$dataa[0]";
  3065. }
  3066.     }
  3067.    }
  3068. }
  3069. echo "<br><b>Records Successfully Updated</b><br>";
  3070.  
  3071.  
  3072. }
  3073.  
  3074. }
  3075.  
  3076.  
  3077.   elseif (trim($b)==310)
  3078.   {
  3079.   $a[1]=trim($_POST[burl]);
  3080. $a[1]=addslashes($a[1]);
  3081.   $a[2]=trim($_POST[wurl]);
  3082. $a[2]=str_replace("\"","",$a[2]);
  3083. $a[2]=str_replace("'","",$a[2]);
  3084. //  $a[3]=trim($_POST[textad]);
  3085. //$a[3]=addslashes($a[3]);
  3086.  
  3087. $textad="$_POST[burl1]<br>$_POST[burl2]<br>$_POST[burl3]";
  3088. $textad=addslashes($textad);
  3089.   $a[3]=trim($textad);
  3090.  
  3091.  if ($_POST[burl])
  3092.  {
  3093. $sql_i="insert into memberstextads(Username,Textad,WebsiteURL,assigned,remaining,hits,approved,Date,Textad1) values('admin','$a[1]','$a[2]',$_POST[credits],$_POST[credits],0,0,now(),'$a[3]')";
  3094. $rsi=mysql_query($sql_i);
  3095.  
  3096.     print "<p align='center'><font color='red'><b>Sucessfully added record!</b></font></p><br><br>";
  3097.  }
  3098. else {
  3099. ?>
  3100. <p align="center"><h2 align="center">Add Text Ad</h2>
  3101. <form method="post" width="60%" action="" />
  3102. <table border="0" align="center">
  3103. <table>
  3104. <tr><td><font face=verdana size=2>Subject:</td><td><input type=text name=burl maxlength=20 value=""></td></tr>
  3105. <tr><td><font face=verdana size=2>Line1 Text Ad:</td><td><input type=text name=burl1 maxlength=24 value=""></td></tr>
  3106. <tr><td><font face=verdana size=2>Line2 Text Ad:</td><td><input type=text name=burl2 maxlength=24 value=""></td></tr>
  3107. <tr><td><font face=verdana size=2>Line3 Text Ad:</td><td><input type=text name=burl3 maxlength=24 value=""></td></tr>
  3108. <tr><td><font face=verdana size=2>Website Url:</td><td><input type=text name=wurl value="http://"></td></tr>
  3109. <tr><td><font face=verdana size=2>Assign Credits:</td><td><input type=text name=credits value="1000"></td></tr>
  3110. <tr><td colspan=2><input type=submit value="Add Record"> </td></tr>
  3111. </table>
  3112. </form>
  3113. <?  }
  3114. }
  3115.  
  3116.  
  3117.   elseif(trim($b)==311)
  3118.   {
  3119.         echo "<h2 align=center>Approved Text Ads</h2>";
  3120.   $step=50;
  3121.   $currentpage = $p;
  3122.     $sql="Select * from memberstextads where approved=1 order by ID";
  3123.   if(!$rs=mysql_query($sql))
  3124.   {
  3125.     print mysql_error();
  3126.     exit;
  3127.   }
  3128.   $row=mysql_num_rows($rs);
  3129.     $totallinks=$row;
  3130.   if(!isset($currentpage))
  3131.   {
  3132.     $currentpage=1;
  3133.   }
  3134.  
  3135.   if ($totallinks > 0)
  3136.   {
  3137.     if ($totallinks < 50)
  3138.     {
  3139.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  3140.     }
  3141.     else
  3142.     {
  3143.       if (($currentpage*50) > $totallinks)
  3144.       {
  3145.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  3146.       }
  3147.       else
  3148.       {
  3149.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  3150.       }
  3151.     }
  3152.   }
  3153.  
  3154.   if($totallinks > $step)
  3155.   {
  3156.     $pagecount=ceil($totallinks/$step);
  3157.     print "<br>Page NO - &nbsp;&nbsp;";
  3158.     for($i=1;$i<=$pagecount;$i++)
  3159.     {
  3160.       if($pageno==$i)
  3161.       {
  3162.         echo($i . " ");
  3163.       }
  3164.       else
  3165.       {
  3166.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  3167.       }
  3168.     }
  3169.     echo("<br><br><br>");
  3170.   }
  3171.   $start=($currentpage-1)*$step;
  3172.  
  3173.     $query="Select * from memberstextads where approved=1 order by ID";
  3174.   $sql = $query . " LIMIT $start,$step";
  3175.  
  3176.   if(!$result=mysql_query($sql))
  3177.   {
  3178.     print mysql_error();
  3179.     exit;
  3180.   }
  3181.  
  3182.     echo("<br><form action=admin.php method=post name=maj><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>ID.</b></td><td align=center><b>Member ID</b></td><td width=486 align=center><b>Text Ad</b></td><td width=70 align=center><b>Impressions Purchased</b></td><td width=70 align=center><b>Remaining</b></td><td width=70 align=center><b>Hits</b></td><td width=70 align=center><b>Date</b></td><td>Action</td></tr>");
  3183.     while($rs=mysql_fetch_row($result))
  3184.     {
  3185.       echo("<tr><td align=center>".$rs[0]."</td><Td align=center>". $rs[1]."</td><Td align=center><a href=$rs[3] target=_blank>".stripslashes($rs[2])."</a><br>".stripslashes($rs[9])."</td><Td align=center>$rs[4]</td><Td align=center>$rs[5]</td><Td align=center>$rs[6]</td><Td align=center>$rs[8]</td><td><input type=checkbox name=id".$rs[0]."></td></tr>");
  3186.     }
  3187. echo "<tr><td colspan=8 align=center><input name=allbox type=checkbox value=1 onClick=\"CheckAll();\">Select/Un-Select All
  3188. <br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Remove TextAd'>
  3189. </form></td></tr>";
  3190.     echo("</table>");
  3191. ?>
  3192. <script language="JavaScript">
  3193.    <!--
  3194.    function CheckAll()
  3195.    {
  3196.       for (var i=0;i<document.maj.elements.length;i++)
  3197.       {
  3198.          var e = document.maj.elements[i];
  3199.          if (e.name != "allbox")
  3200.             e.checked = document.maj.allbox.checked;
  3201.       }
  3202.    }
  3203.    //-->
  3204. </script>
  3205. <?
  3206.   }
  3207.  
  3208.  
  3209.   elseif(trim($b)==312)
  3210.   {
  3211.         echo "<h2 align=center>Pending Text Ads</h2>";
  3212.   $step=50;
  3213.   $currentpage = $p;
  3214.     $sql="Select * from memberstextads where approved=0 order by ID";
  3215.   if(!$rs=mysql_query($sql))
  3216.   {
  3217.     print mysql_error();
  3218.     exit;
  3219.   }
  3220.   $row=mysql_num_rows($rs);
  3221.     $totallinks=$row;
  3222.   if(!isset($currentpage))
  3223.   {
  3224.     $currentpage=1;
  3225.   }
  3226.  
  3227.   if ($totallinks > 0)
  3228.   {
  3229.     if ($totallinks < 50)
  3230.     {
  3231.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  3232.     }
  3233.     else
  3234.     {
  3235.       if (($currentpage*50) > $totallinks)
  3236.       {
  3237.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  3238.       }
  3239.       else
  3240.       {
  3241.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  3242.       }
  3243.     }
  3244.   }
  3245.  
  3246.   if($totallinks > $step)
  3247.   {
  3248.     $pagecount=ceil($totallinks/$step);
  3249.     print "<br>Page NO - &nbsp;&nbsp;";
  3250.     for($i=1;$i<=$pagecount;$i++)
  3251.     {
  3252.       if($pageno==$i)
  3253.       {
  3254.         echo($i . " ");
  3255.       }
  3256.       else
  3257.       {
  3258.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  3259.       }
  3260.     }
  3261.     echo("<br><br><br>");
  3262.   }
  3263.   $start=($currentpage-1)*$step;
  3264.  
  3265.     $query="Select * from memberstextads where approved=0 order by ID";
  3266.   $sql = $query . " LIMIT $start,$step";
  3267.  
  3268.   if(!$result=mysql_query($sql))
  3269.   {
  3270.     print mysql_error();
  3271.     exit;
  3272.   }
  3273.  
  3274.     echo("<br><form action=admin.php method=post name=maj><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>ID.</b></td><td align=center><b>Member ID</b></td><td width=486 align=center><b>Text Ad</b></td><td width=70 align=center><b>Impressions Purchased</b></td><td width=70 align=center><b>Remaining</b></td><td width=70 align=center><b>Hits</b></td><td width=70 align=center><b>Date</b></td><td align=center><b>Action</b></td></tr>");
  3275.     while($rs=mysql_fetch_row($result))
  3276.     {
  3277.       echo("<tr><td align=center>".$rs[0]."</td><Td align=center>". $rs[1]."</td><Td align=center><a href=$rs[3] target=_blank>".stripslashes($rs[2])."</a><br>".stripslashes($rs[9])."</td><Td align=center>$rs[4]</td><Td align=center>$rs[5]</td><Td align=center>$rs[6]</td><Td align=center>$rs[8]</td><td><input type=checkbox name=id".$rs[0]."></td></tr>");
  3278.     }
  3279. echo "<tr><td colspan=8 align=center><input name=allbox type=checkbox value=1 onClick=\"CheckAll();\">Select/Un-Select All
  3280. <br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Approve TextAd'>
  3281.    <input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Remove TextAd'>
  3282. </form></td></tr>";
  3283.     echo("</table>");
  3284. ?>
  3285. <script language="JavaScript">
  3286.    <!--
  3287.    function CheckAll()
  3288.    {
  3289.       for (var i=0;i<document.maj.elements.length;i++)
  3290.       {
  3291.          var e = document.maj.elements[i];
  3292.          if (e.name != "allbox")
  3293.             e.checked = document.maj.allbox.checked;
  3294.       }
  3295.    }
  3296.    //-->
  3297. </script>
  3298. <?
  3299.   }
  3300.  
  3301.  
  3302.   elseif(trim($b)=="Remove TextAd")
  3303.   {
  3304. foreach($_POST as $k=>$v) {
  3305. $d=explode("id",$k);
  3306. if($d[1]!="") {
  3307. $rs=mysql_query("select * from memberstextads where ID=$d[1]");
  3308. $arr=mysql_fetch_array($rs);
  3309. $id=$arr[0];
  3310.  
  3311.     $sql_d="select * from memberstextads where ID=" .  $id;
  3312.     $rs_d=mysql_query($sql_d);
  3313.     $arr=mysql_fetch_array($rs_d);
  3314.  
  3315.     $sql_d="delete from memberstextads where ID=" .  $id;
  3316.     $rs_d=mysql_query($sql_d);
  3317.  
  3318.     $sql="select * from users where Username='$arr[1]'" ;
  3319.     $rs=mysql_query($sql);
  3320.     $arr1=mysql_fetch_array($rs);
  3321.  
  3322. mysql_query("update users set textadsused=textadsused-$arr[5] where Username='$arr[1]'");
  3323.  
  3324. $to=$arr1[7];
  3325. $message1=$message9;
  3326. $message1=str_replace("{name}","$arr1[1]",$message1);
  3327. $message1=str_replace("{email}","$arr1[7]",$message1);
  3328. $message1=str_replace("{username}","$arr1[8]",$message1);
  3329. $message1=str_replace("{password}","$arr1[9]",$message1);
  3330. $message1=str_replace("{textad}","$arr[2]",$message1);
  3331. $message1=str_replace("{websiteurl}","$arr[3]",$message1);
  3332. $message1=str_replace("{sitename}","$sitename",$message1);
  3333. $message1=str_replace("{siteurl}","$siteurl",$message1);
  3334.  
  3335. $subject1=str_replace("{name}","$arr1[1]",$subject9);
  3336. $subject1=str_replace("{email}","$arr1[7]",$subject1);
  3337. $subject1=str_replace("{username}","$arr1[8]",$subject1);
  3338. $subject1=str_replace("{password}","$arr1[9]",$subject1);
  3339. $subject1=str_replace("{sitename}","$sitename",$subject1);
  3340. $subject1=str_replace("{siteurl}","$siteurl",$subject1);
  3341.       $message=stripslashes($message1);
  3342.       $subject=stripslashes($subject1);
  3343.  
  3344. $from=$webmasteremail;
  3345.         $header = "From: $sitename<$from>\n";
  3346. if($eformat9==1)
  3347.     $header .="Content-type: text/plain; charset=iso-8859-1\n";
  3348. else
  3349.     $header .="Content-type: text/html; charset=iso-8859-1\n";
  3350.     $header .= "Reply-To: <$from>\n";
  3351.     $header .= "X-Sender: <$from>\n";
  3352.     $header .= "X-Mailer: PHP4\n";
  3353.     $header .= "X-Priority: 3\n";
  3354.     $header .= "Return-Path: <$from>\n";
  3355.  
  3356.   mail($to,$subject,$message,$header);
  3357.  
  3358. }
  3359. }
  3360.     echo("<br><b>Text Ad(s) Successfully Removed");
  3361.   }
  3362.  
  3363.  
  3364.   elseif(trim($b)=="Approve TextAd")
  3365.   {
  3366. foreach($_POST as $k=>$v) {
  3367. $d=explode("id",$k);
  3368. if($d[1]!="") {
  3369. $rs=mysql_query("select * from memberstextads where ID=$d[1]");
  3370. $arr=mysql_fetch_array($rs);
  3371. $id=$arr[0];
  3372.  
  3373.     $sql_d="Update memberstextads set approved=1 where ID=".$id;
  3374.     $rs_d=mysql_query($sql_d);
  3375.     $sql_d="select * from memberstextads where ID=".$id;
  3376.     $rs_d=mysql_query($sql_d);
  3377.     $arr=mysql_fetch_array($rs_d);
  3378.  
  3379.     $sql="select * from users where Username='$arr[1]'" ;
  3380.     $rs=mysql_query($sql);
  3381.     $arr1=mysql_fetch_array($rs);
  3382.  
  3383. $to=$arr1[7];
  3384. $message1=$message8;
  3385. $message1=str_replace("{name}","$arr1[1]",$message1);
  3386. $message1=str_replace("{email}","$arr1[7]",$message1);
  3387. $message1=str_replace("{username}","$arr1[8]",$message1);
  3388. $message1=str_replace("{password}","$arr1[9]",$message1);
  3389. $message1=str_replace("{textad}","$arr[2]",$message1);
  3390. $message1=str_replace("{websiteurl}","$arr[3]",$message1);
  3391. $message1=str_replace("{sitename}","$sitename",$message1);
  3392. $message1=str_replace("{siteurl}","$siteurl",$message1);
  3393.  
  3394. $subject1=str_replace("{name}","$arr1[1]",$subject8);
  3395. $subject1=str_replace("{email}","$arr1[7]",$subject1);
  3396. $subject1=str_replace("{username}","$arr1[8]",$subject1);
  3397. $subject1=str_replace("{password}","$arr1[9]",$subject1);
  3398. $subject1=str_replace("{sitename}","$sitename",$subject1);
  3399. $subject1=str_replace("{siteurl}","$siteurl",$subject1);
  3400.       $message=stripslashes($message1);
  3401.       $subject=stripslashes($subject1);
  3402.  
  3403. $from=$webmasteremail;
  3404.         $header = "From: $sitename<$from>\n";
  3405. if($eformat8==1)
  3406.     $header .="Content-type: text/plain; charset=iso-8859-1\n";
  3407. else
  3408.     $header .="Content-type: text/html; charset=iso-8859-1\n";
  3409.     $header .= "Reply-To: <$from>\n";
  3410.     $header .= "X-Sender: <$from>\n";
  3411.     $header .= "X-Mailer: PHP4\n";
  3412.     $header .= "X-Priority: 3\n";
  3413.     $header .= "Return-Path: <$from>\n";
  3414.  
  3415.   mail($to,$subject,$message,$header);
  3416. }
  3417. }
  3418.     echo("<br><b>Text Ad(s) Successfully Approved");
  3419.   }
  3420.  
  3421.  
  3422.  
  3423.  
  3424.  
  3425.   else { ?>
  3426. <br>
  3427. <br>
  3428. <b><center><font face=verdana size=2>Live News Update from Script Seller</b>
  3429. <br><br>
  3430. <script src="http://www.freeworldscripts.com/revsharingadmin.php"></script>
  3431. </font>
  3432. </center>
  3433. <?
  3434.   }
  3435.  
  3436. }
  3437.   // ***************************************************
  3438.   function sendmail($from,$to,$subject,$format,$body)
  3439.   {
  3440. include "config.php";
  3441.     $to = $to;
  3442.     $subject = $subject;
  3443. $from=$webmasteremail;
  3444.         $header = "From: $sitename<$from>\n";
  3445.  
  3446.     if($format == 1)
  3447.     $header .="Content-type: text/html; charset=iso-8859-1\n";
  3448.     else
  3449.     $header .="Content-type: text/plain; charset=iso-8859-1\n";
  3450.  
  3451.     $header .= "Reply-To: <$from>\n";
  3452.     $header .= "X-Sender: <$from>\n";
  3453.     $header .= "X-Mailer: PHP4\n";
  3454.     $header .= "X-Priority: 3\n";
  3455.     $header .= "Return-Path: <$from>\n";
  3456.  
  3457.     mail($to, $subject , $body, $header);
  3458.  }
  3459. function my_array_unique($somearray){
  3460.    $tmparr = array_unique($somearray);
  3461.    $k=0;
  3462.    foreach ($tmparr as $v) {
  3463.        $newarr[$k] = $v;
  3464.        $k++;
  3465.    }
  3466.    return $newarr;
  3467. }
  3468.     function random_number()
  3469.     {
  3470.         $random_number = rand(0,9);
  3471.         return $random_number;
  3472.     }
  3473.  
  3474.  
  3475. function membersrecords($query, $number, $b ,$p)
  3476. {
  3477.   $step=50;
  3478.   $currentpage = $p;
  3479.  
  3480.     $sql="select * from users";
  3481.   if(!$rs=mysql_query($sql))
  3482.   {
  3483.     print mysql_error();
  3484.     exit;
  3485.   }
  3486.   $row=mysql_num_rows($rs);
  3487.     $totallinks=$row;
  3488.   if(!isset($currentpage))
  3489.   {
  3490.     $currentpage=1;
  3491.   }
  3492.  
  3493.   if ($totallinks > 0)
  3494.   {
  3495.     if ($totallinks < 50)
  3496.     {
  3497.         echo("<br><b>Displaying Records from 1 - " . $totallinks . "</b><br>");
  3498.     }
  3499.     else
  3500.     {
  3501.       if (($currentpage*50) > $totallinks)
  3502.       {
  3503.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".$totallinks."</b><br>");
  3504.       }
  3505.       else
  3506.       {
  3507.         echo("<br><b>Displaying Records from ".intval(($currentpage*50)-49)." - ".intval($currentpage*50)."</b><br>");
  3508.       }
  3509.     }
  3510.   }
  3511.  
  3512.   if($totallinks > $step)
  3513.   {
  3514.     $pagecount=ceil($totallinks/$step);
  3515.     print "<br>Page NO - &nbsp;&nbsp;";
  3516.     for($i=1;$i<=$pagecount;$i++)
  3517.     {
  3518.       if($pageno==$i)
  3519.       {
  3520.         echo($i . " ");
  3521.       }
  3522.       else
  3523.       {
  3524.         echo("<a href='admin.php?b=".$b."&p=".$i."'>".$i."</a> &nbsp; ");
  3525.       }
  3526.     }
  3527.     echo("<br><br><br>");
  3528.   }
  3529.   $start=($currentpage-1)*$step;
  3530.  
  3531.     $query="Select * from users order by ID";
  3532.   $sql = $query . " LIMIT $start,$step";
  3533.  
  3534.   if(!$result=mysql_query($sql))
  3535.   {
  3536.     print mysql_error();
  3537.     exit;
  3538.   }
  3539.     echo("<br><table width=98% border=1 cellspacing=0 cellpadding=0><tr><td align=center width=20><b>Record No.</b></td><td align=center><b>Name</b></td><td align=center valign=center><b>Email</b></td><td width=70 align=center><b>Username</b></td><td width=70 align=center><b>Status</b></td><td align=center><b>Action</b></td></tr>");
  3540.     while($rs=mysql_fetch_row($result))
  3541.     {
  3542.       $rowcount=$rowcount+1;
  3543.       $no = (intval($currentpage* 50)-50 + $rowcount);
  3544.     if($rs[10]==0) {
  3545.     $st="Inactive<br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Resend Verfication Email'><br><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Verify Account'>";
  3546.     } else {
  3547.     if($rs[14]==1) {
  3548.     $st="Free";
  3549.     }
  3550.     else {
  3551.     $st="Pro";
  3552.     }   }
  3553.       echo("<tr><form action='admin.php' method=post><input type=hidden name=id value=". $rs[0]."><td align=center>".$no."</td><Td align=center>". $rs[1]."</td><Td align=center>". $rs[7]."</td><Td align=center>". $rs[8]."</td><Td align=center>". $st."</td><Td align=center valign=center>");
  3554.       echo("<input type=hidden name=atype value=".$number."><input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='View Details'>&nbsp;&nbsp;");
  3555.       echo("<input type=Submit style='color: #000000; font-size: 10pt; font-family: Verdana; font-weight: bold; border: 1px ridge #000000; background-color: B0D8DD' name='b' value='Delete Account'></form></td></tr>");
  3556.     }  // wend
  3557.     echo("</table>");
  3558.  
  3559. } // Function
  3560.  
  3561.  
  3562. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!