Vasil 71 Report post Posted January 8, 2017 --[[ IGS Crystal By Mob Extension made By Vasil pkoDev,Please do not claim or redistribute the credits :) *Requirements: -LuaSQL by Wrexor -TradeServer Program -TradeDB -SQL 2008 or higher *Configuration: I guess the example i gave is clear Just if you're going to use .\SQLEXPRESS , make it x2 dashes otherwise it will be as .SQLEXPRESS e.g : .\\SQLEXPRESS Just change the map that the function will run inside and the monster ID that will give the IGSP If encountering any bug or flaw or glitch,please contact me - Vasil Download from here: CrystalByMob.rar Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted January 8, 2017 Note:This was been tested before sharing! Quote Share this post Link to post Share on other sites
GustavoHMA 15 Report post Posted January 10, 2017 There are some flaws because I created a similar function, but in the form of a Card and requires checking some errors: If the player never enters In-Game Mall, it will never add the points, so you need to check if there is any record in SQL; If there is an error in SQL, it will be necessary to create logs so that it is resolved by the administrator. Well, I guess that's just it. 1 Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted January 10, 2017 Hello @GustavoHMA , i am using Xero's TradeServer and i am not facing anything from what you said,you'll only get it if you're using WolfenDev TradeServer Quote Share this post Link to post Share on other sites
Guest Report post Posted January 10, 2017 9 minutes ago, Vasil said: Hello @GustavoHMA , i am using Xero's TradeServer and i am not facing anything from what you said,you'll only get it if you're using WolfenDev TradeServer Gustavo was talking about LuaSQL add-on I suppose, also, what's the connection between your script and TradeServer tools? Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted January 10, 2017 12 minutes ago, qwerty said: Gustavo was talking about LuaSQL add-on I suppose, also, what's the connection between your script and TradeServer tools? He is talking about the added points,u won't recieve them unless you open crystals shop,i encountered that error only while using WolfenDev tradeserver,but Xero's one nope Quote Share this post Link to post Share on other sites
GustavoHMA 15 Report post Posted January 10, 2017 33 minutes ago, Vasil said: Hello @GustavoHMA , i am using Xero's TradeServer and i am not facing anything from what you said,you'll only get it if you're using WolfenDev TradeServer I think you did not get it. My TradeServer is the same as yours. Make the following test, create a new account and then add points by killing the monsters, after entering the In-game Mall you will realize that no point has been added. That is the question. 1 Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted January 10, 2017 Oh OKAY!Thank you!I'll test it out Quote Share this post Link to post Share on other sites
Angelix 374 Report post Posted January 19, 2017 On 1/10/2017 at 7:48 AM, Vasil said: Oh OKAY!Thank you!I'll test it out Did you manage to get that working out fine? Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted January 21, 2017 On 1/19/2017 at 3:24 AM, Angelix said: Did you manage to get that working out fine? Nope,not yet,i was so busy this week,i'll be testing it out so soon. Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted January 22, 2017 Hello @GustavoHMA it's working good in here,i don't know what caused your error but i believe you should use "127.0.0.1\\SQLEXPRESS",Thanks to @Wrexor for showing me this one.Allow Pipes too & IP Connection in your SQL. Quote Share this post Link to post Share on other sites
GustavoHMA 15 Report post Posted January 25, 2017 On 22/01/2017 at 10:49 AM, Vasil said: Hello @GustavoHMA it's working good in here,i don't know what caused your error but i believe you should use "127.0.0.1\\SQLEXPRESS",Thanks to @Wrexor for showing me this one.Allow Pipes too & IP Connection in your SQL. Glad you're working well there. Quote Share this post Link to post Share on other sites
Angelix 374 Report post Posted January 25, 2017 What I think @GustavoHMA means is that if a newly created account is playing and kills a monster then gets some points, those points won't get added since that account doesn't exist within TradeDB. Accounts created don't synchronize with TradeDB, they get create once a player enters in-game mall for the first time since TradeServer checks whether an account exists, if it doesn't, then it creates a record for it within TradeDB. Your query goes on ahead expecting the account you're trying to access/modify does exist which in reality can or can't exist depending on whether the player has entered or not the in-game mall before getting some points added. Try this: Create two new accounts, "A" and "B". Check TradeDB, you'll see that neither accounts exists within it. Create a new character in each account. With player "A" access in-game mall and a record for that account will be created within TradeDB while account "B" won't have one. With both characters kill a monster to add some points to their account. Account "A" should get points while account "B" shouldn't be getting since it does not exists within TradeDB. Then with player "B" enter in-game mall and then the record should be created and see if it has points from before. 2 Quote Share this post Link to post Share on other sites
GustavoHMA 15 Report post Posted January 25, 2017 2 minutes ago, Angelix said: What I think @GustavoHMA means is that if a newly created account is playing and kills a monster then gets some points, those points won't get added since that account doesn't exist within TradeDB. Accounts created don't synchronize with TradeDB, they get create once a player enters in-game mall for the first time since TradeServer checks whether an account exists, if it doesn't, then it creates a record for it within TradeDB. Your query goes on ahead expecting the account you're trying to access/modify does exist which in reality can or can't exist depending on whether the player has entered or not the in-game mall before getting some points added. Try this: Create two new accounts, "A" and "B". Check TradeDB, you'll see that neither accounts exists within it. Create a new character in each account. With player "A" access in-game mall and a record for that account will be created within TradeDB while account "B" won't have one. With both characters kill a monster to add some points to their account. Account "A" should get points while account "B" shouldn't be getting since it does not exists within TradeDB. Then with player "B" enter in-game mall and then the record should be created and see if it has points from before. Finally someone understood me. Quote Share this post Link to post Share on other sites
johan 2 Report post Posted July 8, 2017 Hello how are you. What is the database and the table that contains the points that are seen in the game store? Quote Share this post Link to post Share on other sites
Onioni 58 Report post Posted July 8, 2017 (edited) On 10.1.2017 at 4:12 PM, GustavoHMA said: There are some flaws because I created a similar function, but in the form of a Card and requires checking some errors: If the player never enters In-Game Mall, it will never add the points, so you need to check if there is any record in SQL; If there is an error in SQL, it will be necessary to create logs so that it is resolved by the administrator. Well, I guess that's just it. That problem u can fix by adding in website when make new account do on it, tradedb account crystals 0 Edited July 8, 2017 by Onioni Quote Download: Nightmare Demonic Helm Dimension Pirates Online files: get now New map Project: Flag PK Black Skin 3.1.3 for pko 1: Get now Share this post Link to post Share on other sites
johan 2 Report post Posted July 8, 2017 I have tradedb and in the AccountInfo table this Money = Crystal But I do not have a table for Points = ?? Quote Share this post Link to post Share on other sites
Faller 93 Report post Posted July 8, 2017 (edited) Hey, @johan! You don't need to worry about the points, it's a "show-only" thing. There's no points exchanger or such functions in the IGS itself. When you click in the "Exchange" button, it will simply take you to IGG's website which had the exchange function in PHP. Edited July 8, 2017 by Faller Quote Share this post Link to post Share on other sites
Andy 39 Report post Posted July 8, 2017 (edited) @johan accountserver db/ account_details table/ credit column Edited July 8, 2017 by Andy Quote Share this post Link to post Share on other sites
johan 2 Report post Posted July 8, 2017 6 hours ago, Andy said: @johan accountserver db/ account_details table/ credit column @Andy Hey man, thank you, really, thank you Quote Share this post Link to post Share on other sites
1g0rS1lv4 68 Report post Posted June 6, 2019 (edited) Would it be possible to put to win in quest? without having to use scroll. Edited June 6, 2019 by 1g0rS1lv4 Quote Being better than others is for those who are weak; what matters is to be true to yourself. Share this post Link to post Share on other sites
Eviles 179 Report post Posted June 6, 2019 14 hours ago, 1g0rS1lv4 said: Would it be possible to put to win in quest? without having to use scroll. @Hello @1g0rS1lv4! Just add the function which gives crytal to the player at ActionsProc(), located at missionsdk.lua. Eg: elseif actions[i].func == GiveCrystal then GiveCrystal( character, actions[i].p1 ) Usage on quest: MisResultAction(GiveCrystal, 10) -- Gives 10 crystal to player 1 Quote Share this post Link to post Share on other sites
Legacy 2 Report post Posted April 14, 2020 Does anyone have this uploaded anywhere else? Link is no longer working. Quote Share this post Link to post Share on other sites
hetser 0 Report post Posted April 17, 2020 On 4/14/2020 at 2:38 PM, Legacy said: Does anyone have this uploaded anywhere else? Link is no longer working. please! Quote Share this post Link to post Share on other sites
Angelix 374 Report post Posted April 19, 2020 @Legacy & @hetser. This is the content within that rar file. print("* Loading CrystalByMob Extension <init.lua>") --[[ IGS Crystal By Mob Extension made By Vasil pkoDev,Please do not claim or redistribute the credits :) *Requirements: -LuaSQL by Wrexor -TradeServer Program -TradeDB -SQL 2008 or higher *Configuration: I guess the example i gave is clear Just if you're going to use .\SQLEXPRESS , make it x2 dashes otherwise it will be as .SQLEXPRESS e.g : .\\SQLEXPRESS Just change the map that the function will run inside and the monster ID that will give the IGSP If encountering any bug or flaw or glitch,please contact me - Vasil --]] SQLConnector = {}; SQLConnector.sql = { host = "127.0.0.1\\SQLEXPRESS", user = "sa", pass = "Y87dc#$98", db = "TradeDB" }; CrystalByMobHook = GetExp_PKM GetExp_PKM = function( dead , atk , money ) CrystalByMobHook(dead,atk, money) local DeadMonster = GetChaID(dead) local accountName = GetActName(atk) local Money = Money local Rum = { }; Rum['Money'] = Money; if(GetChaMapName(atk) == "garner" or GetChaMapName(atk) == "crystal") then if(DeadMonster == 1526)then QueryAsync( SQLConnector.sql['host'], SQLConnector.sql['user'], SQLConnector.sql['pass'], "UPDATE "..SQLConnector.sql['db']..".dbo.AccountInfo SET Money = Money + 1 WHERE accName = '"..accountName.."'" ); BickerNotice( atk, "[IGSP]:You have obtained 1 IGS Crystal from "..GetChaDefaultName(dead) ) end end end Please take into consideration this: On 1/24/2017 at 7:28 PM, Angelix said: What I think @GustavoHMA means is that if a newly created account is playing and kills a monster then gets some points, those points won't get added since that account doesn't exist within TradeDB. Accounts created don't synchronize with TradeDB, they get create once a player enters in-game mall for the first time since TradeServer checks whether an account exists, if it doesn't, then it creates a record for it within TradeDB. Your query goes on ahead expecting the account you're trying to access/modify does exist which in reality can or can't exist depending on whether the player has entered or not the in-game mall before getting some points added. Try this: Create two new accounts, "A" and "B". Check TradeDB, you'll see that neither accounts exists within it. Create a new character in each account. With player "A" access in-game mall and a record for that account will be created within TradeDB while account "B" won't have one. With both characters kill a monster to add some points to their account. Account "A" should get points while account "B" shouldn't be getting since it does not exists within TradeDB. Then with player "B" enter in-game mall and then the record should be created and see if it has points from before. 1 Quote Share this post Link to post Share on other sites