Changeset 0c49836855deaeaf90620d3f0b6b5bcc0ca5312f

Show
Ignore:
Timestamp:
02/11/07 17:09:38 (2 years ago)
Author:
Christopher Jung <bktheg@web.de>
git-committer:
Christopher Jung <bktheg@web.de> 1171210178 +0100
git-parent:

[51e110b31c89b1863f17f1e6751efea7d6cdb6ec]

git-author:
Christopher Jung <bktheg@web.de> 1171210178 +0100
Message:

Query gefixt

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • src/net/driftingsouls/ds2/server/modules/schiffplugins/NavigationDefault.java

    ra900209 r0c49836  
    170170                         
    171171                         
    172                         SQLQuery aBase = db.query("SELECT DISTINCT x,y,owner,klasse,size FROM bases WHERE system=",sys," AND FLOOR(SQRT(POW(",x,"-x,2)+POW(",y,"-y,2)))-CAST(size AS SIGNED) <= 1"); 
     172                        SQLQuery aBase = db.query("SELECT DISTINCT x,y,owner,klasse,system,size FROM bases WHERE system=",sys," AND FLOOR(SQRT(POW(",x,"-x,2)+POW(",y,"-y,2)))-CAST(size AS SIGNED) <= 1"); 
    173173                        while( aBase.next() ) { 
    174174                                if( (aBase.getInt("size") == 0) && (sectorimgs[aBase.getInt("x")-x+1][aBase.getInt("y")-y+1] == null) ) {