PHPLD help

I want to change the link type of all my directory listings via phpmyadmin, but I don't know what query to run.

Can anyone advise?

Nevermind... a friend just gave me what I needed

UPDATE PLD_LINK SET `LINK_TYPE`= 'xx' WHERE `LINK_TYPE`= 'xx'

xx = whatever value you want to change

 

There is no such option in admin.
However in simple way you can add new field to link edit page, so you can edit link type.
So...

Edit file: templates/Core/admin/dir_links_edit.tpl
Find lines:

{html_options options=$stats selected=$STATUS name="STATUS" id="STATUS"}
         </td>
      </tr>

Code (markup):

Paste after it:

      <tr>
         <td class="label"><label for="LINK_TYPE">{l}Link Type{/l}:</label></td>
         <td class="smallDesc">
            <input type="text" id="LINK_TYPE" name="LINK_TYPE" value="{$LINK_TYPE}" maxlength="1" class="text" />
         </td>
      </tr>

Code (markup):

Then remember values you can enter:

0 - none (created in Admin)
1 - free
2 - normal
3 - reciprocal
4 - featured


For version 2.xx the file is in other place, also in new 3.3 it is in admin templates folder.

- D.

 

Thank you very much, that will come in handy!