Jump to content

  •  

lipitb

Member Since 18 Jun 2013
Offline Last Active Sep 20 2013 01:48 PM
-----

Topics I've Started

Dynamic IP and Server

03 September 2013 - 04:17 AM

Hello
Use dynamic IP and use the host ragnahome.servegame.com for the client to connect, and the login / char / map-conf ...
Turns out the modem and restart my ip changes, the server loses connection in char_server. I try to restart.
Had another way without rebooting the server?

Getitemname first database

02 September 2013 - 07:37 PM

Hi!

I want to modify the function "getitemname" for first check the name in the database as my script:
example:

 

 

 

 

 

 

 

 

 function script getitemname {

 

 

set @querysql, query_sql("select name_japanese from `ragdb`.`item_db` WHERE `id` ="+getarg(0)+" ORDER BY id ASC LIMIT 0,1", $@itemname$);
if(@querysql == 0) {set $@itemname$, getitemname(getarg(0));}
return;
}
//$@itemname$ = Item name
 
 
 

 

/*==========================================
 * Get the item name by item_id or null
 *------------------------------------------*/
BUILDIN(getitemname)
{
int item_id=0;
struct item_data *i_data;
char *item_name;
struct script_data *data;
data=script_getdata(st,2);
script->get_val(st,data);
if( data_isstring(data) ){
const char *name=script->conv_str(st,data);
struct item_data *item_data = itemdb->search_name(name);
if( item_data )
item_id=item_data->nameid;
}else
item_id=script->conv_num(st,data);
i_data = itemdb->exists(item_id);
if (i_data == NULL)
{
script_pushconststr(st,"null");
return true;
}
item_name=(char *)aMalloc(ITEM_NAME_LENGTH*sizeof(char));
memcpy(item_name, i_data->jname, ITEM_NAME_LENGTH);
script_pushstr(st,item_name);
return true;
}
 

 

 

 


vending shop to database

22 August 2013 - 01:32 PM

Hi!

 

Who take the vending shop (shop name,item list, price, location x y,map) to database table?

 

Thanks


Who return a shop vending title?

20 August 2013 - 02:26 PM

HI

 

please

 

Who return a shop vending title?

src/map/vending.c

 

if( SQL_ERROR == SQL->Query(mmysql_handle, "INSERT INTO `vending_list` "
"(`char_id`,`shopname`,`item_id`,`amount`,`price`,`timestamp`) "
"VALUES ('%d', '%s', '%d', '%d', '%d', 'CURRENT_TIMESTAMP')",
sd->status.char_id, [color=rgb(255,0,0);]<RETURN A SHOP TITLE>[/color], sd->status.cart[index], sd->vending[i].amount, sd->vending[i].value))
{
Sql_ShowDebug(mmysql_handle);
continue;
}
 

GM_cant_drop_items groups

20 August 2013 - 03:08 AM

Good night!
I apologize if you're posting in the wrong session, and if the translation is not good. I am Brazilian.
I share with you my modification in source.
 
In my hercules emulator upgraded in its latest version, GMs can drop items regardless of the option in can_trade groups.conf.
 
solution:
 
src/map/battle.c
Find
{ "client_accept_chatdori",             &battle_config.client_accept_chatdori,          0,      0,      INT_MAX, },
Paste before
//MODIFICATIONS
{ "gm_cant_drop_min",             &battle_config.gm_cant_drop_min,          10,      0,      99, },
{ "gm_cant_drop_max",             &battle_config.gm_cant_drop_max,          98,      0,      99, },
src/map/battle.h
Find
int gm_ignore_warpable_area;
int client_accept_chatdori; // [Ai4rei/Mirei]
Paste before
//MODIFICATIONS
int gm_cant_drop_min;
int gm_cant_drop_max;
src/map/pc.c
Find
if( !pc->can_give_items(sd) ) //check if this GM level can drop items
return 0;
Paste before
//MODIFICATIONS
if ( battle_config.gm_cant_drop_min != 0 && battle_config.gm_cant_drop_max != 0) {
if ( pc_get_group_level(sd) >= battle_config.gm_cant_drop_min && pc_get_group_level(sd) <= battle_config.gm_cant_drop_max ){ // your group you want to disable
clif->message(sd->fd, msg_txt(246));
return 0;
}}
 
insert into Battle_conf.txt
 
gm_cant_drop_min: 10 //This level until the low, GMs cant drop items.
gm_cant_drop_max: 98