Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Ijji Website problem

Initiate Mage
Joined
Jun 13, 2011
Messages
76
Reaction score
0
there is problem in ijji gunz website in
/gunz/ijji_player.php
the problem is if you click on this website

without the number of player CID
you will see SQL Error
image ( example )
Untitled - Ijji Website problem - RaGEZONE Forums
and it's the same with clans
/gunz/ijji_clan.php
image ( example )
Untitled1 - Ijji Website problem - RaGEZONE Forums

i think i can make it with website redirect but i dont find any php website redirect code
So please help me
 

Attachments

You must be registered for see attachments list
Initiate Mage
Joined
Jan 22, 2013
Messages
49
Reaction score
9
there is problem in ijji gunz website in
/gunz/ijji_player.php
the problem is if you click on this website

without the number of player CID
you will see SQL Error
image ( example )
View attachment 121941
and it's the same with clans
/gunz/ijji_clan.php
image ( example )
View attachment 121942

i think i can make it with website redirect but i dont find any php website redirect code
So please help me

Can you give me the code? so i can take a look into it?
 
Upvote 0
DRGunZ 2 Creator
Member
Joined
Jan 21, 2007
Messages
4,493
Reaction score
161
First pic: Edit gunz/ijji_players.php lines 2-26 with this:
PHP:
    <?
    $cid = clean($_GET['info']);
    $res = mssql_query("SELECT * FROM Character WHERE CID = '$cid'");
    $char = mssql_fetch_assoc($res);

    $res2 = mssql_query("SELECT * FROM Character a, Account b WHERE a.AID=b.AID AND CID = '$cid'");
    $char2 = mssql_fetch_assoc($res2);
    
    $res3 = mssql_query("SELECT * FROM ClanMember WHERE CID = '".$char['CID']."'"); 
    $clan = mssql_fetch_assoc($res3);
    $res4 = mssql_query("SELECT * FROM Clan WHERE CLID = '".$clan['CLID']."'"); 
    $claninfo = mssql_fetch_assoc($res4);

    if($claninfo == "")
       $claninfo = "-"; 

    mssql_query("UPDATE Character SET Views = Views + 1 WHERE CID = '$cid'");
    
    $data = explode("/", $char2['RegDate']);
    $mes = $data[1];
    $dia = $data[0];
    $ano = $data[2];
    $data = ( isset($dia) && isset($mes) && isset($ano) ) ? $dia."/".$mes."/".$ano : "";

?>

Second pic:
Edit gunz/ijji_players.php replace line 115 with this:
PHP:
 $query2 = mssql_query("SELECT * FROM ClanMember WHERE CLID = '$clid'");
That should work.
 
Upvote 0
Back
Top