Changeset 10378

Timestamp:

05/01/09 01:18:36 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

Location:

trunk

Files:

• admin/adminMenuCompose.php (modified) (7 diffs)
• admin/global_settings.php (modified) (1 diff)
• admin/groups.php (modified) (3 diffs)
• admin/lang_file.php (modified) (8 diffs)
• admin/memb_levels.php (modified) (12 diffs)
• admin/member_menu_compose.php (modified) (5 diffs)
• admin/menu_compose.php (modified) (5 diffs)
• admin/notifies.php (modified) (1 diff)
• admin/profiles.php (modified) (1 diff)
• admin/quotes.php (modified) (3 diffs)
• group_actions.php (modified) (4 diffs)
• inc/admin.inc.php (modified) (1 diff)
• inc/classes/BxDolCommunicator.php (modified) (2 diffs)
• inc/classes/BxDolCronCmd.php (modified) (4 diffs)
• inc/classes/BxDolGroups.php (modified) (2 diffs)
• inc/classes/BxDolInstaller.php (modified) (2 diffs)
• inc/classes/BxDolMailBox.php (modified) (3 diffs)
• inc/classes/BxDolPFM.php (modified) (3 diffs)
• inc/classes/BxDolPageViewAdmin.php (modified) (2 diffs)
• inc/classes/BxDolProfilesController.php (modified) (1 diff)
• inc/languages.inc.php (modified) (7 diffs)
• inc/membership_levels.inc.php (modified) (2 diffs)
• inc/profiles.inc.php (modified) (1 diff)
• inc/utils.inc.php (modified) (2 diffs)
• member.php (modified) (1 diff)
• modules/boonex/ads/classes/BxAdsModule.php (modified) (8 diffs)
• modules/boonex/ads/post_mod_ads.php (modified) (4 diffs)
• modules/boonex/blogs/classes/BxBlogsModule.php (modified) (2 diffs)
• modules/boonex/shared_photo/classes/BxShPhotoMain.php (modified) (1 diff)
• periodic/cmd.php (modified) (4 diffs)

trunk/admin/adminMenuCompose.php

@@ -74 +74 @@
                 $id = $id - 1000;
                 db_res( "DELETE FROM `sys_menu_admin_categ` WHERE `ID`=$id" );
-                echo mysql_affected_rows();
+                echo db_affected_rows();
             }
             else
@@ -128 +128 @@
             }
             
-            if( mysql_affected_rows() )
+            if( db_affected_rows() )
                 echo 'OK';
             else
@@ -407 +407 @@
                 " );
             
-            $newID = mysql_insert_id();
+            $newID = db_last_id();
         }
         elseif( $type == 'custom' and $source < 1000 )
@@ -426 +426 @@
                     " );
                 
-                $newID = mysql_insert_id();
+                $newID = db_last_id();
             }
         }
@@ -442 +442 @@
                 " );
             
-            $newID = mysql_insert_id();
+            $newID = db_last_id();
         }
         elseif( $type == 'top' and $source < 1000 )
@@ -455 +455 @@
                 " );
             
-            $newID = mysql_insert_id();
+            $newID = db_last_id();
         }
     }
@@ -465 +465 @@
             db_res( "INSERT INTO `sys_menu_admin` SET `Title` = 'NEW ITEM'" );
             
-        $newID = mysql_insert_id();
+        $newID = db_last_id();
     }
     

trunk/admin/global_settings.php

@@ -596 +596 @@
         // Write new password to database.
         $q_str = "UPDATE `sys_admins` SET Password = md5('$pwd_new') WHERE Name = '$admin_name'";
-        mysql_query($q_str);
+        db_res($q_str);
         $result = S_OK;
     }

trunk/admin/groups.php

@@ -40 +40 @@
             $sNewURI = uriGenerate($sPrepName, 'GroupsCateg', 'Uri', 255);
             db_res( "INSERT INTO `GroupsCateg` SET `Name`='{$sPrepName}', `Uri`='{$sNewURI}'" );
-            $newID = mysql_insert_id();
+            $newID = db_last_id();
             if( $newID )
                 $actionMsg .= 'Added succesfully';
