Xmas stuff and a role script

Aloha,

i need some things again. Maybe sumone can help me with this:

1. All IDs for Xmas stuff. I know the trigger for the snowmen and the ID for the Xmas trees but while browsing the textures in models.pck i saw some more things but i didnt find them in elements.data ( i cant search for chinese letters :D: )

2. Anyone knows how to get a list of the characternames and the ID like in pwAdmins role page just without using java ( or maybe got a jsp script that only shows a list of names with the ID next to it. ( oh and if someone wants to tell me this is not possible, just the account ID, it IS possible because when you open pwAdmins rolepage and click a name you see the ID of the char and not the account ID :D: )

Zorno did you want the ids of the Christmas fashion or was it for other things? Got the ids below of the xmas head fashion, and it's 795 for the male Santa head pill, 796 for the girls :D

Yes reading Chinese characters is a right pain in the ****, I was even dreaming Chinese characters at one point :?::lol:

Spoiler:

The Gents
Xmas Color Model 955
Xmas Color Texture 961

Xmas Festival Model 956
Xmas Festival Texture 962

The Ladies
Xmas Classic Model 958
Xmas Classic Texture 964

Xmas Cute Model 959
Xmas Cute Texture 965

I did think about creating a thread with all the head model ids and some info on how to stick them in the character ini file, should I do that?

Code:

---

<%@page contentType="text/html; charset=GBK"%>
<%@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="com.goldhuman.util.*"%>
<%@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://localhost:3306/dbo?useUnicode=true&characterEncoding=utf8", "root", "");
        Statement statement = connection.createStatement();
        String xGetAccountID = request.getParameter("id");
        int AccountID = Integer.parseInt(xGetAccountID);
        int roleid = AccountID;
        roleid = roleid - 1;
        RoleBean role = null;
        String tempplayername = null;
        String command = null;
        int index = 0;
        int uid = 0;
        int eachacc = 0;
        int maxid = roleid + 8;
       
        while (roleid <= maxid)
        {
                roleid++;
                eachacc++;
                try
                {
                        if (eachacc < 16) // ADSLPREDATOR
                        {
                                role = GameDB.get( roleid );
                                session.setAttribute( "gamedb_rolebean", role );
                                if (null == role){
                                        continue;
                                }
                                else
                                {
                                        tempplayername = null;
                                        tempplayername = StringEscapeUtils.escapeHtml(role.base.name.getString());
                                       
                                        index = 0;
                                        index = tempplayername.indexOf("'");
                                        StringBuffer playername = new StringBuffer(tempplayername);
                                        if(index > 0){
                                                playername.replace(index, index + 1, "?");
                                        }                                               
                                        out.println("<font color=red><br>ID: <b><font color=green>" + roleid + "</b></font> -  Name: <b><font color=green>" + tempplayername + "</b></font> -  Level: <b><font color=green>" + role.status.level + "</b></font> -  Location: <b><font color=green>" + role.status.worldtag + "</b></font></font></b>");
                                }
                        }
                        else if (eachacc == 16) // ADSLPREDATOR
                                eachacc = 0;
                        else
                                continue;
                }
                catch (Exception e)
                {
                        continue;
                }
        }
       
%>

---

Modified an existing code, simply just socket this script in php:

/showinfo.jsp?id=$POSTID

Hopefully tht helps.

Quote:

---

Originally Posted by micropanther

Zorno did you want the ids of the Christmas fashion or was it for other things?

---

Both :):

Quote:

---

Originally Posted by micropanther

Got the ids below of the xmas head fashion, and it's 795 for the male Santa head pill, 796 for the girls :D

Yes reading Chinese characters is a right pain in the ****, I was even dreaming Chinese characters at one point :?::lol:

Spoiler:

The Gents
Xmas Color Model 955
Xmas Color Texture 961

Xmas Festival Model 956
Xmas Festival Texture 962

The Ladies
Xmas Classic Model 958
Xmas Classic Texture 964

Xmas Cute Model 959
Xmas Cute Texture 965

---

Thanks :):

Quote:

---

Originally Posted by micropanther

I did think about creating a thread with all the head model ids and some info on how to stick them in the character ini file, should I do that?

---

That whould be great :):

But there must be some Xmas decoration that i dont find. I attached a texture as example. Found that one in models.pck ...

Taken from elements.data, using Ronny's pwd and his Debian server, thanks Ronny!!

Just the girl Christmas fash for now, will seek out the guys stuff, need sleep!

Spoiler:

Christmas coat 13647
Christmas skirt 13648
Christmas mittens 13650
Christmas high heels 13649

(can be dyed)
Yule dress 23586
Yule gloves 23587
Yule heels 23588

Classic Yule dress 23590
Classic Yule Gloves 23593
Classic Yule heels 23595

(can be dyed)
X'mas Color top 27315
X'mas Color skirt 27321
X'mas Color sleeves 27325
X'mas Color Boots 27331

X'mas Festival coat 27316
X'mas Festival skirt 27322
X'mas Festival sleeves 27326
X'mas Festival boots 27332

My archer, wearing the dyed xmas color set in white, looks great with the winter cut hairstyle, though the shoes are naff, even the Navistock Shieldbearer is hiding from them :lol:

Spoiler:

http://i51.tinypic.com/2llmtsx.jpg

Will get working on that other thread :)

You can get gamedbd from the terminal to give you all that, just type ./gamedbd and it will tell you all the commands it takes, just mess with it a bit and you'll figure it out

Quote:

---

Originally Posted by Zorno

i cant search for chinese letters :D:

---

I think ronny's smodfix can translate realtime from chineese. Just choose path to required folder and enjoy :blushing:
If i'm not mistaken, it translates even to russian :thumbup:
http://s015.radikal.ru/i330/1011/09/96d237a6f2fct.jpg

Quote:

---

Originally Posted by das7002

You can get gamedbd from the terminal to give you all that, just type ./gamedbd and it will tell you all the commands it takes, just mess with it a bit and you'll figure it out

---

Played around with it a bit and it shows a nice list but without the names :ehh:

i tried ./gamedbd gamesys.conf listrolebrief and it showed me this:

Spoiler:

roleid,userid,name,occupation,level,exp,moneyall,reputation
16,16,"",0,1,0,0,0
17,16,"",0,1,0,0,0
18,16,"",1,1,0,0,0
19,16,"",1,1,0,0,0
20,16,"",2,1,0,0,0
21,16,"",2,1,0,0,0
22,16,"",3,1,0,0,0
23,16,"",3,1,0,0,0
24,16,"",4,1,0,0,0
25,16,"",4,1,0,0,0
26,16,"",5,1,0,0,0
27,16,"",5,1,0,0,0
28,16,"",6,1,0,0,0
29,16,"",6,1,0,0,0
30,16,"",7,1,0,0,0
31,16,"",7,1,0,0,0
32,32,"",0,109,0,2000000000,200890
33,32,"",7,65,595288,0,0
34,32,"",4,1,0,0,0
48,48,"",0,1,0,0,0
49,48,"",1,109,0,999999,4052
52,48,"",7,101,264776629,331901868,331902016
64,64,"",0,102,317115730,999999,308131603
96,96,"",7,102,361630253,9999999,100005
97,96,"",4,102,357489172,0,100017
98,96,"",3,102,359469184,99999,9999
99,96,"",3,102,358102429,0,10007

this list whould be perfect for my needs but it should give me the names :D:

Quote:

---

Originally Posted by Zorno

Played around with it a bit and it shows a nice list but without the names :ehh:

i tried ./gamedbd gamesys.conf listrolebrief and it showed me this:

Spoiler:

roleid,userid,name,occupation,level,exp,moneyall,reputation
16,16,"",0,1,0,0,0
17,16,"",0,1,0,0,0
18,16,"",1,1,0,0,0
19,16,"",1,1,0,0,0
20,16,"",2,1,0,0,0
21,16,"",2,1,0,0,0
22,16,"",3,1,0,0,0
23,16,"",3,1,0,0,0
24,16,"",4,1,0,0,0
25,16,"",4,1,0,0,0
26,16,"",5,1,0,0,0
27,16,"",5,1,0,0,0
28,16,"",6,1,0,0,0
29,16,"",6,1,0,0,0
30,16,"",7,1,0,0,0
31,16,"",7,1,0,0,0
32,32,"",0,109,0,2000000000,200890
33,32,"",7,65,595288,0,0
34,32,"",4,1,0,0,0
48,48,"",0,1,0,0,0
49,48,"",1,109,0,999999,4052
52,48,"",7,101,264776629,331901868,331902016
64,64,"",0,102,317115730,999999,308131603
96,96,"",7,102,361630253,9999999,100005
97,96,"",4,102,357489172,0,100017
98,96,"",3,102,359469184,99999,9999
99,96,"",3,102,358102429,0,10007

this list whould be perfect for my needs but it should give me the names :D:

---

If you use listrole it does give you the name I believe, just explode it at , as it's just a csv export

Edit: Seems that it doesn't, investigating which one does
Edit2: Doesn't seem like the terminal interfaces like to give up names, I'll work out how to get it without using Java

Quote:

---

Originally Posted by das7002

I'll work out how to get it without using Java

---

Whould be great. Need that to update mah chat program :D: I want to make the Player names visible and when that is done, change the program that it is like a normal chat.
At the end it should work like a messenger but there will be some work to do till its done :):

Quote:

---

Originally Posted by Zorno

Whould be great. Need that to update mah chat program :D: I want to make the Player names visible and when that is done, change the program that it is like a normal chat.
At the end it should work like a messenger but there will be some work to do till its done :):

---

Even though with the few Javascript tools I've released here on Ragezone aren't that fancy, Javascript (and JQuery) with a PHP backend allow for some quite amazing web applications and that is better then a desktop one any day..

Anyone ever tried that quest from the Xmas Tree (ID 18255) ?

It tells something about Xmas cards but i dont have a clue how this works.

Zorno, I do apologise for not posting the ids for the guy stuff sooner, real life's been mad lately!

Spoiler:

Christmas Jacket 13643
Christmas Pants 13644
Christmas Gloves 13646
Christmas Boots 13645

(can be dyed)
Yule Jacket 23582
Yule Pants 23583
Yule Gloves 23584
Yule Boots 23585

Classic Yule Jacket 23589
Classic Yule Pants 23591
Classic Yule Gloves 23592
Classic Yule Boots 23593

X'mas Festival Jacket 27313
X'mas Festival Pants 27319
X'mas Festival Gloves 27324
X'mas Festival Shoes 27329

(can be dyed)
X'mas Colour Jacket 27312
X'mas Colour Pants 27318
X'mas Colour Gloves 27323
X'mas Colour Shoes 27328

Quote:

---

Originally Posted by micropanther

Zorno, I do apologise for not posting the ids for the guy stuff sooner, real life's been mad lately!

Spoiler:

Christmas Jacket 13643
Christmas Pants 13644
Christmas Gloves 13646
Christmas Boots 13645

(can be dyed)
Yule Jacket 23582
Yule Pants 23583
Yule Gloves 23584
Yule Boots 23585

Classic Yule Jacket 23589
Classic Yule Pants 23591
Classic Yule Gloves 23592
Classic Yule Boots 23593

X'mas Festival Jacket 27313
X'mas Festival Pants 27319
X'mas Festival Gloves 27324
X'mas Festival Shoes 27329

(can be dyed)
X'mas Colour Jacket 27312
X'mas Colour Pants 27318
X'mas Colour Gloves 27323
X'mas Colour Shoes 27328

---

Reallife is always first so dont worry :):
Thanks for the list :):