Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Release] Displaying/Adding/Delete Item to ShopItemMap (no need to open SQL)

Junior Spellweaver
Joined
Apr 23, 2006
Messages
115
Reaction score
9
Ok guyz first Download the files from my attachment.

This is the guide how to make this page works with no errors.

Add WebLoginState to your UserInfo in RanUser DB

1) Follow the instruction in the first Picture below.
lucian0127 - [Release] Displaying/Adding/Delete Item to ShopItemMap (no need to open SQL) - RaGEZONE Forums


2) Follow the instruction in the Second Picture below.
lucian0127 - [Release] Displaying/Adding/Delete Item to ShopItemMap (no need to open SQL) - RaGEZONE Forums


3) Now the last part extract the files inside your htdocs\ranCP\ folder.

Now you can open the itemMap Table in <-- ShopItemMap Table
<-- Adding item to ShopItemMap Table

Note: You can access this page by logging in your GM account, the normal account can't access this page ^__^v

If you do it correctly, this will happen...
ShopItemMap
lucian0127 - [Release] Displaying/Adding/Delete Item to ShopItemMap (no need to open SQL) - RaGEZONE Forums


Adding Item
lucian0127 - [Release] Displaying/Adding/Delete Item to ShopItemMap (no need to open SQL) - RaGEZONE Forums


NOTE: FOR WebLoginState PROBLEM
Just add this line in your query.php
DEFINE("ACCOUNT_ONLINE", "UPDATE UserInfo SET WebLoginState = 1 WHERE UserName = '%s'");

then under your UserInfo add new Column name it WebLoginState with default value of 0

For the ShopItemMap... Make sure all of existing items has the value of 1 for ItemList if Null will not work.

now try to browse it again...
Updated *April, 2007 1:31pm*
Sorry guys i got busy this pass few months hehehe... thanks to all

Attachment Updated(Nov.9 2007 | 2pm)
 

Attachments

You must be registered for see attachments list
Last edited:
Initiate Mage
Joined
Nov 7, 2007
Messages
1
Reaction score
0
Re: [ADDON] Displaying/Adding Item (no need to open ShopItemMAP) Less time

it is really a big help especially for newbies like me..can you please share it to us..
 
Initiate Mage
Joined
Dec 17, 2006
Messages
59
Reaction score
1
Re: [ADDON] Displaying/Adding Item (no need to open ShopItemMAP) Less time

count me in ^_^V

tnx!
 
Junior Spellweaver
Joined
Jul 12, 2007
Messages
102
Reaction score
2
Re: [ADDON] Displaying/Adding Item (no need to open ShopItemMAP) Less time

im just afraid of someone laugh at my works i know this for begginer..

afraid? this is s*ck. ur a monster to me tsong lucian.. dont mind them, ^^ this script make itemMap simple and clear..
 
Junior Spellweaver
Joined
Sep 25, 2006
Messages
107
Reaction score
0
Re: [ADDON] Displaying/Adding Item (no need to open ShopItemMAP) Less time

:D just share it's ok.
i've done the displaying items when i shared the addon sending gift to all

adding items is a big help for my addon sending gift to all. esp to those lack of ShopItemMap items in it.

simple but it helps
 
Initiate Mage
Joined
Aug 28, 2006
Messages
87
Reaction score
0
Re: [ADDON] Displaying/Adding Item (no need to open ShopItemMAP) Less time

whoah i cant wait.... share it dude ^_^
 
Initiate Mage
Joined
Oct 13, 2006
Messages
13
Reaction score
0
Re: [ADDON] Displaying/Adding Item (no need to open ShopItemMAP) Less time

^^ This Is Nice...
Less Time...
^^ ComE on Share It...
Cant W8 Anymore...^^
More Power Man
 
Initiate Mage
Joined
Apr 11, 2006
Messages
11
Reaction score
0
Re: [ADDON] Displaying/Adding Item (no need to open ShopItemMAP) Less time

release the script plz :p
 
Junior Spellweaver
Joined
Apr 23, 2006
Messages
115
Reaction score
9
Re: [ADDON] Displaying/Adding Item (no need to open ShopItemMAP) Less time

@ALL
Im hoping that this GUIDE will help guyz ^_^
 
Initiate Mage
Joined
Apr 11, 2006
Messages
11
Reaction score
0
Re: [ADDON RELEASE] Displaying/Adding Item (no need to open ShopItemMAP) Less time

Warning: mssql_query(): message: Invalid column name 'WebLoginState'. (severity 16) in C:\Program Files\Abyss Web Server\htdocs\ran\function.php on line 6

Warning: mssql_query(): Query failed in C:\Program Files\Abyss Web Server\htdocs\ran\function.php on line 6

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\Program Files\Abyss Web Server\htdocs\ran\function.php on line 7

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\htdocs\ran\function.php:6) in C:\Program Files\Abyss Web Server\htdocs\ran\function.php on line 173

Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Abyss Web Server\htdocs\ran\function.php:6) in C:\Program Files\Abyss Web Server\htdocs\ran\function.php on line 174

:eek6:

query script error
 
Junior Spellweaver
Joined
Sep 25, 2006
Messages
107
Reaction score
0
Re: [ADDON RELEASE] Displaying/Adding Item (no need to open ShopItemMAP) Less time

@keldai
try to pass the port in of ur mssql and ur done.
edit the settings of ur ip.

i met that error so many times hekhekhek.
just pass the port.

edit:
Warning: mssql_query(): message: Invalid column name 'WebLoginState'. (severity 16) in C:\Program Files\Abyss Web Server\htdocs\ran\function.php on line 6

u need to put webloginstate in ur database. ask lucian where.
 
Initiate Mage
Joined
Oct 13, 2006
Messages
13
Reaction score
0
Re: [ADDON RELEASE] Displaying/Adding Item (no need to open ShopItemMAP) Less time

I test it...!
and theres a little problem here...

Fatal error: Call to undefined function: securitycheck() in C:\Program Files\Abyss Web Server\htdocs\ran\page\newitem.php on line 3

what shall i do..?
 
Junior Spellweaver
Joined
Apr 23, 2006
Messages
115
Reaction score
9
Re: [ADDON RELEASE] Displaying/Adding Item (no need to open ShopItemMAP) Less time

Add WebLoginState to your UserInfo in RanUser DB. When you are currently in game, you can login to ranCP without logging out your account in the game.

Column Name: WebLoginState
Type: smallint
Default Value: 1
 
Last edited:
Initiate Mage
Joined
Oct 13, 2006
Messages
13
Reaction score
0
Re: [ADDON RELEASE] Displaying/Adding Item (no need to open ShopItemMAP) Less time

ok...
but what could be the data type for that one...and the value
 
Initiate Mage
Joined
Dec 14, 2006
Messages
38
Reaction score
0
Re: [ADDON RELEASE] Displaying/Adding Item (no need to open ShopItemMAP) Less time

ei idol thats realy a big help but in addition can u add up another form which can edit existing item on item shop...

example: we can search for a item name or item number and edit or delete the item chosen!!

and if this program add up to shop (and item map ) then can this allso create the icon for the item to be sold (can add something like that to it)
 
Junior Spellweaver
Joined
Apr 23, 2006
Messages
115
Reaction score
9
Re: [ADDON RELEASE] Displaying/Adding Item (no need to open ShopItemMAP) Less time

I RE-ATTACHED THE NEW FILES with ITEM DELETE if ever you enter a wrong item. hehe ^__^

the default value "1" will use with the query
like this
"SELECT ProductNum, ItemMain, ItemSub, ItemName, ItemList FROM ShopItemMap WHERE ItemList = '%s' ORDER BY ProductNum DESC"

this script is for imapping page which is to display your item available at ShopItemMap
 
Last edited:
Junior Spellweaver
Joined
Feb 3, 2007
Messages
142
Reaction score
0
Re: [RANCP ADDON] Displaying/Adding/Delete Item to ShopItemMap (no need to open SQL)

works fine with me the imapping and adding new item..

but not yet tried the one with delete...



edit: here is the screen shot for the delete.. works fine Nice JOB LUCIAN!!
 

Attachments

You must be registered for see attachments list
Last edited:
Initiate Mage
Joined
Apr 11, 2006
Messages
11
Reaction score
0
Re: [RANCP ADDON] Displaying/Adding/Delete Item to ShopItemMap (no need to open SQL)

working fine actually..
just add webloginstate..
thx lucian :)
 
Quit
Member
Joined
Oct 18, 2006
Messages
709
Reaction score
94
Re: [RANCP ADDON] Displaying/Adding/Delete Item to ShopItemMap (no need to open SQL)

huuhuh im noobs in this kind of staff ahahaha but i will try my best ahaha...
btw tnx pre lucian ^_^
 
Back
Top