-____________- i just tryed to upgrade and now i get even more errors this *Beep* is crazy

im going to try and use one of the other programs u mentioned if it doesnt work i will post the errors i get

Dovac's guide to what?

I am not sure how your setup is, but since you are setting up the web server yourself my guess is that all the ragnarok and related servers are on your own local network. If that is the case, then you do not need to use the wan ip address to access the database, use the lan ip address. Also, make sure that you are not forwarding port 1433 to anywhere inside of your network, as it could point towards your mssql server and it is a big security hole.

If this is an inaccurate assumption of your network, then generally explain how you have things set up in regards to where the mssql server is and where the web server is and how they connect to the internet.

On page 2 of this thread dovac typed up a lil guide and yes i have everything on 1 pc.......i set it all up using remote desktop i don't have physical acess to the machine. I had a few friends try to connect to the CP and they said it work fine tho everyonce in awhile that error pop up after a refresh it works perfectly......













On a side note anyone know how to make it so gm don't show on ladder?

This might have been addressed before, I'm not too sure actually. If you set up everything and including the extra database that comes with aegis cp then it should ignore whatever accounts are in the 'ignored' table.

As I'm looking over more and more of the code, efficiency apparently was thrown out of the window. If it gets the job done though, that's good enough for some.

Try to recode it all! you seem bright enough and id love to bug u more for help since nuc wnt be around anymore hahah.

If you have it don't use that... but if you want you could add a extra statement like if(function_exists('file_get_contents') == NULL) to do the checking and etc

Regards,
fritz

The computer i am trying to host the cp site is on a router, so should I forward the port 1433?

1. This may be caused by many things. You might not have enough bandwidth for both your web server and a ragnarok online server to be used at the same time. The code that is used for the server status page is somewhat experimental and typically isn't used for checking if a server is up or not. If you are hosting everything ( account, char, inter, zone, mssql, http ) on the same computer, you might not have enough resources for all of them to run nicely at the same time.

What I ultimately suggest for this is to disable the server status page and see if it's ok after that. If not, then try to move the cp to another host.

2. If you have the cp outside of the network that the mssql server is on, then you have to make sure that the mssql server can be accessable by computers outside of its network. THIS IS A BIG SECURITY RISK. That being said, you have to forward port 1433 on the router to the network that the mssql server is behind. To illustrate:

internet -> router 1 -> mssql server

internet -> router 2 -> http server with the aegis cp

You have to forward port 1433 to the ip that the mssql server has on router 1. Preferrably, if your router can do port forwarding for only certain ips, such as the ip of your http server with the aegis cp on it, it would be much more secure than letting everybody access it. I'm sure my new(ish) dlink 624 can, but my old zyxel whatever cannot; it's router specific.

It would all depend on how many pvp maps you want. The query would be:

$pvp = mssql_query("select * from PvPScore where GID='$GID'", $char_db);

Then later on when outputting whatever scores that character has, you need to loop through the results of that query. Delete:

while ($pvp_array = mssql_fetch_array($pvp))
{
$Score = $pvp_array['WinTime'];
}

Then go down where it says:

echo "<td bgcolor=\"$color\" width=\"80\" class=\"mytext\">$scolor$Score$ccolor</td>";

And replace it with:

while ($pvp_array = mssql_fetch_array($pvp))
{
echo "<td bgcolor=\"$color\" width=\"80\" class=\"mytext\">$pvp_array['MapName'] - $pvp_array['WinTime']</td>";
}

This might work.. might not. In the end it should look something like 'map_name_1.gat - the_score'. Unless you know a bit of PHP it would probably be easier to just leave the query as it is now, and just change the map to the most popular pvp map you have.

hello



did u, find the way to maka validation is not required?? cause i need it too,



fritz : You people really need to upgrade... but heres file_get_contents()(Can't believe you people couldnt do it your self, makes since to open a file and read all of the contents lol)

yes.. i can't do it by my self.. cause i dont know what to do... can u help me, cause it still get me error file_get_contents..
i use php triad phptriad2-2-1(1), cause its only php server that work, easy php get me more lot error( 1.7) and also php that i download from there web site..
please help me.. what should i do to correct the problem... ( i dont know how to upgrade it so i dont get that error anymore
(
Fatal error: Call to undefined function: file_get_contents() in c:\apache\htdocs\source\memory.php on line 86
)


thx alot... God Bless

hi serra....

thx for help... i mean in acp.... not in game...

i create new account... n buy but wing n red pot..

i put red pot in kafra storage n but wing still in my inventory...

....

then i open ACP to see in menu view in char management... view items...

it show me all item i have excep error in kafra storage
1 Wing_of_Butterfly(s)
30 kf_1_pit(s) this one from kafra storage.. should be red pot
Cotton_Shirt [ ]
Ahuramazda [ ]
Angra_manyu [ ]


please help me... sorry if my english not too good and makes different from i mean... /sry

Those are the items in your inventory, not your storage. When you used storage, you got 30 Kafra Points (which explains the 30 kf_1_pit). Your Red Potions don't show up because they're in storage. The Butterfly Wing, Cotton Shirt, Ahuramazda, and AngraManyu, as well as the invisible quest item "kf_1_pit" are in the inventory of your character.

any idea?

go to line ~200 in user_add.php

find:

change it to:

"secure registration" lol... little white lies never hurt. trust me, players believe ANYTHING you tell them.

and replace with

O and something else.. If your smtp server requires you to give a username and password how would that be done..?? I am not very good at php scripting or php globally for that matter.

EDIT 2

Well never mind about that smtp user name and password thingy. I just figured out my ISP does not support it. But it just wont work for me. Emails dont get send and i am using the smtp server of my ISP wich does indeed not accept sends from IP's not on their network but i still dont understand why it does not accept my server since its my second pc

Arg i want it to work.. O and yes i ready seen the post from echira but i want the validation thing to work also the same for recovering lost passwords.

EDIT 3

Woohoo i fixed it its now working and for those also having trouble here is what i did. Offcourse put your smtp server in your php.ini also fill in the sendmail_from to the email your using on that smtp server.

then open memory.php and find (should be line 131)

And change it to

Now these fixes all worked for me and my php knowledge is very limited so i cant say for 100% it will work for you.

Greetz Solid

The main thing to realize is that you only need to protect from SQL injection where it is open to the public, and takes in GET arguments. I suppose it can be done in the Account management page, but I'm not really that good at injecting myself.

We're working on it... It has lots of nice new features too It's coming out great!

-- It's much more secure than the original release
-- Money transfer exploits are fixed
-- Character ID is hidden in money transfers, to increase security
-- SQL Injection is fixed
-- "Storage Storage" - My system for switching storage boxes, to allow up to 5 Storage Boxes (it shows you the actual list of items in each, too)
-- "Character Storage" - Lets you hold up to 255 characters in storage (this one is compatible with the account cleanup script) [not stolen from Maldiablo or azndragon! mine looks a lot better and.... it's cooler! heh, it's true, ask echira!]
-- ItemLog Searching and Viewing [by echira and xmarv!] - Very useful system to view item logs and keep an eye on your players and GMs
-- GMs can view items in carts and storage, as opposed to just inventory [by echira!!]
-- Password Change script is fixed, it actually changes your password
-- Script that allows the players to reset the clothes dye, in case they're getting errors; script that lets players reset their location (back to their save point), in case they get stuck (these two are really helpful to reduce stress on GMs)
-- Addition to the Guild Ladder, enables the guild leader to upload his/her own guild emblem to be displayed on the ladder
-- Richest Player ladder [by Tweak] -- like the Player Ladder, but shows them in order of zeny
-- Includes 3 different methods of account verification [by echira] - E-mail verification, GM verification, and no verification
-- Easier to configure conf.def [by echira!]
-- Comes with an easy to use installer to attach the required database
-- And, of course, it's a lot more secure than the original

That's not all, we're trying to think of more features.
Any suggestions are very welcome, we'll try our best to make this as useful as we can

Have you actually tested this? The ACP is programmed to make sure the user is offline in RO before being able to transfer money.

Alright, I've looked into that problem. I believe (but I am currently unable to test) that the problem is caused by the GOD-Login Account Server Emulator. I've heard that it has some problems with the t_user table. However, I have written a fix for it, and it will be included in our release of the new ACP.

edit: Do you happen to know if the server that you tested this on is using the GOD-Login emulator?

line 46 -> $result = mssql_query(" select * from login ",$login_db);

where i must modify maximun execution time out?

but... where i must declare it? (inside code) :? thank you in advance

Warning: mssql_query(): message: Sintaxis incorrecta cerca de la palabra clave 'AND'. login.php on line 58