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 ))))
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 ))))
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 )
@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?
@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.
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?
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
[Helping Topic] 24/7 Helping Services! 08/27/2008 - EO PServer Hosting - 31 Replies stucked on anything while setuping your server?
post your problem here and you will get answer as fast as possible better than spamming with posts :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""