User Tag List

Page 2 of 9 FirstFirst 1 2 3 4 5 6 ... LastLast
Results 8 to 14 of 59

Thread: [Eluna] Grumbo`z VIP System

  1. #8
    Founder <span style='color: #FF4500'>Foereaper</span>'s Avatar
    Join Date
    Apr 2013
    Posts
    926
    XP
    38,862
    Level
    60
    Thanks
    125
    Thanked 329 Times in 156 Posts
    The script works fine, make sure the item is actually in your database, or change the stones entry in the script to whatever is correct :)

  2. #9
    Respected Member <span style='color: #FF0000'><span class='glow_000000'>Tok124</span></span>'s Avatar
    Join Date
    Sep 2013
    Location
    Sweden
    Posts
    338
    XP
    3,815
    Level
    17
    Thanks
    31
    Thanked 61 Times in 35 Posts
    Quote Originally Posted by Foereaper View Post
    The script works fine, make sure the item is actually in your database, or change the stones entry in the script to whatever is correct :)
    Hello Foereaper, I'm a friend to Mariow and i can confirm that the item is in the database. Both items is there. And we also restarted the server and both the item appear ingame and we did not change the entry of the items. So we use the Default Entry. I did "reload eluna" in worldserver.exe and also restarted but the script wont work... I also added the "vip" column to account table in auth but it just wont work...

  3. #10
    Respected Member <span style='color: #FF0000'><span class='glow_000000'>Tok124</span></span>'s Avatar
    Join Date
    Sep 2013
    Location
    Sweden
    Posts
    338
    XP
    3,815
    Level
    17
    Thanks
    31
    Thanked 61 Times in 35 Posts
    Quote Originally Posted by slp13at420 View Post
    "VIP_coin.lua"
    The Vip Coin will allow players to get extra perks and access to extra commands when a player has one in there inventory.:" may be required for some scripts to work properly."
    Code:
    
    REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `WDBVerified`) VALUES 
    (63020, 15, 0, -1, 'VIP Coin', 32282, 1, 64, 0, 1, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13567, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, 'Click me to view your stats.\r\nA MUST HAVE item.\r\nFor all your VIP needs.\r\n', 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 'Vipcoin_Trigger', 0, 0, 0, 0, 0, 12340);
    
    And also. It says vip_coin.lua but this is not a lua script. It's a SQL Script... However we did import this item. The only thing i changed was WDBVerified to VerifiedBuild

  4. The Following User Says Thank You to Tok124 For This Useful Post:


  5. #11
    Original Poster
    Mad Scientist <span style='color: #008000'><span class='glow_006400'>slp13at420</span></span>'s Avatar



    Join Date
    Dec 2013
    Location
    Idaho
    Posts
    2,536
    XP
    20,135,369
    Level
    500
    Thanks
    1,102
    Thanked 337 Times in 217 Posts
    Quote Originally Posted by 125125 View Post
    And also. It says vip_coin.lua but this is not a lua script. It's a SQL Script... However we did import this item. The only thing i changed was WDBVerified to VerifiedBuild

    thanx good catch.
    -fixed-
    this is an sql file and needs to be added to your sql world.item_template DB.
    yea if you were placing it in the lua_scripts folder rather than grinding it into your SQL db then it would cause the problems your having.
    sorry my fault .

    Last edited by slp13at420; 07-13-2014 at 05:29 PM.
    Achievements:
    Shopper Got a Sticky! Member 1 year registered Level XL Level D
    Awards:
    Pot Head LOL Raffle Winner Top Tagger Donator Hangman Scripter Repacker Drunk Support Member of Staff Da Bomb!
    "Cuz PvP's better with a bag 'o' weed"
    !! King Spade !!

    -Guild Plot System-
    Grumbo'z Guild Warz


    -VIP System-
    Grumbo'z VIP System

  6. #12
    Respected Member <span style='color: #FF0000'><span class='glow_000000'>Tok124</span></span>'s Avatar
    Join Date
    Sep 2013
    Location
    Sweden
    Posts
    338
    XP
    3,815
    Level
    17
    Thanks
    31
    Thanked 61 Times in 35 Posts
    Quote Originally Posted by slp13at420 View Post

    thanx good catch.
    -fixed-
    this is an sql file and needs to be added to your sql world.item_template DB.
    yea if you were placing it in the lua_scripts folder rather than grinding it into your SQL db then it would cause the problems your having.
    sorry my fault .

    Np, However first i just tried to insert the items into DB and then i got that error and then i was thinking that maybe there is a function in the lua script that includes that SQL so then i added that SQL File in lua_scripts folder. And it reported same error. So the error was there before i added that to the folder. Anyway i will try again.

    Btw, You can also edit the query to support latest DB Version, Just change WDBVerified to VerifiedBuild. Most people know how to edit this but before someone ask about it i would atleast recommend that you change it :P

  7. The Following User Says Thank You to Tok124 For This Useful Post:


  8. #13
    Original Poster
    Mad Scientist <span style='color: #008000'><span class='glow_006400'>slp13at420</span></span>'s Avatar



    Join Date
    Dec 2013
    Location
    Idaho
    Posts
    2,536
    XP
    20,135,369
    Level
    500
    Thanks
    1,102
    Thanked 337 Times in 217 Posts
    tnx and updated.
    I may shorten it down to just the basic needed data so it wont need to be edited after every TC update lol
    Last edited by slp13at420; 03-17-2015 at 09:52 PM.
    Achievements:
    Shopper Got a Sticky! Member 1 year registered Level XL Level D
    Awards:
    Pot Head LOL Raffle Winner Top Tagger Donator Hangman Scripter Repacker Drunk Support Member of Staff Da Bomb!
    "Cuz PvP's better with a bag 'o' weed"
    !! King Spade !!

    -Guild Plot System-
    Grumbo'z Guild Warz


    -VIP System-
    Grumbo'z VIP System

  9. #14
    Original Poster
    Mad Scientist <span style='color: #008000'><span class='glow_006400'>slp13at420</span></span>'s Avatar



    Join Date
    Dec 2013
    Location
    Idaho
    Posts
    2,536
    XP
    20,135,369
    Level
    500
    Thanks
    1,102
    Thanked 337 Times in 217 Posts
    ok -updated-
    stripped it down the just the needed data so it should be better for both newer/older cores.
    this was one of those back-burnur things I been meaning to get to rofl shortening up all the sql files to short needed data. K.I.S.S.
    Last edited by slp13at420; 07-13-2014 at 06:48 PM.
    Achievements:
    Shopper Got a Sticky! Member 1 year registered Level XL Level D
    Awards:
    Pot Head LOL Raffle Winner Top Tagger Donator Hangman Scripter Repacker Drunk Support Member of Staff Da Bomb!
    "Cuz PvP's better with a bag 'o' weed"
    !! King Spade !!

    -Guild Plot System-
    Grumbo'z Guild Warz


    -VIP System-
    Grumbo'z VIP System

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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