[help]pos sindeo tin data base me to site gia na ftiaksune acc apo to site

[skills]

gia sas tha ithela na matho pos sindeo to site me tin data base ose na ftiaxnun acc apo to site.

[PsyCho0]

gia sas tha ithela na matho pos sindeo to site me tin data base ose na ftiaxnun acc apo to site.

katarxas prepei na 3eris oti to site perpei na exei morfi .php

sou dino to code pou prepei na peraseis sto site kai na sindesis tin db

<?php
  define('mySQL_hostname', '127.0.0.1');  //database IP
  define('mySQL_database', 'Database');  //database name
  define('mySQL_username', 'User');  //database user
  define('mySQL_password', 'Pass');  //database password

  function l2j_encrypt($password) 
    {
        return base64_encode(pack("H*", sha1(utf8_encode($password))));
    }

  $str =  l2j_encrypt($_POST['pass']);

  $user = $_POST["name"];

  $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
    or die( 'Error connecting to mysql<br><br>'.mysql_error() );

  $db_select = mysql_select_db( mySQL_database, $db_link )
    or die( 'Error connecting to Database<br><br>'.mysql_error() );

  if ($user == '') { print'Incorrect UserID'; mysql_close(); }
  else {
  $db_add = mysql_query( "INSERT INTO `accounts` VALUES ('$user', '$str', '0', '0', '')" )
    or die( 'Error: '.mysql_error() );
  }
  print 'Account Created<br><br>Enjoy youre gameplay.';
  mysql_close();
?>

 

to 2o Gia server Status!

<?php
    print'<table width="150">';
    $server  = "127.0.0.1";
    $portg   = "7777";
    $portl   = "9014";
    $timeout = "5";

    if ($server and $port and $timeout) {
        $game =  @fsockopen("$server", $portg, $errno, $errstr, $timeout);
        $login =  @fsockopen("$server", $portl, $errno, $errstr, $timeout);
    }
    print'<tr><td align="center"><strong>Server Status</strong></td></tr>';
    if($login) { print'<tr><td>Login:</td><td><font color="#00FF00"><strong> Online</strong></font><br><br></td></tr>'; }
    else { print'<tr><td>Login:</td><td><font color="#FF0000"><strong> Offline</strong></font><br><br></td></tr>'; }
    if($game) { print'<tr><td>Game:</td><td><font color="#00FF00"><strong> Online</strong></font></td></tr>'; }
    else { print'<tr><td>Game:</td><td"><font color="#FF0000"><strong> Offline</strong></td></tr>'; } 
    print'</table>';
?>

 

meta apo auto vazoume auto sto index!

            <form action="acc.php" method=post>
                        UserID:<input type="text" name="name" size 20><br><br>
                        Password:<input type="password" name="pass" size 20><br><br>
                         <input type=submit name="submit" value="Login">
            </form>

kai to 3o Gia Online Players!!

<?php
//first you need to define db info
  define('mySQL_hostname', '127.0.0.1');  //database IP
  define('mySQL_database', 'Database');  //database name
  define('mySQL_username', 'User');  //database user
  define('mySQL_password', 'Pass');  //database password

//connects to mysql
  $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
    or die( 'Error connecting to mysql<br><br>'.mysql_error() );

//connects to Database
  $db_select = mysql_select_db( mySQL_database, $db_link )
    or die( 'Error connecting to Database<br><br>'.mysql_error() );

//selects desired table
   $chars=mysql_query("SELECT * FROM characters");

//tells how much rows are there (will come helpfull with while loops)
   $rows =mysql_numrows($characters);

   $i=0;
   $x=0;

//while $i is smaller than number of rows repeat the code
   while ($i < $rows) {
    $online=mysql_result($chars,$i,"online"); //looks into characters table, under column online(if player is online its "0" else "1"), at row $i
    if ($online == 1) { $x++; } // if column online at row $i is "1", increase $x
    $i++; //increase $i
    }
   print 'Online players:<em>'.$x.'<em>'; //prints out the $x number of players online
?>

Eplizw na se voi8isa sou edwsa kai 2 parapano ama 8es ta vazis ;) GL

[skills]

katarxas prepei na 3eris oti to site perpei na exei morfi .php

sou dino to code pou prepei na peraseis sto site kai na sindesis tin db

<?php
  define('mySQL_hostname', '127.0.0.1');  //database IP
  define('mySQL_database', 'Database');  //database name
  define('mySQL_username', 'User');  //database user
  define('mySQL_password', 'Pass');  //database password

  function l2j_encrypt($password) 
    {
        return base64_encode(pack("H*", sha1(utf8_encode($password))));
    }

  $str =  l2j_encrypt($_POST['pass']);

  $user = $_POST["name"];

  $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
    or die( 'Error connecting to mysql<br><br>'.mysql_error() );

  $db_select = mysql_select_db( mySQL_database, $db_link )
    or die( 'Error connecting to Database<br><br>'.mysql_error() );

  if ($user == '') { print'Incorrect UserID'; mysql_close(); }
  else {
  $db_add = mysql_query( "INSERT INTO `accounts` VALUES ('$user', '$str', '0', '0', '')" )
    or die( 'Error: '.mysql_error() );
  }
  print 'Account Created<br><br>Enjoy youre gameplay.';
  mysql_close();
?>

 

to 2o Gia server Status!

<?php
    print'<table width="150">';
    $server  = "127.0.0.1";
    $portg   = "7777";
    $portl   = "9014";
    $timeout = "5";

    if ($server and $port and $timeout) {
        $game =  @fsockopen("$server", $portg, $errno, $errstr, $timeout);
        $login =  @fsockopen("$server", $portl, $errno, $errstr, $timeout);
    }
    print'<tr><td align="center"><strong>Server Status</strong></td></tr>';
    if($login) { print'<tr><td>Login:</td><td><font color="#00FF00"><strong> Online</strong></font><br><br></td></tr>'; }
    else { print'<tr><td>Login:</td><td><font color="#FF0000"><strong> Offline</strong></font><br><br></td></tr>'; }
    if($game) { print'<tr><td>Game:</td><td><font color="#00FF00"><strong> Online</strong></font></td></tr>'; }
    else { print'<tr><td>Game:</td><td"><font color="#FF0000"><strong> Offline</strong></td></tr>'; } 
    print'</table>';
?>

 

meta apo auto vazoume auto sto index!

            <form action="acc.php" method=post>
                        UserID:<input type="text" name="name" size 20><br><br>
                        Password:<input type="password" name="pass" size 20><br><br>
                         <input type=submit name="submit" value="Login">
            </form>

kai to 3o Gia Online Players!!

<?php
//first you need to define db info
  define('mySQL_hostname', '127.0.0.1');  //database IP
  define('mySQL_database', 'Database');  //database name
  define('mySQL_username', 'User');  //database user
  define('mySQL_password', 'Pass');  //database password

//connects to mysql
  $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
    or die( 'Error connecting to mysql<br><br>'.mysql_error() );

//connects to Database
  $db_select = mysql_select_db( mySQL_database, $db_link )
    or die( 'Error connecting to Database<br><br>'.mysql_error() );

//selects desired table
   $chars=mysql_query("SELECT * FROM characters");

//tells how much rows are there (will come helpfull with while loops)
   $rows =mysql_numrows($characters);

   $i=0;
   $x=0;

//while $i is smaller than number of rows repeat the code
   while ($i < $rows) {
    $online=mysql_result($chars,$i,"online"); //looks into characters table, under column online(if player is online its "0" else "1"), at row $i
    if ($online == 1) { $x++; } // if column online at row $i is "1", increase $x
    $i++; //increase $i
    }
   print 'Online players:<em>'.$x.'<em>'; //prints out the $x number of players online
?>

Eplizw na se voi8isa sou edwsa kai 2 parapano ama 8es ta vazis ;) GL

efxaristo para poli nase kala.

[mpouki]

Ean to site einai se morfi, html, pws mporw na to kanw???? Den mou einai .php :/....

Euxaristw ek twn protairwn...

[skills]

Ean to site einai se morfi, html, pws mporw na to kanw???? Den mou einai .php :/....

Euxaristw ek twn protairwn...

ela de ute ego to katafera gt malon thelo olokliro guide gia na sindeso tin data base me to site gia account

[skills]

pedia iparxi kana guide pos tha kanume account apo to site prospatho na to vro edo ke kati mines ala tespa na fandastite ematha ala pola gia site ke afto akoma na to vro please help gt me afto pano den vgazo akri gt apo vlepo theli ke ales diadikasies

[Pinaepple]

pedia iparxi kana guide pos tha kanume account apo to site prospatho na to vro edo ke kati mines ala tespa na fandastite ematha ala pola gia site ke afto akoma na to vro please help gt me afto pano den vgazo akri gt apo vlepo theli ke ales diadikasies

t paidi pano s edwse ta code..

[skills]

t paidi pano s edwse ta code..

ine ligo berdema pistepseme gt alazis ke apo database ala den ksero ti alazis eki ke pos ta kanis tha itane iperoxo me ena guide aloste exo prospathisi poles fores ala den to exo kataferi

[LioNtaraki]

bres ena site diksw kai kane apoki o diksw sideete stin db

[skills]

bres ena site diksw kai kane apoki o diksw sideete stin db

exo site gia test to exo plirosi gia 2 xronia

[TEOGR_hItMaKeR]

Ayto ginete me site me diskw .......

Otan les exeis plirwsei 2 xronia ennoeis domain?

[skills]

Ayto ginete me site me diskw .......

Otan les exeis plirwsei 2 xronia ennoeis domain?

malista domain ke to elenxo meso smart ftp i linux ego prosopika to elenxo me smart ftp to opio vazo ke vgazo arxei apo to site

den ginete na sikoso to site kanonika apo to domain ke na sikoso mono to account manager apo disko ke na doso link meso site xd mia pou to anafera pos ginete na sikoso site apo disko iparxi afto episis?