Index: trunk/kernel/include/item.php =================================================================== diff -u -r341 -r389 --- trunk/kernel/include/item.php (.../item.php) (revision 341) +++ trunk/kernel/include/item.php (.../item.php) (revision 389) @@ -779,14 +779,16 @@ $db =& $this->adodbConnection; $sql = sprintf('SELECT * FROM %s WHERE CategoryId = %s AND ItemResourceId = %s', $SourceTable, $CatId, $this->Get("ResourceId")); $rs = $db->Execute($sql); - if($rs->RecordCount() == 0 ) - { - $sql = "INSERT INTO $SourceTable (CategoryId,ItemResourceId, PrimaryCat) VALUES ('$CatId','".$this->Get("ResourceId")."',$Primary)"; - if($this->debuglevel) - echo $sql."
\n"; - $this->adodbConnection->Execute($sql); - } - + + if (is_object($rs)) { + if($rs->RecordCount() == 0 ) + { + $sql = "INSERT INTO $SourceTable (CategoryId,ItemResourceId, PrimaryCat) VALUES ('$CatId','".$this->Get("ResourceId")."',$Primary)"; + if($this->debuglevel) + echo $sql."
\n"; + $this->adodbConnection->Execute($sql); + } + } $c = $objCatList->GetCategory($CatId); } Index: trunk/globals.php =================================================================== diff -u -r385 -r389 --- trunk/globals.php (.../globals.php) (revision 385) +++ trunk/globals.php (.../globals.php) (revision 389) @@ -140,6 +140,30 @@ return $val; } +function IsTablePresent($ado, $tables) +{ + $ado = GetADODBConnection(); + + $t = explode(",",$tables); + + $i = $ado->MetaTables(); + for($x=0;$xVGhpcyBzZWN0aW9uIGFsbG93cyB5b3UgdG8gbWFuYWdlIGNhdGVnb3JpZXMgYW5kIGl0ZW1zIGFjcm9zcyBhbGwgY2F0ZWdvcmllcw== RWRpdG9yJ3MgUGljayBMaW5rcw== RWRpdG9yJ3MgUGljayBBcnRpY2xlcw== +RW1haWwgTG9n +RnJvbQ== +U2VudCBUbw== +RXZlbnQ= +U2VudCBPbg== +U2VydmVyIEluZm9ybWF0aW9u +VGhpcyBzZWN0aW9uIGFsbG93cyB0byB2aWV3IFBIUCBjb25maWd1cmF0aW9u +VGhpcyBzZWN0aW9uIHNob3dzIGFsbCBlLW1haWxzIHNlbnQgYnkgSW4tUG9ydGFs +VGhpcyBzZWN0aW9uIGFsbG93cyB0byBwZXJmb3JtIGRhdGEgaW1wb3J0IGZyb20gb3RoZXIgc3lzdGVtcw== +RGF0YWJhc2UgU2V0dGluZ3M= +U2VydmVyIFR5cGU= +U2VydmVyIEhvc3RuYW1l +U2VydmVyIERhdGFiYXNl +RGF0YWJzZSBVc2VyIE5hbWU= +U2VydmVyIFBhc3N3b3Jk +VGFibGUgTmFtZSBQcmVmaXg= WC1Qcmlvcml0eTogMQ0KWC1NU01haWwtUHJpb3JpdHk6IEhpZ2gNClgtTWFpbGVyOiBJbi1Qb3J0YWwKU3ViamVjdDogSW4tcG9ydGFsIHJlZ2lzdHJhdGlvbgoKRGVhciA8aW5wOnRvdXNlciBfRmllbGQ9IkZpcnN0TmFtZSIgLz4gPGlucDp0b3VzZXIgX0ZpZWxkPSJMYXN0TmFtZSIgLz4sDQoNClRoYW5rIHlvdSBmb3IgcmVnaXN0ZXJpbmcgb24gPGlucDptX3BhZ2VfdGl0bGUgLz4uIFlvdXIgcmVnaXN0cmF0aW9uIGlzIG5vdyBhY3RpdmUu WC1Qcmlvcml0eTogMQ0KWC1NU01haWwtUHJpb3JpdHk6IEhpZ2gNClgtTWFpbGVyOiBJbi1Qb3J0YWwKU3ViamVjdDogTmV3IHVzZXIgaGFzIGJlZW4gYWRkZWQKCkEgbmV3IHVzZXIgIjxpbnA6dG91c2VyIF9GaWVsZD0iVXNlck5hbWUiIC8+IiBoYXMgYmVlbiBhZGRlZC4= WC1Qcmlvcml0eTogMQ0KWC1NU01haWwtUHJpb3JpdHk6IEhpZ2gNClgtTWFpbGVyOiBJbi1Qb3J0YWwKU3ViamVjdDogWW91IGhhdmUgYmVlbiBhcHByb3ZlZAoKV2VsY29tZSB0byBJbi1wb3J0YWwhDQpZb3VyIHVzZXIgcmVnaXN0cmF0aW9uIGhhcyBiZWVuIGFwcHJvdmVkLiBZb3VyIHVzZXIgbmFtZSBpcyAiPGlucDp0b3VzZXIgX0ZpZWxkPSJVc2VyTmFtZSIgLz4iLg==