Release:: L2toolz Beta

Page 2 of 7 FirstFirst 1234567 LastLast
Results 16 to 30 of 101
  1. #16
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    Im wondering.. how did u get ur top.php to work.. wat connection did u use?

    but if ur working with linux..

    INSTALLING PHP

    1-. Download the PHP in this site (www.php.net)
    2-. tar -zxvf php-5.0-ORC3.tar.gz
    3-. cd php-5.0-ORC3
    4-. ./configure --with-apxs2=/etc/httpd/bin/apxs --enable-versioning --with-mssql=/usr/local/freetds --disable-libxml
    5-. make
    6-. make install
    7-. cp php.ini-DIST /usr/local/lib
    8-. Add the next line in /etc/httpd/conf/httpd.conf
    AddType application/x-httpd-php .php

    TESTING

    <html>
    <body>
    <?php
    $con = mssql_connect ("<ip of the server SQL>", "sa", "");
    mssql_select_db ("<Data Base>", $con);
    $sql= "SELECT * FROM <Table>";
    $rs= mssql_query ($sql, $con);
    echo "The field number one is: ";
    echo mssql_result ($rs, 0, 0);
    mssql_close ($con);
    ?>
    </body>
    </html>
    correction... just checked the file list for linux/unix php files

    the files is called mssql.so not php_mssql.so
    should be found in ur /usr/lib/php4

    so editing php.ini
    extension=mssql.so
    (removing the comment tag (;) or adding it near the other extension files)

  2. #17
    Apprentice Systemer is offline
    MemberRank
    Apr 2005 Join Date
    Russia, MoscowLocation
    18Posts
    Quote Originally Posted by john_d
    Im wondering.. how did u get ur top.php to work.. wat connection did u use?

    but if ur working with linux..
    Chert!
    I should rebuid ALL php. Its no good. Time is money, but.. But I wil try. gcc forever :)

    Excuse me, which top.php do you mean?

    Quote Originally Posted by john_d
    Im wondering.. how did u get ur top.php to work.. wat connection did u use?

    but if ur working with linux..



    correction... just checked the file list for linux/unix php files

    the files is called mssql.so not php_mssql.so
    should be found in ur /usr/lib/php4

    so editing php.ini
    extension=mssql.so
    (removing the comment tag (;) or adding it near the other extension files)
    I got it.
    But , did you mean, that in php4.x.x (yeap. Which version php I need exactly?) included mssql.so by default?

  3. #18
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    http://195.91.250.50:3128/top.php

    ow it is on another machine.

    so ur planning to remote connect this. so if ur machine can accept mssql connection from another machine then there should be no problem... but if u cant

    u can try to create an ODBC DSN on ur linux machine or the same machine the website is running.

    ----------------

    well according ur phpinfo or linux machine.. ur php extension files are in /usr/lib/php4

    it is probably there. mssql is a mainstay extension for php.. just try enabling it in ur php.ini

    ow if u dont know wer ur php.ini is.. it is @ /etc/php.ini

  4. #19
    Apprentice Systemer is offline
    MemberRank
    Apr 2005 Join Date
    Russia, MoscowLocation
    18Posts
    Quote Originally Posted by john_d
    http://195.91.250.50:3128/top.php

    ow it is on another machine.

    so ur planning to remote connect this. so if ur machine can accept mssql connection from another machine then there should be no problem... but if u cant

    u can try to create an ODBC DSN on ur linux machine or the same machine the website is running.

    ----------------

    well according ur phpinfo or linux machine.. ur php extension files are in /usr/lib/php4

    it is probably there. mssql is a mainstay extension for php.. just try enabling it in ur php.ini
    Yes, top.php is under apache win32 :(
    I have the same problem with mssql connect where I setup registration page :(

    Why we havent l2 c2 under Linux? Isnt it? :)
    But in closest future I wil try run l2 c2 under Crossover Office. May be its way.
    Excuse me again, but another question: (I cant playing under mssql - becouse my area is mysql :) )

    I cant restore l2toolz.bak mssql database via mssql Ent. Manager :

    Too many backup device specified for backup or restore; only 64 are allowed. RESTORE DATABASE is terminated abnormaly.

  5. #20
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    ill try to make another backup.. maybe i missed something..

    try to make l2toolz beta work first.

  6. #21
    Apprentice Systemer is offline
    MemberRank
    Apr 2005 Join Date
    Russia, MoscowLocation
    18Posts
    Quote Originally Posted by john_d
    ill try to make another backup.. maybe i missed something..

    try to make l2toolz beta work first.
    Im already tried :) No changes :)

    Today is bad day. After 2toolz is installed, I lost my prev. registration page.
    195.91.250.50:3128 - clear white page.
    Shit.

  7. #22
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    it worked for me.. here is wat i did.

    created a DB called L2toolz
    Right click > restore >
    from file > browse to file.

    some options.. on advance i think, ( imusing ms management studio but mostly the same) u should the location of the L2toolz and L2toolz log to somewer that is real.. the default is c:\program files\mssql server ... blah blah blah.

    1 SUggestion though...

    u should just put L2toolz on ur server pc.. the one that has the apache and mssql. that should solve ur problem. lolz

  8. #23
    Apprentice Systemer is offline
    MemberRank
    Apr 2005 Join Date
    Russia, MoscowLocation
    18Posts
    Quote Originally Posted by john_d
    it worked for me.. here is wat i did.

    created a DB called L2toolz
    Right click > restore >
    from file > browse to file.

    some options.. on advance i think, ( imusing ms management studio but mostly the same) u should the location of the L2toolz and L2toolz log to somewer that is real.. the default is c:\program files\mssql server ... blah blah blah.

    1 SUggestion though...

    u should just put L2toolz on ur server pc.. the one that has the apache and mssql. that should solve ur problem. lolz
    So, thats ok, but the probem with restore l2toolz DB is open.
    I cant. Error the same.
    ---
    What I do:
    EM-->SRV-->databases--> make new--> L2Toolz
    then:
    right cick on Database L2toolz --> all tasks --> Restore Database -->
    in window:
    Restore - from device --> select devices --> add -> File name --> choose file location L2toolz.bak --> OK -> OK -then
    Options --> set logoca file names and phisical file names
    then OK
    and OK for restore

    But - error message is appeared

  9. #24
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    i could not find a problem with this part.. hehe ill try to use another pc later to see if restores there without problem.

    i could send u all the sql queries if u want. there is about 12 files u need to load to mssql.

    u can get the sql queries from my download folder now.

  10. #25
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    We got this RUNNING a while ago.

    installation about 20 mins.. trouble shooting for nonexistant problem 1hour.. lolz

    http://www.liilegacy.com:8080

  11. #26
    Member gutron is offline
    MemberRank
    May 2005 Join Date
    USA, West VirginiaLocation
    86Posts

    error

    i get this error

    Lineage2 World Database Error: DB Error: connect failed

    help plz i setup all the db's right i enabled the msql.dll thing to plz help me!

  12. #27
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    gimme link!

    Oh yeah!

    Attention:

    If ur Creating the ODBC dsn .. PLEASE CREATE WITH THIS INMIND!

    1. THe ODBC DSN names must be exactly the same with the one on the config.

    L2toolz is different from l2toolz
    - this will cause the L2toolz beta not to recognize ur ODBC and make connection errors.

    2. MAKE SURE U MAKE THEM IN SYSTEM DSN

    3. MAKE SURE THEY ARE NOT WINDOW AUTHENTICATION

    4. TEST CONNECT UR ODBC DSN !

    --------
    i HIGHLY RECOMMEND
    ODBC CONNECTION

    since with that. ur Clan Crest will appear.

  13. #28
    Novice s00r_s00r is offline
    MemberRank
    May 2005 Join Date
    RussinLocation
    4Posts
    Quote Originally Posted by Systemer
    So, thats ok, but the probem with restore l2toolz DB is open.
    I cant. Error the same.
    ---
    What I do:
    EM-->SRV-->databases--> make new--> L2Toolz
    then:
    right cick on Database L2toolz --> all tasks --> Restore Database -->
    in window:
    Restore - from device --> select devices --> add -> File name --> choose file location L2toolz.bak --> OK -> OK -then
    Options --> set logoca file names and phisical file names
    then OK
    and OK for restore

    But - error message is appeared
    i see error too :((

    2john_d, make pls L2toolz.sql
    Last edited by s00r_s00r; 16-06-05 at 11:01 AM.

  14. #29
    Alpha Member john_d is offline
    MemberRank
    Feb 2004 Join Date
    PhilippinesLocation
    2,868Posts
    i already did.. go to the web folder again

    http://johnd.mrqgamez.com

    ull see a zip file (L2toolz-sqlqueries.zip) with 4 folders inside

    just follow it... open 1st folder.. then 2nd and so on...

    u need to run then in that order so that.. u wont have problems with indexes.. since Mssql auto indexes the files

    fyi: thus u cant run itemnames.sql if u dont have data in item table, thus must first run the items.sql

  15. #30
    Novice s00r_s00r is offline
    MemberRank
    May 2005 Join Date
    RussinLocation
    4Posts
    Yes, it's work :))
    thank's :))



Page 2 of 7 FirstFirst 1234567 LastLast

Advertisement