RELEASE CHINESE SERVER DB + CLIENT PATCH

07/18/2008 07:37 funhacker#31
Quote:
Originally Posted by DiobloSlayeR View Post
It contain acc and chars in same, meaning the accounts and user in my, there is no account table, only my, so what shoulda do?
if your talking about ingame accounts they are in your my database which this table is slightly different to your existing ones

-for---the---ones---that---can---connect---to---their---db--via--navicat-

first open the connections to both your english and your chinese database rename the chinese database from my -> chinese now import it into your english database if you dont know how just goto your folders and copy and paste into your english database data folder

now run this script replacing the word [table] with the tables you want to edit

this script will delete any of the old information within your chinese database and only leave new information that your current database doesnt have

delete from chinese.[table] using my.[table] inner join chinese.[table]
where
chinese.[table].id = my.[table].id;

then when you view your chinese tables you will only see the new stuff your current database doesnt have

example:

delete from chinese.cq_action using my.cq_action inner join chinese.cq_action
where
chinese.cq_action.id = my.cq_action.id;

------------------------------------------------------
--Those that cant connect at all----------------------
------------------------------------------------------
just rename the tables you want to something like this

example: cq_action -> cq_action1 or chineseaction

then run this script simialar to the above one

delete from [chinesetable] using [englishtable] inner join [chinesetable]
where
[chinesetable].id = [englishtable].id;

example

delete from cq_action1 using cq_action inner join cq_action1
where
cq_action1.id = cq_action.id;
07/18/2008 18:12 DiobloSlayeR#32
Well, Il tell you, Example, I dont want English Version, I only needthe CHINESE version, the register script will not work with chinese one, So Im trying to use the wamp[so that it contains apache etc], So , the chinese one contain "MY" only, So how can i seperate the ones in account and my? Im tellin u that :P PS: I couldn't understand lol :/ send me a pm step by step, lol!
07/18/2008 18:44 haciveli#33
edit the register.php files so it matches with the db like if it says "$myaccount = account" (somthing similar) just change that to my so it looks like this $myaccount = my" and look around in the script so it all inserts the data into the my d/b, ive got a register script that works with the chinese d/b but im on vacation atm, so dnt have access to any of my server files.
07/18/2008 23:17 hio77#34
Quote:
Originally Posted by haciveli View Post
edit the register.php files so it matches with the db like if it says " = account" (somthing similar) just change that to my so it looks like this = my" and look around in the script so it all inserts the data into the my d/b, ive got a register script that works with the chinese d/b but im on vacation atm, so dnt have access to any of my server files.
depends on the sript lol most would use a config.php file becuse its more scure
07/18/2008 23:56 g0d Eo#35
i need help my login is stuck at verifying acc
07/18/2008 23:58 hio77#36
Quote:
Originally Posted by s01work View Post
i need help my login is stuck at verifying acc
pass word is rong lol try taking out the [accountsever] thing in gamesetup.ini
07/19/2008 00:02 g0d Eo#37
Quote:
Originally Posted by hio77 View Post
pass word is rong lol try taking out the [accountsever] thing in gamesetup.ini
alright the thing is i cant even get into my own server how lame can that be

still doesnt work
07/19/2008 05:15 DiobloSlayeR#38
Quote:
Originally Posted by haciveli View Post
edit the register.php files so it matches with the db like if it says " = account" (somthing similar) just change that to my so it looks like this = my" and look around in the script so it all inserts the data into the my d/b, ive got a register script that works with the chinese d/b but im on vacation atm, so dnt have access to any of my server files.
umm.. then if the chinese one contains the c:/tqmy ,there isnt any wamps, wamp contains apache, right? So the register script wont work without apache :/ And I tried another method, I just Installed wamp, and extracted everything the TQMY has, to wamp, and I re-named it too, to TQMY, still it doesn't work, It couldnt run apache too, it says some httpd.conf file prob...So that the apache would close in 30sec :/
07/19/2008 05:19 hio77#39
Quote:
Originally Posted by s01work View Post
alright the thing is i cant even get into my own server how lame can that be

still doesnt work
well you have messed somthink up lol

have a nother look for the accounts they are in the database my and table account

the pasword 53b6320eb06e2c62888a6d1739cd24bd is test

look at the username and do it like that :)
07/19/2008 06:44 funhacker#40
Quote:
Originally Posted by s01work View Post
i need help my login is stuck at verifying acc
you have to add the version type of the account.exe into your oem somethin like 9888 I cant remember what it is been sometime since I tested this software

Quote:
Originally Posted by hio77 View Post
pass word is rong lol try taking out the [accountsever] thing in gamesetup.ini
if the pass was wrong it would say so whats happening is it isnt allowing him to connect through his acc server
07/19/2008 15:23 g0d Eo#41
Quote:
Originally Posted by funhacker View Post
you have to add the version type of the account.exe into your oem somethin like 9888 I cant remember what it is been sometime since I tested this software
heres my oem

[Oem]
Id=2010

; maybe something else can be here?
[AccountSetup]
Type=1

[ServerInfo]
URL=http://whatever you like.txt

[ServerStatus]
Link=http://whatever you like.txt

[Header]
GroupAmount=1
Group1=EO

[Group1]
ServerAmount=1
Server1=EO
Ip1=76.23.77.252:9820
Pic1=Server1
ServerName1=EO
07/19/2008 15:35 funhacker#42
[Oem]
Id=9820

; maybe something else can be here?
[AccountSetup]
Type=1

[ServerInfo]
URL=http://whatever you like.txt

[ServerStatus]
Link=http://whatever you like.txt

[Header]
GroupAmount=1
Group1=EO

[Group1]
ServerAmount=1
Server1=EO
Ip1=76.23.77.252:9958
Pic1=Server1
ServerName1=EO


try that its all guess work for me as I only logged in once
07/19/2008 15:46 ahmedpotop#43
Funghacker emeber i had that proplem no one helped so i know the fix :D
07/19/2008 15:46 g0d Eo#44
not work
07/19/2008 17:29 funhacker#45
Quote:
Originally Posted by ahmedpotop View Post
Funghacker emeber i had that proplem no one helped so i know the fix :D
perhaps you should explain it to him here for him and others that might need it then, no point hidin it imo people can just get your oem and copy it so might aswell get some credit for it