Examples of DBCommand

com.knowgate.dataobjs.DBCommand
A wrapper for some common SQL command sequences @author Sergio Montoro Ten @version 5.0
marauroa.server.db.command.DBCommand
a database command that can be processed asynchronously. @author hendrik, madmetzger
org.apache.empire.db.DBCommand
This abstract class handles the creation of the SQL-Commands. There are methods to create SQL-Commands, like update, insert, delete and select.

Examples of com.knowgate.dataobjs.DBCommand

    
    oInsertDespatch = oConn.prepareStatement("INSERT INTO k_despatch_advices (gu_despatch,gu_workarea,pg_despatch,gu_shop,id_currency,bo_approved,bo_credit_ok,id_priority,gu_warehouse,dt_modified,dt_delivered,dt_printed,dt_promised,dt_payment,dt_cancel,de_despatch,tx_location,gu_company,gu_contact,nm_client  ,id_legal,gu_ship_addr,gu_bill_addr,id_ref,id_status,id_pay_status,id_ship_method,im_subtotal,im_taxes,im_shipping,im_discount,im_total,tx_ship_notes,tx_email_to,tx_comments) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
  oInsertLine = oConn.prepareStatement("INSERT INTO k_despatch_lines (gu_despatch,pg_line,pr_sale,nu_quantity,id_unit,pr_total,pct_tax_rate,is_tax_included,nm_product,gu_product,gu_item,id_status,tx_promotion,tx_options) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
  oInsertRelationWithOrder = oConn.prepareStatement("INSERT INTO k_x_orders_despatch (gu_order,gu_despatch) VALUES (?,?)");
    oFindProductGUID = oConn.prepareStatement("SELECT gu_product FROM k_products WHERE nm_product=?", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
    oLoadOrder = new DBCommand();
  }

View Full Code Here

Examples of marauroa.server.db.command.DBCommand

  public void storeRPObject(RPObject player) throws SQLException, IOException {
    // And update the entry
    object = player;


    // We store the object in the database
    DBCommand command = new StoreCharacterCommand(username, character, player);
    DBCommandQueue.get().enqueue(command);
  }

View Full Code Here

Examples of marauroa.server.db.command.DBCommand


      /*
       * Build player character list and send it to client
       */
      if (sendListOfCharacters) {
        DBCommand command = new LoadAllActiveCharactersCommand(username,
            new SendCharacterListHandler(netMan, protocolVersion), clientid, channel,
            protocolVersion);
        DBCommandQueue.get().enqueue(command);
      }
    } else {

View Full Code Here

Examples of marauroa.server.db.command.DBCommand

   * @param msg MessageC2SChooseCharacter
   * @param clientid clientid
   * @param entry PlayerEntry
   */
  private void loadAndPlaceInWorld(MessageC2SChooseCharacter msg, int clientid, PlayerEntry entry) {
    DBCommand command = new LoadActiveCharacterCommand(entry.username, entry.character, this, clientid, msg.getSocketChannel(), msg.getProtocolVersion());
    DBCommandQueue.get().enqueue(command);
  }

View Full Code Here

Examples of marauroa.server.db.command.DBCommand

      if (!isValidEvent(msg, entry, ClientState.CONNECTION_ACCEPTED)) {
        return;
      }


      SecuredLoginInfo info = fillLoginInfo(msg, entry);
      DBCommand command = new LoginCommand(info, 
          this, entry.clientid, 
          msg.getSocketChannel(), msg.getProtocolVersion());
      DBCommandQueue.get().enqueue(command);
  }

View Full Code Here

Examples of marauroa.server.db.command.DBCommand

    msgServerInfo.setClientID(clientid);
    msgServerInfo.setProtocolVersion(protocolVersion);
    netMan.sendMessage(msgServerInfo);


    /* Build player character list and send it to client */
    DBCommand command = new LoadAllActiveCharactersCommand(entry.username, 
        new SendCharacterListHandler(netMan, protocolVersion), 
        clientid, channel, protocolVersion);
    DBCommandQueue.get().enqueue(command);


    entry.state = ClientState.LOGIN_COMPLETE;

View Full Code Here

Examples of marauroa.server.db.command.DBCommand

    } else {
      activateGhostmode(player);
    }


    /* Notify database that the player is in Ghost mode */
    DBCommand command = new SetOnlineStatusCommand(player.getName(), !player.isGhost());
    DBCommandQueue.get().enqueue(command);


    /* Notify players about admin going into ghost mode. */
    StendhalRPRuleProcessor.get().notifyOnlineStatus(!player.isGhost(), player);

View Full Code Here

Examples of marauroa.server.db.command.DBCommand


        getOnlinePlayers().add(player);


        if (!player.isGhost()) {
          notifyOnlineStatus(true, player);
          DBCommand command = new SetOnlineStatusCommand(player.getName(), true);
          DBCommandQueue.get().enqueue(command);
        }
        updatePlayerNameListForPlayersOnLogin(player);
        String[] params = {};

View Full Code Here

Examples of marauroa.server.db.command.DBCommand

        updatePlayerNameListForPlayersOnLogout(player);


        Player.destroy(player);
        getOnlinePlayers().remove(player);


        DBCommand command = new SetOnlineStatusCommand(player.getName(), false);
        DBCommandQueue.get().enqueue(command);


        String[] params = {};
        new GameEvent(player.getName(), "logout", params).raise();
        logger.debug("removed player " + player);

View Full Code Here

Examples of marauroa.server.db.command.DBCommand

        supported.notifyWorldAboutChanges();
        SingletonRepository.getRuleProcessor().sendMessageToSupporters(message);
        
      } else {
        // that player is not logged in. Do they exist at all or are they just offline? Try sending a message with postman.
        DBCommand command = new StoreMessageCommand(player.getName(), action.get(TARGET), "In answer to your support question:\n" + reply + " \nIf you wish to reply, use /support.", "S");
        DBCommandQueue.get().enqueueAndAwaitResult(command, handle);
        TurnNotifier.get().notifyInTurns(0, new TurnListenerDecorator(this));
      }
    }
  }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.