Changeset 9984 for trunk/aff/partners.php

Timestamp:

04/06/09 22:50:09 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/aff/partners.php (modified) (6 diffs)

trunk/aff/partners.php

@@ -106 +106 @@
             if ( (int)$key && $val == "on" )
             {
-                $res = db_res("DELETE FROM aff WHERE ID='$key'");
+                $res = db_res("DELETE FROM `sys_aff` WHERE ID='$key'");
                 if (!$res)
                 {
@@ -134 +134 @@
         $aff_percent = process_db_input( $_POST['Percent'] );
         $aff_status = process_db_input( $_POST['Status'] );
-        $res = db_res("INSERT INTO `aff` (`Name`,`email`,`Password`,`Percent`,`Status`) VALUES ('$aff_name', '$aff_email', md5( '$aff_password' ), '$aff_percent', '$aff_status')");
+        $res = db_res("INSERT INTO `sys_aff` (`Name`,`email`,`Password`,`Percent`,`Status`) VALUES ('$aff_name', '$aff_email', md5( '$aff_password' ), '$aff_percent', '$aff_status')");
         if (!$res)
         {
@@ -152 +152 @@
     if ( !$demo_mode && (int)$_GET[editdis] )
     {
-        $editdis_arr = db_arr( "SELECT `ID`, `Name`, `email`, `Password`, `Percent`, `seed`, DATE_FORMAT(`RegDate`, '$date_format' ) AS RegDate, `Status`, `www1`, `www2` FROM aff WHERE ID='".$_GET[editdis]."'" );
+        $editdis_arr = db_arr( "SELECT `ID`, `Name`, `email`, `Password`, `Percent`, `seed`, DATE_FORMAT(`RegDate`, '$date_format' ) AS RegDate, `Status`, `www1`, `www2` FROM `sys_aff` WHERE ID='".$_GET[editdis]."'" );
     }
 
@@ -161 +161 @@
         else
             $sPassword = "`Password`=md5( '$_POST[Password]' ),";
-        $res = db_res("UPDATE aff SET `Name`='$_POST[Name]',`email`='$_POST[email]'," . $sPassword . "`Percent`='$_POST[Percent]',`Status`='$_POST[Status]' WHERE ID=$_POST[ID]");
+        $res = db_res("UPDATE `sys_aff` SET `Name`='$_POST[Name]',`email`='$_POST[email]'," . $sPassword . "`Percent`='$_POST[Percent]',`Status`='$_POST[Status]' WHERE ID=$_POST[ID]");
         if ( $res )
             $status_text = "Partner was successfully updated.";
@@ -184 +184 @@
 // ------------------------------
 
-$p_num = db_arr( "SELECT COUNT(*) FROM aff" );
+$p_num = db_arr( "SELECT COUNT(*) FROM `sys_aff`" );
 $p_num = $p_num[0];
 $pages_num = ceil( $p_num / $p_per_page );
@@ -191 +191 @@
 $page_first_p = $real_first_p + 1;
 
-$result = db_res( "SELECT ID, Name, email, Password, Percent, www1, www2, Status, DATE_FORMAT(`RegDate`, '$date_format' ) AS RegDate, COUNT(idProfile) AS m_count FROM aff LEFT JOIN `sys_aff_members` ON (ID=idAff) GROUP BY ID $part_addon ORDER BY ID ASC LIMIT $real_first_p, $p_per_page" );
+$result = db_res( "SELECT ID, Name, email, Password, Percent, www1, www2, Status, DATE_FORMAT(`RegDate`, '$date_format' ) AS RegDate, COUNT(idProfile) AS m_count FROM `sys_aff` LEFT JOIN `sys_aff_members` ON (ID=idAff) GROUP BY ID $part_addon ORDER BY ID ASC LIMIT $real_first_p, $p_per_page" );
 $page_p_num = mysql_num_rows( $result );