[Help Thread] Please post your questions here.

Page 476 of 586

476

05/30/2018 21:57 Rozan4ik7232314#7126

Quote:

Originally Posted by ThunderNikk

You ran both the following commands in the following order?

use arcadia
update NPCResource set contact_script = 'NPC_Secroute_mage_contact()' where contact_script like 'NPC_Secroute_mage_contact1()'

Then run

use arcadia
update NPCResource set local_flag = 1 where contact_script like 'NPC_Secroute_mage_contact()'
update NPCResource set local_flag = -1 where contact_script like 'NPC_Secroute_mage_contact1()'
update NPCResource set local_flag = -1 where contact_script like 'NPC_Foreign_Secroute_mage_contact()'

Yes i've done this.
after first query i have message ( string completed: 0 )
after second query i have message
(string completed: 1 )
(string completed: 0 )
(string completed: 3 )

Then i restart DB, and server, but there still no NPC in HV
its some kind of magic )))

Quote:

Originally Posted by ThunderNikk

You would have to actually edit the percentages in the drop tables for that.

If you mean you have an SQL file that is not in your database and you want to convert that file into an RDB then you would have to write a tool for that because it doesn't exist yet.

If you can import that SQL file into your database table then you can use the guide to write an RDB from the dbo.ItemResource and create the db_item.rdb and db_item.ref

In yours game.opt string: N:game.cash_usable_server:1
if i use "1" there - after relog i have no skill bars, but have NPC in HV, if i use "0" its ok with skills, but there no NPC ))))

05/31/2018 00:28 ThunderNikk#7127

Quote:

Originally Posted by Rozan4ik7232314

In yours game.opt string: N:game.cash_usable_server:1
if i use "1" there - after relog i have no skill bars, but have NPC in HV, if i use "0" its ok with skills, but there no NPC ))))

Did you restore the billing database?

05/31/2018 08:48 Rozan4ik7232314#7128

Quote:

Originally Posted by ThunderNikk

Did you restore the billing database?

Yes, i've done everything with following you [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by ThunderNikk

Did you restore the billing database?

Solved! I had BILLING94 and i changed BILLING to BILLING94 in opt file, but there weren't NPCs, then i renamed BILLING94 to BLILLING and do the same in opt file, and now it works fine.... But have one problem, there is no dialog with Druid Kart ( NPC Buffer in HV )

05/31/2018 12:46 ThunderNikk#7129

Well if you are using my Buff corrections you need to use my lua file I posted.

If you want original then restore your Arcadia database.

I will post my .lua file later tonight.

05/31/2018 13:46 Rozan4ik7232314#7130

@ThunderNikk, ty )) But i have one more question.... I cant give anyone HV pass
using game server an using commands in game.....
when i use ( #insert_item(910023, 1, 0, 0, 1, "Char") ) it always put HV pass in My inventory.... How can i put HV Pass to an other char or account?

05/31/2018 16:33 Dark Blaze#7131

Quote:

Originally Posted by Rozan4ik7232314

@ThunderNikk, ty )) But i have one more question.... I cant give anyone HV pass
using game server an using commands in game.....
when i use ( #insert_item(910023, 1, 0, 0, 1, "Char") ) it always put HV pass in My inventory.... How can i put HV Pass to an other char or account?

There is a stored procedure called "smp_insert_paid_item" which you can use to insert items into the item boxes of players, you need to pass 4 parameters: account ID, account name, item ID, item count.

05/31/2018 23:43 ThunderNikk#7132

Modified Buff Lua...

06/01/2018 20:17 Rozan4ik7232314#7133

Quote:

Originally Posted by Dark Blaze

There is a stored procedure called "smp_insert_paid_item" which you can use to insert items into the item boxes of players, you need to pass 4 parameters: account ID, account name, item ID, item count.

I've searched all my SQL, but i didn't find this smp_insert_paid_item procedure or .dbo.

Can you put me on right way, where i need to look it?

Sorry for bad English...

06/02/2018 01:11 Dark Blaze#7134

Quote:

Originally Posted by Rozan4ik7232314

I've searched all my SQL, but i didn't find this smp_insert_paid_item procedure or .dbo.

Can you put me on right way, where i need to look it?

Sorry for bad English...

Expand Telecaster DB then expand "Programmability" and after that expand "Stored Procedures"
[Only registered and activated users can see links. Click Here To Register...]

06/02/2018 02:33 PetTrainer#7135

Can anyone help me ....

i would like HEX the Gameserver ... how can i make max Rupees to 999.999.999.999 and other things ?

06/02/2018 11:10 khshe#7136

Quote:

Originally Posted by PetTrainer

Can anyone help me ....

i would like HEX the Gameserver ... how can i make max Rupees to 999.999.999.999 and other things ?

and pets lvl for 300lv

06/03/2018 09:20 Rozan4ik7232314#7137

Quote:

Originally Posted by Dark Blaze

Expand Telecaster DB then expand "Programmability" and after that expand "Stored Procedures"
[Only registered and activated users can see links. Click Here To Register...]

Hmmm.... So... What should i do with this procedure, to put an item in item-box to random char ?)

06/03/2018 17:59 Dark Blaze#7138

Quote:

Originally Posted by Rozan4ik7232314

Hmmm.... So... What should i do with this procedure, to put an item in item-box to random char ?)

[Only registered and activated users can see links. Click Here To Register...]

You have to execute the stored procedure, you can use any programming language to call the stored procedure.

C# example:

Spoiler

06/09/2018 18:00 blackcs1#7139

Checking if i did miss somrgong over here
Item.ref, item.rdb 9.4 how can I insert those to my database? As people say these two make the table of item resource so I’m lost of how to import them to db

06/10/2018 16:32 mlejnek2#7140

F:game.monster_regen_boss:5
F:game.monster_regen:5

what exacly is this for hp regen or what ?
just need to know is all its in the GS so needed to clearify what it realy dose is all

Page 476 of 586

476