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

skills · June 6, 2010

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

PsyCho0 · June 7, 2010

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 · June 11, 2010

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 · July 3, 2010

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

Euxaristw ek twn protairwn...

skills · July 3, 2010

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 · July 3, 2010

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 · July 3, 2010

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 · July 3, 2010

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 · July 3, 2010

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

skills · July 3, 2010

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

exo site gia test to exo plirosi gia 2 xronia

TEOGR_hItMaKeR · July 3, 2010

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

Otan les exeis plirwsei 2 xronia ennoeis domain?

skills · July 3, 2010

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?

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

Question

skills

11 answers to this question

Recommended Posts

PsyCho0

skills

mpouki

skills

skills

Pinaepple

skills

LioNtaraki

skills

TEOGR_hItMaKeR

skills

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store

Important Information