SQL: INSERT, Update if not exist

[SQL: INSERT, Update if not exist]

@AnnieRuru i was trying to make some mod on your script VIP SYSTEM. I want to prevent inserting new record for  same char_id each time it expire and avail again. The query_sql seems not update the record. thanks

 

CREATE TABLE `vip_system` (
 `char_id` int(11) unsigned NOT NULL,
 `start_time` datetime DEFAULT NULL,
 `end_time` datetime DEFAULT NULL,
 PRIMARY KEY (`char_id`),
 UNIQUE KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

query_sql "INSERT INTO `vip_system` VALUES ("+ getcharid(CHAR_ID_CHAR) +", NOW(), DATE_ADD(NOW(), INTERVAL "+ 1 +" WEEK)) ON DUPLICATE KEY UPDATE `char_id` = "+getcharid(CHAR_ID_CHAR);

 

[Server closing after exiting putty]

use screen. 

$ cd yourROFolder
$ screen -S login  (this will create screen named "login")
$ ./login-server
$  ctrl+a+d to exit screen.

 

To restore screen, use

$ screen -r login

 

[Client Support Before 2012-04-10]

9 hours ago, Caspian said:

Do you have any issues with guild flags over the head using old clients?

I mean the guild flags over the head are displaced. Try to check it out.

u mean the emblem? so far not experienced.

[Client Support Before 2012-04-10]

 2012-07-10 works fine thank you @4144

[Client Support Before 2012-04-10]

36 minutes ago, 4144 said:

0x0945 look like often used as shuffle packet

you really used correct packet version and client type? because if not, server will not works with this clients at all

 

i used

Serverside (Latest Herc)
mmo.h  #define PACKETVER 20120320
client.conf packet_obfuscation: 2
renewal.h #define DISABLE_RENEWAL
compiled using: ./configure && make clean && make sql

Clien t Side:
http://nemo.herc.ws/downloads/2012-03-20aRagexe/
diffed using NEMO with these settings:

8 Custom Window Title
9 Disable 1rag1 type parameters (Recommended)
10 Disable 4 Letter Character Name Limit
11 Disable 4 Letter User Name Limit
12 Disable 4 Letter Password Limit
13 Disable Ragexe Filename Check (Recommended)
15 Disable HShield (Recommended)
18 Skip Service Selection Screen
19 Enable Title Bar Menu
33 Always Call SelectKoreaClientInfo() (Recommended)
35 Read Data Folder First
36 Read msgstringtable.txt (Recommended)
37 Read questid2display.txt (Recommended)
38 Remove Gravity Ads (Recommended)
39 Remove Gravity Logo (Recommended)
40 Restore Login Window (Recommended)
44 Translate Client (Recommended)
47 Use Ragnarok Icon
48 Use Plain Text Descriptions (Recommended)
49 Enable Multiple GRFs (Recommended)
50 Skip License Screen
53 Use Ascii on All LangTypes (Recommended)
64 @ Bug Fix (Recommended)
73 Remove Hourly Announce (Recommended)
84 Remove Serial Display (Recommended)
86 Only First Login Background
91 Disconnect to Login Window
97 Cancel to Login Window (Recommended)

Did i missed some configurations? Here is my error:
Login: ok
Display Char: ok

Create Char:  chr->parse_char: Received unknown packet 0x67

Select Char:  Unhandled packet 0x0945 (length 19)

[Client Support Before 2012-04-10]

Been trying hard to use client version before 2012-04-10 as these clients uses old character creation. Does anyone here success with this client build on the latest Herc?

 

20120222 - (map) Unhandled packet 0x0945 (length 19)
20120229 - (map) Unhandled packet 0x0945 (length 19)
20120320 - (map) Unhandled packet 0x0945 (length 19)
20120328 - (map) Unhandled packet 0x08A6 (length 19)
20120404 - can't connect to map (no packet error)
/* start of new char creation */
20120410 - (ok) 
20120724 - (ok)

packet_obfuscation: 2

 

[inventoryselect]

is it possible also to modify
callshop .shop_npc_name$,2; to just show a specific type of item to be sold?

[Charms]

very nice. Thank you @AnnieRuru its a great contribution!

[Charms]

charm.c: In function 'npc_parse_unknown_mapflag_pre':
charm.c:173:31: warning: declaration of 'cidata' shadows a previous local [-Wshadow]
       struct charm_item_data *cidata = getFromITEMDATA(idata, 0);
                               ^
charm.c:131:26: warning: shadowed declaration is here [-Wshadow]
  struct charm_item_data *cidata = NULL;
                          ^
charm.c:131:26: warning: unused variable 'cidata' [-Wunused-variable]

Some minor warning

[inventoryselect]

Quote

is it okay with this warning?

[@autoattack]

On 7/26/2020 at 11:53 PM, Clark619 said:

i found the solution just find the line with waktoxy and change it to walk_toxy... and disable the autoattack if you are warping or teleporting..

unit->walk_toxy(&sd->bl,sd->bl.x+(rand()%2==0?-1:1)*(rand()%10),sd->bl.y+(rand()%2==0?-1:1)*(rand()%10),0);

its nice but i think needs more improvement to use a skill in F1~F12.

[Maintenance mode]

Thank you @AnnieRuru
 

[Castle Guild Member Limit]

THanks @AnnieRuru so much learning.!

[Castle Guild Member Limit]

-	script	woelimit	HIDDEN_NPC,{
end;

OnPCLoadMapEvent:
	.@rid = playerattached();
	if ( !compare(strcharinfo(PC_MAP), "g_cas") || !agitcheck() ) end;
	getguildmember getcharid(CHAR_ID_GUILD), 1;
	getguildmember getcharid(CHAR_ID_GUILD), 2;
	.@count = 0;
	for ( .@i = 0; .@i < $@guildmembercount; .@i++ ) {
		if (attachrid($@guildmemberaid[.@i])) {
			if( compare(strcharinfo(PC_MAP), "g_cas") ) .@count++;
		}
	}
	if ( .@rid )
      		attachrid(.@rid);
	else
        	detachrid;

	if(.@count > .max){
		message strcharinfo(0), "WARNING: Max of "+.max+" members can simultaneously join the WOE.";
		warp "SavePoint",0,0;
	}
	end;

OnInit:
	.max = 25;
	end;
}

try this

[Castle Guild Member Limit]

i will try also  i will share if i get it right.

[Castle Guild Member Limit]

maybe limit your guild capacity?

[Flux cp referral registration code]

i would like to share some idea, you can somehow.
1. add column at login table `referral` default to 0
2. pass variable $referral at registration in flux. like /?module=account&action=create&referral=2001154

		if(isset($_SESSION['referral'])){
			$referral = $_SESSION['referral'];
		} else {
			$referral = 0;
		}

		// Woohoo! Register ;)
		$result = $server->loginServer->register($username, $password, $confirm, $email, $gender, $birthdate, $referral, $code);

3. save that extra field referral if there is.
4. use script to manage your controls.

[Bound Items <color>]

where can i possible change the color of bound items?

[@adopt atcommand]

thanks for this. it does not work when adopted char name has space _ on it. How can I fix?

 

[Null Returned]

Yes its from the Extended Battleground. I have have lot of those in logs  also.  @Dastgir

[Request @autotrade limit]

at_timeout: 480

[[Release] ExtendedBG for Hercules (with eAmod BG modes)]

@Dastgir there are moments that this happens
(07/06/2020 20:11:31) [ Error ] : get_variable: NULL RETURNED. 202-4
(07/06/2020 20:11:31) [ Error ] : SET_VARIABLE_ADD: Cannot Add 186 to 202 (AccountID:2001296, Name:xxruid!)
(07/06/2020 20:11:31) [ Error ] : get_variable: NULL RETURNED. 202-4
(07/06/2020 20:11:31) [ Error ] : SET_VARIABLE_ADD: Cannot Add 114 to 202 (AccountID:2001296, Name:xxruid!)

also this where some player can't get any reward at all:
(07/06/2020 20:16:54) [ Warning ] : bg_team_rewards: Cannot give x5 7773 to BG_ID: 0

[Slim Potion Pitcher Not Working]

 

this will be fixed on the next release
https://github.com/HerculesWS/Hercules/pull/2774#pullrequestreview-438731089

 

[Script that runs a custom monster for testing.]

how about how to set mob not to knockback? @meko

 

[i'm looking this for ages this db/pre-re/item_trade.txt]

it was already merge to the item_db 

{
	Id: 675
	AegisName: "Silver_Coin"
	Name: "Silver Roulette Coin"
	Type: "IT_USABLE"
	Trade: {
		nodrop: true
		notrade: true
		noselltonpc: true
		nocart: true
		nostorage: true
		nogstorage: true
		nomail: true
		noauction: true
	}
	Script: <" TmpRouletteSilver += 1; ">
},