Changeset 2180662
- Timestamp:
- 10/26/2019 02:49:09 PM (6 years ago)
- File:
-
- 1 edited
-
vampire-character/trunk/inc/install.php (modified) (12 diffs)
Legend:
- Unmodified
- Added
- Removed
-
vampire-character/trunk/inc/install.php
r2056046 r2180662 1219 1219 // Only read in data if the target table is clear 1220 1220 $sql = "select ID from " . VTM_TABLE_PREFIX . $tablename; 1221 $rows = count($wpdb->get_results($sql));1221 $rows = vtm_count($wpdb->get_results($sql)); 1222 1222 if (!$rows) { 1223 1223 $filehandle = fopen($datafile,"r"); … … 1360 1360 foreach ($data as $key => $entry) { 1361 1361 $sql = "select VALUE from " . VTM_TABLE_PREFIX . "ST_LINK where VALUE = %s;"; 1362 $exists = count($wpdb->get_results($wpdb->prepare($sql,$key)));1362 $exists = vtm_count($wpdb->get_results($wpdb->prepare($sql,$key))); 1363 1363 if (!$exists) 1364 1364 $rowsadded = $wpdb->insert( VTM_TABLE_PREFIX . "ST_LINK", $entry); … … 1487 1487 $sql = "SHOW TABLES LIKE '" . $prefix . $table . "'"; 1488 1488 $result = $wpdb->get_results($sql); 1489 $tableExists = count($result) > 0;1489 $tableExists = vtm_count($result) > 0; 1490 1490 1491 1491 //echo "<p>Table $table exists: $tableExists ($sql)</p>"; … … 1558 1558 $sql = $wpdb->prepare($sql, $oldprefix . "%"); 1559 1559 $result = $wpdb->get_col($sql); 1560 if ( count($result) > 0) {1560 if (vtm_count($result) > 0) { 1561 1561 foreach ($result as $table) { 1562 1562 $newtable = str_replace($oldprefix, VTM_TABLE_PREFIX, $table); … … 1567 1567 //echo "<p>SQL: $sql</p>"; 1568 1568 1569 if ( count($result) == 0) {1569 if (vtm_count($result) == 0) { 1570 1570 $sql = "RENAME TABLE $table TO $newtable"; 1571 1571 $result = $wpdb->query($sql); … … 1598 1598 $result = $wpdb->get_col($sql); 1599 1599 //print_r($result); 1600 if ( count($result) > 0) {1600 if (vtm_count($result) > 0) { 1601 1601 foreach ($result as $characterID) { 1602 1602 $wpdb->update(VTM_TABLE_PREFIX . "CHARACTER", … … 1613 1613 //echo "<li>SQL: $sql</li>"; 1614 1614 //print_r($result); 1615 if ( count($result) > 0) {1615 if (vtm_count($result) > 0) { 1616 1616 foreach ($result as $clanID) { 1617 1617 $wpdb->update(VTM_TABLE_PREFIX . "CLAN", … … 1635 1635 //echo "<p>SQL: $sql</p>"; 1636 1636 $result = $wpdb->get_results($sql); 1637 if ( count($result) > 0) {1637 if (vtm_count($result) > 0) { 1638 1638 foreach ($result as $row) { 1639 1639 $userdata = get_user_by( 'login', $row->WORDPRESS_ID ); … … 1710 1710 $result = $wpdb->get_col($sql); 1711 1711 //print_r($result); 1712 if ( count($result) > 0) {1712 if (vtm_count($result) > 0) { 1713 1713 foreach ($result as $roadid) { 1714 1714 $wpdb->update(VTM_TABLE_PREFIX . "ROAD_OR_PATH", … … 1745 1745 //print_r($result); 1746 1746 //echo "<li>Updating...</li>"; 1747 if ( count($result) > 0) {1747 if (vtm_count($result) > 0) { 1748 1748 foreach ($result as $row) { 1749 1749 $grp = sanitize_key($row->GROUPING); … … 1930 1930 1931 1931 // Display what database updates were made by dbDelta 1932 if (empty($error) && count($for_update) > 0 ) {1932 if (empty($error) && vtm_count($for_update) > 0 ) { 1933 1933 $erroutput = ""; 1934 1934 foreach ($for_update as $update) { … … 2109 2109 fputcsv($file, $headings); 2110 2110 // output contents 2111 if ( count($contents) > 0) {2111 if (vtm_count($contents) > 0) { 2112 2112 foreach ($contents as $data) { 2113 2113 foreach ($headings as $heading) {
Note: See TracChangeset
for help on using the changeset viewer.