[Help Thread] Please post your questions here.

matedgo · 05/24/2013, 02:26

Hello i'm using this for registration page

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

ThunderNikk · 05/24/2013, 02:36

Quote:
Originally Posted by matedgo
Hello i'm using this for registration page 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

matedgo · 05/24/2013, 02:48

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.

ThunderNikk · 05/24/2013, 03:18

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.

matedgo · 05/24/2013, 07:38

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.

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

ridhapellz · 05/24/2013, 14:27

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

ThunderNikk · 05/24/2013, 15:10

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?

matedgo · 05/24/2013, 19:38

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

EDIT

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

Player95 · 05/24/2013, 20:14

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:

Pyrochina · 05/24/2013, 22:22

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

ThunderNikk · 05/25/2013, 00:48

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%'

Pyrochina · 05/25/2013, 01:24

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

ThunderNikk · 05/25/2013, 02:29

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

matedgo · 05/25/2013, 10:51

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.

Pyrochina · 05/25/2013, 14:02

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