Help needed for dropcalc testing.

If something doesn't fit in any other forum then post it here.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Locked
User avatar
MELERIX
L2j Veteran
L2j Veteran
Posts: 6667
Joined: Sat Sep 23, 2006 11:31 pm
Location: Chile
Contact:

Post by MELERIX »

now i use import accounts function in servers tools, and errors messages not show anymore, but now get other error XD

Could not retrieve from database: Unknown column 'warnlevel' in 'field list'

:roll:
msknight
Advanced User
Advanced User
Posts: 308
Joined: Wed May 10, 2006 11:40 am
Location: U.K.

Post by msknight »

These should be the fields in the knightdrop table ...

Code: Select all

Field         Type           Collation         
------------  -------------  -----------------  
name          varchar(45)    latin1_swedish_ci      
lastaction    int(11)        NULL               Y
token         varchar(10)    latin1_swedish_ci  
mapaccess     decimal(20,0)  NULL               
recipeaccess  decimal(20,0)  NULL               
boxingok      decimal(1,0)   NULL               
warnlevel     decimal(1,0)   NULL            
... are they alll there?

Also, don't forget to downlaod this image Image and put it in the images folder.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
User avatar
MELERIX
L2j Veteran
L2j Veteran
Posts: 6667
Joined: Sat Sep 23, 2006 11:31 pm
Location: Chile
Contact:

Post by MELERIX »

Thank you, now i add manually these fields to my knightdrop table:

boxingok decimal(1,0) NULL
warnlevel decimal(1,0) NULL

And trouble are solved, thank you ;)

But i have one question: why when i press "import logon accounts" these fields (boxingok, warnlevel) are erased automatically in knightdrop table ?

:roll:
msknight
Advanced User
Advanced User
Posts: 308
Joined: Wed May 10, 2006 11:40 am
Location: U.K.

Post by msknight »

MELERIX wrote:But i have one question: why when i press "import logon accounts" these fields (boxingok, warnlevel) are erased automatically in knightdrop table ?
The code drops and recreates the table. I missed out on updating the code. I'll get that done tonight when I get home from work.

Thanks for letting me know.

Michelle. :)
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
msknight
Advanced User
Advanced User
Posts: 308
Joined: Wed May 10, 2006 11:40 am
Location: U.K.

Post by msknight »

Hey ho - fixed. I've uploaded the new code now.

--- and it can now talk with the login server via telnet if you have it enabled. There are also some new settings in the config.php file for the logon telnet settings.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
Fulminus
L2j Veteran
L2j Veteran
Posts: 1554
Joined: Mon Oct 10, 2005 6:49 pm

Post by Fulminus »

msknight,
I noticed you openned a new thread for suggestions on your dropcalc, due to this thread growing too large. However, now both threads get replies :P
do you prefer it this way (i.e. does each of the 2 threads actually serve a different purporse and keeping them separate helps you be organized) or would you prefer that this thread gets locked and replies continue in the other thread?
Let me know. If you prefer, I can make a last reply here with a link to the other thread and then lock this thread for you.
BTW, I don't mind having 2 threads. I'm just offering to lock this for your own convinience, seeing how you must now respond to 2 threads ;)
I'm a joyful, merriful, playful, curious, young, little elf!!! :-)
I'm also a High(tech) Elf, (computer) wiz!
msknight
Advanced User
Advanced User
Posts: 308
Joined: Wed May 10, 2006 11:40 am
Location: U.K.

Post by msknight »

Hi Fulminus ... yes please ... lock this thread. I feel that this part of the drop calc is at an end and a new part is begining ... moving from drop calc to admin tool.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
User avatar
MELERIX
L2j Veteran
L2j Veteran
Posts: 6667
Joined: Sat Sep 23, 2006 11:31 pm
Location: Chile
Contact:

Post by MELERIX »

Exist any form to share (link's) to others user safely.

any form to prevent user info in hash link.

but example if i share a link to other player, this player can change my password :S <---- this is a security risk present in your tool :/

sorry my english, but i don't know how explaining this good.
msknight
Advanced User
Advanced User
Posts: 308
Joined: Wed May 10, 2006 11:40 am
Location: U.K.

Post by msknight »

The short answer is ... don't share the link.

It was written this way so that people who run many gameservers from the same logon server, can have a dropcalc open for each server, at the same time, even on different machines, without requiring a separate account.

I will build in a function which ties the logon session down to the IP address, however, and that should help. I will do that this weekend.

I hit a problem with many browsers coming with very tight security settings ... on some it is a real pain to set a cookie even. Popups are blocked, some stop cookies and Javascript from running ... real headache for security.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
User avatar
MELERIX
L2j Veteran
L2j Veteran
Posts: 6667
Joined: Sat Sep 23, 2006 11:31 pm
Location: Chile
Contact:

Post by MELERIX »

Thank you for answer ;)

Good luck with your work in this tool... :D

I'll be waiting for good news ;)
kadar
L2j Veteran
L2j Veteran
Posts: 152
Joined: Sun Apr 10, 2005 1:34 am

Post by kadar »

Locked