Jump to content
  • Sign Up
  • 0
Sign in to follow this  
Followers 0
kerbiii

help on my npc pls

Asked by kerbiii

Question

kerbiii    5

kerbiii
Posted (edited)

/help

 

 

[Debug]: Source (NPC): Game Rewarder at prontera (116,158)
[info]: Saved guild (1 - MADNESS): level members
[info]: Saved char 150000 - GM Cross: status.
[info]: Saved char 150042 - GM White: status.

: DB error - Table 'ragnarok.Item_command' doesn't exist
[Debug]: at script.c:14290 - INSERT INTO `Item_command` (`char_name`, `won_id`, `nameid`, `amount`, `date`) VALUES ('GM Cross', 'Desp', '0', '0', '2013-11-20')
[Debug]: Source (NPC): Game Rewarder at prontera (116,158)

 

 

this is my script :)

 

 

prontera,116,158,5 script Game Rewarder 98,{

if(getgroupid()< 4){
mes "Hello "+strcharinfo(0)+"";
close;
}

set .@date$,gettimestr("%Y-%m-%d",21);
setarray .@rewardItemGM[1],.@itemid; //Item IDs
setarray .@rewardamItemGM[1],.@itemcount; //Item Amounts

set .@rewardMenu$,"";

switch(select("Give Reward:Check Logs:Reset History")){

case 1:
mes "Hello Game Master!";
mes "Please select how you give out Items?";
next;
switch(select("Per Person:By Guild:By Party")){

//=================================== INDIVIDUAL
case 1:
input .@reward_name$;

set .@reward_char, getcharid(0,""+.@reward_name$+""); //char id
set .@reward_acc, getcharid(3,""+.@reward_name$+""); //account id

set .@status, isloggedin(.@reward_acc,.@reward_char); //check if online or offline

if(.@status == 0){
mes "The character with a name of "+.@reward_name$+" is now offline or you got the wrong character name, please review it..";
close;
}

message .@reward_name$,"Please don't log out as Game Master "+strcharinfo(0)+" will give you some reward. Thank you.";

for( set .@i,1; .@i < getarraysize( .@rewardItemGM ); set .@i,.@i + 1 ){
set .@rewardMenu$,.@rewardMenu$ + getitemname( .@rewardItemGM[.@i] )+":";
}

set .@ItemGM,select( .@rewardMenu$ );
set .@xstatus, isloggedin(.@reward_acc,.@reward_char); //check again if online or offline

if(.@xstatus == 0){
mes ""+.@reward_name$+" logged out. Terminating mission sir..";
close;
}

for( set .@i,1; .@i < getarraysize( .@rewardamItemGM ); set .@i,.@i + 1 ){
if( .@i == .@ItemGM ) {
set .@rewardItemGMx,.@rewardItemGM[.@i];
set .@rewardamItemGMx,.@rewardamItemGM[.@i];
getitem .@rewardItemGMx,.@rewardamItemGMx,.@reward_acc;
}
}

message .@reward_name$,"You've been rewarded by Game Master "+strcharinfo(0)+" a "+getitemname(.@rewardItemGMx)+"(s).";
announce "Game Master "+strcharinfo(0)+" rewarded "+.@reward_name$+" a "+.@rewardamItemGMx+" "+getitemname(.@rewardItemGMx)+"(s).",bc_all,bc_yellow;

/* Insert to database for History */
query_sql "INSERT INTO `Item_command` (`char_name`, `won_id`, `nameid`, `amount`, `date`) VALUES ('"+strcharinfo(0)+"', '"+.@reward_name$+"', '"+.@rewardItemGMx+"', '"+.@rewardamItemGMx+"', '"+.@date$+"')";
close;
break;

//=================================== GUILD
case 2:
mes "Please input the Guild Master name:";
next;
input .@gmGuild$;

set .@reward_guildM,getcharid(2,""+.@gmGuild$+""); //get guild ID
set .@reward_char, getcharid(0,""+.@gmGuild$+""); //get Char id
set .@reward_acc, getcharid(3,""+.@gmGuild$+""); //get account id

set .@status, isloggedin(.@reward_acc,.@reward_char); //check if the Guild Master is online or offline
if(.@status == 0){
mes "The Guild Master with a name of "+.@gmGuild$+" is now offline or you got the wrong name, please review it..";
close;
}

mes "Guild Name - "+getguildname(.@reward_guildM);
mes "Guild ID - "+.@reward_guildM;
close;
break;


//=================================== PARTY
case 3:
mes "Please input the Character name of the Party Member, just one member:";
next;
input .@gmPartyPips$;

set .@reward_partyid,getcharid(1,""+.@gmPartyPips$+""); //get party ID
set .@reward_char, getcharid(0,""+.@gmPartyPips$+""); //char id
set .@reward_acc, getcharid(3,""+.@gmPartyPips$+""); //account id
set .@reward_leaderaid, getpartyleader(.@reward_partyid,1); //get party leader acc id
set .@reward_leadercid, getpartyleader(.@reward_partyid,2); //get party leader char id

set .@status, isloggedin(.@reward_acc,.@reward_char); //check if the Party Member is online or offline
set .@xstatus, isloggedin(.@reward_leaderaid,.@reward_leadercid); //check if the Party Leader is online or offline

if(.@status == 0){
mes "The Party member with a name of "+.@gmPartyPips$+" is now offline or you got the wrong name, please review it..";
close;
}

if(.@xstatus == 0){
mes "The Party leader with a name of "+rid2name(.@reward_leaderaid)+" is now offline or you got the wrong name, please review it..";
close;
}

for( set .@i,1; .@i < getarraysize( .@rewardItemGM ); set .@i,.@i + 1 ){
set .@rewardMenu$,.@rewardMenu$ + getitemname( .@rewardItemGM[.@i] )+":";
}

set .@ItemGM,select( .@rewardMenu$ );

getpartymember .@reward_partyid,0; // array name of all party members
getpartymember .@reward_partyid,2; // array account id of all party members

set .@count, $@partymembercount;
copyarray .@accidParty[0], $@partymemberaid[0], $@partymembercount;
copyarray .@name$[0], $@partymembername$[0], $@partymembercount;

for (set .@i,0; .@i < .@count; set .@i, .@i+1) {
message .@name$[.@i],"Please don't log out as Game Master "+strcharinfo(0)+" will give you some reward. Thank you.";
}

for (set .@i,0; .@i < .@count; set .@i, .@i+1) {
mes (.@i +1) + ". ^0000FF" + .@name$[.@i] + "^000000";
getitem .@rewardItemGM[.@ItemGM],.@rewardamItemGM[.@ItemGM],.@accidParty[.@i];
message .@name$[.@i],"You've been rewarded by Game Master "+strcharinfo(0)+" a "+.@rewardamItemGM[.@ItemGM]+" "+getitemname(.@rewardItemGM[.@ItemGM])+"(s).";
}
dispbottom "The list of name are those party member who received the rewards, those offline are not included..";
announce "Game Master "+strcharinfo(0)+" rewarded "+getpartyname(.@reward_partyid)+"'s Party a "+.@rewardamItemGM[.@ItemGM]+" "+getitemname(.@rewardItemGM[.@ItemGM])+"(s).",bc_all,bc_yellow;

query_sql "INSERT INTO `Item_command` (`char_name`, `party_name`, `nameid`, `amount`, `date`) VALUES ('"+strcharinfo(0)+"', '"+getpartyname(.@reward_partyid)+"', '"+.@rewardItemGM[.@ItemGM]+"', '"+.@rewardamItemGM[.@ItemGM]+"', '"+.@date$+"')";
//mes "Party Leader - "+rid2name(.@reward_leaderaid);
//mes "Party Name - "+getpartyname(.@reward_partyid);
//mes "Party ID - "+.@reward_partyid;
//mes "Rewarded: "+.@rewardamItemGM[.@ItemGM]+" "+getitemname(.@rewardItemGM[.@ItemGM])+"";
close;
break;
}
break;

case 2:
switch(select("Individual:Party:Guild")){
case 1:
query_sql "SELECT `char_name`, `won_id`, `nameid`, `amount`, `date` FROM `Item_command` ORDER BY `date` DESC LIMIT 5", @gmID$, @wonID$, @rewardID, @rewAm, @history$;
if(getarraysize(@gmID$) == 0) { goto L_Nodata; end; }
mes "^FF0000Name-Receiver-Item-Amount-Date^000000";
for (set .@i,0; .@i < getarraysize(@gmID$); set .@i, .@i+1){
mes "^FF0000[ "+(.@i+1) + "]. ^000000 ["+ @gmID$[.@i] +"] ["+ @wonID$[.@i] +"] ["+ @rewardID[.@i] +"] ["+ @rewAm[.@i] +"] ["+ @history$[.@i] +"]";
}
close;
break;

case 2:
query_sql "SELECT `char_name`, `party_name`, `nameid`, `amount`, `date` FROM `Item_command` ORDER BY `party_name` DESC LIMIT 5", @gmID$, @partyID$, @rewardID, @rewAm, @history$;
if(getarraysize(@partyID$) == 0) { goto L_Nodata; end; }
mes "^FF0000Name-Party-Item-Amount-Date^000000";
for (set .@i,0; .@i < getarraysize(@partyID$); set .@i, .@i+1){
mes "^FF0000[ "+(.@i+1) + "]. ^000000 ["+ @gmID$[.@i] +"] ["+ @partyID$[.@i] +"] ["+ @rewardID[.@i] +"] ["+ @rewAm[.@i] +"] ["+ @history$[.@i] +"]";
}
close;
break;

case 3:
query_sql "SELECT `char_name`, `guild_name`, `nameid`, `amount`, `date` FROM `Item_command` ORDER BY `guild_name` DESC LIMIT 5", @gmID$, @guildID$, @rewardID, @rewAm, @history$;
if(getarraysize(@guildID$) == 0) { goto L_Nodata; end; }
mes "^FF0000Name-Guild-Item-Amount-Date^000000";
for (set .@i,0; .@i < getarraysize(@guildID$); set .@i, .@i+1){
mes "^FF0000[ "+(.@i+1) + "]. ^000000 ["+ @gmID$[.@i] +"] ["+ @guildID$[.@i] +"] ["+ @rewardID[.@i] +"] ["+ @rewAm[.@i] +"] ["+ @history$[.@i] +"]";
}
close;
break;
}
break;

case 3:
if(getgroupid()< 99) end;
mes "Are you sure you want to Reset the logs?";
next;
if (select("Yes","No")==1){
query_sql "TRUNCATE TABLE `Item_command`";
dispbottom "Records wiped out...You need to relog in order for this to take effect..";
}
close;
break;

close;
}

L_Nodata:
mes "There are no records yet..";
close;
}

 

