butasro

Where is the Table Script for this? anyone ^^ thanks


anyone update this script ^^ with points like on rathena, and exhange for items, more info with pics, ^^ ty

@@butasro here you go
//===========================================// // Charwipe Script // version 1.0 // By Zhao Chow // Plug and Play Philippines // https://facebook.com/plugandplayPH //==========================================// - script plugandplay#charwipe -1,{ OnInit: bindatcmd "charwipe",strnpcinfo( 3 )+"::OnCharWipe",99,99; end; OnCharWipe: if ( .@atcmd_numparameters < 1 ) { message strcharinfo( 0 ),"Usage: @charwipe <char name>"; } else { .@charname$ = ""; for (.@i = 0; .@i < .@atcmd_numparameters; ++.@i) { .@charname$ += (.@i > 0 ? " " : "") + .@atcmd_parameters$[.@i]; } // Sql query // query_sql("SELECT `name` , `online` FROM `char` WHERE `name` = '"+.@charname$+"'",.@CharNameqry$, .@Onlineqry ); //----------// if ( .@CharNameqry$ != .@charname$ ) { message strcharinfo( 0 ),"Invalid Character Name"; end; } if ( .@CharNameqry$ == .@charname$ && .@Onlineqry == 1 ) { message strcharinfo( 0 ),"Character "+.@charname$+" has been reseted"; atcommand "@kick "+.@charname$; query_sql("UPDATE `char` SET `class`= 0 , `base_level` = 1 , `job_level` = 1 , `base_exp` = 1 , `job_exp` = 1 , `str` = 1 , `agi` = 1 , `vit` = 1 , `INT` = 1 , `dex` = 1 , `luk` = 1 , `status_point` = 48 , `skill_point` = 0 , `homun_id` = 0 WHERE `name`='"+.@charname$+"'"); end; } if ( .@CharNameqry$ == .@charname$ && .@Onlineqry == 0 ) { message strcharinfo( 0 ),"Character "+.@charname$+" has been reseted"; query_sql("UPDATE `char` SET `class`= 0 , `base_level` = 1 , `job_level` = 1 , `base_exp` = 1 , `job_exp` = 1 , `str` = 1 , `agi` = 1 , `vit` = 1 , `INT` = 1 , `dex` = 1 , `luk` = 1 , `status_point` = 48 , `skill_point` = 0 , `homun_id` = 0 WHERE `name`='"+.@charname$+"'"); end; } } end; }

example :
@charwipe butasro
then your char will become novice and blvl & jlvl will turn into 1 right?
 
Edit : give me 10mins to make the script

http://upaste.me/08d8226956edfea7b

change Case to case

Check when what?
When login?
When level up?
When click on NPC?
 
When login:
 
OnPCLoginEvent: if(BaseLevel == 90)  announce "announce", bc_self; end;    
When levelup:
 
OnPCBaseLvUpEvent: if(BaseLevel == 90)     announce "announce", bc_self; end;    
When Click:
 
npc_header { if(BaseLevel == 90) {     announce "announce", bc_self; } else {   // not 90 lvl } }  

prt_fild08,176,346,3    script    name    50,{ mes "input new name"; input(@name$); query_sql("SELECT name FROM `char` WHERE `name` = '" + @name$ + "'", @newName$); if(@newName$ != ""){ mes "this name is already used"; close; } for(.i = 0; .i < getarraysize(.badSymbol$); .i++){ if(compare(@name$, .badSymbol$[.i])){ mes "you can't use name with this symbol"; close; } } // changename close; OnInit: setarray .badSymbol$[0], "#", "@"; //add your's end; } idk, try this. I don't have a server for test now :<

i dont give you a code that change the name
 
for change name replace this:
 
// changename
 
to this:
query_sql("UPDATE `char` SET `name` = '" + @name + "' WHERE `char_id` = '" + getcharid(0) + "'");

150$ basic functionality +70$ some additional functions

Hello, community
 
I wanna show you my release - Followers like in World of Warcraft (maybe XD)
I start write this in august 2015 o.O
Current version: 2.0.1
Languages: Russian/English
FluxCP addon: included
 
 
Some info: (sorry for my English)
 
Based on SQL and dynamic variables.
4 classes: Warrior, Healer, Mage, Assassin
Max. Follower level: 7
Followers have a item level.
 
Mission types:
Standart- rewards taken from SQL
Random- rewards taken from arrays for each follower level
Special (if variable random_reward = 1) you can set your special item ID for each mission, if random reward is ON.
 
Chance for complete:
You can set your standart chance for complete mission (standart: 25%)
Each mission have a requirement for item level (if you want)
So, if mission req. item level = 50 and Follower item level = 100 chance for complete will be like 60% (if 25 = standart)
But if Follower item level = 0 and mission item level = 50 chance will be (5%~)
 
How to create a new Follower from game?
You can create a NPC that gives a Followers, or new items for each Follower
For create just use a function: 
callfunc("Companion_Create", unique_id from 'companion_list' table in SQL); I have a companion in DB:
Name: Mellisandra
UniqueID: 1
Class: 2 (healer)
 
so, i create a simple script:
 
map,x,y,face[tab]script[tab]Simple Follower[tab]sprite,{ mes "Hello! I can create Follower for you!"; next; if(select("yes, please!:No, thx") == 2) close; callfunc("Companion_Create", 1); close; }  
this script will give a player Follower with ID 1 (Mellisandra)
 
Guys, i'm really sorry for my english, I wanted to tell you all information, but I can not express the idea
Maybe someone will use this and create guide for you.
I'll try to answer your questions.
 
Special thanks for: Google Translate.
Good luck:)
 
Script: http://pastebin.com/5cMPGsMh
SQL: http://pastebin.com/465XdhBr
Time function: http://upaste.me/aba022682946e3a7d
 
Together (with FluxCP addons): Companions_ENGLISH.rar
 
Preview addons:
http://kubix-service.ru/?module=followers&action=list_all
http://kubix-service.ru/?module=missions&action=list

Preview video (russian interface, sorry):
https://www.youtube.com/watch?v=j3u4dIfKVs0&feature=youtu.be
https://www.youtube.com/watch?v=cdGGQ50VmhY&feature=youtu.be
 
 
Original post from Russian eA-Support: http://ea-support.ws/index.php?/topic/3467-s-sistema-soratnikov-world-of-warcraft/

switch(Sex)
{
case 0:
mes "female";
close;
case 1:
mes "male";
close;
}

request: http://herc.ws/board/topic/11776-request-forum-system/
 
For?
You can give rewards ingame for forum achievements.
Example:
 
100 messages = 500K zeny
20 likes = 50k zeny
3 trophies = 3K zeny
and whatever you want:)
 
Maybe later I will write a new functions for give rewards on forum for achievements in game
Example:
100 pvp kills = new icon on forum and etc.
 
Info:
Forum tables must be in one database with ragnarok tables (because I do not remember whether you can use a different database from RO, in addition to the one that is configured in inter_athena)
 
Video: https://youtu.be/2C3VzMWV2G4
Download (sample NPC and FluxCP addon): Google Drive
 
Configure /addons/integration/lang/en_us.php !