[Help Thread] Please post your questions here.

[sapir619]

Originally Posted by Sherock

i need to insert this for every characters in my server using sql code

INSERT [dbo].[GlobalVariable] ([name], [value]) VALUES (N'123321_X', N'Y')

where x is the name of characters and Y is number of logins
notice that i want to implement this code for all characters

Lua is the solution for you.
set_global_vairable("122321_"..gv('name'),gv('logi n_count'))

Now you have to write it at the correct place, which mean you have to know what you want to do with the information you set.

[Mr Guitou]

Hello.

I have some trouble with LUA scripting.
I try to access some (non-standard) values about object, and I don't found any function working.

I want read the "wear_type" value from itemressources table, in order create a pnj that make different actions depending on this value.

Try some:
-> get_item_wear_type(Handle)
-> get_id_item_wear_type (ID) (and every "_id" position)
-> get_item_value (ID, "wear_type" )

The only thing I found about this value is get_wear_item_handle(i) that return handle to an object weared by character
Don't need this one anymore, I already have the handle :P

Any idea?

PS: I realize while working on it that there's no public reference guide about usable lua functions with captain herlock :-(

PPS: sorry for poor english

[Sherock]

Originally Posted by sapir619

Lua is the solution for you.
set_global_vairable("122321_"..gv('name'),gv('logi n_count'))

Now you have to write it at the correct place, which mean you have to know what you want to do with the information you set.

login_count was just an example ... i want arena_mvp_count
and arena_mvp_count can't be called using get_value in lua

[TheOnlyOneRaskim]

Originally Posted by Mr Guitou

Hello.

I have some trouble with LUA scripting.
I try to access some (non-standard) values about object, and I don't found any function working.

I want read the "wear_type" value from itemressources table, in order create a pnj that make different actions depending on this value.

Try some:
-> get_item_wear_type(Handle)
-> get_id_item_wear_type (ID) (and every "_id" position)
-> get_item_value (ID, "wear_type" )

The only thing I found about this value is get_wear_item_handle(i) that return handle to an object weared by character
Don't need this one anymore, I already have the handle :P

Any idea?

PS: I realize while working on it that there's no public reference guide about usable lua functions with captain herlock :-(

PPS: sorry for poor english

[Mr Guitou]

Originally Posted by TheOnlyOneRaskim

Thanks

Take a deep look inside this usefull topic, seems there's no integrated function to solve my problem, need to found an other way

Chalenge accepted

[TheOnlyOneRaskim]

I can send you the wear type numbers when I'm at home. Otherwise I don't understand what you're trying to do

[Sherock]

Originally Posted by Sherock

login_count was just an example ... i want arena_mvp_count
and arena_mvp_count can't be called using get_value in lua

Up ^^

[ThunderNikk]

Have you read the topic about using SQL statements with lua scripting by mongreldogg?

[Mr Guitou]

Originally Posted by TheOnlyOneRaskim

I can send you the wear type numbers when I'm at home. Otherwise I don't understand what you're trying to do

I think you don't understand. In all case, don't waste your time, I already have the values

You already answer all what I need with the link you give
I didn't need more than a reference guide.

What I need to do for now is learn and try... And

[Sherock]

Originally Posted by thndr

Have you read the topic about using SQL statements with lua scripting by mongreldogg?

yes but i want to insert a global value for each character in my telecaster using SQL code

but i don't know how

for example

Server_"name" , lv

name , value

using sql only

[DaedeM]

I've set up a 9.1 server following these instructions



but when I go to launch the game it only loads half way. I don't know what info I need to put here but I'll get what I can.

Edit: I think the issue is I have a 9.2 SFrame. Gonna get a 9.1 and see if that works.

[Sherock]

i did it but is it able to let global variables can use without restart game server when you add it using sql ?

[sunnyxie49]

Originally Posted by Space()

I have given you the shop.
If you do not know the set, do not do shop.

this shop don't have login page!
<form action="/login/" method="POST"></form>
don't have "/login/" folder,and internal documents!

[Space()]

I have questions about the ports on a Server.

- Can we change the ports in the ".opt" file ?
- What ports to open for the firewall ? (inbound/outbound)

[ThunderNikk]

Originally Posted by Space()

- Can we change the ports in the ".opt" file ?

Yes

Originally Posted by Space()

- What ports to open for the firewall ? (inbound/outbound)

All of them except 1433 or whatever you set as database port.

You should read the guide on server security linked in the tools thread if you are opening the database port for remote management.