Display URL Mod

Ap0s7le · 11-27-2005

Try it out, let me know what you think etc.

If you appreciate this mod, please send me a donation or if you need PHP work done, also feel free to contact me.

Thanks

Code:

Content visible to registered users only.

Wenchie · 11-28-2005

Ohhh nice! I needed this and it works perfectly.. thank you for it.

Donation sent.

You didn't say where to send the donation so I used the link from here.. hope that was okay.

Ap0s7le · 11-28-2005

Haha thanks

David actually gets that, my PayPal address can be PM'd upon request.

I'm very glad you liked it!

Thank you

-Casey

Wenchie · 11-29-2005

Oh no! I'm so sorry. David give Casey my donation please. :lol:

GiveItaGo · 01-18-2006

Like the sound of this MOD so I am going to give it a go - I just have a quick query regarding the database alteration.

ALTER TABLE `PLD_LINK` ADD `DISPLAYURL` VARCHAR( 255 ) NOT NULL ;

- no problem fully understand that one!

INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_DISPLAYURL', '1');

- Does this mean that the current fields ID & Value require altering to the values in brackets respectively or that additional fields with those values need creating?

If it is the former (which I think it is) how do I alter the value of ID to 'ENABLE_DISPLAYURL' - Do I need to change the 'Type' to i.e. - 'CHAR' or perhaps something else?

Once again any help would be appreciated.

regards

Paul

GiveItaGo · 01-18-2006

Well managed to work it out - The values discussed need to be entered in the 'default settings' of those particular fields. Other than that this was very easy to implement with some excellent instructions.

If you pm/email me with your paypal details I will gladly make a contribution for this mod and thankyou for making this available.

regards

Paul

melaniejk · 02-11-2006

Hi.
I would like to put this Mod on my directory. I read over the directions and think I can handle all the steps except one -- the first one.

How do I edit SQL ?

I went to my Cpanl and clicked on MySQL. The options are Delete, Check, or Repair.

Do I click on Repair? I want to make sure before I do in case I'm wrong and mess something up.

Oh, can anyone who used this mod verify that your affiliate links for Commission Junction were able to work and you got proper credit.

I'll be happy to make a donation if I can get this to work properly.

Thank you.

#-----[ SQL ]------------------------------------------
# Where 'PLD_' is your table prefix
ALTER TABLE `PLD_LINK` ADD `DISPLAYURL` VARCHAR( 255 ) NOT NULL ;
INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_DISPLAYURL', '1');
#

Ap0s7le · 02-11-2006

Hello melaniejk,

Once in the MySQL part of CPanel, look for "phpMyAdmin"
When you get there, on the left use the dropdown to find your table, then when it loads on the right, hit "SQL" and it will show a big textarea to add that part in.

If you have any questions, or need help feel free to contact me personally.

Kind Regards,

-Casey

melaniejk · 02-11-2006

Anyone online available to help right now?

I just need help on the phpMyAdmin step.

**Boby** · 02-11-2006

Code:

Content visible to registered users only.

Yes!
Please post your question/problem, I am here and will help you.

Boby

melaniejk · 02-11-2006

Hi. I'm stuck in the phpMyAdmin area.
I think I'm supposed to paste the following in a white box.
Do I paste it exactly?

ALTER TABLE `PLD_LINK` ADD `DISPLAYURL` VARCHAR( 255 ) NOT NULL ;
INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_DISPLAYURL', '1');

The box already has text in it. So, I'm thinking I should delete it.
But, then how do I add this. Do I click on Insert.

I don't want to make a mistake and mess things up. So, I'm waiting for a thumbs up.

David · 02-11-2006

Defintely backup your database first.
Then yes, replace what is in the box with this.

melaniejk · 02-11-2006

Ok, thanks.
I figured out the problem.

I needed to click on the GO button after pasting that stuff in the white box.

wtms · 03-06-2006

Code:

Content visible to registered users only.

Thanks for the MOD Casey.

Looks like I got it to work in 3.0.2

I will gladly drop few bucks your way - give me your PayPal e-mail.

I have a question:
What needs to be changed to enable "display URL" field in "Submit link" template and database to store this info. This way when somebody submits new link they could submit both - actual url and display url. If I understand correct - right now "display URL" can be entered only from admin interface?

Thanks
P.S. I was serious about PayPal address.

anon · 03-06-2006

Code:

Content visible to registered users only.

Thanks for the MOD Casey.

Looks like I got it to work in 3.0.2

I will gladly drop few bucks your way - give me your PayPal e-mail.

I have a question:
What needs to be changed to enable "display URL" field in "Submit link" template and database to store this info. This way when somebody submits new link they could submit both - actual url and display url. If I understand correct - right now "display URL" can be entered only from admin interface?

Thanks
P.S. I was serious about PayPal address.[/quote]

last line of his sig where it says: Grateful for my help? Send some cash

wtms · 03-16-2006

Casey,

Any chance to see update for version 3.0?
I tried to modify detailed listing page myself but with no luck...

Could you... Please...

jeeplaw · 05-07-2006

Does anyone have this working for 3.0.4?

Steven Myers · 05-07-2006

LOVE this mod, thank you so much for making it, I'll donate in a few days!

jeeplaw · 05-09-2006

Can anyone cofirm that this works for 3.0.4? I'm sort of hesitant in implementing this if there's a chance it might not work..

Neticus · 05-09-2006

This works on 3.04, however it dosen't transalate to the 'more details' page.

You could always remove

<span class="url"> - {$URL|escape|trim}</span> (the bit that does http://www.domain.com}

from the details.tpl

If I figure out how to transalate it to details.tpl I'll post it.
(This is in amateur non-coder time, not proffessional Know-what-to-look-for time)

Anyone else is welcome to give this a bash.

11-27-2005	#1
Ap0s7le Join Date: Jun 2005 Location: The world Posts: 813	Display URL Mod Try it out, let me know what you think etc. If you appreciate this mod, please send me a donation or if you need PHP work done, also feel free to contact me. Thanks Code: Content visible to registered users only. __________________ Casey Wilson / Ap0s7le Freelance Programmer Need help with PHPLD? PM me

11-28-2005	#2
Wenchie Join Date: Sep 2005 Location: Alabama Posts: 13	Ohhh nice! I needed this and it works perfectly.. thank you for it. Donation sent. You didn't say where to send the donation so I used the link from here.. hope that was okay. __________________ Wenchie

11-28-2005	#3
Ap0s7le Join Date: Jun 2005 Location: The world Posts: 813	Haha thanks David actually gets that, my PayPal address can be PM'd upon request. I'm very glad you liked it! Thank you -Casey __________________ Casey Wilson / Ap0s7le Freelance Programmer Need help with PHPLD? PM me

11-29-2005	#4
Wenchie Join Date: Sep 2005 Location: Alabama Posts: 13	Oh no! I'm so sorry. David give Casey my donation please. :lol: __________________ Wenchie

01-18-2006	#5
GiveItaGo Join Date: Jan 2006 Posts: 9	Quick Query Like the sound of this MOD so I am going to give it a go - I just have a quick query regarding the database alteration. ALTER TABLE `PLD_LINK` ADD `DISPLAYURL` VARCHAR( 255 ) NOT NULL ; - no problem fully understand that one! INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_DISPLAYURL', '1'); - Does this mean that the current fields ID & Value require altering to the values in brackets respectively or that additional fields with those values need creating? If it is the former (which I think it is) how do I alter the value of ID to 'ENABLE_DISPLAYURL' - Do I need to change the 'Type' to i.e. - 'CHAR' or perhaps something else? Once again any help would be appreciated. regards Paul

01-18-2006	#6
GiveItaGo Join Date: Jan 2006 Posts: 9	Worked it out! Well managed to work it out - The values discussed need to be entered in the 'default settings' of those particular fields. Other than that this was very easy to implement with some excellent instructions. If you pm/email me with your paypal details I will gladly make a contribution for this mod and thankyou for making this available. regards Paul

02-11-2006	#7
melaniejk Join Date: Oct 2005 Posts: 34	First step? Hi. I would like to put this Mod on my directory. I read over the directions and think I can handle all the steps except one -- the first one. How do I edit SQL ? I went to my Cpanl and clicked on MySQL. The options are Delete, Check, or Repair. Do I click on Repair? I want to make sure before I do in case I'm wrong and mess something up. Oh, can anyone who used this mod verify that your affiliate links for Commission Junction were able to work and you got proper credit. I'll be happy to make a donation if I can get this to work properly. Thank you. #-----[ SQL ]------------------------------------------ # Where 'PLD_' is your table prefix ALTER TABLE `PLD_LINK` ADD `DISPLAYURL` VARCHAR( 255 ) NOT NULL ; INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_DISPLAYURL', '1'); #

02-11-2006	#9
melaniejk Join Date: Oct 2005 Posts: 34	phpMyAdmin step Anyone online available to help right now? I just need help on the phpMyAdmin step.

02-11-2006	#10
Boby Supporter Moderator Join Date: Dec 2005 Location: Cluj-Napoca/Sighisoara (Romania) Posts: 4,524	Code: Content visible to registered users only. Yes! Please post your question/problem, I am here and will help you. Boby __________________ *Please do not* contact me for support on phpLD!! I can hardly find time to give support for my own mods, for anything else I won't.** My phpLD Mods I am not a phpLD staff member, so please do not ask me to grant permissions, sales stuff, for access to the private supporter forums or phpLD download area. Before you report your problems, make sure it happens with the default package and not your highly modified code. Don't forget to use the search feature and do not bump threads to soon (allow at least 24h).

02-11-2006	#11
melaniejk Join Date: Oct 2005 Posts: 34	stuck Hi. I'm stuck in the phpMyAdmin area. I think I'm supposed to paste the following in a white box. Do I paste it exactly? ALTER TABLE `PLD_LINK` ADD `DISPLAYURL` VARCHAR( 255 ) NOT NULL ; INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_DISPLAYURL', '1'); The box already has text in it. So, I'm thinking I should delete it. But, then how do I add this. Do I click on Insert. I don't want to make a mistake and mess things up. So, I'm waiting for a thumbs up.

02-11-2006	#12
David Administrator *phpLD Administrator* Supporter Join Date: Jan 2005 Posts: 12,325	Defintely backup your database first. Then yes, replace what is in the box with this. __________________ Helpful Links: templates supporters forum █ New phpLD User? Start here █ Quality Guidelines for Directories █ Recommended Host

02-11-2006	#13
melaniejk Join Date: Oct 2005 Posts: 34	GO button Ok, thanks. I figured out the problem. I needed to click on the GO button after pasting that stuff in the white box.

03-06-2006	#14
wtms Supporter Join Date: Mar 2006 Location: East Coast Posts: 77	Re: Display URL Mod Code: Content visible to registered users only. Thanks for the MOD Casey. Looks like I got it to work in 3.0.2 I will gladly drop few bucks your way - give me your PayPal e-mail. I have a question: What needs to be changed to enable "display URL" field in "Submit link" template and database to store this info. This way when somebody submits new link they could submit both - actual url and display url. If I understand correct - right now "display URL" can be entered only from admin interface? Thanks P.S. I was serious about PayPal address.

03-06-2006	#15
anon Supporter Join Date: Feb 2006 Location: As far from you as humanly possible! Posts: 2,860	Re: Display URL Mod Code: Content visible to registered users only. Thanks for the MOD Casey. Looks like I got it to work in 3.0.2 I will gladly drop few bucks your way - give me your PayPal e-mail. I have a question: What needs to be changed to enable "display URL" field in "Submit link" template and database to store this info. This way when somebody submits new link they could submit both - actual url and display url. If I understand correct - right now "display URL" can be entered only from admin interface? Thanks P.S. I was serious about PayPal address.[/quote] last line of his sig where it says: Grateful for my help? Send some cash

03-16-2006	#16
wtms Supporter Join Date: Mar 2006 Location: East Coast Posts: 77	Casey, Any chance to see update for version 3.0? I tried to modify detailed listing page myself but with no luck... Could you... Please...

05-07-2006	#17
jeeplaw Supporter Join Date: May 2006 Posts: 49	Does anyone have this working for 3.0.4?

05-07-2006	#18
Steven Myers Supporter Join Date: May 2006 Posts: 1,279	LOVE this mod, thank you so much for making it, I'll donate in a few days!

05-09-2006	#19
jeeplaw Supporter Join Date: May 2006 Posts: 49	Can anyone cofirm that this works for 3.0.4? I'm sort of hesitant in implementing this if there's a chance it might not work..

05-09-2006	#20
Neticus Supporter Join Date: Dec 2005 Posts: 484	This works on 3.04, however it dosen't transalate to the 'more details' page. You could always remove <span class="url"> - {$URL\|escape\|trim}</span> (the bit that does http://www.domain.com} from the details.tpl If I figure out how to transalate it to details.tpl I'll post it. (This is in amateur non-coder time, not proffessional Know-what-to-look-for time) Anyone else is welcome to give this a bash.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)