BFPkiller

April 11, 2021

On 11/6/2018 at 1:05 AM, Emistry said:
shutdown server and execute this query
ALTER TABLE `login` ADD `last_login_date` DATETIME;
UPDATE `login` SET `last_login_date` = `last_login` WHERE `last_login_date` IS NULL
then load this npc.

https://pastebin.com/hduVVqPB

this doesnt work anymore , i have it all correctly installed , but it doesnt give the reward, nor does it error

fixed it myself , pretty easy to, wonder why no one ever made this known

-.@daycount

March 15, 2021

i like the answer to this one as well.
is there anyone kind enough to help out ?

March 14, 2020

@meyraw how do i put that in the APK then ? when i add stuff to the RAW folder where clientinfo goes and repack, i cant install it on my phone , it says apk isnt good

Thanks for you reply

March 9, 2020

Wich doc are you reffering to ?

Since there are multiple doc that describe on howto install, and all have it a little different then the other...

It confuses me to...

@sader1992

i used this doc https://github.com/Normynator/roCORD/blob/master/docs/installation.md

in a fresh rathena, all went well untill these steps ;
( try doing sudo apt-get install libssl1.0-dev , this gives a weird message as well )

 $ cd <path to your rathena>
 $ mkdir build
 $ cd build
 $ /usr/local/bin/cmake -G"Unix Makefiles" -DINSTALL_TO_SOURCE=ON -DJSON=/usr/local/include/nlohmann -DWEBSOCKETPP=~/websocketpp ..
 $ make install

all went well untill "make install" , resulted in :

/src/map/script.cpp: In function ‘int buildin_convertpcinfo(script_state*)’:
/src/map/script.cpp:4881:31: error: ‘buildin_discord’ was not declared in this scope
 #define BUILDIN_DEF(x,args) { buildin_ ## x , #x , args, NULL }
                               ^
/src/map/script.cpp:24484:2: note: in expansion of macro ‘BUILDIN_DEF’
  BUILDIN_DEF(discord,"ss"),
  ^
/map/script.cpp:24484:27: error: expected primary-expression before ‘,’ token
  BUILDIN_DEF(discord,"ss"),
                           ^

March 9, 2020

@sader1992

well as i said i cant login the game , wich is weird

March 9, 2020

@sader1992
it compiles fine in build folder yet i get this when starting the server and cant login game

Heartbeat ACK: {"d":null,"op":11,"s":null,"t":null}
[2020-03-09 02:37:36] [info] asio async_read_at_least error: asio.ssl:335544539 (short read)
[2020-03-09 02:37:36] [error] handle_read_frame error: websocketpp.transport:11 (Generic TLS related error)
[2020-03-09 02:37:36] [info] asio async_write error: asio.ssl:336396495 (protocol is shutdown)
[2020-03-09 02:37:36] [fatal] handle_write_frame error: websocketpp.transport:2 (Underlying Transport Error)
[2020-03-09 02:37:36] [info] asio async_shutdown error: asio.ssl:335544539 (short read)
Socket Init: -150
TLS Init: -1021023349
Close: 4465813
[Debug]: {"d":null,"op":11,"s":null,"t":null}
[Debug]: Waiting for heartbeat thread to finish!

March 8, 2020

@sader1992 i read them all what do you mean ?

March 8, 2020

@sader1992

This is the whole thing , i deleted out server name..

$ make clean && make
make[1]: Entering directory '/src/common'
        CLEAN   common
make[1]: Leaving directory '/src/common'
make[1]: Entering directory '/3rdparty/libconfig'
        CLEAN   libconfig
make[1]: Leaving directory '/3rdparty/libconfig'
make[1]: Entering directory '/3rdparty/yaml-cpp'
        CLEAN   yaml-cpp
make[1]: Leaving directory '/3rdparty/yaml-cpp'
make[1]: Entering directory '/src/login'
        CLEAN   login
make[1]: Leaving directory '/src/login'
make[1]: Entering directory '/src/char'
        CLEAN   char
make[1]: Leaving directory '/src/char'
make[1]: Entering directory '/src/map'
        CLEAN   map
make[1]: Leaving directory '/src/map'
make[1]: Entering directory '/src/tool'
        CLEAN   tool
