Release:: L2toolz Beta

Page 1 of 7 1234567 LastLast
Results 1 to 15 of 101
  1. #1
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts

    Release:: L2toolz Beta

    With a Week of Hard coding and noncience... i finally decided to give it a go with L2toolz Beta edition.

    Notes:
    This Beta Release only has the Minimum amount of Features, oh well cause it is a test

    Quote Originally Posted by Release Notes
    How to Install:

    notes: if u dont know how to install a webserver, u dont deserve this.

    A. ( Ignore if U already have a Apache Webserver working with Php Pear DB )
    1. Download ( WAMP apache server ) or XAMPP Server ( if u dont know wer, try googling )
    2. Setup and Configure your server
    3. Install Pear DB by going to ur php directory and Running the Pear.bat file, just follow the instructions

    B. L2toolz general installation
    1. Download L2toolz

    2. Unzip to ur Web directory ( check http.conf for ur current web directory )

    3. Check settings,. open in browser the phpinfo.php ( this file is the l2toolz package, will update it soon )
    Php Variables: ( in phpinfo.php )
    -- include_path .;c:\wamp\php\pear .;c:\wamp\php\pear
    something like this,. note nessesarily exact. this is to check if pear is installed.
    if it is not then Go check A.3
    -- ZLib Support enabled
    this is just a gzip compression check

    4. ODBC install ( in L2toolz there is 3 (three)
    ODBC links or dsn that needed.
    - lin2world1 ( that is connected to ur lin2world database, must connect using the $dbuser and $dbpass
    values.
    - lin2db1 ( connected to ur lin2db, and like the first one connects via $dbuser/$dbpass values.
    - L2toolz ( not used in Beta, is used for Forum and Items/Npc/Skills and etc Databases. )
    So u need to create this oDBC links.


    5. Simple Config,. ( edit config.php ) on ur L2toolz folder.

    $IP = array(
    "Auth server:" => "xx.xx.xxx.xxx:2106",
    "Game server:" => "xx.x.xx.xxx:7777",
    );

    -- should explains itself. wer xx.xx.xxx.xx is the ip and the number is the port.
    -- this is for server check


    $dbuser = "sa"; //database username
    $dbpass = "xxxxxx"; //database password

    -- explains itself. these are used to connect to ur Database via ODBC

    $db2 =& DB::connect("odbc://$dbuser:$dbpass@lin2db1");
    if (PEAR::isError($db2)) {
    die("Error in Lineage 2 Db Database , Please Check Connection" . $db2->getMessage());
    **

    -- as u can see, L2toolz uses ODBC, so basically it means u can remote ur website to anywer which has ODBC to connect to connect to ur running/working database.
    -- Again $dbuser and $dbpass is used as the Username Password for the ODBC link
    -- lin2db1 < is the odbc system dsn name ... like i said on B.4 u need to create ODBC links.


    6. Now open ur website and see :)

    Features on this Beta release:

    1. Register page
    2. Server Stats/check
    3. World Map locator (with search and stuff)
    4. Rankings

    Notes: not all features are given since this is a beta release, and is only to give test on how the L2toolz will be further developed.

    Release Notes:

    Since this is a Ragezone Project. Please do not remove the ragezone.com Logo, Donations are accepted and appreciated. hehehe!

    If u have any question please direct them to forum.Ragezone.com (lineage2 section)
    or the L2toolz Builtin forum ( well it is not still 100% operation and inserted, but it should be ok ) http://johnd.mrqgamez.com/l2toolz/phpbb ( this should be the correct link to the forum for the L2toolz
    ( oh! yeah this forum is included in the L2toolz FULL edition )

    LInks:

    http://johnd.mrqgamez.com ::: For L2toolz beta download
    http://forum.ragezone.com ::: Support Forums
    http://johnd.mrqgamez.coml2toolz ::: Running Example for L2toolz Full edition
    QUICK LINKS DOWNLOAD:

    http://johnd.mrqgamez.com/index.php?...ile=l2beta.zip

    Please post here ur Problems with install and if u got it right.. congrats.. can i see the page then :)
    Last edited by john_d; 15-06-05 at 11:35 PM.


  2. #2
    Apprentice BAHEK is offline
    MemberRank
    May 2005 Join Date
    6Posts
    It requires something db.php, but it doesnt exist on my server, can u post it?

  3. #3
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    did u read the instruction...

    install PEAR!

  4. #4
    Apprentice BAHEK is offline
    MemberRank
    May 2005 Join Date
    6Posts
    there is folder "pear" but no DB.php

    Found it.
    Where can i change in script php folder?

    Changed : )
    It write
    "Error in Lineage 2 World Database , Please Check Connection: DB Error: not found"
    but i changed in config to mine ODBC
    Last edited by BAHEK; 14-06-05 at 11:14 AM.

  5. #5
    Member Brianbio is offline
    MemberRank
    Apr 2005 Join Date
    somewhereLocation
    63Posts
    nice job john as always :)

  6. #6
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    Quote Originally Posted by BAHEK
    there is folder "pear" but no DB.php

    Found it.
    Where can i change in script php folder?

    Changed : )
    It write
    "Error in Lineage 2 World Database , Please Check Connection: DB Error: not found"
    but i changed in config to mine ODBC

    did u read the error is says ur odbc doesnt exist. or not found.

    i suggest u make a new one. like wat i said in the intruction....


    Please if anyone got it to work.. please post a link.

  7. #7
    Valued Member Sundh is offline
    MemberRank
    Jan 2005 Join Date
    swedenLocation
    119Posts
    nice job john_d

  8. #8
    Enthusiast Smerch is offline
    MemberRank
    May 2005 Join Date
    MoscowLocation
    29Posts
    Error in Lineage 2 World Database , Please Check Connection: DB Error: connect failed

    what this?... help me please...

  9. #9
    Apprentice Systemer is offline
    MemberRank
    Apr 2005 Join Date
    Russia, MoscowLocation
    18Posts
    Quote Originally Posted by Brianbio
    nice job john as always :)
    Hi Gents

    Ive got some problems with connect to database :
    Error in Lineage 2 World Database , Please Check Connection: DB Error: connect failed

    For connection I use .dsn lin2db1 & lin2world1 (in the same paramaters with lin2db & lin2world).

    How I can solve this problem?

    You can try too :)
    http://lineageworld.ru/l2toolz/index.php?op=ranking

    system:

    [root@base ~]# apachectl -v
    Server version: Apache/2.0.52
    Server built: Nov 30 2004 11:22:20
    [root@base ~]# uname -a
    Linux xxx.lineageworld.ru 2.6.9-5.EL #1 Wed Jan 5 19:22:18 EST 2005 i686 i686 i386 GNU/Linux
    [root@base ~]# rpm -qa |grep pear
    php-pear-4.3.9-3.1
    [root@base ~]# rpm -qa|grep php
    php-snmp-4.3.9-3.1
    php-devel-4.3.9-3.1
    php-mysql-4.3.9-3.1
    php-4.3.9-3.1
    php-pgsql-4.3.9-3.1
    php-ldap-4.3.9-3.1
    php-gd-4.3.9-3.1
    php-mbstring-4.3.9-3.1
    php-ncurses-4.3.9-3.1
    php-domxml-4.3.9-3.1
    php-pear-4.3.9-3.1
    php-odbc-4.3.9-3.1
    php-imap-4.3.9-3.1
    php-xmlrpc-4.3.9-3.1
    [root@base ~]#


    And I sure, that I have no problems with firewall settings for connection between http server and game server.
    Last edited by Systemer; 15-06-05 at 01:48 PM.

  10. #10
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    hmmmm.. i have made modification to the connection settings.. on the config..

    u will have a choice on which on which type of connection to use..

    mssql or ODBC..

    l2toolz beta 0.1 will be ready for download in a few mins.

    There is 3 files.. u will need

    L2toolz-beta01.zip > this is the main file.
    L2toolz-database.zip > mssql restore file for L2toolz database (for items and etc)
    L2toolz-l2dp.zip > L2dp (item/skills database) an addon to the L2toolz

    This Beta v0.1 RELEASE

    is exactly the same as the on http://johnd.mrqgamez.com/l2toolz/index.php?op=ranking

    im troubleshooting why the CREST (clan logos) are not showing up on other people machines.. i think it has something to do with the binary decoding, since im just using a trick to make it look like it is showing logos form the, but actually all the info on the rankings are gotten via 1 MSSQL query, including the logos.

    Oh yeah..

    Dont be alarmed with the Page Generation TIme.. on the bottom of everypage.

    i just forcefully put it there so i can see how the site's generating speed on ur sites.

    ofcors on my pc.. it would be above 10s for rankings, since my pc is slow and database is half way around the world.

    but i think on ur server.. all pages will have less then a second to generate.
    Last edited by john_d; 15-06-05 at 11:38 PM.

  11. #11
    Apprentice Systemer is offline
    MemberRank
    Apr 2005 Join Date
    Russia, MoscowLocation
    18Posts
    Thanks, I will try now.

    Regarding the hosting: I can give you hosting for web free fo charge :)

  12. #12
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    Run the check.php file.. dude. i see ur mssql extension is not enabled.

  13. #13
    Apprentice Systemer is offline
    MemberRank
    Apr 2005 Join Date
    Russia, MoscowLocation
    18Posts
    No success
    :(

    If I set $db_conn_type = 1; (MSSQL)then I have:

    Lineage2 World Database Error: DB Error: extension not found

    and if I set $db_conn_type = 0; (ODBC)

    I see: Lineage2 World Database Error: DB Error: connect failed

    BUT:

    [root@base l2toolz]# telnet evo.lineageworld.ru 2106
    Trying 195.91.250.50...
    Connected to evo.lineageworld.ru (195.91.250.50).
    Escape character is '^]'.

    in_CZx^]
    telnet> quit
    Connection closed.
    [root@base l2toolz]# telnet evo.lineageworld.ru 7777
    Trying 195.91.250.50...
    Connected to evo.lineageworld.ru (195.91.250.50).
    Escape character is '^]'.
    ^]
    telnet> quit
    Connection closed.
    Last edited by Systemer; 15-06-05 at 04:47 PM.

  14. #14
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    Like i said above.. ur mssql extension is not.. enabled

    edit : php.ini ( some people have mutiple php.ini , that are conflicting, jsut edit them all to make sure)

    find

    ;extension php_mssql.so

    or

    ;extension php_mssql.dll

    just simple remove the ;

    then restart webserver...

    run check.php if it is successfully loaded.

  15. #15
    Apprentice Systemer is offline
    MemberRank
    Apr 2005 Join Date
    Russia, MoscowLocation
    18Posts
    I have no php_mssql.so
    Where I can get it?



Page 1 of 7 1234567 LastLast

Advertisement