Is there something wrong with my SQL? menu

User Tag List

Results 1 to 3 of 3
  1. #1
    tyeeeee1's Avatar Member
    Reputation
    6
    Join Date
    Feb 2008
    Posts
    95
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Is there something wrong with my SQL?

    Hey,

    I'm currently working on a batch file to create SQLs for NPCs, Items, Quests, etc...
    I finally got to a pint where I created both the "creature_names" and "creature_proto" and saved it to an SQL file.

    My problem is that when I input the SQL into my database it wont go in. Can someone who knows how an SQL should look check the following two for any errors.

    INSERT INTO `creature_names` VALUES ('666', 'My', 'Name', '', '0', '0', '0', '0', '0', '0', '1234', '2341', '3412', '4123', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
    INSERT INTO `creature_proto` VALUES ('666', '1', '2', '7', '1', '1', '1', '1', '0', '2000', '0', '1', '1', '0', '0', '0', '0', '1000', '10', '0', '0', '0', '0', '0', '0', '1.5', '0.3', '0', '0', '111111', '0', '2.5', '8', '14', '', '0', '0', '0', '0', '0', '0', '0', '', '');
    I've checked and the entry 666 isnt used in the names or proto tables.
    Last edited by stoneharry; 10-30-2011 at 02:14 PM. Reason: do not go around censors

    Is there something wrong with my SQL?
  2. #2
    stoneharry's Avatar Moderator Harry

    Authenticator enabled
    Reputation
    1613
    Join Date
    Sep 2007
    Posts
    4,554
    Thanks G/R
    151/146
    Trade Feedback
    0 (0%)
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    What error are you getting?

  3. #3
    tyeeeee1's Avatar Member
    Reputation
    6
    Join Date
    Feb 2008
    Posts
    95
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It was giving 3 errors which SqlYOG didn't allow me t osee because the "let me see the errors" box wasn't checked in preferences. The creature I created works in game so everything is solved for now.
    If I get the 3 errors when doing another test later on I'll post them here so I can find out what causes them.

    PS: Thx for the quick reply.

Similar Threads

  1. Replies: 6
    Last Post: 10-28-2015, 10:25 PM
  2. [Mangos] Is there something wrong with my scriptdev2?
    By brydon10 in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 06-26-2010, 12:02 PM
  3. Something Wrong with my Spora Page?
    By Corosive720 in forum World of Warcraft Emulator Servers
    Replies: 8
    Last Post: 01-19-2008, 09:10 AM
  4. something wrong with my head
    By Chango99 in forum WoW ME Questions and Requests
    Replies: 4
    Last Post: 04-07-2007, 04:04 PM
  5. Something wrong with My macro :S
    By Sørensen in forum World of Warcraft General
    Replies: 2
    Last Post: 03-22-2007, 08:38 AM
All times are GMT -5. The time now is 03:07 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search