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

[lucian0127]

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.


2) Follow the instruction in the Second Picture below.


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

Now you can open the itemMap Table in http://yoursite/ran/home.php?page=imapping <-- ShopItemMap Table
http://yoursite/ran/home.php?page=newitem <-- 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


Adding Item

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)

[MentaL]

[itsjustme143]

it is really a big help especially for newbies like me..can you please share it to us..

[larrelle]

count me in ^_^V

tnx!

[heavenzel]

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..

[programmer27]

: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

[eliteskill]

whoah i cant wait.... share it dude ^_^

[kelvin_112]

^^ This Is Nice...
Less Time...
^^ ComE on Share It...
Cant W8 Anymore...^^
More Power Man

[keldai]

release the script plz :p

[lucian0127]

@ALL
Im hoping that this GUIDE will help guyz ^_^

[keldai]

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

[programmer27]

@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.

[kelvin_112]

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..?

[lucian0127]

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

[kelvin_112]

ok...
but what could be the data type for that one...and the value

[neosharky]

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)