Jump to content

Mantosh

Members
  • Posts

    108
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by Mantosh

  1. Your SQL is missing closing parenthesis. UPDATE characters SET botprev_fail_account = (SELECT botprev_fail_account FROM accounts WHERE account_name = ?) Note, that this will update ALL characters botprev_fail_account to the value of botprev_fail_account pulled from that one account. As far as I understand that's not what You want. To fix that You should add a WHERE for characters part of the query. Something like this: UPDATE characters SET botprev_fail_account = (SELECT botprev_fail_account FROM accounts WHERE account_name = ?) WHERE uID = ? Also, instead of SELECT You could do it through JOIN like so: UPDATE characters c INNER JOIN accounts a ON c.accountID = a.uID SET c.botprev_fail_account = a.botprev_fail_account WHERE c.uID = ? Alternatively, just to give You some options, You could fetch botprev_fail_account value from accounts instead of saving (I assume) same value on two tables. SELECT a.botprev_fail_account, c.something FROM characters c INNER JOIN accounts a ON c.accountID = a.uID WHERE c.uID = ? Please note, that I haven't checked if any of those work and I assumed few column names - change them per Your database as needed.
  2. Let's get back to greetings :) Hey! Welcome
  3. Have You tried the solutions mentioned in previous posts?
  4. You could try different remote services, like VNC or CRD, but chances are slim here. Clickers and macro software like AHK use the same mouse click emulation method, which is blocked by client protection. I'm not experienced enough in this field to expand on that, just speaking from my experience trying to do it myself :) Let me know if You find something that works! GL
  5. Most client protections block these kind of emulated events.
  6. Strange times we live in, huh?
  7. @Loftheim Calling something "shit" is not constructive criticism. Say You're sorry, that You didn't express Yourself right and move on. @V-Ray I just figured out what do You remind me of... Trump! Kara's "I'm studying quantum physics and medicine and You're too stupid to even comprehend what I'm talking about" (too lazy to look for direct quote) vs. Trump's "<...>OK, very smart, the Wharton School of Finance, very good, very smart<...>" Kara's "People messaged me on skype saying how well I did on a forum topic" vs. Trump's "<...>He really wrote a beautiful three-page — I mean right from top to bottom — a really beautiful letter.<...>" I know You'll just start flaming me, but please, consider what multiple people are saying, maybe they are at least a little right? Sometimes? Maybe?
  8. Very interesting concept, thanks for sharing! The HTML needs some work, yes, but it's definitely not "shit"... Great job overall! Upvote from me :)
  9. As far as I remember - no
  10. Check levels by right clicking on the map.
  11. Chronicle 5 is not ol .... d ... 13 YEARS?!
  12. Makes sense. Thank You, Rootware
  13. What would You recommend then?
  14. Subscribed :)
  15. Someone with some spare money, purchase source from him, and sell "his" source half price. I'm not saying l2-scripts source is good or not overpriced - I'm no expert, but what You're doing is at least a little bit douchey.
  16. If he doesn't run firewall and AV - I'd start with Malwarebytes ;)
  17. Shame? :D
  18. [Mantosh seal of approval] This server is what l2 classic supposed to have been! Nostalgic, hard and fun!
  19. Then use Your computers local network IP (Most likely 192.168.0.x)
  20. The "Login Server" should be IP of Your server's Login.
  21. So basically this bot is for lineage2idle.com server only (unless another server purposely disabled protection against it). If You're trying to get it working on idle, I would recommend asking around at their forum. As far as I remember the only thing You need to do to make it work IG on idle is to change the IP address in Your l2.ini to 127.0.0.1 Cheers
×
×
  • Create New...