60
I am new to XOOPS (a week maybe), so please don't laugh if this make no sense at all...
Here is what I am thinking about duplicate Categories:
1. In table xidr_links, use char instead int for cid. So it will look like this "cid1,cid2,cid4" if it belong to these three categories.
2. Whenever we need to refer to the xdir_link, we need to first extract all the cids. And then treat each cid with the rest of the fields as one tuple (row). In other word, a link with 3 cids, will be treated as thee rows and the only difference between them is the cid.
Let me know if this will work or not ...