[HELP] CONVERT Phoenix CATALOG to Mercury CATALOG [HELP]

[iBaBBo]

Hello Ragezone,
i have got a really good Catalog for Phoenix.
I want convert the SQLs, furnidata, and so on.
But i dont know how.

I search a person who can do this for me.
Maybe for free oder maybe for 25$ via Paypal or Paysafecard.

You can only contact me on Facebook: https://www.facebook.com/alex.hohoff

Many regards,

[MentaL]

[FatalLulz]

@iBaBBo - Do you use Phoenix 3.11 or GTE? I'll create a script to convert the SQL's over and to generate your furnidata.

[iBaBBo]

@iBaBBo - Do you use Phoenix 3.11 or GTE? I'll create a script to convert the SQL's over and to generate your furnidata.

I use GTE mate

[FatalLulz]

I use GTE mate

I was eating dinner. Catalog Items and furniture converting are done as well furnidata. Working on catalog_pages. I'll edit this post soon.

You will need to use Spot Ify's tool to edit your swfs to add the graphics tag as I won't do that for you.

Open notepad++ and do as I say !
Copy and paste this in a file and call it itemgte.php and make sure to save it as a .php and in your main directory (wwwroot or htdocs)

Spoiler:

<?php
/*  */



$host = "localhost"; 
$user = "root";       
$password = "password";      
$database = "gteftw";       
set_time_limit(10000);  

mysql_connect($host, $user, $password) or die(mysql_error());   
mysql_select_db($database) or die(mysql_error());                  

$sql = 'SELECT * FROM `catalog_items` ORDER BY `catalog_items` . `id` ASC'; 
$catalog_items = mysql_query("$sql") or die(mysql_error());                              
echo "INSERT INTO `catalog_items`(`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_loyalty`, `cost_duckets`, `amounts`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `club_only` `extradata`, `badge`) VALUES ";      
while ($output = mysql_fetch_array($catalog_items)){                                          
?>
(
'<?php echo "$output[id]"; ?>',
'<?php echo "$output[page_id]"; ?>',
'<?php echo "$output[item_ids]"; ?>',
'<?php echo "$output[catalog_name]"; ?>',
'<?php echo "$output[cost_credits]"; ?>',
'<?php echo "$output[cost_snow]"; ?>',
'0',
'<?php echo "$output[cost_pixels]"; ?>',
'<?php echo "$output[amount]"; ?>',
'0',
'0',
'0',
'0',
'0',
'0',
'',
''),<br />
<?php
}
?>
<br />
<br />
<br />
<?php
echo "Done";

?>

Do the same again but save this as furnigte.php

Spoiler:

<?php
/* GTE To Mercury Catalogue Scripts - Ask FatalLulz for more! */

$host = "localhost";  
$user = "root";    
$password = "password";     
$database = "gteftw";    

mysql_connect($host, $user, $password) or die(mysql_error());   
mysql_select_db($database) or die(mysql_error());                

$sql = 'SELECT * FROM `furniture` ORDER BY `id` ASC';
$furni = mysql_query("$sql") or die(mysql_error()); 
echo "INSERT INTO `furniture`(`id`, `flat_id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `stack_multiplier`, `subscriber`, `effectid`) VALUES "; 
while ($output = mysql_fetch_array($furni)){ 
$name = mysql_real_escape_string("$output[public_name]");
?>
('<?php echo "$output[id]"; ?>',
'-1',
'<?php echo $name; ?>',
'<?php echo "$output[item_name]"; ?>',
'<?php echo "$output[type]"; ?>',
'<?php echo "$output[width]"; ?>',
'<?php echo "$output[length]"; ?>',
'<?php if 
("$output[stack_height]" == 1)
{
echo"1.00";
}
elseif ("$output[stack_height]" == 2)
{
echo"2.00";
}
elseif ("$output[stack_height]" == 3)
{
echo"3.00";
}
elseif ("$output[stack_height]" == 4)
{
echo"4.00";
}
elseif ("$output[stack_height]" == 5)
{
echo"5.00";
}
elseif ("$output[stack_height]" == 6)
{
echo"6.00";
}
elseif ("$output[stack_height]" == 0)
{
echo"0.00";
}
else
{
echo "$output[stack_height]";
}
?>',
'<?php echo "$output[can_stack]"; ?>',
'<?php echo "$output[can_sit]"; ?>',
'<?php echo "$output[is_walkable]"; ?>',
'<?php echo "$output[sprite_id]"; ?>',
'<?php echo "$output[allow_recycle]"; ?>',
'<?php echo "$output[allow_trade]"; ?>',
'<?php echo "$output[allow_marketplace_sell]"; ?>',
'<?php echo "$output[allow_gift]"; ?>',
'<?php echo "$output[allow_inventory_stack]"; ?>',
'<?php echo "$output[interaction_type]"; ?>',
'<?php echo "$output[interaction_modes_count]"; ?>',
'<?php echo "$output[vending_ids]"; ?>',
'',
'0',
'<?php echo"$output[effectid]"; ?>'),
<br />
<?php
}
?>

Do the same again and save this as cpgte.php

Spoiler:

<?php
/* GTE To Mercury Catalogue Scripts - Ask FatalLulz for more!  */



$host = "localhost"; 
$user = "root";       
$password = "password";      
$database = "gteftw";       
set_time_limit(10000);  

mysql_connect($host, $user, $password) or die(mysql_error());   
mysql_select_db($database) or die(mysql_error());                  

