Sanasol

dont know why, but many visitors didnt try demo... so here video that shows how it work

Enticing title - done Showcase RO:SE - start just now hey everyone! I'm Sanasol I want to introduce you my awesome web project. Tools used for it: brain, hands, php, js, html, css, google and pinch of magic Multi accs & Storage Transfe Main feature multi game account system. That mean you have master account(on site), then you can create game accounts attached to your master account. So RO:SE bring to you possibility to transfer storage items between all of your game accounts Main storage As well you have (main)storage on site with unlimited space Some functions Also you can reset char position and see how your chars looks like. Character view based on RMS: Ro Character Simulator Status: RC1 drumroll, aaaaaaand.... DEMO

3912

suggest to use account bound items to prevent new account birthday exploit ofc Need check for IP(or something else) or account bound

prontera,160,180,5 script TCG Trader 757,{ set .max_zeny,1000000000; set .@price,500000000; mes "[^0000FFTrader^000000]"; mes "I can change ur TCG <> Zeny"; //mes "or Zeny to TCG"; mes "1 TCG = 500kk Zeny"; //mes "I see u have: ^00FF00 "+countitem(7227)+"^000000 TCG"; //mes "and Zeny: ^FF0000"+Zeny+"^000000"; mes "So what do u want?"; switch( select("^00FF00TCG^000000 > ^FF0000Zeny^000000","^FF0000Zeny^000000 > ^00FF00TCG^000000","Quit")) { case 1: set .@maximum,(( .max_zeny - Zeny ) / .@price ); mes "You can change maximum "+.@maximum+" x ^00FF00TCG^000000"; next; mes "[^0000FFTrader^000000]"; mes "What count of ^00FF00TCG^000000 u wanna change?(It cant be more than 2 at a time)"; input @count,0,.@maximum; if(@count > .@maximum || @count <= 0) { mes "Sorry I cant do that, u've too many Zeny or dont have TCG"; close; } else { if(countitem(7227) < @count) { mes "You scammer, wanted to deceive me? GTFO"; close; } else { delitem 7227,@count; set Zeny,Zeny+(.@price*@count); mes "Ok, get ur ^FF0000Zeny^000000. Bye!"; close; } } close; break; case 2: set .@maximum,(Zeny / .@price ); mes "You can get maximum "+.@maximum+" x ^00FF00TCG^000000"; next; mes "[^0000FFTrader^000000]"; mes "What count of ^00FF00TCG^000000 u wanna get?"; input @count,0,.@maximum; if(@count > .@maximum || @count <= 0) { mes "Sorry I cant do that, U dont have enough ^FF0000Zeny^000000"; close; } else { if(Zeny < @count*.@price) { mes "You scammer, wanted to deceive me? GTFO"; close; } else { getitem 7227,@count; set Zeny,Zeny-(.@price*@count); mes "Ok, get ur ^00FF00TCG^000000. Bye!"; close; } } close; break; case 3: mes "[^0000FFTrader^000000]"; mes "Good bye!"; close; break; } } lil bit of edit and it will like you want

- script birthday -1,{ OnPCLoginEvent: if(#last_bdyear != gettime(7)) { set @nb, query_sql("select birthdate from `login` where `account_id`='"+getcharid(3)+"'", @bdate$); explode(.@bdate$, @bdate$, "-"); set .@curdate$, gettimestr("%m%d",21); if(.@curdate$ == (.@bdate$[1]+""+.@bdate$[2])) { getitem 7227,1; set #last_bdyear,gettimestr("%Y",21); set @byear, .@bdate$[0]; set .@sexword$, (sex) ? "his":"her"; announce "Hey everyone, "+strcharinfo(0)+" celebrates "+.@sexword$+" "+(#last_bdyear-@byear)+" birthday!",bc_blue|bc_all; } } end; }

maybe no memory left ram/swap?

noooo rAthena Board → Other Support & Releases → Graphic Enhancements → Graphics Requests

src/char/char.c function mmo_char_tosql find (unsigned long)p->delete_date, // FIXME: platform-dependent size p->robe,p->character_moves, p->account_id, p->char_id) ) { Sql_ShowDebug(sql_handle); errors++; } else strcat(save_status, " status"); } add after if (p->zeny != cp->zeny) { //Save zeny if( SQL_ERROR == Sql_Query(sql_handle, "UPDATE `%s` SET `zeny`='%d' WHERE `account_id`='%d'", char_db, p->zeny, p->account_id) ) { Sql_ShowDebug(sql_handle); errors++; } else strcat(save_status, " zeny"); } all chars on account will have same zeny amount !!!IT WILL UPDATE ALL CHARS IN ACCOUNT ON FIRST LOGIN AFTER ADDING THIS CODE!!! and other characters will have zeny like first logged, then zeny will be synchronized

didn't try

you can unpack it from data.grf indoorrswtable.txt viewpointtable.txt

Frog Hat Quest - http://rathena.org/board/topic/87655-frog-hat-ques-script/?p=223625

https://gist.github.com/S-anasol/6589054 short version by me and quest_db.txt 4999,0,0,0,0,0,0,0,"Extermination Crisis" 5001,0,1037,50,0,0,0,0,"King Froggie VII's revenge" 5002,0,0,0,0,0,0,0,"The hero of the frogs" 5003,0,0,0,0,0,0,0,"Frog Hiding Skill" 5004,0,1099,50,0,0,0,0,"Food Shortage"

lub it is compiled lua you need luA, not luB take it here http://subversion.assembla.com/svn/ClientSide/Lua_Project/lua%20files/

what about trunk/conf/subnet_athena.conf?

anyway without wavs each of those who have downloaded could simply update kRo client King poring added in patch 19.04.13 if I'm not mistaken

В конфиг после $db = new db("mysql:host={$host};dbname={$dbname}", $user, $pass); $db->setErrorCallbackFunction("print_r", "text"); добавь $db->run("set names utf8"); и таблицу в utf-8 оставь. Вот здесь так и работает http://ragnaok.net/vending_database/

Можно утф-8, если не поможет попробуй cp1251 CREATE TABLE `vending` ( `char_id` int(11) unsigned NOT NULL DEFAULT '0', `name` varchar(50) DEFAULT NULL, `index` tinyint(3) unsigned NOT NULL DEFAULT '0', `nameid` int(11) unsigned NOT NULL DEFAULT '0', `amount` int(11) unsigned NOT NULL DEFAULT '0', `price` bigint(20) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `card0` smallint(11) NOT NULL DEFAULT '0', `card1` smallint(11) NOT NULL DEFAULT '0', `card2` smallint(11) NOT NULL DEFAULT '0', `card3` smallint(11) NOT NULL DEFAULT '0', PRIMARY KEY (`char_id`,`index`), KEY `char_id` (`char_id`), KEY `nameid` (`nameid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

omnomnom king_poring_wavs.zip

maybe? yum install zlib-devel

SELECT * FROM `picklog` WHERE `char_id` = 123465 AND `type` = 'N'

i think depend on which job level player change class. 9 points - novice 39 - second job = 48 points after reset (didnt try just theory)

so add second getitem for this or try this { getrandgroupitem(IG_GiftBox),2; }

or apt-get install zlib1g-dev

random in 1 map, look at the video, after killing poring king the coins is appeared randomly in the whole prt_fild08 as if it is a big drop from poring king . so do rand with script, rand(map_x, map_x_max)