Being new Hurts!

[Gank]

so new it hurts:(  i can not seem to do much lol.  i had a SD Stang mag price change, it worked till i put in UPDATE `traders_data` SET qty=10 WHERE `item` LIKE '%ItemVault%' AND qty=0;  but not after.  i had email GTX and they reset my data on a new server and it worked for the traders but not the price change.  i was happy with that till this morning when Dallas servers rebooted or something new to me.  Now however nothing is working i do not know anything and GTX somewhat rudely sent me to you nice fellas:)  Plz help a clueless begininger:)

[Gank]

Says

 

UPDATE epoch.traders_data SET qty = 10 WHERE qty = 0

SELECT * FROM `traders_data` WHERE 1

 

but i just tried it again and it does not work:( says:

 

 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `traders_data` WHERE 1' at line 2

[MassAsster]

UPDATE `Traders_DATA` SET `qty`= 100 WHERE qty = 0

 

http://www.w3schools.com/sql/sql_update.asp

[Gank]

UPDATE `Traders_DATA` SET `qty`= 100 WHERE qty = 0
SELECT * FROM `traders_data` WHERE 1

 

and got this  

 

 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `traders_data` WHERE 1' at line 2

[Gank]

I guess i'm doing it wrong? I enter phbMyadmin and I hit the database/trader data/SQL  and than add in the text.  i'm 100% cluess over how to do this so its very likely i'm simple not correctly going about it.  Any help would be great:)  And TY MassAsster it was likely helpful I just do not yet know what i'm doing:)

[MassAsster]

my traders data table is Caps -   yours may not

 

IE     traders_DATA  vs   traders_data

 

try making that change to fit your table name

[Judge Bread]

a) did u get this sorted?

if not

b ) what tool/software are you using to manage your database or is this some custom GTX specific tool/sw

 

(b without the space looks like this.. b))

[Gank]

Rented through GTX so TCadmin and PhbMyadmin.  I think the main reason is i'm clueless about how load a setting to work in the database.  I was told go to the trade data, go to SQL and put in

UPDATE `traders_data` SET qty=10 WHERE `item` LIKE '%ItemVault%' AND qty=0;

 

It did once work for a week or so but now anything I do seems to not take effect. I have tried a few, others have been nice to try offer, but so far noithing works right from pbhMYadmin.  i'm sure its simple once to know a tiny bit about what your doing lol but I am not there yet. Trying the DATA now

[Gank]

I tried it i'll come back later let you know how it worked out, TY for the help:)

[MassAsster]

requires a restart of the server once you get the tables updated

[Gank]

did not work , i think i might need to talk to some one i have a vent if you also do , or anyone that knows how this whole set up thing works:)  Pretty sure i'm just not doing it correctly.

[MassAsster]

Can you upload a picture of what you see when you log into your database - the table structure on the left hand side

[Gank]

Hi back sorry Christmas stold meh:)  not sure how to post a pic on here has too many images.  i'll try attach it:)

 

PhP look.txt

[Gank]

I can post it with all the images but says too many images so I truly hope this helps.  I so know you can look at the images in a preview post :)

[MassAsster]

ok , try this dude

 

traders_data is your table for traders

 

UPDATE `traders_data` SET qty = 500 WHERE qty < 100

(IE: Update traders_data (table) ,  set a value for QTY (quantity of the item in stock) to 500, where the qty < (less then) 100

[Gank]

Let me just say TY again  for all the help.  This is crazy not to work but i'll forsure try the above.  One question; What if they did not have 100 will it change them as well?  My major issue with this it the code I tried did work before it worked (UPDATE `traders_data` SET qty=10 WHERE `item` LIKE '%ItemVault%' AND qty=0;).  So I do not believe it was the code.  But I will sure try this one:)  is it possible to put a code in too much ?  That could be the issue maybe?

 

OMW to to this latest :)

[MassAsster]

the code you had   UPDATE `traders_data` SET qty=10 WHERE `item` LIKE '%ItemVault%' AND qty=0

(IE: update the "traders_data" table,  set (the) qty=10 (Quantity to 10) WHERE item (column item) LIKE %itemVault% (is more or less containing the words ItemVault) AND qty=0 (And the current QTY is currently equal to 0 )

 

This code is very item specific for vaults only, and very specific about the count of vaults being none.

 

no, you can't really use a manual "code" too much, it either has no effect, or an effect.

 

and the less than symbol  means anything less than 100 will get updated to 500

[Gank]

^{Ok here what I did.  went to phpmyadmin, went to trader data, went up to SQL in a cleared box I put the scrip you said to, it went through I restarted the server and went to the dealer, nothing haha.  Do you think maybe you or someone you know could come in to vent and help set it up or even set it up ( afew starter scrpits) ??  I could donate to you or your sever for your kind work:)}

[Gank]

OO This now a hot Topic!  :)  Because of that i'm just going throw it out there , my server ( its getting there) might be looking for a few select players wanting to get away from the whole open pvp for awhile and buildbuildbuild, fight ai, and group planed pvp and other fun stuff:)  I'm on trying to get it working right, and hopping for 5-10 more players that enjoy a server password protected, no open pvp inless planned, fight AI and building like crazy:)

 

Sorry BTW MassAsster, no clue why it changed the text size:)

[MassAsster]

it should give you feedback after you hit GO -

like 0 rows of #### effected .   or error..   or something

[Gank]

 0 rows affected. (Query took 0.1091 sec)

UPDATE `traders_data` SET qty =500 WHERE qty <100

UPDATE `traders_data` SET qty = 500 WHERE qty < 100                  <----}  (says in the box)

 

This what I see:)

[MassAsster]

something is funky going on - I'll be more than willing to look at it from your point of view if you trust me with your user/pass

[Gank]

Bud we got it , your not going believe this lol.  So everything I and yourself have been doing works just fine.  Heres what happen I rented an Orgin server before I knew about the Epoch, so this whole time I was logging under that server (shut for a month now).  So TYVM and sorry  it took a minute for me to figure out we was wasting our time on the wrong sever.  Its all happy time now I hope:)  Agin TY so much for your help, all the codes above work it seems.

[MassAsster]

Hey, glad it was something simple

[Gank]

Wanted to come back in and say again TY for all your help.  The Gankers Club is alive and running well now.  we most of the scripts in and working.  After a tun of reading and youtube vids, the server has become something great:)