@@ -52 +52 @@
         if( $catID ) {
             db_res( "DELETE FROM `GroupsCateg` WHERE `ID`=$catID" );
-            if( mysql_affected_rows() )
+            if( db_affected_rows() )
                 $actionMsg .= 'Deleted succesfully';
             else
@@ -64 +64 @@
         if( $catID and $name ) {
             db_res( "UPDATE `GroupsCateg` SET `Name`='".process_db_input($name)."' WHERE `ID`=$catID" );
-            if( mysql_affected_rows() )
+            if( db_affected_rows() )
                 $actionMsg .= 'Renamed succesfully';
             else

trunk/admin/lang_file.php

@@ -433 +433 @@
         {
             db_res("INSERT INTO `sys_localization_categories` (`Name`) VALUES ('$newCategoryName')");
-            $categoryID = mysql_insert_id();
+            $categoryID = db_last_id();
 
             if ( !$categoryID )
@@ -451 +451 @@
         } else {
             db_res("INSERT INTO `sys_localization_keys` (`IDCategory`, `Key`) VALUES ({$categoryID}, '{$newKeyName}')", 0);
-            $newKeyID = mysql_insert_id();
+            $newKeyID = db_last_id();
         }
 
@@ -475 +475 @@
             );
 
-            if( !mysql_affected_rows() )
+            if( !db_affected_rows() )
                 return '<font color="red">Could not insert a string parameter.</font>';
         }
@@ -504 +504 @@
                         VALUES ({$newKeyID}, {$langKey}, '{$langString}')
                     ");
-                    if (mysql_affected_rows() <= 0) return '<font color="red">Error: could not add a language string.</font>';
+                    if (db_affected_rows() <= 0) return '<font color="red">Error: could not add a language string.</font>';
                 }
             }
@@ -649 +649 @@
                     `IDLanguage` = $langID");
 
