Problem with SQL file menu
Follow us:

User Tag List

Results 1 to 6 of 6
  1. 11-02-2008 #1
    lilbdiablo12's Avatar
    lilbdiablo12
    lilbdiablo12 is offline
    Active Member
    Reputation
    40
    Join Date
    Feb 2008
    Posts
    535
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problem with SQL file

    Code:
    UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90078')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90077')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90076')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90075')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90074')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90073')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90072')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90071')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90070')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90069')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90068')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90067')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90066')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90065')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90064')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90063')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90062')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90061')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90060')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90059')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90058')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90057')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90056')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90055')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90054')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90053')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90052')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90051')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90050')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90049')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90048')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90047')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90046')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90045')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90044')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90043')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90042')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90041')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90040')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90039')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90038')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90037')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90036')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90035')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90034')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90033')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90032')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90031')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90030')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90029')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90028')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90027')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90028')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90025')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90024')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90023')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90022')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90021')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90020')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90019')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90018')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90017')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90016')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90015')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90014')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90013')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90012')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90011')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90010')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90009')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90008')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90007')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90006')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90005')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90004')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90003')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90002')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90001')
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90000')
    Would anyone know what i did wrong here?
    Reply With Quote Reply With Quote
    Problem with SQL file
  2. 11-02-2008 #2
    Reflection's Avatar
    Reflection
    Reflection is offline
    Legendary
    Reputation
    783
    Join Date
    Mar 2008
    Posts
    3,377
    Thanks G/R
    1/2
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What error are you getting?

    Freelance Digital Artist
    https://reflectionartwork.deviantart.com
    You did not desert me
    My brothers in arms
    Reply With Quote Reply With Quote
  3. 11-02-2008 #3
    Ground Zero's Avatar
    Ground Zero
    Ground Zero is offline
    ★ Elder ★
    Reputation
    1132
    Join Date
    Aug 2008
    Posts
    3,504
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Looks alright to me.... :S Like Reflection Said. What error?
    Reply With Quote Reply With Quote
  4. 11-02-2008 #4
    Snailz's Avatar
    Snailz
    Snailz is offline
    Contributor Authenticator enabled
    Reputation
    239
    Join Date
    Nov 2007
    Posts
    941
    Thanks G/R
    2/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Im supprised you 2 havent noticed he forgot the ; after every line, so the script should be something like this.

    Code:
    UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90078');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90077');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90076');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90075');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90074');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90073');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90072');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90071');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90070');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90069');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90068');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90067');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90066');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90065');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90064');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90063');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90062');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90061');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90060');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90059');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90058');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90057');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90056');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90055');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90054');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90053');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90052');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90051');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90050');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90049');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90048');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90047');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90046');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90045');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90044');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90043');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90042');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90041');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90040');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90039');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90038');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90037');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90036');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90035');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90034');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90033');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90032');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90031');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90030');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90029');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90028');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90027');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90028');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90025');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90024');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90023');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90022');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90021');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90020');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90019');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90018');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90017');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90016');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90015');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90014');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90013');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90012');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90011');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90010');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90009');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90008');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90007');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90006');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90005');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90004');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90003');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90002');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90001');
UPDATE `creature_names` SET `male_displayid`='20023' WHERE (`entry`='90000');
    Cheese Cake?
    Reply With Quote Reply With Quote
  5. 11-02-2008 #5
    lilbdiablo12's Avatar
    lilbdiablo12
    lilbdiablo12 is offline
    Active Member
    Reputation
    40
    Join Date
    Feb 2008
    Posts
    535
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    AHH i knew it was something simple! ty snailz +rep

    EDIT: Must spread lol
    Reply With Quote Reply With Quote
  6. 11-02-2008 #6
    Ground Zero's Avatar
    Ground Zero
    Ground Zero is offline
    ★ Elder ★
    Reputation
    1132
    Join Date
    Aug 2008
    Posts
    3,504
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Omg! I Feel so stupid.....

    +Rep Snailz
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Help with sql files.
    By macke013 in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 06-14-2008, 08:54 AM
  2. I have problem with 2.3.3 mpq files
    By seleucid in forum WoW ME Questions and Requests
    Replies: 6
    Last Post: 04-13-2008, 12:23 PM
  3. Need help with orginal sql file!
    By Ollox in forum WoW EMU Guides & Tutorials
    Replies: 3
    Last Post: 03-28-2008, 08:30 PM
  4. How to Execute SQL Files To Your DB With Pictures
    By C.C. in forum WoW EMU Guides & Tutorials
    Replies: 5
    Last Post: 11-24-2007, 07:21 PM
  5. Help needed - how to insert .sql files with SQLyog
    By ADAMZY in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 11-23-2007, 05:32 PM
All times are GMT -5. The time now is 08:48 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search