Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //=========================================================================//
- /*
- Script Name : Information Center
- Script Creator : maniacsociety
- Script Function :
- - Server Information Center
- - To know more about your Server
- - SQL Function
- - Send Support Ticket
- - Donation Panel
- - Code panel
- */
- //=========================================================================//
- // Npc Location
- //=========================================================================//
- prontera.gat,153,181,5 script Information Center 910,{
- //=========================================================================//
- // Configuration
- //=========================================================================//
- set .@gmcode$,callsub(S_GenerateRandStr,10,12);
- set .@gmcodes$,callsub(S_GenerateRandStr,10,12);
- set .@gm1$,callsub(S_GenerateRandStr,10,12);
- set .@gm2$,callsub(S_GenerateRandStr,10,12);
- set .@npcname$,"^FF0000[Information Center Assistant]^000000";
- set .@code$,"^FFF000[Encoder Department Assistant]^000000";
- set .@donate$,"^0000FF[Donation Department Assistant]^000000";
- set .@server$,"^FFFF00[National Ragnarok Online]^000000";
- set .@admincp$,"^FF0000[09993591472]^000000";
- //=========================================================================//
- // NPC On Talk
- if(getgmlevel() <99) goto NormalPlayerViews;
- if(getgmlevel() >= 99) goto AdminViews;
- //=========================================================================//
- NormalPlayerViews:
- cutin "zonda_01",2;
- mes .@npcname$;
- mes "Welcome "+strcharinfo(0)+" to the "+.@server$+" Information Center";
- mes "I am here to guide you.";
- mes "What do you want to know?";
- next;
- switch(select("About this Server:Donation:Encode:Cancel")){
- case 1:
- mes .@npcname$;
- mes "Please wait while redirecting to our Main Department.";
- next;
- goto ServerInfo;
- case 2:
- mes .@npcname$;
- mes "Please wait while redirecting to our Donation Department.";
- next;
- goto DonationInfo;
- case 3:
- mes .@npcname$;
- mes "Please wait while redirecting to our Encoder Department";
- next;
- goto EncodeInfo;
- case 4:
- mes .@npcname$;
- mes "Thank you for visiting "+.@server$+" Information Center";
- close;
- }
- cutin "", 255;
- end;
- //=========================================================================//
- ServerInfo:
- cutin "zonda_01",2;
- mes .@npcname$;
- mes "Hello Im back.";
- mes "Which of the following you want to know?";
- menu "Send Support Ticket",L_SST,"Server Information",L_SI,"Game Master List",L_GML,"Cancel",-;
- mes .@npcname$;
- mes "Thank you for visiting Information Center.";
- mes "You can come back anytime you want";
- close;
- L_SST:
- mes .@npcname$;
- mes "Okay before we continue on sending a support ticket.";
- mes "I will guide you on how or what to do.";
- next;
- mes .@npcname$;
- mes "----------------- Guide -----------------";
- mes "First : ";
- mes "Enter your name";
- mes "Second : ";
- mes "Subject of the letter";
- mes "Third : ";
- mes "Message";
- next;
- mes .@npcname$;
- mes "Please enter your name";
- input .@acc_n$;
- query_sql "SELECT `userid` FROM `login` WHERE `userid` = '"+@acc_n$+"'";
- if(.@acc_n$ == "") {
- next;
- mes .@npcname$;
- mes "The name you enter is not located at our system please try again.";
- goto L_SST;
- } else {
- next;
- mes .@npcname$;
- mes "You enter your name successfully.";
- mes "Next Enter the Subject Letter";
- input .@subject$;
- next;
- mes .@npcname$;
- mes "You Enter this "+.@subject$+" as your subject.";
- mes "And now the message.";
- input .@message$;
- next;
- mes .@npcname$;
- mes "You Enter this as your message.";
- next;
- mes .@npcname$;
- mes "Input your email address in case we cannot contact you online.";
- input .@mail$;
- next;
- mes .@npcname$;
- mes "-------------- Full Info ---------------";
- mes "Name : "+.@acc_n$+" ";
- mes "Subject : "+.@subject$+" ";
- mes "Message : ";
- mes ""+.@message$+" ";
- next;
- query_sql "INSERT INTO `supportsystem` (`account_name`,`subject`,`message`,`email`) VALUES ( '"+.@acc_n$+"' , '"+.@subject$+"' , '"+.@message$+"' , '"+.@mail$+"' )";
- mes .@npcname$;
- mes "We are now sending a message to our department.";
- mes "We will send you a message once our head department read it.";
- close;
- cutin "", 255;
- end;
- L_SI:
- mes .@npcname$;
- mes "Server Information";
- mes "Server Name : "+.@server+" ";
- mes "Server Rates : 1000/1000/1000";
- mes "Server Status : Online";
- next;
- mes .@npcname$;
- mes "Card & Equipment Rates";
- mes "Normal Card : 7.00";
- mes "Boss Card : 1.00";
- mes "Normal Equip : 40.00";
- mes "Boss Equip : 50.00";
- next;
- mes .@npcname$;
- mes "Server NPC";
- mes "Job Changer";
- mes "Kafra";
- mes "Platinum Skill";
- mes "Universal Rental";
- mes "Stylist";
- mes "PvP";
- mes "GvG";
- mes "Healer";
- mes "Reset Girl";
- mes "And many more.";
- next;
- mes .@npcname$;
- mes "Custom Items :";
- mes "Weapon";
- mes "Wings";
- mes "Armor";
- mes "Shield";
- mes "Headgear";
- mes "Accessory";
- mes "Card";
- mes "Set";
- close;
- cutin "", 255;
- end;
- L_GML:
- next;
- mes .@npcname$;
- mes "Here are the list of Game Master";
- mes "^FF0000Admin Chivas^000000";
- mes "- Server Owner";
- mes "- Main Admin";
- mes "- Server Host";
- next;
- mes .@npcname$;
- mes "^FFF000Admin Glade^000000";
- mes "- Scripter";
- mes "- Developer";
- mes "- Co-Admin";
- mes "- Co-Owner";
- next;
- mes .@npcname$;
- mes "^0000FFGM Force^000000";
- mes "- Event GM";
- mes "- Customier";
- close;
- cutin "", 255;
- end;
- //=========================================================================//
- DonationInfo:
- cutin "kafra_02",2;
- mes .@donate$;
- mes "This is the Donation Department";
- mes "How may I help you sir?";
- menu "^FFF000Get My Code^000000",L_GMC,"^0000FFDonate^000000",L_D,"Donation Info",L_DI,"Cancel",-;
- mes .@donate$;
- mes "Thank you for visiting Donation Department";
- close;
- L_GMC:
- mes .@donate$;
- mes "Welcome "+strcharinfo(0)+"";
- mes "Are you here to claim your donate?";
- next;
- mes "Input your validation code.";
- input .@valid$;
- query_sql "SELECT `validation` FROM `donatesystem` WHERE `validation` ='"+.@valid$+"'";
- if(.@valid$ == "") {
- next;
- mes "The validation code you enter is incorrect.";
- mes "Please try again";
- goto DonationInfo;
- } else {
- next;
- mes .@donate$;
- mes "You enter a correct validation code.";
- mes "Here is you Code.";
- query_sql "SELECT `code` FROM `donatesystem` WHERE `validation`= '"+.@valid$+"'", .@codenumber$;
- next;
- mes .@donate$;
- mes " "+.@codenumber$+" ";
- dispbottom "Code : ["+.@codenumber$+"] ";
- close;
- L_D:
- next;
- mes .@donate$;
- mes "Donate? You cannot donate online";
- mes "Except for Load Donation";
- next;
- mes .@donate$;
- mes "You want to donate by Load Donation?";
- next;
- mes "Enter you account name";
- input .@acc_name$;
- next;
- mes "Enter the Phone Number";
- input .@cp_n$;
- next;
- mes "Enter the amount";
- input .@cp_amount$;
- query_sql "INSERT INTO `donatesystem` ( `account_name` , `phonenumber` , `amount` ) VALUES ('"+.@acc_name$+"' ,'"+.@cp_n$+"' ,'"+.@cp_amount$+"')";
- next;
- mes .@donate$;
- mes "Once we confirm the load donation";
- mes "We will email you in game with the validation code.";
- next;
- mes .@donate$;
- mes "If you load the amount already and verify already.";
- mes "By receiving the email.";
- mes "You can simply get you code.";
- next;
- goto DonationInfo;
- L_DI:
- mes .@donate$;
- mes "Which contact of Admin you want to view?";
- next;
- menu "Admin Chivas",L_AC$,"Admin Glade",-;
- mes .@donate$;
- mes "Donation Information Center";
- next;
- mes "How to Donate? for Admin Glade?";
- mes "PayPal, Western Union, LBC & Other Transfer Method";
- mes "Name : Mark Willow Aldave";
- mes "Age : 18";
- mes "Address : ISG Central Zone II Western Bicutan Taguig City";
- mes "Phone Number : "+.@admincp$+" ";
- next;
- mes "Load Donation Method?";
- mes "1. Name";
- mes "2. Phone Number";
- mes "3. Amount";
- mes "And then send to "+.@admincp$+" ";
- next;
- mes "How to claim the donate?";
- mes "Our system will email you as soon as possible you`ve done donating";
- mes "If we already verify the donate we will email you.";
- next;
- mes "Once you receive an email thats the validation code you have to enter it into encoder department.";
- close;
- L_AC$:
- mes .@donate$;
- mes "Donation Information Center";
- next;
- mes "How to Donate? for Admin Glade?";
- mes "PayPal, Western Union, LBC & Other Transfer Method";
- mes "Name : N/A";
- mes "Age : N/A";
- mes "Address : N/A";
- mes "Phone Number : N/A ";
- next;
- mes "Load Donation Method?";
- mes "1. Name";
- mes "2. Phone Number";
- mes "3. Amount";
- mes "And then send to N/A ";
- next;
- mes .@npcname$;
- mes "Visit our site for Admin Chivas";
- mes "www.nationalro.axwebs.com";
- next;
- mes "How to claim the donate?";
- mes "Our system will email you as soon as possible you`ve done donating";
- mes "If we already verify the donate we will email you.";
- next;
- mes "Once you receive an email thats the validation code you have to enter it into encoder department.";
- close;
- cutin "", 255;
- end;
- //=========================================================================//
- EncodeInfo:
- cutin "kafra_05",2;
- mes .@code$;
- mes "Welcome to Encoder Department";
- mes "How may I help you?";
- menu "Enter My Code",L_EMC,"Cancel",-;
- next;
- mes .@code$;
- mes "Thank you for visiting Encoder department you can come back if you want.";
- close;
- L_EMC:
- next;
- mes .@code$;
- mes "Please enter your code";
- input .@codelist$;
- if(query_sql("SELECT `codelist`,`status`=1 FROM `encodesystem` WHERE `codelist`='"+escape_sql(.@codelist$)+"'", .@codelist$,.@used))
- if(.@used){
- next;
- mes .@code$;
- mes "This code is correct but its already used by another character.";
- mes "Please input a different code.";
- close;
- } else {
- query_sql "UPDATE `encodesystem` SET `status`=0 WHERE `codelist`='"+.@codelist$+"'";
- mes .@code$;
- mes "This code is valid and correct.";
- mes "Redirecting to Shop Department";
- query_sql "UPDATE `encodesystem` SET `status`=1 WHERE `codelist`='"+.@codelist$+"'";
- next;
- goto ShopInfo;
- } else {
- mes .@code$;
- mes "The system cannot find your code";
- mes "Please enter a valid one.";
- close;
- ShopInfo:
- mes "^FFFF00[Shop Department]^000000";
- mes "Please choose your desired item";
- next;
- switch(select("100 Gacha Box",
- "5000 Coupon",
- "4000 nRO Cash Ticket",
- "Unknown Box 1",
- "Unknown Box 2",
- "Unknown Box 3",
- "Unknown Box 4",
- "Unknown Box 5")){
- case 1: callsub L_Reward,30800,100;
- case 2: callsub L_Reward,30800,100;
- case 3: callsub L_Reward,30800,100;
- case 4: callsub L_Reward,30800,100;
- case 5: callsub L_Reward,30800,100;
- case 6: callsub L_Reward,30800,100;
- case 7: callsub L_Reward,30800,100;
- }
- L_Reward:
- mes "^FFFF00[Shop Department]^000000";
- mes "Request Confirm";
- getitem getarg(0),getarg(1);
- close;
- cutin "", 255;
- end;
- }
- }
- }
- //=========================================================================//
- AdminViews:
- mes .@npcname$;
- mes "Welcome "+strcharinfo(0)+" to the "+.@server$+" Information Center.";
- mes "How may I help yah sir?";
- next;
- menu "View Support Ticket Log",L_VSTL,"View Donation Log",L_VDL,"View Code Log",L_VCL,"Add Code",L_AC,"Add Donation",L_AD,"Add Validation",L_AV,"Delete Code^000000",L_DC,"Delete Donate",L_DD,"Player Views",L_PV;
- L_VSTL:
- mes .@npcname$;
- mes "This is the list of character who send support ticket";
- query_sql "SELECT `account_name` , `subject` , `message` , `email` FROM `supportsystem` ORDER BY `account_name` DESC", .@acc_n$, .@subject$, .@message$, .@mail$;
- if(.@acc_n$) {
- mes .@npcname$;
- mes "There are no entrys in the Support Ticket List.";
- close;
- } else {
- next;
- mes .@npcname$;
- mes "The list will spawn at your main chat box.";
- dispbottom "Account Name | Subject | Message | Email";
- for(set @ei,0; @ei < getarraysize(.@acc_n$); set @ei,@ei + 1) {
- dispbottom ""+.@acc_n$[@ei]+" | "+.@subject$[@ei]+" | "+.@message$[@ei]+" | "+.@mail$[@ei]+" ";
- goto AdminViews;
- L_VDL:
- mes .@npcname$;
- mes "This is the list of donation logs";
- query_sql "SELECT `account_name` , `phonenumber` , `amount` FROM `donatesystem` ORDER BY `account_name` DESC", .@acc_name$, .@cp_n$, .@cp_amount$;
- if(.@acc_name$) {
- mes .@npcname$;
- mes "There are no entrys in the Donation List.";
- close;
- } else {
- next;
- mes .@npcname$;
- mes "The list will spawn at your main chat box.";
- dispbottom "Account Name | Phone Number | Amount";
- for(set @ei,0; @ei < getarraysize(.@acc_name$); set @ei,@ei + 1) {
- dispbottom ""+.@acc_name$[@ei]+" | "+.@cp_n$[@ei]+" | "+.@cp_amount$[@ei]+" ";
- next;
- goto AdminViews;
- L_VCL:
- mes .@npcname$;
- mes "This is the list of code logs";
- query_sql "SELECT `codelist` , `status` , `validation` FROM `encodesystem` ORDER BY `codelist` DESC", .@codelist$, .@status$, .@validation$;
- if(.@codelist) {
- mes .@npcname$;
- mes "There are no entrys in the Code List.";
- close;
- } else {
- next;
- mes .@npcname$;
- mes "The list will spawn at your main chat box.";
- dispbottom "Codelist | Status | Validation";
- for(set @ei,0; @ei < getarraysize(.@codelist$); set @ei,@ei + 1) {
- dispbottom ""+.@codelist$[@ei]+" | "+.@status$[@ei]+" | "+.@validation$[@ei]+" ";
- next;
- goto AdminViews;
- L_AC:
- mes .@npcname$;
- mes "Do you want to add code?";
- mes "Please enter the code.";
- next;
- input .@codelist$;
- next;
- mes "Please input now the code status";
- input .@status$;
- next;
- mes "And now input the validation for the code.";
- input .@validation$;
- next;
- mes .@npcname$;
- mes "This is what you enter.";
- mes "Code : "+.@codelist$+" ";
- mes "Status : "+.@status$+" ";
- mes "Validation : "+.@validation$+" ";
- next;
- query_sql "INSERT INTO `encodesystem` ( `codelist` ,`status`,`validation`) VALUES ( '"+.@codelist$+"' , '"+.@status$+"' , '"+.@validation$+"' )";
- mes .@npcname$;
- mes "Code has been successfully added.";
- next;
- goto AdminViews;
- set .@stats$,1;
- L_AD:
- mes .@npcname$;
- mes "Do you want to add donation?";
- mes "Please input the donator name";
- input .@name$;
- next;
- mes "Input the Phone Number";
- input .@cp$;
- next;
- mes "Input the donated amount";
- input .@amount$;
- next;
- mes "This is the validation code.";
- mes " "+.@gm1$+" ";
- next;
- mes "This is the code.";
- mes " "+.@gm2$+" ";
- next;
- mes .@npcname$;
- mes "This is the new donation that you have been added.";
- mes "Donator Name : "+.@name$+" ";
- mes "Phone Number : "+.@cp$+" ";
- mes "Amount : "+.@amount$+" ";
- mes "Validation : "+.@gm1$+"";
- mes "Code : "+.@gm2$+" ";
- next;
- query_sql "INSERT INTO `donatesystem` (`account_name`,`phonenumber`,`amount`,`validation`,`code`) VALUES ('"+.@name$+"','"+.@cp$+"','"+.@amount$+"','"+.@gm1$+"','"+.@gm2$+"')";
- query_sql "INSERT INTO `encodesystem` (`codelist`,`status`,`validation`) VALUES ('"+.@gm2$+"','"+.@stats$+"','"+.@gm1$+"')";
- mes .@npcname$;
- mes "Donation has been added";
- next;
- goto AdminViews;
- set .@codestats$,0;
- L_AV:
- mes .@npcname$;
- mes "Add a validation to unvalidate donate?";
- mes "but first I have to ask some questions";
- mes "Please input the Character Name";
- input .@name$;
- next;
- query_sql "SELECT `account_name` FROM `donatesystem` WHERE `account_name` = '"+.@name$+"'", @check_id$;
- if(@check_id$) {
- mes "Invalid Name, please try again.";
- goto L_AV;
- } else {
- next;
- dispbottom "Character Name: "+.@name$;
- mes .@npcname$;
- mes "This is the validation code for that account";
- mes " "+.@gmcode$+" ";
- next;
- mes .@npcname$;
- mes "This is the code for that account";
- mes " "+.@gmcodes$+" ";
- next;
- mes .@npcname$;
- mes "This is what you want to add.";
- mes "Character Name : "+.@name$+" ";
- mes "Validation Code : "+.@gmcode$+" ";
- mes "Code : "+.@gmcodes$;
- next;
- query_sql "UPDATE `donatesystem` SET `validation`='"+.@gmcode$+"' WHERE `account_name`='"+.@name$+"'";
- query_sql "UPDATE `donatesystem` SET `code`='"+.@gmcodes$+"' WHERE `account_name`='"+.@name$+"'";
- query_sql "INSERT INTO `encodesystem` (`codelist`,`status`,`validation`) VALUES ('"+.@gmcodes$+"','"+.@codestats$+"','"+.@gmcode$+"')";
- query_sql "UPDATE `encodesystem` SET `validation`='"+.@gmcode$+"' WHERE `codelist`='"+.@gmcodes$+"'";
- query_sql "UPDATE `encodesystem` SET `status`='"+.@codestats$+"' WHERE `codelist`='"+.@gmcodes$+"'";
- mes .@npcname$;
- mes "You have successfully add the validation";
- next;
- goto AdminViews;
- L_DC:
- mes .@npcname$;
- mes "Code Delete System";
- mes "Please choose,";
- mes "Which you want to be deleted";
- next;
- query_sql "SELECT `codelist` , `status` , `validation` FROM `encodesystem`", .@codelist$, .@status$, .@validation$;
- if(.@codelist$ == "") {
- mes .@npcname$;
- mes "There is no entry at Code System.";
- close;
- }
- set @code_menu$,"";
- for(set @ei,0; @ei < getarraysize(.@codelist$); set @ei,@ei + 1) {
- mes "Code System List";
- mes .@codelist$[@ei];
- mes "---- Status ----";
- mes .@status$[@ei];
- mes "-- Validation --";
- mes .@validation$;
- set @code_menu$,@code_menu$ + "- "+.@codelist$[@ei]+":";
- }
- set @code_menu$,@code_menu$ + "- Nothing";
- if((prompt(@code_menu$) - getarraysize(.@codelist$)) > 0) {
- break;
- } else {
- next;
- set @ip,@menu - 1;
- mes .@npcname$;
- mes "You have choosen";
- mes "Code Name ";
- mes .@codelist$[@ip];
- mes "---- Status ----";
- mes .@status$[@ip];
- mes "-- Validation --";
- mes .@validation$[@ip];
- mes "================";
- mes "Wanna delete this entry";
- next;
- query_sql "DELETE FROM `encodesystem` WHERE `codelist` = '"+.@codelist$[@ip]+"'";
- mes .@npcname$;
- mes "The entry has been deleted.";
- close;
- }
- L_DD:
- mes .@npcname$;
- mes "Donate Delete System";
- mes "Please choose,";
- mes "Which you want to be deleted";
- next;
- query_sql "SELECT `account_name` , `phonenumber` , `amount` FROM `donatesystem`", .@name$, .@cp$, .@amount$;
- if(.@name$ == "") {
- mes .@npcname$;
- mes "There is no entry at Donate System.";
- close;
- }
- set @codes_menu$,"";
- for(set @ei,0; @ei < getarraysize(.@name$); set @ei,@ei + 1) {
- mes "Code System List";
- mes .@name$[@ei];
- mes "- Phone Number -";
- mes .@cp$[@ei];
- mes "---- Amount ----";
- mes .@amount$;
- set @codes_menu$,@codes_menu$ + "- "+.@name$[@ei]+":";
- }
- set @codes_menu$,@codes_menu$ + "- Nothing";
- if((prompt(@codes_menu$) - getarraysize(.@name$)) > 0) {
- break;
- } else {
- next;
- set @ip,@menu - 1;
- mes .@npcname$;
- mes "You have choosen";
- mes "Code Name ";
- mes .@name$[@ip];
- mes "- Phone Number -";
- mes .@cp$[@ip];
- mes "---- Amount ----";
- mes .@amount$[@ip];
- mes "================";
- mes "Wanna delete this entry";
- next;
- query_sql "DELETE FROM `donatesystem` WHERE `account_name` = '"+.@name$[@ip]+"'";
- mes .@npcname$;
- mes "The entry has been deleted.";
- next;
- close;
- }
- L_PV:
- mes .@npcname$;
- mes "Please wait while redirecting to the Player Menu";
- next;
- goto NormalPlayerViews;
- S_GenerateRandStr:
- // getarg(0) = type Value is a bit field (1: lowercase, 2: numbers, 4: symbols, 8: UPPERCASE)
- // getarg(1) = length
- if (getarg(0) & 1) setarray .@chars$[getarraysize(.@chars$)], "a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z";
- if (getarg(0) & 2) setarray .@chars$[getarraysize(.@chars$)], "1","2","3","4","5","6","7","8","9","0";
- if (getarg(0) & 4) setarray .@chars$[getarraysize(.@chars$)], "!","@","#","$","%","^","&","*","(",")","<",">","?";
- if (getarg(0) & 8) setarray .@chars$[getarraysize(.@chars$)], "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z";
- set .@length, getarg(1);
- while (.@length) {
- set .@str$, .@str$ + .@chars$[rand(getarraysize(.@chars$))];
- set .@length, .@length -1;
- }
- return .@str$;
- }
- }
- }
- }
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement