Changeset 7677 for extensions/AMetaData/amd_ajax.php
- Timestamp:
- Nov 7, 2010, 5:11:39 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/AMetaData/amd_ajax.php
r7519 r7677 841 841 elseif($selected=='n') 842 842 { 843 $sql="DELETE FROM ".$this->tables['selected_tags']." st843 $sql="DELETE FROM ".$this->tables['selected_tags']." 844 844 USING ".$this->tables['used_tags']." ut 845 LEFT JOIN ".$this->tables['selected_tags']." st846 ON ut.tagID = st.tagId845 LEFT JOIN ".$this->tables['selected_tags']." 846 ON ut.tagID = ".$this->tables['selected_tags'].".tagId 847 847 WHERE ut.numId = $numId;"; 848 848 pwg_query($sql); … … 1371 1371 // add a new metadata 1372 1372 $sql="INSERT INTO ".$this->tables['used_tags']." 1373 VALUES ('', '".$properties['tagId']."', 'n', '".$properties['name']."', 0, '".$properties['name']."' )";1373 VALUES ('', '".$properties['tagId']."', 'n', '".$properties['name']."', 0, '".$properties['name']."', 'n')"; 1374 1374 $result=pwg_query($sql); 1375 1375 $id=pwg_db_insert_id();
Note: See TracChangeset
for help on using the changeset viewer.