Code Search for Developers
 
 		 
  

prunetables.sql from Scorched 3D at Krugle


Show prunetables.sql syntax highlighted 

delete from scorched3d_events where TO_DAYS(NOW()) - TO_DAYS(scorched3d_events.eventtime) > 7;

create temporary table tmp select playerid from scorched3d_stats group by playerid having sum(shots) = 0;

delete from scorched3d_players using scorched3d_players, tmp where scorched3d_players.playerid = tmp.playerid;


See more files for this project here

Scorched 3D

Scorched3D is a 3D remake of the popular 2D artillery game Scorched Earth.\r\nScorched3D can be played against the computer, other players and remotely across the internet or LAN.

Project homepage: http://sourceforge.net/projects/scorched3d
Programming language(s): C,C++,XML
License: gpl2

  accessories/
    banana/
      banana.txt
      bantex.bmp
    barrage/
      barrage.txt
      gradient.bmp
      white.bmp
      yellow.bmp
    beer_bottle/
      bottle.bmp
      bottle.txt
    bomb/
      black.bmp
      bomb.txt
      white.bmp
    bomblet/
      bomblet.txt
      yellow.bmp
    bouncingbetty/
      black.bmp
      bouncingbetty.txt
    digger/
      black.bmp
      digger.txt
      swirl.bmp
    dirt/
      camo.bmp
      dirt.txt
    fatman/
      black.bmp
      fatman.txt
    hawkmissile/
      gradient.bmp
      hawk.txt
      white.bmp
      yellow.bmp
    herring/
      body.bmp
      eyes.bmp
      herring.txt
    icbm/
      black.bmp
      gradient.bmp
      icbm.txt
      white.bmp
      yellow.bmp
    laser/
      about.txt
      alpha2.bmp
      blue128.bmp
      hlaser.txt
      laser.txt
      red128.bmp
    littleboy/
      black.bmp
      littleboy.txt
    m48/
      gradient.bmp
      m48.txt
      white.bmp
      yellow.bmp
    mirvwarhead/
      black.bmp
      mirvwarhead.txt
    napalm/
      body.bmp
      napalm.txt
    palmtree/
      black.bmp
      burntpalm.txt
      burntpalm2.txt
      green.bmp
      palm.txt
      palm2.txt
      tan.bmp
    patriot/
      gradient.bmp
      patriot.txt
      white.bmp
      yellow.bmp
    pinguins/
      2pinguins.txt
      birdmat.bmp
      pinguin1.txt
      pinguin2.txt
    pwrcrate/
      pwrcrate.bmp
      pwrcrate.txt
    riot/
      base.bmp
      body.bmp
      riot.txt
    roller/
      roller.bmp
      roller.txt
    sa6/
      gradient.bmp
      sa6.txt
      white.bmp
      yellow.bmp
    shack/
      roof.bmp
      shack.bmp
      shack.txt
      window.bmp
    shell/
      black.bmp
      shell.txt
    smallpine/
      black.bmp
      burntsmallpine.txt
      green.bmp
      smallpine.txt
      smallpine2.txt
      smallpine3.txt
      tan.bmp
      wintergreen.bmp
      wintersmallpine.txt
      wintersmallpine2.txt
      wintersmallpine3.txt
    sonicring/
      sonicring.bmp
      sonicring.txt
    teleport/
      base.bmp
      detail.bmp
      teleport.txt
    v2missile/
      black.bmp
      checker.bmp
      gradient.bmp
      v2missile.txt
      yellow.bmp
    clusterbomb.ase
    clusterbomb2.ase
    default.ase
    default.bmp
    flare.txt
    magma.bmp
    roller.ase
    white.bmp
  avatars/
    agreement.txt
    animal.png
    baby.png
    bavia.png
    computer.png
    daisy.png
    fish.png
    flower.png
    floyd.png
    heart.png
    lips.png
    mxpx.png
    pint.png
    player.png
    prot.png
    termin.png
    vader.png
    web.png
    yoda.png
  fonts/
    VERA-COPYRIGHT.TXT
    test.ttf
    testout.ttf
    vera.ttf
    veramobd.ttf
  globalmods/
    apoc/
    globalmods.txt
  html/
    server/
  landscapes/
    ambientsoundjet.xml
    ambientsoundjungle.xml
    ambientsoundlava.xml
    ambientsoundnight.xml
    ambientsoundrain.xml
    ambientsoundtrees.xml
    ambientsoundwaves.xml
    ascencion-pic.bmp
    ascencion.bmp
    boidsah64.xml
    boidsbats.xml
    boidsf16.xml
    boidsf18.xml
    boidsgulls.xml
    boidsparrot.xml
    canyon-pic.bmp
    canyon.bmp
    cavern-pic.bmp
    defnascencion.xml
  meshes/
  shaders/
  talk/
  tanks/
  textures/
  wav/
  windows/
  accessories.xml
  ainames.txt
  autoexec.xml
  custominfo.xml
  fastestdisplay.xml
  keys.xml
  landscapes.xml
  modinfo.xml
  mysql.xml
  playernames.txt
  prunetables.sql
  random.no
  safedisplay.xml
  server.xml
  singlecustom.xml
  singleeasy.xml
  singlehard.xml
  singlenormal.xml
  singletarget.xml
  singletutorial.xml
  ssdisplay.xml
  ssgame.xml
  statstables.sql
  tankais.xml
  tankaiweaponsets.xml
  tanks.xml
  tanktypes.xml
  textureset.xml
  tips.txt
  tutorial.xml
  windows.xml