site problem!!!plz help

[snoremc]

guys...i have a problem with my l2 site...it is registered with no-ip.biz.

well the problem is that i can open the site in lan, but i cant in internet...(i have 2 pc's on 1 router)

plz help me guys...i need you...

 

tnx

 

p.s.: if you want any info ask me!!!

[JustLikeMe]

Check the previous page for my edited post. I don't know about any start.bat you've made one? post the batch code here. Think what you've changed before 3 days.

[snoremc]

well...can you try visit my website???

[JustLikeMe]

No the site doesnt exist. Well i dont know how they can log into ur site if they connect to the same dynamic link. It doesnt make sense, it doesnt stack. Your users log into the server, not in the IP. Except if u got .php files that connect with sql. So find another webhost provider. Plus i think no-ip gives domains for money

[snoremc]

well...cause i am a bit noob in all this...can you explain to me what do u mean by saying: Except if u got .php files that connect with sql

what exactly are the .php files, and how can i found them?

[JustLikeMe]

php is a programing language like html, java, . . . With it you can make the file to access your sql (of course with the username and password) and find anything u want from the tables in ur DB based on the code.

Edit: An examble for server stats in ur server.

This connects to your sql db

stats.php:

<?php

 

   $db_user = "root";

   $db_pass = "XXX";

   $db_name = "l2jdb";

   $db_serv = "XXXXX.no-ip.biz";

 

   $res = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]");

   $resdb = mysql_select_db ( "$db_name",$res );

 

   return $res;

 

?>

 

Now with this you take the info from stats.php and connects to sql DB with it + it shows in the site the statistics (the content of the tables. It accesses the sql tables and transfers the info.

Server Statistics:

<?php include "config/stats.php" ?>

<?php

 

mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error());

 

mysql_select_db($db_name) or die(mysql_error());

 

//Online Players

$query = ("SELECT * FROM characters WHERE online=1 and accesslevel>=0");

 

$result = mysql_query($query) or die(mysql_error());

 

$num2=mysql_numrows($result);

$sum=$num2;

 

//Total Accounts

$query = ("SELECT * FROM accounts WHERE access_level>=0");

 

$result = mysql_query($query) or die(mysql_error());

 

$acc2=mysql_numrows($result);

 

 

//Total Characters

$query = ("SELECT * FROM characters WHERE accesslevel>=0");

 

$result = mysql_query($query) or die(mysql_error());

 

$char2=mysql_numrows($result);

 

 

//Alliance

$query = ("SELECT * FROM clan_data WHERE ally_id!=\"\"");

 

$result = mysql_query($query) or die(mysql_error());

 

$alliance2=mysql_numrows($result);

 

 

//Clan

$get_config_data="SELECT clan_id FROM clan_data";

 

$query = ("SELECT clan_id FROM clan_data WHERE clan_id>0");

 

$result = mysql_query($query) or die(mysql_error());

 

$clan2=mysql_numrows($result);

 

 

mysql_close();

 

mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error());

 

mysql_select_db($db_name) or die(mysql_error());

?>

Total Accounts: <?php print ("$acc2"); ?><br>

Total Characters: <?php print ("$char2"); ?><br>

Total Aliances: <?php print ("$alliance2"); ?><br>

Total Clans: <?php print ("$clan2"); ?><br>

 

e.g. u can make sql file to access the characters table and if theres the number 1 in the online category (means the player is on 0 is off) it shows the players that are online.

[snoremc]

xmmm...ok...and where can i find this file, so i can fix it???

oh...god...i forgot to tell you that the pc was at another lan...is this a problem?e.x. the server ip there was: 192.168.1.33, and mine is 192.168.2.5...i fix the server internal ip as mine at the files: server.config and loginserver.config of course...but could this stop the site???

[JustLikeMe]

Check my edited post in this page for php examples.

xmmm...ok...and where can i find this file, so i can fix it???

oh...god...i forgot to tell you that the pc was at another lan...is this a problem?e.x. the server ip there was: 192.168.1.33, and mine is 192.168.2.5...i fix the server internal ip as mine at the files: server.config and loginserver.config of course...but could this stop the site???

 

So you got 2 pcs. The one is for the server and you connect ur ip with the no-ip for users to be able to connect and the other for playing or whatever. If you say that you could see the site from lan means that you could see it from the server - pc. Dunno if it needs internal internet ip(1 wireless that  2 pcs uses it) or internal lan ip(means your pcs are connected with a cable.(=καλώδιο)).

 

Edit: Theres no such thing with same dynamic ip site that users can log.

1. Change webhost provider.

2. Use/search php files or find already made sites with php files.

I suggest that you don't enable your telnet from server + sql because anyone will be able to access it thro the internet, if he knows the ip (he can find it easily) and the username+password. As php files do. Except if you have changed the root password and have a good password, but still a hacker can brute force it. Thing that i dont think it will happen. If he accesses your db he can do everything. Make an account, a character in the account, set master access level e.g. 200 and then bye bye. Rollback (backup) saves you.

[snoremc]

can you gimme the location of data.php, please???

[JustLikeMe]

what do u mean data.php?