-        if (mysql_affected_rows() <= 0)
+        if (db_affected_rows() <= 0)
         {
             return '<font color="red">The string has <b>NOT</b> been updated.</font>';
@@ -946 +946 @@
         db_res( $sQuery );
 
-        if ( mysql_affected_rows() )
+        if ( db_affected_rows() )
             return 'Language has been successfully updated.';
 
@@ -1012 +1012 @@
         ");
 
-        if(mysql_affected_rows() <= 0) return '<font color="red">Error: could not add a new language to the database.</font>';
-
-        $newLangID = mysql_insert_id();
+        if(db_affected_rows() <= 0) return '<font color="red">Error: could not add a new language to the database.</font>';
+
+        $newLangID = db_last_id();
 
         $resSourceLangStrings = db_res("
@@ -1031 +1031 @@
                 ", 0);
             
-            if( !mysql_affected_rows() )
+            if( !db_affected_rows() )
                 return '<font color="red">Error: could not add a language string to the database.</font>';
         }

trunk/admin/memb_levels.php

@@ -135 +135 @@
     if($membershipID <= 0) return '';
 
-    $resMemLevel = mysql_query("SELECT `Icon`, `Removable` FROM `sys_acl_levels` WHERE ID = $membershipID");
+    $resMemLevel = db_res("SELECT `Icon`, `Removable` FROM `sys_acl_levels` WHERE ID = $membershipID");
 
     if(mysql_num_rows($resMemLevel) < 1) {
@@ -150 +150 @@
     //check if there are still members using this membership
 
-    $resMaxDateExpires = @mysql_query("
+    $resMaxDateExpires = db_res("
         SELECT UNIX_TIMESTAMP(MAX(DateExpires)) as MaxDateExpires
         FROM `sys_acl_levels_members` WHERE IDLevel = $membershipID");
@@ -169 +169 @@
 
     @unlink(BX_DIRECTORY_PATH_ROOT . 'media/images/membership/' . $aRemovable['Icon']);
-    @mysql_query("DELETE FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID");
-    @mysql_query("DELETE FROM `sys_acl_matrix` WHERE IDLevel = $membershipID");
-    @mysql_query("DELETE FROM `sys_acl_levels` WHERE ID = $membershipID");
-
-    if(mysql_affected_rows() > 0) {
+    db_res("DELETE FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID");
+    db_res("DELETE FROM `sys_acl_matrix` WHERE IDLevel = $membershipID");
+    db_res("DELETE FROM `sys_acl_levels` WHERE ID = $membershipID");
+
+    if(db_affected_rows() > 0) {
         return "\n<div class=\"actionSuccess\">Membership has been deleted</div>";
     }
@@ -187 +187 @@
     if($membershipID <= 0) return '';
 
-    $resMemLevel = mysql_query("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
+    $resMemLevel = db_res("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
 
     if(mysql_num_rows($resMemLevel) < 1) {
@@ -202 +202 @@
     }
 
-    @mysql_query("UPDATE `sys_acl_levels` SET Active = '$active' WHERE ID = $membershipID");
-
-    if(mysql_affected_rows() <= 0){
+    db_res("UPDATE `sys_acl_levels` SET Active = '$active' WHERE ID = $membershipID");
+
+    if(db_affected_rows() <= 0){
         $de = $active ? '' : 'de';
         return "\n<div class=\"actionFailure\">Error: membership has not been {$de}activated</div>";
@@ -441 +441 @@
     if($days < 0 || $price <= 0) return "\n<div class=\"actionFailure\">Error: payment option has not been added</div>";
 
-    @mysql_query("INSERT INTO `sys_acl_level_prices` (IDLevel, Days, Price) VALUES ($membershipID, $days, $price)");
-
-    if(mysql_affected_rows() > 0)
+    db_res("INSERT INTO `sys_acl_level_prices` (IDLevel, Days, Price) VALUES ($membershipID, $days, $price)");
+
+    if(db_affected_rows() > 0)
     {
         if ( $days > 0 )
@@ -465 +465 @@
     if($membershipID <= 0 || $days < 0) return '';
 
-    @mysql_query("DELETE FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID AND Days = $days");
-
-    if(mysql_affected_rows() > 0)
+    db_res("DELETE FROM `sys_acl_level_prices` WHERE IDLevel = $membershipID AND Days = $days");
+
+    if(db_affected_rows() > 0)
     {
         if ( $days > 0 )
@@ -489 +489 @@
     //check if membership can be purchased
 
-    $resMemLevel = mysql_query("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
+    $resMemLevel = db_res("SELECT Purchasable FROM `sys_acl_levels` WHERE ID = $membershipID");
 
     if(mysql_num_rows($resMemLevel) < 1) {
@@ -594 +594 @@
     if($membershipID <= 0 || $actionID <= 0) return '';
 
-    @mysql_query("INSERT INTO `sys_acl_matrix`
+    db_res("INSERT INTO `sys_acl_matrix`
                   (IDLevel, IDAction, AllowedCount, AllowedPeriodLen, AllowedPeriodStart, AllowedPeriodEnd)
                   VALUES ($membershipID, $actionID, NULL, NULL, NULL, NULL)");
 
-    if(mysql_affected_rows() > 0)
+    if(db_affected_rows() > 0)
         return $msgAdded;
     else
@@ -614 +614 @@
     if($membershipID <= 0 || $actionID <= 0) return '';
 
-    @mysql_query("DELETE FROM `sys_acl_matrix` WHERE IDLevel = $membershipID AND IDAction = $actionID");
-
-    if(mysql_affected_rows() > 0)
+    db_res("DELETE FROM `sys_acl_matrix` WHERE IDLevel = $membershipID AND IDAction = $actionID");
+
+    if(db_affected_rows() > 0)
         return $msgDeleted;
     else
@@ -660 +660 @@
     $periodEnd = "FROM_UNIXTIME($periodEnd)";
 
-    @mysql_query("
+    db_res("
         UPDATE  `sys_acl_matrix`
         SET     AllowedCount = $cnt,
@@ -669 +669 @@
         WHERE IDLevel = $membershipID AND IDAction = $actionID");
 
-    if(mysql_affected_rows() > 0) {
+    if(db_affected_rows() > 0) {
         return $msgUpdated;
     }else {

trunk/admin/member_menu_compose.php

@@ -82 +82 @@
         case 'deactivate_item':
             $res = db_res( "UPDATE `sys_menu_member` SET `Active`='0' WHERE `ID`=" . (int)$_GET['id'] );
-            $sResponce =  mysql_affected_rows();
+            $sResponce =  db_affected_rows();
         break;
 
@@ -128 +128 @@
                 else {
                     db_res( "DELETE FROM `sys_menu_member` WHERE `ID` = $id" );
-                    if( mysql_affected_rows() )
+                    if( db_affected_rows() )
                     {
                         $sResponce =  'OK';
@@ -382 +382 @@
                     FROM `sys_menu_member`
                     WHERE `ID`=$source" );
-            $newID = mysql_insert_id();
+            $newID = db_last_id();
         }
     }
@@ -389 +389 @@
         //create new
         db_res( "INSERT INTO `sys_menu_member` ( `Name`, `Position` ) VALUES ( 'NEW ITEM', '$type' )" );
-        $newID = mysql_insert_id();
+        $newID = db_last_id();
     }
     
@@ -456 +456 @@
     {
         db_res( "INSERT INTO `sys_localization_keys` SET `IDCategory` = 2, `Key` = '" . process_db_input( $key ) . "'" );
-        db_res( "INSERT INTO `sys_localization_strings` SET `IDKey` = " . mysql_insert_id() . ", `IDLanguage` = $langID, `String` = '" .process_db_input( $string ) . "'" );
+        db_res( "INSERT INTO `sys_localization_strings` SET `IDKey` = " . db_last_id() . ", `IDLanguage` = $langID, `String` = '" .process_db_input( $string ) . "'" );
     }
     

trunk/admin/menu_compose.php

@@ -61 +61 @@
         case 'deactivate_item':
             $res = db_res( "UPDATE `sys_menu_top` SET `Active`=0 WHERE `ID`=" . (int)$_GET['id'] );
-            echo mysql_affected_rows();
+            echo db_affected_rows();
             $oMenu -> compile();
         exit;
@@ -116 +116 @@
             
             db_res( "DELETE FROM `sys_menu_top` WHERE `ID` = $id" );
-            if( mysql_affected_rows() )
+            if( db_affected_rows() )
                 echo 'OK';
             else
@@ -358 +358 @@
                     FROM `sys_menu_top`
                     WHERE `ID`=$source" );
-            $newID = mysql_insert_id();
+            $newID = db_last_id();
         }
     }
@@ -365 +365 @@
         //create new
         db_res( "INSERT INTO `sys_menu_top` ( `Name`, `Type` ) VALUES ( 'NEW ITEM', '$type' )" );
-        $newID = mysql_insert_id();
+        $newID = db_last_id();
     }
     
@@ -421 +421 @@
     {
         db_res( "INSERT INTO `sys_localization_keys` SET `IDCategory` = 2, `Key` = '" . process_db_input( $key ) . "'" );
-        db_res( "INSERT INTO `sys_localization_strings` SET `IDKey` = " . mysql_insert_id() . ", `IDLanguage` = $langID, `String` = '" .process_db_input( $string ) . "'" );
+        db_res( "INSERT INTO `sys_localization_strings` SET `IDKey` = " . db_last_id() . ", `IDLanguage` = $langID, `String` = '" .process_db_input( $string ) . "'" );
     }
     

trunk/admin/notifies.php

@@ -251 +251 @@
     $res = db_res( $query );
     if ( $res )
-        $_POST['msgs_id'] = mysql_insert_id();
+        $_POST['msgs_id'] = db_last_id();
 
     return $res;

trunk/admin/profiles.php

@@ -88 +88 @@
                     $sCheckBanSQL = "SELECT * FROM `sys_admin_ban_list` WHERE `ProfID`='{$val}' LIMIT 1";
                     db_res($sCheckBanSQL);
-                    if (mysql_affected_rows()==1) {
+                    if (db_affected_rows()==1) {
                         $sBamSQL = "UPDATE `sys_admin_ban_list` SET `Time`='{$iBanTime}', `DateTime`=NOW() WHERE `ProfID`='{$val}'";
                     } else {

trunk/admin/quotes.php

@@ -1 @@
-<?
+<?php
 
 /***************************************************************************
@@ -398 +398 @@
     global $use_table;
     global $fields_types;
-    global $MySQL;
 
     $num = 0;
@@ -408 +407 @@
             $query = "DELETE FROM $use_table WHERE ". get_index_fieldname() ." = $k";
             if ( db_res ($query) )
-                $num += mysql_affected_rows( $MySQL->link );
+                $num += db_affected_rows();
         }
     }

trunk/group_actions.php

@@ -140 +140 @@
                                         db_res( $query );
                                         
-                                        $imgID = mysql_insert_id();
+                                        $imgID = db_last_id();
                                         
                                         rename( $tempImg,  $oGroups->sGrpGalPath."{$groupID}_{$imgID}_{$seed}.{$Ext}" );
@@ -347 +347 @@
                     
                     $resAppr = db_res( $queryAppr );
-                    if( mysql_affected_rows() )
+                    if( db_affected_rows() )
                     {
                         $_page['header']        = _t( "_Group member approve" );
@@ -398 +398 @@
                     
                     $resAppr = db_res( $queryAppr );
-                    if( mysql_affected_rows() )
+                    if( db_affected_rows() )
                     {
                         $_page['header']        = _t( "_Group member reject" );
@@ -508 +508 @@
                     `status`='Invited'
                 " );
-            if( mysql_affected_rows() )
+            if( db_affected_rows() )
             {
                 $_page['header']        = _t( "_Group invite accept" );

trunk/inc/admin.inc.php

@@ -840 +840 @@
     db_res( "DELETE FROM `sys_greetings` WHERE `ID` = '{$ID}' OR `Profile` = '{$ID}'" );
     
-    if ( !mysql_affected_rows() )
+    if ( ! db_affected_rows() )
         return false;
     

trunk/inc/classes/BxDolCommunicator.php

@@ -264 +264 @@
             }
 
-            return mysql_affected_rows();
+            return db_affected_rows();
         }
 
@@ -302 +302 @@
            }
 
-           return mysql_affected_rows();
+           return db_affected_rows();
         }
 

trunk/inc/classes/BxDolCronCmd.php

@@ -75 +75 @@
             $res = db_res("DELETE FROM `sys_greetings` WHERE (TO_DAYS(NOW()) - TO_DAYS(`When`)) > $db_clean_vkiss");
             if ( $res )
-                $db_clean_vkiss_num = mysql_affected_rows();
+                $db_clean_vkiss_num = db_affected_rows();
         }
     
@@ -82 +82 @@
             $res = db_res("DELETE FROM `sys_messages` WHERE (TO_DAYS(NOW()) - TO_DAYS(`Date`)) > $db_clean_msg");
             if ( $res )
-                $db_clean_msg_num = mysql_affected_rows();
+                $db_clean_msg_num = db_affected_rows();
         }
     
@@ -89 +89 @@
             $res = db_res("DELETE FROM `sys_profiles_track` WHERE (TO_DAYS(NOW())-TO_DAYS(`When`)) > $db_clean_views");
             if ( $res )
-                $db_clean_views_num = mysql_affected_rows();
+                $db_clean_views_num = db_affected_rows();
         }
         
@@ -99 +99 @@
             $rRes = db_res($sqlQuery);
             if ($rRes)
-                $iDbCleanAlertNum = mysql_affected_rows();
+                $iDbCleanAlertNum = db_affected_rows();
         }
         echo "\n- Database cleaning -\n";

trunk/inc/classes/BxDolGroups.php

@@ -1667 +1667 @@
             $sQuerySQL = "UPDATE `Groups` {$sSqlSet} WHERE `ID`='{$iGroupID}'";
             db_res( $sQuerySQL );
-            if( mysql_affected_rows() ) {
+            if( db_affected_rows() ) {
                 $this->saveGroupForum( $iGroupID, $aGroupInfo );
                 return true;
@@ -1675 +1675 @@
             $sQuerySQL = "INSERT `Groups` {$sSqlSet}, `created`=UNIX_TIMESTAMP()";
             db_res( $sQuerySQL );
-            $iGroupID = mysql_insert_id();
+            $iGroupID = db_last_id();
             if( $iGroupID ) {
                 $this->saveGroupForum( $iGroupID, $aGroupInfo, true );

trunk/inc/classes/BxDolInstaller.php

@@ -338 +338 @@
         if($bInstall && !empty($sCategoryName)) {            
             db_res("INSERT IGNORE INTO `sys_localization_categories` SET `Name`='" . $sCategoryName . "'");
-            if(mysql_affected_rows() <= 0 )
+            if(db_affected_rows() <= 0 )
                 $iCategoryId = (int)db_value("SELECT `ID` FROM `sys_localization_categories` WHERE `Name`='" . $sCategoryName . "' LIMIT 1");
             else 
@@ -537 +537 @@
             foreach($aLangContent as $sKey => $sValue) {
                 db_res("INSERT IGNORE INTO `sys_localization_keys`(`IDCategory`, `Key`) VALUES('" . $iCategoryId . "', '" . $sKey . "')");
-                if(mysql_affected_rows() <= 0 ) continue;
+                if(db_affected_rows() <= 0 ) continue;
                 
                 $iLangKeyId = db_last_id();                                                

trunk/inc/classes/BxDolMailBox.php

@@ -623 +623 @@
                db_res($sQuery);
 
-               return mysql_affected_rows();
+               return db_affected_rows();
           }
 
@@ -668 +668 @@
                db_res($sQuery);
 
-               return mysql_affected_rows();
+               return db_affected_rows();
           }
 
@@ -727 +727 @@
                     db_res($sQuery);
 
-                    return mysql_affected_rows();
+                    return db_affected_rows();
                }
           }

trunk/inc/classes/BxDolPFM.php

@@ -1211 +1211 @@
         
         //try to insert new item
-        if( db_res( "INSERT INTO `sys_profile_fields` (`Name`, `Type` ) VALUES ('NEW_ITEM', 'text')", 0 ) and $iNewID = mysql_insert_id() ) {
+        if( db_res( "INSERT INTO `sys_profile_fields` (`Name`, `Type` ) VALUES ('NEW_ITEM', 'text')", 0 ) and $iNewID = db_last_id() ) {
             //if success - try to alter table
             if( !db_res( "ALTER TABLE `Profiles` ADD `NEW_ITEM` varchar(255) NOT NULL default ''", 0 ) ) {
@@ -1225 +1225 @@
     function createNewBlock() {
         db_res( "INSERT INTO `sys_profile_fields` (`Name`, `Type` ) VALUES ('NEW BLOCK', 'block')", 0 );
-        $iNewID = mysql_insert_id();
+        $iNewID = db_last_id();
         
         db_res( "
@@ -1251 +1251 @@
             $sQuery = "INSERT INTO `sys_localization_keys` (`IDCategory`,`Key`) VALUES (32,'$sKey_db')";
             db_res( $sQuery );
-            $iKeyID = mysql_insert_id();
+            $iKeyID = db_last_id();
         }
         

trunk/inc/classes/BxDolPageViewAdmin.php

@@ -137 +137 @@
         db_res($sQuery);
         
-        if (!mysql_affected_rows())
+        if (!db_affected_rows())
             return false;
         
@@ -175 +175 @@
             db_res( $sQuery );
             
-            echo mysql_insert_id();
+            echo db_last_id();
             
             $this -> createCache();

trunk/inc/classes/BxDolProfilesController.php

@@ -224 +224 @@
         db_res($sQuery);
         $this -> createProfileCache( $iMemberID );
-        return (bool)mysql_affected_rows();
+        return (bool)db_affected_rows();
     }
     

trunk/inc/languages.inc.php

@@ -180 +180 @@
     if($langID <= 0) return false;
 
-    $resLangs = mysql_query('
+    $resLangs = db_res('
             SELECT  `ID`, `Name`
             FROM    `sys_localization_languages`
@@ -189 +189 @@
     $arrLang = mysql_fetch_assoc($resLangs);
 
-    $numStrings = mysql_query('
+    $numStrings = db_res('
         SELECT COUNT(`IDKey`)
         FROM `sys_localization_strings`
@@ -196 +196 @@
     $numStrings = $numStrings[0];
 
-    mysql_query('DELETE FROM `sys_localization_strings` WHERE `IDLanguage` = '.$langID);
-
-    if(mysql_affected_rows() < $numStrings) return false;
-
-    mysql_query('DELETE FROM `sys_localization_languages` WHERE `ID` = '.$langID);
-
-    if(mysql_affected_rows() <= 0) return false;
+    db_res('DELETE FROM `sys_localization_strings` WHERE `IDLanguage` = '.$langID);
+
+    if(db_affected_rows() < $numStrings) return false;
+
+    db_res('DELETE FROM `sys_localization_languages` WHERE `ID` = '.$langID);
+
+    if(db_affected_rows() <= 0) return false;
 
     @unlink( BX_DIRECTORY_PATH_ROOT . 'langs/lang-'.$arrLang['Name'].'.php');
@@ -230 +230 @@
     $keyID = (int)$keyID;
 
-    $resParams = mysql_query("
+    $resParams = db_res("
         SELECT  `IDParam`,
                 `Description`
@@ -336 +336 @@
         SET         `IDCategory` = $categoryID,
                     `Key` = '$langKey'", false );
-    if ( !$resInsertKey || mysql_affected_rows() <= 0 )
+    if ( !$resInsertKey || db_affected_rows() <= 0 )
         return false;
 
-    $keyID = mysql_insert_id();
+    $keyID = db_last_id();
 
     while($arrLanguage = mysql_fetch_assoc($resLangs)) {
@@ -347 +347 @@
                         `IDLanguage` = {$arrLanguage['ID']},
                         `String` = '$langString'", false );
-        if ( !$resInsertString || mysql_affected_rows() <= 0 )
+        if ( !$resInsertString || db_affected_rows() <= 0 )
             return false;
     }
@@ -386 +386 @@
             WHERE       `IDKey` = $keyID
             AND         `IDLanguage` = {$arrLanguage['ID']}", false );
-        if ( !$resUpdateString || mysql_affected_rows() <= 0 )
+        if ( !$resUpdateString || db_affected_rows() <= 0 )
             return false;
     }

trunk/inc/membership_levels.inc.php

@@ -695 +695 @@
                     AND (DateExpires IS NULL OR DateExpires > NOW())");
 
-        if(mysql_affected_rows() > 0)
+        if(db_affected_rows() > 0)
         {
             return true;
@@ -762 +762 @@
         VALUES ($memberID, $membershipID, FROM_UNIXTIME($dateStarts), FROM_UNIXTIME($dateExpires), '$transactionID')");
 
-    if(mysql_affected_rows() <= 0) return false;
+    if(db_affected_rows() <= 0) return false;
 
     return true;

trunk/inc/profiles.inc.php

@@ -386 +386 @@
         ";
         db_res($CheckSQL);
-        if (mysql_affected_rows()>0) {
+        if (db_affected_rows()>0) {
             return true;
         }

trunk/inc/utils.inc.php

@@ -578 +578 @@
             $sCheckSQL = "SELECT * FROM `sys_ip_list` WHERE `Type`='deny' AND `LastDT` > NOW()";
             $vIPRes = db_res($sCheckSQL);
-            if (mysql_affected_rows()>0) {
+            if (db_affected_rows()>0) {
                 while ( $aCheckIP = mysql_fetch_assoc($vIPRes) ) {
                     if ($aCheckIP['To']==0 && $aCheckIP['From']==$sCurLongIP) {
@@ -593 +593 @@
             $sCheckSQL = "SELECT * FROM `sys_ip_list` WHERE `Type`='allow' AND `LastDT` > NOW()";
             $vIPRes = db_res($sCheckSQL);
-            if (mysql_affected_rows()>0) {
+            if (db_affected_rows()>0) {
                 while ( $aCheckIP = mysql_fetch_assoc($vIPRes) ) {
                     if ($aCheckIP['To']==0 && $aCheckIP['From']==$sCurLongIP) {

trunk/member.php

@@ -984 +984 @@
                 $sVisitsSQL = "SELECT * FROM `sys_ip_members_visits` WHERE CURRENT_DATE() = DATE(`DateTime`) AND `From`='{$sCurLongIP}' LIMIT 1";
                 db_res($sVisitsSQL);
-                if (mysql_affected_rows()!=1) {
+                if (db_affected_rows()!=1) {
                     $sInsertSQL = "INSERT INTO `sys_ip_members_visits` SET `From`='{$sCurLongIP}', `DateTime`=NOW()";
                     db_res($sInsertSQL);

trunk/modules/boonex/ads/classes/BxAdsModule.php

@@ -397 +397 @@
 
         $vSqlRes = $this->_oDb->getAllCatsInfo();
-        if (mysql_affected_rows()==-1) {
+        if (db_affected_rows()==-1) {
             return $this->GetSQLError("");
         }
@@ -552 +552 @@
 
         $vSqlRes = $this->_oDb->getAllCatsInfo();
-        if (mysql_affected_rows()==-1)
+        if (db_affected_rows()==-1)
             return $this->GetSQLError("");
         $sCatOptions = '';
@@ -1132 +1132 @@
             foreach ( $aChunks as $iMedId ) {
                 $aSqlRes = $this->_oDb->getMediaInfo($iMedId);
-                if (mysql_affected_rows()>0) {
+                if (db_affected_rows()>0) {
                     if (file_exists(BX_DIRECTORY_PATH_ROOT.$this->sUploadDir.'big_thumb_'.$aSqlRes['MediaFile']) == true) {
                         $sFileName = $site['url']. $this->sUploadDir.'big_thumb_'.$aSqlRes['MediaFile'];
@@ -2136 +2136 @@
 
             $sqlResSubs = $this->_oDb->getAllSubCatsInfo($aSqlResStr['ID']);
-            if (mysql_affected_rows()==-1) {
+            if (db_affected_rows()==-1) {
                 return $this->GetSQLError('');
             }
@@ -2330 +2330 @@
         $sClassifiedsOptions = '';
         $vSqlRes = $this->_oDb->getAllCatsInfo();
-        if (mysql_affected_rows()==-1)
+        if (db_affected_rows()==-1)
             return $this->GetSQLError("");
 
@@ -2557 +2557 @@
     function PrintManageClassifiedsForm() {
         $vSqlResCls = $this->_oDb->getAllCatsInfo();
-        if (mysql_affected_rows()==-1)
+        if (db_affected_rows()==-1)
             return $this->GetSQLError("");
 
@@ -2748 +2748 @@
 
         $vSqlResCls = $this->_oDb->getAllCatsInfo();
-        if (mysql_affected_rows()==-1)
+        if (db_affected_rows()==-1)
             return $this->GetSQLError("");
 
@@ -3091 +3091 @@
                 $sUpdateSQL = "UPDATE `ClassifiedsAdvertisements` SET `Media` = '{$sNewMedia}' WHERE `ClassifiedsAdvertisements`.`ID` = {$iEditAdvertisementID} LIMIT 1";
                 db_res( $sUpdateSQL );
-                if (mysql_affected_rows() == 1) {//continue
+                if (db_affected_rows() == 1) {//continue
                     //5. physycally delete file
                     $sMediaFileName = $this->_oDb->getMediaFile($iMediaID);

trunk/modules/boonex/ads/post_mod_ads.php

@@ -116 +116 @@
                     }
                     $sqlRes = InsertC($sName, $sDescription, $sCustomName1, $sCustomName2, $sCustomAction1, $sCustomAction2);
-                    echo (mysql_affected_rows()!=0) ? $sAddMainCatSuccC : $sAddMainCatFailC;
+                    echo (db_affected_rows()!=0) ? $sAddMainCatSuccC : $sAddMainCatFailC;
                     break;
                 case 'AddSubCategory':
@@ -127 +127 @@
                         }
                         $sqlRes = InsertCS($sCategoryID, $sName, $sDescription);
-                        echo (mysql_affected_rows()!=0) ? $sAddSubCatSuccC : $sAddSubCatFailC;
+                        echo (db_affected_rows()!=0) ? $sAddSubCatSuccC : $sAddSubCatFailC;
                     }
                 break;
@@ -135 +135 @@
                         $sSQL = "DELETE FROM `Classifieds` WHERE `ID` = '{$sCategoryID}'";
                         $sqlRes = db_res($sSQL);
-                        echo (mysql_affected_rows()!=0) ? $sDelMainCatSuccC : $sDelMainCatFailC;
+                        echo (db_affected_rows()!=0) ? $sDelMainCatSuccC : $sDelMainCatFailC;
                     }
                 break;
@@ -143 +143 @@
                         $sSQL = "DELETE FROM `ClassifiedsSubs` WHERE `ClassifiedsSubs`.`ID` = {$sCategoryID}";
                         $sqlRes = db_res($sSQL);
-                        echo (mysql_affected_rows()!=0) ? $sDelSubCatSuccC : $sDelSubCatFailC;
+                        echo (db_affected_rows()!=0) ? $sDelSubCatSuccC : $sDelSubCatFailC;
                     }
                 break;

trunk/modules/boonex/blogs/classes/BxBlogsModule.php

@@ -1087 +1087 @@
 
             $vSqlRes = $this->_oDb->performUpdatePostWithPhoto($iPostID);
-            $sRet = (mysql_affected_rows()>0) ? _t($sSuccUpdPost) : _t($sFailUpdPost);
+            $sRet = (db_affected_rows()>0) ? _t($sSuccUpdPost) : _t($sFailUpdPost);
             return MsgBox($sRet);
         } elseif($this->_iVisitorID != $iPostOwnerID) {
@@ -1129 +1129 @@
 
             $vSqlRes = $this->_oDb->deletePost($iPostID);
-            $sRet = (mysql_affected_rows()>0) ? _t('_post_successfully_deleted') : _t('_failed_to_delete_post');
+            $sRet = (db_affected_rows()>0) ? _t('_post_successfully_deleted') : _t('_failed_to_delete_post');
 
             $this->isAllowedPostDelete($iPostOwnerID, true); // perform action

trunk/modules/boonex/shared_photo/classes/BxShPhotoMain.php

@@ -187 +187 @@
                     ";
                 db_res($sqlQuery);
-                if (mysql_affected_rows()) {
+                if (db_affected_rows()) {
                     createUserDataFile($this->iViewer);
                     require_once(BX_DIRECTORY_PATH_CLASSES . 'BxDolAlerts.php');

trunk/periodic/cmd.php

@@ -74 +74 @@
         $res = db_res("DELETE FROM `sys_greetings` WHERE (TO_DAYS(NOW()) - TO_DAYS(`When`)) > $db_clean_vkiss");
         if ( $res )
-            $db_clean_vkiss_num = mysql_affected_rows();
+            $db_clean_vkiss_num = db_affected_rows();
     }
 
@@ -81 +81 @@
         $res = db_res("DELETE FROM `sys_messages` WHERE (TO_DAYS(NOW()) - TO_DAYS(`Date`)) > $db_clean_msg");
         if ( $res )
-            $db_clean_msg_num = mysql_affected_rows();
+            $db_clean_msg_num = db_affected_rows();
     }
 
@@ -88 +88 @@
         $res = db_res("DELETE FROM `sys_profiles_track` WHERE (TO_DAYS(NOW())-TO_DAYS(`When`)) > $db_clean_views");
         if ( $res )
-            $db_clean_views_num = mysql_affected_rows();
+            $db_clean_views_num = db_affected_rows();
     }
     
@@ -98 +98 @@
         $rRes = db_res($sqlQuery);
         if ($rRes)
-            $iDbCleanAlertNum = mysql_affected_rows();
+            $iDbCleanAlertNum = db_affected_rows();
     }
     echo "\n- Database cleaning -\n";