Seven Signs Question

[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 :/

[jurchiks]

just check the table

[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 = charid
cabal = dawn, dusk, gnosis or seal ?
seal = no clue

[jurchiks]

not the .sql file, the table from your live server

[Jesus.M]

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.

[jurchiks]

well then somebody post an example, got problems with connection to my server :@

[Kedon]

Yes that would me nice please

[Kedon]

Guys ? Could someone post some examples from seven_signs ? Like 10 differents if possible

[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