Edited by kerbiii

Share this post

Link to post
Share on other sites

7 answers to this question

Recommended Posts

  • 0

Patskie    88

Patskie
Posted

Execute this on your database :

CREATE TABLE IF NOT EXISTS `ragnarok`.`item_command` (	`char_name` VARCHAR(30) NOT NULL DEFAULT '',	 `won_id` VARCHAR(50) NOT NULL DEFAULT '',	`nameid` INT(11) NOT NULL DEFAULT '0',	`amount` INT(11) NOT NULL DEFAULT '0',	`date` DATE NOT NULL) ENGINE=MyISAM;

Share this post

Link to post
Share on other sites
  • 0

kerbiii    5

kerbiii
Posted (edited)

 

Execute this on your database :

CREATE TABLE IF NOT EXISTS `ragnarok`.`item_command` (	`char_name` VARCHAR(30) NOT NULL DEFAULT '',	 `won_id` VARCHAR(50) NOT NULL DEFAULT '',	`nameid` INT(11) NOT NULL DEFAULT '0',	`amount` INT(11) NOT NULL DEFAULT '0',	`date` DATE NOT NULL) ENGINE=MyISAM;

excuted it properly but still nothing appears on my npc it gives me a blank menu and not asking for input ID and input ammount i think i miss something on my script but i cant find it,  and when i check the logs i get stuck

