OnMyMobDead: //When a Monster is killed
set .mobs_left, .mobs_left-1;
if (.mobs_left==0) {
announce "[ Rune-Midgard Guard ]: "+getmonsterinfo(.MvpID,0)+" has spawned in " + .Map$ + "!", bc_all;
monster .Map$,0,0,getmonsterinfo(.MvpID,0),.MvpID,1,"Event Invasion::OnSpecialMobDead";
i have two parameters, one i should use a temporary the "event_point" and an permanent "t_event_points" permanent. When killing a mob I would like that added the sql table in both, however I do not have much sql knowledge, I tried one way and gave error, someone could me help? when i finish my event i'll share it! ^^
"when i kill a mob event_point add+1 and t_event_point add +1"
I receive this error:
[Debug]: Source (NPC): Event Invasion at prontera (148,178)
Code:
: DB error - 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 ''event_points','t_event_points' = event_points + '1', t_event_points + '1'' at line 1
my sql table:
DROP TABLE IF EXISTS `event_rank`;
CREATE TABLE `event_rank` (
`id` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL DEFAULT '',
`event_points` mediumint(50) DEFAULT NULL,
`t_event_points` mediumint(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
my formula to convert event points in "event coins: ID8052 in my case" I tried to change some things, but it didn't work.
20 event_points = 1 event coin
for example: if i input 27 event_points npc will give me 1 event coin and return 7 event points.
OLD FORMULA when event_points was the var: #Event_point
switch(select("Convert Event Points:Back")) {
case 1:
{if(#Event_point < 20)
goto noEP;
}
{ if(#Event_point >= 20)
.@remainDiv = #Event_point%20;
.@remaindiv01 = #Event_point - .@remainDiv;
set #Event_point, #Event_point - .@remaindiv01;
mes " [Event Manager]";
mes "Thank you for choosing ^777777RagnaRebirth^000000 that luck be with you in future events, and you can win many Coins.";
.@remaindiv01 = .@remaindiv01/20;
getitem 8052,.@remaindiv01;
close;
}
case 2:
goto Main;
}
NEW FORMULA (I tried, but failed! )
switch(select("Convert Event Points:Back")) {
case 1:
query_sql "SELECT `event_points` FROM `event_rank` ORDER BY `event_points` DESC LIMIT "+$topevent+"",@event_points$;
{if(@event_points$ < 20)
goto noEP;
}
{ if(@event_points$ >= 20)
.@remainDiv = @event_points$%20;
.@remaindiv01 = @event_points$ - .@remainDiv;
set @event_points$, @event_points$ - .@remaindiv01;
query_sql "INSERT INTO `event_rank`(`id`, `name`, `event_points`) VALUES ('"+getcharid(3)+"','"+strcharinfo(0)+"','1') ON DUPLICATE KEY UPDATE `event_points` = `event_points` - '@event_points$'";
mes " [Event Manager]";
mes "Thank you for choosing ^777777myRO^000000 that luck be with you in future events, and you can win many Coins.";
.@remaindiv01 = .@remaindiv01/20;
getitem 8052,.@remaindiv01;
close;
}
case 2:
goto Main;
}
in this part:
query_sql "SELECT `event_points` FROM `event_rank` ORDER BY `event_points` DESC LIMIT "+$topevent+"",@event_points$;
how can i remove "+$topevent+" when I removed gave me an error!
query_sql "SELECT `event_points` FROM `event_rank` WHERE `id` = '"+getcharid(3)+"'", .@points;
if (.@item_cost > .@points)
{
// We don't have what we need.
mes "Sorry, but you don't have " + .@item_cost + " Event Points.";
close;
}
else
{
.@result = .@points / .@item_cost;
.@rest = .@points % .@item_cost;
mes "You can get "+.@result+"x " + getitemname(.@item_id) + " and you will have " + .@rest + " Event Points";
mes "You want trade?";
if (select("Yes:No") == 2)
close;
getitem .@item_id, .@result;
query_sql "UPDATE `event_rank` SET `event_points` = '"+.@rest+"' WHERE `id` = '"+getcharid(3)+"'";
mes "Here it is";
close;
}
}
Note: You will need change 'getcharid(3)' to 'getcharid(0)' if you want save character number id, because 'getcharid(3)' save account number id.
query_sql "SELECT `event_points` FROM `event_rank` WHERE `id` = '"+getcharid(3)+"'", .@points;
if (.@item_cost > .@points)
{
// We don't have what we need.
mes "Sorry, but you don't have " + .@item_cost + " Event Points.";
close;
}
else
{
.@result = .@points / .@item_cost;
.@rest = .@points % .@item_cost;
mes "You can get "+.@result+"x " + getitemname(.@item_id) + " and you will have " + .@rest + " Event Points";
mes "You want trade?";
if (select("Yes:No") == 2)
close;
getitem .@item_id, .@result;
query_sql "UPDATE `event_rank` SET `event_points` = '"+.@rest+"' WHERE `id` = '"+getcharid(3)+"'";
mes "Here it is";
close;
}
}
Note: You will need change 'getcharid(3)' to 'getcharid(0)' if you want save character number id, because 'getcharid(3)' save account number id.
query_sql "SELECT `event_points` FROM `event_rank` WHERE `id` = '"+getcharid(3)+"'", .@points;
if (.@item_cost > .@points)
{
// We don't have what we need.
mes "Sorry, but you don't have " + .@item_cost + " Event Points.";
close;
}
else
{
.@result = .@points / .@item_cost;
.@rest = .@points % .@item_cost;
mes "You can get "+.@result+"x " + getitemname(.@item_id) + " and you will have " + .@rest + " Event Points";
mes "You want trade?";
if (select("Yes:No") == 2)
close;
getitem .@item_id, .@result;
query_sql "UPDATE `event_rank` SET `event_points` = '"+.@rest+"' WHERE `id` = '"+getcharid(3)+"'";
mes "Here it is";
close;
}
}
Note: You will need change 'getcharid(3)' to 'getcharid(0)' if you want save character number id, because 'getcharid(3)' save account number id.
Here's my Invasion Event, if you want to check, and if you have any tips to how to improve it! Invasion_Event_v1.5
I know I can decrease the code, especially in parts of the cities, but I was a long time without messing with ragnarok scripts and now i have to remember a lot of things, but it's functional !
PS: i try, but i dont know how to implement an option on the menu to choose the day and time to start the event, you showed me an example I tried to follow him, but there were several errors.
I will look your script and try to mount the part to start the event for you to understand a bit how it works, it's a little complicated at first, I had much difficulty, but it is now quite simple.
I will look your script and try to mount the part to start the event for you to understand a bit how it works, it's a little complicated at first, I had much difficulty, but it is now quite simple.