make[1]: Leaving directory '/src/tool'
make[1]: Entering directory '/3rdparty/libconfig'
        MKDIR   obj
        CC      grammar.c
        CC      libconfig.c
        CC      scanctx.c
        CC      scanner.c
        CC      strbuf.c
        AR      obj/libconfig.a
make[1]: Leaving directory '/3rdparty/libconfig'
make[1]: Entering directory '/3rdparty/yaml-cpp'
        MKDIR   obj/src/contrib
        CXX     src/scanner.cpp
        CXX     src/simplekey.cpp
        CXX     src/exceptions.cpp
        CXX     src/exp.cpp
        CXX     src/singledocparser.cpp
        CXX     src/directives.cpp
        CXX     src/regex_yaml.cpp
        CXX     src/nodebuilder.cpp
        CXX     src/node_data.cpp
        CXX     src/nodeevents.cpp
        CXX     src/emitter.cpp
        CXX     src/parser.cpp
        CXX     src/node.cpp
        CXX     src/contrib/graphbuilder.cpp
        CXX     src/contrib/graphbuilderadapter.cpp
        CXX     src/binary.cpp
        CXX     src/tag.cpp
        CXX     src/parse.cpp
        CXX     src/emitfromevents.cpp
        CXX     src/scantag.cpp
        CXX     src/emitterstate.cpp
        CXX     src/memory.cpp
        CXX     src/scantoken.cpp
        CXX     src/stream.cpp
        CXX     src/null.cpp
        CXX     src/emit.cpp
        CXX     src/emitterutils.cpp
        CXX     src/convert.cpp
        CXX     src/ostream_wrapper.cpp
        CXX     src/scanscalar.cpp
        AR      obj/yaml-cpp.a
make[1]: Leaving directory '/3rdparty/yaml-cpp'
make[1]: Entering directory '/src/common'
        MKDIR   obj
        CXX     core.cpp
        CXX     socket.cpp
        CXX     timer.cpp
        CXX     db.cpp
        CXX     nullpo.cpp
        CXX     malloc.cpp
        CXX     showmsg.cpp
        CXX     strlib.cpp
        CXX     utils.cpp
        CXX     utilities.cpp
        CXX     grfio.cpp
        CXX     mapindex.cpp
        CXX     ers.cpp
        CXX     md5calc.cpp
        CXX     core.cpp
        CXX     socket.cpp
        CXX     malloc.cpp
        CXX     random.cpp
        CXX     des.cpp
        CXX     conf.cpp
        CXX     msg_conf.cpp
        CXX     cli.cpp
        CXX     sql.cpp
        CXX     database.cpp
        AR      obj/common.a
make[1]: Leaving directory '/src/common'
make[1]: Entering directory '/src/login'
        MKDIR   obj
        CXX     account.cpp
        CXX     ipban.cpp
        CXX     loginchrif.cpp
        CXX     loginclif.cpp
        CXX     logincnslif.cpp
        CXX     login.cpp
        CXX     loginlog.cpp
        LD      login-server
make[1]: Leaving directory '/src/login'
make[1]: Entering directory '/src/char'
        MKDIR   obj
        CXX     char_clif.cpp
        CXX     char_cnslif.cpp
        CXX     char.cpp
        CXX     char_logif.cpp
        CXX     char_mapif.cpp
        CXX     int_achievement.cpp
        CXX     int_auction.cpp
        CXX     int_clan.cpp
        CXX     int_elemental.cpp
        CXX     inter.cpp
        CXX     int_guild.cpp
        CXX     int_homun.cpp
        CXX     int_mail.cpp
        CXX     int_mercenary.cpp
        CXX     int_party.cpp
        CXX     int_pet.cpp
        CXX     int_quest.cpp
        CXX     int_storage.cpp
        LD      char-server
