Jump to content

Zath

Members
  • Posts

    20
  • Joined

  • Last visited

Contact Methods

  • Website URL
    http://
  • ICQ
    0

Profile Information

  • Location
    England

Zath's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. I host an online game. To connect to that game, the user runs the client which uses an IP address to find the server and then user entry of id and password to gain access to the next part of the game. The ID and password are held on an MS SQL 2012 SQL table. The server itself uses ODBC. I would like to have a web page that displays "Server online" or "Server Offline". This info would be gained when a visitor sees the web page. I've seen it done elsewhere with javascript. Is there a way to create a php code or javascript (or other) that will be able to try and connect to the SQL table and server using a hidden server side Id and password and display the results ? Perhaps I'm not looking at this the right way. Can anyone advise me please ?
  2. Care to elaborate ? The table is always live and its contents can be called in game by clicking a link. However, I can't pick up that call server side via SQL. Is it achieved with a query or does the table setup itself need changing regardless of data within ?
  3. Hello. Is it possible to change the underlying order of a table with DESC ? I run a game server where items are offered for sale. Users call up lists of items which need to be displayed as most recent at the top. Having learnt that I can add ORDER BY FLD_SELLDATE DESC to the list calling stored procedures, I can correct the bug and display items in the correct order. However, there is one list option that has no associated stored procedure and that's the full item list so I can't sort this with DESC, hence my question. If it is possible to change the whole table, would this negate the changes made to the stored procedures ? Thanks PS I'm using MS SQL Server Management Studio 2012
×
×
  • Create New...