Hello & Welcome to our community. Is this your first visit? Register
Results 1 to 10 of 10
  1. #1
    Account Upgraded | Title Enabled! grahamtar0z's Avatar

    Rank
    True Member
    Join Date
    Nov 2010
    Posts
    628
    Likes (Received)
    4

    Item shop of ep7 ^_^ 100% working

    elow guys
    If you have a problem in your RanShop ty my RANSHOP.BAK
    This is EP6 RanShop but its working on EP7 100% ^_^

    Guide
    - Extrack the Ranshop.rar in "C:"
    - Open MSSQL Server Management Studio
    - Login by the user sa and password ****
    - Expand Database +++
    - Expand RanShop Database
    - Click RanShop
    - RightClick>>Choose Tasks>>Restore>>Database
    - They Popup Medium Box and Find "From Device" click the small rectangle.
    - They Popup again Small Box Click "Add" and find the "RanShop.bak" Click it and Press OK.
    - Check the Restore>>Option>>Check "Overwrite the existing database" Press OK..

    That all ^_^

    (Ok lang ba tong ginawang kong guide??)

    Like plsee
    Attached Files Attached Files
    Buying VPS + DDOS PM ME LOW PRICE

  2. #2
    Member FTD's Avatar

    Rank
    Member
    Join Date
    Feb 2012
    Posts
    46
    Likes (Received)
    1

    Re: Item shop of ep7 ^_^ 100% working

    Yea ur GUID is GOOD keep it UP..

  3. #3
    Inno UrbanMuzik urbanmuzik's Avatar

    Rank
    True Member
    Join Date
    Jul 2011
    Location
    Front of you
    Posts
    554
    Likes (Received)
    20

    Re: Item shop of ep7 ^_^ 100% working

    since this isa tutorial maybe u should include some SS. to make this more attractive to our newbie to rz ran section troops

    Even if you fail, Keep moving forward
    Opening up new minds because we are all curious ,
    And Curiousity will lead us down to a new path.

  4. #4
    Account Upgraded | Title Enabled! grahamtar0z's Avatar

    Rank
    True Member
    Join Date
    Nov 2010
    Posts
    628
    Likes (Received)
    4

    Re: Item shop of ep7 ^_^ 100% working

    urbanmuzik-Nod nid SS for this if you do this you see working 100% heheh..

    FTD-thnx Press LIKE ^_^ wahahah
    Buying VPS + DDOS PM ME LOW PRICE

  5. #5
    Hardcore Member

    Rank
    Member
    Join Date
    Jan 2009
    Posts
    128
    Likes (Received)
    1

    Re: Item shop of ep7 ^_^ 100% working

    cant see my items on itemshop i use ran extinction cp..

  6. #6
    Common Sense FreedomRecords's Avatar

    Rank
    True Member
    Join Date
    Apr 2011
    Location
    Philippines
    Posts
    657
    Likes (Received)
    125

    Re: Item shop of ep7 ^_^ 100% working

    Quote Originally Posted by juzztin12 View Post
    cant see my items on itemshop i use ran extinction cp..
    Delete your dbo.shopitemmap in RanShop then execute this script :

    PHP Code:
    USE [RanShop]
    GO
    /****** Object: Table [dbo].[ShopItemMap] Script Date: 04/24/2012 11:52:27 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE 
    [dbo].[ShopItemMap](
    [
    ProductNum] [intIDENTITY(1,1NOT NULL,
    [
    ItemMain] [intNULL,
    [
    ItemSub] [intNULL,
    [
    ItemName] [varchar](100NULL,
    [
    ItemSec] [intNULL,
    [
    ItemPrice] [varchar](100NULL,
    [
    Itemstock] [varchar](100NULL,
    [
    ItemCtg] [intNULL,
    [
    Itemexp] [varchar](100NULL,
    [
    ItemIco] [varchar](100NULL,
    [
    ItemSS] [varchar](100NULL,
    [
    date] [datetimeNOT NULL CONSTRAINT [DF_ShopItemMap_date] DEFAULT (getdate()),
    CONSTRAINT [PK_ShopItemMapPRIMARY KEY CLUSTERED
    (
    [
    ProductNumASC
    )WITH (PAD_INDEX OFFSTATISTICS_NORECOMPUTE OFFIGNORE_DUP_KEY OFFALLOW_ROW_LOCKS ONALLOW_PAGE_LOCKS ONON [PRIMARY]
    ON [PRIMARY]

    GO
    SET ANSI_PADDING OFF 
    Lawrenze Valdez

  7. #7
    Hardcore Member

    Rank
    Member
    Join Date
    Jan 2009
    Posts
    128
    Likes (Received)
    1

    Re: Item shop of ep7 ^_^ 100% working

    @freedomrecords - iwill trythis now
    --
    it works but it show only in latest items but in category V items cant see also in category weapons ..
    i add lava sword for testing , i put it in the category of weapons . but it cant show in my exact itemshop it only show in latest item .
    --
    it works thanks ,, i cant see my items on my server pc but in other pc i see my items on itemshop .
    thanks for this script .. i will also click like for this !
    Last edited by juzztin12; 08-06-12 at 04:43 PM.

  8. #8
    Common Sense FreedomRecords's Avatar

    Rank
    True Member
    Join Date
    Apr 2011
    Location
    Philippines
    Posts
    657
    Likes (Received)
    125

    Re: Item shop of ep7 ^_^ 100% working

    @juzztin - your welcome .
    Lawrenze Valdez

  9. #9
    Hardcore Member

    Rank
    Member
    Join Date
    Apr 2013
    Posts
    101
    Likes (Received)
    7

    Re: Item shop of ep7 ^_^ 100% working

    Quote Originally Posted by FreedomRecords View Post
    Delete your dbo.shopitemmap in RanShop then execute this script :

    PHP Code:
    USE [RanShop]
    GO
    /****** Object: Table [dbo].[ShopItemMap] Script Date: 04/24/2012 11:52:27 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_PADDING ON
    GO
    CREATE TABLE 
    [dbo].[ShopItemMap](
    [
    ProductNum] [intIDENTITY(1,1NOT NULL,
    [
    ItemMain] [intNULL,
    [
    ItemSub] [intNULL,
    [
    ItemName] [varchar](100NULL,
    [
    ItemSec] [intNULL,
    [
    ItemPrice] [varchar](100NULL,
    [
    Itemstock] [varchar](100NULL,
    [
    ItemCtg] [intNULL,
    [
    Itemexp] [varchar](100NULL,
    [
    ItemIco] [varchar](100NULL,
    [
    ItemSS] [varchar](100NULL,
    [
    date] [datetimeNOT NULL CONSTRAINT [DF_ShopItemMap_date] DEFAULT (getdate()),
    CONSTRAINT [PK_ShopItemMapPRIMARY KEY CLUSTERED
    (
    [
    ProductNumASC
    )WITH (PAD_INDEX OFFSTATISTICS_NORECOMPUTE OFFIGNORE_DUP_KEY OFFALLOW_ROW_LOCKS ONALLOW_PAGE_LOCKS ONON [PRIMARY]
    ON [PRIMARY]

    GO
    SET ANSI_PADDING OFF 

    Sir,

    why do we need to delete the shopitemmap from Ranshop in order to execute the script? I noticed all my Items recreated from Ran Manager 3.2 are all deleted, but luckily all my items inserted to my modified Control panel shared by, which solved the appearance of items inside my webshop, but I'd like to know if someone who can share the perfect RANMANAGER to be recreated the shopitemap fully functioning both "ItemShop appearance from Control panel and Ran manager recreation of shop item map..

    who can share script that will function both ranmanager itemstrtable recreated that will perfectly shown up in itemshop control panel like "Dutch_X panel or Glacier CP..
    BACK TO MODIFYING RAN-ONLINE

  10. #10
    TroubleMaker AgungEvo's Avatar

    Rank
    True Member
    Join Date
    Aug 2011
    Posts
    204
    Likes (Received)
    0

    Re: Item shop of ep7 ^_^ 100% working

    nice sir, let me try

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

HostKey
Sponsored by HostKey , secured by Incapsula and mods by DBTech.
All times are GMT +1. The time now is 10:37 AM.
Powered by vBulletin® Copyright , Jelsoft Enterprises Ltd.