i want to buy script But?

[medyaoyun]

hi there

i m curently using your free version. i want to buy eSyndiCat Pro One (1) Domain license.

but i wonder if i buy, should i transfer all cat and link database. or will i get some patch for upgrading to paid version.

thanks

[Sergey Ten]

Hello medyaoyun,

I could converting your database from free to pro version of the eSyndiCat. Send me your dump and I will try converting as soon as possible.

sten@esyndicat.com

[medyaoyun]

can you also provide me installation help please. i get some mail subjected "bug"

and error is bellow

SELECT * FROM `dir_categories` WHERE `id` = '51'<br />Duplicate entry '12' for key 1

when i tried to submit a link i get "Unknown column 'ip_address' in 'field list'" error mesagge

[Sai_dallas]

search for my posts, in one them I posted the file content.


Thanks

[medyaoyun]

search for my posts, in one them I posted the file content.


Thanks

i have found it but i get error page when i run the convert_flat.php
i got "Internal Server Error"

what am i doing wrong?
please check http://www.freightlist.net/convert_flat.php
thanks for help<?php
require_once('includes/config.inc.php');
require_once('classes/DirDb.php');

$db = new Database();

$db->mDbhost = $gDirConfig['localhost'];
$db->mDbname = $gDirConfig['name'];
$db->mDbuser = $gDirConfig['myusername'];
$db->mDbpwd = $gDirConfig['mypass'];
$db->connect();

// Get categories
$sql = "SELECT `id`,`id_parent` FROM `{$gDirConfig['prefix']}categories` WHERE `id_parent` > -1";
$cats =& $db->getAll($sql);

if ($cats)
{
foreach ($cats as $key => $value)
{
$sql = "INSERT INTO `{$gDirConfig['prefix']}flat_structure` (`id_parent`,`id_category`)";
$sql .= "VALUES ({$value['id']}, {$value['id']})";
$db->query($sql);
add_flat($value['id'], $value['id_parent']);
}
}

function add_flat($id, $id_parent)
{
global $db;
global $gDirConfig;

// Insert record into "flat" table
$sql = "INSERT INTO `{$gDirConfig['prefix']}flat_structure` (`id_parent`,`id_category`)";
$sql .= "VALUES ({$id_parent},{$id})";
$db->query($sql);

// Check if parent > 0 and call itself recursively
if ($id_parent > 0)
{
// Get parent's parent
$sql = "SELECT `id_parent` FROM `dir_categories` WHERE `id` = {$id_parent}";
$id_parent2 = $db->getOne($sql);
add_flat($id, $id_parent2);
}
}
?>

this is the php that i used.
thanks

[medyaoyun]

Hello medyaoyun,

I could converting your database from free to pro version of the eSyndiCat. Send me your dump and I will try converting as soon as possible.

sten@esyndicat.com

Sergey could you find time to look at my dump. i have send it to you.

also i cant add link to my directory i got this error Unknown column 'ip_address' in 'field list' "

can you help me please

[Sergey Ten]

Hello medyaoyun,

Yes, sure I could investigate your dump, please send me it. And could you please email me your FTP and Cpanel (phpMyAdmin) credentials.

sten@esyndicat.com

[medyaoyun]

Hello medyaoyun,

Yes, sure I could investigate your dump, please send me it. And could you please email me your FTP and Cpanel (phpMyAdmin) credentials.

sten@esyndicat.com

thanks sergey i have fixed it. and i get my converted dump. great support thak you verymuch
murat

[Sergey Ten]

Murat,

You are welcome.

If you will have some questions please let me know.