vb.org Archive - Help with Karma -> Reputation PHP Script Please

Well, the header pretty much says it all.

We've been using vBulletin 2.3.7 for the past couple of years, and wish to upgrade to v3.5 within the next couple weeks. It's been my job to prepare for the conversion, and I need a bit of help. We've been using the Karma hack for vb 2.x, and when upgrading I'd like to transfer this all over to the new vb reputation system.

The script I've written works, but exits after about half of the records have been transferred (there's 36,931 total records in Karma, and only 17,987 in Reputation when it times out).

Anyway, here's the code I'm using... forgive my kludgy code... this is the first time I've even attempted to write any PHP/MySQL code.

Code:

<?php

$dbhost = 'localhost';

$dbuser = 'root';

$dbpass = '<password>';



$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');



$dbname = 'forums';

mysql_select_db($dbname);



$query  = "SELECT karmaid, postid, userid, whoadded, karmapos, karmaneg, reason, timestamp FROM karma";

$result = mysql_query($query);



while($row = mysql_fetch_array($result, MYSQL_ASSOC))

{



        mysql_select_db($dbname);

        $postid = $row['postid'];

        $userid = $row['userid'];

        $reputation = ($row['karmapos'] - $row['karmaneg']);

        $whoadded = $row['whoadded'];

        $reason = $row['reason'];

        $dateline = $row['timestamp'];

        $query2 = "INSERT INTO reputation (postid, userid, reputation, whoadded, reason, dateline) VALUES ('$postid', '$userid', '$reputation', '$whoadded', '$reason', '$dateline')".

        mysql_query($query2) or die ('Error with this insert');



} 





mysql_close($conn);

?>

I get this error in the httpd.log when I run this script: PHP Notice: Undefined variable: query2 in /Users/david/Sites/karma.php on line 27, but the script still seems to run okay.

What I'd like to know is if there is something I'm doing wrong that is causing the script to end before it's supposed to?

I checked over my PHP (4.3.11) settings, and set_time_limit is set at 30 seconds, and PHP's memory is set at 8MB. Do I need to set any of these to a different value? I tried to do it via a php.ini file, but it didn't seem to make a difference (the values are still the same).

I'd appreciate any help I could get... I hate it when I'm almost there, yet have some little problem that keeps me from getting across that final step.

Thanks.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01616 seconds Memory Usage 1,709KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (1)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
Messages: