[Requests] Who needs ... ?

Page 2 of 7

10/10/2009 08:29 Zombe#16

Sorry, I wan't able to start working on this...
I am at my grandma's house, and, of course, she doesn't have Dreamweaver...
So I will start working on those as soon as I get home, and that will be in around 5 hours...
Peace. Gotta go water some potatoes.

10/10/2009 08:32 Decima#17

u have to have DW zombe :O

10/10/2009 08:42 janvier123#18

i want to marry DW :)
i LOVE it !!!

ok iam ckecking "freeskier4lif3" php code

EDIT: does it need to be ODBC ?
EDIT2: Give that script to zombe, hes got a cookie login, and i might need it for this

10/10/2009 10:30 gedimazs#19

Need script that entering User ID you can see what characters belongs to that user. Thx. And I know that Zombe has it, but can't find him online. :)

10/10/2009 10:36 janvier123#20

i have one also, ill post it

EDIT: zombe was too slow again so ..
gedimazs here is your script

[Only registered and activated users can see links. Click Here To Register...]

Call it: usercharacter.php !!

PHP Code:


			
<?php

// written by janvier123

// Please fill in your MSSQL Info

//<--! begin MSSQL info !-->

$mssql = array(

        'host' => "localhost",    // Normaly "localhost" or "XXX.XXX.XXX.XXX"

        'user' => "sa",            // Your username for MSSQL server, normaly "sa"

        'pass' => "server"        // Your password for MSSQL server

    );



//<--! end MSSQL info !-->

$accname = $_POST['accname'];





if ($_GET['step'] == ""){    

    echo'<center><Form Name ="form" action="usercharacter.php?step=2" Method ="POST">';

    echo'Enter <b>Account</b> Name<p>';

    echo'<input name="accname" type="text" value="">';

    echo'<br>';

    echo'<input type="hidden" name="select" value="1">';

    echo'<input name="submit" type="submit" value="Next ...">';

    echo'</form></center>';



} else if ($_GET['step'] == "2"){    

if($_POST['select']) {

    $accname = $_POST['accname'];



        echo "<center><form action='usercharacter.php?step=3' method='POST'>

            <table class='innertab'>

                <tr>

                    <td colspan='2' align='left'><b><u>Character(s) found! Please select one.</b></u></td>

                </tr>

                <tr>

                    <td colspan='2' align='left'>&nbsp;</td>

                </tr>

                <tr>

                    <td align='left'>Character Name</td>

                        <td><select name='accname'>"; 

                                $ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);

                                $result2 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_id = '".$accname."'",$ms_con); 

                                $row2 = mssql_fetch_row($result2); 



                                $result3 = mssql_query("SELECT character_name FROM character.dbo.user_character WHERE user_no = '".$row2[0]."'",$ms_con); 

                                while($row3 = mssql_fetch_row($result3)) 

                    

                        echo "<option value='".$row2[0]."'>".$row3[0]."</option>";

                        }

                    echo "</select></td>

            </tr>

            <tr>

                <td align='left' colspan='2'>

                    <input type='hidden' name='user_no' value='".$row2[0]."'>

                    <input type='submit' value='Show character stats'>

                </td>

            </tr>

        </table>

    </form></center>";    

    





    } else if ($_GET['step'] == "3"){    

//        ------------------------------

    if($_POST['user_no']) {



            $classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior"); 

            $statreset = array('0' => "Unused", '1' => "Used"); 

            $skillreset = array('0' => "Unused", '1' => "Used"); 

            

            $ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);

            

            // IF you dont have the "Reborn" table in your mssql database under character.dbo.user_character

            // please remove the "Reborn" from the list below.

            $result5 = mssql_query("SELECT character_no,user_no,dwExp,dwMoney,dwStoreMoney,wStr,wDex,wCon,wSpr,wRetPosX,wRetPosY,wRetMapIndex,wStatPoint,wSkillPoint,wLevel,byPCClass,wPKCount,wChaoticLevel,dwPVPPoint,wWinRecord,wLoseRecord,wDrawRecord,Reborn,bySkillClearCount,byStatClearCount,character_name,dwAdv FROM character.dbo.user_character WHERE user_no = '".$_POST['user_no']."'",$ms_con);

            $row5 = mssql_fetch_row($result5);

            echo "<center><br>

                <table class='innertab'>

                    <tr>

                        <td colspan='3' align='left'><b><u>Character Stats</b></u></td>

                    </tr>

                    <tr>

                        <td colspan='3' align='left'>&nbsp;</td>

                    </tr>

                    <tr>

                        <td align='left'>---------- Type ----------</td>

                        <td align='left'>---------- Current Stats ----------</td>

                    </tr>

                    <tr>

                        <td align='left'>Character Name</td>

                        <td align='left'>".$row5[25]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Experience</td>

                        <td align='left'>".$row5[2]."</td>

                    </tr>

                        <tr>

                        <td align='left'>Adv</td>

                        <td align='left'>".$row5[26]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Level</td>

                        <td align='left'>".$row5[14]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Class</td>

                        <td align='left'>".$classes[$row5[15]]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Str</td>

                        <td align='left'>".$row5[5]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Dex</td>

                        <td align='left'>".$row5[6]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Con</td>

                        <td align='left'>".$row5[7]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Spr</td>

                        <td align='left'>".$row5[8]."</td>

                    </tr>

                    <tr>

                        <td align='left'>DIL Inventory</td>

                        <td align='left'>".$row5[3]."</td>

                    </tr>

                    <tr>

                        <td align='left'>DIL Warehouse</td>

                        <td align='left'>".$row5[4]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Return Map</td>

                        <td align='left'>".$row5[11]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Free stats points</td>

                        <td align='left'>".$row5[12]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Free skill points</td>

                        <td align='left'>".$row5[13]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Total PvP</td>

                        <td align='left'>".$row5[18]."</td>

                    </tr>

                    <tr>

                        <td align='left'>PvP Obtained</td>

                        <td align='left'>".$row5[19]."</td>

                    </tr>

                    <tr>

                        <td align='left'>PvP Lost</td>

                        <td align='left'>".$row5[20]."</td>

                    </tr>

                    <tr>

                        <td align='left'>PvP Draw</td>

                        <td align='left'>".$row5[21]."</td>

                    </tr>

                    <tr>

                        <td align='left'>PK points</td>

                        <td align='left'>".$row5[16]."</td>

                    </tr>

                    <tr>

                        <td align='left'>Chaotic Level (IP)</td>

                        <td align='left'>".$row5[17]."</td>

                    </tr>";

            // IF you dont have the "Reborn" table in your mssql database under character.dbo.user_character

            // please remove the "Reborn" from the list below.

                    echo "

                        <tr>

                        <td align='left'>Reborn</td>

                        <td align='left'>".$row5[22]."</td>

                    </tr>

                        <tr>

                        <td align='left'>Skill Reset</td>

                        <td align='left'>".$skillreset[$row5[23]]."</td>

                    </tr>

                        <tr>

                        <td align='left'>Stats Reset</td>

                        <td align='left'>".$statreset[$row5[24]]."</td>

                    </tr>

                    <tr>

                    </tr>

                </table>

            </center>";

        }

    } 

?>

10/10/2009 13:30 gedimazs#21

Big fat thanks for the script !

10/10/2009 13:36 Zombe#22

Here, my version of the appointed characters listing script...

PHP Code:


			
<?php



/* -------------{The appointed characters listing page by Zombe}------------- */



$MSSQLserverIP = 'localhost'; // IP goes here

$MSSQLusername = 'sa'; // MSSQL username goes here

$MSSQLpassword = 'password'; // MSSQL password goes here





//        Don't edit below if you don't know what you are doing.





$link = mssql_connect ("$MSSQLserverIP", "$MSSQLusername", "$MSSQLpassword");

if(!$link)

{

    die('Something went wrong while connecting to MSSQL');

}



echo'<center>';

echo'<Form Name ="form0" Method ="POST">';

echo'Enter an account name:<p>';

echo'<input name="name" type="text"><p>';

echo'<input name="submit" type="submit" value="Get character list!"><p>';

echo'</form0>';

$name = $_POST['name'];



if ($name)

{

    $result2 = mssql_query("SELECT * FROM account.dbo.Tbl_user WHERE user_id = '$name'",$link);

    $row2 = mssql_fetch_array($result2);

    $user_no = "$row2[user_no]";

    $login = "$row2[login_time]";

    $logout = "$row2[logout_time]";

    if (($login) && ($logout) && ($login > $logout)) $status = 'Online';

    else $status = 'Offline';

    

    if ($user_no)

    {

        echo "

            <p>&nbsp<p>&nbsp<p>

            The account <b>$name</b> has the following characters:<br><table border='1'><p>&nbsp

            <tr>

            <td align='center'><b>Char. No</b></td>

            <td align='center'><b>Char. Name</b></td>

            <td align='center'><b>Level</b></td>

            <td align='center'><b>Class</b></td>

            <td align='center'><b>Map index</b></td>

            <td align='center'><b>Status</b></td>

            </tr>

        ";

    }

    else echo 'No such account';

    

    $result = mssql_query("SELECT * FROM character.dbo.user_character WHERE user_no = '$user_no'",$link);

    while ($record = mssql_fetch_array($result))

    {

        if ($record[byPCClass] == 0) $class = 'Azure Knight';

        if ($record[byPCClass] == 1) $class = 'Segita Hunter';

        if ($record[byPCClass] == 2) $class = 'Incar Magician';

        if ($record[byPCClass] == 3) $class = 'Vicious Summoner';

        if ($record[byPCClass] == 4) $class = 'Segnale';

        if ($record[byPCClass] == 5) $class = 'Bagi Warrior';

        if ($record[byPCClass] == 6) $class = 'Aloken';

        if (($record[login_time]) && ($record[logout_time]) && ($record[login_time] > $record[logout_time])) $status = 'Online';

        else $status = 'Offline';

        

        echo "

            <tr>

            <td align='center'>$record[character_no]</td>

            <td align='center'>$record[character_name]</td>

            <td align='center'>$record[wLevel]</td>

            <td align='center'>$class</td>

            <td align='center'>$record[wMapIndex]</td>

            <td align='center'>$status</td>

            </tr>

        ";

    }

}

?>

Preview:

Spoiler

EDIT: Back from grandma, yaaaay! ^_^
EDIT2: Made it show character_no.

10/10/2009 14:02 lol2k1#23

Quote:

Originally Posted by janvier123

i said USEFULL comments !
not retarded ones

PHP Code:

$q = "SELECT * FROM account.dbo.USER_PROFILE WHERE login_flag = '1100'"; $r = mssql_query($q); $sad = mssql_num_rows($r); echo "<div align=left>Total Characters Online: $sad";

like that ?
srr i use my own code, i know there are other ways :)

sorry but i am not here to test u or anything .
i want that script and u opened this topic to help .
so if u cant make this script for me so tell me that i cant do .
dont tell me that my comment is retarded .

EDIT :
any chance to make my script plz ?

10/10/2009 14:18 Zombe#24

Online characters listing script, as requested.

PHP Code:


			
<?php

/* -------------{The online characters listing page by Zombe}------------- */



$MSSQLserverIP = 'localhost'; // IP goes here

$MSSQLusername = 'sa'; // MSSQL username goes here

$MSSQLpassword = 'password'; // MSSQL password goes here





//        Don't edit below if you don't know what you are doing.





$link = mssql_connect ("$MSSQLserverIP", "$MSSQLusername", "$MSSQLpassword");

if(!$link)

{

    die('Something went wrong while connecting to MSSQL');

}





echo "

    <center>

    <b><font size = 5>Online characters list:</font><b><br><table border='1'><p>&nbsp

    <tr>

    <td align='center'><b>Char. Name</b></td>

    <td align='center'><b>Account</b></td>

    <td align='center'><b>Class</b></td>

    <td align='center'><b>Level</b></td>

    <td align='center'><b>Map</b></td>

    </tr>

";





$result = mssql_query("SELECT * FROM character.dbo.user_character WHERE login_time > logout_time",$link);

while ($record = mssql_fetch_array($result))

{

    if ($record[byPCClass] == 0) $class = 'Azure Knight';

    if ($record[byPCClass] == 1) $class = 'Segita Hunter';

    if ($record[byPCClass] == 2) $class = 'Incar Magician';

    if ($record[byPCClass] == 3) $class = 'Vicious Summoner';

    if ($record[byPCClass] == 4) $class = 'Segnale';

    if ($record[byPCClass] == 5) $class = 'Bagi Warrior';

    if ($record[byPCClass] == 6) $class = 'Aloken';

    $user_no = $record[user_no];

    $result3 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_no = '$user_no'",$link);

    $row3 = mssql_fetch_array($result3);

    $account = "$row3[user_id]";

    echo "

        <tr>

        <td align='center'>$record[character_name]</td>

        <td align='center'>$account</td>

        <td align='center'>$class</td>

        <td align='center'>$record[wLevel]</td>

        <td align='center'>$record[wMapIndex]</td>

        </tr>

    ";

}

?>

Preview:

Spoiler

EDIT: I'll get on lol2k1's script now, even if I don't like that guy at all...

10/10/2009 14:34 gedimazs#25

New quest for Zombe and janvier123. Make the script that admin could send messages to players from web and write announcements from web.

I think send messages it is possible to make, but it will be harder to make announcements writting when you are not connected to the game :)
Good luck guys.

10/11/2009 15:13 lol2k1#26

i already asked to make script and u ignored .
so FAIL

10/11/2009 16:46 powerfear#27

Quote:

Originally Posted by lol2k1

i already asked to make script and u ignored .
so FAIL

Are you retarded?

Quote:

Originally Posted by Zombe

Online characters listing script, as requested.
EDIT: I'll get on lol2k1's script now, even if I don't like that guy at all...

look at Zombe edit it was made before your post he didn't ignored you..

10/11/2009 16:47 seias#28

what about Edit characters , like Hp, dil, MP , name , reborn , dill, stats etc ...

10/11/2009 18:44 Zombe#29

Quote:

Originally Posted by seias

what about Edit characters , like Hp, dil, MP , name , reborn , dill, stats etc ...

Hmm, ok, that I can make, but I am going away from the PC, so I will start on it tomorrow.

And about that aloken script, creating a character not in-game is quite hard, how about...
Creating any character in-game, specifying the name and changing it to aloken? With username and password verification of course, and works only on level 1 characters... That's good enough?

10/11/2009 19:59 2bartz#30

Quote:

Originally Posted by Zombe

how about...
Creating any character in-game, specifying the name and changing it to aloken? With username and password verification of course, and works only on level 1 characters... That's good enough?

yay prolly nice suggestion on the script to release cant wait.. :mofo:

Page 2 of 7

Last »