GM Check for CubiShop

What I need to do to make CubiShop only for GM? :):
Cuz I wanna allow my GM to refill their accounts via pwAdmin without asking myself everytime. And I don't wanna let them access to the full pwAdmin :laugh:

CubiShop:
http://img851.imageshack.us/img851/4...0317113639.png

And for GetItem if possible too:
http://img148.imageshack.us/img148/4...0317114447.png

Hmm... I don't think it is possible. Maybe you could get a type of screen-sharing software that allows them to only to view 1 page. In teamviewer there is a option where they can't imput any data, so they couldnt edit server files. Or; you could find some way to link it to a webpage where GM's only know about.
Thats my 2 cents.

I think pwAdmin is not the answer. I suggest creating a separate portal for this function add a few layers of security via iptables (ie port and IP filtering). Unless ronny will do the function you are requesting.

Everything is possible in Java so I'm sure there are someway to include it in the code of cubishop or getitem. :):

Where is the problem exactly?!

U'll just need to check for specific account name which will cause ongoing changings on the script if you have new GMs comin / old leaving.
Or just check the GM state via dbo.auth

Quote:

---

Originally Posted by [D@nte]

Or just check the GM state via dbo.auth

---

I wanna know the code for it cuz I'm noob in Java :):

Quote:

---

Originally Posted by Romulan

I wanna know the code for it cuz I'm noob in Java :):

---

Oh.. You need is to have your GMs were a constant amount of Cubi_Gold without your intervention? like 50.000 ?

Or you need a separate page for GMs with the ability to authorize and translation available to them Cubi_Gold in the game?

Code:

---

Class.forName("com.mysql.jdbc.Driver").newInstance();
                                        Connection connection = DriverManager.getConnection("jdbc:mysql://" + db_host + ":" + db_port + "/" + db_database, db_user, db_password);
                                        Statement statement = connection.createStatement();
                                        ResultSet rs = statement.executeQuery("SELECT zoneid FROM auth WHERE userid='" + userid + "'");
                                        rs.next();
                                    if(rs.getString("zoneid") == null)

---

Something like that I guess but realy I'm not sure...

then something like this:

PHP Code:

---

<%@page import="java.lang.*"%>
<%@page import="java.util.*"%>
<%@page import="java.text.*"%>
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@page import="protocol.*"%>
<%@page import="com.goldhuman.auth.*"%>
<%@page import="org.apache.commons.logging.Log"%>
<%@page import="org.apache.commons.logging.LogFactory"%>
<%@page import="java.sql.*"%>
<%

      Connection connection = null;
      Class.forName("com.mysql.jdbc.Driver");

      connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1/pw?useUnicode=true&amp;characterEncoding=UTF-8", "MySQL_login", "MySQL_Password");
        Statement statement = connection.createStatement();
        ResultSet rs=null;
        int ident = PLAYER_ID;
        int ammount = CUBI_GOLD_TO_BE_ADDED;
        rs = statement.executeQuery("call usecash ( '" + ident + "' , 1, 0, 1, 0, '" + 100*amount + "', 1, @error)");
    rs.close();
    statement.close();
    connection.close();
        
%> 


---

MySQL_login = your MySql login
MySQL_Password = you Mysq password
PLAYER_ID = player ID
CUBI_GOLD_TO_BE_ADDED = ammount of cubi...