News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Location Mod

Started by Gobalopper, November 19, 2004, 01:43:12 AM

Previous topic - Next topic

trenchteam

QuoteColumn count doesn't match value count at row 1
File: /home/shoyorol/public_html/forum/Packages/temp/install.php
Line: 45

Anyone on this error?

beemer

#541
SMF 1.1 public beta 3 MKP 1.0 Helios Multi 11

Not sure whats changed but member map still works and shows flags but clicking on "users online" from the forum front page gives me this error

" Not unique table/alias: 'ip2c'
File: /homepages/35/d129670262/htdocs/forum/Sources/Who.php
Line: 106"

Line 106

WHERE IFNULL(mem.showOnline, 1) = 1" : ''), __FILE__, __LINE__);


AnyBody Help Please?
http://www.bmw7resource.co.uk
SMF 1.1 RC1
MKP 1.1 RC1
Helios Multi RC1
-------------------------------------------------------
http://www.thefishsheadnhorsesarse.co.uk
SMF 1.1 RC2
TinyPortal 0.8.6

digit

Can someone please tell me which files need to be writable to install the Location Mod?

I don't want to chmod EVERYTHING to 777.

Thx.
Happily using a heavily modified 1.1.16 version of SMF!

2748011 Posts in 320998 Topics by 50986 Members


SOLD my website - thanks it was a good run - they converted to vbadvanced. (and screwed it up good!)

Gobalopper

That is in the second post of this thread. :P

digit

voila!  'must be blind!  Thanks.
Happily using a heavily modified 1.1.16 version of SMF!

2748011 Posts in 320998 Topics by 50986 Members


SOLD my website - thanks it was a good run - they converted to vbadvanced. (and screwed it up good!)

Gobalopper

Quote from: beemer on September 04, 2005, 04:53:29 PMSMF 1.1 public beta 3 MKP 1.0 Helios Multi 11

Not sure whats changed but member map still works and shows flags but clicking on "users online" from the forum front page gives me this error

" Not unique table/alias: 'ip2c'
File: /homepages/35/d129670262/htdocs/forum/Sources/Who.php
Line: 106"

Line 106

WHERE IFNULL(mem.showOnline, 1) = 1" : ''), __FILE__, __LINE__);


AnyBody Help Please?

I'm thinking that MySQL query has lines duplicated. Can you cut and paste the entire thing?

Gobalopper

Quote from: trenchteam on August 30, 2005, 09:50:19 PM
QuoteColumn count doesn't match value count at row 1
File: /home/shoyorol/public_html/forum/Packages/temp/install.php
Line: 45

Anyone on this error?

You can try running this query first:
ALTER TABLE smf_mm_maps ADD COLUMN visible TINYINT(1) NOT NULL default '1'

Just replace the smf_ with whatever prefix you use, by default it is smf_ though.

Tripp

Quote from: Tripp on August 23, 2005, 03:44:29 PM
Yes, I also use 1.0.5.  I would love to use it too!!

Did anyone ever answer of how to get the mod for 1.0.5?  Thanks!

Gobalopper

I think this is the old version...

trenchteam

Quote from: Gobalopper on September 06, 2005, 09:25:42 PM
Quote from: trenchteam on August 30, 2005, 09:50:19 PM
QuoteColumn count doesn't match value count at row 1
File: /home/shoyorol/public_html/forum/Packages/temp/install.php
Line: 45

Anyone on this error?

You can try running this query first:
ALTER TABLE smf_mm_maps ADD COLUMN visible TINYINT(1) NOT NULL default '1'

Just replace the smf_ with whatever prefix you use, by default it is smf_ though.

Haha! Yes, that did it!!! SWEET!

mrandall131

#550
Awsome mod!  Installed it last night and am extremely happy!!!

Saw this iin another post, that someone uploaded the new button for their theme and thought it was a good idea, so here it is.  I am using blue_jeans theme and here is the button I made for it.


revgreed

Hello,

Is it possible to assign the text and links its own class in the CSS file?  For example, the "Place Your Pin" link and the "User Listing: " portions - I want to assign its own color.  If so, where can that be done at?  See, I'm using a black background, but the tables and whatnot for the forum are white with black text.  So, these portions I'm refering to are also black on a black background.

Thank you.


perplexed

Quote from: elliel on August 15, 2005, 06:42:41 AM
um if I am supposed to edit the display template, then can someone tell me what I am supposed to put there to make it work?

I don't want to mess it up and create errors


this still doesnt work for me on the beta version?

I also checked on the default theme since I am using another theme but it also does not show up the flag on the posts on the default theme either... so I gave up on it

It seems a pity to have the mod but not have it working so I'm trying again.  Can anyone tell me what I have to do to get this to show up on posts?
Thanks

beemer

#554
Hi All New Problem  :-X

