Welcome to Geeklog, Anonymous Thursday, April 17 2025 @ 09:32 pm EDT

Geeklog Forums

Customised links problem - how to carry around a new field?

Post New Reply

Author:

Mood:

Code

Font Color Font Size Close Tags

Forum BBCode Help

BBCode	Effect
[b]bolded text[/b]	bolded text
[i]italicized text[/i]	italicized text
[u]underlined text[/u]	underlined text
[s]strikethrough text[/s]	strikethrough text
[img]http://www.site.com/forum/images/forum.png[/img] OR [img h=65 w=50]http://www.site.com/forum/images/forum.png[/img]
[url=https://www.geeklog.net]Geeklog[/url]	Geeklog
[quote]quoted text[/quote]	To quote: quoted text
[size=15]Your Text[/size] "12" is usually standard on message boards. Usually measured in pixels (px).	Your Text
[color=red]Red Text[/color] OR [color=#FF0000]Red Text[/color] Can use many different color names or hex codes.	Red Text
[list] []List item 1 []List item 2 [/list] OR [list=1] []List item 1 []List item 2 [/list]	List item 1 List item 2 List item 1 List item 2
[code]monospaced text[/code]	monospaced text
[code=XYX]formatted code[/code] Where XYZ can be any of the following: c css html4strict java javascript jquery perl php plain python SQL and many more...	formatted code
To enter a backslash (\) in your post, use \\\\	\

Subject

[QUOTE][u]Quote by: worldfooty[/u][p]Hi,

A year or so ago I implemented a change to the links plugin for my website so that a link (say to a new club) could also have a flag associated with it called "map" to indicate whether to place a pin on a Google map of the location of the club.  And similarly variables for "lat" and "lon".

This was a pretty basic change as I was doing the old program by example in php and sql etc.

Really I just added new fields for map, lat and lon to the links table, and if I want to map a location associated with a new link, I manually edit the database.  Ugly but it works and only a once a week type thing for a colleague who does it.  I then have an Atlas page and some php there that reads the database to display pins at club locations.

[url]http://www.worldfootynews.com/staticpages/index.php/Atlas[/url]

BUT, one of our guys wants to change the categories around which means editing all our links.  He discovered (too late, he was already 100 links in out of probably 400) that every time he does that, those extra fields I added get re-initialised, i.e. they lose their info.

I don't know much about sql but that seems strange.

My thought was to get into admin/plugins/links/index.php and ensure the new variables are read in and saved out.  To test, I'm just starting with the map variable, which is an integer 0 for off, 1 for on.  So I've added map to these lines of code:

[code]     DB_save ($_TABLES['links'], 'lid,cid,url,description,title,date,hits,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,map', "'$lid','$cid','$url','$description','$title',NOW(),'$hits',$owner_id,$group_id,$perm_owner,$perm_group,$perm_members,$perm_anon,'$map'");
[/code]
and

and

[code]   $display .= savelink (COM_applyFilter ($_POST['lid']),
            COM_applyFilter ($_POST['old_lid']),
            $cid, $_POST['categorydd'],
            $_POST['url'], $_POST['description'], $_POST['title'],
            COM_applyFilter ($_POST['hits'], true),
            COM_applyFilter ($_POST['owner_id'], true),
            COM_applyFilter ($_POST['group_id'], true),
            $_POST['perm_owner'], $_POST['perm_group'],
            $_POST['perm_members'], $_POST['perm_anon'], $_POST['map']);[/code]

There's no apparent error when I edit a link, but map still returns to its default of 0.  If I do:

[code]echo $title;
echo $map;[/code]

near the start of the savelink function, it displays the link title but no map variable, so I gather it's not making it into this function.

Any hints on what I might be forgetting?  I assume there was no better way to customise this, there's a custom.php which I've never seen as something that would help in this kind of situation.

Cheers,
Brett[/p][/QUOTE]

Options:

HTML Mode

Geeklog Forums

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks