| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> cast it
<1> Darken| its already stored as signed we need to manipulate existing data
<2> this is why we do not know what it is
<0> In the C++ code.
<1> Halo_Four yes if thats the only way ? is it ?
<0> The DB has nothing to do with this.
<3> scatterp your question is a C/C++ question
<3> NOT a sql question
<1> Halo_Four but it does becase were trying to make the database display a new colunm
<0> Which you're trying to do because you have no idea how to use the database.
<3> i've repeated myself over 3 times
<1> Darken| the question is esentialy how do i "cast x as unsigned int" that works in MYSQL
<3> i'm not repeating anymore
<0> And you're trying to make a data storage mechanism do something that your program needs to do.
<3> scatterp WE TOLD YOU NOT TO DO IT INSIDE THE DATABASE
<0> You can't do that in MSSQL.
<2> Darken| it is SQL because thats what we need to convert
<3> AND WE HATE MYSQL
<0> Use MySQL, please.
<1> sorry Darken| every ones talking at once im trying to read and answer and make sense of all what your saying
<3> I TOLD YOU I'D HELP YOU WRITE THE FUNCTION IN YOUR NATIVE LANGUAGE FOR THE APPLICATION
<2> the database is in mssql
<3> BUT IM SICK OF REPEATING MYSELF
<0> Too bad.
<3> i'm leaving
<0> You have no options. MSSQL does not understand unsigned datatypes.
<3> go pay someone $50 to write it
<3> it's retarded to store negative numbers unsigned also
<3> i'd scrap your whole game development
<1> darken i have a coder that can do it in c++
<3> you have a bad development team
<0> It's retarded to store data in a composite manner as such.
<1> darken but all i am asking is can it be done in MSSQL
<1> Halo_Four i agree
<0> For the 50th time, NO
<1> Halo_Four ok got it
<2> we took over the game code it had already been partly coded
<2> so to change all at that stage would have been to much
<0> I'd suggest chucking it overboard and moving onto something different.
<1> ok so i need to ask our c++ guy to read the data colunm convert it and then add it to a new table with the origninal and new value right ?
<3> no scatterp
<3> stop ****ing trying to add new columns
<1> ok
<3> do not touch your sql server
<3> leave it as is
<1> ok
<3> this is 100% a programming issue on the c++ side
<3> if your programmer can not do it, fire him
<3> as I teach 1 month new apprentices how to do this
<1> your saying convert the game not to save in that format ?
<3> keep the format as is
<3> it's storing fine as signed, no?
<1> yes it is
<2> yes it is
<3> don't fix what isn't broken
<3> leave it then
<1> so what should the c++ coder do then ?
<3> he should write a conversion routine from signed int to char
<3> to display the equivalent characters you want
<1> hes done that already
<1> dos tool
<3> ...
<3> games do not use "dos tools"
<3> or 3rd party applications
<3> this must be compiled in with your game
<1> hmm thats what we asked him to make
<1> ok so build that tool in to the game ?
<3> making it an external binary is inefficient
<3> and no game should do that
<3> yes scatterp
<3> but i have a feeling that tool is a piece of junk
<3> just a feeling..
<1> ok but after doing that
<0> Why would a game need conversion tools?
<1> how would that help us for example get a list of all items with more than +50 hit points ?
<1> from the database
<3> scatterp you should not be searching your database for text anyway
<3> why would you feed it "50" as text?
<1> becase as a human i cant convert from 50 as text to some unsigned int then on to a signed int rapidly enough to examine 21000 lines
<1> also a where statement wouldnt work out to well if i was doing it by eye
<1> :s
<3> i think you have flaws in your core code to begin with
<3> this sounds odd
<1> yes theres tons of them
<3> your game should not read "+50" as text
<1> it does not
<3> it should maintain it as an integer, which it is
<3> that's retarded
<1> but i want to
<1> wait
<2> which we are fixing as we go thought the code
<1> it doesnt maintain 50 as an int
<3> ***yIce until then you need the conversion function as stated
<3> that's all you need
<1> what it does is it groups all the attribuates in to one value (unsigned)
<1> converts it to signed
<1> then saves it to the database
<1> so in 1 entry theres a lot of info encoded
<1> so its not like i can just say where x > 50
<1> becase theres no x colunm
<3> u_int char2int(char buf);
<3> char int2char(u_int num);
<3> what's the problem?
<3> make those functions, call them all you want
<3> and be happy as can eb
<3> be, until you fix the code correctly
<1> but i cant call them from inside the mssql
<3> ms sql doesn't need to call them
<1> i think your really missing my question (due to me explaining it badly)
<3> gather the data from ms sql to your program, as an unsigned int
<3> which it is, and keep it that way
<3> maybe i am
<1> hold on let me think how i can explain it clearer
<2> Darken| there are 5 servers all diff to work on fixing each bug as we go thought the code and the code is very very big
<2> on each server
<1> ok were in a database looking for items that have found there way in to the game via illegal methods
<1> so for example we know an item known as a power ring should not legaly be in the game
<1> we can execute
<1> select *
<1> from item_t
<1> where sitemid = 934
<3> why are you adding items which aren't even in your inventory in the first place?
<4> h4x
<2> we had a bad GM
<3> yes, but why is his server allowing it
<3> ***yIce is this game in production right now
<2> who could create items in game
<1> becase its not programed yet to stop it
<3> or can i easily say scrap the game project
<3> and get a new job?
<2> this is where the problem came from
<1> wait
<1> stop confuseing it
<1> and let me finish explaining
<3> _zoul_, your ***istance is needed
<0> hehe, yes, drag him into this.
<1> now we can look for that said item
<1> which is a powerring
<1> now how about we used
<1> sitemid = 1
<1> thats a dagger
<1> no problem with a harmless dagger
<5> where did virgin29 go
<4> i think wow was written in vb 6
<1> but if the dagger had a iattribute of 4294964823
<1> it would be a very deadly dagger and shouldnt be there
<3> phargle WoW also lags on my computer
<3> with not many sprites
<1> so i humanly know 4294964823 is bad so i can tell that
<1> but in mssql
<1> for the sql to display just the bad stuff i need to do something like
Return to
#sql
or
Go to some related
logs:
#beginner
#sex
#nhl
#beginner
#heroin
#freebsd
#firebird
tsn streem
error: conflicting types for 'tparm' bitchx term.c
JP18．com
|
|