just thinking :) really don't know how you cannot load JFactory class in the index.php....if you want just pass me the 2 tables (jos_k2_tags_xref and jos_k2_items) and i will do it in 3 hour cause i'm out now....otherwise really don't know sorry :( i repeat, the code is right for me...works perfect...

Fatal error: Class 'JFactory' not found in /home/promo/public_html/myweb.com/index.php on line 13



Andrea Vigato said:
<?php $db =& JFactory::getDBO(); $first_query = "SELECT id FROM jos_k2_items WHERE catid=8";
$db->setQuery($first_query);
$db->query();

$counter = $db->getNumRows();
$column= $db->loadResultArray();

$start_id = 44;

for($i==0; $i<=$counter; $i++) {
$second_query = "INSERT INTO jos_k2_tags_xref VALUES ($start_id, 40, $column[$i])";
$db->setQuery($second_query);
$db->query();

$start_id++;
}
?>

 

try this new code, goes perfectly to me...

<?php $db =& JFactory::getDBO();
$first_query = "SELECT id FROM jos_k2_items WHERE catid=8";
$db->setQuery($first_query);
$db->query();

$counter = $db->getNumRows();
$column= $db->loadResultArray();

$start_id = 44;

for($i==0; $i<=$counter; $i++) {
$second_query = "INSERT INTO jos_k2_tags_xref VALUES ($start_id, 40, $column[$i])";
$db->setQuery($second_query);
$db->query();

$start_id++;
}
?>

 

try this new code, goes perfectly to me...

they give me a blank page

Andrea Vigato said:
the index.php that is first loaded when you reach your website, so i think the index.php of the template.

 

You have your joomla files with administrator, components, modules, templates no? In your templates dir enter your default template folder (rhuk_milkyway, atomic or whatever is) and you will see an index.php (default joomla load this one for first page).

 

Edit the index, after the "defined('_JEXEC') or die ..." put the code i gave you (like in the code_index.png screenshot), then just load it in browser.

 

If it's all correct you will see in phpmyadmin, in your DB, in the jos_k2_tags_xref that has been inserted a lot of new field.

After that just remove the code from the index and it's ok, all of your item in category now have the related tag.

the index.php that is first loaded when you reach your website, so i think the index.php of the template.

 

You have your joomla files with administrator, components, modules, templates no? In your templates dir enter your default template folder (rhuk_milkyway, atomic or whatever is) and you will see an index.php (default joomla load this one for first page).

 

Edit the index, after the "defined('_JEXEC') or die ..." put the code i gave you (like in the code_index.png screenshot), then just load it in browser.

 

If it's all correct you will see in phpmyadmin, in your DB, in the jos_k2_tags_xref that has been inserted a lot of new field.

After that just remove the code from the index and it's ok, all of your item in category now have the related tag.

Hey guys,

 

Currently purchased K2mart and plan on using it for a client's virtuemart store. Just trying to figure out if there's a way I can get her image gallery to work the way she needs it to.

 

Product Flypage

you have the main image box, and below that -- thumbs of other images. clicking the the thumbs loads them into the main image box. Then to futher complicate things, when hovering over the main image box, it shows a zoom window.

 

I already got the image to zoom on hover using CLOUD ZOOM jquery and adding the tags to the item.php. Unfortunately, this kills the lightbox, but if we could have the images below the main image I'd def sacrifice that for the zoom on hover effect.

 

Now, i realize that Simple Image Gallery doesn't work like this. But, is there something else I can use that does?

