Changeset 1061

Timestamp:

10/17/09 11:42:33 (4 years ago)

Author:

d0nut

Message:

more fixes

Location:

g-map

Files:

• files/lib/page/MapPage.class.php (modified) (1 diff)
• install.sql (modified) (2 diffs)
• package.xml (modified) (1 diff)

g-map/files/lib/page/MapPage.class.php

@@ -62 +62 @@
                         ON              ug.groupID = g.groupID
                         AND             ug.userID = ".intval(WCF::getUser()->userID)."
-                        WHERE           groupID > 2
+                        WHERE           g.groupID > 2
                         AND             (
                                         SELECT  COUNT( userID )
                                         FROM    wcf".WCF_N."_user_to_groups user_to_groups
-                                        WHERE   wcf".WCF_N."_group.groupID = user_to_groups.groupID
+                                        WHERE   g.groupID = user_to_groups.groupID
                                         ) > 0;";
 

g-map/install.sql

@@ -1 @@
-CREATE TABLE IF NOT EXISTS wcf1_gmap (
+CREATE TABLE wcf1_gmap (
         mapID int(11) UNSIGNED NOT NULL auto_increment,
         userID int(11) UNSIGNED NOT NULL DEFAULT 0,
@@ -10 +10 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-
-ALTER TABLE wcf1_user ADD coords point NULL;
-ALTER TABLE wcf1_user ADD SPATIAL KEY coords (pt);

g-map/package.xml

@@ -51 +51 @@
                 <files>files.tar</files>
                 <useroptions>useroptions.xml</useroptions>
-                <sql>install.sql</sql>
-                <cronjobs>cronjobs.xml</cronjobs>
         </instructions>
 </package>