some users can, some users can't :(

members are in the same group and some see a map and some see a black hole

some have moved there pin then lost it?

refresh makes no difference - any ideas
http://www.bmw7resource.co.uk/forum/index.php

Globalopper you were right I fixed this one thx
Quote from: Gobalopper on September 06, 2005, 09:22:44 PM
Quote from: beemer on September 04, 2005, 04:53:29 PMSMF 1.1 public beta 3 MKP 1.0 Helios Multi 11

Not sure whats changed but member map still works and shows flags but clicking on "users online" from the forum front page gives me this error

" Not unique table/alias: 'ip2c'
File: /homepages/35/d129670262/htdocs/forum/Sources/Who.php
Line: 106"

Line 106

WHERE IFNULL(mem.showOnline, 1) = 1" : ''), __FILE__, __LINE__);


AnyBody Help Please?

I'm thinking that MySQL query has lines duplicated. Can you cut and paste the entire thing?
http://www.bmw7resource.co.uk
SMF 1.1 RC1
MKP 1.1 RC1
Helios Multi RC1
-------------------------------------------------------
http://www.thefishsheadnhorsesarse.co.uk
SMF 1.1 RC2
TinyPortal 0.8.6

beemer

#555
Quote from: elliel on September 13, 2005, 02:51:23 PM
Quote from: elliel on August 15, 2005, 06:42:41 AM
um if I am supposed to edit the display template, then can someone tell me what I am supposed to put there to make it work?

I don't want to mess it up and create errors


this still doesnt work for me on the beta version?

I also checked on the default theme since I am using another theme but it also does not show up the flag on the posts on the default theme either... so I gave up on it

It seems a pity to have the mod but not have it working so I'm trying again.  Can anyone tell me what I have to do to get this to show up on posts?
Thanks


Has the Display.template.php in your default theme been updated (3 lines) by the installer?

The flags wont show if these lines are not there!

Search the file for the word flag if it dont find it it aint updated it ???
http://www.bmw7resource.co.uk
SMF 1.1 RC1
MKP 1.1 RC1
Helios Multi RC1
-------------------------------------------------------
http://www.thefishsheadnhorsesarse.co.uk
SMF 1.1 RC2
TinyPortal 0.8.6

perplexed

Quote from: beemer on September 13, 2005, 08:35:27 PM
Quote from: elliel on September 13, 2005, 02:51:23 PM
Quote from: elliel on August 15, 2005, 06:42:41 AM
um if I am supposed to edit the display template, then can someone tell me what I am supposed to put there to make it work?

I don't want to mess it up and create errors


this still doesnt work for me on the beta version?

I also checked on the default theme since I am using another theme but it also does not show up the flag on the posts on the default theme either... so I gave up on it

It seems a pity to have the mod but not have it working so I'm trying again.  Can anyone tell me what I have to do to get this to show up on posts?
Thanks


Has the Display.template.php in your default theme been updated (3 lines) by the installer?

The flags wont show if these lines are not there!

Search the file for the word flag if it dont find it it aint updated it ???



hmmm I searched and no mention of the word 'flag' anywhere.  I guess it hasn't worked :( although the member map seems to work *shrug*

beemer

Elliel

Open display.template from your them folder & Find the following

// Show the post group if and only if they have no other group or the option is on, and they are in a post group.
if ((empty($settings['hide_post_group']) || $message['member']['group'] == '') && $message['member']['post_group'] != '')
echo '
', $message['member']['post_group'], '<br />';
echo '
', $message['member']['group_stars'], '<br />';

and add under

if (!empty($message['member']['flag']['country']))
echo '
<img src="', $settings['default_images_url'], '/flags/', $message['member']['flag']['country'], '.png" alt="', $message['member']['flag']['name'], '" title="', $message['member']['flag']['name'], '" /><br />';
http://www.bmw7resource.co.uk
SMF 1.1 RC1
MKP 1.1 RC1
Helios Multi RC1
-------------------------------------------------------
http://www.thefishsheadnhorsesarse.co.uk
SMF 1.1 RC2
TinyPortal 0.8.6

perplexed

hey!  thanks for that. It worked a treat.

That was really helpful.

Now to go find more flags to sort out the UK members LOL

perplexed

#559
ok, i found on page 18 of this thread that someone attached some Uk flags ie scotland, wales etc and gave some instructions to do something in myphpadmin.... which I don't seem to have :(

The question I had was if this is meant to work with the member map then do I need to upload a special map or something that separates the individual countries in the UK and recognises them and applies the correct flag accordingly? So that members can be recognised as being in Scotland or wales etc instead of just the UK generally?

The Map I have in member map is just UK and Ireland so there is no division for scotland or wales, so how do I get it to recognise the separate countries and apply the flags?

anyone know what do to?

Advertisement: