[Help Thread] Please post your questions here.

Page 118 of 586

118

05/24/2013 02:26 matedgo#1756

Hello i'm using this for registration page[Only registered and activated users can see links. Click Here To Register...] i added every column which is needed for making account, now i have small problem with account id, how to make it read last id and add +1.

Code:

                            SqlCommand cmd = new SqlCommand("INSERT INTO Account (account_id,account,password,block,withdraw_remain_time,age,auth_ok,pcbang,last_login_server_idx,event_code,result, email)VALUES(5,@User,@Pass,0,0,@Age,1,1,1,0,1,@Email)");

i tryed just 5, but there cant be multiple id 5

05/24/2013 02:36 ThunderNikk#1757

Quote:
Originally Posted by matedgo
Hello i'm using this for registration page[Only registered and activated users can see links. Click Here To Register...] i added every column which is needed for making account, now i have small problem with account id, how to make it read last id and add +1.
Code:
                            SqlCommand cmd = new SqlCommand("INSERT INTO Account (account_id,account,password,block,withdraw_remain_time,age,auth_ok,pcbang,last_login_server_idx,event_code,result, email)VALUES(5,@User,@Pass,0,0,@Age,1,1,1,0,1,@Email)");
i tryed just 5, but there cant be multiple id 5

Why put account_id in the script, it auto populates that field when an account is created.

Does it really need to auto populate by +1?

I use the same script but I never put in account_id

05/24/2013 02:48 matedgo#1758

if i erase account_id in script, on registration it says it cannot be null. Idk do we use same auth database, because database from gameportal is alot different then this scripts is made of.

05/24/2013 03:18 ThunderNikk#1759

If you manually create an account do you fill in that column?

Cause I don't and my DB fills it in automatically the same way as if I use the script.

My script is a little different from yours because I have a few different columns but I still do not put in account_id and my database does not allow nulls in account_id either.

My script...

Code:

SqlCommand cmd = new SqlCommand("INSERT INTO Account (account,password,email,pk_,creationDate_,updateDate_,creatorId_,updatorId_,portId_,accessDate_,password2,ban,bantime,age)VALUES(@User,@Pass,@Email,1,NULL,NULL,NULL,NULL,NULL,NULL,@Pass,NULL,NULL,@Age)");

account_id is also the first row in my database.

05/24/2013 07:38 matedgo#1760

nope, i need to insert it manual:

Code:

nnot insert the value NULL into column 'account_id', table 'Auth.dbo.Account'; column does not allow nulls. INSERT fails. The statement has been terminated.

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

EDIT:Fixed,made that account_id is identity, now everything works.

05/24/2013 14:27 ridhapellz#1761

I'm having Big problem i almost done everything i restore the data base to SQL but when i open Auth Server i get DB Auth Error and ConnectionOpen i can many pepole have this problem i tryed all things posted in forum but nothing worked Config is done ! i reamoved the Pass from sa ! and everything doen Like The Tuto i dont know what is the problem will someone add me in skype and fix the problem please = espion54

05/24/2013 15:10 ThunderNikk#1762

Does "sa" own the databases? (set ownership to "sa")

Did you make your edits to the .opt files and compress them?

Did you open the correct ports in Windows Advanced Firewall?

05/24/2013 19:38 matedgo#1763

how to give world buff or better to say buff to all players ?

EDIT:one more question, is this database problem or client problem, skills after relog does not stay. i need put them again in slots.

05/24/2013 20:14 Player95#1764

For buff:
I think you mean serverwide buffs who do not expire.

You have to add this into server_init: add_event_state(id, lv).

Look at following post to understand:
[Only registered and activated users can see links. Click Here To Register...]

05/24/2013 22:22 Pyrochina#1765

Quote:
Originally Posted by HeavenOnlyWishes
Or you can just add the add_event_state() statements. LUA in Rappelz doesn't require you to setup a function to run most of it's built in methods. And since on_server_init() is already a setup function, you can just add the statements to that function... rather than using a stacked function.

So it would look like this:
Code:
function on_server_init()
	roaming()
	rare_mob()
	guardian_spawn()
	random_respawn()
        add_event_state(1013,20)
        add_event_state(1007,15)
        add_event_state(1008,15)
        add_event_state(1002,10)
        add_event_state(1001,10)
end

I tried this and it doesn't buff me on log in

================================================== ============

Also when I go on my server, the Keys do not work. "I" is suppose to be a hot key to the inventory but it does not work! I go in options and I set them all up and then I place player attack to key "1" but when I disconnect and reconnect, it doesn't work

05/25/2013 00:48 ThunderNikk#1766

Quote:

Originally Posted by Pyrochina

I tried this and it doesn't buff me on log in

The method I left in that thread works in my server, not sure if his would or not but since my function works I have no need to try his.

Quote:

Originally Posted by Pyrochina

Also when I go on my server, the Keys do not work. "I" is suppose to be a hot key to the inventory but it does not work! I go in options and I set them all up and then I place player attack to key "1" but when I disconnect and reconnect, it doesn't work

Getting hot keys to save is an easy task but getting HV to work again afterward is a not so easy task.

Hot keys will function if you change...

T game.cash_usable_server:1

to...

T game.cash_usable_server:0

but as stated I am not sure why this fixes Hotkeys but I do know why it turns HV NPCs off.

Now in order to fix the HV NPCs you need to change their value in dbo.NPCResource.

The Value you need to change is "spawn_type" which will originally be a "4" so it only spawns if it is a cash usable server.

Change the value to "0" and they will spawn like any other NPC.

Code:

use
Arcadia
UPDATE [Arcadia].[dbo].[NPCResource]  SET[spawn_type] = 0  WHERE [contact_script] LIKE '%Secroute%'

05/25/2013 01:24 Pyrochina#1767

Ok! And I want to know the line to pop a Butkadah to me

05/25/2013 02:29 ThunderNikk#1768

Quote:

Originally Posted by Pyrochina

Ok! And I want to know the line to pop a Butkadah to me

/run add_npc(X, Y, MOB-ID, HowMuch)

Butkadah 20185001

To find your X, Y

/position

05/25/2013 10:51 matedgo#1769

when i make "T game.cash_usable_server:0" then always getting sql error and cant start server, if is at 1 then it works.

How to make npc seller and add item to him, same thing with npc buff.

05/25/2013 14:02 Pyrochina#1770

Need Help plz.

Can't log in to server (Log in error message):

Game Server

Code:

S:app.name:game001
N:auth.server_idx:1
S:auth.server_name:Test
S:db.c._password:
S:db.c.account:sa
S:db.c.name:Arcadia
S:db.c.server:127.0.0.1
S:db.user._password:
S:db.user.account:sa
S:db.user.server:127.0.0.1
N:game.AdultServer:0
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
N:game.broadcast_event_item_pickup:0
N:game.cash_usable_server:1
F:game.chaos_drop_rate:1
N:game.check_storage_security_always:0
N:game.enhance_fail_type:2
F:game.exp_rate:1
F:game.gold_drop_rate:1
F:game.item_drop_rate:1
N:game.limit_field_logout:0
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
F:game.mod:0.2
N:game.pcbang_bonus_server:0
F:game.premium_pcbang_bonus_rate:1
F:game.premium_pcbang_chaos_bonus_rate:0.1
N:game.restrict_banword_for_booth:1
N:game.use_auto_jail:0
N:game.use_auto_trap:0
N:game.use_delete_security:0
N:game.use_play_point:0
N:game.use_security:0
N:game.use_storage_security:0
N:io.max_connection:5000
N:log.chat.working:0
N:game.ServiceServer:1
S:game.caution_url:http://IP/upload/client/popup/default.aspx
S:game.guild_icon_base_url:http://IP/upload/client/guild/
S:game.server_screenshot_url:
N:game.update.version:24
S:game.url_list:guild.url||http://IP/client/guild/login.aspx|gu...load.port|4615
N:game.version:200610030
S:io.auth.ip:127.0.0.1
S:io.ip_address:25.97.227.214
S io.port:4504
S:log.ip:127.0.0.1
N:game.disable_buy_booth:0
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:upload.server_name:game001
N:game.disable_trade:0
N:game.disable_booth:0
S:console.allow_ip:127.0.0.1
S:console._password:

Auth

Code:

 S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S db.auth.port:1433
S io.auth.port:8841
S app.name:auth
N game.user_limit:3000
N auth.max_client_per_ip:30000
S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120
N auth.max_daily_client_per_ip:50000
S db.auth.md5_key:5412
N db.auth.use_md5:1
N db.auth.use_md5_for_security_no:0
N billing.user_keep_alive_interval:30000

Start

Code:

 Start SFrame.exe /auth_ip:25.97.227.214 /auth_port:8841 /locale:ASCII /country:US /cash /commercial_shophelp_url_w:620 /help_url_h:633

Page 118 of 586

118