CabalToolz Development

[john_d]

then don't put an invitation code

 

[Aezeroth]

mamen.. how to INSERT into varbinary datatype?

when creating an account, the info's will be added at cabal_auth_table from ACCOUNT database..
unfortunately, on the GAMEDB database, the UserNum (or the newley created account) is not added on the cabal_warehouse_table.. not unless the user will go to his warehouse(in-game) and put something..

i wanted to put up a trigger or add the info into GAMEDB through the website when creating an account, automatically add info's for cabal_warehouse_table and add 10,000 of alz..

i can manage to put up the other info's (UserNum, Alz, and Reserved1)
but the Data table (Warehouse).. it is in varbinary datatype and i dont know how to put up something in it and it doesnt allow Nulls..

i can manage to get the hex value but when putting the hexed value through PhP.. it says to use CONVERT function and i dont know how..

can you help me?

im making our own site..
(this dj inan, The Rebirth Crew Webdeveloper - im just using ungas's account)

------------------

To view the content, you need to sign in or register

 

[john_d]

hmmm blindly putting warehouse data .

try this:

insert into cabal_warehouse_table (UserNum, Alz, Data) values (NUMBER,NUMBER,0x)

---
update.. finally decoded the Styles in teh character table. from gender, hair, haircolor, face, rank, and class.

 

[Aezeroth]

the 1st query was this

$sql2 = mssql_query("INSERT INTO dbo.cabal_warehouse_table (UserNum,Data,Alz)
VALUES ('$usernumrs','0x','1,000')");

the value was with quote ('0x')

this is the error message..

mssql_query() [function.mssql-query]: message: Disallowed implicit conversion from data type varchar to data type varbinary, table 'GAMEDB.dbo.cabal_warehouse_table', column 'Data'. Use the CONVERT function to run this query

this is the second query:
$sql2 = mssql_query("INSERT INTO dbo.cabal_warehouse_table (UserNum,Data,Alz)
VALUES ('$usernumrs',0x,'1,000')");

value of Data is without quote (0x)

this is the error message,
mssql_query() [function.mssql-query]: message: Error converting data type varchar to bigint. (severity 16)

mssql_query() [function.mssql-query]: Query failed

hmm..

--------------

To view the content, you need to sign in or register

 

[darkxl]

It will publish a publisher?
I see only the release of its server…

 

[john_d]

the 1st query was this

$sql2 = mssql_query("INSERT INTO dbo.cabal_warehouse_table (UserNum,Data,Alz)
VALUES ('$usernumrs','0x','1,000')");

the value was with quote ('0x')

this is the error message..

mssql_query() [function.mssql-query]: message: Disallowed implicit conversion from data type varchar to data type varbinary, table 'GAMEDB.dbo.cabal_warehouse_table', column 'Data'. Use the CONVERT function to run this query

this is the second query:
$sql2 = mssql_query("INSERT INTO dbo.cabal_warehouse_table (UserNum,Data,Alz)
VALUES ('$usernumrs',0x,'1,000')");

value of Data is without quote (0x)

this is the error message,
mssql_query() [function.mssql-query]: message: Error converting data type varchar to bigint. (severity 16)

mssql_query() [function.mssql-query]: Query failed

hmm..

--------------

To view the content, you need to sign in or register

ur 1st query.. mistake
1. don't put quotes on Binary
2. don't put , (commas) on integer

@ darkxl.. what u mean?

 

[djinan]

thanx man.. i awe you one..

if u need anything.. i can be of help..

 

[john_d]

it;s ok bro.

anyway my usercp is almost complete ^^

 

[ScriptKid]

Nice sig johhy ^^ by the way usercp almost done ^^

 

[djinan]

nice.. im into your Toolz..

 

[john_d]

Ow ya.. item encode and decode.. done ^^

To view the content, you need to sign in or register

 

[djinan]

nice slide.. heheheh
ill be waiting for it..

 

[john_d]

Question ... how do i make a release of cabaltoolz.

installation is complicated as hell.

consist of two website installation. and other stuff.

 

[Terbee]

Question ... how do i make a release of cabaltoolz.

installation is complicated as hell.

consist of two website installation. and other stuff.

a good guide will do sir johny...
gj.. /no1

 

[cypher]

I should have watched my mouth and not said/talked **** to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

 

[john_d]

it is not my problem that it wasn't moved to the Dev section...

----
i gaved the 1st beta to [hidden].. if he can make it work.. well i guess we can release it for everyone...

everyone knows [hidden] is the most noob here bahahhaha joke.

 

[cypher]

I should have watched my mouth and not said/talked **** to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

 

[[hidden]]

it is not my problem that it wasn't moved to the Dev section...

----
i gaved the 1st beta to [hidden].. if he can make it work.. well i guess we can release it for everyone...

everyone knows [hidden] is the most noob here bahahhaha joke.

hahah crazy.. =P

/help

id have to say this is one masterpiece

tested. working. testing more...

 

[myliquid]

Question ... how do i make a release of cabaltoolz.

installation is complicated as hell.

consist of two website installation. and other stuff.

you said it complicated, why not just release it? And if you did'nt want to guide ppl how to install and use it, no body will blame you, cause you said it complicated and hard to teach ppl how to install.

 

[john_d]

the one [hidden] has should be enough for a BETA release...
ill leave it to him to clean up all my mmowebs.com links bahaha