**The OcUK User Map**

Status
Not open for further replies.
Ok i have the same software up on my site:

http://www.richard-slater.co.uk/map/

come and spam it for me... either that or hamish could I get a SQL dump?

[edit]

[FIND]
or trigger_error("Invalid Query");

[REPLACE]
or trigger_error("The SQL ('" . $sql . "') generated an error (" . mysql_error() . ")");

This will give a slightly more verbose error.

[/edit]
 
Last edited:
Just had a quick look at the source code and I think the reason you are getting the error is in the database table the id field is declared as a tinyint.
This is an 8 bit field, so given that it is unsigned the maximum value it can take will be 255.

You need to declare it as a smallint, that is 16 bits
 
Originally posted by Haircut
Just had a quick look at the source code and I think the reason you are getting the error is in the database table the id field is declared as a tinyint.
This is an 8 bit field, so given that it is unsigned the maximum value it can take will be 255.

You need to declare it as a smallint, that is 16 bits
Click to expand...

Seems reasonable, the following code should fix that then:

Code: 
ALTER TABLE `usermap_users` CHANGE `id` `id` SMALINT UNSIGNED NOT NULL AUTO_INCREMENT;
 
Neat idea.. shame about the spam on it already. Trace their IP pass it on to who ever from here, ban them if they use these forums, simple as that... so ermmm not so simple, good idea though.

Could you make ot so that the map shows who is in what area when you click on it, Tyne & Wear is so small and the are quite a few people for around here who use these boards either that or a much bigger map :D
 
Status
Not open for further replies.
Back
Top Bottom