make[1]: Leaving directory '/src/char'
make[1]: Entering directory '/src/map'
        MKDIR   obj
        CXX     achievement.cpp
        CXX     atcommand.cpp
        CXX     battle.cpp
        CXX     battleground.cpp                                                                                            ^
        CXX     buyingstore.cpp
        CXX     cashshop.cpp
        CXX     channel.cpp
        CXX     chat.cpp
        CXX     chrif.cpp
        CXX     clan.cpp
        CXX     clif.cpp
        CXX     date.cpp
        CXX     duel.cpp
        CXX     elemental.cpp
        CXX     guild.cpp
        CXX     homunculus.cpp
        CXX     instance.cpp
        CXX     intif.cpp
        CXX     itemdb.cpp
        CXX     log.cpp
        CXX     mail.cpp
        CXX     map.cpp
        CXX     mapreg.cpp
        CXX     mercenary.cpp
        CXX     mob.cpp
        CXX     npc_chat.cpp
        CXX     npc.cpp (custom rule)
        CXX     party.cpp
        CXX     path.cpp
        CXX     pc.cpp
        CXX     pc_groups.cpp
        CXX     pet.cpp
        CXX     quest.cpp
        CXX     script.cpp
        CXX     searchstore.cpp
        CXX     skill.cpp
        CXX     status.cpp
        CXX     storage.cpp
        CXX     trade.cpp
        CXX     unit.cpp
        CXX     vending.cpp
        LD      map-server
obj/channel.o: In function `channel_send(Channel*, map_session_data*, char const*)':
/src/map/channel.cpp:460: undefined reference to `discord_send(char const*, char const*, char const*)'
obj/map.o: In function `do_init(int, char**)':
/src/map/map.cpp:5232: undefined reference to `discord_init()'
obj/script.o: In function `buildin_discord(script_state*)':
/src/map/script.cpp:23944: undefined reference to `discord_script(char const*, char const*)'
collect2: error: ld returned 1 exit status
Makefile:72: recipe for target 'map-server' failed
make[1]: *** [map-server] Error 1
make[1]: Leaving directory '/map'
Makefile:50: recipe for target 'map' failed
make: *** [map] Error 2

March 8, 2020

All steps before that, are completed succesfully.

March 8, 2020

@sader1992

im getting these now

obj/channel.o: In function `channel_send(Channel*, map_session_data*, char const*)':
/src/map/channel.cpp:460: undefined reference to `discord_send(char const*, char const*, char const*)'
obj/map.o: In function `do_init(int, char**)':
/src/map/map.cpp:5232: undefined reference to `discord_init()'
obj/script.o: In function `buildin_discord(script_state*)':
/src/map/script.cpp:23944: undefined reference to `discord_script(char const*, char const*)'

still the same errors.

These errors come at the end of the map server compiling

those are the last ones.

March 8, 2020

2 minutes ago, sader1992 said:

i am sure that it not the case , the compiler stop at that error , so you don't see what after

however , upload channel.cpp , if you get error after that , i will again tell you to track the changes and delete tham than re-apply

obj/channel.o: In function `channel_send(Channel*, map_session_data*, char const*)':
/src/map/channel.cpp:460: undefined reference to `discord_send(char const*, char const*, char const*)'
obj/map.o: In function `do_init(int, char**)':
/src/map/map.cpp:5232: undefined reference to `discord_init()'
obj/script.o: In function `buildin_discord(script_state*)':
/src/map/script.cpp:23944: undefined reference to `discord_script(char const*, char const*)'

those are the errors left here are my files

channel.cpp script.cpp map.cpp

March 5, 2020

i applied the patch manually but when compiling it get this :

any suggestions ?

obj/channel.o: In function channel_send(Channel*, map_session_data*, char const*)': /home/hiwa/Hiwa_Prod/src/map/channel.cpp:460: undefined reference to discord_send(char const, char const, char const)' obj/script.o: In function `buildin_discord(script_state)': /src/map/script.cpp:23944: undefined reference to `discord_script(char const, char const)'

these are the only errors left ...

any idea howto fix them ?

March 4, 2020

hi!

im trying to install this , i have allot of errors allready fixed but still im getting new ones like

: obj/channel.o: In function channel_send(Channel*, map_session_data*, char const*)': /src/map/channel.cpp:460: undefined reference to discord_send(char const, char const, char const)' obj/script.o: In function `buildin_discord(script_state)': /src/map/script.cpp:23944: undefined reference to `discord_script(char const, char const)'

can someone help me out ??

March 3, 2020

16 hours ago, sader1992 said:

try this

script.cpp 697.54 kB · 2 downloads

Hi,

Thanks it seems to have fixed the script.cpp error!

Now I'm having this error tho:

image.png.8769154b655be9f01827d15fa9c6fb7f.png