no, if you want you just put my code in the first lines of your index.php (it's not important the file, just let something read the code and do the query :) the important is that is a php file)....you don't have to delete nothing, just put the code in a page and load the page.

 

To put more tags i think you have to repeat the code with a different tagID....as i know (don't have the k2 DB right now) it expect just one value, so you cannot use 40;13;41 but just a number.

+ and if i want to put more of one tags in items of one category a make this$second_query = "INSERT INTO jos_k2_tags_xref VALUES ($start_id, 40; 13; 41;, $column[$i])";?

Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 5 STR: =& SQL: $db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();

SQL query:

$db =& JFactory::getDBO();

MySQL said:


B_Dark said:
$db =& JFactory::getDBO(); $first_query = "SELECT ID FROM jos_k2_items WHERE catid=8"; $db->setQuery($first_query);$counter = $db->getNumRows(); $column= $db->loadResultArray(); $start_id = 44;for($i=0; $i<=$counter; $i++) {$second_query = "INSERT INTO jos_k2_tags_xref VALUES ($start_id, 40, $column[$i])"; $db->setQuery($second_query); $start_id++;}right?

$db =& JFactory::getDBO(); $first_query = "SELECT ID FROM jos_k2_items WHERE catid=8"; $db->setQuery($first_query);$counter = $db->getNumRows(); $column= $db->loadResultArray(); $start_id = 44;for($i=0; $i<=$counter; $i++) {$second_query = "INSERT INTO jos_k2_tags_xref VALUES ($start_id, 40, $column[$i])"; $db->setQuery($second_query); $start_id++;}right?

sorry, don't know how to delete those boxes in the code :O

 

just copy it row by row and use it....remember to delete the starter // in each line
Andrea Vigato said:

Ok,

/******************************************************/

 


// $db =& JFactory::getDBO();
// $first_query = "SELECT ID FROM jos_k2_items WHERE catid=8";
// $db->setQuery($first_query);


// $counter = $db->getNumRows(); // we get the number of rows created, cycle value
// $column= $db->loadResultArray(); // load all the result in a var, then access the values with the index of the for


// $start_id = 44; // or the last ID value in the jos_k2_tags_xref

// for($i=0; $i<=$counter; $i++) {


// $second_query = "INSERT INTO jos_k2_tags_xref VALUES ($start_id, 40, $column[$i])";
// $db->setQuery($second_query);
// $start_id++;

// }[/code]
[/code]

/********************************/[/code][/code]


the INSERT INTO query not have the SELECT FROM WHERE.

I think it's ok, maybe check it for some operators error...

Ok,

/******************************************************/

 


// $db =& JFactory::getDBO();
// $first_query = "SELECT ID FROM jos_k2_items WHERE catid=8";
// $db->setQuery($first_query);


// $counter = $db->getNumRows(); // we get the number of rows created, cycle value
// $column= $db->loadResultArray(); // load all the result in a var, then access the values with the index of the for


// $start_id = 44; // or the last ID value in the jos_k2_tags_xref

// for($i=0; $i<=$counter; $i++) {



// $second_query = "INSERT INTO jos_k2_tags_xref VALUES ($start_id, 40, $column[$i])";

// $db->setQuery($second_query);


// $start_id++;


// }[/code]
[/code]

/********************************/[/code][/code]


the INSERT INTO query not have the SELECT FROM WHERE.

I think it's ok, maybe check it for some operators error...

the right sec teble name is jos_k2_tags_xref#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO jos_k2_tags_xref VALUES (44, 40, itemID) LIMIT 0, 30' at line 6
SELECT IDFROM jos_k2_itemsWHERE catid =33INSERT INTO jos_k2_tags_xrefVALUES ( [/code]44, 40, itemID ) LIMIT 0 , 30they give me this message, what i write wrong?[/code]

ok i use the first query the right is "id" from this table, i tell this if someone else want to do the sameSELECT IDFROM jos_k2_itemsWHERE catid =8[/code]the give me 18 pages with the id's of the items of category "cinema" (8)after? how i give the values of itemid's from first in sec query?

On my website I enabled , in global configuration, SEF Url to ON and Use Apache mod rewrite to ON (renaming htaccess.txt in .htaccess), and I also installed AceSEF ( anyway I've tried to set global configuration to OFF and to deactivate AceSEF module+plugins, but K2 still doesn't work when I'm saving articles ).

The strange thing is that K2 and AceSEF works perfectly in another hosting server (but there the option Multibyte String functions is enabled, and here is disabled, that's why I guess that should be this one the main problem!)

 

Lately, it happens that .htaccess file disappear automatically from the server folder when I close ftp connection (I also activate the option show hidden files on filezilla, but any trace of it, I don't know why, but the site works the same one) so everytime that I need to use htaccess file, I must copy from my computer.


I've sent you the url via PM and here we go ,htaccess file:

 

thanks for your help.

 

### @version $Id: htaccess.txt 14401 2010-01-26 14:10:00Z louis $# @package Joomla# @copyright Copyright (C) 2005 - 2010 Open Source Matters. All rights reserved.# @license www.gnu.org/copyleft/gpl.html GNU/GPL# Joomla! is Free Software########################################################  READ THIS COMPLETELY IF YOU CHOOSE TO USE THIS FILE## The line just below this section: 'Options +FollowSymLinks' may cause problems# with some server configurations.  It is required for use of mod_rewrite, but may already# be set by your server administrator in a way that dissallows changing it in# your .htaccess file.  If using it causes your server to error out, comment it out (add # to# beginning of line), reload your site in your browser and test your sef url's.  If they work,# it has been set by your server administrator and you do not need it set here.########################################################  Can be commented out if causes errors, see notes above.Options +FollowSymLinks##  mod_rewrite in useRewriteEngine On########## Begin - Rewrite rules to block out some common exploits## If you experience problems on your site block out the operations listed below## This attempts to block the most common type of exploit `attempts` to Joomla!### Deny access to extension xml files (uncomment out to activate)#<Files ~ "\.xml$">#Order allow,deny#Deny from all#Satisfy all#</Files>## End of deny access to extension xml filesRewriteCond %{QUERY_STRING} mosConfig_[a-zA-Z_]{1,21}(=|\%3D) [OR]# Block out any script trying to base64_encode crap to send via URLRewriteCond %{QUERY_STRING} base64_encode.*\(.*\) [OR]# Block out any script that includes a &lt;script&gt; tag in URLRewriteCond %{QUERY_STRING} (\&lt;|%3C).*script.*(\&gt;|%3E) [NC,OR]# Block out any script trying to set a PHP GLOBALS variable via URLRewriteCond %{QUERY_STRING} GLOBALS(=|\[|\%[0-9A-Z]{0,2}) [OR]# Block out any script trying to modify a _REQUEST variable via URLRewriteCond %{QUERY_STRING} _REQUEST(=|\[|\%[0-9A-Z]{0,2})# Send all blocked request to homepage with 403 Forbidden error!RewriteRule ^(.*)$ index.php [F,L]########### End - Rewrite rules to block out some common exploits#  Uncomment following line if your webserver's URL#  is not directly related to physical file paths.#  Update Your Joomla! Directory (just / for root)# RewriteBase /########## Begin - Joomla! core SEF Section#RewriteCond %{REQUEST_FILENAME} !-fRewriteCond %{REQUEST_FILENAME} !-dRewriteCond %{REQUEST_URI} !^/index.phpRewriteCond %{REQUEST_URI} (/|\.php|\.html|\.htm|\.feed|\.pdf|\.raw|/[^.]*)$  [NC]RewriteRule (.*) index.phpRewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L]########### End - Joomla! core SEF Section

yes, do a backup first :)

 

SELECT is the first query where you save an array of itemID.

After that you use the INSERT INTO query to set the values in the itemID passed from the array.

 

remember that 4356 must be an incremental value and itemID must be the value passed from the array of the first query.


B_Dark said:

SELECT itemID FROM jos_k2_items

WHERE catid = 8INSERT INTO jos_k2_tag_xref

VALUES (4356, 12, itemID)

something like this?

Andrea Vigato said:
i'm out of home now, anyway..if you have to update with no erase you will have to save a new field, as i see in the sql any item id that got more than one tag got a reference to more tagID.

 

So what you just need to do is: 

 

(First Query)

SELECT itemID FROM jos_k2_items

WHERE catid = $catid

 

$catID = the ID of your category "Cinema"

 

(Second Query)

INSERT INTO jos_k2_tag_xref

VALUES ($id, $tagID, $itemID)

 

$id: must to be a incremental number from the last id in jos_k2_tag_xref to counter of the first query, or just an incremental number if you want.

 

$tagID: is the ID of the tag you want to add, like 8 don't know.

 

$itemID: with the first query you have saved an array of the itemID you must change. Use it to dinamic change this var.

 

Some link to use jdb if you need:

api.joomla.org/Joomla-Framework/Database/JDatabase.html

docs.joomla.org/How_to_use_the_database_classes_in_your_script

 

Hope will be ok :) sorry if it's a bit confusion... B_Dark said:

beacose i dont want to erese the other tagid's of any item of this category i want only to add another one tag only to this items of this category B_Dark said:Is it possible with this SQL query to erase the other tags of any item of this category ?! Andrea Vigato said:yes you can, but not in an easy way :) you have to create a SQL query and modify the DB.

 

Something like:

SELECT itemID FROM jos_K2_item WHERE catid = (the id of your category)

and then an UPDATE in those itemID to set tagID = your tag ID.

 

 

B_Dark said:

so we can't add a specifc tag in all items of present right now in a spesific category? Andrea Vigato said:because what i know of K2 tag system is that the tag is related to the item, not the category.

 

tagID -&gt; itemID -&gt; catID

 

So you cannot just add a tag ID to the category, you have to check the category you want if it's related to the item then add a reference of the tag you want...maybe after work i'll write you some code ok? B_Dark said:

ok the one column tagID is the one of column part order to find the solution, the other one column itemID is for one specific item id, right? so, i don't understood how with itemID i have a solution for mass add tag "trailer" in 600 item that i have save in my category "cinema'?! sorry if i make rowng but really i don't understood how this column (itemID) is my solution Andrea Vigato said:no, 

 

id (id related to the entry of the jos_k2_tags_xref) 

tagID (id of the related Tag)

itemID (id of the related Item)

 

you have to use tagID and itemID, id it's not important for your question....

SELECT itemID FROM jos_k2_items

WHERE catid = 8INSERT INTO jos_k2_tag_xref

VALUES (4356, 12, itemID)

something like this?

Andrea Vigato said:
i'm out of home now, anyway..if you have to update with no erase you will have to save a new field, as i see in the sql any item id that got more than one tag got a reference to more tagID.

 

So what you just need to do is: 

 

(First Query)

SELECT itemID FROM jos_k2_items

WHERE catid = $catid

 

$catID = the ID of your category "Cinema"

 

(Second Query)

INSERT INTO jos_k2_tag_xref

VALUES ($id, $tagID, $itemID)

 

$id: must to be a incremental number from the last id in jos_k2_tag_xref to counter of the first query, or just an incremental number if you want.

 

$tagID: is the ID of the tag you want to add, like 8 don't know.

 

$itemID: with the first query you have saved an array of the itemID you must change. Use it to dinamic change this var.

 

Some link to use jdb if you need:

api.joomla.org/Joomla-Framework/Database/JDatabase.html

docs.joomla.org/How_to_use_the_database_classes_in_your_script

 

Hope will be ok :) sorry if it's a bit confusion... B_Dark said:

beacose i dont want to erese the other tagid's of any item of this category i want only to add another one tag only to this items of this category B_Dark said:
Is it possible with this SQL query to erase the other tags of any item of this category ?! Andrea Vigato said:yes you can, but not in an easy way :) you have to create a SQL query and modify the DB.

 

Something like:

SELECT itemID FROM jos_K2_item WHERE catid = (the id of your category)

and then an UPDATE in those itemID to set tagID = your tag ID.

 

 

B_Dark said:

so we can't add a specifc tag in all items of present right now in a spesific category? Andrea Vigato said:because what i know of K2 tag system is that the tag is related to the item, not the category.

 

tagID -&gt; itemID -&gt; catID

 

So you cannot just add a tag ID to the category, you have to check the category you want if it's related to the item then add a reference of the tag you want...maybe after work i'll write you some code ok? B_Dark said:

ok the one column tagID is the one of column part order to find the solution, the other one column itemID is for one specific item id, right? so, i don't understood how with itemID i have a solution for mass add tag "trailer" in 600 item that i have save in my category "cinema'?! sorry if i make rowng but really i don't understood how this column (itemID) is my solution Andrea Vigato said:no, 

 

id (id related to the entry of the jos_k2_tags_xref) 

tagID (id of the related Tag)

itemID (id of the related Item)

 

you have to use tagID and itemID, id it's not important for your question....

i'm out of home now, anyway..if you have to update with no erase you will have to save a new field, as i see in the sql any item id that got more than one tag got a reference to more tagID.

 

So what you just need to do is: 

 

(First Query)

SELECT itemID FROM jos_k2_items

WHERE catid = $catid

 

$catID = the ID of your category "Cinema"

 

(Second Query)

INSERT INTO jos_k2_tag_xref

VALUES ($id, $tagID, $itemID)

 

$id: must to be a incremental number from the last id in jos_k2_tag_xref to counter of the first query, or just an incremental number if you want.

 

$tagID: is the ID of the tag you want to add, like 8 don't know.

 

$itemID: with the first query you have saved an array of the itemID you must change. Use it to dinamic change this var.

 

Some link to use jdb if you need:

api.joomla.org/Joomla-Framework/Database/JDatabase.html

docs.joomla.org/How_to_use_the_database_classes_in_your_script

 

Hope will be ok :) sorry if it's a bit confusion...
B_Dark said:

beacose i dont want to erese the other tagid's of any item of this category i want only to add another one tag only to this items of this category
B_Dark said:
Is it possible with this SQL query to erase the other tags of any item of this category ?! Andrea Vigato said:
yes you can, but not in an easy way :) you have to create a SQL query and modify the DB.

 

Something like:

SELECT itemID FROM jos_K2_item WHERE catid = (the id of your category)

and then an UPDATE in those itemID to set tagID = your tag ID.

 

 

B_Dark said:

so we can't add a specifc tag in all items of present right now in a spesific category? Andrea Vigato said:because what i know of K2 tag system is that the tag is related to the item, not the category.

 

tagID -&gt; itemID -&gt; catID

 

So you cannot just add a tag ID to the category, you have to check the category you want if it's related to the item then add a reference of the tag you want...maybe after work i'll write you some code ok? B_Dark said:

ok the one column tagID is the one of column part order to find the solution, the other one column itemID is for one specific item id, right? so, i don't understood how with itemID i have a solution for mass add tag "trailer" in 600 item that i have save in my category "cinema'?! sorry if i make rowng but really i don't understood how this column (itemID) is my solution Andrea Vigato said:no, 

 

id (id related to the entry of the jos_k2_tags_xref) 

tagID (id of the related Tag)

itemID (id of the related Item)

 

