Webmastersite.net
Register Log In

Changes in DB after using custom fields
Custom attach fields and filters

Comments on Changes in DB after using custom fields

befeleme
Experienced

Usergroup: Customer
Joined: Aug 27, 2005
Location: Czech Republic

Total Topics: 48
Total Comments: 82
Posted Jun 13, 2006 - 10:57 AM:

Hallo Paul,

I have problem with using filter and custom attach field.

I add new link custom attach field name: logoattach
and I add new link custom field type check box with name: mycustomfield. I use in template displaylinks.tpl this code:
<form action="index.php?action=displaycat&catid={CATID}&filter=mycustomfield&linkfilteraction=add" 
method="post">
<select name="filtervalue">
<option value="removefilter">all</option>
<option value="monday">Monday</option>
<option value="saturday">Saturday</option>
</select> <input type="submit" value=" OK " class="button">
</form>

and this code:
<!-- BEGIN REGULAR LINKS -->
..........
<img src="https://www.webmastersite.net/forums/download.php?id={LINKID}&field=logoattach">
<!-- END REGULAR LINKS -->

Now user submits links with name: Link1 (value of mycustomfield is monday and he attached picture: logo.jpg - by use custom field logoattach).
Link1 displays corect with logo.jpg in category and MySQL mycustomfield contains: monday.

Now user select in category filter with value Monday and only links displays, where is mycustomfield is monday. It is correct, but logo.jpg does not display and after use this filter MySQL mycustomfield contains: monday[,][,]1[,][,] !!!!!!

After when user select value of filter "all" (removefilter), all links displays in category and Link1 is correct with logo.jpg.

Now user again select filter with value Monday, but now LINK1 does not display, because mycustomfield contains: monday[,][,]1[,][,]

I tested all many times as member and as Admin, on the localhost, on the web, in original version WSNlinks 3.3.17 and 3.3.19, (multilingual) in browsers IE 6, Firefox and Opera 8.5 with the same results.

When field logoattach is empty (no custom attach files) all filter works correctly without changes in MYSQL and field mycustomfield constantly contains value monday after using filter).

All is great mystery for me.

Thank you for your reply.

P.S. Paul, similar problems are in https://www.webmastersite.net/forums/thread/6435

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jul 27, 2006 - 10:12 AM:

You must not have written the procedure you followed, since logoattach still contains 70e5bf6e1316818741e9fd0df951d436.wsn[,]abstract.png[,]3[,]100[,]80

You didn't say much of anything about what you were doing with mycustomfield so I had to guess.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.