Here's my map.cpp:
map.cpp

Kind Regards

March 2, 2020

here is my script.cpp

script.cpp

March 1, 2020

hi all !!

i am trying to install roCORD but got these errors ..

have been trying to fix it by adding the user patch etc but no luck.
can anyone help ?

February 22, 2020

how do i get the latest andro to connect remotely ? , wich files do i need to edit ?
ive searched through all the folders but had no luck.

it works using a full client on my phone but i want my http host to stream them as this guide says
http://roworkshop.com/andro/main/own-fileserver.html

so the question is wich files inside the .apk need to be added/edited.

anyone mind to share ?

February 8, 2020

is this revival still alive ??

February 3, 2020

thanks for your answer , ive managed to get it running, but now i face the problem it doesnt read from the GRF's ...
all i setup as described on robrowser.com yet it only read from data folder ...

i hope someone can setup a more detailed configuration or updates the current one ?

Can someone help me figure out how i get it to read the grfs ?

January 26, 2020

anyone ?

i get up tot he point that i see it connects to the server, then it takes awhile and then it says disconnected.
[Network] Packet "0xac4" not register, skipping 222 bytes.
receive @ Online.js?1.001:229875
OnMessage @ Online.js?1.001:17293
[Network] Disconnect from server

January 25, 2020

hello all!!

im playing around with RoBrowser, but in my Chrome browser i get this error.

is this familiar to someone ?

( i striped out the ip adress , username and pass , for privacy. )

[Network] Success to connect to -----:6900
Online.js?26:229751 [Network] Send: PACKET_CA_EXE_HASHCHECK {HashValue: "FA5C3249FEDEADL33TC4FEB4B3CA9924"}
Online.js?26:229751 [Network] Send: PACKET_CA_LOGIN {Version: 26, ID: "-----", Passwd: "----", clienttype: 9}
Online.js?26:229875 [Network] Packet "0x4753" not register, skipping 34 bytes.

I can see the connection attempt on my server, no packet error on serverside , yet it doesnt connect.

thanks in advance !

December 23, 2019

3 hours ago, Haruka Mayumi said:

You must declare the shop first because on the script. it read the V4P manager first and run the OnInit first..
although its okay if you use @reloadscript to show the items. but its not the case on @reloadnpcfile.


