Help needed for dropcalc testing.

law · Post by **law** » Fri Aug 11, 2006 4:35 am

would be a nice features for your dropcalc, just need to show this faultes every admin and gm

found a bug in you sql script. Line 10 USE `l2jdb`;

Not everyone runs his db with this name

law · Post by **law** » Fri Aug 11, 2006 4:48 am

okay got it runing

very nice job

law · Post by **law** » Fri Aug 11, 2006 4:49 am

got only one problem :

Warning: file(): open_basedir restriction in effect. File(/home/christian/l2j/gameserver/data/announcements.txt) is not within the allowed path(s): (/var/www/web2/:/var/www/phpmyadmin/:/var/www/confixx/html/gesperrt/) in

how to give him rights on taht folder ?

and another error when i search for mobs , in order keltir, and klick on silver nuggets then i get this error:

Warning: Missing argument 7 for mobcount() in /var/www/web2/html/dropcalc/config.php on line 643

Warning: Missing argument 7 for mobcount() in /var/www/web2/html/dropcalc/config.php on line 643

Warning: Missing argument 8 for mobcount() in /var/www/web2/html/dropcalc/config.php on line 643

Warning: Missing argument 9 for mobcount() in /var/www/web2/html/dropcalc/config.php on line 643

Warning: Missing argument 6 for mobcount() in /var/www/web2/html/dropcalc/config.php on line 643

Warning: Missing argument 7 for mobcount() in /var/www/web2/html/dropcalc/config.php on line 643

end so on

and another one is when i klick the arrow near field char it shows me all chars but this error msg is above:

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 216 in /var/www/web2/html/dropcalc/c-search.php on line 185

another one is when i list items and klick on the button where it shows me which char is holding such an item there comes:

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 38 in /var/www/web2/html/dropcalc/ci-search.php on line 224

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 38 in /var/www/web2/html/dropcalc/ci-search.php on line 225

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 38 in /var/www/web2/html/dropcalc/ci-search.php on line 226

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 38 in /var/www/web2/html/dropcalc/ci-search.php on line 227

Post by **msknight** » Fri Aug 11, 2006 5:46 am

law wrote:found a bug in you sql script. Line 10 USE `l2jdb`;

Can't change that dynamically. It's up to the person using it to change it before running the script.

The script is running as webadmin, (see the bit on setting up the permissions for the chat - then you'll find out the user name of your web system - and make them a member of the group that has permissions to the files.

keltir search problem - in i-count.php search for mobcount - the line should read ...
$mob_spwn = mobcount($mob_id,$db_location,$db_user,$db_psswd, $db_l2jdb, $dblog_location, $dblog_user, $dblog_psswd, $dblog_l2jdb);

law wrote:and another one is when i klick the arrow near field char

I'm not sure where you are here.

law wrote:when i list items and klick on the button where it shows me which char is holding such an item there comes:

That is a result of searching the characters table for the character name. Check that the character is still in your characters table ... maybe put an echo statement above the sqp variable assignment to make sure the variable $c_owner contains a valid character name? The function is working here.

I think I will introduce another tool to search for items that don't belong to characters, characters that don't belong to accounts, etc.

Post by **msknight** » Fri Aug 11, 2006 5:50 am

law wrote:and another one is when i klick the arrow near field char it shows me all chars but this error msg is above:

Found it. It relates to a search for the clanid number of a clan.

In c-search, at arouns line 186, there is a $ missing from the front of "result clan" the line should read ...

if (!$result_clan)

law · Post by **law** » Fri Aug 11, 2006 6:39 am

keltir search problem - in i-count.php search for mobcount - the line should read ...
$mob_spwn = mobcount($mob_id,$db_location,$db_user,$db_psswd, $db_l2jdb, $dblog_location, $dblog_user, $dblog_psswd, $dblog_l2jdb);

there is no i-count.php

got it its called i-search ^^

Post by **msknight** » Fri Aug 11, 2006 6:46 am

Sorry - i-search.php - I haven't had my coffee this morning.

Also, I'm having a problem with pattern matching in PHP. My usual perl stuff isn't working in preg_replace for some reason.

Basically, I've got a string and I want to strip it so that there are only alphanumerics and underscores in it (for the user name) What is the best way to do this in PHP please?

law · Post by **law** » Fri Aug 11, 2006 6:50 am

hm in c++ i would know some ways.

maybe this helps you a bit , but dont knowif its the right way.

http://de2.php.net/manual/en/function.p ... ch-all.php[/quote]

Post by **msknight** » Fri Aug 11, 2006 7:07 am

Found it ...
$usrnamechk2 = preg_replace('/[^a-z,^A-Z,^0-9,^_]/', '', $usrname);
I was being a dullard and using .. instead of - !!! I write too many languages

and don't drink enough coffee

law · Post by **law** » Fri Aug 11, 2006 7:08 am

also an error in cl-search.php

change this:

line 309: check_item channge to this
check_item($c_item, $db_location, $db_user, $db_psswd, $db_l2jdb, $dblog_location, $dblog_user, $dblog_psswd, $dblog_l2jdb);

law · Post by **law** » Fri Aug 11, 2006 7:16 am

another problem , when you klick on Mobs by Lvl and try to sort by Type you get an error , cant see the error there files to big for vi on shell ^^

edit: sort for mp dont works too

Post by **msknight** » Fri Aug 11, 2006 7:28 am

Are you using the datapack that has the separate spawns for day and night? If those columns aren't there, that could be what is causing the problem.

Sort for hp, mp isn't working because the "," is getting stripped out by the string check function at the bottom of config.php. I'll correct that. Thanks!

EDIT - Line at the bottom of config.php should read ...
$str = preg_replace('/[&;%$\/\|@<>#Â£]/','',$str);

law · Post by **law** » Fri Aug 11, 2006 7:34 am

replace solved tha problem

Post by **msknight** » Fri Aug 11, 2006 7:35 am

... and now I've got to go to work

... again. Keep posting anything you find, and I'll sort it out when I return home.

law · Post by **law** » Fri Aug 11, 2006 7:46 am

i will be back here on wednesday