Edit Site-Sift Deep Links in Admin Panel

As everyone knows terryuk of linksjuice.com had wrote a tutorial on how to do site-sift deep links.

Well I was toying on popotalk's IndexSniff Web Directory(site-sift driven) and he asked if i could install the deep links for him and so I did.
Well anywho, I thought that is sucked for erroneous submissions that would make you have to go into phpMyAdmin in order to fix it, so I went ahead and just figured how to add it all into the admin for easy edits. Nothing really rocket science about it, but anywho, i will go by terryuk's naming convention so things don't get mixed up.

this is easy editing, but still, back your stuff up before you do any editing:

goto and open up: admin/pages/edit.php

line: 45 (the insert)

Replace it with this one.

  $updateSQL = sprintf("UPDATE pages SET rLink=%s, rLinkStatus=%s, url=%s, title=%s, description=%s, keywords=%s, active=%s," .$pdatestr . "exp=%s, mid=%s, ip=%s, catID=%s, o_url1=%s, o_url2=%s, o_url3=%s, o_url4=%s, o_url5=%s, o_title1=%s, o_title2=%s, o_title3=%s, o_title4=%s, o_title5=%s WHERE id=%s",
                       GetSQLValueString($_POST['rLink'], "text"),
                       GetSQLValueString($_POST['rlstat'], "text"),
                       GetSQLValueString($_POST['url'], "text"),
                       GetSQLValueString($_POST['title'], "text"),
                       GetSQLValueString($_POST['description'], "text"),
                       GetSQLValueString($_POST['keywords'], "text"),
                       GetSQLValueString($_POST['active'], "text"),
					   GetSQLValueString($_POST['exp'], "int"),
					   GetSQLValueString($_POST['mid'], "int"),
                       GetSQLValueString($_POST['ip'], "text"),
                       GetSQLValueString($_POST['catID'], "int"),
					   GetSQLValueString($_POST['o_url1'], "text"),
					   GetSQLValueString($_POST['o_url2'], "text"),
					   GetSQLValueString($_POST['o_url3'], "text"),
					   GetSQLValueString($_POST['o_url4'], "text"),
					   GetSQLValueString($_POST['o_url5'], "text"),
					   GetSQLValueString($_POST['o_title1'], "text"),
					   GetSQLValueString($_POST['o_title2'], "text"),
					   GetSQLValueString($_POST['o_title3'], "text"),
					   GetSQLValueString($_POST['o_title4'], "text"),
					   GetSQLValueString($_POST['o_title5'], "text"),
					   GetSQLValueString($_POST['id'], "int"));

Code (markup):

scroll down to like: 116 and drop this in there:

			  <tr id="row1">
			  <td align="right" nowrap class="colTextNoBG">URL 1:</td>
			  <td class="rowTextNoBG"><input name="o_url1" type="text" size="50" maxlength="254" value="<?php echo $row_page['o_url1']; ?>"></td>
			  </tr>
			  <tr id="row2">
			  <td align="right" nowrap class="colTextNoBG">Title 1:</td>
			  <td class="rowTextNoBG"><input id="title1" name="o_title1" type="text" size="50" maxlength="100" value="<?php echo $row_page['o_title1']; ?>"></td>
			  </tr>
			  <tr id="row3">
			  <td align="right" nowrap class="colTextNoBG">URL 2:</td>
			  <td class="rowTextNoBG"><input name="o_url2" type="text" size="50" maxlength="254" value="<?php echo $row_page['o_url2']; ?>"></td>
			  </tr>
			  <tr id="row4">
			  <td align="right" nowrap class="colTextNoBG">Title 2:</td>
			  <td class="rowTextNoBG"><input id="title2" name="o_title2" type="text" size="50" maxlength="100" value="<?php echo $row_page['o_title2']; ?>"></td>
			  </tr>
			  <tr id="row5">
			  <td align="right" nowrap class="colTextNoBG">URL 3:</td>
			  <td class="rowTextNoBG"><input name="o_url3" type="text" size="50" maxlength="254" value="<?php echo $row_page['o_url3']; ?>"></td>
			  </tr>
			  <tr id="row6">
			  <td align="right" nowrap class="colTextNoBG">Title 3:</td>
			  <td class="rowTextNoBG"><input id="title3" name="o_title3" type="text" size="50" maxlength="100" value="<?php echo $row_page['o_title3']; ?>"></td>
			  </tr>
			  <tr id="row7">
			  <td align="right" nowrap class="colTextNoBG">URL 4:</td>
			  <td class="rowTextNoBG"><input name="o_url4" type="text" size="50" maxlength="254" value="<?php echo $row_page['o_url4']; ?>"></td>
			  </tr>
			  <tr id="row8">
			  <td align="right" nowrap class="colTextNoBG">Title 4:</td>
			  <td class="rowTextNoBG"><input id="title4" name="o_title4" type="text" size="50" maxlength="100" value="<?php echo $row_page['o_title4']; ?>"></td>
			  </tr>
			  <tr id="row9">
			  <td align="right" nowrap class="colTextNoBG">URL 5:</td>
			  <td class="rowTextNoBG"><input name="o_url5" type="text" size="50" maxlength="254" value="<?php echo $row_page['o_url5']; ?>"></td>
			  </tr>
			  <tr id="row10">
			  <td align="right" nowrap class="colTextNoBG">Title 5:</td>
			  <td class="rowTextNoBG"><input id="title5" name="o_title5" type="text" size="50" maxlength="100" value="<?php echo $row_page['o_title5']; ?>"></td>
			  </tr>

Code (markup):

save it and you're done. now you can edit your deep links from within the admin if there is a problem.

I hadn't seen anyone provide this, but if someone has, let me know and i'll provide them with full credit.

 

Another FINE improvements from Rob. Thank you.

 

Another top OP
Thanks for the 'heads up'

 

well im finally glad the boy in the bubble finally decided to work on other scripts also as i remeber you telling me if its not phpld you wouldnt touch it. So i have an adult directory that has your name written all over it lol

Nice work an0n as always....

thx
malcolm

 

I feel very special.

 

tks for this initiative! will be installing it soon on my 2 directories...

 

Nice to see an0n working for site-sift too..

 

What a nice gesture An0n and also thanks to Terry for providing the tuts and An0n for improving it or making it easy.

Thanks guy's!!!

 

Very nice.
Thank you for sharing, will play around with it on my site-sift directory.

Morty

 

Anyone give it a try and did everything work out for you without any problems?

 

Yeah I installed it on http://www.herdir.com/ and everything worked.

Thanks Rob!

 

I can see one problem on http://www.indexsniff.com if click on Sponsor then paid (which dose not have deeplinks) the deep link dose not despair. Is should be a easy fix for anOn i assume.

 

Cool! Rob, thanks for you sharing.

 

This thread is for the admin section, not the submit. But thanks for letting me know about the submit page. 10 second fix
I'll give ya some green for doing popotalk's job hahaha

Rob

 

Nice work I never got around to making that part of the mod.. i'll be installing it for sure

 

Yo Babes! You did it again. Nice work
Glad to see the beginning of a revolution here

Now i have more solid reason to make more directories on sitesift

Well done and great thanks!

 

Not only that as you can see there are more on it at detail pages and more to come.
http://www.indexsniff.com/4/Directories/-detail-160.html

Thanks