-	shop	votepoints_shop	-1,512:-1
vip_lounge,140,243,4	script	V4P Manager	62,{
function getPoints;

	set .@n$, 			"[VFP Manager]";
	set .@settings, 	1;		// 0 = item, 1 = shop
	set .@itemReward, 	501;	// if settings is set to item
	set .@convertRate, 	2;		// 2 Vote Points for 1 Red Potion
	set .vp, 			getPoints(getcharid(3));
	
	switch (.@settings) {
		case 0:
			mes .@n$;
			mes "Would you like to convert your "+ .vp +" Vote Points?";
			mes "^ff0000The current convert rate is "+ .@convertRate +" Vote Points for 1 "+ getitemname(.@itemReward) +".";
			next;
			menu "Yes", L_Convert, "No", -;
			mes .@n$;
			mes "Bye, then.";
			break;
		case 1:
			mes .@n$;
			mes "You have ^ff0000"+ .vp +"^000000 Vote Points.";
			mes "Would you like to go shopping?";
			next;
			menu "Yes", -, "No", L_Goodbye;
			mes .@n$;
			mes "Have fun shopping!";
			callshop "votepoints_shop",1;
			npcshopattach "votepoints_shop";
			end;
	}
	
	L_Goodbye:
		mes .@n$;
		mes "Goodbye, then.";
		close;
	
	L_Convert:
		if (.vp < .@convertRate)
			goto L_VotePointsTooLow;
		mes .@n$;
		mes "How much Vote Points would you like to convert?";
		next;
		menu "All", L_ConvertAll, "Input Amount", L_ConvertAmount;
	
	L_ConvertAmount:
		input .@convert;
		
		if (.@convert > .vp)
			goto L_VotePointsTooLow;
		
		set .vp, ((.vp - .@convert) + (.@convert % .@convertRate));
		set .@convert, (.@convert / .@convertRate);
		getitem .@itemReward, .@convert;
		query_sql("UPDATE cp_createlog SET votepoints = "+ .vp +" WHERE account_id = "+ getcharid(3));
		
		mes .@n$;
		mes "You have received "+ .@convert +"x "+ getitemname(.@itemReward) +".";
		mes "Your current Vote Points is "+ .vp;
		close;
		
	L_ConvertAll:
		set .@convert, (.vp / .@convertRate);
		set .vp, (.vp % .@convertRate);
		getitem .@itemReward, .@convert;
		query_sql("UPDATE cp_createlog SET votepoints = "+ .vp +" WHERE account_id = "+ getcharid(3));
		
		mes .@n$;
		mes "You have received "+ .@convert +"x "+ getitemname(.@itemReward) +".";
		mes "Your current Vote Points is "+ .vp;
		close;
	
	L_VotePointsTooLow:
		mes .@n$;
		mes "Your Vote Points is too low. Come back when you have the minimum amount of Vote Points.";
		close;
	
	function getPoints {
		set .@account_id, getarg(0);
		
		set .@count, query_sql("SELECT votepoints FROM cp_createlog WHERE account_id = "+ .@account_id, .@votepoints);
		
		return .@count ? .@votepoints : 0;
	}
	
	OnBuyItem:
		set .@cost,0;
		for(set .@i,0; .@i<getarraysize(@bought_nameid); set .@i,.@i+1)
			for(set .@j,0; .@j<getarraysize(.itemShop); set .@j,.@j+2)
				if (@bought_nameid[.@i] == .itemShop[.@j]) {
					set .@cost, .@cost+(.itemShop[.@j+1]*@bought_quantity[.@i]);
					break;
				}
		mes .@n$;
		if (.@cost > .vp) mes "You don't have enough Vote Points.";
		else {
			for(set .@i,0; .@i<getarraysize(@bought_nameid); set .@i,.@i+1) {
				getitem @bought_nameid[.@i], @bought_quantity[.@i];
				dispbottom "Purchased "+@bought_quantity[.@i]+"x "+getitemname(@bought_nameid[.@i])+".";
			}
			set .vp, .vp - .@cost;
			query_sql("UPDATE cp_createlog SET votepoints = votepoints - "+ .@cost +" WHERE account_id = "+ getcharid(3));
			mes .@n$;
			mes "Deal completed.";
			mes "You now have ^ff0000"+ .vp +"^000000 Vote Points.";
			emotion et_money;
		}
		set .@cost,0;
		deletearray @bought_nameid[0], getarraysize(@bought_nameid);
		deletearray @bought_quantity[0], getarraysize(@bought_quantity);
		close;
	
	OnInit:
		setarray .itemShop[0],	501,2,607,5; // <ITEM_ID>,<PRICE>,...
		
		npcshopdelitem "votepoints_shop",512;
		for(set .@i, 0; .@i < getarraysize(.itemShop); set .@i, .@i+2)
			npcshopadditem "votepoints_shop", .itemShop[.@i], .itemShop[.@i+1];
	end;
}

This did the trick!!

thank you !!

December 23, 2019

22 minutes ago, BeWan said:
maybe this is your problem
npcshopdelitem "votepoints_shop",512;

i tried various things on that line, keep getting the apple to show up only

Ex.

npcshopdelitem "votepoints_shop"+.@i,512;

December 23, 2019

Hi all !

I have a problem with my VFP npc,
it shows the correct Points i gained from Voting but,
it only shows an apple when i click it ingame.

The items that i want in are supposed to be bought with the Points you get from Voting.

Hope you guys can help me out.

