Welcome, Guest. Please login or register.

Author Topic: hello good can you help me I'm trying to enter a vip code and aio  (Read 164 times)

0 Members and 1 Guest are viewing this topic.

Offline progressive

  • L2jHellas User
  • *
  • Posts: 9
  • Country: ar
  • Karma: 0
I added the code once and it turned out fine I don't know what I'm doing wrong because I added it again and it doesn't turn out right now


here I leave the code
Code: [Select]
private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?, maxHp=?, curHp=?, maxCp=?, curCp=?, maxMp=?, curMp=?, str=?, con=?, dex=?, _int=?, men=?, wit=?, face=?, hairStyle=?, hairColor=?, heading=?, x=?, y=?, z=?, exp=?, expBeforeDeath=?, sp=?, karma=?, pvpkills=?, pkkills=?, rec_have=?, rec_left=?, clanid=?, maxload=?, race=?, classid=?, deletetime=?, title=?, accesslevel=?, online=?, isin7sdungeon=?, clan_privs=?, wantspeace=?, base_class=?, onlinetime=?, in_jail=?, jail_timer=?, newbie=?, nobless=?, power_grade=?, subpledge=?, last_recom_date=?, lvl_joined_academy=?, apprentice=?, sponsor=?, varka_ketra_ally=?, clan_join_expiry_time=?, clan_create_expiry_time=?, char_name=?, vip=?,vip_end=?, death_penalty_level=?, chat_filter_count=? WHERE obj_id=?";
private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally, clan_join_expiry_time, clan_create_expiry_time, death_penalty_level, hero, donator, vip,vip_end chatban_timer, chatban_reason, chat_filter_count FROM characters WHERE obj_Id=?";

ALTER TABLE `characters` ADD COLUMN `vip` decimal(1,0) NOT NULL DEFAULT 0 AFTER `donator`;
ALTER TABLE `characters` ADD COLUMN `vip_end` decimal(20,0) NOT NULL DEFAULT 0 AFTER `vip`;



Online AbsolutePower

  • Admin
  • Head Developer
  • L2jHellas User
  • ******
  • Posts: 380
  • Country: gr
  • Karma: 10
Re: hello good can you help me I'm trying to enter a vip code and aio
« Reply #1 on: November 09, 2022, 06:10:54 pm »
I added the code once and it turned out fine I don't know what I'm doing wrong because I added it again and it doesn't turn out right now


here I leave the code
Code: [Select]
private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?, maxHp=?, curHp=?, maxCp=?, curCp=?, maxMp=?, curMp=?, str=?, con=?, dex=?, _int=?, men=?, wit=?, face=?, hairStyle=?, hairColor=?, heading=?, x=?, y=?, z=?, exp=?, expBeforeDeath=?, sp=?, karma=?, pvpkills=?, pkkills=?, rec_have=?, rec_left=?, clanid=?, maxload=?, race=?, classid=?, deletetime=?, title=?, accesslevel=?, online=?, isin7sdungeon=?, clan_privs=?, wantspeace=?, base_class=?, onlinetime=?, in_jail=?, jail_timer=?, newbie=?, nobless=?, power_grade=?, subpledge=?, last_recom_date=?, lvl_joined_academy=?, apprentice=?, sponsor=?, varka_ketra_ally=?, clan_join_expiry_time=?, clan_create_expiry_time=?, char_name=?, vip=?,vip_end=?, death_penalty_level=?, chat_filter_count=? WHERE obj_id=?";
private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally, clan_join_expiry_time, clan_create_expiry_time, death_penalty_level, hero, donator, vip,vip_end chatban_timer, chatban_reason, chat_filter_count FROM characters WHERE obj_Id=?";

ALTER TABLE `characters` ADD COLUMN `vip` decimal(1,0) NOT NULL DEFAULT 0 AFTER `donator`;
ALTER TABLE `characters` ADD COLUMN `vip_end` decimal(20,0) NOT NULL DEFAULT 0 AFTER `vip`;


l2jhellas already have vip-donator system
« Last Edit: November 09, 2022, 07:58:35 pm by AbsolutePower »



Offline progressive

  • L2jHellas User
  • *
  • Posts: 9
  • Country: ar
  • Karma: 0
Re: hello good can you help me I'm trying to enter a vip code and aio
« Reply #2 on: November 10, 2022, 01:51:36 am »
I don't understand what you want to say I want to add the vip system


I adapted a vip system and an aio but I can't solve that part


you mistake the sorcel throws me
com.l2jhellas.gameserver.model.actor.instance.L2PcInstance: Could not store char base data:
« Last Edit: November 10, 2022, 02:36:49 am by progressive »

Online AbsolutePower

  • Admin
  • Head Developer
  • L2jHellas User
  • ******
  • Posts: 380
  • Country: gr
  • Karma: 10
Re: hello good can you help me I'm trying to enter a vip code and aio
« Reply #3 on: November 11, 2022, 06:38:08 pm »
I don't understand what you want to say I want to add the vip system


I adapted a vip system and an aio but I can't solve that part


you mistake the sorcel throws me
com.l2jhellas.gameserver.model.actor.instance.L2PcInstance: Could not store char base data:
error will be fixed in free revision soon,  you dont understand? go to rates(config )  , enable UsePremiumServices and try with admin //premium_menu and .premium for  normal players.



Offline progressive

  • L2jHellas User
  • *
  • Posts: 9
  • Country: ar
  • Karma: 0
Re: hello good can you help me I'm trying to enter a vip code and aio
« Reply #4 on: November 12, 2022, 05:19:29 am »
well thanks you couldn't solve it your way the same thanks

algo de aca estoy poniendo mal que no logro desifrar
Code: [Select]
   private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?, maxHp=?, curHp=?, maxCp=?, curCp=?, maxMp=?, curMp=?, str=?, con=?, dex=?, _int=?, men=?, wit=?, face=?, hairStyle=?, hairColor=?, heading=?, x=?, y=?, z=?, exp=?, expBeforeDeath=?, sp=?, karma=?, pvpkills=?, pkkills=?, rec_have=?, rec_left=?, clanid=?, maxload=?, race=?, classid=?, deletetime=?, title=?, accesslevel=?, online=?, isin7sdungeon=?, clan_privs=?, wantspeace=?, base_class=?, onlinetime=?, in_jail=?, jail_timer=?, newbie=?, nobless=?, power_grade=?, subpledge=?, last_recom_date=?, lvl_joined_academy=?, apprentice=?, sponsor=?, varka_ketra_ally=?, clan_join_expiry_time=?, clan_create_expiry_time=?, char_name=?, vip=?,vip_end=?, death_penalty_level=?, chat_filter_count=? WHERE obj_id=?";
   private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally, clan_join_expiry_time, clan_create_expiry_time, death_penalty_level, vip,vip_end, hero, donator, chatban_timer, chatban_reason, chat_filter_count FROM characters WHERE obj_Id=?";
« Last Edit: November 12, 2022, 05:37:52 am by progressive »