here is the bk2483 rancp edited by me.
this rancp is for ep3 mix ep4 server!
files :
rancp file :
You must be registered to see links
update 23-11-2008
ranshop db for sql 2k :
You must be registered to see links
ranshop db for sql 2k5 :
You must be registered to see links
my own php file for abyss web server :
You must be registered to see links
guide :
new installation
***remember to use abyss or xampp.
***remember!!! You must use the sir ianz ranshop db to make your itemshop/item mall working.
1.) extract the rancp file and put your in your webserver htdoc directory
2.) name the folder to rancp or any name you want.
2.) now go to
You must be registered to see links
3.) just follow step by step.
step 1 - choose mssql or odbc (choose mssql, odbc is not configured yet)
step 2 - now put the correct info. And example shown below.
Code:
local host : 127.0.0.1 (leave as it is)
Code:
[b]*sql server host : Computername\sqlexpress (change computername to yours or put your server ip for sql 2000)[/b]
[b]database user : Sa[/b]
[b]database password : 1234 (change to your pass)[/b]
[b]*ran online database : Ranuser (leave as it is)[/b]
step 3 - enter the infos
step 4 - same
once your done installing it then go here
You must be registered to see links
then you done.
after that, you must deleted the install folder.
if you get this error "web database loading failed! Error #118" then
add this column to your ranuser.dbo.web.
reset_stat, varchar(50) , null
reset_skill, varchar(50) , null
reset_quest, varchar(50) , null
or use this sql script run or execute
Code:
[b]alter table web add reset_stat varchar(50) null[/b]
[b]alter table web add reset_skill varchar(50) null[/b]
[b]alter table web add reset_quest varchar(50) null[/b]
if your having registration problems be sure to add this column to your fulluserinfo table
bodyid2, varchar(50) null
or run the query below
Code:
[b]alter table fulluserinfo add bodyid2 varchar(50) null[/b]
make new table on ranuser and name it to topup
add column name
- code varchar 20 no null
- codevalue int 4 null
itemshop instruction
set productnum to identity = yes.
(see this picture for example)
View attachment 62392
**im sorry, at the copyright bar, i already change to my copyright because i just copy my rancp to share to you all...
you can change if you wan.
credit to :
- bk2483 - rancp
- mike915 - help to fix itemshop
- ianz - ran db