<?php

//########CONFIGS#########
$account = 'realms'; //DATABASE WHERE ACCOUNTS ARE STORED
$host = 'localhost'; //HOST NOT WEBHOST
$user = 'root'; //USER OF THAT HOST
$pass = 'ascent'; //PASS OF THAT HOST
$webwow = 'webwow'; // DATABASE WHERE THE NEW VOTE SYSTEM IS LOCATED
$vote = 'cruelwow_account'; //DATABASE OF OLD VOTE SYSTEM
//("SELECT vp FROM accounts_more WHERE acc_login = 'ADMIN2'", $conn)or die('Error in query select'.mysql_query());;
//$vbwebwowrow = @mysql_fetch_assoc($vpwebwow);
$conn = mysql_connect($host,$user,$pass);
mysql_select_db($account);
$result=mysql_query("SELECT * FROM ".$account.".account", $conn);
$row = mysql_fetch_assoc($result);
$id = 0;

do{

$id = ($id+1);
$result=mysql_query("SELECT * FROM ".$account.".account WHERE id = '$id'", $conn) or die ('Error in query account'.mysql_query()) ;
$row = mysql_fetch_assoc($result);
$name = $row['username'];

mysql_select_db($webwow);

$vpwebwow = mysql_query("SELECT * FROM ".$webwow.".accounts_more WHERE acc_login = '$name'", $conn) or die ('Error in query oldvp'.mysql_error());
$arrww = mysql_fetch_row($vpwebwow);
$results2ww = $arrww[2];

$checkaccid = mysql_query("SELECT * FROM ".$account.".account WHERE username = '$name'", $conn) or die ('Error in checking acc id'.mysql_error());
$arrcheck= mysql_fetch_row($checkaccid);
$results2check = $arrcheck[0];

$checkaccidww= mysql_query("SELECT * FROM ".$webwow.".accounts_more WHERE acc_login = '$name'", $conn) or die ('Error in checking acc id'.mysql_error());
$arrcheckww= mysql_fetch_row($checkaccidww);
$results2checkww = $arrcheckww[1];


$output.= '<br/><br/> Account id: '.$id;
$output.= '<br/><br/> Account name: '.$name;
$output.= '<br/>New Voting Points : '.$results2ww;

// als er geen acc_login is
if (!$results2checkww && (isset($results2check)))
{
$insert = mysql_query("INSERT INTO ".$webwow.".accounts_more (acc_login, vp, question_id, answer, dp) VALUES ('$name', '0', '0','nothing', '0')") or die ('Error in query inserting new acc'.mysql_error());
$output.= '<br/> Created new webwow account: '.$name;
}

if (!$results2check)
{
$output.= '<br/> Id does not exist';
}


if(!$vbwebwow && isset($results2check))
{

$vpwebwow2 = mysql_query("SELECT * FROM ".$webwow.".accounts_more WHERE acc_login = '$name'", $conn) or die ('Error in query oldvp'.mysql_error());
$arrww2 = mysql_fetch_row($vpwebwow2);
$results2ww2 = $arrww2[2];

$checkaccidww= mysql_query("SELECT * FROM ".$webwow.".accounts_more WHERE acc_login = '$name'", $conn) or die ('Error in checking acc id'.mysql_error());
$arrcheckww= mysql_fetch_row($checkaccidww);
$results2checkww = $arrcheckww[0];
}






mysql_select_db($vote);
$oquery = mysql_query("SELECT * FROM ".$vote.".voting_points WHERE id = '$id'", $conn)or die('Error in query oldvp'.mysql_query());
$arrovp = mysql_fetch_row($oquery);
$oldvp = $arrovp[1];

$output.= '<br/>Old Voting Points : '.$oldvp;
$newvp = ($results2ww + $oldvp);
$output.= '<br/>Newest Voting Points : '.$newvp;


mysql_select_db($webwow);
$ok = @mysql_query("UPDATE ".$webwow.".accounts_more SET vp = '$newvp' WHERE acc_login = '$name'", $conn) or die('Error in query update'.mysql_query());

//$ok = mysql_query("update webwow.accounts_more (vp) WHERE 'acc_login' = $name SELECT vp FROM voting_points.test WHERE id = $id") or die('Error in query'.mysql_query());
if(!$ok && ($vpwebwowrow['vp'] >= 0) && ($oldvp >= 0) )
{
$output.= '<br/>Error';
}
else
{
$output.='<br/>Succes';
}
}while($id != 200);
echo $output;
sleep(5);
$output = "";
echo $output;
echo'<meta http-equiv="refresh" content="600">';
echo '<br>Transferring Vote points COMPLETE!';
?>