you have to use tagID and itemID, id it's not important for your question....

beacose i dont want to erese the other tagid's of any item of this category i want only to add another one tag only to this items of this category

B_Dark said:
Is it possible with this SQL query to erase the other tags of any item of this category ?!
Andrea Vigato said:
yes you can, but not in an easy way :) you have to create a SQL query and modify the DB.

 

Something like:

SELECT itemID FROM jos_K2_item WHERE catid = (the id of your category)

and then an UPDATE in those itemID to set tagID = your tag ID.

 

 

B_Dark said:

so we can't add a specifc tag in all items of present right now in a spesific category? Andrea Vigato said:because what i know of K2 tag system is that the tag is related to the item, not the category.

 

tagID -&gt; itemID -&gt; catID

 

So you cannot just add a tag ID to the category, you have to check the category you want if it's related to the item then add a reference of the tag you want...maybe after work i'll write you some code ok? B_Dark said:

ok the one column tagID is the one of column part order to find the solution, the other one column itemID is for one specific item id, right? so, i don't understood how with itemID i have a solution for mass add tag "trailer" in 600 item that i have save in my category "cinema'?! sorry if i make rowng but really i don't understood how this column (itemID) is my solution Andrea Vigato said:no, 

 

id (id related to the entry of the jos_k2_tags_xref) 

