To upgrade , delete old Kroax files, you dont need to touch your uploads folder or if you have another movie folder (do it, the structure have changed alot).
Then go to administration > settings > way down that page hit upgrade yes! then adjust your settings the way you want it.
Everything but ffmpeg will be on by default.


// If you have issues with our admin upgrade service follow this mess instead !


If you are running versions prior to 3.9.

Paste this code in a costumepage in adminstration, give a temp title & then run a preview once and youre done.

<?php
$result = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD roax_set_show VARCHAR( 20 ) NOT NULL AFTER  kroax_set_copy");
?>


If you are running a version prior to 4.20

Paste this code in a costumepage in adminstration, give a temp title & then run a preview once and youre done.


<?php
$result = dbquery("ALTER TABLE ".$db_prefix."kroax CHANGE kroax_spare1 kroax_access VARCHAR(10)");
$result = dbquery("ALTER TABLE ".$db_prefix."kroax_kategori ADD kroax_namn_access VARCHAR(10) NOT NULL AFTER kroax_namn_cat1");
$result = dbquery("UPDATE ".$db_prefix."kroax_kategori SET kroax_namn_access='0' WHERE kroax_namn_access=''");
$result = dbquery("UPDATE ".$db_prefix."kroax SET kroax_access='0' WHERE kroax_access=''");
$result = dbquery("ALTER TABLE ".$db_prefix."kroax ADD kroax_access_cat VARCHAR(10) NOT NULL AFTER kroax_access");
$result = dbquery("UPDATE ".$db_prefix."kroax SET kroax_access_cat='0' WHERE kroax_access_cat=''");
$result = dbquery("SELECT * FROM ".$db_prefix."kroax");
while ($data = dbarray($result)) {
$kroax_cat=$data['kroax_cat'];
$k_access =$data['kroax_access'];
$id=$data['kroax_id'];
$detect = dbquery("SELECT * FROM ".$db_prefix."kroax_kategori WHERE kroax_namn_cat1='$kroax_cat'");
echo $kroax_cat;
while ($detect_access = dbarray($detect)) {
$access = $detect_access['kroax_namn_access'];

echo"[".$id."] New access: ".$access." Old access: ".$k_access."<br>";
$result4 = dbquery("UPDATE ".$db_prefix."kroax SET kroax_access_cat='$access' WHERE kroax_id='$id'");
}
}

$result = dbquery("ALTER TABLE ".$db_prefix."kroax CHANGE kroax_spare2 kroax_spare2 text not null");

?>

If you upgrade to 4.7x from any version you will need to run this in a costume page as a page preview for administration to work properly.

<?php
$result = dbquery("UPDATE ".$db_prefix."admin SET admin_link='../infusions/the_kroax/admin/admin.php' WHERE admin_image='the_kroax.jpg'");
?>

If you upgrade from any version prior to 4.72 you need to run this in a costum page preview.

<?php
$result = dbquery("ALTER TABLE ".$db_prefix."kroax_kategori ADD kroax_cat_img VARCHAR(20) NOT NULL AFTER kroax_namn_access");
$result = dbquery("UPDATE ".$db_prefix."kroax_kategori SET kroax_cat_img='0' WHERE kroax_cat_img=''");
$result = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_thumb VARCHAR(10) NOT NULL AFTER kroax_set_show");
$result = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_thumb='1'");
?>

No database upgrade needed for 5.0

Upgrade for 5.1 

Run this in a costum page preview.

<?php
//Here starts 5.1 changes..
//some propper nameing
$result = dbquery("ALTER TABLE ".$db_prefix."kroax_kategori CHANGE kroax_id_cat cid smallint(5)");
$result = dbquery("ALTER TABLE ".$db_prefix."kroax_kategori CHANGE kroax_namn_cat1 title varchar(40)");
$result = dbquery("ALTER TABLE ".$db_prefix."kroax_kategori CHANGE kroax_namn_access access varchar(10)");
$result = dbquery("ALTER TABLE ".$db_prefix."kroax_kategori CHANGE kroaX_cat_img image varchar(30)");

