Rappelz server files

[jw988]

all the 0 in the following was changed to 1 "if get_env("game.cash_usable_server") == 1 then"

just a temp fix to get the ktc npc and skills work

[Strean]

Originally Posted by jw988

all the 1 in the following was changed to 0 "if get_env("game.cash_usable_server") == 0 then"

just a temp fix to get the ktc npc and skills work

o.ô the lua script you uploaded contain this :

get_env("game.cash_usable_server") == 1 then -- There == 1 not 0 ?

is this right ?

[DaJohnson]

The version of NPC Merchant ETC I have has it as:

	-- game.cash_usable_server ? 1: ½ÃÅ©·çÆ® °ü·Ã ³»¿ë »ç¿ë ¼*¹ö  /  0: »ç¿ë ¾È ÇÏ´Â ¼*¹ö
	if get_env("game.cash_usable_server") == 0 then

After testing this with the "S game.cash_usable_server:0",
I do now get the KTS npc in-game. They dont seem to have items for sale tho.

[jw988]

it should be set to 1 in the lua, i redited my post, 1 makes it work with out the set game cash shop command. to get the items to work i had to change every item code in the r5 r6 r7 person other wise they came up as broken empty strings, but the changes are in my upload.

[DaJohnson]

Nope, quite correct JW. With it set to 1, it works. Didnt notice your edit to your post, I grabbed your file with it still set to 0.

[RoflcopterGoesSoiSoiSoi]

Thanks for the updated repack, my files have been all over the place and this is cleaning them up a bit.

--

Looking for a dev partner. Must speak English at a near-native or native level. Experience in SQL required, LUA/PHP a plus.

[DaJohnson]

What about if your dev partner is experienced in MySQL more than MSSQL, but has a nice knowledge of Php/Lua? And do they need to *speak* english, or is written english not good enough? o.O

[RoflcopterGoesSoiSoiSoi]

Originally Posted by DaJohnson

What about if your dev partner is experienced in MySQL more than MSSQL, but has a nice knowledge of Php/Lua? And do they need to *speak* english, or is written english not good enough? o.O

phpmyadmin is similar enough to mssql management studio, i had no experience with mssql when i first started this project XD

in php it's easy to work with mssql..
mysql_query() -> mssql_query()
mysql_connect() -> mssql_connect()
mysql_select_db() -> mssql_select_db()
etc..

--will message now

[Strean]

Originally Posted by jw988

it should be set to 1 in the lua, i redited my post, 1 makes it work with out the set game cash shop command. to get the items to work i had to change every item code in the r5 r6 r7 person other wise they came up as broken empty strings, but the changes are in my upload.

ok because i was wondering you said that we should set it to 0 ; )

ok now i know what is to do ^^

thanks

php and mssql connection need an static ip .....

[DaJohnson]

If you run all from a single local machine, you have a static ip.
Plenty of easy ways to get a local web server up and running on a local machine these days, xampp or whatever, comes to mind.

[RoflcopterGoesSoiSoiSoi]

Using WAMP-

<?php
$user = "sa";
$pass = "";
$ip = "127.0.0.1";
$db = "Telecaster";

mssql_connect("$ip","$user","$pass")or die("Cannot connect to MSSQL: ".mssql_error());
mssql_select_db("$db")
?>

[Strean]

yea but if you want to upload your php script to a webserver ....

you need a static ip or you can't connect to the mssql server because the server isn't running on the web server...

[RoflcopterGoesSoiSoiSoi]

Two different topics there. I'm just working on my own computer, not quite to the point of needing or wanting to make it public.

I was creating a special event script when I ran into an issue. There's a custom function used frequently in LUA [get_value()] that retrieves the value of .. what I'm assuming to be the column corresponding to the logged in users' unique ID. I added some extra columns that would complete my event, but get_value() wouldn't return the values at all - they were all null. I created a debug chat message.

LUA:  

player_level = get_value("level")
rank_1_achieved = get_value("rank_1_achieved")
message("Level: "..player_level")
message("Rank 1 Achieved: "..rank_1_achieved")

Output in chat:

Level: 160
Rank 1 Achieved: 
Rank 2 Achieved: 
Rank 3 Achieved: 
Rank 4 Achieved:
...etc...

Written from memory, I can't be ****** to find the actual stuff right now. I don't know why it wasn't correctly querying the database.

[DaJohnson]

Eh? Sorry Strean, I think you need to look into running a local php enabled webserver, on the same machine as your Rappelz mssql...

Uploading to the webserver, becomes a case of dropping it into the http_docs folder, and then just running it locally.

None of this requires a server online to do.

If, when the server is vastly improved and somewhat considered, stable, then sure, to host it online you'l need online servers. Static ip? Possibly, I'm confident with some trickery, you can get away with use a dynamic IP and a dynamic IP service to give a fake name for it, DynDNS service for example, but why would anyone at this time, want to host this server live?

As a thought tho, you could allow online developing of the server, using your own VPN server, OpenVPN/Hamachi, for example. Might be worth a look in, to some people.

[Strean]

Originally Posted by DaJohnson

Eh? Sorry Strean, I think you need to look into running a local php enabled webserver, on the same machine as your Rappelz mssql...

Uploading to the webserver, becomes a case of dropping it into the http_docs folder, and then just running it locally.

None of this requires a server online to do.

If, when the server is vastly improved and somewhat considered, stable, then sure, to host it online you'l need online servers. Static ip? Possibly, I'm confident with some trickery, you can get away with use a dynamic IP and a dynamic IP service to give a fake name for it, DynDNS service for example, but why would anyone at this time, want to host this server live?

As a thought tho, you could allow online developing of the server, using your own VPN server, OpenVPN/Hamachi, for example. Might be worth a look in, to some people.

ololol xD you understand me wrong ... I now this things im web developer ; D

i say it for other poeple : D !