Jump to content
  • 0

Error L2jPack


MrAderson

Question

Pedia mpori na me eksigi kaneis gt vgazi auto to error

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `armor` ('9901', 'Rhea`s Earring', 'rear,lear', 'true', 'none', '150' at line 2

[Msg] Finished - Unsuccessfully

Link to comment
Share on other sites

10 answers to this question

Recommended Posts

  • 0

('9901', 'Rhea`s Earring', 'rear

 

leipei ena (') prin to koma..

 

Enas filos mou 8elo help dn to katalava auto pou eipes

na ksana to error

 

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `armor` ('9901', 'Rhea`s Earring', 'rear,lear', 'true', 'none', '150' at line 2

[Msg] Finished - Unsuccessfully

 

 

auto to bazo se txt gia na to kano add sto navicat gia l2jfree. pou kano lathos?

 

INSERT INTO `armor` VALUES('9900', 'Zeus Neckle', 'neck', 'true', 'none', '150', 'gold', 's','0','-1','0','11','0','2340','0','true','true','true','true','0','0'),

INSERT INTO `armor` ('9901', 'Rhea`s Earring', 'rear,lear', 'true', 'none', '150', 'gold', 's', '0','-1','0','11','0','2340','0','true','true','true','true','0','0'),

INSERT INTO `armor` ('9902', 'Cronos Earring', 'rear,lear', 'true', 'none', '150', 'gold', 's', '0', '0','-1','0','11','0','2340','0','true','true','true','true','0','0'),

INSERT INTO `armor` ('9903', 'Heracles Ring', 'rfinger,lfinger', 'true', 'none', '150', 'gold', 'b','0','-1','0','11','0','2340','0','true','true','true','true','0','0'),

INSERT INTO `armor` ('9904', 'Alcmene Ring', 'rfinger,lfinger', 'true', 'none', '150', 'gold', 's', '0','-1','0','11','0','2340','0','true','true','true','true','0','0'),

 

 

MASTROPOS: MHN XANAKANEIS DOUBLEPOST!

Link to comment
Share on other sites

  • 0

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `armor` ('9901', 'Rhea`s Earring', 'rear,lear', 'true', 'none', '150' at line 2

[Msg] Finished - Unsuccessfully

 

 

Koita ti diafora sto kokino k to prasino.. sto kokino leipei ena (') enw to prasino exei kanonika 2

 

 

P.S: k apoti vlepw einai sta queries olwn twn jewels..se ola leipei apo ena (') :P

Link to comment
Share on other sites

  • 0

auti einai i sinexia

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `armor` VALUES ('9600','Epic Dark Knight Heavy Armor','fullarmor','t' at line 2

[Msg] Finished - Unsuccessfully

Link to comment
Share on other sites

  • 0

De mporw na katalavw gt exeis tosa errors!

Dokimase ta dika mou pou doulevoun mia xara, gia mena toulaxiston..

 

http://rapidshare.com/files/41573561/epicsqls.rar.html

 

na  se po auto diko sou einai mesa kai exi armo kai jeweles weapon etc? :P

Link to comment
Share on other sites

  • 0

PfFfFf..Prepei na xrisimopieis kana oneo i l2jfree e? :P

 

Dokimase na ta valeis manual stin db (an k tha sou parei ligo xrono)

i apla checkare ti parapanw yparxei sta sql ap ta tables tou navicat :P

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • Hello if anyone is looking for interlude server with free bot, no P2W and uniques features I can recommend freshly opened https://l2romans.com/features/, great server for chilling and having fun with friends casually. Everyone is welcomed
    • So excited to announce 3x Telegram Premium (6 months)   Join our official TG and participate to win!   Asocks.com - trusted proxy service providing mobile and residential proxies with a single price of $3 per 1GB   A huge locations pool and high speed will help complete all tasks    
    • Well, sorry not sorry for resurrecting old topic, but I believe it's ultimately stupid to implement license checks like Vilmis did 🙂   private static String url = "jdbc:mysql://185.80.128.233/" + getData("Zm9ydW1fZGI="); private static String username = getData("bXJjb3B5cmlnaHQ="); private static String password = getData("Y29weXJpZ2h0XzEyMw=="); con = GlobalDB.getInstance().getConnection(); PreparedStatement statement; statement = con.prepareStatement("SELECT field_6 from core_pfields_content WHERE member_id = ?"); statement.setInt(1, Config.FORUM_USER_ID); ResultSet rset = statement.executeQuery();   This awesome way of coding things leaves us with base64-encoded credentials and DB exposed and accessible globally 😉 Btw he checks his licensing data from some plugin generated table his forum uses. Vilmis took action and ensured that mrcopyright user would have only needed accesses and rights for this operation. But he forgot to ensure that his INFORMATION_SCHEMA database would not be exposed and readable... That leads us to fully readable server variables like version used (10.1.26-MariaDB-0+deb9u1 - pretty ancient DB and OS, I'd assume). From here you can go south and do some kinky stuff, if you want and have knowledge for that. But who cares, right?   Ooh, table core_pfields_content field_6 is IP address which is checked by FORUM_USER_ID. Yep, you can query all IP addresses there (124 of them right now) and also do whatever you want with them! 🙂  The most fun part? Files source has been shared what, more than 2 years ago?  Vilmis still uses very same credentials and never changed it after sources exposure - who cares. Although, "sources" may be way too strong word here. If anyone still use paid Orion versions, I'd suggest packing your shit and leaving immediately, or at least fix this incompetent fool caused problems. It's obvious Vilmis don't care or maybe doesn't even know from the first place how to solve this problem (hint hint - tiny PHP Rest API microservice which would do absolutely the same but without exposing sensitive data?). By doing that, he exposes his infrastructure and YOUR data, and he does that for more than 2 years now 🙂 Developer of century!    
    • rename the l2.bin into l2.exe
  • Topics

×
×
  • Create New...