Edited by kerbiii

Share this post

Link to post
Share on other sites
  • 0

kerbiii    5

kerbiii
Posted

are you sure it was executed properly? because your server can't read it in your sql. please re-check..

yes it was now, but i think my script is wrong can you take a look at it?

Share this post

Link to post
Share on other sites
  • 0

quesoph    105

quesoph
Posted (edited)

You are missing some parts.

 

 

Try to change this:

because .@rewardItemGM[1] has no value thats why your menu is empty..

same with .@rewardamItemGM[1].

 

setarray .@rewardItemGM[1],.@itemid; //Item IDssetarray .@rewardamItemGM[1],.@itemcount; //Item Amounts

 

to this:

 

setarray .@rewardItemGM[1],501,502,503; //Item IDssetarray .@rewardamItemGM[1],1,2,3; //Item Amounts
Edited by quesoph

Share this post

Link to post
Share on other sites
  • 0

kerbiii    5

kerbiii
Posted

 

You are missing some parts.

 

 

Try to change this:

because .@rewardItemGM[1] has no value thats why your menu is empty..

same with .@rewardamItemGM[1].

 

setarray .@rewardItemGM[1],.@itemid; //Item IDssetarray .@rewardamItemGM[1],.@itemcount; //Item Amounts

 

to this:

 

setarray .@rewardItemGM[1],501,502,503; //Item IDssetarray .@rewardamItemGM[1],1,2,3; //Item Amounts

yes it was that before but i try to change it to input ID and input ammount instead of fixed prize i want my event gm to choose any item they want

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
Sign in to follow this  
Followers 0
Go To Question Listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept