vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Some More Help with PHP & mySQL (https://vborg.vbsupport.ru/showthread.php?t=66638)

Dan 06-28-2004 03:34 PM
Some More Help with PHP & mySQL
 
Ok trafix kindly helped me by providing me with this script which he thought would work. I also think it should work and tried fooling around with it and changing things to try and make it work.

I added a bunch of avatars to one of my forums and it named a lot of the with the beginning of the file name like Ff Avatars and so forth as I had them all named a certain way. So I have this script which I thought would work to remove those First characters in the title of the avatar but It doesn't. It renames everything in the range to le). So any help would be nice.

Here is the script.

PHP Code:
<?php
// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// ##################### DEFINE IMPORTANT CONSTANTS #######################
define('CVS_REVISION', '$RCSfile: avatarrenamer.php,v $ - $Revision: 1.81 $');
define('NO_REGISTER_GLOBALS', 1);
// ########################## REQUIRE BACK-END ############################
require_once('./global.php');

// ########################################################################
// ######################### START MAIN SCRIPT ############################
// ########################################################################
print_cp_header($vbphrase['avatarz']);
if (empty($_REQUEST['do']))
{
    $_REQUEST['do'] = 'modtable';
}
// ###################### Start avatar renaming #######################
if ($_REQUEST['do'] == 'modtable')
{
$min = 83; // set this to the number of the first db row that you want to change
$max = 90; // set this to the number of the last db row that you want to change
    
    for ($x = $min; $x <= $max; $x++)
    {
        
        $avname=$DB_site->query_first(" 
        SELECT * 
        FROM " . TABLE_PREFIX . "avatar 
        WHERE avatarid=$x ");
        
        $newavname = substr("$avname(title)", 9);
        
        $DB_site->query("
                UPDATE " . TABLE_PREFIX . "avatar 
                SET title = '" . addslashes($newavname) . "'
                    WHERE avatarid=$x
                ");
        
        echo"$avname(title) * $newavname<br>";          
    }
    echo"DONE!";
}
?>

NTLDR 06-28-2004 04:51 PM
This should remove the Ff prefix for all avatars:

PHP Code:
<?php
error_reporting(E_ALL & ~E_NOTICE);

define('NO_REGISTER_GLOBALS', 1);

require_once('./global.php');

$avs = $DB_site->query(" 
    SELECT * 
    FROM ".TABLE_PREFIX."avatar 
    WHERE title like 'Ff%' 
");

while($av = $DB_site->fetch_array($avs))
{
    $newavname = substr($av['title'], 2);
        
    $DB_site->query("
        UPDATE ".TABLE_PREFIX."avatar 
        SET title = '".addslashes($newavname)."'
        WHERE avatarid = $av[avatarid]
    ");
}

echo 'DONE';

?>


All times are GMT. The time now is 11:48 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01687 seconds
  • Memory Usage 1,733KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete