hi everybody
iam planning to make a simple online game, but iam not so skilled in db language and i cant use mysql dll plugin
i have this code:
MySQL_Init
x=320
y=240
sync on
do
cls
hide mouse
rem trying to connect mysql server
server$ = \"server=crossfireonline.extra.sql;\"
uid$ = \"uid=crossfireonline;\"
pwd$ = \"pwd=something;\"
database$ = \"database=crossfireonline;\"
driver$ = \"DRIVER={phpMyAdmin 2.9.1.1};\"
sql$ = driver$ + server$ + uid$ + pwd$ + database$
result = MySQL_SetConnection( sql$ )
If result = 0
showErrorSQLError =1
EndIf
rem trying to loggin in
rem input \"ID:\",id
rem input \"Password:\",pw
if id=mysql select and pw = mysql pw then
print \"succesfull login!!!\"
else print \"something wrong\"
rem game
if upkey()=1 then y=y-1
if downkey()=1 then y=y+1
if leftkey()=1 then x=x-1
if rightkey()=1 then x=x+1
if escapekey()=1 then end
circle x,y,20
rem select mysql status[online players coordinate X, coordiante Y
rem circle coordinateX, coordianteY ,20
sync
loop
i have ID,passwrod,coordiantesX,coordiantesY,status in mysql
stastus show if online
coordinates show online members coordinate
pls someone help me
