75 replies to this topic

[fester]

I would like to come in contact with a member who can help me with a paid modification to this component to be used together with Googlemaps and Thailand data.

I am willing to pay 100 USD for the service. Please PM me if you are interested.

[PBF]

well apparently i should have looked more in detail... does this mod not support canada? if not, how can i make it support canada?

[PBF]

2 errors

===================================================
Date: Sat, 15 Nov 2008 12:34:34 -0700
Error Number: 1054
Error: Unknown column 'K9L1J' in 'where clause'
IP Address: 24.235.160.212
Page: /forum/index.php?autocom=venues&code=locator
mySQL query error: SELECT z_id FROM ibf_venue_zipdb WHERE z_zipcode=K9L1J
===================================================
Date: Sat, 15 Nov 2008 12:36:59 -0700
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
IP Address: 24.235.160.212
Page: /forum/index.php?autocom=venues&code=sethome&id=1
mySQL query error: SELECT COUNT(*) AS cnt FROM ibf_members WHERE home_venue=

[Michael]

PBF, on Nov 15 2008, 03:32 PM, said:

well apparently i should have looked more in detail... does this mod not support canada? if not, how can i make it support canada?

I'd need a source to get zip code/latitude longitude info for Canada.  The mod was written to support the US and UK, because I had their data, I don't currently have this data for Canada.  I've found one site that has this data, but it costs more than the price of this mod.  If you can find this data somewhere, I can add it into this mod.

PBF, on Nov 15 2008, 03:37 PM, said:

2 errors

===================================================
Date: Sat, 15 Nov 2008 12:34:34 -0700
Error Number: 1054
Error: Unknown column 'K9L1J' in 'where clause'
IP Address: 24.235.160.212
Page: /forum/index.php?autocom=venues&code=locator
mySQL query error: SELECT z_id FROM ibf_venue_zipdb WHERE z_zipcode=K9L1J
===================================================
Date: Sat, 15 Nov 2008 12:36:59 -0700
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
IP Address: 24.235.160.212
Page: /forum/index.php?autocom=venues&code=sethome&id=1
mySQL query error: SELECT COUNT(*) AS cnt FROM ibf_members WHERE home_venue=

Think I see the problem with those queries, will send you an updated /sources/components_public/venues.php file.

[PBF]

will the "workstation license" from that link work? ill buy it and send it to you if you'd like.

[Michael]

Well, it would probably work for just you, but my guess is that since the license description of that says "single-user, single workstation" that I could only put this into the mod for you and it wouldn't then be something I could really update the mod for others with.  Still, if you need that, then yes, buy that and send me the file and I should be able to work it into this mod for you.  Will take some time to get it changed to the format this mod uses.

[PBF]

error after the patch that you sent me

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/content/e/h/e/ehenshaw/html/paintballforces/forum/sources/components_public/venues.php on line 2484

[Michael]

Crap, sorry!  Just resent you a file which should fix that.

[PBF]

got it, seems to have worked... it is still only allowing 5 digits for zip/post code... I will need 6 for canada

[Michael]

Run these queries one at a time in your SQL Toolbox:

ALTER TABLE ibf_venues CHANGE v_zipcode v_zipcode VARCHAR(10) NOT NULL;
ALTER TABLE ibf_venue_zipdb CHANGE z_zipcode z_zipcode VARCHAR(10) NOT NULL;
ALTER TABLE ibf_members CHANGE zip_code zip_code VARCHAR(10) NOT NULL;

You'll also need to change this line in the skin_venues -> usercp_form skin template:

					  <td class="row1" width="50%"><input type='text' name='u_zip' value='{$data['zip']}' size='10' maxlength='5'></td>

To this:

					  <td class="row1" width="50%"><input type='text' name='u_zip' value='{$data['zip']}' size='10' maxlength='10'></td>

And this line in skin_venies -> venue_form:

					  <td class="row1" width="50%"><input type='text' name='v_zip' value='{$data['zip']}' size='10' maxlength='5'></td>

To this:

					  <td class="row1" width="50%"><input type='text' name='v_zip' value='{$data['zip']}' size='10' maxlength='10'></td>

[PBF]

let me know when you have the time, ill purchase that zip listing and send it to you. Sound ok?

[Michael]

Yep, I can do that whenever you send it to me.

[Morph]

Hi Michael

Is there a venues for version 3?

If not I have left a service request for you.

Thanks

[Morph]

Anyone have any idea?

[Michael]

This mod has not been upgraded for IP.Board 3.0 yet, but should be eventually.  I have other projects to do first, though.

[PBF]

Is there any way for my members to have the option (or be forced) to enter their postal code upon registration? (2.3.x)