Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 10-25-2005, 03:53 AM
addict addict is offline
 
Join Date: Jan 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03378 seconds
  • Memory Usage 2,155KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete