• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

(Gesior, OTX Server 11.49) New Character created with completed quests?

Shawno0

Member
Joined
Dec 12, 2009
Messages
101
Reaction score
8
Hey Guys,

Having a bit of a weird issue, when creating a brand new character through the Gesior website, characters are being created with a tone of completed quests, so loads of Player_Storage tables..

I am assuming this is related to the website, as these are appearing before the account is even logged into the server, so the second you hit create character on the website, these tables are appearing in the DB.

I have been through every file and script I could think to check that could be related but am at a completely dead end with this! I've even used Text Crawler to go through the whole Data & htdocs directory but still I cannot find anything that's creating these tables!

Any hints would be greatly appreciated ^^
 
Solution
Hey Guys,

Having a bit of a weird issue, when creating a brand new character through the Gesior website, characters are being created with a tone of completed quests, so loads of Player_Storage tables..

I am assuming this is related to the website, as these are appearing before the account is even logged into the server, so the second you hit create character on the website, these tables are appearing in the DB.

I have been through every file and script I could think to check that could be related but am at a completely dead end with this! I've even used Text Crawler to go through the whole Data & htdocs directory but still I cannot find anything that's creating these tables!

Any hints would be greatly appreciated ^^

It can...
I didn't find anything related to modifying player_storage in this Gesior you posted. Are you sure its created on the website and not through server .lua script?
 
Hey Guys,

Having a bit of a weird issue, when creating a brand new character through the Gesior website, characters are being created with a tone of completed quests, so loads of Player_Storage tables..

I am assuming this is related to the website, as these are appearing before the account is even logged into the server, so the second you hit create character on the website, these tables are appearing in the DB.

I have been through every file and script I could think to check that could be related but am at a completely dead end with this! I've even used Text Crawler to go through the whole Data & htdocs directory but still I cannot find anything that's creating these tables!

Any hints would be greatly appreciated ^^

It can be sampled in something related.
Have you tried importing other schemas?
 
Solution
It can be sampled in something related.
Have you tried importing other schemas?
Falacchi, you're a genius!

I ran a search for player_storage in the schema file from the Gesior site, and found the below:

Code:
DELIMITER $$
CREATE TRIGGER `initialQuests` AFTER INSERT ON `players` FOR EACH ROW BEGIN

    INSERT INTO player_storage VALUES
   
    (NEW.id, 12300,1),
    (NEW.id, 12301,2),
    (NEW.id, 12302,3),
    (NEW.id, 12303,5),
    (NEW.id, 12304,3),
    (NEW.id, 12305,6),
   
   
    (NEW.id, 50716,1),
    (NEW.id, 50717,2),
    (NEW.id, 50718,2),
    (NEW.id, 50719,2),
   
   
    (NEW.id, 12400,1),
    (NEW.id, 12401,2),
    (NEW.id, 12402,2),
   
   
    (NEW.id, 12240,48),
    (NEW.id, 12241,6),
    (NEW.id, 12242,8),
    (NEW.id, 12243,6),
    (NEW.id, 12244,6),
    (NEW.id, 12245,8),
    (NEW.id, 12246,5),
    (NEW.id, 12247,5),
    (NEW.id, 12248,4),
    (NEW.id, 12249,1),
   
   
    (NEW.id, 100157,1),
   
   
    (NEW.id, 12600,1),
    (NEW.id, 12603,2),
    (NEW.id, 12604,6),
    (NEW.id, 12606,3),
    (NEW.id, 12608,2),
   
   
    (NEW.id, 12200,1),
    (NEW.id, 12201,3),
    (NEW.id, 12202,5),
    (NEW.id, 12203,3),
    (NEW.id, 12204,2),
    (NEW.id, 12205,6),
    (NEW.id, 12206,8),
    (NEW.id, 12207,3),
    (NEW.id, 12208,4),
    (NEW.id,12209,1),
   
   
    (NEW.id, 12160,20),
    (NEW.id, 12161,7),
    (NEW.id, 12162,3),
    (NEW.id, 12163,6),
    (NEW.id, 12164,3),
    (NEW.id, 12165,3),
    (NEW.id, 12166,3),
   
   
   
    (NEW.id,12130,25),
    (NEW.id, 12131,3),
    (NEW.id, 12132,6),
    (NEW.id, 12133,3),
    (NEW.id, 12134,2),
    (NEW.id, 12135,7),
    (NEW.id, 12136,3),
    (NEW.id, 12137,3),
    (NEW.id, 12138,2),
    (NEW.id, 12139,1),
   
   
    (NEW.id,50013,1),
    (NEW.id,50014,1),
    (NEW.id,50015,1),
    (NEW.id,50016,1),
    (NEW.id,50018,1),
    (NEW.id,50019,1),
   
   
    (NEW.id, 12700,1),
    (NEW.id, 12707,1),
    (NEW.id, 12703,1),
    (NEW.id, 12710,4),
   
   
    (NEW.id, 101,2),
    (NEW.id, 102,5),
    (NEW.id, 103,3),
    (NEW.id, 104,3),
    (NEW.id, 105,3),
    (NEW.id, 106,2),
    (NEW.id, 107,1),
   
   
    (NEW.id, 12650,1),
   
   
    (NEW.id, 12350,25),
    (NEW.id, 12351,3),
    (NEW.id, 12352,3),
    (NEW.id,12353,3),
    (NEW.id, 12354,3),
    (NEW.id, 12355,3),
    (NEW.id, 12356,4),
    (NEW.id, 12357,6),
    (NEW.id, 12358,1);
   
END
$$
DELIMITER ;

Thanks :D
 
Back
Top