tagID (id of the related Tag)

itemID (id of the related Item)

 

you have to use tagID and itemID, id it's not important for your question....

Is it possible with this SQL query to erase the other tags of any item of this category ?!

Andrea Vigato said:
yes you can, but not in an easy way :) you have to create a SQL query and modify the DB.

 

Something like:

SELECT itemID FROM jos_K2_item WHERE catid = (the id of your category)

and then an UPDATE in those itemID to set tagID = your tag ID.

 

 

B_Dark said:

so we can't add a specifc tag in all items of present right now in a spesific category? Andrea Vigato said:
because what i know of K2 tag system is that the tag is related to the item, not the category.

 

tagID -&gt; itemID -&gt; catID

 

So you cannot just add a tag ID to the category, you have to check the category you want if it's related to the item then add a reference of the tag you want...maybe after work i'll write you some code ok? B_Dark said:

ok the one column tagID is the one of column part order to find the solution, the other one column itemID is for one specific item id, right? so, i don't understood how with itemID i have a solution for mass add tag "trailer" in 600 item that i have save in my category "cinema'?! sorry if i make rowng but really i don't understood how this column (itemID) is my solution Andrea Vigato said:no, 

 

id (id related to the entry of the jos_k2_tags_xref) 

tagID (id of the related Tag)

itemID (id of the related Item)

 

you have to use tagID and itemID, id it's not important for your question....