Jump to content

All Activity

This stream auto-updates     

  1. Yesterday
  2. This JavaScript code would do the same as the Vb.Net, to create an account. <!DOCTYPE html> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.0.0/jquery.min.js"> </script> <script type="text/javascript"> window.onload = function() { document.getElementById("Save").onclick = function fun() { var request = { user: document.forms["accountCreate"]["user"].value, pass: document.forms["accountCreate"]["pass"].value, email: document.forms["accountCreate"]["email"].value, gmLevel: document.forms["accountCreate"]["gmLevel"].value }; var jsonText = JSON.stringify(request); alert(jsonText); var xhr = new XMLHttpRequest(); var url = "http://localhost:8081/create/"; var method = "POST"; xhr.open(method, url, true); xhr.setRequestHeader("Content-Type", "application/json"); xhr.send(jsonText); } } </script> </head> <body> <center> Javascript Post Request Test <br><br> <form name="accountCreate"> <input type="text" name="user"/> <input type="text" name="pass"/> <input type="text" name="email"/> <input type="text" name="gmLevel"/> <input type="button" id="Save" onclick="f1()" value="test"/> </form> </center> </body> </html>
  3. Please watch the full video and read all post before asking. Here is a video with a resume of what Web Services can do. After watching this, you are wondering with whats the diference with all the Account Managment tools available in the market? Well the application you can see in that video does nothing than sending REST requests to my webservices and the web service is the one that create/edit my Micosoft Sql Server Databases with the values i sent. For example, in the first process (Account Creation) i define: Username Password Email GM Level So the application creates the following json with the given values: { "user": "Admin", "pass": "E10ADC3949BA59ABBE56E057F20F883E", "oldPass": "123456", "email": "shah@jasja.com", "gmLevel": 99, } Where pass value is the MD5 Hash for "123456" My web service receives this information, process it and execute the following query to my Microsoft SQL Server Database. First to create Account INSERT INTO [AccountServer].[dbo].[account_login] (name, password, originalPassword, email, ban) VALUES ( 'Admin', 'E10ADC3949BA59ABBE56E057F20F883E', '123456' , 'hadhs@das.com',0); Then to set Gm Level INSERT INTO GameDB.dbo.account (act_id, act_name, gm, cha_ids, last_ip, disc_reason, last_leave, password, merge_state) VALUES ( '1', 'Admin', 99 , ';', ' ', ' ', '2001-01-01 00:00:00.000', null, 0); And after this, the webservice just return the information of this Created Account with the following Json. { "idCode": "31", "name": "Admin", "password": "E10ADC3949BA59ABBE56E057F20F883E", "originalPassword": "123456", "loginStatus": "0", "lastLoginTime": "1534535165653", "lastLogoutTime": "1534535165653", "lastLoginIp": "null", "ban": "0", "email": "dasd@jas.com" } Then my application just process this data received from the Web Service and show it to you. The same works with the Character Editing function, it looks for the character in the Sql Database and update the colums of str,dex,gb,etc. This are just two examples i had in mind as i dont know too much of Server Development but if you have more ideas of things i can do ingame with sql querys just leave a comment. Finally why we are here, the good thing with this is that this webservice supports request from diferent plataforms. As i programmed a Vb.Net program to consume my services, you can develope desktop applications(C++, C#, Java, Python, (EVEN LUA, im not a lua programmer so idk if this work but u may be able to do web services from Game client)), web applications, mobile applications, etc. As long as they support REST Request. So , for example, you can develop a simple website with two textboxes and 1 button. The button function would be just send this Json explained before as a Post Request to my Web Service and the account would be created. Later you want to create an addon to ur Game Launcher to create an account. You should program just 2 textbox and 1 botton and the button send a Post Request to my webservice. The thing with this is that you didnt have to program all the connections and querys to the database again when you programmed your second application. So you can continue programming diferent apps that works with different web services. So what im offering is my Web Services, the development of new web services And im asking for ideas to develope. I may create a Tales of Pirates Mall, Character teleportation, etc. And this are services you can use in ur WebSites, Launcher, Tools, Etc. I leave you with my Vb.Net Project in Visual Studio 2017: https://www.dropbox.com/s/haf1ud8scgv85bk/Tales of Pirates Administration.rar?dl=0 Leave any question or request below. Thanks you.
  4. chrisroses

    Skills pet dont work

    Who can help me, skills pet dont work :c
  5. superNL

    Item Mall - Laravel

    This look really nice, thanks for the share!
  6. Rinor

    Amplifier Handler - Serialization

    I went through all and add everything but still wont work, it wont even show the bickernotice when i click the amp nor add double exp
  7. Natta

    Character class bugged

    @JoJo Thank you for your reply!
  8. chrisroses

    Gateserver error

    I have a problem, im trying conect gateserver
  9. Last week
  10. There is any Web Service (APIs) Development and Integration in Top Private Server Market? If someone is Interested Pm me and i create a post explaining this.
  11. Satan

    Amplifier Handler - Serialization

    You probably forgot something on installation, check path to data or read whole codes and installation process again.
  12. Rinor

    Amplifier Handler - Serialization

    I replaced the exp_and_lvl & skilleffect functions, and iteminfo item_use function to the one on amp handler but it wont work, no errors at lua_err
  13. JoJo

    Character class bugged

    GameServer.exe?
  14. saa0d

    Database(lottery system) problem

    I actually don't know how to use them xD
  15. Satan

    Amplifier Handler - Serialization

    You must replace original amplifiers function to new one that on handler, otherwise it will not work for sure. Timer just for ads system..
  16. Sultan

    Database(lottery system) problem

    Great mods bro! share plz~ XD
  17. saa0d

    Database(lottery system) problem

    Hello, thank you for replying. Where do I find that LotterySetting table? thank you.
  18. Totoka

    Database(lottery system) problem

    Hello @saa0d, Seems like the LotterySetting table is missing, OR it doesnt have the correct fields. If you're using 2.0+ server files, this is the query being executed behind that error: "select section from LotterySetting (nolock) where 1=2"
  19. I'm trying to run my server files on a new computer but I have been running into few issues till now. I'm trying to run the servers locally, using 127.0.0.1 which works perfectly fine on the other computer. The problem I ran into was that the account,gate,group servers were not connecting to the database using either local IP address or 127.0.0.1 . Each time I was getting account server hang and groupserver unable to connect. So I tried doing something which is copying the Instance name of the SQL to the cfg files like this: When I did that, the account server, group and gate servers all were connected to the local database. But when I tried running the game server, it gave me a message (Database Connected!) But then right away I got the error "Database (lottery system) initialization error" Please help me to resolve this. If it's possible to resolve the whole thing where I can type 127.0.0.1 instead of the instance name it would be even better. Thank you. P.S: I'm using MYSQL 2012 with compatible database. Everything is working fine on my other computer and i'm able to enter the game. But I'm unable to start the server on this computer. What's wrong??
  20. Rinor

    Amplifier Handler - Serialization

    I'm having a problem that im not gaining double exp when using amp, not getting errors at lua_err tho.. im using a custom_timer same name as on script "player_timer"
  21. Natta

    Character class bugged

    Hello! I got an bug/issue with the character class, everytime a character relogs it loses the class. I've been looking in the files for the issue but can't seem to find anything, I even tried to replace with clean files in case its something with my resources but its still the same even with clean files. Does anyone have a clue what it could be or where I should look to fix this. Thank you all! :)
  22. Edilson

    Gem Level Limit

    Good evening everyone, could anyone help me how can I add the level limit of a gem to forge on some equipment? Thank you!
  23. JoJo

    Anonymous Pirates Online

    Fixed Reputation not given when killing Sorrow Warrior Gem Combine Scroll in Mall - Allows combining gems within inventory Fairy Stamina Card in Mall Socket price changed from 6m to 3m New Hat apparels New Map - Nightmare Icicle more details regarding Nightmare Icicle can be found here (Note that not all the equipments are released yet: http://talesofpirates2.forumotion.com/t2-nightmare-icicle http://talesofpirates2.forumotion.com/t4-nightmare-helmet http://talesofpirates2.forumotion.com/t14-nightmare-ring Story Quest Adjustments (Not all quests) - Players now will receive Fairy Rations + Extra gold when completing quests. New Quests - Based on Level, the quests can be found at Server Quest NPC. Price of Rep Frag needed for Fairy Marriage in Rep NPC is lowered from 20 to 10 Fruit Fragments needed for a fruit reduced from 99 to 30
  24. Satan

    Amplifier Handler - Serialization

    Functions that need to be replace from this handler will fix errors and make call the amplifier statelv from it's functions too. A example of error is the ship experience which is not granted when u use amp, where on this handler it fixed.
  25. Rinor

    Amplifier Handler - Serialization

    @Satan Hi, i wanna know if it makes any difference when i need to replace some functions at exp_and_lvl.lua to the one that this file require
  26. daim2604

    SQL 2014 Express setup

    Hello sir, thanks alot for this guide. I'm getting error, connection to database failed, the process terminated. This is my first time setting up a private server. I've googled to no avail. I've checked/given user permission still the same. I'm using sql server 2014 instance. Thanks in advance.
  1. Load more activity
×