| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
Comments:
<0> Ox41464b: what is '2 database' ? 2nd database? two databases? Just tell me in plain english what it's doing and what it's not.
<1> Jymmm, from another database in that machine *check config.ini file*
<2> Kaitlyn: i dunno.. i cant find it
<0> Ox41464b I'm not gonna sit here and analyze your code, you need to explain it .
<0> Ox41464b especially since it isn't commented at all.
<1> Ok, 1st, take 'uid' from [SQLDB], and from this uid im taking 10 blob data from [Meia] and [Gaia], 1 Blob data equal to 100 Rows of Data
<0> Ox41464b: Hold up...
<1> and finally i insert Whole 'Rows' into [SQLDB]
<1> extraction from blob into Rows is done in: parseItemBinary.phps
<0> Ox41464b I dont want you do give me directions, I want you to explain what it's doing in layman terms.
<3> Kaitlyn, {} with strings is well documented in the php manual, with many examples
<2> Ox41464b: url?
<0> Ox41464b example.... what is wget ?
<1> ah... the point of whole process is, extract blob into rows (just like what happen in http://satria.web.id/files/task.html #2)
<1> but this time... 1 blob == 100 Rows
<0> Ox41464b and what are they already?
<1> done already, but... take 'LONG' time
<0> Ox41464b what is the blob, an image?
<1> binary data of the 'Rows'
<1> no plain version :(
<0> Ox41464b og what rows?
<0> of
<0> Ox41464b work with me here.... I hate acting like I'm pulling teeth
<1> ItemData Rows
<0> Ox41464b you have a table in one db with records that are blobs. yes?
<1> Correct
<0> Ox41464b just a single field in this table?
<1> 5 field
<0> k
<1> cSQLDB.phps -> function saveItemtoSQL
<1> its the End data i want
<0> and you want to extract the binary record from this table, convert it to plain text and toss them into another db. correct?
<1> Jymmm, perfect... thats what i want to do
<0> Ox41464b ok, and what EXACTLY is this binary data? and how is it "in" binary format?
<1> ItemId,Amount,Value,Attribute,etc
<0> no, those ate ascii, not binary
<0> are
<1> how do i explain that? you want me paste HEX code here ?
<0> are they images? how did they get to be binary?
<2> arent all images 'binary' ?
<0> image as in photographs
<2> Ox41464b: is this some twisted school project?
<0> and no, there are ascii image formats too
<1> myconid, scholl project will not using 10GB of data
<0> and not vector either.
<2> Jymmm: such as?
<0> PGM
<1> Jymmm, they are not 'images' they are ... http://satria.web.id/files/task.html #2
<2> 5 minutes to process 10 gigs isnt that slow is it?
<1> myconid, contain 100k id, and 20.id need around 941.08 secs
<0> Ox41464b is this a school project?
<1> Jymmm, again... no school working with 10GB data
<0> Ox41464b bull****
<1> ...
<0> Ox41464b anyhow... where did this data come from?
<2> Wouldnt binary to (arbitrary format here) be alot faster/easier in C?
<1> Jymmm, that Whole BLOBdata is 'InventoryData' from 3rd party application
<1> and what im doing is Convert the BLOB into plain.SQL format
<0> Ox41464b : Look, I dont mind helping you, but you need to be forthcoming with information. I feel like I'm having to extract every little bit of info from you ARTICULATE please!
<1> er... what kind of Information again you need? :(
<2> Ox41464b: can I see the code?
<1> ok
<4> is there any php editors that have like code insight?
<0> Ox41464b How did this this data get stored in binary format to begin with?
<2> DragonD: zend does it nicely.
<1> Jymmm, that part is covered in ParseItemBinary.phps, and the binaryFormat its not designed by me
<1> myconid, 'MMORPG Game Provider'
<4> myconid: zend?
<2> DragonD: zend studio, zend.com
<2> $99/$399
<2> eclispe php (google the two words) also does it .. but not as well.
<0> Ox41464b and your using MSSQL?
<1> correct
<0> Ox41464b: Okey... then why dont you let the db do what it does best?
<1> Jymmm, meaning... ?
<0> Ox41464b dont do this in php at all, let the db do all the converstions internally
<2> Ox41464b: is this data in binaryt format in mssql? or plaintext
<1> myconid, blob==binary
<2> you can store plaintext in a blob..
<2> and store binary in a varchar
<1> Jymmm, i dont know SQL.Language :( and i dont think storeProcedure can do that
<0> ~+sql
<1> myconid, ....
<5> hmmm
<2> Ox41464b: datatype doesnt reflect contents very accurately.
<0> Ox41464b then learn sql.... it'll save you so many headaches and be FAR faster
<2> Wizz_Kidd1: how goes it
<0> and a SP can do anything you want it to.
<5> myconid: you mean what it do :P
<1> convert that whole process into SQL ? oh... what a headache..
<2> Wizz_Kidd1: you gunna p***word protect your admin interface someday?
<1> i just not sure in some 0xFF converting
<1> in SQL
<5> when its in production
<0> Ox41464b: No, wrtie a sql statement to do the converstion for you.
<2> Wizz_Kidd1: k :)
<5> about ot do another big upload
<0> Ox41464b all within the db itself, no external php script
<5> whats up there nowis not really up to date
<2> Wizz_Kidd1: gotchya.
<1> Jymmm, the blob extraction part is the part i wondering
<0> Ox41464b if you have mssql, you probably have MS-Access too, right?
<1> its hard for me to convert it into SQL
<0> Ox41464b no, you let the db do it.
<5> my next project will be fun as well hehehehehe
<1> db doing the blobExtraction ?
<2> Wizz_Kidd1: lancegoogle?
<5> lol
<5> nope a payment gateway
<2> Wizz_Kidd1: just what the world needs, another payment gateway.
<2> Wizz_Kidd1: paypal/gpay/auth.net/etc/etc called, they want their idea back
<5> not what u think
<0> !+u
<6> Surely you mean 'you', not 'u'? The letter 'u' is not a personal pronoun. Talking like this in ##php may get you silenced. For details, /msg php-bot aolbonics
<2> What makes lancepay different?
<5> why you think its gonan be called lance pay lol
<7> silenced?
<7> thats a lil inaccurate, isnt it?
<2> numist: +b wont kick you, but you cant talk.
<7> more like blowed up
<7> myconid: +b wont kick you, but Jymmm will :P
<0> numist is that a request?
<5> i thgoht +q was no talk ?
<8> +q means you cant talk at all on the server
<2> Wizz_Kidd1: so.. what makes lancepay different?
<8> +b mutes you in the channel
<7> Jymmm: nah
<0> numist then shush
<5> myconidL its not gonna be called lance pay
<7> Wizz_Kidd1: if +b isnt followed by a kick, it just means that you cant join after you part
<5> i c
<8> +b also means you are muted, and cannot change your nickname
<1> /join #irc, and discuss about channel mode in there please
<5> myconid: its a whole different kind of payment gateway something similar to EMO
<2> Wizz_Kidd1: url?
<5> to?
<2> Wizz_Kidd1: emo.. never heard of it
<2> Wizz_Kidd1: i bet theres a market for a yahoo stores knock off.
<5> emocorp.com
<2> emocorp sounds like something I need to slit my wrists before i goto
<5> i dont do knock offs
<5> i think its bad business
<2> lol.. "The EMO website is temporarily off-line due to a DDOS attack"
<5> lol
<5> sec
<9> myconid, i wonder how many kids cut themselves when they had nothing to do cause of that...
<5> http://64.233.179.104/search?q=cache:ShKAGYKekEAJ:www.emocorp.com/+emocorp&hl=en&gl=us&ct=clnk&cd=1 theres a cache
Return to
#php
or
Go to some related
logs:
zaurusd
#linux
nf4 alsa microphone
slackware libperl.so
craig cmp1400
http2irc
#perl
cant enable xinerama fluxbox
#perl
#css
|
|