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

Discussion in 'Support' started by Shawno0, Mar 10, 2018.

  1. Shawno0

    Shawno0 Member

    Joined:
    Dec 12, 2009
    Messages:
    101
    Likes Received:
    7
    Best Answers:
    0
    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 ^^
     
  2. Best Answer:
    Post #7 by Falacchi, Mar 14, 2018
  3. Shawno0

    Shawno0 Member

    Joined:
    Dec 12, 2009
    Messages:
    101
    Likes Received:
    7
    Best Answers:
    0
  4. slawkens

    slawkens Well-Known Member

    Joined:
    Aug 27, 2007
    Messages:
    2,722
    Likes Received:
    316
    Best Answers:
    45
    Which version of gesior are you using exactly? Where downloaded?
     
  5. Shawno0

    Shawno0 Member

    Joined:
    Dec 12, 2009
    Messages:
    101
    Likes Received:
    7
    Best Answers:
    0
  6. Shawno0

    Shawno0 Member

    Joined:
    Dec 12, 2009
    Messages:
    101
    Likes Received:
    7
    Best Answers:
    0
  7. slawkens

    slawkens Well-Known Member

    Joined:
    Aug 27, 2007
    Messages:
    2,722
    Likes Received:
    316
    Best Answers:
    45
    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?
     
  8. Falacchi

    Falacchi Member

    Joined:
    May 3, 2011
    Messages:
    71
    Likes Received:
    2
    Best Answers:
    3
    Best Answer
    It can be sampled in something related.
    Have you tried importing other schemas?
     
  9. Shawno0

    Shawno0 Member

    Joined:
    Dec 12, 2009
    Messages:
    101
    Likes Received:
    7
    Best Answers:
    0
    I haven't no, I used the schema from the Gesior site I linked :/
     
  10. Shawno0

    Shawno0 Member

    Joined:
    Dec 12, 2009
    Messages:
    101
    Likes Received:
    7
    Best Answers:
    0
    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 (Text):
    1. DELIMITER $$
    2. CREATE TRIGGER `initialQuests` AFTER INSERT ON `players` FOR EACH ROW BEGIN
    3.  
    4.     INSERT INTO player_storage VALUES
    5.    
    6.     (NEW.id, 12300,1),
    7.     (NEW.id, 12301,2),
    8.     (NEW.id, 12302,3),
    9.     (NEW.id, 12303,5),
    10.     (NEW.id, 12304,3),
    11.     (NEW.id, 12305,6),
    12.    
    13.    
    14.     (NEW.id, 50716,1),
    15.     (NEW.id, 50717,2),
    16.     (NEW.id, 50718,2),
    17.     (NEW.id, 50719,2),
    18.    
    19.    
    20.     (NEW.id, 12400,1),
    21.     (NEW.id, 12401,2),
    22.     (NEW.id, 12402,2),
    23.    
    24.    
    25.     (NEW.id, 12240,48),
    26.     (NEW.id, 12241,6),
    27.     (NEW.id, 12242,8),
    28.     (NEW.id, 12243,6),
    29.     (NEW.id, 12244,6),
    30.     (NEW.id, 12245,8),
    31.     (NEW.id, 12246,5),
    32.     (NEW.id, 12247,5),
    33.     (NEW.id, 12248,4),
    34.     (NEW.id, 12249,1),
    35.    
    36.    
    37.     (NEW.id, 100157,1),
    38.    
    39.    
    40.     (NEW.id, 12600,1),
    41.     (NEW.id, 12603,2),
    42.     (NEW.id, 12604,6),
    43.     (NEW.id, 12606,3),
    44.     (NEW.id, 12608,2),
    45.    
    46.    
    47.     (NEW.id, 12200,1),
    48.     (NEW.id, 12201,3),
    49.     (NEW.id, 12202,5),
    50.     (NEW.id, 12203,3),
    51.     (NEW.id, 12204,2),
    52.     (NEW.id, 12205,6),
    53.     (NEW.id, 12206,8),
    54.     (NEW.id, 12207,3),
    55.     (NEW.id, 12208,4),
    56.     (NEW.id,12209,1),
    57.    
    58.    
    59.     (NEW.id, 12160,20),
    60.     (NEW.id, 12161,7),
    61.     (NEW.id, 12162,3),
    62.     (NEW.id, 12163,6),
    63.     (NEW.id, 12164,3),
    64.     (NEW.id, 12165,3),
    65.     (NEW.id, 12166,3),
    66.    
    67.    
    68.    
    69.     (NEW.id,12130,25),
    70.     (NEW.id, 12131,3),
    71.     (NEW.id, 12132,6),
    72.     (NEW.id, 12133,3),
    73.     (NEW.id, 12134,2),
    74.     (NEW.id, 12135,7),
    75.     (NEW.id, 12136,3),
    76.     (NEW.id, 12137,3),
    77.     (NEW.id, 12138,2),
    78.     (NEW.id, 12139,1),
    79.    
    80.    
    81.     (NEW.id,50013,1),
    82.     (NEW.id,50014,1),
    83.     (NEW.id,50015,1),
    84.     (NEW.id,50016,1),
    85.     (NEW.id,50018,1),
    86.     (NEW.id,50019,1),
    87.    
    88.    
    89.     (NEW.id, 12700,1),
    90.     (NEW.id, 12707,1),
    91.     (NEW.id, 12703,1),
    92.     (NEW.id, 12710,4),
    93.    
    94.    
    95.     (NEW.id, 101,2),
    96.     (NEW.id, 102,5),
    97.     (NEW.id, 103,3),
    98.     (NEW.id, 104,3),
    99.     (NEW.id, 105,3),
    100.     (NEW.id, 106,2),
    101.     (NEW.id, 107,1),
    102.    
    103.    
    104.     (NEW.id, 12650,1),
    105.    
    106.    
    107.     (NEW.id, 12350,25),
    108.     (NEW.id, 12351,3),
    109.     (NEW.id, 12352,3),
    110.     (NEW.id,12353,3),
    111.     (NEW.id, 12354,3),
    112.     (NEW.id, 12355,3),
    113.     (NEW.id, 12356,4),
    114.     (NEW.id, 12357,6),
    115.     (NEW.id, 12358,1);
    116.    
    117. END
    118. $$
    119. DELIMITER ;
    Thanks :D
     
  11. Falacchi

    Falacchi Member

    Joined:
    May 3, 2011
    Messages:
    71
    Likes Received:
    2
    Best Answers:
    3
    Glad to help! O/
     

Share This Page

Loading...