Item shop of ep7 ^_^ 100% working

Results 1 to 10 of 10
  1. #1
    Account Upgraded | Title Enabled! grahamtar0z is offline
    True MemberRank
    Nov 2010 Join Date
    782Posts

    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


  2.  
  3. #2
    Account Inactive FTD is offline
    InactiveRank
    Feb 2012 Join Date
    46Posts

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

    Yea ur GUID is GOOD keep it UP..

  4. #3
    Listed Ervs is offline
    SubscriberRank
    Jul 2011 Join Date
    /root/Location
    838Posts

    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.


  5. #4
    Account Upgraded | Title Enabled! grahamtar0z is offline
    True MemberRank
    Nov 2010 Join Date
    782Posts

    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

  6. #5
    Account Inactive juzztin12 is offline
    InactiveRank
    Jan 2009 Join Date
    128Posts

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

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

  7. #6
    Common Sense FreedomRecords is offline
    True MemberRank
    Apr 2011 Join Date
    PhilippinesLocation
    662Posts

    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

  8. #7
    Account Inactive juzztin12 is offline
    InactiveRank
    Jan 2009 Join Date
    128Posts

    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.

  9. #8
    Common Sense FreedomRecords is offline
    True MemberRank
    Apr 2011 Join Date
    PhilippinesLocation
    662Posts

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

    @juzztin - your welcome .
    Lawrenze Valdez

  10. #9
    Hardcore Member Jigzz is offline
    MemberRank
    Apr 2013 Join Date
    111Posts

    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..
    BUYING CHEAPEST DDS CP NUMBER AREA CODE +63 9362896640 FROM PH


    >>>>>>>>>>>>>>Selfish Bad Attitude<<<<<<<<<<<<<<<<<<<<

  11. #10
    TroubleMaker AgungEvo is offline
    True MemberRank
    Aug 2011 Join Date
    225Posts

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

    nice sir, let me try


  12.  

    Latest Gaming Releases

Advertisement