Kawacito
-
Posts
33 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Everything posted by Kawacito
-
It would be something like the following: .@mkname$ = strcharinfo(0); query_sql "SELECT * FROM JM_MVPTR WHERE char_name = .@mkname$",.@charname; if(.@charname != .@mkname$){ mes" Tu no eres el campeon de HERO."; close; } else { mes"toma toma tu premio"; getitem 40300,1; close; but that does not work for me, I must also add that I can only request it 1 time for each event that takes place every 2 hours
-
If in any case I managed to create what I needed with that information, now I only have the part where I can only deliver the prize to the champion user of that event and that he can claim it only once until the event is generated again, which is every 2 hours
-
I have a small question, the event is held every 2 hours, how do I reset the points each time the event is entered?
-
ready now if it works perfectly, a small detail for everyone to know in the insert part says: instead name replace by char_name since when creating the tables it is created as char_name and not as name, other than that it works perfectly!
-
I did a test, manually add points to the SQL with name and date but the npc keeps telling me that there is no top MVP
-
The last part is not understood, in my script I have the following: - script MobDeathMvP -1,{ OnMyMobDead: set .i, .Items$[rand(getarraysize(.Items$))]; set @rand,rand(10,10); getitem 11512,3; getitem .i,1; set #HEROPOINT , #HEROPOINT + 1; Right there I must add the points system but I don't know how to add it
-
I'm trying to create a code for an NPC to tell me the name of the user with the most #MVP points generated so far, I'm using a points system called #HEROPOINT which goes to an SQL table called acc_reg_num with the following values account_id, key , index and value, what I need is that from that table I take the user (account_id) with the most points (value) and as a result the NPC tells me the NAME OF THE CHAR with the most points and the amount of points I generated to mention it as champion of the event... maybe someone can help me with this issue since I don't understand how to bind the SQL to an NPC
