Page 1 of 1
Seven Signs Question
Posted: Thu Apr 29, 2010 7:23 pm
by Kedon
If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision
4121:
L2JDP Revision
7321:
Hello Guys. I searched already in the Forum but i didn't really found an answer to my Question... Soooo my Question is: Is it possible to insert Charakters manually to Seven Signs ? Like INSET INTO seven_signs (charId, cabal) VALUES ... ? That would be cool because i worked alot on my Server and now i have some ppl but they can't enter Catacombs because it's not register time :/
Re: Seven Signs Question
Posted: Thu Apr 29, 2010 7:29 pm
by jurchiks
just check the table
Re: Seven Signs Question
Posted: Thu Apr 29, 2010 7:36 pm
by Kedon
What a helpfull answer
My table is empty so it helps not much
Code: Select all
CREATE TABLE IF NOT EXISTS `seven_signs` ( `charId` int(10) unsigned NOT NULL default '0', `cabal` varchar(4) NOT NULL default '', `seal` int(1) NOT NULL default '0', `red_stones` int(11) NOT NULL default '0', `green_stones` int(11) NOT NULL default '0', `blue_stones` int(11) NOT NULL default '0', `ancient_adena_amount` decimal(20,0) NOT NULL default '0', `contribution_score` decimal(20,0) NOT NULL default '0', PRIMARY KEY (`charId`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
=
charid
cabal =
dawn,
dusk,
gnosis or seal ?
seal = no clue
Re: Seven Signs Question
Posted: Thu Apr 29, 2010 7:48 pm
by jurchiks
not the .sql file, the table from your live server
Re: Seven Signs Question
Posted: Thu Apr 29, 2010 7:55 pm
by Jesus.M
jurchiks wrote:not the .sql file, the table from your live server
He just said that his table is empty - 0 registered, so he has nowhere to look any examples.
Re: Seven Signs Question
Posted: Fri Apr 30, 2010 7:51 am
by jurchiks
well then somebody post an example, got problems with connection to my server :@
Re: Seven Signs Question
Posted: Fri Apr 30, 2010 7:59 am
by Kedon
Yes that would me nice please
Re: Seven Signs Question
Posted: Fri Apr 30, 2010 2:03 pm
by Kedon
Guys ? Could someone post some examples from seven_signs ? Like 10 differents if possible
Re: Seven Signs Question
Posted: Fri Apr 30, 2010 2:19 pm
by jurchiks
charid=character's object id
cabal= dusk,dawn, empty line (no capital letters)
seal = 0, 1, 2 (you only get one after seal validation period afaik)
red,green,blue stones = amount of stones contributed
ancient_adena_amount = sum of all stones worth (red*10, green*5...)
contribution score = afaik the same as ancient_adena_amount, except that you need one of them empty (period differences)
in my server it's like this:
charid, dawn/dusk, 2/1 (gnosis or avarice), 0, 200000, 0, 1000000, 0 (seal color and amount may differ)
or
charid, empty line/dawn/dusk, 0/1/2, 0, 0, 0, 0, 0/some score
insert into seven_signs values
(charid,"dawn",2,0,0,0,any number);
should work