$sql = 'SELECT * FROM `catalog_pages` ORDER BY `catalog_pages` . `id` ASC'; 
$catalog_items = mysql_query("$sql") or die(mysql_error());                              
echo "INSERT INTO `catalog_pages`(`id`, `parent_id`, `code_name`, `caption`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`, `vip_only`, `page_link_description`, page_link_pagename`) VALUES ";      
while ($output = mysql_fetch_array($catalog_items)){                                          
?>
(
'<?php echo "$output[id]"; ?>',
'<?php echo "$output[parent_id]"; ?>',
'<?php echo "$output[caption]"; ?>',
'<?php echo "$output[caption]"; ?>',
'<?php echo "$output[icon_image]"; ?>',
'<?php echo "$output[visible]"; ?>',
'<?php echo "$output[enabled]"; ?>',
'<?php echo "$output[min_rank]"; ?>',
'<?php echo "$output[club_only]"; ?>',
'<?php echo "$output[order_num]"; ?>',
'<?php echo "$output[page_layout]"; ?>',
'<?php echo "$output[page_headline]"; ?>',
'<?php echo "$output[page_teaser]"; ?>',
'<?php echo "$output[page_special]"; ?>',
'<?php echo "$output[page_text1]"; ?>',
'<?php echo "$output[page_text2]"; ?>',
'<?php echo "$output[page_text_details]"; ?>',
'<?php echo "$output[page_text_teaser]"; ?>',
'<?php echo "$output[vip_only]"; ?>',
'<?php echo "$output[page_link_description]"; ?>',
'<?php echo "$output[page_link_pagename]"; ?>'),<br />
<?php
}
?>

Now do the same again and save this as furni2.php

Spoiler:

<?php

$host = "localhost";
$user = "root";
$password = "password";
$database = "rushhotel";   

mysql_connect($host, $user, $password) or die(mysql_error());   
mysql_select_db($database) or die(mysql_error()); 

header("Content-type: text/xml"); 
?>
<?xml version="1.0" encoding="UTF-8"?><furnidata><roomitemtypes>
<?php
$fpconvert1 = mysql_query("SELECT * FROM furniture");
$fpconvert2 = mysql_query("SELECT * FROM catalog_items");
while($fpconvert3 = mysql_fetch_assoc($fpconvert2))
while($fpconvert = mysql_fetch_assoc($fpconvert1)){ 
if($fpconvert['type'] == 's'){ ?>
<furnitype id="<?php echo $fpconvert['sprite_id']; ?>" classname="<?php echo $fpconvert['item_name']; ?>">
<revision>0</revision>
<defaultdir>0</defaultdir>
<xdim>1</xdim>
<ydim>1</ydim>
<partcolors>
<color>0</color>
<color>0</color>
<color>0</color>
</partcolors>
<name><?php echo $fpconvert['public_name']; ?></name>
<description><?php echo $fpconvert['description']; ?></description>
<adurl></adurl>
<offerid>-1</offerid>
<buyout>1</buyout>
<rentofferid>-1</rentofferid>
<rentbuyout>0</rentbuyout>
<bc>1</bc>
<customparams/>
<specialtype><?php echo $fpconvert['specialtype']; ?></specialtype>
<canstandon><?php echo $fpconvert['can_stack']; ?></canstandon>
<cansiton><?php echo $fpconvert['can_sit']; ?></cansiton>
<canlayon><?php echo $fpconvert['canlayon']; ?></canlayon>
</furnitype>
<?php } } echo "</roomitemtypes><wallitemtypes>"; ?>
<?php
$fpconvert2 = mysql_query("SELECT * FROM furniture WHERE item_name NOT LIKE 'a2 t' and item_name NOT LIKE 'a2 l' and item_name NOT LIKE 'wallpaper 1' and item_name NOT LIKE 'landscape 10'");
while($fpconvert1 = mysql_fetch_assoc($fpconvert2)){ 
if($fpconvert1['type'] == 'i'){ ?>
<furnitype id="<?php echo $fpconvert1['sprite_id']; ?>" classname="<?php echo $fpconvert1['item_name']; ?>">
<revision>0</revision>
<name><?php echo $fpconvert1['public_name']; ?></name>
<description><?php echo $fpconvert1['description']; ?></description>
<adurl></adurl>
<offerid>-1</offerid>
<buyout>1</buyout>
<rentofferid>-1</rentofferid>
<rentbuyout>0</rentbuyout>
<bc>1</bc>
<specialtype><?php echo $fpconvert1['specialtype']; ?></specialtype>
</furnitype>
<?php } } echo "</wallitemtypes></furnidata>"; ?>

Now how to use ! First off open the PHP files and make sure you edit the database information at the top ! then simply go to http://url/filename.php so http://url/cpgte.php or http://url/furni2.php etc etc. Copy and paste the SQL's, make sure you remove the last , and replace it for ; it shall work fine. Don't forget to replace your furnidata with the one it will generate when going to /furni2.php replace your furnidata.xml with that. Will work fine. Tested myself.

[iBaBBo]

I was eating dinner. Catalog Items and furniture converting are done as well furnidata. Working on catalog_pages. I'll edit this post soon.

You will need to use Spot Ify's tool to edit your swfs to add the graphics tag as I won't do that for you.

Thanks a lot, where can i download this tool?
I am so grateful to you :-)

[FatalLulz]

Thanks a lot, where can i download this tool?
I am so grateful to you :-)

He released it here so just search for it.

[MrEpic123]

Can you please make the same thing for phoenix -> azure