//So we need to set it right in kroax table too..
$result = dbquery("SELECT * FROM ".$db_prefix."kroax_kategori");
while ($data = dbarray($result)) {
$update = dbquery("UPDATE ".$db_prefix."kroax SET kroax_cat='".$data['cid']."' WHERE kroax_cat='".$data['title']."'");
}
//While we are at it, lets add the support for subcats & a status support on that..
$update2 = dbquery("ALTER TABLE ".$db_prefix."kroax_kategori ADD parentid int(10) NOT NULL AFTER image");
$update3 = dbquery("ALTER TABLE ".$db_prefix."kroax_kategori ADD status int(10) NOT NULL AFTER parentid");
//Lets make all categories available..
$update4 = dbquery("UPDATE ".$db_prefix."kroax_kategori SET status='1'");
//Some propper nameing of kroax tables
$result = dbquery("ALTER TABLE ".$db_prefix."kroax CHANGE kroax_spare3 kroax_lastplayed int(10)");
$result = dbquery("ALTER TABLE ".$db_prefix."kroax CHANGE kroax_date kroax_date int(10)");
$result = dbquery("ALTER TABLE ".$db_prefix."kroax CHANGE kroax_spare2 kroax_embed text");
$result = dbquery("ALTER TABLE ".$db_prefix."kroax CHANGE kroax_spare4 kroax_downloads int(10)");
//We need to fix the dates, sorry this will blow all dates out and put it to current.
$result = dbquery("UPDATE ".$db_prefix."kroax set kroax_date ='".time()."'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_thumbs_per_row  int(10) NOT NULL default '0' AFTER kroax_set_thumb");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_thumbs_per_row='4'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_thumbs_per_page  int(10) NOT NULL default '0' AFTER kroax_set_thumbs_per_row");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_thumbs_per_page='16'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_ffmpeg  int(10) NOT NULL default '0' AFTER kroax_set_thumbs_per_page");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_ffmpeg='0'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_favorites  int(10) NOT NULL default '0' AFTER kroax_set_ffmpeg");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_favorites ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_recommend int(10) NOT NULL default '0' AFTER kroax_set_favorites");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_recommend ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_ratings int(10) NOT NULL default '0' AFTER kroax_set_recommend");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_ratings ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_comments int(10) NOT NULL default '0' AFTER kroax_set_ratings");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_comments ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_keepalive int(10) NOT NULL default '0' AFTER kroax_set_comments");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_keepalive ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_playingnow int(10) NOT NULL default '0' AFTER kroax_set_keepalive");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_playingnow ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_bannerimg VARCHAR(100) NOT NULL default '0' AFTER kroax_set_playingnow");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_bannerimg ='img/logo.gif'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_related int(10) NOT NULL default '0' AFTER kroax_set_bannerimg");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_related ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_report int(10) NOT NULL default '0' AFTER kroax_set_related");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_report ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_allowembed int(10) NOT NULL default '0' AFTER kroax_set_report");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_allowembed ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_allowdownloads int(10) NOT NULL default '0' AFTER kroax_set_allowembed");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_allowdownloads ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_allowplaylist int(10) NOT NULL default '0' AFTER kroax_set_allowdownloads");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_allowplaylist ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_allowuploads int(10) NOT NULL default '0' AFTER kroax_set_allowplaylist");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_allowuploads ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_defaultview int(10) NOT NULL default '0' AFTER kroax_set_allowuploads");
$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_defaultview ='1'");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."kroax_set ADD kroax_set_version varchar(10) NOT NULL default '0' AFTER kroax_set_defaultview");

$result = dbquery("CREATE TABLE ".DB_PREFIX."kroax_favourites (
  `fav_id` int(30) NOT NULL default '0',
  `fav_user` int(30) NOT NULL default '0',
  `fav_date` int(10) NOT NULL default '0'
) TYPE=MyISAM; ");
$result = dbquery("CREATE TABLE ".DB_PREFIX."kroax_active (
 `movie_id` int(10) NOT NULL default '0',
  `title` varchar(50) NOT NULL default '0',
  `icon` varchar(50) NOT NULL default '0',
  `lastactive` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM; ");
$result = dbquery("CREATE TABLE ".DB_PREFIX."kroax_activeusr (
 `movie_id` int(10) NOT NULL default '0',
  `member` int(10) NOT NULL default '0',
  `user_ip` varchar(20) NOT NULL default '0',
  `lastactive` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM; ");

$upgrade = dbquery("UPDATE ".$db_prefix."kroax_set SET kroax_set_version='5.1'");
$upgrade = dbquery("UPDATE ".$db_prefix."infusions SET inf_version='5.1' WHERE inf_title='Kroax'");
//Trying Some ninja hack to fix the admin link issue atleast one person seem to have...
$result = dbquery("UPDATE ".$db_prefix."admin SET admin_link='../infusions/the_kroax/admin/admin.php' WHERE admin_image='../../infusions/the_kroax/img/the_kroax.jpg'");
$result = dbquery("UPDATE ".$db_prefix."admin SET admin_link='../infusions/the_kroax/admin/admin.php' WHERE admin_image='the_kroax.jpg'");

?>