vip_lounge,140,243,4	script	V4P Manager	62,{
function getPoints;

	set .@n$, 			"[VFP Manager]";
	set .@settings, 	1;		// 0 = item, 1 = shop
	set .@itemReward, 	501;	// if settings is set to item
	set .@convertRate, 	2;		// 2 Vote Points for 1 Red Potion
	set .vp, 			getPoints(getcharid(3));
	
	switch (.@settings) {
		case 0:
			mes .@n$;
			mes "Would you like to convert your "+ .vp +" Vote Points?";
			mes "^ff0000The current convert rate is "+ .@convertRate +" Vote Points for 1 "+ getitemname(.@itemReward) +".";
			next;
			menu "Yes", L_Convert, "No", -;
			mes .@n$;
			mes "Bye, then.";
			break;
		case 1:
			mes .@n$;
			mes "You have ^ff0000"+ .vp +"^000000 Vote Points.";
			mes "Would you like to go shopping?";
			next;
			menu "Yes", -, "No", L_Goodbye;
			mes .@n$;
			mes "Have fun shopping!";
			callshop "votepoints_shop",1;
			npcshopattach "votepoints_shop";
			end;
	}
	
	L_Goodbye:
		mes .@n$;
		mes "Goodbye, then.";
		close;
	
	L_Convert:
		if (.vp < .@convertRate)
			goto L_VotePointsTooLow;
		mes .@n$;
		mes "How much Vote Points would you like to convert?";
		next;
		menu "All", L_ConvertAll, "Input Amount", L_ConvertAmount;
	
	L_ConvertAmount:
		input .@convert;
		
		if (.@convert > .vp)
			goto L_VotePointsTooLow;
		
		set .vp, ((.vp - .@convert) + (.@convert % .@convertRate));
		set .@convert, (.@convert / .@convertRate);
		getitem .@itemReward, .@convert;
		query_sql("UPDATE cp_createlog SET votepoints = "+ .vp +" WHERE account_id = "+ getcharid(3));
		
		mes .@n$;
		mes "You have received "+ .@convert +"x "+ getitemname(.@itemReward) +".";
		mes "Your current Vote Points is "+ .vp;
		close;
		
	L_ConvertAll:
		set .@convert, (.vp / .@convertRate);
		set .vp, (.vp % .@convertRate);
		getitem .@itemReward, .@convert;
		query_sql("UPDATE cp_createlog SET votepoints = "+ .vp +" WHERE account_id = "+ getcharid(3));
		
		mes .@n$;
		mes "You have received "+ .@convert +"x "+ getitemname(.@itemReward) +".";
		mes "Your current Vote Points is "+ .vp;
		close;
	
	L_VotePointsTooLow:
		mes .@n$;
		mes "Your Vote Points is too low. Come back when you have the minimum amount of Vote Points.";
		close;
	
	function getPoints {
		set .@account_id, getarg(0);
		
		set .@count, query_sql("SELECT votepoints FROM cp_createlog WHERE account_id = "+ .@account_id, .@votepoints);
		
		return .@count ? .@votepoints : 0;
	}
	
	OnBuyItem:
		set .@cost,0;
		for(set .@i,0; .@i<getarraysize(@bought_nameid); set .@i,.@i+1)
			for(set .@j,0; .@j<getarraysize(.itemShop); set .@j,.@j+2)
				if (@bought_nameid[.@i] == .itemShop[.@j]) {
					set .@cost, .@cost+(.itemShop[.@j+1]*@bought_quantity[.@i]);
					break;
				}
		mes .@n$;
		if (.@cost > .vp) mes "You don't have enough Vote Points.";
		else {
			for(set .@i,0; .@i<getarraysize(@bought_nameid); set .@i,.@i+1) {
				getitem @bought_nameid[.@i], @bought_quantity[.@i];
				dispbottom "Purchased "+@bought_quantity[.@i]+"x "+getitemname(@bought_nameid[.@i])+".";
			}
			set .vp, .vp - .@cost;
			query_sql("UPDATE cp_createlog SET votepoints = votepoints - "+ .@cost +" WHERE account_id = "+ getcharid(3));
			mes .@n$;
			mes "Deal completed.";
			mes "You now have ^ff0000"+ .vp +"^000000 Vote Points.";
			emotion et_money;
		}
		set .@cost,0;
		deletearray @bought_nameid[0], getarraysize(@bought_nameid);
		deletearray @bought_quantity[0], getarraysize(@bought_quantity);
		close;
	
	OnInit:
		setarray .itemShop[0],	501,2,607,5; // <ITEM_ID>,<PRICE>,...
		
		npcshopdelitem "votepoints_shop",512;
		for(set .@i, 0; .@i < getarraysize(.itemShop); set .@i, .@i+2)
			npcshopadditem "votepoints_shop", .itemShop[.@i], .itemShop[.@i+1];
	end;
}

-	shop	votepoints_shop	-1,512:-1

December 13, 2019

can anyone help on this ?

Sorry to Bump , but haven't gotten it fixed yet.

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by BFPkiller